musiccaps_details (view)
5 rows where musiccaps_aspects contains "distorted", musiccaps_aspects contains "flat male vocal" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- distorted · 5 ✖
- flat male vocal · 5 ✖
- live performance · 5 ✖
- low quality 5
- loud 3
- energetic 2
- noisy 2
- "4 on the floor" kick pattern 1
- acoustic rhythm guitar 1
- addictive synth melody 1
- aggressive 1
- buzzy 1
- crowd chattering 1
- crowd screaming 1
- crushed 1
- dull 1
- energetic drums 1
- exciting 1
- groovy 1
- groovy bass guitar 1
- groovy didgeridoo 1
- manic drums 1
- messy 1
- metal 1
- muffled 1
- playback 1
- pop rock 1
- repetitive cowbell percussion 1
- shimmering hi hats 1
- snappy rimshots 1
- soft rock 1
- sustained strings melody 1
- traditional 1
- uptempo 1
- wooden percussive elements 1
- woodwinds melody 1
musiccaps_names (array) 14 ✖
- Music 4
- Cowbell 1
- Didgeridoo 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Exciting music 1
- Lullaby 1
- Musical instrument 1
- Percussion 1
- Pop music 1
- Rimshot 1
- Singing 1
- Sitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jard Seng TAI 1 1/3 ( Shanmusic.tht.in ) | The low quality recording features a live performance of a traditional song that consists of flat male vocal singing over wooden percussive elements, sustained strings melody and woodwinds melody. The recording is very noisy and buzzy. | 2010-10-14T06:25:42Z | shanmusic taisongs | Shanmusic | ["Singing", "Music", "Sitar"] | ["low quality", "live performance", "buzzy", "noisy", "flat male vocal", "wooden percussive elements", "sustained strings melody", "woodwinds melody", "distorted", "traditional"] | 4 | Orge4_UlvNI | 2475 | |
Aboriginal DIDGERIDOO Playing Live in Sydney | The low quality recording features a groovy didgeridoo playing over playback that consists of a "4 on the floor" kick pattern and shimmering hi hats, followed by snappy rimshots. There is a flat male vocal talking at one point. The recording is loud, distorted and it sounds groovy overall. | 2007-09-13T09:57:48Z | Andy Lloyd | What is says lol | ["Didgeridoo", "Music", "Musical instrument"] | ["low quality", "live performance", "groovy didgeridoo", "shimmering hi hats", "snappy rimshots", "\"4 on the floor\" kick pattern", "playback", "flat male vocal", "loud", "distorted", "groovy"] | 4 | VgwsGjRk61M | 3021 | |
Jonas Brothers - Take on Me Music Video | The low quality recording features a live performance of a pop rock song and it consists of flat male vocals counting down over addictive synth melody, energetic drums and groovy bass guitar. There are loud crowd screams in the background. It sounds distorted, loud and crushed, as it was probably recorded with a phone, but it is still energetic and exciting. | 2008-03-16T18:30:37Z | JBMusicOnRedbull465 | I took off the comments because i was super sick of what people were saying...maybe i'll put them back up later http://jbmusiconredbull.webs.com | ["Music", "Pop music", "Exciting music"] | ["pop rock", "flat male vocal", "low quality", "live performance", "energetic", "exciting", "crowd screaming", "loud", "addictive synth melody", "energetic drums", "groovy bass guitar", "distorted", "crushed"] | 4 | WTVC7ZI9WtY | 3098 | |
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 | |
the Spill Canvas - lullaby | The low quality recording features a live performance of a soft rock song that consists of acoustic rhythm guitar and flat male vocals singing over it. The crowd is loudly chattering in the background. It sounds noisy, dull and distorted. | 2008-02-12T14:07:34Z | TrickyNixon | TSC performing lullaby at Soca Basel Switzerland | ["Music", "Lullaby"] | ["low quality", "live performance", "acoustic rhythm guitar", "distorted", "noisy", "flat male vocal", "soft rock", "crowd chattering", "dull"] | 4 | r8B3-yBc-4U | 4854 |
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;