musiccaps
2 rows where aspect_list contains "guitar licks" and audioset_ids contains "/m/02rr_"
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 |
---|---|---|---|---|---|---|---|---|---|---|
R4b_-IT43P4 | The song is an instrumental. The song is medium tempo with an amplified guitar solo lead, complete with knob flicking tones. The song is loud and energetic. The audio quality is poor and recorded live at home. | ["electric guitar lead", "poor audio quality", "rock solo", "guitar amplifier", "home music video", "guitar tone test demo", "medium tempo", "rock guitar lead", "tremolo tones", "echo tones", "amplifier knob flicks", "loud music", "emotional", "passionate", "exciting", "medium tempo", "guitar licks"] | ["Blues", "Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | 1 | 30 | 40 | 0 | 1 | ["/m/0155w", "/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/04rlf", "/m/0g12c5"] | |
cHMDIt3-TsE | This clip features an electric guitar being played. This electric guitar has a distortion effect. A chorus effect is also added. The distortion guitar starts off with a descending lick on the pentatonic scale followed by palm muted power chords. A few double stops are played and at the end, a string bend is played. There are no other instruments in this song. There is no voice in this clip. This song can be used in a demo of a chorus effects pedal. | ["electric guitar", "distortion guitar", "guitar riffs", "guitar licks", "no other instrument", "no voice", "instrumental"] | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | 0 | 30 | 40 | 0 | 0 | ["/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/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 );