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 Literacy Proficiency, Total,
  "piaac_mean_adult_numeracy_proficiency_total" FLOAT  -- Piaac, Mean Adult Numeracy Proficiency, Total,
  "piaac_mean_young_adult_numeracy_proficiency_total" FLOAT  -- Piaac, Mean Young Adult Numeracy Proficiency, Total,
  "pisa_mean_performance_on_the_mathematics_scale" FLOAT  -- Pisa, Mean Performance On The Mathematics Scale,
  "pisa_female_15_year_olds_by_mathematics_proficiency_le_6851482c" FLOAT  -- Pisa, Female 15 Year Olds By Mathematics Proficiency Level, Pct, Level 6,
  "pisa_male_15_year_olds_by_mathematics_proficiency_leve_f581001c" FLOAT  -- Pisa, Male 15 Year Olds By Mathematics Proficiency Level, Pct, Level 6,
  "pisa_mean_performance_on_the_mathematics_scale_female" FLOAT  -- Pisa, Mean Performance On The Mathematics Scale, Female,
  "pisa_mean_performance_on_the_mathematics_scale_male" FLOAT  -- Pisa, Mean Performance On The Mathematics Scale, Male,
  "pisa_mean_performance_on_the_reading_scale" FLOAT  -- Pisa, Mean Performance On The Reading Scale,
  "pisa_mean_performance_on_the_reading_scale_female" FLOAT  -- Pisa, Mean Performance On The Reading Scale, Female,
  "pisa_mean_performance_on_the_reading_scale_male" FLOAT  -- Pisa, Mean Performance On The Reading Scale, Male,
  "normalized_hci" FLOAT,
  "annual_statutory_teacher_salaries_in_public_institutio_8da0abae" FLOAT  -- Annual Statutory Teacher Salaries In Public Institutions In Usd, Primary, 10 Years Of Experience,
  "wittgenstein_projection_percentage_of_the_population_a_8eba3c9d" FLOAT  -- Wittgenstein Projection, Percentage Of The Population Age 15plus By Highest Level Of Educational Attainment, No Education, Total,
  "saber_teachers_policy_goal_7_supporting_teachers_to_im_99acc051" FLOAT  -- Saber, Teachers, Policy Goal 7, Supporting Teachers To Improve Instruction,
  "literacy_rate_youth_female_pct_of_females_ages_15_24" FLOAT  -- Literacy Rate, Youth Female, Pct Of Females Ages 15–24,
  "literacy_rate_youth_male_pct_of_males_ages_15_24" FLOAT  -- Literacy Rate, Youth Male, Pct Of Males Ages 15–24,
  "literacy_rate_youth_total_pct_of_people_ages_15_24" FLOAT  -- Literacy Rate, Youth Total, Pct Of People Ages 15–24,
  "literacy_rate_adult_total_pct_of_people_ages_15_and_above" FLOAT  -- Literacy Rate, Adult Total, Pct Of People Ages 15 And Above,
  "compulsory_education_duration_years" FLOAT  -- Compulsory Education, Duration, Years,
  "school_enrollment_preprimary_pct_gross" FLOAT  -- School Enrollment, Preprimary, Pct Gross,
  "percentage_of_enrolment_in_pre_primary_education_in_pr_f23f2b1b" FLOAT  -- Percentage Of Enrolment In Pre Primary Education In Private Institutions, Pct,
  "school_enrollment_primary_pct_gross" FLOAT  -- School Enrollment, Primary, Pct Gross,
  "school_enrollment_primary_private_pct_of_total_primary" FLOAT  -- School Enrollment, Primary, Private, Pct Of Total Primary,
  "trained_teachers_in_primary_education_pct_of_total_teachers" FLOAT  -- Trained Teachers In Primary Education, Pct Of Total Teachers,
  "primary_education_teachers_pct_female" FLOAT  -- Primary Education, Teachers, Pct Female,
  "school_enrollment_secondary_pct_gross" FLOAT  -- School Enrollment, Secondary, Pct Gross,
  "trained_teachers_in_secondary_education_pct_of_total_teachers" FLOAT  -- Trained Teachers In Secondary Education, Pct Of Total Teachers,
  "secondary_education_teachers_pct_female" FLOAT  -- Secondary Education, Teachers, Pct Female,
  "school_enrollment_tertiary_pct_gross" FLOAT  -- School Enrollment, Tertiary, Pct Gross,
  "tertiary_education_academic_staff_pct_female" FLOAT  -- Tertiary Education, Academic Staff, Pct Female,
  "government_expenditure_on_education_total_pct_of_gover_a5b9de6b" FLOAT  -- Government Expenditure On Education, Total, Pct Of Government Expenditure,
  "government_expenditure_on_education_total_pct_of_gdp" FLOAT  -- Government Expenditure On Education, Total, Pct Of Gdp,
  "share_of_youth_not_in_education_employment_or_training_123889ad" FLOAT  -- Share Of Youth Not In Education, Employment Or Training, Male, Pct Of Male Youth Population,
  "share_of_youth_not_in_education_employment_or_training_9ec66868" FLOAT  -- Share Of Youth Not In Education, Employment Or Training, Total, Pct Of Youth Population,
  "official_entrance_age_to_compulsory_education_years" FLOAT  -- Official Entrance Age To Compulsory Education, Years,
  "completion_rate_lower_secondary_education_both_sexes_pct" FLOAT  -- Completion Rate, Lower Secondary Education, Both Sexes, Pct,
  "completion_rate_upper_secondary_education_both_sexes_pct" FLOAT  -- Completion Rate, Upper Secondary Education, Both Sexes, Pct,
  "uis_percentage_of_population_age_25plus_with_at_least__5ad211be" FLOAT  -- Uis, Percentage Of Population Age 25plus With At Least Completed Lower Secondary Education, Isced 2 Or Higher, Total,
  "uis_percentage_of_population_age_25plus_with_at_least__b37fe0eb" FLOAT  -- Uis, Percentage Of Population Age 25plus With At Least Completed Post Secondary Education, Isced 4 Or Higher, Total,
  "uis_mean_years_of_schooling_isced_1_or_higher_populati_64783938" FLOAT  -- Uis, Mean Years Of Schooling, Isced 1 Or Higher, Population 25plus Years, Female,
  "uis_mean_years_of_schooling_isced_1_or_higher_populati_ca77add0" FLOAT  -- Uis, Mean Years Of Schooling, Isced 1 Or Higher, Population 25plus Years, Male,
  "literacy_rate_population_25_64_years_both_sexes_pct" FLOAT  -- Literacy Rate, Population 25–64 Years, Both Sexes, Pct,
  "elderly_literacy_rate_population_65plus_years_both_sexes_pct" FLOAT  -- Elderly Literacy Rate, Population 65plus Years, Both Sexes, Pct,
  "inbound_mobility_rate_both_sexes_pct" FLOAT  -- Inbound Mobility Rate, Both Sexes, Pct,
  "total_net_attendance_rate_primary_both_sexes_pct" FLOAT  -- Total Net Attendance Rate, Primary, Both Sexes, Pct,
  "total_net_enrolment_rate_primary_both_sexes_pct" FLOAT  -- Total Net Enrolment Rate, Primary, Both Sexes, Pct,
  "total_net_enrolment_rate_primary_gender_parity_index_gpi" FLOAT  -- Total Net Enrolment Rate, Primary, Gender Parity Index, Gpi,
  "total_net_enrolment_rate_lower_secondary_gender_parity_cd6a6bff" FLOAT  -- Total Net Enrolment Rate, Lower Secondary, Gender Parity Index, Gpi,
  "out_of_school_children_adolescents_and_youth_of_primar_8f6c15c7" FLOAT  -- Out Of School Children, Adolescents And Youth Of Primary And Secondary School Age, Female, Number,
  "out_of_school_children_adolescents_and_youth_of_primar_334bd155" FLOAT  -- Out Of School Children, Adolescents And Youth Of Primary And Secondary School Age, Male, Number,
  "outbound_mobility_ratio_all_regions_both_sexes_pct" FLOAT  -- Outbound Mobility Ratio, All Regions, Both Sexes, Pct,
  "pupil_qualified_teacher_ratio_in_pre_primary_education_b0d3228d" FLOAT  -- Pupil Qualified Teacher Ratio In Pre Primary Education, Headcount Basis,
  "pupil_qualified_teacher_ratio_in_primary_education_hea_ec2fa981" FLOAT  -- Pupil Qualified Teacher Ratio In Primary Education, Headcount Basis,
  "percentage_of_qualified_teachers_in_secondary_educatio_b173af53" FLOAT  -- Percentage Of Qualified Teachers In Secondary Education, Both Sexes, Pct,
  "proportion_of_students_at_the_end_of_lower_secondary_e_d044ba03" FLOAT  -- Proportion Of Students At The End Of Lower Secondary Education Achieving At Least A Minimum Proficiency Level In Reading, Both Sexes, Pct,
  "proportion_of_primary_schools_with_single_sex_basic_sa_9008432e" FLOAT  -- Proportion Of Primary Schools With Single Sex Basic Sanitation Facilities, Pct,
  "proportion_of_primary_schools_with_access_to_basic_dri_3b7c42c5" FLOAT  -- Proportion Of Primary Schools With Access To Basic Drinking Water, Pct,
  "school_life_expectancy_primary_gender_parity_index_gpi" FLOAT  -- School Life Expectancy, Primary, Gender Parity Index, Gpi,
  "official_entrance_age_to_pre_primary_education_years" FLOAT  -- Official Entrance Age To Pre Primary Education, Years,
  "theoretical_duration_of_pre_primary_education_years" FLOAT  -- Theoretical Duration Of Pre Primary Education, Years,
  "government_expenditure_on_education_pppdollar_millions" FLOAT  -- Government Expenditure On Education, Pppdollar, Millions,
  "government_expenditure_on_pre_primary_education_as_pct_1b0f1170" FLOAT  -- Government Expenditure On Pre Primary Education As Pct Of Gdp, Pct,
  "government_expenditure_on_primary_education_as_pct_of_gdp_pct" FLOAT  -- Government Expenditure On Primary Education As Pct Of Gdp, Pct,
  "government_expenditure_on_secondary_education_as_pct_of_gdp_pct" FLOAT  -- Government Expenditure On Secondary Education As Pct Of Gdp, Pct,
  "government_expenditure_on_tertiary_education_as_pct_of_gdp_pct" FLOAT  -- Government Expenditure On Tertiary Education As Pct Of Gdp, Pct,
  "all_staff_compensation_as_pct_of_total_expenditure_in__f8a49844" FLOAT  -- All Staff Compensation As Pct Of Total Expenditure In Primary Public Institutions, Pct,
  "all_staff_compensation_as_pct_of_total_expenditure_in__2ae2eb15" FLOAT  -- All Staff Compensation As Pct Of Total Expenditure In Public Institutions, Pct,
  "initial_government_funding_per_primary_student_constan_27b1bdaf" FLOAT  -- Initial Government Funding Per Primary Student, Constant Pppdollar
);