musiccaps
2 rows where aspect_list contains "groovy bass guitar", aspect_list contains "mono", aspect_list contains "passionate male vocal" and aspect_list contains "punchy snare"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1_YHHL_t2GI | The low quality recording features clapping and shoe tapping sounds over rock songs played on playback. The song consists of a passionate male vocal that sings over punchy kick and snare hits, shimmering hi hats, electric guitar melody and groovy bass guitar. The recording is in mono and a bit noisy, as it was probably recorded with a phone. | ["low quality", "clapping", "shoe tapping", "mono", "noisy", "rock", "playback", "passionate male vocal", "electric guitar melody", "punchy snare", "shimmering hi hats", "groovy bass guitar", "punchy kick"] | ["Country", "Music", "Tap"] | 4 | 150 | 160 | 0 | 0 | ["/m/01lyv", "/m/04rlf", "/m/07qcpgn"] | |
lHlOSsnP48c | The low quality recording features an uptempo rock song that consists of suspenseful electric guitar melody, punchy snare, simple kick pattern, groovy bass guitar, tinny percussive elements and passionate male vocal singing over it. The recording is in mono and it sounds energetic, groovy and like something you would dance to with your friends. | ["rock", "suspenseful electric guitar melody", "punchy snare", "simple kick pattern", "groovy bass guitar", "passionate male vocal", "mono", "low quality", "energetic", "uptempo", "tinny percussive elements"] | ["Music", "Roll", "Rock and roll"] | 4 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/07s8j8t", "/m/07sbbz2"] |
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 );