musiccaps_details (view)
4 rows where musiccaps_aspects contains "harsh" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- harsh · 4 ✖
- live performance · 4 ✖
- low quality 4
- crushed 2
- distorted 2
- energetic 2
- loud 2
- messy 2
- mono 2
- noisy 2
- addictive 1
- addictive brass melody 1
- addictive female vocal 1
- arpeggiate synth keys melody 1
- crowd excitement 1
- distorted bass 1
- electric guitar melody 1
- groovy bass 1
- harmonizing mixed vocals 1
- metal 1
- muddy 1
- muffled male vocal 1
- mystical 1
- passionate 1
- punchy kick 1
- punchy snare 1
- reggae 1
- shimmering cymbals 1
- snare roll 1
- string melody 1
- thin 1
- traditional pop 1
- unbalanced stereo 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 | |
Raskahuele--LA Sound System | The low quality recording features a live performance of a reggae song that consists of shimmering cymbals, addictive brass melody and muffled male vocal singing over it. It is noisy and in mono, and it sounds thin, harsh, muddy, messy and energetic. | 2008-06-22T17:38:28Z | Geovanni De Leon | LASS | ["Music", "Ska", "Music of Latin America"] | ["low quality", "shimmering cymbals", "noisy", "mono", "addictive brass melody", "muffled male vocal", "live performance", "reggae", "loud", "thin", "harsh", "muddy", "messy", "energetic"] | 4 | GkB_BkyVyPs | 1752 | |
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 | |
Fatima Tuz Zahra Oyshee-De De pal Tule de - Live on RTV MUSIC STATION | The low quality recording features a live performance of a traditional pop song and it consists of an addictive female vocal singing over punchy kick and snare hits, groovy bass, electric guitar melody, strings melody and wooden percussion. There is a short snare roll, right before the bass drops. It sounds messy, a bit harsh, distorted, but also passionate, addictive and energetic. | 2015-11-15T15:01:18Z | Oyshee Express | Singer- Fatima Tuz zahra Oyshee Lyric & Tune: Abdur Rahman Boyati Produced by Khoshru Anchored by Liza Bass Guitar- Sohel Rana Flute: Kamrul Lead Guitar: Roman Keyboard: Nadim Pad: Sakib Percussion: Ujjol | ["Music of Asia", "Music", "Salsa music"] | ["live performance", "low quality", "traditional pop", "addictive female vocal", "punchy snare", "wooden percussions", "snare roll", "groovy bass", "string melody", "electric guitar melody", "punchy kick", "messy", "distorted", "harsh", "passionate", "addictive", "energetic"] | 4 | eISYX9koocM | 3855 |
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;