musiccaps
1 row where aspect_list contains "acoustic guitar", aspect_list contains "male singer" and aspect_list contains "shakers"
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 |
---|---|---|---|---|---|---|---|---|---|---|
keIvA2wSPZc | A male vocalist sings this soft country song. The tempo is slow with a gentle acoustic guitar and resonator rhythm, subtle keyboard, soft drumming, tambourine beats and soft auto harp strains. The vocals are mellow, gentle, sentimental, emotional, poignant, melancholic and nostalgic. This song is a Classic Country song. | ["male singer", "slow tempo", "mellow", "soft", "dulcet", "melodic", "acoustic guitar", "auto harp", "resonator", "tambourine", "shakers", "keyboard harmony", "sentimental", "emotional", "nostalgia", "poignant", "boomy bass lines", "steady drumming", "sentimental"] | ["Blues", "Music"] | 7 | 30 | 40 | 0 | 1 | ["/m/0155w", "/m/04rlf"] |
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 );