musiccaps_details (view)

1 row where musiccaps_aspects contains "catchy", musiccaps_aspects contains "groovy drumming" and musiccaps_aspects contains "punchy"

✎ 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
Return of The Groove: Lesson 2 - Nasty Cowbell Groove (KindBeats) This music is instrumental. The tempo is fast with a groovy drumming rhythm with bass drums, snares, cymbals and a Cowbell. The rhythm is upbeat, catchy, punchy and buoyant. This music is a Drumming lesson/ tutorial. 2011-05-17T04:53:40Z Andrew McAuley www.kindbeats.net In the second installation of the "ROTG" series, I break down an original boom bap groove that has a heavy emphasis on the cowbell (clave variation). Enjoy! TRANSCRIPTION at http://i.imgur.com/x8Q0PqY.jpg. Proud to endorsee by Hammerax cymbals and hybrids! My Current Cymbal Line Up (set ups vary): 13" Ultra Violet™ Hi-Hats 15" Andrew McAuley Under Violet Hi-Hats 16" HellHat™ Hi-Hats 16" Indigo® Flatride 18" Meanie 19" LTD Indigo® Crash Ride 22" Boomywang® Nano Thin Vibrato Hybrid Nano Baby Boomywang (prototype) Crash Course Splashvine Bash ["Cymbal", "Cowbell", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] ["instrumental", "fast tempo", "rhythmic beat", "idiophone", "non tuned percussion", "rock music", "cowbell", "percussion", "upbeat", "catchy", "punchy", "buoyant", "drumming", "groovy drumming", "snare", "cymbals", "bass drums", "cow bell", "sound of bell", "drumming lesson", "drumming tutorial"] 7 nu_Bl8Pz6PE 4588

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;