johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
116 rows where active = 1900 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3331734 | 3331734 | 2021-07-21 | Russia | Kaliningrad Oblast | 40870 | 565 | 38405 | 1900 | 54.7293041 | 21.1489473 | 2021-07-22 04:21:19 | Kaliningrad Oblast, Russia | ||
2423072 | 2423072 | 2021-06-23 | Qatar | 221273 | 586 | 218787 | 1900 | 25.3548 | 51.1839 | 2021-06-24 04:21:55 | Qatar | |||
2422780 | 2422780 | 2021-06-23 | Fiji | 2549 | 13 | 636 | 1900 | -17.7134 | 178.065 | 2021-06-24 04:21:55 | Fiji | |||
1125455 | 1125455 | 2021-06-18 | Colombia | Tolima | 83584 | 2685 | 78999 | 1900 | 4.0925 | -75.1545 | 2021-06-19 04:22:33 | Tolima, Colombia | ||
3574830 | 3574830 | 2021-05-17 | Russia | Penza Oblast | 46248 | 732 | 43616 | 1900 | 53.1655415 | 44.78791810000001 | 2021-05-18 04:20:33 | Penza Oblast, Russia | ||
2939548 | 2939548 | 2021-05-16 | Russia | Mordovia Republic | 20528 | 260 | 18368 | 1900 | 54.4419829 | 44.4661144 | 2021-05-17 04:20:34 | Mordovia Republic, Russia | ||
888349 | 888349 | 2021-04-26 | Russia | Novgorod Oblast | 29757 | 121 | 27736 | 1900 | 58.2843833 | 32.5169757 | 2021-04-27 04:20:52 | Novgorod Oblast, Russia | ||
887914 | 887914 | 2021-04-26 | Chile | OHiggins | 46886 | 1025 | 43961 | 1900 | -34.5755 | -71.0022 | 2021-04-27 04:20:52 | OHiggins, Chile | ||
3883440 | 3883440 | 2021-04-11 | Colombia | Magdalena | 48929 | 1819 | 45210 | 1900 | 10.4113 | -74.4057 | 2021-04-12 04:21:00 | Magdalena, Colombia | ||
3962589 | 3962589 | 2021-03-10 | Mali | 8710 | 358 | 6452 | 1900 | 17.570692 | -3.996166000000001 | 2021-03-11 05:25:48 | Mali | |||
3962464 | 3962464 | 2021-03-10 | India | Delhi | 642030 | 10931 | 629199 | 1900 | 28.646519 | 77.10898 | 2021-03-11 05:25:48 | Delhi, India | ||
3962379 | 3962379 | 2021-03-10 | Colombia | Santander | 92314 | 3395 | 87019 | 1900 | 6.6437 | -73.6536 | 2021-03-11 05:25:48 | Santander, Colombia | ||
3663865 | 3663865 | 2021-03-09 | Russia | Vladimir Oblast | 28390 | 918 | 25572 | 1900 | 56.0503336 | 40.6561633 | 2021-03-10 05:24:35 | Vladimir Oblast, Russia | ||
2210222 | 2210222 | 2021-03-04 | US | Oklahoma | Murray | 40099 | 1922 | 22 | 0 | 1900 | 34.48116015 | -97.06826283 | 2021-03-05 05:26:29 | Murray, Oklahoma, US |
1091996 | 1091996 | 2021-03-03 | US | Missouri | McDonald | 29119 | 1926 | 26 | 0 | 1900 | 36.62869595 | -94.34867205 | 2021-03-04 05:24:24 | McDonald, Missouri, US |
3256508 | 3256508 | 2021-03-02 | US | North Carolina | Transylvania | 37175 | 1927 | 27 | 0 | 1900 | 35.20383864 | -82.79638423 | 2021-03-03 05:23:28 | Transylvania, North Carolina, US |
1001859 | 1001859 | 2021-03-01 | US | Washington | Adams | 53001 | 1921 | 21 | 0 | 1900 | 46.98299757 | -118.5601734 | 2021-03-02 05:23:30 | Adams, Washington, US |
998221 | 998221 | 2021-03-01 | Chile | Araucania | 40643 | 533 | 38210 | 1900 | -38.9489 | -72.3311 | 2021-03-02 05:23:30 | Araucania, Chile | ||
534090 | 534090 | 2021-02-22 | US | Virginia | Prince Edward | 51147 | 1922 | 22 | 0 | 1900 | 37.22554789 | -78.43597949 | 2021-02-23 05:23:41 | Prince Edward, Virginia, US |
2285660 | 2285660 | 2021-02-14 | US | New York | Lewis | 36049 | 1929 | 29 | 0 | 1900 | 43.7844157 | -75.44903992 | 2021-02-15 05:24:49 | Lewis, New York, US |
2679301 | 2679301 | 2021-02-13 | US | Kentucky | Woodford | 21239 | 1904 | 4 | 0 | 1900 | 38.04178222 | -84.7417556 | 2021-02-14 05:23:43 | Woodford, Kentucky, US |
3542359 | 3542359 | 2021-02-12 | US | South Dakota | Union | 46127 | 1939 | 39 | 0 | 1900 | 42.83112163 | -96.6557828 | 2021-02-13 05:22:12 | Union, South Dakota, US |
3540097 | 3540097 | 2021-02-12 | US | Colorado | Pitkin | 8097 | 1954 | 4 | 0 | 1900 | 39.21720112 | -106.9310027 | 2021-02-13 05:22:12 | Pitkin, Colorado, US |
3539704 | 3539704 | 2021-02-12 | Russia | Smolensk Oblast | 24400 | 514 | 21986 | 1900 | 55.03434960000001 | 33.0192065 | 2021-02-13 05:22:12 | Smolensk Oblast, Russia | ||
3539237 | 3539237 | 2021-02-12 | Canada | Saskatchewan | 26145 | 350 | 23895 | 1900 | 52.9399 | -106.4509 | 2021-02-13 05:22:12 | Saskatchewan, Canada | ||
3982041 | 3982041 | 2021-02-10 | US | West Virginia | Brooke | 54009 | 1950 | 50 | 0 | 1900 | 40.27367263 | -80.57915332 | 2021-02-11 05:23:55 | Brooke, West Virginia, US |
1673690 | 1673690 | 2021-02-07 | US | Iowa | Tama | 19171 | 1963 | 63 | 0 | 1900 | 42.07991767 | -92.53266945 | 2021-02-08 05:22:39 | Tama, Iowa, US |
976151 | 976151 | 2021-02-06 | US | Iowa | Tama | 19171 | 1963 | 63 | 0 | 1900 | 42.07991767 | -92.53266945 | 2021-02-07 05:23:00 | Tama, Iowa, US |
975995 | 975995 | 2021-02-06 | US | Indiana | Fountain | 18045 | 1937 | 37 | 0 | 1900 | 40.12361933 | -87.24217689 | 2021-02-07 05:23:00 | Fountain, Indiana, US |
1591474 | 1591474 | 2021-02-05 | US | Virginia | Botetourt | 51023 | 1922 | 22 | 0 | 1900 | 37.55531756 | -79.80982182 | 2021-02-06 05:23:55 | Botetourt, Virginia, US |
791880 | 791880 | 2021-02-04 | US | Louisiana | Grant | 22043 | 1947 | 47 | 0 | 1900 | 31.59882456 | -92.56124347 | 2021-02-05 05:22:38 | Grant, Louisiana, US |
1685845 | 1685845 | 2021-02-02 | US | Kansas | Sumner | 20191 | 1935 | 35 | 0 | 1900 | 37.23682549 | -97.47721621 | 2021-02-03 05:22:52 | Sumner, Kansas, US |
1677815 | 1677815 | 2021-02-01 | US | Kansas | Sumner | 20191 | 1935 | 35 | 0 | 1900 | 37.23682549 | -97.47721621 | 2021-02-02 05:22:49 | Sumner, Kansas, US |
3156748 | 3156748 | 2021-01-27 | US | Texas | Lavaca | 48285 | 1937 | 64 | 0 | 1900 | 29.38508402 | -96.93186692 | 2021-01-28 05:22:24 | Lavaca, Texas, US |
14011 | 14011 | 2021-01-26 | US | Michigan | Out of MI | 80026 | 1911 | 11 | 0 | 1900 | 47.63197653 | 0.0 | 2021-01-27 05:23:41 | Out of MI, Michigan, US |
13077 | 13077 | 2021-01-26 | US | Georgia | Appling | 13001 | 1951 | 51 | 0 | 1900 | 31.74847232 | -82.28909114 | 2021-01-27 05:23:41 | Appling, Georgia, US |
2567927 | 2567927 | 2021-01-25 | Russia | Zabaykalsky Krai | 32957 | 456 | 30601 | 1900 | 52.248521 | 115.956325 | 2021-01-26 05:22:02 | Zabaykalsky Krai, Russia | ||
1094896 | 1094896 | 2021-01-20 | US | Georgia | Hart | 13147 | 1937 | 37 | 0 | 1900 | 34.34626973 | -82.96567682 | 2021-01-21 05:22:01 | Hart, Georgia, US |
909271 | 909271 | 2021-01-19 | US | Indiana | Jennings | 18079 | 1939 | 39 | 0 | 1900 | 38.99588883 | -85.62710784 | 2021-01-20 05:21:54 | Jennings, Indiana, US |
3882019 | 3882019 | 2021-01-14 | US | Ohio | Coshocton | 39031 | 1945 | 45 | 0 | 1900 | 40.30096166 | -81.91729018 | 2021-01-15 05:22:24 | Coshocton, Ohio, US |
3310439 | 3310439 | 2021-01-13 | US | New York | Montgomery | 36057 | 1967 | 67 | 0 | 1900 | 42.90123494 | -74.44011632 | 2021-01-14 05:22:32 | Montgomery, New York, US |
3309994 | 3309994 | 2021-01-13 | US | Mississippi | George | 28039 | 1937 | 37 | 0 | 1900 | 30.86259065 | -88.64436789 | 2021-01-14 05:22:32 | George, Mississippi, US |
3309239 | 3309239 | 2021-01-13 | US | Illinois | Shelby | 17173 | 1931 | 31 | 0 | 1900 | 39.39133527 | -88.80611122 | 2021-01-14 05:22:32 | Shelby, Illinois, US |
777120 | 777120 | 2021-01-12 | US | Puerto Rico | Trujillo Alto | 72139 | 1900 | 0 | 0 | 1900 | 18.336159 | -65.99888399999999 | 2021-01-13 05:22:15 | Trujillo Alto, Puerto Rico, US |
2627361 | 2627361 | 2021-01-10 | US | Louisiana | De Soto | 22031 | 1954 | 54 | 0 | 1900 | 32.05457447 | -93.74130302 | 2021-01-11 05:21:50 | De Soto, Louisiana, US |
157479 | 157479 | 2021-01-08 | US | West Virginia | Preston | 54077 | 1932 | 32 | 0 | 1900 | 39.46770987 | -79.66712803 | 2021-01-09 05:22:18 | Preston, West Virginia, US |
2544790 | 2544790 | 2021-01-07 | US | Virginia | Prince George | 51149 | 1909 | 9 | 0 | 1900 | 37.18497668 | -77.22922187 | 2021-01-08 05:22:42 | Prince George, Virginia, US |
3036789 | 3036789 | 2021-01-05 | US | Ohio | Morrow | 39117 | 1927 | 27 | 0 | 1900 | 40.52363560000001 | -82.7892599 | 2021-01-06 05:22:16 | Morrow, Ohio, US |
3035367 | 3035367 | 2021-01-05 | US | Indiana | Clay | 18021 | 1938 | 38 | 0 | 1900 | 39.39561833 | -87.11723506 | 2021-01-06 05:22:16 | Clay, Indiana, US |
3035099 | 3035099 | 2021-01-05 | US | Georgia | Gilmer | 13123 | 1938 | 38 | 0 | 1900 | 34.69316688 | -84.45802506 | 2021-01-06 05:22:16 | Gilmer, Georgia, US |
2228224 | 2228224 | 2021-01-02 | US | Florida | Levy | 12075 | 1920 | 20 | 0 | 1900 | 29.31829741 | -82.74007147 | 2021-01-03 05:22:52 | Levy, Florida, US |
3697283 | 3697283 | 2020-12-31 | US | Mississippi | Grenada | 28043 | 1962 | 62 | 0 | 1900 | 33.77036166 | -89.80245083 | 2021-01-01 05:23:07 | Grenada, Mississippi, US |
1010194 | 1010194 | 2020-12-30 | Eswatini | 9146 | 184 | 7062 | 1900 | -26.5225 | 31.4659 | 2020-12-31 05:22:49 | Eswatini | |||
766508 | 766508 | 2020-12-29 | Russia | Bryansk Oblast | 22735 | 216 | 20619 | 1900 | 52.8873315 | 33.41585300000001 | 2020-12-30 05:22:34 | Bryansk Oblast, Russia | ||
2408752 | 2408752 | 2020-12-23 | US | Missouri | Miller | 29131 | 1942 | 42 | 0 | 1900 | 38.21450288 | -92.42610898 | 2020-12-24 05:23:04 | Miller, Missouri, US |
1904352 | 1904352 | 2020-12-18 | US | Texas | Polk | 48373 | 1861 | 48 | 0 | 1900 | 30.79472531 | -94.8276624 | 2020-12-19 05:27:52 | Polk, Texas, US |
2131178 | 2131178 | 2020-12-17 | US | Texas | Polk | 48373 | 1847 | 48 | 0 | 1900 | 30.79472531 | -94.8276624 | 2020-12-18 05:28:18 | Polk, Texas, US |
846740 | 846740 | 2020-12-12 | US | Iowa | Crawford | 19047 | 1916 | 16 | 0 | 1900 | 42.03718237 | -95.3819718 | 2020-12-13 05:27:20 | Crawford, Iowa, US |
846097 | 846097 | 2020-12-12 | US | Arkansas | Yell | 5149 | 1936 | 36 | 0 | 1900 | 35.00292371 | -93.41171338 | 2020-12-13 05:27:20 | Yell, Arkansas, US |
2978468 | 2978468 | 2020-12-09 | US | Texas | Wharton | 48481 | 1885 | 71 | 0 | 1900 | 29.27765923 | -96.22319248 | 2020-12-10 05:26:19 | Wharton, Texas, US |
1008581 | 1008581 | 2020-12-06 | US | North Carolina | Carteret | 37031 | 1914 | 14 | 0 | 1900 | 34.8932941 | -76.54120135 | 2020-12-07 05:26:14 | Carteret, North Carolina, US |
76927 | 76927 | 2020-12-03 | US | Mississippi | Sunflower | 28133 | 1955 | 55 | 0 | 1900 | 33.60192578 | -90.58882684 | 2020-12-04 05:27:27 | Sunflower, Mississippi, US |
76143 | 76143 | 2020-12-03 | US | Indiana | Adams | 18001 | 1927 | 27 | 0 | 1900 | 40.7457653 | -84.93671406 | 2020-12-04 05:27:27 | Adams, Indiana, US |
3569162 | 3569162 | 2020-11-29 | US | Oklahoma | Woodward | 40153 | 1907 | 7 | 0 | 1900 | 36.42316318 | -99.26283045 | 2020-11-30 05:26:13 | Woodward, Oklahoma, US |
678751 | 678751 | 2020-11-23 | US | Arizona | Graham | 4009 | 1933 | 33 | 0 | 1900 | 32.93166885 | -109.8882178 | 2020-11-24 05:27:31 | Graham, Arizona, US |
2881885 | 2881885 | 2020-11-15 | US | Michigan | Van Buren | 26159 | 1925 | 25 | 0 | 1900 | 42.25190229 | -86.01939087 | 2020-11-16 05:25:57 | Van Buren, Michigan, US |
2879914 | 2879914 | 2020-11-15 | Bahrain | 84703 | 334 | 82469 | 1900 | 26.0275 | 50.55 | 2020-11-16 05:25:57 | Bahrain | |||
2916863 | 2916863 | 2020-11-14 | US | Michigan | Van Buren | 26159 | 1925 | 25 | 0 | 1900 | 42.25190229 | -86.01939087 | 2020-11-15 05:26:53 | Van Buren, Michigan, US |
2788440 | 2788440 | 2020-11-13 | US | Washington | Kitsap | 53035 | 1926 | 26 | 0 | 1900 | 47.63479026 | -122.6436061 | 2020-11-14 05:25:37 | Kitsap, Washington, US |
867695 | 867695 | 2020-11-12 | US | Tennessee | Fayette | 47047 | 1940 | 34 | 0 | 1900 | 35.19615831 | -89.41399032 | 2020-11-13 05:25:30 | Fayette, Tennessee, US |
377324 | 377324 | 2020-11-06 | US | Indiana | Wayne | 18177 | 1939 | 39 | 0 | 1900 | 39.8633444 | -85.01044989 | 2020-11-07 05:24:52 | Wayne, Indiana, US |
894706 | 894706 | 2020-11-05 | US | Oklahoma | Texas | 40139 | 1910 | 10 | 0 | 1900 | 36.74777635 | -101.4889765 | 2020-11-06 05:24:55 | Texas, Oklahoma, US |
2245673 | 2245673 | 2020-10-30 | US | North Carolina | Chatham | 37037 | 1961 | 61 | 0 | 1900 | 35.70394416 | -79.25541492 | 2020-10-31 04:24:44 | Chatham, North Carolina, US |
755173 | 755173 | 2020-10-28 | US | Georgia | Tift | 13277 | 1964 | 64 | 0 | 1900 | 31.45743864 | -83.5236119 | 2020-10-29 04:24:49 | Tift, Georgia, US |
3483422 | 3483422 | 2020-10-26 | US | Texas | Hunt | 48231 | 959 | 44 | 0 | 1900 | 33.12351514 | -96.08551032 | 2020-10-27 04:24:45 | Hunt, Texas, US |
11443 | 11443 | 2020-10-25 | US | Texas | Hunt | 48231 | 955 | 44 | 0 | 1900 | 33.12351514 | -96.08551032 | 2020-10-26 04:25:02 | Hunt, Texas, US |
1179678 | 1179678 | 2020-10-22 | US | New Mexico | Lea | 35025 | 1928 | 28 | 0 | 1900 | 32.79215361 | -103.4123733 | 2020-10-23 04:24:46 | Lea, New Mexico, US |
2192476 | 2192476 | 2020-10-21 | US | Georgia | Unassigned | 90013 | 1906 | 6 | 0 | 1900 | 34.91369188 | 0.0 | 2020-10-22 04:24:27 | Unassigned, Georgia, US |
3993089 | 3993089 | 2020-10-20 | US | Ohio | Miami | 39109 | 1956 | 56 | 0 | 1900 | 40.0543329 | -84.22871271 | 2020-10-21 04:24:14 | Miami, Ohio, US |
3990342 | 3990342 | 2020-10-20 | Brazil | Alagoas | 89644 | 2187 | 85557 | 1900 | -9.5713 | -36.782 | 2020-10-21 04:24:14 | Alagoas, Brazil | ||
1027285 | 1027285 | 2020-10-17 | US | Idaho | Madison | 16065 | 1902 | 2 | 0 | 1900 | 43.78141028 | -111.65384740000002 | 2020-10-18 04:24:25 | Madison, Idaho, US |
1026210 | 1026210 | 2020-10-17 | Colombia | Risaralda | 14584 | 313 | 12371 | 1900 | 5.3158 | -75.9928 | 2020-10-18 04:24:25 | Risaralda, Colombia | ||
3784946 | 3784946 | 2020-10-13 | US | Texas | Coryell | 48099 | 2233 | 12 | 0 | 1900 | 31.39078397 | -97.79936155 | 2020-10-14 04:24:05 | Coryell, Texas, US |
2293970 | 2293970 | 2020-10-12 | US | Oklahoma | Comanche | 40031 | 1913 | 13 | 0 | 1900 | 34.65973764 | -98.47195055 | 2020-10-13 04:24:02 | Comanche, Oklahoma, US |
1044358 | 1044358 | 2020-10-07 | US | Oklahoma | Garfield | 40047 | 1922 | 22 | 0 | 1900 | 36.3791334 | -97.78265517 | 2020-10-08 04:23:56 | Garfield, Oklahoma, US |
3121094 | 3121094 | 2020-10-06 | Ukraine | Crimea Republic* | 5063 | 72 | 3091 | 1900 | 45.2835 | 34.2008 | 2020-10-07 04:23:40 | Crimea Republic*, Ukraine | ||
3117251 | 3117251 | 2020-10-06 | Canada | Alberta | 19211 | 281 | 17030 | 1900 | 53.9333 | -116.5765 | 2020-10-07 04:23:40 | Alberta, Canada | ||
1515909 | 1515909 | 2020-09-28 | US | Arkansas | Unassigned | 90005 | 1900 | 0 | 0 | 1900 | 36.38177105 | 0.0 | 2020-09-29 04:23:42 | Unassigned, Arkansas, US |
2585379 | 2585379 | 2020-09-27 | US | Virginia | Suffolk | 51800 | 1972 | 72 | 0 | 1900 | 36.70155394 | -76.63603554 | 2020-09-28 04:23:00 | Suffolk, Virginia, US |
2584331 | 2584331 | 2020-09-27 | US | North Carolina | Stanly | 37167 | 1956 | 56 | 0 | 1900 | 35.31647813 | -80.25093221 | 2020-09-28 04:23:00 | Stanly, North Carolina, US |
2814891 | 2814891 | 2020-09-25 | US | New Hampshire | Rockingham | 33015 | 2003 | 103 | 0 | 1900 | 42.98499744 | -71.12883377 | 2020-09-26 04:23:00 | Rockingham, New Hampshire, US |
2870515 | 2870515 | 2020-09-13 | US | Mississippi | Lafayette | 28071 | 1939 | 39 | 0 | 1900 | 34.35687874 | -89.48490961 | 2020-09-14 04:26:00 | Lafayette, Mississippi, US |
547809 | 547809 | 2020-09-12 | US | Indiana | Cass | 18017 | 1910 | 10 | 0 | 1900 | 40.76135835 | -86.34830753 | 2020-09-13 04:30:52 | Cass, Indiana, US |
1173514 | 1173514 | 2020-09-10 | Trinidad and Tobago | 2698 | 43 | 755 | 1900 | 10.6918 | -61.2225 | 2020-09-11 04:46:23 | Trinidad and Tobago | |||
2174239 | 2174239 | 2020-09-09 | US | Pennsylvania | Westmoreland | 42129 | 1949 | 49 | 0 | 1900 | 40.31377979999999 | -79.46615476 | 2020-09-10 04:29:01 | Westmoreland, Pennsylvania, US |
1245025 | 1245025 | 2020-09-08 | US | Kansas | Finney | 20055 | 1912 | 12 | 0 | 1900 | 38.04340344 | -100.7381938 | 2020-09-09 04:28:48 | Finney, Kansas, US |
428604 | 428604 | 2020-09-07 | US | Kansas | Finney | 20055 | 1912 | 12 | 0 | 1900 | 38.04340344 | -100.7381938 | 2020-09-08 04:28:25 | Finney, Kansas, US |
2661843 | 2661843 | 2020-09-04 | Malawi | 5608 | 175 | 3533 | 1900 | -13.2543 | 34.3015 | 2020-09-05 04:28:19 | Malawi | |||
3484608 | 3484608 | 2020-08-20 | Sweden | Dalarna | 2074 | 174 | 0 | 1900 | 61.0917 | 14.6664 | 2020-08-21 04:27:41 | Dalarna, Sweden | ||
1558780 | 1558780 | 2020-08-16 | US | South Carolina | Pickens | 45077 | 1929 | 29 | 0 | 1900 | 34.88807695 | -82.72791551 | 2020-08-17 04:27:20 | Pickens, South Carolina, 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]);