musiccaps
3 rows where audioset_names contains "Guitar", audioset_names contains "Singing" and author_id = 8
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 |
---|---|---|---|---|---|---|---|---|---|---|
7IndxxjZe1c | 70's jazz fusion featuring an eccentric male singer accompanied by drum kit, electric bass, electric piano and mallet percussion all playing odd meters and complex rhythms and staccato band hits. The music is quirky and complicated and features a drum fill. | ["quirky", "complicated", "eccentric male vocalist", "staccato band hits", "drum fill", "jazz fusion", "70's", "odd meter", "complex rhythms", "electric piano", "drums", "electric bass", "mallet percussion"] | ["Singing", "Guitar", "Music", "Musical instrument", "Ska", "Plucked string instrument"] | 8 | 70 | 80 | 0 | 0 | ["/m/015lz1", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06rqw", "/m/0fx80y"] | |
CD3OyaDW348 | A jazz organ trio playing a swing blues song with a male singer accompanied by electric guitar, Hammond organ, a steady ride pattern on the cymbals. The whole band hits on beat one with the drum breaks, as is common in this style of music. | ["jazz", "swing", "blues", "jazz electric guitar", "male vocalist", "drum breaks", "organ trio", "hammond organ", "b3", "steady ride pattern"] | ["Singing", "Swing music", "Guitar", "Music"] | 8 | 30 | 40 | 0 | 1 | ["/m/015lz1", "/m/015y_n", "/m/0342h", "/m/04rlf"] | |
KyRJP_fDrbk | Low-fidelity recording of a female singer displaying vocal virtuosity and melisma, accompaniment by strummed steel string acoustic guitar. | ["female singer", "melisma", "vocal virtuosity", "strummed acoustic guitar", "steel string guitar", "low-fidelity recording"] | ["Singing", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | 8 | 180 | 190 | 0 | 0 | ["/m/015lz1", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07s0s5r", "/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 );