This section describes the U.S. K-12 Public Schools file structure.

The U.S. national scope flat file includes one record for each school.

The default file structure is Excel XLSX.

 

Illustrative view of K12 charter schools

US1_2019 GIS project using CV XE GIS http://proximityone.com/us1_2019.htm

GIS project:  c:\us1_2019\us1_2019.gis

 

 

 

 

 

 

Sample school display -- http://proximityone.com/k12schools/sch1415sample.xls

 

Data Item/Fields

Item Description	ItemName	Notes	Format
Year	YEAR		C,4,0
Federal School ID	SCHOOLID		C,12,0
State FIPS Code	FIPST		C,2,0
Federal School District Code	LEAID		C,7,0
Federal School Code	SCHNO		C,5,0
State education agency code	STID		C,14,0
State school code	SEASCH		C,20,0
Education agency name	LEANM		C,60,0
School name	NAME		C,50,0
Telephone	PHONE		C,10,0
Mailing street	ADDR		C,30,0
Mailing city	CITY		C,25,0
Mailing state	STAB		C,2,0
Mailing ZIP5	ZIP		C,5,0
Mailing ZIP+4	ZIP4		C,4,0
Location street	ADDRL		C,30,0
Location city	CITYL		C,25,0
Location state	STABL		C,2,0
Location ZIP5	ZIPL		C,5,0
Location ZIP+4	ZIP4L		C,4,0
Type   1 = Regular school   2 = Special education school   3 = Vocational school   4 = Other/alternative school   5 = Reportable program	TYPE		C,1,0
Operational status   1 = operational at the time of the last report and is currently operational.   2 = closed since the time of the last report.   3 = opened since the time of the last report.   4 = in existence, but not reported in a previous year and is now being added.   5 = listed in previous year as being affiliated with a different education agency.   6 = temporarily closed and may reopen within three years.   7 = scheduled to be operational within two years.   8 = closed on a previous year’s file but has reopened.	STATUS		C,1,0
Locale code where UA: Urbanized Area; UC: Urban Cluster; PC: Principal City   11 = City, Large: area inside UA & inside PC & population >= 250,000.   12 = City, Midsize: area inside UA & inside PC & population 100,000-250,000.   13 = City, Small: area inside UA & inside PC & population < 100,000.   21 = Suburb, Large: area outside PC & inside UA & population >= 250,000.   22 = Suburb, Midsize: area outside PC & inside UA & population 100,000-250,000.   23 = Suburb, Small: area outside PC & inside UA & population < 100,000.   31 = Town, Fringe: area inside UC that is <= 10 miles from UA.   32 = Town, Distant: area inside UC that is 10-35 miles from UA.   33 = Town, Remote: area inside UC that is > 35 miles from UA.   41 = Rural, Fringe: non-urban area <= 5 miles from UA & <= 2.5 miles from UC   42 = Rural, Distant: non-urban area 5-25 miles from UA & 2.5-10 miles from UC   43 = Rural, Remote: non-urban area >= 25 miles from UA & >= 10 miles from UC	LOCALE		C,2,0
Latitude	LATITUDE		N,12,6
Longitude	LONGITUDE		N,12,6
County FIPS code	CONUM		C,5,0
County name	CONAME		C,33,0
Congressional District	CDCODE		C,4,0
Bureau of Indian Education code	BIES		C,1,0
Reconstituted year	RECONSTY		C,4,0
Reconstituted flag	RECONSTF		C,1,0
Total full-time-equivalent classroom teachers	FTE		N,9,2
Low grade offered	GSLO		C,2,0
High grade offered	GSHI		C,2,0
Prekindergarten offered	PKO		C,1,0
Kindergarten offered	KGO		C,1,0
1st grade offered	G01O		C,1,0
2nd grade offered	G02O		C,1,0
3rd offered	G03O		C,1,0
4th offered	G04O		C,1,0
5th grade offered	G05O		C,1,0
6th grade offered	G06O		C,1,0
7th grade offered	G07O		C,1,0
8th grade offered	G08O		C,1,0
9th grade offered	G09O		C,1,0
10th grade offered	G10O		C,1,0
11th grade offered	G11O		C,1,0
12th grade offered	G12O		C,1,0
Ungraded offered	UGO		C,1,0
School level   1 = Primary (low grade = PK through 03; high grade = PK through 08)   2 = Middle (low grade = 04 through 07; high grade = 04 through 09)   3 = High (low grade = 07 through 12; high grade = 12 only)   4 = Other (any other configuration not falling within the above three categories, including ungraded)	LEVEL		N,9,0
Title I school status   1 = School eligible for Title I Targeted Assistance (TAS) but provides no program   2 = School eligible for Title I Targeted Assistance (TAS) and provides TAS program   3 = School eligible for Title I Schoolwide program (SWP) and provides TAS program   4 = School eligible for Title I Schoolwide program (SWP) but provides no program   5 = School eligible for Title I Schoolwide program (SWP) and provides Title I Schoolwide program   6 = School not eligible for either Title I Targeted Assistance (TAS) or Schoolwide program	TITLEISTAT		N,9,0
Title I Eligible School	TITLEI		N,9,0
School-wide Title I	STITLI		C,3,0
Magnet school Special school designed to attract students of different race/ethnicity to reduce, prevent, eliminate racial isolation or provide academic/social focus on a particular theme.   Yes   No	MAGNET		C,3,0
Charter school School that provides free elementary and/or secondary education to eligible students under a specific charter granted by the state legislature or other appropriate authority.   Yes   No	CHARTER		C,3,0
Shared time school	SHARED		N,9,0
Students eligible to participate in the Free Lunch Program under the National School Lunch Act	FRELCH		N,9,0
Students eligible to participate in the Reduced-Price Lunch Program under the National School Lunch Act	REDLCH		N,9,0
Students free lunch eligible and reduced-price lunch eligible	TOTFRL		N,9,0
Race/ethnicities categories indicator	RACECAT		N,9,0
Prekindergarten students	PK		N,9,0
Kindergarten students	KG		N,9,0
Grade 1 students	G01		N,9,0
Grade 2 students	G02		N,9,0
Grade 3 students	G03		N,9,0
Grade 4 students	G04		N,9,0
Grade 5 students	G05		N,9,0
Grade 6 students	G06		N,9,0
Grade 7 students	G07		N,9,0
Grade 8 students	G08		N,9,0
Grade 9 students	G09		N,9,0
Grade 10 students	G10		N,9,0
Grade 11 students	G11		N,9,0
Grade 12 students	G12		N,9,0
Grade 13 students	G13		N,9,0
Ungraded students	UG		N,9,0
Adult education students	AE		N,9,0
Total students, all grades, includes AE	STUDENTS		N,9,0
American Indian/Alaska Native students	AIAN		N,9,0
American Indian/Alaska Native students, male	AIANM		N,9,0
American Indian/Alaska Native students, female	AIANF		N,9,0
Asian students	ASIAN		N,9,0
Asian students, male	ASIANM		N,9,0
Asian students, female	ASIANF		N,9,0
Hispanic students	HISPANIC		N,9,0
Hispanic students, male	HISPANICM		N,9,0
Hispanic students, female	HISPANICF		N,9,0
Black, non-Hispanic students	BLACK		N,9,0
Black, non-Hispanic students, male	BLACKM		N,9,0
Black, non-Hispanic students, female	BLACKF		N,9,0
White, non-Hispanic students	WHITE		N,9,0
White, non-Hispanic students, male	WHITEM		N,9,0
White, non-Hispanic students, female	WHITEF		N,9,0
Native Hawaiian/Pacific Islander students	NHPI		N,9,0
Native Hawaiian/Pacific Islander students, male	NHPIM		N,9,0
Native Hawaiian/Pacific Islander students, female	NHPIF		N,9,0
Two or more races students	TRACES		N,9,0
Two or more races students, male	TRACESM		N,9,0
Two or more races students, female	TRACESF		N,9,0

 

Handling of data items without a positive reported data value.

All data elements are either completed by the state or have been filled with a “0,” “-1,” “-2,” “-9,” “M,” or “N.”

 

0 - There are no occurrences of this data element. A value was expected and measured, but there were no cases in the category.

-- For example, a high school having no 12th graders would report 0.

 

M (or -1 for numeric values) - Data are missing. A value was expected and none was measured.

-- For example, a school that has at least one 12th grader but cannot measure the number of 12th graders would report -1.

 

N (or -2 for numeric values) - Data are not applicable. A value was neither expected nor measured.

-- For example, an elementary school would report -2 for 12th graders.