musiccaps
2 rows where aspect_list contains "groovy piano chord progression" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
7y9RfZXJZsk | The low quality recording features a regional Mexican song that consists of a reverberant male vocal singing over widely spread groovy piano chord progression, brass section, shimmering shakers, groovy percussive elements and smooth bass. It sounds tropical, exotic and fun, like something you would hear at latin weddings. | ["low quality", "groovy piano chord progression", "wide brass section", "shimmering shakers", "wide groovy percussive elements", "smooth bass", "reverberant make vocal", "traditional", "regional mexican", "tropical", "exotic", "fun"] | ["Music", "Salsa music"] | 4 | 90 | 100 | 0 | 1 | ["/m/04rlf", "/m/0ln16"] | |
XkBXsaSXDJ0 | The Pop song features a passionate male vocal, alongside widely spread harmonizing mixed vocals, singing over groovy piano chord progression, funky electric guitar melody, groovy bass guitar, shimmering hi hats, punchy kick and punchy snare. It sounds emotional, addictive and euphoric - like a Christmas song. | ["wide harmonizing mixed vocals", "passionate male vocal", "punchy snare", "groovy piano chord progression", "funky electric guitar melody", "groovy bass guitar", "pop", "shimmering hi hats", "punchy kick", "emotional", "addictive", "euphoric"] | ["Music", "Song", "Soul music"] | 4 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/074ft", "/m/0gywn"] |
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 );