US Schools Dataset

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

@kaggle.andrewmvd_us_schools_dataset

Table List

2 tables(17.68 MB)

Private Schools

@kaggle.andrewmvd_us_schools_dataset.private_schools

3.8 MB
31064 rows
33 columns

x X	y Y	fid FID	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	start_grad START GRAD	end_grade END GRADE	ft_teacher FT TEACHER	shelter_id SHELTER ID
-8136078.0189	5055505.9896	1	1201	A0507274	A CHILD'S GARDEN	20 IVY BROOK RD	SHELTON	CT	6484	6418	NOT AVAILABLE	7	1	8	FAIRFIELD	9001	USA	41.291989997	-73.087632372	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0507274	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY	Thu Feb 25 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0507274	1	6	2	3	2	NOT AVAILABLE
-8147299.6039	5037066.9873	2	1202	A0500844	BRIDGEPORT INTERNATIONAL ACADEMY	285 LAFAYETTE ST STE 200	BRIDGEPORT	CT	6604	5755	NOT AVAILABLE	3	1	68	FAIRFIELD	9001	USA	41.16741635	-73.188437585	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0500844	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Tue Feb 23 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0500844	2	60	14	17	8	NOT AVAILABLE
-8197042.168	5018050.0417	3	1203	A0108054	CARMEL ACADMEY	270 LAKE AVE	GREENWICH	CT	6830	4518	NOT AVAILABLE	3	1	278	FAIRFIELD	9001	USA	41.038689564	-73.635282641	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0108054	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY	Fri Mar 05 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0108054	1	225	3	13	53	NOT AVAILABLE
-8171503.8456	5077290.6691	4	1204	A0507283	COUNTRY KIDS CLUB	94 OLD STATE RD	BROOKFIELD	CT	6804	2524	NOT AVAILABLE	7	1	11	FAIRFIELD	9001	USA	41.438861027	-73.405867987	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0507283	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	GEOCODE	Thu Feb 25 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0507283	1	10	2	3	1	NOT AVAILABLE
-8197595.5419	5017131.4369	5	1205	01612613	EAGLE HILL SCHOOL	45 GLENVILLE RD	GREENWICH	CT	6831	NOT AVAILABLE	NOT AVAILABLE	4	1	318	FAIRFIELD	9001	USA	41.032465088	-73.640253683	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=01612613	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY/OTHER	Fri Feb 26 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=01612613	3	253	4	15	65	NOT AVAILABLE
-8159167.1067	5049491.2825	6	1206	A0101544	EASTON COUNTRY DAY SCHOOL	660 MOREHOUSE RD	EASTON	CT	6612	1338	NOT AVAILABLE	1	1	183	FAIRFIELD	9001	USA	41.251380804	-73.295045176	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0101544	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY	Thu Mar 04 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0101544	3	155	2	17	28	NOT AVAILABLE
-8148757.8142	5044575.2854	7	1207	A0300688	FAIRFIELD COUNTY SDA SCHOOL	827 TRUMBULL AVE	BRIDGEPORT	CT	6606	2438	NOT AVAILABLE	1	1	44	FAIRFIELD	9001	USA	41.218170957	-73.201536911	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0300688	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY	Fri Feb 26 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0300688	1	41	3	13	3	NOT AVAILABLE
-8157597.6808	5068701.6672	8	1208	AA001061	FRASER WOODS MONTESSORI SCHOOL	173 S MAIN ST	NEWTOWN	CT	6470	2792	NOT AVAILABLE	2	1	176	FAIRFIELD	9001	USA	41.380994068	-73.280946784	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=AA001061	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY	Thu Mar 04 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=AA001061	1	161	2	13	15	NOT AVAILABLE
-8158145.9372	5034308.7064	9	1209	A0101480	GIANT STEPS CONNECTICUT	309 BARBERRY RD	SOUTHPORT	CT	6890	3034	NOT AVAILABLE	4	1	45	FAIRFIELD	9001	USA	41.148761036	-73.285871855	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0101480	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY	Fri Feb 26 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0101480	3	37	3	17	8	NOT AVAILABLE
-8165875.6107	5068435.6103	10	1210	A9700803	HOUSATONIC VALLEY WALDORF SCHOOL	52 DODGINGTOWN ROAD	NEWTOWN	CT	6470	1861	NOT AVAILABLE	3	1	135	FAIRFIELD	9001	USA	41.379200731	-73.355308693	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A9700803	Fri Jan 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	IMAGERY	Mon Mar 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A9700803	1	120	2	13	15	NOT AVAILABLE


CREATE TABLE private_schools (
  "x" DOUBLE,
  "y" DOUBLE,
  "fid" BIGINT,
  "objectid" BIGINT,
  "ncesid" VARCHAR,
  "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" BIGINT,
  "enrollment" BIGINT,
  "start_grad" BIGINT,
  "end_grade" BIGINT,
  "ft_teacher" BIGINT,
  "shelter_id" VARCHAR
);