musiccaps
2 rows where aspect_list contains "sad" and audioset_ids contains "/m/0y4f8"
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"] | |
mq_b6QKVsuc | A female vocalist sings this soft melody. The tempo is slow with acoustic guitar accompaniment. The guitar sound is muffled. The song is sad,poignant, melancholic, sentimental,emotional and lonely. This song is Pop. | ["home video", "home recording", "female singing", "lonely sad", "room acoustics", "muffled guitar quality", "husky voice", "lonely", "sad", "poignant", "acoustic guitar", "slow tempo", "soft", "mellow", "poignant", "melancholic", "pop"] | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Vocal music"] | 7 | 30 | 40 | 0 | 1 | ["/m/042v_gx", "/m/04rlf", "/m/06w87", "/m/07s0s5r", "/m/0y4f8"] |
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 );