musiccaps
1 row where aspect_list contains "ending song" and aspect_list contains "male vocalist"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- electric guitar 1
- ending song · 1 ✖
- first love 1
- infectious drumming 1
- keyboard harmony 1
- love song 1
- male vocalist · 1 ✖
- medium fast tempo 1
- mellow 1
- ost 1
- pop 1
- romantic 1
- sentimental 1
- soft rock 1
- steady bass lines 1
- tender 1
- violin harmony soft 1
- you’ve got mail 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
6PWiDlWmPs0 | A male vocalist sings this romantic song. The tempo is medium fast with keyboard harmony, infectious drumming, steady bass lines and electronic guitar. The song is simple, mellow, tender, sentimental, emotional and mellow. This is a Romantic Soft Rock. | ["male vocalist", "medium fast tempo", "infectious drumming", "sentimental", "mellow", "tender", "love song", "first love", "pop", "ost", "you’ve got mail", "ending song", "keyboard harmony", "steady bass lines", "violin harmony soft", "mellow", "romantic", "soft rock", "electric guitar"] | ["Jazz", "Music", "Rhythm and blues"] | 7 | 30 | 40 | 0 | 0 | ["/m/03_d0", "/m/04rlf", "/m/06j6l"] |
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 );