musiccaps
1 row where aspect_list contains "dexterity", aspect_list contains "inferior quality audio" and aspect_list contains "pop rock"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 );