musiccaps
1 row where aspect_list contains "dreamy" and aspect_list contains "high on adrenaline"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- adrenaline rush 1
- d]steady drumming rhythm 1
- dreamy · 1 ✖
- emotional 1
- groovy music 1
- guitar skills 1
- guitar solo 1
- high on adrenaline · 1 ✖
- instrumental hits 1
- keybiard harmony 1
- keyboard harmony 1
- medium tempo 1
- retro guitar hits 1
- rock guitar solo 1
- rock guitarist 1
- soloist 1
- steady percussion rhythm 1
- string section accompaniment 1
- tremolo 1
- vibrato 1
- whammy bar 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
BqIZipifARo | The song is an instrumental. The tempo is medium with an electric guitar playing a dreamy solo with a keyboard accompaniment , string section harmony and rhythmic percussion rhythm. The song is passionate and emotional. The song is a rock guitar instrumental. | ["guitar solo", "whammy bar", "keyboard harmony", "steady percussion rhythm", "tremolo", "vibrato", "guitar skills", "rock guitar solo", "dreamy", "emotional", "adrenaline rush", "retro guitar hits", "instrumental hits", "high on adrenaline", "string section accompaniment", "rock guitarist", "soloist", "keybiard harmony", "steady percussion rhythm", "d]steady drumming rhythm", "groovy music", "medium tempo"] | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | 1 | 80 | 90 | 0 | 0 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/06w87", "/m/0fx80y"] |
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 );