National Economic and Demographic Development

This dataset provides a comprehensive, structured relational view of global economic performance and demographic transitions over a 54-year period (1970–2024). The data is organized into five normalized tables designed for relational database research and analysis. The core of the dataset is the COUNTRY entity, which serves as a dimensional hub for three major indicator groups: Economic Indicators, Demographic Statistics, and Investment Infrastructure.

Economic indicators include Gross Domestic Product (GDP) in current USD, GDP per Capita, Inflation rates (CPI), and Unemployment rates. Demographic statistics track Total Population, Life Expectancy at birth, Median Age, and Rural/Urban population shifts. Finally, the Investment Infrastructure table captures public spending on education and healthcare as a percentage of GDP, along with Gross Fixed Capital Formation (Infrastructure Investment) in USD.

The primary objective of this dataset is to enable researchers to analyze the multi-dimensional correlations between financial growth and human development. For example, users can query the relationship between healthcare spending (Investment) and life expectancy (Demographics) or observe how rapid urbanization impacts regional inflation rates. By providing the data in a normalized format, this collection eliminates the redundancy typically found in flat-file World Bank exports, making it ready for immediate import into SQL-based environments for complex join-based analysis and longitudinal studies.

本数据集以结构化关系型视角，完整呈现1970年至2024年（共54年）的全球经济表现与人口转型全貌。数据被整理为五张规范化数据表，适配关系数据库的研究与分析场景。
数据集的核心为国家实体（COUNTRY entity），其作为维度枢纽，关联三大指标类别：经济指标（Economic Indicators）、人口统计数据（Demographic Statistics）与投资基础设施（Investment Infrastructure）。
经济指标包含以现价美元计价的国内生产总值（Gross Domestic Product, GDP）、人均国内生产总值、通货膨胀率（消费者物价指数，CPI）以及失业率。人口统计数据涵盖总人口、出生时预期寿命、年龄中位数以及城乡人口迁移变化。最后，投资基础设施数据表收录以GDP占比核算的教育与医疗公共支出，以及以美元计价的固定资本形成总额（Gross Fixed Capital Formation，即基础设施投资）。
本数据集的核心宗旨是支持研究者分析经济增长与人类发展之间的多维关联。例如，使用者可查询医疗支出（投资维度）与预期寿命（人口维度）的相关关系，或观察快速城市化对区域通货膨胀率的影响。本数据集采用规范化格式存储，消除了平面文件格式的世界银行导出数据中普遍存在的冗余问题，可直接导入基于结构化查询语言（Structured Query Language, SQL）的环境，用于开展复杂关联分析与纵向研究。