musiccaps
2 rows where aspect_list contains "mono" and audioset_ids contains "/m/03qtq"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-CUp_Tmg2Y0 | The low quality recording features a drum solo that consists of a double pedal kick, punchy snare, shimmering cymbals and boomy toms. It sounds energetic and manic, thanks to that kick pattern. The recording is mono and noisy. | ["low quality", "mono", "noisy", "drums solo", "double pedal kick", "punchy snare", "shimmering cymbals", "boomy toms", "energetic", "manic"] | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Bass drum", "Percussion"] | 4 | 30 | 40 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/03qtq", "/m/03t3fj", "/m/0bm02", "/m/0l14md"] | |
jR_wBfxgZwE | The low quality recording features laughing male sounds over sloppy drums that contain energetic crash cymbal hits and toms percussion. It sounds exciting, even though the recording is noisy and in mono, as it was probably recorded with a phone. | ["low quality", "noisy", "mono", "exciting", "laughing male sounds", "toms percussions", "energetic crash cymbal", "sloppy drums"] | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 4 | 10 | 20 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/02k_mr", "/m/03qtq", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] |
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 );