U.S. K-12 Public Schools Characteristics; SY 2013-14
Contents
This section describes the U.S. K-12 Public Schools file structure (school year 2013-14 data)
The U.S. national scope flat file includes one record for each school.
The default file structure is Excel XLSX.
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 | N,9,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. 1 = Yes 2 = No | MAGNET | N,9,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. 1 = Yes 2 = No | CHARTER | N,9,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 | |
| Ungraded students | UG | N,9,0 | |
| Total students, all grades | 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.