musiccaps
2 rows where aspect_list contains "solo" 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 |
---|---|---|---|---|---|---|---|---|---|---|
DvOA0K-DIFM | This is an amateur jam video of an electric guitar solo. The player uses the flanger pedal to achieve the effect of two tape recordings playing at the same time, one slower than the other. This piece could be used as a sample for a beat with a trippy feel. | ["jam", "instrumental", "electric guitar", "solo", "flanger pedal", "trippy"] | ["Tapping (guitar technique)", "Effects unit", "Music", "Musical instrument", "Steel guitar, slide guitar", "Distortion"] | 9 | 30 | 40 | 0 | 1 | ["/m/01glhc", "/m/02rr_", "/m/04rlf", "/m/04szw", "/m/06w87", "/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 );