← Selected projects

Interactive analysis

Agricultural Insurance Explorer

Compare insured liability, premiums, and claims across U.S. states and insurance programs.

USDA RMA2016–2025 · Public dataSource updated: September 14, 2026Sources & methodology ↓

Loading the published insurance data…

About the analysis

Sources & methodology

Data preparation, analysis, and visualization by Wajdi Belgacem.

Download analysis code (ZIP) ↓

Data coverage

The crop and forage view uses USDA RMA’s State/County/Crop files, including coverage levels. The livestock and dairy view uses the LRP, LGM, and DRP participation files. Reporting years span 2016–2025; DRP begins in 2019. Data accessed: September 20, 2026. Latest source update: September 14, 2026; archived files have earlier update dates.

Figures reflect the published reporting periods and remain subject to USDA revisions. Incomplete 2026 records are excluded.

Reporting years and locations

Crop and forage figures use commodity year. Livestock and dairy figures use reinsurance year as published in the participation files. These are separate views and are not summed together. Reinsurance year is the insurance agreement year, not the calendar year in which payments are made.

National totals include business with no disclosed state. These amounts cannot be assigned to the state map. State results therefore describe the published, geographically identified business and may understate a state’s actual business. Gray means no published amount or an undefined ratio, not zero risk. Coverage-level filtering is available for crop and forage records; livestock products have different coverage and deductible structures.

Calculations and interpretation

Dollar amounts are summed over the selected records. Loss ratio is total indemnities divided by total premium, including subsidized premium. Federal subsidy share is the reported federal subsidy divided by total premium. Ratios are calculated from summed amounts, never averaged from individual row ratios. A zero denominator produces no ratio.

Liability is the reported dollar amount of insurance. It is not a forecast of expected loss. Indemnities are reported insurance payments for the selected year. Amounts are nominal dollars, without inflation adjustment. State and private subsidies, additional subsidies, and EFA discounts are retained separately in the crop data; “premium less federal subsidy” is not the final producer bill. Livestock producer premium is taken directly from the source.

These are aggregate program statistics. They do not measure farm-level basis risk, uninsured losses, coverage adequacy, farmer profit, or insurer net profit. Different crop mixes and insured risks affect comparisons.

Data sources and code

State totals are aggregated from public USDA county and endorsement records. Records with no earned premium and entirely empty or zero financial fields are excluded; all reported financial amounts are retained.

Alaska and Hawaii are shown as geographic insets. Rounded display values may not add exactly; the CSV contains unrounded dollar totals. The map’s amount scales adapt to the current selection. The loss-ratio scale uses fixed thresholds.