return to top of page
Covid-19 Table 03/23/20

Sortable Tables Fixed Headers

Each Table on this page is Sortable and in addition each table has Fixed Headers. While this page is largely for demonstrating the sortability of tables, practical applications can be deduced from the examples. Fixed headers are only practical when the table is larger than a screen full of data
(see US Population below). Original File SortableTables.html – Sortable but Headers are not fixed.

Click on the Header to Sort the table by the selected Category
Subsequent click on any category reverses the sort order

Clicking on the Provincial or State links,
provides a wealth of information about the specific jurisdiction.

Canada's Population US Population Latest Provincial Statistics Table Corona Virus Canada

WorldCovid – Global Covid-19 Snapshot 12/31/2020


musical notes musical notes


Nana Mouskouri – A Place In My Heart  –  Lyrics


Simple Sortable Table
2043 Olympic Gold Medal Divers

Athlete Age Country Gold
Medals
Boudia David 23 United States 2
Chen Ruolin 19 China 2
James Peter 26 Denmark 2
Fekete Imre 48 Hungary 5
Flight Fred 36 Great Britan 4
Woods Tiger 39 United States 3
Zakharov Ilya 21 Russia 1
Trudeau Justin 27 France 3
Adamson Scott 26 Scotland 2
Wang Hao 19 Afghanistan 1
Moore Paul 18 Ireland 3
Fekete Jim 66 Canada 6
Peterson Fred 26 Ireland 2
Robarts John 36 Canada 4
Casey Charles 24 Congo 1
Walters David 44 USA 1
Salinas Carlos 34 Mexico 1
Castro Fidel 24 Cuba 1
Faistero Pedro 34 Argentina 2

 



Striped Sortable Table
2043 Olympic Gold Medal Divers

Athletes Age Country Gold
Medals
Einstein Albert 44 Germany 4
Scott Adam 23 Australia 2
Chen Ruolin 19 China 2
James Peter 26 Denmark 2
Fekete Imre 48 Hungary 5
Flight Fred 36 Great Britain 3
Woods Tiger 39 United States 3
Zakharov Ilya 21 Russia 1
Trudeau Justin 27 France 3
Adamson Scott 26 Scotland 2
Wang Hao 19 Afghanistan 1
Moore Paul 18 Ireland 3
Fekete Jim 66 Canada 6
Peterson Fred 26 Ireland 2
Robarts John 36 Canada 4
Casey Charles 24 Congo 1
Walters David 44 USA 1
Salinas Carlos 34 Mexico 1
Castro Fidel 24 Cuba 1
Faistero Pedro 34 Argentina 2

Source Many sortable variables explained Local Version Not as fancy

HowF.html & MyTables.html have MANY local tables and css Tables. The CSS required for the Striped Sortable Table may be causing conflicts with local table declarations in HowF. I will have to confirm that multiple .css declarations may interfere with one another. A single .css with all variables may be the solution.

SortableTablesTable.css has LOTS of comments. Originated with TablesTable which is also manually stripable has current year declared as an option used in DST, Easter and Thanksgiving tables.


Striped Sortable Table
2043 Olympic Gold Medal Divers

Created a table of just the header followed by the actual sortable table, same as the one above. May not be the perfect solution but it gets the job done.



2043 Gold Medal Divers
Athletes Age Country Gold
Medals
Einstein Albert 44 Germany 4
Scott Adam 23 Australia 2
Chen Ruolin 19 China 2
James Peter 26 Denmark 2
Fekete Imre 48 Hungary 5
Flight Fred 36 Great Britain 3
Woods Tiger 39 United States 3
Zakharov Ilya 21 Russia 1
Trudeau Justin 27 France 3
Adamson Scott 26 Scotland 2
Wang Hao 19 Afghanistan 1
Moore Paul 18 Ireland 3
Fekete Jim 66 Canada 6
Peterson Fred 26 Ireland 2
Robarts John 36 Canada 4
Casey Charles 24 Congo 1
Walters David 44 USA 1
Salinas Carlos 34 Mexico 1
Castro Fidel 24 Cuba 1
Faistero Pedro 34 Argentina 2

 



Canadian Population Statistics


Name Population
2019
Land area
(km2)
Percent
of Total
Ontario14,446,515908,699.3338.3%
Quebec8,433,3011,356,625.27 23.2%
British Columbia5,020,302922,503.0113.2%
Alberta4,345,737640,330.4611.6%
Manitoba1,360,396552,370.993.6%
Saskatchewan1,168,423588,243.543.1%
Nova Scotia965,38252,942.272.6%
New Brunswick772,09471,388.812.1%
Newfoundland Labrador  523,790370,514.081.5%
Prince Edward Island 154,7485,686.030.41%
Northwest Territory44,5981,143,793.860.12%
Nunavut38,7871,877,778.530.10%
Yukon40,369474,712.680.10%

Table Created: February 11th 2020



Canadian Population Statistics


Location Name Location Population
2020
Population
% of Total
Land area
(km2)
Pop
(km2)
Ontario14,733,11938.77%908,699.33 14.8
Quebec8,575,779 22.56%1,356,625.276.0
British Columbia5,145,85113.55%922,503.015.0
Alberta4,428,11211.64%640,330.466.4
Manitoba1,379,584 3.63%552,370.992.3
Saskatchewan1,177,8843.10%588,243.541.9
Nova Scotia979,1152.58%52,942.2717.4
New Brunswick781,3152.06%71,388.8110.5
Newfoundland Labrador  520,9981.37%370,514.081.4
Prince Edward Island 159,7130.42%5,686.0325.1
Northwest Territory45,0740.12%1,143,793.860.04
Nunavut39,2850.10%1,877,778.530.02
Yukon42,1760.11%474,712.680.08
Canada38,008,005100%8,965,588.853.9

Table Created: February 12th 2020

Information Source More data at > Canada's Population

 


US 2020 Population by State

State State State Population
2020
Percent
of Total
Area
(mi2)
Density (p/mi2)
California 39,937,489 11.94% 163,694.74 256
Texas 29,472,295 8.81% 268,596.46 113
Florida 21,992,985 6.58% 65,757.70 410
New York 19,440,469 5.81% 54,554.98 413
Pennsylvania 12,820,878 3.83% 46,054.34 287
Illinois 12,659,682 3.79% 57,913.55 228
Ohio 11,747,694 3.51% 44,825.58 288
Georgia 10,736,059 3.21% 59,425.15 187
North Carolina 10,611,862 3.17% 53,819.16 218
Michigan 10,045,029 3.00% 96,713.51 178
New Jersey 8,936,574 2.67% 8,722.58 1,215
Virginia 8,626,207 2.58% 42,774.93 218
Washington 7,797,095 2.33% 71,297.95 117
Arizona 7,378,494 2.21% 113,990.30 65
Massachusetts 6,976,597 2.09% 10,554.39 894
Tennessee 6,897,576 2.06% 42,144.25 167
Indiana 6,745,354 2.02% 36,419.55 188
Missouri 6,169,270 1.85% 69,706.99 90
Maryland 6,083,116 1.82% 12,405.93 627
Wisconsin 5,851,754 1.75% 65,496.38 108
Colorado 5,845,526 1.75% 104,093.67 56
Minnesota 5,700,671 1.70% 86,935.83 72
South Carolina 5,210,095 1.56% 32,020.49 173
Alabama 4,908,621 1.47% 52,420.07 97
Louisiana 4,645,184 1.39% 52,378.13 108
Kentucky 4,499,692 1.35% 40,407.80 114
Oregon 4,301,089 1.29% 98,378.54 45
Oklahoma 3,954,821 1.18% 69,898.87 58
Connecticut 3,563,077 1.07% 5,543.41 736
Utah 3,282,115 0.98% 84,896.88 40
Iowa 3,179,849 0.95% 56,272.81 57
Nevada 3,139,658 0.94% 110,571.82 29
Arkansas 3,038,999 0.91% 53,178.55 58
Puerto Rico 3,032,165 0.91% 5,324.84 877
Mississippi 2,989,260 0.89% 48,431.78 64
Kansas 2,910,357 0.87% 82,278.36 36
New Mexico 2,096,640 0.63% 121,590.30 17
Nebraska 1,952,570 0.58% 77,347.81 25
Idaho 1,826,156 0.55% 83,568.95 22
West Virginia 1,778,070 0.53% 24,230.04 74
Hawaii 1,412,687 0.42% 10,931.72 220
New Hampshire 1,371,246 0.41% 9,349.16 153
Maine 1,345,790 0.40% 35,379.74 44
Montana 1,086,759 0.33% 147,039.71 7
Rhode Island 1,056,161 0.32% 1,544.89 1,021
Delaware 982,895 0.29% 2,488.72 504
South Dakota 903,027 0.27% 77,115.68 12
North Dakota 761,723 0.23% 70,698.32 11
Alaska 734,002 0.22% 665,384.04 1
District of Columbia 720,687 0.22% 68.34 11,815
Vermont 628,061 0.19% 9,616.36 68
Wyoming 567,025 0.17% 97,813.01 6

Table Created: February 17th 2020

Information Source More Data at > US Population

 

I find the striped tables far more functional both for ease of use and aesthetics.



Corona Virus Canada

Table 1231
Cases of COVID-19 in Canada as of March 23, 2020
Province, Territory
or Other
Confirmed
Cases
Probable
Cases
Deaths
Newfoundland and Labrador 4 20 0
Prince Edward Island 3 0 0
Nova Scotia 41 0 0
New Brunswick 9 8 0
Quebec 221 407 4
Ontario 503 0 6
Manitoba 11 9 0
Saskatchewan 65 1 0
Alberta 301 0 1
British Columbia 472 0 13
Yukon 2 0 0
Northwest Territories 1 0 0
Nunavut 0 0 0
Repatriated travellers 13 0 0
Total 1,646 445 24

The Total line excluded from being sorted, as it should be. I will use the above table as benchmark, providing additional updated tables from time to time to demonstrate the progress of the Canadian exposure.

Information Source

 



Corona Virus Canada 2020 Final


Table 01/31

Cases of COVID-19 in Canada as of December 31, 2020
No Breakdown by Location Available for this Date
Province, Territory
or Other
Confirmed
Cases
Number of
Deaths
Newfoundland and Labrador 390 4
Prince Edward Island 96 0
Nova Scotia 1,483 65
New Brunswick 596 8
Quebec 199,822 8,165
Ontario 178,831 4,474
Manitoba 24,513 661
Saskatchewan 15,160 154
Alberta 100,428 1,046
British Columbia 51,300 893
Yukon 60 1
Northwest Territories 24 0
Nunavut 266 1
Total 581,395 15,606

 

Previous

Corona Virus 2021

Table 0131
COVID-19 Cases in Canada as of January 31, 2021
Province, Territory
or Other
Confirmed
Cases
Number of
Deaths
Newfoundland and Labrador 408 4
Prince Edward Island 111 15
Nova Scotia 1,580 65
New Brunswick 1,256 18
Quebec 262,583 9,794
Ontario 268,211 6,188
Manitoba 29,564 829
Saskatchewan 23,864 304
Alberta 124,208 1,639
British Columbia 66,779 1,189
Yukon 70 1
Northwest Territories 31 0
Nunavut 294 1
Total for Canada 778,972 20,032
Previous

Information Source Additional (local) Statistics


 

Table 03/31
COVID-19 Cases Canada in 2021
Moved to Covid2021.html Covid2021.html
No use duplicating the effort

 





Today is: , and

 


Fekete Unicorn Unicorn over Unicorn
Click me for
Larger image