musiccaps
2 rows where aspect_list contains "dj scratching", aspect_list contains "energetic", aspect_list contains "groovy" and aspect_list contains "low quality"
This data as json, CSV (advanced)
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"] | |
UDTsCTLkZzc | The low quality recording features an electro song being scratched by a DJ. The song consists of synth lead melody, punchy kick, claps, boomy bass and reverberant metallic impacts. It sounds groovy and energetic. | ["electro", "low quality", "dj scratching", "flat male vocal", "synth lead melody", "punchy kick", "claps", "boomy bass", "energetic", "reverberant metallic impact", "groovy"] | ["Scratching (performance technique)", "Electronic music", "House music", "Music"] | 4 | 90 | 100 | 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 );