musiccaps
1 row where aspect_list contains "boomy" and aspect_list contains "happy"
This data as json, CSV (advanced)
aspect_list (array) 14 ✖
- 4 on the floor cowbell pattern 1
- 4 on the floor kick 1
- accordion melody 1
- acoustic rhythm guitar 1
- boomy · 1 ✖
- country 1
- fun 1
- groovy bass 1
- happy · 1 ✖
- passionate male vocal 1
- poor mix 1
- shimmering shakers 1
- soft crash cymbal 1
- syncopated snare 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
bLjOJRg2P_Q | The Country song features a passionate male vocalist singing over accordion melody, groovy bass, layered "4 on the floor" kick and cowbell pattern, soft crash cymbal, shimmering shakers and acoustic rhythm guitar. It sounds fun and happy, even though the song is poorly mixed, as it sounds a bit boomy. | ["country", "passionate male vocal", "accordion melody", "groovy bass", "4 on the floor cowbell pattern", "acoustic rhythm guitar", "fun", "happy", "4 on the floor kick", "syncopated snare", "soft crash cymbal", "shimmering shakers", "poor mix", "boomy"] | ["Singing", "Music", "Salsa music"] | 4 | 100 | 110 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/0ln16"] |
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 );