Global Education Statistics
Over 4000 internationally comparable educational indicators
@kaggle.andrewmvd_global_education_statistics
Over 4000 internationally comparable educational indicators
@kaggle.andrewmvd_global_education_statistics
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 and 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.
If you use this dataset in your research, please credit the authors
Citation
World Bank. (2013). Education statistics. Retrieved June 6, 2020, from http://data.worldbank.org/data-catalog/ed-stats
License
CC BY 4.0
Splash banner
Photo by 🇸🇮 Janko Ferlič on Unsplash
CREATE TABLE edstatscountry (
"country_code" VARCHAR,
"short_name" VARCHAR,
"table_name" VARCHAR,
"long_name" VARCHAR,
"n_2_alpha_code" VARCHAR -- 2-alpha Code,
"currency_unit" VARCHAR,
"special_notes" VARCHAR,
"region" VARCHAR,
"income_group" VARCHAR,
"wb_2_code" VARCHAR,
"national_accounts_base_year" VARCHAR,
"national_accounts_reference_year" DOUBLE,
"sna_price_valuation" VARCHAR,
"lending_category" VARCHAR,
"other_groups" VARCHAR,
"system_of_national_accounts" VARCHAR,
"alternative_conversion_factor" VARCHAR,
"ppp_survey_year" VARCHAR,
"balance_of_payments_manual_in_use" VARCHAR,
"external_debt_reporting_status" VARCHAR,
"system_of_trade" VARCHAR,
"government_accounting_concept" VARCHAR,
"imf_data_dissemination_standard" VARCHAR,
"latest_population_census" VARCHAR,
"latest_household_survey" VARCHAR,
"source_of_most_recent_income_and_expenditure_data" VARCHAR,
"vital_registration_complete" VARCHAR,
"latest_agricultural_census" VARCHAR,
"latest_industrial_data" DOUBLE,
"latest_trade_data" DOUBLE,
"latest_water_withdrawal_data" VARCHAR,
"unnamed_31" VARCHAR -- Unnamed: 31
);CREATE TABLE edstatscountry_series (
"countrycode" VARCHAR,
"seriescode" VARCHAR,
"description" VARCHAR,
"unnamed_3" VARCHAR -- Unnamed: 3
);CREATE TABLE edstatsdata (
"country_name" VARCHAR,
"country_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_code" VARCHAR,
"n_1970" DOUBLE -- 1970,
"n_1971" DOUBLE -- 1971,
"n_1972" DOUBLE -- 1972,
"n_1973" DOUBLE -- 1973,
"n_1974" DOUBLE -- 1974,
"n_1975" DOUBLE -- 1975,
"n_1976" DOUBLE -- 1976,
"n_1977" DOUBLE -- 1977,
"n_1978" DOUBLE -- 1978,
"n_1979" DOUBLE -- 1979,
"n_1980" DOUBLE -- 1980,
"n_1981" DOUBLE -- 1981,
"n_1982" DOUBLE -- 1982,
"n_1983" DOUBLE -- 1983,
"n_1984" DOUBLE -- 1984,
"n_1985" DOUBLE -- 1985,
"n_1986" DOUBLE -- 1986,
"n_1987" DOUBLE -- 1987,
"n_1988" DOUBLE -- 1988,
"n_1989" DOUBLE -- 1989,
"n_1990" DOUBLE -- 1990,
"n_1991" DOUBLE -- 1991,
"n_1992" DOUBLE -- 1992,
"n_1993" DOUBLE -- 1993,
"n_1994" DOUBLE -- 1994,
"n_1995" DOUBLE -- 1995,
"n_1996" DOUBLE -- 1996,
"n_1997" DOUBLE -- 1997,
"n_1998" DOUBLE -- 1998,
"n_1999" DOUBLE -- 1999,
"n_2000" DOUBLE -- 2000,
"n_2001" DOUBLE -- 2001,
"n_2002" DOUBLE -- 2002,
"n_2003" DOUBLE -- 2003,
"n_2004" DOUBLE -- 2004,
"n_2005" DOUBLE -- 2005,
"n_2006" DOUBLE -- 2006,
"n_2007" DOUBLE -- 2007,
"n_2008" DOUBLE -- 2008,
"n_2009" DOUBLE -- 2009,
"n_2010" DOUBLE -- 2010,
"n_2011" DOUBLE -- 2011,
"n_2012" DOUBLE -- 2012,
"n_2013" DOUBLE -- 2013,
"n_2014" DOUBLE -- 2014,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2020" DOUBLE -- 2020,
"n_2025" DOUBLE -- 2025,
"n_2030" DOUBLE -- 2030,
"n_2035" DOUBLE -- 2035,
"n_2040" DOUBLE -- 2040,
"n_2045" DOUBLE -- 2045,
"n_2050" DOUBLE -- 2050,
"n_2055" DOUBLE -- 2055,
"n_2060" DOUBLE -- 2060,
"n_2065" DOUBLE -- 2065,
"n_2070" DOUBLE -- 2070,
"n_2075" DOUBLE -- 2075,
"n_2080" DOUBLE -- 2080,
"n_2085" DOUBLE -- 2085,
"n_2090" DOUBLE -- 2090,
"n_2095" DOUBLE -- 2095,
"n_2100" DOUBLE -- 2100,
"unnamed_69" VARCHAR -- Unnamed: 69
);CREATE TABLE edstatsfootnote (
"countrycode" VARCHAR,
"seriescode" VARCHAR,
"year" VARCHAR,
"description" VARCHAR,
"unnamed_4" VARCHAR -- Unnamed: 4
);CREATE TABLE edstatsseries (
"series_code" VARCHAR,
"topic" VARCHAR,
"indicator_name" VARCHAR,
"short_definition" VARCHAR,
"long_definition" VARCHAR,
"unit_of_measure" VARCHAR,
"periodicity" VARCHAR,
"base_period" VARCHAR,
"other_notes" VARCHAR,
"aggregation_method" VARCHAR,
"limitations_and_exceptions" VARCHAR,
"notes_from_original_source" VARCHAR,
"general_comments" VARCHAR,
"source" VARCHAR,
"statistical_concept_and_methodology" VARCHAR,
"development_relevance" VARCHAR,
"related_source_links" VARCHAR,
"other_web_links" VARCHAR,
"related_indicators" VARCHAR,
"license_type" VARCHAR,
"unnamed_20" VARCHAR -- Unnamed: 20
);Anyone who has the link will be able to view this.