musiccaps
3 rows where aspect_list contains "soft crash cymbals" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
1Rd1w7Ty1ak | The low quality recording features a pop song that contains a soft male vocal singing over soft crash cymbals, claps, punchy kick, shimmering shakers, groovy bass, piano melody and electric guitar melody. It sounds easygoing. | ["low quality", "pop", "electric guitar melody", "punchy kick", "shimmering shakers", "groovy bass", "claps", "soft crash cymbals", "soft male vocal", "piano melody", "easygoing"] | ["Music", "Happy music"] | 4 | 160 | 170 | 0 | 0 | ["/m/04rlf", "/t/dd00031"] | |
4o0bARRMYQ8 | The Gospel song features a harmonized mixed choir vocals singing over mellow piano melody, smooth bass, soft kick, snare and cymbals hits and sustained strings melody. It sounds passionate, emotional, powerful and soulful. | ["gospel", "harmonized mixed choir vocals", "mellow piano melody", "smooth bass", "soft crash cymbals", "soft kick", "soft snare", "sustained strings melody", "emotional", "powerful", "soulful", "passionate"] | ["Christian music", "Music"] | 4 | 160 | 170 | 0 | 0 | ["/m/02mscn", "/m/04rlf"] | |
AYOlvoM5bjY | The low quality recording features a wide shimmering shakers, soft crash cymbals, wide whistling and crowd cheering sounds, followed by addictive accordion melody, walking double bass and "4 on the floor" cowbell pattern. It sounds fun, happy, sentimental, euphoric and nostalgic. | ["low quality", "wide shimmering shakers", "soft crash cymbals", "wide whistling", "wide crowd cheering", "addictive accordion melody", "walking double bass", "4 on the floor cowbell", "fun", "happy", "sentimental", "euphoric", "nostalgic"] | ["Christmas music", "Christian music", "Music"] | 4 | 60 | 70 | 0 | 1 | ["/m/0140xf", "/m/02mscn", "/m/04rlf"] |
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 );