musiccaps
1 row where audioset_names contains "Guitar" and audioset_names contains "Rattle (instrument)"
This data as json, CSV (advanced)
audioset_names (array) 6 ✖
- Guitar · 1 ✖
- Music 1
- Musical instrument 1
- Plucked string instrument 1
- Rattle (instrument) · 1 ✖
- Ukulele 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
LjxhswBV1UA | This song has a traditional Mexican mariachi sound. It is fun, vibrant and energetic and is led by rhythmic and melodic playing on the Mexican Vihuela. The maracas add an element of rhythmic percussion. There are sounds of laughter in the background. | ["maracas", "background laughter sounds", "mexican vihuela", "mexican traditional music", "percussion", "stringed instrument", "mariachi music", "fiesta", "celebration", "upbeat", "energetic", "fun"] | ["Guitar", "Music", "Musical instrument", "Rattle (instrument)", "Ukulele", "Plucked string instrument"] | 3 | 20 | 30 | 0 | 1 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/05r5wn", "/m/07xzm", "/m/0fx80y"] |
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 );