musiccaps_details (view)
5 rows where musiccaps_aspects contains "crushed" and musiccaps_aspects contains "harsh"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- crushed · 5 ✖
- harsh · 5 ✖
- low quality 5
- mono 3
- noisy 3
- distorted 2
- live performance 2
- loud 2
- arpeggiate synth keys melody 1
- crowd excitement 1
- distorted bass 1
- eastern pop 1
- echoing autotune male vocal 1
- energetic 1
- groovy 1
- harmonizing mixed vocals 1
- live prrformance 1
- loud static sound 1
- messy 1
- metal 1
- muffled instrumental 1
- mystical 1
- punk 1
- screaming female vocal 1
- shimmering shakers 1
- synth bells sound effect 1
- thin 1
- unbalanced stereo 1
- uptempo chiptune song 1
- video game sound 1
- wooden percussions 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Rescues - Shout by Tears for Fears | The low quality recording features a live performance that consists of harmonizing mixed vocals singing over distorted bass and arpeggiated synth keys melody. It sounds crushed, harsh and the stereo image is unbalanced since the sound is leaning towards the right channel of the stereo image. There are some crowd excitement sounds in the background. | 2009-08-30T15:17:59Z | thevmannc | New Project 1 | ["Music", "Whoop"] | ["low quality", "harmonizing mixed vocals", "harsh", "live performance", "distorted bass", "arpeggiate synth keys melody", "crushed", "crowd excitement", "unbalanced stereo", "mystical"] | 4 | DKBbLySEGic | 1463 | |
The Mentalists/The Good Ship | The low quality recording features a live performance of a punk song that consists of screaming female vocal singing over a muffled instrumental. It sounds energetic, harsh, crushed, loud and the recording is noisy and in mono. | 2007-05-31T20:39:50Z | Allyn Lai | Another tune by The Mentalists | ["Music", "Steelpan"] | ["low quality", "live prrformance", "punk", "screaming female vocal", "loud", "crushed", "noisy", "muffled instrumental", "energetic", "harsh", "mono"] | 4 | Ex18Xwznj60 | 1603 | |
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 | |
Chaba sousou Duo Faycal Lmignon - Khalouhe rahe mjarjarni (Jdida Live 2014) by Lamia Malahi | The low quality recording features an Eastern pop song that contains echoing autotune male vocal singing over wooden percussion and shimmering shakers. It sounds distorted, crushed, harsh and messy, as it was probably recorded with a poor quality microphone. | 2014-04-12T22:48:05Z | Lamia Malahi | ["Music", "Rattle (instrument)"] | ["eastern pop", "low quality", "shimmering shakers", "wooden percussions", "echoing autotune male vocal", "harsh", "groovy", "distorted", "crushed", "messy"] | 4 | nEOPm7TeydY | 4526 | ||
Pokemon Soul Silver Enigma Stone Event Exclusive Gameplay | The low quality recording features an uptempo chiptune song playing in the background with some synth bells sound effects. In the second half of the loop, there is a loud static noise. The recording is in mono, thin - as it lacks bass frequencies, crushed - due to the harsh mid range frequencies and it sounds like a video game sound. | 2009-11-26T23:52:43Z | Giancarlo Parimango | Pokemon Heart Gold and Soul Silver Enigma Event! More Pokemon HG/SS: http://www.youtube.com/channel/UCuoIRHs-H1gbexuM5V3g7HA?sub_confirmation=1 | ["Music", "Pink noise"] | ["low quality", "loud static sound", "uptempo chiptune song", "synth bells sound effect", "mono", "noisy", "video game sound", "harsh", "crushed", "thin"] | 4 | snYtQd1S12s | 4980 |
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;