musiccaps
1 row where aspect_list contains "amplified guitar solo" and aspect_list contains "hissing tones"
This data as json, CSV (advanced)
aspect_list (array) 16 ✖
- advertisement jingle 1
- ambient room sounds 1
- amplified guitar solo · 1 ✖
- documentary sound track 1
- electric guitar solo 1
- emotional 1
- energetic 1
- guitar amplifier tone 1
- hissing tones · 1 ✖
- instrumental music 1
- long pause 1
- medium tempo 1
- poor audio quality 1
- solemn 1
- soloist 1
- song introduction 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
Y_eh6C0EBP8 | The song is an instrumental followed by a long pause. The song is medium tempo and features an electric guitar playing a solemn solo. The song is passionate and mysterious. The audio quality is poor. | ["instrumental music", "long pause", "electric guitar solo", "poor audio quality", "song introduction", "soloist", "hissing tones", "ambient room sounds", "documentary sound track", "advertisement jingle", "amplified guitar solo", "solemn", "emotional", "energetic", "guitar amplifier tone", "medium tempo", "instrumental music"] | ["Silence", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | 1 | 0 | 10 | 0 | 1 | ["/m/028v0c", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0b_fwt", "/m/0fx80y", "/t/dd00125"] |
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 );