US Public Schools

By HIFLD

All Public elementary and secondary education facilities in the United States as defined by the Common Core of Data

Product type

Dataset

Update frequency

Monthly

Updated

Dec 8, 2022

Delivery method

Download

Metadata is available for each file version of the dataset. A JSON file can be downloaded once you subscribe to the dataset. The information below is an example of the metadata included in each JSON file.

Dataset file name: Public_Schools.csv

Key Statistics

Total records

102,334

Missing values

Duplicate rows

Columns

Categorical

Numeric

Date/time

Correlations

Correlated columns

FT_TEACHER and POPULATION, ENROLLMENT and POPULATION, NCESID and COUNTYFIPS, Y and LATITUDE, ENROLLMENT and FT_TEACHER, X and LONGITUDE, DISTRICTID and NCESID, DISTRICTID and COUNTYFIPS

Column name	Type	Unique values	Min value	Max value
Y	numeric	101,133	-1613687.9	11505738
OBJECTID	numeric	102,334	1	102334
X	numeric	100,611	-19663464	16132198
NCESID	numeric	102,334	10000500870	780003000034
ZIP	numeric	22,621	601	99950
TYPE	numeric	4	1	4
STATUS	numeric	8	1	8
POPULATION	numeric	3,074	-999	14672
COUNTYFIPS	numeric	3,223	1001	78030
LATITUDE	numeric	100,885	-14.343785	71.300285
NAICS_CODE	numeric	1	611110	611110
LONGITUDE	numeric	100,689	-176.6399	144.91801
ENROLLMENT	numeric	2,946	-999	14286
DISTRICTID	numeric	17,626	100005	7800030
FT_TEACHER	numeric	266	-999	1419
STATE	categorical	55	2	2
CITY	categorical	12,695	3	26
ZIP4	categorical	8,640	1	13
COUNTY	categorical	1,912	3	21
COUNTRY	categorical	5	3	3
LEVEL_	categorical	10	4	15
ST_GRADE	categorical	18	1	2
END_GRADE	categorical	19	1	2
NAME	text	87,088	3	60
ADDRESS	text	93,138	3	56
TELEPHONE	text	92,878	14	14
NAICS_DESC	text	1	32	32
VAL_METHOD	text	4	7	13
WEBSITE	text	33,439	7	80
SOURCE	text	102,334	79	79
SHELTER_ID	text	22,508	4	13
SOURCEDATE	date	49	2009/10/13 00:00:00	2020/02/06 00:00:00
VAL_DATE	date	662	2010/02/10 00:00:00	2020/04/21 00:00:00