musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "no percussion moderate tempo", musiccaps_aspects contains "whistles" and musiccaps_names contains "Salsa music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Folk Dance-House Music - Hungary (38) | This amateur recording features folk music being played on violins. There are multiple violins playing in harmony. The tempo is moderate. There is no percussion in this song. Crowd voices and whistles can be heard during the performance. This song is played for a folk dance. | 2011-02-15T08:59:13Z | HUNGARIAN and other TRADITIONS | Táncház a XVI. Bakony Néptáncfesztiválon. Játszik a Heveder zenekar ( Sepsiszentgyörgy ), Ajka 2010.11.05. | ["Music", "Music of Latin America", "Salsa music", "/t/dd00032"] | ["amateur recording", "violin music", "acoustic guitar", "crowd voice", "whistles", "folk music", "folk dance music", "no percussion moderate tempo"] | 0 | NNeEzTVATHg | 2333 |
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;