johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,026 rows where province_or_state = "Quebec" sorted by confirmed
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1195987 | 1195987 | 2020-06-17 | Canada | Quebec | 54201 | 5528 | 22549 | 26124 | 52.9399 | -73.5491 | 2020-06-18 04:33:18 | Quebec, Canada | ||
3682784 | 3682784 | 2020-06-18 | Canada | Quebec | 54336 | 5534 | 22754 | 26048 | 52.9399 | -73.5491 | 2020-06-19 04:33:17 | Quebec, Canada | ||
1691635 | 1691635 | 2020-06-19 | Canada | Quebec | 54469 | 5547 | 22972 | 25950 | 52.9399 | -73.5491 | 2020-06-20 04:33:19 | Quebec, Canada | ||
2438057 | 2438057 | 2020-06-20 | Canada | Quebec | 54564 | 5551 | 23201 | 25812 | 52.9399 | -73.5491 | 2020-06-21 04:33:19 | Quebec, Canada | ||
3249464 | 3249464 | 2020-06-21 | Canada | Quebec | 54645 | 5561 | 23322 | 25762 | 52.9399 | -73.5491 | 2020-06-22 04:33:20 | Quebec, Canada | ||
1510725 | 1510725 | 2020-06-22 | Canada | Quebec | 54730 | 5569 | 23506 | 25655 | 52.9399 | -73.5491 | 2020-06-23 04:33:22 | Quebec, Canada | ||
1522531 | 1522531 | 2020-06-23 | Canada | Quebec | 54824 | 5582 | 23620 | 25622 | 52.9399 | -73.5491 | 2020-06-24 04:33:28 | Quebec, Canada | ||
2700846 | 2700846 | 2020-06-24 | Canada | Quebec | 54913 | 5597 | 23710 | 25606 | 52.9399 | -73.5491 | 2020-06-25 05:26:54 | Quebec, Canada | ||
2625206 | 2625206 | 2020-06-25 | Canada | Quebec | 55003 | 5604 | 23786 | 25613 | 52.9399 | -73.5491 | 2020-06-26 04:33:43 | Quebec, Canada | ||
1136219 | 1136219 | 2020-06-26 | Canada | Quebec | 55088 | 5607 | 23786 | 25695 | 52.9399 | -73.5491 | 2020-06-27 04:33:35 | Quebec, Canada | ||
2039938 | 2039938 | 2020-06-27 | Canada | Quebec | 55176 | 5611 | 23786 | 25779 | 52.9399 | -73.5491 | 2020-06-28 04:34:04 | Quebec, Canada | ||
2306603 | 2306603 | 2020-06-28 | Canada | Quebec | 55234 | 5615 | 23786 | 25833 | 52.9399 | -73.5491 | 2020-06-29 04:33:44 | Quebec, Canada | ||
2633040 | 2633040 | 2020-06-29 | Canada | Quebec | 55292 | 5625 | 24602 | 25065 | 52.9399 | -73.5491 | 2020-06-30 04:33:48 | Quebec, Canada | ||
2974563 | 2974563 | 2020-06-30 | Canada | Quebec | 55390 | 5633 | 24798 | 24959 | 52.9399 | -73.5491 | 2020-07-01 04:33:52 | Quebec, Canada | ||
303185 | 303185 | 2020-07-01 | Canada | Quebec | 55463 | 5639 | 24949 | 24875 | 52.9399 | -73.5491 | 2020-07-02 04:33:46 | Quebec, Canada | ||
3045494 | 3045494 | 2020-07-02 | Canada | Quebec | 55533 | 5647 | 25034 | 24852 | 52.9399 | -73.5491 | 2020-07-03 04:33:54 | Quebec, Canada | ||
2234700 | 2234700 | 2020-07-03 | Canada | Quebec | 55623 | 5651 | 25158 | 24814 | 52.9399 | -73.5491 | 2020-07-04 04:33:51 | Quebec, Canada | ||
530039 | 530039 | 2020-07-04 | Canada | Quebec | 55715 | 5655 | 25280 | 24780 | 52.9399 | -73.5491 | 2020-07-05 04:33:46 | Quebec, Canada | ||
415477 | 415477 | 2020-07-05 | Canada | Quebec | 55772 | 5658 | 25346 | 24768 | 52.9399 | -73.5491 | 2020-07-06 04:33:57 | Quebec, Canada | ||
2685012 | 2685012 | 2020-07-06 | Canada | Quebec | 55840 | 5665 | 25378 | 24797 | 52.9399 | -73.5491 | 2020-07-07 04:34:00 | Quebec, Canada | ||
887452 | 887452 | 2020-07-07 | Canada | Quebec | 55947 | 5668 | 25458 | 24821 | 52.9399 | -73.5491 | 2020-07-08 05:33:48 | Quebec, Canada | ||
2222843 | 2222843 | 2020-07-08 | Canada | Quebec | 56047 | 5672 | 25534 | 24841 | 52.9399 | -73.5491 | 2020-07-09 04:34:23 | Quebec, Canada | ||
1005627 | 1005627 | 2020-07-09 | Canada | Quebec | 56177 | 5677 | 25616 | 24884 | 52.9399 | -73.5491 | 2020-07-10 04:34:24 | Quebec, Canada | ||
3237642 | 3237642 | 2020-07-10 | Canada | Quebec | 56289 | 5680 | 25675 | 24934 | 52.9399 | -73.5491 | 2020-07-11 04:34:26 | Quebec, Canada | ||
3436144 | 3436144 | 2020-07-11 | Canada | Quebec | 56390 | 5684 | 25773 | 24933 | 52.9399 | -73.5491 | 2020-07-12 04:34:30 | Quebec, Canada | ||
3737749 | 3737749 | 2020-07-12 | Canada | Quebec | 56465 | 5685 | 25862 | 24918 | 52.9399 | -73.5491 | 2020-07-13 04:43:04 | Quebec, Canada | ||
3491486 | 3491486 | 2020-07-13 | Canada | Quebec | 56602 | 5687 | 25911 | 25004 | 52.9399 | -73.5491 | 2020-07-14 04:34:46 | Quebec, Canada | ||
2158845 | 2158845 | 2020-07-14 | Canada | Quebec | 56732 | 5688 | 26025 | 25019 | 52.9399 | -73.5491 | 2020-07-15 04:34:39 | Quebec, Canada | ||
2748201 | 2748201 | 2020-07-15 | Canada | Quebec | 56879 | 5693 | 26097 | 25089 | 52.9399 | -73.5491 | 2020-07-16 04:44:59 | Quebec, Canada | ||
367533 | 367533 | 2020-07-16 | Canada | Quebec | 57017 | 5697 | 26253 | 25067 | 52.9399 | -73.5491 | 2020-07-17 04:34:50 | Quebec, Canada | ||
2708723 | 2708723 | 2020-07-17 | Canada | Quebec | 57213 | 5699 | 49939 | 1575 | 52.9399 | -73.5491 | 2020-07-18 04:34:45 | Quebec, Canada | ||
3205421 | 3205421 | 2020-07-18 | Canada | Quebec | 57401 | 5701 | 50027 | 1673 | 52.9399 | -73.5491 | 2020-07-19 04:34:58 | Quebec, Canada | ||
122032 | 122032 | 2020-07-19 | Canada | Quebec | 57529 | 5702 | 50050 | 1777 | 52.9399 | -73.5491 | 2020-07-20 05:34:40 | Quebec, Canada | ||
327127 | 327127 | 2020-07-20 | Canada | Quebec | 57660 | 5702 | 50190 | 1768 | 52.9399 | -73.5491 | 2020-07-21 04:38:46 | Quebec, Canada | ||
1707636 | 1707636 | 2020-07-21 | Canada | Quebec | 57810 | 5704 | 50298 | 1808 | 52.9399 | -73.5491 | 2020-07-22 04:34:42 | Quebec, Canada | ||
844897 | 844897 | 2020-07-22 | Canada | Quebec | 57984 | 5707 | 50373 | 1904 | 52.9399 | -73.5491 | 2020-07-23 05:15:04 | Quebec, Canada | ||
62088 | 62088 | 2020-07-23 | Canada | Quebec | 58176 | 5709 | 50505 | 1962 | 52.9399 | -73.5491 | 2020-07-24 05:30:40 | Quebec, Canada | ||
2563877 | 2563877 | 2020-07-24 | Canada | Quebec | 58336 | 5710 | 50615 | 2011 | 52.9399 | -73.5491 | 2020-07-25 04:47:39 | Quebec, Canada | ||
1502907 | 1502907 | 2020-07-25 | Canada | Quebec | 58498 | 5711 | 50713 | 2074 | 52.9399 | -73.5491 | 2020-07-26 04:35:00 | Quebec, Canada | ||
442663 | 442663 | 2020-07-26 | Canada | Quebec | 58645 | 5711 | 50812 | 2122 | 52.9399 | -73.5491 | 2020-07-27 04:35:02 | Quebec, Canada | ||
177350 | 177350 | 2020-07-27 | Canada | Quebec | 58734 | 5713 | 50886 | 2135 | 52.9399 | -73.5491 | 2020-07-28 04:58:43 | Quebec, Canada | ||
3185299 | 3185299 | 2020-07-28 | Canada | Quebec | 58864 | 5714 | 50886 | 2264 | 52.9399 | -73.5491 | 2020-07-29 04:35:11 | Quebec, Canada | ||
2958683 | 2958683 | 2020-07-29 | Canada | Quebec | 59041 | 5714 | 50886 | 2441 | 52.9399 | -73.5491 | 2020-07-30 04:35:05 | Quebec, Canada | ||
1928515 | 1928515 | 2020-07-30 | Canada | Quebec | 59194 | 5718 | 50886 | 2590 | 52.9399 | -73.5491 | 2020-07-31 04:35:18 | Quebec, Canada | ||
3264808 | 3264808 | 2020-07-31 | Canada | Quebec | 59328 | 5719 | 50886 | 2723 | 52.9399 | -73.5491 | 2020-08-01 04:36:27 | Quebec, Canada | ||
753643 | 753643 | 2020-08-01 | Canada | Quebec | 59458 | 5721 | 50886 | 2851 | 52.9399 | -73.5491 | 2020-08-02 04:34:47 | Quebec, Canada | ||
2808075 | 2808075 | 2020-08-02 | Canada | Quebec | 59550 | 5723 | 50886 | 2941 | 52.9399 | -73.5491 | 2020-08-03 04:34:35 | Quebec, Canada | ||
2740323 | 2740323 | 2020-08-03 | Canada | Quebec | 59694 | 5723 | 50886 | 3085 | 52.9399 | -73.5491 | 2020-08-04 04:41:59 | Quebec, Canada | ||
98440 | 98440 | 2020-08-04 | Canada | Quebec | 59844 | 5723 | 50886 | 3235 | 52.9399 | -73.5491 | 2020-08-05 04:34:43 | Quebec, Canada | ||
3793204 | 3793204 | 2020-08-05 | Canada | Quebec | 59969 | 5726 | 50886 | 3357 | 52.9399 | -73.5491 | 2020-08-06 04:35:02 | Quebec, Canada | ||
3612374 | 3612374 | 2020-08-06 | Canada | Quebec | 60061 | 5729 | 50886 | 3446 | 52.9399 | -73.5491 | 2020-08-07 04:35:11 | Quebec, Canada | ||
458689 | 458689 | 2020-08-07 | Canada | Quebec | 60189 | 5730 | 50886 | 3573 | 52.9399 | -73.5491 | 2020-08-08 04:34:53 | Quebec, Canada | ||
371505 | 371505 | 2020-08-08 | Canada | Quebec | 60303 | 5732 | 50886 | 3685 | 52.9399 | -73.5491 | 2020-08-09 04:34:54 | Quebec, Canada | ||
3923337 | 3923337 | 2020-08-09 | Canada | Quebec | 60400 | 5734 | 50886 | 3780 | 52.9399 | -73.5491 | 2020-08-10 04:34:55 | Quebec, Canada | ||
1920528 | 1920528 | 2020-08-10 | Canada | Quebec | 60500 | 5736 | 53041 | 1723 | 52.9399 | -73.5491 | 2020-08-11 04:35:08 | Quebec, Canada | ||
662078 | 662078 | 2020-08-11 | Canada | Quebec | 60600 | 5739 | 53135 | 1726 | 52.9399 | -73.5491 | 2020-08-12 04:27:29 | Quebec, Canada | ||
3531229 | 3531229 | 2020-08-12 | Canada | Quebec | 60690 | 5742 | 53270 | 1678 | 52.9399 | -73.5491 | 2020-08-13 04:29:15 | Quebec, Canada | ||
582610 | 582610 | 2020-08-13 | Canada | Quebec | 60788 | 5743 | 53441 | 1604 | 52.9399 | -73.5491 | 2020-08-14 04:51:19 | Quebec, Canada | ||
1612026 | 1612026 | 2020-08-14 | Canada | Quebec | 60863 | 5745 | 53598 | 1520 | 52.9399 | -73.5491 | 2020-08-15 04:27:31 | Quebec, Canada | ||
145751 | 145751 | 2020-08-15 | Canada | Quebec | 60929 | 5748 | 53709 | 1472 | 52.9399 | -73.5491 | 2020-08-16 04:27:42 | Quebec, Canada | ||
1555749 | 1555749 | 2020-08-16 | Canada | Quebec | 60973 | 5752 | 53847 | 1374 | 52.9399 | -73.5491 | 2020-08-17 04:27:20 | Quebec, Canada | ||
837391 | 837391 | 2020-08-17 | Canada | Quebec | 61023 | 5754 | 53930 | 1339 | 52.9399 | -73.5491 | 2020-08-18 04:27:56 | Quebec, Canada | ||
3177787 | 3177787 | 2020-08-18 | Canada | Quebec | 61104 | 5755 | 54083 | 1266 | 52.9399 | -73.5491 | 2020-08-19 04:27:00 | Quebec, Canada | ||
206033 | 206033 | 2020-08-19 | Canada | Quebec | 61177 | 5758 | 54238 | 1181 | 52.9399 | -73.5491 | 2020-08-20 04:27:43 | Quebec, Canada | ||
3484084 | 3484084 | 2020-08-20 | Canada | Quebec | 61282 | 5760 | 54383 | 1139 | 52.9399 | -73.5491 | 2020-08-21 04:27:41 | Quebec, Canada | ||
1479335 | 1479335 | 2020-08-21 | Canada | Quebec | 61388 | 5764 | 54472 | 1152 | 52.9399 | -73.5491 | 2020-08-22 04:27:49 | Quebec, Canada | ||
2299228 | 2299228 | 2020-08-22 | Canada | Quebec | 61460 | 5764 | 54576 | 1120 | 52.9399 | -73.5491 | 2020-08-23 04:27:48 | Quebec, Canada | ||
2215446 | 2215446 | 2020-08-23 | Canada | Quebec | 61536 | 5767 | 54682 | 1087 | 52.9399 | -73.5491 | 2020-08-24 04:27:56 | Quebec, Canada | ||
2991051 | 2991051 | 2020-08-24 | Canada | Quebec | 61580 | 5769 | 54761 | 1050 | 52.9399 | -73.5491 | 2020-08-25 04:28:02 | Quebec, Canada | ||
3562347 | 3562347 | 2020-08-25 | Canada | Quebec | 61678 | 5769 | 54850 | 1059 | 52.9399 | -73.5491 | 2020-08-26 04:28:11 | Quebec, Canada | ||
1996423 | 1996423 | 2020-08-26 | Canada | Quebec | 61804 | 5770 | 54922 | 1112 | 52.9399 | -73.5491 | 2020-08-27 04:28:15 | Quebec, Canada | ||
2509963 | 2509963 | 2020-08-27 | Canada | Quebec | 61926 | 5770 | 55008 | 1148 | 52.9399 | -73.5491 | 2020-08-28 04:28:11 | Quebec, Canada | ||
1522962 | 1522962 | 2020-08-28 | Canada | Quebec | 62035 | 5776 | 55106 | 1153 | 52.9399 | -73.5491 | 2020-08-29 04:28:19 | Quebec, Canada | ||
609467 | 609467 | 2020-08-29 | Canada | Quebec | 62175 | 5778 | 55235 | 1162 | 52.9399 | -73.5491 | 2020-08-30 04:28:22 | Quebec, Canada | ||
3931805 | 3931805 | 2020-08-30 | Canada | Quebec | 62293 | 5779 | 55300 | 1214 | 52.9399 | -73.5491 | 2020-08-31 04:28:27 | Quebec, Canada | ||
193846 | 193846 | 2020-08-31 | Canada | Quebec | 62423 | 5780 | 55353 | 1290 | 52.9399 | -73.5491 | 2020-09-01 04:28:31 | Quebec, Canada | ||
2059661 | 2059661 | 2020-09-01 | Canada | Quebec | 62577 | 5780 | 55438 | 1359 | 52.9399 | -73.5491 | 2020-09-02 04:28:25 | Quebec, Canada | ||
1105332 | 1105332 | 2020-09-02 | Canada | Quebec | 62761 | 5781 | 55515 | 1465 | 52.9399 | -73.5491 | 2020-09-03 04:28:22 | Quebec, Canada | ||
1354095 | 1354095 | 2020-09-03 | Canada | Quebec | 62988 | 5783 | 55615 | 1590 | 52.9399 | -73.5491 | 2020-09-04 04:28:26 | Quebec, Canada | ||
2661555 | 2661555 | 2020-09-04 | Canada | Quebec | 63173 | 5783 | 55724 | 1666 | 52.9399 | -73.5491 | 2020-09-05 04:28:19 | Quebec, Canada | ||
813355 | 813355 | 2020-09-05 | Canada | Quebec | 63368 | 5784 | 55810 | 1774 | 52.9399 | -73.5491 | 2020-09-06 04:28:33 | Quebec, Canada | ||
3161400 | 3161400 | 2020-09-06 | Canada | Quebec | 63562 | 5784 | 55871 | 1907 | 52.9399 | -73.5491 | 2020-09-07 04:28:30 | Quebec, Canada | ||
427115 | 427115 | 2020-09-07 | Canada | Quebec | 63753 | 5786 | 55960 | 2007 | 52.9399 | -73.5491 | 2020-09-08 04:28:25 | Quebec, Canada | ||
1243536 | 1243536 | 2020-09-08 | Canada | Quebec | 63945 | 5786 | 56162 | 1997 | 52.9399 | -73.5491 | 2020-09-09 04:28:48 | Quebec, Canada | ||
2171327 | 2171327 | 2020-09-09 | Canada | Quebec | 64197 | 5790 | 56400 | 2007 | 52.9399 | -73.5491 | 2020-09-10 04:29:01 | Quebec, Canada | ||
1172962 | 1172962 | 2020-09-10 | Canada | Quebec | 64457 | 5791 | 56624 | 2042 | 52.9399 | -73.5491 | 2020-09-11 04:46:23 | Quebec, Canada | ||
1444361 | 1444361 | 2020-09-11 | Canada | Quebec | 64763 | 5791 | 56843 | 2129 | 52.9399 | -73.5491 | 2020-09-12 04:25:05 | Quebec, Canada | ||
546532 | 546532 | 2020-09-12 | Canada | Quebec | 65058 | 5793 | 57054 | 2211 | 52.9399 | -73.5491 | 2020-09-13 04:30:52 | Quebec, Canada | ||
2868493 | 2868493 | 2020-09-13 | Canada | Quebec | 65374 | 5796 | 57268 | 2310 | 52.9399 | -73.5491 | 2020-09-14 04:26:00 | Quebec, Canada | ||
344054 | 344054 | 2020-09-14 | Canada | Quebec | 65651 | 5800 | 57428 | 2423 | 52.9399 | -73.5491 | 2020-09-15 03:22:50 | Quebec, Canada | ||
2728782 | 2728782 | 2020-09-15 | Canada | Quebec | 65972 | 5803 | 57628 | 2541 | 52.9399 | -73.5491 | 2020-09-16 04:22:53 | Quebec, Canada | ||
666057 | 666057 | 2020-09-16 | Canada | Quebec | 66275 | 5806 | 57804 | 2665 | 52.9399 | -73.5491 | 2020-09-17 04:22:00 | Quebec, Canada | ||
1121368 | 1121368 | 2020-09-17 | Canada | Quebec | 66626 | 5809 | 58012 | 2805 | 52.9399 | -73.5491 | 2020-09-18 05:05:00 | Quebec, Canada | ||
2848619 | 2848619 | 2020-09-18 | Canada | Quebec | 67113 | 5815 | 58218 | 3080 | 52.9399 | -73.5491 | 2020-09-19 04:22:00 | Quebec, Canada | ||
2454550 | 2454550 | 2020-09-19 | Canada | Quebec | 67610 | 5821 | 58490 | 3299 | 52.9399 | -73.5491 | 2020-09-20 04:22:00 | Quebec, Canada | ||
3093200 | 3093200 | 2020-09-20 | Canada | Quebec | 68113 | 5823 | 58796 | 3494 | 52.9399 | -73.5491 | 2020-09-21 04:23:00 | Quebec, Canada | ||
2836595 | 2836595 | 2020-09-21 | Canada | Quebec | 68591 | 5825 | 59131 | 3635 | 52.9399 | -73.5491 | 2020-09-22 04:23:00 | Quebec, Canada | ||
3315996 | 3315996 | 2020-09-22 | Canada | Quebec | 69113 | 5828 | 59450 | 3835 | 52.9399 | -73.5491 | 2020-09-23 04:23:00 | Quebec, Canada | ||
2653547 | 2653547 | 2020-09-23 | Canada | Quebec | 69801 | 5832 | 59686 | 4283 | 52.9399 | -73.5491 | 2020-09-24 04:23:00 | Quebec, Canada | ||
2605804 | 2605804 | 2020-09-24 | Canada | Quebec | 70527 | 5838 | 59943 | 4746 | 52.9399 | -73.5491 | 2020-09-25 04:23:00 | 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]);