musiccaps
2 rows where aspect_list contains "hand claps" and audioset_ids contains "/m/0326g"
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 |
---|---|---|---|---|---|---|---|---|---|---|
IwqD859w2_E | A fiery, passionate flamenco duet between a nylon string guitar player and a clapping dancer. The guitar playing is virtuosic, employing flamenco strumming and fast scales. The rhythms are complex and additive. | ["flamenco", "duet", "spanish guitar", "classical guitar", "nylon string guitar", "hand claps", "virtuosic", "fast scales", "flamenco strumming", "additive rhythm", "complex rhythm", "fiery", "passionate"] | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | 8 | 30 | 40 | 0 | 1 | ["/m/0326g", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/0fx80y"] | |
YzpzKyzyL0Y | Latin music featuring a quick tempo, hand percussion, tambourine, lively hand claps, guiro, a low tuned bass drum, an acoustic guitar solo with a wah effect, flamenco inspired fast acoustic guitar strumming, complex chords and a modern electric bass sound supporting a passionate female singer. | ["latin", "low tuned bass drum", "lively", "electric guitar", "wah", "acoustic guitar solo", "hand percussion", "fast strumming acoustic guitar", "flamenco influence", "tambourine", "guiro", "passionate female singer", "complex chords", "fast beat", "modern electric bass", "hand claps", "quick tempo"] | ["Flamenco", "Music", "Music of Latin America"] | 8 | 110 | 120 | 1 | 1 | ["/m/0326g", "/m/04rlf", "/m/0g293"] |
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 );