municipalities

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

Data license: CC BY 4.0 · Data source: MyTown

49 rows where kind = "city", platform = "escribe" and state = "BC" 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

platform 1

  • escribe · 49 ✖

kind 1

  • city · 49 ✖
Link rowid id slug name ▼ state platform body_count added_at last_fetched country kind
1973 1973 2183 pub-abbotsford Abbotsford BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:50 CA city
2955 2955 3291 pub-acrd Area F (Alberni Highway) BC escribe   2026-07-07 15:27:24 2026-08-06 22:35:10 CA city
1971 1971 2181 pub-burnaby Burnaby BC escribe   2026-07-05 00:04:57 2026-08-06 22:35:29 CA city
2970 2970 3306 pub-crd Capital Regional District BC escribe   2026-07-07 15:30:54 2026-08-06 22:34:47 CA city
2015 2015 2225 pub-centralsaanich Central Saanich BC escribe   2026-07-05 00:04:57 2026-08-06 18:34:46 CA city
2010 2010 2220 pub-chetwynd Chetwynd BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:31 CA city
1998 1998 2208 pub-chilliwack Chilliwack BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:29 CA city
2013 2013 2223 pub-courtenay Courtenay BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:30 CA city
2957 2957 3293 pub-cvrd Cowichan Valley Regional District BC escribe   2026-07-07 15:27:58 2026-08-06 22:35:23 CA city
1929 1929 2139 pub-creston Creston BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:32 CA city
1877 1877 2086 pub-cumberland Cumberland BC escribe   2026-07-05 00:04:57 2026-08-06 18:34:46 CA city
1885 1885 2094 pub-delta Delta BC escribe   2026-07-05 00:04:57 2026-08-06 22:36:10 CA city
2954 2954 3290 pub-fvrd Fraser Valley Regional District BC escribe   2026-07-07 15:27:20 2026-08-06 22:34:33 CA city
2979 2979 3315 pub-goldriver Gold River BC escribe   2026-07-07 15:31:27 2026-08-06 22:34:15 CA city
1920 1920 2130 pub-hazelton Hazelton BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:31 CA city
2082 2082 2292 pub-hudsonshope Hudson's Hope BC escribe   2026-07-05 00:04:58 2026-08-06 22:34:33 CA city
2969 2969 3305 pub-ladysmith Ladysmith BC escribe   2026-07-07 15:30:50 2026-08-06 22:34:15 CA city
2068 2068 2278 pub-lakecountry Lake Country BC escribe   2026-07-05 00:04:58 2026-08-06 22:33:46 CA city
1999 1999 2209 pub-langford Langford BC escribe   2026-07-05 00:04:57 2026-08-06 22:35:31 CA city
2061 2061 2271 pub-lantzville Lantzville BC escribe   2026-07-05 00:04:58 2026-08-06 22:35:25 CA city
2968 2968 3304 pub-lionsbay Lions Bay BC escribe   2026-07-07 15:30:48 2026-08-06 18:34:45 CA city
2101 2101 2311 pub-mapleridge Maple Ridge BC escribe   2026-07-05 00:04:58 2026-08-06 22:35:26 CA city
2012 2012 2222 pub-merritt Merritt BC escribe   2026-07-05 00:04:57 2026-08-06 18:34:32 CA city
1867 1867 2076 pub-mission Mission BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:46 CA city
2102 2102 2312 pub-nanaimo Nanaimo BC escribe   2026-07-05 00:04:58 2026-08-06 22:35:28 CA city
2973 2973 3309 pub-newwestcity New Westminster BC escribe   2026-07-07 15:31:06 2026-08-06 22:34:47 CA city
2064 2064 2274 pub-northcowichan North Cowichan BC escribe   2026-07-05 00:04:58 2026-08-06 22:35:27 CA city
1937 1937 2147 pub-oliver Oliver BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:49 CA city
2962 2962 3298 pub-prrd Peace River Regional District BC escribe   2026-07-07 15:28:23 2026-08-06 18:34:44 CA city
1952 1952 2162 pub-peachland Peachland BC escribe   2026-07-05 00:04:57 2026-08-06 22:33:55 CA city
2977 2977 3313 pub-pemberton Pemberton BC escribe   2026-07-07 15:31:20 2026-08-06 22:34:48 CA city
1997 1997 2207 pub-penticton Penticton BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:30 CA city
2048 2048 2258 pub-pittmeadows Pitt Meadows BC escribe   2026-07-05 00:04:57 2026-08-06 22:35:24 CA city
1993 1993 2203 pub-portcoquitlam Port Coquitlam BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:46 CA city
1996 1996 2206 pub-portmoody Port Moody BC escribe   2026-07-05 00:04:57 2026-08-06 22:35:30 CA city
2980 2980 3316 pub-poucecoupe Pouce Coupe BC escribe   2026-07-07 15:31:30 2026-08-06 22:36:09 CA city
1989 1989 2199 pub-princegeorge Prince George BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:29 CA city
2959 2959 3295 pub-rdbn Regional District of Bulkley-Nechako BC escribe   2026-07-07 15:28:03 2026-08-06 22:36:09 CA city
2958 2958 3294 pub-rdek Regional District of East Kootenay BC escribe   2026-07-07 15:28:00 2026-08-06 22:34:57 CA city
2960 2960 3296 pub-rdffg Regional District of Fraser-Fort George BC escribe   2026-07-07 15:28:11 2026-08-06 22:34:32 CA city
2963 2963 3299 pub-rdos Regional District of Okanagan-Similkameen BC escribe   2026-07-07 15:28:27 2026-08-06 18:34:45 CA city
2089 2089 2299 pub-salmonarm Salmon Arm BC escribe   2026-07-05 00:04:58 2026-08-06 22:34:42 CA city
2046 2046 2256 pub-sechelt Sechelt BC escribe   2026-07-05 00:04:57 2026-08-06 22:35:24 CA city
2956 2956 3292 pub-scrd Sunshine Coast Regional District BC escribe   2026-07-07 15:27:39 2026-08-06 22:35:28 CA city
1896 1896 2106 pub-vernon Vernon BC escribe   2026-07-05 00:04:57 2026-08-06 22:35:29 CA city
1881 1881 2090 pub-victoria Victoria BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:48 CA city
2961 2961 3297 pub-rdco West Central Okanagan Electoral Area BC escribe   2026-07-07 15:28:23 2026-08-06 18:34:32 CA city
2062 2062 2272 pub-westkelowna West Kelowna BC escribe   2026-07-05 00:04:58 2026-08-06 22:35:22 CA city
2006 2006 2216 pub-westvancouver West Vancouver BC escribe   2026-07-05 00:04:57 2026-08-06 22:34:30 CA 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");