musiccaps
2 rows where aspect_list contains "groovy bass", audioset_names contains "Funk" and audioset_names contains "Music of Africa"
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 |
---|---|---|---|---|---|---|---|---|---|---|
DdxW_JziHTA | The low quality recording features a funk song that consists of passionate male vocal singing over shimmering open hats and shakers, funky and groovy keys melody, groovy bass, wooden percussive elements and "4 on the floor" kick pattern. It is noisy, but also funky and the stereo image is unbalanced, as the song is leaning towards the right channel. | ["low quality", "funk", "funky keys melody", "shimmering shakers", "shimmering open hat", "passionate male vocal", "wooden percussive elements", "groovy bass", "4 on the floor kick", "noisy", "unbalanced stereo"] | ["Music of Africa", "Funk", "Music"] | 4 | 30 | 40 | 1 | 1 | ["/m/0164x2", "/m/02x8m", "/m/04rlf"] | |
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 );