musiccaps
2 rows where aspect_list contains "fun" and aspect_list contains "piano"
This data as json, CSV (advanced)
aspect_list (array) 17 ✖
- fun · 2 ✖
- piano · 2 ✖
- bongo 1
- brass instruments 1
- brass section 1
- busy percussion 1
- charming female vocalist 1
- claves 1
- conga 1
- dance 1
- energetic 1
- energetic female vocalist 1
- fast tempo 1
- group male vocals 1
- latin 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"] | |
q9Gh-zh-5Ig | Energetic, fun latin salsa music with a fast tempo that includes busy percussion, a brass section, piano, group male vocals. | ["latin", "busy percussion", "brass section", "piano", "group male vocals", "energetic", "fun", "fast tempo"] | ["Afrobeat", "Music of Africa", "Flamenco", "Music"] | 8 | 250 | 260 | 0 | 0 | ["/m/0145m", "/m/0164x2", "/m/0326g", "/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 );