musiccaps
2 rows where aspect_list contains "warm" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
e6lTl9JIW5Y | The low quality recording features a jazz performance that consists of saxophone solo melody played over shimmering cymbals, followed by trombone melody and walking double bass. It sounds warm, but dark, due to the poor quality microphone it was recorded with. | ["low quality", "mono", "noisy", "shimmering cymbals", "trombone melody", "saxophone solo melody", "walking double bass", "jazz", "warm", "dark"] | ["Jazz"] | 4 | 40 | 50 | 0 | 0 | ["/m/03_d0"] |
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 );