johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "Quebec, Canada" and country_or_region = "Canada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
1771118 | 1771118 | 2021-05-23 | Canada | Quebec | 367924 | 11084 | 348694 | 8146 | 52.9399 | -73.5491 | 2021-05-24 04:20:53 | 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 | ||
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 | ||
887895 | 887895 | 2021-04-26 | Canada | Quebec | 346270 | 10886 | 324441 | 10943 | 52.9399 | -73.5491 | 2021-04-27 04:20:52 | Quebec, Canada | ||
954640 | 954640 | 2021-04-25 | Canada | Quebec | 345301 | 10878 | 323086 | 11337 | 52.9399 | -73.5491 | 2021-04-26 04:21:04 | Quebec, Canada | ||
3923787 | 3923787 | 2021-04-24 | Canada | Quebec | 344410 | 10869 | 321667 | 11874 | 52.9399 | -73.5491 | 2021-04-25 04:20:32 | Quebec, Canada | ||
1408818 | 1408818 | 2021-04-23 | Canada | Quebec | 343211 | 10860 | 320302 | 12049 | 52.9399 | -73.5491 | 2021-04-24 04:20:38 | Quebec, Canada | ||
1567881 | 1567881 | 2021-04-22 | Canada | Quebec | 342293 | 10845 | 318676 | 12772 | 52.9399 | -73.5491 | 2021-04-23 04:20:52 | Quebec, Canada | ||
3242102 | 3242102 | 2021-04-21 | Canada | Quebec | 341199 | 10838 | 317338 | 13023 | 52.9399 | -73.5491 | 2021-04-22 04:20:53 | Quebec, Canada | ||
2020498 | 2020498 | 2021-04-20 | Canada | Quebec | 339999 | 10833 | 315984 | 13182 | 52.9399 | -73.5491 | 2021-04-21 04:21:14 | Quebec, Canada | ||
2410619 | 2410619 | 2021-04-19 | Canada | Quebec | 338775 | 10816 | 314376 | 13583 | 52.9399 | -73.5491 | 2021-04-20 04:20:41 | Quebec, Canada | ||
3129296 | 3129296 | 2021-04-18 | Canada | Quebec | 337587 | 10802 | 312701 | 14084 | 52.9399 | -73.5491 | 2021-04-19 04:20:57 | Quebec, Canada | ||
982724 | 982724 | 2021-04-17 | Canada | Quebec | 336562 | 10793 | 311047 | 14722 | 52.9399 | -73.5491 | 2021-04-18 04:20:41 | Quebec, Canada | ||
169819 | 169819 | 2021-04-16 | Canada | Quebec | 335270 | 10785 | 309345 | 15140 | 52.9399 | -73.5491 | 2021-04-17 04:20:40 | Quebec, Canada | ||
2548650 | 2548650 | 2021-04-15 | Canada | Quebec | 333814 | 10778 | 307748 | 15288 | 52.9399 | -73.5491 | 2021-04-16 04:20:46 | Quebec, Canada | ||
1841720 | 1841720 | 2021-04-14 | Canada | Quebec | 332132 | 10763 | 306608 | 14761 | 52.9399 | -73.5491 | 2021-04-15 04:20:54 | Quebec, Canada | ||
2571454 | 2571454 | 2021-04-13 | Canada | Quebec | 330615 | 10756 | 305463 | 14396 | 52.9399 | -73.5491 | 2021-04-14 04:20:41 | Quebec, Canada | ||
36205 | 36205 | 2021-04-12 | Canada | Quebec | 329082 | 10744 | 304267 | 14071 | 52.9399 | -73.5491 | 2021-04-13 04:20:37 | Quebec, Canada | ||
3883364 | 3883364 | 2021-04-11 | Canada | Quebec | 327660 | 10742 | 303039 | 13879 | 52.9399 | -73.5491 | 2021-04-12 04:21:00 | Quebec, Canada | ||
2983032 | 2983032 | 2021-04-10 | Canada | Quebec | 326165 | 10737 | 301740 | 13688 | 52.9399 | -73.5491 | 2021-04-11 04:20:56 | Quebec, Canada | ||
605464 | 605464 | 2021-04-09 | Canada | Quebec | 324533 | 10726 | 300471 | 13336 | 52.9399 | -73.5491 | 2021-04-10 04:20:59 | Quebec, Canada | ||
2645528 | 2645528 | 2021-04-08 | Canada | Quebec | 322666 | 10718 | 299241 | 12707 | 52.9399 | -73.5491 | 2021-04-09 04:21:13 | Quebec, Canada | ||
2247170 | 2247170 | 2021-04-07 | Canada | Quebec | 320946 | 10709 | 298298 | 11939 | 52.9399 | -73.5491 | 2021-04-08 04:21:13 | Quebec, Canada | ||
3003080 | 3003080 | 2021-04-06 | Canada | Quebec | 319304 | 10701 | 297384 | 11219 | 52.9399 | -73.5491 | 2021-04-07 04:20:53 | Quebec, Canada | ||
3085075 | 3085075 | 2021-04-05 | Canada | Quebec | 317995 | 10697 | 296396 | 10902 | 52.9399 | -73.5491 | 2021-04-06 04:20:32 | Quebec, Canada | ||
387998 | 387998 | 2021-04-04 | Canada | Quebec | 316776 | 10693 | 294560 | 11523 | 52.9399 | -73.5491 | 2021-04-05 04:20:35 | Quebec, Canada | ||
3709914 | 3709914 | 2021-04-03 | Canada | Quebec | 315640 | 10684 | 294560 | 10396 | 52.9399 | -73.5491 | 2021-04-04 04:20:49 | Quebec, Canada | ||
241030 | 241030 | 2021-04-02 | Canada | Quebec | 314350 | 10681 | 292648 | 11021 | 52.9399 | -73.5491 | 2021-04-03 04:20:44 | Quebec, Canada | ||
1301827 | 1301827 | 2021-04-01 | Canada | Quebec | 313062 | 10676 | 292648 | 9738 | 52.9399 | -73.5491 | 2021-04-02 04:20:36 | Quebec, Canada | ||
637699 | 637699 | 2021-03-31 | Canada | Quebec | 311776 | 10667 | 291906 | 9203 | 52.9399 | -73.5491 | 2021-04-01 04:27:05 | Quebec, Canada | ||
3643328 | 3643328 | 2021-03-30 | Canada | Quebec | 310351 | 10658 | 291290 | 8403 | 52.9399 | -73.5491 | 2021-03-31 04:26:25 | Quebec, Canada | ||
1289781 | 1289781 | 2021-03-29 | Canada | Quebec | 309354 | 10651 | 290564 | 8139 | 52.9399 | -73.5491 | 2021-03-30 04:26:23 | Quebec, Canada | ||
1535703 | 1535703 | 2021-03-28 | Canada | Quebec | 308412 | 10647 | 289827 | 7938 | 52.9399 | -73.5491 | 2021-03-29 04:28:35 | Quebec, Canada | ||
1219343 | 1219343 | 2021-03-27 | Canada | Quebec | 307588 | 10645 | 289132 | 7811 | 52.9399 | -73.5491 | 2021-03-28 05:28:10 | Quebec, Canada | ||
1880761 | 1880761 | 2021-03-26 | Canada | Quebec | 306657 | 10637 | 288384 | 7636 | 52.9399 | -73.5491 | 2021-03-27 05:25:04 | Quebec, Canada | ||
1980391 | 1980391 | 2021-03-25 | Canada | Quebec | 305648 | 10630 | 287632 | 7386 | 52.9399 | -73.5491 | 2021-03-26 05:26:55 | Quebec, Canada | ||
2780769 | 2780769 | 2021-03-24 | Canada | Quebec | 304641 | 10626 | 286946 | 7069 | 52.9399 | -73.5491 | 2021-03-25 05:27:00 | Quebec, Canada | ||
1798414 | 1798414 | 2021-03-23 | Canada | Quebec | 303611 | 10618 | 286347 | 6646 | 52.9399 | -73.5491 | 2021-03-24 05:25:40 | Quebec, Canada | ||
1203582 | 1203582 | 2021-03-22 | Canada | Quebec | 302846 | 10614 | 285682 | 6550 | 52.9399 | -73.5491 | 2021-03-23 05:26:18 | Quebec, Canada | ||
3369104 | 3369104 | 2021-03-21 | Canada | Quebec | 302138 | 10599 | 284940 | 6599 | 52.9399 | -73.5491 | 2021-03-22 05:25:43 | Quebec, Canada | ||
1744314 | 1744314 | 2021-03-20 | Canada | Quebec | 301473 | 10594 | 284203 | 6676 | 52.9399 | -73.5491 | 2021-03-21 05:25:44 | Quebec, Canada | ||
3420694 | 3420694 | 2021-03-19 | Canada | Quebec | 300792 | 10587 | 283478 | 6727 | 52.9399 | -73.5491 | 2021-03-20 05:25:46 | Quebec, Canada | ||
3452632 | 3452632 | 2021-03-18 | Canada | Quebec | 299986 | 10576 | 282693 | 6717 | 52.9399 | -73.5491 | 2021-03-19 05:26:09 | Quebec, Canada | ||
3620856 | 3620856 | 2021-03-17 | Canada | Quebec | 299224 | 10570 | 282047 | 6607 | 52.9399 | -73.5491 | 2021-03-18 05:26:22 | Quebec, Canada | ||
702180 | 702180 | 2021-03-16 | Canada | Quebec | 298495 | 10558 | 281436 | 6501 | 52.9399 | -73.5491 | 2021-03-17 05:25:07 | Quebec, Canada | ||
2055658 | 2055658 | 2021-03-15 | Canada | Quebec | 297774 | 10550 | 280755 | 6469 | 52.9399 | -73.5491 | 2021-03-16 05:25:13 | Quebec, Canada | ||
1732270 | 1732270 | 2021-03-14 | Canada | Quebec | 297201 | 10540 | 280030 | 6631 | 52.9399 | -73.5491 | 2021-03-15 05:25:51 | Quebec, Canada | ||
1579927 | 1579927 | 2021-03-13 | Canada | Quebec | 296594 | 10535 | 279230 | 6829 | 52.9399 | -73.5491 | 2021-03-14 05:25:37 | Quebec, Canada | ||
1837706 | 1837706 | 2021-03-12 | Canada | Quebec | 295934 | 10526 | 278489 | 6919 | 52.9399 | -73.5491 | 2021-03-13 05:25:15 | Quebec, Canada | ||
352071 | 352071 | 2021-03-11 | Canada | Quebec | 295122 | 10518 | 277738 | 6866 | 52.9399 | -73.5491 | 2021-03-12 05:26:50 | 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]);