musiccaps
1 row where aspect_list contains "amplified" and aspect_list contains "instructional video"
This data as json, CSV (advanced)
aspect_list (array) 27 ✖
- amplified · 1 ✖
- amplified guitar 1
- bass electric guitar 1
- bass lines 1
- dense sounds 1
- electric guitar 1
- energetic 1
- enthusiastic riff 1
- groovy 1
- instructional video · 1 ✖
- instructions 1
- loud 1
- lower notes 1
- lower octave 1
- male vocals 1
- man talking 1
- powerful 1
- resonant 1
- skilful 1
- smooth 1
- sonic power 1
- static 1
- stringed guitar 1
- supporting instrument 1
- tutorial 1
- vibrations 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
JPZlyvPNZj4 | This music clip is a bass electric guitar instrumental. The tempo is medium fast with the guitarist playing an enthusiastic riff after giving instructions. No other instruments are used and the talking at the beginning of the audio clip indicates that this is a tutorial or instructional video. | ["male vocals", "electric guitar", "powerful", "loud", "skilful", "supporting instrument", "groovy", "dense sounds", "bass lines", "vibrations", "resonant", "bass electric guitar", "lower notes", "lower octave", "smooth", "instructional video", "sonic power", "amplified", "stringed guitar", "amplified guitar", "enthusiastic riff", "energetic", "youthful", "man talking", "tutorial", "instructions", "static"] | ["Tapping (guitar technique)", "Electric guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | 7 | 30 | 40 | 0 | 1 | ["/m/01glhc", "/m/02sgy", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/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 );