DEV Community

zeeshan hussain
zeeshan hussain

Posted on

Tracking concrete prices by US region with 30 lines of Python and FRED

Our concrete cost calculator gets the same question in different forms: "is this price normal?" A national average does not answer it well, because ready-mix concrete is priced locally. A truck can only drive so far before the load starts to set.

The Bureau of Labor Statistics publishes a producer price index (PPI) for ready-mix concrete split by Census region, and FRED serves it as plain CSV. No API key, no scraping. Here is the whole pipeline we used for our regional concrete price page.

The five series

Region FRED series
Northeast PCU327320327320A
Midwest PCU327320327320B
South PCU327320327320C
West PCU327320327320D
United States PCU327320327320

The regional indexes have a different base period from the national one, so the index levels cannot be compared with each other directly. Percentage changes can.

Fetch all five in one request

FRED's graph endpoint takes several series IDs separated by commas and returns one CSV with a column per series:

import csv, io, urllib.request

IDS = ["PCU327320327320A", "PCU327320327320B",
       "PCU327320327320C", "PCU327320327320D", "PCU327320327320"]
NAMES = ["Northeast", "Midwest", "South", "West", "United States"]

url = "https://fred.stlouisfed.org/graph/fredgraph.csv?id=" + ",".join(IDS)
req = urllib.request.Request(url, headers={"User-Agent": "Mozilla/5.0"})
text = urllib.request.urlopen(req).read().decode()

rows = {}
for r in csv.DictReader(io.StringIO(text)):
    month = r["observation_date"][:7]          # "2026-10"
    vals = [r[i] for i in IDS]
    if "." not in vals:                        # FRED marks gaps with "."
        rows[month] = [float(v) for v in vals]
Enter fullscreen mode Exit fullscreen mode

Two details matter. FRED uses . for a missing value, so skip those months rather than crash on float("."). And a plain User-Agent header avoids the occasional 403 from scripted requests.

Percent change, not index points

def pct(a, b):
    return (b / a - 1) * 100

base, latest = rows["2020-02"], rows["2026-10"]
for name, a, b in zip(NAMES, base, latest):
    print(f"{name:14} {pct(a, b):5.1f}%   $1,000 then = ${1000 * b / a:,.0f} now")
Enter fullscreen mode Exit fullscreen mode

February 2020 is the baseline because it is the last month before the pandemic disrupted supply chains. The output:

Northeast       36.7%   $1,000 then = $1,367 now
Midwest         47.6%   $1,000 then = $1,476 now
South           35.1%   $1,000 then = $1,351 now
West            39.6%   $1,000 then = $1,396 now
United States   39.1%   $1,000 then = $1,391 now
Enter fullscreen mode Exit fullscreen mode

The "$1,000 then" column is the part people actually use: it turns an index into a budget adjustment for an old quote.

Year by year, December to December

years = ["2020-12", "2021-12", "2022-12", "2023-12", "2024-12", "2025-12"]
for i, name in enumerate(NAMES):
    steps = [pct(rows[a][i], rows[b][i]) for a, b in zip(years, years[1:])]
    print(name, " ".join(f"{s:5.1f}" for s in steps))
Enter fullscreen mode Exit fullscreen mode
Region 2021 2022 2023 2024 2025
Northeast 4.0 9.4 8.7 3.5 3.7
Midwest 5.9 12.6 11.2 6.8 0.2
South 7.1 11.7 7.0 6.1 −1.4
West 8.6 17.7 2.7 1.6 1.0
United States 6.7 13.3 6.9 4.8 0.1

A few things stand out once the numbers are side by side:

  • 2022 was the big year everywhere, but the West took a 17.7% jump and then nearly flattened.
  • The Midwest kept climbing through 2023 and 2024 and ends up with the largest total rise, 47.6%.
  • The South actually fell 1.4% in 2025, the only regional decline in the series since 2020.
  • The national figure hides all of that. A flat-looking 0.1% for 2025 is the Northeast rising, the South falling and the rest roughly even.

Caveats

A PPI measures what producers receive, not what a contractor pays you. It tracks the direction and size of price changes, not the price per yard in your town. For a project budget, pair it with a local quote: use the index to sanity-check how far an old quote has drifted, and a calculator to get the volume right.

The full tables, the states in each region, and links to every series are on the regional concrete prices page. If you are pricing a pour, the concrete cost calculator compares bagged concrete with ready-mix for the same job.

Top comments (0)