A complete list of 5,162 cities, municipalities, districts, towns, townships, villages, hamlets in Canada from Stats Canada's Census in 2016

Spreadsheet below is a complete list of 5,162 cities, municipalities, districts, towns, townships, villages, hamlets, etc. according to Statistics Canada (Stats Can) 2017, Population and Dwelling Count Highlight Tables - 2016 Census.

Spreadsheet below contains an analysis and all the Census subdivisions (CSD) for Canada, but you can get the source dataset from Statistics Canada directly (download^[2]).

But you must understand this does not include all places in Canada, for that we need 2 other datasets to be involved, the designated places and geographic place name datasets.

Firstly, what is a 

Census subdivision (CSD)^[3]?

Stats Can defines Census subdivision (CSD)^[4], but generally is term for municipalities which 

including cities, municipalities, districts, hamlets, cree village et c. There are 54 Census Subdivisions (CSD) types. NOT all of which are populated and thus does not show up in the Census data collected and therefore not in the spreadsheet/charts below. 

All Census Subdivision (CSD) Types Table

http://www12.statcan.gc.ca/census-recensement/2011/ref/dict/table-tableau/table-tableau-5-eng.cfm^[6]

Interesting CSDs are Summer District, Township and royalty, and Island Municipality!

List all Canadian Geographic Dimensions Datasets  

http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/hlt-fst/pd-pl/comprehensive.cfm^[7]

Some Interesting Finds in the CSD Dataset

Funny City/Town/Township/Hamlet/Village names 

Low, Joly, Mono, Webb, Zorra, Vonda, Zelma, O'Leary, Outlook, Zeballos, Ivujivik, Markinch, Spy Hill, Tehkummah, Quispamsis, Burns Lake, Pohénégamook, Whapmagoostui, Aroostook, Asphodel-Norwood, Hoodoo No. 401, Moosomin No. 121, Happy Valley-Goose Bay, Sainte-Madeleine-de-la-Rivière-Madeleine, Sainte-Thérèse-de-Gaspé, Summer Village of Golden Days, Summer Village of Ghost Lake, Saint-Hubert-de-Rivière-du-Loup, Sainte-Catherine-de-la-Jacques-Cartier and lastly Saint-Louis-du-Ha! Ha! 

Find and add your favourite in comment section below. See spreadsheet below.

Other Geographic Dimension Datasets of Interest

http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/hlt-fst/pd-pl/comprehensive.cfm^[8]

Some Interesting Finds in the Designated Places (DPL) Dataset (download)
Designated Places (DPL) is defined as a small community that does not meet the criteria used to define municipalities (not a CSD in other words).^[9]

Funny Designated Place Names

This were you find the infamous name Dildo, 

Newfoundland and Labrador

Some Interesting Finds in the Geographic Place Names Dataset (download^[10])
 

This dataset comes from Canada Centre for Mapping and Earth Observation, Natural Resources Canada. Geographic "Place Name (PN)^[11]" refers to selected names of active and retired geographic areas as well as names from the Canadian Geographical Names Data Base. 

There are 230,550 unique geographic place names.
 

Funny Geographic Place Names

This were you find the infamous name "Blow Me Down", Newfoundland and Labrador.

Other fun names are; 

Also Blow Me Down Bight, Tomahawk Bay, The Boot Leg Bay, Toadstool Island, Toadasses, Toad River Hot Springs Park, Tor Mountain, Tork 7, Zoot Lake and Sẁiẁs Park

Neat or Curious Places

Aklaktuk Pingo (a Pingo is Isolated, conical, ice-cored mound occurring in areas of permafrost)
 

Funny Creek Names in the Geographic Place Names dataset

There is no Schitt's Creek in Canada, but there is Schist Creek, Schiste Creek, and Etschitka, Scherf Creek, Schimmens Creek, Scherf Creek, Amazon Creek^[12]

and Blowhole Creek. But to top it all there is a Mashiter Creek. 

14,447 Creeks in all of Canada 

Interesting names ?yu?h Anta?t Teetshik Creek, 150 Yard Creek, Furry Creek, Tea, Creek, Tzela Creek, Zig Zag Creek, Xenia Creek

Fun Find
Can someone confirm these names - http://www.cbc.ca/stillstanding/blog/the-most-hilarious-town-names-in-canada (note, most of these live in ^[13]designated places and geographic place name datasets)

Fun Stats of CSD Dataset, in Spreadsheet below

There are no cities / CSDs with a name of length of 1 in Canada.
There are no cities /CSDs with a name of length of 2 in Canada.
There are 4 cities / CSDs with a name of length of 3 in Canada.

Table 1
   Length  Name                                         CSD

3	Emo	Township of
3	Tay	Township of
3	Low	Township
3	Oka	Municipality

Some Edge Cases of City Name Lengths in Canada

Longest CSD name in Canada has 50 characters.
Indian reserve of "Buffalo River Dene Nation 193 (Peter Pond Lake 193)"

Table 2
Length         Count

3	4
4	34
5	145

47	1
49	1
51	3

Fun Find ? Can someone confirm these names - http://www.cbc.ca/stillstanding/blog/the-most-hilarious-town-names-in-canada^[14]
(this is not accurate, most of these live in designated places and geographic place name datasets)

Excel Spreadsheet of 5,162 cities, municipalities, districts, towns, townships, villages, hamlets, etc. aka CSDs in Canada according Statistics Canada 2017, Population and Dwelling Count Highlight Tables - 2016 Census.

This is a LIVE spreadsheet, you can play with it and screw it up. But next reload will refresh with new data. See my post^[15] on how embed this on your site.