musiccaps
1 row where aspect_list contains "crushed" and aspect_list contains "electric guitar solo"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- blues 1
- brass melody 1
- crushed · 1 ✖
- distorted 1
- electric guitar solo · 1 ✖
- energetic drums 1
- low quality 1
- noisy 1
- passionate male vocal 1
- smooth bass 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
DlU56FGTVEk | The low quality record features a blues song played on some device and it features brass melody, electric guitar solo melody, energetic drums, smooth bass and passionate male vocal singing over it. It sounds crushed, distorted and noisy. | ["low quality", "blues", "electric guitar solo", "passionate male vocal", "energetic drums", "brass melody", "smooth bass", "crushed", "distorted", "noisy"] | ["Music", "Tambourine"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07brj"] |
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 );