musiccaps
1 row where aspect_list contains "distant trumpet melody" and aspect_list contains "noisy"
This data as json, CSV (advanced)
aspect_list (array) 9 ✖
- distant trumpet melody · 1 ✖
- energetic 1
- energetic cymbals 1
- loud 1
- low quality 1
- manic metallic percussions 1
- mono 1
- noisy · 1 ✖
- snare rolls 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
7lV4IvuW2lk | The low quality recording features a live performance of distant trumpet melody, followed by energetic cymbals, snare roll and manically played metallic percussion. It sounds energetic and loud, while the recording is noisy and in mono, as it was probably recorded with a phone. | ["low quality", "distant trumpet melody", "manic metallic percussions", "energetic cymbals", "snare rolls", "energetic", "loud", "noisy", "mono"] | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 4 | 410 | 420 | 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 );