musiccaps
1 row where aspect_list contains "distorted electric guitar chords" and audioset_ids contains "/m/0342h"
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 |
---|---|---|---|---|---|---|---|---|---|---|
m8poFnEbvW8 | The low quality recording features distorted electric guitar chords playing over rock songs played on playback. It sounds messy and harsh, as the frequencies of the room and the actual sound of the guitar and song are clashing with each other. | ["low quality", "distorted electric guitar chords", "playback", "harsh", "messy", "rock"] | ["Guitar", "Music", "Musical instrument", "Rock music", "Progressive rock", "Plucked string instrument"] | 4 | 180 | 190 | 0 | 0 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/06by7", "/m/0dl5d", "/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 );