musiccaps
2 rows where aspect_list contains "bass clarinet" 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 |
---|---|---|---|---|---|---|---|---|---|---|
9WzzYYWpeyA | Here we have a quartet of clarinet players playing a classical piece. One of them plays a rapidly ascending melodic motif. The others play sustained notes ranging from bass to alto which provide a support for the melody. | ["quartet", "clarinet", "woodwind instruments", "bass clarinet", "alto clarinet", "harmonious classical music", "synchronous playing", "rapid ascending melody"] | ["Brass instrument", "Clarinet"] | 3 | 130 | 140 | 0 | 0 | ["/m/01kcd", "/m/01wy6"] | |
cSBRb4KF5xs | The song is an instrumental. The song is in medium tempo with a cello playing percussively, a clarinet in melody and supported in harmony by a bass clarinet and a trombone. The song is a rock song cover played live. The song is engaging and rich in quality. | ["clarinet", "bass clarinet", "trombone", "cell player", "rich quality", "western classical quartet", "song cover", "rock music cover", "medium tempo", "clarinet melody", "horn and string quartet", "live performance", "groovy rhythm", "instrumental music", "melancholic music", "mysterious", "live audience"] | ["Brass instrument", "Clarinet", "Trombone"] | 1 | 10 | 20 | 0 | 0 | ["/m/01kcd", "/m/01wy6", "/m/07c6l"] |
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 );