musiccaps
2 rows where aspect_list contains "banjo" and audioset_ids contains "/m/01kcd"
This data as json, CSV (advanced)
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"] | |
VSf3_XpiPkQ | This is an indie folk music piece. There is a melancholic melody being played by the banjo and the trombone, then they both stop and the organ can be heard holding a note. The atmosphere is sentimental. This piece could be used in the soundtrack of a drama, especially during the scenes where people are mourning the loss of a character. | ["indie folk music", "instrumental", "banjo", "trombone", "organ", "sentimental", "melancholic"] | ["Brass instrument", "Trumpet"] | 9 | 210 | 220 | 0 | 0 | ["/m/01kcd", "/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 );