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_llece_rea6_p10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_rea6_p25 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_rea6_p50 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_rea6_p75 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_rea6_p90 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_0 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_0_fe (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_0_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_1 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_1_fe (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_1_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_2 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_2_fe (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_2_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_3 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_3_fe (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_3_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_4 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_4_fe (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_4_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_fe (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_p10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_p25 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_p50 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_p75 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_llece_sci6_p90 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre5 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre5_fe (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre5_hig (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre5_hig_fe (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre5_hig_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre5_lo (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre5_lo_fe (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre5_lo_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre5_ma (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre_p05 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre_p10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre_p25 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre_p50 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre_p75 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre_p90 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_fre_p95 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_mat_2 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_mat_2_add1 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_mat_2_add2 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_mat_2_add3 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_mat_2_cnt_0t60 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE lo_pasec_mat_2_cnt_61t80 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);Anyone who has the link will be able to view this.