Skip to main content

GTI.i_view()

Show the table filtered and sorted, as readers first see it.

Usage

Source

GTI.i_view(
    filter=None,
    sort=None,
    hidden=None,
    group_by=None,
)

The table is first shown with the rows that filter= keeps, in the order sort= gives them, without the columns hidden= hides, and with the rows grouped by the column group_by= names, which readers can then change (with the column filters, sort buttons, and the bar’s “Columns” and “Group rows” panels) or clear. Rows stay within their row groups, as they do when readers sort the table, and a table whose stub has cells merged across rows is shown as it is. Without arguments, the table is shown with all its rows and columns, in order (the default).

Parameters

filter: str | dict[str, Any] | None = None

The filters, as a query: {"and": [clauses]}, where a clause is a dictionary with a column ("col"), an operation ("op"), and a value ("value"), and keeps the rows that it’s true of. A clause’s column needs a filter (see i_cols_filter()) of a type that has its operation: "contains" for a text filter (the value is the text, matched as readers’ typing is), or "matches" (the value is a regular expression, which has a match in the text a cell shows, as it is: with its case and accents), "in" for a facet (a list of values, with None for a missing value), and "gte" (at least), "lte" (at most), "gt" (more than) and "lt" (less than) for a range (a number) or a date filter (a date, as "2015-06-15": for a column of dates and times, its midnight, so "gt" keeps 09:30 that day). A range or date filter has "top_n" and "bottom_n" too, whose value is a whole number, n, at least 1: they keep the rows with the n largest (or smallest) values of all the table’s rows, and those tied with the n-th (so {"col": "population_2021", "op": "top_n", "value": 10} keeps the ten most populous, and any tied with the tenth), but not a missing value, NaN or an infinity. A "matches" pattern is in the part of regular expressions’ syntax that the browser, Polars, Pandas and PyArrow read alike: characters (\ before punctuation for the character itself), ., ^ and $ (the start and end of the text), classes as [a-z] and [^0-9], \d, \w and \s (ASCII’s), groups ((...) or (?:...)) and |, and repeats (*, +, ?, and {n,m}); a pattern starting with (?i) ignores case. A clause {"col": ..., "op": "is_null"}, without a value, keeps the rows whose value is missing (None, or NaN in a column of floats), in a column with any type of filter. A column can have one clause of each operation. With None (the default), the rows aren’t filtered.

A part of the query can be a group instead of a clause: {"or": [parts]} keeps the rows that any of its parts keeps, {"and": [parts]} those that all of them keep, and {"not": part} those that its part doesn’t keep (a row whose value is missing, which a clause doesn’t keep, is kept by "not"). Groups can be in groups, and a column can have one clause of each operation in each "and". The column filters show the query’s clauses, and the bar below the table shows each group (and each "is_null", "matches", "gt", "lt", "top_n" and "bottom_n" clause), which readers can edit as text, or remove.

The query can be written as text instead: clauses joined by and, each a column name and then contains and a string, matches and a pattern between slashes, in and values in parentheses, >=, <=, > or < and a number (or a date in double quotes), top or bottom and a whole number, or is null (e.g., 'status in ("single-tier") and population_2021 >= 10000', "name matches /^st\./i", "population_2021 top 10", or "population_2016 is null"; is not null is not and is null, and so are not in, not contains and not matches, as in 'status not in ("city")'). Strings are in double quotes, and values are written as in JSON (null for a missing value, true and false). A pattern’s flag i is its (?i), and a / in it is escaped (\/) but in a class. A column name that isn’t letters, digits and underscores goes in backticks (`Name of town`). Groups are written with or, not and parentheses, not binding tighter than and, and and tighter than or (e.g., 'population_2021 >= 10000 and (status in ("lower-tier") or not name contains "ton")').

sort: str | list[str] | None = None

The columns to sort by: a column name, or a list of them (the first sorts the rows, the next sorts the rows that tie, and so on), each in ascending order, or descending with a - before its name (e.g., "-population_2021"). Missing values are last. The columns can be sorted even if readers can’t sort them (i_sorting(False), or i_cols_controls(sortable=False)). With None (the default), the rows keep their order.

hidden: SelectExpr = None

The columns to hide, which readers can show again: a column name, a list of them, or a selector (e.g., Polars’ cs.numeric()). Readers have to be able to hide them (see i_cols_controls(hideable=True)). With None (the default), none are hidden.

group_by: str | None = None
The column to group the rows by, which readers can change: a column name. Readers have to be able to group the rows by it (see i_cols_controls(groupable=True)). With None (the default), the rows aren’t grouped.

Returns

GTI
The GTI object is returned.

Examples

Here’s a table of Ontario’s municipalities, first showing the single-tier ones with at least 10,000 people, most populous first. Readers can change the filters (or clear them) in the column labels or the bar below the table, and the sort with the sort buttons.

from great_tables import GTI
from great_tables.data import towny

(
    GTI(towny[["name", "status", "population_2021"]], rowname_col="name")
    .fmt_integer(columns="population_2021")
    .i_cols_filter(columns=["status", "population_2021"])
    .i_view(
        filter={
            "and": [
                {"col": "status", "op": "in", "value": ["single-tier"]},
                {"col": "population_2021", "op": "gte", "value": 10000},
            ]
        },
        sort="-population_2021",
    )
)
status population_2021
Addington Highlands lower-tier 2,534
Adelaide Metcalfe lower-tier 3,011
Adjala-Tosorontio lower-tier 10,989
Admaston/Bromley lower-tier 2,995
Ajax lower-tier 126,666
Alberton single-tier 954
Alfred and Plantagenet lower-tier 9,949
Algonquin Highlands lower-tier 2,588
Alnwick/Haldimand lower-tier 7,473
Amaranth lower-tier 4,327
Amherstburg lower-tier 23,524
The Archipelago single-tier 979
Armour single-tier 1,459
Armstrong single-tier 1,199
Arnprior lower-tier 9,629
Arran–Elderslie lower-tier 6,913
Ashfield–Colborne–Wawanosh lower-tier 5,884
Asphodel–Norwood lower-tier 4,658
Assiginack single-tier 1,008
Athens lower-tier 3,042
Atikokan single-tier 2,642
Augusta lower-tier 7,386
Aurora lower-tier 62,057
Aylmer lower-tier 7,699
Baldwin single-tier 579
Bancroft lower-tier 4,065
Barrie single-tier 147,829
Bayham lower-tier 7,096
Beckwith lower-tier 9,021
Belleville single-tier 55,071
Billings single-tier 753
Black River-Matheson single-tier 2,572
Blandford-Blenheim lower-tier 7,565
Blind River single-tier 3,422
The Blue Mountains lower-tier 9,390
Bluewater lower-tier 7,540
Bonfield single-tier 2,146
Bonnechere Valley lower-tier 3,898
Bracebridge lower-tier 17,305
Bradford West Gwillimbury lower-tier 42,880
Brampton lower-tier 656,480
Brant single-tier 39,474
Brantford single-tier 104,688
Brethour single-tier 105
Brighton lower-tier 12,108
Brock lower-tier 12,567
Brockton lower-tier 9,784
Brockville single-tier 22,116
Brooke-Alvinston lower-tier 2,359
Bruce Mines single-tier 582
Brudenell, Lyndoch and Raglan lower-tier 1,552
Burk's Falls single-tier 957
Burlington lower-tier 186,948
Burpee and Mills single-tier 382
Caledon lower-tier 76,581
Callander single-tier 3,964
Calvin single-tier 557
Cambridge lower-tier 138,479
Carleton Place lower-tier 12,517
Carling single-tier 1,491
Carlow/Mayo lower-tier 953
Casey single-tier 341
Casselman lower-tier 3,960
Cavan Monaghan lower-tier 10,016
Central Elgin lower-tier 13,746
Central Frontenac lower-tier 4,892
Central Huron lower-tier 7,799
Central Manitoulin single-tier 2,235
Centre Hastings lower-tier 4,801
Centre Wellington lower-tier 31,093
Chamberlain single-tier 311
Champlain lower-tier 8,665
Chapleau single-tier 1,942
Chapple single-tier 763
Charlton and Dack single-tier 686
Chatham-Kent single-tier 103,988
Chatsworth lower-tier 7,080
Chisholm single-tier 1,312
Clarence-Rockland lower-tier 26,505
Clarington lower-tier 101,427
Clearview lower-tier 14,814
Cobalt single-tier 989
Cobourg lower-tier 20,519
Cochrane single-tier 5,390
Cockburn Island single-tier 16
Coleman single-tier 517
Collingwood lower-tier 24,811
Conmee single-tier 798
Cornwall single-tier 47,845
Cramahe lower-tier 6,509
Dawn-Euphemia lower-tier 1,968
Dawson single-tier 399
Deep River lower-tier 4,175
Deseronto lower-tier 1,747
Dorion single-tier 375
Douro-Dummer lower-tier 7,632
Drummond/North Elmsley lower-tier 8,183
Dryden single-tier 7,388
Dubreuilville single-tier 576
Dutton/Dunwich lower-tier 4,152
Dysart, Dudley, Harcourt, Guilford, Harburn, Bruton, Havelock, Eyre and Clyde lower-tier 7,182
Ear Falls single-tier 924
East Ferris single-tier 4,946
East Garafraxa lower-tier 2,794
East Gwillimbury lower-tier 34,637
East Hawkesbury lower-tier 3,418
East Zorra-Tavistock lower-tier 7,841
Edwardsburgh/Cardinal lower-tier 7,505
Elizabethtown-Kitley lower-tier 9,545
Elliot Lake single-tier 11,372
Emo single-tier 1,204
Englehart single-tier 1,442
Enniskillen lower-tier 2,825
Erin lower-tier 11,981
Espanola single-tier 5,185
Essa lower-tier 22,970
Essex lower-tier 21,216
Evanturel single-tier 502
Faraday lower-tier 1,612
Fauquier-Strickland single-tier 467
Fort Erie lower-tier 32,901
Fort Frances single-tier 7,466
French River single-tier 2,828
Front of Yonge lower-tier 2,595
Frontenac Islands lower-tier 1,930
Gananoque single-tier 5,383
Gauthier single-tier 151
Georgian Bay lower-tier 3,441
Georgian Bluffs lower-tier 11,100
Georgina lower-tier 47,642
Gillies single-tier 441
Goderich lower-tier 7,881
Gordon/Barrie Island single-tier 613
Gore Bay single-tier 808
Grand Valley lower-tier 3,851
Gravenhurst lower-tier 13,157
Greater Madawaska lower-tier 2,864
Greater Napanee lower-tier 16,879
Greater Sudbury single-tier 166,004
Greenstone single-tier 4,309
Grey Highlands lower-tier 10,424
Grimsby lower-tier 28,883
Guelph single-tier 143,740
Guelph/Eramosa lower-tier 13,904
Haldimand single-tier 49,216
Halton Hills lower-tier 62,951
Hamilton lower-tier 11,059
Hamilton single-tier 569,353
Hanover lower-tier 7,967
Harley single-tier 524
Harris single-tier 530
Hastings Highlands lower-tier 4,385
Havelock-Belmont-Methuen lower-tier 5,083
Hawkesbury lower-tier 10,194
Head, Clara and Maria lower-tier 267
Hearst single-tier 4,794
Highlands East lower-tier 3,830
Hilliard single-tier 215
Hilton single-tier 382
Hilton Beach single-tier 198
Hornepayne single-tier 968
Horton lower-tier 3,182
Howick lower-tier 4,045
Hudson single-tier 530
Huntsville lower-tier 21,147
Huron East lower-tier 9,512
Huron Shores single-tier 1,860
Huron-Kinloss lower-tier 7,723
Ignace single-tier 1,206
Ingersoll lower-tier 13,693
Innisfil lower-tier 43,326
Iroquois Falls single-tier 4,418
James single-tier 348
Jocelyn single-tier 314
Johnson single-tier 749
Joly single-tier 293
Kapuskasing single-tier 8,057
Kawartha Lakes single-tier 79,247
Kearney single-tier 974
Kenora single-tier 14,967
Kerns single-tier 330
Killaloe, Hagarty and Richards lower-tier 2,410
Killarney single-tier 397
Kincardine lower-tier 12,268
King lower-tier 27,333
Kingston single-tier 132,485
Kingsville lower-tier 22,119
Kirkland Lake single-tier 7,750
Kitchener lower-tier 256,885
La Vallee single-tier 788
Laird single-tier 1,121
Lake of Bays lower-tier 3,759
Lake of the Woods single-tier 308
Lakeshore lower-tier 40,410
Lambton Shores lower-tier 11,876
Lanark Highlands lower-tier 5,737
Larder Lake single-tier 745
LaSalle lower-tier 32,721
Latchford single-tier 355
Laurentian Hills lower-tier 2,885
Laurentian Valley lower-tier 9,450
Leamington lower-tier 29,680
Leeds and the Thousand Islands lower-tier 9,804
Limerick lower-tier 436
Lincoln lower-tier 25,719
London single-tier 422,324
Loyalist lower-tier 17,943
Lucan Biddulph lower-tier 5,680
Macdonald, Meredith and Aberdeen Additional single-tier 1,513
Machar single-tier 969
Machin single-tier 1,012
Madawaska Valley lower-tier 3,927
Madoc lower-tier 2,233
Magnetawan single-tier 1,753
Malahide lower-tier 9,308
Manitouwadge single-tier 1,974
Mapleton lower-tier 10,839
Marathon single-tier 3,138
Markham lower-tier 338,503
Markstay-Warren single-tier 2,708
Marmora and Lake lower-tier 4,267
Matachewan single-tier 268
Mattawa single-tier 1,881
Mattawan single-tier 153
Mattice-Val Côté single-tier 542
McDougall single-tier 2,744
McGarry single-tier 579
McKellar single-tier 1,419
McMurrich/Monteith single-tier 907
McNab/Braeside lower-tier 7,591
Meaford lower-tier 11,485
Melancthon lower-tier 3,132
Merrickville–Wolford lower-tier 3,135
Middlesex Centre lower-tier 18,928
Midland lower-tier 17,817
Milton lower-tier 132,979
Minden Hills lower-tier 6,971
Minto lower-tier 9,094
Mississauga lower-tier 717,961
Mississippi Mills lower-tier 14,740
Mono lower-tier 9,421
Montague lower-tier 3,914
Moonbeam single-tier 1,157
Moosonee single-tier 1,512
Morley single-tier 493
Morris-Turnberry lower-tier 3,590
Mulmur lower-tier 3,571
Muskoka Lakes lower-tier 7,652
Nairn and Hyman single-tier 373
The Nation lower-tier 13,350
Neebing single-tier 2,241
New Tecumseth lower-tier 43,948
Newbury lower-tier 440
Newmarket lower-tier 87,942
Niagara Falls lower-tier 94,415
Niagara-on-the-Lake lower-tier 19,088
Nipigon single-tier 1,473
Nipissing single-tier 1,769
Norfolk single-tier 67,490
North Algona Wilberforce lower-tier 3,111
North Bay single-tier 52,662
North Dumfries lower-tier 10,619
North Dundas lower-tier 11,304
North Frontenac lower-tier 2,285
North Glengarry lower-tier 10,144
North Grenville lower-tier 17,964
North Huron lower-tier 5,052
North Kawartha lower-tier 2,877
North Middlesex lower-tier 6,307
North Perth lower-tier 15,538
The North Shore single-tier 531
North Stormont lower-tier 7,400
Northeastern Manitoulin and the Islands single-tier 2,641
Northern Bruce Peninsula lower-tier 4,404
Norwich lower-tier 11,151
Oakville lower-tier 213,759
O'Connor single-tier 689
Oil Springs lower-tier 647
Oliver Paipoonge single-tier 6,035
Opasatika single-tier 200
Orangeville lower-tier 30,167
Orillia single-tier 33,411
Oro-Medonte lower-tier 23,017
Oshawa lower-tier 175,383
Otonabee–South Monaghan lower-tier 7,087
Ottawa single-tier 1,017,449
Owen Sound lower-tier 21,612
Papineau-Cameron single-tier 982
Parry Sound single-tier 6,879
Pelee single-tier 230
Pelham lower-tier 18,192
Pembroke single-tier 14,364
Penetanguishene lower-tier 10,077
Perry single-tier 2,650
Perth lower-tier 6,469
Perth East lower-tier 12,595
Perth South lower-tier 3,776
Petawawa lower-tier 18,160
Peterborough single-tier 83,651
Petrolia lower-tier 6,013
Pickering lower-tier 99,186
Pickle Lake single-tier 398
Plummer Additional single-tier 757
Plympton–Wyoming lower-tier 8,308
Point Edward lower-tier 1,930
Port Colborne lower-tier 20,033
Port Hope lower-tier 17,294
Powassan single-tier 3,346
Prescott single-tier 4,078
Prince single-tier 975
Prince Edward single-tier 25,704
Puslinch lower-tier 7,944
Quinte West single-tier 46,560
Rainy River single-tier 752
Ramara lower-tier 10,377
Red Lake single-tier 4,094
Red Rock single-tier 895
Renfrew lower-tier 8,190
Richmond Hill lower-tier 202,022
Rideau Lakes lower-tier 10,883
Russell lower-tier 19,598
Ryerson single-tier 745
Sables-Spanish Rivers single-tier 3,237
Sarnia lower-tier 72,047
Saugeen Shores lower-tier 15,908
Sault Ste. Marie single-tier 72,051
Schreiber single-tier 1,039
Scugog lower-tier 21,581
Seguin single-tier 5,280
Selwyn lower-tier 18,653
Severn lower-tier 14,576
Shelburne lower-tier 8,994
Shuniah single-tier 3,247
Sioux Lookout single-tier 5,839
Sioux Narrows-Nestor Falls single-tier 727
Smiths Falls single-tier 9,254
Smooth Rock Falls single-tier 1,200
South Algonquin single-tier 1,055
South Bruce lower-tier 5,880
South Bruce Peninsula lower-tier 9,137
South Dundas lower-tier 11,044
South Frontenac lower-tier 20,188
South Glengarry lower-tier 13,330
South Huron lower-tier 10,063
South River single-tier 1,101
South Stormont lower-tier 13,570
Southgate lower-tier 8,716
Southwest Middlesex lower-tier 5,893
South-West Oxford lower-tier 7,583
Southwold lower-tier 4,851
Spanish single-tier 670
Springwater lower-tier 21,701
St. Catharines lower-tier 136,803
St. Clair lower-tier 14,659
St. Joseph single-tier 1,426
St. Marys single-tier 7,386
St. Thomas single-tier 42,840
St.-Charles single-tier 1,357
Stirling-Rawdon lower-tier 5,015
Stone Mills lower-tier 7,826
Stratford single-tier 33,232
Strathroy-Caradoc lower-tier 23,871
Strong single-tier 1,566
Sundridge single-tier 938
Tarbutt single-tier 573
Tay lower-tier 11,091
Tay Valley lower-tier 5,925
Tecumseh lower-tier 23,300
Tehkummah single-tier 450
Temagami single-tier 862
Temiskaming Shores single-tier 9,634
Terrace Bay single-tier 1,528
Thames Centre lower-tier 13,980
Thessalon single-tier 1,260
Thornloe single-tier 92
Thorold lower-tier 23,816
Thunder Bay single-tier 108,843
Tillsonburg lower-tier 18,615
Timmins single-tier 41,145
Tiny lower-tier 12,966
Toronto single-tier 2,794,356
Trent Hills lower-tier 13,861
Trent Lakes lower-tier 6,439
Tudor and Cashel lower-tier 740
Tweed lower-tier 6,067
Tyendinaga lower-tier 4,538
Uxbridge lower-tier 21,556
Val Rita-Harty single-tier 757
Vaughan lower-tier 323,103
Wainfleet lower-tier 6,887
Warwick lower-tier 3,641
Wasaga Beach lower-tier 24,862
Waterloo lower-tier 121,436
Wawa single-tier 2,705
Welland lower-tier 55,750
Wellesley lower-tier 11,318
Wellington North lower-tier 12,431
West Elgin lower-tier 5,060
West Grey lower-tier 13,131
West Lincoln lower-tier 15,454
West Nipissing single-tier 14,583
West Perth lower-tier 9,038
Westport lower-tier 634
Whitby lower-tier 138,501
Whitchurch-Stouffville lower-tier 49,864
White River single-tier 557
Whitestone single-tier 1,075
Whitewater lower-tier 7,225
Wilmot lower-tier 21,429
Windsor single-tier 229,660
Wollaston lower-tier 721
Woodstock lower-tier 46,705
Woolwich lower-tier 26,999
Zorra lower-tier 8,628

The same view, with its filter written as text:

(
    GTI(towny[["name", "status", "population_2021"]], rowname_col="name")
    .fmt_integer(columns="population_2021")
    .i_cols_filter(columns=["status", "population_2021"])
    .i_view(
        filter='status in ("single-tier") and population_2021 >= 10000',
        sort="-population_2021",
    )
)
status population_2021
Addington Highlands lower-tier 2,534
Adelaide Metcalfe lower-tier 3,011
Adjala-Tosorontio lower-tier 10,989
Admaston/Bromley lower-tier 2,995
Ajax lower-tier 126,666
Alberton single-tier 954
Alfred and Plantagenet lower-tier 9,949
Algonquin Highlands lower-tier 2,588
Alnwick/Haldimand lower-tier 7,473
Amaranth lower-tier 4,327
Amherstburg lower-tier 23,524
The Archipelago single-tier 979
Armour single-tier 1,459
Armstrong single-tier 1,199
Arnprior lower-tier 9,629
Arran–Elderslie lower-tier 6,913
Ashfield–Colborne–Wawanosh lower-tier 5,884
Asphodel–Norwood lower-tier 4,658
Assiginack single-tier 1,008
Athens lower-tier 3,042
Atikokan single-tier 2,642
Augusta lower-tier 7,386
Aurora lower-tier 62,057
Aylmer lower-tier 7,699
Baldwin single-tier 579
Bancroft lower-tier 4,065
Barrie single-tier 147,829
Bayham lower-tier 7,096
Beckwith lower-tier 9,021
Belleville single-tier 55,071
Billings single-tier 753
Black River-Matheson single-tier 2,572
Blandford-Blenheim lower-tier 7,565
Blind River single-tier 3,422
The Blue Mountains lower-tier 9,390
Bluewater lower-tier 7,540
Bonfield single-tier 2,146
Bonnechere Valley lower-tier 3,898
Bracebridge lower-tier 17,305
Bradford West Gwillimbury lower-tier 42,880
Brampton lower-tier 656,480
Brant single-tier 39,474
Brantford single-tier 104,688
Brethour single-tier 105
Brighton lower-tier 12,108
Brock lower-tier 12,567
Brockton lower-tier 9,784
Brockville single-tier 22,116
Brooke-Alvinston lower-tier 2,359
Bruce Mines single-tier 582
Brudenell, Lyndoch and Raglan lower-tier 1,552
Burk's Falls single-tier 957
Burlington lower-tier 186,948
Burpee and Mills single-tier 382
Caledon lower-tier 76,581
Callander single-tier 3,964
Calvin single-tier 557
Cambridge lower-tier 138,479
Carleton Place lower-tier 12,517
Carling single-tier 1,491
Carlow/Mayo lower-tier 953
Casey single-tier 341
Casselman lower-tier 3,960
Cavan Monaghan lower-tier 10,016
Central Elgin lower-tier 13,746
Central Frontenac lower-tier 4,892
Central Huron lower-tier 7,799
Central Manitoulin single-tier 2,235
Centre Hastings lower-tier 4,801
Centre Wellington lower-tier 31,093
Chamberlain single-tier 311
Champlain lower-tier 8,665
Chapleau single-tier 1,942
Chapple single-tier 763
Charlton and Dack single-tier 686
Chatham-Kent single-tier 103,988
Chatsworth lower-tier 7,080
Chisholm single-tier 1,312
Clarence-Rockland lower-tier 26,505
Clarington lower-tier 101,427
Clearview lower-tier 14,814
Cobalt single-tier 989
Cobourg lower-tier 20,519
Cochrane single-tier 5,390
Cockburn Island single-tier 16
Coleman single-tier 517
Collingwood lower-tier 24,811
Conmee single-tier 798
Cornwall single-tier 47,845
Cramahe lower-tier 6,509
Dawn-Euphemia lower-tier 1,968
Dawson single-tier 399
Deep River lower-tier 4,175
Deseronto lower-tier 1,747
Dorion single-tier 375
Douro-Dummer lower-tier 7,632
Drummond/North Elmsley lower-tier 8,183
Dryden single-tier 7,388
Dubreuilville single-tier 576
Dutton/Dunwich lower-tier 4,152
Dysart, Dudley, Harcourt, Guilford, Harburn, Bruton, Havelock, Eyre and Clyde lower-tier 7,182
Ear Falls single-tier 924
East Ferris single-tier 4,946
East Garafraxa lower-tier 2,794
East Gwillimbury lower-tier 34,637
East Hawkesbury lower-tier 3,418
East Zorra-Tavistock lower-tier 7,841
Edwardsburgh/Cardinal lower-tier 7,505
Elizabethtown-Kitley lower-tier 9,545
Elliot Lake single-tier 11,372
Emo single-tier 1,204
Englehart single-tier 1,442
Enniskillen lower-tier 2,825
Erin lower-tier 11,981
Espanola single-tier 5,185
Essa lower-tier 22,970
Essex lower-tier 21,216
Evanturel single-tier 502
Faraday lower-tier 1,612
Fauquier-Strickland single-tier 467
Fort Erie lower-tier 32,901
Fort Frances single-tier 7,466
French River single-tier 2,828
Front of Yonge lower-tier 2,595
Frontenac Islands lower-tier 1,930
Gananoque single-tier 5,383
Gauthier single-tier 151
Georgian Bay lower-tier 3,441
Georgian Bluffs lower-tier 11,100
Georgina lower-tier 47,642
Gillies single-tier 441
Goderich lower-tier 7,881
Gordon/Barrie Island single-tier 613
Gore Bay single-tier 808
Grand Valley lower-tier 3,851
Gravenhurst lower-tier 13,157
Greater Madawaska lower-tier 2,864
Greater Napanee lower-tier 16,879
Greater Sudbury single-tier 166,004
Greenstone single-tier 4,309
Grey Highlands lower-tier 10,424
Grimsby lower-tier 28,883
Guelph single-tier 143,740
Guelph/Eramosa lower-tier 13,904
Haldimand single-tier 49,216
Halton Hills lower-tier 62,951
Hamilton lower-tier 11,059
Hamilton single-tier 569,353
Hanover lower-tier 7,967
Harley single-tier 524
Harris single-tier 530
Hastings Highlands lower-tier 4,385
Havelock-Belmont-Methuen lower-tier 5,083
Hawkesbury lower-tier 10,194
Head, Clara and Maria lower-tier 267
Hearst single-tier 4,794
Highlands East lower-tier 3,830
Hilliard single-tier 215
Hilton single-tier 382
Hilton Beach single-tier 198
Hornepayne single-tier 968
Horton lower-tier 3,182
Howick lower-tier 4,045
Hudson single-tier 530
Huntsville lower-tier 21,147
Huron East lower-tier 9,512
Huron Shores single-tier 1,860
Huron-Kinloss lower-tier 7,723
Ignace single-tier 1,206
Ingersoll lower-tier 13,693
Innisfil lower-tier 43,326
Iroquois Falls single-tier 4,418
James single-tier 348
Jocelyn single-tier 314
Johnson single-tier 749
Joly single-tier 293
Kapuskasing single-tier 8,057
Kawartha Lakes single-tier 79,247
Kearney single-tier 974
Kenora single-tier 14,967
Kerns single-tier 330
Killaloe, Hagarty and Richards lower-tier 2,410
Killarney single-tier 397
Kincardine lower-tier 12,268
King lower-tier 27,333
Kingston single-tier 132,485
Kingsville lower-tier 22,119
Kirkland Lake single-tier 7,750
Kitchener lower-tier 256,885
La Vallee single-tier 788
Laird single-tier 1,121
Lake of Bays lower-tier 3,759
Lake of the Woods single-tier 308
Lakeshore lower-tier 40,410
Lambton Shores lower-tier 11,876
Lanark Highlands lower-tier 5,737
Larder Lake single-tier 745
LaSalle lower-tier 32,721
Latchford single-tier 355
Laurentian Hills lower-tier 2,885
Laurentian Valley lower-tier 9,450
Leamington lower-tier 29,680
Leeds and the Thousand Islands lower-tier 9,804
Limerick lower-tier 436
Lincoln lower-tier 25,719
London single-tier 422,324
Loyalist lower-tier 17,943
Lucan Biddulph lower-tier 5,680
Macdonald, Meredith and Aberdeen Additional single-tier 1,513
Machar single-tier 969
Machin single-tier 1,012
Madawaska Valley lower-tier 3,927
Madoc lower-tier 2,233
Magnetawan single-tier 1,753
Malahide lower-tier 9,308
Manitouwadge single-tier 1,974
Mapleton lower-tier 10,839
Marathon single-tier 3,138
Markham lower-tier 338,503
Markstay-Warren single-tier 2,708
Marmora and Lake lower-tier 4,267
Matachewan single-tier 268
Mattawa single-tier 1,881
Mattawan single-tier 153
Mattice-Val Côté single-tier 542
McDougall single-tier 2,744
McGarry single-tier 579
McKellar single-tier 1,419
McMurrich/Monteith single-tier 907
McNab/Braeside lower-tier 7,591
Meaford lower-tier 11,485
Melancthon lower-tier 3,132
Merrickville–Wolford lower-tier 3,135
Middlesex Centre lower-tier 18,928
Midland lower-tier 17,817
Milton lower-tier 132,979
Minden Hills lower-tier 6,971
Minto lower-tier 9,094
Mississauga lower-tier 717,961
Mississippi Mills lower-tier 14,740
Mono lower-tier 9,421
Montague lower-tier 3,914
Moonbeam single-tier 1,157
Moosonee single-tier 1,512
Morley single-tier 493
Morris-Turnberry lower-tier 3,590
Mulmur lower-tier 3,571
Muskoka Lakes lower-tier 7,652
Nairn and Hyman single-tier 373
The Nation lower-tier 13,350
Neebing single-tier 2,241
New Tecumseth lower-tier 43,948
Newbury lower-tier 440
Newmarket lower-tier 87,942
Niagara Falls lower-tier 94,415
Niagara-on-the-Lake lower-tier 19,088
Nipigon single-tier 1,473
Nipissing single-tier 1,769
Norfolk single-tier 67,490
North Algona Wilberforce lower-tier 3,111
North Bay single-tier 52,662
North Dumfries lower-tier 10,619
North Dundas lower-tier 11,304
North Frontenac lower-tier 2,285
North Glengarry lower-tier 10,144
North Grenville lower-tier 17,964
North Huron lower-tier 5,052
North Kawartha lower-tier 2,877
North Middlesex lower-tier 6,307
North Perth lower-tier 15,538
The North Shore single-tier 531
North Stormont lower-tier 7,400
Northeastern Manitoulin and the Islands single-tier 2,641
Northern Bruce Peninsula lower-tier 4,404
Norwich lower-tier 11,151
Oakville lower-tier 213,759
O'Connor single-tier 689
Oil Springs lower-tier 647
Oliver Paipoonge single-tier 6,035
Opasatika single-tier 200
Orangeville lower-tier 30,167
Orillia single-tier 33,411
Oro-Medonte lower-tier 23,017
Oshawa lower-tier 175,383
Otonabee–South Monaghan lower-tier 7,087
Ottawa single-tier 1,017,449
Owen Sound lower-tier 21,612
Papineau-Cameron single-tier 982
Parry Sound single-tier 6,879
Pelee single-tier 230
Pelham lower-tier 18,192
Pembroke single-tier 14,364
Penetanguishene lower-tier 10,077
Perry single-tier 2,650
Perth lower-tier 6,469
Perth East lower-tier 12,595
Perth South lower-tier 3,776
Petawawa lower-tier 18,160
Peterborough single-tier 83,651
Petrolia lower-tier 6,013
Pickering lower-tier 99,186
Pickle Lake single-tier 398
Plummer Additional single-tier 757
Plympton–Wyoming lower-tier 8,308
Point Edward lower-tier 1,930
Port Colborne lower-tier 20,033
Port Hope lower-tier 17,294
Powassan single-tier 3,346
Prescott single-tier 4,078
Prince single-tier 975
Prince Edward single-tier 25,704
Puslinch lower-tier 7,944
Quinte West single-tier 46,560
Rainy River single-tier 752
Ramara lower-tier 10,377
Red Lake single-tier 4,094
Red Rock single-tier 895
Renfrew lower-tier 8,190
Richmond Hill lower-tier 202,022
Rideau Lakes lower-tier 10,883
Russell lower-tier 19,598
Ryerson single-tier 745
Sables-Spanish Rivers single-tier 3,237
Sarnia lower-tier 72,047
Saugeen Shores lower-tier 15,908
Sault Ste. Marie single-tier 72,051
Schreiber single-tier 1,039
Scugog lower-tier 21,581
Seguin single-tier 5,280
Selwyn lower-tier 18,653
Severn lower-tier 14,576
Shelburne lower-tier 8,994
Shuniah single-tier 3,247
Sioux Lookout single-tier 5,839
Sioux Narrows-Nestor Falls single-tier 727
Smiths Falls single-tier 9,254
Smooth Rock Falls single-tier 1,200
South Algonquin single-tier 1,055
South Bruce lower-tier 5,880
South Bruce Peninsula lower-tier 9,137
South Dundas lower-tier 11,044
South Frontenac lower-tier 20,188
South Glengarry lower-tier 13,330
South Huron lower-tier 10,063
South River single-tier 1,101
South Stormont lower-tier 13,570
Southgate lower-tier 8,716
Southwest Middlesex lower-tier 5,893
South-West Oxford lower-tier 7,583
Southwold lower-tier 4,851
Spanish single-tier 670
Springwater lower-tier 21,701
St. Catharines lower-tier 136,803
St. Clair lower-tier 14,659
St. Joseph single-tier 1,426
St. Marys single-tier 7,386
St. Thomas single-tier 42,840
St.-Charles single-tier 1,357
Stirling-Rawdon lower-tier 5,015
Stone Mills lower-tier 7,826
Stratford single-tier 33,232
Strathroy-Caradoc lower-tier 23,871
Strong single-tier 1,566
Sundridge single-tier 938
Tarbutt single-tier 573
Tay lower-tier 11,091
Tay Valley lower-tier 5,925
Tecumseh lower-tier 23,300
Tehkummah single-tier 450
Temagami single-tier 862
Temiskaming Shores single-tier 9,634
Terrace Bay single-tier 1,528
Thames Centre lower-tier 13,980
Thessalon single-tier 1,260
Thornloe single-tier 92
Thorold lower-tier 23,816
Thunder Bay single-tier 108,843
Tillsonburg lower-tier 18,615
Timmins single-tier 41,145
Tiny lower-tier 12,966
Toronto single-tier 2,794,356
Trent Hills lower-tier 13,861
Trent Lakes lower-tier 6,439
Tudor and Cashel lower-tier 740
Tweed lower-tier 6,067
Tyendinaga lower-tier 4,538
Uxbridge lower-tier 21,556
Val Rita-Harty single-tier 757
Vaughan lower-tier 323,103
Wainfleet lower-tier 6,887
Warwick lower-tier 3,641
Wasaga Beach lower-tier 24,862
Waterloo lower-tier 121,436
Wawa single-tier 2,705
Welland lower-tier 55,750
Wellesley lower-tier 11,318
Wellington North lower-tier 12,431
West Elgin lower-tier 5,060
West Grey lower-tier 13,131
West Lincoln lower-tier 15,454
West Nipissing single-tier 14,583
West Perth lower-tier 9,038
Westport lower-tier 634
Whitby lower-tier 138,501
Whitchurch-Stouffville lower-tier 49,864
White River single-tier 557
Whitestone single-tier 1,075
Whitewater lower-tier 7,225
Wilmot lower-tier 21,429
Windsor single-tier 229,660
Wollaston lower-tier 721
Woodstock lower-tier 46,705
Woolwich lower-tier 26,999
Zorra lower-tier 8,628

The single-tier municipalities with at least 100,000 people, and the lower-tier ones with at least 50,000, with an or group (which the bar shows, as it isn’t one column’s filter):

(
    GTI(towny[["name", "status", "population_2021"]], rowname_col="name")
    .fmt_integer(columns="population_2021")
    .i_cols_filter(columns=["status", "population_2021"])
    .i_view(
        filter=(
            'status in ("single-tier") and population_2021 >= 100000 '
            'or status in ("lower-tier") and population_2021 >= 50000'
        ),
        sort="-population_2021",
    )
)
status population_2021
Addington Highlands lower-tier 2,534
Adelaide Metcalfe lower-tier 3,011
Adjala-Tosorontio lower-tier 10,989
Admaston/Bromley lower-tier 2,995
Ajax lower-tier 126,666
Alberton single-tier 954
Alfred and Plantagenet lower-tier 9,949
Algonquin Highlands lower-tier 2,588
Alnwick/Haldimand lower-tier 7,473
Amaranth lower-tier 4,327
Amherstburg lower-tier 23,524
The Archipelago single-tier 979
Armour single-tier 1,459
Armstrong single-tier 1,199
Arnprior lower-tier 9,629
Arran–Elderslie lower-tier 6,913
Ashfield–Colborne–Wawanosh lower-tier 5,884
Asphodel–Norwood lower-tier 4,658
Assiginack single-tier 1,008
Athens lower-tier 3,042
Atikokan single-tier 2,642
Augusta lower-tier 7,386
Aurora lower-tier 62,057
Aylmer lower-tier 7,699
Baldwin single-tier 579
Bancroft lower-tier 4,065
Barrie single-tier 147,829
Bayham lower-tier 7,096
Beckwith lower-tier 9,021
Belleville single-tier 55,071
Billings single-tier 753
Black River-Matheson single-tier 2,572
Blandford-Blenheim lower-tier 7,565
Blind River single-tier 3,422
The Blue Mountains lower-tier 9,390
Bluewater lower-tier 7,540
Bonfield single-tier 2,146
Bonnechere Valley lower-tier 3,898
Bracebridge lower-tier 17,305
Bradford West Gwillimbury lower-tier 42,880
Brampton lower-tier 656,480
Brant single-tier 39,474
Brantford single-tier 104,688
Brethour single-tier 105
Brighton lower-tier 12,108
Brock lower-tier 12,567
Brockton lower-tier 9,784
Brockville single-tier 22,116
Brooke-Alvinston lower-tier 2,359
Bruce Mines single-tier 582
Brudenell, Lyndoch and Raglan lower-tier 1,552
Burk's Falls single-tier 957
Burlington lower-tier 186,948
Burpee and Mills single-tier 382
Caledon lower-tier 76,581
Callander single-tier 3,964
Calvin single-tier 557
Cambridge lower-tier 138,479
Carleton Place lower-tier 12,517
Carling single-tier 1,491
Carlow/Mayo lower-tier 953
Casey single-tier 341
Casselman lower-tier 3,960
Cavan Monaghan lower-tier 10,016
Central Elgin lower-tier 13,746
Central Frontenac lower-tier 4,892
Central Huron lower-tier 7,799
Central Manitoulin single-tier 2,235
Centre Hastings lower-tier 4,801
Centre Wellington lower-tier 31,093
Chamberlain single-tier 311
Champlain lower-tier 8,665
Chapleau single-tier 1,942
Chapple single-tier 763
Charlton and Dack single-tier 686
Chatham-Kent single-tier 103,988
Chatsworth lower-tier 7,080
Chisholm single-tier 1,312
Clarence-Rockland lower-tier 26,505
Clarington lower-tier 101,427
Clearview lower-tier 14,814
Cobalt single-tier 989
Cobourg lower-tier 20,519
Cochrane single-tier 5,390
Cockburn Island single-tier 16
Coleman single-tier 517
Collingwood lower-tier 24,811
Conmee single-tier 798
Cornwall single-tier 47,845
Cramahe lower-tier 6,509
Dawn-Euphemia lower-tier 1,968
Dawson single-tier 399
Deep River lower-tier 4,175
Deseronto lower-tier 1,747
Dorion single-tier 375
Douro-Dummer lower-tier 7,632
Drummond/North Elmsley lower-tier 8,183
Dryden single-tier 7,388
Dubreuilville single-tier 576
Dutton/Dunwich lower-tier 4,152
Dysart, Dudley, Harcourt, Guilford, Harburn, Bruton, Havelock, Eyre and Clyde lower-tier 7,182
Ear Falls single-tier 924
East Ferris single-tier 4,946
East Garafraxa lower-tier 2,794
East Gwillimbury lower-tier 34,637
East Hawkesbury lower-tier 3,418
East Zorra-Tavistock lower-tier 7,841
Edwardsburgh/Cardinal lower-tier 7,505
Elizabethtown-Kitley lower-tier 9,545
Elliot Lake single-tier 11,372
Emo single-tier 1,204
Englehart single-tier 1,442
Enniskillen lower-tier 2,825
Erin lower-tier 11,981
Espanola single-tier 5,185
Essa lower-tier 22,970
Essex lower-tier 21,216
Evanturel single-tier 502
Faraday lower-tier 1,612
Fauquier-Strickland single-tier 467
Fort Erie lower-tier 32,901
Fort Frances single-tier 7,466
French River single-tier 2,828
Front of Yonge lower-tier 2,595
Frontenac Islands lower-tier 1,930
Gananoque single-tier 5,383
Gauthier single-tier 151
Georgian Bay lower-tier 3,441
Georgian Bluffs lower-tier 11,100
Georgina lower-tier 47,642
Gillies single-tier 441
Goderich lower-tier 7,881
Gordon/Barrie Island single-tier 613
Gore Bay single-tier 808
Grand Valley lower-tier 3,851
Gravenhurst lower-tier 13,157
Greater Madawaska lower-tier 2,864
Greater Napanee lower-tier 16,879
Greater Sudbury single-tier 166,004
Greenstone single-tier 4,309
Grey Highlands lower-tier 10,424
Grimsby lower-tier 28,883
Guelph single-tier 143,740
Guelph/Eramosa lower-tier 13,904
Haldimand single-tier 49,216
Halton Hills lower-tier 62,951
Hamilton lower-tier 11,059
Hamilton single-tier 569,353
Hanover lower-tier 7,967
Harley single-tier 524
Harris single-tier 530
Hastings Highlands lower-tier 4,385
Havelock-Belmont-Methuen lower-tier 5,083
Hawkesbury lower-tier 10,194
Head, Clara and Maria lower-tier 267
Hearst single-tier 4,794
Highlands East lower-tier 3,830
Hilliard single-tier 215
Hilton single-tier 382
Hilton Beach single-tier 198
Hornepayne single-tier 968
Horton lower-tier 3,182
Howick lower-tier 4,045
Hudson single-tier 530
Huntsville lower-tier 21,147
Huron East lower-tier 9,512
Huron Shores single-tier 1,860
Huron-Kinloss lower-tier 7,723
Ignace single-tier 1,206
Ingersoll lower-tier 13,693
Innisfil lower-tier 43,326
Iroquois Falls single-tier 4,418
James single-tier 348
Jocelyn single-tier 314
Johnson single-tier 749
Joly single-tier 293
Kapuskasing single-tier 8,057
Kawartha Lakes single-tier 79,247
Kearney single-tier 974
Kenora single-tier 14,967
Kerns single-tier 330
Killaloe, Hagarty and Richards lower-tier 2,410
Killarney single-tier 397
Kincardine lower-tier 12,268
King lower-tier 27,333
Kingston single-tier 132,485
Kingsville lower-tier 22,119
Kirkland Lake single-tier 7,750
Kitchener lower-tier 256,885
La Vallee single-tier 788
Laird single-tier 1,121
Lake of Bays lower-tier 3,759
Lake of the Woods single-tier 308
Lakeshore lower-tier 40,410
Lambton Shores lower-tier 11,876
Lanark Highlands lower-tier 5,737
Larder Lake single-tier 745
LaSalle lower-tier 32,721
Latchford single-tier 355
Laurentian Hills lower-tier 2,885
Laurentian Valley lower-tier 9,450
Leamington lower-tier 29,680
Leeds and the Thousand Islands lower-tier 9,804
Limerick lower-tier 436
Lincoln lower-tier 25,719
London single-tier 422,324
Loyalist lower-tier 17,943
Lucan Biddulph lower-tier 5,680
Macdonald, Meredith and Aberdeen Additional single-tier 1,513
Machar single-tier 969
Machin single-tier 1,012
Madawaska Valley lower-tier 3,927
Madoc lower-tier 2,233
Magnetawan single-tier 1,753
Malahide lower-tier 9,308
Manitouwadge single-tier 1,974
Mapleton lower-tier 10,839
Marathon single-tier 3,138
Markham lower-tier 338,503
Markstay-Warren single-tier 2,708
Marmora and Lake lower-tier 4,267
Matachewan single-tier 268
Mattawa single-tier 1,881
Mattawan single-tier 153
Mattice-Val Côté single-tier 542
McDougall single-tier 2,744
McGarry single-tier 579
McKellar single-tier 1,419
McMurrich/Monteith single-tier 907
McNab/Braeside lower-tier 7,591
Meaford lower-tier 11,485
Melancthon lower-tier 3,132
Merrickville–Wolford lower-tier 3,135
Middlesex Centre lower-tier 18,928
Midland lower-tier 17,817
Milton lower-tier 132,979
Minden Hills lower-tier 6,971
Minto lower-tier 9,094
Mississauga lower-tier 717,961
Mississippi Mills lower-tier 14,740
Mono lower-tier 9,421
Montague lower-tier 3,914
Moonbeam single-tier 1,157
Moosonee single-tier 1,512
Morley single-tier 493
Morris-Turnberry lower-tier 3,590
Mulmur lower-tier 3,571
Muskoka Lakes lower-tier 7,652
Nairn and Hyman single-tier 373
The Nation lower-tier 13,350
Neebing single-tier 2,241
New Tecumseth lower-tier 43,948
Newbury lower-tier 440
Newmarket lower-tier 87,942
Niagara Falls lower-tier 94,415
Niagara-on-the-Lake lower-tier 19,088
Nipigon single-tier 1,473
Nipissing single-tier 1,769
Norfolk single-tier 67,490
North Algona Wilberforce lower-tier 3,111
North Bay single-tier 52,662
North Dumfries lower-tier 10,619
North Dundas lower-tier 11,304
North Frontenac lower-tier 2,285
North Glengarry lower-tier 10,144
North Grenville lower-tier 17,964
North Huron lower-tier 5,052
North Kawartha lower-tier 2,877
North Middlesex lower-tier 6,307
North Perth lower-tier 15,538
The North Shore single-tier 531
North Stormont lower-tier 7,400
Northeastern Manitoulin and the Islands single-tier 2,641
Northern Bruce Peninsula lower-tier 4,404
Norwich lower-tier 11,151
Oakville lower-tier 213,759
O'Connor single-tier 689
Oil Springs lower-tier 647
Oliver Paipoonge single-tier 6,035
Opasatika single-tier 200
Orangeville lower-tier 30,167
Orillia single-tier 33,411
Oro-Medonte lower-tier 23,017
Oshawa lower-tier 175,383
Otonabee–South Monaghan lower-tier 7,087
Ottawa single-tier 1,017,449
Owen Sound lower-tier 21,612
Papineau-Cameron single-tier 982
Parry Sound single-tier 6,879
Pelee single-tier 230
Pelham lower-tier 18,192
Pembroke single-tier 14,364
Penetanguishene lower-tier 10,077
Perry single-tier 2,650
Perth lower-tier 6,469
Perth East lower-tier 12,595
Perth South lower-tier 3,776
Petawawa lower-tier 18,160
Peterborough single-tier 83,651
Petrolia lower-tier 6,013
Pickering lower-tier 99,186
Pickle Lake single-tier 398
Plummer Additional single-tier 757
Plympton–Wyoming lower-tier 8,308
Point Edward lower-tier 1,930
Port Colborne lower-tier 20,033
Port Hope lower-tier 17,294
Powassan single-tier 3,346
Prescott single-tier 4,078
Prince single-tier 975
Prince Edward single-tier 25,704
Puslinch lower-tier 7,944
Quinte West single-tier 46,560
Rainy River single-tier 752
Ramara lower-tier 10,377
Red Lake single-tier 4,094
Red Rock single-tier 895
Renfrew lower-tier 8,190
Richmond Hill lower-tier 202,022
Rideau Lakes lower-tier 10,883
Russell lower-tier 19,598
Ryerson single-tier 745
Sables-Spanish Rivers single-tier 3,237
Sarnia lower-tier 72,047
Saugeen Shores lower-tier 15,908
Sault Ste. Marie single-tier 72,051
Schreiber single-tier 1,039
Scugog lower-tier 21,581
Seguin single-tier 5,280
Selwyn lower-tier 18,653
Severn lower-tier 14,576
Shelburne lower-tier 8,994
Shuniah single-tier 3,247
Sioux Lookout single-tier 5,839
Sioux Narrows-Nestor Falls single-tier 727
Smiths Falls single-tier 9,254
Smooth Rock Falls single-tier 1,200
South Algonquin single-tier 1,055
South Bruce lower-tier 5,880
South Bruce Peninsula lower-tier 9,137
South Dundas lower-tier 11,044
South Frontenac lower-tier 20,188
South Glengarry lower-tier 13,330
South Huron lower-tier 10,063
South River single-tier 1,101
South Stormont lower-tier 13,570
Southgate lower-tier 8,716
Southwest Middlesex lower-tier 5,893
South-West Oxford lower-tier 7,583
Southwold lower-tier 4,851
Spanish single-tier 670
Springwater lower-tier 21,701
St. Catharines lower-tier 136,803
St. Clair lower-tier 14,659
St. Joseph single-tier 1,426
St. Marys single-tier 7,386
St. Thomas single-tier 42,840
St.-Charles single-tier 1,357
Stirling-Rawdon lower-tier 5,015
Stone Mills lower-tier 7,826
Stratford single-tier 33,232
Strathroy-Caradoc lower-tier 23,871
Strong single-tier 1,566
Sundridge single-tier 938
Tarbutt single-tier 573
Tay lower-tier 11,091
Tay Valley lower-tier 5,925
Tecumseh lower-tier 23,300
Tehkummah single-tier 450
Temagami single-tier 862
Temiskaming Shores single-tier 9,634
Terrace Bay single-tier 1,528
Thames Centre lower-tier 13,980
Thessalon single-tier 1,260
Thornloe single-tier 92
Thorold lower-tier 23,816
Thunder Bay single-tier 108,843
Tillsonburg lower-tier 18,615
Timmins single-tier 41,145
Tiny lower-tier 12,966
Toronto single-tier 2,794,356
Trent Hills lower-tier 13,861
Trent Lakes lower-tier 6,439
Tudor and Cashel lower-tier 740
Tweed lower-tier 6,067
Tyendinaga lower-tier 4,538
Uxbridge lower-tier 21,556
Val Rita-Harty single-tier 757
Vaughan lower-tier 323,103
Wainfleet lower-tier 6,887
Warwick lower-tier 3,641
Wasaga Beach lower-tier 24,862
Waterloo lower-tier 121,436
Wawa single-tier 2,705
Welland lower-tier 55,750
Wellesley lower-tier 11,318
Wellington North lower-tier 12,431
West Elgin lower-tier 5,060
West Grey lower-tier 13,131
West Lincoln lower-tier 15,454
West Nipissing single-tier 14,583
West Perth lower-tier 9,038
Westport lower-tier 634
Whitby lower-tier 138,501
Whitchurch-Stouffville lower-tier 49,864
White River single-tier 557
Whitestone single-tier 1,075
Whitewater lower-tier 7,225
Wilmot lower-tier 21,429
Windsor single-tier 229,660
Wollaston lower-tier 721
Woodstock lower-tier 46,705
Woolwich lower-tier 26,999
Zorra lower-tier 8,628

A table first shown with only the latest census year, whose readers can show the others from the “Columns” button in the control bar:

years = [f"population_{year}" for year in range(1996, 2022, 5)]

(
    GTI(towny[["name", *years]].head(10), rowname_col="name")
    .fmt_integer(columns=years)
    .i_cols_controls(columns=years, hideable=True)
    .i_view(hidden=years[:-1])
)
population_1996 population_2001 population_2006 population_2011 population_2016 population_2021
Addington Highlands 2,429 2,402 2,512 2,517 2,318 2,534
Adelaide Metcalfe 3,128 3,149 3,135 3,028 2,990 3,011
Adjala-Tosorontio 9,359 10,082 10,695 10,603 10,975 10,989
Admaston/Bromley 2,837 2,824 2,716 2,844 2,935 2,995
Ajax 64,430 73,753 90,167 109,600 119,677 126,666
Alberton 1,027 956 958 864 969 954
Alfred and Plantagenet 8,315 8,593 8,654 9,196 9,680 9,949
Algonquin Highlands 1,687 1,827 1,976 2,186 2,351 2,588
Alnwick/Haldimand 5,528 5,846 6,435 6,617 6,869 7,473
Amaranth 3,450 3,770 3,845 3,963 4,079 4,327

A table first shown with the municipalities grouped by their status, most populous first in each group, which readers can group otherwise (or not at all) from the “Group rows” button in the control bar:

(
    GTI(towny[["name", "status", "population_2021"]], rowname_col="name")
    .fmt_integer(columns="population_2021")
    .i_cols_controls(columns="status", groupable=True)
    .i_view(sort="-population_2021", group_by="status")
)
status population_2021
Addington Highlands lower-tier 2,534
Adelaide Metcalfe lower-tier 3,011
Adjala-Tosorontio lower-tier 10,989
Admaston/Bromley lower-tier 2,995
Ajax lower-tier 126,666
Alberton single-tier 954
Alfred and Plantagenet lower-tier 9,949
Algonquin Highlands lower-tier 2,588
Alnwick/Haldimand lower-tier 7,473
Amaranth lower-tier 4,327
Amherstburg lower-tier 23,524
The Archipelago single-tier 979
Armour single-tier 1,459
Armstrong single-tier 1,199
Arnprior lower-tier 9,629
Arran–Elderslie lower-tier 6,913
Ashfield–Colborne–Wawanosh lower-tier 5,884
Asphodel–Norwood lower-tier 4,658
Assiginack single-tier 1,008
Athens lower-tier 3,042
Atikokan single-tier 2,642
Augusta lower-tier 7,386
Aurora lower-tier 62,057
Aylmer lower-tier 7,699
Baldwin single-tier 579
Bancroft lower-tier 4,065
Barrie single-tier 147,829
Bayham lower-tier 7,096
Beckwith lower-tier 9,021
Belleville single-tier 55,071
Billings single-tier 753
Black River-Matheson single-tier 2,572
Blandford-Blenheim lower-tier 7,565
Blind River single-tier 3,422
The Blue Mountains lower-tier 9,390
Bluewater lower-tier 7,540
Bonfield single-tier 2,146
Bonnechere Valley lower-tier 3,898
Bracebridge lower-tier 17,305
Bradford West Gwillimbury lower-tier 42,880
Brampton lower-tier 656,480
Brant single-tier 39,474
Brantford single-tier 104,688
Brethour single-tier 105
Brighton lower-tier 12,108
Brock lower-tier 12,567
Brockton lower-tier 9,784
Brockville single-tier 22,116
Brooke-Alvinston lower-tier 2,359
Bruce Mines single-tier 582
Brudenell, Lyndoch and Raglan lower-tier 1,552
Burk's Falls single-tier 957
Burlington lower-tier 186,948
Burpee and Mills single-tier 382
Caledon lower-tier 76,581
Callander single-tier 3,964
Calvin single-tier 557
Cambridge lower-tier 138,479
Carleton Place lower-tier 12,517
Carling single-tier 1,491
Carlow/Mayo lower-tier 953
Casey single-tier 341
Casselman lower-tier 3,960
Cavan Monaghan lower-tier 10,016
Central Elgin lower-tier 13,746
Central Frontenac lower-tier 4,892
Central Huron lower-tier 7,799
Central Manitoulin single-tier 2,235
Centre Hastings lower-tier 4,801
Centre Wellington lower-tier 31,093
Chamberlain single-tier 311
Champlain lower-tier 8,665
Chapleau single-tier 1,942
Chapple single-tier 763
Charlton and Dack single-tier 686
Chatham-Kent single-tier 103,988
Chatsworth lower-tier 7,080
Chisholm single-tier 1,312
Clarence-Rockland lower-tier 26,505
Clarington lower-tier 101,427
Clearview lower-tier 14,814
Cobalt single-tier 989
Cobourg lower-tier 20,519
Cochrane single-tier 5,390
Cockburn Island single-tier 16
Coleman single-tier 517
Collingwood lower-tier 24,811
Conmee single-tier 798
Cornwall single-tier 47,845
Cramahe lower-tier 6,509
Dawn-Euphemia lower-tier 1,968
Dawson single-tier 399
Deep River lower-tier 4,175
Deseronto lower-tier 1,747
Dorion single-tier 375
Douro-Dummer lower-tier 7,632
Drummond/North Elmsley lower-tier 8,183
Dryden single-tier 7,388
Dubreuilville single-tier 576
Dutton/Dunwich lower-tier 4,152
Dysart, Dudley, Harcourt, Guilford, Harburn, Bruton, Havelock, Eyre and Clyde lower-tier 7,182
Ear Falls single-tier 924
East Ferris single-tier 4,946
East Garafraxa lower-tier 2,794
East Gwillimbury lower-tier 34,637
East Hawkesbury lower-tier 3,418
East Zorra-Tavistock lower-tier 7,841
Edwardsburgh/Cardinal lower-tier 7,505
Elizabethtown-Kitley lower-tier 9,545
Elliot Lake single-tier 11,372
Emo single-tier 1,204
Englehart single-tier 1,442
Enniskillen lower-tier 2,825
Erin lower-tier 11,981
Espanola single-tier 5,185
Essa lower-tier 22,970
Essex lower-tier 21,216
Evanturel single-tier 502
Faraday lower-tier 1,612
Fauquier-Strickland single-tier 467
Fort Erie lower-tier 32,901
Fort Frances single-tier 7,466
French River single-tier 2,828
Front of Yonge lower-tier 2,595
Frontenac Islands lower-tier 1,930
Gananoque single-tier 5,383
Gauthier single-tier 151
Georgian Bay lower-tier 3,441
Georgian Bluffs lower-tier 11,100
Georgina lower-tier 47,642
Gillies single-tier 441
Goderich lower-tier 7,881
Gordon/Barrie Island single-tier 613
Gore Bay single-tier 808
Grand Valley lower-tier 3,851
Gravenhurst lower-tier 13,157
Greater Madawaska lower-tier 2,864
Greater Napanee lower-tier 16,879
Greater Sudbury single-tier 166,004
Greenstone single-tier 4,309
Grey Highlands lower-tier 10,424
Grimsby lower-tier 28,883
Guelph single-tier 143,740
Guelph/Eramosa lower-tier 13,904
Haldimand single-tier 49,216
Halton Hills lower-tier 62,951
Hamilton lower-tier 11,059
Hamilton single-tier 569,353
Hanover lower-tier 7,967
Harley single-tier 524
Harris single-tier 530
Hastings Highlands lower-tier 4,385
Havelock-Belmont-Methuen lower-tier 5,083
Hawkesbury lower-tier 10,194
Head, Clara and Maria lower-tier 267
Hearst single-tier 4,794
Highlands East lower-tier 3,830
Hilliard single-tier 215
Hilton single-tier 382
Hilton Beach single-tier 198
Hornepayne single-tier 968
Horton lower-tier 3,182
Howick lower-tier 4,045
Hudson single-tier 530
Huntsville lower-tier 21,147
Huron East lower-tier 9,512
Huron Shores single-tier 1,860
Huron-Kinloss lower-tier 7,723
Ignace single-tier 1,206
Ingersoll lower-tier 13,693
Innisfil lower-tier 43,326
Iroquois Falls single-tier 4,418
James single-tier 348
Jocelyn single-tier 314
Johnson single-tier 749
Joly single-tier 293
Kapuskasing single-tier 8,057
Kawartha Lakes single-tier 79,247
Kearney single-tier 974
Kenora single-tier 14,967
Kerns single-tier 330
Killaloe, Hagarty and Richards lower-tier 2,410
Killarney single-tier 397
Kincardine lower-tier 12,268
King lower-tier 27,333
Kingston single-tier 132,485
Kingsville lower-tier 22,119
Kirkland Lake single-tier 7,750
Kitchener lower-tier 256,885
La Vallee single-tier 788
Laird single-tier 1,121
Lake of Bays lower-tier 3,759
Lake of the Woods single-tier 308
Lakeshore lower-tier 40,410
Lambton Shores lower-tier 11,876
Lanark Highlands lower-tier 5,737
Larder Lake single-tier 745
LaSalle lower-tier 32,721
Latchford single-tier 355
Laurentian Hills lower-tier 2,885
Laurentian Valley lower-tier 9,450
Leamington lower-tier 29,680
Leeds and the Thousand Islands lower-tier 9,804
Limerick lower-tier 436
Lincoln lower-tier 25,719
London single-tier 422,324
Loyalist lower-tier 17,943
Lucan Biddulph lower-tier 5,680
Macdonald, Meredith and Aberdeen Additional single-tier 1,513
Machar single-tier 969
Machin single-tier 1,012
Madawaska Valley lower-tier 3,927
Madoc lower-tier 2,233
Magnetawan single-tier 1,753
Malahide lower-tier 9,308
Manitouwadge single-tier 1,974
Mapleton lower-tier 10,839
Marathon single-tier 3,138
Markham lower-tier 338,503
Markstay-Warren single-tier 2,708
Marmora and Lake lower-tier 4,267
Matachewan single-tier 268
Mattawa single-tier 1,881
Mattawan single-tier 153
Mattice-Val Côté single-tier 542
McDougall single-tier 2,744
McGarry single-tier 579
McKellar single-tier 1,419
McMurrich/Monteith single-tier 907
McNab/Braeside lower-tier 7,591
Meaford lower-tier 11,485
Melancthon lower-tier 3,132
Merrickville–Wolford lower-tier 3,135
Middlesex Centre lower-tier 18,928
Midland lower-tier 17,817
Milton lower-tier 132,979
Minden Hills lower-tier 6,971
Minto lower-tier 9,094
Mississauga lower-tier 717,961
Mississippi Mills lower-tier 14,740
Mono lower-tier 9,421
Montague lower-tier 3,914
Moonbeam single-tier 1,157
Moosonee single-tier 1,512
Morley single-tier 493
Morris-Turnberry lower-tier 3,590
Mulmur lower-tier 3,571
Muskoka Lakes lower-tier 7,652
Nairn and Hyman single-tier 373
The Nation lower-tier 13,350
Neebing single-tier 2,241
New Tecumseth lower-tier 43,948
Newbury lower-tier 440
Newmarket lower-tier 87,942
Niagara Falls lower-tier 94,415
Niagara-on-the-Lake lower-tier 19,088
Nipigon single-tier 1,473
Nipissing single-tier 1,769
Norfolk single-tier 67,490
North Algona Wilberforce lower-tier 3,111
North Bay single-tier 52,662
North Dumfries lower-tier 10,619
North Dundas lower-tier 11,304
North Frontenac lower-tier 2,285
North Glengarry lower-tier 10,144
North Grenville lower-tier 17,964
North Huron lower-tier 5,052
North Kawartha lower-tier 2,877
North Middlesex lower-tier 6,307
North Perth lower-tier 15,538
The North Shore single-tier 531
North Stormont lower-tier 7,400
Northeastern Manitoulin and the Islands single-tier 2,641
Northern Bruce Peninsula lower-tier 4,404
Norwich lower-tier 11,151
Oakville lower-tier 213,759
O'Connor single-tier 689
Oil Springs lower-tier 647
Oliver Paipoonge single-tier 6,035
Opasatika single-tier 200
Orangeville lower-tier 30,167
Orillia single-tier 33,411
Oro-Medonte lower-tier 23,017
Oshawa lower-tier 175,383
Otonabee–South Monaghan lower-tier 7,087
Ottawa single-tier 1,017,449
Owen Sound lower-tier 21,612
Papineau-Cameron single-tier 982
Parry Sound single-tier 6,879
Pelee single-tier 230
Pelham lower-tier 18,192
Pembroke single-tier 14,364
Penetanguishene lower-tier 10,077
Perry single-tier 2,650
Perth lower-tier 6,469
Perth East lower-tier 12,595
Perth South lower-tier 3,776
Petawawa lower-tier 18,160
Peterborough single-tier 83,651
Petrolia lower-tier 6,013
Pickering lower-tier 99,186
Pickle Lake single-tier 398
Plummer Additional single-tier 757
Plympton–Wyoming lower-tier 8,308
Point Edward lower-tier 1,930
Port Colborne lower-tier 20,033
Port Hope lower-tier 17,294
Powassan single-tier 3,346
Prescott single-tier 4,078
Prince single-tier 975
Prince Edward single-tier 25,704
Puslinch lower-tier 7,944
Quinte West single-tier 46,560
Rainy River single-tier 752
Ramara lower-tier 10,377
Red Lake single-tier 4,094
Red Rock single-tier 895
Renfrew lower-tier 8,190
Richmond Hill lower-tier 202,022
Rideau Lakes lower-tier 10,883
Russell lower-tier 19,598
Ryerson single-tier 745
Sables-Spanish Rivers single-tier 3,237
Sarnia lower-tier 72,047
Saugeen Shores lower-tier 15,908
Sault Ste. Marie single-tier 72,051
Schreiber single-tier 1,039
Scugog lower-tier 21,581
Seguin single-tier 5,280
Selwyn lower-tier 18,653
Severn lower-tier 14,576
Shelburne lower-tier 8,994
Shuniah single-tier 3,247
Sioux Lookout single-tier 5,839
Sioux Narrows-Nestor Falls single-tier 727
Smiths Falls single-tier 9,254
Smooth Rock Falls single-tier 1,200
South Algonquin single-tier 1,055
South Bruce lower-tier 5,880
South Bruce Peninsula lower-tier 9,137
South Dundas lower-tier 11,044
South Frontenac lower-tier 20,188
South Glengarry lower-tier 13,330
South Huron lower-tier 10,063
South River single-tier 1,101
South Stormont lower-tier 13,570
Southgate lower-tier 8,716
Southwest Middlesex lower-tier 5,893
South-West Oxford lower-tier 7,583
Southwold lower-tier 4,851
Spanish single-tier 670
Springwater lower-tier 21,701
St. Catharines lower-tier 136,803
St. Clair lower-tier 14,659
St. Joseph single-tier 1,426
St. Marys single-tier 7,386
St. Thomas single-tier 42,840
St.-Charles single-tier 1,357
Stirling-Rawdon lower-tier 5,015
Stone Mills lower-tier 7,826
Stratford single-tier 33,232
Strathroy-Caradoc lower-tier 23,871
Strong single-tier 1,566
Sundridge single-tier 938
Tarbutt single-tier 573
Tay lower-tier 11,091
Tay Valley lower-tier 5,925
Tecumseh lower-tier 23,300
Tehkummah single-tier 450
Temagami single-tier 862
Temiskaming Shores single-tier 9,634
Terrace Bay single-tier 1,528
Thames Centre lower-tier 13,980
Thessalon single-tier 1,260
Thornloe single-tier 92
Thorold lower-tier 23,816
Thunder Bay single-tier 108,843
Tillsonburg lower-tier 18,615
Timmins single-tier 41,145
Tiny lower-tier 12,966
Toronto single-tier 2,794,356
Trent Hills lower-tier 13,861
Trent Lakes lower-tier 6,439
Tudor and Cashel lower-tier 740
Tweed lower-tier 6,067
Tyendinaga lower-tier 4,538
Uxbridge lower-tier 21,556
Val Rita-Harty single-tier 757
Vaughan lower-tier 323,103
Wainfleet lower-tier 6,887
Warwick lower-tier 3,641
Wasaga Beach lower-tier 24,862
Waterloo lower-tier 121,436
Wawa single-tier 2,705
Welland lower-tier 55,750
Wellesley lower-tier 11,318
Wellington North lower-tier 12,431
West Elgin lower-tier 5,060
West Grey lower-tier 13,131
West Lincoln lower-tier 15,454
West Nipissing single-tier 14,583
West Perth lower-tier 9,038
Westport lower-tier 634
Whitby lower-tier 138,501
Whitchurch-Stouffville lower-tier 49,864
White River single-tier 557
Whitestone single-tier 1,075
Whitewater lower-tier 7,225
Wilmot lower-tier 21,429
Windsor single-tier 229,660
Wollaston lower-tier 721
Woodstock lower-tier 46,705
Woolwich lower-tier 26,999
Zorra lower-tier 8,628