CEHI logo
Children’s Environmental Health Initiative
University of Illinois Chicago
2705 University Hall
Chicago, IL 60607
https://cehi.uic.edu/
School Information

Primary_Key

Primary key

character (12)

Raw Value

Position in File: 1


School_Number

School number

character (8)

Raw Value

Position in File: 2


School_Year

School year

integer

Raw Value

Position in File: 3


School_Name

School name

character (42)

Raw Value

Position in File: 4


Official_School_Name

Official school name

character (62)

Raw Value

Position in File: 5


LEA_Number

Local Education Agency (LEA) Number

character (5)

Raw Value

Position in File: 6

Related Attributes:
Alternate Of LEA_Name


LEA_Name

Schools name equivalent for Local Education Agency (LEA) number

character (42)

Raw Value

Position in File: 7

Related Attributes:
Alternate Of LEA_Number


OpenDate

Open date

date (MM/DD/YYYY)

Raw Value

Position in File: 14


Closing_Date

Closing date

date (D-Mon-YY)

Raw Value

Position in File: 15

Related Attributes:
Alternate Of CloseDate


CloseDate

Closing date

date (MM/DD/YYYY)

Raw Value

Position in File: 17

Related Attributes:
Alternate Of Closing_Date


Geography

Address_Line1

character (36)

Raw Value

Position in File: 8


Address_Line2

character (31)

Raw Value

Position in File: 9


City

City

character (22)

Raw Value

Position in File: 10


State

State

character (4)

Raw Value

Position in File: 11


Zip_Code_5

character (5)

Raw Value

Position in File: 12


Zip_Code_4

character (4)

Raw Value

Position in File: 13


County_Code

County code

character (3)

Raw Value

Position in File: 16


NGC

Non-geocodable

integer

Raw Value

Position in File: 18

Value Description
0 Geocodable
1 Non-geocodable
Set to 1 if a the address was geocoded, either programatically or by hand.


Match_addr

Match address

character (120)

Raw Value

Position in File: 19

Populated if a match was found in a geocode file. Hand-matched addresses will not have a value for this field.


X

X coordinate - WGS 1984

decimal

Calculated Value

Position in File: 20


Y

Y coordinate - WGS 1984

decimal

Calculated Value

Position in File: 21


GEOID00

Census Block (2000)

character (15)

Calculated Value

Position in File: 22

Geographic Resolution: Block

Related Attributes:
Was Derived From X, Y


GEOID10

Census Block (2010)

character (15)

Calculated Value

Position in File: 23

Geographic Resolution: Block

Related Attributes:
Was Derived From X, Y


Geocoded

Address was successfully geocoded

integer

Raw Value

Position in File: 24

Value Description
0 Not geocoded
1 Geocoded