musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_author = 3, musiccaps_names contains "Music" and "youtube_published" is on date 2015-12-22
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 |
---|---|---|---|---|---|---|---|---|---|---|
Star Wars Theme - Double Bass Solo | This is an instrumental track featuring the double bass and acoustic guitar. Initially, chords are strummed on the acoustic guitar, and then arpeggio notes are played. The double bass is played with a bow and plays the leading melodic motif in the song. The song feels like it would be suitable in an adventure movie. | 2015-12-22T22:50:11Z | TESEO | Star Wars Theme - Double Bass Solo - Plays Francesco Tesei - New Fan Page https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Country", "Music", "Wedding music"] | ["double bass", "acoustic guitar", "guitar arpeggios", "fantasy", "exciting"] | 3 | X6Q53uXgaHc | 3161 |
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;