A 50-Year Relational Time-Series of Economic and Demographic Development of 217 World Bank economies (1976-2025): Macroeconomic, Demographic, and Other Developmental Indicators

The dataset is a relational, analytics-oriented panel designed to support research on global development patterns across 217 World Bank economies from 1976 through 2025. It consolidates wide-range of indicators from the World Bank and the United Nations into a consistent country-year structure, making it suitable for econometric modeling, trend analysis, policy benchmarking, and cross-domain feature engineering.

Most indicator tables use a composite key of Country_ISO3_Code + Observation_Year, which enables clean joins across domains without reshaping source files each time. Core indicator domains include:
- Macroeconomics: GDP, GDP per capita PPP, inflation, unemployment
- Demographics: population, life expectancy, age distribution, urbanization
- Investment & Infrastructure: capital formation, electricity and internet access, broadband/mobile penetration, energy use, transport proxies
- Foreign Investment & External Finance: FDI inflows/outflows, remittances, ODA, external debt
- Education Investment & Outcomes: education spending, completion/literacy metrics, enrollment levels, and gender parity indicators

To support interpretability and governance, the dataset separates descriptive reference entities from measurements via dimension-style tables such as continent, lending category, and income group. A dedicated historical classification table tracks how each economy’s income group changes over time, allowing analysts to study structural transitions (for example, low-income to middle-income movement) while preserving period context.
Although the time window is broad and standardized, users should treat it as a bounded panel rather than a perfectly complete matrix: some countries or indicators may have missing values in specific years depending on source availability. Overall, the dataset is built to be SQL-friendly, reproducible, and directly usable for downstream BI dashboards, forecasting workflows, and academic-grade comparative analysis.
Overview of the included files:
- The “/data” folder includes original datasets.
- The “/Final_Dataset_20260411_144349” folder contains processed datasets.
- “transform.py” convert raw datasets into clean, relational datasets.
- “ER_Diagram.png” shows an overview and relationships between entities.
- “create_tables.sql” and “ER_model.mwb” are used to model the final data structures in mySQL Workbench.

本数据集为面向分析的关系型面板数据，旨在支持针对1976年至2025年间217个世界银行（World Bank）经济体的全球发展格局研究。它整合了世界银行与联合国（United Nations）的多维度指标，构建为统一的国家-年份结构，适用于计量经济学建模、趋势分析、政策基准对标以及跨领域特征工程。

多数指标表采用Country_ISO3_Code + Observation_Year复合主键，可实现跨领域的高效关联，无需每次重新重塑源文件格式。核心指标领域包括：
- 宏观经济学：GDP、人均购买力平价GDP（GDP per capita PPP）、通货膨胀率、失业率
- 人口学：人口总量、预期寿命、年龄结构、城市化水平
- 投资与基础设施：资本形成总额、电力与互联网普及率、宽带/移动网络渗透率、能源消耗、交通代理指标
- 外商投资与外部融资：外商直接投资（FDI）流入/流出额、汇款、官方发展援助（ODA）、外债规模
- 教育投入与成果：教育支出、毕业率/识字率指标、入学率及性别平等指标

为增强可解释性与治理性，本数据集通过维度表（如大陆分类、贷款类别、收入组别）将描述性参考实体与测量数据分离。专属的历史分类表可追踪各经济体收入组别的随时间变化情况，支持研究人员分析结构性转型（例如从低收入经济体向中等收入经济体的跃迁）并保留时期语境。

尽管时间窗口覆盖广泛且已标准化，用户仍应将其视为受限面板而非完美完整的矩阵：部分国家或指标在特定年份可能因数据源限制存在缺失值。总体而言，本数据集适配结构化查询语言（SQL）操作、可复现，可直接用于下游商业智能（BI）仪表盘、预测工作流及学术级别的比较分析。

数据集包含文件说明如下：
- `/data` 文件夹存放原始数据集
- `/Final_Dataset_20260411_144349` 文件夹存放已处理的数据集
- `transform.py` 用于将原始数据集转换为干净的关系型数据集
- `ER_Diagram.png` 展示实体概览及实体间关联关系
- `create_tables.sql` 与 `ER_model.mwb` 用于在MySQL Workbench中构建最终数据结构