musiccaps
1 row where aspect_list contains "love song" and aspect_list contains "rock"
This data as json, CSV (advanced)
aspect_list (array) 15 ✖
- acoustic guitar accompaniment 1
- alternative metal 1
- alternative rock 1
- ambient sounds 1
- auditorium acoustics 1
- emotional 1
- live performance 1
- love song · 1 ✖
- male vocalist 1
- medium tempo 1
- minimalist 1
- passionate 1
- rock · 1 ✖
- romantic 1
- sentimental 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
9ogEGxsJcSY | A male vocalist sings this passionate song. The tempo is slow with emphatic vocals and an acoustic guitar accompaniment. The song is melodic, emotional,sentimental, passionate,pensive, reflective and deep. This song is Alternative Rock. | ["male vocalist", "medium tempo", "rock", "alternative rock", "alternative metal", "acoustic guitar accompaniment", "minimalist", "live performance", "ambient sounds", "auditorium acoustics", "romantic", "love song", "passionate", "emotional", "sentimental"] | ["Blues", "Music"] | 7 | 30 | 40 | 0 | 0 | ["/m/0155w", "/m/04rlf"] |
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 );