musiccaps
1 row where aspect_list contains "guiro" and aspect_list contains "tuba"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- animated 1
- banjo 1
- brass band 1
- brass instruments 1
- buskers 1
- busking 1
- busking percussion 1
- clarinet 1
- fast tempo 1
- guiro · 1 ✖
- instrumental 1
- lively 1
- resonator 1
- scratching sound 1
- shakers 1
- spirited 1
- street busking 1
- trombones 1
- trumpet 1
- tuba · 1 ✖
- wind instrument 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
4EwWBI-tHLk | This music is a lively harmony of the brass and wind instruments. The tempo is fast with lively tuba, trombone, trumpet, clarinet with mandolin and resonator accompaniment and busking percussion that sounds like scratching. His music is loud, vibrant, perky, engaging and animated street busking. | ["instrumental", "fast tempo", "brass band", "tuba", "clarinet", "street busking", "trumpet", "scratching sound", "guiro", "busking percussion", "lively", "animated", "spirited", "trombones", "clarinet", "wind instrument", "brass instruments", "banjo", "resonator", "shakers", "busking", "buskers"] | ["Brass instrument", "Clarinet", "Trombone", "Trumpet"] | 7 | 30 | 40 | 0 | 0 | ["/m/01kcd", "/m/01wy6", "/m/07c6l", "/m/07gql"] |
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 );