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.