musiccaps
2 rows where aspect_list contains "jazzy" 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"] | |
3cEQfNZ_F1w | This is a jazzy instrumental that sounds upbeat, cheery and vibrant. This would be suitable for some swing dancing. It's got an electric guitarist playing licks, a punchy piano, and groovy intricate drum pattern. The piece is in four over four time signature. | ["jazzy", "upbeat", "electric guitar licks", "piano groove", "hoppy jazz beat", "cheery bassline"] | ["Jazz", "Music", "Pop music"] | 3 | 30 | 40 | 0 | 0 | ["/m/03_d0", "/m/04rlf", "/m/064t9"] |
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 );