musiccaps
2 rows where aspect_list contains "concert hall" and audioset_ids contains "/m/01kcd"
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 |
---|---|---|---|---|---|---|---|---|---|---|
G7pD1K3jYg4 | The low quality recording features a live performance of a classical song and it consists of tuba melody. It sounds mellow, soft and reverberant, as it was recorded in a huge concert hall. The recording is a bit noisy. | ["low quality", "tuba melody", "reverberant", "mellow", "noisy", "soft", "concert hall", "classical", "live performance"] | ["Brass instrument", "French horn"] | 4 | 30 | 40 | 0 | 0 | ["/m/01kcd", "/m/0319l"] | |
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 );