Rank Counties
By Participation Rate
By Size of Unserved Population
Avg by Consortia
## # A tibble: 464 × 34
## county conso…¹ year elder…² adult…³ child…⁴ esl_c…⁵ pct_c…⁶ count…⁷ elder…⁸
## <chr> <chr> <dbl> <dbl> <dbl> <dbl> <chr> <chr> <dbl> <dbl>
## 1 Alameda CalWIN 2014 8668 59357 61616 40005 <NA> 1599685 291375
## 2 Alpine C-IV 2014 14 122 60 0 <NA> 1163 353
## 3 Amador C-IV 2014 227 1907 1261 97 <NA> 37447 12635
## 4 Butte C-IV 2014 1414 17170 13224 2689 <NA> 223899 52958
## 5 Calave… C-IV 2014 404 3021 1846 130 <NA> 45009 15672
## 6 Colusa C-IV 2014 76 701 1007 559 <NA> 22139 4164
## 7 Contra… CalWIN 2014 3571 32543 37059 16216 <NA> 1102941 226850
## 8 Del No… C-IV 2014 212 2800 2197 223 <NA> 27235 6214
## 9 El Dor… C-IV 2014 887 7138 4858 900 <NA> 182547 47296
## 10 Fresno CalWIN 2014 6644 100050 126245 61169 <NA> 969410 152453
## # … with 454 more rows, 24 more variables: child_pop <dbl>, esl_pop <dbl>,
## # ssi_recipients <dbl>, eligible_pop_minus_ssi <dbl>,
## # eligible_pop_with_ssi <dbl>, pri_estimate_freq <chr>, pri_minus_ssi <dbl>,
## # pri_with_ssi <dbl>, total_participants <dbl>, pct_pop_esl <dbl>,
## # pct_pop_ssi <dbl>, GEOID <chr>, total_population <dbl>, poverty_pop <dbl>,
## # median_hh_income <dbl>, median_home_price <dbl>, pct_college_educ <dbl>,
## # pct_non_white <dbl>, pct_single_family <dbl>, pct_poverty <dbl>, …
Trends over time
Need to Control for Pct Population Eligible for CalFresh
Simple Regressions
|
regression
|
term
|
est
|
se
|
p_val
|
|
pri_with_ssi vs log_pop
|
log_pop
|
0.029
|
0.011
|
0.010
|
|
pri_with_ssi vs log_pop
|
pct_pop_eligible_w_ssi
|
1.115
|
0.381
|
0.005
|
|
pri_with_ssi vs pct_pop_esl
|
pct_pop_esl
|
0.746
|
0.467
|
0.116
|
|
pri_with_ssi vs pct_pop_esl
|
pct_pop_eligible_w_ssi
|
0.804
|
0.371
|
0.035
|
|
pri_with_ssi vs pct_pop_ssi
|
pct_pop_ssi
|
9.010
|
2.362
|
0.000
|
|
pri_with_ssi vs pct_pop_ssi
|
pct_pop_eligible_w_ssi
|
-0.905
|
0.554
|
0.108
|
|
pri_with_ssi vs median_hh_income
|
median_hh_income
|
0.000
|
0.000
|
0.075
|
|
pri_with_ssi vs median_hh_income
|
pct_pop_eligible_w_ssi
|
-0.218
|
0.658
|
0.741
|
|
pri_with_ssi vs median_home_price
|
median_home_price
|
0.000
|
0.000
|
0.070
|
|
pri_with_ssi vs median_home_price
|
pct_pop_eligible_w_ssi
|
0.031
|
0.544
|
0.955
|
|
pri_with_ssi vs pct_college_educ
|
pct_college_educ
|
-0.651
|
0.206
|
0.003
|
|
pri_with_ssi vs pct_college_educ
|
pct_pop_eligible_w_ssi
|
-0.188
|
0.463
|
0.686
|
|
pri_with_ssi vs pct_single_family
|
pct_single_family
|
0.240
|
0.216
|
0.271
|
|
pri_with_ssi vs pct_single_family
|
pct_pop_eligible_w_ssi
|
0.742
|
0.377
|
0.054
|
|
pri_with_ssi vs pct_poverty
|
pct_poverty
|
3.711
|
0.998
|
0.000
|
|
pri_with_ssi vs pct_poverty
|
pct_pop_eligible_w_ssi
|
-2.180
|
0.863
|
0.014
|
##
## Call:
## lm(formula = pri_with_ssi ~ pct_poverty, data = data_for_correl)
##
## Residuals:
## Min 1Q Median 3Q Max
## -0.3447 -0.0858 0.0004 0.1098 0.2411
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 0.4688 0.0602 7.79 1.7e-10 ***
## pct_poverty 1.3934 0.4112 3.39 0.0013 **
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.143 on 56 degrees of freedom
## Multiple R-squared: 0.17, Adjusted R-squared: 0.155
## F-statistic: 11.5 on 1 and 56 DF, p-value: 0.00129
Correlation Plots
Take-Up Rate (PRI) vs. Poverty (No Controls)
Churn Rate vs. Poverty (No Controls)
Avg Time to Approve vs. Poverty (No Controls)
