musiccaps
2 rows where aspect_list contains "hip hop" and audioset_ids contains "/m/03_d0"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
2RMOegT2Jn8 | hip hop music featuring a young male rapper over a minimalist beat with only percussion such as cowbell, kick drum, shaker, and triangle. | ["hip hop", "cow bell", "kick drum", "young male rapper", "pitched vocal sample", "triangle", "male laughing", "minimal production", "shaker"] | ["Jazz", "Music", "Rhythm and blues", "Dance music"] | 8 | 30 | 40 | 0 | 0 | ["/m/03_d0", "/m/04rlf", "/m/06j6l", "/m/0ggx5q"] | |
3bg0iy-ypcw | The Hip Hip songs live performance consists of repetitive male vocal singing over repetitive piano melody, smooth bass, shimmering hi hats and soft kick and snare hits. It sounds jazzy and warm. | ["hip hop", "live performance", "warm", "repetitive piano melody", "smooth bass", "repetitive male vocal", "shimmering hi hats", "soft snare", "soft kick", "jazzy"] | ["Jazz", "Music"] | 4 | 30 | 40 | 0 | 1 | ["/m/03_d0", "/m/04rlf"] |
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 );