musiccaps
1 row where aspect_list contains "groovy double bass" and aspect_list contains "soft kick hits"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- groovy 1
- groovy double bass · 1 ✖
- groovy piano melody 1
- jazz 1
- passionate 1
- reverberant saxophone 1
- shimmering cymbals 1
- soft kick hits · 1 ✖
- trumpet melody 1
- uptempo 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
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 );