musiccaps
1 row where aspect_list contains "acoustic guitar harmony" and aspect_list contains "electric guitar lead"
This data as json, CSV (advanced)
aspect_list (array) 19 ✖
- acoustic guitar harmony · 1 ✖
- compelling 1
- cover song 1
- electric guitar lead · 1 ✖
- emphatic 1
- emphatic vocals 1
- female vocalist 1
- hard rock 1
- keyboard accompaniment 1
- lively electric guitar 1
- medium tempo 1
- passionate 1
- persuasive 1
- pop rock 1
- powerful 1
- powerful vocals 1
- rock 1
- steady drumming 1
- tambourine beats 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
W2EJai-3k2w | A female vocalist sings this passionate Rock song. The tempo is medium with infectious electric guitars on lead and harmony, tambourine beats , steady drumming and keyboard accompaniment. The song is intense, passionate, empathic, powerful, persuasive and compelling. This song is Soft Rock. | ["female vocalist", "medium tempo", "cover song", "passionate", "emphatic", "powerful", "persuasive", "compelling", "tambourine beats", "lively electric guitar", "electric guitar lead", "acoustic guitar harmony", "keyboard accompaniment", "emphatic vocals", "powerful vocals", "steady drumming", "rock", "hard rock", "pop rock"] | ["Singing", "Music", "Grunge"] | 7 | 130 | 140 | 0 | 1 | ["/m/015lz1", "/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 );