musiccaps
1 row where aspect_list contains "dj scratching sounds" and aspect_list contains "mono"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- dj scratching sounds · 1 ✖
- groovy 1
- hip hop 1
- low quality 1
- mono · 1 ✖
- noisy 1
- plastic tapping sounds 1
- punchy kick 1
- punchy snare 1
- shimmering hi hats 1
- syncopated open hat 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
FmytwY7SAfU | The low quality recording features a DJ scratching a hip hop song that consists of punchy kick and snare hits, shimmering hi hats and syncopated open hats. There are some plastic tapping sounds. The recording is noisy, in mono and it sounds groovy. | ["low quality", "hip hop", "dj scratching sounds", "punchy kick", "punchy snare", "shimmering hi hats", "syncopated open hat", "noisy", "mono", "plastic tapping sounds", "groovy"] | ["Scratching (performance technique)", "Funk", "Music", "Scratch"] | 4 | 60 | 70 | 0 | 0 | ["/m/01hgjl", "/m/02x8m", "/m/04rlf", "/m/07qb_dv"] |
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 );