musiccaps
2 rows where aspect_list contains "happy", aspect_list contains "low quality", aspect_list contains "shimmering hi hats" and aspect_list contains "wooden percussions"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-rAhS48FkYw | The low quality recording features a pop song that consists of a passionate male vocal singing over mellow kick hits, shimmering hi hats, wide electric guitar melody, syncopated snare and wooden percussion. The first half of the loop does not consist of the vocal, snare and hi hats. It sounds happy, fun and joyful. | ["low quality", "pop", "passionate male vocal", "happy", "fun", "joyful", "mellow kick hits", "shimmering hi hats", "wide electric guitar melody", "wooden percussions", "syncopated snare"] | ["Blues", "Music"] | 4 | 30 | 40 | 0 | 0 | ["/m/0155w", "/m/04rlf"] | |
PnJx0uLJ_oE | The low quality recording features a traditional song that consists of a flat male vocal singing over shimmering hi hats, strings melody and wooden percussion, while a male vocal is mocking them. It sounds groovy, funny and it gives off happy vibes. | ["low quality", "male mocking vocal", "flat male vocal", "strings melody", "wooden percussions", "shimmering hi hats", "groovy", "fun", "happy", "traditional"] | ["Music", "Reggae", "/t/dd00032"] | 4 | 140 | 150 | 0 | 0 | ["/m/04rlf", "/m/06cqb", "/t/dd00032"] |
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 );