musiccaps
2 rows where aspect_list contains "emotional", aspect_list contains "energetic", aspect_list contains "groovy bass" and aspect_list contains "noisy"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
2I6pPRWKsCQ | The low quality recording features a live performance of a R&B song that consists of muffled male vocal singing over groovy bass guitar, mellow synth keys melody and energetic drums. There are some crowd noises in the background. The recording is noisy, as it was probably recorded with a phone, but it sounds energetic, passionate and emotional. | ["low quality", "noisy", "crowd noise", "live performance", "r&b", "energetic drums", "muffled male vocal", "groovy bass", "mellow synth keys melody", "energetic", "passionate", "emotional"] | ["Electric piano", "Keyboard (musical)", "Piano"] | 4 | 380 | 390 | 0 | 0 | ["/m/01s0ps", "/m/05148p4", "/m/05r5c"] | |
WmTDKYYH5OU | The low quality recording features a flat male vocal rapping over sustained strings melody, punchy kick, mellow snare, groovy bass and some commentary that can be heard in the background. It sounds emotional, energetic and the recording is noisy. | ["low quality", "sustained strings", "flat male vocal", "punchy kick", "mellow snare", "groovy bass", "commentary", "noisy", "emotional", "energetic"] | ["Cello", "Double bass", "Bowed string instrument"] | 4 | 180 | 190 | 0 | 0 | ["/m/01xqw", "/m/02fsn", "/m/0l14_3"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );