musiccaps
1 row where aspect_list contains "acoustic guitar accompaniment" and aspect_list contains "sweet"
This data as json, CSV (advanced)
aspect_list (array) 17 ✖
- acoustic guitar accompaniment · 1 ✖
- dissonant tambourine beats 1
- electric guitar rhythm 1
- emotional 1
- energetic drumming 1
- groovy bass line 1
- keyboard harmony 1
- male vocalist 1
- medium tempo 1
- mellow 1
- melodious 1
- nostalgic 1
- poignant 1
- romantic 1
- sentimental 1
- sweet · 1 ✖
- synth arrangement 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
l9vYSBR9nio | A male vocalist sings this melodic pop song.The tempo is medium with energetic drumming, keyboard harmony, groovy bass lines, electric guitar harmony, acoustic guitar rhythm and dissonant tambourine beats. The is soft, calming, mellow, sentimental, emotional and nostalgic. This song is Pop Rock/Soft Rock. | ["male vocalist", "medium tempo", "energetic drumming", "groovy bass line", "synth arrangement", "keyboard harmony", "electric guitar rhythm", "dissonant tambourine beats", "sweet", "melodious", "mellow", "romantic", "emotional", "sentimental", "nostalgic", "poignant", "acoustic guitar accompaniment"] | ["Music", "Grunge"] | 7 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/0dls3"] |
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 );