musiccaps
1 row where aspect_list contains "acoustic guitar", aspect_list contains "banjo", aspect_list contains "melancholy" and aspect_list contains "sentimental"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Sl9ZkYViEIs | A male vocalist sings this melancholic country song. The tempo is slow with acoustic guitar lead and harmony with another string instrument accompanying. The song is soft, mellow, sad, pensive, melancholic and poignant with a sweet , pleasant melody. This song is a Classic Country song. | ["male vocalist", "slow tempo", "acoustic guitar", "simple melody", "hillbilly music", "banjo", "old-time country rock", "folk lyrics", "country music", "bluegrass", "country hits", "regional music", "country folk songs", "acoustic bass", "mellow", "soft", "sentimental", "nostalgic", "pensive", "melancholy", "story telling"] | ["Folk music", "Music"] | 7 | 30 | 40 | 0 | 1 | ["/m/02w4v", "/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 );