UNESCO Institute For Statistics (UIS) - Education (other Policy Relevant Indicators)
@owid.education_opri
@owid.education_opri
CREATE TABLE owid_education_opri_1 (
"country" VARCHAR,
"year" INTEGER,
"adult_illiterate_population_15plus_years_pct_female" FLOAT,
"adult_illiterate_population_15plus_years_both_sexes_number" FLOAT,
"adult_illiterate_population_15plus_years_female_number" FLOAT,
"adult_illiterate_population_15plus_years_male_number" FLOAT,
"adult_illiterate_population_15plus_years_rural_pct_female" FLOAT,
"adult_illiterate_population_15plus_years_rural_both_se_015bf327" FLOAT,
"adult_illiterate_population_15plus_years_rural_female_number" FLOAT,
"adult_illiterate_population_15plus_years_rural_male_number" FLOAT,
"adult_illiterate_population_15plus_years_urban_pct_female" FLOAT,
"adult_illiterate_population_15plus_years_urban_both_se_84de2cf4" FLOAT,
"adult_illiterate_population_15plus_years_urban_female_number" FLOAT,
"adult_illiterate_population_15plus_years_urban_male_number" FLOAT,
"africa_students_from_algeria_both_sexes_number" FLOAT,
"africa_students_from_angola_both_sexes_number" FLOAT,
"africa_students_from_benin_both_sexes_number" FLOAT,
"africa_students_from_botswana_both_sexes_number" FLOAT,
"africa_students_from_burkina_faso_both_sexes_number" FLOAT,
"africa_students_from_burundi_both_sexes_number" FLOAT,
"africa_students_from_cameroon_both_sexes_number" FLOAT,
"africa_students_from_cape_verde_both_sexes_number" FLOAT,
"africa_students_from_chad_both_sexes_number" FLOAT,
"africa_students_from_comoros_both_sexes_number" FLOAT,
"africa_students_from_cote_divoire_both_sexes_number" FLOAT,
"africa_students_from_djibouti_both_sexes_number" FLOAT,
"africa_students_from_egypt_both_sexes_number" FLOAT,
"africa_students_from_equatorial_guinea_both_sexes_number" FLOAT,
"africa_students_from_eritrea_both_sexes_number" FLOAT,
"africa_students_from_eswatini_both_sexes_number" FLOAT,
"africa_students_from_ethiopia_both_sexes_number" FLOAT,
"africa_students_from_gabon_both_sexes_number" FLOAT,
"africa_students_from_ghana_both_sexes_number" FLOAT,
"africa_students_from_guinea_both_sexes_number" FLOAT,
"africa_students_from_guinea_bissau_both_sexes_number" FLOAT,
"africa_students_from_kenya_both_sexes_number" FLOAT,
"africa_students_from_lesotho_both_sexes_number" FLOAT,
"africa_students_from_liberia_both_sexes_number" FLOAT,
"africa_students_from_libya_both_sexes_number" FLOAT,
"africa_students_from_madagascar_both_sexes_number" FLOAT,
"africa_students_from_malawi_both_sexes_number" FLOAT,
"africa_students_from_mali_both_sexes_number" FLOAT,
"africa_students_from_mauritania_both_sexes_number" FLOAT,
"africa_students_from_mauritius_both_sexes_number" FLOAT,
"africa_students_from_morocco_both_sexes_number" FLOAT,
"africa_students_from_mozambique_both_sexes_number" FLOAT,
"africa_students_from_namibia_both_sexes_number" FLOAT,
"africa_students_from_niger_both_sexes_number" FLOAT,
"africa_students_from_nigeria_both_sexes_number" FLOAT,
"africa_students_from_rwanda_both_sexes_number" FLOAT,
"africa_students_from_sao_tome_and_principe_both_sexes_number" FLOAT,
"africa_students_from_senegal_both_sexes_number" FLOAT,
"africa_students_from_seychelles_both_sexes_number" FLOAT,
"africa_students_from_sierra_leone_both_sexes_number" FLOAT,
"africa_students_from_somalia_both_sexes_number" FLOAT,
"africa_students_from_south_africa_both_sexes_number" FLOAT,
"africa_students_from_south_sudan_both_sexes_number" FLOAT,
"africa_students_from_sudan_pre_secession_both_sexes_number" FLOAT,
"africa_students_from_sudan_both_sexes_number" FLOAT,
"africa_students_from_togo_both_sexes_number" FLOAT,
"africa_students_from_tunisia_both_sexes_number" FLOAT,
"africa_students_from_uganda_both_sexes_number" FLOAT,
"africa_students_from_zambia_both_sexes_number" FLOAT,
"africa_students_from_zimbabwe_both_sexes_number" FLOAT,
"africa_students_from_the_central_african_republic_both_a61391fc" FLOAT,
"africa_students_from_the_congo_both_sexes_number" FLOAT,
"africa_students_from_the_democratic_republic_of_the_co_b5a0ca92" FLOAT,
"africa_students_from_the_gambia_both_sexes_number" FLOAT,
"africa_students_from_the_united_republic_of_tanzania_b_f2bb1302" FLOAT,
"africa_students_from_unknown_countries_both_sexes_number" FLOAT,
"all_staff_compensation_as_a_percentage_of_total_expend_48dd5dc1" FLOAT,
"all_staff_compensation_as_a_percentage_of_total_expend_64296cbb" FLOAT,
"all_staff_compensation_as_a_percentage_of_total_expend_2a5b99c6" FLOAT,
"all_staff_compensation_as_a_percentage_of_total_expend_9ce088ff" FLOAT,
"all_staff_compensation_as_a_percentage_of_total_expend_f41b6f27" FLOAT,
"all_staff_compensation_as_a_percentage_of_total_expend_d3979df8" FLOAT,
"all_staff_compensation_as_a_percentage_of_total_expend_42632ef8" FLOAT,
"all_staff_compensation_as_a_percentage_of_total_expend_83a7ecfc" FLOAT,
"asia_students_from_afghanistan_both_sexes_number" FLOAT,
"asia_students_from_armenia_both_sexes_number" FLOAT,
"asia_students_from_azerbaijan_both_sexes_number" FLOAT,
"asia_students_from_bahrain_both_sexes_number" FLOAT,
"asia_students_from_bangladesh_both_sexes_number" FLOAT,
"asia_students_from_bhutan_both_sexes_number" FLOAT,
"asia_students_from_brunei_darussalam_both_sexes_number" FLOAT,
"asia_students_from_cambodia_both_sexes_number" FLOAT,
"asia_students_from_china_both_sexes_number" FLOAT,
"asia_students_from_cyprus_both_sexes_number" FLOAT,
"asia_students_from_georgia_both_sexes_number" FLOAT,
"asia_students_from_hong_kong_special_administrative_re_fb7714e0" FLOAT,
"asia_students_from_india_both_sexes_number" FLOAT,
"asia_students_from_indonesia_both_sexes_number" FLOAT,
"asia_students_from_iraq_both_sexes_number" FLOAT,
"asia_students_from_israel_both_sexes_number" FLOAT,
"asia_students_from_japan_both_sexes_number" FLOAT,
"asia_students_from_jordan_both_sexes_number" FLOAT,
"asia_students_from_kazakhstan_both_sexes_number" FLOAT,
"asia_students_from_kuwait_both_sexes_number" FLOAT,
"asia_students_from_kyrgyzstan_both_sexes_number" FLOAT,
"asia_students_from_lao_peoples_democratic_republic_bot_01f31e72" FLOAT
);
CREATE TABLE owid_education_opri_2 (
"country" VARCHAR,
"year" INTEGER,
"adult_illiterate_population_15plus_years_pct_female" FLOAT,
"adult_illiterate_population_15plus_years_both_sexes_number" UINTEGER,
"adult_illiterate_population_15plus_years_female_number" UINTEGER,
"adult_illiterate_population_15plus_years_male_number" UINTEGER,
"adult_illiterate_population_15plus_years_rural_pct_female" INTEGER,
"adult_illiterate_population_15plus_years_rural_both_se_015bf327" UINTEGER,
"adult_illiterate_population_15plus_years_rural_female_number" UINTEGER,
"adult_illiterate_population_15plus_years_rural_male_number" UINTEGER,
"adult_illiterate_population_15plus_years_urban_pct_female" INTEGER,
"adult_illiterate_population_15plus_years_urban_both_se_84de2cf4" UINTEGER,
"adult_illiterate_population_15plus_years_urban_female_number" UINTEGER,
"adult_illiterate_population_15plus_years_urban_male_number" UINTEGER,
"africa_students_from_algeria_both_sexes_number" FLOAT,
"africa_students_from_algeria_female_number" FLOAT,
"africa_students_from_algeria_male_number" FLOAT,
"africa_students_from_angola_both_sexes_number" FLOAT,
"africa_students_from_angola_female_number" FLOAT,
"africa_students_from_angola_male_number" FLOAT,
"africa_students_from_benin_both_sexes_number" FLOAT,
"africa_students_from_benin_female_number" FLOAT,
"africa_students_from_benin_male_number" FLOAT,
"africa_students_from_botswana_both_sexes_number" FLOAT,
"africa_students_from_botswana_female_number" FLOAT,
"africa_students_from_botswana_male_number" FLOAT,
"africa_students_from_burkina_faso_both_sexes_number" FLOAT,
"africa_students_from_burkina_faso_female_number" FLOAT,
"africa_students_from_burkina_faso_male_number" FLOAT,
"africa_students_from_burundi_both_sexes_number" FLOAT,
"africa_students_from_burundi_female_number" FLOAT,
"africa_students_from_burundi_male_number" FLOAT,
"africa_students_from_cameroon_both_sexes_number" FLOAT,
"africa_students_from_cameroon_female_number" FLOAT,
"africa_students_from_cameroon_male_number" FLOAT,
"africa_students_from_cape_verde_both_sexes_number" FLOAT,
"africa_students_from_cape_verde_female_number" FLOAT,
"africa_students_from_cape_verde_male_number" FLOAT,
"africa_students_from_chad_both_sexes_number" FLOAT,
"africa_students_from_chad_female_number" FLOAT,
"africa_students_from_chad_male_number" FLOAT,
"africa_students_from_comoros_both_sexes_number" FLOAT,
"africa_students_from_comoros_female_number" FLOAT,
"africa_students_from_comoros_male_number" FLOAT,
"africa_students_from_cote_divoire_both_sexes_number" FLOAT,
"africa_students_from_cote_divoire_female_number" FLOAT,
"africa_students_from_cote_divoire_male_number" FLOAT,
"africa_students_from_djibouti_both_sexes_number" FLOAT,
"africa_students_from_djibouti_female_number" FLOAT,
"africa_students_from_djibouti_male_number" FLOAT,
"africa_students_from_egypt_both_sexes_number" FLOAT,
"africa_students_from_egypt_female_number" FLOAT,
"africa_students_from_egypt_male_number" FLOAT,
"africa_students_from_equatorial_guinea_both_sexes_number" FLOAT,
"africa_students_from_equatorial_guinea_female_number" FLOAT,
"africa_students_from_equatorial_guinea_male_number" FLOAT,
"africa_students_from_eritrea_both_sexes_number" FLOAT,
"africa_students_from_eritrea_female_number" FLOAT,
"africa_students_from_eritrea_male_number" FLOAT,
"africa_students_from_eswatini_both_sexes_number" FLOAT,
"africa_students_from_eswatini_female_number" FLOAT,
"africa_students_from_eswatini_male_number" FLOAT,
"africa_students_from_ethiopia_both_sexes_number" FLOAT,
"africa_students_from_ethiopia_female_number" FLOAT,
"africa_students_from_ethiopia_male_number" FLOAT,
"africa_students_from_gabon_both_sexes_number" FLOAT,
"africa_students_from_gabon_female_number" FLOAT,
"africa_students_from_gabon_male_number" FLOAT,
"africa_students_from_ghana_both_sexes_number" FLOAT,
"africa_students_from_ghana_female_number" FLOAT,
"africa_students_from_ghana_male_number" FLOAT,
"africa_students_from_guinea_both_sexes_number" FLOAT,
"africa_students_from_guinea_female_number" FLOAT,
"africa_students_from_guinea_male_number" FLOAT,
"africa_students_from_guinea_bissau_both_sexes_number" FLOAT,
"africa_students_from_guinea_bissau_female_number" FLOAT,
"africa_students_from_guinea_bissau_male_number" FLOAT,
"africa_students_from_kenya_both_sexes_number" FLOAT,
"africa_students_from_kenya_female_number" FLOAT,
"africa_students_from_kenya_male_number" FLOAT,
"africa_students_from_lesotho_both_sexes_number" FLOAT,
"africa_students_from_lesotho_female_number" FLOAT,
"africa_students_from_lesotho_male_number" FLOAT,
"africa_students_from_liberia_both_sexes_number" FLOAT,
"africa_students_from_liberia_female_number" FLOAT,
"africa_students_from_liberia_male_number" FLOAT,
"africa_students_from_libya_both_sexes_number" FLOAT,
"africa_students_from_libya_female_number" FLOAT,
"africa_students_from_libya_male_number" FLOAT,
"africa_students_from_madagascar_both_sexes_number" FLOAT,
"africa_students_from_madagascar_female_number" FLOAT,
"africa_students_from_madagascar_male_number" FLOAT,
"africa_students_from_malawi_both_sexes_number" FLOAT,
"africa_students_from_malawi_female_number" FLOAT,
"africa_students_from_malawi_male_number" FLOAT,
"africa_students_from_mali_both_sexes_number" FLOAT,
"africa_students_from_mali_female_number" FLOAT,
"africa_students_from_mali_male_number" FLOAT,
"africa_students_from_mauritania_both_sexes_number" FLOAT,
"africa_students_from_mauritania_female_number" FLOAT
);
Anyone who has the link will be able to view this.