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

DOB

Date of Birth

date (MM/DD/YYYY)

Raw Value

Position in File: 12

ID_Legacy

Child ID is a Legacy ID

integer

Raw Value

Position in File: 35

Value Description
0 No
1 Yes, (2009-2015 only)
If set to 1, indicates that this child had a test in the earlier years.

Applicable Years: 2009, 2010, 2011, 2012, 2013, 2014, 2015

Child_ID

Unique Child Identifier

integer

Raw Value

Position in File: 1

The value for this field was the provided value from the data source for records starting in 2009, or are modified versions of the legacy id, to make the formats consistent.

Related Attributes:
Was Derived From ID_Legacy

ID

Unique Child Identifier - Original

char

Raw Value

Position in File: 31

Applicable Years: 2009, 2010, 2011, 2012, 2013, 2014, 2015

LeadRecID

Unique Record ID (1992-2008 only)

decimal

Calculated Value

Position in File: 29

Consists of the child id followed by a decimal point, then a sequence number. The sequence number was deteremined from the chronological order of the lead test(s) for this child.

Applicable Years: 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008

Related Attributes:
Was Derived From Child_ID


Identifiers
Personally Identifiable Information

FName

First Name

char

Raw Value

Position in File: 9

MeSH: Names

LName

Last Name

char

Raw Value

Position in File: 10

MeSH: Names


Demographics
Demography

Hispanic

Hispanic indicator

integer

Raw Value

Position in File: 2

Value Description
1 Yes
2 No
9 Unknown
The Hispanic indicator is sparsely populated until 1999. Starting in 1999, the percentage of records with known Hispanic status slowly rises from ~40% to ~70%. This level of data population is consistent across NC counties.


AmIndAK

American Indian/AK Native indicator

integer

Calculated Value

Position in File: 3

Value Description
0 No
1 Yes
Constructed from source race file that contained one record per child per race (2003-2015). Earlier years had a single value indicating race.


AsianPI

Asian/Hawaiian/Pacific Islander indicator

integer

Calculated Value

Position in File: 4

Value Description
0 No
1 Yes
Constructed from source race file that contained one record per child per race (2003-2015). Earlier years had a single value indicating race.


Black

Black / African American indicator

integer

Calculated Value

Position in File: 5

Value Description
0 No
1 Yes
Constructed from source race file that contained one record per child per race (2003-2015). Earlier years had a single value indicating race.


White

White indicator

integer

Calculated Value

Position in File: 6

Value Description
0 No
1 Yes
Constructed from source race file that contained one record per child per race (2003-2015). Earlier years had a single value indicating race.


Other

Other Known Race Indicator

integer

Calculated Value

Position in File: 7

Value Description
0 No
1 Yes
Constructed from source race file that contained one record per child per race (2003-2015). Earlier years had a single value indicating race.


RaceGroup

Race Group

integer

Calculated Value

Position in File: 38

Value Description
1 Non-Hispanic White
2 Non-Hispanic Black
3 Hispanic
4 Non-Hispanic Asian/Hawaiian/Pacific Islander
5 Non-Hispanic Other (includes multi-racial)

Related Attributes:
Was Derived From Hispanic, Black, AmindAK, AsianPI, White, Other

Male

Child is Male

integer

Raw Value

Position in File: 23

Value Description
0 No
1 Yes
MeSH: Sex

Age

Age

integer

Calculated Value

Position in File: 28

Age at the time of test. Computed from BLLgeo_1992_2015:DOB_impute and test date.


Related Attributes:
Was Derived From DOB, Testdate

DOB_impute

Date of Birth Imputed

integer

Raw Value

Position in File: 22

Value Description
0 No
1 Yes, (1992-2008 only)
date of birth provided by source was imputed based on age at time of test.

Applicable Years: 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008


ExclAge7

Exclusion Indicator for Children Age 7+ (or Unknown)

integer

Calculated Value

Position in File: 27

Value Description
0 No
1 Yes
Set to 1 if Age is missing, or if child is 7 years old or older. Otherwise, set to 0.


Related Attributes:
Was Derived From Age

Refugee

Child is a Refugee

integer

Raw Value

Position in File: 34

Value Description
0 No
1 Yes
Applicable Years: 2009, 2010, 2011, 2012, 2013, 2014, 2015

MeSH: Refugees


Blood Lead Level
Lead Poisoning

Testdate

Date of Blood Lead Level Test

date (MM/DD/YYYY)

Raw Value

Position in File: 14

Lead

Blood Lead Level (micrograms per deciliter)

integer (micrograms per deciliter)

Raw Value

Position in File: 15

Test_Yr

Year of Blood Lead Level test

integer

Calculated Value

Position in File: 24

Related Attributes:
Was Derived From Testdate

SpecType

Specimen Collection Source

char

Raw Value

Position in File: 30

Value
Blood specimen
Capillary Blood
Venous Blood
Body fluid, unsp
Whole blood sample
Specimen of unknown material

UnDupeChild

Flag to Un-duplicate by Child

integer

Calculated Value

Position in File: 37

Value
0
1


Geography
Residence Characteristics

Addr_ID

Unique Address ID

integer

Raw Value

Position in File: 16

Source provides this address identifier. It is not used in the geocoding process. Instead, the geocoding was based on the actual addresses provided from the source. The address is not included in this dataset.

Geographic Resolution: Address/parcel

CO_Code

NC Department of Health and Human Services County Code

char

Raw Value

Position in File: 18

This value was provided by the source for years prior to 2009 and was determined and populated for later years.

Geographic Resolution: County

City

City

char

Raw Value

Position in File: 19

Geographic Resolution: City


ZipCode

5 Digit Zip Code

char

Raw Value

Position in File: 20

Geographic Resolution: Zip code


CoRes

County of Residence (standard)

char

Calculated Value

Position in File: 25

Geographic Resolution: County

Related Attributes:
Was Derived From CO_Code

CoResFIPS

County of Residence Federal Information Processing Standards (FIPS)

char

Calculated Value

Position in File: 26

The first 5 characters (state/county) of their respective block id (state/county/tract/block group/block) values.

Geographic Resolution: County

Related Attributes:
Was Derived From CO_Code

State

State Abbreviation

char

Raw Value

Position in File: 33

State was populated in the source records for this dataset only in the indicated years. However, all data is from North Carolina.

Applicable Years: 2009, 2010, 2011, 2012, 2013, 2014, 2015


GEOID10

Census Block (2010)

char

Calculated Value

Position in File: 39

Calculated using X/Y via a spatial join

Geographic Resolution: Block

Related Attributes:
Was Derived From X, Y

GEOID00

Census Block (2000)

char

Calculated Value

Position in File: 40

Calculated using X/Y via a spatial join

Geographic Resolution: Block

Related Attributes:
Was Derived From X, Y

X

WGS 1984 X Coordinate

decimal

Calculated Value

Position in File: 41

Calculated from child's address

Y

WGS 1984 Y Coordinate

decimal

Calculated Value

Position in File: 42

Calculated from child's address

NGC

Not Geocodable Indicator

integer

Calculated Value

Position in File: 43

Value Description
0 No
1 Yes

dateGeo

Date of Geocode File

date (YYYY-MM)

Calculated Value

Position in File: 44

CntyGeo00

State/County Federal Information Processing Standards (FIPS) (2000)

char

Calculated Value

Position in File: 45

The first 5 characters (state/county) of their respective block id (state/county/tract/block group/block) values.

Geographic Resolution: County


CntyGeo10

State/County Federal Information Processing Standards (FIPS) (2010)

char

Calculated Value

Position in File: 46

The first 5 characters (state/county) of their respective block id (state/county/tract/block group/block) values.

Geographic Resolution: County


GeoCoded

GeoCoded

integer

Calculated Value

Position in File: 47

Value Description
0 No
1 Yes

MissAddr

Address is Missing

integer

Calculated Value

Position in File: 48

Value Description
0 No
1 Yes
Set to 1 if no address was included in the source files.


Sociological Factors
Sociological Factors

Medicaid

Medicaid indicator (if ever enrolled)

integer

Raw Value

Position in File: 13

Value Description
0 No
1 Yes
MeSH: Medicaid

Plural

Plural Birth Indicator

integer

Raw Value

Position in File: 21

Value Description
0 No
1 Yes
Plural birth indicator, where 1 indicates that there were multiple births and 0 indicates a single birth



Laboratory/Clinic Information

Lab

Laboratory ID

char

Raw Value

Position in File: 17

Laboratory ID (1992-2008 only). These represent the same labs as those in BLLgeo_1992_2015:CLIA, but with different codes, as provided by the source.

Applicable Years: 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008

Related Attributes:
Alternate Of CLIA

CLIA

Laboratory ID

char

Raw Value

Position in File: 32

Laboratory ID (2009-2015 only). These represent the same labs as those in BLLgeo_1992_2015:Lab, but with different codes, as provided by the source.

Applicable Years: 2009, 2010, 2011, 2012, 2013, 2014, 2015

Related Attributes:
Alternate Of Lab

EIN

Clinic Code (Employer Identification Number)

char

Raw Value

Position in File: 8

LabNum

Accession Number from Laboratory

char

Raw Value

Position in File: 11

LabName

Laboratory Name

char

Raw Value

Position in File: 36

Applicable Years: 2009, 2010, 2011, 2012, 2013, 2014, 2015