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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026130 | 1026130 | 2020-10-17 | Canada | Quebec | 93474 | 6072 | 76512 | 10890 | 52.9399 | -73.5491 | 2020-10-18 04:24:25 | Quebec, Canada | ||
2856625 | 2856625 | 2020-10-16 | Canada | Quebec | 92419 | 6065 | 76512 | 9842 | 52.9399 | -73.5491 | 2020-10-17 04:24:12 | Quebec, Canada | ||
786155 | 786155 | 2020-10-15 | Canada | Quebec | 91285 | 6045 | 75467 | 9773 | 52.9399 | -73.5491 | 2020-10-16 04:24:01 | Quebec, Canada | ||
78866 | 78866 | 2020-10-14 | Canada | Quebec | 90138 | 6035 | 74483 | 9620 | 52.9399 | -73.5491 | 2020-10-15 04:24:28 | Quebec, Canada | ||
3781681 | 3781681 | 2020-10-13 | Canada | Quebec | 89041 | 6015 | 73734 | 9292 | 52.9399 | -73.5491 | 2020-10-14 04:24:05 | Quebec, Canada | ||
2291221 | 2291221 | 2020-10-12 | Canada | Quebec | 88092 | 6005 | 72857 | 9230 | 52.9399 | -73.5491 | 2020-10-13 04:24:02 | Quebec, Canada | ||
3785674 | 3785674 | 2020-10-11 | Canada | Quebec | 87296 | 5995 | 71839 | 9462 | 52.9399 | -73.5491 | 2020-10-12 04:23:45 | Quebec, Canada | ||
2601812 | 2601812 | 2020-10-10 | Canada | Quebec | 86216 | 5983 | 70696 | 9537 | 52.9399 | -73.5491 | 2020-10-11 04:23:46 | Quebec, Canada | ||
817345 | 817345 | 2020-10-09 | Canada | Quebec | 85306 | 5966 | 69586 | 9754 | 52.9399 | -73.5491 | 2020-10-10 04:23:57 | Quebec, Canada | ||
2689460 | 2689460 | 2020-10-08 | Canada | Quebec | 84166 | 5960 | 68585 | 9621 | 52.9399 | -73.5491 | 2020-10-09 04:23:59 | Quebec, Canada | ||
1041602 | 1041602 | 2020-10-07 | Canada | Quebec | 83069 | 5949 | 67735 | 9385 | 52.9399 | -73.5491 | 2020-10-08 04:23:56 | Quebec, Canada | ||
3117263 | 3117263 | 2020-10-06 | Canada | Quebec | 82093 | 5934 | 67033 | 9126 | 52.9399 | -73.5491 | 2020-10-07 04:23:40 | Quebec, Canada | ||
3801675 | 3801675 | 2020-10-05 | Canada | Quebec | 81092 | 5923 | 66180 | 8989 | 52.9399 | -73.5491 | 2020-10-06 04:23:33 | Quebec, Canada | ||
1822565 | 1822565 | 2020-10-04 | Canada | Quebec | 80247 | 5915 | 65304 | 9028 | 52.9399 | -73.5491 | 2020-10-05 04:23:33 | Quebec, Canada | ||
2513949 | 2513949 | 2020-10-03 | Canada | Quebec | 79198 | 5905 | 64478 | 8815 | 52.9399 | -73.5491 | 2020-10-04 04:23:44 | Quebec, Canada | ||
3389167 | 3389167 | 2020-10-02 | Canada | Quebec | 78043 | 5896 | 63683 | 8464 | 52.9399 | -73.5491 | 2020-10-03 04:23:40 | Quebec, Canada | ||
2379408 | 2379408 | 2020-10-01 | Canada | Quebec | 76874 | 5889 | 63144 | 7841 | 52.9399 | -73.5491 | 2020-10-02 04:23:51 | Quebec, Canada | ||
1045594 | 1045594 | 2020-09-30 | Canada | Quebec | 75917 | 5879 | 62564 | 7474 | 52.9399 | -73.5491 | 2020-10-01 04:23:42 | Quebec, Canada | ||
966675 | 966675 | 2020-09-29 | Canada | Quebec | 74900 | 5866 | 62095 | 6939 | 52.9399 | -73.5491 | 2020-09-30 04:23:33 | Quebec, Canada | ||
1515172 | 1515172 | 2020-09-28 | Canada | Quebec | 73942 | 5858 | 61629 | 6455 | 52.9399 | -73.5491 | 2020-09-29 04:23:42 | Quebec, Canada | ||
2581760 | 2581760 | 2020-09-27 | Canada | Quebec | 73033 | 5850 | 61129 | 6054 | 52.9399 | -73.5491 | 2020-09-28 04:23:00 | Quebec, Canada | ||
2613812 | 2613812 | 2020-09-26 | Canada | Quebec | 72183 | 5846 | 60660 | 5677 | 52.9399 | -73.5491 | 2020-09-27 04:23:00 | Quebec, Canada | ||
2812527 | 2812527 | 2020-09-25 | Canada | Quebec | 71270 | 5840 | 60256 | 5174 | 52.9399 | -73.5491 | 2020-09-26 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 | ||
2653547 | 2653547 | 2020-09-23 | Canada | Quebec | 69801 | 5832 | 59686 | 4283 | 52.9399 | -73.5491 | 2020-09-24 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 | ||
2836595 | 2836595 | 2020-09-21 | Canada | Quebec | 68591 | 5825 | 59131 | 3635 | 52.9399 | -73.5491 | 2020-09-22 04:23: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 | ||
2454550 | 2454550 | 2020-09-19 | Canada | Quebec | 67610 | 5821 | 58490 | 3299 | 52.9399 | -73.5491 | 2020-09-20 04:22: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 | ||
1121368 | 1121368 | 2020-09-17 | Canada | Quebec | 66626 | 5809 | 58012 | 2805 | 52.9399 | -73.5491 | 2020-09-18 05:05:00 | 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 | ||
2728782 | 2728782 | 2020-09-15 | Canada | Quebec | 65972 | 5803 | 57628 | 2541 | 52.9399 | -73.5491 | 2020-09-16 04:22:53 | 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 | ||
2868493 | 2868493 | 2020-09-13 | Canada | Quebec | 65374 | 5796 | 57268 | 2310 | 52.9399 | -73.5491 | 2020-09-14 04:26:00 | 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 | ||
1444361 | 1444361 | 2020-09-11 | Canada | Quebec | 64763 | 5791 | 56843 | 2129 | 52.9399 | -73.5491 | 2020-09-12 04:25:05 | 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 | ||
2171327 | 2171327 | 2020-09-09 | Canada | Quebec | 64197 | 5790 | 56400 | 2007 | 52.9399 | -73.5491 | 2020-09-10 04:29:01 | 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 | ||
427115 | 427115 | 2020-09-07 | Canada | Quebec | 63753 | 5786 | 55960 | 2007 | 52.9399 | -73.5491 | 2020-09-08 04:28:25 | 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 | ||
813355 | 813355 | 2020-09-05 | Canada | Quebec | 63368 | 5784 | 55810 | 1774 | 52.9399 | -73.5491 | 2020-09-06 04:28:33 | 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 | ||
1354095 | 1354095 | 2020-09-03 | Canada | Quebec | 62988 | 5783 | 55615 | 1590 | 52.9399 | -73.5491 | 2020-09-04 04:28:26 | 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 | ||
2059661 | 2059661 | 2020-09-01 | Canada | Quebec | 62577 | 5780 | 55438 | 1359 | 52.9399 | -73.5491 | 2020-09-02 04:28:25 | 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 | ||
3931805 | 3931805 | 2020-08-30 | Canada | Quebec | 62293 | 5779 | 55300 | 1214 | 52.9399 | -73.5491 | 2020-08-31 04:28:27 | 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 | ||
1522962 | 1522962 | 2020-08-28 | Canada | Quebec | 62035 | 5776 | 55106 | 1153 | 52.9399 | -73.5491 | 2020-08-29 04:28:19 | 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 | ||
1996423 | 1996423 | 2020-08-26 | Canada | Quebec | 61804 | 5770 | 54922 | 1112 | 52.9399 | -73.5491 | 2020-08-27 04:28:15 | 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 | ||
2991051 | 2991051 | 2020-08-24 | Canada | Quebec | 61580 | 5769 | 54761 | 1050 | 52.9399 | -73.5491 | 2020-08-25 04:28:02 | 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 | ||
2299228 | 2299228 | 2020-08-22 | Canada | Quebec | 61460 | 5764 | 54576 | 1120 | 52.9399 | -73.5491 | 2020-08-23 04:27:48 | 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 | ||
3484084 | 3484084 | 2020-08-20 | Canada | Quebec | 61282 | 5760 | 54383 | 1139 | 52.9399 | -73.5491 | 2020-08-21 04:27:41 | 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 | ||
3177787 | 3177787 | 2020-08-18 | Canada | Quebec | 61104 | 5755 | 54083 | 1266 | 52.9399 | -73.5491 | 2020-08-19 04:27:00 | 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 | ||
1555749 | 1555749 | 2020-08-16 | Canada | Quebec | 60973 | 5752 | 53847 | 1374 | 52.9399 | -73.5491 | 2020-08-17 04:27:20 | 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 | ||
1612026 | 1612026 | 2020-08-14 | Canada | Quebec | 60863 | 5745 | 53598 | 1520 | 52.9399 | -73.5491 | 2020-08-15 04:27:31 | 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 | ||
3531229 | 3531229 | 2020-08-12 | Canada | Quebec | 60690 | 5742 | 53270 | 1678 | 52.9399 | -73.5491 | 2020-08-13 04:29:15 | 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 | ||
1920528 | 1920528 | 2020-08-10 | Canada | Quebec | 60500 | 5736 | 53041 | 1723 | 52.9399 | -73.5491 | 2020-08-11 04:35:08 | 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 | ||
371505 | 371505 | 2020-08-08 | Canada | Quebec | 60303 | 5732 | 50886 | 3685 | 52.9399 | -73.5491 | 2020-08-09 04:34:54 | 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 | ||
3612374 | 3612374 | 2020-08-06 | Canada | Quebec | 60061 | 5729 | 50886 | 3446 | 52.9399 | -73.5491 | 2020-08-07 04:35:11 | 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 | ||
98440 | 98440 | 2020-08-04 | Canada | Quebec | 59844 | 5723 | 50886 | 3235 | 52.9399 | -73.5491 | 2020-08-05 04:34:43 | 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 | ||
2808075 | 2808075 | 2020-08-02 | Canada | Quebec | 59550 | 5723 | 50886 | 2941 | 52.9399 | -73.5491 | 2020-08-03 04:34:35 | 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 | ||
3264808 | 3264808 | 2020-07-31 | Canada | Quebec | 59328 | 5719 | 50886 | 2723 | 52.9399 | -73.5491 | 2020-08-01 04:36:27 | 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 | ||
2958683 | 2958683 | 2020-07-29 | Canada | Quebec | 59041 | 5714 | 50886 | 2441 | 52.9399 | -73.5491 | 2020-07-30 04:35:05 | 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 | ||
177350 | 177350 | 2020-07-27 | Canada | Quebec | 58734 | 5713 | 50886 | 2135 | 52.9399 | -73.5491 | 2020-07-28 04:58:43 | 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 | ||
1502907 | 1502907 | 2020-07-25 | Canada | Quebec | 58498 | 5711 | 50713 | 2074 | 52.9399 | -73.5491 | 2020-07-26 04:35:00 | 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 | ||
62088 | 62088 | 2020-07-23 | Canada | Quebec | 58176 | 5709 | 50505 | 1962 | 52.9399 | -73.5491 | 2020-07-24 05:30:40 | 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 | ||
1707636 | 1707636 | 2020-07-21 | Canada | Quebec | 57810 | 5704 | 50298 | 1808 | 52.9399 | -73.5491 | 2020-07-22 04:34:42 | 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 | ||
122032 | 122032 | 2020-07-19 | Canada | Quebec | 57529 | 5702 | 50050 | 1777 | 52.9399 | -73.5491 | 2020-07-20 05:34:40 | 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 | ||
2708723 | 2708723 | 2020-07-17 | Canada | Quebec | 57213 | 5699 | 49939 | 1575 | 52.9399 | -73.5491 | 2020-07-18 04:34:45 | 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 | ||
2748201 | 2748201 | 2020-07-15 | Canada | Quebec | 56879 | 5693 | 26097 | 25089 | 52.9399 | -73.5491 | 2020-07-16 04:44:59 | 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 | ||
3491486 | 3491486 | 2020-07-13 | Canada | Quebec | 56602 | 5687 | 25911 | 25004 | 52.9399 | -73.5491 | 2020-07-14 04:34:46 | 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 | ||
3436144 | 3436144 | 2020-07-11 | Canada | Quebec | 56390 | 5684 | 25773 | 24933 | 52.9399 | -73.5491 | 2020-07-12 04:34:30 | 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 |
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]);