A normalized SQLite database of every coded Pittsburgh Water board vote, running in your browser. Write SQL, or click a starter query. Nothing leaves the page.
meetings (24) · board_members (8) ·
questioned_resolutions (72) · resolution_questions (82, the
who-asked-what junction) · peer_boards.
Views: v_headline, v_questions_by_member.
Full schema in schema.sql; more examples in queries.sql.
Rebuild with python 03-harness/build_db.py.
python 03-harness/check.py.
Evidence archive ·
SHA-256 hashes ·
Provenance and Wayback ·
Coded data (CSV) ·
Download the database