Cattle auction prices in R
USDA AMS cattle auction reports come as PDFs and text. Our API gives you one row per lot as CSV, so it loads into a data frame with one line of R.
Base R
url <- paste0("https://api.kossinlabs.com/v1/prices?state=KS&class=STEERS",
"&weight_min=500&weight_max=700&limit=200",
"&format=csv&api_key=kl_free_demo_2026")
df <- read.csv(url)
df <- df[grepl("Cwt", df$unit), ]
df$value <- df$head_count * df$price_avg
daily <- aggregate(cbind(head_count, value) ~ report_date, data = df, FUN = sum)
daily$avg_cwt <- round(daily$value / daily$head_count, 2)
tail(daily[, c("report_date", "head_count", "avg_cwt")])
That's a head-weighted average $/cwt per sale date for Kansas feeder steers, 500 to 700 lb. kl_free_demo_2026 is a free demo key for trying it out.
With readr and dplyr
library(readr)
library(dplyr)
lots <- read_csv(url, show_col_types = FALSE)
lots |>
filter(grepl("Cwt", unit)) |>
group_by(report_date) |>
summarise(head = sum(head_count),
avg_cwt = round(sum(head_count * price_avg) / head, 2)) |>
arrange(desc(report_date))
Weighting by head keeps a 5-head lot from counting as much as a 300-head one.
What one lot looks like
A real row from Winter Livestock (KS) on Nov 11, 2026:
auction_name,state,report_date,class_name,grade,unit,head_count,weight_avg,price_avg,comments
Winter Livestock,KS,2026-11-11,STEERS,Medium and Large 1,Per Cwt / Actual Wt,35,516,497.6,Fancy
(Some columns left out to fit.) Rough lot value is (weight_avg / 100) * price_avg * head_count. Check the unit first, because some replacement lots are priced per head. More on units: cattle price per cwt.
Filters
state: two-letter state, like KS or TX.class: STEERS, HEIFERS, BULLS, COWS and so on, as AMS writes them.weight_min/weight_max: weight band in pounds.date_from/date_to: YYYY-MM-DD.auction: one barn.limitandoffsetpage through results.
Full list and the OpenAPI spec: api.kossinlabs.com. Other ways in: Python, Google Sheets, plain CSV.
Your own key
The demo key is shared. Get your own free key in one click, or Starter is $29/mo for higher limits: subscribe. 30-day money-back guarantee. Product page: cattle auction prices API. Source: USDA AMS Livestock, Poultry & Grain Market News (public). We are not affiliated with USDA.