musiccaps
1 row where aspect_list contains "chirpy" and aspect_list contains "plucking"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- 8 stringed instrument 1
- acoustic guitar accompaniment 1
- animated 1
- bright 1
- cheerful 1
- chirpy · 1 ✖
- dance music 1
- folk music 1
- happy 1
- high notes 1
- instrumental 1
- lively 1
- lute family 1
- mandolin 1
- mandolin harmony 1
- plucking · 1 ✖
- soprano string instrument 1
- spirited 1
- string harmony 1
- stringed instruments 1
- sunny 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
D-p9s8y2z_U | This music is instrumental . The tempo is fast with mandolins playing a lively, spirited rhythmic harmony with acoustic guitar accompaniment. The instrumentation is minimal with emphasis on the mandolin melody. The music is chirpy, perky, cheerful, happy, animated and spirited. | ["instrumental", "mandolin", "mandolin harmony", "stringed instruments", "8 stringed instrument", "string harmony", "lute family", "soprano string instrument", "high notes", "plucking", "lively", "cheerful", "happy", "sunny", "chirpy", "bright", "animated", "spirited", "dance music", "folk music", "acoustic guitar accompaniment"] | ["Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | 7 | 0 | 10 | 0 | 1 | ["/m/042v_gx", "/m/04rlf", "/m/04rzd", "/m/04szw", "/m/0fx80y"] |
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 );