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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2466581 | 2466581 | 2021-01-22 | Canada | Quebec | 251607 | 9396 | 223367 | 18844 | 52.9399 | -73.5491 | 2021-01-23 05:22:03 | Quebec, Canada | ||
435132 | 435132 | 2021-01-21 | Canada | Quebec | 250073 | 9338 | 221327 | 19408 | 52.9399 | -73.5491 | 2021-01-22 05:22:10 | Quebec, Canada | ||
1093864 | 1093864 | 2021-01-20 | Canada | Quebec | 248277 | 9293 | 219592 | 19392 | 52.9399 | -73.5491 | 2021-01-21 05:22:01 | Quebec, Canada | ||
907954 | 907954 | 2021-01-19 | Canada | Quebec | 246704 | 9235 | 217575 | 19894 | 52.9399 | -73.5491 | 2021-01-20 05:21:54 | Quebec, Canada | ||
237017 | 237017 | 2021-01-18 | Canada | Quebec | 245187 | 9188 | 215325 | 20674 | 52.9399 | -73.5491 | 2021-01-19 05:22:15 | Quebec, Canada | ||
3503134 | 3503134 | 2021-01-17 | Canada | Quebec | 243849 | 9137 | 213008 | 21704 | 52.9399 | -73.5491 | 2021-01-18 05:22:34 | Quebec, Canada | ||
3101217 | 3101217 | 2021-01-16 | Canada | Quebec | 242336 | 9096 | 210364 | 22876 | 52.9399 | -73.5491 | 2021-01-17 05:22:17 | Quebec, Canada | ||
3515179 | 3515179 | 2021-01-15 | Canada | Quebec | 240410 | 9051 | 207934 | 23425 | 52.9399 | -73.5491 | 2021-01-16 05:22:40 | Quebec, Canada | ||
3879352 | 3879352 | 2021-01-14 | Canada | Quebec | 238528 | 9005 | 204741 | 24782 | 52.9399 | -73.5491 | 2021-01-15 05:22:24 | Quebec, Canada | ||
3307979 | 3307979 | 2021-01-13 | Canada | Quebec | 236581 | 8950 | 202166 | 25465 | 52.9399 | -73.5491 | 2021-01-14 05:22:32 | Quebec, Canada | ||
774124 | 774124 | 2021-01-12 | Canada | Quebec | 234567 | 8886 | 199920 | 25761 | 52.9399 | -73.5491 | 2021-01-13 05:22:15 | Quebec, Canada | ||
189845 | 189845 | 2021-01-11 | Canada | Quebec | 232383 | 8840 | 197938 | 25605 | 52.9399 | -73.5491 | 2021-01-12 05:22:15 | Quebec, Canada | ||
2625648 | 2625648 | 2021-01-10 | Canada | Quebec | 230590 | 8800 | 195663 | 26127 | 52.9399 | -73.5491 | 2021-01-11 05:21:50 | Quebec, Canada | ||
3899736 | 3899736 | 2021-01-09 | Canada | Quebec | 228557 | 8762 | 192979 | 26816 | 52.9399 | -73.5491 | 2021-01-10 05:22:12 | Quebec, Canada | ||
153759 | 153759 | 2021-01-08 | Canada | Quebec | 226549 | 8717 | 189937 | 27895 | 52.9399 | -73.5491 | 2021-01-09 05:22:18 | Quebec, Canada | ||
2541183 | 2541183 | 2021-01-07 | Canada | Quebec | 223803 | 8671 | 186996 | 28136 | 52.9399 | -73.5491 | 2021-01-08 05:22:42 | Quebec, Canada | ||
2864492 | 2864492 | 2021-01-06 | Canada | Quebec | 220970 | 8624 | 184904 | 27442 | 52.9399 | -73.5491 | 2021-01-07 05:22:03 | Quebec, Canada | ||
3034079 | 3034079 | 2021-01-05 | Canada | Quebec | 218103 | 8577 | 182602 | 26924 | 52.9399 | -73.5491 | 2021-01-06 05:22:16 | Quebec, Canada | ||
1061624 | 1061624 | 2021-01-04 | Canada | Quebec | 215517 | 8528 | 181205 | 25784 | 52.9399 | -73.5491 | 2021-01-05 05:21:49 | Quebec, Canada | ||
3230227 | 3230227 | 2021-01-03 | Canada | Quebec | 212962 | 8473 | 179456 | 25033 | 52.9399 | -73.5491 | 2021-01-04 05:22:02 | Quebec, Canada | ||
2227297 | 2227297 | 2021-01-02 | Canada | Quebec | 210797 | 8433 | 170045 | 32319 | 52.9399 | -73.5491 | 2021-01-03 05:22:52 | Quebec, Canada | ||
1136661 | 1136661 | 2021-01-01 | Canada | Quebec | 208390 | 8388 | 170045 | 29957 | 52.9399 | -73.5491 | 2021-01-02 05:22:33 | Quebec, Canada | ||
3695267 | 3695267 | 2020-12-31 | Canada | Quebec | 205661 | 8356 | 170045 | 27260 | 52.9399 | -73.5491 | 2021-01-01 05:23:07 | Quebec, Canada | ||
1010082 | 1010082 | 2020-12-30 | Canada | Quebec | 203129 | 8317 | 170045 | 24767 | 52.9399 | -73.5491 | 2020-12-31 05:22:49 | Quebec, Canada | ||
766097 | 766097 | 2020-12-29 | Canada | Quebec | 200327 | 8265 | 168061 | 24001 | 52.9399 | -73.5491 | 2020-12-30 05:22:34 | Quebec, Canada | ||
3761361 | 3761361 | 2020-12-28 | Canada | Quebec | 197468 | 8219 | 166066 | 23183 | 52.9399 | -73.5491 | 2020-12-29 05:22:37 | Quebec, Canada | ||
3777681 | 3777681 | 2020-12-27 | Canada | Quebec | 195161 | 8173 | 164163 | 22825 | 52.9399 | -73.5491 | 2020-12-28 05:22:06 | Quebec, Canada | ||
2223286 | 2223286 | 2020-12-26 | Canada | Quebec | 193003 | 8130 | 156275 | 28598 | 52.9399 | -73.5491 | 2020-12-27 05:22:55 | Quebec, Canada | ||
202033 | 202033 | 2020-12-25 | Canada | Quebec | 190916 | 8085 | 156275 | 26556 | 52.9399 | -73.5491 | 2020-12-26 05:22:28 | Quebec, Canada | ||
3691256 | 3691256 | 2020-12-24 | Canada | Quebec | 188618 | 8040 | 156275 | 24303 | 52.9399 | -73.5491 | 2020-12-25 05:22:48 | Quebec, Canada | ||
2406608 | 2406608 | 2020-12-23 | Canada | Quebec | 186221 | 8003 | 156275 | 21943 | 52.9399 | -73.5491 | 2020-12-24 05:23:04 | Quebec, Canada | ||
3769654 | 3769654 | 2020-12-22 | Canada | Quebec | 183998 | 7957 | 154673 | 21368 | 52.9399 | -73.5491 | 2020-12-23 05:22:03 | Quebec, Canada | ||
927470 | 927470 | 2020-12-21 | Canada | Quebec | 181844 | 7901 | 152869 | 21074 | 52.9399 | -73.5491 | 2020-12-22 05:22:33 | Quebec, Canada | ||
2119491 | 2119491 | 2020-12-20 | Canada | Quebec | 179737 | 7865 | 151044 | 20828 | 52.9399 | -73.5491 | 2020-12-21 05:27:58 | Quebec, Canada | ||
2930998 | 2930998 | 2020-12-19 | Canada | Quebec | 177772 | 7828 | 149245 | 20699 | 52.9399 | -73.5491 | 2020-12-20 05:27:32 | Quebec, Canada | ||
1900944 | 1900944 | 2020-12-18 | Canada | Quebec | 175716 | 7796 | 147398 | 20522 | 52.9399 | -73.5491 | 2020-12-19 05:27:52 | Quebec, Canada | ||
2127770 | 2127770 | 2020-12-17 | Canada | Quebec | 173598 | 7762 | 145532 | 20304 | 52.9399 | -73.5491 | 2020-12-18 05:28:18 | Quebec, Canada | ||
3149370 | 3149370 | 2020-12-16 | Canada | Quebec | 171282 | 7709 | 144168 | 19405 | 52.9399 | -73.5491 | 2020-12-17 05:28:12 | Quebec, Canada | ||
1034151 | 1034151 | 2020-12-15 | Canada | Quebec | 169164 | 7679 | 142894 | 18591 | 52.9399 | -73.5491 | 2020-12-16 05:28:04 | Quebec, Canada | ||
1751045 | 1751045 | 2020-12-14 | Canada | Quebec | 167376 | 7640 | 141345 | 18391 | 52.9399 | -73.5491 | 2020-12-15 05:26:38 | Quebec, Canada | ||
3847565 | 3847565 | 2020-12-13 | Canada | Quebec | 165488 | 7594 | 139850 | 18044 | 52.9399 | -73.5491 | 2020-12-14 05:26:27 | Quebec, Canada | ||
845347 | 845347 | 2020-12-12 | Canada | Quebec | 163726 | 7561 | 138270 | 17895 | 52.9399 | -73.5491 | 2020-12-13 05:27:20 | Quebec, Canada | ||
860454 | 860454 | 2020-12-11 | Canada | Quebec | 161734 | 7523 | 136646 | 17565 | 52.9399 | -73.5491 | 2020-12-12 05:26:19 | Quebec, Canada | ||
1599996 | 1599996 | 2020-12-10 | Canada | Quebec | 159823 | 7479 | 134910 | 17434 | 52.9399 | -73.5491 | 2020-12-11 05:26:59 | Quebec, Canada | ||
2975005 | 2975005 | 2020-12-09 | Canada | Quebec | 158063 | 7449 | 133692 | 16922 | 52.9399 | -73.5491 | 2020-12-10 05:26:19 | Quebec, Canada | ||
1818565 | 1818565 | 2020-12-08 | Canada | Quebec | 156317 | 7419 | 132573 | 16325 | 52.9399 | -73.5491 | 2020-12-09 05:28:01 | Quebec, Canada | ||
2347201 | 2347201 | 2020-12-07 | Canada | Quebec | 154658 | 7377 | 131297 | 15984 | 52.9399 | -73.5491 | 2020-12-08 05:27:42 | Quebec, Canada | ||
1006071 | 1006071 | 2020-12-06 | Canada | Quebec | 153032 | 7342 | 130018 | 15672 | 52.9399 | -73.5491 | 2020-12-07 05:26:14 | Quebec, Canada | ||
1632080 | 1632080 | 2020-12-05 | Canada | Quebec | 151496 | 7314 | 128828 | 15354 | 52.9399 | -73.5491 | 2020-12-06 05:26:18 | Quebec, Canada | ||
3859608 | 3859608 | 2020-12-04 | Canada | Quebec | 149853 | 7280 | 127549 | 15024 | 52.9399 | -73.5491 | 2020-12-05 05:27:36 | Quebec, Canada | ||
74866 | 74866 | 2020-12-03 | Canada | Quebec | 148087 | 7245 | 126179 | 14663 | 52.9399 | -73.5491 | 2020-12-04 05:27:27 | Quebec, Canada | ||
738078 | 738078 | 2020-12-02 | Canada | Quebec | 146584 | 7206 | 125197 | 14181 | 52.9399 | -73.5491 | 2020-12-03 05:28:22 | Quebec, Canada | ||
2537172 | 2537172 | 2020-12-01 | Canada | Quebec | 145039 | 7172 | 124200 | 13667 | 52.9399 | -73.5491 | 2020-12-02 05:27:41 | Quebec, Canada | ||
1583941 | 1583941 | 2020-11-30 | Canada | Quebec | 143522 | 7148 | 123177 | 13197 | 52.9399 | -73.5491 | 2020-12-01 05:26:18 | Quebec, Canada | ||
3566344 | 3566344 | 2020-11-29 | Canada | Quebec | 142256 | 7117 | 122014 | 13125 | 52.9399 | -73.5491 | 2020-11-30 05:26:13 | Quebec, Canada | ||
2935009 | 2935009 | 2020-11-28 | Canada | Quebec | 140874 | 7084 | 120906 | 12884 | 52.9399 | -73.5491 | 2020-11-29 05:25:55 | Quebec, Canada | ||
392012 | 392012 | 2020-11-27 | Canada | Quebec | 139443 | 7056 | 119727 | 12660 | 52.9399 | -73.5491 | 2020-11-28 05:25:50 | Quebec, Canada | ||
923459 | 923459 | 2020-11-26 | Canada | Quebec | 138170 | 7031 | 118491 | 12648 | 52.9399 | -73.5491 | 2020-11-27 05:26:53 | Quebec, Canada | ||
1972364 | 1972364 | 2020-11-25 | Canada | Quebec | 136835 | 7002 | 117551 | 12282 | 52.9399 | -73.5491 | 2020-11-26 05:27:44 | Quebec, Canada | ||
1350095 | 1350095 | 2020-11-24 | Canada | Quebec | 135452 | 6973 | 116624 | 11855 | 52.9399 | -73.5491 | 2020-11-25 05:27:20 | Quebec, Canada | ||
678090 | 678090 | 2020-11-23 | Canada | Quebec | 134221 | 6934 | 115367 | 11920 | 52.9399 | -73.5491 | 2020-11-24 05:27:31 | Quebec, Canada | ||
3189766 | 3189766 | 2020-11-22 | Canada | Quebec | 133144 | 6910 | 114085 | 12149 | 52.9399 | -73.5491 | 2020-11-23 05:25:26 | Quebec, Canada | ||
3836260 | 3836260 | 2020-11-21 | Canada | Quebec | 131937 | 6878 | 112734 | 12325 | 52.9399 | -73.5491 | 2020-11-22 05:25:45 | Quebec, Canada | ||
2701288 | 2701288 | 2020-11-20 | Canada | Quebec | 130821 | 6850 | 111326 | 12645 | 52.9399 | -73.5491 | 2020-11-21 05:25:51 | Quebec, Canada | ||
821348 | 821348 | 2020-11-19 | Canada | Quebec | 129674 | 6824 | 109800 | 13050 | 52.9399 | -73.5491 | 2020-11-20 05:26:28 | Quebec, Canada | ||
122482 | 122482 | 2020-11-18 | Canada | Quebec | 128366 | 6796 | 108625 | 12945 | 52.9399 | -73.5491 | 2020-11-19 05:25:23 | Quebec, Canada | ||
3338370 | 3338370 | 2020-11-17 | Canada | Quebec | 127162 | 6759 | 107326 | 13077 | 52.9399 | -73.5491 | 2020-11-18 05:40:31 | Quebec, Canada | ||
3169415 | 3169415 | 2020-11-16 | Canada | Quebec | 126036 | 6728 | 105998 | 13310 | 52.9399 | -73.5491 | 2020-11-17 05:25:54 | Quebec, Canada | ||
2879983 | 2879983 | 2020-11-15 | Canada | Quebec | 125011 | 6703 | 104848 | 13460 | 52.9399 | -73.5491 | 2020-11-16 05:25:57 | Quebec, Canada | ||
2914961 | 2914961 | 2020-11-14 | Canada | Quebec | 123898 | 6677 | 103668 | 13553 | 52.9399 | -73.5491 | 2020-11-15 05:26:53 | Quebec, Canada | ||
2784783 | 2784783 | 2020-11-13 | Canada | Quebec | 122659 | 6652 | 102569 | 13438 | 52.9399 | -73.5491 | 2020-11-14 05:25:37 | Quebec, Canada | ||
864548 | 864548 | 2020-11-12 | Canada | Quebec | 121284 | 6634 | 101407 | 13243 | 52.9399 | -73.5491 | 2020-11-13 05:25:30 | Quebec, Canada | ||
3440593 | 3440593 | 2020-11-11 | Canada | Quebec | 119952 | 6599 | 100564 | 12789 | 52.9399 | -73.5491 | 2020-11-12 05:25:55 | Quebec, Canada | ||
271933 | 271933 | 2020-11-10 | Canada | Quebec | 118562 | 6569 | 99721 | 12272 | 52.9399 | -73.5491 | 2020-11-11 05:25:30 | Quebec, Canada | ||
1988410 | 1988410 | 2020-11-09 | Canada | Quebec | 117257 | 6537 | 98740 | 11980 | 52.9399 | -73.5491 | 2020-11-10 05:40:07 | Quebec, Canada | ||
1728262 | 1728262 | 2020-11-08 | Canada | Quebec | 116050 | 6506 | 97789 | 11755 | 52.9399 | -73.5491 | 2020-11-09 05:25:45 | Quebec, Canada | ||
1543722 | 1543722 | 2020-11-07 | Canada | Quebec | 114747 | 6477 | 96831 | 11439 | 52.9399 | -73.5491 | 2020-11-08 05:24:56 | Quebec, Canada | ||
375960 | 375960 | 2020-11-06 | Canada | Quebec | 113509 | 6456 | 95956 | 11097 | 52.9399 | -73.5491 | 2020-11-07 05:24:52 | Quebec, Canada | ||
891898 | 891898 | 2020-11-05 | Canada | Quebec | 112313 | 6430 | 94884 | 10999 | 52.9399 | -73.5491 | 2020-11-06 05:24:55 | Quebec, Canada | ||
2918960 | 2918960 | 2020-11-04 | Canada | Quebec | 111042 | 6409 | 94101 | 10532 | 52.9399 | -73.5491 | 2020-11-05 06:05:03 | Quebec, Canada | ||
2497797 | 2497797 | 2020-11-03 | Canada | Quebec | 109878 | 6386 | 93316 | 10176 | 52.9399 | -73.5491 | 2020-11-04 05:25:09 | Quebec, Canada | ||
3303972 | 3303972 | 2020-11-02 | Canada | Quebec | 108814 | 6366 | 92396 | 10052 | 52.9399 | -73.5491 | 2020-11-03 06:00:16 | Quebec, Canada | ||
3409221 | 3409221 | 2020-11-01 | Canada | Quebec | 107918 | 6355 | 91488 | 10075 | 52.9399 | -73.5491 | 2020-11-02 05:25:04 | Quebec, Canada | ||
2079710 | 2079710 | 2020-10-31 | Canada | Quebec | 106894 | 6335 | 90576 | 9983 | 52.9399 | -73.5491 | 2020-11-01 04:36:19 | Quebec, Canada | ||
2243163 | 2243163 | 2020-10-30 | Canada | Quebec | 105911 | 6305 | 89592 | 10014 | 52.9399 | -73.5491 | 2020-10-31 04:24:44 | Quebec, Canada | ||
210018 | 210018 | 2020-10-29 | Canada | Quebec | 104958 | 6279 | 88442 | 10237 | 52.9399 | -73.5491 | 2020-10-30 04:24:49 | Quebec, Canada | ||
754080 | 754080 | 2020-10-28 | Canada | Quebec | 103894 | 6263 | 87638 | 9993 | 52.9399 | -73.5491 | 2020-10-29 04:24:49 | Quebec, Canada | ||
1452365 | 1452365 | 2020-10-27 | Canada | Quebec | 102903 | 6240 | 86786 | 9877 | 52.9399 | -73.5491 | 2020-10-28 04:24:39 | Quebec, Canada | ||
3480089 | 3480089 | 2020-10-26 | Canada | Quebec | 101933 | 6222 | 85822 | 9889 | 52.9399 | -73.5491 | 2020-10-27 04:24:45 | Quebec, Canada | ||
8110 | 8110 | 2020-10-25 | Canada | Quebec | 100944 | 6205 | 84828 | 9911 | 52.9399 | -73.5491 | 2020-10-26 04:25:02 | Quebec, Canada | ||
3651347 | 3651347 | 2020-10-24 | Canada | Quebec | 100119 | 6189 | 83819 | 10111 | 52.9399 | -73.5491 | 2020-10-25 04:24:36 | Quebec, Canada | ||
1053602 | 1053602 | 2020-10-23 | Canada | Quebec | 99281 | 6170 | 82792 | 10319 | 52.9399 | -73.5491 | 2020-10-24 04:24:46 | Quebec, Canada | ||
1177272 | 1177272 | 2020-10-22 | Canada | Quebec | 98245 | 6155 | 82033 | 10057 | 52.9399 | -73.5491 | 2020-10-23 04:24:46 | Quebec, Canada | ||
2191377 | 2191377 | 2020-10-21 | Canada | Quebec | 97313 | 6137 | 81267 | 9909 | 52.9399 | -73.5491 | 2020-10-22 04:24:27 | Quebec, Canada | ||
3990388 | 3990388 | 2020-10-20 | Canada | Quebec | 96332 | 6115 | 80468 | 9749 | 52.9399 | -73.5491 | 2020-10-21 04:24:14 | Quebec, Canada | ||
1794408 | 1794408 | 2020-10-19 | Canada | Quebec | 95294 | 6103 | 79529 | 9662 | 52.9399 | -73.5491 | 2020-10-20 04:24:22 | Quebec, Canada | ||
762092 | 762092 | 2020-10-18 | Canada | Quebec | 94448 | 6082 | 78559 | 9807 | 52.9399 | -73.5491 | 2020-10-19 04:24:16 | Quebec, Canada | ||
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 |
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]);