Education And COVID-19

Enrollment Data from UIS as of July 30th 2020

@kaggle.landlord_education_and_covid19

Table List

1 table(28.33 KB)

Education Covid19

@kaggle.landlord_education_and_covid19.education_covid19

28.33 KB
200 rows
18 columns

country_code Country Code	country_name Country Name	dt_extraction Dt Extraction	if_closed_due_to_covid19_when If Closed Due To COVID19 When	income_level Income Level	region_name Region Name	school_status School Status	year_pre Year Pre	year_prm Year Prm	year_sec Year Sec	year_ter Year Ter	latitude_generated Latitude (generated)	longitude_generated Longitude (generated)	enrollment Enrollment	se_pre_enrl Se Pre Enrl	se_prm_enrl Se Prm Enrl	se_sec_enrl Se Sec Enrl	se_ter_enrl Se Ter Enrl
ERI	Eritrea	30-07-2020 17:40	nan	Low income	Sub-Saharan Africa	Closed	2018	2018	2018	2016	15.982	38.02	667452	47047	349753	260421	10231
GNB	Guinea-Bissau	30-07-2020 17:40	nan	Low income	Sub-Saharan Africa	Closed	2010	2010	2006	2006	12.191	-14.475	346705	8950	278890	55176	3689
SMR	San Marino	30-07-2020 17:40	01-Mar	High income	Europe and Central Asia	Closed	2018	2018	2018	2018	43.942	12.4611	4999	909	1698	1653	739
GEO	Georgia	30-07-2020 17:40	03-Mar	Upper middle income	Europe and Central Asia	Closed	2008	2018	2018	2019	42.05	43.576	815661	78642	305368	280425	151226
ITA	Italy	30-07-2020 17:40	03-Mar	High income	Europe and Central Asia	Closed	2017	2017	2017	2017	44.3713	11.1084	10876792	1535493	2902379	4601869	1837051
MNG	Mongolia	30-07-2020 17:40	01-Jan-20	Lower middle income	East Asia and Pacific	Closed	2018	2018	2010	2018	46.516	102.564	999014	256720	311063	275983	155248
YEM	Yemen, Rep.	30-07-2020 17:40	01-Mar-20	Low income	Middle East and North Africa	Closed	2016	2016	2016	2011	15.569	47.793	6119823	36320	3900134	1915871	267498
PSE	West Bank and Gaza	30-07-2020 17:40	05-Mar-20	Lower middle income	Middle East and North Africa	Closed	2018	2018	2018	2018	32.097	35.26	1626357	150851	488184	764986	222336
BTN	Bhutan	30-07-2020 17:40	09-Mar-20	Lower middle income	South Asia	Closed	2018	2018	2018	2018	27.5342	90.3002	188432	8499	91768	76221	11944
SAU	Saudi Arabia	30-07-2020 17:40	09-Mar-20	High income	Middle East and North Africa	Closed	2018	2018	2018	2018	24.191	44.32	8410264	382601	3298788	3108384	1620491


CREATE TABLE education_covid19 (
  "country_code" VARCHAR,
  "country_name" VARCHAR,
  "dt_extraction" VARCHAR,
  "if_closed_due_to_covid19_when" VARCHAR,
  "income_level" VARCHAR,
  "region_name" VARCHAR,
  "school_status" VARCHAR,
  "year_pre" DOUBLE,
  "year_prm" DOUBLE,
  "year_sec" DOUBLE,
  "year_ter" DOUBLE,
  "latitude_generated" DOUBLE,
  "longitude_generated" DOUBLE,
  "enrollment" DOUBLE,
  "se_pre_enrl" DOUBLE,
  "se_prm_enrl" DOUBLE,
  "se_sec_enrl" DOUBLE,
  "se_ter_enrl" DOUBLE
);