musiccaps
1 row where aspect_list contains "electric guitar" and aspect_list contains "jarring"
This data as json, CSV (advanced)
aspect_list (array) 14 ✖
- amateur recording 1
- amplified guitar 1
- boomy 1
- distorted audio 1
- electric guitar · 1 ✖
- electrical distortion 1
- home video 1
- instrumental 1
- jarring · 1 ✖
- loud feed back 1
- resonant 1
- reverberating 1
- sonic power 1
- vibrations 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
Xus0LI3QV2A | This clip is an instrumental. The tempo is slow and deliberate with an electric guitar playing an energetic riff. It is minimal instrumentation with no other instrument used. The electric guitar is loud, boomy, jarring, resonant,recurring, with an insistent riff. | ["instrumental", "electric guitar", "jarring", "reverberating", "boomy", "home video", "amateur recording", "vibrations", "sonic power", "amplified guitar", "resonant", "loud feed back", "distorted audio", "electrical distortion"] | ["Reverberation", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Music", "Distortion"] | 7 | 30 | 40 | 0 | 1 | ["/m/01b9nn", "/m/01glhc", "/m/02rr_", "/m/02sgy", "/m/04rlf", "/m/0g12c5"] |
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 );