musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "fun" and author_id = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|
LjxhswBV1UA | This song has a traditional Mexican mariachi sound. It is fun, vibrant and energetic and is led by rhythmic and melodic playing on the Mexican Vihuela. The maracas add an element of rhythmic percussion. There are sounds of laughter in the background. | ["maracas", "background laughter sounds", "mexican vihuela", "mexican traditional music", "percussion", "stringed instrument", "mariachi music", "fiesta", "celebration", "upbeat", "energetic", "fun"] | ["Guitar", "Music", "Musical instrument", "Rattle (instrument)", "Ukulele", "Plucked string instrument"] | 3 | 20 | 30 | 0 | 1 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/05r5wn", "/m/07xzm", "/m/0fx80y"] | |
puAclKsCbes | This is a fun, upbeat country folk song. We hear a banjo player strum rapidly and then go on to do a solo. We hear cheering and clapping fans, intricate basslines and acoustic guitars being rapidly strummed. It's a fun, uptempo song that would be heard in a barnyard. | ["live country folk band", "folk music", "fast paced", "uptempo", "energetic", "banjo playing", "acoustic guitar strumming", "live recording", "poor audio quality", "crowd cheering", "crowd clapping", "fun", "barnyard"] | ["Country", "Guitar", "Music", "Musical instrument", "Tambourine", "Plucked string instrument", "Bowed string instrument"] | 3 | 280 | 290 | 0 | 0 | ["/m/01lyv", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07brj", "/m/0fx80y", "/m/0l14_3"] |
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 );