musiccaps
1 row where aspect_list contains "fiesta" and aspect_list contains "madly in love"
This data as json, CSV (advanced)
aspect_list (array) 22 ✖
- bossa nova 1
- fiesta · 1 ✖
- giro 1
- instrumental music 1
- keyboard styles 1
- latin dance groove 1
- latin dancers 1
- latin jazz music 1
- latin percussion instruments 1
- madly in love · 1 ✖
- medium tempo 1
- memdium tenpo 1
- music keyboard demo 1
- old school romance 1
- party time 1
- passioante affair 1
- passionate 1
- passionate affair 1
- rhodes organ 1
- romantic 1
- spirited 1
- various percussion hits 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
LKVSEQCLCLo | The song is an instrumental. The song is medium tempo with various Latin percussion playing groovily to the sounds of a Rhodes organ melody. The song is romantic and passionate. The soundtrack is a demonstration for a keyboard model. | ["latin dance groove", "bossa nova", "giro", "madly in love", "passioante affair", "old school romance", "passionate affair", "medium tempo", "latin percussion instruments", "memdium tenpo", "rhodes organ", "various percussion hits", "latin jazz music", "latin dancers", "romantic", "party time", "fiesta", "romantic", "spirited", "passionate", "keyboard styles", "instrumental music", "music keyboard demo"] | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Synthesizer"] | 1 | 10 | 20 | 0 | 0 | ["/m/04rlf", "/m/04szw", "/m/05148p4", "/m/05r5c", "/m/0l14qv"] |
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 );