musiccaps
2 rows where aspect_list contains "electric guitar", aspect_list contains "electric guitar lead", aspect_list contains "groovy" and aspect_list contains "jazz"
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 |
---|---|---|---|---|---|---|---|---|---|---|
kVYXcbvw9u4 | This music is an electronic instrumental; the tempo is medium with a solo electric guitar lead and no accompanying instruments. The music is melodic, rhythmic, and groovy. | ["instrumental", "electric guitar", "amplified", "vibration", "string instrument", "electric guitar lead", "minimalist", "groovy", "external amplification", "heavy metal", "rock", "reggae", "jazz", "funk"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | 7 | 580 | 590 | 1 | 1 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y", "/m/0g12c5"] | |
ouVuF-y8bog | This music is an electric guitar instrumental. The tempo is medium with a smooth electric guitar lead harmony. The music is clear, emphatic, smooth, groovy, youthful, crisp, edgy and dominant. | ["instrumental", "electric guitars", "medium tempo", "demonstration", "tutorial", "learning electric", "electric guitar lesson", "clear", "loud", "powerful", "empahtic", "amplified guitar", "electric guitar", "stringed instrument", "loud feed back", "blues", "rock", "jazz", "resonating", "reverb", "youthful", "groovy", "catchy riff", "smooth", "electric guitar lead", "electric guitar solo", "dense", "rich", "crisp", "edgy"] | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | 7 | 30 | 40 | 0 | 0 | ["/m/01b9nn", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/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 );