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

4 rows where platform = "legistar" and state = "PA" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

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

state 1

  • PA · 4 ✖

platform 1

  • legistar · 4 ✖

kind 1

  • city 4
Link rowid id slug name ▼ state platform body_count added_at last_fetched country kind
138 138 153 allentownpa Allentown PA legistar   2026-07-04 21:32:52 2026-08-07 03:22:06 US city
209 209 231 erie Erie PA legistar   2026-07-04 22:33:59 2026-08-06 05:23:51 US city
5 5 5 phila Philadelphia PA legistar 100 2026-07-04 21:02:04 2026-07-28 14:25:57 US city
8 8 8 pittsburgh Pittsburgh PA legistar 15 2026-07-04 21:02:04 2026-08-05 15:26:26 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 136.119ms · Data license: CC BY 4.0 · Data source: MyTown