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 rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4002427 | 4002427 | 2022-10-08 | Canada | Quebec | 1207949 | 16842 | 0 | 52.9399 | -73.5491 | 2022-10-09 04:21:16 | Quebec, Canada | |||
3998410 | 3998410 | 2021-12-30 | Canada | Quebec | 586606 | 11711 | 0 | 52.9399 | -73.5491 | 2021-12-31 04:21:50 | Quebec, Canada | |||
3994395 | 3994395 | 2022-09-27 | Canada | Quebec | 1197701 | 16754 | 0 | 52.9399 | -73.5491 | 2022-09-28 04:23:01 | 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 | ||
3986384 | 3986384 | 2022-09-15 | Canada | Quebec | 1188798 | 16637 | 0 | 52.9399 | -73.5491 | 2022-09-16 04:21:19 | Quebec, Canada | |||
3982368 | 3982368 | 2022-06-15 | Canada | Quebec | 1075567 | 15514 | 0 | 52.9399 | -73.5491 | 2022-06-16 04:20:55 | 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 | ||
3974339 | 3974339 | 2021-09-03 | Canada | Quebec | 391363 | 11291 | 0 | 52.9399 | -73.5491 | 2021-09-04 04:21:28 | Quebec, Canada | |||
3970325 | 3970325 | 2021-06-11 | Canada | Quebec | 373150 | 11167 | 359421 | 2562 | 52.9399 | -73.5491 | 2021-06-12 04:22:22 | Quebec, Canada | ||
3966310 | 3966310 | 2022-07-05 | Canada | Quebec | 1096171 | 15617 | 0 | 52.9399 | -73.5491 | 2022-07-06 04:20:58 | 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 | ||
3958281 | 3958281 | 2021-06-26 | Canada | Quebec | 374872 | 11202 | 362130 | 1540 | 52.9399 | -73.5491 | 2021-06-27 04:21:39 | Quebec, Canada | ||
3954267 | 3954267 | 2021-05-11 | Canada | Quebec | 360134 | 11002 | 340637 | 8495 | 52.9399 | -73.5491 | 2021-05-12 04:21:29 | Quebec, Canada | ||
3950252 | 3950252 | 2022-08-17 | Canada | Quebec | 1166390 | 16179 | 0 | 52.9399 | -73.5491 | 2022-08-18 04:21:11 | Quebec, Canada | |||
3949919 | 3949919 | 2020-04-09 | Canada | Quebec | 11760 | 484 | 0 | 11276 | 52.9399 | -73.5491 | 2020-04-09 23:09:01 | Quebec, Canada | ||
3946978 | 3946978 | 2020-03-28 | Canada | Quebec | 3007 | 43 | 0 | 2964 | 52.9399 | -73.5491 | 3/28/20 23:10 | Quebec, Canada | ||
3939819 | 3939819 | 2022-06-30 | Canada | Quebec | 1090311 | 15589 | 0 | 52.9399 | -73.5491 | 2022-07-01 04:21:10 | Quebec, Canada | |||
3935803 | 3935803 | 2022-12-09 | Canada | Quebec | 1262542 | 17442 | 0 | 52.9399 | -73.5491 | 2022-12-10 04:21:02 | 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 | ||
3927801 | 3927801 | 2021-10-02 | Canada | Quebec | 411463 | 11382 | 0 | 52.9399 | -73.5491 | 2021-10-03 04:21:24 | 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 | ||
3923337 | 3923337 | 2020-08-09 | Canada | Quebec | 60400 | 5734 | 50886 | 3780 | 52.9399 | -73.5491 | 2020-08-10 04:34:55 | Quebec, Canada | ||
3915795 | 3915795 | 2022-05-01 | Canada | Quebec | 1043729 | 15006 | 0 | 52.9399 | -73.5491 | 2022-05-02 04:21:10 | Quebec, Canada | |||
3911779 | 3911779 | 2022-02-20 | Canada | Quebec | 911397 | 13853 | 0 | 52.9399 | -73.5491 | 2022-02-21 04:21:05 | Quebec, Canada | |||
3907763 | 3907763 | 2022-08-11 | Canada | Quebec | 1160337 | 16098 | 0 | 52.9399 | -73.5491 | 2022-08-12 04:20:54 | Quebec, Canada | |||
3903748 | 3903748 | 2021-07-31 | Canada | Quebec | 377486 | 11241 | 364033 | 2212 | 52.9399 | -73.5491 | 2021-08-01 04: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 | ||
3895721 | 3895721 | 2022-05-19 | Canada | Quebec | 1060042 | 15326 | 0 | 52.9399 | -73.5491 | 2022-05-20 04:20:57 | Quebec, Canada | |||
3891706 | 3891706 | 2021-08-29 | Canada | Quebec | 388413 | 11285 | 0 | 52.9399 | -73.5491 | 2021-08-30 04:21:23 | Quebec, Canada | |||
3891404 | 3891404 | 2020-03-17 | Canada | Quebec | 128 | 1 | 0 | 52.9399 | -73.5491 | 2020-03-17T19:33:03 | ||||
3887379 | 3887379 | 2022-06-06 | Canada | Quebec | 1069517 | 15450 | 0 | 52.9399 | -73.5491 | 2022-06-07 04:21:08 | 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 | ||
3879352 | 3879352 | 2021-01-14 | Canada | Quebec | 238528 | 9005 | 204741 | 24782 | 52.9399 | -73.5491 | 2021-01-15 05:22:24 | Quebec, Canada | ||
3875337 | 3875337 | 2022-02-19 | Canada | Quebec | 910200 | 13841 | 0 | 52.9399 | -73.5491 | 2022-02-20 04:21:00 | Quebec, Canada | |||
3871321 | 3871321 | 2022-07-31 | Canada | Quebec | 1147838 | 15959 | 0 | 52.9399 | -73.5491 | 2022-08-01 04:21:03 | Quebec, Canada | |||
3867305 | 3867305 | 2022-04-05 | Canada | Quebec | 981536 | 14442 | 0 | 52.9399 | -73.5491 | 2022-04-06 04:20:49 | Quebec, Canada | |||
3866875 | 3866875 | 2020-06-03 | Canada | Quebec | 51901 | 5277 | 17098 | 29526 | 52.9399 | -73.5491 | 2020-06-04 02:33:14 | 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 | ||
3855593 | 3855593 | 2022-02-18 | Canada | Quebec | 908464 | 13835 | 0 | 52.9399 | -73.5491 | 2022-02-19 04:21:11 | Quebec, Canada | |||
3851577 | 3851577 | 2022-04-27 | Canada | Quebec | 1037655 | 14928 | 0 | 52.9399 | -73.5491 | 2022-04-28 04:20:47 | 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 | ||
3847227 | 3847227 | 2020-05-13 | Canada | Quebec | 40679 | 4006 | 0 | 36673 | 52.9399 | -73.5491 | 2020-05-14 03:32:28 | Quebec, Canada | ||
3840270 | 3840270 | 2022-01-15 | Canada | Quebec | 789806 | 12289 | 0 | 52.9399 | -73.5491 | 2022-01-16 04:21:12 | 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 | ||
3832245 | 3832245 | 2021-10-05 | Canada | Quebec | 412800 | 11397 | 0 | 52.9399 | -73.5491 | 2021-10-06 04:21:33 | Quebec, Canada | |||
3828229 | 3828229 | 2021-12-21 | Canada | Quebec | 495336 | 11650 | 0 | 52.9399 | -73.5491 | 2021-12-22 04:21:54 | Quebec, Canada | |||
3824214 | 3824214 | 2022-09-10 | Canada | Quebec | 1185085 | 16479 | 0 | 52.9399 | -73.5491 | 2022-09-11 04:20:50 | Quebec, Canada | |||
3820198 | 3820198 | 2022-02-16 | Canada | Quebec | 904572 | 13790 | 0 | 52.9399 | -73.5491 | 2022-02-17 04:20:56 | Quebec, Canada | |||
3816181 | 3816181 | 2021-12-23 | Canada | Quebec | 511094 | 11658 | 0 | 52.9399 | -73.5491 | 2021-12-24 04:21:34 | Quebec, Canada | |||
3815853 | 3815853 | 2020-03-31 | Canada | Quebec | 4881 | 82 | 0 | 4799 | 52.9399 | -73.5491 | 2020-03-31 23:49:13 | Quebec, Canada | ||
3809692 | 3809692 | 2022-01-28 | Canada | Quebec | 853119 | 13113 | 0 | 52.9399 | -73.5491 | 2022-01-29 04:21:10 | Quebec, Canada | |||
3805678 | 3805678 | 2021-09-11 | Canada | Quebec | 396034 | 11301 | 0 | 52.9399 | -73.5491 | 2021-09-12 04:21:13 | 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 | ||
3797671 | 3797671 | 2022-08-20 | Canada | Quebec | 1169400 | 16222 | 0 | 52.9399 | -73.5491 | 2022-08-21 04:20:44 | Quebec, Canada | |||
3793654 | 3793654 | 2021-10-25 | Canada | Quebec | 422994 | 11477 | 0 | 52.9399 | -73.5491 | 2021-10-26 04:22:09 | 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 | ||
3785674 | 3785674 | 2020-10-11 | Canada | Quebec | 87296 | 5995 | 71839 | 9462 | 52.9399 | -73.5491 | 2020-10-12 04:23:45 | 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 | ||
3777681 | 3777681 | 2020-12-27 | Canada | Quebec | 195161 | 8173 | 164163 | 22825 | 52.9399 | -73.5491 | 2020-12-28 05:22:06 | Quebec, Canada | ||
3773666 | 3773666 | 2022-08-30 | Canada | Quebec | 1176935 | 16363 | 0 | 52.9399 | -73.5491 | 2022-08-31 04:20:57 | 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 | ||
3765639 | 3765639 | 2022-09-11 | Canada | Quebec | 1185085 | 16479 | 0 | 52.9399 | -73.5491 | 2022-09-12 04:20:58 | Quebec, Canada | |||
3765373 | 3765373 | 2020-03-13 | Canada | Quebec | 37 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-11T20:00:00 | ||||
3761361 | 3761361 | 2020-12-28 | Canada | Quebec | 197468 | 8219 | 166066 | 23183 | 52.9399 | -73.5491 | 2020-12-29 05:22:37 | Quebec, Canada | ||
3757248 | 3757248 | 2021-09-21 | Canada | Quebec | 404291 | 11335 | 0 | 52.9399 | -73.5491 | 2021-09-22 04:21:45 | Quebec, Canada | |||
3753233 | 3753233 | 2022-10-13 | Canada | Quebec | 1212417 | 16863 | 0 | 52.9399 | -73.5491 | 2022-10-14 04:22:28 | Quebec, Canada | |||
3752954 | 3752954 | 2020-03-10 | Canada | Quebec | 17 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-10T00:53:03 | ||||
3748886 | 3748886 | 2021-11-22 | Canada | Quebec | 439762 | 11560 | 0 | 52.9399 | -73.5491 | 2021-11-23 04:22:39 | Quebec, Canada | |||
3744871 | 3744871 | 2022-09-07 | Canada | Quebec | 1182668 | 16433 | 0 | 52.9399 | -73.5491 | 2022-09-08 04:21:02 | Quebec, Canada | |||
3740856 | 3740856 | 2021-07-12 | Canada | Quebec | 375997 | 11231 | 364033 | 733 | 52.9399 | -73.5491 | 2021-07-13 04:21:18 | Quebec, Canada | ||
3740526 | 3740526 | 2020-04-03 | Canada | Quebec | 7223 | 159 | 0 | 7064 | 52.9399 | -73.5491 | 2020-04-03 22:52: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 | ||
3734017 | 3734017 | 2020-03-20 | Canada | Quebec | 371 | 4 | 0 | 52.9399 | -73.5491 | 2020-03-20T21:13:29 | ||||
3729993 | 3729993 | 2022-04-03 | Canada | Quebec | 976590 | 14404 | 0 | 52.9399 | -73.5491 | 2022-04-04 04:20:51 | Quebec, Canada | |||
3725977 | 3725977 | 2022-06-07 | Canada | Quebec | 1070147 | 15456 | 0 | 52.9399 | -73.5491 | 2022-06-08 04:20:55 | Quebec, Canada | |||
3721961 | 3721961 | 2022-04-25 | Canada | Quebec | 1033922 | 14874 | 0 | 52.9399 | -73.5491 | 2022-04-26 04:20:51 | Quebec, Canada | |||
3717945 | 3717945 | 2022-02-21 | Canada | Quebec | 912461 | 13856 | 0 | 52.9399 | -73.5491 | 2022-02-22 04:21:01 | Quebec, Canada | |||
3713929 | 3713929 | 2022-12-06 | Canada | Quebec | 1258503 | 17409 | 0 | 52.9399 | -73.5491 | 2022-12-07 04:20:58 | 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 | ||
3705900 | 3705900 | 2021-07-17 | Canada | Quebec | 376289 | 11236 | 364033 | 1020 | 52.9399 | -73.5491 | 2021-07-18 04:22:07 | 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 | ||
3701556 | 3701556 | 2020-04-02 | Canada | Quebec | 6453 | 121 | 0 | 6332 | 52.9399 | -73.5491 | 4/2/20 23:31 | 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 | ||
3691256 | 3691256 | 2020-12-24 | Canada | Quebec | 188618 | 8040 | 156275 | 24303 | 52.9399 | -73.5491 | 2020-12-25 05:22:48 | Quebec, Canada | ||
3687240 | 3687240 | 2022-01-13 | Canada | Quebec | 766926 | 12125 | 0 | 52.9399 | -73.5491 | 2022-01-14 04:21:54 | Quebec, Canada | |||
3683226 | 3683226 | 2021-08-02 | Canada | Quebec | 377798 | 11241 | 364033 | 2524 | 52.9399 | -73.5491 | 2021-08-03 04:21:39 | 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 | ||
3675427 | 3675427 | 2021-05-04 | Canada | Quebec | 354163 | 10959 | 333624 | 9580 | 52.9399 | -73.5491 | 2021-05-05 04:20:43 | Quebec, Canada | ||
3671412 | 3671412 | 2022-02-15 | Canada | Quebec | 902244 | 13766 | 0 | 52.9399 | -73.5491 | 2022-02-16 04:21:10 | 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 | ||
3663383 | 3663383 | 2021-03-09 | Canada | Quebec | 293648 | 10493 | 276602 | 6553 | 52.9399 | -73.5491 | 2021-03-10 05:24:35 | Quebec, Canada | ||
3659369 | 3659369 | 2021-07-11 | Canada | Quebec | 375937 | 11230 | 363775 | 932 | 52.9399 | -73.5491 | 2021-07-12 04:21:34 | Quebec, Canada | ||
3655353 | 3655353 | 2021-12-10 | Canada | Quebec | 460430 | 11603 | 0 | 52.9399 | -73.5491 | 2021-12-11 04:22:45 | 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 | ||
3647343 | 3647343 | 2022-08-14 | Canada | Quebec | 1161491 | 16116 | 0 | 52.9399 | -73.5491 | 2022-08-15 04:20:59 | 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 | ||
3639312 | 3639312 | 2021-11-08 | Canada | Quebec | 430394 | 11522 | 0 | 52.9399 | -73.5491 | 2021-11-09 04:21:36 | Quebec, Canada | |||
3638917 | 3638917 | 2020-05-30 | Canada | Quebec | 50775 | 5137 | 16070 | 29568 | 52.9399 | -73.5491 | 2020-05-31 02:32:45 | Quebec, Canada | ||
3631732 | 3631732 | 2021-07-14 | Canada | Quebec | 376109 | 11231 | 364033 | 845 | 52.9399 | -73.5491 | 2021-07-15 04:21:48 | Quebec, Canada | ||
3627717 | 3627717 | 2022-03-13 | Canada | Quebec | 936575 | 14173 | 0 | 52.9399 | -73.5491 | 2022-03-14 04:20:46 | 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]);