musiccaps
1 row where aspect_list contains "metallic snare" and aspect_list contains "reggae"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- electric guitar licks 1
- flat male vocal 1
- groovy bass 1
- happy 1
- metallic snare · 1 ✖
- offbeat acoustic rhythm guitar chords 1
- reggae · 1 ✖
- simple kick 1
- uplifting 1
- wide background harmonizing female vocals 1
- wide tinny percussive elements 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
R5JRh08zgMo | The Reggae song features a flat male vocal singing, alongside wide background harmonizing female vocals, over metallic snare, simple kick hits, offbeat acoustic rhythm guitar chords, groovy bass, electric guitar licks and tinny percussive elements widely spread in the stereo image. Sounds happy and uplifting, like something you can listen to while chilling at the beach. | ["reggae", "offbeat acoustic rhythm guitar chords", "wide background harmonizing female vocals", "flat male vocal", "groovy bass", "electric guitar licks", "metallic snare", "wide tinny percussive elements", "happy", "uplifting", "simple kick"] | ["Afrobeat", "Music of Africa", "Funk", "Music", "Mouse", "Ska"] | 4 | 30 | 40 | 1 | 1 | ["/m/0145m", "/m/0164x2", "/m/02x8m", "/m/04rlf", "/m/04rmv", "/m/06rqw"] |
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 );