musiccaps
2 rows where aspect_list contains "emotional", aspect_list contains "noisy", aspect_list contains "playback" and aspect_list contains "rock"
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 |
---|---|---|---|---|---|---|---|---|---|---|
36ToDxW_hns | The low quality recording features a cover of a rock and it consists of passionately played solo acoustic guitar melody over staccato strings melody playing in the background on playback. Even though the recording is noisy, it sounds emotional and passionate. | ["low quality", "staccato strings melody", "passionate solo acoustic guitar melody", "noisy", "cover", "rock", "playback", "emotional", "passionate"] | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | 4 | 90 | 100 | 0 | 1 | ["/m/0342h", "/m/04rlf", "/m/04rzd", "/m/04szw", "/m/0fx80y"] | |
zYsFbF9emtI | The low quality recording features a cover of a rock song played on bass guitar over electric guitar arpeggiated melody played on playback in the background. The recording is noisy, in mono, as it was probably recorded on a phone, and it sounds emotional and passionate. | ["low quality", "noisy", "mono", "playback", "electric guitar arpeggiated melody", "rock", "bass guitar", "cover", "emotional", "passionate"] | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | 4 | 0 | 10 | 0 | 0 | ["/m/018vs", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/t/dd00125"] |
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 );