musiccaps_details (view)
1 row where musiccaps_aspects contains "easygoing" and "youtube_published" is on date 2014-06-17
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 |
---|---|---|---|---|---|---|---|---|---|---|
Dos Eddies-Come And Get Your Love (cover)-HD-Ogden Tap Room-Ogden, NC-6/14/14 | This is a live acoustic performance of a rock music song. There is a male vocalist singing at a medium-to-high pitch in a melodic manner while two acoustic guitars are carrying the background with a simple tune composed of only four chords. The music might be played at a bar in the background. | 2014-06-17T01:56:11Z | castromusicfreak | Dos Eddies performing Redbone's "Come And Get Your Love" at the Ogden Tap Room in Ogden, NC on 6/14/14. Greg Miller and Mark Weathers have created an acoustic duo version of The Steady Eddies, streamlined for those events that call for an unplugged experience. For more information about Dos Eddies, visit their Facebook page at: https://www.facebook.com/pages/Dos-Eddies/152709704894082 Video by Sue Kropp A Stolen Rune Recording | ["Country", "Music"] | ["acoustic rock", "acoustic guitar", "male vocal", "live performance", "simple", "melodic", "easygoing"] | 9 | eiFyXXqd9Rk | 3892 |
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;