musiccaps
1 row where aspect_list contains "amateur recording" and aspect_list contains "bagpiper"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- amateur recording · 1 ✖
- ambient sounds 1
- bagpiper · 1 ✖
- bellows-blown bagpipe 1
- chamber instrument 1
- droning 1
- emotional 1
- fast tempo 1
- haunting 1
- humming melody 1
- instrumental 1
- live audience 1
- live performance 1
- loud 1
- passionate 1
- people talking 1
- rhythmic foot tapping 1
- small pipe harmony 1
- static 1
- woodwind 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
IbD0zpcimgM | This music is instrumental. The tempo is fast with a spirited small pipe harmony with rhythmic foot tapping. The music is upbeat, engaging, sharp, humming, haunting, droning and cheerful. This a live performance with ambient sounds of people talking and static as this is an amateur recording. | ["instrumental", "fast tempo", "small pipe harmony", "droning", "haunting", "emotional", "passionate", "loud", "humming melody", "amateur recording", "rhythmic foot tapping", "live performance", "live audience", "static", "ambient sounds", "people talking", "bellows-blown bagpipe", "bagpiper", "woodwind", "chamber instrument"] | ["Bagpipes", "Wind instrument, woodwind instrument"] | 7 | 30 | 40 | 0 | 0 | ["/m/0192l", "/m/085jw"] |
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 );