musiccaps_details (view)
2 rows where musiccaps_aspects contains "aggressive" and musiccaps_aspects contains "weird"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- aggressive · 2 ✖
- low quality 2
- weird · 2 ✖
- aggressive male breathing 1
- buzzy synth leads 1
- clapping 1
- claps 1
- dj scratching sound effects 1
- energetic 1
- foot stomping 1
- groovy bass 1
- punchy "4 on the floor" kick pattern 1
- shimmering hi hats 1
- short accordion melody 1
- techno 1
- uncomfortable 1
- weird mouth noises 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Weird Al Yankovic - Another One Rides The Bus | The Low quality recording features a widely spread, weird mouth noises, foot stomping in the right channel and aggressive male breathing and claps in the left channel of the stereo image. There is a short accordion melody at the very beginning of the loop. It sounds very weird and aggressive, almost uncomfortable. | 2007-12-18T11:03:59Z | Brian Fountain | Another One Rides The Bus - Weird Al,a little video for fun | ["Burping, eructation", "Music"] | ["short accordion melody", "aggressive male breathing", "clapping", "foot stomping", "weird mouth noises", "weird", "low quality", "aggressive", "uncomfortable"] | 4 | _KYo_89lgf0 | 3464 | |
Dancing to Techno Music | The low quality recording features a techno song that consists of DJ scratching sound effects, groovy bass, buzzy synth leads, punchy "4 on the floor" kick pattern, shimmering hi hats and some claps. It sounds energetic, aggressive and weird - due to those synth lead "screams". | 2007-10-27T05:55:40Z | Sebastien Verrot | A french dancer, Spoke, dancing to techno music with a combination of smurf, break dance and tecktonik. | ["Electronic music", "House music", "Music", "Techno"] | ["techno", "low quality", "dj scratching sound effects", "groovy bass", "buzzy synth leads", "punchy \"4 on the floor\" kick pattern", "shimmering hi hats", "claps", "energetic", "weird", "aggressive"] | 4 | nvoGwmKh6NI | 4592 |
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;