musiccaps
2 rows where aspect_list contains "piano" and aspect_list contains "trumpet solo"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- piano · 2 ✖
- trumpet solo · 2 ✖
- acoustic bass 1
- acoustic jazz drums 1
- audience sounds 1
- complex 1
- danceable 1
- improvisation 1
- instrumental 1
- jazz 1
- jazz fusion 1
- latin jazz 1
- live performance 1
- no singer 1
- recital hall 1
- restless 1
- reverb 1
- sneeze 1
- syncopated drums 1
- upbeat rhythm 1
- upright bass 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
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 );