johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
111 rows where active = 2010 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- US 90
- Cameroon 6
- Russia 5
- Chile 2
- Colombia 1
- Czechia 1
- Germany 1
- India 1
- Kazakhstan 1
- Kyrgyzstan 1
- Mexico 1
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015199 | 3015199 | 2021-08-01 | Colombia | Huila | 85600 | 2946 | 80644 | 2010 | 2.5359 | -75.5277 | 2021-08-02 04:21:36 | Huila, Colombia | ||
3137738 | 3137738 | 2021-07-23 | Russia | Amur Oblast | 26652 | 331 | 24311 | 2010 | 52.8032368 | 128.437295 | 2021-07-24 00:21:36 | Amur Oblast, Russia | ||
3659468 | 3659468 | 2021-07-11 | Czechia | 1669351 | 30331 | 1637010 | 2010 | 49.8175 | 15.473 | 2021-07-12 04:21:34 | Czechia | |||
2072164 | 2072164 | 2021-07-02 | Russia | Saratov Oblast | 66575 | 1354 | 63211 | 2010 | 51.6520555 | 46.86319520000001 | 2021-07-03 04:21:37 | Saratov Oblast, Russia | ||
2717187 | 2717187 | 2021-06-10 | Russia | Krasnodar Krai | 49395 | 3140 | 44245 | 2010 | 45.7684014 | 39.0261044 | 2021-06-11 04:23:20 | Krasnodar Krai, Russia | ||
3954451 | 3954451 | 2021-05-11 | India | Mizoram | 8035 | 23 | 6002 | 2010 | 23.309381 | 92.83822 | 2021-05-12 04:21:29 | Mizoram, India | ||
3668998 | 3668998 | 2021-03-06 | US | Kentucky | Carter | 21043 | 2034 | 24 | 0 | 2010 | 38.31690743 | -83.05092385 | 2021-03-07 05:21:54 | Carter, Kentucky, US |
3254998 | 3254998 | 2021-03-02 | US | Georgia | Pike | 13231 | 2041 | 31 | 0 | 2010 | 33.09310242 | -84.38790389 | 2021-03-03 05:23:28 | Pike, Georgia, US |
3065796 | 3065796 | 2021-02-27 | Chile | Valparaiso | 49881 | 1591 | 46280 | 2010 | -33.0472 | -71.6127 | 2021-02-28 05:22:20 | Valparaiso, Chile | ||
1939753 | 1939753 | 2021-02-23 | US | Virginia | Buckingham | 51029 | 2032 | 22 | 0 | 2010 | 37.57242268 | -78.52518834 | 2021-02-24 05:29:16 | Buckingham, Virginia, US |
531076 | 531076 | 2021-02-22 | US | Alabama | Hale | 1065 | 2074 | 64 | 0 | 2010 | 32.76039258 | -87.63284988 | 2021-02-23 05:23:41 | Hale, Alabama, US |
183924 | 183924 | 2021-02-21 | US | Missouri | Crawford | 29055 | 2039 | 29 | 0 | 2010 | 37.97663738 | -91.30528104 | 2021-02-22 05:24:21 | Crawford, Missouri, US |
1154465 | 1154465 | 2021-02-18 | US | Kansas | Sumner | 20191 | 2056 | 46 | 0 | 2010 | 37.23682549 | -97.47721621 | 2021-02-19 05:24:16 | Sumner, Kansas, US |
3602901 | 3602901 | 2021-02-17 | US | Missouri | Audrain | 29007 | 2064 | 54 | 0 | 2010 | 39.215877 | -91.84242683 | 2021-02-18 05:22:58 | Audrain, Missouri, US |
3602385 | 3602385 | 2021-02-17 | US | Kansas | Sumner | 20191 | 2056 | 46 | 0 | 2010 | 37.23682549 | -97.47721621 | 2021-02-18 05:22:58 | Sumner, Kansas, US |
3600804 | 3600804 | 2021-02-17 | Cameroon | 32098 | 479 | 29609 | 2010 | 3.848 | 11.5021 | 2021-02-18 05:22:58 | Cameroon | |||
3051908 | 3051908 | 2021-02-16 | US | Minnesota | Meeker | 27093 | 2043 | 33 | 0 | 2010 | 45.12328869 | -94.52839455 | 2021-02-17 05:23:10 | Meeker, Minnesota, US |
3051520 | 3051520 | 2021-02-16 | US | Kansas | Sumner | 20191 | 2053 | 43 | 0 | 2010 | 37.23682549 | -97.47721621 | 2021-02-17 05:23:10 | Sumner, Kansas, US |
3049939 | 3049939 | 2021-02-16 | Cameroon | 32098 | 479 | 29609 | 2010 | 3.848 | 11.5021 | 2021-02-17 05:23:10 | Cameroon | |||
1339619 | 1339619 | 2021-02-15 | US | Kansas | Sumner | 20191 | 2053 | 43 | 0 | 2010 | 37.23682549 | -97.47721621 | 2021-02-16 05:24:38 | Sumner, Kansas, US |
1338038 | 1338038 | 2021-02-15 | Cameroon | 32098 | 479 | 29609 | 2010 | 3.848 | 11.5021 | 2021-02-16 05:24:38 | Cameroon | |||
2283189 | 2283189 | 2021-02-14 | Cameroon | 32098 | 479 | 29609 | 2010 | 3.848 | 11.5021 | 2021-02-15 05:24:49 | Cameroon | |||
2677589 | 2677589 | 2021-02-13 | Cameroon | 32098 | 479 | 29609 | 2010 | 3.848 | 11.5021 | 2021-02-14 05:23:43 | Cameroon | |||
3541191 | 3541191 | 2021-02-12 | US | Minnesota | Meeker | 27093 | 2043 | 33 | 0 | 2010 | 45.12328869 | -94.52839455 | 2021-02-13 05:22:12 | Meeker, Minnesota, US |
3541090 | 3541090 | 2021-02-12 | US | Michigan | Huron | 26063 | 2067 | 57 | 0 | 2010 | 43.83353985 | -83.04078453 | 2021-02-13 05:22:12 | Huron, Michigan, US |
3539222 | 3539222 | 2021-02-12 | Cameroon | 32098 | 479 | 29609 | 2010 | 3.848 | 11.5021 | 2021-02-13 05:22:12 | Cameroon | |||
2638188 | 2638188 | 2021-02-11 | US | Arkansas | Columbia | 5027 | 2063 | 53 | 0 | 2010 | 33.21230701 | -93.22642793 | 2021-02-12 05:23:29 | Columbia, Arkansas, US |
1529961 | 1529961 | 2021-02-09 | US | Nebraska | Gage | 31067 | 2026 | 16 | 0 | 2010 | 40.26186809 | -96.68946704 | 2021-02-10 05:22:41 | Gage, Nebraska, US |
1672512 | 1672512 | 2021-02-07 | Kyrgyzstan | 85071 | 1426 | 81635 | 2010 | 41.20438 | 74.766098 | 2021-02-08 05:22:39 | Kyrgyzstan | |||
976886 | 976886 | 2021-02-06 | US | Missouri | Warren | 29219 | 2023 | 13 | 0 | 2010 | 38.76529479 | -91.16124662 | 2021-02-07 05:23:00 | Warren, Missouri, US |
343243 | 343243 | 2021-02-03 | US | Tennessee | Morgan | 47129 | 2203 | 22 | 0 | 2010 | 36.13248031 | -84.64880098 | 2021-02-04 05:22:26 | Morgan, Tennessee, US |
2213491 | 2213491 | 2021-01-30 | US | Mississippi | Newton | 28101 | 2058 | 48 | 0 | 2010 | 32.40021118 | -89.11843336 | 2021-01-31 05:22:42 | Newton, Mississippi, US |
2483007 | 2483007 | 2021-01-28 | US | Illinois | Shelby | 17173 | 2042 | 32 | 0 | 2010 | 39.39133527 | -88.80611122 | 2021-01-29 05:22:23 | Shelby, Illinois, US |
2568707 | 2568707 | 2021-01-25 | US | Illinois | Union | 17181 | 2040 | 30 | 0 | 2010 | 37.47119609 | -89.25548938 | 2021-01-26 05:22:02 | Union, Illinois, US |
1761237 | 1761237 | 2021-01-24 | US | Missouri | Polk | 29167 | 2035 | 25 | 0 | 2010 | 37.6162296 | -93.39828174 | 2021-01-25 05:22:16 | Polk, Missouri, US |
2469219 | 2469219 | 2021-01-22 | US | North Dakota | Rolette | 38079 | 2023 | 27 | 0 | 2010 | 48.77245354 | -99.84097493 | 2021-01-23 05:22:03 | Rolette, North Dakota, US |
1094953 | 1094953 | 2021-01-20 | US | Georgia | Sumter | 13261 | 2087 | 77 | 0 | 2010 | 32.03650571 | -84.19821492 | 2021-01-21 05:22:01 | Sumter, Georgia, US |
910506 | 910506 | 2021-01-19 | US | North Carolina | Macon | 37113 | 2022 | 12 | 0 | 2010 | 35.14867843 | -83.41696617 | 2021-01-20 05:21:54 | Macon, North Carolina, US |
3516524 | 3516524 | 2021-01-15 | US | Indiana | Randolph | 18135 | 2067 | 57 | 0 | 2010 | 40.15734772 | -85.01139319 | 2021-01-16 05:22:40 | Randolph, Indiana, US |
3881107 | 3881107 | 2021-01-14 | US | Louisiana | Union | 22111 | 2079 | 69 | 0 | 2010 | 32.83121059 | -92.3749373 | 2021-01-15 05:22:24 | Union, Louisiana, US |
3310547 | 3310547 | 2021-01-13 | US | North Carolina | Person | 37145 | 2041 | 31 | 0 | 2010 | 36.38989032 | -78.97217358 | 2021-01-14 05:22:32 | Person, North Carolina, US |
190325 | 190325 | 2021-01-11 | Russia | Vladimir Oblast | 20409 | 544 | 17855 | 2010 | 56.0503336 | 40.6561633 | 2021-01-12 05:22:15 | Vladimir Oblast, Russia | ||
3900499 | 3900499 | 2021-01-09 | US | California | Humboldt | 6023 | 2032 | 22 | 0 | 2010 | 40.69923009 | -123.876044 | 2021-01-10 05:22:12 | Humboldt, California, US |
156324 | 156324 | 2021-01-08 | US | North Carolina | Pasquotank | 37139 | 2069 | 59 | 0 | 2010 | 36.26723798 | -76.25134778 | 2021-01-09 05:22:18 | Pasquotank, North Carolina, US |
2541196 | 2541196 | 2021-01-07 | Chile | Los Lagos | 28053 | 276 | 25767 | 2010 | -41.9198 | -72.1416 | 2021-01-08 05:22:42 | Los Lagos, Chile | ||
3035931 | 3035931 | 2021-01-05 | US | Michigan | Houghton | 26061 | 2043 | 33 | 0 | 2010 | 46.89988536 | -88.68495385 | 2021-01-06 05:22:16 | Houghton, Michigan, US |
1063807 | 1063807 | 2021-01-04 | US | Missouri | Stoddard | 29207 | 2044 | 34 | 0 | 2010 | 36.85571651 | -89.9444155 | 2021-01-05 05:21:49 | Stoddard, Missouri, US |
3232292 | 3232292 | 2021-01-03 | US | Mississippi | Tippah | 28139 | 2050 | 40 | 0 | 2010 | 34.76872156 | -88.90988194 | 2021-01-04 05:22:02 | Tippah, Mississippi, US |
1138831 | 1138831 | 2021-01-01 | US | Missouri | Saline | 29195 | 2033 | 23 | 0 | 2010 | 39.13734288 | -93.20259964 | 2021-01-02 05:22:33 | Saline, Missouri, US |
3698675 | 3698675 | 2020-12-31 | US | Texas | Polk | 48373 | 2106 | 58 | 0 | 2010 | 30.79472531 | -94.8276624 | 2021-01-01 05:23:07 | Polk, Texas, US |
3698659 | 3698659 | 2020-12-31 | US | Texas | Moore | 48341 | 2624 | 48 | 0 | 2010 | 35.83769242 | -101.8930281 | 2021-01-01 05:23:07 | Moore, Texas, US |
768174 | 768174 | 2020-12-29 | US | Mississippi | Yazoo | 28163 | 2060 | 50 | 0 | 2010 | 32.77890365 | -90.39656148 | 2020-12-30 05:22:34 | Yazoo, Mississippi, US |
767343 | 767343 | 2020-12-29 | US | Illinois | Perry | 17145 | 2053 | 43 | 0 | 2010 | 38.08510853 | -89.36856219 | 2020-12-30 05:22:34 | Perry, Illinois, US |
3778834 | 3778834 | 2020-12-27 | US | Idaho | Jefferson | 16051 | 2024 | 14 | 0 | 2010 | 43.82078483 | -112.3131749 | 2020-12-28 05:22:06 | Jefferson, Idaho, US |
2408393 | 2408393 | 2020-12-23 | US | Maryland | Calvert | 24009 | 2055 | 45 | 0 | 2010 | 38.53961642 | -76.56820632 | 2020-12-24 05:23:04 | Calvert, Maryland, US |
3151871 | 3151871 | 2020-12-16 | US | North Carolina | Beaufort | 37013 | 2068 | 58 | 0 | 2010 | 35.48531943 | -76.84325809 | 2020-12-17 05:28:12 | Beaufort, North Carolina, US |
1754176 | 1754176 | 2020-12-14 | US | Tennessee | Campbell | 47013 | 2030 | 27 | 0 | 2010 | 36.40355516 | -84.15108559999999 | 2020-12-15 05:26:38 | Campbell, Tennessee, US |
848096 | 848096 | 2020-12-12 | US | Oklahoma | Carter | 40019 | 2026 | 16 | 0 | 2010 | 34.25103751 | -97.28552485 | 2020-12-13 05:27:20 | Carter, Oklahoma, US |
2977891 | 2977891 | 2020-12-09 | US | Pennsylvania | Huntingdon | 42061 | 2074 | 64 | 0 | 2010 | 40.42162652 | -77.97673273 | 2020-12-10 05:26:19 | Huntingdon, Pennsylvania, US |
2349592 | 2349592 | 2020-12-07 | US | New Jersey | Salem | 34033 | 2109 | 99 | 0 | 2010 | 39.58719656 | -75.34696629999998 | 2020-12-08 05:27:42 | Salem, New Jersey, US |
3862185 | 3862185 | 2020-12-04 | US | North Carolina | Scotland | 37165 | 2053 | 43 | 0 | 2010 | 34.8386299 | -79.4757978 | 2020-12-05 05:27:36 | Scotland, North Carolina, US |
1585165 | 1585165 | 2020-11-30 | US | Illinois | Lee | 17103 | 2019 | 9 | 0 | 2010 | 41.74583951 | -89.29977132 | 2020-12-01 05:26:18 | Lee, Illinois, US |
395162 | 395162 | 2020-11-27 | US | Tennessee | Franklin | 47051 | 2061 | 34 | 0 | 2010 | 35.15634626 | -86.09201039 | 2020-11-28 05:25:50 | Franklin, Tennessee, US |
393444 | 393444 | 2020-11-27 | US | Iowa | Marion | 19125 | 2029 | 19 | 0 | 2010 | 41.33445101 | -93.09934783 | 2020-11-28 05:25:50 | Marion, Iowa, US |
926948 | 926948 | 2020-11-26 | US | Utah | Wasatch | 49051 | 2023 | 13 | 0 | 2010 | 40.33110236 | -111.1691419 | 2020-11-27 05:26:53 | Wasatch, Utah, US |
1975853 | 1975853 | 2020-11-25 | US | Utah | Wasatch | 49051 | 2023 | 13 | 0 | 2010 | 40.33110236 | -111.1691419 | 2020-11-26 05:27:44 | Wasatch, Utah, US |
125629 | 125629 | 2020-11-18 | US | Tennessee | Fayette | 47047 | 2056 | 37 | 0 | 2010 | 35.19615831 | -89.41399032 | 2020-11-19 05:25:23 | Fayette, Tennessee, US |
3171052 | 3171052 | 2020-11-16 | US | Kentucky | Laurel | 21125 | 2021 | 11 | 0 | 2010 | 37.10975748 | -84.11321779 | 2020-11-17 05:25:54 | Laurel, Kentucky, US |
2881620 | 2881620 | 2020-11-15 | US | Kentucky | Laurel | 21125 | 2021 | 11 | 0 | 2010 | 37.10975748 | -84.11321779 | 2020-11-16 05:25:57 | Laurel, Kentucky, US |
1731300 | 1731300 | 2020-11-08 | US | South Carolina | Laurens | 45059 | 2073 | 63 | 0 | 2010 | 34.48244419 | -82.00490796 | 2020-11-09 05:25:45 | Laurens, South Carolina, US |
1730773 | 1730773 | 2020-11-08 | US | North Carolina | Chatham | 37037 | 2073 | 63 | 0 | 2010 | 35.70394416 | -79.25541492 | 2020-11-09 05:25:45 | Chatham, North Carolina, US |
1729334 | 1729334 | 2020-11-08 | US | Georgia | Polk | 13233 | 2039 | 29 | 0 | 2010 | 34.00267074 | -85.18677781 | 2020-11-09 05:25:45 | Polk, Georgia, US |
1546148 | 1546148 | 2020-11-07 | US | New Mexico | Unassigned | 90035 | 2010 | 0 | 0 | 2010 | 36.60569702 | -108.7151824 | 2020-11-08 05:24:56 | Unassigned, New Mexico, US |
2245207 | 2245207 | 2020-10-30 | US | Mississippi | Oktibbeha | 28105 | 2066 | 56 | 0 | 2010 | 33.42491685 | -88.87905132 | 2020-10-31 04:24:44 | Oktibbeha, Mississippi, US |
757140 | 757140 | 2020-10-28 | US | South Dakota | Brown | 46013 | 2014 | 4 | 0 | 2010 | 45.58994323 | -98.35165355 | 2020-10-29 04:24:49 | Brown, South Dakota, US |
1454512 | 1454512 | 2020-10-27 | US | Missouri | Newton | 29145 | 2031 | 21 | 0 | 2010 | 36.90519407 | -94.3394104 | 2020-10-28 04:24:39 | Newton, Missouri, US |
1454240 | 1454240 | 2020-10-27 | US | Michigan | Monroe | 26115 | 2046 | 36 | 0 | 2010 | 41.92734151 | -83.53749864 | 2020-10-28 04:24:39 | Monroe, Michigan, US |
1054159 | 1054159 | 2020-10-23 | US | Alabama | Autauga | 1001 | 2040 | 30 | 0 | 2010 | 32.53952745 | -86.64408227 | 2020-10-24 04:24:46 | Autauga, Alabama, US |
2194025 | 2194025 | 2020-10-21 | US | Ohio | Allen | 39003 | 2080 | 70 | 0 | 2010 | 40.77285242 | -84.10802343 | 2020-10-22 04:24:27 | Allen, Ohio, US |
2858719 | 2858719 | 2020-10-16 | US | Missouri | Christian | 29043 | 2018 | 8 | 0 | 2010 | 36.9711783 | -93.18537118 | 2020-10-17 04:24:12 | Christian, Missouri, US |
788877 | 788877 | 2020-10-15 | US | Ohio | Trumbull | 39155 | 2125 | 115 | 0 | 2010 | 41.31735028 | -80.76109643 | 2020-10-16 04:24:01 | Trumbull, Ohio, US |
79963 | 79963 | 2020-10-14 | US | Georgia | Unassigned | 90013 | 2014 | 4 | 0 | 2010 | 34.91369188 | 0.0 | 2020-10-15 04:24:28 | Unassigned, Georgia, US |
1042956 | 1042956 | 2020-10-07 | US | Indiana | Vigo | 18167 | 2051 | 41 | 0 | 2010 | 39.42944561 | -87.39169027 | 2020-10-08 04:23:56 | Vigo, Indiana, US |
2516313 | 2516313 | 2020-10-03 | US | New Hampshire | Rockingham | 33015 | 2114 | 104 | 0 | 2010 | 42.98499744 | -71.12883377 | 2020-10-04 04:23:44 | Rockingham, New Hampshire, US |
3391699 | 3391699 | 2020-10-02 | US | North Carolina | Henderson | 37089 | 2074 | 64 | 0 | 2010 | 35.33788927 | -82.4766782 | 2020-10-03 04:23:40 | Henderson, North Carolina, US |
2381489 | 2381489 | 2020-10-01 | US | Missouri | Buchanan | 29021 | 2026 | 16 | 0 | 2010 | 39.65816401 | -94.80138942 | 2020-10-02 04:23:51 | Buchanan, Missouri, US |
1047675 | 1047675 | 2020-09-30 | US | Missouri | Buchanan | 29021 | 2026 | 16 | 0 | 2010 | 39.65816401 | -94.80138942 | 2020-10-01 04:23:42 | Buchanan, Missouri, US |
1046301 | 1046301 | 2020-09-30 | US | Arkansas | Lincoln | 5079 | 2025 | 15 | 0 | 2010 | 33.95317155 | -91.74002806 | 2020-10-01 04:23:42 | Lincoln, Arkansas, US |
968756 | 968756 | 2020-09-29 | US | Missouri | Buchanan | 29021 | 2026 | 16 | 0 | 2010 | 39.65816401 | -94.80138942 | 2020-09-30 04:23:33 | Buchanan, Missouri, US |
1517253 | 1517253 | 2020-09-28 | US | Missouri | Buchanan | 29021 | 2026 | 16 | 0 | 2010 | 39.65816401 | -94.80138942 | 2020-09-29 04:23:42 | Buchanan, Missouri, US |
2812835 | 2812835 | 2020-09-25 | Mexico | Jalisco | 25730 | 3180 | 20540 | 2010 | 20.6595 | -103.3494 | 2020-09-26 04:23:00 | Jalisco, Mexico | ||
2849576 | 2849576 | 2020-09-18 | US | Georgia | Barrow | 13013 | 2054 | 44 | 0 | 2010 | 33.99148694 | -83.71436292 | 2020-09-19 04:22:00 | Barrow, Georgia, US |
1176152 | 1176152 | 2020-09-10 | US | Tennessee | Robertson | 47147 | 2051 | 31 | 0 | 2010 | 36.52454807 | -86.87346725 | 2020-09-11 04:46:23 | Robertson, Tennessee, US |
1173904 | 1173904 | 2020-09-10 | US | Florida | Sumter | 12119 | 2069 | 59 | 0 | 2010 | 28.70181754 | -82.0794267 | 2020-09-11 04:46:23 | Sumter, Florida, US |
430986 | 430986 | 2020-09-07 | Uzbekistan | 43893 | 352 | 41531 | 2010 | 41.377491 | 64.585262 | 2020-09-08 04:28:25 | Uzbekistan | |||
3163665 | 3163665 | 2020-09-06 | US | Nebraska | Dakota | 31043 | 2053 | 43 | 0 | 2010 | 42.39040144 | -96.56656425 | 2020-09-07 04:28:30 | Dakota, Nebraska, US |
3163463 | 3163463 | 2020-09-06 | US | Mississippi | Washington | 28151 | 2077 | 67 | 0 | 2010 | 33.28392041 | -90.94196237 | 2020-09-07 04:28:30 | Washington, Mississippi, US |
3934048 | 3934048 | 2020-08-30 | US | Montana | Yellowstone | 30111 | 2053 | 43 | 0 | 2010 | 45.93955949 | -108.2691486 | 2020-08-31 04:28:27 | Yellowstone, Montana, US |
2219079 | 2219079 | 2020-08-23 | US | Washington | Clark | 53011 | 2066 | 56 | 0 | 2010 | 45.77568046 | -122.4829204 | 2020-08-24 04:27:56 | Clark, Washington, US |
1479479 | 1479479 | 2020-08-21 | Germany | Unknown | 2010 | 0 | 0 | 2010 | 2020-08-22 04:27:49 | Unknown, Germany |
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]);