Dataset Overview 📝

The dataset includes the following key indicators, collected for over 200 countries:

• Government Expenditure on Education (% of GDP): Shows the percentage of a country’s GDP allocated to education.
• Literacy Rate (Adult Total): Represents the percentage of the population aged 15 and above who can read and write.
• Primary Completion Rate: The percentage of children who complete their primary education within the official age group.
• Pupil-Teacher Ratio (Primary and Secondary Education): Indicates the average number of students per teacher at the primary and secondary levels.
• School Enrollment Rates (Primary, Secondary, Tertiary): Reflects the percentage of the relevant age group enrolled in schools across different education levels.

Data Source 🌐

World Bank: This dataset is compiled from the World Bank's educational database, providing reliable, updated statistics on educational progress worldwide.

Potential Use Cases 🔍 This dataset is ideal for anyone interested in:

Educational Research: Understanding how education spending and policies impact literacy, enrollment, and overall educational outcomes. Predictive Modeling: Building models to predict educational success factors, such as completion rates and literacy. Global Education Analysis: Analyzing trends in global education systems and how different countries allocate resources to education. Policy Development: Helping governments and organizations make data-driven decisions regarding educational reforms and funding.

Key Questions You Can Explore 🤔

How does government expenditure on education correlate with literacy rates and school enrollment across different regions? What are the trends in pupil-teacher ratios over time, and how do they affect educational outcomes? How do education indicators differ between low-income and high-income countries? Can we predict which countries will achieve universal primary education based on current trends?

Important Notes ⚠️ - Missing Data: Some values may be missing for certain years or countries. Consider using techniques like forward filling or interpolation when working with time series models. - Data Limitations: This dataset provides global averages and may not capture regional disparities within countries.

The World Bank EdStats All Indicator Query holds over 4,000 internationally comparable indicators that describe education access, progression, completion, literacy, teachers, population, and expenditures. The indicators cover the education cycle from pre-primary to vocational and tertiary education. The query also holds learning outcome data from international and regional learning assessments (e.g. PISA, TIMSS, PIRLS), equity data from household surveys, and projection/attainment data to 2050. For further information, please visit the EdStats website.

For further details, please refer to https://datatopics.worldbank.org/education/wRsc/about

Context

The World Bank is an international financial institution that provides loans to countries of the world for capital projects. The World Bank's stated goal is the reduction of poverty. Source: https://en.wikipedia.org/wiki/World_Bank

Content

This dataset combines key education statistics from a variety of sources to provide a look at global literacy, spending, and access.

For more information, see the World Bank website.

Fork this kernel to get started with this dataset.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:world_bank_health_population

http://data.worldbank.org/data-catalog/ed-stats

https://cloud.google.com/bigquery/public-data/world-bank-education

Citation: The World Bank: Education Statistics

Dataset Source: World Bank. This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by @till_indeman from Unplash.

Inspiration

Of total government spending, what percentage is spent on education?

This meticulously curated dataset offers a panoramic view of education on a global scale , delivering profound insights into the dynamic landscape of education across diverse countries and regions. Spanning a rich tapestry of educational aspects, it encapsulates crucial metrics including out-of-school rates, completion rates, proficiency levels, literacy rates, birth rates, and primary and tertiary education enrollment statistics. A treasure trove of knowledge, this dataset is an indispensable asset for discerning researchers, dedicated educators, and forward-thinking policymakers, enabling them to embark on a transformative journey of assessing, enhancing, and reshaping education systems worldwide.

Key Features: - Countries and Areas: Name of the countries and areas. - Latitude: Latitude coordinates of the geographical location. - Longitude: Longitude coordinates of the geographical location. - OOSR_Pre0Primary_Age_Male: Out-of-school rate for pre-primary age males. - OOSR_Pre0Primary_Age_Female: Out-of-school rate for pre-primary age females. - OOSR_Primary_Age_Male: Out-of-school rate for primary age males. - OOSR_Primary_Age_Female: Out-of-school rate for primary age females. - OOSR_Lower_Secondary_Age_Male: Out-of-school rate for lower secondary age males. - OOSR_Lower_Secondary_Age_Female: Out-of-school rate for lower secondary age females. - OOSR_Upper_Secondary_Age_Male: Out-of-school rate for upper secondary age males. - OOSR_Upper_Secondary_Age_Female: Out-of-school rate for upper secondary age females. - Completion_Rate_Primary_Male: Completion rate for primary education among males. - Completion_Rate_Primary_Female: Completion rate for primary education among females. - Completion_Rate_Lower_Secondary_Male: Completion rate for lower secondary education among males. - Completion_Rate_Lower_Secondary_Female: Completion rate for lower secondary education among females. - Completion_Rate_Upper_Secondary_Male: Completion rate for upper secondary education among males. - Completion_Rate_Upper_Secondary_Female: Completion rate for upper secondary education among females. - Grade_2_3_Proficiency_Reading: Proficiency in reading for grade 2-3 students. - Grade_2_3_Proficiency_Math: Proficiency in math for grade 2-3 students. - Primary_End_Proficiency_Reading: Proficiency in reading at the end of primary education. - Primary_End_Proficiency_Math: Proficiency in math at the end of primary education. - Lower_Secondary_End_Proficiency_Reading: Proficiency in reading at the end of lower secondary education. - Lower_Secondary_End_Proficiency_Math: Proficiency in math at the end of lower secondary education. - Youth_15_24_Literacy_Rate_Male: Literacy rate among male youths aged 15-24. - Youth_15_24_Literacy_Rate_Female: Literacy rate among female youths aged 15-24. - Birth_Rate: Birth rate in the respective countries/areas. - Gross_Primary_Education_Enrollment: Gross enrollment in primary education. - Gross_Tertiary_Education_Enrollment: Gross enrollment in tertiary education. - Unemployment_Rate: Unemployment rate in the respective countries/areas.

CL: Educational Attainment: At Least Master's or Equivalent: Population 25+ Years: Female: % Cumulative data was reported at 2.926 % in 2023. This records an increase from the previous number of 2.822 % for 2022. CL: Educational Attainment: At Least Master's or Equivalent: Population 25+ Years: Female: % Cumulative data is updated yearly, averaging 1.246 % from Dec 2010 (Median) to 2023, with 14 observations. The data reached an all-time high of 2.926 % in 2023 and a record low of 0.370 % in 2011. CL: Educational Attainment: At Least Master's or Equivalent: Population 25+ Years: Female: % Cumulative data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Chile – Table CL.World Bank.WDI: Social: Education Statistics. The percentage of population ages 25 and over that attained or completed Master's or equivalent.;UNESCO Institute for Statistics (UIS). UIS.Stat Bulk Data Download Service. Accessed April 5, 2025. https://apiportal.uis.unesco.org/bdds.;;

The UNESCO Institute for Statistics (UIS) is the official and trusted source of internationally comparable data on education, science, culture and communication. As the official statistical agency of UNESCO, and the custodian agency for Sustainable Development Goal 4 on Education (SDG 4), the UIS produces a wide range of data to inform the policies and investments needed to transform lives and propel the world towards its development goals.

This collection includes only a subset of indicators from the source dataset.

US: Children Out of School: Primary: Female data was reported at 437,901.000 Person in 1996. This records an increase from the previous number of 321,013.000 Person for 1995. US: Children Out of School: Primary: Female data is updated yearly, averaging 373,553.500 Person from Dec 1986 (Median) to 1996, with 8 observations. The data reached an all-time high of 561,183.000 Person in 1986 and a record low of 106,133.000 Person in 1990. US: Children Out of School: Primary: Female data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s USA – Table US.World Bank: Education Statistics. Children out of school are the number of primary-school-age children not enrolled in primary or secondary school.; ; UNESCO Institute for Statistics; Sum; Each economy is classified based on the classification of World Bank Group's fiscal year 2018 (July 1, 2017-June 30, 2018).

PL: Educational Attainment: At Least Competed Short-Cycle Tertiary: Population 25+ Years: Total: % Cumulative data was reported at 23.885 % in 2014. This records an increase from the previous number of 22.799 % for 2013. PL: Educational Attainment: At Least Competed Short-Cycle Tertiary: Population 25+ Years: Total: % Cumulative data is updated yearly, averaging 20.720 % from Dec 2002 (Median) to 2014, with 8 observations. The data reached an all-time high of 23.885 % in 2014 and a record low of 12.374 % in 2002. PL: Educational Attainment: At Least Competed Short-Cycle Tertiary: Population 25+ Years: Total: % Cumulative data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Poland – Table PL.World Bank: Education Statistics. The percentage of population ages 25 and over that attained or completed short-cycle tertiary education.; ; UNESCO Institute for Statistics; ;

CL: Current Education Expenditure: Total: % of Total Expenditure in Public Institutions data was reported at 94.539 % in 2021. This records a decrease from the previous number of 94.907 % for 2020. CL: Current Education Expenditure: Total: % of Total Expenditure in Public Institutions data is updated yearly, averaging 94.539 % from Dec 1999 (Median) to 2021, with 15 observations. The data reached an all-time high of 97.229 % in 2008 and a record low of 85.272 % in 2004. CL: Current Education Expenditure: Total: % of Total Expenditure in Public Institutions data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Chile – Table CL.World Bank.WDI: Social: Education Statistics. Current expenditure is expressed as a percentage of direct expenditure in public educational institutions (instructional and non-instructional) of the specified level of education. Financial aid to students and other transfers are excluded from direct expenditure. Current expenditure is consumed within the current year and would have to be renewed if needed in the following year. It includes staff compensation and current expenditure other than for staff compensation (ex. on teaching materials, ancillary services and administration).;UNESCO Institute for Statistics (UIS). UIS.Stat Bulk Data Download Service. Accessed April 5, 2025. https://apiportal.uis.unesco.org/bdds.;Median;

CL: Children Out of School: % of Primary School Age data was reported at 1.293 % in 2022. This records a decrease from the previous number of 2.167 % for 2021. CL: Children Out of School: % of Primary School Age data is updated yearly, averaging 2.841 % from Dec 2007 (Median) to 2022, with 16 observations. The data reached an all-time high of 4.814 % in 2009 and a record low of 1.293 % in 2022. CL: Children Out of School: % of Primary School Age data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Chile – Table CL.World Bank.WDI: Social: Education Statistics. Children out of school are the percentage of primary-school-age children who are not enrolled in primary or secondary school. Children in the official primary age group that are in preprimary education should be considered out of school.;UNESCO Institute for Statistics (UIS). UIS.Stat Bulk Data Download Service. Accessed April 5, 2025. https://apiportal.uis.unesco.org/bdds.;Weighted average;

CL: Repeaters: Primary: % of Total Enrollment data was reported at 3.014 % in 2017. This records a decrease from the previous number of 3.346 % for 2016. CL: Repeaters: Primary: % of Total Enrollment data is updated yearly, averaging 8.034 % from Dec 1970 (Median) to 2017, with 17 observations. The data reached an all-time high of 13.764 % in 1977 and a record low of 3.014 % in 2017. CL: Repeaters: Primary: % of Total Enrollment data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Chile – Table CL.World Bank.WDI: Social: Education Statistics. Repeaters in primary school are the number of students enrolled in the same grade as in the previous year, as a percentage of all students enrolled in primary school.;UNESCO Institute for Statistics (http://uis.unesco.org/). Data as of February 2020.;Weighted average;

AM: Educational Attainment: At Least Completed Post-Secondary: Population 25+ Years: Total: % Cumulative data was reported at 53.163 % in 2022. This records a decrease from the previous number of 54.253 % for 2021. AM: Educational Attainment: At Least Completed Post-Secondary: Population 25+ Years: Total: % Cumulative data is updated yearly, averaging 48.336 % from Dec 2001 (Median) to 2022, with 12 observations. The data reached an all-time high of 54.253 % in 2021 and a record low of 42.110 % in 2001. AM: Educational Attainment: At Least Completed Post-Secondary: Population 25+ Years: Total: % Cumulative data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Armenia – Table AM.World Bank.WDI: Social: Education Statistics. The percentage of population ages 25 and over that attained or completed post-secondary non-tertiary education.;UNESCO Institute for Statistics (UIS). UIS.Stat Bulk Data Download Service. Accessed April 5, 2025. https://apiportal.uis.unesco.org/bdds.;;

United States US: Primary Education: Pupils data was reported at 24,785,697.041 Person in 2015. This records an increase from the previous number of 24,538,371.000 Person for 2014. United States US: Primary Education: Pupils data is updated yearly, averaging 23,212,276.000 Person from Dec 1971 (Median) to 2015, with 41 observations. The data reached an all-time high of 25,297,600.000 Person in 2001 and a record low of 19,169,000.000 Person in 1979. United States US: Primary Education: Pupils data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s USA – Table US.World Bank: Education Statistics. Primary education pupils is the total number of pupils enrolled at primary level in public and private schools.; ; UNESCO Institute for Statistics; Sum; Each economy is classified based on the classification of World Bank Group's fiscal year 2018 (July 1, 2017-June 30, 2018).

CO: Educational Attainment, At Least Completed Upper Secondary: Population 25+ Years: Total: % Cumulative data was reported at 57.024 % in 2023. This records an increase from the previous number of 56.080 % for 2022. CO: Educational Attainment, At Least Completed Upper Secondary: Population 25+ Years: Total: % Cumulative data is updated yearly, averaging 41.010 % from Dec 1993 (Median) to 2023, with 23 observations. The data reached an all-time high of 57.024 % in 2023 and a record low of 27.680 % in 1993. CO: Educational Attainment, At Least Completed Upper Secondary: Population 25+ Years: Total: % Cumulative data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Colombia – Table CO.World Bank.WDI: Social: Education Statistics. The percentage of population ages 25 and over that attained or completed upper secondary education.;UNESCO Institute for Statistics (UIS). UIS.Stat Bulk Data Download Service. Accessed April 5, 2025. https://apiportal.uis.unesco.org/bdds.;;

CL: School Enrollment: Preprimary: % Gross data was reported at 84.511 % in 2020. This records a decrease from the previous number of 84.802 % for 2019. CL: School Enrollment: Preprimary: % Gross data is updated yearly, averaging 80.842 % from Dec 1970 (Median) to 2020, with 47 observations. The data reached an all-time high of 114.302 % in 2012 and a record low of 23.290 % in 1970. CL: School Enrollment: Preprimary: % Gross data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Chile – Table CL.World Bank.WDI: Social: Education Statistics. Gross enrollment ratio is the ratio of total enrollment, regardless of age, to the population of the age group that officially corresponds to the level of education shown. Preprimary education refers to programs at the initial stage of organized instruction, designed primarily to introduce very young children to a school-type environment and to provide a bridge between home and school.;UNESCO Institute for Statistics (UIS). UIS.Stat Bulk Data Download Service. Accessed October 24, 2022. https://apiportal.uis.unesco.org/bdds.;Weighted average;

AM: Educational Attainment: At Least Bachelor's or Equivalent: Population 25+ Years: Female: % Cumulative data was reported at 28.606 % in 2022. This records a decrease from the previous number of 29.258 % for 2021. AM: Educational Attainment: At Least Bachelor's or Equivalent: Population 25+ Years: Female: % Cumulative data is updated yearly, averaging 24.150 % from Dec 2001 (Median) to 2022, with 14 observations. The data reached an all-time high of 29.258 % in 2021 and a record low of 19.500 % in 2001. AM: Educational Attainment: At Least Bachelor's or Equivalent: Population 25+ Years: Female: % Cumulative data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Armenia – Table AM.World Bank.WDI: Social: Education Statistics. The percentage of population ages 25 and over that attained or completed Bachelor's or equivalent.;UNESCO Institute for Statistics (UIS). UIS.Stat Bulk Data Download Service. Accessed April 5, 2025. https://apiportal.uis.unesco.org/bdds.;;

AZ: Educational Attainment: At Least Competed Short-Cycle Tertiary: Population 25+ Years: Female: % Cumulative data was reported at 27.100 % in 2023. This records a decrease from the previous number of 27.395 % for 2022. AZ: Educational Attainment: At Least Competed Short-Cycle Tertiary: Population 25+ Years: Female: % Cumulative data is updated yearly, averaging 23.555 % from Dec 2007 (Median) to 2023, with 16 observations. The data reached an all-time high of 27.395 % in 2022 and a record low of 22.800 % in 2007. AZ: Educational Attainment: At Least Competed Short-Cycle Tertiary: Population 25+ Years: Female: % Cumulative data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Azerbaijan – Table AZ.World Bank.WDI: Social: Education Statistics. The percentage of population ages 25 and over that attained or completed short-cycle tertiary education.;UNESCO Institute for Statistics (UIS). UIS.Stat Bulk Data Download Service. Accessed April 5, 2025. https://apiportal.uis.unesco.org/bdds.;;

CU: School Enrollment: Preprimary: Male: % Gross data was reported at 100.017 % in 2021. This records an increase from the previous number of 96.896 % for 2020. CU: School Enrollment: Preprimary: Male: % Gross data is updated yearly, averaging 97.937 % from Dec 1971 (Median) to 2021, with 50 observations. The data reached an all-time high of 111.041 % in 1991 and a record low of 47.216 % in 1973. CU: School Enrollment: Preprimary: Male: % Gross data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Cuba – Table CU.World Bank.WDI: Social: Education Statistics. Gross enrollment ratio is the ratio of total enrollment, regardless of age, to the population of the age group that officially corresponds to the level of education shown. Preprimary education refers to programs at the initial stage of organized instruction, designed primarily to introduce very young children to a school-type environment and to provide a bridge between home and school.;UNESCO Institute for Statistics (UIS). UIS.Stat Bulk Data Download Service. Accessed October 24, 2022. https://apiportal.uis.unesco.org/bdds.;Weighted average;

CO: School Enrollment: Primary: % Net data was reported at 92.920 % in 2018. This records a decrease from the previous number of 93.135 % for 2017. CO: School Enrollment: Primary: % Net data is updated yearly, averaging 91.811 % from Dec 1982 (Median) to 2018, with 33 observations. The data reached an all-time high of 94.122 % in 2005 and a record low of 68.057 % in 1986. CO: School Enrollment: Primary: % Net data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Colombia – Table CO.World Bank.WDI: Social: Education Statistics. Net enrollment rate is the ratio of children of official school age who are enrolled in school to the population of the corresponding official school age. Primary education provides children with basic reading, writing, and mathematics skills along with an elementary understanding of such subjects as history, geography, natural science, social science, art, and music.;UNESCO Institute for Statistics (http://uis.unesco.org/). Data as of February 2020.;Weighted average;

DZ: Repeaters: Primary: Male: % of Male Enrollment data was reported at 7.175 % in 2018. This records a decrease from the previous number of 7.304 % for 2017. DZ: Repeaters: Primary: Male: % of Male Enrollment data is updated yearly, averaging 11.093 % from Dec 1972 (Median) to 2018, with 46 observations. The data reached an all-time high of 17.172 % in 2000 and a record low of 7.175 % in 2018. DZ: Repeaters: Primary: Male: % of Male Enrollment data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Algeria – Table DZ.World Bank.WDI: Social: Education Statistics. Repeaters in primary school are the number of students enrolled in the same grade as in the previous year, as a percentage of all students enrolled in primary school.;UNESCO Institute for Statistics (http://uis.unesco.org/). Data as of February 2020.;Weighted average;