Livestock Mandatory Price Reporting Notices and Updates
May 02, 2022 - NOTICE on LMR API Changes
Changes are coming to the LMR API May 30, 2022
In an effort to address extensive user feedback and be consistent in LMR reporting, all fields that are contained on LMR PDF reports will now be available in the LMR API and Web Service.
Previously, there were certain fields such as “Week Ago” or “Year Ago” that were on PDF reports but not consumable in the LMR API or Web Service. Effective May 30, 2022, those fields (and others) will be available.
The LMR Team strongly encourages users review the attached Excel file to identify what fields are being added to which report. The Excel file has each commodity broken up on an individual sheet with the fields being added. An image is provided to show the fields as they will appear.
If you have any questions, please email the LMR team @ email@example.com.
April 11, 2022
The U.S. Department of Agriculture’s (USDA) Agricultural Marketing Service (AMS) will host a cattle industry listening session to inform the development of a Cattle Contracts Library Pilot Program. The session will be held on Thursday, April 21, 2022, from 8:00 a.m. – 5:30 p.m. CT. Interested stakeholders can participate virtually or in person at the USDA National Grain Center located at 10383 North Ambassador Drive, Kansas City, Mo. 64153.
The Consolidated Appropriations Act of 2022 directed AMS to create a Cattle Contracts Library Pilot Program to increase market transparency for cattle producers. This listening session provides an open forum for industry stakeholders to share their feedback and help identify expectations for the Pilot Program. The intent of this session is to hear from industry, and as such there will not be time for a discussion or questions. AMS is specifically interested in insights on the following questions:
- What information should a Cattle Contracts Library include to be most helpful to cattle marketers?
- What concerns do you have with USDA releasing a Cattle Contracts Library?
- What format should be used to present the information contained in a Cattle Contracts Library?
During the session, AMS will provide an overview of the Cattle Contracts Library Pilot Program, then participants will be given an opportunity to provide feedback. Given the short notice and as an extension of this session, AMS will accept written comments through April 28, 2022. Written feedback can be submitted to Wash.LPGMN@usda.gov. All written feedback and a recording of the session will be posted on the AMS website.
This meeting will be held in a federal facility, so in-person attendees must register in advance by sending an email to Wash.LPGMN@usda.gov by Monday, April 18, 2022. Space is limited and each industry association is asked to send only one or two representatives. For virtual attendees, the meeting will be broadcasted live as a webinar. Please register in advance at: https://www.zoomgov.com/webinar/register/WN_QKvnrWIlTNevadyBpFbuTw. After registering, you will receive a confirmation email with additional instructions. AMS will closely monitor the COVID-19 Community Level and make any adjustments prior to the meeting following Safer Federal Workforce Task Force guidance for public meetings. For additional information, contact Michael Sheats, Livestock, Poultry, and Grain Market News Director, at 202-690-3145.
March 16, 2022
On 18 MAR 2022 from 6pm CST to 19 MAR 2022 6am CST the LMPRS system will be unavailable for system upgrades.
January 18, 2022
On January 21, 2022 there will be two changes introduced to the LMR Datamart, Webservice and API.
- There will be a "is_correction" field added to all Header/Summary tables. This field will indicate if that report has had a correction issued. Users can filter on this attribute and only pull corrections if desired. The field will not be in a report section tables.
- There will also be an change to the (LM_HG216, LM_HG217, and LM_HG218) reports. The change adds comparison data to each region of each report that will show the price changed from the previous day’s report. This change will be seen on Negotiated carcass and live only. The field will be named "price_chg".
September 23, 2021
- On October 1, 2021 LPGMN will release a slightly revised (National Weekly Comprehensive Lamb Carcass (Fri) (PDF) (LM_XL555) that removes the summary section and introduces a new line in the data section of the report. This new line will include both a total Head Count and total Weighted Average at the bottom of the data section.
August 11, 2021
The LMR API now supports “sendEmail” and “Email=” attribute. Any standard API request can now be sent to the LMR API with these attributes and an email will be send to that address with a link to download the zip file of your data request. The zip file will contain one or more CSV files. The URL is only good for 24hrs. The email address can be any email address.
For API requests where “allsections” is used. The zip file will contain separate CSV files for each section of the report.
August 5, 2011
The U.S. Department of Agriculture (USDA) today announced that beginning Monday, August 9, 2021, it will issue two new USDA Market News reports based on Livestock Mandatory Reporting data that will provide additional insight into formula cattle trades and help promote fair and competitive markets. This action is one piece of USDA’s efforts to deliver on President Biden’s Executive Order 14036 on Promoting Competition in the American Economy, which directed USDA to, among other things, “enhance price discovery, increase transparency, and improve the functioning of the cattle and other livestock markets.” The Executive Order on Competition launched a whole-of-government effort to promote competition, including 72 specific agency initiatives. USDA has already undertaken several other initiatives under the Executive Order, including announcing investments of at least $500 million in meat processing capacity, new rulemakings under the Packers & Stockyards Act, and a top-to-bottom review of the “Product of USA” label.
January 05, 2021
If you were consuming any of these reports (LM_HG 200, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 230, 231, 232, 233) either through the web service or API, you will need to make changes to your API process. These reports were discontinued on 04 JAN 21 and replaced with these comprehensive reports. The new reports (LM_HG 216, LM_HG217, LM_HG218, and LM_HG234) have fundamentally different sections and will require you to remap to new Slug ID’s and Sections.
- The prior day purchase reports (LM_HG200, 204, 207, & 208) are found on the LM_HG218. New Slug ID 3458
- The morning purchase reports (LM_HG202, 205, 209, & 211) are found on the LM_HG216. New Slug ID 2674
- The afternoon purchase reports (LM_HG203, 206, 210, & 212) are found on the LM_HG217. New Slug ID 2675
- The sow reports (LM_HG230, 231, 232, & 233) are found on the LM_HG234. New Slug ID 3452
December 17, 2020
AMS has released new features to the LMR API that will help users identify “Corrections”. Access the LMR API User Guide for more details.
- For example, a user can make an API call that returns reports that are only Corrections to a previously released report.
- The second example allows users to request for only Corrections since a particular date. https://mpr.datamart.ams.usda.gov/services/v1.1/reports/XXXX/Detail?correctionsOnly=true&anyChangesSince=MM/DD/YYYY
- The third example allows users to request the current Detail subsections for a report published in the last X days.
(X is a positive integer: 1, 2, ……)
- The fourth and final example will allow users to request the current Detail subsections for the X most recent XXXX report ID published reports (X is a positive integer: 1, 2, ……) https://mpr.datamart.ams.usda.gov/services/v1.1/reports/XXXX/Detail?lastReports=X
Note: The URL's above are samples and are currently non-functioning. The "XXXX" represents the Slug ID of an LMR report.
December 7, 2020
Beginning Dec. 7, 2020, the U.S. Department of Agriculture’s (USDA) Agricultural Marketing Service (AMS) will publish new Daily Prior Day Hog Purchase Reports (LM_HG218 (pdf) and LM_HG234 (pdf)) through its Livestock Mandatory Reporting Program (LMR). These all-inclusive USDA Market News reports will provide customers with more accessible data for easier market analysis and replace the individual national and regional reports, which will be discontinued effective Jan. 4, 2021. During the transition to the new format, customers will continue to have seamless access to this reliable and unbiased data. Historical data will continue to be available using various platforms such as DataMart, LMR Web Service (pdf) and the My Market News API.
Similar to the Daily Direct Hog Reports (LM_HG216 and LM_HG217), the new reports will combine all regional purchase information from the Eastern Cornbelt, Iowa-Minnesota and Western Cornbelt Daily Prior Day Purchase Reports with national information into a single report versus four separate reports. The reports will show purchase volumes by purchase type for barrows and gilts as well as sows and boars on a carcass and live basis, along with volume data for the previous week and year, and state of origin. Moreover, customers will see an improved Negotiated Hog Purchase Matrix (pdf) for barrows and gilts as well as additional purchase type data for all classes, specifically Other Market Formula and Other Purchase Arrangement purchases, not previously reported.
To access direct swine reports, visit: www.ams.usda.gov/market-news/swine-direct-reports. For more information on LMR, visit: www.ams.usda.gov/rules-regulations/mmr. For additional information, contact Jim Bernau, LMR Field Chief, at (515) 284-4460.
November 11, 2020
Updated LMR API User Guide posted. (https://mpr.datamart.ams.usda.gov/USDA%20LMPRS%20API%20User-Guide.pdf). V2.2 of User Guide is most current.
October 15, 2020
AMS modified the database field names contained in the LM_PK603 “Change From Prior Day” & “5 Day Average Cutout and Primal” sections. Previously, they were named with less than descriptive names. Industry users requested that we name then more realistically. Sample links to both of those revised sections are shown below.
- https://mpr.datamart.ams.usda.gov/services/v1.1/reports/2499/Change From Prior Day?q=report_date=10/19/2020
- https://mpr.datamart.ams.usda.gov/services/v1.1/reports/2499/5-Day Average Cutout and Primal Values?q=report_date=10/19/2020
October 14, 2020
The following discontinued legacy reports were added to LMR API for consumption. These reports are not available on My Market News website, as they are discontinued and cannot be retrieved using the "Service Previous Reports" feature.
- AMS_3450 National Daily Lamb Report - Committed and Delivered Lambs (TXT) (LM_LM301)
- AMS_3451 National Daily Lamb Carcass Report (TXT) (LM_XL501)
September 22, 2020
AMS modifies the XML Web Service and LMR API to allow for the consumption of the LM_PK650 Primal Values in the Volume Section. Previously, they were not available.
September 16, 2020
AMS makes corrections to the rounding issue. Now the official reports, the XML web service and the new LMR API round the same.
June 1, 2020
AMS clarifies in the LMR API User Guide that the API limit data extracts to 100,000 records. This is done to ensure that the API is available and operational for all to use.
April 30, 2020
Starting on the afternoon of May 4, 2020, LMR will begin releasing report data on LMR Datamart, LMR Web Service and the LMR API in real time. Prior to this change, report data was available at the top of the hour for most reports. The removal of Text reports on LMR necessitated this change. This change will bring both voluntary and mandatory report release processes in sync.
- Note: With this change, there will be a few minutes delay for the actual PDF report to be uploaded to the AMS website and MyMarketNews. That will be resolved in the coming month.
April 23, 2020
Recent security patching of LMR servers on 04.16.20 has caused technical problems with Text Report generation. PDF report generation remains operational. Over the course of the last few days, an attempt to resolve this issue was undertaken without success. The security protocols have been re-enabled on the LMR server and text reports will no longer be offered.