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 recovered
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
657822 | 657822 | 2020-03-09 | Canada | Quebec | 15 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-09T08:43:03 | ||||
658074 | 658074 | 2022-05-13 | Canada | Quebec | 1056174 | 15256 | 0 | 52.9399 | -73.5491 | 2022-05-14 04:20:48 | Quebec, Canada | |||
670059 | 670059 | 2022-07-21 | Canada | Quebec | 1132764 | 15834 | 0 | 52.9399 | -73.5491 | 2022-07-22 04:21:15 | Quebec, Canada | |||
674075 | 674075 | 2022-07-30 | Canada | Quebec | 1146894 | 15957 | 0 | 52.9399 | -73.5491 | 2022-07-31 04:21:02 | Quebec, Canada | |||
682100 | 682100 | 2021-10-24 | Canada | Quebec | 422670 | 11472 | 0 | 52.9399 | -73.5491 | 2021-10-25 04:22:31 | Quebec, Canada | |||
686116 | 686116 | 2021-11-13 | Canada | Quebec | 433705 | 11541 | 0 | 52.9399 | -73.5491 | 2021-11-14 04:21:31 | Quebec, Canada | |||
690133 | 690133 | 2022-12-23 | Canada | Quebec | 1277720 | 17615 | 0 | 52.9399 | -73.5491 | 2022-12-24 04:21:02 | Quebec, Canada | |||
694149 | 694149 | 2022-03-17 | Canada | Quebec | 939648 | 14232 | 0 | 52.9399 | -73.5491 | 2022-03-18 04:20:55 | Quebec, Canada | |||
698164 | 698164 | 2021-11-04 | Canada | Quebec | 428059 | 11510 | 0 | 52.9399 | -73.5491 | 2021-11-05 04:21:54 | Quebec, Canada | |||
706194 | 706194 | 2021-09-29 | Canada | Quebec | 409525 | 11369 | 0 | 52.9399 | -73.5491 | 2021-09-30 04:21:20 | Quebec, Canada | |||
710210 | 710210 | 2022-11-01 | Canada | Quebec | 1228697 | 17059 | 0 | 52.9399 | -73.5491 | 2022-11-02 04:22:09 | Quebec, Canada | |||
714225 | 714225 | 2021-11-12 | Canada | Quebec | 432990 | 11535 | 0 | 52.9399 | -73.5491 | 2021-11-13 04:21:38 | Quebec, Canada | |||
718242 | 718242 | 2022-12-04 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
722257 | 722257 | 2021-11-20 | Canada | Quebec | 438363 | 11555 | 0 | 52.9399 | -73.5491 | 2021-11-21 04:22:13 | Quebec, Canada | |||
730287 | 730287 | 2021-12-27 | Canada | Quebec | 546436 | 11677 | 0 | 52.9399 | -73.5491 | 2021-12-28 04:21:47 | Quebec, Canada | |||
746104 | 746104 | 2022-04-23 | Canada | Quebec | 1030942 | 14846 | 0 | 52.9399 | -73.5491 | 2022-04-24 04:20:56 | Quebec, Canada | |||
758087 | 758087 | 2021-11-26 | Canada | Quebec | 444584 | 11571 | 0 | 52.9399 | -73.5491 | 2021-11-27 04:22:45 | Quebec, Canada | |||
770108 | 770108 | 2021-10-23 | Canada | Quebec | 422241 | 11470 | 0 | 52.9399 | -73.5491 | 2021-10-24 04:21:22 | Quebec, Canada | |||
782150 | 782150 | 2021-12-13 | Canada | Quebec | 467608 | 11611 | 0 | 52.9399 | -73.5491 | 2021-12-14 04:22:38 | Quebec, Canada | |||
794174 | 794174 | 2022-10-24 | Canada | Quebec | 1221866 | 16957 | 0 | 52.9399 | -73.5491 | 2022-10-25 04:21:53 | Quebec, Canada | |||
798189 | 798189 | 2021-12-22 | Canada | Quebec | 501697 | 11652 | 0 | 52.9399 | -73.5491 | 2021-12-23 04:21:21 | Quebec, Canada | |||
809028 | 809028 | 2020-03-27 | Canada | Quebec | 2591 | 30 | 0 | 2561 | 52.9399 | -73.5491 | 2020-03-27 23:27:32 | Quebec, Canada | ||
809351 | 809351 | 2021-09-20 | Canada | Quebec | 403704 | 11326 | 0 | 52.9399 | -73.5491 | 2021-09-21 04:21:26 | Quebec, Canada | |||
833387 | 833387 | 2022-12-02 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
849359 | 849359 | 2022-11-02 | Canada | Quebec | 1229725 | 17065 | 0 | 52.9399 | -73.5491 | 2022-11-03 04:22:05 | Quebec, Canada | |||
853375 | 853375 | 2022-09-30 | Canada | Quebec | 1200754 | 16784 | 0 | 52.9399 | -73.5491 | 2022-10-01 04:23:01 | Quebec, Canada | |||
860121 | 860121 | 2020-04-15 | Canada | Quebec | 16874 | 994 | 0 | 15880 | 52.9399 | -73.5491 | 2020-04-15 23:04:09 | Quebec, Canada | ||
868559 | 868559 | 2022-12-11 | Canada | Quebec | 1264296 | 17462 | 0 | 52.9399 | -73.5491 | 2022-12-12 04:21:01 | Quebec, Canada | |||
876024 | 876024 | 2022-03-27 | Canada | Quebec | 957595 | 14324 | 0 | 52.9399 | -73.5491 | 2022-03-28 04:20:33 | Quebec, Canada | |||
880040 | 880040 | 2022-08-05 | Canada | Quebec | 1154061 | 16024 | 0 | 52.9399 | -73.5491 | 2022-08-06 04:20:56 | Quebec, Canada | |||
895907 | 895907 | 2022-07-24 | Canada | Quebec | 1137615 | 15872 | 0 | 52.9399 | -73.5491 | 2022-07-25 04:20:51 | Quebec, Canada | |||
899923 | 899923 | 2022-07-22 | Canada | Quebec | 1134683 | 15849 | 0 | 52.9399 | -73.5491 | 2022-07-23 04:20:53 | Quebec, Canada | |||
903938 | 903938 | 2021-11-24 | Canada | Quebec | 441343 | 11566 | 0 | 52.9399 | -73.5491 | 2021-11-25 04:22:33 | Quebec, Canada | |||
911968 | 911968 | 2022-10-29 | Canada | Quebec | 1226692 | 17038 | 0 | 52.9399 | -73.5491 | 2022-10-30 04:22:14 | Quebec, Canada | |||
919121 | 919121 | 2020-03-26 | Canada | Quebec | 2140 | 27 | 0 | 2113 | 52.9399 | -73.5491 | 2020-03-26 23:53:11 | Quebec, Canada | ||
919444 | 919444 | 2022-03-08 | Canada | Quebec | 930748 | 14120 | 0 | 52.9399 | -73.5491 | 2022-03-09 04:20:59 | Quebec, Canada | |||
934227 | 934227 | 2020-04-16 | Canada | Quebec | 17838 | 1089 | 0 | 16749 | 52.9399 | -73.5491 | 2020-04-16 23:38:03 | Quebec, Canada | ||
934560 | 934560 | 2021-10-16 | Canada | Quebec | 419186 | 11440 | 0 | 52.9399 | -73.5491 | 2021-10-17 04:21:29 | Quebec, Canada | |||
938577 | 938577 | 2022-06-25 | Canada | Quebec | 1084376 | 15565 | 0 | 52.9399 | -73.5491 | 2022-06-26 04:21:02 | Quebec, Canada | |||
942593 | 942593 | 2022-02-28 | Canada | Quebec | 921875 | 13981 | 0 | 52.9399 | -73.5491 | 2022-03-01 04:21:09 | Quebec, Canada | |||
946609 | 946609 | 2022-06-14 | Canada | Quebec | 1074672 | 15496 | 0 | 52.9399 | -73.5491 | 2022-06-15 04:20:54 | Quebec, Canada | |||
950625 | 950625 | 2022-03-12 | Canada | Quebec | 935709 | 14168 | 0 | 52.9399 | -73.5491 | 2022-03-13 04:20:49 | Quebec, Canada | |||
958655 | 958655 | 2022-07-19 | Canada | Quebec | 1128222 | 15800 | 0 | 52.9399 | -73.5491 | 2022-07-20 04:20:59 | Quebec, Canada | |||
962671 | 962671 | 2022-09-09 | Canada | Quebec | 1184448 | 16471 | 0 | 52.9399 | -73.5491 | 2022-09-10 04:21:10 | Quebec, Canada | |||
970679 | 970679 | 2022-06-01 | Canada | Quebec | 1066903 | 15427 | 0 | 52.9399 | -73.5491 | 2022-06-02 05:20:39 | Quebec, Canada | |||
978708 | 978708 | 2022-02-01 | Canada | Quebec | 864619 | 13286 | 0 | 52.9399 | -73.5491 | 2022-02-02 04:21:09 | Quebec, Canada | |||
986738 | 986738 | 2021-10-04 | Canada | Quebec | 412364 | 11389 | 0 | 52.9399 | -73.5491 | 2021-10-05 04:21:27 | Quebec, Canada | |||
990754 | 990754 | 2022-08-16 | Canada | Quebec | 1165128 | 16165 | 0 | 52.9399 | -73.5491 | 2022-08-17 04:20:59 | Quebec, Canada | |||
1014093 | 1014093 | 2021-11-21 | Canada | Quebec | 439070 | 11558 | 0 | 52.9399 | -73.5491 | 2021-11-22 04:22:20 | Quebec, Canada | |||
1018110 | 1018110 | 2022-12-24 | Canada | Quebec | 1277720 | 17615 | 0 | 52.9399 | -73.5491 | 2022-12-25 04:21:04 | Quebec, Canada | |||
1022126 | 1022126 | 2022-11-04 | Canada | Quebec | 1231520 | 17086 | 0 | 52.9399 | -73.5491 | 2022-11-05 04:21:52 | Quebec, Canada | |||
1030135 | 1030135 | 2021-12-06 | Canada | Quebec | 455824 | 11589 | 0 | 52.9399 | -73.5491 | 2021-12-07 04:22:34 | Quebec, Canada | |||
1049598 | 1049598 | 2022-11-06 | Canada | Quebec | 1231520 | 17086 | 0 | 52.9399 | -73.5491 | 2022-11-07 04:21:26 | Quebec, Canada | |||
1057609 | 1057609 | 2022-02-23 | Canada | Quebec | 915760 | 13903 | 0 | 52.9399 | -73.5491 | 2022-02-24 04:21:14 | Quebec, Canada | |||
1065637 | 1065637 | 2022-07-28 | Canada | Quebec | 1144098 | 15929 | 0 | 52.9399 | -73.5491 | 2022-07-29 04:20:45 | Quebec, Canada | |||
1069653 | 1069653 | 2022-08-07 | Canada | Quebec | 1155884 | 16040 | 0 | 52.9399 | -73.5491 | 2022-08-08 04:21:08 | Quebec, Canada | |||
1073669 | 1073669 | 2022-12-28 | Canada | Quebec | 1281152 | 17644 | 0 | 52.9399 | -73.5491 | 2022-12-29 04:21:01 | Quebec, Canada | |||
1077684 | 1077684 | 2021-12-09 | Canada | Quebec | 460232 | 11597 | 0 | 52.9399 | -73.5491 | 2021-12-10 04:22:28 | Quebec, Canada | |||
1085835 | 1085835 | 2022-08-09 | Canada | Quebec | 1157876 | 16069 | 0 | 52.9399 | -73.5491 | 2022-08-10 04:20:57 | Quebec, Canada | |||
1097878 | 1097878 | 2022-08-03 | Canada | Quebec | 1151659 | 15992 | 0 | 52.9399 | -73.5491 | 2022-08-04 04:20:58 | Quebec, Canada | |||
1109334 | 1109334 | 2022-05-21 | Canada | Quebec | 1061253 | 15349 | 0 | 52.9399 | -73.5491 | 2022-05-22 04:20:52 | Quebec, Canada | |||
1113349 | 1113349 | 2022-01-11 | Canada | Quebec | 749865 | 12028 | 0 | 52.9399 | -73.5491 | 2022-01-12 04:21:44 | Quebec, Canada | |||
1117365 | 1117365 | 2021-08-06 | Canada | Quebec | 378680 | 11241 | 0 | 52.9399 | -73.5491 | 2021-08-07 04:21:30 | Quebec, Canada | |||
1132523 | 1132523 | 2020-03-25 | Canada | Quebec | 1774 | 18 | 0 | 1756 | 52.9399 | -73.5491 | 2020-03-25 23:37:36 | Quebec, Canada | ||
1140672 | 1140672 | 2022-01-23 | Canada | Quebec | 830488 | 12766 | 0 | 52.9399 | -73.5491 | 2022-01-24 04:21:12 | Quebec, Canada | |||
1144688 | 1144688 | 2021-12-01 | Canada | Quebec | 449366 | 11581 | 0 | 52.9399 | -73.5491 | 2021-12-02 04:22:37 | Quebec, Canada | |||
1148705 | 1148705 | 2022-12-12 | Canada | Quebec | 1265044 | 17463 | 0 | 52.9399 | -73.5491 | 2022-12-13 04:21:01 | Quebec, Canada | |||
1156912 | 1156912 | 2022-04-29 | Canada | Quebec | 1041072 | 14977 | 0 | 52.9399 | -73.5491 | 2022-04-30 04:21:05 | Quebec, Canada | |||
1160928 | 1160928 | 2022-08-18 | Canada | Quebec | 1167547 | 16195 | 0 | 52.9399 | -73.5491 | 2022-08-19 04:20:54 | Quebec, Canada | |||
1168958 | 1168958 | 2022-05-20 | Canada | Quebec | 1060654 | 15338 | 0 | 52.9399 | -73.5491 | 2022-05-21 04:20:58 | Quebec, Canada | |||
1176971 | 1176971 | 2020-03-18 | Canada | Quebec | 169 | 3 | 0 | 52.9399 | -73.5491 | 2020-03-18T17:53:03 | ||||
1184169 | 1184169 | 2020-05-01 | Canada | Quebec | 30862 | 2866 | 0 | 27996 | 52.9399 | -73.5491 | 2020-05-02 02:32:27 | Quebec, Canada | ||
1184505 | 1184505 | 2022-05-18 | Canada | Quebec | 1059416 | 15312 | 0 | 52.9399 | -73.5491 | 2022-05-19 04:20:54 | Quebec, Canada | |||
1199233 | 1199233 | 2020-04-22 | Canada | Quebec | 22943 | 1735 | 0 | 21208 | 52.9399 | -73.5491 | 2020-04-22 23:38:42 | Quebec, Canada | ||
1199567 | 1199567 | 2022-07-06 | Canada | Quebec | 1096171 | 15630 | 0 | 52.9399 | -73.5491 | 2022-07-07 04:20:55 | Quebec, Canada | |||
1211312 | 1211312 | 2022-07-11 | Canada | Quebec | 1104909 | 15674 | 0 | 52.9399 | -73.5491 | 2022-07-12 04:20:51 | Quebec, Canada | |||
1215327 | 1215327 | 2022-01-08 | Canada | Quebec | 712357 | 11873 | 0 | 52.9399 | -73.5491 | 2022-01-09 04:21:46 | Quebec, Canada | |||
1223358 | 1223358 | 2022-04-14 | Canada | Quebec | 1010193 | 14618 | 0 | 52.9399 | -73.5491 | 2022-04-15 04:20:57 | Quebec, Canada | |||
1227373 | 1227373 | 2022-01-24 | Canada | Quebec | 838436 | 12851 | 0 | 52.9399 | -73.5491 | 2022-01-25 04:21:05 | Quebec, Canada | |||
1231389 | 1231389 | 2021-11-28 | Canada | Quebec | 446630 | 11574 | 0 | 52.9399 | -73.5491 | 2021-11-29 04:22:30 | Quebec, Canada | |||
1235405 | 1235405 | 2021-09-27 | Canada | Quebec | 408462 | 11356 | 0 | 52.9399 | -73.5491 | 2021-09-28 04:21:28 | Quebec, Canada | |||
1239421 | 1239421 | 2022-11-28 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-29 04:21:05 | Quebec, Canada | |||
1250182 | 1250182 | 2020-04-10 | Canada | Quebec | 12395 | 551 | 0 | 11844 | 52.9399 | -73.5491 | 2020-04-10 23:01:26 | Quebec, Canada | ||
1250517 | 1250517 | 2022-08-23 | Canada | Quebec | 1170654 | 16223 | 0 | 52.9399 | -73.5491 | 2022-08-24 04:20:46 | Quebec, Canada | |||
1254532 | 1254532 | 2021-12-20 | Canada | Quebec | 490293 | 11642 | 0 | 52.9399 | -73.5491 | 2021-12-21 03:21:27 | Quebec, Canada | |||
1258548 | 1258548 | 2021-12-18 | Canada | Quebec | 481876 | 11636 | 0 | 52.9399 | -73.5491 | 2021-12-19 04:21:11 | Quebec, Canada | |||
1262564 | 1262564 | 2021-09-09 | Canada | Quebec | 395155 | 11297 | 0 | 52.9399 | -73.5491 | 2021-09-10 04:21:20 | Quebec, Canada | |||
1274048 | 1274048 | 2021-10-03 | Canada | Quebec | 411962 | 11383 | 0 | 52.9399 | -73.5491 | 2021-10-04 04:21:31 | Quebec, Canada | |||
1281749 | 1281749 | 2022-01-05 | Canada | Quebec | 665821 | 11820 | 0 | 52.9399 | -73.5491 | 2022-01-06 04:22:09 | Quebec, Canada | |||
1285765 | 1285765 | 2022-01-04 | Canada | Quebec | 651327 | 11760 | 0 | 52.9399 | -73.5491 | 2022-01-05 04:21:59 | Quebec, Canada | |||
1293795 | 1293795 | 2022-02-05 | Canada | Quebec | 878382 | 13453 | 0 | 52.9399 | -73.5491 | 2022-02-06 04:21:00 | Quebec, Canada | |||
1297812 | 1297812 | 2022-02-17 | Canada | Quebec | 906627 | 13812 | 0 | 52.9399 | -73.5491 | 2022-02-18 04:21:04 | Quebec, Canada | |||
1313959 | 1313959 | 2022-05-27 | Canada | Quebec | 1064328 | 15400 | 0 | 52.9399 | -73.5491 | 2022-05-28 04:21:07 | Quebec, Canada | |||
1317974 | 1317974 | 2022-01-26 | Canada | Quebec | 841413 | 12936 | 0 | 52.9399 | -73.5491 | 2022-01-27 04:21:19 | Quebec, Canada | |||
1321990 | 1321990 | 2021-11-14 | Canada | Quebec | 434339 | 11545 | 0 | 52.9399 | -73.5491 | 2021-11-15 04:21:36 | Quebec, Canada | |||
1326007 | 1326007 | 2022-04-26 | Canada | Quebec | 1035592 | 14906 | 0 | 52.9399 | -73.5491 | 2022-04-27 04:20:52 | Quebec, Canada | |||
1334036 | 1334036 | 2021-09-28 | Canada | Quebec | 408931 | 11362 | 0 | 52.9399 | -73.5491 | 2021-09-29 04:21:45 | Quebec, Canada | |||
1342065 | 1342065 | 2021-08-11 | Canada | Quebec | 380038 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-12 04:21:25 | Quebec, Canada | |||
1346080 | 1346080 | 2022-08-10 | Canada | Quebec | 1159087 | 16088 | 0 | 52.9399 | -73.5491 | 2022-08-11 04:20:49 | Quebec, Canada | |||
1358096 | 1358096 | 2021-11-27 | Canada | Quebec | 445755 | 11574 | 0 | 52.9399 | -73.5491 | 2021-11-28 04:22:43 | 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]);