musiccaps_details (view)
2 rows where musiccaps_aspects contains "audience sounds" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- audience sounds · 2 ✖
- acoustic bass 1
- danceable 1
- drone 1
- grating 1
- harsh 1
- latin jazz 1
- piano 1
- recital hall 1
- reverb 1
- sneeze 1
- solo bagpipe 1
- syncopated drums 1
- trumpet solo 1
- upbeat rhythm 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bagpiper Angus McColl 1 | Harsh, grating sound of a solo bagpipe with audience sounds in the background. | 2006-12-30T21:44:45Z | 3DPiper | An amazing performance by Gold Medal/World Champion level piper Angus McColl at the Red River Workshop in Shreveport, LA, 2005 1 of 2 Full Playlist: http://www.youtube.com/view_play_list?p=CC4EC1A82C4245A2 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["solo bagpipe", "drone", "audience sounds", "harsh", "grating"] | 8 | 3TP1itJqv-E | 470 | |
Arturo & Doc Solos.mp4 | a latin jazz ensemble performing in a recital hall. A trumpet solo is accompanied by acoustic bass, syncopated drums and piano. The rhythm is upbeat and danceable. You can hear the reverb of the recital hall as well as audience sounds, someone sneezing. | 2010-11-29T02:19:26Z | jazzman1222 | This is my second Video of Doc and Arturo at the Rafael Mendez Trumpet Festival in Mexico City. Hard to believe that Doc is 83, he still has a wonderful sound!!! Arturo is still burnin´as usual!! | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Trumpet", "Inside, large room or hall"] | ["latin jazz", "trumpet solo", "acoustic bass", "recital hall", "reverb", "audience sounds", "sneeze", "piano", "syncopated drums", "upbeat rhythm", "danceable"] | 8 | eiyyoUt64Zc | 3894 |
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;