World Bank Education Statistics (EdStats)

CREATE TABLE owid_education (
  "country" VARCHAR,
  "year" INTEGER,
  "combined_expenditure" FLOAT,
  "combined_literacy" FLOAT,
  "expected_years_of_school" FLOAT,
  "harmonized_test_scores" FLOAT,
  "learning_adjusted_years_of_school" FLOAT,
  "piaac_mean_adult_literacy_proficiency_total" FLOAT,
  "piaac_mean_adult_numeracy_proficiency_total" FLOAT,
  "piaac_mean_young_adult_numeracy_proficiency_total" FLOAT,
  "pisa_mean_performance_on_the_mathematics_scale" FLOAT,
  "pisa_female_15_year_olds_by_mathematics_proficiency_le_6851482c" FLOAT,
  "pisa_male_15_year_olds_by_mathematics_proficiency_leve_f581001c" FLOAT,
  "pisa_mean_performance_on_the_mathematics_scale_female" FLOAT,
  "pisa_mean_performance_on_the_mathematics_scale_male" FLOAT,
  "pisa_mean_performance_on_the_reading_scale" FLOAT,
  "pisa_mean_performance_on_the_reading_scale_female" FLOAT,
  "pisa_mean_performance_on_the_reading_scale_male" FLOAT,
  "normalized_hci" FLOAT,
  "annual_statutory_teacher_salaries_in_public_institutio_8da0abae" FLOAT,
  "wittgenstein_projection_percentage_of_the_population_a_8eba3c9d" FLOAT,
  "saber_teachers_policy_goal_7_supporting_teachers_to_im_99acc051" FLOAT,
  "literacy_rate_youth_female_pct_of_females_ages_15_24" FLOAT,
  "literacy_rate_youth_male_pct_of_males_ages_15_24" FLOAT,
  "literacy_rate_youth_total_pct_of_people_ages_15_24" FLOAT,
  "literacy_rate_adult_total_pct_of_people_ages_15_and_above" FLOAT,
  "compulsory_education_duration_years" FLOAT,
  "school_enrollment_preprimary_pct_gross" FLOAT,
  "percentage_of_enrolment_in_pre_primary_education_in_pr_f23f2b1b" FLOAT,
  "school_enrollment_primary_pct_gross" FLOAT,
  "school_enrollment_primary_private_pct_of_total_primary" FLOAT,
  "trained_teachers_in_primary_education_pct_of_total_teachers" FLOAT,
  "primary_education_teachers_pct_female" FLOAT,
  "school_enrollment_secondary_pct_gross" FLOAT,
  "trained_teachers_in_secondary_education_pct_of_total_teachers" FLOAT,
  "secondary_education_teachers_pct_female" FLOAT,
  "school_enrollment_tertiary_pct_gross" FLOAT,
  "tertiary_education_academic_staff_pct_female" FLOAT,
  "government_expenditure_on_education_total_pct_of_gover_a5b9de6b" FLOAT,
  "government_expenditure_on_education_total_pct_of_gdp" FLOAT,
  "share_of_youth_not_in_education_employment_or_training_123889ad" FLOAT,
  "share_of_youth_not_in_education_employment_or_training_9ec66868" FLOAT,
  "official_entrance_age_to_compulsory_education_years" FLOAT,
  "completion_rate_lower_secondary_education_both_sexes_pct" FLOAT,
  "completion_rate_upper_secondary_education_both_sexes_pct" FLOAT,
  "uis_percentage_of_population_age_25plus_with_at_least__5ad211be" FLOAT,
  "uis_percentage_of_population_age_25plus_with_at_least__b37fe0eb" FLOAT,
  "uis_mean_years_of_schooling_isced_1_or_higher_populati_64783938" FLOAT,
  "uis_mean_years_of_schooling_isced_1_or_higher_populati_ca77add0" FLOAT,
  "literacy_rate_population_25_64_years_both_sexes_pct" FLOAT,
  "elderly_literacy_rate_population_65plus_years_both_sexes_pct" FLOAT,
  "inbound_mobility_rate_both_sexes_pct" FLOAT,
  "total_net_attendance_rate_primary_both_sexes_pct" FLOAT,
  "total_net_enrolment_rate_primary_both_sexes_pct" FLOAT,
  "total_net_enrolment_rate_primary_gender_parity_index_gpi" FLOAT,
  "total_net_enrolment_rate_lower_secondary_gender_parity_cd6a6bff" FLOAT,
  "out_of_school_children_adolescents_and_youth_of_primar_8f6c15c7" FLOAT,
  "out_of_school_children_adolescents_and_youth_of_primar_334bd155" FLOAT,
  "outbound_mobility_ratio_all_regions_both_sexes_pct" FLOAT,
  "pupil_qualified_teacher_ratio_in_pre_primary_education_b0d3228d" FLOAT,
  "pupil_qualified_teacher_ratio_in_primary_education_hea_ec2fa981" FLOAT,
  "percentage_of_qualified_teachers_in_secondary_educatio_b173af53" FLOAT,
  "proportion_of_students_at_the_end_of_lower_secondary_e_d044ba03" FLOAT,
  "proportion_of_primary_schools_with_single_sex_basic_sa_9008432e" FLOAT,
  "proportion_of_primary_schools_with_access_to_basic_dri_3b7c42c5" FLOAT,
  "school_life_expectancy_primary_gender_parity_index_gpi" FLOAT,
  "official_entrance_age_to_pre_primary_education_years" FLOAT,
  "theoretical_duration_of_pre_primary_education_years" FLOAT,
  "government_expenditure_on_education_pppdollar_millions" FLOAT,
  "government_expenditure_on_pre_primary_education_as_pct_1b0f1170" FLOAT,
  "government_expenditure_on_primary_education_as_pct_of_gdp_pct" FLOAT,
  "government_expenditure_on_secondary_education_as_pct_of_gdp_pct" FLOAT,
  "government_expenditure_on_tertiary_education_as_pct_of_gdp_pct" FLOAT,
  "all_staff_compensation_as_pct_of_total_expenditure_in__f8a49844" FLOAT,
  "all_staff_compensation_as_pct_of_total_expenditure_in__2ae2eb15" FLOAT,
  "initial_government_funding_per_primary_student_constan_27b1bdaf" FLOAT
);