johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and province_or_state = "Sinaloa" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
last_update (date) >30 ✖
- 2022-04-13 2
- 2022-05-26 2
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- …
province_or_state 1
- Sinaloa · 954 ✖
country_or_region 1
- Mexico · 954 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1431988 | 1431988 | 2020-05-20 | Mexico | Sinaloa | 2161 | 326 | 1476 | 359 | 25.1721 | -107.4795 | 2020-05-21 02:32:48 | Sinaloa, Mexico | ||
268405 | 268405 | 2020-05-21 | Mexico | Sinaloa | 2243 | 354 | 1525 | 364 | 25.1721 | -107.4795 | 2020-05-22 02:36:51 | Sinaloa, Mexico | ||
1864899 | 1864899 | 2020-05-22 | Mexico | Sinaloa | 2328 | 366 | 1584 | 378 | 25.1721 | -107.4795 | 2020-05-23 02:32:42 | Sinaloa, Mexico | ||
997876 | 997876 | 2020-05-23 | Mexico | Sinaloa | 2438 | 380 | 1642 | 416 | 25.1721 | -107.4795 | 2020-05-24 02:32:43 | Sinaloa, Mexico | ||
875685 | 875685 | 2020-05-24 | Mexico | Sinaloa | 2587 | 390 | 1740 | 457 | 25.1721 | -107.4795 | 2020-05-25 02:32:44 | Sinaloa, Mexico | ||
1105005 | 1105005 | 2020-05-25 | Mexico | Sinaloa | 2794 | 406 | 1831 | 557 | 25.1721 | -107.4795 | 2020-05-26 02:32:35 | Sinaloa, Mexico | ||
1041275 | 1041275 | 2020-05-26 | Mexico | Sinaloa | 2813 | 427 | 1895 | 491 | 25.1721 | -107.4795 | 2020-05-27 02:32:31 | Sinaloa, Mexico | ||
2548312 | 2548312 | 2020-05-27 | Mexico | Sinaloa | 2903 | 431 | 1967 | 505 | 25.1721 | -107.4795 | 2020-05-28 02:32:31 | Sinaloa, Mexico | ||
2712378 | 2712378 | 2020-05-28 | Mexico | Sinaloa | 3014 | 448 | 2045 | 521 | 25.1721 | -107.4795 | 2020-05-29 02:32:50 | Sinaloa, Mexico | ||
1790499 | 1790499 | 2020-05-29 | Mexico | Sinaloa | 3125 | 460 | 2193 | 472 | 25.1721 | -107.4795 | 2020-05-30 02:32:48 | Sinaloa, Mexico | ||
3638958 | 3638958 | 2020-05-30 | Mexico | Sinaloa | 3261 | 488 | 2283 | 490 | 25.1721 | -107.4795 | 2020-05-31 02:32:45 | Sinaloa, Mexico | ||
1794065 | 1794065 | 2020-05-31 | Mexico | Sinaloa | 3421 | 501 | 2369 | 551 | 25.1721 | -107.4795 | 2020-06-01 02:32:46 | Sinaloa, Mexico | ||
805504 | 805504 | 2020-06-01 | Mexico | Sinaloa | 3580 | 522 | 2465 | 593 | 25.1721 | -107.4795 | 2020-06-02 02:33:08 | Sinaloa, Mexico | ||
2555967 | 2555967 | 2020-06-02 | Mexico | Sinaloa | 3699 | 548 | 2560 | 591 | 25.1721 | -107.4795 | 2020-06-03 02:33:13 | Sinaloa, Mexico | ||
3866925 | 3866925 | 2020-06-03 | Mexico | Sinaloa | 3903 | 624 | 2687 | 592 | 25.1721 | -107.4795 | 2020-06-04 02:33:14 | Sinaloa, Mexico | ||
1281370 | 1281370 | 2020-06-04 | Mexico | Sinaloa | 4036 | 646 | 2795 | 595 | 25.1721 | -107.4795 | 2020-06-05 02:33:06 | Sinaloa, Mexico | ||
1269901 | 1269901 | 2020-06-05 | Mexico | Sinaloa | 4237 | 673 | 2936 | 628 | 25.1721 | -107.4795 | 2020-06-06 02:33:00 | Sinaloa, Mexico | ||
574204 | 574204 | 2020-06-06 | Mexico | Sinaloa | 4405 | 684 | 3079 | 642 | 25.1721 | -107.4795 | 2020-06-07 03:53:30 | Sinaloa, Mexico | ||
2800148 | 2800148 | 2020-06-07 | Mexico | Sinaloa | 4551 | 708 | 3211 | 632 | 25.1721 | -107.4795 | 2020-06-08 03:33:22 | Sinaloa, Mexico | ||
217352 | 217352 | 2020-06-08 | Mexico | Sinaloa | 4762 | 732 | 3376 | 654 | 25.1721 | -107.4795 | 2020-06-09 03:33:03 | Sinaloa, Mexico | ||
1210925 | 1210925 | 2020-06-09 | Mexico | Sinaloa | 4866 | 774 | 3479 | 613 | 25.1721 | -107.4795 | 2020-06-10 04:07:00 | Sinaloa, Mexico | ||
2864100 | 2864100 | 2020-06-10 | Mexico | Sinaloa | 5062 | 800 | 3599 | 663 | 25.1721 | -107.4795 | 2020-06-11 03:33:41 | Sinaloa, Mexico | ||
1273659 | 1273659 | 2020-06-11 | Mexico | Sinaloa | 5191 | 835 | 3697 | 659 | 25.1721 | -107.4795 | 2020-06-12 05:09:52 | Sinaloa, Mexico | ||
737689 | 737689 | 2020-06-12 | Mexico | Sinaloa | 5314 | 852 | 3822 | 640 | 25.1721 | -107.4795 | 2020-06-13 03:33:14 | Sinaloa, Mexico | ||
3061369 | 3061369 | 2020-06-13 | Mexico | Sinaloa | 5366 | 867 | 3936 | 563 | 25.1721 | -107.4795 | 2020-06-14 03:33:15 | Sinaloa, Mexico | ||
1837317 | 1837317 | 2020-06-14 | Mexico | Sinaloa | 5635 | 879 | 4106 | 650 | 25.1721 | -107.4795 | 2020-06-15 03:33:14 | Sinaloa, Mexico | ||
287366 | 287366 | 2020-06-15 | Mexico | Sinaloa | 5854 | 907 | 4307 | 640 | 25.1721 | -107.4795 | 2020-06-16 04:33:09 | Sinaloa, Mexico | ||
2386803 | 2386803 | 2020-06-16 | Mexico | Sinaloa | 5945 | 933 | 4413 | 599 | 25.1721 | -107.4795 | 2020-06-17 04:33:21 | Sinaloa, Mexico | ||
1196040 | 1196040 | 2020-06-17 | Mexico | Sinaloa | 6019 | 953 | 4537 | 529 | 25.1721 | -107.4795 | 2020-06-18 04:33:18 | Sinaloa, Mexico | ||
3682837 | 3682837 | 2020-06-18 | Mexico | Sinaloa | 6154 | 967 | 4693 | 494 | 25.1721 | -107.4795 | 2020-06-19 04:33:17 | Sinaloa, Mexico | ||
1691688 | 1691688 | 2020-06-19 | Mexico | Sinaloa | 6328 | 990 | 4909 | 429 | 25.1721 | -107.4795 | 2020-06-20 04:33:19 | Sinaloa, Mexico | ||
2438110 | 2438110 | 2020-06-20 | Mexico | Sinaloa | 6478 | 1005 | 5128 | 345 | 25.1721 | -107.4795 | 2020-06-21 04:33:19 | Sinaloa, Mexico | ||
3249517 | 3249517 | 2020-06-21 | Mexico | Sinaloa | 6683 | 1020 | 5288 | 375 | 25.1721 | -107.4795 | 2020-06-22 04:33:20 | Sinaloa, Mexico | ||
1510778 | 1510778 | 2020-06-22 | Mexico | Sinaloa | 6771 | 1032 | 5451 | 288 | 25.1721 | -107.4795 | 2020-06-23 04:33:22 | Sinaloa, Mexico | ||
1522584 | 1522584 | 2020-06-23 | Mexico | Sinaloa | 7315 | 1098 | 5668 | 549 | 25.1721 | -107.4795 | 2020-06-24 04:33:28 | Sinaloa, Mexico | ||
2700899 | 2700899 | 2020-06-24 | Mexico | Sinaloa | 7473 | 1126 | 5860 | 487 | 25.1721 | -107.4795 | 2020-06-25 05:26:54 | Sinaloa, Mexico | ||
2625259 | 2625259 | 2020-06-25 | Mexico | Sinaloa | 7569 | 1147 | 5967 | 455 | 25.1721 | -107.4795 | 2020-06-26 04:33:43 | Sinaloa, Mexico | ||
1136272 | 1136272 | 2020-06-26 | Mexico | Sinaloa | 7763 | 1169 | 6139 | 455 | 25.1721 | -107.4795 | 2020-06-27 04:33:35 | Sinaloa, Mexico | ||
2039991 | 2039991 | 2020-06-27 | Mexico | Sinaloa | 7801 | 1218 | 6144 | 439 | 25.1721 | -107.4795 | 2020-06-28 04:34:04 | Sinaloa, Mexico | ||
2306656 | 2306656 | 2020-06-28 | Mexico | Sinaloa | 7895 | 1236 | 6255 | 404 | 25.1721 | -107.4795 | 2020-06-29 04:33:44 | Sinaloa, Mexico | ||
2633093 | 2633093 | 2020-06-29 | Mexico | Sinaloa | 8111 | 1257 | 6484 | 370 | 25.1721 | -107.4795 | 2020-06-30 04:33:48 | Sinaloa, Mexico | ||
2974616 | 2974616 | 2020-06-30 | Mexico | Sinaloa | 8296 | 1298 | 6584 | 414 | 25.1721 | -107.4795 | 2020-07-01 04:33:52 | Sinaloa, Mexico | ||
303238 | 303238 | 2020-07-01 | Mexico | Sinaloa | 8456 | 1331 | 6680 | 445 | 25.1721 | -107.4795 | 2020-07-02 04:33:46 | Sinaloa, Mexico | ||
3045547 | 3045547 | 2020-07-02 | Mexico | Sinaloa | 8613 | 1356 | 6829 | 428 | 25.1721 | -107.4795 | 2020-07-03 04:33:54 | Sinaloa, Mexico | ||
2234753 | 2234753 | 2020-07-03 | Mexico | Sinaloa | 8748 | 1383 | 6952 | 413 | 25.1721 | -107.4795 | 2020-07-04 04:33:51 | Sinaloa, Mexico | ||
530092 | 530092 | 2020-07-04 | Mexico | Sinaloa | 8902 | 1404 | 7144 | 354 | 25.1721 | -107.4795 | 2020-07-05 04:33:46 | Sinaloa, Mexico | ||
415530 | 415530 | 2020-07-05 | Mexico | Sinaloa | 8961 | 1413 | 7245 | 303 | 25.1721 | -107.4795 | 2020-07-06 04:33:57 | Sinaloa, Mexico | ||
2685065 | 2685065 | 2020-07-06 | Mexico | Sinaloa | 9163 | 1434 | 7361 | 368 | 25.1721 | -107.4795 | 2020-07-07 04:34:00 | Sinaloa, Mexico | ||
887505 | 887505 | 2020-07-07 | Mexico | Sinaloa | 9333 | 1477 | 7444 | 412 | 25.1721 | -107.4795 | 2020-07-08 05:33:48 | Sinaloa, Mexico | ||
2222896 | 2222896 | 2020-07-08 | Mexico | Sinaloa | 9526 | 1508 | 7554 | 464 | 25.1721 | -107.4795 | 2020-07-09 04:34:23 | Sinaloa, Mexico | ||
1005680 | 1005680 | 2020-07-09 | Mexico | Sinaloa | 9631 | 1545 | 7660 | 426 | 25.1721 | -107.4795 | 2020-07-10 04:34:24 | Sinaloa, Mexico | ||
3237695 | 3237695 | 2020-07-10 | Mexico | Sinaloa | 9775 | 1578 | 7761 | 436 | 25.1721 | -107.4795 | 2020-07-11 04:34:26 | Sinaloa, Mexico | ||
3436197 | 3436197 | 2020-07-11 | Mexico | Sinaloa | 9895 | 1608 | 7842 | 445 | 25.1721 | -107.4795 | 2020-07-12 04:34:30 | Sinaloa, Mexico | ||
3737802 | 3737802 | 2020-07-12 | Mexico | Sinaloa | 10103 | 1640 | 7988 | 475 | 25.1721 | -107.4795 | 2020-07-13 04:43:04 | Sinaloa, Mexico | ||
3491539 | 3491539 | 2020-07-13 | Mexico | Sinaloa | 10312 | 1655 | 8123 | 534 | 25.1721 | -107.4795 | 2020-07-14 04:34:46 | Sinaloa, Mexico | ||
2158898 | 2158898 | 2020-07-14 | Mexico | Sinaloa | 10563 | 1689 | 8256 | 618 | 25.1721 | -107.4795 | 2020-07-15 04:34:39 | Sinaloa, Mexico | ||
2748254 | 2748254 | 2020-07-15 | Mexico | Sinaloa | 10748 | 1714 | 8440 | 594 | 25.1721 | -107.4795 | 2020-07-16 04:44:59 | Sinaloa, Mexico | ||
367586 | 367586 | 2020-07-16 | Mexico | Sinaloa | 10859 | 1739 | 8572 | 548 | 25.1721 | -107.4795 | 2020-07-17 04:34:50 | Sinaloa, Mexico | ||
2708776 | 2708776 | 2020-07-17 | Mexico | Sinaloa | 11037 | 1791 | 8698 | 548 | 25.1721 | -107.4795 | 2020-07-18 04:34:45 | Sinaloa, Mexico | ||
3205474 | 3205474 | 2020-07-18 | Mexico | Sinaloa | 11304 | 1821 | 8935 | 548 | 25.1721 | -107.4795 | 2020-07-19 04:34:58 | Sinaloa, Mexico | ||
122085 | 122085 | 2020-07-19 | Mexico | Sinaloa | 11314 | 1830 | 8545 | 939 | 25.1721 | -107.4795 | 2020-07-20 05:34:40 | Sinaloa, Mexico | ||
327180 | 327180 | 2020-07-20 | Mexico | Sinaloa | 11350 | 1843 | 8676 | 831 | 25.1721 | -107.4795 | 2020-07-21 04:38:46 | Sinaloa, Mexico | ||
1707689 | 1707689 | 2020-07-21 | Mexico | Sinaloa | 11683 | 1894 | 8931 | 858 | 25.1721 | -107.4795 | 2020-07-22 04:34:42 | Sinaloa, Mexico | ||
844950 | 844950 | 2020-07-22 | Mexico | Sinaloa | 11811 | 1941 | 9036 | 834 | 25.1721 | -107.4795 | 2020-07-23 05:15:04 | Sinaloa, Mexico | ||
62421 | 62421 | 2020-07-23 | Mexico | Sinaloa | 11918 | 1970 | 9086 | 862 | 25.1721 | -107.4795 | 2020-07-24 03:34:53 | Sinaloa, Mexico | ||
2563930 | 2563930 | 2020-07-24 | Mexico | Sinaloa | 12018 | 1991 | 9202 | 825 | 25.1721 | -107.4795 | 2020-07-25 04:47:39 | Sinaloa, Mexico | ||
1502960 | 1502960 | 2020-07-25 | Mexico | Sinaloa | 12170 | 2016 | 9360 | 794 | 25.1721 | -107.4795 | 2020-07-26 04:35:00 | Sinaloa, Mexico | ||
442716 | 442716 | 2020-07-26 | Mexico | Sinaloa | 12285 | 2030 | 9470 | 785 | 25.1721 | -107.4795 | 2020-07-27 04:35:02 | Sinaloa, Mexico | ||
177403 | 177403 | 2020-07-27 | Mexico | Sinaloa | 12338 | 2048 | 9550 | 740 | 25.1721 | -107.4795 | 2020-07-28 04:58:43 | Sinaloa, Mexico | ||
3185352 | 3185352 | 2020-07-28 | Mexico | Sinaloa | 12441 | 2077 | 9621 | 743 | 25.1721 | -107.4795 | 2020-07-29 04:35:11 | Sinaloa, Mexico | ||
2958736 | 2958736 | 2020-07-29 | Mexico | Sinaloa | 12463 | 2103 | 9607 | 753 | 25.1721 | -107.4795 | 2020-07-30 04:35:05 | Sinaloa, Mexico | ||
1928568 | 1928568 | 2020-07-30 | Mexico | Sinaloa | 12519 | 2159 | 9663 | 697 | 25.1721 | -107.4795 | 2020-07-31 04:35:18 | Sinaloa, Mexico | ||
3264861 | 3264861 | 2020-07-31 | Mexico | Sinaloa | 12685 | 2191 | 9673 | 821 | 25.1721 | -107.4795 | 2020-08-01 04:36:27 | Sinaloa, Mexico | ||
753696 | 753696 | 2020-08-01 | Mexico | Sinaloa | 12774 | 2233 | 9683 | 858 | 25.1721 | -107.4795 | 2020-08-02 04:34:47 | Sinaloa, Mexico | ||
2808128 | 2808128 | 2020-08-02 | Mexico | Sinaloa | 12810 | 2242 | 9740 | 828 | 25.1721 | -107.4795 | 2020-08-03 04:34:35 | Sinaloa, Mexico | ||
2740376 | 2740376 | 2020-08-03 | Mexico | Sinaloa | 12871 | 2248 | 9901 | 722 | 25.1721 | -107.4795 | 2020-08-04 04:41:59 | Sinaloa, Mexico | ||
98493 | 98493 | 2020-08-04 | Mexico | Sinaloa | 13068 | 2272 | 10072 | 724 | 25.1721 | -107.4795 | 2020-08-05 04:34:43 | Sinaloa, Mexico | ||
3793257 | 3793257 | 2020-08-05 | Mexico | Sinaloa | 13217 | 2307 | 10162 | 748 | 25.1721 | -107.4795 | 2020-08-06 04:35:02 | Sinaloa, Mexico | ||
3612427 | 3612427 | 2020-08-06 | Mexico | Sinaloa | 13387 | 2334 | 10267 | 786 | 25.1721 | -107.4795 | 2020-08-07 04:35:11 | Sinaloa, Mexico | ||
458742 | 458742 | 2020-08-07 | Mexico | Sinaloa | 13583 | 2348 | 10415 | 820 | 25.1721 | -107.4795 | 2020-08-08 04:34:53 | Sinaloa, Mexico | ||
371558 | 371558 | 2020-08-08 | Mexico | Sinaloa | 13729 | 2380 | 10510 | 839 | 25.1721 | -107.4795 | 2020-08-09 04:34:54 | Sinaloa, Mexico | ||
3923390 | 3923390 | 2020-08-09 | Mexico | Sinaloa | 13750 | 2390 | 10563 | 797 | 25.1721 | -107.4795 | 2020-08-10 04:34:55 | Sinaloa, Mexico | ||
1920581 | 1920581 | 2020-08-10 | Mexico | Sinaloa | 13817 | 2421 | 10681 | 715 | 25.1721 | -107.4795 | 2020-08-11 04:35:08 | Sinaloa, Mexico | ||
662395 | 662395 | 2020-08-11 | Mexico | Sinaloa | 14106 | 2465 | 10981 | 660 | 25.1721 | -107.4795 | 2020-08-12 04:27:29 | Sinaloa, Mexico | ||
3531547 | 3531547 | 2020-08-12 | Mexico | Sinaloa | 14174 | 2502 | 11017 | 655 | 25.1721 | -107.4795 | 2020-08-13 04:29:15 | Sinaloa, Mexico | ||
582928 | 582928 | 2020-08-13 | Mexico | Sinaloa | 14217 | 2512 | 11009 | 696 | 25.1721 | -107.4795 | 2020-08-14 04:51:19 | Sinaloa, Mexico | ||
1612344 | 1612344 | 2020-08-14 | Mexico | Sinaloa | 14340 | 2526 | 11118 | 696 | 25.1721 | -107.4795 | 2020-08-15 04:27:31 | Sinaloa, Mexico | ||
146069 | 146069 | 2020-08-15 | Mexico | Sinaloa | 14466 | 2545 | 11256 | 665 | 25.1721 | -107.4795 | 2020-08-16 04:27:42 | Sinaloa, Mexico | ||
1556067 | 1556067 | 2020-08-16 | Mexico | Sinaloa | 14495 | 2550 | 11282 | 663 | 25.1721 | -107.4795 | 2020-08-17 04:27:20 | Sinaloa, Mexico | ||
837709 | 837709 | 2020-08-17 | Mexico | Sinaloa | 14521 | 2555 | 11379 | 587 | 25.1721 | -107.4795 | 2020-08-18 04:27:56 | Sinaloa, Mexico | ||
3178105 | 3178105 | 2020-08-18 | Mexico | Sinaloa | 14776 | 2582 | 11554 | 640 | 25.1721 | -107.4795 | 2020-08-19 04:27:00 | Sinaloa, Mexico | ||
206351 | 206351 | 2020-08-19 | Mexico | Sinaloa | 14858 | 2594 | 11601 | 663 | 25.1721 | -107.4795 | 2020-08-20 04:27:43 | Sinaloa, Mexico | ||
3484402 | 3484402 | 2020-08-20 | Mexico | Sinaloa | 15020 | 2610 | 11743 | 667 | 25.1721 | -107.4795 | 2020-08-21 04:27:41 | Sinaloa, Mexico | ||
1479653 | 1479653 | 2020-08-21 | Mexico | Sinaloa | 15159 | 2627 | 11835 | 697 | 25.1721 | -107.4795 | 2020-08-22 04:27:49 | Sinaloa, Mexico | ||
2299546 | 2299546 | 2020-08-22 | Mexico | Sinaloa | 15288 | 2652 | 11916 | 720 | 25.1721 | -107.4795 | 2020-08-23 04:27:48 | Sinaloa, Mexico | ||
2215764 | 2215764 | 2020-08-23 | Mexico | Sinaloa | 15359 | 2666 | 11982 | 711 | 25.1721 | -107.4795 | 2020-08-24 04:27:56 | Sinaloa, Mexico | ||
2991369 | 2991369 | 2020-08-24 | Mexico | Sinaloa | 15386 | 2671 | 12105 | 610 | 25.1721 | -107.4795 | 2020-08-25 04:28:02 | Sinaloa, Mexico | ||
3562665 | 3562665 | 2020-08-25 | Mexico | Sinaloa | 15558 | 2694 | 12215 | 649 | 25.1721 | -107.4795 | 2020-08-26 04:28:11 | Sinaloa, Mexico | ||
1996741 | 1996741 | 2020-08-26 | Mexico | Sinaloa | 15647 | 2709 | 12278 | 660 | 25.1721 | -107.4795 | 2020-08-27 04:28:15 | Sinaloa, Mexico | ||
2510281 | 2510281 | 2020-08-27 | Mexico | Sinaloa | 15747 | 2724 | 12339 | 684 | 25.1721 | -107.4795 | 2020-08-28 04:28:11 | Sinaloa, 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]);