musiccaps
1 row where aspect_list contains "distortion guitar" and aspect_list contains "guitar instructional clip"
This data as json, CSV (advanced)
aspect_list (array) 7 ✖
- distortion guitar · 1 ✖
- guitar instructional clip · 1 ✖
- instructional audio 1
- low quality audio 1
- male voice 1
- no other instruments 1
- root and fifth 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
fsXQHyg5qDI | This song features a male giving instructions on playing a guitar. A distortion guitar is playing the root note and the fifth. After the instruction, the root note and the fifth is played individually. This song features only the male instruction voice and no vocal melody. There are no other instruments in this song. There is no percussion in this song. | ["guitar instructional clip", "low quality audio", "distortion guitar", "no other instruments", "male voice", "instructional audio", "root and fifth"] | ["Tapping (guitar technique)", "Guitar", "Musical instrument", "Plucked string instrument"] | 0 | 120 | 130 | 0 | 0 | ["/m/01glhc", "/m/0342h", "/m/04szw", "/m/0fx80y"] |
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 );