musiccaps
2 rows where aspect_list contains "accordion", aspect_list contains "live performance" and aspect_list contains "lively"
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 |
---|---|---|---|---|---|---|---|---|---|---|
XOsHEjo-RSg | This is a Mexican folk music piece being performed live. There is male voice shouting at the end of the piece. The accordion is playing the main melody. The acoustic guitar and the bass guitar are playing in the background. The rhythmic background consists of a latin acoustic drum beat. The atmosphere is lively. This piece could be playing in the background at a Mexican restaurant. | ["mexican folk music", "live performance", "male voice", "shouting", "accordion", "bass guitar", "acoustic guitar", "acoustic drums", "lively", "vibrant"] | ["Accordion"] | 9 | 180 | 190 | 0 | 0 | ["/m/0mkg"] | |
xR2p3UED4VU | This is the live performance of a Romanian folk music piece. It is instrumental. There is an accordion playing the leading melody while the fiddle, acoustic guitar and the upright bass play in the background. There is a percussive element in the rhythmic background. The atmosphere is lively and joyful. | ["romanian folk music", "live performance", "instrumental", "accordion", "upright bass", "acoustic guitar", "percussion", "fiddle", "lively", "upbeat", "joyful"] | ["Accordion"] | 9 | 20 | 30 | 0 | 0 | ["/m/0mkg"] |
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 );