musiccaps
1 row where aspect_list contains "crowd chattering" and aspect_list contains "shimmering hi hats"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- accordion melody 1
- crowd chattering · 1 ✖
- electric guitar melody 1
- folk 1
- groovy 1
- groovy bass 1
- live performance 1
- low quality 1
- passionate 1
- punchy snare 1
- shimmering hi hats · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
ChqJYrmQIN4 | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | 4 | 50 | 60 | 0 | 0 | ["/m/015lz1", "/m/02p0sh1", "/m/04rlf", "/m/04szw", "/m/05pd6", "/m/09x0r", "/m/0g293", "/m/0mkg"] |
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 );