USDA · Risk Management Agency cause of loss
Crop-loss bands by county — license
The Risk Management Agency files, for every insured county and commodity in the United States, the premium, the indemnity, the liability, the quantity planted and lost, and the policy counts, cause by cause and year by year. This desk re-projects that filing onto the county-crop and states the band the year-by-year ratios make. The derived table is licensed for a state, or for the whole national register, refreshed for the term, for use inside the licensee's own work. A research engagement is quoted per piece of work.
- 18,794county-crops on the register
What you get
- The county-crop table itself: premium, indemnity, liability, quantity planted, quantity lost and policy counts, one row per county and commodity
- The year-by-year ratio behind each row, so the band can be recomputed rather than taken on trust
- The cause mix behind each row, with the indemnity each cause paid
- The filing each figure came from, carried on the row
- Refresh for the term, so a licensed table does not go stale in the licensee's hands
- Terms in writing: a single state or the whole national register, for use inside the licensee's own work
18,794 rows, newest load read 2026-09-17T02:38:47.914422+00:00 — download 100 real rows (CSV, no email).
Buy the license
- The nation, internal use — $12,000/year
How we handle your data → Privacy
What the license is
crop-loss bands by county, licensed as data: every table below, as the agency publishes it, with the columns the license file carries and nothing recomputed.
License terms and price
- The whole register, internal use: $12,000/year
Update cadence: rebuilt daily from the live register.
Download a 100-row sample (CSV) — the license file's own columns, a hundred real rows, no email required.
The full register is 18,794 county_crops. License it — the nation, internal use, $12,000/year.
See the full data sheet — 1 table, every column, as the register holds it
Tables and columns
croploss_county_crops — One row per county and commodity: premium, indemnity, liability, quantity planted and lost, policy counts, year by year and cause by cause.
18,794 rows, newest load read 2026-09-17T02:38:47.914422+00:00
county_fips— County, as a FIPS code.commodity_code— USDA RMA's commodity code.state_fips— State, as a FIPS code.state_code— State, USPS code.county_name— County name.commodity_name— Commodity name.first_year— First crop year with a policy on record for this county/commodity.last_year— Last crop year with a policy on record for this county/commodity.years— Number of crop years with a policy on record.policies— Total policies earning premium, summed across all years.policies_loss— Total policies with an indemnified loss, summed across all years.quantity_planted— Total quantity planted, summed across all years.quantity_loss— Total quantity lost (indemnified), summed across all years.liability— Total insured liability dollars, summed across all years.premium— Total premium dollars, summed across all years.indemnity— Total indemnity dollars paid, summed across all years.by_year— The same figures broken out year by year.by_cause— The same figures broken out by cause of loss.source_read_at— When this county/commodity row was last read from USDA RMA's source file.
Sample built 2026-10-19T00:04:23Z (UTC).
Who buys it
Agricultural lenders building county exposure models, crop insurers and reinsurers, cooperatives and input suppliers planning a region, and research groups studying a growing area.
Questions
- What is actually licensed?
- The county-crop table this desk builds: one row per county and commodity, carrying premium, indemnity, liability, quantity planted, quantity lost and policy counts, with the year-by-year ratios and the cause mix behind the row. It is the derived table that is licensed, and each row states the filing it came from.
- Is the underlying agency file mine to resell?
- No, and this license does not claim it is. The agency's file is a United States Government work published free to anyone; what is licensed here is this desk's re-projection of it onto the county-crop, together with the refresh and the terms. A licensee who wants the agency's file can fetch it from the agency.
- How is a national license priced?
- Against the term and the scope. The whole national register is one arrangement and a single state is another, each charged at its own annual figure for the term, written in the license rather than left to be inferred from a single number.
- What is a research engagement?
- Quoted per piece of work: a question about a county-crop, a region or a cause, answered from the filing and delivered as a document. It is quoted rather than listed because the work is scoped before it is priced.
How the figures are built
Every figure is the one its source document printed, shown with the file it came from. The three shares that are divided and the positions that are ranked are named on one page. Nothing is estimated. How each figure is defined.
Who publishes this
VELARIONAI LLC · Andrew Richardson, founder. Corrections reach a person: hello@velarionrecords.com. About this publication.
If it is not what you needed
Full refund within 7 days, one click — a subscription from your own page, a report or a license from the link that delivered it. No trial to forget to cancel.