musiccaps
2 rows where aspect_list contains "cymbals" and audioset_ids contains "/m/04szw"
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 |
---|---|---|---|---|---|---|---|---|---|---|
UsdoUjuczY4 | This music clip is an percussionary instrument. The tempo is medium fast with steady bass drum, energetic snare drum beat and cymbal rides. This music is a youthful, punchy, energetic, simple drumming style. | ["instrumental", "fast tempo", "percussion", "cymbal rides", "steady drumming", "snare drums", "cymbals", "bass drum", "auxiliary percussion instruments", "tom-toms", "floor tom-tom", "hi-hat cymbals", "steady drumming", "simple drumming style", "drum solo", "tutorial"] | ["Cymbal", "Drum", "Drum kit", "Bell", "Hi-hat", "Music", "Musical instrument", "Snare drum"] | 7 | 30 | 40 | 1 | 1 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/0395lw", "/m/03qtq", "/m/04rlf", "/m/04szw", "/m/06rvn"] | |
WCl93HBuj60 | This music is instrumental. The tempo is fast with lively percussion rhythms of the drums, cymbal riffs, congas, bongos, steel pan and piano accompaniment. The music is lively, spirited, engaging, funky, groovy and buoyant. This music is a percussive instrumental. | ["instrumental", "fast tempo", "intense drumming", "infectious drumming", "percussive instrumental", "piano accompaniment", "congas", "bongos", "steel pan", "percussion instruments", "cymbals", "upbeat", "lively catchy", "energetic", "enthusiastic", "hand percussions", "piano accompaniment"] | ["Drum", "Jazz", "Music", "Musical instrument", "Steelpan"] | 7 | 490 | 500 | 0 | 0 | ["/m/026t6", "/m/03_d0", "/m/04rlf", "/m/04szw", "/m/0l156b"] |
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 );