johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
342 rows where active = 596 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 296
- Russia 11
- Colombia 6
- Mexico 4
- Chile 3
- Denmark 3
- Italy 3
- India 2
- Japan 2
- Malaysia 2
- Australia 1
- Congo (Kinshasa) 1
- Croatia 1
- Guinea-Bissau 1
- Mali 1
- Mauritania 1
- Netherlands 1
- North Macedonia 1
- Pakistan 1
- Sweden 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
829447 | 829447 | 2021-07-09 | Colombia | La Guajira | 40154 | 1270 | 38288 | 596 | 11.3548 | -72.5205 | 2021-07-10 04:21:25 | La Guajira, Colombia | ||
829437 | 829437 | 2021-07-09 | Colombia | Caqueta | 20979 | 807 | 19576 | 596 | 0.8699 | -73.8419 | 2021-07-10 04:21:25 | Caqueta, Colombia | ||
1440454 | 1440454 | 2021-07-07 | Croatia | 360483 | 8224 | 351663 | 596 | 45.1 | 15.2 | 2021-07-08 04:21:26 | Croatia | |||
2589785 | 2589785 | 2021-06-27 | Chile | Arica y Parinacota | 24915 | 475 | 23844 | 596 | -18.594 | -69.4785 | 2021-06-28 04:21:29 | Arica y Parinacota, Chile | ||
107301 | 107301 | 2021-06-19 | Colombia | La Guajira | 38456 | 1213 | 36647 | 596 | 11.3548 | -72.5205 | 2021-06-20 04:21:48 | La Guajira, Colombia | ||
2315291 | 2315291 | 2021-06-04 | Italy | P.A. Bolzano | 72987 | 1176 | 71215 | 596 | 46.49933453 | 11.35662422 | 2021-06-05 04:23:03 | P.A. Bolzano, Italy | ||
1552007 | 1552007 | 2021-05-08 | Japan | Shiga | 4118 | 67 | 3455 | 596 | 35.21582700000001 | 136.138064 | 2021-05-09 04:20:35 | Shiga, Japan | ||
1290195 | 1290195 | 2021-03-29 | Russia | Bryansk Oblast | 35465 | 283 | 34586 | 596 | 52.8873315 | 33.41585300000001 | 2021-03-30 04:26:23 | Bryansk Oblast, Russia | ||
3962722 | 3962722 | 2021-03-10 | Russia | Kalmykia Republic | 19325 | 302 | 18427 | 596 | 46.2313018 | 45.3275745 | 2021-03-11 05:25:48 | Kalmykia Republic, Russia | ||
3667593 | 3667593 | 2021-03-06 | India | Uttarakhand | 97363 | 1694 | 95073 | 596 | 30.156447 | 79.197608 | 2021-03-07 05:21:54 | Uttarakhand, India | ||
2210416 | 2210416 | 2021-03-04 | US | Puerto Rico | Quebradillas | 72115 | 596 | 0 | 0 | 596 | 18.439692 | -66.926113 | 2021-03-05 05:26:29 | Quebradillas, Puerto Rico, US |
2208993 | 2208993 | 2021-03-04 | US | Kansas | Sherman | 20181 | 607 | 11 | 0 | 596 | 39.35147699 | -101.7197624 | 2021-03-05 05:26:29 | Sherman, Kansas, US |
1091414 | 1091414 | 2021-03-03 | US | Kansas | Sherman | 20181 | 607 | 11 | 0 | 596 | 39.35147699 | -101.7197624 | 2021-03-04 05:24:24 | Sherman, Kansas, US |
3255486 | 3255486 | 2021-03-02 | US | Kansas | Sherman | 20181 | 607 | 11 | 0 | 596 | 39.35147699 | -101.7197624 | 2021-03-03 05:23:28 | Sherman, Kansas, US |
1001942 | 1001942 | 2021-03-01 | US | West Virginia | Roane | 54087 | 603 | 7 | 0 | 596 | 38.71622686 | -81.35243568 | 2021-03-02 05:23:30 | Roane, West Virginia, US |
1001595 | 1001595 | 2021-03-01 | US | Texas | Martin | 48317 | 570 | 18 | 0 | 596 | 32.30600051 | -101.9513518 | 2021-03-02 05:23:30 | Martin, Texas, US |
999778 | 999778 | 2021-03-01 | US | Kansas | Sherman | 20181 | 607 | 11 | 0 | 596 | 39.35147699 | -101.7197624 | 2021-03-02 05:23:30 | Sherman, Kansas, US |
2371000 | 2371000 | 2021-02-28 | US | West Virginia | Roane | 54087 | 603 | 7 | 0 | 596 | 38.71622686 | -81.35243568 | 2021-03-01 05:23:01 | Roane, West Virginia, US |
2370653 | 2370653 | 2021-02-28 | US | Texas | Martin | 48317 | 570 | 18 | 0 | 596 | 32.30600051 | -101.9513518 | 2021-03-01 05:23:01 | Martin, Texas, US |
2369302 | 2369302 | 2021-02-28 | US | Mississippi | Jefferson | 28063 | 623 | 27 | 0 | 596 | 31.73397872 | -91.03764977 | 2021-03-01 05:23:01 | Jefferson, Mississippi, US |
2185436 | 2185436 | 2021-02-26 | US | Mississippi | Wilkinson | 28157 | 622 | 26 | 0 | 596 | 31.16078225 | -91.31018819 | 2021-02-27 05:22:28 | Wilkinson, Mississippi, US |
2185049 | 2185049 | 2021-02-26 | US | Kentucky | Trimble | 21223 | 599 | 3 | 0 | 596 | 38.61056487 | -85.33775972 | 2021-02-27 05:22:28 | Trimble, Kentucky, US |
2183512 | 2183512 | 2021-02-26 | Guinea-Bissau | 3241 | 48 | 2597 | 596 | 11.8037 | -15.1804 | 2021-02-27 05:22:28 | Guinea-Bissau | |||
1859858 | 1859858 | 2021-02-25 | US | Mississippi | Wilkinson | 28157 | 622 | 26 | 0 | 596 | 31.16078225 | -91.31018819 | 2021-02-26 05:22:40 | Wilkinson, Mississippi, US |
1859471 | 1859471 | 2021-02-25 | US | Kentucky | Trimble | 21223 | 599 | 3 | 0 | 596 | 38.61056487 | -85.33775972 | 2021-02-26 05:22:40 | Trimble, Kentucky, US |
282594 | 282594 | 2021-02-24 | US | North Dakota | Ransom | 38073 | 612 | 16 | 0 | 596 | 46.45621782 | -97.65742504 | 2021-02-25 05:24:57 | Ransom, North Dakota, US |
282036 | 282036 | 2021-02-24 | US | Mississippi | Wilkinson | 28157 | 622 | 26 | 0 | 596 | 31.16078225 | -91.31018819 | 2021-02-25 05:24:57 | Wilkinson, Mississippi, US |
1939337 | 1939337 | 2021-02-23 | US | South Dakota | Moody | 46101 | 612 | 16 | 0 | 596 | 44.02266214 | -96.67081159 | 2021-02-24 05:29:16 | Moody, South Dakota, US |
1938304 | 1938304 | 2021-02-23 | US | Mississippi | Wilkinson | 28157 | 622 | 26 | 0 | 596 | 31.16078225 | -91.31018819 | 2021-02-24 05:29:16 | Wilkinson, Mississippi, US |
533592 | 533592 | 2021-02-22 | US | South Dakota | Moody | 46101 | 612 | 16 | 0 | 596 | 44.02266214 | -96.67081159 | 2021-02-23 05:23:41 | Moody, South Dakota, US |
185485 | 185485 | 2021-02-21 | US | Washington | Pend Oreille | 53051 | 601 | 5 | 0 | 596 | 48.53234021 | -117.2741804 | 2021-02-22 05:24:21 | Pend Oreille, Washington, US |
184926 | 184926 | 2021-02-21 | US | South Dakota | Moody | 46101 | 612 | 16 | 0 | 596 | 44.02266214 | -96.67081159 | 2021-02-22 05:24:21 | Moody, South Dakota, US |
745759 | 745759 | 2021-02-20 | US | Washington | Pend Oreille | 53051 | 601 | 5 | 0 | 596 | 48.53234021 | -117.2741804 | 2021-02-21 05:24:33 | Pend Oreille, Washington, US |
745200 | 745200 | 2021-02-20 | US | South Dakota | Moody | 46101 | 612 | 16 | 0 | 596 | 44.02266214 | -96.67081159 | 2021-02-21 05:24:33 | Moody, South Dakota, US |
474298 | 474298 | 2021-02-19 | US | South Dakota | Moody | 46101 | 612 | 16 | 0 | 596 | 44.02266214 | -96.67081159 | 2021-02-20 05:22:51 | Moody, South Dakota, US |
1156007 | 1156007 | 2021-02-18 | US | South Dakota | Moody | 46101 | 612 | 16 | 0 | 596 | 44.02266214 | -96.67081159 | 2021-02-19 05:24:16 | Moody, South Dakota, US |
3542214 | 3542214 | 2021-02-12 | US | Puerto Rico | Naguabo | 72103 | 596 | 0 | 0 | 596 | 18.230637 | -65.753897 | 2021-02-13 05:22:12 | Naguabo, Puerto Rico, US |
3541007 | 3541007 | 2021-02-12 | US | Maine | Knox | 23013 | 601 | 5 | 0 | 596 | 44.11486325 | -69.10529169 | 2021-02-13 05:22:12 | Knox, Maine, US |
2641229 | 2641229 | 2021-02-11 | US | West Virginia | Tyler | 54095 | 600 | 4 | 0 | 596 | 39.46811972 | -80.88772676 | 2021-02-12 05:23:29 | Tyler, West Virginia, US |
617374 | 617374 | 2021-02-08 | Malaysia | Terengganu | 2620 | 5 | 2019 | 596 | 5.3117 | 103.1324 | 2021-02-09 05:23:30 | Terengganu, Malaysia | ||
617061 | 617061 | 2021-02-08 | US | Virginia | Northumberland | 51133 | 609 | 13 | 0 | 596 | 37.89202088 | -76.41949732 | 2021-02-09 05:23:30 | Northumberland, Virginia, US |
1675055 | 1675055 | 2021-02-07 | US | Oregon | Baker | 41001 | 603 | 7 | 0 | 596 | 44.70915557 | -117.6749883 | 2021-02-08 05:22:39 | Baker, Oregon, US |
1591050 | 1591050 | 2021-02-05 | US | South Dakota | Kingsbury | 46077 | 609 | 13 | 0 | 596 | 44.36956169 | -97.4913945 | 2021-02-06 05:23:55 | Kingsbury, South Dakota, US |
793680 | 793680 | 2021-02-04 | US | Virginia | Bland | 51021 | 605 | 9 | 0 | 596 | 37.13128068 | -81.13599391 | 2021-02-05 05:22:38 | Bland, Virginia, US |
343055 | 343055 | 2021-02-03 | US | Puerto Rico | Villalba | 72149 | 596 | 0 | 0 | 596 | 18.127951 | -66.473115 | 2021-02-04 05:22:26 | Villalba, Puerto Rico, US |
341219 | 341219 | 2021-02-03 | US | Idaho | Power | 16077 | 603 | 7 | 0 | 596 | 42.69254894 | -112.83957420000002 | 2021-02-04 05:22:26 | Power, Idaho, US |
1687281 | 1687281 | 2021-02-02 | US | Puerto Rico | Villalba | 72149 | 596 | 0 | 0 | 596 | 18.127951 | -66.473115 | 2021-02-03 05:22:52 | Villalba, Puerto Rico, US |
3153677 | 3153677 | 2021-01-27 | Mauritania | 16506 | 419 | 15491 | 596 | 21.0079 | -10.9408 | 2021-01-28 05:22:24 | Mauritania | |||
1762586 | 1762586 | 2021-01-24 | US | Virginia | Amelia | 51007 | 605 | 9 | 0 | 596 | 37.34081025 | -77.98584649 | 2021-01-25 05:22:16 | Amelia, Virginia, US |
1761017 | 1761017 | 2021-01-24 | US | Minnesota | Koochiching | 27071 | 606 | 10 | 0 | 596 | 48.24539665 | -93.78352843 | 2021-01-25 05:22:16 | Koochiching, Minnesota, US |
2468853 | 2468853 | 2021-01-22 | US | Nebraska | Clay | 31035 | 607 | 11 | 0 | 596 | 40.52439441 | -98.05126296 | 2021-01-23 05:22:03 | Clay, Nebraska, US |
1096911 | 1096911 | 2021-01-20 | US | South Carolina | McCormick | 45065 | 607 | 11 | 0 | 596 | 33.90161443 | -82.30794338 | 2021-01-21 05:22:01 | McCormick, South Carolina, US |
1096166 | 1096166 | 2021-01-20 | US | Nebraska | Johnson | 31097 | 603 | 7 | 0 | 596 | 40.39257596 | -96.26522753 | 2021-01-21 05:22:01 | Johnson, Nebraska, US |
1095632 | 1095632 | 2021-01-20 | US | Maine | Franklin | 23007 | 603 | 7 | 0 | 596 | 44.97330019 | -70.44381045 | 2021-01-21 05:22:01 | Franklin, Maine, US |
911621 | 911621 | 2021-01-19 | US | Washington | Pacific | 53049 | 604 | 8 | 0 | 596 | 46.55418369 | -123.7285716 | 2021-01-20 05:21:54 | Pacific, Washington, US |
909960 | 909960 | 2021-01-19 | US | Mississippi | Choctaw | 28019 | 609 | 13 | 0 | 596 | 33.34598242 | -89.24809382 | 2021-01-20 05:21:54 | Choctaw, Mississippi, US |
3504603 | 3504603 | 2021-01-17 | US | Iowa | Worth | 19195 | 599 | 3 | 0 | 596 | 43.37750768 | -93.26087602 | 2021-01-18 05:22:34 | Worth, Iowa, US |
3103620 | 3103620 | 2021-01-16 | US | New Mexico | Colfax | 35007 | 624 | 28 | 0 | 596 | 36.60569702 | -104.64726740000002 | 2021-01-17 05:22:17 | Colfax, New Mexico, US |
3103441 | 3103441 | 2021-01-16 | US | Montana | Madison | 30057 | 599 | 3 | 0 | 596 | 45.30080065 | -111.9173017 | 2021-01-17 05:22:17 | Madison, Montana, US |
3517378 | 3517378 | 2021-01-15 | US | Montana | Blaine | 30005 | 619 | 23 | 0 | 596 | 48.43175214 | -108.9582723 | 2021-01-16 05:22:40 | Blaine, Montana, US |
3516055 | 3516055 | 2021-01-15 | US | Colorado | Yuma | 8125 | 759 | 16 | 0 | 596 | 40.00346839 | -102.4258673 | 2021-01-16 05:22:40 | Yuma, Colorado, US |
3881550 | 3881550 | 2021-01-14 | US | Montana | Blaine | 30005 | 619 | 23 | 0 | 596 | 48.43175214 | -108.9582723 | 2021-01-15 05:22:24 | Blaine, Montana, US |
3880974 | 3880974 | 2021-01-14 | US | Kentucky | Hancock | 21091 | 607 | 11 | 0 | 596 | 37.83766422 | -86.78280584 | 2021-01-15 05:22:24 | Hancock, Kentucky, US |
3310177 | 3310177 | 2021-01-13 | US | Montana | Blaine | 30005 | 619 | 23 | 0 | 596 | 48.43175214 | -108.9582723 | 2021-01-14 05:22:32 | Blaine, Montana, US |
776322 | 776322 | 2021-01-12 | US | Montana | Blaine | 30005 | 619 | 23 | 0 | 596 | 48.43175214 | -108.9582723 | 2021-01-13 05:22:15 | Blaine, Montana, US |
192043 | 192043 | 2021-01-11 | US | Montana | Blaine | 30005 | 619 | 23 | 0 | 596 | 48.43175214 | -108.9582723 | 2021-01-12 05:22:15 | Blaine, Montana, US |
2627846 | 2627846 | 2021-01-10 | US | Montana | Blaine | 30005 | 619 | 23 | 0 | 596 | 48.43175214 | -108.9582723 | 2021-01-11 05:21:50 | Blaine, Montana, US |
3901934 | 3901934 | 2021-01-09 | US | Montana | Blaine | 30005 | 619 | 23 | 0 | 596 | 48.43175214 | -108.9582723 | 2021-01-10 05:22:12 | Blaine, Montana, US |
3901504 | 3901504 | 2021-01-09 | US | Maine | Hancock | 23009 | 619 | 23 | 0 | 596 | 44.59816444 | -68.38401854 | 2021-01-10 05:22:12 | Hancock, Maine, US |
155751 | 155751 | 2021-01-08 | US | Minnesota | Wilkin | 27167 | 605 | 9 | 0 | 596 | 46.35721532 | -96.4684375 | 2021-01-09 05:22:18 | Wilkin, Minnesota, US |
3036680 | 3036680 | 2021-01-05 | US | North Dakota | Bottineau | 38009 | 621 | 20 | 0 | 596 | 48.79106111 | -100.8378166 | 2021-01-06 05:22:16 | Bottineau, North Dakota, US |
3232099 | 3232099 | 2021-01-03 | US | Michigan | Manistee | 26101 | 612 | 16 | 0 | 596 | 44.33352407 | -86.05626916 | 2021-01-04 05:22:02 | Manistee, Michigan, US |
3230992 | 3230992 | 2021-01-03 | US | California | Inyo | 6027 | 623 | 20 | 0 | 596 | 36.51112084 | -117.41119779999998 | 2021-01-04 05:22:02 | Inyo, California, US |
2229168 | 2229168 | 2021-01-02 | US | Michigan | Manistee | 26101 | 612 | 16 | 0 | 596 | 44.33352407 | -86.05626916 | 2021-01-03 05:22:52 | Manistee, Michigan, US |
3765073 | 3765073 | 2020-12-28 | US | West Virginia | Monroe | 54063 | 607 | 11 | 0 | 596 | 37.56274716 | -80.54577965 | 2020-12-29 05:22:37 | Monroe, West Virginia, US |
3764918 | 3764918 | 2020-12-28 | US | Virginia | Goochland | 51075 | 603 | 7 | 0 | 596 | 37.71714806 | -77.90381514 | 2020-12-29 05:22:37 | Goochland, Virginia, US |
3764901 | 3764901 | 2020-12-28 | US | Virginia | Dickenson | 51051 | 600 | 4 | 0 | 596 | 37.12560977 | -82.35124171 | 2020-12-29 05:22:37 | Dickenson, Virginia, US |
3778671 | 3778671 | 2020-12-27 | US | Georgia | Clinch | 13065 | 610 | 14 | 0 | 596 | 30.91395822 | -82.70432472 | 2020-12-28 05:22:06 | Clinch, Georgia, US |
2224723 | 2224723 | 2020-12-26 | US | Iowa | Monroe | 19135 | 612 | 16 | 0 | 596 | 41.02988815 | -92.8690667 | 2020-12-27 05:22:55 | Monroe, Iowa, US |
3772579 | 3772579 | 2020-12-22 | US | Puerto Rico | Aguada | 72003 | 596 | 0 | 0 | 596 | 18.360255 | -67.17513100000001 | 2020-12-23 05:22:03 | Aguada, Puerto Rico, US |
3771095 | 3771095 | 2020-12-22 | US | Iowa | Osceola | 19143 | 603 | 7 | 0 | 596 | 43.37824276 | -95.62422844 | 2020-12-23 05:22:03 | Osceola, Iowa, US |
929469 | 929469 | 2020-12-21 | US | Mississippi | Benton | 28009 | 616 | 20 | 0 | 596 | 34.81681228 | -89.18945516 | 2020-12-22 05:22:33 | Benton, Mississippi, US |
928911 | 928911 | 2020-12-21 | US | Iowa | Osceola | 19143 | 602 | 6 | 0 | 596 | 43.37824276 | -95.62422844 | 2020-12-22 05:22:33 | Osceola, Iowa, US |
2121763 | 2121763 | 2020-12-20 | US | Nebraska | Custer | 31041 | 610 | 14 | 0 | 596 | 41.39374521 | -99.72805369 | 2020-12-21 05:27:58 | Custer, Nebraska, US |
2934116 | 2934116 | 2020-12-19 | US | South Dakota | Tripp | 46123 | 606 | 10 | 0 | 596 | 43.34459388 | -99.8854891 | 2020-12-20 05:27:32 | Tripp, South Dakota, US |
2129799 | 2129799 | 2020-12-17 | US | Mississippi | Kemper | 28069 | 615 | 19 | 0 | 596 | 32.75462946 | -88.64105766 | 2020-12-18 05:28:18 | Kemper, Mississippi, US |
3153015 | 3153015 | 2020-12-16 | US | Washington | Clallam | 53009 | 600 | 4 | 0 | 596 | 48.04754642 | -123.9226319 | 2020-12-17 05:28:12 | Clallam, Washington, US |
3150349 | 3150349 | 2020-12-16 | US | Georgia | Candler | 13043 | 631 | 35 | 0 | 596 | 32.40209349 | -82.07702563 | 2020-12-17 05:28:12 | Candler, Georgia, US |
1037796 | 1037796 | 2020-12-15 | US | Washington | Clallam | 53009 | 600 | 4 | 0 | 596 | 48.04754642 | -123.9226319 | 2020-12-16 05:28:04 | Clallam, Washington, US |
1752719 | 1752719 | 2020-12-14 | US | Kentucky | Powell | 21197 | 596 | 0 | 0 | 596 | 37.83218794 | -83.82553961 | 2020-12-15 05:26:38 | Powell, Kentucky, US |
3849189 | 3849189 | 2020-12-13 | US | Kentucky | Harrison | 21097 | 597 | 1 | 0 | 596 | 38.44188174 | -84.32869741 | 2020-12-14 05:26:27 | Harrison, Kentucky, US |
862404 | 862404 | 2020-12-11 | US | Minnesota | Marshall | 27089 | 607 | 11 | 0 | 596 | 48.35825983 | -96.37017407 | 2020-12-12 05:26:19 | Marshall, Minnesota, US |
861269 | 861269 | 2020-12-11 | US | Colorado | Bent | 8011 | 772 | 15 | 0 | 596 | 37.95474293 | -103.0720195 | 2020-12-12 05:26:19 | Bent, Colorado, US |
860476 | 860476 | 2020-12-11 | Chile | Valparaiso | 33320 | 1177 | 31547 | 596 | -33.0472 | -71.6127 | 2020-12-12 05:26:19 | Valparaiso, Chile | ||
1602212 | 1602212 | 2020-12-10 | US | Montana | Jefferson | 30043 | 597 | 1 | 0 | 596 | 46.14907081 | -112.094396 | 2020-12-11 05:26:59 | Jefferson, Montana, US |
1601412 | 1601412 | 2020-12-10 | US | Iowa | Ida | 19093 | 612 | 16 | 0 | 596 | 42.38696136 | -95.51355387 | 2020-12-11 05:26:59 | Ida, Iowa, US |
2976654 | 2976654 | 2020-12-09 | US | Kentucky | Magoffin | 21153 | 597 | 1 | 0 | 596 | 37.70820545 | -83.0657714 | 2020-12-10 05:26:19 | Magoffin, Kentucky, US |
2975704 | 2975704 | 2020-12-09 | US | Arkansas | Fulton | 5049 | 609 | 13 | 0 | 596 | 36.38177105 | -91.81729127 | 2020-12-10 05:26:19 | Fulton, Arkansas, US |
1821535 | 1821535 | 2020-12-08 | US | Puerto Rico | Manati | 72091 | 596 | 0 | 0 | 596 | 18.420473 | -66.490461 | 2020-12-09 05:28:01 | Manati, Puerto Rico, US |
2347977 | 2347977 | 2020-12-07 | US | California | Mono | 6051 | 601 | 3 | 0 | 596 | 37.93899289 | -118.8872409 | 2020-12-08 05:27:42 | Mono, California, US |
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]);