musiccaps_details (view)

2 rows where musiccaps_aspects contains "drums solo", musiccaps_aspects contains "energetic", musiccaps_aspects contains "punchy snare" 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
Eric Singer Pearl Promo Video drum solo FULL The low quality recording features a drum solo that consists of a double pedal kick, punchy snare, shimmering cymbals and boomy toms. It sounds energetic and manic, thanks to that kick pattern. The recording is mono and noisy. 2008-04-11T05:51:12Z Rob Eggleston A small drum solo Eric Singer plays at the end of a Pearl Drumming instructional video on a Pearl Forum using Pearl cymbals. Feel free to comment, rate, favourite or subscribe. ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Bass drum", "Percussion"] ["low quality", "mono", "noisy", "drums solo", "double pedal kick", "punchy snare", "shimmering cymbals", "boomy toms", "energetic", "manic"] 4 -CUp_Tmg2Y0 26
Mambo/Songo/Solo Drums (Latin Jazz Drumming) The low quality recording features a latin jazz song played in the background over which a drums solo is played. The solo consists of shimmering hi hats, punchy snare and kick hits and low tom rolls, while the latin jazz song consists of groovy piano chords and wooden percussion. It sounds energetic and exciting. 2011-05-13T11:31:17Z Thomas Sienko Mambo and Songo from Tommy Igoe's Groove Essentials. Groove 41 Fast, Groove 42 Slow. Hope you enjoy! ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Bass drum", "Percussion"] ["low quality", "latin jazz", "groovy piano chords", "wooden percussion", "drums solo", "punchy kick", "punchy snare", "low tom roll", "shimmering hi hats", "energetic", "exciting"] 4 MrMXYO2fzJ4 2303

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;