musiccaps
2 rows where audioset_names contains "Musical instrument", audioset_names contains "Trumpet" and author_id = 8
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 |
---|---|---|---|---|---|---|---|---|---|---|
DTkKGYCRMlc | Quick, forceful wind ensemble music featuring a horn solo with brass, tuba, bass drum and snare drum accompanying. | ["horn solo", "wind ensemble", "brass", "bass drum", "snare drum", "tuba", "quick tempo", "forceful"] | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Orchestra", "Trumpet", "Classical music"] | 8 | 80 | 90 | 0 | 1 | ["/m/01kcd", "/m/04fq5q", "/m/04rlf", "/m/04szw", "/m/05pd6", "/m/07gql", "/m/0ggq0m"] | |
eiyyoUt64Zc | a latin jazz ensemble performing in a recital hall. A trumpet solo is accompanied by acoustic bass, syncopated drums and piano. The rhythm is upbeat and danceable. You can hear the reverb of the recital hall as well as audience sounds, someone sneezing. | ["latin jazz", "trumpet solo", "acoustic bass", "recital hall", "reverb", "audience sounds", "sneeze", "piano", "syncopated drums", "upbeat rhythm", "danceable"] | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Trumpet", "Inside, large room or hall"] | 8 | 100 | 110 | 0 | 1 | ["/m/01kcd", "/m/03_d0", "/m/04rlf", "/m/04szw", "/m/07gql", "/t/dd00126"] |
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 );