⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

7,296 rows where country_or_region = "Canada" sorted by admin2

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Canada · 7,296
Link rowid day country_or_region province_or_state admin2 ▼ fips confirmed deaths recovered active latitude longitude last_update combined_key
66 2020-09-15 Canada Alberta     15957 254 14212 1491 53.9333 -116.5765 2020-09-16 04:22:53 Alberta, Canada
67 2020-09-15 Canada British Columbia     7376 219 5548 1609 53.7267 -127.6476 2020-09-16 04:22:53 British Columbia, Canada
68 2020-09-15 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-16 04:22:53 Diamond Princess, Canada
69 2020-09-15 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-09-16 04:22:53 Grand Princess, Canada
70 2020-09-15 Canada Manitoba     1466 16 1181 269 53.7609 -98.8139 2020-09-16 04:22:53 Manitoba, Canada
71 2020-09-15 Canada New Brunswick     194 2 189 3 46.5653 -66.4619 2020-09-16 04:22:53 New Brunswick, Canada
72 2020-09-15 Canada Newfoundland and Labrador     271 3 267 1 53.1355 -57.6604 2020-09-16 04:22:53 Newfoundland and Labrador, Canada
73 2020-09-15 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-09-16 04:22:53 Northwest Territories,Canada
74 2020-09-15 Canada Nova Scotia     1086 65 1020 1 44.682 -63.7443 2020-09-16 04:22:53 Nova Scotia, Canada
75 2020-09-15 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-09-16 04:22:53 Nunavut, Canada
76 2020-09-15 Canada Ontario     47165 2870 42027 2268 51.2538 -85.3232 2020-09-16 04:22:53 Ontario, Canada
77 2020-09-15 Canada Prince Edward Island     57 0 56 1 46.5107 -63.4168 2020-09-16 04:22:53 Prince Edward Island, Canada
78 2020-09-15 Canada Quebec     65554 5803 57628 2141 52.9399 -73.5491 2020-09-16 04:22:53 Quebec, Canada
79 2020-09-15 Canada Saskatchewan     1741 24 1616 101 52.9399 -106.4509 2020-09-16 04:22:53 Saskatchewan, Canada
80 2020-09-15 Canada Yukon     15 0 15 0 64.2823 -135.0 2020-09-16 04:22:53 Yukon, Canada
4039 2020-12-05 Canada Alberta     66730 596 47328 18806 53.9333 -116.5765 2020-12-06 05:26:18 Alberta, Canada
4040 2020-12-05 Canada British Columbia     36132 492 25658 9982 53.7267 -127.6476 2020-12-06 05:26:18 British Columbia, Canada
4041 2020-12-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-06 05:26:18 Diamond Princess, Canada
4042 2020-12-05 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-06 05:26:18 Grand Princess, Canada
4043 2020-12-05 Canada Manitoba     18423 381 8927 9115 53.7609 -98.8139 2020-12-06 05:26:18 Manitoba, Canada
4044 2020-12-05 Canada New Brunswick     530 7 425 98 46.5653 -66.4619 2020-12-06 05:26:18 New Brunswick, Canada
4045 2020-12-05 Canada Newfoundland and Labrador     347 4 317 26 53.1355 -57.6604 2020-12-06 05:26:18 Newfoundland and Labrador, Canada
4046 2020-12-05 Canada Northwest Territories     15 0 15 0 64.8255 -124.8457 2020-12-06 05:26:18 Northwest Territories,Canada
4047 2020-12-05 Canada Nova Scotia     1364 65 1204 95 44.682 -63.7443 2020-12-06 05:26:18 Nova Scotia, Canada
4048 2020-12-05 Canada Nunavut     214 0 158 56 70.2998 -83.1076 2020-12-06 05:26:18 Nunavut, Canada
4049 2020-12-05 Canada Ontario     128997 3774 111197 14026 51.2538 -85.3232 2020-12-06 05:26:18 Ontario, Canada
4050 2020-12-05 Canada Prince Edward Island     73 0 68 5 46.5107 -63.4168 2020-12-06 05:26:18 Prince Edward Island, Canada
4051 2020-12-05 Canada Quebec     149908 7314 128828 13849 52.9399 -73.5491 2020-12-06 05:26:18 Quebec, Canada
4052 2020-12-05 Canada Repatriated Travellers     13 0 13 0     2020-12-06 05:26:18 Repatriated Travellers, Canada
4053 2020-12-05 Canada Saskatchewan     9730 55 5484 4191 52.9399 -106.4509 2020-12-06 05:26:18 Saskatchewan, Canada
4054 2020-12-05 Canada Yukon     54 1 41 12 64.2823 -135.0 2020-12-06 05:26:18 Yukon, Canada
10995 2020-06-09 Canada Alberta     7229 151 6722 356 53.9333 -116.5765 2020-06-10 04:07:00 Alberta, Canada
11044 2020-06-09 Canada British Columbia     2669 167 2319 183 53.7267 -127.6476 2020-06-10 04:07:00 British Columbia, Canada
11092 2020-06-09 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-06-10 04:07:00 Diamond Princess, Canada
11118 2020-06-09 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-06-10 04:07:00 Grand Princess, Canada
11219 2020-06-09 Canada Manitoba     300 7 285 8 53.7609 -98.8139 2020-06-10 04:07:00 Manitoba, Canada
11255 2020-06-09 Canada New Brunswick     147 1 121 25 46.5653 -66.4619 2020-06-10 04:07:00 New Brunswick, Canada
11258 2020-06-09 Canada Newfoundland and Labrador     261 3 256 2 53.1355 -57.6604 2020-06-10 04:07:00 Newfoundland and Labrador, Canada
11269 2020-06-09 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-06-10 04:07:00 Northwest Territories, Canada
11270 2020-06-09 Canada Nova Scotia     1060 62 998 0 44.681999999999995 -63.7443 2020-06-10 04:07:00 Nova Scotia, Canada
11271 2020-06-09 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-06-10 04:07:00 Nunavut, Canada
11283 2020-06-09 Canada Ontario     32678 2536 25375 4767 51.2538 -85.3232 2020-06-10 04:07:00 Ontario, Canada
11305 2020-06-09 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-06-10 04:07:00 Prince Edward Island, Canada
11313 2020-06-09 Canada Quebec     53185 5406 19361 28795 52.9399 -73.5491 2020-06-10 04:07:00 Quebec, Canada
11350 2020-06-09 Canada Saskatchewan     656 13 624 19 52.9399 -106.4509 2020-06-10 04:07:00 Saskatchewan, Canada
11443 2020-06-09 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-06-10 04:07:00 Yukon, Canada
11705 2021-04-28 Canada Alberta     186679 2073 163668 20938 53.9333 -116.5765 2021-04-29 04:20:55 Alberta, Canada
11706 2021-04-28 Canada British Columbia     127889 1576 118057 8256 53.7267 -127.6476 2021-04-29 04:20:55 British Columbia, Canada
11707 2021-04-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
11708 2021-04-28 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
11709 2021-04-28 Canada Manitoba     38211 971 35034 2206 53.7609 -98.8139 2021-04-29 04:20:55 Manitoba, Canada
11710 2021-04-28 Canada New Brunswick     1890 36 1731 123 46.5653 -66.4619 2021-04-29 04:20:55 New Brunswick, Canada
11711 2021-04-28 Canada Newfoundland and Labrador     1066 6 1029 31 53.1355 -57.6604 2021-04-29 04:20:55 Newfoundland and Labrador, Canada
11712 2021-04-28 Canada Northwest Territories     57 0 51 6 64.8255 -124.8457 2021-04-29 04:20:55 Northwest Territories,Canada
11713 2021-04-28 Canada Nova Scotia     2290 67 1734 489 44.682 -63.7443 2021-04-29 04:20:55 Nova Scotia, Canada
11714 2021-04-28 Canada Nunavut     478 4 424 50 70.2998 -83.1076 2021-04-29 04:20:55 Nunavut, Canada
11715 2021-04-28 Canada Ontario     463770 7980 420930 34860 51.2538 -85.3232 2021-04-29 04:20:55 Ontario, Canada
11716 2021-04-28 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-04-29 04:20:55 Prince Edward Island, Canada
11717 2021-04-28 Canada Quebec     347690 10908 326834 9948 52.9399 -73.5491 2021-04-29 04:20:55 Quebec, Canada
11718 2021-04-28 Canada Repatriated Travellers     13 0 13 0     2021-04-29 04:20:55 Repatriated Travellers, Canada
11719 2021-04-28 Canada Saskatchewan     40614 486 37685 2443 52.9399 -106.4509 2021-04-29 04:20:55 Saskatchewan, Canada
11720 2021-04-28 Canada Yukon     81 2 79 0 64.2823 -135.0 2021-04-29 04:20:55 Yukon, Canada
17974 2020-04-03 Canada Alberta     969 13 0 0 53.9333 -116.5765 2020-04-03 22:52:30 Alberta, Canada
17982 2020-04-03 Canada British Columbia     1174 31 0 0 53.7267 -127.6476 2020-04-03 22:52:30 British Columbia, Canada
17988 2020-04-03 Canada Diamond Princess     0 1 0 0 0.0 0.0 2020-04-03 22:52:30 Diamond Princess, Canada
17996 2020-04-03 Canada Grand Princess     13 0 0 0 37.6489 0.0 2020-04-03 22:52:30 Grand Princess, Canada
18018 2020-04-03 Canada Manitoba     182 2 0 0 53.7609 -98.8139 2020-04-03 22:52:30 Manitoba, Canada
18022 2020-04-03 Canada New Brunswick     91 0 0 0 46.5653 -66.4619 2020-04-03 22:52:30 New Brunswick, Canada
18025 2020-04-03 Canada Newfoundland and Labrador     195 1 0 0 53.1355 -57.6604 2020-04-03 22:52:30 Newfoundland and Labrador, Canada
18029 2020-04-03 Canada Northwest Territories     2 0 0 0 64.8255 -124.8457 2020-04-03 22:52:30 ,Northwest Territories,Canada
18030 2020-04-03 Canada Nova Scotia     207 0 0 0 44.681999999999995 -63.7443 2020-04-03 22:52:30 Nova Scotia, Canada
18031 2020-04-03 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-04-03 22:52:30 Nunavut, Canada
18032 2020-04-03 Canada Ontario     3255 67 0 0 51.2538 -85.3232 2020-04-03 22:52:30 Ontario, Canada
18033 2020-04-03 Canada Prince Edward Island     22 0 0 0 46.5107 -63.4168 2020-04-03 22:52:30 Prince Edward Island, Canada
18036 2020-04-03 Canada Quebec     6101 159 0 0 52.9399 -73.5491 2020-04-03 22:52:30 Quebec, Canada
18038 2020-04-03 Canada Recovered     0 0 2175 0 0.0 0.0 2020-04-03 22:52:30 Recovered, Canada
18043 2020-04-03 Canada Saskatchewan     220 3 0 0 52.9399 -106.4509 2020-04-03 22:52:30 Saskatchewan, Canada
18060 2020-04-03 Canada Yukon     6 0 0 0 64.2823 -135.0 2020-04-03 22:52:30 ,Yukon,Canada
21323 2020-06-17 Canada Alberta     7530 151 6893 486 53.9333 -116.5765 2020-06-18 04:33:18 Alberta, Canada
21379 2020-06-17 Canada British Columbia     2775 168 2422 185 53.7267 -127.6476 2020-06-18 04:33:18 British Columbia, Canada
21431 2020-06-17 Canada Diamond Princess     0 1 0 -1 0.0 0.0 2020-06-18 04:33:18 Diamond Princess, Canada
21460 2020-06-17 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-06-18 04:33:18 Grand Princess, Canada
21574 2020-06-17 Canada Manitoba     306 7 293 6 53.7609 -98.8139 2020-06-18 04:33:18 Manitoba, Canada
21613 2020-06-17 Canada New Brunswick     164 2 133 29 46.5653 -66.4619 2020-06-18 04:33:18 New Brunswick, Canada
21616 2020-06-17 Canada Newfoundland and Labrador     261 3 257 1 53.1355 -57.6604 2020-06-18 04:33:18 Newfoundland and Labrador, Canada
21628 2020-06-17 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-06-18 04:33:18 Northwest Territories, Canada
21629 2020-06-17 Canada Nova Scotia     1061 62 997 2 44.681999999999995 -63.7443 2020-06-18 04:33:18 Nova Scotia, Canada
21630 2020-06-17 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-06-18 04:33:18 Nunavut, Canada
21643 2020-06-17 Canada Ontario     34382 2607 29047 2728 51.2538 -85.3232 2020-06-18 04:33:18 Ontario, Canada
21665 2020-06-17 Canada Prince Edward Island     27 0 27 0 46.5107 -63.4168 2020-06-18 04:33:18 Prince Edward Island, Canada
21676 2020-06-17 Canada Quebec     54263 5528 22549 26416 52.9399 -73.5491 2020-06-18 04:33:18 Quebec, Canada
21714 2020-06-17 Canada Saskatchewan     693 13 633 47 52.9399 -106.4509 2020-06-18 04:33:18 Saskatchewan, Canada
21819 2020-06-17 Canada Yukon     11 0 11 0 64.2823 -135.0 2020-06-18 04:33:18 Yukon, Canada
22061 2020-03-06 Canada Toronto, ON     24 0 2   43.6532 -79.3832 2020-03-06T20:53:02  
22064 2020-03-06 Canada British Columbia     21 0 3   49.2827 -123.1207 2020-03-06T04:43:03  
22120 2020-03-06 Canada Montreal, QC     2 0 0   45.5017 -73.5673 2020-03-05T14:03:04  
22146 2020-03-06 Canada Calgary, Alberta     1 0 0   51.0447 -114.0719 2020-03-06T13:13:34  
22147 2020-03-06 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
22281 2021-03-12 Canada Alberta     137562 1935 131081 4546 53.9333 -116.5765 2021-03-13 05:25:15 Alberta, Canada
22282 2021-03-12 Canada British Columbia     86867 1397 80325 5145 53.7267 -127.6476 2021-03-13 05:25:15 British Columbia, Canada

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);