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

10 rows where kind = "city", platform = "civicclerk" and state = "AL" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

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

state 1

  • AL · 10 ✖

platform 1

  • civicclerk · 10 ✖

kind 1

  • city · 10 ✖
Link rowid id slug name ▼ state platform body_count added_at last_fetched country kind
3406 3406 3764 fairhopeal Fairhope AL civicclerk   2026-07-14 06:24:31 2026-08-07 03:52:13 US city
5864 5864 64460 leedsal Leeds AL civicclerk   2026-07-22 23:53:07 2026-08-07 04:06:56 US city
3136 3136 3475 madisonal Madison AL civicclerk   2026-07-13 04:33:39 2026-08-07 04:09:39 US city
2260 2260 2474 mobileal Mobile AL civicclerk   2026-07-05 20:42:34 2026-08-07 04:13:28 US city
5876 5876 64475 muscleshoalsal Muscle Shoals AL civicclerk   2026-07-22 23:53:38 2026-08-06 22:09:00 US city
3410 3410 3770 opelikaal Opelika AL civicclerk   2026-07-14 07:03:05 2026-08-06 22:11:43 US city
2826 2826 3162 orangebeachal Orange Beach AL civicclerk   2026-07-07 03:52:10 2026-08-06 22:11:46 US city
5884 5884 64484 pelhamal Pelham AL civicclerk   2026-07-22 23:53:56 2026-08-06 22:13:35 US city
3415 3415 3776 summerdaleal Summerdale AL civicclerk   2026-07-14 07:23:14 2026-08-06 22:23:12 US city
2286 2286 2500 vestaviahillsal Vestavia Hills AL civicclerk   2026-07-05 20:52:56 2026-08-06 22:25:40 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 151.927ms · Data license: CC BY 4.0 · Data source: MyTown