CauseofCropLoss2000to2020.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	CommodityYear	StateCode	StateAbbreviation	CountyCode	CountyName	CommodityCode	CommodityName	InsurancePlanCode	CoverageCategory	CauseofLossCode	CauseofLossDescription	MonthofLoss	MonthofLossName	PoliciesEarningPremium	PoliciesIndemnified	NetPlantedAcres	NetEndorsedAcres	Liability	TotalPremium	ProducerPaidPremium	Subsidy	StatePrivateSubsidy	AdditionalSubsidy	EFA_PremiumDiscount	NetDeterminedAcres	IndemnityAmount	LossRatio
2	2000	21	KY	103	Henry	11	WHEAT	90	A	11	Drought	12	DEC	1	1	48	0	7303	578	295	283	0	0	99	48	6034	10.44
3	2000	21	KY	103	Henry	231	BURLEY TOBACCO	70	A	11	Drought	7	JUL	1	1	8223.6	0	9675.2	406.4	178	228.4	0	0	59.2	4.2	546	1.34
4	2000	21	KY	185	Oldham	81	SOYBEANS	90	C	21	Hail	8	AUG	1	1	43.15	0	1839	118	0	118	0	0	0	27.8	963	8.16
5	2000	21	KY	185	Oldham	81	SOYBEANS	90	C	21	Hail	8	AUG	1	1	43.15	0	1839	118	0	118	0	0	0	58.5	1072	9.08
6	2000	21	KY	211	Shelby	11	WHEAT	44	L	11	Drought	12	DEC	1	1	40	0	2900	296	153	143	0	0	51	40	774	2.61
7	2000	21	KY	211	Shelby	11	WHEAT	44	A	11	Drought	4	APR	1	1	60	0	6735	1057	643	414	0	0	214	60	3868	3.66
8	2000	21	KY	211	Shelby	81	SOYBEANS	90	A	11	Drought	6	JUN	1	1	54	0	6909	864	496	368	0	0	165	54	2139	2.48
9	2000	21	KY	211	Shelby	81	SOYBEANS	44	A	44	Cold Wet Weather	11	NOV	1	1	59	0	6862	1333	815	518	0	0	272	59	1393	1.05
10	2000	21	KY	211	Shelby	231	BURLEY TOBACCO	70	A	21	Hail	8	AUG	1	1	3339	0	1964	114	49	65	0	0	17	0.875	1964	17.23
11	2000	21	KY	215	Spencer	41	CORN	44	A	11	Drought	8	AUG	1	1	25	0	5467	524	292	232	0	0	97	25	1447	2.76
12	2000	21	KY	215	Spencer	41	CORN	44	A	12	Heat	8	AUG	1	1	94	0	20549	1971	1099	872	0	0	366	94	6685	3.39
13	2000	21	KY	215	Spencer	81	SOYBEANS	90	A	11	Drought	0		1	1	26.91	0	2607	236.1	103.5	132.6	0	0	34.2	25.92	-54	-0.23
14	2000	21	KY	215	Spencer	81	SOYBEANS	90	A	11	Drought	7	JUL	1	1	70.11	0	5684.4	636.3	278.1	358.2	0	0	93	60.66	2505	3.94
15	2000	21	KY	215	Spencer	81	SOYBEANS	44	A	11	Drought	8	AUG	1	1	101.5	0	11933	1145	580	565	0	0	193	101.5	11023	9.63
16	2000	21	KY	215	Spencer	81	SOYBEANS	90	A	11	Drought	7	JUL	1	1	26.91	0	2607	236.1	103.5	132.6	0	0	34.2	10.44	338.4	1.43
17	2000	21	KY	215	Spencer	81	SOYBEANS	44	A	12	Heat	8	AUG	1	1	26.55	0	3178.5	294.5	150	144.5	0	0	50	13.1	626	2.13
18	2000	21	KY	215	Spencer	81	SOYBEANS	44	A	12	Heat	8	AUG	1	1	26.55	0	3178.5	294.5	150	144.5	0	0	50	40	4505	15.3
19	2000	21	KY	215	Spencer	231	BURLEY TOBACCO	70	A	21	Hail	8	AUG	1	1	14925	0	17559	843	368	475	0	0	123	14	17559	20.83
20	2001	21	KY	29	Bullitt	81	SOYBEANS	44	A	11	Drought	9	SEP	1	1	105	0	18194	1910	783	1127	0	0	0	105.3	3607	1.89
21	2001	21	KY	29	Bullitt	81	SOYBEANS	44	A	11	Drought	11	NOV	1	1	33.2	0	2820.5	604	247.5	356.5	0	0	0	28.2	2372	3.93
22	2001	21	KY	29	Bullitt	81	SOYBEANS	44	A	11	Drought	11	NOV	1	1	143.2	0	13252.5	2519	1032.5	1486.5	0	0	0	148.2	5372	2.13
23	2001	21	KY	29	Bullitt	231	BURLEY TOBACCO	70	A	11	Drought	8	AUG	1	1	11451	0	13621	654	268	386	0	0	0	3.88	1698	2.6
24	2001	21	KY	185	Oldham	11	WHEAT	44	A	11	Drought	7	JUL	1	1	33.3	0	2364	498	224	274	0	0	0	33.3	749	1.5
25	2001	21	KY	211	Shelby	11	WHEAT	44	A	11	Drought	4	APR	1	1	17	0	2161	291	131	160	0	0	0	17	257	0.88
26	2001	21	KY	211	Shelby	81	SOYBEANS	90	A	11	Drought	7	JUL	1	1	73.5	0	8744	619	254	365	0	0	0	73.5	1130	1.83
27	2001	21	KY	215	Spencer	41	CORN	44	A	11	Drought	4	APR	2	2	203.4	0	47835	3939	1615	2323	0	0	0	168.75	3321	0.84
28	2001	21	KY	215	Spencer	81	SOYBEANS	25	A	11	Drought	7	JUL	1	1	106.7	0	12707	1561	703	858	0	0	0	107	3998	2.56
29	2001	21	KY	215	Spencer	81	SOYBEANS	90	A	11	Drought	7	JUL	1	1	132.6	0	14092	1398	573	825	0	0	0	132.6	2117	1.51
30	2001	21	KY	223	Trimble	11	WHEAT	90	A	44	Cold Wet Weather	10	OCT	1	1	180	0	16078	1163	477	686	0	0	0	182.5	11958	10.28
31	2002	21	KY	29	Bullitt	41	CORN	90	A	11	Drought	7	JUL	1	1	80	0	8672	447	148	299	0	0	0	80	3035	6.79
32	2002	21	KY	29	Bullitt	81	SOYBEANS	90	C	11	Drought	8	AUG	1	1	35.25	0	1427	105.5	0	105.5	0	0	0	26	-197	-1.87
33	2002	21	KY	29	Bullitt	81	SOYBEANS	44	A	11	Drought	7	JUL	1	1	355.5	0	29715	7371	3021	4350	0	0	0	355.5	15562	2.11
34	2002	21	KY	29	Bullitt	81	SOYBEANS	90	C	11	Drought	8	AUG	1	1	14.25	0	561	42.5	0	42.5	0	0	0	23.5	756	17.79
35	2002	21	KY	103	Henry	41	CORN	90	C	11	Drought	0		1	1	20	0	902	86	0	86	0	0	0	20	-640	-7.44
36	2002	21	KY	103	Henry	41	CORN	90	C	11	Drought	6	JUN	1	1	42	0	1839	181	0	181	0	0	0	42	1327	7.33
37	2002	21	KY	103	Henry	41	CORN	90	A	11	Drought	7	JUL	1	1	30	0	3552	375	154	221	0	0	0	30	1380	3.68
38	2002	21	KY	103	Henry	41	CORN	44	A	11	Drought	6	JUN	1	1	8	0	1195.2	144	59.2	84.8	0	0	0	8	423.2	2.94
39	2002	21	KY	103	Henry	81	SOYBEANS	25	A	11	Drought	7	JUL	1	1	15	0	1721	207	93	114	0	0	0	15	1249	6.03
40	2002	21	KY	103	Henry	81	SOYBEANS	90	A	11	Drought	6	JUN	3	3	1550	0	173863	15396	6313	9083	0	0	0	1550	47332	3.07
41	2002	21	KY	103	Henry	81	SOYBEANS	90	A	11	Drought	7	JUL	2	2	65	0	6730	544	223	321	0	0	0	65	757	1.39
42	2002	21	KY	103	Henry	231	BURLEY TOBACCO	70	A	11	Drought	6	JUN	1	1	8681	0	10382	436	179	257	0	0	0	3	596	1.37
43	2002	21	KY	103	Henry	231	BURLEY TOBACCO	70	A	11	Drought	7	JUL	2	2	16764	0	22180	1299	575	724	0	0	0	10.73	6929	5.33
44	2002	21	KY	185	Oldham	41	CORN	25	A	11	Drought	7	JUL	1	1	34.4	0	8212	727	298	429	0	0	0	34.4	1450	1.99
45	2002	21	KY	185	Oldham	81	SOYBEANS	90	A	11	Drought	9	SEP	1	1	18	0	2635	135	55	80	0	0	0	19	2283	16.91
46	2002	21	KY	185	Oldham	81	SOYBEANS	25	A	11	Drought	7	JUL	3	3	576.3	0	87382	9375	4218	5157	0	0	0	576.3	23237	2.48
47	2002	21	KY	185	Oldham	81	SOYBEANS	90	C	11	Drought	7	JUL	1	1	426.9	0	20925	1054	0	1054	0	0	0	426.9	8344	7.92
48	2002	21	KY	185	Oldham	231	BURLEY TOBACCO	70	A	11	Drought	6	JUN	2	2	15238.4	0	17563.05	1211.6	544.85	666.75	0	0	0	7.5555	8441.5	6.97
49	2002	21	KY	211	Shelby	11	WHEAT	25	A	11	Drought	6	JUN	1	1	13.85	0	1120	173	71	102	0	0	0	13.85	44	0.25
50	2002	21	KY	211	Shelby	41	CORN	44	A	11	Drought	7	JUL	3	3	124	0	19996	2100	861	1239	0	0	0	124	9842	4.69
51	2002	21	KY	211	Shelby	41	CORN	90	C	11	Drought	6	JUN	6	6	170.77	0	8596.5	667.5	0	667.5	0	0	0	157.82	1761	2.64
52	2002	21	KY	211	Shelby	41	CORN	90	A	11	Drought	6	JUN	2	2	173.2	0	15795	2756	1129	1627	0	0	0	173.2	7068	2.56
53	2002	21	KY	211	Shelby	41	CORN	44	A	11	Drought	7	JUL	2	2	108	0	18904	2206	904	1302	0	0	0	108	7878	3.57
54	2002	21	KY	211	Shelby	41	CORN	90	C	11	Drought	7	JUL	5	5	222	0	10783.5	880	0	880	0	0	0	253	6295	7.15
55	2002	21	KY	211	Shelby	41	CORN	90	C	11	Drought	7	JUL	6	6	274.05	0	14184	1046.5	0	1046.5	0	0	0	256	6332	6.05
56	2002	21	KY	211	Shelby	41	CORN	25	A	11	Drought	7	JUL	2	2	180.75	0	31691	4436.5	1997	2439.5	0	0	0	192.95	29587	6.67
57	2002	21	KY	211	Shelby	41	CORN	90	A	11	Drought	7	JUL	7	7	622.355	0	91494.5	13643.5	6093.5	7550	0	0	0	615.04	52584	3.85
58	2002	21	KY	211	Shelby	41	CORN	90	C	11	Drought	0		1	1	80	0	3608	325	0	325	0	0	0	80	-402	-1.24
59	2002	21	KY	211	Shelby	41	CORN	90	A	11	Drought	7	JUL	4	4	98.565	0	19590.5	2656.5	1194.5	1462	0	0	0	105.88	13519	5.09
60	2002	21	KY	211	Shelby	41	CORN	90	C	11	Drought	6	JUN	1	1	24.8	0	1228	96	0	96	0	0	0	24.8	915	9.53
61	2002	21	KY	211	Shelby	41	CORN	90	A	11	Drought	6	JUN	1	1	23.5	0	2016	353	145	208	0	0	0	23.5	381	1.08
62	2002	21	KY	211	Shelby	41	CORN	25	A	11	Drought	7	JUL	4	4	599.2	0	108563	15248.5	6861	8387.5	0	0	0	600.9	40900	2.68
63	2002	21	KY	211	Shelby	81	SOYBEANS	90	A	11	Drought	6	JUN	6	6	1076.37	0	140484	12239.5	5052.5	7187	0	0	0	1082.87	57877	4.73
64	2002	21	KY	211	Shelby	81	SOYBEANS	90	A	11	Drought	9	SEP	1	1	153.2	0	20680	2114	951	1163	0	0	0	153.2	7560	3.58
65	2002	21	KY	211	Shelby	81	SOYBEANS	90	C	11	Drought	6	JUN	2	2	45.885	0	2271	108.5	0	108.5	0	0	0	9.5	305	2.81
66	2002	21	KY	211	Shelby	81	SOYBEANS	90	A	11	Drought	8	AUG	2	2	179.55	0	22597.5	2155	949	1206	0	0	0	177.11	8979	4.17
67	2002	21	KY	211	Shelby	81	SOYBEANS	90	A	11	Drought	7	JUL	2	2	953.05	0	128971	14207	6381	7826	0	0	0	953.05	70252	4.94
68	2002	21	KY	211	Shelby	81	SOYBEANS	90	A	11	Drought	8	AUG	1	1	4.56	0	431.5	41	17	24	0	0	0	7	346	8.44
69	2002	21	KY	211	Shelby	81	SOYBEANS	90	C	11	Drought	0		1	1	10.45	0	517	25	0	25	0	0	0	10.45	-159	-6.36
70	2002	21	KY	211	Shelby	81	SOYBEANS	90	C	11	Drought	7	JUL	1	1	84.5	0	4360.5	207	0	207	0	0	0	49	1704	8.23
71	2002	21	KY	211	Shelby	81	SOYBEANS	44	A	11	Drought	7	JUL	2	2	435	0	40987	4912	1957	2955	0	0	0	435	13539	2.76
72	2002	21	KY	211	Shelby	81	SOYBEANS	25	A	11	Drought	7	JUL	3	3	474.4	0	65480	6419	2888	3531	0	0	0	476.8	41153	6.41
73	2002	21	KY	211	Shelby	81	SOYBEANS	44	A	11	Drought	6	JUN	1	1	10	0	819	97	40	57	0	0	0	10	410	4.23
74	2002	21	KY	211	Shelby	81	SOYBEANS	90	A	11	Drought	6	JUN	2	2	62	0	7940	649.5	266.5	383	0	0	0	55.5	1785	2.75
75	2002	21	KY	211	Shelby	81	SOYBEANS	90	C	11	Drought	6	JUN	6	6	424.805	0	18355	1083.5	0	1083.5	0	0	0	461.19	4290	3.96
76	2002	21	KY	211	Shelby	81	SOYBEANS	44	A	11	Drought	8	AUG	1	1	58.5	0	4982	619	254	365	0	0	0	58.5	672	1.09
77	2002	21	KY	211	Shelby	81	SOYBEANS	90	C	11	Drought	8	AUG	1	1	18	0	965	42	0	42	0	0	0	18	458	10.9
78	2002	21	KY	211	Shelby	81	SOYBEANS	90	C	11	Drought	7	JUL	3	3	187.6	0	8756.5	464	0	464	0	0	0	223.1	5709	12.3
79	2002	21	KY	211	Shelby	231	BURLEY TOBACCO	70	A	11	Drought	7	JUL	6	6	42068	0	30816	1817	735	1082	0	0	0	11.9	10086	5.55
80	2002	21	KY	211	Shelby	231	BURLEY TOBACCO	70	A	11	Drought	8	AUG	3	3	1894	0	1271.2	63.6	24	39.6	0	0	0	0.58	1070	16.82
81	2002	21	KY	211	Shelby	231	BURLEY TOBACCO	70	C	11	Drought	7	JUL	2	2	28648.8	0	7305.6	307.2	0	307.2	0	0	0	7.2	4845.6	15.77
82	2002	21	KY	211	Shelby	231	BURLEY TOBACCO	70	A	11	Drought	6	JUN	2	2	8614.25	0	9028.25	611.5	250.5	361	0	0	0	2.8	7558.25	12.36
83	2002	21	KY	211	Shelby	231	BURLEY TOBACCO	70	A	11	Drought	7	JUL	3	3	2841	0	1906.8	95.4	36	59.4	0	0	0	0.87	1605	16.82
84	2002	21	KY	215	Spencer	41	CORN	90	A	11	Drought	6	JUN	2	2	140.8	0	18178	1616	662	954	0	0	0	140.8	4587	2.84
85	2002	21	KY	215	Spencer	41	CORN	25	A	11	Drought	7	JUL	1	1	18.35	0	3402	443.5	199.5	244	0	0	0	19.33	1659	3.74
86	2002	21	KY	215	Spencer	41	CORN	90	C	11	Drought	6	JUN	4	4	59.745	0	2099.5	242	0	242	0	0	0	32.29	719	2.97
87	2002	21	KY	215	Spencer	41	CORN	90	C	11	Drought	5	MAY	1	1	104	0	5663	335	0	335	0	0	0	104	5119	15.28
88	2002	21	KY	215	Spencer	41	CORN	25	A	11	Drought	7	JUL	1	1	444.2	0	81782	10490.5	4720.5	5770	0	0	0	443.26	36814	3.51
89	2002	21	KY	215	Spencer	41	CORN	90	C	11	Drought	7	JUL	4	4	126.15	0	6820	413	0	413	0	0	0	97.8	2800	6.78
90	2002	21	KY	215	Spencer	41	CORN	90	C	11	Drought	7	JUL	4	4	184.25	0	9815	607	0	607	0	0	0	212.6	4809	7.92
91	2002	21	KY	215	Spencer	41	CORN	90	A	11	Drought	7	JUL	1	1	95.7	0	11082	1056	433	623	0	0	0	95.7	8281	7.84
92	2002	21	KY	215	Spencer	41	CORN	90	C	11	Drought	6	JUN	3	3	50.745	0	1842.5	200	0	200	0	0	0	78.2	1656	8.28
93	2002	21	KY	215	Spencer	81	SOYBEANS	90	C	11	Drought	7	JUL	3	3	177.25	0	8657	408	0	408	0	0	0	177.25	2433	5.96
94	2002	21	KY	215	Spencer	81	SOYBEANS	90	A	11	Drought	6	JUN	1	1	66.5	0	9075	495	203	292	0	0	0	66.5	1543	3.12
95	2002	21	KY	215	Spencer	81	SOYBEANS	90	C	11	Drought	8	AUG	1	1	66	0	3424	149	0	149	0	0	0	66	995	6.68
96	2002	21	KY	215	Spencer	81	SOYBEANS	25	A	11	Drought	7	JUL	1	1	655	0	85006	9264	4170	5094	0	0	0	655.05	49634	5.36
97	2002	21	KY	215	Spencer	81	SOYBEANS	90	A	11	Drought	6	JUN	1	1	115.9	0	10955	1453	596	857	0	0	0	115.9	8560	5.89
98	2002	21	KY	215	Spencer	81	SOYBEANS	90	C	11	Drought	6	JUN	2	2	69	0	3341	159	0	159	0	0	0	69	621	3.91
99	2002	21	KY	215	Spencer	231	BURLEY TOBACCO	70	A	11	Drought	7	JUL	8	8	122924	0	102840.8	6814.6	2966.6	3848	0	0	0	34.32	34933.4	5.13
100	2002	21	KY	215	Spencer	231	BURLEY TOBACCO	70	A	11	Drought	6	JUN	1	1	5900	0	5741	275	113	162	0	0	0	2	847	3.08