musiccaps
1 row where aspect_list contains "instructive" and aspect_list contains "single instrument"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- effect pedal 1
- electric guitar 1
- guitar solo 1
- instructive · 1 ✖
- instrumental 1
- jam 1
- male voice 1
- reverb 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 |
---|---|---|---|---|---|---|---|---|---|---|
n179cK8EubU | This is a gear showcase jam. There is a male voice talking in between the sounds giving information about a reverb pedal. There is an electric guitar playing random tunes with the reverb effect. The tunes in the recording are simple. Sounds from this recording could be sampled for use in beat-making. | ["jam", "instrumental", "single instrument", "male voice", "instructive", "electric guitar", "guitar solo", "effect pedal", "reverb", "simple tunes"] | ["Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Distortion"] | 9 | 320 | 330 | 0 | 0 | ["/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/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 );