musiccaps
1 row where aspect_list contains "dance rhythm" and aspect_list contains "trance hits"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- adrenaline rush 1
- dance floor 1
- dance hits 1
- dance remix 1
- dance rhythm · 1 ✖
- dancing all night 1
- dj 1
- electronic dance music 1
- fashion party mix 1
- ibiza party 1
- instrumental music 1
- medium fast tempo 1
- party nights 1
- poor audio quality 1
- spirited 1
- techno dance music 1
- trance hits · 1 ✖
- trance nights 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
u3pYqyLM0f4 | The song is an instrumental. The song is medium fast tempo with a strong techno drum rhythm, groovy bass line, keyboard harmony and percussion hits. The song is exciting and groovy for dance. The audio quality is poor. | ["techno dance music", "electronic dance music", "dance remix", "trance nights", "dancing all night", "ibiza party", "fashion party mix", "trance hits", "medium fast tempo", "instrumental music", "dance hits", "poor audio quality", "adrenaline rush", "spirited", "dance rhythm", "dance floor", "dj", "party nights"] | ["Drum and bass", "Music", "Techno", "Trance music", "Electronica"] | 1 | 30 | 40 | 0 | 1 | ["/m/0283d", "/m/04rlf", "/m/07gxw", "/m/07lnk", "/m/0m0jc"] |
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 );