musiccaps
2 rows where aspect_list contains "long crash cymbal" 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 |
---|---|---|---|---|---|---|---|---|---|---|
E29kpquu8W4 | The Drum & Bass song features a mellow electric guitar melody, synth pad chord, long crash cymbal, buzzy synth lead melody and distant, fading out drums playing in the background. It is very reverberant, thus the song has a spacey vibe. It sounds relaxing and calming. | ["drum & bass", "mellow electric guitar melody", "synth pad chord", "long crash cymbal", "buzzy synth lead melody", "distant drums", "relaxing", "calming", "fade out drums", "reverberant", "spacey"] | ["Electric piano", "Keyboard (musical)", "Piano"] | 4 | 30 | 40 | 0 | 0 | ["/m/01s0ps", "/m/05148p4", "/m/05r5c"] | |
X0MN34Us6eE | The low quality recording features a flat male vocal singing over tinny wooden percussions, punchy "4 on the floor" kick pattern, groovy bass, long crash cymbal, shimmering shakers, syncopated snare hits and electric guitar melody. In the first half of the loop, there is a short snippet of crowd cheering and clapping over brass melody. It sounds fun, happy and energetic. | ["low quality", "tinny wooden percussion", "crowd cheering", "crowd clapping", "flat male vocal", "punchy \"4 on the floor\" kick pattern", "groovy bass", "long crash cymbal", "shimmering shakers", "syncopated snare", "electric guitar melody", "brass melody", "fun", "happy", "energetic"] | ["Afrobeat", "Music of Africa", "Music"] | 4 | 30 | 40 | 0 | 0 | ["/m/0145m", "/m/0164x2", "/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 );