Usda Market News

Read dated rows from one USDA AMS My Market News report (fruit and vegetable shipping-point / terminal / import-crossing prices, grain, hay, cotton and other non-livestock reports). Every row keeps AMS's own fields: commodity, variety, package or unit, origin, and low / high / mostly / mean price as separate values; nothing is averaged. Optional `commodity` keeps only rows whose commodity, variety or group contains that word (e.g. "lime"); optional `district` keeps rows whose district or market location contains that text (e.g. "mexico crossings through texas"). If the report has rows but none match, the result says so and lists the commodities or districts it does carry. Reports are daily: a weekly view is a start_date/end_date range of up to 31 days, newest first. With no dates it returns the most recent report date (looking back up to a week). If AMS has no rows the status is "no_rows_for_request" with the report's last published date, never an empty array. Dates are ISO (2026-10-22).

Find USDA AMS My Market News reports outside livestock: fruit and vegetable shipping-point and terminal-market prices (limes, tomatoes, avocados...), Mexico and other import crossings, grain bids, hay, cotton, ornamentals and more (about a thousand reports). Words in `query` must all appear in the report title, slug, market type or office, e.g. "shipping point fruit", "mcallen", "terminal market vegetables", "grain bids". Returns report_id, title, market types, office, sections and last published date. Commodities (limes, apples, corn...) and crossing districts are fields INSIDE a report's rows, not in its title: a produce report is named for the AMS office, e.g. "Phoenix Shipping Point Fruit Prices" carries limes from Mexico crossings through Texas. Find the office/market-type report here, then filter its rows with `commodity` and `district` in ams_market_report. Use the report_id with ams_market_report. If nothing matches the result says so and gives the market types that exist; it is never a bare empty list. Livestock price reports are ams_report_search.

Read dated rows from one USDA AMS livestock price report (Livestock Mandatory Price Reporting). Every response states the report family, report title, market type and office, and each row keeps its own basis fields (class, selling basis, grade, weight range) plus price low / high / weighted-average as separate fields: ranges are never collapsed and nothing is averaged here. Pick a section (see sections in ams_report_search; prices are usually in "Detail", not "Summary"). With no date it returns the most recent report date. If AMS has no rows for the requested date or section (not published yet, holiday, wrong section) the result is status "no_rows_for_request" with the report's last published date, not an empty array. Dates are ISO (2026-10-22).

Find USDA AMS livestock price reports (Livestock Mandatory Price Reporting): national and regional direct slaughter cattle, boxed beef and cow-beef cutouts, hogs and pork, lamb. Filter by words in the title and/or species (cattle, beef, swine, pork, lamb). Returns report_id, report code, title, the sections each report has, and when AMS last published it. Use the report_id with ams_report. Livestock only (produce, grain, hay and cotton: ams_market_report_search); if nothing matches it says so and states what is not covered (it never returns a bare empty list).