municipalities

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

Data license: CC BY 4.0 · Data source: MyTown

11 rows where kind = "city", platform = "civicclerk" and state = "VA" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

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

state 1

platform 1

  • civicclerk · 11 ✖

kind 1

  • city · 11 ✖
Link rowid id slug name ▼ state platform body_count added_at last_fetched country kind
2701 2701 3036 berryvilleva Berryville VA civicclerk   2026-07-07 00:53:48 2026-08-07 03:32:16 US city
2704 2704 3039 charlottesvilleva Charlottesville VA civicclerk   2026-07-07 00:54:02 2026-08-07 03:40:39 US city
2706 2706 3041 surrycova Claremont VA civicclerk   2026-07-07 00:54:13 2026-08-06 22:23:33 US city
2708 2708 3043 danvilleva Danville VA civicclerk   2026-07-07 00:54:18 2026-08-07 03:48:05 US city
2709 2709 3044 farmvilleva Drakes Branch VA civicclerk   2026-07-07 00:54:26 2026-08-07 03:52:48 US city
4252 4252 4621 herndonva Herndon VA civicclerk   2026-07-16 04:47:43 2026-08-07 03:58:52 US city
2282 2282 2496 lynchburgva Lynchburg VA civicclerk   2026-07-05 20:44:17 2026-08-07 04:09:08 US city
170 170 186 norfolkva Norfolk VA civicclerk   2026-07-04 21:47:39 2026-08-06 22:10:28 US city
2716 2716 3051 petersburgva Petersburg VA civicclerk   2026-07-07 00:55:30 2026-08-06 22:13:44 US city
2719 2719 3054 rockymountva Rocky Mount VA civicclerk   2026-07-07 00:55:40 2026-08-06 22:17:50 US city
2720 2720 3055 smithfieldtwpva Smithfield VA civicclerk   2026-07-07 00:55:43 2026-08-06 22:20:44 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");