musiccaps
2 rows where aspect_list contains "punchy kick" and audioset_ids contains "/m/02w4v"
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 |
---|---|---|---|---|---|---|---|---|---|---|
8OsmFmhNjoA | The low quality recording features a latin urban song that consists of a passionate male vocal, alongside wide harmonizing vocals, singing over punchy kick and snare hits, shimmering cymbals, funky electric guitar melody, synth pad chords, groovy bass and synth keys melody. It sounds energetic and addictive. | ["low quality", "latin urban", "passionate male vocal", "punchy kick", "punchy snare", "shimmering cymbals", "funky electric guitar melody", "synth pad chords", "groovy bass", "wide harmonizing vocals", "synth keys melody", "energetic", "addictive"] | ["Folk music", "Music", "Rhythm and blues"] | 4 | 30 | 40 | 0 | 0 | ["/m/02w4v", "/m/04rlf", "/m/06j6l"] | |
wg_kYW4xvz4 | The low quality recording features a hip hop song played on a speaker that features groovy piano melody, synth lead melody, strings power chords, punchy snare, shimmering shakers, claps and punchy kick hits. It sounds noisy and thin as it lacks bass frequencies. | ["low quality", "hip hop", "noisy", "thin", "muffled", "groovy piano melody", "synth lead melody", "strings power chords", "punchy snare", "shimmering shakers", "clapping", "punchy kick"] | ["Folk music", "Music"] | 4 | 30 | 40 | 1 | 1 | ["/m/02w4v", "/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 );