Census Eligibility EDA

Abstract

Use census data to understand our yield rate and how many people end up eligible for the study

```{stata}
*| output: false
do "$code/setup_p3_legacy.do"
use "$data_gen/Pilot_3_Census_Reshaped_Analysis.dta", clear
// Generate variables for counting adults in HH (first selection criteria)
  // Number of adults
  gen adult_1 = age_cs > 16 & !missing(age_cs)
  // Number of working adults
  gen adult_2 = age_cs > 16 & age_cs <= 60 & !missing(age_cs)

  gen members = !missing(age_cs)

// Generate indicator for those who are eligible
  // Current criteria (Pilot 3)
  gen eligible_1 = female & age_cs >= 18 & age_cs <= 65 & !missing(age_cs) & !missing(female)
  // New criteria
  gen eligible_2 = female & age_cs >= 18 & age_cs <= 60 & !missing(age_cs) & !missing(female)
  // Make sure the eligible people are also willing
  replace eligible_1 = eligible_1 & work_home & !missing(work_home)
  replace eligible_2 = eligible_2 & work_home & !missing(work_home)

collapse (sum) adult_1 adult_2 members (max) eligible_1 eligible_2, by(hh_id reported_hh_adult_size reported_hh_adult_size_large)
```

Eligibility Count

The following table shows eligibility counts under different criteria combinations:

• Rows: Age range for eligible participants (18-65 vs 18-60)
• Columns: Definition of household adults (all adults vs only 18-60)

```{stata}
*| output: asis

qui count if eligible_1 & adult_1 <= 5 & members <= 15
local c1 = `r(N)'
qui count if eligible_1 & adult_2 <= 5 & members <= 15
local c2 = `r(N)'
qui count if eligible_2 & adult_1 <= 5 & members <= 15
local c3 = `r(N)'
qui count if eligible_2 & adult_2 <= 5 & members <= 15
local c4 = `r(N)'




display "Eligible HH counts by criteria combinations:"
display _n "|                     | No. adults (>16) <= 5 | No. adults (16<age<=60) <= 5|"
display    "---------------------+----------------+----------------------"
display    "Female and age 18-65  |" %15.0f `c1' " |" %21.0f `c2' "
display    "Female and age 18-60  |" %15.0f `c3' " |" %21.0f `c4' "
```

Eligible HH counts by criteria combinations:

	No. adults (>16) <= 5	No. adults (16<age<=60) <= 5
Female and age 18-65	749	762
Female and age 18-60	745	758

As proportions of the overall sample (1202)

```{stata}
*| output: asis

qui count
local total = 1202

qui count if eligible_1 & adult_1 <= 5 & members <= 15
local c1 = `r(N)' / `total'
qui count if eligible_1 & adult_2 <= 5 & members <= 15
local c2 = `r(N)' / `total'
qui count if eligible_2 & adult_1 <= 5 & members <= 15
local c3 = `r(N)' / `total'
qui count if eligible_2 & adult_2 <= 5 & members <= 15
local c4 = `r(N)' / `total'


display "Yield rate:"

display _n "|                     | No. adults (>16) <= 5 | No. adults (16<age<=60) <= 5|"
display    "---------------------+----------------+----------------------"
display    "Female and age 18-65  |" %15.3f `c1' " |" %21.3f `c2' "
display    "Female and age 18-60  |" %15.3f `c3' " |" %21.3f `c4' "
```

Yield rate:

	No. adults (>16) <= 5	No. adults (16<age<=60) <= 5
Female and age 18-65	0.623	0.634
Female and age 18-60	0.620	0.631

Self Reported v Roster count

```{stata}
count if adult_1 > reported_hh_adult_size
count if adult_1 != reported_hh_adult_size_large
```

  94
  206