musiccaps
2 rows where aspect_list contains "electric guitar melody", aspect_list contains "mellow" and aspect_list contains "noisy"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1Ccis4FDGwY | The low quality recording features an electric guitar melody playing in the left channel only in the first half of the loop. At the very end of the loop, the second electric guitar melody appears in the right channel of the stereo image, which makes the stereo image more balanced. It sounds mellow, soft and passionate. The recording is a bit noisy. | ["low quality", "noisy", "electric guitar melody", "mellow", "soft", "passionate"] | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 4 | 20 | 30 | 0 | 0 | ["/m/01b9nn", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] | |
ib8pMT_ug7o | The low quality recording features an electric guitar melody. It sounds mellow, chill and easygoing. | ["low quality", "noisy", "electric guitar melody", "mellow", "easygoing", "chill"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | 4 | 30 | 40 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y", "/m/0g12c5"] |
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 );