musiccaps
1 row where aspect_list contains "keybiard harmony" and aspect_list contains "people dancing"
This data as json, CSV (advanced)
aspect_list (array) 19 ✖
- cymbals crashing loud 1
- dance club 1
- dance floor 1
- dance hits 1
- dance party 1
- dj 1
- electronic dance music 1
- energetic 1
- groovy bass line 1
- keybiard harmony · 1 ✖
- keyboard harmony 1
- medium tempo 1
- night party 1
- people dancing · 1 ✖
- percussion hits 1
- steady rhythm 1
- techno dance music 1
- teenage romance 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
ClK_qf_Twm8 | The song is instrumental. The song is medium tempo with a groovy bass line, keyboard harmony, various percussion hits and a steady drumming rhythm. The song has a dance rhythm and is exciting. | ["techno dance music", "electronic dance music", "cymbals crashing loud", "percussion hits", "keyboard harmony", "dance party", "dance club", "dance floor", "electronic dance music", "youthful", "energetic", "teenage romance", "dance hits", "steady rhythm", "medium tempo", "keybiard harmony", "groovy bass line", "people dancing", "dj", "night party"] | ["Disco", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | 1 | 30 | 40 | 0 | 1 | ["/m/026z9", "/m/04rlf", "/m/07gxw", "/m/07s72n", "/m/08cyft", "/m/0ggx5q"] |
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 );