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
What caused each paid loss
Sample of 25 rows out of about 4,815,081
· 33 columns
| id | county_fips | crop_year | state_code | state | county_code | county_name | commodity_code | commodity | plan_code | plan | coverage_category | stage_code | cause_code | cause | month_of_loss | month_name | year_of_loss | policies_earning_premium | policies_indemnified | net_planted_qty | net_endorsed_acres | liability | total_premium | producer_paid_premium | subsidy | state_private_subsidy | additional_subsidy | efa_premium_discount | net_determined_qty | indemnity | loss_ratio | file_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0021 | Cotton | 02 | RP | A | H | 01 | Decline in Price | 10 | OCT | 2024 | 1 | 1 | 19.35 | 0.0 | 8727.0 | 644.0 | 264.0 | 380.0 | 0.0 | 0.0 | 0.0 | 19.35 | 272.0 | 0.42 | 2026-10-05 |
| 2 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0021 | Cotton | 02 | RP | A | H | 01 | Decline in Price | 11 | NOV | 2024 | 5 | 5 | 561.548 | 0.0 | 294253.73 | 23758.6 | 6330.63 | 17427.97 | 0.0 | 0.0 | 0.0 | 561.548 | 53627.73 | 2.26 | 2026-10-05 |
| 3 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0021 | Cotton | 02 | RP | A | H | 11 | Drought | 6 | JUN | 2024 | 1 | 1 | 936.9 | 0.0 | 617541.0 | 43478.0 | 9998.0 | 33480.0 | 0.0 | 0.0 | 0.0 | 936.9 | 114522.0 | 2.63 | 2026-10-05 |
| 4 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0021 | Cotton | 02 | RP | A | H | 11 | Drought | 8 | AUG | 2024 | 5 | 5 | 1032.922 | 0.0 | 534229.57 | 40248.7 | 10151.07 | 30097.63 | 0.0 | 0.0 | 0.0 | 1032.922 | 113866.97 | 2.83 | 2026-10-05 |
| 5 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0021 | Cotton | 02 | RP | A | H | 12 | Heat | 8 | AUG | 2024 | 3 | 3 | 683.98 | 0.0 | 459490.7 | 30911.7 | 7046.3 | 23865.4 | 0.0 | 0.0 | 0.0 | 683.98 | 17834.3 | 0.58 | 2026-10-05 |
| 6 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0021 | Cotton | 35 | STAX-RP | A | FL | 55 | ARPI/SCO/ECO/STAX/MP/PACE Crops Only | 6 | JUN | 2025 | 8 | 8 | 0.0 | 2554.02 | 165291.0 | 70607.0 | 14118.0 | 56489.0 | 0.0 | 0.0 | 0.0 | 2554.02 | 163265.0 | 2.31 | 2026-10-05 |
| 7 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0041 | Corn | 02 | RP | A | H | 01 | Decline in Price | 8 | AUG | 2024 | 1 | 1 | 80.9 | 0.0 | 47521.0 | 3841.0 | 1238.6 | 2602.4 | 0.0 | 0.0 | 0.0 | 80.9 | 21550.4 | 5.61 | 2026-10-05 |
| 8 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0041 | Corn | 02 | RP | A | H | 11 | Drought | 6 | JUN | 2024 | 3 | 3 | 531.792 | 0.0 | 239554.1 | 33575.9 | 7817.8 | 25758.1 | 0.0 | 0.0 | 0.0 | 531.792 | 68668.3 | 2.05 | 2026-10-05 |
| 9 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0041 | Corn | 02 | RP | A | H | 11 | Drought | 8 | AUG | 2024 | 1 | 1 | 54.925 | 0.0 | 15460.75 | 2644.25 | 607.75 | 2036.5 | 0.0 | 0.0 | 0.0 | 71.3 | 16426.0 | 6.21 | 2026-10-05 |
| 10 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0041 | Corn | 02 | RP | A | UH | 11 | Drought | 8 | AUG | 2024 | 1 | 1 | 56.975 | 0.0 | 15489.75 | 2789.75 | 641.25 | 2148.5 | 0.0 | 0.0 | 0.0 | 40.6 | 11360.5 | 4.07 | 2026-10-05 |
| 11 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0041 | Corn | 02 | RP | A | UH | 12 | Heat | 8 | AUG | 2024 | 1 | 1 | 56.975 | 0.0 | 15489.75 | 2789.75 | 641.25 | 2148.5 | 0.0 | 0.0 | 0.0 | 40.6 | 11360.5 | 4.07 | 2026-10-05 |
| 12 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0041 | Corn | 02 | RP | A | H | 12 | Heat | 6 | JUN | 2024 | 1 | 1 | 20.6 | 0.0 | 8196.5 | 733.5 | 264.0 | 469.5 | 0.0 | 0.0 | 0.0 | 20.6 | 5183.5 | 7.07 | 2026-10-05 |
| 13 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0041 | Corn | 02 | RP | A | H | 12 | Heat | 7 | JUL | 2024 | 1 | 1 | 153.408 | 0.0 | 128954.4 | 6457.6 | 2905.6 | 3552.0 | 0.0 | 0.0 | 0.0 | 153.408 | 46808.8 | 7.25 | 2026-10-05 |
| 14 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0041 | Corn | 02 | RP | A | H | 12 | Heat | 8 | AUG | 2024 | 1 | 1 | 54.925 | 0.0 | 15460.75 | 2644.25 | 607.75 | 2036.5 | 0.0 | 0.0 | 0.0 | 71.3 | 16426.0 | 6.21 | 2026-10-05 |
| 15 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0075 | Peanuts | 01 | YP | A | H | 11 | Drought | 8 | AUG | 2024 | 1 | 1 | 48.5 | 0.0 | 39059.5 | 6068.0 | 1395.5 | 4672.5 | 0.0 | 0.0 | 0.0 | 48.5 | 31773.5 | 5.24 | 2026-10-05 |
| 16 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0075 | Peanuts | 01 | YP | A | H | 12 | Heat | 8 | AUG | 2024 | 1 | 1 | 48.5 | 0.0 | 39059.5 | 6068.0 | 1395.5 | 4672.5 | 0.0 | 0.0 | 0.0 | 48.5 | 31773.5 | 5.24 | 2026-10-05 |
| 17 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0088 | Pasture,Rangeland,Forage | 13 | RI | A | FL | 55 | ARPI/SCO/ECO/STAX/MP/PACE Crops Only | 1 | JAN | 2025 | 2 | 2 | 348.525 | 0.0 | 31357.0 | 4985.0 | 2293.0 | 2692.0 | 0.0 | 0.0 | 0.0 | 0.0 | 10738.0 | 2.15 | 2026-10-05 |
| 18 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0088 | Pasture,Rangeland,Forage | 13 | RI | A | FL | 55 | ARPI/SCO/ECO/STAX/MP/PACE Crops Only | 2 | FEB | 2025 | 1 | 1 | 23.1 | 0.0 | 1722.0 | 265.0 | 130.0 | 135.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1014.0 | 3.83 | 2026-10-05 |
| 19 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0088 | Pasture,Rangeland,Forage | 13 | RI | A | FL | 55 | ARPI/SCO/ECO/STAX/MP/PACE Crops Only | 10 | OCT | 2024 | 4 | 4 | 661.215 | 0.0 | 54109.0 | 5565.0 | 2638.0 | 2927.0 | 0.0 | 0.0 | 0.0 | 0.0 | 19615.0 | 3.52 | 2026-10-05 |
| 20 | 01001 | 2024 | 01 | AL | 001 | Autauga | 0088 | Pasture,Rangeland,Forage | 13 | RI | A | FL | 55 | ARPI/SCO/ECO/STAX/MP/PACE Crops Only | 11 | NOV | 2024 | 3 | 3 | 375.74 | 0.0 | 46029.0 | 4813.0 | 2281.0 | 2532.0 | 0.0 | 0.0 | 0.0 | 0.0 | 19935.0 | 4.14 | 2026-10-05 |
| 21 | 01001 | 2024 | 01 | AL | 001 | Autauga | 9999 | All Other Crops | 13 | RI | A | FL | 55 | ARPI/SCO/ECO/STAX/MP/PACE Crops Only | 2 | FEB | 2025 | 1 | 1 | 60.8 | 0.0 | 8206.0 | 1388.0 | 680.0 | 708.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4435.0 | 3.2 | 2026-10-05 |
| 22 | 01001 | 2024 | 01 | AL | 001 | Autauga | 9999 | All Other Crops | 13 | RI | A | FL | 55 | ARPI/SCO/ECO/STAX/MP/PACE Crops Only | 7 | JUL | 2024 | 1 | 1 | 18.0 | 0.0 | 2429.0 | 303.0 | 148.0 | 155.0 | 0.0 | 0.0 | 0.0 | 0.0 | 7.0 | 0.02 | 2026-10-05 |
| 23 | 01001 | 2024 | 01 | AL | 001 | Autauga | 9999 | All Other Crops | 13 | RI | A | FL | 55 | ARPI/SCO/ECO/STAX/MP/PACE Crops Only | 10 | OCT | 2024 | 1 | 1 | 21.4 | 0.0 | 2889.0 | 309.0 | 152.0 | 157.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1016.0 | 3.29 | 2026-10-05 |
| 24 | 01001 | 2024 | 01 | AL | 001 | Autauga | 9999 | All Other Crops | 13 | RI | A | FL | 55 | ARPI/SCO/ECO/STAX/MP/PACE Crops Only | 11 | NOV | 2024 | 1 | 1 | 32.7 | 0.0 | 4413.0 | 559.0 | 273.0 | 286.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1138.0 | 2.04 | 2026-10-05 |
| 25 | 01003 | 2024 | 01 | AL | 003 | Baldwin | 0016 | Oats | 01 | YP | A | H | 42 | Freeze | 1 | JAN | 2024 | 2 | 2 | 230.5 | 0.0 | 33782.0 | 1858.0 | 614.0 | 1244.0 | 0.0 | 0.0 | 0.0 | 230.5 | 28788.0 | 15.49 | 2026-10-05 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing