daily_reports (view)
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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-09-29 | Canada | Quebec | 409525 | 11369 | 0 | 52.9399 | -73.5491 | 2021-09-30 04:21:20 | Quebec, Canada | |||
2022-11-01 | Canada | Quebec | 1228697 | 17059 | 0 | 52.9399 | -73.5491 | 2022-11-02 04:22:09 | Quebec, Canada | |||
2021-11-12 | Canada | Quebec | 432990 | 11535 | 0 | 52.9399 | -73.5491 | 2021-11-13 04:21:38 | Quebec, Canada | |||
2022-12-04 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
2021-11-20 | Canada | Quebec | 438363 | 11555 | 0 | 52.9399 | -73.5491 | 2021-11-21 04:22:13 | Quebec, Canada | |||
2021-12-27 | Canada | Quebec | 546436 | 11677 | 0 | 52.9399 | -73.5491 | 2021-12-28 04:21:47 | Quebec, Canada | |||
2022-04-23 | Canada | Quebec | 1030942 | 14846 | 0 | 52.9399 | -73.5491 | 2022-04-24 04:20:56 | Quebec, Canada | |||
2021-11-26 | Canada | Quebec | 444584 | 11571 | 0 | 52.9399 | -73.5491 | 2021-11-27 04:22:45 | Quebec, Canada | |||
2021-10-23 | Canada | Quebec | 422241 | 11470 | 0 | 52.9399 | -73.5491 | 2021-10-24 04:21:22 | Quebec, Canada | |||
2021-12-13 | Canada | Quebec | 467608 | 11611 | 0 | 52.9399 | -73.5491 | 2021-12-14 04:22:38 | Quebec, Canada | |||
2022-10-24 | Canada | Quebec | 1221866 | 16957 | 0 | 52.9399 | -73.5491 | 2022-10-25 04:21:53 | Quebec, Canada | |||
2021-12-22 | Canada | Quebec | 501697 | 11652 | 0 | 52.9399 | -73.5491 | 2021-12-23 04:21:21 | Quebec, Canada | |||
2021-09-20 | Canada | Quebec | 403704 | 11326 | 0 | 52.9399 | -73.5491 | 2021-09-21 04:21:26 | Quebec, Canada | |||
2022-12-02 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
2022-11-02 | Canada | Quebec | 1229725 | 17065 | 0 | 52.9399 | -73.5491 | 2022-11-03 04:22:05 | Quebec, Canada | |||
2022-09-30 | Canada | Quebec | 1200754 | 16784 | 0 | 52.9399 | -73.5491 | 2022-10-01 04:23:01 | Quebec, Canada | |||
2022-12-11 | Canada | Quebec | 1264296 | 17462 | 0 | 52.9399 | -73.5491 | 2022-12-12 04:21:01 | Quebec, Canada | |||
2022-03-27 | Canada | Quebec | 957595 | 14324 | 0 | 52.9399 | -73.5491 | 2022-03-28 04:20:33 | Quebec, Canada | |||
2022-08-05 | Canada | Quebec | 1154061 | 16024 | 0 | 52.9399 | -73.5491 | 2022-08-06 04:20:56 | Quebec, Canada | |||
2022-07-24 | Canada | Quebec | 1137615 | 15872 | 0 | 52.9399 | -73.5491 | 2022-07-25 04:20:51 | Quebec, Canada | |||
2022-07-22 | Canada | Quebec | 1134683 | 15849 | 0 | 52.9399 | -73.5491 | 2022-07-23 04:20:53 | Quebec, Canada | |||
2021-11-24 | Canada | Quebec | 441343 | 11566 | 0 | 52.9399 | -73.5491 | 2021-11-25 04:22:33 | Quebec, Canada | |||
2022-10-29 | Canada | Quebec | 1226692 | 17038 | 0 | 52.9399 | -73.5491 | 2022-10-30 04:22:14 | Quebec, Canada | |||
2022-03-08 | Canada | Quebec | 930748 | 14120 | 0 | 52.9399 | -73.5491 | 2022-03-09 04:20:59 | Quebec, Canada | |||
2021-10-16 | Canada | Quebec | 419186 | 11440 | 0 | 52.9399 | -73.5491 | 2021-10-17 04:21:29 | Quebec, Canada | |||
2022-06-25 | Canada | Quebec | 1084376 | 15565 | 0 | 52.9399 | -73.5491 | 2022-06-26 04:21:02 | Quebec, Canada | |||
2022-02-28 | Canada | Quebec | 921875 | 13981 | 0 | 52.9399 | -73.5491 | 2022-03-01 04:21:09 | Quebec, Canada | |||
2022-06-14 | Canada | Quebec | 1074672 | 15496 | 0 | 52.9399 | -73.5491 | 2022-06-15 04:20:54 | Quebec, Canada | |||
2022-03-12 | Canada | Quebec | 935709 | 14168 | 0 | 52.9399 | -73.5491 | 2022-03-13 04:20:49 | Quebec, Canada | |||
2022-07-19 | Canada | Quebec | 1128222 | 15800 | 0 | 52.9399 | -73.5491 | 2022-07-20 04:20:59 | Quebec, Canada | |||
2022-09-09 | Canada | Quebec | 1184448 | 16471 | 0 | 52.9399 | -73.5491 | 2022-09-10 04:21:10 | Quebec, Canada | |||
2022-06-01 | Canada | Quebec | 1066903 | 15427 | 0 | 52.9399 | -73.5491 | 2022-06-02 05:20:39 | Quebec, Canada | |||
2022-02-01 | Canada | Quebec | 864619 | 13286 | 0 | 52.9399 | -73.5491 | 2022-02-02 04:21:09 | Quebec, Canada | |||
2021-10-04 | Canada | Quebec | 412364 | 11389 | 0 | 52.9399 | -73.5491 | 2021-10-05 04:21:27 | Quebec, Canada | |||
2022-08-16 | Canada | Quebec | 1165128 | 16165 | 0 | 52.9399 | -73.5491 | 2022-08-17 04:20:59 | Quebec, Canada | |||
2021-11-21 | Canada | Quebec | 439070 | 11558 | 0 | 52.9399 | -73.5491 | 2021-11-22 04:22:20 | Quebec, Canada | |||
2022-12-24 | Canada | Quebec | 1277720 | 17615 | 0 | 52.9399 | -73.5491 | 2022-12-25 04:21:04 | Quebec, Canada | |||
2022-11-04 | Canada | Quebec | 1231520 | 17086 | 0 | 52.9399 | -73.5491 | 2022-11-05 04:21:52 | Quebec, Canada | |||
2021-12-06 | Canada | Quebec | 455824 | 11589 | 0 | 52.9399 | -73.5491 | 2021-12-07 04:22:34 | Quebec, Canada | |||
2022-11-06 | Canada | Quebec | 1231520 | 17086 | 0 | 52.9399 | -73.5491 | 2022-11-07 04:21:26 | Quebec, Canada | |||
2022-02-23 | Canada | Quebec | 915760 | 13903 | 0 | 52.9399 | -73.5491 | 2022-02-24 04:21:14 | Quebec, Canada | |||
2022-07-28 | Canada | Quebec | 1144098 | 15929 | 0 | 52.9399 | -73.5491 | 2022-07-29 04:20:45 | Quebec, Canada | |||
2022-08-07 | Canada | Quebec | 1155884 | 16040 | 0 | 52.9399 | -73.5491 | 2022-08-08 04:21:08 | Quebec, Canada | |||
2022-12-28 | Canada | Quebec | 1281152 | 17644 | 0 | 52.9399 | -73.5491 | 2022-12-29 04:21:01 | Quebec, Canada | |||
2021-12-09 | Canada | Quebec | 460232 | 11597 | 0 | 52.9399 | -73.5491 | 2021-12-10 04:22:28 | Quebec, Canada | |||
2022-08-09 | Canada | Quebec | 1157876 | 16069 | 0 | 52.9399 | -73.5491 | 2022-08-10 04:20:57 | Quebec, Canada | |||
2022-08-03 | Canada | Quebec | 1151659 | 15992 | 0 | 52.9399 | -73.5491 | 2022-08-04 04:20:58 | Quebec, Canada | |||
2022-05-21 | Canada | Quebec | 1061253 | 15349 | 0 | 52.9399 | -73.5491 | 2022-05-22 04:20:52 | Quebec, Canada | |||
2022-01-11 | Canada | Quebec | 749865 | 12028 | 0 | 52.9399 | -73.5491 | 2022-01-12 04:21:44 | Quebec, Canada | |||
2021-08-06 | Canada | Quebec | 378680 | 11241 | 0 | 52.9399 | -73.5491 | 2021-08-07 04:21:30 | Quebec, Canada | |||
2022-01-23 | Canada | Quebec | 830488 | 12766 | 0 | 52.9399 | -73.5491 | 2022-01-24 04:21:12 | Quebec, Canada | |||
2021-12-01 | Canada | Quebec | 449366 | 11581 | 0 | 52.9399 | -73.5491 | 2021-12-02 04:22:37 | Quebec, Canada | |||
2022-12-12 | Canada | Quebec | 1265044 | 17463 | 0 | 52.9399 | -73.5491 | 2022-12-13 04:21:01 | Quebec, Canada | |||
2022-04-29 | Canada | Quebec | 1041072 | 14977 | 0 | 52.9399 | -73.5491 | 2022-04-30 04:21:05 | Quebec, Canada | |||
2022-08-18 | Canada | Quebec | 1167547 | 16195 | 0 | 52.9399 | -73.5491 | 2022-08-19 04:20:54 | Quebec, Canada | |||
2022-05-20 | Canada | Quebec | 1060654 | 15338 | 0 | 52.9399 | -73.5491 | 2022-05-21 04:20:58 | Quebec, Canada | |||
2020-03-18 | Canada | Quebec | 169 | 3 | 0 | 52.9399 | -73.5491 | 2020-03-18T17:53:03 | ||||
2022-05-18 | Canada | Quebec | 1059416 | 15312 | 0 | 52.9399 | -73.5491 | 2022-05-19 04:20:54 | Quebec, Canada | |||
2022-07-06 | Canada | Quebec | 1096171 | 15630 | 0 | 52.9399 | -73.5491 | 2022-07-07 04:20:55 | Quebec, Canada | |||
2022-07-11 | Canada | Quebec | 1104909 | 15674 | 0 | 52.9399 | -73.5491 | 2022-07-12 04:20:51 | Quebec, Canada | |||
2022-01-08 | Canada | Quebec | 712357 | 11873 | 0 | 52.9399 | -73.5491 | 2022-01-09 04:21:46 | Quebec, Canada | |||
2022-04-14 | Canada | Quebec | 1010193 | 14618 | 0 | 52.9399 | -73.5491 | 2022-04-15 04:20:57 | Quebec, Canada | |||
2022-01-24 | Canada | Quebec | 838436 | 12851 | 0 | 52.9399 | -73.5491 | 2022-01-25 04:21:05 | Quebec, Canada | |||
2021-11-28 | Canada | Quebec | 446630 | 11574 | 0 | 52.9399 | -73.5491 | 2021-11-29 04:22:30 | Quebec, Canada | |||
2021-09-27 | Canada | Quebec | 408462 | 11356 | 0 | 52.9399 | -73.5491 | 2021-09-28 04:21:28 | Quebec, Canada | |||
2022-11-28 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-29 04:21:05 | Quebec, Canada | |||
2022-08-23 | Canada | Quebec | 1170654 | 16223 | 0 | 52.9399 | -73.5491 | 2022-08-24 04:20:46 | Quebec, Canada | |||
2021-12-20 | Canada | Quebec | 490293 | 11642 | 0 | 52.9399 | -73.5491 | 2021-12-21 03:21:27 | Quebec, Canada | |||
2021-12-18 | Canada | Quebec | 481876 | 11636 | 0 | 52.9399 | -73.5491 | 2021-12-19 04:21:11 | Quebec, Canada | |||
2021-09-09 | Canada | Quebec | 395155 | 11297 | 0 | 52.9399 | -73.5491 | 2021-09-10 04:21:20 | Quebec, Canada | |||
2021-10-03 | Canada | Quebec | 411962 | 11383 | 0 | 52.9399 | -73.5491 | 2021-10-04 04:21:31 | Quebec, Canada | |||
2022-01-05 | Canada | Quebec | 665821 | 11820 | 0 | 52.9399 | -73.5491 | 2022-01-06 04:22:09 | Quebec, Canada | |||
2022-01-04 | Canada | Quebec | 651327 | 11760 | 0 | 52.9399 | -73.5491 | 2022-01-05 04:21:59 | Quebec, Canada | |||
2022-02-05 | Canada | Quebec | 878382 | 13453 | 0 | 52.9399 | -73.5491 | 2022-02-06 04:21:00 | Quebec, Canada | |||
2022-02-17 | Canada | Quebec | 906627 | 13812 | 0 | 52.9399 | -73.5491 | 2022-02-18 04:21:04 | Quebec, Canada | |||
2022-05-27 | Canada | Quebec | 1064328 | 15400 | 0 | 52.9399 | -73.5491 | 2022-05-28 04:21:07 | Quebec, Canada | |||
2022-01-26 | Canada | Quebec | 841413 | 12936 | 0 | 52.9399 | -73.5491 | 2022-01-27 04:21:19 | Quebec, Canada | |||
2021-11-14 | Canada | Quebec | 434339 | 11545 | 0 | 52.9399 | -73.5491 | 2021-11-15 04:21:36 | Quebec, Canada | |||
2022-04-26 | Canada | Quebec | 1035592 | 14906 | 0 | 52.9399 | -73.5491 | 2022-04-27 04:20:52 | Quebec, Canada | |||
2021-09-28 | Canada | Quebec | 408931 | 11362 | 0 | 52.9399 | -73.5491 | 2021-09-29 04:21:45 | Quebec, Canada | |||
2021-08-11 | Canada | Quebec | 380038 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-12 04:21:25 | Quebec, Canada | |||
2022-08-10 | Canada | Quebec | 1159087 | 16088 | 0 | 52.9399 | -73.5491 | 2022-08-11 04:20:49 | Quebec, Canada | |||
2021-11-27 | Canada | Quebec | 445755 | 11574 | 0 | 52.9399 | -73.5491 | 2021-11-28 04:22:43 | Quebec, Canada | |||
2022-02-08 | Canada | Quebec | 885694 | 13551 | 0 | 52.9399 | -73.5491 | 2022-02-09 04:21:04 | Quebec, Canada | |||
2022-10-28 | Canada | Quebec | 1225874 | 17026 | 0 | 52.9399 | -73.5491 | 2022-10-29 04:21:13 | Quebec, Canada | |||
2022-09-21 | Canada | Quebec | 1193035 | 16697 | 0 | 52.9399 | -73.5491 | 2022-09-22 04:22:56 | Quebec, Canada | |||
2021-09-15 | Canada | Quebec | 399843 | 11313 | 0 | 52.9399 | -73.5491 | 2021-09-16 04:22:19 | Quebec, Canada | |||
2021-09-13 | Canada | Quebec | 398425 | 11305 | 0 | 52.9399 | -73.5491 | 2021-09-14 04:21:41 | Quebec, Canada | |||
2022-01-07 | Canada | Quebec | 696181 | 11873 | 0 | 52.9399 | -73.5491 | 2022-01-08 04:21:53 | Quebec, Canada | |||
2022-09-02 | Canada | Quebec | 1179550 | 16409 | 0 | 52.9399 | -73.5491 | 2022-09-03 04:21:04 | Quebec, Canada | |||
2022-05-06 | Canada | Quebec | 1050121 | 15106 | 0 | 52.9399 | -73.5491 | 2022-05-07 04:21:09 | Quebec, Canada | |||
2022-08-02 | Canada | Quebec | 1150154 | 15971 | 0 | 52.9399 | -73.5491 | 2022-08-03 04:20:59 | Quebec, Canada | |||
2022-07-08 | Canada | Quebec | 1101362 | 15663 | 0 | 52.9399 | -73.5491 | 2022-07-09 04:20:59 | Quebec, Canada | |||
2022-06-08 | Canada | Quebec | 1070885 | 15467 | 0 | 52.9399 | -73.5491 | 2022-06-09 04:20:54 | Quebec, Canada | |||
2021-12-28 | Canada | Quebec | 559269 | 11692 | 0 | 52.9399 | -73.5491 | 2021-12-29 03:21:43 | Quebec, Canada | |||
2022-03-28 | Canada | Quebec | 959209 | 14325 | 0 | 52.9399 | -73.5491 | 2022-03-29 04:20:46 | Quebec, Canada | |||
2020-03-15 | Canada | Quebec | 68 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-15T01:53:02 | ||||
2022-02-10 | Canada | Quebec | 891949 | 13617 | 0 | 52.9399 | -73.5491 | 2022-02-11 04:21:09 | Quebec, Canada | |||
2022-03-24 | Canada | Quebec | 951292 | 14288 | 0 | 52.9399 | -73.5491 | 2022-03-25 04:20:46 | Quebec, Canada | |||
2022-01-17 | Canada | Quebec | 801152 | 12364 | 0 | 52.9399 | -73.5491 | 2022-01-18 04:21:04 | Quebec, Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;