musiccaps
1 row where aspect_list contains "cool" and audioset_ids contains "/m/01b9nn"
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 |
---|---|---|---|---|---|---|---|---|---|---|
w4ayJNZ5w5o | The low quality recording features an electric guitar solo melody played with some sliding techniques. It sounds cool, passionate and the recording is noisy and in mono, as it was probably recorded with a phone. | ["low quality", "noisy", "mono", "electric guitar solo melody", "sliding effect", "cool", "passionate"] | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 4 | 280 | 290 | 0 | 0 | ["/m/01b9nn", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] |
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 );