musiccaps
2 rows where aspect_list contains "female vocalist", aspect_list contains "soft" and aspect_list contains "story telling"
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 |
---|---|---|---|---|---|---|---|---|---|---|
DP2vmsftZHY | This song is a sweet duet. The tempo is medium with a melodious, intense piano accompaniment , electric guitar rhythm, steady drumming and synthesiser arrangements. This song is melodic, story telling, spirited, emotional, passionate and sweet. The lyrics are simple and so this song could be a Children’s Song. | ["duet", "male vocalist", "female vocalist", "children’s song", "strong", "electric guitar rhythm", "steady drumming", "digital drum beat", "synthesiser arrangement", "story telling", "soft", "melodious", "melodic amplified piano"] | ["Christmas music", "Music"] | 7 | 30 | 40 | 1 | 1 | ["/m/0140xf", "/m/04rlf"] | |
WSaCGNkM6_k | A female vocalist sings this sweet melody. It is medium tempo with rhythmic accompaniment of acoustic guitar, mandolin, resonator, dobro, banjo, cello, fiddle and auto harp. The song is soft, soothing, pleasant, dulcet, sentimental, emotional and simple. This song is Country Pop. | ["female vocalist", "medium tempo", "cello", "melodious harmony", "no percussions", "vocal emphasis", "banjo", "mellow", "string harmony", "dulcet", "soft", "pleasant", "story telling", "country pop", "country song", "regional pop", "resonator", "fiddle", "mandolin", "auto harp", "dobro", "acoustic guitar", "no percussions", "vocal emphasis", "dulcet"] | ["Country", "Music"] | 7 | 30 | 40 | 0 | 1 | ["/m/01lyv", "/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 );