musiccaps
2 rows where aspect_list contains "entertaining", aspect_list contains "instrumental music", aspect_list contains "live performance" and aspect_list contains "passionate"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0HXYdGGKV2k | The song is an instrumental. The song is medium tempo with a groovy rhythm and fast fingers playing this banjo solo. The song is entertaining and exciting. The song is of poor audio quality and a live performance video. | ["banjo player", "fast tempo", "groovy music", "love video performance", "instrumental music", "virtuoso", "walking bass line", "entertaining", "love performance", "soloist", "country blue grass", "entertaining", "energetic", "passionate", "spirited", "instrumentalist", "poor audio quality", "live performance"] | ["Banjo", "Music", "Bluegrass"] | 1 | 30 | 40 | 0 | 1 | ["/m/018j2", "/m/04rlf", "/m/0gg8l"] | |
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"] |
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 );