musiccaps
1 row where aspect_list contains "effects pedal" and aspect_list contains "electric guitar"
This data as json, CSV (advanced)
aspect_list (array) 6 ✖
- effects pedal · 1 ✖
- electric guitar · 1 ✖
- guitar lick 1
- instrumental 1
- no other instruments 1
- no voices 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
pL71P2hVjMc | This audio features an electric guitar. This guitar is played through an effects pedal adding reverb to the sound. A guitar lick is played with one open string and the melody on the higher register of another string. There are no other instruments in this song. There is no voice in this song. This song can be played in an instructional video on effects pedals. | ["electric guitar", "effects pedal", "no voices", "instrumental", "guitar lick", "no other instruments"] | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Distortion"] | 0 | 270 | 280 | 0 | 0 | ["/m/01b9nn", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0b_fwt", "/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 );