musiccaps
2 rows where aspect_list contains "jazz" and aspect_list contains "trumpet solo"
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 |
---|---|---|---|---|---|---|---|---|---|---|
HXwX9f9ugZ4 | This jazz song features a trumpet playing the main melody. This is accompanied by a string section. There are long pauses in between lines where the backing instruments pause while the trumpet solo is played. Percussion is played along with the string section. There are no voices in this song. This is an instrumental song. This song can be played in a silent movie. | ["jazz", "trumpet solo", "string section", "percussion", "bass", "no voices", "instrumental", "slow tempo"] | ["Jazz", "Music", "Classical music"] | 0 | 340 | 350 | 0 | 0 | ["/m/03_d0", "/m/04rlf", "/m/0ggq0m"] | |
R6k2BkwZt1Y | This is the live performance of a jazz music piece. There is a trumpet solo at the forefront. The background consists of the piano, the upright bass and a jazz acoustic drum beat. The atmosphere is restless. This piece could be playing in the background at a jazz bar. | ["jazz", "jazz fusion", "live performance", "no singer", "instrumental", "trumpet solo", "piano", "upright bass", "acoustic jazz drums", "improvisation", "complex", "restless"] | ["Brass instrument", "Trumpet"] | 9 | 120 | 130 | 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 );