AdvertiseDonate
Thursday, November 19, 2026
What’s happening across America.
Journal Signal · 400 East Pratt Street, 8th Floor, Baltimore, MD 21202

Latest stories

  1. Maryland Man Sentenced to Prison After Social Media Threats Against Trump
  2. Trilateral Summit Overtakes APEC Trade Goals
  3. Fairbanks district suspends two hockey teams as Wasilla police probe alleged assaults
  4. Botanic Garden Trains Mark 250th
  5. Putin, Trump, and Xi Meet in Shenzhen to Reshape Global Order
Tech · Pittsburgh

Pittsburgh Budget Explorer Turns 2027 City Financials Into Searchable Data

Developers used AI tools to convert hundreds of pages of city PDFs into an interactive database, though they caution the site is not an official government publication.

By Pedro Tanaka ·

Illustration for: Pittsburgh Budget Explorer Turns 2027 City Financials Into Searchable Data
Illustration generated for this article, not a news photograph.

Hundreds of pages of tables, narratives, and financial data comprise the City of Pittsburgh's proposed 2027 operating and capital budgets. PublicSource has converted this dense documentation into a searchable and sortable digital format to help residents track specific departmental spending without manually reviewing PDF files.

The project, known as the Pittsburgh Budget Explorer, extracts figures from the city's official documents. The data covers the proposed 2027 operating budget, which includes department budgets, revenue, personnel, grants, trust funds, and financial forecasts. It also includes the proposed 2027 capital budget, detailing infrastructure, facilities, parks, and equipment projects.

Developers relied heavily on Claude Code, an AI coding tool from Anthropic, to build the site. The AI handled code writing for data extraction, debugging, and the construction of the website layout, navigation, search functions, and visualizations. It also drafted labels and short factual descriptions of budget terms based strictly on the city's documents.

Max Chis, founder of Lemali Consulting, leads the technical side of the project. His Pittsburgh-based firm provides software engineering and technical services to local nonprofits and civic institutions. Chis is reachable via email at max@lemaliconsulting.com.

A team of one editor, one developer, and one journalist fact-checked the AI-generated work. They instructed the tool to stick to the budget documents and make its work easy to verify. When the team found an error, they had the AI identify and fix the same issue across the entire site before re-checking the changes.

The site is not an official publication of the City of Pittsburgh and has not been reviewed by city officials. Developers note that extracting data from PDFs is imperfect. Issues such as misaligned columns, missing data, inconsistent formatting, negative numbers, and footnotes can lead to misinterpretation. Users can verify figures by checking page references on the site against the original source documents.

In cases where a city budget PDF contains a clear labeling error that causes wrong or missing figures, the site corrects the label and notes the change on the affected table and section page. These corrections are made by the developers, not the city. The original source PDFs remain unchanged, and no dollar amount is altered. The extraction code, test suite, and website source code are available on GitHub for public review.

More Tech · Report a business · Got a Story?

Get Journal Signal in your inboxWhat’s happening across America. Free, a few times a week, unsubscribe any time.

Related stories

Get Journal Signal in your inboxWhat’s happening across America. Free, a few times a week, unsubscribe any time.