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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3962295 | 3962295 | 2021-03-10 | Canada | Quebec | 294366 | 10503 | 277185 | 6678 | 52.9399 | -73.5491 | 2021-03-11 05:25:48 | Quebec, Canada | ||
3663383 | 3663383 | 2021-03-09 | Canada | Quebec | 293648 | 10493 | 276602 | 6553 | 52.9399 | -73.5491 | 2021-03-10 05:24:35 | Quebec, Canada | ||
2359242 | 2359242 | 2021-03-08 | Canada | Quebec | 292852 | 10481 | 275796 | 6575 | 52.9399 | -73.5491 | 2021-03-09 05:28:19 | Quebec, Canada | ||
54580 | 54580 | 2021-03-07 | Canada | Quebec | 292239 | 10472 | 275059 | 6708 | 52.9399 | -73.5491 | 2021-03-08 05:24:48 | Quebec, Canada | ||
3667397 | 3667397 | 2021-03-06 | Canada | Quebec | 291628 | 10465 | 274245 | 6918 | 52.9399 | -73.5491 | 2021-03-07 05:21:54 | Quebec, Canada | ||
1616018 | 1616018 | 2021-03-05 | Canada | Quebec | 290885 | 10455 | 273430 | 7000 | 52.9399 | -73.5491 | 2021-03-06 04:23:41 | Quebec, Canada | ||
2207429 | 2207429 | 2021-03-04 | Canada | Quebec | 290181 | 10445 | 272553 | 7183 | 52.9399 | -73.5491 | 2021-03-05 05:26:29 | Quebec, Canada | ||
1089850 | 1089850 | 2021-03-03 | Canada | Quebec | 289322 | 10426 | 271908 | 6988 | 52.9399 | -73.5491 | 2021-03-04 05:24:24 | Quebec, Canada | ||
3253922 | 3253922 | 2021-03-02 | Canada | Quebec | 288637 | 10407 | 271156 | 7074 | 52.9399 | -73.5491 | 2021-03-03 05:23:28 | Quebec, Canada | ||
998214 | 998214 | 2021-03-01 | Canada | Quebec | 287874 | 10399 | 270364 | 7111 | 52.9399 | -73.5491 | 2021-03-02 05:23:30 | Quebec, Canada | ||
2367272 | 2367272 | 2021-02-28 | Canada | Quebec | 287289 | 10393 | 269530 | 7366 | 52.9399 | -73.5491 | 2021-03-01 05:23:01 | Quebec, Canada | ||
3065774 | 3065774 | 2021-02-27 | Canada | Quebec | 286714 | 10385 | 268645 | 7684 | 52.9399 | -73.5491 | 2021-02-28 05:22:20 | Quebec, Canada | ||
2183358 | 2183358 | 2021-02-26 | Canada | Quebec | 286006 | 10372 | 267885 | 7749 | 52.9399 | -73.5491 | 2021-02-27 05:22:28 | Quebec, Canada | ||
1857780 | 1857780 | 2021-02-25 | Canada | Quebec | 285136 | 10361 | 266879 | 7896 | 52.9399 | -73.5491 | 2021-02-26 05:22:40 | Quebec, Canada | ||
279958 | 279958 | 2021-02-24 | Canada | Quebec | 284324 | 10346 | 266138 | 7840 | 52.9399 | -73.5491 | 2021-02-25 05:24:57 | Quebec, Canada | ||
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 |
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]);