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

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
4039 2020-12-05 Canada Alberta     66730 596 47328 18806 53.9333 -116.5765 2020-12-06 05:26:18 Alberta, Canada
10995 2020-06-09 Canada Alberta     7229 151 6722 356 53.9333 -116.5765 2020-06-10 04:07:00 Alberta, Canada
11705 2021-04-28 Canada Alberta     186679 2073 163668 20938 53.9333 -116.5765 2021-04-29 04:20:55 Alberta, Canada
17974 2020-04-03 Canada Alberta     969 13 0 0 53.9333 -116.5765 2020-04-03 22:52:30 Alberta, Canada
21323 2020-06-17 Canada Alberta     7530 151 6893 486 53.9333 -116.5765 2020-06-18 04:33:18 Alberta, Canada
22281 2021-03-12 Canada Alberta     137562 1935 131081 4546 53.9333 -116.5765 2021-03-13 05:25:15 Alberta, Canada
29441 2020-08-02 Canada Alberta     10843 196 9261 1386 53.9333 -116.5765 2020-08-03 04:34:35 Alberta, Canada
30200 2020-10-09 Canada Alberta     19995 283 17488 2224 53.9333 -116.5765 2020-10-10 04:23:57 Alberta, Canada
34164 2020-08-21 Canada Alberta     12748 230 11374 1144 53.9333 -116.5765 2020-08-22 04:27:49 Alberta, Canada
38132 2021-04-29 Canada Alberta     188727 2075 165267 21385 53.9333 -116.5765 2021-04-30 04:21:03 Alberta, Canada
42118 2021-02-26 Canada Alberta     132788 1877 126406 4505 53.9333 -116.5765 2021-02-27 05:22:28 Alberta, Canada
46104 2020-12-31 Canada Alberta     100428 1046 84827 14555 53.9333 -116.5765 2021-01-01 05:23:07 Alberta, Canada
50076 2020-09-24 Canada Alberta     17190 261 15467 1462 53.9333 -116.5765 2020-09-25 04:23:00 Alberta, Canada
54051 2021-05-22 Canada Alberta     223632 2170 205960 15502 53.9333 -116.5765 2021-05-23 04:20:51 Alberta, Canada
60866 2020-04-30 Canada Alberta     5355 90 0 5265 53.9333 -116.5765 2020-05-01 02:32:28 Alberta, Canada
64106 2020-05-10 Canada Alberta     6253 117 0 6136 53.9333 -116.5765 2020-05-11 02:32:30 Alberta, Canada
64484 2020-03-17 Canada Alberta     74 0 0   53.9333 -116.5765 2020-03-17T03:13:18  
64742 2021-05-18 Canada Alberta     220559 2152 198394 20013 53.9333 -116.5765 2021-05-19 04:20:42 Alberta, Canada
68857 2021-01-08 Canada Alberta     109652 1241 94783 13628 53.9333 -116.5765 2021-01-09 05:22:18 Alberta, Canada
73089 2021-04-04 Canada Alberta     150307 1994 138560 9753 53.9333 -116.5765 2021-04-05 04:20:35 Alberta, Canada
79959 2020-05-09 Canada Alberta     6157 116 0 6041 53.9333 -116.5765 2020-05-10 02:32:30 Alberta, Canada
80413 2021-06-12 Canada Alberta     230298 2269 224782 3247 53.9333 -116.5765 2021-06-13 04:22:44 Alberta, Canada
87450 2020-07-03 Canada Alberta     8259 155 7532 572 53.9333 -116.5765 2020-07-04 04:33:51 Alberta, Canada
88205 2021-04-06 Canada Alberta     154125 2001 141315 10809 53.9333 -116.5765 2021-04-07 04:20:53 Alberta, Canada
92191 2021-01-09 Canada Alberta     110641 1272 94932 14437 53.9333 -116.5765 2021-01-10 05:22:12 Alberta, Canada
96175 2021-04-22 Canada Alberta     177087 2054 155851 19182 53.9333 -116.5765 2021-04-23 04:20:52 Alberta, Canada
100211 2021-02-23 Canada Alberta     131603 1853 125234 4516 53.9333 -116.5765 2021-02-24 05:29:16 Alberta, Canada
104186 2020-09-25 Canada Alberta     17343 261 15585 1497 53.9333 -116.5765 2020-09-26 04:23:00 Alberta, Canada
108161 2020-12-28 Canada Alberta     98269 1002 81780 15487 53.9333 -116.5765 2020-12-29 05:22:37 Alberta, Canada
112133 2020-10-26 Canada Alberta     25733 307 20949 4477 53.9333 -116.5765 2020-10-27 04:24:45 Alberta, Canada
116111 2021-02-21 Canada Alberta     131063 1827 124478 4758 53.9333 -116.5765 2021-02-22 05:24:21 Alberta, Canada
122242 2020-04-01 Canada Alberta     754 9 0 0 53.9333 -116.5765 2020-04-01 22:04:44 Alberta, Canada
122587 2021-04-05 Canada Alberta     153194 1998 140614 10582 53.9333 -116.5765 2021-04-06 04:20:32 Alberta, Canada
126562 2020-09-29 Canada Alberta     17909 266 16072 1571 53.9333 -116.5765 2020-09-30 04:23:33 Alberta, Canada
133714 2020-08-06 Canada Alberta     11296 205 9984 1107 53.9333 -116.5765 2020-08-07 04:35:11 Alberta, Canada
134486 2021-01-19 Canada Alberta     117767 1463 105208 11096 53.9333 -116.5765 2021-01-20 05:21:54 Alberta, Canada
141643 2020-07-30 Canada Alberta     10716 195 9113 1408 53.9333 -116.5765 2020-07-31 04:35:18 Alberta, Canada
145478 2020-07-11 Canada Alberta     8596 160 7844 592 53.9333 -116.5765 2020-07-12 04:34:30 Alberta, Canada
149242 2020-06-21 Canada Alberta     7704 152 7018 534 53.9333 -116.5765 2020-06-22 04:33:20 Alberta, Canada
149997 2020-11-19 Canada Alberta     42797 451 31964 10382 53.9333 -116.5765 2020-11-20 05:26:28 Alberta, Canada
154034 2020-12-23 Canada Alberta     93781 890 75070 17821 53.9333 -116.5765 2020-12-24 05:23:04 Alberta, Canada
160582 2020-04-09 Canada Alberta     1423 29 0 0 53.9333 -116.5765 2020-04-09 23:09:01 Alberta, Canada
160922 2020-11-02 Canada Alberta     27664 323 22169 5172 53.9333 -116.5765 2020-11-03 06:00:16 Alberta, Canada
167813 2020-05-19 Canada Alberta     6716 128 5584 1004 53.9333 -116.5765 2020-05-20 02:32:19 Alberta, Canada
168223 2021-06-19 Canada Alberta     231259 2289 226800 2170 53.9333 -116.5765 2021-06-20 04:21:48 Alberta, Canada
172209 2021-03-09 Canada Alberta     136374 1926 129978 4470 53.9333 -116.5765 2021-03-10 05:24:35 Alberta, Canada
179084 2020-05-12 Canada Alberta     6345 118 0 6227 53.9333 -116.5765 2020-05-13 03:32:26 Alberta, Canada
179464 2020-03-19 Canada Alberta     119 0 0   53.9333 -116.5765 2020-03-19T03:13:26  
179736 2020-12-04 Canada Alberta     64851 590 46018 18243 53.9333 -116.5765 2020-12-05 05:27:36 Alberta, Canada
186689 2020-06-07 Canada Alberta     7138 146 6656 336 53.9333 -116.5765 2020-06-08 03:33:22 Alberta, Canada
187399 2021-02-20 Canada Alberta     130735 1818 124114 4803 53.9333 -116.5765 2021-02-21 05:24:33 Alberta, Canada
194559 2020-08-03 Canada Alberta     10843 196 9261 1386 53.9333 -116.5765 2020-08-04 04:41:59 Alberta, Canada
195318 2020-08-28 Canada Alberta     13476 237 12054 1185 53.9333 -116.5765 2020-08-29 04:28:19 Alberta, Canada
199276 2020-08-24 Canada Alberta     13006 234 11600 1172 53.9333 -116.5765 2020-08-25 04:28:02 Alberta, Canada
206347 2020-03-22 Canada Alberta     259 1 0 0 53.9333 -116.5765 3/22/20 23:48 Alberta, Canada
206669 2021-02-22 Canada Alberta     131336 1843 124818 4675 53.9333 -116.5765 2021-02-23 05:23:41 Alberta, Canada
210644 2020-11-08 Canada Alberta     33504 363 24684 8457 53.9333 -116.5765 2020-11-09 05:25:45 Alberta, Canada
214624 2021-01-13 Canada Alberta     113618 1368 99412 12838 53.9333 -116.5765 2021-01-14 05:22:32 Alberta, Canada
221701 2020-03-25 Canada Alberta     358 2 0 0 53.9333 -116.5765 2020-03-25 23:37:36 Alberta, Canada
225091 2020-07-07 Canada Alberta     8436 157 7659 620 53.9333 -116.5765 2020-07-08 05:33:48 Alberta, Canada
225847 2020-11-28 Canada Alberta     54836 524 39381 14931 53.9333 -116.5765 2020-11-29 05:25:55 Alberta, Canada
229830 2021-03-19 Canada Alberta     140823 1957 133437 5429 53.9333 -116.5765 2021-03-20 05:25:46 Alberta, Canada
233805 2020-09-21 Canada Alberta     16739 256 15024 1459 53.9333 -116.5765 2020-09-22 04:23:00 Alberta, Canada
237780 2021-04-16 Canada Alberta     167793 2034 149000 16759 53.9333 -116.5765 2021-04-17 04:20:40 Alberta, Canada
241755 2020-08-22 Canada Alberta     12748 230 11374 1144 53.9333 -116.5765 2020-08-23 04:27:48 Alberta, Canada
248822 2020-03-29 Canada Alberta     621 2 0 0 53.9333 -116.5765 3/29/20 23:13 Alberta, Canada
252107 2020-05-27 Canada Alberta     6926 141 6106 679 53.9333 -116.5765 2020-05-28 02:32:31 Alberta, Canada
252664 2021-03-10 Canada Alberta     136773 1928 130382 4463 53.9333 -116.5765 2021-03-11 05:25:48 Alberta, Canada
256650 2021-02-16 Canada Alberta     129338 1791 122554 4993 53.9333 -116.5765 2021-02-17 05:23:10 Alberta, Canada
260636 2020-11-29 Canada Alberta     56444 533 40219 15692 53.9333 -116.5765 2020-11-30 05:26:13 Alberta, Canada
267672 2020-07-05 Canada Alberta     8259 155 7532 572 53.9333 -116.5765 2020-07-06 04:33:57 Alberta, Canada
271309 2020-05-08 Canada Alberta     6098 115 0 5983 53.9333 -116.5765 2020-05-09 02:32:35 Alberta, Canada
271654 2020-10-19 Canada Alberta     22673 292 19243 3138 53.9333 -116.5765 2020-10-20 04:24:22 Alberta, Canada
275632 2021-03-14 Canada Alberta     138424 1946 131781 4697 53.9333 -116.5765 2021-03-15 05:25:51 Alberta, Canada
279618 2021-01-23 Canada Alberta     120330 1525 109078 9727 53.9333 -116.5765 2021-01-24 05:22:35 Alberta, Canada
283593 2020-10-02 Canada Alberta     18357 272 16527 1558 53.9333 -116.5765 2020-10-03 04:23:40 Alberta, Canada
287568 2021-01-07 Canada Alberta     108469 1217 93954 13298 53.9333 -116.5765 2021-01-08 05:22:42 Alberta, Canada
291552 2021-06-01 Canada Alberta     227718 2228 218719 6771 53.9333 -116.5765 2021-06-02 04:24:34 Alberta, Canada
295538 2020-12-13 Canada Alberta     80099 719 58818 20562 53.9333 -116.5765 2020-12-14 05:26:27 Alberta, Canada
302440 2020-05-01 Canada Alberta     5573 92 0 5481 53.9333 -116.5765 2020-05-02 02:32:27 Alberta, Canada
302794 2020-11-26 Canada Alberta     51878 510 37316 14052 53.9333 -116.5765 2020-11-27 05:26:53 Alberta, Canada
306793 2020-03-21 Canada Alberta     195 1 0   53.9333 -116.5765 2020-03-21T02:43:03  
310017 2020-05-23 Canada Alberta     6818 135 5869 814 53.9333 -116.5765 2020-05-24 02:32:43 Alberta, Canada
310487 2020-08-31 Canada Alberta     13902 239 12293 1370 53.9333 -116.5765 2020-09-01 04:28:31 Alberta, Canada
317381 2020-05-20 Canada Alberta     6735 128 5637 970 53.9333 -116.5765 2020-05-21 02:32:48 Alberta, Canada
317862 2021-06-03 Canada Alberta     228424 2236 220357 5831 53.9333 -116.5765 2021-06-04 04:23:37 Alberta, Canada
321848 2020-11-16 Canada Alberta     40189 427 29731 10031 53.9333 -116.5765 2020-11-17 05:25:54 Alberta, Canada
328683 2020-05-04 Canada Alberta     5836 104 0 5732 53.9333 -116.5765 2020-05-05 02:32:34 Alberta, Canada
332214 2020-08-10 Canada Alberta     11687 213 10384 1090 53.9333 -116.5765 2020-08-11 04:35:08 Alberta, Canada
336076 2020-03-26 Canada Alberta     486 2 0 0 53.9333 -116.5765 2020-03-26 23:53:11 Alberta, Canada
336414 2021-03-05 Canada Alberta     135196 1913 128644 4639 53.9333 -116.5765 2021-03-06 04:23:41 Alberta, Canada
343410 2020-06-22 Canada Alberta     7736 153 7041 542 53.9333 -116.5765 2020-06-23 04:33:22 Alberta, Canada
344154 2020-08-30 Canada Alberta     13476 237 12054 1185 53.9333 -116.5765 2020-08-31 04:28:27 Alberta, Canada
348123 2021-02-27 Canada Alberta     133203 1883 126774 4546 53.9333 -116.5765 2021-02-28 05:22:20 Alberta, Canada
352154 2021-01-06 Canada Alberta     107501 1193 92858 13450 53.9333 -116.5765 2021-01-07 05:22:03 Alberta, Canada
356127 2020-09-18 Canada Alberta     16381 255 14702 1424 53.9333 -116.5765 2020-09-19 04:22:00 Alberta, Canada
360100 2021-06-07 Canada Alberta     229319 2248 222364 4707 53.9333 -116.5765 2021-06-08 04:22:35 Alberta, Canada
364086 2020-11-13 Canada Alberta     37312 398 28321 8593 53.9333 -116.5765 2020-11-14 05:25:37 Alberta, Canada
368102 2020-03-15 Canada Alberta     39 0 0   53.9333 -116.5765 2020-03-15T01:53:03  

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]);