musiccaps_details (view)

1 row where musiccaps_aspects contains "ride cymbal", musiccaps_names contains "Bass drum" 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
Highschool of the Dead 学園黙示録 H.O.T.D. Anime Full Theme Drum Cover by Myron Carlos Here we have an energetic, up-tempo japanese rock song. The drumming is potent, punchy and predominant. The drummer plays the ride cymbal frequently, creating a shimmery effect in the song. The female singer has a calming voice. 2013-05-25T13:13:01Z xymbalreborn Highschool of the Dead 学園黙示録 HO.T.D. Anime Full Theme Drum Cover by Myron Carlos. ANIME "SHORT" INTRO: http://www.youtube.com/watch?v=V64aypD-9Ys This is NOT a note for note cover. Yes, I know I did this one already but that was the short, one minute intro. This is the whole thing! At least, I think it is. I was asked by Niall Hamilton (http://www.youtube.com/user/TheNiallHamilton) to cover this particular arrangement. Hopefully we'll compile this together with other covers to present a full band cover of this one. Enjoy! Follow me: Youtube - http://www.youtube.com/xymbalreborn Facebook - http://www.facebook.com/xymbalreborn Google+ - http://plus.google.c...191915642/posts Twitter - http://www.twitter.com/xymbalreborn Tumblr - http://www.tumblr.co...og/xymbalreborn Pintrest - http://pinterest.com/xymbalreborn/ Webpage - http://www.myroncarlos.co.cc/ Myron Carlos is endorsed by and uses: SOULTONE CYMBALS: http://www.soultonecymbals.com SILVERFOX DRUMSTICKS: http://www.silverfoxpercussion.com GROVER PRO PERCUSSION: http://www.groverpro.com/home.html GIBRALTAR DRUM HARDWARE: http://www.gibraltarhardware.com/ REMO DRUMHEADS: http://www.remo.com/ SAMSON TECHNOLOGIES: http://www.samsontech.com/ KEEN FOOTWEAR: http://www.keenfootwear.com CYMPAD: http://www.cympad.com/ Equipment List: Drums: Tama Rockstar DX 1990 - 14" Snare - 10" Tom - 12" Tom - 13" Tom - 16" Floor Tom - 22" Bass (2) Pearl Concert Toms - 6" - 8" - 10" - 12" Cymbals: Soultone - 6" M Series Bell - 6" Extreme Splash - 10" Extreme Splash - 12" Extreme China/13" FXO Crash Stack - 13" Gospel Hi-hat - 14" Extreme Hi-hat - 16" FXO China - 16" Extreme Crash - 18" Extreme China - 18" Extreme Crash - 22" Extreme Ride Sticks: SilverFox 1A Nylon Drumheads: Remo - Snare: Black X Emperor top; Black Suede Snare resonant - Rack Toms: Black Suede Emperor top; Starfire Chrome resonant - Bass Drums: Black Suede Powerstroke 3 top with Remo Falam Slam Pads; Starfire Chrome resonant - Concert Toms: Clear Ambassador Effects: - LP Black Beauty Cowbell (2) - … ["Wood block", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] ["uptempo", "calming female vocalist", "drumming", "rock", "metallic electric guitar", "intricate electric guitar licks", "japanese rock", "punchy energetic rock drumming", "ride cymbal"] 3 YSXrSxC68VM 3285

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;