musiccaps_details (view)
1 row where musiccaps_aspects contains "drums", musiccaps_names contains "Drum roll" and "youtube_published" is on date 2013-07-18
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 |
---|---|---|---|---|---|---|---|---|---|---|
Yamaha PHX Phoenix Drum Set 22/10/12/14/16 - Burled Ash Garnet Fade Gloss | Someone is playing a drum groove on the ride with a lot of fill-ins on toms. This song may be playing during drum practice. | 2013-07-18T20:24:45Z | Memphis Drum Shop | Yamaha PHX Drum Set available from Memphis Drum Shop. Buy it now at http://memphisdrumshop.com/drum-sets/yamaha/ Contact us at sales@memphisdrumshop.com https://www.facebook.com/MemphisDrumShop https://www.facebook.com/myCymbal https://twitter.com/memphisdrumshop Other gear used in this video: • Cymbals (From drummer's L to R): Zildjian 14 1/4" K Custom Hybrid Hi Hat Cymbals, Zildjian 19" K Custom Hybrid Crash Cymbal, Zildjian 21" K Custom Hybrid Ride Cymbal, Zildjian 17" K Custom Hybrid Crash Cymbal • Snare: Yamaha 14x6.5 Sensitive Series Maple Snare Drum | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["amateur recording", "drums", "medium to uptempo"] | 6 | tOb0M2k3deo | 5031 |
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;