musiccaps
2 rows where aspect_list contains "electric guitar solo" and is_balanced_subset = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
guYWKdxrtIg | This music is an electric guitar solo. The tempo is medium fast with an animated electric guitar riff without any accompaniment. The music is loud, powerful, rhythmic and youthful with a bit of static or white noise . | ["instrumental", "medium fast tempo", "home video", "stringed instrument", "electric guitar lead", "amateur recording", "minimalist", "no accompaniment", "electric guitar solo", "amplified guitar", "static", "electric guitar solo", "vibration", "rock", "metal", "hard rock", "heavy metal", "powerful", "loud feedback", "sonic power"] | ["Bass guitar", "Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | 7 | 30 | 40 | 1 | 1 | ["/m/018vs", "/m/01glhc", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0g12c5"] | |
ylKvglDzBU4 | The song is an instrumental improvisation. The song is medium fast tempo with a groovy bass line, electric guitar playing, saxophone playing, jazz drumming with percussive hits and a xylophone playing. The song is highly improvisational and energetic. The song is a modern jazz fusion or improvisation jam. | ["funk jazz", "medium fast tempo", "instrumental music", "saxophone playing", "electric guitar solo", "funky jazz drumming", "groovy bass line", "drum rolls", "various percussion hits", "live improvisation", "bells percussion tones", "xylophone playing", "jazz improvisation", "energetic", "exciting", "jazz band", "modern jazz hits", "groovy rhythm", "jazz festival", "emphatic cries", "emotional", "passionate"] | ["Music", "Ska", "Vibraphone"] | 1 | 70 | 80 | 1 | 1 | ["/m/04rlf", "/m/06rqw", "/m/0dwt5"] |
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 );