musiccaps_details (view)
1 row where musiccaps_aspects contains "country", musiccaps_aspects contains "emotional", musiccaps_aspects contains "heartfelt" and musiccaps_aspects contains "percussive acoustic rhythm guitar"
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 |
---|---|---|---|---|---|---|---|---|---|---|
George Jones - Colour of the Blues - Country Music Experience | The Country song features a fruity male vocal singing over percussive acoustic rhythm guitar, simple bass and keys chords. It sounds emotional, passionate and heartfelt - like something you would hear in the old pubs and bars. | 2012-10-07T07:52:56Z | Country Music Experience | Country Music Experience : (Re)Discover the finestcountry Music Selection. Country Music experience is your channel for all the country music, where you can experience music, in high audio quality. Subscribe to stay connected to our channel and receive all of our video updates! -Country Music experience | ["Christmas music", "Music"] | ["country", "percussive acoustic rhythm guitar", "keys chords", "fruity male vocal", "emotional", "passionate", "heartfelt", "simple bass"] | 4 | tGic59TlrVg | 5022 |
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;