musiccaps
2 rows where aspect_list contains "rock music" and audioset_ids contains "/m/01qbl"
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 |
---|---|---|---|---|---|---|---|---|---|---|
KjJj5-HvSvQ | This is a box opening video. There is a male voice speaking and kids shouting. A rock music piece starts playing with a common sounding electric guitar tune and a simple acoustic drum beat. The atmosphere is generic. | ["box opening video", "male voice speaking", "clap sounds", "kids shouting", "rock music", "electric guitar", "acoustic drums", "generic", "common sounding"] | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 9 | 20 | 30 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/03qtq", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] | |
nu_Bl8Pz6PE | This music is instrumental. The tempo is fast with a groovy drumming rhythm with bass drums, snares, cymbals and a Cowbell. The rhythm is upbeat, catchy, punchy and buoyant. This music is a Drumming lesson/ tutorial. | ["instrumental", "fast tempo", "rhythmic beat", "idiophone", "non tuned percussion", "rock music", "cowbell", "percussion", "upbeat", "catchy", "punchy", "buoyant", "drumming", "groovy drumming", "snare", "cymbals", "bass drums", "cow bell", "sound of bell", "drumming lesson", "drumming tutorial"] | ["Cymbal", "Cowbell", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 7 | 50 | 60 | 0 | 0 | ["/m/01qbl", "/m/0239kh", "/m/026t6", "/m/02hnl", "/m/03qtq", "/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 );