musiccaps
2 rows where aspect_list contains "groovy", aspect_list contains "shimmering cymbals" and aspect_list contains "soft kick hits"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ZzyWbehtt0M | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | 4 | 30 | 40 | 0 | 0 | ["/m/0155w", "/m/015lz1", "/m/015y_n", "/m/01lyv", "/m/04rlf", "/m/06j6l", "/m/0g293"] | |
oBwt8T8P8Zs | The Jazz song features reverberant saxophones and trumpet melodies playing over groovy double bass, groovy piano melody, shimmering cymbals and soft kick hits. It sounds uptempo, groovy and passionate, like something you would hear in traditional jazz bars. | ["jazz", "reverberant saxophone", "trumpet melody", "shimmering cymbals", "soft kick hits", "groovy double bass", "groovy piano melody", "groovy", "uptempo", "passionate"] | ["Swing music", "Jazz", "Music"] | 4 | 380 | 390 | 0 | 0 | ["/m/015y_n", "/m/03_d0", "/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 );