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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1936226 | 1936226 | 2021-02-23 | Canada | Quebec | 283469 | 10330 | 265456 | 7683 | 52.9399 | -73.5491 | 2021-02-24 05:29:16 | Quebec, Canada | ||
530481 | 530481 | 2021-02-22 | Canada | Quebec | 282638 | 10318 | 264497 | 7823 | 52.9399 | -73.5491 | 2021-02-23 05:23:41 | Quebec, Canada | ||
181815 | 181815 | 2021-02-21 | Canada | Quebec | 282002 | 10307 | 263537 | 8158 | 52.9399 | -73.5491 | 2021-02-22 05:24:21 | Quebec, Canada | ||
742089 | 742089 | 2021-02-20 | Canada | Quebec | 281186 | 10292 | 262506 | 8388 | 52.9399 | -73.5491 | 2021-02-21 05:24:33 | Quebec, Canada | ||
471187 | 471187 | 2021-02-19 | Canada | Quebec | 280468 | 10278 | 261429 | 8761 | 52.9399 | -73.5491 | 2021-02-20 05:22:51 | Quebec, Canada | ||
1152897 | 1152897 | 2021-02-18 | Canada | Quebec | 279690 | 10264 | 260245 | 9181 | 52.9399 | -73.5491 | 2021-02-19 05:24:16 | Quebec, Canada | ||
3600817 | 3600817 | 2021-02-17 | Canada | Quebec | 278830 | 10258 | 259416 | 9156 | 52.9399 | -73.5491 | 2021-02-18 05:22:58 | Quebec, Canada | ||
3049952 | 3049952 | 2021-02-16 | Canada | Quebec | 278048 | 10246 | 258542 | 9260 | 52.9399 | -73.5491 | 2021-02-17 05:23:10 | Quebec, Canada | ||
1338051 | 1338051 | 2021-02-15 | Canada | Quebec | 277201 | 10229 | 257434 | 9538 | 52.9399 | -73.5491 | 2021-02-16 05:24:38 | Quebec, Canada | ||
2283202 | 2283202 | 2021-02-14 | Canada | Quebec | 276530 | 10214 | 256270 | 10046 | 52.9399 | -73.5491 | 2021-02-15 05:24:49 | Quebec, Canada | ||
2677602 | 2677602 | 2021-02-13 | Canada | Quebec | 275807 | 10201 | 254001 | 11605 | 52.9399 | -73.5491 | 2021-02-14 05:23:43 | Quebec, Canada | ||
3539235 | 3539235 | 2021-02-12 | Canada | Quebec | 274974 | 10173 | 254001 | 10800 | 52.9399 | -73.5491 | 2021-02-13 05:22:12 | Quebec, Canada | ||
2637498 | 2637498 | 2021-02-11 | Canada | Quebec | 273953 | 10149 | 252651 | 11153 | 52.9399 | -73.5491 | 2021-02-12 05:23:29 | Quebec, Canada | ||
3978353 | 3978353 | 2021-02-10 | Canada | Quebec | 272938 | 10112 | 251620 | 11206 | 52.9399 | -73.5491 | 2021-02-11 05:23:55 | Quebec, Canada | ||
1527673 | 1527673 | 2021-02-09 | Canada | Quebec | 271776 | 10078 | 250652 | 11046 | 52.9399 | -73.5491 | 2021-02-10 05:22:41 | Quebec, Canada | ||
613464 | 613464 | 2021-02-08 | Canada | Quebec | 270807 | 10046 | 249361 | 11400 | 52.9399 | -73.5491 | 2021-02-09 05:23:30 | Quebec, Canada | ||
1672233 | 1672233 | 2021-02-07 | Canada | Quebec | 270030 | 10031 | 248112 | 11887 | 52.9399 | -73.5491 | 2021-02-08 05:22:39 | Quebec, Canada | ||
974694 | 974694 | 2021-02-06 | Canada | Quebec | 269193 | 9999 | 246695 | 12499 | 52.9399 | -73.5491 | 2021-02-07 05:23:00 | Quebec, Canada | ||
1587952 | 1587952 | 2021-02-05 | Canada | Quebec | 268147 | 9973 | 245339 | 12835 | 52.9399 | -73.5491 | 2021-02-06 05:23:55 | Quebec, Canada | ||
790159 | 790159 | 2021-02-04 | Canada | Quebec | 266928 | 9941 | 243769 | 13218 | 52.9399 | -73.5491 | 2021-02-05 05:22:38 | Quebec, Canada | ||
340051 | 340051 | 2021-02-03 | Canada | Quebec | 265848 | 9899 | 242692 | 13257 | 52.9399 | -73.5491 | 2021-02-04 05:22:26 | Quebec, Canada | ||
1684277 | 1684277 | 2021-02-02 | Canada | Quebec | 264766 | 9862 | 241537 | 13367 | 52.9399 | -73.5491 | 2021-02-03 05:22:52 | Quebec, Canada | ||
1676247 | 1676247 | 2021-02-01 | Canada | Quebec | 263599 | 9826 | 240083 | 13690 | 52.9399 | -73.5491 | 2021-02-02 05:22:49 | Quebec, Canada | ||
1459535 | 1459535 | 2021-01-31 | Canada | Quebec | 262623 | 9794 | 238648 | 14181 | 52.9399 | -73.5491 | 2021-02-01 05:22:53 | Quebec, Canada | ||
2211443 | 2211443 | 2021-01-30 | Canada | Quebec | 261745 | 9763 | 237088 | 14894 | 52.9399 | -73.5491 | 2021-01-31 05:22:42 | Quebec, Canada | ||
1896930 | 1896930 | 2021-01-29 | Canada | Quebec | 260512 | 9717 | 235516 | 15279 | 52.9399 | -73.5491 | 2021-01-30 05:22:49 | Quebec, Canada | ||
2481746 | 2481746 | 2021-01-28 | Canada | Quebec | 259231 | 9667 | 233768 | 15796 | 52.9399 | -73.5491 | 2021-01-29 05:22:23 | Quebec, Canada | ||
3153381 | 3153381 | 2021-01-27 | Canada | Quebec | 257944 | 9561 | 232221 | 16162 | 52.9399 | -73.5491 | 2021-01-28 05:22:24 | Quebec, Canada | ||
12116 | 12116 | 2021-01-26 | Canada | Quebec | 256671 | 9553 | 230803 | 16315 | 52.9399 | -73.5491 | 2021-01-27 05:23:41 | Quebec, Canada | ||
2567440 | 2567440 | 2021-01-25 | Canada | Quebec | 255320 | 9519 | 228887 | 16914 | 52.9399 | -73.5491 | 2021-01-26 05:22:02 | Quebec, Canada | ||
1759072 | 1759072 | 2021-01-24 | Canada | Quebec | 254102 | 9494 | 227215 | 17393 | 52.9399 | -73.5491 | 2021-01-25 05:22:16 | Quebec, Canada | ||
2426679 | 2426679 | 2021-01-23 | Canada | Quebec | 252937 | 9443 | 223367 | 20127 | 52.9399 | -73.5491 | 2021-01-24 05:22:35 | Quebec, Canada | ||
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 |
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]);