musiccaps
2 rows where aspect_list contains "wooden percussive elements" and audioset_ids contains "/m/0145m"
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 |
---|---|---|---|---|---|---|---|---|---|---|
B_kAtTBUDIA | The low quality recording features a regional Mexican song that contains wooden percussive elements, groovy bass and staccato brass melody over which flat male vocalists sing. It sounds vintage, as the recording is very noisy and in mono. | ["low quality", "flat male vocal", "wooden percussive elements", "staccato brass melody", "groovy bass", "mono", "noisy", "regional mexican", "vintage"] | ["Afrobeat", "Music", "Salsa music"] | 4 | 30 | 40 | 0 | 1 | ["/m/0145m", "/m/04rlf", "/m/0ln16"] | |
Byk9p21g51g | The low quality recording features an urban latin remix that consists of passionate female vocal singing over groovy piano chords, wooden percussive elements, "4 on the floor" kick pattern, syncopated claps, shimmering shakers, smooth bass and exciting male vocals. It sounds energetic, fun and happy. | ["low quality", "urban latin remix", "passionate female vocal", "groovy piano chords", "wooden percussive elements", "\"4 on the floor\" kick pattern", "syncopated claps", "shimmering shakers", "smooth bass", "exciting male vocal", "energetic", "fun", "happy", "thin"] | ["Afrobeat", "Music of Africa", "Music", "Reggae", "Salsa music"] | 4 | 30 | 40 | 1 | 1 | ["/m/0145m", "/m/0164x2", "/m/04rlf", "/m/06cqb", "/m/0ln16"] |
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 );