musiccaps
1 row where aspect_list contains "charming" and aspect_list contains "colourful"
This data as json, CSV (advanced)
aspect_list (array) 17 ✖
- acoustic guitar 1
- charming · 1 ✖
- colourful · 1 ✖
- dreamy 1
- emotional 1
- female vocalisation 1
- instrumental 1
- keyboard accompaniment 1
- mellow 1
- poignant 1
- romantic 1
- sentimental 1
- slow tempo 1
- soft 1
- violin harmony 1
- vocalisation 1
- warm 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
WNmAlKrAPjQ | This music is instrumental. The tempo is slow with an emphatic violin harmony, keyboard accompaniment and rhythmic acoustic guitar with female vocalisation. The song is romantic, sentimental, emotional, nostalgic, poignant, charming, dreamy and soft. | ["instrumental", "slow tempo", "vocalisation", "female vocalisation", "charming", "dreamy", "poignant", "colourful", "warm", "keyboard accompaniment", "violin harmony", "acoustic guitar", "mellow", "soft", "romantic", "emotional", "sentimental"] | ["Music", "Sad music"] | 7 | 240 | 250 | 0 | 0 | ["/m/04rlf", "/t/dd00033"] |
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 );