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

DOB

Birth Date

date (MM/DD/YY)

Raw Value

Position in File: 1

DBR_ID

Unique Child ID

character (10)

Raw Value

Position in File: 2

Related Attributes:
Alternate Of SORT_ID

SORT_ID

Actual Birth Order

character (10)

Raw Value

Position in File: 71

Fixed width character representation of DBR_ID. Indicates actual birth order.

Related Attributes:
Alternate Of DBR_ID

MomID

Unique Mother ID

character (11)

Calculated Value

Position in File: 78

This ID allows the identification of children with the same birth mother (biological siblings). The process for assigning MomID included several iterations of linking identifer information using both exact and fuzzy matching.

Related Attributes:
Was Influenced By DOB, GEOID10, M_RACEGROUP, CoRes, DLLB


Demographics
Demography

Yr_Birth

Year of Birth

integer

Raw Value

Position in File: 72

C_RaceGroup

Child's Race/Ethnicity Group

integer

Calculated Value

Position in File: 3

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)

M_AGEGROUP

Mother's Age Group

integer

Calculated Value

Position in File: 6

Value Description
1 15-19
2 20-24
3 25-29
4 30-34
5 35-39
6 40-44

M_RACEGROUP

Mother's Race/Ethnicity Group

integer

Calculated Value

Position in File: 7

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)

NOTMARRIED

Not Married

integer

Raw Value

Position in File: 8

Value Description
0 No
1 Yes

F_AGEGROUP

Father's Age Group

integer

Calculated Value

Position in File: 4

Value Description
1 15-19
2 20-24
3 25-29
4 30-34
5 35-39
6 40-44

F_RACEGROUP

Father's Race/Ethnicity Group

integer

Calculated Value

Position in File: 5

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)

Reproductive History
Reproductive History

DLLB

Date of Last Live Birth

date (MM/YYYY)

Calculated Value

Position in File: 14

Source data includes only month and year. Day is set to '1' to create a valid date. Where Month is missing, January is used.

DLTERM

Date of Last Termination

date (MM/YYYY)

Calculated Value

Position in File: 15

Source data includes only month and year. Day is set to '1' to create a valid date. Where Month is missing, January is used.

DEAD

Number of Children Born Alive Now Dead

integer

Raw Value

Position in File: 13

TERM

Number of Other Terminations

integer

Raw Value

Position in File: 24


Prenatal Care
Prenatal Care

VISITS

Number of PreNatal Care Visits

integer

Raw Value

Position in File: 73


Gestation
Reproductive Physiological Phenomena

DLNM

Date of Last Normal Menses

date (MM/DD/YY)

Calculated Value

Position in File: 37

Invalid dates are corrected if it is reasonable to do so. For example, Feb. 29 in non-leap years is set to Feb. 28, and days=31 in months with 30 days are set to 30. Otherwise, invalid dates are set to missing.

GAINED

Weight gained

integer (lbs)

Raw Value

Position in File: 38

GEST

Weeks Gestation, Clinical

integer (weeks)

Raw Value

Position in File: 39


Related Attributes:
Alternate Of WKSGEST_NVS

PTB

Pre-Term Birth (<37 weeks, Clinical)

integer

Calculated Value

Position in File: 40

Value Description
0 No
1 Yes
Calculated based on clincal estimate of gestation


Related Attributes:
Alternate Of PTB_NVS

PTB_NVS

Pre-Term Birth (<37 weeks, National Vital Statistics (NVS))

integer

Calculated Value

Position in File: 41

Value Description
0 No
1 Yes
Calculated based on NVS estimate of gestation


Related Attributes:
Alternate Of PTB

VPTB

Very Pre-Term Birth (<34 weeks, Clinical)

integer

Calculated Value

Position in File: 42

Value Description
0 No
1 Yes
Calculated based on clincal estimate of gestation


Related Attributes:
Alternate Of VPTB_NVS

VPTB_NVS

Very Pre-Term Birth (<34 weeks, National Vital Statistics (NVS))

integer

Calculated Value

Position in File: 43

Value Description
0 No
1 Yes
Calculated based on NVS estimate of gestation


Related Attributes:
Alternate Of VPTB

WKSGEST_NVS

Weeks Gestation, National Vital Statistics (NVS)

integer (weeks)

Calculated Value

Position in File: 44

Calculated using the same method that the NVS uses. Code for calculations was supplied by the source.


Related Attributes:
Alternate Of GEST


Delivery
Delivery, Obstetric

CSDel

Method of Delivery: C-Section Delivery (all)

integer

Raw Value

Position in File: 75

Value Description
0 No
1 Yes

VDel

Method of Delivery: Vaginal Delivery (all)

integer

Raw Value

Position in File: 76

Value Description
0 No
1 Yes

Birth
Reproductive Physiological Phenomena

BIRTHORDER

Birth Order

integer

Calculated Value

Position in File: 9

BirthOrder = LIVING + DEAD + 1


Related Attributes:
Was Derived From LIVING, DEAD

BW_grams

Birth Weight (grams)

integer (grams)

Calculated Value

Position in File: 10

Calculated from LBS + OZS and rounded to a whole number


Related Attributes:
Was Derived From LBS, OZS

BWTpctl_clin

Birthweight Percentile (Clinical estimate of gestation)

decimal (percentile)

Calculated Value

Position in File: 11

Birth Weight Percentiles – Using the same subset of US births as the 'small for gestational age' (SGA) calculations use, the percentile associated with every possible birth weight (in grams) was calculated, by gestational age and sex. These were attached to each birth record by gestational age, sex and birth weight to determine the exact percentile for each birth. Two birth weight percentile variables were calculated: BWTpctl_clin – using the clinical estimate of gestation, by birth weight, gestational and sex. BWTpctl_NVS – using the NVS imputed estimate of gestation, by birth weight, gestational and sex.


Related Attributes:
Was Derived From BW_grams, LBS, OZS, GEST

BWTpctl_NVS

Birthweight Percentile (National Vital Statistics (NVS) estimate of gestation)

decimal (percentile)

Calculated Value

Position in File: 12

Birth Weight Percentiles – Using the same subset of US births as the 'small for gestational age' (SGA) calculations use, the percentile associated with every possible birth weight (in grams) was calculated, by gestational age and sex. These were attached to each birth record by gestational age, sex and birth weight to determine the exact percentile for each birth. Two birth weight percentile variables were calculated: BWTpctl_clin – using the clinical estimate of gestation, by birth weight, gestational and sex. BWTpctl_NVS – using the NVS imputed estimate of gestation, by birth weight, gestational and sex.


Related Attributes:
Was Derived From BW_grams, LBS, OZS, WKSGEST_NVS

ITRANS

Infant Transfer Status

integer

Raw Value

Position in File: 16

Value Description
1 Transferred after delivery
2 No transfer

LBS

Pounds of Birthweight

integer (pounds)

Raw Value

Position in File: 17


Related Attributes:
Alternate Of 2010:BW_grams

OZS

Ounces of Birthweight

integer (ounces)

Raw Value

Position in File: 20


Related Attributes:
Alternate Of BW_grams, LBS

LBW

Low Birth Weight (<2500 grams)

integer

Calculated Value

Position in File: 18

Value Description
0 No
1 Yes
Set to 1 if birth weight < 2500 grams


Related Attributes:
Was Derived From BW_grams, OZS, LBS

LIVING

Number of Living Children

integer

Raw Value

Position in File: 19

MeSH: Parity

PLURAL

Plurality

integer

Raw Value

Position in File: 21

SGA_clinical

Small for Gestational Age (SGA, Clinical)

integer

Calculated Value

Position in File: 22

Value Description
0 No
1 Yes
Benchmark birth weight percentiles were calculated using all US births from the CDC National Vital Statistics (NVS) natality files. The US data were subset to include only singleton births from 2000-2004 with known weight and gender with gestational age 20-44 weeks. Only the NVS imputed estimate of gestation was used for the calculations since CA does not report the clinical estimate at all. The US births were summarized by gestational age and sex, calculating various percentiles. These were matched to each birth record by gestational age and sex. The 10th percentile was then used to calculate 'small for gestational age' (SGA). In this way, two SGA variables were calculated: SGA_clinical – SGA using the clinical estimate of gestation, by gestational age and sex; SGA_NVS – SGA using the NVS imputed estimate of gestation, by gestational age and sex.

Related Attributes:
Was Derived From BW_grams, LBS, OZS, GEST

SGA_NVS

Small for Gestational Age (SGA, National Vital Statistics (NVS))

integer

Calculated Value

Position in File: 23

Value Description
0 No
1 Yes
Benchmark birth weight percentiles were calculated using all US births from the CDC National Vital Statistics (NVS) natality files. The US data were subset to include only singleton births from 2000-2004 with known weight and gender with gestational age 20-44 weeks. Only the NVS imputed estimate of gestation was used for the calculations since CA does not report the clinical estimate at all. The US births were summarized by gestational age and sex, calculating various percentiles. These were matched to each birth record by gestational age and sex. The 10th percentile was then used to calculate 'small for gestational age' (SGA). In this way, two SGA variables were calculated: SGA_clinical – SGA using the clinical estimate of gestation, by gestational age and sex; SGA_NVS – SGA using the NVS imputed estimate of gestation, by gestational age and sex.


Related Attributes:

VLBW

Very Low Birth Weight (<1500 grams)

integer

Calculated Value

Position in File: 25

Value Description
0 No
1 Yes
Set to 1 if birth weight < 1500 grams


Related Attributes:
Was Derived From BW_grams

APGAR5

Apgar Score 5 Minutes

integer

Raw Value

Position in File: 74


MTRANS

Mother Transfer Status

integer

Raw Value

Position in File: 77

Value Description
1 Transferred before delivery
2 No transfer

Identifiers
Personally Identifiable Information

CFNAME

Child's First Name

character (30)

Raw Value

Position in File: 47

MeSH: Names

CLNAME

Child's Last Name

character (30)

Raw Value

Position in File: 48

MeSH: Names

CMNAME

Child's Middle Name

character (30)

Raw Value

Position in File: 49

MeSH: Names

CSUFFIX

Child's Suffix

character (10)

Raw Value

Position in File: 50

MALE

Male Infant Indicator

integer

Raw Value

Position in File: 64

Value Description
0 No
1 Yes
MeSH: Sex

F_USA

Father Born in USA

integer

Raw Value

Position in File: 51

Value Description
0 No
1 Yes

F_USAPR

Father Born in USA or Puerto Rico

integer

Raw Value

Position in File: 52

Value Description
0 No
1 Yes

FAGE

Age of Father

integer

Raw Value

Position in File: 53


Related Attributes:
Was Derived From FBDATE, FBDATE

FBDATE

Father's Date of Birth

date (MM/DD/YY)

Calculated Value

Position in File: 54

Invalid dates are corrected if it is reasonable to do so. For example, Feb. 29 in non-leap years is set to Feb. 28, and days=31 in months with 30 days are set to 30. Otherwise, invalid dates are set to missing.

FFNAME

Father's First Name

character (30)

Raw Value

Position in File: 55

MeSH: Names

FLNAME

Father's Last Name

character (30)

Raw Value

Position in File: 56

MeSH: Names

FMNAME

Father's Middle Name

character (30)

Raw Value

Position in File: 57

MeSH: Names

FSTOB

Father's State of Birth

character (2)

Raw Value

Position in File: 58

FSUFFIX

Father's Suffix

character (10)

Raw Value

Position in File: 59

M_USA

Mother born in USA

integer

Raw Value

Position in File: 60

Value Description
0 No
1 Yes

M_USAPR

Mother born in USA or Puerto Rico

integer

Raw Value

Position in File: 61

Value Description
0 No
1 Yes

MAGE

Mother's Age at Time of Birth

integer

Raw Value

Position in File: 62


Related Attributes:
Was Derived From MBDATE, MBDATE

MAIDEN

Mother's Maiden Name

character (30)

Raw Value

Position in File: 63

MeSH: Names

MBDATE

Mother's Date of Birth

date (MM/DD/YY)

Raw Value

Position in File: 65

Invalid dates are corrected if it is reasonable to do so. For example, Feb. 29 in non-leap years is set to Feb. 28, and days=31 in months with 30 days are set to 30. Otherwise, invalid dates are set to missing.

MFNAME

Mother's First Name

character (30)

Raw Value

Position in File: 66

MeSH: Names

MLNAME

Mother's Last Name

character (30)

Raw Value

Position in File: 67

MeSH: Names

MMNAME

Mother's Middle Name

character (30)

Raw Value

Position in File: 68

MeSH: Names

MSTOB

Mother's State of Birth

character (2)

Raw Value

Position in File: 69

MSUFFIX

Mother's Suffix

character (10)

Raw Value

Position in File: 70


Hospital

HOSPITAL

Hospital Code

character (7)

Calculated Value

Position in File: 45

Determined by combining the following fields: county of occurrence, city of occurrence, and bed

Related Attributes:
Was Derived From CITYOCC

HOSPNAME

Standardized Hospital Name

character (60)

Raw Value

Position in File: 46


Geography
Residence Characteristics

CITYOCC

City of Occurrence

character (2)

Raw Value

Position in File: 26

CntyGeo00

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

character (5)

Calculated Value

Position in File: 27

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


Related Attributes:
Was Derived From GEOID00

CntyGeo10

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

character (5)

Calculated Value

Position in File: 28

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


Related Attributes:
Was Derived From GEOID10

COOCC

County of Occurrence

character (3)

Raw Value

Position in File: 29

CoRes

County of Residence

character (3)

Raw Value

Position in File: 30

CoResFIPS

County of Residence, Federal Information Processing Standards (FIPS)

character (3)

Raw Value

Position in File: 31

Related Attributes:
Was Derived From CoRes

GeoCoded

GeoCoded indicator

integer

Calculated Value

Position in File: 32

Value Description
0 No
1 Yes
Set to 1 if X/Y are populated


Related Attributes:
Was Derived From 2010:X, 2010:Y

GEOID00

Census Block (2000)

character (15)

Calculated Value

Position in File: 33

Calculated using X/Y via a spatial join

Related Attributes:
Was Derived From 2010:X, 2010:Y

GEOID10

Census Block (2010)

character (15)

Calculated Value

Position in File: 34

Calculated using X/Y via a spatial join

Related Attributes:
Was Derived From 2010:X, 2010:Y

X

WGS 1984 X Coordinate

decimal

Calculated Value

Position in File: 35

Calculated using mother's address at the time of birth. Only includes NC addresses

Y

WGS 1984 Y Coordinate

decimal

Calculated Value

Position in File: 36

Calculated using mother's address at the time of birth. Only includes NC addresses