Education Statistics
2,500+ education indicators
@worldbank.education_statistics
2,500+ education indicators
@worldbank.education_statistics
The World Bank EdStats Query holds around 2,500 internationally comparable education indicators for access, progression, completion, literacy, teachers, population, and expenditures.
The indicators cover the education cycle from pre-primary to tertiary education. The query also holds learning outcome data from international learning assessments (PISA, TIMSS, etc.), equity data from household surveys, and projection data to 2050.
CREATE TABLE lo_pasec_rea_6_l3 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_l4 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_mg_gap (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_npp (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_p05 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_p1 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_p10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_p25 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_p50 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_p75 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_p90 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_p95 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_p99 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_pp (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_pp_gap (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_pri_gap (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_rea_6_ru_gap (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_1 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_2 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_3 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_4 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_5 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_be (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_fe (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_fe_1 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_fe_2 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_fe_3 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_fe_4 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_fe_45 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_fe_5 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_fe_be (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_ma_1 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_ma_2 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_ma_3 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_ma_4 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_ma_45 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_ma_5 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_ma_be (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_p05 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_p10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_p25 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_p50 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_p75 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_p90 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_p95 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_you (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_piaac_lit_you_1 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);Anyone who has the link will be able to view this.