musiccaps
1 row where aspect_list contains "fun", aspect_list contains "salsa music" and audioset_names contains "Music of Latin America"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 );