musiccaps_details (view)

1 row where musiccaps_aspects contains "groovy", musiccaps_aspects contains "rapid playing" and musiccaps_names contains "Drum"

✎ View and edit SQL

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

CSV options: 

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;