musiccaps
1 row where aspect_list contains "country song" and aspect_list contains "vocal emphasis"
This data as json, CSV (advanced)
aspect_list (array) 22 ✖
- acoustic guitar 1
- auto harp 1
- banjo 1
- cello 1
- country pop 1
- country song · 1 ✖
- dobro 1
- dulcet 1
- female vocalist 1
- fiddle 1
- mandolin 1
- medium tempo 1
- mellow 1
- melodious harmony 1
- no percussions 1
- pleasant 1
- regional pop 1
- resonator 1
- soft 1
- story telling 1
- string harmony 1
- vocal emphasis · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
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 );