musiccaps_details (view)
1 row where musiccaps_aspects contains "live performance", musiccaps_aspects contains "noisy", musiccaps_aspects contains "wooden impact" and musiccaps_names contains "Wood block"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Bobby Previte's TERMINAL 4 - So Percussion and Bobby Previte | The low quality recording features a live performance of groovy wooden percussion. There is a wooden impact in the form of a wooden stick falling on the floor - which is a part of the groove. The recording is a bit noisy, due to a ventilation system, which also makes it very intimate. | 2011-04-27T19:30:54Z | Bobby Previte | If you can't watch it all, check out 21:30...and the "special guest" at the end... from TERMINALS: PART 1 - DEPARTURES Five Concertos for Percussion Ensemble and Soloist composed by Bobby Previte featuring So Percussion - Eric Beach, Josh Quillen, Adam Sliwinski, and Jason Treuting and guest soloist Bobby Previte, drums. Recorded from the live world premiere, March 28, 2011 at The Ecstatic Music Festival as part of WNYC's New Sounds Live series produced by John Schaefer, recorded for broadcast by Ed Haber at WNYC. Video shot by Arrien Zinghini Audio and video mixed and edited by Bobby Previte | ["Wood block", "Percussion"] | ["low quality", "live performance", "groovy wooden percussions", "wooden impact", "noisy", "intimate"] | 4 | 7DIPyJB4osY | 819 |
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;