musiccaps_details (view)
2 rows where musiccaps_aspects contains "distorted", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "flat male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- distorted · 2 ✖
- energetic · 2 ✖
- flat male vocal · 2 ✖
- live performance 2
- loud 2
- low quality 2
- addictive synth melody 1
- aggressive 1
- crowd screaming 1
- crushed 1
- energetic drums 1
- exciting 1
- groovy bass guitar 1
- manic drums 1
- messy 1
- metal 1
- muffled 1
- pop rock 1
- repetitive cowbell percussion 1
- uptempo 1
musiccaps_names (array) 9 ✖
- Cowbell 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Exciting music 1
- Music 1
- Percussion 1
- Pop music 1
- Rimshot 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;