johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
105 rows where active = 1944 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468026 | 3468026 | 2021-08-03 | Colombia | Huila | 85949 | 2978 | 81027 | 1944 | 2.5359 | -75.5277 | 2021-08-04 04:21:25 | Huila, Colombia | ||
3683633 | 3683633 | 2021-08-02 | Qatar | 226540 | 601 | 223995 | 1944 | 25.3548 | 51.1839 | 2021-08-03 04:21:39 | Qatar | |||
3125732 | 3125732 | 2021-06-28 | Russia | Mordovia Republic | 21897 | 325 | 19628 | 1944 | 54.4419829 | 44.4661144 | 2021-06-29 04:21:28 | Mordovia Republic, Russia | ||
2107758 | 2107758 | 2021-06-01 | Ukraine | Kirovohrad Oblast | 20296 | 801 | 17551 | 1944 | 48.5079 | 32.2623 | 2021-06-02 04:24:34 | Kirovohrad Oblast, Ukraine | ||
1913434 | 1913434 | 2021-05-20 | Russia | Mordovia Republic | 20645 | 266 | 18435 | 1944 | 54.4419829 | 44.4661144 | 2021-05-21 04:20:43 | Mordovia Republic, Russia | ||
3574617 | 3574617 | 2021-05-17 | Japan | Kyoto | 14776 | 196 | 12636 | 1944 | 35.253815 | 135.443341 | 2021-05-18 04:20:33 | Kyoto, Japan | ||
1872886 | 1872886 | 2021-05-15 | Guyana | 15168 | 338 | 12886 | 1944 | 4.860416000000002 | -58.93018000000001 | 2021-05-16 04:20:49 | Guyana | |||
983164 | 983164 | 2021-04-17 | Russia | Krasnoyarsk Krai | 68835 | 3358 | 63533 | 1944 | 63.3233807 | 97.0979974 | 2021-04-18 04:20:41 | Krasnoyarsk Krai, Russia | ||
3883797 | 3883797 | 2021-04-11 | Russia | Khabarovsk Krai | 51129 | 364 | 48821 | 1944 | 51.6312684 | 136.121524 | 2021-04-12 04:21:00 | Khabarovsk Krai, Russia | ||
3369577 | 3369577 | 2021-03-21 | Russia | Tambov Oblast | 28481 | 387 | 26150 | 1944 | 52.9019574 | 41.3578918 | 2021-03-22 05:25:43 | Tambov Oblast, Russia | ||
2211019 | 2211019 | 2021-03-04 | US | Virginia | Mecklenburg | 51117 | 2002 | 58 | 0 | 1944 | 36.67882005 | -78.36131056 | 2021-03-05 05:26:29 | Mecklenburg, Virginia, US |
2210744 | 2210744 | 2021-03-04 | US | Texas | Gray | 48179 | 2624 | 54 | 0 | 1944 | 35.40081878 | -100.8129222 | 2021-03-05 05:26:29 | Gray, Texas, US |
2184290 | 2184290 | 2021-02-26 | US | Florida | Madison | 12079 | 1986 | 42 | 0 | 1944 | 30.44396917 | -83.47398594 | 2021-02-27 05:22:28 | Madison, Florida, US |
1938126 | 1938126 | 2021-02-23 | US | Michigan | Sanilac | 26151 | 2020 | 76 | 0 | 1944 | 43.42406072 | -82.82055898 | 2021-02-24 05:29:16 | Sanilac, Michigan, US |
185504 | 185504 | 2021-02-21 | US | West Virginia | Brooke | 54009 | 1993 | 49 | 0 | 1944 | 40.27367263 | -80.57915332 | 2021-02-22 05:24:21 | Brooke, West Virginia, US |
472887 | 472887 | 2021-02-19 | US | Kentucky | Woodford | 21239 | 1948 | 4 | 0 | 1944 | 38.04178222 | -84.7417556 | 2021-02-20 05:22:51 | Woodford, Kentucky, US |
3050957 | 3050957 | 2021-02-16 | US | Georgia | Dodge | 13091 | 2038 | 94 | 0 | 1944 | 32.17265114 | -83.16948926 | 2021-02-17 05:23:10 | Dodge, Georgia, US |
1340057 | 1340057 | 2021-02-15 | US | Mississippi | Chickasaw | 28017 | 1994 | 50 | 0 | 1944 | 33.91983202 | -88.9481545 | 2021-02-16 05:24:38 | Chickasaw, Mississippi, US |
1339056 | 1339056 | 2021-02-15 | US | Georgia | Dodge | 13091 | 2036 | 92 | 0 | 1944 | 32.17265114 | -83.16948926 | 2021-02-16 05:24:38 | Dodge, Georgia, US |
1338765 | 1338765 | 2021-02-15 | US | Arkansas | Lawrence | 5075 | 1985 | 41 | 0 | 1944 | 36.04188196 | -91.10867198 | 2021-02-16 05:24:38 | Lawrence, Arkansas, US |
2284207 | 2284207 | 2021-02-14 | US | Georgia | Dodge | 13091 | 2035 | 91 | 0 | 1944 | 32.17265114 | -83.16948926 | 2021-02-15 05:24:49 | Dodge, Georgia, US |
2283916 | 2283916 | 2021-02-14 | US | Arkansas | Lawrence | 5075 | 1985 | 41 | 0 | 1944 | 36.04188196 | -91.10867198 | 2021-02-15 05:24:49 | Lawrence, Arkansas, US |
2678316 | 2678316 | 2021-02-13 | US | Arkansas | Lawrence | 5075 | 1985 | 41 | 0 | 1944 | 36.04188196 | -91.10867198 | 2021-02-14 05:23:43 | Lawrence, Arkansas, US |
1529339 | 1529339 | 2021-02-09 | US | Kentucky | Morgan | 21175 | 1944 | 0 | 0 | 1944 | 37.92465657 | -83.25558245 | 2021-02-10 05:22:41 | Morgan, Kentucky, US |
615808 | 615808 | 2021-02-08 | US | Nebraska | Washington | 31177 | 1963 | 19 | 0 | 1944 | 41.52815707 | -96.22019892 | 2021-02-09 05:23:30 | Washington, Nebraska, US |
615253 | 615253 | 2021-02-08 | US | Maryland | Caroline | 24011 | 1962 | 18 | 0 | 1944 | 38.87172293 | -75.82904158 | 2021-02-09 05:23:30 | Caroline, Maryland, US |
1674577 | 1674577 | 2021-02-07 | US | Nebraska | Washington | 31177 | 1963 | 19 | 0 | 1944 | 41.52815707 | -96.22019892 | 2021-02-08 05:22:39 | Washington, Nebraska, US |
1589605 | 1589605 | 2021-02-05 | US | Kentucky | Marion | 21155 | 1965 | 21 | 0 | 1944 | 37.55218078 | -85.26898542 | 2021-02-06 05:23:55 | Marion, Kentucky, US |
341066 | 341066 | 2021-02-03 | US | Georgia | Fannin | 13111 | 1999 | 55 | 0 | 1944 | 34.86430205 | -84.316964 | 2021-02-04 05:22:26 | Fannin, Georgia, US |
1687198 | 1687198 | 2021-02-02 | US | Pennsylvania | Warren | 42123 | 2036 | 92 | 0 | 1944 | 41.81304978 | -79.26969577 | 2021-02-03 05:22:52 | Warren, Pennsylvania, US |
1678248 | 1678248 | 2021-02-01 | US | Mississippi | Attala | 28007 | 2009 | 65 | 0 | 1944 | 33.08658803 | -89.57838564 | 2021-02-02 05:22:49 | Attala, Mississippi, US |
2483166 | 2483166 | 2021-01-28 | US | Iowa | Jackson | 19097 | 1976 | 32 | 0 | 1944 | 42.17178824 | -90.57354837 | 2021-01-29 05:22:23 | Jackson, Iowa, US |
15135 | 15135 | 2021-01-26 | US | South Carolina | Barnwell | 45011 | 1984 | 40 | 0 | 1944 | 33.26679302 | -81.43584352 | 2021-01-27 05:23:41 | Barnwell, South Carolina, US |
2428727 | 2428727 | 2021-01-23 | US | Mississippi | Newton | 28101 | 1990 | 46 | 0 | 1944 | 32.40021118 | -89.11843336 | 2021-01-24 05:22:35 | Newton, Mississippi, US |
1094479 | 1094479 | 2021-01-20 | US | Alabama | Pickens | 1107 | 1975 | 31 | 0 | 1944 | 33.28094866 | -88.08818103 | 2021-01-21 05:22:01 | Pickens, Alabama, US |
907960 | 907960 | 2021-01-19 | Chile | Antofagasta | 28110 | 605 | 25561 | 1944 | -23.6509 | -70.3975 | 2021-01-20 05:21:54 | Antofagasta, Chile | ||
3505326 | 3505326 | 2021-01-17 | US | Missouri | Washington | 29221 | 1985 | 41 | 0 | 1944 | 37.96130078 | -90.87948158 | 2021-01-18 05:22:34 | Washington, Missouri, US |
3515785 | 3515785 | 2021-01-15 | US | Alabama | Marengo | 1091 | 1973 | 29 | 0 | 1944 | 32.24767634 | -87.78796182 | 2021-01-16 05:22:40 | Marengo, Alabama, US |
777233 | 777233 | 2021-01-12 | US | South Dakota | Oglala Lakota | 46102 | 1981 | 37 | 0 | 1944 | 43.33749164 | -102.5555498 | 2021-01-13 05:22:15 | Oglala Lakota, South Dakota, US |
777149 | 777149 | 2021-01-12 | US | South Carolina | Clarendon | 45027 | 2025 | 81 | 0 | 1944 | 33.66610974 | -80.21647898 | 2021-01-13 05:22:15 | Clarendon, South Carolina, US |
2627250 | 2627250 | 2021-01-10 | US | Kentucky | Clay | 21051 | 1954 | 10 | 0 | 1944 | 37.16451126 | -83.712575 | 2021-01-11 05:21:50 | Clay, Kentucky, US |
2867788 | 2867788 | 2021-01-06 | US | Texas | Fannin | 48147 | 2129 | 56 | 0 | 1944 | 33.59564294 | -96.10751083 | 2021-01-07 05:22:03 | Fannin, Texas, US |
1063327 | 1063327 | 2021-01-04 | US | Louisiana | Beauregard | 22011 | 2000 | 56 | 0 | 1944 | 30.64836518 | -93.34173616 | 2021-01-05 05:21:49 | Beauregard, Louisiana, US |
1062672 | 1062672 | 2021-01-04 | US | Georgia | Liberty | 13179 | 1975 | 31 | 0 | 1944 | 31.82588896 | -81.49251135 | 2021-01-05 05:21:49 | Liberty, Georgia, US |
3230631 | 3230631 | 2021-01-03 | Russia | Adygea Republic | 11261 | 93 | 9224 | 1944 | 44.6939006 | 40.1520421 | 2021-01-04 05:22:02 | Adygea Republic, Russia | ||
2227700 | 2227700 | 2021-01-02 | Russia | Adygea Republic | 11184 | 93 | 9147 | 1944 | 44.6939006 | 40.1520421 | 2021-01-03 05:22:52 | Adygea Republic, Russia | ||
3763899 | 3763899 | 2020-12-28 | US | North Carolina | Haywood | 37087 | 2005 | 61 | 0 | 1944 | 35.55269063 | -82.98196486 | 2020-12-29 05:22:37 | Haywood, North Carolina, US |
3694762 | 3694762 | 2020-12-24 | US | Virgin Islands | 78 | 1967 | 23 | 0 | 1944 | 18.3358 | -64.8963 | 2020-12-25 05:22:48 | Virgin Islands, US | |
2410114 | 2410114 | 2020-12-23 | US | Virgin Islands | 78 | 1967 | 23 | 0 | 1944 | 18.3358 | -64.8963 | 2020-12-24 05:23:04 | Virgin Islands, US | |
2120345 | 2120345 | 2020-12-20 | US | Colorado | Morgan | 8087 | 2110 | 86 | 0 | 1944 | 40.26279810000001 | -103.8093302 | 2020-12-21 05:27:58 | Morgan, Colorado, US |
1601690 | 1601690 | 2020-12-10 | US | Kentucky | Whitley | 21235 | 1952 | 8 | 0 | 1944 | 36.75700531 | -84.14541217 | 2020-12-11 05:26:59 | Whitley, Kentucky, US |
2977075 | 2977075 | 2020-12-09 | US | Mississippi | Warren | 28149 | 2004 | 60 | 0 | 1944 | 32.35810271 | -90.83352619 | 2020-12-10 05:26:19 | Warren, Mississippi, US |
2976598 | 2976598 | 2020-12-09 | US | Kentucky | Calloway | 21035 | 1961 | 17 | 0 | 1944 | 36.62093411 | -88.2731593 | 2020-12-10 05:26:19 | Calloway, Kentucky, US |
1821002 | 1821002 | 2020-12-08 | US | New York | Chautauqua | 36013 | 1960 | 16 | 0 | 1944 | 42.22769210000001 | -79.36691763 | 2020-12-09 05:28:01 | Chautauqua, New York, US |
1820372 | 1820372 | 2020-12-08 | US | Massachusetts | Berkshire | 25003 | 2025 | 73 | 0 | 1944 | 42.37428441 | -73.20524838 | 2020-12-09 05:28:01 | Berkshire, Massachusetts, US |
1006495 | 1006495 | 2020-12-06 | Russia | Kalmykia Republic | 12227 | 162 | 10121 | 1944 | 46.2313018 | 45.3275745 | 2020-12-07 05:26:14 | Kalmykia Republic, Russia | ||
77641 | 77641 | 2020-12-03 | US | Oklahoma | Kay | 40071 | 1970 | 26 | 0 | 1944 | 36.81799745 | -97.14421435 | 2020-12-04 05:27:27 | Kay, Oklahoma, US |
395109 | 395109 | 2020-11-27 | US | South Dakota | Lawrence | 46081 | 1966 | 22 | 0 | 1944 | 44.35919441 | -103.7929428 | 2020-11-28 05:25:50 | Lawrence, South Dakota, US |
925495 | 925495 | 2020-11-26 | US | Mississippi | Leflore | 28083 | 2034 | 90 | 0 | 1944 | 33.55545125 | -90.29900733 | 2020-11-27 05:26:53 | Leflore, Mississippi, US |
923868 | 923868 | 2020-11-26 | Russia | Bashkortostan Republic | 13715 | 79 | 11692 | 1944 | 54.8573563 | 57.1439682 | 2020-11-27 05:26:53 | Bashkortostan Republic, Russia | ||
3191578 | 3191578 | 2020-11-22 | US | Massachusetts | Hampshire | 25015 | 2105 | 126 | 0 | 1944 | 42.33997957 | -72.65898478 | 2020-11-23 05:25:26 | Hampshire, Massachusetts, US |
2704037 | 2704037 | 2020-11-20 | US | Oklahoma | Cherokee | 40021 | 1954 | 10 | 0 | 1944 | 35.90692775 | -94.99980896 | 2020-11-21 05:25:51 | Cherokee, Oklahoma, US |
2916222 | 2916222 | 2020-11-14 | US | Illinois | Stephenson | 17177 | 1961 | 17 | 0 | 1944 | 42.35129217 | -89.662598 | 2020-11-15 05:26:53 | Stephenson, Illinois, US |
2787175 | 2787175 | 2020-11-13 | US | New Jersey | Sussex | 34037 | 2142 | 198 | 0 | 1944 | 41.13891592 | -74.69118243 | 2020-11-14 05:25:37 | Sussex, New Jersey, US |
2786420 | 2786420 | 2020-11-13 | US | Kentucky | Laurel | 21125 | 1955 | 11 | 0 | 1944 | 37.10975748 | -84.11321779 | 2020-11-14 05:25:37 | Laurel, Kentucky, US |
866639 | 866639 | 2020-11-12 | US | Missouri | Camden | 29029 | 1985 | 41 | 0 | 1944 | 38.02199522 | -92.76083747 | 2020-11-13 05:25:30 | Camden, Missouri, US |
272940 | 272940 | 2020-11-10 | US | Georgia | Effingham | 13103 | 1974 | 30 | 0 | 1944 | 32.36616021 | -81.34280942 | 2020-11-11 05:25:30 | Effingham, Georgia, US |
1546954 | 1546954 | 2020-11-07 | US | Texas | Bee | 48025 | 2481 | 39 | 0 | 1944 | 28.41761668 | -97.74215593 | 2020-11-08 05:24:56 | Bee, Texas, US |
376044 | 376044 | 2020-11-06 | Colombia | Tolima | 22090 | 679 | 19467 | 1944 | 4.0925 | -75.1545 | 2020-11-07 05:24:52 | Tolima, Colombia | ||
2246952 | 2246952 | 2020-10-30 | US | Wisconsin | Sauk | 55111 | 1951 | 7 | 0 | 1944 | 43.42574087 | -89.94966132 | 2020-10-31 04:24:44 | Sauk, Wisconsin, US |
1452908 | 1452908 | 2020-10-27 | Sweden | Vasternorrland | 2081 | 137 | 0 | 1944 | 63.4276 | 17.7292 | 2020-10-28 04:24:39 | Vasternorrland, Sweden | ||
10505 | 10505 | 2020-10-25 | US | New Mexico | Chaves | 35005 | 1963 | 19 | 0 | 1944 | 33.36406072 | -104.4665365 | 2020-10-26 04:25:02 | Chaves, New Mexico, US |
764970 | 764970 | 2020-10-18 | US | Pennsylvania | Franklin | 42055 | 1997 | 53 | 0 | 1944 | 39.92956518 | -77.72157791 | 2020-10-19 04:24:16 | Franklin, Pennsylvania, US |
1029061 | 1029061 | 2020-10-17 | US | Puerto Rico | Caguas | 72025 | 1944 | 0 | 0 | 1944 | 18.211615 | -66.050779 | 2020-10-18 04:24:25 | Caguas, Puerto Rico, US |
787256 | 787256 | 2020-10-15 | US | Georgia | Walton | 13297 | 2008 | 64 | 0 | 1944 | 33.78017694 | -83.73552314 | 2020-10-16 04:24:01 | Walton, Georgia, US |
3785237 | 3785237 | 2020-10-13 | US | Virginia | Hampton | 51650 | 1972 | 28 | 0 | 1944 | 37.03513786 | -76.35879121 | 2020-10-14 04:24:05 | Hampton, Virginia, US |
2689931 | 2689931 | 2020-10-08 | Russia | Tver Oblast | 6872 | 266 | 4662 | 1944 | 57.1134475 | 35.174442799999994 | 2020-10-09 04:23:59 | Tver Oblast, Russia | ||
1043243 | 1043243 | 2020-10-07 | US | Kentucky | Madison | 21151 | 1951 | 7 | 0 | 1944 | 37.71659336 | -84.27220275 | 2020-10-08 04:23:56 | Madison, Kentucky, US |
1516969 | 1516969 | 2020-09-28 | US | Maryland | Wicomico | 24045 | 1992 | 48 | 0 | 1944 | 38.37301947 | -75.62705831 | 2020-09-29 04:23:42 | Wicomico, Maryland, US |
2838343 | 2838343 | 2020-09-21 | US | Louisiana | Vermilion | 22113 | 2002 | 58 | 0 | 1944 | 29.83517605 | -92.30292538 | 2020-09-22 04:23:00 | Vermilion, Louisiana, US |
668661 | 668661 | 2020-09-16 | US | North Dakota | Grand Forks | 38035 | 1962 | 12 | 0 | 1944 | 47.92093639 | -97.45450447 | 2020-09-17 04:22:00 | Grand Forks, North Dakota, US |
666966 | 666966 | 2020-09-16 | US | Florida | Highlands | 12055 | 2024 | 80 | 0 | 1944 | 27.34254618 | -81.34071957 | 2020-09-17 04:22:00 | Highlands, Florida, US |
1173293 | 1173293 | 2020-09-10 | Mozambique | 4832 | 31 | 2857 | 1944 | -18.665695 | 35.529562 | 2020-09-11 04:46:23 | Mozambique | |||
3162648 | 3162648 | 2020-09-06 | US | Illinois | Sangamon | 17167 | 1983 | 39 | 0 | 1944 | 39.75836914 | -89.65872023 | 2020-09-07 04:28:30 | Sangamon, Illinois, US |
1357310 | 1357310 | 2020-09-03 | US | Texas | Angelina | 48005 | 1750 | 69 | 0 | 1944 | 31.25457347 | -94.60901487 | 2020-09-04 04:28:26 | Angelina, Texas, US |
1355002 | 1355002 | 2020-09-03 | US | Florida | Hendry | 12051 | 1983 | 39 | 0 | 1944 | 26.55386945 | -81.16469006 | 2020-09-04 04:28:26 | Hendry, Florida, US |
1108547 | 1108547 | 2020-09-02 | US | Texas | Angelina | 48005 | 1748 | 69 | 0 | 1944 | 31.25457347 | -94.60901487 | 2020-09-03 04:28:22 | Angelina, Texas, US |
2062876 | 2062876 | 2020-09-01 | US | Texas | Angelina | 48005 | 1743 | 69 | 0 | 1944 | 31.25457347 | -94.60901487 | 2020-09-02 04:28:25 | Angelina, Texas, US |
194666 | 194666 | 2020-08-31 | US | Colorado | Douglas | 8035 | 2204 | 59 | 0 | 1944 | 39.33133796 | -104.930001 | 2020-09-01 04:28:31 | Douglas, Colorado, US |
1525227 | 1525227 | 2020-08-28 | US | Nebraska | Dakota | 31043 | 1986 | 42 | 0 | 1944 | 42.39040144 | -96.56656425 | 2020-08-29 04:28:19 | Dakota, Nebraska, US |
840309 | 840309 | 2020-08-17 | US | Puerto Rico | Bayamon | 72021 | 1944 | 0 | 0 | 1944 | 18.34946 | -66.168435 | 2020-08-18 04:27:56 | Bayamon, Puerto Rico, US |
1612106 | 1612106 | 2020-08-14 | Colombia | Risaralda | 3321 | 61 | 1316 | 1944 | 5.3158 | -75.9928 | 2020-08-15 04:27:31 | Risaralda, Colombia | ||
455329 | 455329 | 2020-08-07 | US | Colorado | Boulder | 8013 | 2126 | 71 | 0 | 1944 | 40.09313619 | -105.3546767 | 2020-08-08 04:34:53 | Boulder, Colorado, US |
96292 | 96292 | 2020-08-04 | US | Iowa | Johnson | 19103 | 1959 | 15 | 0 | 1944 | 41.67169354 | -91.58754744 | 2020-08-05 04:34:43 | Johnson, Iowa, US |
2805371 | 2805371 | 2020-08-02 | US | Alabama | Etowah | 1055 | 1969 | 25 | 0 | 1944 | 34.04567266 | -86.04051873 | 2020-08-03 04:34:35 | Etowah, Alabama, US |
3183866 | 3183866 | 2020-07-28 | US | South Carolina | Orangeburg | 45075 | 1992 | 48 | 0 | 1944 | 33.4391073 | -80.79886287 | 2020-07-29 04:35:11 | Orangeburg, South Carolina, US |
62326 | 62326 | 2020-07-23 | Malawi | 3302 | 76 | 1282 | 1944 | -13.254307999999998 | 34.301525 | 2020-07-24 05:30:40 | Malawi | |||
845146 | 845146 | 2020-07-22 | Malawi | 3302 | 76 | 1282 | 1944 | -13.254307999999998 | 34.301525 | 2020-07-23 05:15:04 | Malawi | |||
2158803 | 2158803 | 2020-07-14 | Mexico | Nuevo Leon | 10575 | 583 | 8048 | 1944 | 25.5922 | -99.9962 | 2020-07-15 04:34:39 | Nuevo Leon, Mexico | ||
2632748 | 2632748 | 2020-06-29 | Peru | Cajamarca | 2091 | 147 | 0 | 1944 | -6.430284 | -78.74559599999998 | 2020-06-30 04:33:48 | Cajamarca, Peru |
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]);