musiccaps_details (view)
1 row where musiccaps_aspects contains "metallic electric guitar", musiccaps_author = 3 and musiccaps_names contains "Bass drum"
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
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;