This study presents a novel global database, Wikimpacts 1.0, that leverages natural language processing and automated information extraction to systematically capture multi-scale socio-economic impacts of climate extremes over nearly a millennium. By demonstrating strong accuracy and complementary coverage to established datasets, it highlights the transformative potential of AI-driven approaches to expand, refine and democratize climate impact data for research and decision-making.