johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,026 rows where country_or_region = "Canada" and province_or_state = "Quebec" sorted by recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▲ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
1872731 | 1872731 | 2021-05-15 | Canada | Quebec | 363329 | 11032 | 344039 | 8258 | 52.9399 | -73.5491 | 2021-05-16 04:20:49 | Quebec, Canada | ||
1081700 | 1081700 | 2021-05-14 | Canada | Quebec | 362670 | 11025 | 343142 | 8503 | 52.9399 | -73.5491 | 2021-05-15 04:20:58 | Quebec, Canada | ||
3053966 | 3053966 | 2021-05-13 | Canada | Quebec | 361880 | 11017 | 342170 | 8693 | 52.9399 | -73.5491 | 2021-05-14 04:20:41 | Quebec, Canada | ||
2004436 | 2004436 | 2021-05-12 | Canada | Quebec | 360992 | 11012 | 341433 | 8547 | 52.9399 | -73.5491 | 2021-05-13 04:20:51 | Quebec, Canada | ||
3954267 | 3954267 | 2021-05-11 | Canada | Quebec | 360134 | 11002 | 340637 | 8495 | 52.9399 | -73.5491 | 2021-05-12 04:21:29 | Quebec, Canada | ||
2820546 | 2820546 | 2021-05-10 | Canada | Quebec | 359300 | 10993 | 339660 | 8647 | 52.9399 | -73.5491 | 2021-05-11 04:20:41 | Quebec, Canada | ||
1424878 | 1424878 | 2021-05-09 | Canada | Quebec | 358629 | 10987 | 338628 | 9014 | 52.9399 | -73.5491 | 2021-05-10 04:20:38 | Quebec, Canada | ||
1551746 | 1551746 | 2021-05-08 | Canada | Quebec | 357918 | 10981 | 337538 | 9399 | 52.9399 | -73.5491 | 2021-05-09 04:20:35 | Quebec, Canada | ||
2501804 | 2501804 | 2021-05-07 | Canada | Quebec | 357104 | 10974 | 336505 | 9625 | 52.9399 | -73.5491 | 2021-05-08 04:21:04 | Quebec, Canada | ||
3113260 | 3113260 | 2021-05-06 | Canada | Quebec | 356097 | 10971 | 335421 | 9705 | 52.9399 | -73.5491 | 2021-05-07 04:20:40 | Quebec, Canada | ||
645727 | 645727 | 2021-05-05 | Canada | Quebec | 355057 | 10964 | 334531 | 9562 | 52.9399 | -73.5491 | 2021-05-06 04:20:38 | Quebec, Canada | ||
3675427 | 3675427 | 2021-05-04 | Canada | Quebec | 354163 | 10959 | 333624 | 9580 | 52.9399 | -73.5491 | 2021-05-05 04:20:43 | Quebec, Canada | ||
2760694 | 2760694 | 2021-05-03 | Canada | Quebec | 353258 | 10944 | 332577 | 9737 | 52.9399 | -73.5491 | 2021-05-04 04:20:34 | Quebec, Canada | ||
2450547 | 2450547 | 2021-05-02 | Canada | Quebec | 352408 | 10942 | 331513 | 9953 | 52.9399 | -73.5491 | 2021-05-03 04:20:39 | Quebec, Canada | ||
2824560 | 2824560 | 2021-05-01 | Canada | Quebec | 351631 | 10933 | 330362 | 10336 | 52.9399 | -73.5491 | 2021-05-02 04:20:48 | Quebec, Canada | ||
379968 | 379968 | 2021-04-30 | Canada | Quebec | 350711 | 10926 | 329174 | 10611 | 52.9399 | -73.5491 | 2021-05-01 04:20:47 | Quebec, Canada | ||
1636091 | 1636091 | 2021-04-29 | Canada | Quebec | 349538 | 10913 | 327865 | 10760 | 52.9399 | -73.5491 | 2021-04-30 04:21:03 | Quebec, Canada | ||
3393170 | 3393170 | 2021-04-28 | Canada | Quebec | 348423 | 10908 | 326834 | 10681 | 52.9399 | -73.5491 | 2021-04-29 04:20:55 | Quebec, Canada | ||
3701886 | 3701886 | 2021-04-27 | Canada | Quebec | 347353 | 10898 | 325691 | 10764 | 52.9399 | -73.5491 | 2021-04-28 04:20:32 | 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]);