Dataset: Wittgenstein Centre, Human Capital (Historical Data + Projections)

About this Dataset

Wittgenstein Centre, Human Capital (Historical Data + Projections)

This website presents the 2023 revision of the Wittgenstein Centre population projections (Version 3), following the initial projections (Version 1) in 2013 (Lutz, Butz, and KC (Eds.) 2014) and the 2018 update (Version 2) (Lutz, Goujon, KC, Stonawski, and, Stilianakis (Eds.) 2018). Further details on the updates and the revisions can be found in K.C. et al. (2024) and in other satellite papers focusing on the migration component (Yildiz and Abel 2024), the mortality component (Dhakad and KC 2024 - forthcoming), and the fertility component (Adhikari et al. 2024 - forthcoming).

In 2021, the Shared Socioeconomic Pathways (SSPs) scenario community related to the Intergovernmental Panel on Climate Change requested an update of the human core of the SSPs, which is at the origin of this version. This updated version is based on 2020 as the reference year, with adjustments to certain short-term assumptions extending to 2030. However, most long-term assumptions have not been changed. Several changes were nevertheless implemented particularly in estimating and using country-specific education differentials in mortality and migration.

This new version includes population projections by levels of educational attainment from 2020 to 2100 for 200 countries according to seven scenarios (SSP1-5, SSP2-Zero Migration and SSP2-Double Migration). The reconstruction will become available in the course of 2024.

Tables

Human Capital, Wittgenstein Centre

@owid.wittgenstein_human_capital.owid_by_age

467.09 KB
778975 rows
5 columns


CREATE TABLE owid_by_age (
  "country" VARCHAR,
  "scenario" INTEGER,
  "age" VARCHAR,
  "year" INTEGER,
  "sexratio" FLOAT
);

Human Capital, Wittgenstein Centre

@owid.wittgenstein_human_capital.owid_by_age_edu

1.41 MB
1057980 rows
6 columns


CREATE TABLE owid_by_age_edu (
  "country" VARCHAR,
  "scenario" INTEGER,
  "age" VARCHAR,
  "education" VARCHAR,
  "year" INTEGER,
  "asfr" FLOAT
);

Human Capital, Wittgenstein Centre

@owid.wittgenstein_human_capital.owid_by_edu

504.25 KB
241080 rows
7 columns


CREATE TABLE owid_by_edu (
  "country" VARCHAR,
  "scenario" INTEGER,
  "education" VARCHAR,
  "year" INTEGER,
  "ggapedu15" FLOAT,
  "ggapedu25" FLOAT,
  "tfr" FLOAT
);

Human Capital, Wittgenstein Centre

@owid.wittgenstein_human_capital.owid_by_sex

190.88 KB
68700 rows
7 columns


CREATE TABLE owid_by_sex (
  "country" VARCHAR,
  "scenario" INTEGER,
  "sex" VARCHAR,
  "year" INTEGER,
  "pryl15" FLOAT,
  "ryl15" FLOAT,
  "e0" FLOAT
);

Human Capital, Wittgenstein Centre

@owid.wittgenstein_human_capital.owid_by_sex_age

3.74 MB
3058520 rows
6 columns


CREATE TABLE owid_by_sex_age (
  "country" VARCHAR,
  "scenario" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "year" INTEGER,
  "mys" FLOAT
);

Human Capital, Wittgenstein Centre

@owid.wittgenstein_human_capital.owid_by_sex_age_edu

100.15 MB
21161835 rows
9 columns


CREATE TABLE owid_by_sex_age_edu (
  "country" VARCHAR,
  "scenario" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "education" VARCHAR,
  "year" INTEGER,
  "pop" FLOAT,
  "assr" FLOAT,
  "prop" FLOAT
);

Human Capital, Wittgenstein Centre

@owid.wittgenstein_human_capital.owid_main

313.56 KB
35495 rows
13 columns


CREATE TABLE owid_main (
  "country" VARCHAR,
  "year" INTEGER,
  "scenario" INTEGER,
  "tdr" FLOAT,
  "ggapmys25" FLOAT,
  "mage" FLOAT,
  "ydr" FLOAT,
  "ggapmys15" FLOAT,
  "odr" FLOAT,
  "growth" FLOAT,
  "cbr" FLOAT,
  "nirate" FLOAT,
  "cdr" FLOAT
);