johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
174 rows where active = 1261 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468137 | 3468137 | 2021-08-03 | India | Nagaland | 28072 | 577 | 26234 | 1261 | 26.06702 | 94.470302 | 2021-08-04 04:21:25 | Nagaland, India | ||
3125270 | 3125270 | 2021-06-28 | Canada | Alberta | 231850 | 2295 | 228294 | 1261 | 53.9333 | -116.5765 | 2021-06-29 04:21:28 | Alberta, Canada | ||
2590262 | 2590262 | 2021-06-27 | Russia | Vladimir Oblast | 35573 | 1271 | 33041 | 1261 | 56.0503336 | 40.6561633 | 2021-06-28 04:21:29 | Vladimir Oblast, Russia | ||
3958483 | 3958483 | 2021-06-26 | Israel | 840823 | 6429 | 833133 | 1261 | 31.046051 | 34.851612 | 2021-06-27 04:21:39 | Israel | |||
380153 | 380153 | 2021-04-30 | India | Nagaland | 13976 | 104 | 12611 | 1261 | 26.06702 | 94.470302 | 2021-05-01 04:20:47 | Nagaland, India | ||
1841976 | 1841976 | 2021-04-14 | Japan | Okinawa | 10981 | 130 | 9590 | 1261 | 25.768923 | 126.668016 | 2021-04-15 04:20:54 | Okinawa, Japan | ||
2780761 | 2780761 | 2021-03-24 | Canada | Manitoba | 33591 | 929 | 31401 | 1261 | 53.7609 | -98.8139 | 2021-03-25 05:27:00 | Manitoba, Canada | ||
1802303 | 1802303 | 2021-03-23 | Yemen | 3612 | 785 | 1566 | 1261 | 15.552727 | 48.516388 | 2021-03-24 05:25:40 | Yemen | |||
3962371 | 3962371 | 2021-03-10 | Colombia | Magdalena | 36420 | 1359 | 33800 | 1261 | 10.4113 | -74.4057 | 2021-03-11 05:25:48 | Magdalena, Colombia | ||
1617212 | 1617212 | 2021-03-05 | US | Illinois | De Witt | 17039 | 1283 | 22 | 0 | 1261 | 40.17514519 | -88.90959682 | 2021-03-06 04:23:41 | De Witt, Illinois, US |
2211048 | 2211048 | 2021-03-04 | US | Virginia | Rockbridge | 51163 | 1298 | 37 | 0 | 1261 | 37.81204314 | -79.44605905 | 2021-03-05 05:26:29 | Rockbridge, Virginia, US |
1093376 | 1093376 | 2021-03-03 | US | Virginia | Buchanan | 51027 | 1296 | 35 | 0 | 1261 | 37.26818323 | -82.03749726 | 2021-03-04 05:24:24 | Buchanan, Virginia, US |
1090617 | 1090617 | 2021-03-03 | US | California | Inyo | 6027 | 1303 | 35 | 0 | 1261 | 36.51112084 | -117.41119779999998 | 2021-03-04 05:24:24 | Inyo, California, US |
3257448 | 3257448 | 2021-03-02 | US | Virginia | Buchanan | 51027 | 1295 | 34 | 0 | 1261 | 37.26818323 | -82.03749726 | 2021-03-03 05:23:28 | Buchanan, Virginia, US |
3254796 | 3254796 | 2021-03-02 | US | Colorado | Teller | 8119 | 1323 | 14 | 0 | 1261 | 38.88133511 | -105.1614893 | 2021-03-03 05:23:28 | Teller, Colorado, US |
3254736 | 3254736 | 2021-03-02 | US | Colorado | Alamosa | 8003 | 1337 | 30 | 0 | 1261 | 37.57250606 | -105.7885451 | 2021-03-03 05:23:28 | Alamosa, Colorado, US |
3254527 | 3254527 | 2021-03-02 | US | Alabama | Lowndes | 1085 | 1312 | 51 | 0 | 1261 | 32.1597283 | -86.65158371 | 2021-03-03 05:23:28 | Lowndes, Alabama, US |
1001740 | 1001740 | 2021-03-01 | US | Virginia | Buchanan | 51027 | 1295 | 34 | 0 | 1261 | 37.26818323 | -82.03749726 | 2021-03-02 05:23:30 | Buchanan, Virginia, US |
999088 | 999088 | 2021-03-01 | US | Colorado | Teller | 8119 | 1318 | 14 | 0 | 1261 | 38.88133511 | -105.1614893 | 2021-03-02 05:23:30 | Teller, Colorado, US |
2370798 | 2370798 | 2021-02-28 | US | Virginia | Buchanan | 51027 | 1295 | 34 | 0 | 1261 | 37.26818323 | -82.03749726 | 2021-03-01 05:23:01 | Buchanan, Virginia, US |
3069300 | 3069300 | 2021-02-27 | US | Virginia | Buchanan | 51027 | 1295 | 34 | 0 | 1261 | 37.26818323 | -82.03749726 | 2021-02-28 05:22:20 | Buchanan, Virginia, US |
3066203 | 3066203 | 2021-02-27 | Russia | Kamchatka Krai | 13482 | 118 | 12103 | 1261 | 57.1914882 | 160.03838190000005 | 2021-02-28 05:22:20 | Kamchatka Krai, Russia | ||
3066197 | 3066197 | 2021-02-27 | Russia | Ivanovo Oblast | 30476 | 920 | 28295 | 1261 | 56.9167446 | 41.43521370000001 | 2021-02-28 05:22:20 | Ivanovo Oblast, Russia | ||
2186884 | 2186884 | 2021-02-26 | US | Virginia | Buchanan | 51027 | 1295 | 34 | 0 | 1261 | 37.26818323 | -82.03749726 | 2021-02-27 05:22:28 | Buchanan, Virginia, US |
2184192 | 2184192 | 2021-02-26 | US | Colorado | Elbert | 8039 | 1351 | 12 | 0 | 1261 | 39.28656773 | -104.1358721 | 2021-02-27 05:22:28 | Elbert, Colorado, US |
1861285 | 1861285 | 2021-02-25 | US | Vermont | Rutland | 50021 | 1272 | 11 | 0 | 1261 | 43.57723578 | -73.03741676 | 2021-02-26 05:22:40 | Rutland, Vermont, US |
283484 | 283484 | 2021-02-24 | US | Virginia | Buchanan | 51027 | 1294 | 33 | 0 | 1261 | 37.26818323 | -82.03749726 | 2021-02-25 05:24:57 | Buchanan, Virginia, US |
281949 | 281949 | 2021-02-24 | US | Minnesota | Wadena | 27159 | 1281 | 20 | 0 | 1261 | 46.58589171 | -94.96968506 | 2021-02-25 05:24:57 | Wadena, Minnesota, US |
1938217 | 1938217 | 2021-02-23 | US | Minnesota | Wadena | 27159 | 1281 | 20 | 0 | 1261 | 46.58589171 | -94.96968506 | 2021-02-24 05:29:16 | Wadena, Minnesota, US |
1936693 | 1936693 | 2021-02-23 | Russia | Sakhalin Oblast | 21302 | 33 | 20008 | 1261 | 49.7219665 | 143.448533 | 2021-02-24 05:29:16 | Sakhalin Oblast, Russia | ||
531392 | 531392 | 2021-02-22 | US | Florida | Franklin | 12037 | 1274 | 13 | 0 | 1261 | 29.83791238 | -84.82731662 | 2021-02-23 05:23:41 | Franklin, Florida, US |
182726 | 182726 | 2021-02-21 | US | Florida | Franklin | 12037 | 1274 | 13 | 0 | 1261 | 29.83791238 | -84.82731662 | 2021-02-22 05:24:21 | Franklin, Florida, US |
745642 | 745642 | 2021-02-20 | US | Virginia | Fluvanna | 51065 | 1274 | 13 | 0 | 1261 | 37.84157909 | -78.27715475 | 2021-02-21 05:24:33 | Fluvanna, Virginia, US |
1154979 | 1154979 | 2021-02-18 | US | Missouri | Andrew | 29003 | 1278 | 17 | 0 | 1261 | 39.98492163 | -94.80163024 | 2021-02-19 05:24:16 | Andrew, Missouri, US |
1153807 | 1153807 | 2021-02-18 | US | Florida | Franklin | 12037 | 1273 | 12 | 0 | 1261 | 29.83791238 | -84.82731662 | 2021-02-19 05:24:16 | Franklin, Florida, US |
3602201 | 3602201 | 2021-02-17 | US | Iowa | Calhoun | 19025 | 1271 | 10 | 0 | 1261 | 42.38521079 | -94.64046046 | 2021-02-18 05:22:58 | Calhoun, Iowa, US |
3051336 | 3051336 | 2021-02-16 | US | Iowa | Calhoun | 19025 | 1270 | 9 | 0 | 1261 | 42.38521079 | -94.64046046 | 2021-02-17 05:23:10 | Calhoun, Iowa, US |
2679922 | 2679922 | 2021-02-13 | US | Nebraska | Otoe | 31131 | 1267 | 6 | 0 | 1261 | 40.64843556 | -96.13374142 | 2021-02-14 05:23:43 | Otoe, Nebraska, US |
3542730 | 3542730 | 2021-02-12 | US | Vermont | Bennington | 50003 | 1268 | 7 | 0 | 1261 | 43.03519828 | -73.09048868 | 2021-02-13 05:22:12 | Bennington, Vermont, US |
3541569 | 3541569 | 2021-02-12 | US | Nebraska | Seward | 31159 | 1286 | 25 | 0 | 1261 | 40.87241834 | -97.139673 | 2021-02-13 05:22:12 | Seward, Nebraska, US |
1531467 | 1531467 | 2021-02-09 | US | Wisconsin | Rusk | 55107 | 1278 | 17 | 0 | 1261 | 45.47498854 | -91.1333012 | 2021-02-10 05:22:41 | Rusk, Wisconsin, US |
616465 | 616465 | 2021-02-08 | US | Puerto Rico | Vega Alta | 72143 | 1261 | 0 | 0 | 1261 | 18.409346 | -66.33725 | 2021-02-09 05:23:30 | Vega Alta, Puerto Rico, US |
1672163 | 1672163 | 2021-02-07 | Bahamas | 8256 | 176 | 6819 | 1261 | 25.025885 | -78.035889 | 2021-02-08 05:22:39 | Bahamas | |||
974624 | 974624 | 2021-02-06 | Bahamas | 8256 | 176 | 6819 | 1261 | 25.025885 | -78.035889 | 2021-02-07 05:23:00 | Bahamas | |||
1587882 | 1587882 | 2021-02-05 | Bahamas | 8256 | 176 | 6819 | 1261 | 25.025885 | -78.035889 | 2021-02-06 05:23:55 | Bahamas | |||
793869 | 793869 | 2021-02-04 | US | West Virginia | McDowell | 54047 | 1278 | 17 | 0 | 1261 | 37.38002939 | -81.65083669 | 2021-02-05 05:22:38 | McDowell, West Virginia, US |
2484734 | 2484734 | 2021-01-28 | US | Puerto Rico | Rio Grande | 72119 | 1261 | 0 | 0 | 1261 | 18.346329 | -65.813742 | 2021-01-29 05:22:23 | Rio Grande, Puerto Rico, US |
2568015 | 2568015 | 2021-01-25 | US | Alabama | Clay | 1027 | 1307 | 46 | 0 | 1261 | 33.26984193 | -85.85836077 | 2021-01-26 05:22:02 | Clay, Alabama, US |
1761004 | 1761004 | 2021-01-24 | US | Minnesota | Fillmore | 27045 | 1269 | 8 | 0 | 1261 | 43.67394126 | -92.08980382 | 2021-01-25 05:22:16 | Fillmore, Minnesota, US |
2467398 | 2467398 | 2021-01-22 | US | Colorado | Bent | 8011 | 1286 | 21 | 0 | 1261 | 37.95474293 | -103.0720195 | 2021-01-23 05:22:03 | Bent, Colorado, US |
911297 | 911297 | 2021-01-19 | US | Texas | Jackson | 48239 | 1325 | 23 | 0 | 1261 | 28.95472367 | -96.57749563 | 2021-01-20 05:21:54 | Jackson, Texas, US |
909635 | 909635 | 2021-01-19 | US | Kentucky | Russell | 21207 | 1295 | 34 | 0 | 1261 | 36.99308373 | -85.06070117 | 2021-01-20 05:21:54 | Russell, Kentucky, US |
240360 | 240360 | 2021-01-18 | US | Texas | Jackson | 48239 | 1325 | 23 | 0 | 1261 | 28.95472367 | -96.57749563 | 2021-01-19 05:22:15 | Jackson, Texas, US |
3506477 | 3506477 | 2021-01-17 | US | Texas | Jackson | 48239 | 1325 | 23 | 0 | 1261 | 28.95472367 | -96.57749563 | 2021-01-18 05:22:34 | Jackson, Texas, US |
3104560 | 3104560 | 2021-01-16 | US | Texas | Jackson | 48239 | 1325 | 23 | 0 | 1261 | 28.95472367 | -96.57749563 | 2021-01-17 05:22:17 | Jackson, Texas, US |
3103807 | 3103807 | 2021-01-16 | US | North Carolina | Warren | 37185 | 1273 | 12 | 0 | 1261 | 36.39728256 | -78.10652228 | 2021-01-17 05:22:17 | Warren, North Carolina, US |
3517769 | 3517769 | 2021-01-15 | US | North Carolina | Warren | 37185 | 1273 | 12 | 0 | 1261 | 36.39728256 | -78.10652228 | 2021-01-16 05:22:40 | Warren, North Carolina, US |
3516590 | 3516590 | 2021-01-15 | US | Iowa | Hancock | 19081 | 1285 | 24 | 0 | 1261 | 43.08178477 | -93.73454884 | 2021-01-16 05:22:40 | Hancock, Iowa, US |
3882612 | 3882612 | 2021-01-14 | US | Texas | Childress | 48075 | 1393 | 12 | 0 | 1261 | 34.529304100000004 | -100.2077916 | 2021-01-15 05:22:24 | Childress, Texas, US |
192597 | 192597 | 2021-01-11 | US | Oklahoma | Choctaw | 40023 | 1268 | 7 | 0 | 1261 | 34.02807439 | -95.54771129 | 2021-01-12 05:22:15 | Choctaw, Oklahoma, US |
191692 | 191692 | 2021-01-11 | US | Michigan | Gladwin | 26051 | 1296 | 35 | 0 | 1261 | 43.98901072 | -84.38774817 | 2021-01-12 05:22:15 | Gladwin, Michigan, US |
189993 | 189993 | 2021-01-11 | Ghana | 56230 | 338 | 54631 | 1261 | 7.9465 | -1.0232 | 2021-01-12 05:22:15 | Ghana | |||
2626727 | 2626727 | 2021-01-10 | US | Georgia | Rabun | 13241 | 1283 | 22 | 0 | 1261 | 34.88389445 | -83.40304637 | 2021-01-11 05:21:50 | Rabun, Georgia, US |
3900478 | 3900478 | 2021-01-09 | US | Arkansas | Sharp | 5135 | 1297 | 36 | 0 | 1261 | 36.16258158 | -91.47819342 | 2021-01-10 05:22:12 | Sharp, Arkansas, US |
155393 | 155393 | 2021-01-08 | US | Kentucky | Johnson | 21115 | 1277 | 16 | 0 | 1261 | 37.85106355 | -82.8264322 | 2021-01-09 05:22:18 | Johnson, Kentucky, US |
2544745 | 2544745 | 2021-01-07 | US | Virginia | Halifax | 51083 | 1303 | 42 | 0 | 1261 | 36.76654925 | -78.93512622 | 2021-01-08 05:22:42 | Halifax, Virginia, US |
2541659 | 2541659 | 2021-01-07 | Russia | Tyumen Oblast | 24463 | 207 | 22995 | 1261 | 58.8206488 | 70.36588370000001 | 2021-01-08 05:22:42 | Tyumen Oblast, Russia | ||
3037293 | 3037293 | 2021-01-05 | US | Tennessee | Union | 47173 | 1325 | 18 | 0 | 1261 | 36.28590426 | -83.83651902 | 2021-01-06 05:22:16 | Union, Tennessee, US |
3697427 | 3697427 | 2020-12-31 | US | Missouri | Pike | 29163 | 1275 | 14 | 0 | 1261 | 39.34310674 | -91.16980779 | 2021-01-01 05:23:07 | Pike, Missouri, US |
3696306 | 3696306 | 2020-12-31 | US | Georgia | Jefferson | 13163 | 1301 | 40 | 0 | 1261 | 33.05867328 | -82.41609057 | 2021-01-01 05:23:07 | Jefferson, Georgia, US |
1011335 | 1011335 | 2020-12-30 | US | Illinois | Richland | 17159 | 1289 | 28 | 0 | 1261 | 38.71240969 | -88.08475366 | 2020-12-31 05:22:49 | Richland, Illinois, US |
767303 | 767303 | 2020-12-29 | US | Illinois | Hancock | 17067 | 1281 | 20 | 0 | 1261 | 40.40423981 | -91.16313899 | 2020-12-30 05:22:34 | Hancock, Illinois, US |
766782 | 766782 | 2020-12-29 | US | Arkansas | Clay | 5021 | 1291 | 30 | 0 | 1261 | 36.36826212 | -90.4148172 | 2020-12-30 05:22:34 | Clay, Arkansas, US |
928574 | 928574 | 2020-12-21 | US | Georgia | Union | 13291 | 1302 | 41 | 0 | 1261 | 34.82995757 | -83.98967069 | 2020-12-22 05:22:33 | Union, Georgia, US |
2120537 | 2120537 | 2020-12-20 | US | Georgia | Lee | 13177 | 1294 | 33 | 0 | 1261 | 31.779330600000005 | -84.14324253 | 2020-12-21 05:27:58 | Lee, Georgia, US |
2128249 | 2128249 | 2020-12-17 | Russia | Vladimir Oblast | 16014 | 409 | 14344 | 1261 | 56.0503336 | 40.6561633 | 2020-12-18 05:28:18 | Vladimir Oblast, Russia | ||
1037288 | 1037288 | 2020-12-15 | US | Tennessee | Claiborne | 47025 | 1288 | 11 | 0 | 1261 | 36.48319149 | -83.65947309 | 2020-12-16 05:28:04 | Claiborne, Tennessee, US |
1603025 | 1603025 | 2020-12-10 | US | South Carolina | Edgefield | 45037 | 1286 | 25 | 0 | 1261 | 33.77221995 | -81.96231108 | 2020-12-11 05:26:59 | Edgefield, South Carolina, US |
1602233 | 1602233 | 2020-12-10 | US | Montana | Roosevelt | 30085 | 1303 | 42 | 0 | 1261 | 48.29607488 | -105.0079268 | 2020-12-11 05:26:59 | Roosevelt, Montana, US |
2977109 | 2977109 | 2020-12-09 | US | Missouri | Cooper | 29053 | 1271 | 10 | 0 | 1261 | 38.844478 | -92.80896081 | 2020-12-10 05:26:19 | Cooper, Missouri, US |
1822135 | 1822135 | 2020-12-08 | US | Virginia | James City | 51095 | 1283 | 22 | 0 | 1261 | 37.31156958 | -76.76950618 | 2020-12-09 05:28:01 | James City, Virginia, US |
1819811 | 1819811 | 2020-12-08 | US | Illinois | Perry | 17145 | 1291 | 30 | 0 | 1261 | 38.08510853 | -89.36856219 | 2020-12-09 05:28:01 | Perry, Illinois, US |
1633345 | 1633345 | 2020-12-05 | US | Illinois | Union | 17181 | 1289 | 28 | 0 | 1261 | 37.47119609 | -89.25548938 | 2020-12-06 05:26:18 | Union, Illinois, US |
3860583 | 3860583 | 2020-12-04 | US | Georgia | Burke | 13033 | 1277 | 16 | 0 | 1261 | 33.05917989 | -81.99928721 | 2020-12-05 05:27:36 | Burke, Georgia, US |
740153 | 740153 | 2020-12-02 | US | Mississippi | Winston | 28159 | 1287 | 26 | 0 | 1261 | 33.08747908 | -89.03391385 | 2020-12-03 05:28:22 | Winston, Mississippi, US |
3567784 | 3567784 | 2020-11-29 | US | Iowa | O'Brien | 19141 | 1292 | 31 | 0 | 1261 | 43.08310673 | -95.62474482 | 2020-11-30 05:26:13 | O'Brien, Iowa, US |
393063 | 393063 | 2020-11-27 | US | Georgia | Lumpkin | 13187 | 1281 | 20 | 0 | 1261 | 34.57286511 | -84.00425681 | 2020-11-28 05:25:50 | Lumpkin, Georgia, US |
926135 | 926135 | 2020-11-26 | US | Ohio | Fulton | 39051 | 1287 | 26 | 0 | 1261 | 41.60213491 | -84.12571393 | 2020-11-27 05:26:53 | Fulton, Ohio, US |
1975040 | 1975040 | 2020-11-25 | US | Ohio | Fulton | 39051 | 1287 | 26 | 0 | 1261 | 41.60213491 | -84.12571393 | 2020-11-26 05:27:44 | Fulton, Ohio, US |
1353165 | 1353165 | 2020-11-24 | US | South Dakota | Clay | 46027 | 1270 | 9 | 0 | 1261 | 42.91296147 | -96.97656917 | 2020-11-25 05:27:20 | Clay, South Dakota, US |
681737 | 681737 | 2020-11-23 | US | Washington | Cowlitz | 53015 | 1269 | 8 | 0 | 1261 | 46.19074721 | -122.6782231 | 2020-11-24 05:27:31 | Cowlitz, Washington, US |
3836427 | 3836427 | 2020-11-21 | India | Goa | 46748 | 675 | 44812 | 1261 | 15.359682 | 74.057396 | 2020-11-22 05:25:45 | Goa, India | ||
2704794 | 2704794 | 2020-11-20 | US | Virginia | Accomack | 51001 | 1282 | 21 | 0 | 1261 | 37.76707161 | -75.63234615 | 2020-11-21 05:25:51 | Accomack, Virginia, US |
824819 | 824819 | 2020-11-19 | US | Texas | Wood | 48499 | 505 | 47 | 0 | 1261 | 32.78722382 | -95.38236368 | 2020-11-20 05:26:28 | Wood, Texas, US |
3341413 | 3341413 | 2020-11-17 | US | South Carolina | Marlboro | 45069 | 1277 | 16 | 0 | 1261 | 34.59905577 | -79.67561152 | 2020-11-18 05:40:31 | Marlboro, South Carolina, US |
3338975 | 3338975 | 2020-11-17 | US | Alabama | Marion | 1093 | 1294 | 33 | 0 | 1261 | 34.13697363 | -87.88704173 | 2020-11-18 05:40:31 | Marion, Alabama, US |
3172964 | 3172964 | 2020-11-16 | US | Virginia | Franklin | 51067 | 1270 | 9 | 0 | 1261 | 36.99536167 | -79.88023649 | 2020-11-17 05:25:54 | Franklin, Virginia, US |
3170216 | 3170216 | 2020-11-16 | US | California | Tehama | 6103 | 1268 | 7 | 0 | 1261 | 40.12570935 | -122.2370171 | 2020-11-17 05:25:54 | Tehama, California, US |
3443694 | 3443694 | 2020-11-11 | US | South Dakota | Meade | 46093 | 1271 | 10 | 0 | 1261 | 44.56676791 | -102.7162741 | 2020-11-12 05:25:55 | Meade, South Dakota, US |
272374 | 272374 | 2020-11-10 | Russia | Mari El Republic | 6572 | 69 | 5242 | 1261 | 56.5767504 | 47.8817512 | 2020-11-11 05:25:30 | Mari El Republic, Russia |
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]);