musiccaps
2 rows where aspect_list contains "happy", aspect_list contains "punchy snare", aspect_list contains "shimmering hi hats" and aspect_list contains "short electric guitar lick"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1PSzSTilu_s | The low quality recording features a southern rock song that consists of flat male vocal singing over wide acoustic rhythm guitars, short electric guitar lick, smooth bass guitar, punchy snare, simple kick pattern and shimmering hi-hats. It sounds happy and fun. | ["low quality", "flat male vocal", "wide acoustic rhythm guitar", "short electric guitar lick", "smooth bass guitar", "punchy snare", "simple kick pattern", "shimmering hi hats", "happy", "fun", "southern rock"] | ["Music", "/t/dd00032"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00032"] | |
IjP5kKfgBiI | The low quality recording features a groovy piano melody, played over, groovy bass guitar, punchy kick and snare hits, shimmering hi hats, shimmering crash cymbal and short electric guitar lick. It sounds energetic, fun, happy, joyful and like an in-game video game sound. | ["low quality", "punchy snare", "shimmering hi hats", "groovy bass guitar", "short electric guitar lick", "groovy piano melody", "shimmering crash cymbal", "energetic", "fun", "happy", "joyful", "in game sound"] | ["Video game music", "Guitar", "Music", "Musical instrument", "Keyboard (musical)", "Piano"] | 4 | 30 | 40 | 0 | 0 | ["/m/01z7dr", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/05148p4", "/m/05r5c"] |
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 );