musiccaps
1 row where aspect_list contains "keybiard harmony" and aspect_list contains "retro pop hits"
This data as json, CSV (advanced)
aspect_list (array) 19 ✖
- cheerful courtship song 1
- dance rhythm 1
- doo-wop hits 1
- feeling good 1
- female backup singers 1
- female singer 1
- groovy drumming rhythm 1
- groovy guitar rhythm 1
- keybiard harmony · 1 ✖
- memdium tempo 1
- passionate 1
- poor audio quality 1
- retro dance hits 1
- retro pop hits · 1 ✖
- retro pop super hits 1
- sexy 1
- strong bass line 1
- vocal harmony 1
- woo her 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
kQw2NQ_eqyg | A female singer sings this cool melody with backup singers in vocal harmony. The song is medium tempo with a groovy bass line and guitar rhythm, steady drums g rhythm and keyboard harmony. The song is catchy and has a dance groove. The song is a retro dance hit. The song has a poor audio quality issue. | ["retro pop hits", "doo-wop hits", "female singer", "memdium tempo", "female backup singers", "vocal harmony", "groovy guitar rhythm", "strong bass line", "keybiard harmony", "groovy drumming rhythm", "dance rhythm", "passionate", "cheerful courtship song", "woo her", "sexy", "feeling good", "retro pop super hits", "retro dance hits", "poor audio quality"] | ["Disco", "Funk", "Music", "Pop music"] | 1 | 30 | 40 | 1 | 1 | ["/m/026z9", "/m/02x8m", "/m/04rlf", "/m/064t9"] |
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 );