musiccaps
2 rows where aspect_list contains "sentimental" and audioset_ids contains "/m/04rzd"
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 |
---|---|---|---|---|---|---|---|---|---|---|
V5xL8hLFY58 | The Country Blues song features a flat male vocal singing over acoustic guitar melody, accordion and a sustained brass section melody. It sounds very noisy, vintage and therefore nostalgic and sentimental - like something you would hear in an old movie. | ["country blues", "noisy", "vintage", "low quality", "nostalgic", "mono", "flat male vocal", "acoustic guitar melody", "accordion melody", "sustained brass section", "nostalgic", "sentimental"] | ["Music", "Mandolin", "Bluegrass"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/04rzd", "/m/0gg8l"] | |
n1fY-23ffl0 | This song is a pleasant love song duet. The tempo is medium with acoustic guitar and ukulele accompaniment.the song is mellow, soft, emotional, romantic, nostalgic. This song is Country/Folk pop. | ["duet", "medium tempo", "ukelele", "folk pop", "folk music", "mellifluous", "simple melody", "country pop", "country hits", "string instruments", "folk music", "acoustic guitar", "mandolin", "melodious", "pop", "country pop", "mellifluous", "romantic", "emotional", "sentimental", "soft", "mellow"] | ["Singing", "Music", "Mandolin", "Ukulele"] | 7 | 240 | 250 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/04rzd", "/m/07xzm"] |
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 );