musiccaps
2 rows where aspect_list contains "groovy", aspect_list contains "passionate" and aspect_list contains "youtube music video"
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 |
---|---|---|---|---|---|---|---|---|---|---|
PaQGXIh94uc | The song is an instrumental. The song is medium tempo with a ukulele played with a fast strumming technique. The song is groovy and melancholic. The song audio quality is poor but is very relaxing to listen to. | ["live performance", "ukulele player", "instrumental music", "relaxing", "casual", "fast tempo", "technique and expertise", "ukulele online lessons", "poor audio quality", "ukulele strummed fast", "lovely", "entertaining", "passionate", "groovy", "no other instrumentation", "youtube music video", "live demo", "youtube cover", "melancholic", "emotional"] | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | 1 | 150 | 160 | 0 | 1 | ["/m/04rlf", "/m/04szw", "/m/07xzm", "/m/0fx80y"] | |
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 );