musiccaps
2 rows where aspect_list contains "exciting", aspect_list contains "groovy bass", aspect_list contains "happy" and aspect_list contains "joyful"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BfUoopDpmmY | The low quality recording features a children's song that features a flat male vocal, alongside wide harmonizing children vocals, singing over acoustic rhythm guitar, steel guitar melody, happy bells melody, soft kick hits, mellow snare hits, shimmering hi hats and groovy bass. It sounds joyful, happy and exciting. | ["low quality", "children song", "flat male vocal", "wide harmonizing children vocals", "groovy bass", "acoustic rhythm guitar", "steel guitar melody", "shimmering hi hats", "happy bells melody", "soft kick hits", "mellow snare hits", "joyful", "happy", "exciting"] | ["Singing", "Music", "Music for children", "Song"] | 4 | 30 | 40 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/05fw6t", "/m/074ft"] | |
d61plJ66vE8 | The low quality recording features a fruity male vocal singing over steel drums melody, electric guitar melody, brass stabs, punchy kick and snare hits, energetic crash cymbal, groovy bass, shimmering shakers and sustained organ keys chord. It sounds joyful, happy and exciting. | ["low quality", "steel drums melody", "electric guitar melody", "brass stabs", "sustained organ keys chord", "punchy snare", "punchy kick", "groovy bass", "energetic crash", "fruity male vocal", "shimmering shakers", "joyful", "happy", "exciting"] | ["Singing", "Funk", "Music"] | 4 | 110 | 120 | 0 | 0 | ["/m/015lz1", "/m/02x8m", "/m/04rlf"] |
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 );