musiccaps_details (view)
2 rows where musiccaps_aspects contains "loud", musiccaps_aspects contains "messy" and musiccaps_aspects contains "muffled"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- loud · 2 ✖
- low quality 2
- messy · 2 ✖
- muffled · 2 ✖
- 4 on the floor kick 1
- acoustic guitar melody 1
- aggressive 1
- distorted 1
- dull 1
- emotional 1
- energetic 1
- flat male vocal 1
- folk 1
- live performance 1
- loud passionate male vocal 1
- manic drums 1
- mellow pad chords 1
- metal 1
- percussive bongos 1
- repetitive cowbell percussion 1
- shimmering shakers 1
- traditional 1
- uptempo 1
musiccaps_names (array) 9 ✖
- Cowbell 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Music 1
- Music of Bollywood 1
- Percussion 1
- Rimshot 1
- Sad music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
bangla music sad song monir khan | The low quality recording features a folk song that consists of loud passionate male vocal singing over acoustic guitar melody, shimmering shakers, percussive bongos, "4 on the floor" kick and mellow pad chords. It sounds loud, dull, messy and muffled, since the frequencies are clashing. It also sounds traditional and emotional. | 2010-10-19T18:51:15Z | 1JIBONCOMILLACITY | ["Music", "Music of Bollywood", "Sad music"] | ["low quality", "loud passionate male vocal", "acoustic guitar melody", "shimmering shakers", "percussive bongos", "4 on the floor kick", "loud", "traditional", "folk", "emotional", "mellow pad chords", "dull", "messy", "muffled"] | 4 | BL181hSAG60 | 1229 | ||
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;