musiccaps
2 rows where aspect_list contains "manic" and audioset_ids contains "/m/07qb_dv"
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 |
---|---|---|---|---|---|---|---|---|---|---|
cWOohqFud6g | The low quality recording features a DJ scratching a vinyl of a jungle song that consists of punchy kick and snare hits layered with energetic crash cymbal and groovy bass. The song sounds thin as it is probably playing on a speaker. The recording itself is noisy and in mono. It sounds energetic and aggressive overall. | ["dj scratching sound effect", "manic", "aggressive", "mono", "jungle", "punchy kick", "punchy snare", "energetic crash cymbals", "groovy bass", "thin", "noisy", "low quality"] | ["Scratching (performance technique)", "Music", "Scratch", "Drum machine"] | 4 | 30 | 40 | 0 | 1 | ["/m/01hgjl", "/m/04rlf", "/m/07qb_dv", "/m/0cfdd"] | |
hu6sChY-Yps | The low quality recording features a DJ scratching the vinyl of a hip hop song that consists of punchy kick and snare, repetitive wooden percussive elements, shimmering hi hats and open hats and soft crash cymbals. It sounds manic, energetic and kind of muffled, since it was probably recorded with a poor quality microphone. | ["low quality", "dj scratching vinyl", "hip hop", "punchy snare", "punchy kick", "repetitive wooden percussive elements", "shimmering hi hats", "soft crash cymbal", "muffled", "energetic", "manic"] | ["Scratching (performance technique)", "Music", "Scratch"] | 4 | 30 | 40 | 1 | 1 | ["/m/01hgjl", "/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 );