johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Ciudad de Mexico" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
412 | 412 | 2021-12-02 | Mexico | Ciudad de Mexico | 985173 | 40133 | 0 | 19.4326 | -99.1332 | 2021-12-03 04:23:05 | Ciudad de Mexico, Mexico | |||
4428 | 4428 | 2021-10-28 | Mexico | Ciudad de Mexico | 969854 | 39822 | 0 | 19.4326 | -99.1332 | 2021-10-29 04:22:03 | Ciudad de Mexico, Mexico | |||
12420 | 12420 | 2021-01-26 | Mexico | Ciudad de Mexico | 456507 | 21309 | 0 | 435198 | 19.4326 | -99.1332 | 2021-01-27 05:23:41 | Ciudad de Mexico, Mexico | ||
16436 | 16436 | 2021-09-18 | Mexico | Ciudad de Mexico | 928183 | 38486 | 0 | 19.4326 | -99.1332 | 2021-09-19 04:21:34 | Ciudad de Mexico, Mexico | |||
20451 | 20451 | 2021-05-28 | Mexico | Ciudad de Mexico | 657121 | 33171 | 0 | 623950 | 19.4326 | -99.1332 | 2021-05-29 04:20:41 | Ciudad de Mexico, Mexico | ||
24483 | 24483 | 2022-03-20 | Mexico | Ciudad de Mexico | 1379873 | 42529 | 0 | 19.4326 | -99.1332 | 2022-03-21 04:20:50 | Ciudad de Mexico, Mexico | |||
28498 | 28498 | 2021-11-11 | Mexico | Ciudad de Mexico | 976347 | 39992 | 0 | 19.4326 | -99.1332 | 2021-11-12 04:22:01 | Ciudad de Mexico, Mexico | |||
32497 | 32497 | 2021-08-25 | Mexico | Ciudad de Mexico | 879196 | 37266 | 0 | 19.4326 | -99.1332 | 2021-08-26 04:21:28 | Ciudad de Mexico, Mexico | |||
36510 | 36510 | 2021-04-12 | Mexico | Ciudad de Mexico | 621687 | 31585 | 0 | 590102 | 19.4326 | -99.1332 | 2021-04-13 04:20:37 | Ciudad de Mexico, Mexico | ||
43790 | 43790 | 2021-11-02 | Mexico | Ciudad de Mexico | 971599 | 39868 | 0 | 19.4326 | -99.1332 | 2021-11-03 06:22:09 | Ciudad de Mexico, Mexico | |||
50872 | 50872 | 2021-05-29 | Mexico | Ciudad de Mexico | 657832 | 33198 | 0 | 624634 | 19.4326 | -99.1332 | 2021-05-30 04:20:55 | Ciudad de Mexico, Mexico | ||
54885 | 54885 | 2021-03-07 | Mexico | Ciudad de Mexico | 570719 | 28230 | 0 | 542489 | 19.4326 | -99.1332 | 2021-03-08 05:24:48 | Ciudad de Mexico, Mexico | ||
63145 | 63145 | 2022-11-12 | Mexico | Ciudad de Mexico | 1749232 | 43609 | 0 | 19.4326 | -99.1332 | 2022-11-13 04:21:14 | Ciudad de Mexico, Mexico | |||
67142 | 67142 | 2021-09-01 | Mexico | Ciudad de Mexico | 897323 | 37686 | 0 | 19.4326 | -99.1332 | 2021-09-02 04:21:15 | Ciudad de Mexico, Mexico | |||
71173 | 71173 | 2022-02-07 | Mexico | Ciudad de Mexico | 1271088 | 41368 | 0 | 19.4326 | -99.1332 | 2022-02-08 04:21:15 | Ciudad de Mexico, Mexico | |||
75169 | 75169 | 2020-12-03 | Mexico | Ciudad de Mexico | 219465 | 13814 | 0 | 205651 | 19.4326 | -99.1332 | 2020-12-04 05:27:27 | Ciudad de Mexico, Mexico | ||
83175 | 83175 | 2021-05-25 | Mexico | Ciudad de Mexico | 654758 | 33128 | 0 | 621630 | 19.4326 | -99.1332 | 2021-05-26 04:20:35 | Ciudad de Mexico, Mexico | ||
87207 | 87207 | 2021-11-09 | Mexico | Ciudad de Mexico | 975313 | 39968 | 0 | 19.4326 | -99.1332 | 2021-11-10 04:21:38 | Ciudad de Mexico, Mexico | |||
91225 | 91225 | 2022-07-23 | Mexico | Ciudad de Mexico | 1643080 | 43182 | 0 | 19.4326 | -99.1332 | 2022-07-24 04:20:47 | Ciudad de Mexico, Mexico | |||
99408 | 99408 | 2022-01-14 | Mexico | Ciudad de Mexico | 1072218 | 40417 | 0 | 19.4326 | -99.1332 | 2022-01-15 04:21:07 | Ciudad de Mexico, Mexico | |||
103407 | 103407 | 2021-08-15 | Mexico | Ciudad de Mexico | 843818 | 36564 | 0 | 19.4326 | -99.1332 | 2021-08-16 04:21:31 | Ciudad de Mexico, Mexico | |||
107532 | 107532 | 2021-06-19 | Mexico | Ciudad de Mexico | 671941 | 34420 | 0 | 637521 | 19.4326 | -99.1332 | 2021-06-20 04:21:48 | Ciudad de Mexico, Mexico | ||
114835 | 114835 | 2022-09-06 | Mexico | Ciudad de Mexico | 1728744 | 43505 | 0 | 19.4326 | -99.1332 | 2022-09-07 04:20:59 | Ciudad de Mexico, Mexico | |||
122784 | 122784 | 2020-11-18 | Mexico | Ciudad de Mexico | 181913 | 12769 | 0 | 169144 | 19.4326 | -99.1332 | 2020-11-19 05:25:23 | Ciudad de Mexico, Mexico | ||
126815 | 126815 | 2022-01-09 | Mexico | Ciudad de Mexico | 1041573 | 40376 | 0 | 19.4326 | -99.1332 | 2022-01-10 04:22:07 | Ciudad de Mexico, Mexico | |||
130833 | 130833 | 2022-10-04 | Mexico | Ciudad de Mexico | 1739537 | 43567 | 0 | 19.4326 | -99.1332 | 2022-10-05 04:23:06 | Ciudad de Mexico, Mexico | |||
138053 | 138053 | 2021-12-04 | Mexico | Ciudad de Mexico | 986081 | 40176 | 0 | 19.4326 | -99.1332 | 2021-12-05 04:22:25 | Ciudad de Mexico, Mexico | |||
142071 | 142071 | 2022-07-09 | Mexico | Ciudad de Mexico | 1553808 | 42979 | 0 | 19.4326 | -99.1332 | 2022-07-10 04:20:54 | Ciudad de Mexico, Mexico | |||
150066 | 150066 | 2021-11-29 | Mexico | Ciudad de Mexico | 984355 | 40123 | 0 | 19.4326 | -99.1332 | 2021-11-30 04:22:53 | Ciudad de Mexico, Mexico | |||
154063 | 154063 | 2021-01-08 | Mexico | Ciudad de Mexico | 359312 | 17897 | 0 | 341415 | 19.4326 | -99.1332 | 2021-01-09 05:22:18 | Ciudad de Mexico, Mexico | ||
158095 | 158095 | 2022-03-29 | Mexico | Ciudad de Mexico | 1384513 | 42602 | 0 | 19.4326 | -99.1332 | 2022-03-30 04:20:45 | Ciudad de Mexico, Mexico | |||
162110 | 162110 | 2021-11-19 | Mexico | Ciudad de Mexico | 979078 | 40039 | 0 | 19.4326 | -99.1332 | 2021-11-20 04:22:17 | Ciudad de Mexico, Mexico | |||
166128 | 166128 | 2022-06-21 | Mexico | Ciudad de Mexico | 1448900 | 42882 | 0 | 19.4326 | -99.1332 | 2022-06-22 04:20:54 | Ciudad de Mexico, Mexico | |||
170124 | 170124 | 2021-04-16 | Mexico | Ciudad de Mexico | 627326 | 31882 | 0 | 595444 | 19.4326 | -99.1332 | 2021-04-17 04:20:40 | Ciudad de Mexico, Mexico | ||
178107 | 178107 | 2021-09-02 | Mexico | Ciudad de Mexico | 900296 | 37764 | 0 | 19.4326 | -99.1332 | 2021-09-03 04:21:20 | Ciudad de Mexico, Mexico | |||
182120 | 182120 | 2021-02-21 | Mexico | Ciudad de Mexico | 539990 | 26242 | 0 | 513748 | 19.4326 | -99.1332 | 2021-02-22 05:24:21 | Ciudad de Mexico, Mexico | ||
186153 | 186153 | 2022-02-13 | Mexico | Ciudad de Mexico | 1297736 | 41638 | 0 | 19.4326 | -99.1332 | 2022-02-14 04:20:51 | Ciudad de Mexico, Mexico | |||
190149 | 190149 | 2021-01-11 | Mexico | Ciudad de Mexico | 368957 | 18333 | 0 | 350624 | 19.4326 | -99.1332 | 2021-01-12 05:22:15 | Ciudad de Mexico, Mexico | ||
198342 | 198342 | 2022-10-19 | Mexico | Ciudad de Mexico | 1743502 | 43592 | 0 | 19.4326 | -99.1332 | 2022-10-20 04:22:59 | Ciudad de Mexico, Mexico | |||
202336 | 202336 | 2020-12-25 | Mexico | Ciudad de Mexico | 310843 | 16035 | 0 | 294808 | 19.4326 | -99.1332 | 2020-12-26 05:22:28 | Ciudad de Mexico, Mexico | ||
218063 | 218063 | 2022-12-26 | Mexico | Ciudad de Mexico | 1783310 | 43687 | 0 | 19.4326 | -99.1332 | 2022-12-27 04:21:07 | Ciudad de Mexico, Mexico | |||
222078 | 222078 | 2022-05-09 | Mexico | Ciudad de Mexico | 1399114 | 42799 | 0 | 19.4326 | -99.1332 | 2022-05-10 04:20:50 | Ciudad de Mexico, Mexico | |||
229310 | 229310 | 2022-05-31 | Mexico | Ciudad de Mexico | 1411601 | 42830 | 0 | 19.4326 | -99.1332 | 2022-06-01 04:20:55 | Ciudad de Mexico, Mexico | |||
233325 | 233325 | 2022-02-11 | Mexico | Ciudad de Mexico | 1285560 | 41538 | 0 | 19.4326 | -99.1332 | 2022-02-12 04:21:06 | Ciudad de Mexico, Mexico | |||
237321 | 237321 | 2021-01-18 | Mexico | Ciudad de Mexico | 409551 | 19531 | 0 | 390020 | 19.4326 | -99.1332 | 2021-01-19 05:22:15 | Ciudad de Mexico, Mexico | ||
241335 | 241335 | 2021-04-02 | Mexico | Ciudad de Mexico | 611766 | 30630 | 0 | 581136 | 19.4326 | -99.1332 | 2021-04-03 04:20:44 | Ciudad de Mexico, Mexico | ||
245350 | 245350 | 2021-08-17 | Mexico | Ciudad de Mexico | 850361 | 36742 | 0 | 19.4326 | -99.1332 | 2021-08-18 04:21:35 | Ciudad de Mexico, Mexico | |||
249364 | 249364 | 2021-09-04 | Mexico | Ciudad de Mexico | 905935 | 37869 | 0 | 19.4326 | -99.1332 | 2021-09-05 04:21:33 | Ciudad de Mexico, Mexico | |||
253397 | 253397 | 2022-09-08 | Mexico | Ciudad de Mexico | 1728744 | 43505 | 0 | 19.4326 | -99.1332 | 2022-09-09 04:21:11 | Ciudad de Mexico, Mexico | |||
257413 | 257413 | 2022-12-10 | Mexico | Ciudad de Mexico | 1761061 | 43634 | 0 | 19.4326 | -99.1332 | 2022-12-11 04:20:50 | Ciudad de Mexico, Mexico | |||
261615 | 261615 | 2022-03-15 | Mexico | Ciudad de Mexico | 1373679 | 42439 | 0 | 19.4326 | -99.1332 | 2022-03-16 04:20:50 | Ciudad de Mexico, Mexico | |||
276265 | 276265 | 2021-11-03 | Mexico | Ciudad de Mexico | 972097 | 39895 | 0 | 19.4326 | -99.1332 | 2021-11-04 04:22:20 | Ciudad de Mexico, Mexico | |||
280263 | 280263 | 2021-02-24 | Mexico | Ciudad de Mexico | 546877 | 26713 | 0 | 520164 | 19.4326 | -99.1332 | 2021-02-25 05:24:57 | Ciudad de Mexico, Mexico | ||
288078 | 288078 | 2021-10-31 | Mexico | Ciudad de Mexico | 971426 | 39859 | 0 | 19.4326 | -99.1332 | 2021-11-01 04:22:01 | Ciudad de Mexico, Mexico | |||
292096 | 292096 | 2022-11-15 | Mexico | Ciudad de Mexico | 1750164 | 43611 | 0 | 19.4326 | -99.1332 | 2022-11-16 04:21:09 | Ciudad de Mexico, Mexico | |||
296093 | 296093 | 2021-07-15 | Mexico | Ciudad de Mexico | 722391 | 35049 | 0 | 687342 | 19.4326 | -99.1332 | 2021-07-16 04:21:22 | Ciudad de Mexico, Mexico | ||
303951 | 303951 | 2022-04-16 | Mexico | Ciudad de Mexico | 1393189 | 42747 | 0 | 19.4326 | -99.1332 | 2022-04-17 04:20:59 | Ciudad de Mexico, Mexico | |||
307968 | 307968 | 2022-12-13 | Mexico | Ciudad de Mexico | 1764954 | 43651 | 0 | 19.4326 | -99.1332 | 2022-12-14 04:21:04 | Ciudad de Mexico, Mexico | |||
311984 | 311984 | 2022-11-13 | Mexico | Ciudad de Mexico | 1749232 | 43609 | 0 | 19.4326 | -99.1332 | 2022-11-14 04:21:09 | Ciudad de Mexico, Mexico | |||
315999 | 315999 | 2022-02-12 | Mexico | Ciudad de Mexico | 1297736 | 41638 | 0 | 19.4326 | -99.1332 | 2022-02-13 04:21:00 | Ciudad de Mexico, Mexico | |||
320016 | 320016 | 2022-10-30 | Mexico | Ciudad de Mexico | 1746475 | 43605 | 0 | 19.4326 | -99.1332 | 2022-10-31 04:21:36 | Ciudad de Mexico, Mexico | |||
327990 | 327990 | 2022-12-27 | Mexico | Ciudad de Mexico | 1785464 | 43700 | 0 | 19.4326 | -99.1332 | 2022-12-28 04:21:04 | Ciudad de Mexico, Mexico | |||
331987 | 331987 | 2021-08-04 | Mexico | Ciudad de Mexico | 799306 | 35874 | 0 | 763432 | 19.4326 | -99.1332 | 2021-08-05 04:21:51 | Ciudad de Mexico, Mexico | ||
336019 | 336019 | 2022-03-18 | Mexico | Ciudad de Mexico | 1377867 | 42509 | 0 | 19.4326 | -99.1332 | 2022-03-19 04:20:47 | Ciudad de Mexico, Mexico | |||
340355 | 340355 | 2021-02-03 | Mexico | Ciudad de Mexico | 488328 | 22916 | 0 | 465412 | 19.4326 | -99.1332 | 2021-02-04 05:22:26 | Ciudad de Mexico, Mexico | ||
348380 | 348380 | 2022-12-14 | Mexico | Ciudad de Mexico | 1764954 | 43651 | 0 | 19.4326 | -99.1332 | 2022-12-15 04:20:58 | Ciudad de Mexico, Mexico | |||
352376 | 352376 | 2021-03-11 | Mexico | Ciudad de Mexico | 578835 | 28754 | 0 | 550081 | 19.4326 | -99.1332 | 2021-03-12 05:26:50 | Ciudad de Mexico, Mexico | ||
356409 | 356409 | 2022-03-11 | Mexico | Ciudad de Mexico | 1370061 | 42389 | 0 | 19.4326 | -99.1332 | 2022-03-12 04:20:50 | Ciudad de Mexico, Mexico | |||
360425 | 360425 | 2022-05-07 | Mexico | Ciudad de Mexico | 1397401 | 42794 | 0 | 19.4326 | -99.1332 | 2022-05-08 04:20:49 | Ciudad de Mexico, Mexico | |||
372280 | 372280 | 2022-09-13 | Mexico | Ciudad de Mexico | 1731892 | 43517 | 0 | 19.4326 | -99.1332 | 2022-09-14 04:20:44 | Ciudad de Mexico, Mexico | |||
380273 | 380273 | 2021-04-30 | Mexico | Ciudad de Mexico | 640705 | 32567 | 0 | 608138 | 19.4326 | -99.1332 | 2021-05-01 04:20:47 | Ciudad de Mexico, Mexico | ||
384307 | 384307 | 2022-09-23 | Mexico | Ciudad de Mexico | 1736871 | 43556 | 0 | 19.4326 | -99.1332 | 2022-09-24 04:21:40 | Ciudad de Mexico, Mexico | |||
388303 | 388303 | 2021-04-04 | Mexico | Ciudad de Mexico | 612753 | 30686 | 0 | 582067 | 19.4326 | -99.1332 | 2021-04-05 04:20:35 | Ciudad de Mexico, Mexico | ||
392315 | 392315 | 2020-11-27 | Mexico | Ciudad de Mexico | 200704 | 17383 | 0 | 183321 | 19.4326 | -99.1332 | 2020-11-28 05:25:50 | Ciudad de Mexico, Mexico | ||
396348 | 396348 | 2022-10-07 | Mexico | Ciudad de Mexico | 1741025 | 43577 | 0 | 19.4326 | -99.1332 | 2022-10-08 04:22:56 | Ciudad de Mexico, Mexico | |||
400345 | 400345 | 2021-06-29 | Mexico | Ciudad de Mexico | 683409 | 34674 | 0 | 648735 | 19.4326 | -99.1332 | 2021-06-30 04:21:41 | Ciudad de Mexico, Mexico | ||
404376 | 404376 | 2021-12-07 | Mexico | Ciudad de Mexico | 986887 | 40192 | 0 | 19.4326 | -99.1332 | 2021-12-08 04:22:46 | Ciudad de Mexico, Mexico | |||
408375 | 408375 | 2021-07-28 | Mexico | Ciudad de Mexico | 770536 | 35531 | 0 | 735005 | 19.4326 | -99.1332 | 2021-07-29 04:21:33 | Ciudad de Mexico, Mexico | ||
419419 | 419419 | 2022-09-18 | Mexico | Ciudad de Mexico | 1734072 | 43545 | 0 | 19.4326 | -99.1332 | 2022-09-19 04:21:49 | Ciudad de Mexico, Mexico | |||
423433 | 423433 | 2021-10-10 | Mexico | Ciudad de Mexico | 956755 | 39453 | 0 | 19.4326 | -99.1332 | 2021-10-11 04:21:31 | Ciudad de Mexico, Mexico | |||
431441 | 431441 | 2022-11-03 | Mexico | Ciudad de Mexico | 1747014 | 43606 | 0 | 19.4326 | -99.1332 | 2022-11-04 04:22:11 | Ciudad de Mexico, Mexico | |||
435436 | 435436 | 2021-01-21 | Mexico | Ciudad de Mexico | 432631 | 20298 | 0 | 412333 | 19.4326 | -99.1332 | 2021-01-22 05:22:10 | Ciudad de Mexico, Mexico | ||
443437 | 443437 | 2021-10-20 | Mexico | Ciudad de Mexico | 964604 | 39685 | 0 | 19.4326 | -99.1332 | 2021-10-21 04:21:18 | Ciudad de Mexico, Mexico | |||
447453 | 447453 | 2021-11-17 | Mexico | Ciudad de Mexico | 978471 | 40031 | 0 | 19.4326 | -99.1332 | 2021-11-18 04:21:33 | Ciudad de Mexico, Mexico | |||
451471 | 451471 | 2022-12-21 | Mexico | Ciudad de Mexico | 1774057 | 43665 | 0 | 19.4326 | -99.1332 | 2022-12-22 04:20:56 | Ciudad de Mexico, Mexico | |||
459462 | 459462 | 2022-02-02 | Mexico | Ciudad de Mexico | 1233164 | 41086 | 0 | 19.4326 | -99.1332 | 2022-02-03 04:21:21 | Ciudad de Mexico, Mexico | |||
463479 | 463479 | 2022-05-02 | Mexico | Ciudad de Mexico | 1397483 | 42795 | 0 | 19.4326 | -99.1332 | 2022-05-03 04:21:00 | Ciudad de Mexico, Mexico | |||
467494 | 467494 | 2021-10-07 | Mexico | Ciudad de Mexico | 953861 | 39396 | 0 | 19.4326 | -99.1332 | 2021-10-08 04:21:25 | Ciudad de Mexico, Mexico | |||
471492 | 471492 | 2021-02-19 | Mexico | Ciudad de Mexico | 536058 | 25990 | 0 | 510068 | 19.4326 | -99.1332 | 2021-02-20 05:22:51 | Ciudad de Mexico, Mexico | ||
475526 | 475526 | 2022-06-26 | Mexico | Ciudad de Mexico | 1472239 | 42906 | 0 | 19.4326 | -99.1332 | 2022-06-27 04:21:00 | Ciudad de Mexico, Mexico | |||
479674 | 479674 | 2022-11-08 | Mexico | Ciudad de Mexico | 1747959 | 43609 | 0 | 19.4326 | -99.1332 | 2022-11-09 04:21:22 | Ciudad de Mexico, Mexico | |||
483671 | 483671 | 2021-07-19 | Mexico | Ciudad de Mexico | 733303 | 35153 | 0 | 698150 | 19.4326 | -99.1332 | 2021-07-20 04:21:48 | Ciudad de Mexico, Mexico | ||
487704 | 487704 | 2022-11-25 | Mexico | Ciudad de Mexico | 1752242 | 43617 | 0 | 19.4326 | -99.1332 | 2022-11-26 04:21:11 | Ciudad de Mexico, Mexico | |||
491718 | 491718 | 2021-10-14 | Mexico | Ciudad de Mexico | 960463 | 39581 | 0 | 19.4326 | -99.1332 | 2021-10-15 04:21:26 | Ciudad de Mexico, Mexico | |||
495734 | 495734 | 2021-11-06 | Mexico | Ciudad de Mexico | 974295 | 39933 | 0 | 19.4326 | -99.1332 | 2021-11-07 04:21:53 | Ciudad de Mexico, Mexico | |||
499751 | 499751 | 2022-04-02 | Mexico | Ciudad de Mexico | 1387287 | 42625 | 0 | 19.4326 | -99.1332 | 2022-04-03 04:20:48 | Ciudad de Mexico, Mexico | |||
503768 | 503768 | 2022-12-17 | Mexico | Ciudad de Mexico | 1771353 | 43661 | 0 | 19.4326 | -99.1332 | 2022-12-18 04:21:03 | Ciudad de Mexico, Mexico | |||
507765 | 507765 | 2021-08-14 | Mexico | Ciudad de Mexico | 843818 | 36564 | 0 | 19.4326 | -99.1332 | 2021-08-15 04:21:41 | Ciudad de Mexico, Mexico | |||
511779 | 511779 | 2021-08-19 | Mexico | Ciudad de Mexico | 860233 | 36909 | 0 | 19.4326 | -99.1332 | 2021-08-20 04:21:33 | Ciudad de Mexico, Mexico | |||
515812 | 515812 | 2022-10-15 | Mexico | Ciudad de Mexico | 1743399 | 43592 | 0 | 19.4326 | -99.1332 | 2022-10-16 04:22:39 | Ciudad de Mexico, Mexico |
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]);