musiccaps
2 rows where audioset_ids contains "/m/03t3fj", audioset_ids contains "/m/0l14md" and end_s = 150
This data as json, CSV (advanced)
Suggested facets: audioset_ids (array)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
MrMXYO2fzJ4 | The low quality recording features a latin jazz song played in the background over which a drums solo is played. The solo consists of shimmering hi hats, punchy snare and kick hits and low tom rolls, while the latin jazz song consists of groovy piano chords and wooden percussion. It sounds energetic and exciting. | ["low quality", "latin jazz", "groovy piano chords", "wooden percussion", "drums solo", "punchy kick", "punchy snare", "low tom roll", "shimmering hi hats", "energetic", "exciting"] | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Bass drum", "Percussion"] | 4 | 140 | 150 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/03qtq", "/m/03t3fj", "/m/0bm02", "/m/0l14md"] | |
_DHMdtRRJzE | This audio contains someone playing a complex drum groove with fill-ins on cymbals and toms. An e-guitar is playing a dangerous sounding melody along with a distorted e-guitar playing a melody in a higher key and another one in a lower key. This song may be playing live at a festival. | ["progressive rock", "e-guitar", "e-bass", "acoustic drums", "fast tempo", "dangerous atmosphere"] | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 6 | 140 | 150 | 0 | 0 | ["/m/026t6", "/m/02hnl", "/m/02k_mr", "/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 );