musiccaps
2 rows where aspect_list contains "pop rock" and audioset_ids contains "/m/02sgy"
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 |
---|---|---|---|---|---|---|---|---|---|---|
AuwwPMrH5sE | This is the electric guitar cover of a pop punk/pop rock music piece. There is an electric guitar playing a simple riff. In the backing track, a male vocalist is singing melodically at a high range. | ["cover", "pop punk", "pop rock", "electric guitar", "simple riff", "male vocal", "high pitch singing"] | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Pulse", "Plucked string instrument"] | 9 | 170 | 180 | 0 | 0 | ["/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07pt_g0", "/m/0fx80y"] | |
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 );