musiccaps_details (view)
5 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "metal" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- live performance · 5 ✖
- low quality 5
- metal · 5 ✖
- distorted 4
- crushed 3
- loud 3
- aggressive 2
- distorted bass guitar 2
- energetic 2
- manic drums 2
- mono 2
- noisy 2
- aggressive electric guitar melodies 1
- crowd cheering 1
- electric guitar chords 1
- energetic cymbals 1
- energetic drums 1
- energetic male vocal 1
- energetic muffled instrumental 1
- flat male vocal 1
- harsh 1
- messy 1
- muffled 1
- punchy double pedal kick 1
- punchy snare 1
- repetitive cowbell percussion 1
- screaming male vocal 1
- uptempo 1
musiccaps_names (array) 16 ✖
- Music 4
- Drum 3
- Drum kit 2
- Rock music 2
- Angry music 1
- Bellow 1
- Cacophony 1
- Cowbell 1
- Drum roll 1
- Guitar 1
- Heavy metal 1
- Percussion 1
- Punk rock 1
- Rimshot 1
- Singing 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
dsce rock band cacophony at "furore 09" | The low quality recording features a live performance of a metal song and it consists of screaming male vocal singing over energetic, muffled instrumental. The recording is crushed, loud, distorted and mono - everything that the metal live performance should be. | 2009-04-05T07:09:35Z | Puneet J | the very own band of dayananda sagar colg....!! awesome show by them at furore 2009..!! | ["Music", "Cacophony"] | ["low quality", "metal", "live performance", "screaming male vocal", "energetic muffled instrumental", "mono", "loud", "crushed", "distorted"] | 4 | IT5hcf0KhYE | 1908 | |
Motley Crue - Shout at the Devil - 9-7-2006 - Hartford, Ct. | The low quality recording features a live performance of a metal song and it consists of energetic male vocal singing over energetic drums, distorted bass guitar and electric guitar riff. It sounds crushed, energetic, distorted and noisy, as it was probably recorded with a phone. | 2007-06-28T16:44:41Z | evilcartman420 | Another great show by the Crue. | ["Music", "Whoop"] | ["low quality", "crushed", "metal", "live performance", "energetic male vocal", "electric guitar chords", "distorted bass guitar", "energetic drums", "distorted", "noisy"] | 4 | Ime3FHuQG4k | 1937 | |
Pagan's Mind - God's Equation (Live at ProgPower USA X)(HD) | The low quality recording features a live performance of a metal song that consists of manic drums played over aggressive electric guitar melodies and distorted bass guitar. The drums consist of a punchy double pedal kick, punchy snare hits and energetic cymbals. There are some crowd cheering sounds in the background. It sounds aggressive, and energetic overall. | 2010-09-01T16:15:31Z | Pagan's Mind | Pagan's Mind live at ProgPower X in Atlanta, September 2009, performing "God's Equation" as part of the "Returning Heroes" concept. https://www.facebook.com/pagansmind/ http://www.pagansmind.com/ | ["Drum", "Guitar", "Heavy metal", "Music", "Rock music", "Angry music"] | ["low quality", "live performance", "metal", "aggressive", "energetic", "crowd cheering", "manic drums", "aggressive electric guitar melodies", "distorted bass guitar", "punchy double pedal kick", "punchy snare", "energetic cymbals"] | 4 | W7i4LkdSfjw | 3068 | |
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 | |
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;