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

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.