musiccaps_details (view)
1 row where musiccaps_aspects contains "medium to uptempo", musiccaps_aspects contains "turkish baglama" and "youtube_published" is on date 2008-07-27
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Baba Zula & the Istanbul Music Scene | Belly Dancing in Turkey | A digital drum is playing a reggaeton groove along with some acoustic percussion while someone is playing a turkish baglama. A male voice is singing/shouting. This is an amateur recording. This song may be playing outside busking with a band. | 2008-07-27T17:28:38Z | Rudy Maxa's World | For "Rudy Maxa's World," Istanbul's rock group Baba Zula performed in their rehearsal studio, complete with two exotic belly dancers. Turkish style belly dancing and the psychedelic music of this popular band are just one of the cultural highlights this region has to offer. Check out more about Turkey and Istanbul at http://rudymaxasworld.com/episodes/turkey-istanbul/ | ["Music", "Rattle (instrument)"] | ["oriental music", "turkish baglama", "acoustic/digital percussion", "male voice singing/shouting", "medium to uptempo"] | 6 | OB7GyVqufwQ | 2409 |
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;