USDA Risk Management Agency
Crop insurance by county
Federal crop insurance by county, crop, plan, and coverage level since 2015: policies, insured acres, liability, premium, the federal premium subsidy, losses paid, and loss ratio.
Published by USDA Risk Management Agency
Finest detail county
Tables 4
How we use this · on 2 desks
“How much did crop insurance pay out here after the drought?”
Where you'll see it
- Disaster Readiness: Know the risk
- Farm & Food Markets: Farm counties
- AI & Spreadsheets: at Level 3, link it into Excel or Google Sheets, download it, or ask your AI assistant about it
What we added
- Matched to the same county codes as every other source, so it lines up cleanly with all of them
- Every year kept since 2015
- Checked every day for a new release, and loaded when there is one
Summary of business, 1948–1988
Sample of 25 rows out of about 154,406
· 21 columns
| id | county_fips | crop_year | state_code | state | county_code | county_name | commodity_code | commodity | policies_sold | policies_earning | policies_indemnified | units_earning_premium | units_indemnified | net_reported_qty | liability | total_premium | subsidy | indemnity | loss_ratio | file_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 01021 | 1948 | 01 | AL | 021 | CHILTON | 0021 | COTTON | 348.0 | 232.0 | 0.0 | 245.0 | 6.0 | 1247.0 | 31179.0 | 1495.0 | 1495.0 | 154.0 | 0.1 | 2025-04-09 |
| 2 | 01049 | 1948 | 01 | AL | 049 | DE KALB | 0021 | COTTON | 1038.0 | 998.0 | 0.0 | 1240.0 | 170.0 | 7567.0 | 496744.0 | 18392.0 | 18392.0 | 21418.0 | 1.16 | 2025-04-09 |
| 3 | 01069 | 1948 | 01 | AL | 069 | HOUSTON | 0021 | COTTON | 356.0 | 324.0 | 0.0 | 334.0 | 24.0 | 2552.0 | 119880.0 | 9247.0 | 9247.0 | 905.0 | 0.1 | 2025-04-09 |
| 4 | 01089 | 1948 | 01 | AL | 089 | MADISON | 0021 | COTTON | 328.0 | 325.0 | 0.0 | 435.0 | 22.0 | 8392.0 | 462757.0 | 17335.0 | 17335.0 | 4320.0 | 0.25 | 2025-04-09 |
| 5 | 01109 | 1948 | 01 | AL | 109 | PIKE | 0021 | COTTON | 227.0 | 227.0 | 0.0 | 234.0 | 8.0 | 1696.0 | 51123.0 | 5116.0 | 5116.0 | 344.0 | 0.07 | 2025-04-09 |
| 6 | 01125 | 1948 | 01 | AL | 125 | TUSCALOOSA | 0021 | COTTON | 264.0 | 233.0 | 0.0 | 302.0 | 4.0 | 2528.0 | 128016.0 | 10143.0 | 10143.0 | 250.0 | 0.02 | 2025-04-09 |
| 7 | 05017 | 1948 | 05 | AR | 017 | CHICOT | 0021 | COTTON | 393.0 | 375.0 | 0.0 | 438.0 | 16.0 | 9800.0 | 602316.0 | 49918.0 | 49918.0 | 2395.0 | 0.05 | 2025-04-09 |
| 8 | 05035 | 1948 | 05 | AR | 035 | CRITTENDEN | 0021 | COTTON | 231.0 | 225.0 | 0.0 | 372.0 | 47.0 | 6437.0 | 430498.0 | 30316.0 | 30316.0 | 39530.0 | 1.3 | 2025-04-09 |
| 9 | 05041 | 1948 | 05 | AR | 041 | DESHA | 0021 | COTTON | 1044.0 | 994.0 | 0.0 | 1168.0 | 25.0 | 17896.0 | 632309.0 | 30962.0 | 30962.0 | 5463.0 | 0.18 | 2025-04-09 |
| 10 | 05045 | 1948 | 05 | AR | 045 | FAULKNER | 0021 | COTTON | 210.0 | 149.0 | 0.0 | 205.0 | 45.0 | 2046.0 | 89783.0 | 9697.0 | 9697.0 | 3820.0 | 0.39 | 2025-04-09 |
| 11 | 05057 | 1948 | 05 | AR | 057 | HEMPSTEAD | 0021 | COTTON | 287.0 | 287.0 | 0.0 | 335.0 | 122.0 | 4717.0 | 108169.0 | 11496.0 | 11496.0 | 14801.0 | 1.29 | 2025-04-09 |
| 12 | 05075 | 1948 | 05 | AR | 075 | LAWRENCE | 0021 | COTTON | 213.0 | 197.0 | 0.0 | 250.0 | 33.0 | 3695.0 | 124052.0 | 5907.0 | 5907.0 | 7172.0 | 1.21 | 2025-04-09 |
| 13 | 05077 | 1948 | 05 | AR | 077 | LEE | 0021 | COTTON | 241.0 | 212.0 | 0.0 | 230.0 | 6.0 | 3986.0 | 119579.0 | 8197.0 | 8197.0 | 1969.0 | 0.24 | 2025-04-09 |
| 14 | 04021 | 1948 | 04 | AZ | 021 | PINAL | 0021 | COTTON | 79.0 | 74.0 | 0.0 | 111.0 | 0.0 | 22343.0 | 1744173.0 | 81029.0 | 81029.0 | 0.0 | 0.0 | 2025-04-09 |
| 15 | 06079 | 1948 | 06 | CA | 079 | SAN LUIS OBISPO | 0011 | WHEAT | 122.0 | 96.0 | 0.0 | 201.0 | 133.0 | 59671.0 | 1412821.0 | 166771.0 | 166771.0 | 807240.0 | 4.84 | 2025-04-09 |
| 16 | 06101 | 1948 | 06 | CA | 101 | SUTTER | 0011 | WHEAT | 126.0 | 56.0 | 0.0 | 75.0 | 2.0 | 6168.0 | 173860.0 | 14517.0 | 14517.0 | 734.0 | 0.05 | 2025-04-09 |
| 17 | 06107 | 1948 | 06 | CA | 107 | TULARE | 0021 | COTTON | 145.0 | 129.0 | 0.0 | 148.0 | 17.0 | 10117.0 | 1006054.0 | 40327.0 | 40327.0 | 24442.0 | 0.61 | 2025-04-09 |
| 18 | 06107 | 1948 | 06 | CA | 107 | TULARE | 0011 | WHEAT | 58.0 | 44.0 | 0.0 | 184.0 | 174.0 | 19550.0 | 459226.0 | 56976.0 | 56976.0 | 315228.0 | 5.53 | 2025-04-09 |
| 19 | 08001 | 1948 | 08 | CO | 001 | ADAMS | 0011 | WHEAT | 23.0 | 20.0 | 0.0 | 44.0 | 5.0 | 4655.0 | 76836.0 | 18525.0 | 18525.0 | 1074.0 | 0.06 | 2025-04-09 |
| 20 | 08009 | 1948 | 08 | CO | 009 | BACA | 0011 | WHEAT | 29.0 | 25.0 | 0.0 | 88.0 | 20.0 | 11045.0 | 123324.0 | 32432.0 | 32432.0 | 11250.0 | 0.35 | 2025-04-09 |
| 21 | 08039 | 1948 | 08 | CO | 039 | ELBERT | 0047 | DRY BEANS | 114.0 | 114.0 | 0.0 | 125.0 | 48.0 | 5544.0 | 44354.0 | 5690.0 | 5690.0 | 6622.0 | 1.16 | 2025-04-09 |
| 22 | 08063 | 1948 | 08 | CO | 063 | KIT CARSON | 0011 | WHEAT | 26.0 | 20.0 | 0.0 | 38.0 | 3.0 | 3153.0 | 34119.0 | 8363.0 | 8363.0 | 594.0 | 0.07 | 2025-04-09 |
| 23 | 08075 | 1948 | 08 | CO | 075 | LOGAN | 0011 | WHEAT | 286.0 | 279.0 | 0.0 | 504.0 | 136.0 | 52264.0 | 493903.0 | 53791.0 | 53791.0 | 77174.0 | 1.43 | 2025-04-09 |
| 24 | 08095 | 1948 | 08 | CO | 095 | PHILLIPS | 0011 | WHEAT | 51.0 | 50.0 | 0.0 | 90.0 | 5.0 | 7983.0 | 141265.0 | 21884.0 | 21884.0 | 3522.0 | 0.16 | 2025-04-09 |
| 25 | 08123 | 1948 | 08 | CO | 123 | WELD | 0011 | WHEAT | 174.0 | 74.0 | 0.0 | 172.0 | 27.0 | 11968.0 | 211118.0 | 36990.0 | 36990.0 | 16195.0 | 0.44 | 2025-04-09 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing