musiccaps_details (view)
6 rows where musiccaps_aspects contains "distorted", musiccaps_aspects contains "loud" and musiccaps_aspects contains "mono"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- distorted · 6 ✖
- loud · 6 ✖
- low quality 6
- mono · 6 ✖
- noisy 5
- harsh 3
- live performance 3
- crushed 2
- metal 2
- bright bells 1
- compilation 1
- crowd screaming 1
- digital piano melody 1
- electro song 1
- energetic muffled instrumental 1
- flat male vocal 1
- resonating sound 1
- screaming male vocal 1
- shofar tone 1
- weird 1
- wooden percussions 1
musiccaps_names (array) 17 ✖
- Music 4
- Drum 2
- Singing 2
- Bang 1
- Bellow 1
- Cacophony 1
- Chink, clink 1
- Drum kit 1
- Electronic music 1
- Music of Asia 1
- Percussion 1
- Pop music 1
- Punk rock 1
- Rock music 1
- Shofar 1
- Tabla 1
- Wind instrument, woodwind instrument 1
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 | ||
Vlog No. 12 - SHINee's unofficial Vlogs of 2012 - mistakes & unexpected | The low quality recording features a compilation of recordings where the first recording in the loop is a live performance that's distorted, loud and in mono. The second part of the recording is very noisy and it features bright bells, some resonating sounds and it sounds weird. | 2013-01-11T19:53:33Z | maggie198333 | more to come~ please do not re-upload https://twitter.com/maggieline7 http://www.tudou.com/home/maggie198333 | ["Singing", "Music of Asia", "Music", "Pop music", "Chink, clink"] | ["low quality", "live performance", "loud", "distorted", "bright bells", "noisy", "mono", "resonating sound", "weird", "compilation"] | 4 | 6II4JGJDyZo | 740 | |
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 | |
david vendetta actor's marrakech 2007 | The low quality recording features an electro song playing, while the crowd is screaming. It sounds loud, harsh, distorted and the recording is in mono and noisy. | 2008-01-02T01:39:28Z | MOUKHANAK | magnifique soirée a l'Actor's avec David Vendetta | ["Electronic music", "Music", "Bang"] | ["low quality", "crowd screaming", "electro song", "loud", "harsh", "distorted", "noisy", "mono"] | 4 | UxrAsZ7Z09Y | 2962 | |
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 | |
tocando el shofar | The low quality recording features a shofar tone played so loudly that the recording is distorted and harsh, aside from being already noisy itself. It is also in mono, as it was probably recorded with a phone. | 2010-03-08T23:14:09Z | shofares la gloria de DIOS | estos son shofares economicospara un hermano q yo conosco q esta en yutha | ["Wind instrument, woodwind instrument", "Shofar"] | ["low quality", "shofar tone", "loud", "distorted", "harsh", "noisy", "mono"] | 4 | fWu8vVSSkNQ | 3953 |
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;