Hay Prices by State and Hay Auction avatar

Hay Prices by State and Hay Auction

Pricing

$5.00 / 1,000 results

Go to Apify Store
Hay Prices by State and Hay Auction

Hay Prices by State and Hay Auction

Alfalfa, grass and straw prices from 21 state hay reports and 17 hay auctions: package, quality, price range and average. Public market reports.

Pricing

$5.00 / 1,000 results

Rating

0.0

(0)

Developer

Standard Work Co.

Standard Work Co.

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

4 days ago

Last modified

Categories

Share

Informational only. Not for navigation, safety, emergency, financial, medical, or legal decisions. Check the official source before you rely on it.

Prices are USDA Market News reports of past hay trades, asking prices and auction sales, not offers to buy or sell, and not financial advice.

What it does

Pulls hay and straw prices from 21 state direct hay reports and 17 hay auction reports (25 states in all), and returns one clean row per price line: hay type (alfalfa, grass, mixed, bermuda, straw and more), quality, sale type (trade, ask, offer), package (small square, large round, large square 3x4 and more), quantity, price range and average, freight or use, description, crop age, and region where the report gives one.

Quick start (no code)

  1. Leave the default to get Missouri (state report plus the Golden City auction), or type state codes in "States".
  2. Optional: pick Direct or Hay auctions under "Report type", or type alfalfa or straw in "Hay type contains".
  3. Click Start and download the table as CSV, Excel or JSON.

Output fields

Every row has the same fields in the same order. Missing values are null. state, reportKind, reportName, reportId, reportTitle, reportDate, reportStatus, region, section, commodity, quality, saleType, priceUnit, package, quantity, priceLow, priceHigh, priceAvg, freight, description, cropAge, note, error, qcStatus, qcNotes, sourceUrl, retrievedAt, retrievedAtLocal.

  • priceUnit is $/ton, $/bale, $/bundle or $/point/ton, from the report's own heading. Check it before comparing rows.
  • quantity is tons for direct reports, and tons or bales for auctions, as the report gives it.
  • saleType is null for auctions (they report sales).

Self-checks

Rows are never dropped. A row is flagged with a reason when a price is outside a plausible range for its unit, an average falls outside its range, the package is missing, or the report is older than your limit (default 21 days, monthly reports get 14 more). Seasonal auctions can be months old between seasons and are flagged. A report that cannot be fetched returns one row with the error filled in.

Source limits

  • Direct reports come out every two weeks (Kentucky and Tennessee monthly). Auctions report after each sale; some are monthly or seasonal.
  • Asking prices are not sale prices. Use saleType to tell them apart.
  • Values are passed through as published.

Data sources and credits

U.S. Department of Agriculture, Agricultural Marketing Service, Livestock, Poultry and Grain Market News, public hay report PDFs (https://www.ams.usda.gov/market-news/hay-reports). USDA information is public domain. Credit: U.S. Department of Agriculture.

Disclaimer

This is an independent tool by Standard Work Co. It is not affiliated with, endorsed by, or sponsored by any government agency named here. Agency names are used only to say where the data comes from. The data comes from public government sources and is passed through as published, only reformatted. Government data can be preliminary, late, missing, revised, or wrong, and this tool can fail too. This output is not an official government record. Provided "as is" with no warranty of any kind, including accuracy, completeness, or timeliness. You are responsible for checking the official source before acting on anything here. Liability is limited as stated in the Apify Standard Actor Contract for this tool.