musiccaps
1 row where aspect_list contains "jazz chord progression" and aspect_list contains "piano"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- acoustic guitar solo 1
- concert hall 1
- heartfelt 1
- instrumental 1
- jazz chord progression · 1 ✖
- live 1
- loud upright bass 1
- no drums 1
- piano · 1 ✖
- trio 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
d1nz5tZckSA | Trio recorded live in a concert hall with a loud upright bass, piano and acoustic guitar playing a solo. Jazz feel and chord progression with no drums. Heartfelt performance. | ["loud upright bass", "acoustic guitar solo", "jazz chord progression", "piano", "no drums", "instrumental", "trio", "concert hall", "live", "heartfelt"] | ["Music", "Harmonic", "Inside, large room or hall"] | 8 | 280 | 290 | 1 | 1 | ["/m/04rlf", "/m/0b9m1", "/t/dd00126"] |
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 );