musiccaps
2 rows where aspect_list contains "sad" and audioset_ids contains "/m/01lyv"
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 |
---|---|---|---|---|---|---|---|---|---|---|
QtjMlA_7dds | The low quality recording features a live performance of an indie song and it features a passionate male vocal singing over acoustic rhythm guitar and soft double bass, There are laughing and crowd chattering noises in the background. It sounds emotional and sad, even though the recording is a bit noisy. | ["low quality", "indie", "live performance", "noisy", "passionate male vocal", "acoustic rhythm guitar", "soft double bass", "crowd chattering", "laughing", "passionate", "emotional", "sad"] | ["Country", "Flamenco", "Music", "Bluegrass", "Vocal music"] | 4 | 30 | 40 | 0 | 1 | ["/m/01lyv", "/m/0326g", "/m/04rlf", "/m/0gg8l", "/m/0y4f8"] | |
w-YAUcPl-HU | The low quality recording features a sad soft rock song that consists of an acoustic rhythm guitar chord progression over which the reverberant female vocalist sings. The recording is very noisy and it sounds sad and emotional. | ["noisy", "low quality", "reverberant female vocal", "sad acoustic rhythm guitar chord progression", "soft rock", "sad", "emotional"] | ["Country", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | 4 | 30 | 40 | 1 | 1 | ["/m/01lyv", "/m/042v_gx", "/m/04rlf", "/m/06w87", "/m/07s0s5r", "/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 );