Hieu Table

Unknown variable definitions are marked with ???

person_id | hieu_id | family_id | firm_id | person_type | lep | race_ethniciity |

male | doc_status | age | coverage | p_weight | region | minwage_region |

mcaid_predict | n_person | elig_4_medicaid | full_time | num_chronic |

health_status | sector | self_emp | povlev | cobra_flag | marit | firm_size |

tax_dependent | ind_income | family_type | num_on_plan | policy_holder | person |

gvmt_insurance | mcare | having_kids | prem_type | pholder_id_esi | u_esi |

u_priv | u_unins | u_mcaid | u_mcare | c_esi | c_priv |

c_mcaid | c_mcare | c_unins | family_size | num_dependents | fam_income |

tax_filing_status

person_id

Individual Identifier

hieu_id

Health Insurance Unit Identifier

family_id

Family Identifier

firm_id

Employer Firm Identifier

person_type

Relationship to other members of the HIEU

0

First Primary adult

1

Second Primary adult

2

Child 1, age <= 18, documented

3

Child 2, age <= 18, undocumented

4

Adult Child 1

5

Adult Child 2

6

Adult Child 3

7

Adult Child 4

lep

Limited English Proficiency

race_ethnicity

Race/ethnicity

1

White

2

Latino

3

African American

4

Asian

5

Other

male

Gender

0

Female

1

Male

doc_status

Immigration status

0

US-Born

1

Naturalized Citizen/Legal Permanent Resident for 5+ Years

2

Legal Permanent Resident for < 5 Years

3

Undocumented

age

Age

coverage

ex-ante Insurance Category

1

ESI

2

Private

3

Medicare

4

Medicaid

5

Other Public

6

Uninsured

p_weight

Individual Weight

region

Exchange Rating Region

1

Northern Counties

7

Santa Clara

13

LA

2

North Bay

8

San Mateo

14

LA

3

Sacramento Valley

9

Central Coast combined

15

Inland Empire

4

San Francisco

10

San Juaquin/Central Valley combined

16

Orange

5

Contra Costa

11

Eastern Counties

17

San Diego

6

Alameda

12

Kern

minwage_region

Region for minimum wage???

mcaid_predict

???

n_person

???

elig_4_medicaid

Eligibility for Medicaid

0

False

1

True

full_time

this is individual level

Full-Time Worker

-1

Self-employed workers and children <=18 or unemployed

0

Part-time workers

1

Full-time workers, not self-employed

num_chronic

???

nan

-1

0

1

2

3

4

health_status

???

nan

0

1

2

3

4

5

sector

???

nan

-1

0

1

2

3

self_emp

-1

Not-relevant

0

Not self-employed

1

Self-employed

povlev

???

cobra_flag

???

nan

0

1

marit

???

nan

1

2

3

9

firm_size

Size of the firm

tax_dependent

Individual is claimed as a dependent on someone else’s tax filing.

0

independent

1

tax dependent

ind_income

Individual’s income

family_type

???

num_on_plan

Number of family members on plan???

nan

1

2

3

4

5

6

policy_holder

Is the Individual the Policy Holder?

0

No

1

Yes

person

???

0

No

1

Yes

gvmt_insurance

Government Insurance Eligibility???

0

No

1

Yes

mcare

Medicare Eligibility???

0

No

1

Yes

having_kids

If the person has kids??? only has value of 0, can take out?

prem_type

Premium Type???

sp

ch

self

fam

pholder_id_esi

???

u_esi

ESI utility

u_priv

nongroup utility

u_unins

uninsured utility

u_mcaid

Medicaid utility

u_mcare

Medicare Utility

c_esi

ESI Latent Variable

c_priv

Nongroup Latent Variable

c_mcaid

Medicaid Latent Variable

c_mcare

Medicare Latent Variable

c_unins

Uninsured Latent Variable

family_size

Size of Family

num_dependents

Number of dependents in family

fam_income

Family Income

tax_filing_status

Tax Filing status

joint

hhead

single