musiccaps
1 row where aspect_list contains "passionate" and aspect_list contains "solo"
This data as json, CSV (advanced)
aspect_list (array) 23 ✖
- amateur recording 1
- amplification 1
- audio units 1
- demo video 1
- effects pedal demonstration 1
- energetic 1
- groovy music 1
- grunge tones 1
- guitar distortion 1
- guitar effects pedal 1
- guitar playing 1
- guitar rhythm 1
- home studio 1
- instrumental music 1
- medium tempo 1
- passionate · 1 ✖
- poor audio quality 1
- rock music 1
- solo · 1 ✖
- soloist 1
- spirited 1
- tech gear demos 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
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 );