musiccaps
1 row where aspect_list contains "piano" and aspect_list contains "quirky"
This data as json, CSV (advanced)
aspect_list (array) 9 ✖
- eccentric 1
- educational 1
- electronic drums 1
- electronic percussion 1
- instructive 1
- male vocal 1
- piano · 1 ✖
- quirky · 1 ✖
- upright bass 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
C33WdI64FiY | This is an educational music piece. The male vocalist is singing in an instructive manner asking questions directed at kids. There is a quirky piano sound joined by an upright bass. The rhythmic background consists of an electronic drum beat joined by electronic percussive sounds. There is an eccentric atmosphere to this piece. It could be used in an educational atmosphere such as an introductory physics class. | ["educational", "instructive", "male vocal", "piano", "upright bass", "electronic drums", "electronic percussion", "quirky", "eccentric"] | ["Music", "Rapping", "Tick", "Hip hop music"] | 9 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/06bxc", "/m/07qjznt", "/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 );