musiccaps
1 row where aspect_list contains "four chord" and aspect_list contains "r&b"
This data as json, CSV (advanced)
aspect_list (array) 8 ✖
- electronic drums 1
- female vocalist 1
- four chord · 1 ✖
- hip hop 1
- minor key 1
- modern production 1
- r&b · 1 ✖
- synthesizer pad 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
4QES-SJ7mP0 | A four chord modern hip hop/ R&B production featuring synthesizer pads, electronic drums, a female vocalist in a minor key. | ["r&b", "synthesizer pad", "electronic drums", "female vocalist", "hip hop", "minor key", "modern production", "four chord"] | ["Afrobeat", "Music", "Hip hop music"] | 8 | 210 | 220 | 0 | 0 | ["/m/0145m", "/m/04rlf", "/m/0glt670"] |
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 );