US Schools Dataset

Data on 130k+ schools in the US with georeferences.

@kaggle.andrewmvd_us_schools_dataset

Table List

2 tables(17.68 MB)

Public Schools

@kaggle.andrewmvd_us_schools_dataset.public_schools

13.88 MB
102334 rows
33 columns

x X	y Y	objectid OBJECTID	ncesid NCESID	name NAME	address ADDRESS	city CITY	state STATE	zip ZIP	zip4 ZIP4	telephone TELEPHONE	type TYPE	status STATUS	population POPULATION	county COUNTY	countyfips COUNTYFIPS	country COUNTRY	latitude LATITUDE	longitude LONGITUDE	naics_code NAICS CODE	naics_desc NAICS DESC	source SOURCE	sourcedate SOURCEDATE	val_method VAL METHOD	val_date VAL DATE	website WEBSITE	level LEVEL	enrollment ENROLLMENT	st_grade ST GRADE	end_grade END GRADE	districtid DISTRICTID	ft_teacher FT TEACHER	shelter_id SHELTER ID
-9844095.0453	5230976.1334	1	170330000017	ALDEN-HEBRON HIGH SCHOOL	9604 ILLINOIS ST	HEBRON	IL	60034	9618	(815) 648-2442	1	1	123	MCHENRY	17111	USA	42.465566095	-88.431010375	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=170330000017	Tue Oct 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Fri Aug 27 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NOT AVAILABLE	HIGH	112	09	12	1703300	11	NOT AVAILABLE
-9007027.1226	4195441.5319	2	370297001287	WESTERLY HILLS ACADEMY	4420 DENVER AVE	CHARLOTTE	NC	28208	3699	(980) 343-6021	1	1	540	MECKLENBURG	37119	USA	35.23190937	-80.911501287	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=370297001287	Thu Dec 10 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Mon Aug 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	http://schools.cms.k12.nc.us/westerlyhillsES	ELEMENTARY	495	KG	08	3702970	45	NOT AVAILABLE
-9580425.8697	4792069.2056	3	180369000584	NORTHWOOD ELEMENTARY SCHOOL	965 GRIZZLY CUB DR	FRANKLIN	IN	46131	1364	(317) 346-8900	1	1	503	JOHNSON	18081	USA	39.489752551	-86.0624298709999	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=180369000584	Tue Oct 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Mon Aug 02 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NOT AVAILABLE	ELEMENTARY	478	PK	04	1803690	25	NOT AVAILABLE
-12432974.0329	3927587.8699	4	40187003479	DR. GARY AND ANNETTE AUXIER ELEMENTARY SCHOOL	22700 S. POWER RD.	QUEEN CREEK	AZ	85298	NOT AVAILABLE	(480) 812-7000	1	1	1009	MARICOPA	4013	USA	33.242888237	-111.687306008	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=040187003479	Tue Oct 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Wed Oct 24 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NOT AVAILABLE	ELEMENTARY	958	PK	06	401870	51	NOT AVAILABLE
-12432580.2285	3924830.5989	5	40187003483	DR. CAMILLE CASTEEL HIGH SCHOOL	24901 S. POWER RD.	QUEEN CREEK	AZ	85142	NOT AVAILABLE	(480) 424-8100	1	1	2409	MARICOPA	4013	USA	33.222170136	-111.683768403	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=040187003483	Tue Oct 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Wed Oct 24 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NOT AVAILABLE	HIGH	2294	07	12	401870	115	NOT AVAILABLE
-12435059.8462	3929308.1221	6	40378003490	BRIDGES ELEMENTARY SCHOOL	5205 S. SOBOBA ST	GILBERT	AZ	85298	NOT AVAILABLE	(480) 279-7000	1	1	743	MARICOPA	4013	USA	33.2558117040001	-111.706043188	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=040378003490	Tue Oct 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Wed Oct 24 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NOT AVAILABLE	ELEMENTARY	708	KG	06	403780	35	NOT AVAILABLE
-12518034.063	3949789.4637	7	40432003480	LAS BRISAS ACADEMY	18211 W LAS BRISAS DRIVE	GOODYEAR	AZ	85338	NOT AVAILABLE	(623) 327-2860	1	1	489	MARICOPA	4013	USA	33.4095317000001	-112.451413259	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=040432003480	Tue Oct 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Wed Oct 24 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NOT AVAILABLE	ELEMENTARY	463	KG	08	404320	26	NOT AVAILABLE
-12407477.2667	4426920.5747	8	40582003492	MANSON MESA HIGH SCHOOL	500 SOUTH NAVAJO	PAGE	AZ	86040	NOT AVAILABLE	(928) 608-4100	1	1	41	COCONINO	4005	USA	36.9125226350001	-111.45826466	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=040582003492	Tue Oct 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Wed Oct 24 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NOT AVAILABLE	HIGH	39	09	12	405820	2	NOT AVAILABLE
-12423216.5734	3938352.1114	9	40681003477	GATEWAY POLYTECHNIC ACADEMY	5149 S. SIGNAL BUTTE RD.	MESA	AZ	85212	NOT AVAILABLE	(480) 987-5935	1	1	936	MARICOPA	4013	USA	33.3237236090001	-111.599653258	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=040681003477	Tue Oct 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Wed Oct 24 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NOT AVAILABLE	ELEMENTARY	888	PK	08	406810	48	NOT AVAILABLE
-13510876.8757	4665941.5775	10	60143213940	PARAMOUNT COLLEGIATE ACADEMY	4010 EL CAMINO AVE.	SACRAMENTO	CA	95821	6602	(916) 484-1480	1	1	77	SACRAMENTO	6067	USA	38.609867949	-121.370271993	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=060143213940	Tue Oct 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Wed Oct 24 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	http://www.pcaeducation.org	HIGH	76	06	12	601432	1	NOT AVAILABLE


CREATE TABLE public_schools (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "ncesid" BIGINT,
  "name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "zip4" VARCHAR,
  "telephone" VARCHAR,
  "type" BIGINT,
  "status" BIGINT,
  "population" BIGINT,
  "county" VARCHAR,
  "countyfips" BIGINT,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "naics_code" BIGINT,
  "naics_desc" VARCHAR,
  "source" VARCHAR,
  "sourcedate" TIMESTAMP,
  "val_method" VARCHAR,
  "val_date" TIMESTAMP,
  "website" VARCHAR,
  "level" VARCHAR,
  "enrollment" BIGINT,
  "st_grade" VARCHAR,
  "end_grade" VARCHAR,
  "districtid" BIGINT,
  "ft_teacher" BIGINT,
  "shelter_id" VARCHAR
);