Open me first

The Pittsburgh Water Deliberation Record

Everything in the package, one click away. Reporting and data by Brian Nuckols for Public Source.

▶ The story

Start here. The full record, 228 votes and not one dissent, with the charts and the peer app built in. This is the piece to send an editor.

Read the story →

The charts

Five charts: the unbroken record, the 40-question spike, $871M, the peer gap, who asked.

Open →

The peer app

The empirical test, board by board. Pittsburgh Water against Niagara Falls and North Harris County.

Open →

The sourcing

Nine named human sources, organized by role, each with the claims they carry. One full transcript included.

Open →

The fact-check ledger

Every claim as a filterable card — data, watchdog, utility, context — each with a verdict and links to the source and the archived copy.

Open the ledger →

The database

A normalized SQLite database of every coded vote, queryable in the browser. Write SQL, or click a starter query; every headline figure recomputes from it.

Query the database →

The spreadsheet

The multi-tab workbook: six tabs, from the meeting census to the sources. Downloads.

Download the .xlsx →

The written record

The evidence archive

Check the work. Nothing here asks for trust. From the package folder:
python 03-harness/check.py
It re-hashes every archived source and recomputes 228, 223, $871.25M, and the 69% peer rate, then prints one verdict.

If the links above do not open, you are viewing this file directly. Run view.bat (double-click it) or python -m http.server in this folder, then open http://127.0.0.1:8137/. The Markdown docs render best on GitHub; locally they open as plain text.