musiccaps
1 row where aspect_list contains "animated singing" and aspect_list contains "orchestral string harmony"
This data as json, CSV (advanced)
aspect_list (array) 19 ✖
- animated singing · 1 ✖
- emphatic vocals 1
- energetic acoustic guitar 1
- groovy bass line 1
- jealous 1
- lively piano accompaniment 1
- love song 1
- male singer 1
- medium fast tempo 1
- nylon string guitar 1
- orchestra 1
- orchestral string harmony · 1 ✖
- passionate 1
- romantic 1
- sentimental 1
- spirited spanish guitar 1
- story telling 1
- string symphony 1
- vibrant ukelele harmony 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
FF0VaBxb27w | A male vocalist sings this animated song. The tempo is medium with vocal emphasis, a bright ukelele harmony, groovy bass guitar, rhythmic acoustic guitar and piano accompaniment. The song is emphatic, passionate, jealous, emotional, sentimental and story telling. The song has an orchestral vibe. | ["male singer", "medium fast tempo", "romantic", "sentimental", "spirited spanish guitar", "energetic acoustic guitar", "nylon string guitar", "lively piano accompaniment", "animated singing", "emphatic vocals", "story telling", "love song", "vibrant ukelele harmony", "passionate", "jealous", "orchestra", "orchestral string harmony", "string symphony", "groovy bass line"] | ["Singing", "Music", "Ukulele"] | 7 | 30 | 40 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/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 );