Gov Transparency Project/Methodology
← Home

Methodology

How the data is built

Every figure on this site is extracted from public records and linked back to the document it came from. Here is exactly where the data comes from, how it's processed, how meetings are scored, how often it updates, and what it can't tell you.

Sources

Two public sources, used for different things:

The extraction pipeline

  1. Discover. For each city we read the published meeting list and record pointers (URLs) to each agenda and minutes document. We store pointers, not copies.
  2. Parse. Council-approved check registers are parsed into individual payments; the state feeds are parsed into vendor and salary tables. Ledger accounts are mapped to funds (General, Water, Sewer, Capital, and so on).
  3. Link. Every payment, score, and figure carries a link to the source document, so any claim can be verified at its origin.

What we index per city

DatasetWhat it is
PaymentsCouncil-approved warrants from the check register, by vendor and fund.
VendorsPer-vendor annual totals from the state's vendor feed.
SalariesEmployee compensation reported to the state.
Budget & reportsAdopted budgets and audited financial reports (ACFR).
MeetingsIndexed council meetings with agenda and minutes pointers.
ScoresProcedural-transparency scores for reviewed meetings.
GRAMAReady-to-send public-records request templates.

How meetings are scored

Scored meetings get a 0–10 procedural-transparency rating. It measures whether a decision was made in a way a resident could follow, not whether the decision was good. Three things drive the score:

A caveat on "Not Applicable" spending

About half of the spending the state reports has no named vendor — it's filed as "Not Applicable" (payroll, statutory redaction, or under-threshold aggregation). We report named-vendor totals honestly and never present the redacted portion as if it were itemized. We wrote up what that label means, and what cities could do to reduce it, in this analysis.

How often it updates

The dashboards are refreshed on a regular automated schedule that re-pulls each city's data from the public sources and rebuilds the site. Each city page shows its data coverage range.

Limitations & corrections

The data is only as complete and timely as the public sources. State feeds lag, cities post minutes weeks after a meeting, and aggregates can hide detail. Where a city's reporting is incomplete, we say so rather than fill the gap with guesses. If a figure looks wrong, check its linked source first, then send a correction through the contact form on the home page.