musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "groovy piano melody" and aspect_list contains "live performance"
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 |
---|---|---|---|---|---|---|---|---|---|---|
OQz8reoVQEI | The low quality recording features a live performance of salsa music and it consists of flat male vocal talking over microphone, followed by groovy piano melody, some percussive elements, groovy bass and energetic crash cymbals. There are some loud crowd cheering noises and claps. It sounds exciting and energetic. | ["low quality", "live performance", "salsa music", "percussive elements", "groovy piano melody", "energetic crash cymbal", "flat male vocal", "crowd cheering", "crowd clapping", "exciting", "energetic", "groovy bass", "loud"] | ["Music", "Salsa music"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/0ln16"] | |
QZoclbefgak | The low quality recording features a live performance of a rock & roll song performed by passionate female vocal and male vocal ad libs, followed by groovy piano melody, funky electric guitar melody, groovy bass guitar, shimmering hi hats, punchy snare and soft kick hits. It is a bit noisy and there are some subtle microphone feedback sounds in the middle of the performance. It sounds energetic, vintage and passionate. | ["low quality", "male vocal ad libs", "passionate female vocal", "shimmering hi hats", "punchy snare", "soft kick", "groovy bass guitar", "funky electric guitar melody", "groovy piano melody", "rock & roll", "live performance", "subtle microphone feedback", "noisy", "energetic", "passionate", "vintage"] | ["Singing", "Music", "Pop music", "Rock music", "Ska", "Song", "Rock and roll"] | 4 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/064t9", "/m/06by7", "/m/06rqw", "/m/074ft", "/m/07sbbz2"] |
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 );