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

7 rows where kind = "city", platform = "civicclerk" and state = "TN" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

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

state 1

  • TN · 7 ✖

platform 1

  • civicclerk · 7 ✖

kind 1

  • city · 7 ✖
Link rowid id slug name ▼ state platform body_count added_at last_fetched country kind
3039 3039 3375 clarksvilletn Clarksville TN civicclerk   2026-07-12 09:00:42 2026-08-07 03:43:16 US city
4130 4130 4499 columbiatn Columbia TN civicclerk   2026-07-15 02:13:24 2026-08-07 03:44:55 US city
5845 5845 64441 farraguttn Farragut TN civicclerk   2026-07-22 23:52:04 2026-08-07 03:52:56 US city
5848 5848 64444 gallatintn Gallatin TN civicclerk   2026-07-22 23:52:19 2026-08-07 03:54:49 US city
2746 2746 3082 goodlettsvilletn Goodlettsville TN civicclerk   2026-07-07 01:56:34 2026-08-07 03:56:01 US city
6259 6259 150962 lakelandtn Lakeland TN civicclerk   2026-07-27 12:02:48 2026-08-07 04:05:31 US city
2301 2301 2633 smyrnatn Smyrna TN civicclerk   2026-07-05 23:33:56 2026-08-06 22:20:49 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 212.512ms · Data license: CC BY 4.0 · Data source: MyTown