musiccaps
2 rows where aspect_list contains "dj scratching" and aspect_list contains "punchy snare"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- dj scratching · 2 ✖
- low quality 2
- punchy kick 2
- punchy snare · 2 ✖
- cool 1
- electro dub 1
- energetic 1
- groovy 1
- hip hop 1
- mono 1
- muddy 1
- muffled 1
- noisy 1
- short bass stabs 1
- simple synth bells melody 1
- soft crash cymbal 1
- sustained filter mod bass 1
- uptempo hi hats 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
A6ilKRqIDH4 | The low quality recording features a DJ scratching a vinyl of an electro dub song that consists of uptempo hi hats, punchy kick and snare hits, short bass stabs, soft crash cymbal and simple synth melody. It sounds energetic, cool and groovy. | ["low quality", "electro dub", "dj scratching", "punchy snare", "punchy kick", "uptempo hi hats", "soft crash cymbal", "simple synth bells melody", "energetic", "cool", "groovy", "short bass stabs"] | ["Scratching (performance technique)", "Sampler", "Music", "Scratch", "Dubstep", "Drum machine"] | 4 | 30 | 40 | 0 | 1 | ["/m/01hgjl", "/m/01v1d8", "/m/04rlf", "/m/07qb_dv", "/m/07s72n", "/m/0cfdd"] | |
zNgRUFOj3HI | The low quality recording features a DJ scratching the vinyl of a hip hop instrumental that consists of punchy kick and snare hits and sustained filter modulated bass. The recording is muffled, noisy, mono and muddy, as it was probably recorded with a phone. | ["low quality", "dj scratching", "hip hop", "sustained filter mod bass", "punchy kick", "punchy snare", "muffled", "noisy", "mono", "muddy"] | ["Scratching (performance technique)", "Sampler", "Music", "Scratch", "Drum machine", "Synthesizer"] | 4 | 30 | 40 | 1 | 1 | ["/m/01hgjl", "/m/01v1d8", "/m/04rlf", "/m/07qb_dv", "/m/0cfdd", "/m/0l14qv"] |
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 );