musiccaps
1 row where aspect_list contains "groovy" and aspect_list contains "guitar lessons online"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- booming bass line 1
- electric guitar player 1
- excited 1
- exciting 1
- groovy · 1 ✖
- groovy music 1
- guitar demonstration 1
- guitar lessons online · 1 ✖
- guitar licks 1
- guitar solo 1
- guitarist 1
- inspiring 1
- instrumental music 1
- medium fast tempo 1
- medium fats tempo 1
- passionate 1
- positive 1
- riffs 1
- soloist 1
- strumming rhythm 1
- youtube music video 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
Ta0GmXPnGWk | The song is an instrumental. The song is medium tempo with an electric guitar playing guitar riffs with a nice low end; The audio quality is average. The song is passionate and exciting. | ["electric guitar player", "guitarist", "riffs", "guitar licks", "passionate", "exciting", "guitar lessons online", "soloist", "youtube music video", "guitar demonstration", "excited", "positive", "medium fast tempo", "groovy music", "inspiring", "inspiring", "guitar solo", "medium fats tempo", "strumming rhythm", "groovy", "booming bass line", "instrumental music"] | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | 1 | 150 | 160 | 0 | 0 | ["/m/01b9nn", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/t/dd00125"] |
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 );