home / mytown-research

municipalities

Every tracked city, county, and school district. Facet by state or platform.

Data license: CC BY 4.0 · Data source: MyTown

3 rows where kind = "city", platform = "legistar-insite" and state = "CA" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: added_at (date), last_fetched (date)

state 1

  • CA · 3 ✖

platform 1

  • legistar-insite · 3 ✖

kind 1

  • city · 3 ✖
Link rowid id slug name ▼ state platform body_count added_at last_fetched country kind
3088 3088 3426 li-carson Carson CA legistar-insite   2026-07-13 04:24:49 2026-08-06 23:05:44 US city
3077 3077 3414 li-sfgov San Francisco CA legistar-insite   2026-07-13 04:12:09 2026-07-31 23:05:26 US city
3083 3083 3421 li-sanleandro San Leandro CA legistar-insite   2026-07-13 04:24:13 2026-08-04 21:06:33 US city

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "municipalities" ("id", "slug", "name", "state", "platform", "body_count", "added_at", "last_fetched", "country", "kind");
Powered by Datasette · Queries took 639.614ms · Data license: CC BY 4.0 · Data source: MyTown