johns_hopkins_csse_daily_reports
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)
province_or_state 22
- British Columbia 1,067
- 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
- Ontario 935
- 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,127 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▲ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
887893 | 887893 | 2021-04-26 | Canada | Ontario | 458793 | 7935 | 412639 | 36179 | 51.2538 | -85.3232 | 2021-04-27 04:20:52 | Ontario, Canada | ||
954638 | 954638 | 2021-04-25 | Canada | Ontario | 455647 | 7911 | 408512 | 36914 | 51.2538 | -85.3232 | 2021-04-26 04:21:04 | Ontario, Canada | ||
3923785 | 3923785 | 2021-04-24 | Canada | Ontario | 451958 | 7887 | 404392 | 37167 | 51.2538 | -85.3232 | 2021-04-25 04:20:32 | Ontario, Canada | ||
1408816 | 1408816 | 2021-04-23 | Canada | Ontario | 448191 | 7863 | 400089 | 37455 | 51.2538 | -85.3232 | 2021-04-24 04:20:38 | Ontario, Canada | ||
1567879 | 1567879 | 2021-04-22 | Canada | Ontario | 444076 | 7829 | 395406 | 37824 | 51.2538 | -85.3232 | 2021-04-23 04:20:52 | Ontario, Canada | ||
3242100 | 3242100 | 2021-04-21 | Canada | Ontario | 439588 | 7789 | 390833 | 38071 | 51.2538 | -85.3232 | 2021-04-22 04:20:53 | Ontario, Canada | ||
2020496 | 2020496 | 2021-04-20 | Canada | Ontario | 435563 | 7757 | 384917 | 39992 | 51.2538 | -85.3232 | 2021-04-21 04:21:14 | Ontario, Canada | ||
2410617 | 2410617 | 2021-04-19 | Canada | Ontario | 431548 | 7735 | 381260 | 40245 | 51.2538 | -85.3232 | 2021-04-20 04:20:41 | Ontario, Canada | ||
3129294 | 3129294 | 2021-04-18 | Canada | Ontario | 427877 | 7716 | 377777 | 39361 | 51.2538 | -85.3232 | 2021-04-19 04:20:57 | Ontario, Canada | ||
982722 | 982722 | 2021-04-17 | Canada | Ontario | 423702 | 7698 | 374315 | 38228 | 51.2538 | -85.3232 | 2021-04-18 04:20:41 | Ontario, Canada | ||
169817 | 169817 | 2021-04-16 | Canada | Ontario | 419104 | 7664 | 370341 | 38136 | 51.2538 | -85.3232 | 2021-04-17 04:20:40 | Ontario, Canada | ||
2548648 | 2548648 | 2021-04-15 | Canada | Ontario | 415298 | 7639 | 366873 | 36834 | 51.2538 | -85.3232 | 2021-04-16 04:20:46 | Ontario, Canada | ||
295787 | 295787 | 2021-07-15 | Canada | Quebec | 376149 | 11232 | 364033 | 884 | 52.9399 | -73.5491 | 2021-07-16 04:21:22 | Quebec, Canada | ||
331681 | 331681 | 2021-08-04 | Canada | Quebec | 378157 | 11240 | 364033 | 2884 | 52.9399 | -73.5491 | 2021-08-05 04:21:51 | Quebec, Canada | ||
408069 | 408069 | 2021-07-28 | Canada | Quebec | 377034 | 11240 | 364033 | 1761 | 52.9399 | -73.5491 | 2021-07-29 04:21:33 | Quebec, Canada | ||
483365 | 483365 | 2021-07-19 | Canada | Quebec | 376431 | 11236 | 364033 | 1162 | 52.9399 | -73.5491 | 2021-07-20 04:21:48 | Quebec, Canada | ||
578607 | 578607 | 2021-07-13 | Canada | Quebec | 376077 | 11231 | 364033 | 813 | 52.9399 | -73.5491 | 2021-07-14 04:21:35 | Quebec, Canada | ||
1305930 | 1305930 | 2021-07-27 | Canada | Quebec | 376901 | 11240 | 364033 | 1628 | 52.9399 | -73.5491 | 2021-07-28 04:21:39 | Quebec, Canada | ||
1330022 | 1330022 | 2021-07-24 | Canada | Quebec | 376651 | 11239 | 364033 | 1379 | 52.9399 | -73.5491 | 2021-07-25 04:22:12 | Quebec, Canada | ||
1378282 | 1378282 | 2021-07-25 | Canada | Quebec | 376753 | 11240 | 364033 | 1480 | 52.9399 | -73.5491 | 2021-07-26 04:21:28 | Quebec, Canada | ||
2371286 | 2371286 | 2021-07-20 | Canada | Quebec | 376416 | 11236 | 364033 | 1147 | 52.9399 | -73.5491 | 2021-07-21 04:21:40 | Quebec, Canada | ||
2673588 | 2673588 | 2021-07-18 | Canada | Quebec | 376370 | 11236 | 364033 | 1101 | 52.9399 | -73.5491 | 2021-07-19 04:21:24 | Quebec, Canada | ||
2947131 | 2947131 | 2021-07-16 | Canada | Quebec | 376192 | 11235 | 364033 | 924 | 52.9399 | -73.5491 | 2021-07-17 04:22:22 | Quebec, Canada | ||
3015125 | 3015125 | 2021-08-01 | Canada | Quebec | 377644 | 11241 | 364033 | 2370 | 52.9399 | -73.5491 | 2021-08-02 04:21:36 | Quebec, Canada | ||
3137326 | 3137326 | 2021-07-23 | Canada | Quebec | 376530 | 11239 | 364033 | 1258 | 52.9399 | -73.5491 | 2021-07-24 00:21:36 | Quebec, Canada | ||
3218073 | 3218073 | 2021-07-26 | Canada | Quebec | 376828 | 11240 | 364033 | 1555 | 52.9399 | -73.5491 | 2021-07-27 04:21:18 | Quebec, Canada | ||
3295953 | 3295953 | 2021-07-30 | Canada | Quebec | 377297 | 11241 | 364033 | 2023 | 52.9399 | -73.5491 | 2021-07-31 04:21:35 | Quebec, Canada | ||
3331305 | 3331305 | 2021-07-21 | Canada | Quebec | 376519 | 11235 | 364033 | 1251 | 52.9399 | -73.5491 | 2021-07-22 04:21:19 | Quebec, Canada | ||
3385164 | 3385164 | 2021-07-29 | Canada | Quebec | 377172 | 11240 | 364033 | 1899 | 52.9399 | -73.5491 | 2021-07-30 04:21:34 | Quebec, Canada | ||
3467952 | 3467952 | 2021-08-03 | Canada | Quebec | 377973 | 11241 | 364033 | 2699 | 52.9399 | -73.5491 | 2021-08-04 04:21:25 | Quebec, Canada | ||
3476086 | 3476086 | 2021-07-22 | Canada | Quebec | 376429 | 11238 | 364033 | 1158 | 52.9399 | -73.5491 | 2021-07-23 04:21:29 | Quebec, Canada | ||
3631732 | 3631732 | 2021-07-14 | Canada | Quebec | 376109 | 11231 | 364033 | 845 | 52.9399 | -73.5491 | 2021-07-15 04:21:48 | Quebec, Canada | ||
3683226 | 3683226 | 2021-08-02 | Canada | Quebec | 377798 | 11241 | 364033 | 2524 | 52.9399 | -73.5491 | 2021-08-03 04:21:39 | Quebec, Canada | ||
3705900 | 3705900 | 2021-07-17 | Canada | Quebec | 376289 | 11236 | 364033 | 1020 | 52.9399 | -73.5491 | 2021-07-18 04:22:07 | Quebec, Canada | ||
3740856 | 3740856 | 2021-07-12 | Canada | Quebec | 375997 | 11231 | 364033 | 733 | 52.9399 | -73.5491 | 2021-07-13 04:21:18 | Quebec, Canada | ||
3903748 | 3903748 | 2021-07-31 | Canada | Quebec | 377486 | 11241 | 364033 | 2212 | 52.9399 | -73.5491 | 2021-08-01 04:21:50 | Quebec, Canada | ||
625653 | 625653 | 2021-07-10 | Canada | Quebec | 375883 | 11230 | 363775 | 878 | 52.9399 | -73.5491 | 2021-07-11 04:21:43 | Quebec, Canada | ||
829372 | 829372 | 2021-07-09 | Canada | Quebec | 375823 | 11230 | 363775 | 818 | 52.9399 | -73.5491 | 2021-07-10 04:21:25 | Quebec, Canada | ||
3659369 | 3659369 | 2021-07-11 | Canada | Quebec | 375937 | 11230 | 363775 | 932 | 52.9399 | -73.5491 | 2021-07-12 04:21:34 | Quebec, Canada | ||
1841718 | 1841718 | 2021-04-14 | Canada | Ontario | 410541 | 7610 | 363632 | 35321 | 51.2538 | -85.3232 | 2021-04-15 04:20:54 | Ontario, Canada | ||
778136 | 778136 | 2021-07-08 | Canada | Quebec | 375751 | 11229 | 363484 | 1038 | 52.9399 | -73.5491 | 2021-07-09 04:21:21 | Quebec, Canada | ||
1440358 | 1440358 | 2021-07-07 | Canada | Quebec | 375678 | 11219 | 363415 | 1044 | 52.9399 | -73.5491 | 2021-07-08 04:21:26 | Quebec, Canada | ||
2693463 | 2693463 | 2021-07-06 | Canada | Quebec | 375609 | 11218 | 363339 | 1052 | 52.9399 | -73.5491 | 2021-07-07 04:21:20 | Quebec, Canada | ||
1932212 | 1932212 | 2021-07-05 | Canada | Quebec | 375522 | 11218 | 363245 | 1059 | 52.9399 | -73.5491 | 2021-07-06 04:21:32 | Quebec, Canada | ||
1164943 | 1164943 | 2021-07-04 | Canada | Quebec | 375444 | 11217 | 362961 | 1266 | 52.9399 | -73.5491 | 2021-07-05 04:21:28 | Quebec, Canada | ||
1495377 | 1495377 | 2021-07-03 | Canada | Quebec | 375404 | 11217 | 362961 | 1226 | 52.9399 | -73.5491 | 2021-07-04 04:21:38 | Quebec, Canada | ||
2071692 | 2071692 | 2021-07-02 | Canada | Quebec | 375342 | 11217 | 362961 | 1164 | 52.9399 | -73.5491 | 2021-07-03 04:21:37 | Quebec, Canada | ||
1892916 | 1892916 | 2021-06-30 | Canada | Quebec | 375197 | 11210 | 362756 | 1231 | 52.9399 | -73.5491 | 2021-07-01 04:21:19 | Quebec, Canada | ||
2764708 | 2764708 | 2021-07-01 | Canada | Quebec | 375276 | 11210 | 362756 | 1310 | 52.9399 | -73.5491 | 2021-07-02 04:21:47 | Quebec, Canada | ||
400039 | 400039 | 2021-06-29 | Canada | Quebec | 375123 | 11207 | 362646 | 1270 | 52.9399 | -73.5491 | 2021-06-30 04:21:41 | Quebec, Canada | ||
3125282 | 3125282 | 2021-06-28 | Canada | Quebec | 375018 | 11203 | 362523 | 1292 | 52.9399 | -73.5491 | 2021-06-29 04:21:28 | Quebec, Canada | ||
1712100 | 1712100 | 2021-06-25 | Canada | Quebec | 374793 | 11202 | 362130 | 1461 | 52.9399 | -73.5491 | 2021-06-26 04:21:43 | Quebec, Canada | ||
2589777 | 2589777 | 2021-06-27 | Canada | Quebec | 374921 | 11202 | 362130 | 1589 | 52.9399 | -73.5491 | 2021-06-28 04:21:29 | Quebec, Canada | ||
3958281 | 3958281 | 2021-06-26 | Canada | Quebec | 374872 | 11202 | 362130 | 1540 | 52.9399 | -73.5491 | 2021-06-27 04:21:39 | Quebec, Canada | ||
2295225 | 2295225 | 2021-06-24 | Canada | Quebec | 374689 | 11202 | 361952 | 1535 | 52.9399 | -73.5491 | 2021-06-25 04:21:33 | Quebec, Canada | ||
2422665 | 2422665 | 2021-06-23 | Canada | Quebec | 374608 | 11198 | 361840 | 1570 | 52.9399 | -73.5491 | 2021-06-24 04:21:55 | Quebec, Canada | ||
562742 | 562742 | 2021-06-22 | Canada | Quebec | 374528 | 11195 | 361675 | 1658 | 52.9399 | -73.5491 | 2021-06-23 04:21:46 | Quebec, Canada | ||
3358444 | 3358444 | 2021-06-21 | Canada | Quebec | 374400 | 11191 | 361521 | 1688 | 52.9399 | -73.5491 | 2021-06-22 04:21:34 | Quebec, Canada | ||
2884143 | 2884143 | 2021-06-20 | Canada | Quebec | 374307 | 11191 | 361352 | 1764 | 52.9399 | -73.5491 | 2021-06-21 04:21:41 | Quebec, Canada | ||
107226 | 107226 | 2021-06-19 | Canada | Quebec | 374213 | 11189 | 361160 | 1864 | 52.9399 | -73.5491 | 2021-06-20 04:21:48 | Quebec, Canada | ||
1125369 | 1125369 | 2021-06-18 | Canada | Quebec | 374125 | 11180 | 360973 | 1972 | 52.9399 | -73.5491 | 2021-06-19 04:22:33 | Quebec, Canada | ||
2910947 | 2910947 | 2021-06-17 | Canada | Quebec | 373995 | 11178 | 360779 | 2038 | 52.9399 | -73.5491 | 2021-06-18 04:22:16 | Quebec, Canada | ||
3030065 | 3030065 | 2021-06-16 | Canada | Quebec | 373836 | 11177 | 360587 | 2072 | 52.9399 | -73.5491 | 2021-06-17 04:22:36 | Quebec, Canada | ||
2571452 | 2571452 | 2021-04-13 | Canada | Ontario | 405575 | 7582 | 360560 | 33861 | 51.2538 | -85.3232 | 2021-04-14 04:20:41 | Ontario, Canada | ||
2339171 | 2339171 | 2021-06-15 | Canada | Quebec | 373686 | 11177 | 360410 | 2099 | 52.9399 | -73.5491 | 2021-06-16 04:22:32 | Quebec, Canada | ||
1563867 | 1563867 | 2021-06-14 | Canada | Quebec | 373512 | 11173 | 360194 | 2145 | 52.9399 | -73.5491 | 2021-06-15 04:22:22 | Quebec, Canada | ||
3381150 | 3381150 | 2021-06-13 | Canada | Quebec | 373402 | 11172 | 359981 | 2249 | 52.9399 | -73.5491 | 2021-06-14 04:22:46 | Quebec, Canada | ||
1736284 | 1736284 | 2021-06-12 | Canada | Quebec | 373283 | 11170 | 359698 | 2415 | 52.9399 | -73.5491 | 2021-06-13 04:22:44 | Quebec, Canada | ||
3970325 | 3970325 | 2021-06-11 | Canada | Quebec | 373150 | 11167 | 359421 | 2562 | 52.9399 | -73.5491 | 2021-06-12 04:22:22 | Quebec, Canada | ||
2716747 | 2716747 | 2021-06-10 | Canada | Quebec | 372987 | 11166 | 359104 | 2717 | 52.9399 | -73.5491 | 2021-06-11 04:23:20 | Quebec, Canada | ||
522632 | 522632 | 2021-06-09 | Canada | Quebec | 372771 | 11164 | 358849 | 2758 | 52.9399 | -73.5491 | 2021-06-10 04:23:17 | Quebec, Canada | ||
3472072 | 3472072 | 2021-06-08 | Canada | Quebec | 372616 | 11156 | 358553 | 2907 | 52.9399 | -73.5491 | 2021-06-09 04:23:31 | Quebec, Canada | ||
3145356 | 3145356 | 2021-06-07 | Canada | Quebec | 372417 | 11152 | 358221 | 3044 | 52.9399 | -73.5491 | 2021-06-08 04:22:35 | Quebec, Canada | ||
825358 | 825358 | 2021-06-06 | Canada | Quebec | 372254 | 11149 | 357867 | 3238 | 52.9399 | -73.5491 | 2021-06-07 04:22:51 | Quebec, Canada | ||
36203 | 36203 | 2021-04-12 | Canada | Ontario | 401303 | 7567 | 357678 | 33216 | 51.2538 | -85.3232 | 2021-04-13 04:20:37 | Ontario, Canada | ||
2585763 | 2585763 | 2021-06-05 | Canada | Quebec | 372101 | 11150 | 357425 | 3526 | 52.9399 | -73.5491 | 2021-06-06 04:24:03 | Quebec, Canada | ||
2315077 | 2315077 | 2021-06-04 | Canada | Quebec | 371889 | 11148 | 356998 | 3743 | 52.9399 | -73.5491 | 2021-06-05 04:23:03 | Quebec, Canada | ||
1448362 | 1448362 | 2021-06-03 | Canada | Quebec | 371655 | 11144 | 356582 | 3929 | 52.9399 | -73.5491 | 2021-06-04 04:23:37 | Quebec, Canada | ||
1708086 | 1708086 | 2021-06-02 | Canada | Quebec | 371384 | 11138 | 356202 | 4044 | 52.9399 | -73.5491 | 2021-06-03 04:23:32 | Quebec, Canada | ||
2103904 | 2103904 | 2021-06-01 | Canada | Quebec | 371088 | 11133 | 355785 | 4170 | 52.9399 | -73.5491 | 2021-06-02 04:24:34 | Quebec, Canada | ||
1188520 | 1188520 | 2021-05-31 | Canada | Quebec | 370805 | 11128 | 355266 | 4411 | 52.9399 | -73.5491 | 2021-06-01 04:23:09 | Quebec, Canada | ||
3883362 | 3883362 | 2021-04-11 | Canada | Ontario | 397211 | 7552 | 354981 | 31664 | 51.2538 | -85.3232 | 2021-04-12 04:21:00 | Ontario, Canada | ||
3089197 | 3089197 | 2021-05-30 | Canada | Quebec | 370556 | 11127 | 354734 | 4695 | 52.9399 | -73.5491 | 2021-05-31 03:08:59 | Quebec, Canada | ||
50566 | 50566 | 2021-05-29 | Canada | Quebec | 370283 | 11125 | 354104 | 5054 | 52.9399 | -73.5491 | 2021-05-30 04:20:55 | Quebec, Canada | ||
20145 | 20145 | 2021-05-28 | Canada | Quebec | 369980 | 11118 | 353442 | 5420 | 52.9399 | -73.5491 | 2021-05-29 04:20:41 | Quebec, Canada | ||
1806520 | 1806520 | 2021-05-27 | Canada | Quebec | 369580 | 11115 | 352807 | 5658 | 52.9399 | -73.5491 | 2021-05-28 04:20:36 | Quebec, Canada | ||
2983030 | 2983030 | 2021-04-10 | Canada | Ontario | 393147 | 7531 | 352338 | 29779 | 51.2538 | -85.3232 | 2021-04-11 04:20:56 | Ontario, Canada | ||
1309944 | 1309944 | 2021-05-26 | Canada | Quebec | 369167 | 11105 | 352230 | 5832 | 52.9399 | -73.5491 | 2021-05-27 04:20:59 | Quebec, Canada | ||
82870 | 82870 | 2021-05-25 | Canada | Quebec | 368706 | 11101 | 351689 | 5916 | 52.9399 | -73.5491 | 2021-05-26 04:20:35 | Quebec, Canada | ||
1412832 | 1412832 | 2021-05-24 | Canada | Quebec | 368307 | 11095 | 351002 | 6210 | 52.9399 | -73.5491 | 2021-05-25 04:21:08 | Quebec, Canada | ||
605462 | 605462 | 2021-04-09 | Canada | Ontario | 388509 | 7512 | 349619 | 28473 | 51.2538 | -85.3232 | 2021-04-10 04:20:59 | Ontario, Canada | ||
726273 | 726273 | 2021-05-22 | Canada | Quebec | 367575 | 11081 | 348694 | 7800 | 52.9399 | -73.5491 | 2021-05-23 04:20:51 | Quebec, Canada | ||
1771118 | 1771118 | 2021-05-23 | Canada | Quebec | 367924 | 11084 | 348694 | 8146 | 52.9399 | -73.5491 | 2021-05-24 04:20:53 | Quebec, Canada | ||
1952288 | 1952288 | 2021-05-21 | Canada | Quebec | 367080 | 11075 | 348694 | 7311 | 52.9399 | -73.5491 | 2021-05-22 04:20:45 | Quebec, Canada | ||
1912987 | 1912987 | 2021-05-20 | Canada | Quebec | 366525 | 11066 | 347942 | 7517 | 52.9399 | -73.5491 | 2021-05-21 04:20:43 | Quebec, Canada | ||
2255508 | 2255508 | 2021-05-19 | Canada | Quebec | 365849 | 11058 | 347387 | 7404 | 52.9399 | -73.5491 | 2021-05-20 04:21:05 | Quebec, Canada | ||
2645526 | 2645526 | 2021-04-08 | Canada | Ontario | 384512 | 7494 | 346827 | 27228 | 51.2538 | -85.3232 | 2021-04-09 04:21:13 | Ontario, Canada | ||
2390546 | 2390546 | 2021-05-18 | Canada | Quebec | 365049 | 11050 | 346639 | 7360 | 52.9399 | -73.5491 | 2021-05-19 04:20:42 | Quebec, Canada | ||
3574371 | 3574371 | 2021-05-17 | Canada | Quebec | 364465 | 11042 | 345794 | 7629 | 52.9399 | -73.5491 | 2021-05-18 04:20:33 | Quebec, Canada | ||
2939101 | 2939101 | 2021-05-16 | Canada | Quebec | 363888 | 11034 | 344950 | 7904 | 52.9399 | -73.5491 | 2021-05-17 04:20:34 | Quebec, Canada |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);