This is the Pittsburgh mayor’s proposed 2027 budget, pending City Council adoption (expected in December). Figures may change before the budget is adopted.

About Pittsburgh Budget Explorer

How the site was built, what role AI played and what you should keep in mind when using it.

By Max Chis

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:

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.

No corrections have been made to any of the budget documents this site carries.

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.