musiccaps_details (view)
1 row where musiccaps_aspects contains "bass" and musiccaps_aspects contains "booming" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- bass · 1 ✖
- bass drum 1
- booming · 1 ✖
- ceremonial drum 1
- deep sounding 1
- drum beats 1
- instrumental 1
- kick drum 1
- low pitched 1
- march 1
- medium tempo 1
- percussion instrument 1
- percussion instrumental 1
- resounding 1
- rhythmic time 1
- song introduction 1
- tutorial 1
- vibrato 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PANCAKE GONG DRUM - DW Drums | sound test by christian eichlinger | This music is a percussion instrumental. The tempo is medium fast with the drummer playing a groovy beat on the bass drum. The effect is low pitched loud, booming, resounding vibrato. There is no other instrument in this clip, so this could either be a tutorial or an introduction to a song. | 2016-09-01T22:16:14Z | CHRISTIAN EICHLINGER Drummer & Webdesigner | Sound test of the "DW - Pancake Gong Drum". More details can be found at my BLOG http://www.christianeichlingerblog.de/?p=11690 No Compressor or EQ! Recorded and filmed at DANTE AUDIO PRODUCTION Augsburg in 2016 FACEBOOK http://facebook.com/christianeichlingermusic TWITTER http://twitter.com/chriseichlinger INSTAGRAM http://instagram.com/christianeichlingerdrums OFFICIAL http://christian-eichlinger.de BLOG http://christianeichlingerblog.de No Compressor or EQ! Recorded and filmed at DANTE AUDIO PRODUCTION Augsburg in 2016 Christian Eichlinger is an official band member of the Progressive Metal Band DANTE http://danteband.de http://shop.danteband.de http://blog.danteband.de http://facebook.com/danteprog DRUM Kit PEARL - MRP Set #165B Diamondburst / Black Hardware 22" x 18" Kick 10" x 8" Tom 10" x 9" Tom 12" x 10" Tom 13" x 11" Tom 14" x 12" Tom 16" x 16" Floor Tom 18" x 16" Floor Tom DW Drums 20"x 2 1/2 Pancake Gong Drum SNARE Drums 14" x 8" Tama Starclassic Bubinga 10" x 6,2" Pearl Mike Mangini Signature 10" x 5 1/2" Tama Bill Bruford Signature MEINL Cymbals 22" Byzance Vintage Pure Ride 20" Byzance Extra Dry China, 20" Byzance Extra Dry Crash 19" Byzance Extra Dry Crash 18" Byzance Brilliant Medium Crash 16" Byzance Brilliant Medium Crash 16" Byzance Extra Dry China 14" Byzance Dark Hihat (Main) 13" Byzance Extra Dry Hihat (2nd) 10" Byzance Extra Dry Splash 8" Byzance Dark Splash 6" Classics Low Bell 6" Classics High Bell EVANS Drumheads KICK : EMAD Heavyweight TT&FT : Black Chrome SNARE (2nd & 3rd) : Onyx SNARE (MAIN) : HD VIC FIRTH Sticks 5B Titan Carbon Micorphones KICK : Shure Beta91a SNARE DRUM : Audix I5 OVERHEADS : AKG C 451 b ROOM: Octava MK12 Enjoy watching and support me: OFFICIAL http://christian-eichlinger.de BLOG http://christianeichlingerblog.de FACEBOOK http://facebook.com/christianeichlingermusic TWITTER http://twitter.com/chriseichlinger INSTAGRAM http://instagram.com/christianeichlingerdrums | ["Timpani", "Music"] | ["instrumental", "medium tempo", "song introduction", "tutorial", "percussion instrumental", "drum beats", "vibrato", "bass", "ceremonial drum", "bass drum", "kick drum", "rhythmic time", "booming", "resounding", "march", "low pitched", "percussion instrument", "deep sounding"] | 7 | GglIHiqClGM | 1746 |
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;