musiccaps
1 row where aspect_list contains "guitar lead" and aspect_list contains "medium fast tempo"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- amateur recording 1
- amplified guitar 1
- dexterity 1
- distorted sound 1
- electric guitar 1
- guitar lead · 1 ✖
- inferior quality audio 1
- instrumental 1
- medium fast tempo · 1 ✖
- pop rock 1
- rock 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
OH8urnIthoQ | This song is an instrumental solo. The tempo is medium fast with the guitarist playing an enthusiastic lead on an amplified guitar. The music is distorted with inferior audio quality. This song is a PopRock/Rock. | ["instrumental", "amplified guitar", "guitar lead", "electric guitar", "medium fast tempo", "distorted sound", "amateur recording", "inferior quality audio", "dexterity", "rock", "pop rock"] | ["Reverberation", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Distortion"] | 7 | 60 | 70 | 0 | 1 | ["/m/01b9nn", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0g12c5"] |
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 );