musiccaps
1 row where aspect_list contains "simple hi hats" and audioset_ids contains "/m/07sbbz2"
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 |
---|---|---|---|---|---|---|---|---|---|---|
dbldb9tq8ng | The Soft rock song features a mellow female vocal singing the same melody as the lead electric guitar, followed by widely spread acoustic rhythm guitars, simple bass, soft kick hits, punchy snare, simple hi hats, shimmering open hats and energetic crash cymbals. There is a short snare roll at some point in the loop. The stereo bass guitar is what makes the stereo image imbalance and therefore the song sounds lower in quality. | ["soft rock", "mellow female vocal", "wide acoustic rhythm guitars", "mono solo electric guitar lead melody", "short snare roll", "energetic cash cymbal", "simple hi hats", "shimmering open hat", "easygoing", "smooth", "simple bass guitar", "low quality", "stereo imbalance"] | ["Music", "Punk rock", "Rock music", "Rock and roll", "Grunge"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/05r6t", "/m/06by7", "/m/07sbbz2", "/m/0dls3"] |
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 );