musiccaps
1 row where aspect_list contains "amateur recording" and aspect_list contains "dj song"
This data as json, CSV (advanced)
aspect_list (array) 8 ✖
- amateur recording · 1 ✖
- bass 1
- dj song · 1 ✖
- male voice 1
- moderate tempo 1
- programmed percussion 1
- synth sounds 1
- vinyl scratching 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
-m5ZlWziIeA | This amateur recording features a vinyl scratch being played on a DJ console. This is accompanied by programmed percussion playing a simple beat at a fast tempo. The hi-hat is struck in eighth notes. The snare and kick are played in a unique pattern. A synth plays a two-note lick at different intervals. Other instruments are not audible as the audio quality is low. | ["amateur recording", "vinyl scratching", "programmed percussion", "bass", "synth sounds", "moderate tempo", "male voice", "dj song"] | ["Scratching (performance technique)", "Electronic music", "House music", "Music"] | 0 | 200 | 210 | 0 | 0 | ["/m/01hgjl", "/m/02lkt", "/m/03mb9", "/m/04rlf"] |
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 );