musiccaps_details (view)
1 row where musiccaps_aspects contains "drum solo", musiccaps_aspects contains "energetic", musiccaps_aspects contains "rapid playing" and musiccaps_author = 9
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 |
---|---|---|---|---|---|---|---|---|---|---|
JP Bouvet plays DW Drums (100% GoPro) | This is the recording of a drum solo performance. The drummer is performing various complex beats and chops with a rapid procession on an acoustic drum kit. There is a tambourine placed on the snare drum that rattles with every stroke. The atmosphere of the solo is energetic. Parts of this solo could be sampled to be used as intro jingles for music channels. These samples could also be used in beat-making. | 2015-11-19T21:48:08Z | dw drums | JP Bouvet + 6 GoPro cameras = https://youtu.be/WIuLaxWIAAI JP is a NYC based Drummer, Educator, and Clinician. JP has worked with Helicopria, Dave Mackay Group, and Drew of the Drew. Find out more: http://www.jpbouvetmusic.com The Kit: DW Collector's Series 8x10, 9x12, 12x14, 14x16, 18x22 5.5x14 Snare Drum & Side Snare. GoPro: Both Hero3 and Hero3+ cameras used. Audio: Recorded into the Zoom H6 Audix D6 on the bass drum Sure SM57 on the snare Rode NT4 overhead For all things DW, visit: http://www.dwdrums.com To stay extra-connected with all our latest happenings, follow us on your favorite social networks: http://www.facebook.com/dwdrums http://www.twitter.com/dwdrums http://www.youtube.com/dwdrums http://www.instagram.com/dwdrums http://www.pinterest.com/dwdrums http://www.google.com/dwdrums | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["no singer", "instrumental", "acoustic drums", "drum solo", "rapid playing", "energetic", "complex", "groovy"] | 9 | WIuLaxWIAAI | 3082 |
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;