musiccaps
1 row where aspect_list contains "homer simpson cover" and aspect_list contains "simple melody"
This data as json, CSV (advanced)
aspect_list (array) 17 ✖
- amateur singing 1
- animated 1
- auto tune 1
- childish lyrics 1
- funny 1
- guitar 1
- home video 1
- homer simpson cover · 1 ✖
- keyboard harmony 1
- male vocalist 1
- medium fast tempo 1
- off key singing 1
- relatable 1
- rhythmic acoustic 1
- simple bass lines 1
- simple melody · 1 ✖
- steady drumming 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
4W8IZxn3nEI | A male vocalist sings this animated song. The tempo is medium fast with keyboard harmony, acoustic guitar , steady drumming and simple bass lines. The song is simple, catchy, funny, spirited, animated and easy to sing along. The lyrics are funny. | ["male vocalist", "medium fast tempo", "off key singing", "relatable", "simple melody", "funny", "homer simpson cover", "home video", "amateur singing", "animated", "childish lyrics", "keyboard harmony", "steady drumming", "simple bass lines", "auto tune", "rhythmic acoustic", "guitar"] | ["Music", "/t/dd00003", "Synthetic singing"] | 7 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00003", "/t/dd00006"] |
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 );