US Private Schools

All private elementary and secondary education facilities in the United States

@kaggle.joebeachcapital_us_private_schools

Table List

1 table(4 MB)

Us Private Schools

@kaggle.joebeachcapital_us_private_schools.us_private_schools

4 MB
22615 rows
33 columns

geo_point Geo Point	geo_shape Geo Shape	objectid OBJECTID	fid_1 FID 1	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
33.71756207000004, -85.81467499799999	{"coordinates": [-85.81467499799999, 33.71756207000004], "type": "Point"}	14	14	00000306	SACRED HEART CATHOLIC SCHOOL	16 MORTON RD	ANNISTON	AL	36205	NOT AVAILABLE	(256) 237-4231	1	1	261	CALHOUN	1015	USA	33.71756207	-85.814674998	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=00000306	2009-12-10T00:00:00Z	IMAGERY/OTHER	2009-12-31T00:00:00Z	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=00000306	3	240	2	17	21	NOT AVAILABLE
33.66722932000005, -86.81679840099997	{"coordinates": [-86.81679840099997, 33.66722932000005], "type": "Point"}	75	75	A9900029	GARDENDALE CHRISTIAN ACADEMY	1800 DECATUR HWY	GARDENDALE	AL	35071	NOT AVAILABLE	(205) 631-9465	1	1	91	JEFFERSON	1073	USA	33.66722932	-86.816798401	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A9900029	2010-09-24T00:00:00Z	IMAGERY	2010-03-26T00:00:00Z	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A9900029	1	78	2	10	13	NOT AVAILABLE
33.44545522300007, -86.79526022499994	{"coordinates": [-86.79526022499994, 33.44545522300007], "type": "Point"}	85	85	K9300016	ASCENSION EPISCOPAL KINDERGARTEN	1912 CANYON RD	VESTAVIA	AL	35216	NOT AVAILABLE	(205) 979-8711	7	1	14	JEFFERSON	1073	USA	33.445455223	-86.795260225	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=K9300016	2010-09-24T00:00:00Z	IMAGERY	2010-03-25T00:00:00Z	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=K9300016	1	11	2	3	3	NOT AVAILABLE
33.35021164700004, -111.86836737599998	{"coordinates": [-111.86836737599998, 33.35021164700004], "type": "Point"}	226	226	A9703834	DESERT SUN CHILD DEVELOPMENT CENTER	1512 W ELLIOT RD	CHANDLER	AZ	85224	NOT AVAILABLE	(480) 831-1718	6	1	23	MARICOPA	4013	USA	33.350211647	-111.868367376	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A9703834	2010-09-24T00:00:00Z	IMAGERY	2010-05-13T00:00:00Z	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A9703834	1	20	2	3	3	NOT AVAILABLE
33.37578062100005, -111.99262245499995	{"coordinates": [-111.99262245499995, 33.37578062100005], "type": "Point"}	238	238	A0300057	ARIZONA CULTURAL ACADEMY & COLLEGE PREP	7810 S 42ND PL	PHOENIX	AZ	85042	NOT AVAILABLE	(602) 454-1222	1	1	330	MARICOPA	4013	USA	33.375780621	-111.992622455	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0300057	2010-09-24T00:00:00Z	IMAGERY	2010-05-11T00:00:00Z	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A0300057	3	304	2	17	26	NOT AVAILABLE
33.41748526400005, -111.83369701199996	{"coordinates": [-111.83369701199996, 33.41748526400005], "type": "Point"}	288	288	00031185	QUEEN OF PEACE CATHOLIC SCHOOL	141 N MACDONALD	MESA	AZ	85201	NOT AVAILABLE	(480) 969-0226	1	1	227	MARICOPA	4013	USA	33.417485264	-111.833697012	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=00031185	2009-12-10T00:00:00Z	IMAGERY/OTHER	2009-12-31T00:00:00Z	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=00031185	1	215	2	13	12	NOT AVAILABLE
32.23989379500006, -110.94344146699996	{"coordinates": [-110.94344146699996, 32.23989379500006], "type": "Point"}	311	311	00030975	SS PETER & PAUL CATHOLIC SCHOOL	1436 N CAMPBELL AVE	TUCSON	AZ	85719	NOT AVAILABLE	(520) 325-2431	1	1	419	PIMA	4019	USA	32.239893795	-110.943441467	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=00030975	2010-09-24T00:00:00Z	IMAGERY	2010-06-03T00:00:00Z	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=00030975	1	395	3	13	24	NOT AVAILABLE
32.23456831400006, -110.95768625999995	{"coordinates": [-110.95768625999995, 32.23456831400006], "type": "Point"}	347	347	A9900107	AL HUDA ISLAMIC SCHOOL	2800 E RIVER RD	TUCSON	AZ	85718	NOT AVAILABLE	(520) 624-8182	1	1	28	PIMA	4019	USA	32.234568314	-110.95768626	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A9900107	2009-12-10T00:00:00Z	IMAGERY/OTHER	2009-12-31T00:00:00Z	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=A9900107	1	22	2	10	6	NOT AVAILABLE
34.668427407000024, -92.34835217999995	{"coordinates": [-92.34835217999995, 34.668427407000024], "type": "Point"}	410	410	00047796	ST THERESA CATHOLIC SCHOOL	6311 BASELINE RD	LITTLE ROCK	AR	72209	NOT AVAILABLE	(501) 565-3855	1	1	154	PULASKI	5119	USA	34.668427407	-92.34835218	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=00047796	2010-09-24T00:00:00Z	IMAGERY	2010-05-20T00:00:00Z	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=00047796	1	139	2	13	15	NOT AVAILABLE
34.68269256700006, -92.58306331399996	{"coordinates": [-92.58306331399996, 34.68269256700006], "type": "Point"}	430	430	K9300041	AVILLA CHRISTIAN ACADEMY	302 AVILLA E	ALEXANDER	AR	72002	NOT AVAILABLE	(501) 408-4631	1	1	71	SALINE	5125	USA	34.682692567	-92.583063314	611110	ELEMENTARY AND SECONDARY SCHOOLS	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=K9300041	2010-09-24T00:00:00Z	IMAGERY	2010-08-12T00:00:00Z	http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Private&ID=K9300041	3	63	2	17	8	NOT AVAILABLE


CREATE TABLE us_private_schools (
  "geo_point" VARCHAR,
  "geo_shape" VARCHAR,
  "objectid" BIGINT,
  "fid_1" BIGINT,
  "ncesid" VARCHAR,
  "name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "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" VARCHAR,
  "val_method" VARCHAR,
  "val_date" VARCHAR,
  "website" VARCHAR,
  "level" BIGINT,
  "enrollment" BIGINT,
  "start_grad" BIGINT,
  "end_grade" BIGINT,
  "ft_teacher" BIGINT,
  "shelter_id" VARCHAR
);