musiccaps_details (view)
2 rows where musiccaps_aspects contains "accordion", musiccaps_aspects contains "low quality audio" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- accordion · 2 ✖
- low quality audio · 2 ✖
- slow tempo · 2 ✖
- clarinet 1
- emotional song 1
- folk music 1
- folk song 1
- guitar 1
- instrumental 1
- male voice 1
- no voices 1
- rubab 1
- trumpet 1
- tuba 1
- violin 1
musiccaps_names (array) 3 ✖
- Accordion 1
- Folk music 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Uzbek Classic Music | This folk song features a male voice singing the main melody in an emotional mood. This is accompanied by an accordion playing fills in the background. A violin plays a droning melody. There is no percussion in this song. This song can be played at a Central Asian classical concert. | 2008-01-24T15:19:53Z | TashChaynar | Bobomurod Hamdamov Ayrilma | ["Folk music", "Music"] | ["folk music", "rubab", "male voice", "slow tempo", "emotional song", "low quality audio", "violin", "accordion"] | 0 | -5f6hjZf9Yw | 12 | |
Salzburg Quintett - Oberkrainer Medley | This folk song features a clarinet playing the main melody. A trumpet plays a similar melody in harmony. This is accompanied by a tuba playing the bass notes. An acoustic guitar plays chords for this song. There are no voices in this song. This is an instrumental song. There is no percussion in this song. This song can be played at an Oktoberfest party. | 2009-01-31T20:58:16Z | Salzburg Quintett ursprünglich | Salzburg Quintett - Oberkrainer Medley, Festzelt in Inzing/Tirol 1984 | ["Accordion"] | ["low quality audio", "folk song", "guitar", "accordion", "tuba", "no voices", "instrumental", "slow tempo", "clarinet", "trumpet"] | 0 | qRgefptkDeo | 4786 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;