musiccaps
2 rows where aspect_list contains "distorted guitar" and audioset_ids contains "/m/06by7"
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 |
---|---|---|---|---|---|---|---|---|---|---|
8pit9UV69S8 | Harsh amateur recording of hardcore aggressive speed metal. The recording is blown out and distorted. Male scream vocals can be heard as well as loud drums and distorted guitar. | ["harsh", "agressive", "blown out", "distorted", "amateur recording", "speed metal", "hardcore", "male scream vocals", "loud drums", "distorted guitar"] | ["Music", "Rock music", "Pulse"] | 8 | 0 | 10 | 0 | 0 | ["/m/04rlf", "/m/06by7", "/m/07pt_g0"] | |
T8U3ihbHh9A | The song is an instrumental. The tempo is medium with a bass guitar using innovative improvisation skills along with a drum track with heavy cymbal crashes. The song is energetic and passionate. | ["funk rock", "slap bass", "instrumental music", "youtube music video", "experimental", "improvisational", "drum track", "cymbals crashing", "guitar effects pedal", "amplifier", "distorted guitar", "exciting", "passionate", "spirited", "quick slap bass inquest", "guitar demo", "technique video", "bass master class"] | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Rock music", "Plucked string instrument"] | 1 | 0 | 10 | 0 | 0 | ["/m/018vs", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06by7", "/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 );