musiccaps_details (view)

2 rows where musiccaps_aspects contains "pop", musiccaps_author = 4 and musiccaps_names contains "Bass 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
Fede - Kesha - Your Love is My Drug (Drum Cover) World Version The low quality recording features a drum cover of a pop song that consists of energetic tom rolls, shimmering cymbals and punchy kick and snare hits. The audio slowly fades out, as it is probably an Outro section of the song. 2010-11-17T15:24:33Z FedeRabaquino Follow me on: Instagram: https://www.instagram.com/federabaquino Facebook: http://www.facebook.com/FedeRabaquinoMusic Twitter: http://www.twitter.com/FedeRabaquino I had to reupload this video due to copyright issues, I appologize for the audio quality, I had to pitch the song 1 semitone lower and touch the eq, to get a different wave of the track to avoid the copyright guys from bolcking my drum cover. I think that people in the US can still watch my original version with hi quality audio. Thank you guys for all the support and comments you leave on each video. About my youtube videos: I have 10 new drum covers, You can watch them in HD 720, I picked the songs, I´ll be uploding new videos every 2 weeks, The drum kit I used in this series is detailed on my youtube page. Please don´t forget to subscribe!!! Kesha - "Your Love is My Drug" from the 2010 release "Animal" Copyrighted property of its owner(s) -{}- Earphones & Headphones: MEElectronics | http://www.meelec.com ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] ["low quality", "cover", "pop", "energetic tom rolls", "shimmering cymbals", "punchy kick", "punchy snare", "fade out", "outro"] 4 FvdUm5j_oA0 1677
RWBY Crack | #1 The low quality recording features a drums solo at the very beginning of the loop, after which a pop song starts playing and it consists of a passionate female vocal singing over buzzy synth lead melody. The drums solo contains snare roll and shimmering cymbals. Overall it sounds exciting. 2014-11-24T04:20:16Z cookies RWBY Crack, Episode 1~ I think I should DEFINATELY do more of these XD ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] ["low quality", "drums solo", "snare roll", "shimmering cymbals", "pop", "passionate female vocal", "buzzy synth lead melody", "exciting"] 4 KqtlecvEOGw 2125

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;