musiccaps
1 row where aspect_list contains "bongo" and aspect_list contains "brass instruments"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- bongo · 1 ✖
- brass instruments · 1 ✖
- charming female vocalist 1
- claves 1
- conga 1
- dance 1
- energetic female vocalist 1
- fun 1
- piano 1
- salsa music 1
- upbeat 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
RneRJ5ZnHlE | This is a salsa song with an upbeat and vibrant energy. It contains typical salsa instruments like the conga, the trumpet, and the piano. The percussion is upbeat and involves bongos and congas, and the singer is lively. | ["salsa music", "upbeat", "dance", "fun", "brass instruments", "piano", "bongo", "conga", "claves", "charming female vocalist", "energetic female vocalist"] | ["Music", "Music of Latin America", "Salsa music"] | 3 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/0g293", "/m/0ln16"] |
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 );