municipalities

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

Data license: CC BY 4.0 · Data source: MyTown

28 rows where kind = "city", platform = "escribe" and state = "CA" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

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

state 1

platform 1

  • escribe · 28 ✖

kind 1

  • city · 28 ✖
Link rowid id slug name ▼ state platform body_count added_at last_fetched country kind
1919 1919 2129 pub-applevalley Apple Valley CA escribe   2026-07-05 00:04:57 2026-08-06 18:34:36 US city
1925 1925 2135 pub-arcata Arcata CA escribe   2026-07-05 00:04:57 2026-08-06 22:34:38 US city
1933 1933 2143 pub-arroyogrande Arroyo Grande CA escribe   2026-07-05 00:04:57 2026-08-06 22:33:56 US city
1926 1926 2136 pub-atascadero Atascadero CA escribe   2026-07-05 00:04:57 2026-08-06 22:36:31 US city
3031 3031 3367 pub-bakersfield Bakersfield CA escribe   2026-07-12 06:31:25 2026-08-06 22:34:18 US city
1859 1859 2068 pub-beaumont Beaumont CA escribe   2026-07-05 00:04:57 2026-08-06 22:35:55 US city
1870 1870 2079 pub-brentwood Brentwood CA escribe   2026-07-05 00:04:57 2026-08-06 22:35:58 US city
3033 3033 3369 pub-chulavista Chula Vista CA escribe   2026-07-12 08:59:29 2026-08-06 22:33:58 US city
1901 1901 2111 pub-corona Corona CA escribe   2026-07-05 00:04:57 2026-08-06 22:33:57 US city
1884 1884 2093 pub-coronado Coronado CA escribe   2026-07-05 00:04:57 2026-08-06 22:34:00 US city
1866 1866 2075 pub-fairfield Fairfield CA escribe   2026-07-05 00:04:57 2026-08-06 22:34:12 US city
1882 1882 2091 pub-hermosabeach Hermosa Beach CA escribe   2026-07-05 00:04:57 2026-08-06 22:36:25 US city
1905 1905 2115 pub-imperialbeach Imperial Beach CA escribe   2026-07-05 00:04:57 2026-08-06 22:36:32 US city
1903 1903 2113 pub-indianwells Indian Wells CA escribe   2026-07-05 00:04:57 2026-08-06 22:35:05 US city
1876 1876 2085 pub-lamesa La Mesa CA escribe   2026-07-05 00:04:57 2026-08-06 22:35:55 US city
3133 3133 3472 pub-lake-elsinore Lake Elsinore CA escribe   2026-07-13 04:33:15 2026-08-06 22:35:57 US city
1909 1909 2119 pub-lemongrove Lemon Grove CA escribe   2026-07-05 00:04:57 2026-08-06 22:33:56 US city
3238 3238 3595 pub-lynwood Lynwood CA escribe   2026-07-13 04:45:32 2026-08-06 22:35:57 US city
3035 3035 3371 pub-morenovalley Moreno Valley CA escribe   2026-07-12 08:59:48 2026-08-06 22:35:06 US city
1918 1918 2128 pub-morrobay Morro Bay CA escribe   2026-07-05 00:04:57 2026-08-06 22:35:07 US city
1886 1886 2095 pub-palmdesert Palm Desert CA escribe   2026-07-05 00:04:57 2026-08-06 22:33:59 US city
1915 1915 2125 pub-pasorobles Paso Robles CA escribe   2026-07-05 00:04:57 2026-08-06 22:35:06 US city
1860 1860 2069 pub-richmond Richmond CA escribe   2026-07-05 00:04:57 2026-08-06 22:36:31 US city
1927 1927 2137 pub-santamaria Santa Maria CA escribe   2026-07-05 00:04:57 2026-08-06 22:34:38 US city
1868 1868 2077 pub-solanabeach Solana Beach CA escribe   2026-07-05 00:04:57 2026-08-06 22:36:32 US city
1895 1895 2105 pub-sweetwater Sweetwater Authority CA escribe   2026-07-05 00:04:57 2026-08-06 22:35:08 US city
1934 1934 2144 pub-upland Upland CA escribe   2026-07-05 00:04:57 2026-08-06 22:33:56 US city
1904 1904 2114 pub-yorbalinda Yorba Linda CA escribe   2026-07-05 00:04:57 2026-08-06 18:34:35 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");