⚠️ 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

4,928 rows where country_or_region = "Canada" sorted by day descending

View and edit SQL

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

country_or_region

  • Canada · 4,928
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
89444 2021-01-22 Canada Alberta     119757 1512 108258 9987 53.9333 -116.5765 2021-01-23 05:22:03 Alberta, Canada
89445 2021-01-22 Canada British Columbia     63484 1128 56455 5901 53.7267 -127.6476 2021-01-23 05:22:03 British Columbia, Canada
89446 2021-01-22 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
89447 2021-01-22 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
89448 2021-01-22 Canada Manitoba     28260 795 24204 3261 53.7609 -98.8139 2021-01-23 05:22:03 Manitoba, Canada
89449 2021-01-22 Canada New Brunswick     1087 13 742 332 46.5653 -66.4619 2021-01-23 05:22:03 New Brunswick, Canada
89450 2021-01-22 Canada Newfoundland and Labrador     398 4 384 10 53.1355 -57.6604 2021-01-23 05:22:03 Newfoundland and Labrador, Canada
89451 2021-01-22 Canada Northwest Territories     31 0 24 7 64.8255 -124.8457 2021-01-23 05:22:03 Northwest Territories,Canada
89452 2021-01-22 Canada Nova Scotia     1570 65 1483 22 44.682 -63.7443 2021-01-23 05:22:03 Nova Scotia, Canada
89453 2021-01-22 Canada Nunavut     267 1 265 1 70.2998 -83.1076 2021-01-23 05:22:03 Nunavut, Canada
89454 2021-01-22 Canada Ontario     255074 5724 225605 23745 51.2538 -85.3232 2021-01-23 05:22:03 Ontario, Canada
89455 2021-01-22 Canada Prince Edward Island     110 0 103 7 46.5107 -63.4168 2021-01-23 05:22:03 Prince Edward Island, Canada
89456 2021-01-22 Canada Quebec     250491 9142 223367 17982 52.9399 -73.5491 2021-01-23 05:22:03 Quebec, Canada
89457 2021-01-22 Canada Repatriated Travellers     13 0 13 0     2021-01-23 05:22:03 Repatriated Travellers, Canada
89458 2021-01-22 Canada Saskatchewan     21643 247 18200 3196 52.9399 -106.4509 2021-01-23 05:22:03 Saskatchewan, Canada
89459 2021-01-22 Canada Yukon     70 1 69 0 64.2823 -135.0 2021-01-23 05:22:03 Yukon, Canada
302350 2021-01-21 Canada Alberta     119114 1500 107358 10256 53.9333 -116.5765 2021-01-22 05:22:10 Alberta, Canada
302351 2021-01-21 Canada British Columbia     62976 1119 56010 5847 53.7267 -127.6476 2021-01-22 05:22:10 British Columbia, Canada
302352 2021-01-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
302353 2021-01-21 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
302354 2021-01-21 Canada Manitoba     28089 793 24091 3205 53.7609 -98.8139 2021-01-22 05:22:10 Manitoba, Canada
302355 2021-01-21 Canada New Brunswick     1057 13 719 325 46.5653 -66.4619 2021-01-22 05:22:10 New Brunswick, Canada
302356 2021-01-21 Canada Newfoundland and Labrador     397 4 384 9 53.1355 -57.6604 2021-01-22 05:22:10 Newfoundland and Labrador, Canada
302357 2021-01-21 Canada Northwest Territories     31 0 24 7 64.8255 -124.8457 2021-01-22 05:22:10 Northwest Territories,Canada
302358 2021-01-21 Canada Nova Scotia     1565 65 1479 21 44.682 -63.7443 2021-01-22 05:22:10 Nova Scotia, Canada
302359 2021-01-21 Canada Nunavut     266 1 265 0 70.2998 -83.1076 2021-01-22 05:22:10 Nunavut, Canada
302360 2021-01-21 Canada Ontario     252542 5632 222391 24519 51.2538 -85.3232 2021-01-22 05:22:10 Ontario, Canada
302361 2021-01-21 Canada Prince Edward Island     110 0 103 7 46.5107 -63.4168 2021-01-22 05:22:10 Prince Edward Island, Canada
302362 2021-01-21 Canada Quebec     248860 9142 221327 18391 52.9399 -73.5491 2021-01-22 05:22:10 Quebec, Canada
302363 2021-01-21 Canada Repatriated Travellers     13 0 13 0     2021-01-22 05:22:10 Repatriated Travellers, Canada
302364 2021-01-21 Canada Saskatchewan     21338 239 18000 3099 52.9399 -106.4509 2021-01-22 05:22:10 Saskatchewan, Canada
302365 2021-01-21 Canada Yukon     70 1 69 0 64.2823 -135.0 2021-01-22 05:22:10 Yukon, Canada
893402 2021-01-20 Canada Alberta     118436 1484 106387 10565 53.9333 -116.5765 2021-01-21 05:22:01 Alberta, Canada
893403 2021-01-20 Canada British Columbia     62412 1104 55564 5744 53.7267 -127.6476 2021-01-21 05:22:01 British Columbia, Canada
893404 2021-01-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
893405 2021-01-20 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
893406 2021-01-20 Canada Manitoba     27893 788 23968 3137 53.7609 -98.8139 2021-01-21 05:22:01 Manitoba, Canada
893407 2021-01-20 Canada New Brunswick     1025 13 694 318 46.5653 -66.4619 2021-01-21 05:22:01 New Brunswick, Canada
893408 2021-01-20 Canada Newfoundland and Labrador     396 4 384 8 53.1355 -57.6604 2021-01-21 05:22:01 Newfoundland and Labrador, Canada
893409 2021-01-20 Canada Northwest Territories     31 0 24 7 64.8255 -124.8457 2021-01-21 05:22:01 Northwest Territories,Canada
893410 2021-01-20 Canada Nova Scotia     1564 65 1476 23 44.682 -63.7443 2021-01-21 05:22:01 Nova Scotia, Canada
893411 2021-01-20 Canada Nunavut     266 1 265 0 70.2998 -83.1076 2021-01-21 05:22:01 Nunavut, Canada
893412 2021-01-20 Canada Ontario     249753 5587 219231 24935 51.2538 -85.3232 2021-01-21 05:22:01 Ontario, Canada
893413 2021-01-20 Canada Prince Edward Island     110 0 103 7 46.5107 -63.4168 2021-01-21 05:22:01 Prince Edward Island, Canada
893414 2021-01-20 Canada Quebec     247236 9142 219592 18502 52.9399 -73.5491 2021-01-21 05:22:01 Quebec, Canada
893415 2021-01-20 Canada Repatriated Travellers     13 0 13 0     2021-01-21 05:22:01 Repatriated Travellers, Canada
893416 2021-01-20 Canada Saskatchewan     21112 226 17184 3702 52.9399 -106.4509 2021-01-21 05:22:01 Saskatchewan, Canada
893417 2021-01-20 Canada Yukon     70 1 69 0 64.2823 -135.0 2021-01-21 05:22:01 Yukon, Canada
321969 2021-01-19 Canada Alberta     117767 1463 105208 11096 53.9333 -116.5765 2021-01-20 05:21:54 Alberta, Canada
321970 2021-01-19 Canada British Columbia     61912 1090 55099 5723 53.7267 -127.6476 2021-01-20 05:21:54 British Columbia, Canada
321971 2021-01-19 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
321972 2021-01-19 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
321973 2021-01-19 Canada Manitoba     27740 783 23869 3088 53.7609 -98.8139 2021-01-20 05:21:54 Manitoba, Canada
321974 2021-01-19 Canada New Brunswick     1004 13 674 317 46.5653 -66.4619 2021-01-20 05:21:54 New Brunswick, Canada
321975 2021-01-19 Canada Newfoundland and Labrador     396 4 384 8 53.1355 -57.6604 2021-01-20 05:21:54 Newfoundland and Labrador, Canada
321976 2021-01-19 Canada Northwest Territories     28 0 24 4 64.8255 -124.8457 2021-01-20 05:21:54 Northwest Territories,Canada
321977 2021-01-19 Canada Nova Scotia     1561 65 1474 22 44.682 -63.7443 2021-01-20 05:21:54 Nova Scotia, Canada
321978 2021-01-19 Canada Nunavut     266 1 265 0 70.2998 -83.1076 2021-01-20 05:21:54 Nunavut, Canada
321979 2021-01-19 Canada Ontario     247144 5501 215872 25771 51.2538 -85.3232 2021-01-20 05:21:54 Ontario, Canada
321980 2021-01-19 Canada Prince Edward Island     110 0 103 7 46.5107 -63.4168 2021-01-20 05:21:54 Prince Edward Island, Canada
321981 2021-01-19 Canada Quebec     245734 9142 217575 19017 52.9399 -73.5491 2021-01-20 05:21:54 Quebec, Canada
321982 2021-01-19 Canada Repatriated Travellers     13 0 13 0     2021-01-20 05:21:54 Repatriated Travellers, Canada
321983 2021-01-19 Canada Saskatchewan     20871 225 16490 4156 52.9399 -106.4509 2021-01-20 05:21:54 Saskatchewan, Canada
321984 2021-01-19 Canada Yukon     70 1 69 0 64.2823 -135.0 2021-01-20 05:21:54 Yukon, Canada
573955 2021-01-18 Canada Alberta     117311 1447 103941 11923 53.9333 -116.5765 2021-01-19 05:22:15 Alberta, Canada
573956 2021-01-18 Canada British Columbia     61447 1078 54656 5713 53.7267 -127.6476 2021-01-19 05:22:15 British Columbia, Canada
573957 2021-01-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
573958 2021-01-18 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
573959 2021-01-18 Canada Manitoba     27629 773 23748 3108 53.7609 -98.8139 2021-01-19 05:22:15 Manitoba, Canada
573960 2021-01-18 Canada New Brunswick     973 12 656 305 46.5653 -66.4619 2021-01-19 05:22:15 New Brunswick, Canada
573961 2021-01-18 Canada Newfoundland and Labrador     396 4 383 9 53.1355 -57.6604 2021-01-19 05:22:15 Newfoundland and Labrador, Canada
573962 2021-01-18 Canada Northwest Territories     25 0 24 1 64.8255 -124.8457 2021-01-19 05:22:15 Northwest Territories,Canada
573963 2021-01-18 Canada Nova Scotia     1557 65 1467 25 44.682 -63.7443 2021-01-19 05:22:15 Nova Scotia, Canada
573964 2021-01-18 Canada Nunavut     266 1 265 0 70.2998 -83.1076 2021-01-19 05:22:15 Nunavut, Canada
573965 2021-01-18 Canada Ontario     244883 5442 212811 26630 51.2538 -85.3232 2021-01-19 05:22:15 Ontario, Canada
573966 2021-01-18 Canada Prince Edward Island     108 0 98 10 46.5107 -63.4168 2021-01-19 05:22:15 Prince Edward Island, Canada
573967 2021-01-18 Canada Quebec     244348 9087 215325 19936 52.9399 -73.5491 2021-01-19 05:22:15 Quebec, Canada
573968 2021-01-18 Canada Repatriated Travellers     13 0 13 0     2021-01-19 05:22:15 Repatriated Travellers, Canada
573969 2021-01-18 Canada Saskatchewan     20562 219 16078 4265 52.9399 -106.4509 2021-01-19 05:22:15 Saskatchewan, Canada
573970 2021-01-18 Canada Yukon     70 1 69 0 64.2823 -135.0 2021-01-19 05:22:15 Yukon, Canada
538518 2021-01-17 Canada Alberta     116837 1436 103167 12234 53.9333 -116.5765 2021-01-18 05:22:34 Alberta, Canada
538519 2021-01-17 Canada British Columbia     60117 1047 53115 5955 53.7267 -127.6476 2021-01-18 05:22:34 British Columbia, Canada
538520 2021-01-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
538521 2021-01-17 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
538522 2021-01-17 Canada Manitoba     27511 769 23661 3081 53.7609 -98.8139 2021-01-18 05:22:34 Manitoba, Canada
538523 2021-01-17 Canada New Brunswick     947 12 642 293 46.5653 -66.4619 2021-01-18 05:22:34 New Brunswick, Canada
538524 2021-01-17 Canada Newfoundland and Labrador     396 4 383 9 53.1355 -57.6604 2021-01-18 05:22:34 Newfoundland and Labrador, Canada
538525 2021-01-17 Canada Northwest Territories     25 0 24 1 64.8255 -124.8457 2021-01-18 05:22:34 Northwest Territories,Canada
538526 2021-01-17 Canada Nova Scotia     1558 65 1464 29 44.682 -63.7443 2021-01-18 05:22:34 Nova Scotia, Canada
538527 2021-01-17 Canada Nunavut     266 1 265 0 70.2998 -83.1076 2021-01-18 05:22:34 Nunavut, Canada
538528 2021-01-17 Canada Ontario     242339 5418 210004 26917 51.2538 -85.3232 2021-01-18 05:22:34 Ontario, Canada
538529 2021-01-17 Canada Prince Edward Island     103 0 95 8 46.5107 -63.4168 2021-01-18 05:22:34 Prince Edward Island, Canada
538530 2021-01-17 Canada Quebec     242714 9055 213008 20651 52.9399 -73.5491 2021-01-18 05:22:34 Quebec, Canada
538531 2021-01-17 Canada Repatriated Travellers     13 0 13 0     2021-01-18 05:22:34 Repatriated Travellers, Canada
538532 2021-01-17 Canada Saskatchewan     20272 215 15936 4121 52.9399 -106.4509 2021-01-18 05:22:34 Saskatchewan, Canada
538533 2021-01-17 Canada Yukon     70 1 67 2 64.2823 -135.0 2021-01-18 05:22:34 Yukon, Canada
619306 2021-01-16 Canada Alberta     116087 1417 101957 12713 53.9333 -116.5765 2021-01-17 05:22:17 Alberta, Canada
619307 2021-01-16 Canada British Columbia     60117 1047 53115 5955 53.7267 -127.6476 2021-01-17 05:22:17 British Columbia, Canada
619308 2021-01-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
619309 2021-01-16 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand 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]);