⚠️ 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,216 rows where country_or_region = "Canada" sorted by recovered

View and edit SQL

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

country_or_region

  • Canada · 7,216
Link rowid day country_or_region province_or_state admin2 fips confirmed deaths recovered ▼ active latitude longitude last_update combined_key
2804 2020-04-19 Canada Alberta     2803 51 0 2752 53.9333 -116.5765 2020-04-19 23:48:49 Alberta, Canada
2812 2020-04-19 Canada British Columbia     1647 81 0 1566 53.7267 -127.6476 2020-04-19 23:48:49 British Columbia, Canada
2826 2020-04-19 Canada Grand Princess     13 0 0 13 37.6489 0.0 2020-04-19 23:48:49 Grand Princess, Canada
2848 2020-04-19 Canada Manitoba     254 5 0 249 53.7609 -98.8139 2020-04-19 23:48:49 Manitoba, Canada
2852 2020-04-19 Canada New Brunswick     118 0 0 118 46.5653 -66.4619 2020-04-19 23:48:49 New Brunswick, Canada
2855 2020-04-19 Canada Newfoundland and Labrador     257 3 0 254 53.1355 -57.6604 2020-04-19 23:48:49 Newfoundland and Labrador, Canada
2859 2020-04-19 Canada Northwest Territories     5 0 0 5 64.8255 -124.8457 2020-04-19 23:48:49 Northwest Territories, Canada
2860 2020-04-19 Canada Nova Scotia     675 9 0 666 44.682 -63.7443 2020-04-19 23:48:49 Nova Scotia, Canada
2861 2020-04-19 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-04-19 23:48:49 Nunavut, Canada
2862 2020-04-19 Canada Ontario     11561 591 0 10970 51.2538 -85.3232 2020-04-19 23:48:49 Ontario, Canada
2863 2020-04-19 Canada Prince Edward Island     26 0 0 26 46.5107 -63.4168 2020-04-19 23:48:49 Prince Edward Island, Canada
2866 2020-04-19 Canada Quebec     17950 1400 0 17130 52.9399 -73.5491 2020-04-19 23:48:49 Quebec, Canada
2874 2020-04-19 Canada Saskatchewan     315 4 0 311 52.9399 -106.4509 2020-04-19 23:48:49 Saskatchewan, Canada
2891 2020-04-19 Canada Yukon     9 0 0 9 64.2823 -135.0 2020-04-19 23:48:49 Yukon, Canada
3144 2020-10-26 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-27 04:24:45 Diamond Princess, Canada
3151 2020-10-26 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-10-27 04:24:45 Nunavut, Canada
10220 2020-03-30 Canada Alberta     661 3 0 0 53.9333 -116.5765 3/30/20 22:58 Alberta, Canada
10228 2020-03-30 Canada British Columbia     970 19 0 0 53.7267 -127.6476 3/30/20 22:58 British Columbia, Canada
10234 2020-03-30 Canada Diamond Princess     0 1 0 0 0.0 0.0 3/30/20 22:58 Diamond Princess, Canada
10242 2020-03-30 Canada Grand Princess     13 0 0 0 0.0 0.0 3/30/20 22:58 Grand Princess, Canada
10264 2020-03-30 Canada Manitoba     96 1 0 0 53.7609 -98.8139 3/30/20 22:58 Manitoba, Canada
10268 2020-03-30 Canada New Brunswick     68 0 0 0 46.5653 -66.4619 3/30/20 22:58 New Brunswick, Canada
10271 2020-03-30 Canada Newfoundland and Labrador     148 1 0 0 53.1355 -57.6604 3/30/20 22:58 Newfoundland and Labrador, Canada
10275 2020-03-30 Canada Northwest Territories     1 0 0 0 64.8255 -124.8457 3/30/20 22:58 ,Northwest Territories,Canada
10276 2020-03-30 Canada Nova Scotia     127 0 0 0 44.682 -63.7443 3/30/20 22:58 Nova Scotia, Canada
10277 2020-03-30 Canada Nunavut     0 0 0 0 70.2998 -83.1076 3/30/20 22:58 Nunavut, Canada
10278 2020-03-30 Canada Ontario     1706 31 0 0 51.2538 -85.3232 3/30/20 22:58 Ontario, Canada
10279 2020-03-30 Canada Prince Edward Island     18 0 0 0 46.5107 -63.4168 3/30/20 22:58 Prince Edward Island, Canada
10282 2020-03-30 Canada Quebec     3430 67 0 0 52.9399 -73.5491 3/30/20 22:58 Quebec, Canada
10289 2020-03-30 Canada Saskatchewan     156 2 0 0 52.9399 -106.4509 3/30/20 22:58 Saskatchewan, Canada
10306 2020-03-30 Canada Yukon     4 0 0 0 64.2823 -135.0 3/30/20 22:58 ,Yukon,Canada
13746 2020-07-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-18 04:34:45 Diamond Princess, Canada
13952 2020-07-17 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-07-18 04:34:45 Nunavut, Canada
14408 2021-04-30 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
21174 2020-04-24 Canada Alberta     4017 72 0 3945 53.9333 -116.5765 2020-04-25 06:30:55 Alberta, Canada
21181 2020-04-24 Canada British Columbia     1853 98 0 1755 53.7267 -127.6476 2020-04-25 06:30:55 British Columbia, Canada
21187 2020-04-24 Canada Diamond Princess     0 1 0 0 0.0 0.0 2020-04-25 06:30:55 Diamond Princess, Canada
21217 2020-04-24 Canada Manitoba     263 6 0 257 53.7609 -98.8139 2020-04-25 06:30:55 Manitoba, Canada
21221 2020-04-24 Canada New Brunswick     118 0 0 118 46.5653 -66.4619 2020-04-25 06:30:55 New Brunswick, Canada
21223 2020-04-24 Canada Newfoundland and Labrador     256 3 0 253 53.1355 -57.6604 2020-04-25 06:30:55 Newfoundland and Labrador, Canada
21226 2020-04-24 Canada Northwest Territories     5 0 0 5 64.8255 -124.8457 2020-04-25 06:30:55 Northwest Territories, Canada
21227 2020-04-24 Canada Ontario     14550 862 0 13688 51.2538 -85.3232 2020-04-25 06:30:55 Ontario, Canada
21228 2020-04-24 Canada Prince Edward Island     26 0 0 26 46.5107 -63.4168 2020-04-25 06:30:55 Prince Edward Island, Canada
21231 2020-04-24 Canada Quebec     22616 1968 0 21276 52.9399 -73.5491 2020-04-25 06:30:55 Quebec, Canada
21237 2020-04-24 Canada Saskatchewan     341 4 0 337 52.9399 -106.4509 2020-04-25 06:30:55 Saskatchewan, Canada
21250 2020-04-24 Canada Yukon     11 0 0 11 64.2823 -135.0 2020-04-25 06:30:55 Yukon, Canada
21511 2020-10-13 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-14 04:24:05 Diamond Princess, Canada
21518 2020-10-13 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-10-14 04:24:05 Nunavut, Canada
28369 2020-05-11 Canada Alberta     6300 117 0 6183 53.9333 -116.5765 2020-05-12 03:32:27 Alberta, Canada
28377 2020-05-11 Canada British Columbia     2353 130 0 2223 53.7267 -127.6476 2020-05-12 03:32:27 British Columbia, Canada
28383 2020-05-11 Canada Diamond Princess     1 1 0 0 0.0 0.0 2020-05-12 03:32:27 Diamond Princess, Canada
28392 2020-05-11 Canada Grand Princess     13 0 0 13 37.6489 0.0 2020-05-12 03:32:27 Grand Princess, Canada
28414 2020-05-11 Canada Manitoba     289 7 0 282 53.7609 -98.8139 2020-05-12 03:32:27 Manitoba, Canada
28418 2020-05-11 Canada New Brunswick     120 0 0 120 46.5653 -66.4619 2020-05-12 03:32:27 New Brunswick, Canada
28421 2020-05-11 Canada Newfoundland and Labrador     261 3 0 258 53.1355 -57.6604 2020-05-12 03:32:27 Newfoundland and Labrador, Canada
28425 2020-05-11 Canada Northwest Territories     5 0 0 5 64.8255 -124.8457 2020-05-12 03:32:27 Northwest Territories, Canada
28426 2020-05-11 Canada Nova Scotia     1019 48 0 971 44.681999999999995 -63.7443 2020-05-12 03:32:27 Nova Scotia, Canada
28427 2020-05-11 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-05-12 03:32:27 Nunavut, Canada
28428 2020-05-11 Canada Ontario     21817 1788 0 20029 51.2538 -85.3232 2020-05-12 03:32:27 Ontario, Canada
28429 2020-05-11 Canada Prince Edward Island     27 0 0 27 46.5107 -63.4168 2020-05-12 03:32:27 Prince Edward Island, Canada
28432 2020-05-11 Canada Quebec     38480 3855 0 35466 52.9399 -73.5491 2020-05-12 03:32:27 Quebec, Canada
28440 2020-05-11 Canada Saskatchewan     568 7 0 561 52.9399 -106.4509 2020-05-12 03:32:27 Saskatchewan, Canada
28457 2020-05-11 Canada Yukon     11 0 0 11 64.2823 -135.0 2020-05-12 03:32:27 Yukon, Canada
28725 2020-11-23 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-24 05:27:31 Diamond Princess, Canada
32705 2021-04-12 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
36678 2020-10-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-28 04:24:39 Diamond Princess, Canada
36685 2020-10-27 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-10-28 04:24:39 Nunavut, Canada
43932 2020-07-30 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-31 04:35:18 Diamond Princess, Canada
44140 2020-07-30 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-07-31 04:35:18 Nunavut, Canada
47478 2020-05-09 Canada Alberta     6157 116 0 6041 53.9333 -116.5765 2020-05-10 02:32:30 Alberta, Canada
47486 2020-05-09 Canada British Columbia     2330 129 0 2201 53.7267 -127.6476 2020-05-10 02:32:30 British Columbia, Canada
47492 2020-05-09 Canada Diamond Princess     1 1 0 0 0.0 0.0 2020-05-10 02:32:30 Diamond Princess, Canada
47501 2020-05-09 Canada Grand Princess     13 0 0 13 37.6489 0.0 2020-05-10 02:32:30 Grand Princess, Canada
47523 2020-05-09 Canada Manitoba     284 7 0 277 53.7609 -98.8139 2020-05-10 02:32:30 Manitoba, Canada
47527 2020-05-09 Canada New Brunswick     120 0 0 120 46.5653 -66.4619 2020-05-10 02:32:30 New Brunswick, Canada
47530 2020-05-09 Canada Newfoundland and Labrador     261 3 0 258 53.1355 -57.6604 2020-05-10 02:32:30 Newfoundland and Labrador, Canada
47534 2020-05-09 Canada Northwest Territories     5 0 0 5 64.8255 -124.8457 2020-05-10 02:32:30 Northwest Territories, Canada
47535 2020-05-09 Canada Nova Scotia     1011 47 0 964 44.681999999999995 -63.7443 2020-05-10 02:32:30 Nova Scotia, Canada
47536 2020-05-09 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-05-10 02:32:30 Nunavut, Canada
47537 2020-05-09 Canada Ontario     21148 1726 0 19422 51.2538 -85.3232 2020-05-10 02:32:30 Ontario, Canada
47538 2020-05-09 Canada Prince Edward Island     27 0 0 27 46.5107 -63.4168 2020-05-10 02:32:30 Prince Edward Island, Canada
47541 2020-05-09 Canada Quebec     36997 3668 0 34210 52.9399 -73.5491 2020-05-10 02:32:30 Quebec, Canada
47549 2020-05-09 Canada Saskatchewan     553 7 0 546 52.9399 -106.4509 2020-05-10 02:32:30 Saskatchewan, Canada
47566 2020-05-09 Canada Yukon     11 0 0 11 64.2823 -135.0 2020-05-10 02:32:30 Yukon, Canada
47834 2020-12-19 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-20 05:27:32 Diamond Princess, Canada
54840 2020-05-29 Canada Diamond Princess     1 1 0 0 0.0 0.0 2020-05-30 02:32:48 Diamond Princess, Canada
54965 2020-05-29 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-05-30 02:32:48 Nunavut, Canada
55344 2021-03-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
59328 2020-12-07 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-08 05:27:42 Diamond Princess, Canada
66468 2020-07-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-06 04:33:57 Diamond Princess, Canada
66667 2020-07-05 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-07-06 04:33:57 Nunavut, Canada
67222 2021-05-29 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
71206 2021-05-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
78464 2020-07-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-07-28 04:58:43 Diamond Princess, Canada
78671 2020-07-27 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-07-28 04:58:43 Nunavut, Canada
79117 2020-10-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-29 04:24:49 Diamond Princess, Canada
79124 2020-10-28 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-10-29 04:24:49 Nunavut, Canada
83083 2020-09-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-17 04:22:00 Diamond Princess, Canada
83090 2020-09-16 Canada Nunavut     0 0 0 0 70.2998 -83.1076 2020-09-17 04:22:00 Nunavut, Canada
87043 2020-10-09 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-10 04:23:57 Diamond Princess, 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]);