musiccaps
1 row where aspect_list contains "amp plug" and aspect_list contains "jam"
This data as json, CSV (advanced)
aspect_list (array) 9 ✖
- amp plug · 1 ✖
- easygoing 1
- electric guitar 1
- guitar solo 1
- instrumental 1
- jam · 1 ✖
- no singer 1
- simple tunes 1
- single instrument 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
H6Y_7Ax34-g | This is a gear review jam. There is an electric guitar playing simple tunes. An amp plug is connected to the electric guitar. The atmosphere is easygoing. Sounds from this recording can be sampled to be used in advertisement jingles. | ["jam", "no singer", "instrumental", "single instrument", "electric guitar", "guitar solo", "amp plug", "easygoing", "simple tunes"] | ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | 9 | 290 | 300 | 0 | 0 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/0b_fwt", "/m/0fx80y", "/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 );