musiccaps_details (view)
4 rows where musiccaps_aspects contains "distorted" and musiccaps_names contains "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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Photo Zardari %%Bewafa dil tori chadei. | The low quality recording features a flat male vocal singing over digital piano melody and wooden percussion. The recording is noisy, in mono, loud and distorted. | 2012-06-03T10:43:33Z | arjiskani | ["Tabla", "Drum", "Percussion"] | ["low quality", "mono", "noisy", "flat male vocal", "wooden percussions", "digital piano melody", "loud", "distorted"] | 4 | -w4HLksto_k | 102 | ||
| Avenged Sevenfold - Second Heartbeat (Cover) | The low quality recording features a live performance of a metal song. The recording is noisy, in mono and so crushed, distorted, harsh and loud that you can barely hear anything but the loud noise. | 2006-04-06T15:42:42Z | merman2006 | Here is a cover of Second Heartbeat By Avenged Sevenfold performed at the "Last KLCVI Concert" Ricky Bowes - Screams Tim Burak - Drums Steph Barette - Guitar/vocals Scott Merhar - Guitar Shawn Vucko - Bass | ["Singing", "Drum", "Drum kit", "Music", "Punk rock", "Rock music", "Bellow"] | ["low quality", "noisy", "mono", "metal", "crushed", "distorted", "loud", "live performance", "harsh"] | 4 | XjGm3Bn4j5k | 3215 | |
| Ginger Baker´s " visual drum roll" reveiled | The low quality recording features a drums solo that contains manic tom rolls and a ride cymbal one shot at the end. There was an exhale sound once the player finished his performance. The recording is very noisy, in mono and it sounds aggressive and energetic. | 2007-03-12T16:29:16Z | rootheart | VERY EASY, but sounds and looks dramatic: This is an exercise I once learned from "Ginger Baker´s Drumbook", quote "It does not only sound dramatic, but it looks amazing as the right hand is moving around the kit counterclockwise, while the left hand is moving around clockwise"...in fact extremely basic, but played fast once in a song or repeated in a solo it might be extremely impressive.. how to use it is all up t o you.. Triplets: RLR LRL... (R)mounted tom, (L)snare, (R)snare,- (L)mounted tom, (R)floortom, (L)floortom. P.S: Audio and video do not really match, it is just a simple cellphone recording. Posted a long time ago to share the lick with those who didn´t kow it yet, not to impress anyone out there. "Never play to impress the drummer from the other Band". "I no not muffle my drums, I want them to ring"..."I lock the breatherhole with a bold and a nut"" ...Quotes from Ginger Baker´s Drumbook | ["Drum", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "noisy", "drums solo", "manic tom rolls", "distorted", "mono", "exhale", "energetic", "aggressive", "ride cymbal one shot"] | 4 | bJVogLOURmc | 3615 | |
| Andy Demize Cowbell solo | The low quality recording features a live performance of a metal song that features a flat male vocal talking, repetitive cowbell percussion and manic drums. The recording is loud, messy, distorted, muffled and it sounds aggressive and uptempo. | 2007-11-20T23:16:59Z | HyperFuzz | This was during soundcheck in Detroit 11/18/07 | ["Cowbell", "Drum", "Drum kit", "Drum roll", "Rimshot", "Percussion"] | ["low quality", "uptempo", "metal", "loud", "energetic", "messy", "distorted", "flat male vocal", "manic drums", "repetitive cowbell percussion", "aggressive", "muffled", "live performance"] | 4 | jdEbwMS9xqo | 4269 |
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;