musiccaps
2 rows where aspect_list contains "harsh" 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 |
---|---|---|---|---|---|---|---|---|---|---|
_RLsXrr0fQo | The low quality recording features a folk song being covered by passionate male vocal and groovy acoustic guitar melody. It sounds uplifting and a bit harsh, muddy and unbalanced as far as the stereo image goes. | ["low quality", "passionate male vocal", "groovy acoustic guitar melody", "reverberant", "folk", "uplifting", "unbalanced stereo image", "harsh", "muddy"] | ["Singing", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | 4 | 80 | 90 | 0 | 1 | ["/m/015lz1", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07xzm", "/m/0fx80y"] | |
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 );