musiccaps
1 row where aspect_list contains "ambient room noise" and aspect_list contains "knob turns"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- ambient room noise · 1 ✖
- amplified guitar playing in rhythm 1
- classic rock 1
- echo tones 1
- electric buzz 1
- electric hum 1
- energetic 1
- groovy music 1
- increasing volume 1
- instrumental music 1
- knob turns · 1 ✖
- medium tempo 1
- passionate 1
- plugging into the guitar 1
- rebellion 1
- rock guitar 1
- rock music 1
- song intro 1
- strings making noises 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
HEk4fx_XNNE | The song is an instrumental. The song is medium tempo with ambient room noises, like a volume knob turned up, a guitar being plugged in and the rhythmic strumming of an amplified distortion guitar. The song is energetic and passionate. The song is an introduction to a rock song. | ["knob turns", "electric hum", "increasing volume", "strings making noises", "plugging into the guitar", "ambient room noise", "echo tones", "amplified guitar playing in rhythm", "medium tempo", "instrumental music", "song intro", "rock music", "groovy music", "youthful", "energetic", "passionate", "rebellion", "classic rock", "rock guitar", "electric buzz"] | ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | 1 | 20 | 30 | 0 | 1 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/0b_fwt", "/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 );