musiccaps
2 rows where aspect_list contains "groovy", aspect_list contains "mono", aspect_list contains "noisy" and aspect_list contains "shimmering hi hats"
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 |
---|---|---|---|---|---|---|---|---|---|---|
CrkxrgTiVyk | The low quality recording features a live performance of a jazz song and it consists of a groovy bass guitar, groovy rhodes keys, electric guitar melody, shimmering hi hats, punchy kick and punchy snare hits. It sounds groovy, funky and passionate. The recording is noisy and in mono. | ["low quality", "jazz", "live performance", "mono", "noisy", "groovy bass", "groovy rhodes keys melody", "electric guitar melody", "shimmering hi hats", "punchy kick", "punchy snare", "funky", "groovy", "passionate"] | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | 4 | 30 | 40 | 0 | 0 | ["/m/013y1f", "/m/01s0ps", "/m/03xq_f", "/m/05148p4", "/m/05r5c"] | |
FmytwY7SAfU | The low quality recording features a DJ scratching a hip hop song that consists of punchy kick and snare hits, shimmering hi hats and syncopated open hats. There are some plastic tapping sounds. The recording is noisy, in mono and it sounds groovy. | ["low quality", "hip hop", "dj scratching sounds", "punchy kick", "punchy snare", "shimmering hi hats", "syncopated open hat", "noisy", "mono", "plastic tapping sounds", "groovy"] | ["Scratching (performance technique)", "Funk", "Music", "Scratch"] | 4 | 60 | 70 | 0 | 0 | ["/m/01hgjl", "/m/02x8m", "/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 );