daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16,227 rows where country_or_region = "Canada" sorted by recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, day (date), last_update (date)
province_or_state 22
- British Columbia 1,067
- Ontario 1,035
- Alberta 1,026
- Quebec 1,026
- New Brunswick 1,024
- Manitoba 1,022
- Saskatchewan 1,022
- Newfoundland and Labrador 1,020
- Prince Edward Island 1,020
- Nova Scotia 1,016
- Grand Princess 1,015
- Northwest Territories 1,011
- Nunavut 1,010
- Yukon 1,009
- Diamond Princess 1,001
- Repatriated Travellers 766
- Recovered 51
- London, ON 34
- Toronto, ON 34
- Montreal, QC 13
- Calgary, Alberta 3
- Edmonton, Alberta 2
country_or_region 1
- Canada · 16,227 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▲ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | Canada | Ontario | 555177 | 9360 | 547673 | 1593 | 51.2538 | -85.3232 | 2021-08-05 04:21:51 | Ontario, Canada | ||
2021-08-03 | Canada | Ontario | 554903 | 9349 | 547531 | 1586 | 51.2538 | -85.3232 | 2021-08-04 04:21:25 | Ontario, Canada | ||
2021-08-02 | Canada | Ontario | 554687 | 9348 | 547153 | 1535 | 51.2538 | -85.3232 | 2021-08-03 04:21:39 | Ontario, Canada | ||
2021-08-01 | Canada | Ontario | 554537 | 9347 | 547121 | 1539 | 51.2538 | -85.3232 | 2021-08-02 04:21:36 | Ontario, Canada | ||
2021-07-31 | Canada | Ontario | 554376 | 9345 | 547010 | 1511 | 51.2538 | -85.3232 | 2021-08-01 04:21:50 | Ontario, Canada | ||
2021-07-30 | Canada | Ontario | 554177 | 9339 | 546916 | 1448 | 51.2538 | -85.3232 | 2021-07-31 04:21:35 | Ontario, Canada | ||
2021-07-29 | Canada | Ontario | 553945 | 9328 | 546761 | 1377 | 51.2538 | -85.3232 | 2021-07-30 04:21:34 | Ontario, Canada | ||
2021-07-28 | Canada | Ontario | 553697 | 9325 | 546590 | 1322 | 51.2538 | -85.3232 | 2021-07-29 04:21:33 | Ontario, Canada | ||
2021-07-27 | Canada | Ontario | 553459 | 9321 | 546438 | 1287 | 51.2538 | -85.3232 | 2021-07-28 04:21:39 | Ontario, Canada | ||
2021-07-26 | Canada | Ontario | 553286 | 9316 | 546262 | 1352 | 51.2538 | -85.3232 | 2021-07-27 04:21:18 | Ontario, Canada | ||
2021-07-25 | Canada | Ontario | 553155 | 9313 | 546062 | 1294 | 51.2538 | -85.3232 | 2021-07-26 04:21:28 | Ontario, Canada | ||
2021-07-24 | Canada | Ontario | 553019 | 9311 | 545920 | 1329 | 51.2538 | -85.3232 | 2021-07-25 04:22:12 | Ontario, Canada | ||
2021-07-23 | Canada | Ontario | 552872 | 9308 | 545825 | 1329 | 51.2538 | -85.3232 | 2021-07-24 00:21:36 | Ontario, Canada | ||
2021-07-22 | Canada | Ontario | 552691 | 9307 | 545662 | 1313 | 51.2538 | -85.3232 | 2021-07-23 04:21:29 | Ontario, Canada | ||
2021-07-21 | Canada | Ontario | 552495 | 9300 | 545512 | 1270 | 51.2538 | -85.3232 | 2021-07-22 04:21:19 | Ontario, Canada | ||
2021-07-20 | Canada | Ontario | 552319 | 9296 | 545379 | 1252 | 51.2538 | -85.3232 | 2021-07-21 04:21:40 | Ontario, Canada | ||
2021-07-19 | Canada | Ontario | 552153 | 9294 | 545205 | 1304 | 51.2538 | -85.3232 | 2021-07-20 04:21:48 | Ontario, Canada | ||
2021-07-18 | Canada | Ontario | 552012 | 9294 | 544995 | 1300 | 51.2538 | -85.3232 | 2021-07-19 04:21:24 | Ontario, Canada | ||
2021-07-17 | Canada | Ontario | 551884 | 9288 | 544879 | 1282 | 51.2538 | -85.3232 | 2021-07-18 04:22:07 | Ontario, Canada | ||
2021-07-16 | Canada | Ontario | 551730 | 9285 | 544709 | 1338 | 51.2538 | -85.3232 | 2021-07-17 04:22:22 | Ontario, Canada | ||
2021-07-15 | Canada | Ontario | 551558 | 9275 | 544530 | 1341 | 51.2538 | -85.3232 | 2021-07-16 04:21:22 | Ontario, Canada | ||
2021-07-14 | Canada | Ontario | 551370 | 9265 | 544379 | 1372 | 51.2538 | -85.3232 | 2021-07-15 04:21:48 | Ontario, Canada | ||
2021-07-13 | Canada | Ontario | 551225 | 9258 | 544165 | 1443 | 51.2538 | -85.3232 | 2021-07-14 04:21:35 | Ontario, Canada | ||
2021-07-12 | Canada | Ontario | 551068 | 9251 | 543954 | 1525 | 51.2538 | -85.3232 | 2021-07-13 04:21:18 | Ontario, Canada | ||
2021-07-11 | Canada | Ontario | 550954 | 9251 | 543715 | 1580 | 51.2538 | -85.3232 | 2021-07-12 04:21:34 | Ontario, Canada | ||
2021-07-10 | Canada | Ontario | 550825 | 9245 | 543530 | 1649 | 51.2538 | -85.3232 | 2021-07-11 04:21:43 | Ontario, Canada | ||
2021-07-09 | Canada | Ontario | 550668 | 9237 | 543379 | 1681 | 51.2538 | -85.3232 | 2021-07-10 04:21:25 | Ontario, Canada | ||
2021-07-08 | Canada | Ontario | 550496 | 9228 | 543134 | 1742 | 51.2538 | -85.3232 | 2021-07-09 04:21:21 | Ontario, Canada | ||
2021-07-07 | Canada | Ontario | 550337 | 9224 | 542903 | 1749 | 51.2538 | -85.3232 | 2021-07-08 04:21:26 | Ontario, Canada | ||
2021-07-06 | Canada | Ontario | 550110 | 9224 | 542619 | 1808 | 51.2538 | -85.3232 | 2021-07-07 04:21:20 | Ontario, Canada | ||
2021-07-05 | Canada | Ontario | 549888 | 9215 | 542430 | 1906 | 51.2538 | -85.3232 | 2021-07-06 04:21:32 | Ontario, Canada | ||
2021-07-04 | Canada | Ontario | 549754 | 9214 | 541977 | 1989 | 51.2538 | -85.3232 | 2021-07-05 04:21:28 | Ontario, Canada | ||
2021-07-03 | Canada | Ontario | 549596 | 9205 | 541759 | 2069 | 51.2538 | -85.3232 | 2021-07-04 04:21:38 | Ontario, Canada | ||
2021-07-02 | Canada | Ontario | 549377 | 9196 | 541529 | 2132 | 51.2538 | -85.3232 | 2021-07-03 04:21:37 | Ontario, Canada | ||
2021-07-01 | Canada | Ontario | 549179 | 9187 | 541073 | 2216 | 51.2538 | -85.3232 | 2021-07-02 04:21:47 | Ontario, Canada | ||
2021-06-30 | Canada | Ontario | 548993 | 9168 | 541033 | 2214 | 51.2538 | -85.3232 | 2021-07-01 04:21:19 | Ontario, Canada | ||
2021-06-29 | Canada | Ontario | 548760 | 9154 | 540594 | 2432 | 51.2538 | -85.3232 | 2021-06-30 04:21:41 | Ontario, Canada | ||
2021-06-28 | Canada | Ontario | 548523 | 9129 | 540214 | 2663 | 51.2538 | -85.3232 | 2021-06-29 04:21:28 | Ontario, Canada | ||
2021-06-27 | Canada | Ontario | 548331 | 9126 | 539504 | 2965 | 51.2538 | -85.3232 | 2021-06-28 04:21:29 | Ontario, Canada | ||
2021-06-26 | Canada | Ontario | 548125 | 9114 | 539256 | 3024 | 51.2538 | -85.3232 | 2021-06-27 04:21:39 | Ontario, Canada | ||
2021-06-25 | Canada | Ontario | 547882 | 9101 | 538876 | 3159 | 51.2538 | -85.3232 | 2021-06-26 04:21:43 | Ontario, Canada | ||
2021-06-24 | Canada | Ontario | 547576 | 9099 | 538533 | 3216 | 51.2538 | -85.3232 | 2021-06-25 04:21:33 | Ontario, Canada | ||
2021-06-23 | Canada | Ontario | 547278 | 9093 | 538183 | 3266 | 51.2538 | -85.3232 | 2021-06-24 04:21:55 | Ontario, Canada | ||
2021-06-22 | Canada | Ontario | 546986 | 9082 | 537644 | 3513 | 51.2538 | -85.3232 | 2021-06-23 04:21:46 | Ontario, Canada | ||
2021-06-21 | Canada | Ontario | 546708 | 9022 | 537340 | 3707 | 51.2538 | -85.3232 | 2021-06-22 04:21:34 | Ontario, Canada | ||
2021-06-20 | Canada | Ontario | 546508 | 9019 | 536374 | 4160 | 51.2538 | -85.3232 | 2021-06-21 04:21:41 | Ontario, Canada | ||
2021-06-19 | Canada | Ontario | 546240 | 9007 | 536047 | 4270 | 51.2538 | -85.3232 | 2021-06-20 04:21:48 | Ontario, Canada | ||
2021-06-18 | Canada | Ontario | 545958 | 8994 | 535668 | 4386 | 51.2538 | -85.3232 | 2021-06-19 04:22:33 | Ontario, Canada | ||
2021-06-17 | Canada | Ontario | 545634 | 8993 | 535219 | 4533 | 51.2538 | -85.3232 | 2021-06-18 04:22:16 | Ontario, Canada | ||
2021-06-16 | Canada | Ontario | 545280 | 8986 | 534694 | 4708 | 51.2538 | -85.3232 | 2021-06-17 04:22:36 | Ontario, Canada | ||
2021-06-15 | Canada | Ontario | 544916 | 8974 | 534007 | 4978 | 51.2538 | -85.3232 | 2021-06-16 04:22:32 | Ontario, Canada | ||
2021-06-14 | Canada | Ontario | 544536 | 8961 | 533335 | 5361 | 51.2538 | -85.3232 | 2021-06-15 04:22:22 | Ontario, Canada | ||
2021-06-13 | Canada | Ontario | 544180 | 8957 | 532339 | 5738 | 51.2538 | -85.3232 | 2021-06-14 04:22:46 | Ontario, Canada | ||
2021-06-12 | Canada | Ontario | 543822 | 8950 | 531802 | 5872 | 51.2538 | -85.3232 | 2021-06-13 04:22:44 | Ontario, Canada | ||
2021-06-11 | Canada | Ontario | 543395 | 8935 | 531275 | 6014 | 51.2538 | -85.3232 | 2021-06-12 04:22:22 | Ontario, Canada | ||
2021-06-10 | Canada | Ontario | 542882 | 8931 | 530546 | 6215 | 51.2538 | -85.3232 | 2021-06-11 04:23:20 | Ontario, Canada | ||
2021-06-09 | Canada | Ontario | 542357 | 8920 | 529717 | 6480 | 51.2538 | -85.3232 | 2021-06-10 04:23:17 | Ontario, Canada | ||
2021-06-08 | Canada | Ontario | 541757 | 8887 | 528816 | 6933 | 51.2538 | -85.3232 | 2021-06-09 04:23:31 | Ontario, Canada | ||
2021-06-07 | Canada | Ontario | 541231 | 8869 | 527970 | 7524 | 51.2538 | -85.3232 | 2021-06-08 04:22:35 | Ontario, Canada | ||
2021-06-06 | Canada | Ontario | 540795 | 8854 | 526480 | 8267 | 51.2538 | -85.3232 | 2021-06-07 04:22:51 | Ontario, Canada | ||
2021-06-05 | Canada | Ontario | 540305 | 8844 | 525521 | 8585 | 51.2538 | -85.3232 | 2021-06-06 04:24:03 | Ontario, Canada | ||
2021-06-04 | Canada | Ontario | 539713 | 8820 | 524973 | 8733 | 51.2538 | -85.3232 | 2021-06-05 04:23:03 | Ontario, Canada | ||
2021-06-03 | Canada | Ontario | 539004 | 8801 | 523853 | 8987 | 51.2538 | -85.3232 | 2021-06-04 04:23:37 | Ontario, Canada | ||
2021-06-02 | Canada | Ontario | 538148 | 8791 | 522551 | 9421 | 51.2538 | -85.3232 | 2021-06-03 04:23:32 | Ontario, Canada | ||
2021-06-01 | Canada | Ontario | 537291 | 8766 | 520983 | 10161 | 51.2538 | -85.3232 | 2021-06-02 04:24:34 | Ontario, Canada | ||
2021-05-31 | Canada | Ontario | 536474 | 8757 | 519368 | 11071 | 51.2538 | -85.3232 | 2021-06-01 04:23:09 | Ontario, Canada | ||
2021-05-30 | Canada | Ontario | 535790 | 8744 | 516826 | 12349 | 51.2538 | -85.3232 | 2021-05-31 03:08:59 | Ontario, Canada | ||
2021-05-29 | Canada | Ontario | 535100 | 8726 | 515505 | 12907 | 51.2538 | -85.3232 | 2021-05-30 04:20:55 | Ontario, Canada | ||
2021-05-28 | Canada | Ontario | 534047 | 8711 | 514081 | 13482 | 51.2538 | -85.3232 | 2021-05-29 04:20:41 | Ontario, Canada | ||
2021-05-27 | Canada | Ontario | 533011 | 8697 | 511977 | 14413 | 51.2538 | -85.3232 | 2021-05-28 04:20:36 | Ontario, Canada | ||
2021-05-26 | Canada | Ontario | 531794 | 8678 | 506713 | 16807 | 51.2538 | -85.3232 | 2021-05-27 04:20:59 | Ontario, Canada | ||
2021-05-25 | Canada | Ontario | 530593 | 8655 | 505210 | 17497 | 51.2538 | -85.3232 | 2021-05-26 04:20:35 | Ontario, Canada | ||
2021-05-24 | Canada | Ontario | 529589 | 8622 | 503111 | 18371 | 51.2538 | -85.3232 | 2021-05-25 04:21:08 | Ontario, Canada | ||
2021-05-23 | Canada | Ontario | 528576 | 8614 | 502392 | 18742 | 51.2538 | -85.3232 | 2021-05-24 04:20:53 | Ontario, Canada | ||
2021-05-22 | Canada | Ontario | 527341 | 8599 | 500792 | 19125 | 51.2538 | -85.3232 | 2021-05-23 04:20:51 | Ontario, Canada | ||
2021-05-21 | Canada | Ontario | 525749 | 8579 | 499048 | 19484 | 51.2538 | -85.3232 | 2021-05-22 04:20:45 | Ontario, Canada | ||
2021-05-20 | Canada | Ontario | 523866 | 8552 | 496573 | 20240 | 51.2538 | -85.3232 | 2021-05-21 04:20:43 | Ontario, Canada | ||
2021-05-19 | Canada | Ontario | 522059 | 8525 | 494097 | 20564 | 51.2538 | -85.3232 | 2021-05-20 04:21:05 | Ontario, Canada | ||
2021-05-18 | Canada | Ontario | 519944 | 8506 | 491340 | 21185 | 51.2538 | -85.3232 | 2021-05-19 04:20:42 | Ontario, Canada | ||
2021-05-17 | Canada | Ontario | 518021 | 8489 | 488628 | 22459 | 51.2538 | -85.3232 | 2021-05-18 04:20:33 | Ontario, Canada | ||
2021-05-16 | Canada | Ontario | 516409 | 8485 | 483992 | 24030 | 51.2538 | -85.3232 | 2021-05-17 04:20:34 | Ontario, Canada | ||
2021-05-15 | Canada | Ontario | 514685 | 8455 | 481991 | 24461 | 51.2538 | -85.3232 | 2021-05-16 04:20:49 | Ontario, Canada | ||
2021-05-14 | Canada | Ontario | 512473 | 8431 | 479911 | 24765 | 51.2538 | -85.3232 | 2021-05-15 04:20:58 | Ontario, Canada | ||
2021-05-13 | Canada | Ontario | 510049 | 8405 | 475502 | 26044 | 51.2538 | -85.3232 | 2021-05-14 04:20:41 | Ontario, Canada | ||
2021-05-12 | Canada | Ontario | 507662 | 8374 | 473340 | 26329 | 51.2538 | -85.3232 | 2021-05-13 04:20:51 | Ontario, Canada | ||
2021-05-11 | Canada | Ontario | 505056 | 8342 | 470083 | 26939 | 51.2538 | -85.3232 | 2021-05-12 04:21:29 | Ontario, Canada | ||
2021-05-10 | Canada | Ontario | 502460 | 8327 | 466856 | 28113 | 51.2538 | -85.3232 | 2021-05-11 04:20:41 | Ontario, Canada | ||
2021-05-09 | Canada | Ontario | 500347 | 8308 | 461801 | 29137 | 51.2538 | -85.3232 | 2021-05-10 04:20:38 | Ontario, Canada | ||
2021-05-08 | Canada | Ontario | 498040 | 8261 | 459438 | 29333 | 51.2538 | -85.3232 | 2021-05-09 04:20:35 | Ontario, Canada | ||
2021-05-07 | Canada | Ontario | 495355 | 8236 | 457032 | 29616 | 51.2538 | -85.3232 | 2021-05-08 04:21:04 | Ontario, Canada | ||
2021-05-06 | Canada | Ontario | 492355 | 8213 | 453379 | 30334 | 51.2538 | -85.3232 | 2021-05-07 04:20:40 | Ontario, Canada | ||
2021-05-05 | Canada | Ontario | 488978 | 8187 | 449670 | 30678 | 51.2538 | -85.3232 | 2021-05-06 04:20:38 | Ontario, Canada | ||
2021-05-04 | Canada | Ontario | 485692 | 8143 | 445861 | 31165 | 51.2538 | -85.3232 | 2021-05-05 04:20:43 | Ontario, Canada | ||
2021-05-03 | Canada | Ontario | 482801 | 8118 | 442002 | 32327 | 51.2538 | -85.3232 | 2021-05-04 04:20:34 | Ontario, Canada | ||
2021-05-02 | Canada | Ontario | 480173 | 8102 | 436048 | 32988 | 51.2538 | -85.3232 | 2021-05-03 04:20:39 | Ontario, Canada | ||
2021-05-01 | Canada | Ontario | 477228 | 8079 | 433460 | 33056 | 51.2538 | -85.3232 | 2021-05-02 04:20:48 | Ontario, Canada | ||
2021-04-30 | Canada | Ontario | 473522 | 8050 | 430586 | 33655 | 51.2538 | -85.3232 | 2021-05-01 04:20:47 | Ontario, Canada | ||
2021-04-29 | Canada | Ontario | 470141 | 8029 | 426425 | 34031 | 51.2538 | -85.3232 | 2021-04-30 04:21:03 | Ontario, Canada | ||
2021-04-28 | Canada | Ontario | 466331 | 7988 | 420930 | 34852 | 51.2538 | -85.3232 | 2021-04-29 04:20:55 | Ontario, Canada | ||
2021-04-27 | Canada | Ontario | 462304 | 7964 | 416751 | 35075 | 51.2538 | -85.3232 | 2021-04-28 04:20:32 | Ontario, Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;