Wittgenstein Centre, Human Capital (Historical Data + Projections)
@owid.wittgenstein_human_capital
@owid.wittgenstein_human_capital
CREATE TABLE owid_by_age (
"country" VARCHAR,
"scenario" INTEGER,
"age" VARCHAR,
"year" INTEGER,
"sexratio" FLOAT
);
CREATE TABLE owid_by_age_edu (
"country" VARCHAR,
"scenario" INTEGER,
"age" VARCHAR,
"education" VARCHAR,
"year" INTEGER,
"asfr" FLOAT
);
CREATE TABLE owid_by_edu (
"country" VARCHAR,
"scenario" INTEGER,
"education" VARCHAR,
"year" INTEGER,
"ggapedu15" FLOAT,
"ggapedu25" FLOAT,
"tfr" FLOAT
);
CREATE TABLE owid_by_sex (
"country" VARCHAR,
"scenario" INTEGER,
"sex" VARCHAR,
"year" INTEGER,
"pryl15" FLOAT,
"ryl15" FLOAT,
"e0" FLOAT
);
CREATE TABLE owid_by_sex_age (
"country" VARCHAR,
"scenario" INTEGER,
"sex" VARCHAR,
"age" VARCHAR,
"year" INTEGER,
"mys" FLOAT
);
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
);
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
);
Anyone who has the link will be able to view this.