musiccaps
2 rows where aspect_list contains "composers", aspect_list contains "live performance" and aspect_list contains "philharmonic orchestra"
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 |
---|---|---|---|---|---|---|---|---|---|---|
CZWLPPO0KL4 | A female opera singer sings this high pitched lyrical melody. The song tempo is slow with a philharmonic orchestra accompaniment, with a string section harmony and pizzicato violin play. The song is extremely emotional and spirited. The song is a vintage opera hit. | ["opera singer", "high pitched singing", "vintage opera", "string section harmony", "western classic music legends", "live performance", "philharmonic orchestra", "lyrical singing", "string section singing", "slow tempo", "opera classics", "opera legend", "lilting music", "subdued harmony", "retro classic hits", "classical vocalist", "emotional", "poignant", "cheerful", "positive", "inspirational", "violins strings plucked", "pizzicato", "composers", "conductor", "opera hall", "western classical music"] | ["Music", "Opera"] | 1 | 170 | 180 | 0 | 1 | ["/m/04rlf", "/m/05lls"] | |
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 );