⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

459 rows where country_or_region = "Canada" and province_or_state = "Manitoba" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Manitoba · 459

country_or_region

  • Canada · 459
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
222694 2021-06-14 Canada Manitoba     54481 1102 50268 3111 53.7609 -98.8139 2021-06-15 04:22:22 Manitoba, Canada
214726 2021-06-13 Canada Manitoba     54357 1100 49952 3305 53.7609 -98.8139 2021-06-14 04:22:46 Manitoba, Canada
281296 2021-06-12 Canada Manitoba     54163 1093 49633 3437 53.7609 -98.8139 2021-06-13 04:22:44 Manitoba, Canada
1633395 2021-06-11 Canada Manitoba     53872 1089 49293 3490 53.7609 -98.8139 2021-06-12 04:22:22 Manitoba, Canada
662681 2021-06-10 Canada Manitoba     53650 1087 48963 3600 53.7609 -98.8139 2021-06-11 04:23:20 Manitoba, Canada
881785 2021-06-09 Canada Manitoba     53403 1081 48536 3786 53.7609 -98.8139 2021-06-10 04:23:17 Manitoba, Canada
1709784 2021-06-08 Canada Manitoba     53153 1079 48238 3836 53.7609 -98.8139 2021-06-09 04:23:31 Manitoba, Canada
1465628 2021-06-07 Canada Manitoba     52919 1077 47880 3962 53.7609 -98.8139 2021-06-08 04:22:35 Manitoba, Canada
993395 2021-06-06 Canada Manitoba     52751 1075 47607 4069 53.7609 -98.8139 2021-06-07 04:22:51 Manitoba, Canada
158185 2021-06-05 Canada Manitoba     52531 1072 47345 4114 53.7609 -98.8139 2021-06-06 04:24:03 Manitoba, Canada
1516170 2021-06-04 Canada Manitoba     52261 1071 46999 4191 53.7609 -98.8139 2021-06-05 04:23:03 Manitoba, Canada
1140481 2021-06-03 Canada Manitoba     51935 1067 46689 4179 53.7609 -98.8139 2021-06-04 04:23:37 Manitoba, Canada
426925 2021-06-02 Canada Manitoba     51580 1062 46251 4267 53.7609 -98.8139 2021-06-03 04:23:32 Manitoba, Canada
539432 2021-06-01 Canada Manitoba     51316 1056 45927 4333 53.7609 -98.8139 2021-06-02 04:24:34 Manitoba, Canada
786617 2021-05-31 Canada Manitoba     51090 1053 45533 4504 53.7609 -98.8139 2021-06-01 04:23:09 Manitoba, Canada
1330015 2021-05-30 Canada Manitoba     50790 1052 45169 4569 53.7609 -98.8139 2021-05-31 03:08:59 Manitoba, Canada
67224 2021-05-29 Canada Manitoba     50499 1045 44819 4635 53.7609 -98.8139 2021-05-30 04:20:55 Manitoba, Canada
195410 2021-05-28 Canada Manitoba     50144 1042 44426 4676 53.7609 -98.8139 2021-05-29 04:20:41 Manitoba, Canada
938669 2021-05-27 Canada Manitoba     49651 1042 43970 4639 53.7609 -98.8139 2021-05-28 04:20:36 Manitoba, Canada
1226344 2021-05-26 Canada Manitoba     49356 1035 43529 4792 53.7609 -98.8139 2021-05-27 04:20:59 Manitoba, Canada
1337983 2021-05-25 Canada Manitoba     49046 1035 43066 4945 53.7609 -98.8139 2021-05-26 04:20:35 Manitoba, Canada
202815 2021-05-24 Canada Manitoba     48787 1033 42693 5061 53.7609 -98.8139 2021-05-25 04:21:08 Manitoba, Canada
98979 2021-05-23 Canada Manitoba     48436 1029 42335 5072 53.7609 -98.8139 2021-05-24 04:20:53 Manitoba, Canada
523498 2021-05-22 Canada Manitoba     47977 1028 41965 4984 53.7609 -98.8139 2021-05-23 04:20:51 Manitoba, Canada
859193 2021-05-21 Canada Manitoba     47504 1022 41627 4855 53.7609 -98.8139 2021-05-22 04:20:45 Manitoba, Canada
720616 2021-05-20 Canada Manitoba     46916 1019 41238 4659 53.7609 -98.8139 2021-05-21 04:20:43 Manitoba, Canada
407747 2021-05-19 Canada Manitoba     46314 1016 40748 4550 53.7609 -98.8139 2021-05-20 04:21:05 Manitoba, Canada
782633 2021-05-18 Canada Manitoba     45913 1012 40358 4543 53.7609 -98.8139 2021-05-19 04:20:42 Manitoba, Canada
1422775 2021-05-17 Canada Manitoba     45579 1011 40000 4568 53.7609 -98.8139 2021-05-18 04:20:33 Manitoba, Canada
739961 2021-05-16 Canada Manitoba     45149 1010 39699 4440 53.7609 -98.8139 2021-05-17 04:20:34 Manitoba, Canada
1116494 2021-05-15 Canada Manitoba     44617 1006 39392 4219 53.7609 -98.8139 2021-05-16 04:20:49 Manitoba, Canada
1587003 2021-05-14 Canada Manitoba     44189 1002 39024 4163 53.7609 -98.8139 2021-05-15 04:20:58 Manitoba, Canada
1674920 2021-05-13 Canada Manitoba     43700 1002 38652 4046 53.7609 -98.8139 2021-05-14 04:20:41 Manitoba, Canada
802547 2021-05-12 Canada Manitoba     43143 1000 38203 3940 53.7609 -98.8139 2021-05-13 04:20:51 Manitoba, Canada
1180935 2021-05-11 Canada Manitoba     42779 997 37945 3837 53.7609 -98.8139 2021-05-12 04:21:29 Manitoba, Canada
324725 2021-05-10 Canada Manitoba     42451 997 37683 3771 53.7609 -98.8139 2021-05-11 04:20:41 Manitoba, Canada
603872 2021-05-09 Canada Manitoba     41953 993 37461 3499 53.7609 -98.8139 2021-05-10 04:20:38 Manitoba, Canada
985619 2021-05-08 Canada Manitoba     41425 990 37198 3237 53.7609 -98.8139 2021-05-09 04:20:35 Manitoba, Canada
434101 2021-05-07 Canada Manitoba     40940 987 36964 2989 53.7609 -98.8139 2021-05-08 04:21:04 Manitoba, Canada
900882 2021-05-06 Canada Manitoba     40442 986 36724 2732 53.7609 -98.8139 2021-05-07 04:20:40 Manitoba, Canada
71208 2021-05-05 Canada Manitoba     40085 982 36323 2780 53.7609 -98.8139 2021-05-06 04:20:38 Manitoba, Canada
790601 2021-05-04 Canada Manitoba     39814 980 36142 2692 53.7609 -98.8139 2021-05-05 04:20:43 Manitoba, Canada
1613131 2021-05-03 Canada Manitoba     39524 979 35952 2593 53.7609 -98.8139 2021-05-04 04:20:34 Manitoba, Canada
885769 2021-05-02 Canada Manitoba     39274 978 35756 2540 53.7609 -98.8139 2021-05-03 04:20:39 Manitoba, Canada
511474 2021-05-01 Canada Manitoba     38995 976 35551 2468 53.7609 -98.8139 2021-05-02 04:20:48 Manitoba, Canada
14410 2021-04-30 Canada Manitoba     38729 974 35380 2375 53.7609 -98.8139 2021-05-01 04:20:47 Manitoba, Canada
1124514 2021-04-29 Canada Manitoba     38439 973 35203 2263 53.7609 -98.8139 2021-04-30 04:21:03 Manitoba, Canada
461811 2021-04-28 Canada Manitoba     38211 971 35034 2206 53.7609 -98.8139 2021-04-29 04:20:55 Manitoba, Canada
1314517 2021-04-27 Canada Manitoba     38025 968 34884 2173 53.7609 -98.8139 2021-04-28 04:20:32 Manitoba, Canada
1548944 2021-04-26 Canada Manitoba     37808 968 34747 2093 53.7609 -98.8139 2021-04-27 04:20:52 Manitoba, Canada
1629411 2021-04-25 Canada Manitoba     37598 967 34607 2024 53.7609 -98.8139 2021-04-26 04:21:04 Manitoba, Canada
353551 2021-04-24 Canada Manitoba     37339 967 34481 1891 53.7609 -98.8139 2021-04-25 04:20:32 Manitoba, Canada
724600 2021-04-23 Canada Manitoba     37069 964 34366 1739 53.7609 -98.8139 2021-04-24 04:20:38 Manitoba, Canada
1469612 2021-04-22 Canada Manitoba     36890 962 34246 1682 53.7609 -98.8139 2021-04-23 04:20:52 Manitoba, Canada
1222360 2021-04-21 Canada Manitoba     36632 961 33838 1833 53.7609 -98.8139 2021-04-22 04:20:53 Manitoba, Canada
457827 2021-04-20 Canada Manitoba     36470 960 33727 1783 53.7609 -98.8139 2021-04-21 04:21:14 Manitoba, Canada
1300015 2021-04-19 Canada Manitoba     36267 959 33623 1685 53.7609 -98.8139 2021-04-20 04:20:41 Manitoba, Canada
1069594 2021-04-18 Canada Manitoba     36159 959 33512 1688 53.7609 -98.8139 2021-04-19 04:20:57 Manitoba, Canada
1045476 2021-04-17 Canada Manitoba     35992 958 33404 1630 53.7609 -98.8139 2021-04-18 04:20:41 Manitoba, Canada
596752 2021-04-16 Canada Manitoba     35815 955 33309 1551 53.7609 -98.8139 2021-04-17 04:20:40 Manitoba, Canada
1621168 2021-04-15 Canada Manitoba     35688 955 33205 1528 53.7609 -98.8139 2021-04-16 04:20:46 Manitoba, Canada
950599 2021-04-14 Canada Manitoba     35539 954 33146 1439 53.7609 -98.8139 2021-04-15 04:20:54 Manitoba, Canada
592768 2021-04-13 Canada Manitoba     35459 951 33070 1438 53.7609 -98.8139 2021-04-14 04:20:41 Manitoba, Canada
32707 2021-04-12 Canada Manitoba     35327 949 33008 1370 53.7609 -98.8139 2021-04-13 04:20:37 Manitoba, Canada
1371722 2021-04-11 Canada Manitoba     35213 949 32952 1312 53.7609 -98.8139 2021-04-12 04:21:00 Manitoba, Canada
1666974 2021-04-10 Canada Manitoba     35104 949 32896 1259 53.7609 -98.8139 2021-04-11 04:20:56 Manitoba, Canada
1159590 2021-04-09 Canada Manitoba     34969 949 32840 1180 53.7609 -98.8139 2021-04-10 04:20:59 Manitoba, Canada
1057425 2021-04-08 Canada Manitoba     34793 946 32781 1066 53.7609 -98.8139 2021-04-09 04:21:13 Manitoba, Canada
1500214 2021-04-07 Canada Manitoba     34656 943 32419 1294 53.7609 -98.8139 2021-04-08 04:21:13 Manitoba, Canada
1207419 2021-04-06 Canada Manitoba     34549 942 32352 1255 53.7609 -98.8139 2021-04-07 04:20:53 Manitoba, Canada
122720 2021-04-05 Canada Manitoba     34487 940 32267 1280 53.7609 -98.8139 2021-04-06 04:20:32 Manitoba, Canada
1254521 2021-04-04 Canada Manitoba     34352 938 32162 1252 53.7609 -98.8139 2021-04-05 04:20:35 Manitoba, Canada
1128498 2021-04-03 Canada Manitoba     34352 938 32162 1252 53.7609 -98.8139 2021-04-04 04:20:49 Manitoba, Canada
269889 2021-04-02 Canada Manitoba     34174 937 32058 1179 53.7609 -98.8139 2021-04-03 04:20:44 Manitoba, Canada
1173221 2021-04-01 Canada Manitoba     34174 937 32058 1179 53.7609 -98.8139 2021-04-02 04:20:36 Manitoba, Canada
515532 2021-03-31 Canada Manitoba     34122 935 32006 1181 53.7609 -98.8139 2021-04-01 04:27:05 Manitoba, Canada
289261 2021-03-30 Canada Manitoba     34052 934 31921 1197 53.7609 -98.8139 2021-03-31 04:26:25 Manitoba, Canada
1574798 2021-03-29 Canada Manitoba     33975 934 31864 1177 53.7609 -98.8139 2021-03-30 04:26:23 Manitoba, Canada
631075 2021-03-28 Canada Manitoba     33922 934 31809 1179 53.7609 -98.8139 2021-03-29 04:28:35 Manitoba, Canada
607856 2021-03-27 Canada Manitoba     33867 933 31744 1190 53.7609 -98.8139 2021-03-28 05:28:10 Manitoba, Canada
1333999 2021-03-26 Canada Manitoba     33810 932 31709 1169 53.7609 -98.8139 2021-03-27 05:25:04 Manitoba, Canada
150438 2021-03-25 Canada Manitoba     33696 929 31658 1109 53.7609 -98.8139 2021-03-26 05:26:55 Manitoba, Canada
1597959 2021-03-24 Canada Manitoba     33591 929 31401 1261 53.7609 -98.8139 2021-03-25 05:27:00 Manitoba, Canada
403763 2021-03-23 Canada Manitoba     33511 929 31335 1247 53.7609 -98.8139 2021-03-24 05:25:40 Manitoba, Canada
1387300 2021-03-22 Canada Manitoba     33418 928 31285 1205 53.7609 -98.8139 2021-03-23 05:26:18 Manitoba, Canada
304787 2021-03-21 Canada Manitoba     33353 927 31241 1185 53.7609 -98.8139 2021-03-22 05:25:43 Manitoba, Canada
253836 2021-03-20 Canada Manitoba     33263 920 31188 1155 53.7609 -98.8139 2021-03-21 05:25:44 Manitoba, Canada
1230592 2021-03-19 Canada Manitoba     33176 919 31130 1127 53.7609 -98.8139 2021-03-20 05:25:46 Manitoba, Canada
974517 2021-03-18 Canada Manitoba     33085 918 31078 1089 53.7609 -98.8139 2021-03-19 05:26:09 Manitoba, Canada
1532152 2021-03-17 Canada Manitoba     32996 917 31044 1035 53.7609 -98.8139 2021-03-18 05:26:22 Manitoba, Canada
55346 2021-03-16 Canada Manitoba     32903 917 30997 989 53.7609 -98.8139 2021-03-17 05:25:07 Manitoba, Canada
562659 2021-03-15 Canada Manitoba     32793 917 30968 908 53.7609 -98.8139 2021-03-16 05:25:13 Manitoba, Canada
851228 2021-03-14 Canada Manitoba     32743 917 30935 891 53.7609 -98.8139 2021-03-15 05:25:51 Manitoba, Canada
942653 2021-03-13 Canada Manitoba     32699 916 30874 909 53.7609 -98.8139 2021-03-14 05:25:37 Manitoba, Canada
1310533 2021-03-12 Canada Manitoba     32607 912 30823 872 53.7609 -98.8139 2021-03-13 05:25:15 Manitoba, Canada
1077371 2021-03-11 Canada Manitoba     32509 911 30394 1204 53.7609 -98.8139 2021-03-12 05:26:50 Manitoba, Canada
954583 2021-03-10 Canada Manitoba     32421 908 30328 1185 53.7609 -98.8139 2021-03-11 05:25:48 Manitoba, Canada
543416 2021-03-09 Canada Manitoba     32350 907 30290 1153 53.7609 -98.8139 2021-03-10 05:24:35 Manitoba, Canada
1520154 2021-03-08 Canada Manitoba     32288 907 30236 1145 53.7609 -98.8139 2021-03-09 05:28:19 Manitoba, Canada
866435 2021-03-07 Canada Manitoba     32225 907 30188 1130 53.7609 -98.8139 2021-03-08 05:24:48 Manitoba, Canada

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);