prices.json, record by record.
One file, haywireag.com/api/prices.json, holds the latest report week: one record per market, commodity, grade and package. It is deliberately broader than the tables on the site: it also carries per-bale sales converted to per ton with an assumed bale weight, marked estimated: true. Drop those rows for an exact-sale-only analysis.
- report_week, scraped_date, updated — the Monday of the report week, the date HayWire collected it, and the build time.
- prices[] — the records. region is the USDA market (
RockValley_IA_Mon), state and state_code its state, report_date the USDA report the line came from. - commodity, quality, bale_type — alfalfa, grass, mixed and so on; the USDA grade (Supreme, Premium, Good, Fair, Utility;
nullwhen USDA stated none); the package as reported. - price_low, price_high, price_avg, unit — US dollars per ton, as USDA printed the range.
- estimated, assumed_bale_lbs, original_unit, converted —
estimated: truemarks a per-ton price derived from a per-bale report usingassumed_bale_lbs; the original per-bale price isprice_avg × assumed_bale_lbs ÷ 2000. - source, source_kind, source_url, sale_type — the publisher of the line (USDA AMS, or an auction house USDA does not cover) and the kind of sale.
Every record is an exact reported trade. There are no asking prices, no estimates and no interpolation anywhere in the file.