Two city councils, 502 listed public meetings, 1,763 legislative items in one year — and the free API that holds them goes dark for the cities that stop feeding it

The Granicus Legistar InSite API exposes each participating city's full legislative record — every governing body, every meeting, every matter — with no key required. Pulled this run (retrieved 2026-08-08) for a fixed 12-month window, July 1, 2025 through June 30, 2026, two cities publishing live records return the following. Seattle: the API lists 83 governing bodies. In the window, 24 distinct bodies held or listed a meeting, across 327 listed meetings. Of those 327, the API marks 75 "Cancelled" and 252 "Final" or "Revised" — so 252 meetings carried an agenda to completion and 75 were called off, a 23% cancellation rate. The City Council itself accounts for 55 listed meetings and the Council Briefing for 43; 13 bodies met 10 or more times. In the same window Seattle introduced 848 matters, of which 194 are Ordinances, 34 Resolutions, 308 Appointments (to boards and commissions), 203 Information Items, 47 Minutes and 43 Introduction & Referral Calendars. Oakland: the API lists 150 governing bodies. In the window, 24 distinct bodies met across 175 listed meetings, of which at least 30 are flagged cancelled in their agenda comment or body name, leaving roughly 145 held MODELED. The Rules & Legislation Committee alone accounts for 34 listed meetings. Oakland introduced 915 matters: 500 City Resolutions, 261 Reports and Recommendations, 111 Informational Reports and 43 Ordinances. Combined, two cities in one year: 502 listed meetings, roughly 397 of them held, and 1,763 matters introduced. The same API, queried the same way, returns a most-recent matter introduced on 2020-09-17 for San Francisco and 2023-11-10 for Long Beach — those cities' public feeds carry nothing newer.

The following is analysis, not fact. The number that matters is not any single count but the ratio between the record and the coverage. Two mid-size cities generated 502 scheduled public meetings across 48 body-instances in twelve months. A single reporter attending one meeting every weeknight — 52 weeks times 5 nights, 260 sittings a year, with no vacation and no overlap — could physically attend at most 52% of just these two cities' listed meetings, and only by covering nothing else MODELED. Most of these bodies overlap on the same weeknights, so the real reachable share is lower. This is the arithmetic behind "45% of local governing boards have zero reporters": the beat is not under-covered, it is structurally un-coverable one meeting at a time. The two cities also legislate in different grammars, and the counts show it. Seattle's binding output is concentrated in 194 Ordinances and its procedural life in 308 board-and-commission Appointments; Oakland's runs through 500 City Resolutions against just 43 Ordinances. Read naively this looks like Seattle "does more law." It does not follow: a resolution in one city and an ordinance in another can carry equivalent weight, and the instrument mix reflects each charter's drafting conventions, not the volume of governing. What the counts do show without interpretation is where each city's decisions physically live — a resident tracking Oakland by ordinance alone would miss 500 resolutions; one tracking Seattle by ordinance would miss the 308 appointments that seat the very boards nobody watches. The San Francisco and Long Beach gaps are the quietest finding. The method that enumerates Seattle and Oakland is only as live as the city's own publishing. When a city stops feeding the public API — or migrates off it — the outside record simply ends, silently, with no error and no notice. The infrastructure that makes this reporting possible is a municipal choice that can be revoked without a vote.

The strongest counter is that a raw matter count overstates legislative activity, and it partly does. A large share of both totals is administrative rather than substantive: of Seattle's 848 matters, 203 are Information Items and 47 are Minutes; of Oakland's 915, 111 are Informational Reports and 261 are staff Reports and Recommendations. Netting those out, the genuinely legislative core is closer to 228 items in Seattle (Ordinances plus Resolutions) and 543 in Oakland — still large, but not the headline figure. We report the full introduced count and the type breakdown so a reader can draw the line where they prefer. A second caution is on the cancellation and "held" numbers. Seattle's API uses a clean "Cancelled" agenda status, so its 75 cancellations and 252 held meetings are exact. Oakland's status vocabulary differs — it has no equivalent "Cancelled" state — so our 30 Oakland cancellations were detected from agenda comments and body names and are a floor, not a ceiling; Oakland's true cancellation count is likely higher and its "roughly 145 held" correspondingly lower MODELED. The two cities' held-meeting figures are therefore not measured identically. Finally, the San Francisco and Long Beach gaps prove the API is stale for those cities, not that the cities stopped meeting. Both plainly still govern; their records may live on a different portal or a newer system. The verifiable claim is narrow: this specific free endpoint, queried this way, returns nothing newer than 2025 for one and 2023 for the other.

From a statehouse vantage, the two cities' divergent instrument mixes are downstream of state law: California's municipal code leans on resolutions for routine authorizations that Washington charters handle by ordinance, so an ordinance-count comparison across state lines measures drafting convention as much as governing. And from the vantage of the roughly 90,000 US local-government units, Seattle and Oakland are the easy cases — large cities that publish a structured, machine-readable feed at all. The median board in this country posts a PDF, or nothing.

A local reporter covers one meeting: a contested rezone, a budget vote, a police-oversight hearing. What no single-meeting story can show is the shape of the whole calendar and the record it leaves. Reading all of it at once, three facts appear that no attendee carries out of the room. First, the two cities scheduled 502 public meetings in twelve months and a lone reporter working every weeknight could reach at most half of them — the gap is arithmetic, not effort. Second, Seattle scheduled and then cancelled 75 meetings, nearly one in four, so a resident planning around the posted calendar was wrong 75 times. Third, the instrument that seats the city's unwatched boards is itself unwatched: Seattle introduced 308 appointments to its 83 bodies in a single year. And the whole method rests on a fragile courtesy — the same free API that opens Seattle and Oakland to the last agenda item returns nothing for San Francisco after 2020, because a city can go dark on the public record without ever taking a vote to do it.