musiccaps
1 row where aspect_list contains "acoustic guitar" and aspect_list contains "shouting"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- accordion 1
- acoustic drums 1
- acoustic guitar · 1 ✖
- bass guitar 1
- live performance 1
- lively 1
- male voice 1
- mexican folk music 1
- shouting · 1 ✖
- vibrant 1
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"] |
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 );