musiccaps
2 rows where aspect_list contains "live performance", aspect_list contains "noisy" and audioset_names contains "Blues"
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 |
---|---|---|---|---|---|---|---|---|---|---|
FbV2Lgt3H1Q | The low quality recording features a live performance of a rock song that consists of flat male vocal singing over simple electric guitar chords. The recording is noisy and it has some seat crackling noises in it. It sounds sad and emotional though. | ["low quality", "live performance", "seat crackles", "noisy", "simple electric guitar chords", "flat male vocal", "emotional", "sad", "rock"] | ["Blues", "Guitar", "Music"] | 4 | 30 | 40 | 0 | 1 | ["/m/0155w", "/m/0342h", "/m/04rlf"] | |
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 );