Text graphic for Pittsburgh’s Public Source Budget Explorer, titled “Proposed 2027 budget,” with the tagline “Pittsburgh’s budget, as searchable tables and charts” and the URL budget.publicsource.org.

Pittsburgh’s budget shows how the city plans to spend public money. But if you want to know how much is set aside for a particular department or service, you may have to sift through pages of tables. We built this visualization to make those numbers easier to find and compare. We used AI to help write the code. You can read more in Public Source’s AI policy about our approach to AI and the safeguards we follow.

What is the Pittsburgh Budget Explorer?

The city publishes its budgets as PDF documents including hundreds of pages of tables, narratives and financial data. This project extracts that data from the PDFs and presents it in searchable, sortable and visual formats.

What role did AI play?

Claude Code, an AI coding tool made by Anthropic, was used extensively throughout the project for:

  • Writing code to extract information from the city’s PDFs
  • Debugging the extraction process, tables and layout 
  • Building the website, including the layout, navigation, search functionality and visualizations
  • Drafting labels, short factual descriptions and definitions of budget terms using the city’s budget documents

We gave Claude Code instructions to stick to the budget documents and make its work easy to check. An editor, a developer and a journalist who fact-checked the project reviewed the work. When they found an error, they had Claude Code look for and fix the same problem throughout the site, then checked the fixes.

Important caveats about accuracy

This site is not an official City of Pittsburgh publication and hasn’t been reviewed by city officials. For authoritative budget figures, always refer to the official budget documents.

Extracting data from PDFs isn’t perfect. Misaligned columns, missing data, inconsistent formatting, negative numbers and footnotes can lead to misinterpretation.

The section pages on this site include page references that correspond to the original budget documents. If you spot something that looks wrong, you can verify it against the source PDF and email Public Source’s managing editor at rich@publicsource.org. 

Source data

The data for this site comes from:

A Sankey diagram showing funding sources, project types, and the distribution of capital improvement project spending across fiscal years 2027 through 2032.
Pittsburgh Budget Explorer’s flow chart of sources and uses, from Pittsburgh Mayor Corey O’Connor’s 2027 capital budget as proposed on Nov. 9, 2026. (Screenshot of visualization by Max Chis/Pittsburgh’s Public Source)

The extraction code, test suite and website source code are available on GitHub.

Corrections we made to the source documents

Now and then, a city budget PDF contains a labeling error that, taken literally, makes this site show wrong or missing figures. Where the evidence is clear, Pittsburgh Budget Explorer corrects the label and says so on the affected table and section page. These corrections are ours, not the city’s. The source PDFs are unchanged, and only column headings are relabeled. No dollar amount is altered. 

Max Chis is the founder of Lemali Consulting, a Pittsburgh business that provides software engineering and technical services for local nonprofits and civic institutions, and can be reached at max@lemaliconsulting.com.

Help us keep telling stories like this one. Your gift is MATCHED up to 12x!

We’re Pittsburgh’s Public Source, an independent, nonprofit newsroom. That means we rely on donations from readers like you to help us report accurate, timely and impactful stories for the Pittsburgh region — available to everyone without paywalls.

And right now, you have a limited-time opportunity to supercharge your support. Through Dec. 31, our generous local match pool donors will match your new monthly donation 12 times or double your one-time gift until we reach our $80,000 goal!

We've seen our journalism prompt widespread change in the Pittsburgh region — but none of it would be possible without the support of our community. If you found this story valuable, consider "paying it forward" by making a gift today.