musiccaps
1 row where aspect_list contains "organ keys chords" and aspect_list contains "punchy kick"
This data as json, CSV (advanced)
aspect_list (array) 12 ✖
- energetic cymbals 1
- groovy double bass 1
- groovy piano chords 1
- jazz 1
- live performance 1
- manic tom roll 1
- organ keys chords · 1 ✖
- passionate 1
- punchy kick · 1 ✖
- punchy snare 1
- saxophone solo melody 1
- upbeat 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
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"] |
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 );