musiccaps
2 rows where aspect_list contains "jazz", aspect_list contains "passionate", aspect_list contains "passionate female vocal" 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 |
---|---|---|---|---|---|---|---|---|---|---|
ETl0hYRlVmg | The low quality recording features a live performance of a jazz song and it features a passionate female vocal singing over shimmering hi hats, groovy piano chords and smooth double bass. The recording has some audio crackles and that would be the only reason for it to go under the "low quality" category. It sounds emotional, passionate and groovy. | ["low quality", "jazz", "passionate female vocal", "groovy piano chords", "smooth double bass", "shimmering hi hats", "audio crackles", "live performance", "emotional", "passionate", "groovy"] | ["Music", "Lullaby"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07pkxdp"] | |
mFcHGbnNtSQ | The low quality recording features a live performance of a jazz song and it consists of a passionate female vocalist singing over groovy piano melody, saxophone melody, groovy bass, shimmering hi hats, punchy snare and soft kick hits. It sounds passionate, soulful and the recording is noisy and in mono. | ["low quality", "live performance", "passionate female vocal", "groovy piano melody", "saxophone melody", "groovy bass", "shimmering hi hats", "punchy snare", "soft kick hits", "jazz", "passionate", "soulful", "noisy", "mono"] | ["Blues", "Singing", "Jazz", "Music", "Harmonic"] | 4 | 70 | 80 | 0 | 0 | ["/m/0155w", "/m/015lz1", "/m/03_d0", "/m/04rlf", "/m/0b9m1"] |
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 );