musiccaps_details (view)

1 row where musiccaps_aspects contains "drum roll", musiccaps_names contains "Drum kit" and musiccaps_names contains "Hi-hat"

✎ 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
105 BPM Funk Rock Drums This is a drum beat in the rock and roll style, with a drum roll in between that's intricate. The snare, toms, hi-hats and crash cymbal are used. 2014-12-24T23:21:21Z LumBeat Recorded with Rock Drum Machine for iPad - iPhone https://itunes.apple.com/app/rock-drum-machine/id725234217 http://www.rockdrummachine.com Funk rock is a music genre that fuses funk and rock elements. James Brown and others declared that Little Richard and his mid-1950s road band, The Upsetters, were the first to put the funk in the rock and roll beat, with a biographer stating that their music "spark[ed] the musical transition from fifties rock and roll to sixties funk. Funk rock's earliest incarnation on record was heard in the late 1960s through the mid-1970s by acts such as the Jimi Hendrix Experience (later work / Band of Gypsys), Eric Burdon and War, Ike and Tina Turner, Trapeze, Black Merda, Parliament-Funkadelic, Betty Davis and Mother's Finest. During the late 1980s and 1990s funk rock music experienced a surge in popularity, with bands such as Rage Against the Machine, Incubus, Infectious Grooves, Red Hot Chili Peppers, Faith No More and Primus mixing funk rock with many different genres, most notably heavy metal, hip hop, experimental music and punk rock, with this leading to the emergence of the funk rock subgenre funk metal. ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] ["drum beat", "rock drum pattern", "drum roll", "snare", "toms", "hi-hats", "crash cymbal", "complex drum roll"] 3 BcVapmCbULQ 1265

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;