musiccaps
2 rows where aspect_list contains "crowd clapping" and audioset_ids contains "/m/0342h"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-WvVG0wHcTc | The low quality recording features a classical live performance of sustained violin melody, shimmering hi hats, electric guitar melody, theremin solo melody and subtle female vocals at the end of the loop. There are some crowd clapping sounds in the background. It is noisy, in mono and it sounds passionate and emotional. | ["classical", "sustained violin melody", "crowd clapping", "shimmering hi hats", "theremin solo", "subtle female vocal", "live performance", "electric guitar melody", "low quality", "noisy", "mono", "passionate", "emotional"] | ["Singing", "Country", "Guitar", "Music", "Wedding music"] | 4 | 310 | 320 | 0 | 1 | ["/m/015lz1", "/m/01lyv", "/m/0342h", "/m/04rlf", "/m/04wptg"] | |
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 );