azhealthfail.com — An Arizona Healthcare-Accountability Hub with Source-Enforced Integrity

azhealthfail.com

A public accountability hub tracking Arizona health officials, legislators, campaign money, and votes — built on a schema that refuses to publish an unsourced claim.

  • PHP
  • MySQL
  • ETL
  • Data Sourcing
  • Editorial Integrity

Problem

The site makes pointed, named claims about real public officials, so credibility is the entire product. The problem was to build an accountability platform where a factual claim about a named person cannot reach the public page unless it carries a source — enforced structurally, not by editorial willpower alone.

Architecture

Built on the AzDesign framework and the generic content engine. Officials, a full ninety-member legislature roster, per-cycle campaign-money records, sponsored bills, and letter-grade assessments each live in their own sourced tables. The schema encodes the editorial rule: a sourced-record row requires a source reference, and case documents are served only when explicitly marked reviewed and published. A network layer ties the site to its sibling accountability projects, and a data-driven sitemap keeps it discoverable.

Outcome

A live hub where every dollar figure, bill, and grade is anchored to a shown source or is not published at all — a no-fabrication standard enforced by the database itself, with a public methodology page that explains how the grades are reached.


Start a project like this All case studies