musiccaps
2 rows where aspect_list contains "electric bass" and audioset_ids contains "/m/015lz1"
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"] | |
ZYUAY6EN05Q | Cheery and joyous music which would fit well in a musical. Complex vocal arrangements with female background vocals, male and female lead vocalists singing in unison one octave apart. Piano, electric bass, and orchestral accompaniment drive the compound meter. | ["cheery", "joyous", "musical", "complex vocal arrangement", "piano", "electric bass", "compound meter", "male lead vocalist", "female vocalist", "unison", "orchestral accompaniment", "female background vocals"] | ["Christmas music", "Singing", "Music", "Independent music"] | 8 | 30 | 40 | 0 | 0 | ["/m/0140xf", "/m/015lz1", "/m/04rlf", "/m/05rwpb"] |
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 );