musiccaps
2 rows where aspect_list contains "guitar effects pedal" and audioset_ids contains "/m/07m2kt"
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 |
---|---|---|---|---|---|---|---|---|---|---|
4Psyk_xyBl0 | The track features an electric guitar with a chorus pedal effect. The guitar alternates between riff to melody. The sound is space-like and almost psychedelic. The atmosphere is sweet and dreamy. | ["chorus electric guitar", "guitar effects pedal", "mid tempo", "psychedelic", "no vocals", "dreamy"] | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | 5 | 40 | 50 | 0 | 1 | ["/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y", "/m/0g12c5"] | |
merGvga39Yo | The song is an instrumental. The tempo is medium fast with a guitar playing lead with a guitar effects pedal producing a distorted grunge tone. The song is energetic and passionate with no other instrumentation. The song audio quality is very poor. | ["instrumental music", "guitar playing", "audio units", "tech gear demos", "demo video", "rock music", "amateur recording", "poor audio quality", "guitar effects pedal", "amplification", "guitar distortion", "guitar rhythm", "groovy music", "grunge tones", "poor audio quality", "effects pedal demonstration", "energetic", "youthful", "passionate", "spirited", "solo", "soloist", "home studio", "amateur recording", "rock music", "medium tempo"] | ["Effects unit", "Guitar", "Music", "Chorus effect", "Plucked string instrument", "Distortion"] | 1 | 30 | 40 | 0 | 1 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/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 );