musiccaps
2 rows where aspect_list contains "rock music" 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 |
---|---|---|---|---|---|---|---|---|---|---|
J0RzvGnQxD0 | This is an instrumental rock music jam. The only instrument is a clean-sounding electric guitar playing an arpeggio with an added echo effect. The atmosphere is calming. Although the recording quality is a bit low, this piece could be playing in the background of a rock bar after a decent mix is applied. | ["jam", "rock music", "electric guitar", "clean sound", "single instrument", "no singer", "instrumental", "echo", "gentle", "calm"] | ["Echo", "Effects unit", "Guitar", "Heavy metal", "Music", "Musical instrument", "Distortion"] | 9 | 60 | 70 | 0 | 1 | ["/m/01jnbd", "/m/02rr_", "/m/0342h", "/m/03lty", "/m/04rlf", "/m/04szw", "/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 );