Livestock Mandatory Price Reporting Notices and Updates
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.
The LMR API User Guide is here.
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.
Find out more details on the reports to be released here.
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.
https://mpr.datamart.ams.usda.gov/services/v1.1/reports/XXXX/Detail?correctionsOnly=true
- 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, ……)
https://mpr.datamart.ams.usda.gov/services/v1.1/reports/XXXX/Detail?lastDays=X
- 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.