musiccaps
3 rows where audioset_ids contains "/m/03t3fj", audioset_ids contains "/m/0l14md" and end_s = 80
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 |
---|---|---|---|---|---|---|---|---|---|---|
CxgVq6eovRU | The low quality recording features a drums tutorial where a flat male vocalist is talking after shimmering his hats, snappy snare hits and pumping kicks. It sounds groovy and the recording is noisy. | ["low quality", "noisy", "flat male vocal", "drums tutorial", "shimmering hi hats", "pumping kick", "snappy snare", "groovy"] | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 4 | 70 | 80 | 0 | 0 | ["/m/026t6", "/m/02hnl", "/m/02k_mr", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] | |
t1ULMDpL35I | The low quality recording features a jazz live performance that consists of saxophone solo melody played over energetic cymbals, manic tom roll, punchy snare and kick hits, organ keys chords, groovy double bass and groovy piano chords. It sounds passionate and upbeat. | ["live performance", "jazz", "saxophone solo melody", "manic tom roll", "energetic cymbals", "punchy snare", "organ keys chords", "groovy double bass", "punchy kick", "groovy piano chords", "passionate", "upbeat"] | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 4 | 70 | 80 | 0 | 0 | ["/m/0239kh", "/m/026t6", "/m/02hnl", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] | |
wS4d-q9H4NE | This song is a drum solo. The hi-hat is played in eighths on the one, two and four counts of the bar. This drum is playing a syncopated rhythm. On the third count, the snare is played. The cowbell is played five times in 2 bars of eight counts. There are no other instruments in this song. There are no voices in this song. This song can be played as an instruction for syncopated drumming patterns. | ["drum solo", "cowbell accent", "moderate tempo", "no other instruments", "no voices", "instruction music", "instrumental"] | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 0 | 70 | 80 | 0 | 0 | ["/m/0239kh", "/m/026t6", "/m/02hnl", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] |
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 );