musiccaps
1 row where aspect_list contains "average audio quality" and aspect_list contains "synth trumpet lead"
This data as json, CSV (advanced)
aspect_list (array) 16 ✖
- average audio quality · 1 ✖
- dance club 1
- dance floor 1
- dj 1
- electronic dance music 1
- energetic 1
- groovy bass line 1
- groovy rhythm 1
- grunge keyboard tones 1
- instrumental music 1
- medium tempo 1
- people dancing 1
- spirited 1
- synth trumpet lead · 1 ✖
- techno dance rhythm 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
4Mm5mBgktG0 | The song is an instrumental. The song is medium tempo with a groovy bass line, grunge keyboard tones, synth trumpet lead and techno drumming rhythm. The song is entertaining and energetic. The song is an electronic dance song with average quality recording. | ["average audio quality", "groovy rhythm", "electronic dance music", "instrumental music", "groovy bass line", "medium tempo", "synth trumpet lead", "people dancing", "dj", "techno dance rhythm", "dance club", "dance floor", "spirited", "energetic", "youthful", "grunge keyboard tones"] | ["Music", "Techno", "Dubstep", "Cacophony", "Electronic dance music"] | 1 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07gxw", "/m/07s72n", "/m/07szfh9", "/m/08cyft"] |
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 );