musiccaps
2 rows where aspect_list contains "acoustic rhythm guitar", aspect_list contains "groovy bass" and aspect_list contains "steel guitar melody"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BfUoopDpmmY | The low quality recording features a children's song that features a flat male vocal, alongside wide harmonizing children vocals, singing over acoustic rhythm guitar, steel guitar melody, happy bells melody, soft kick hits, mellow snare hits, shimmering hi hats and groovy bass. It sounds joyful, happy and exciting. | ["low quality", "children song", "flat male vocal", "wide harmonizing children vocals", "groovy bass", "acoustic rhythm guitar", "steel guitar melody", "shimmering hi hats", "happy bells melody", "soft kick hits", "mellow snare hits", "joyful", "happy", "exciting"] | ["Singing", "Music", "Music for children", "Song"] | 4 | 30 | 40 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/05fw6t", "/m/074ft"] | |
JCfZpSEH77Y | The low quality recording features a blues song that consists of a passionate fruity male vocal singing over harmonica licks, acoustic rhythm guitar, groovy bass and steel guitar melody. It sounds passionate and soulful. The recording is noisy and since the bass sound is leaning towards the right channel of the stereo image - the stereo image is unbalanced. | ["low quality", "blues", "passionate fruity male vocal", "harmonica licks", "acoustic rhythm guitar", "steel guitar melody", "passionate", "soulful", "groovy bass", "unbalanced stereo", "noisy"] | ["Harmonica", "Wind instrument, woodwind instrument"] | 4 | 380 | 390 | 0 | 0 | ["/m/03qjg", "/m/085jw"] |
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 );