Takeup against insurance program expansion

Program expansion is here shown as the number of unique crops and unique insurance plans in each year.

Restricting to California

Restricting to Corn, Soy and Wheat

Top crops by insurance takeup

measured in reported acres covered

measured in policies sold

## acres covered vs policies sold over time for specific crop

Top plans by takeup

measured in reported acres covered

measured in policies sold

Takeup at insurance plan x commodity level

Other measures of takeup, acres covered and liability amount

Is there lots of heterogeneity in insurance policy types?

Does this come from whether many different crops are grown at county level or many different insurance options are taken by farmers of the same crop?

California: number of unique policies at county level

and average number of unique policies at county-crop level

Illinois: number of unique policies at county and county-commodity level

and average number of unique policies at county-crop level

Summary stats of top insurance policies

Missing or zero values in takeup variables (“policies sold count” and “net reported quantity”)

## # A tibble: 4 × 2
##   missing                 n
##   <chr>               <int>
## 1 both                 7790
## 2 neither           2570442
## 3 policies sold        4276
## 4 reported quantity 1271196

Observations missing both

## # A tibble: 10 × 2
##    insurance_id_name                 n
##    <chr>                         <int>
##  1 CORN/SCO-RP/A                  1277
##  2 SOYBEANS/SCO-RP/A               867
##  3 CORN/RP/A                       672
##  4 SOYBEANS/RP/A                   651
##  5 COTTON/SCO-RP/A                 375
##  6 COTTON/RP/A                     271
##  7 WHEAT/RP/A                      250
##  8 CORN/YP/A                       206
##  9 PASTURE,RANGELAND,FORAGE/RI/A   201
## 10 PEANUTS/RP/A                    188

Observations missing reported quantity

## # A tibble: 10 × 2
##    insurance_id_name         n
##    <chr>                 <int>
##  1 OATS/APH/A            48159
##  2 GRAIN SORGHUM/RP/A    38320
##  3 WHEAT/YP/A            37031
##  4 WHEAT/RP/A            33857
##  5 GRAIN SORGHUM/YP/A    32497
##  6 CORN/YP/A             29378
##  7 ALL OTHER CROPS/APH/A 29321
##  8 CORN/RP/A             27944
##  9 SOYBEANS/RP/A         27687
## 10 SOYBEANS/YP/A         26987

Observations missing policies sold count

## # A tibble: 10 × 2
##    insurance_id_name                 n
##    <chr>                         <int>
##  1 CORN/RP/A                       930
##  2 PASTURE,RANGELAND,FORAGE/RI/A   720
##  3 SOYBEANS/RP/A                   609
##  4 COTTON/RP/A                     218
##  5 CORN/YP/A                       206
##  6 ALL OTHER CROPS/APH/A           168
##  7 ALL OTHER CROPS/RI/A            145
##  8 PEANUTS/RP/A                    144
##  9 CORN/RPHPE/A                    135
## 10 WHEAT/RP/A                      135

insurance_id_name	total_policies_sold	total_premium_amt_mean	total_premium_amt_sd	subsidy_amt_mean	subsidy_amt_sd	loss_ratio_mean	loss_ratio_sd
SOYBEANS/APH/A	2462334	21212.122	54660.767	10687.0513	27500.751	0.6192328	1.346083
CORN/APH/A	2416969	23952.357	65858.582	11682.0119	28996.395	0.6468609	8.465482
CORN/CRC/A	2024540	95710.619	246130.888	51357.3704	142787.072	0.6371799	1.292438
WHEAT/APH/A	1893138	22855.534	100421.843	11130.8521	47401.524	0.7569243	1.791220
SOYBEANS/CRC/A	1564226	48264.050	119008.523	26030.1956	70409.499	0.6071419	1.226984
CORN/APH/E	1480794	34699.152	98414.806	8856.0026	25149.872	0.9780884	2.288199
SOYBEANS/APH/E	1172661	21166.197	56614.852	5359.0316	15008.587	0.7282865	1.765725
WHEAT/APH/E	998077	29395.596	106229.674	7828.0328	29275.051	1.3324411	2.875655
ALL OTHER CROPS/APH/E	347017	8784.733	39301.688	2305.8275	10709.276	1.3028011	2.862568
OATS/APH/E	265374	1939.156	7952.164	545.1241	2371.114	1.3792416	2.925593

insurance_id_name	total_liability	total_premium_amt_mean	total_premium_amt_sd	subsidy_amt_mean	subsidy_amt_sd	loss_ratio_mean	loss_ratio_sd
WHEAT/RP/A	104174720409	127856.7	493796.3	80913.58	308850.5	0.6257089	1.3500705
PASTURE,RANGELAND,FORAGE/RI/A	31498364203	168933.0	620659.3	89647.62	324085.5	0.7109162	0.7268742
ALMONDS/APH/A	31397361831	530317.7	1017940.2	296022.26	572650.7	0.9146703	3.0121536
GRAPES/APH/A	21742140848	130245.7	345821.9	72550.25	187144.9	1.0722328	2.8695385
WHOLE FARM REVENUE PROTECTION/WFRP/A	16911465523	332917.0	866726.0	234863.93	594587.1	0.7795127	2.1992111
APPLES/APH/A	16599614006	189849.6	576597.9	119220.81	372354.0	1.2392958	2.0783340
ORANGE TREES/TDO/A	15482440318	153583.1	420009.7	99054.01	275977.9	0.5857476	3.3174336
ALL OTHER CROPS/DO/C	9506085359	NA	120987.6	NA	120841.7	NA	2.4052419
CHERRIES/ARH/A	7419784399	318907.7	803123.9	181740.06	453344.7	1.3004418	2.1551949
ANNUAL FORAGE/RI/A	4685413374	222180.8	1040660.9	115840.85	533660.4	0.6681489	0.7953694

SOB Data Exploration

2024-06-13

Takeup against insurance program expansion

Restricting to California

Restricting to Corn, Soy and Wheat

Top crops by insurance takeup

measured in reported acres covered

measured in policies sold

Top plans by takeup

measured in reported acres covered

measured in policies sold

Takeup at insurance plan x commodity level

Other measures of takeup, acres covered and liability amount

Is there lots of heterogeneity in insurance policy types?

California: number of unique policies at county level

and average number of unique policies at county-crop level

Illinois: number of unique policies at county and county-commodity level

and average number of unique policies at county-crop level

Summary stats of top insurance policies

Missing or zero values in takeup variables (“policies sold count” and “net reported quantity”)

Observations missing both

Observations missing reported quantity

Observations missing policies sold count

Corn, Revenue Protection, Buyup

Testing different measures of takeup

Takeup, prices, and subsidies over time

Almonds, Actual Prodution History, Buyup

Soybeans, Revenue Protection, Buyup

PASTURE,RANGELAND,FORAGE, Rainfall Index, Buyup