musiccaps
1 row where aspect_list contains "composers" and aspect_list contains "horn section"
This data as json, CSV (advanced)
aspect_list (array) 25 ✖
- bassoons 1
- brass section 1
- clarinet player 1
- clarinets 1
- composers · 1 ✖
- concert hall 1
- conductor 1
- energetic 1
- exciting 1
- grand 1
- high pitched melody 1
- horn section · 1 ✖
- humour 1
- instrumental music 1
- live audience 1
- live performance 1
- medium tempo 1
- passionate 1
- philharmonic orchestra 1
- pomp 1
- poor audio quality 1
- spirited 1
- syncopated rhythms 1
- trumpets 1
- tubas 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
Z-Vb1Ay-zNA | The song is an instrumental. The tempo is medium with a clarinet playing lead supported by a wind section, horn section, brass section and other percussion. The song is exciting and energetic. The song is a western classic tune with bad audio quality issues. | ["clarinet player", "horn section", "brass section", "philharmonic orchestra", "instrumental music", "trumpets", "conductor", "medium tempo", "instrumental music", "concert hall", "high pitched melody", "syncopated rhythms", "grand", "exciting", "pomp", "humour", "energetic", "passionate", "composers", "conductor", "live audience", "live performance", "poor audio quality", "spirited", "tubas", "clarinets", "bassoons"] | ["Brass instrument", "Clarinet", "Trumpet"] | 1 | 400 | 410 | 0 | 0 | ["/m/01kcd", "/m/01wy6", "/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 );