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)

Calculated Value

Position in File: 14

Constructed from source component month/day/year variables

DDR_ID

Unique ID

character (10)

Calculated Value

Position in File: 7

Constructed using the year of death plus a sequential number

DeathDate

Date of Death

date (MM/DD/YYYY)

Calculated Value

Position in File: 8

Constructed from source component month/day/year variables

DOBflag

DOB constructed

integer

Calculated Value

Position in File: 12

Value Description
0 No
1 Yes
Indicates assumptions were made when creating the DOB. For example, if Day is missing, we use '15'. Or if Day is '31' for a month with only 30 days, we substitute '30'.

DupeFlag

Duplicate record

integer

Raw Value

Position in File: 11

Value Description
0 No
1 Yes
Two records are considered duplicates if they have the same values for the following fields: First, Middle, and Last Name; Birth and Death Dates; County of Residence

Yr_Birth

Year of Birth

integer

Raw Value

Position in File: 13

Yr_Death

Year of Death

integer

Raw Value

Position in File: 9


Demographics
Demography

AgeStd

Standardized Age

integer

Calculated Value

Position in File: 36

Age information was provided in the source file, including age in months, days, or minutes for infants. These were converted to age in years, and are considered the given age (Age). In addition, age was calculated using the birth and death dates (CalcAge). This standardized age (AgeStd) was then constructed, based on the two available age values. Where the value of Age is different from the calculated age between birth and death dates, AgeStd contains the value believed to be correct. AgeStd is missing where there are discrepancies that cannot be reconciled. This Age should be used for analyses. When Age = CalcAge, AgeStd = Age; When Age = CalcAge+1 (when someone dies on their birthday), AgeStd = Age; When CalcAge < 0, AgeStd = Age; When abs(Age-CalcAge) < 2, AgeStd = CalcAge; Otherwise AgeStd = missing

EducGroup

Education Group

integer

Calculated Value

Position in File: 46

Value Description
1 Middle school or less
2 Some high school
3 High school
4 Some college/associate's degree
5 Bachelor's degree or above
For the pre-2014 data, assignment of the EducGroup is a 'best guess' since the data available is not specific enough for an absolute determination.


Hisp

Hispanic Origin

character (1)

Raw Value

Position in File: 5

Value Description
C Cuban
M Mexican
N Non-Hispanic
O Other Hispanic
P Puerto Rican
S Central/South American
U Unknown

HispOthDesc

Hispanic Origin Other Description

character (20)

Raw Value

Position in File: 60

Male

Male indicator

integer

Raw Value

Position in File: 43

Value Description
[blank] Unknown
0 No
1 Yes
MeSH: Sex

Marital2

Marital Status

character (1)

Raw Value

Position in File: 47

Value Description
M Married
A Married but Separated, in use starting in 2014
W Widowed
D Divorced
S Never Married
U Not Classifiable

RaceGroup

Race/Ethnicity Group

integer

Calculated Value

Position in File: 15

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)

RaceR

Race

character (1)

Raw Value

Position in File: 45

Value Description
0 Other non-White
1 White
2 Black
3 American Indian
4 Chinese
5 Japanese
6 Hawaiian
7 Filipino
8 Other Asian
9 Unknown

VETERAN

Veteran/Armed Forces?

character (1)

Raw Value

Position in File: 63

Value Description
N No
Y Yes
U Unknown
MeSH: Veterans


Death
Death

Attend

Attendant

integer

Raw Value

Position in File: 3

Value Description
1 Physician
2 Medical Examiner
3 Coroner
4 Health Director

Autopsy2

Was Autopsy Performed?

character (1)

Raw Value

Position in File: 48

Value Description
N No
Y Yes
U Unknown
MeSH: Autopsy

Disposition2

Method of Disposition (burial, cremation, etc)

character (1)

Raw Value

Position in File: 50

Value Description
B Burial
C Cremation
D Donation, in use starting in 2014
E Entombment, in use starting in 2014
O Other
R Removal from state
U Unknown

FACCITY

Facility City, FIPS code

character (5)

Raw Value

Position in File: 62

FACNAME

Facility Name

character (50)

Raw Value

Position in File: 61

Available starting in 2014. Comparable information pre-2014 can be obtained using the combined COOCC/BED variables.

Findings2

Were Autopsy Findings Available to Complete Cause of Death?

character (1)

Raw Value

Position in File: 49

Value Description
N No
Y Yes
U Unknown
Wording is slightly different for pre-2014: 'Autopsy Findings were considered in determining cause of death'

MeSH: Autopsy

HospType

Hospital Type

character (1)

Raw Value

Position in File: 2

Value Description
[blank] En Route to Facility
0 Home or Non-Institution
1 General Hospital
2 TB Hospital
3 Mental Hospital
4 Chronic Hospital
5 Penal Hospital
6 Veterans Hospital
7 Nursing & Rest Home
8 Clinic & Doctor's Office
9 Other Institution

Manner

Manner of Death

character (1)

Raw Value

Position in File: 51

Value Description
A Accident
S Suicide
H Homicide
P Pending
C Could Not Be Determined
6 Self-Inflicted, in use in pre-2014 data
N Natural
[blank] Unknown

PlaceDeath

Place of Death

integer

Raw Value

Position in File: 54

Value Description
1 Hospital Inpatient
2 Hospital ER/Outpatient
3 Hospital Dead on Arrival
4 Decedent's Home, in use starting in 2014
5 Hospice Facility, in use starting in 2014
6 Nursing Home/Long Term Care Facility
7 Other
9 Unknown

PlaceInj

Place of Injury code. Only applicable for injury deaths.

character (1)

Raw Value

Position in File: 52

Value Description
0 Home, in use starting in 2014
1 Residential Institution
2 School, Other Institutions, Admin. Area
3 Sports and Recreation Area
4 Street/Highway
5 Trade and Service Area
6 Industrial and Construction Area
7 Farm
8 Other Specified Place
9 Unspecified Place
[blank] Unknown

PREG

Pregnancy Status

character (1)

Raw Value

Position in File: 65

Value Description
1 Not pregnant w/in past year
2 Pregnant at time of death
3 Not pregnant, but pregnant within 42 days of death
4 Not pregnant, but pregnant 43 days to 1 year before death
9 Unknown if pregnant within past year
8 N/A
7 Not on Certificate

TOBACCO

Did Tobacco use contribute to death?

character (1)

Raw Value

Position in File: 64

Value Description
C Not on certificate
N No
P Probably
U Unknown
Y Yes

TOD

Time of Death

character (4)

Raw Value

Position in File: 59

WorkInj

Injury at Work?

character (1)

Raw Value

Position in File: 53

Value Description
N No
Y Yes
[blank] Unknown

Death - ICD10
Death

ICD10

Primary ICD-10 Code

character (5)

Raw Value

Position in File: 17

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_01

Secondary ICD-10 Code (1)

character (5)

Raw Value

Position in File: 18

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_02

Secondary ICD-10 Code (2)

character (5)

Raw Value

Position in File: 19

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_03

Secondary ICD-10 Code (3)

character (5)

Raw Value

Position in File: 20

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_04

Secondary ICD-10 Code (4)

character (5)

Raw Value

Position in File: 21

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_05

Secondary ICD-10 Code (5)

character (5)

Raw Value

Position in File: 22

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_06

Secondary ICD-10 Code (6)

character (5)

Raw Value

Position in File: 23

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_07

Secondary ICD-10 Code (7)

character (5)

Raw Value

Position in File: 24

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_08

Secondary ICD-10 Code (8)

character (5)

Raw Value

Position in File: 25

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_09

Secondary ICD-10 Code (9)

character (5)

Raw Value

Position in File: 26

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_10

Secondary ICD-10 Code (10)

character (5)

Raw Value

Position in File: 27

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_11

Secondary ICD-10 Code (11)

character (5)

Raw Value

Position in File: 28

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_12

Secondary ICD-10 Code (12)

character (5)

Raw Value

Position in File: 29

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_13

Secondary ICD-10 Code (13)

character (5)

Raw Value

Position in File: 30

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_14

Secondary ICD-10 Code (14)

character (5)

Raw Value

Position in File: 31

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_15

Secondary ICD-10 Code (15)

character (5)

Raw Value

Position in File: 32

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

ICD10_16

Secondary ICD-10 Code (16)

character (5)

Raw Value

Position in File: 33

The original ICD-10 codes are all 4 characters long, and “.” was not included in the source. The “.” was inserted where appropriate. For example, “P012” is converted to “P01.2”, and “V892” is converted to “V89.2”. Entries such as “R99” remain unchanged.

Geography - Birth
Residence Characteristics

StBirth

State of Birth - State Code

character (2)

Raw Value

Position in File: 4

Not FIPS

StBirthAbbr

State of Birth - Abbreviation

character (2)

Raw Value

Position in File: 57


Geography - Death
Residence Characteristics

StDeath

State of Death - State Code

character (2)

Raw Value

Position in File: 1

Value Description
34 NC
Not FIPS. Always '34' for NC. Used through 2013.


StDeathAbbr

State of Death - Abbreviation

character (2)

Raw Value

Position in File: 56

Value Description
NC North Carolina
Always 'NC'. Used starting in 2014.



Geography - Residence at time of Death
Residence Characteristics

City

Residence Address - City

character (30)

Raw Value

Position in File: 44

CityLimits

Residence is Inside City Limits?

character (1)

Raw Value

Position in File: 55

Value Description
N No
Y Yes
U Unknown

CityResFIPS

City of Residence, Federal Information Processing Standards (FIPS) code

character (5)

Raw Value

Position in File: 58

CntyGeo00

County Federal Information Processing Standards (FIPS) (2000), from geocoding

character (5)

Calculated Value

Position in File: 37

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

CntyGeo10

County Federal Information Processing Standards (FIPS) (2010), from geocoding

character (5)

Calculated Value

Position in File: 41

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

CoResFIPS

County of Residence, Federal Information Processing Standards (FIPS) code

character (3)

Raw Value

Position in File: 16

Based on source variable, not geocoding. Where the state of birth or the state of residency is not NC, the corresponding county (county of birth/county of residency) is set to missing. This is done so that county codes for other states are not misinterpreted as NC county codes.

GeoCoded

GeoCoded indicator

integer

Calculated Value

Position in File: 35

Value Description
[blank] Missing
0 No
1 Yes
Set to 1 if X/Y are populated, starting in 2009


GeoID00

Census Block (2000)

character (15)

Calculated Value

Position in File: 34

Calculated using X/Y via a spatial join

GEOID10

Census Block (2010)

character (15)

Calculated Value

Position in File: 38

Calculated using X/Y via a spatial join

NGC

Not Geocodable

character (1)

Calculated Value

Position in File: 42

Value Description
[blank] No
1 Yes
Address is not geocodable. For example, P.O. Boxes.

State

Residence Address - State

character (2)

Raw Value

Position in File: 10

X

WGS 1984 X Coordinate

decimal

Calculated Value

Position in File: 40

Set to 0 for un-geocoded records

Y

WGS 1984 Y Coordinate

decimal

Calculated Value

Position in File: 39

Set to 0 for un-geocoded records

Zipcode

Residence Address - Zip code

character (5)

Raw Value

Position in File: 6