musiccaps
1 row where aspect_list contains "beat boxing" and aspect_list contains "punchy beat"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- beat boxing · 1 ✖
- car honking 1
- catchy 1
- catchy beat 1
- dance groove 1
- dance music 1
- electronic instrumentation 1
- enthusiastic drumming 1
- funky electric guitar riff 1
- guitar 1
- instrumental 1
- keyboard harmony 1
- medium fast tempo 1
- pop 1
- punchy beat · 1 ✖
- vibrant 1
- vocalisation 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
t7oAteGa55g | This song is an instrumental. The tempo is slow with vigorous drumming, keyboard and electric guitar harmony,beatboxing and the sound of a car horn .The song is vibrant, punchy, vigorous and upbeat with a dance groove. This song is a Pop Hit. | ["car honking", "instrumental", "enthusiastic drumming", "keyboard harmony", "punchy beat", "dance groove", "pop", "electronic instrumentation", "beat boxing", "vocalisation", "catchy beat", "medium fast tempo", "vibrant", "youthful", "catchy", "dance music", "funky electric guitar riff", "guitar"] | ["Beatboxing", "Music", "Pop music", "Vehicle horn, car horn, honking"] | 7 | 90 | 100 | 1 | 1 | ["/m/02cz_7", "/m/04rlf", "/m/064t9", "/m/0912c9"] |
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 );