musiccaps
1 row where audioset_names contains "Distortion", audioset_names contains "Effects unit" and audioset_names contains "Inside, small room"
This data as json, CSV (advanced)
audioset_names (array) 8 ✖
- Chorus effect 1
- Distortion · 1 ✖
- Effects unit · 1 ✖
- Guitar 1
- Inside, small room · 1 ✖
- Music 1
- Musical instrument 1
- Plucked string instrument 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
wYtd_Sq2-Tw | This song features an electric guitar playing arpeggiated chords. The guitar is playing with a flanger effect added to change the tone. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. This song can be used in an instructional video on an effects processor. | ["electric guitar", "flanger effect", "no other instruments", "no voices", "instrumental"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion", "Inside, small room"] | 0 | 240 | 250 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y", "/m/0g12c5", "/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 );