johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
310 rows where confirmed = 2455 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- US 281
- Guinea-Bissau 7
- Japan 4
- China 3
- Netherlands 3
- United Kingdom 3
- Malaysia 2
- Russia 2
- Bhutan 1
- Brazil 1
- Chile 1
- Mexico 1
- Spain 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717680 | 3717680 | 2022-12-06 | US | West Virginia | Pleasants | 54073 | 2455 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-12-07 04:20:58 | Pleasants, West Virginia, US | |
2559926 | 2559926 | 2022-11-29 | US | Virginia | Fairfax City | 51600 | 2455 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-11-30 04:21:07 | Fairfax City, Virginia, US | |
3553739 | 3553739 | 2022-11-27 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-28 04:21:02 | Holt, Nebraska, US | |
2102219 | 2102219 | 2022-11-26 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-27 04:21:05 | Holt, Nebraska, US | |
2099943 | 2099943 | 2022-11-26 | China | Xinjiang | 2455 | 3 | 0 | 41.1129 | 85.2401 | 2022-11-27 04:21:05 | Xinjiang, China | |||
489710 | 489710 | 2022-11-25 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-26 04:21:11 | Holt, Nebraska, US | |
487434 | 487434 | 2022-11-25 | China | Xinjiang | 2455 | 3 | 0 | 41.1129 | 85.2401 | 2022-11-26 04:21:11 | Xinjiang, China | |||
3525539 | 3525539 | 2022-11-24 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-25 04:21:06 | Holt, Nebraska, US | |
3314322 | 3314322 | 2022-11-23 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-24 04:21:09 | Holt, Nebraska, US | |
1622363 | 1622363 | 2022-11-22 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-23 04:21:06 | Holt, Nebraska, US | |
3462251 | 3462251 | 2022-11-21 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-22 04:20:47 | Holt, Nebraska, US | |
1642436 | 1642436 | 2022-11-20 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-21 04:21:05 | Holt, Nebraska, US | |
2065993 | 2065993 | 2022-11-19 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-20 04:21:08 | Holt, Nebraska, US | |
1757387 | 1757387 | 2022-11-18 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-19 04:21:14 | Holt, Nebraska, US | |
3028380 | 3028380 | 2022-11-17 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-18 04:21:15 | Holt, Nebraska, US | |
2488091 | 2488091 | 2022-11-16 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-17 04:21:11 | Holt, Nebraska, US | |
294102 | 294102 | 2022-11-15 | US | Nebraska | Holt | 31089 | 2455 | 23 | 0 | 42.45522056 | -98.78402558 | 2022-11-16 04:21:09 | Holt, Nebraska, US | |
199990 | 199990 | 2022-10-19 | US | Minnesota | Jackson | 27063 | 2455 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-10-20 04:22:59 | Jackson, Minnesota, US | |
2758651 | 2758651 | 2022-10-18 | US | Minnesota | Jackson | 27063 | 2455 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-10-19 04:22:26 | Jackson, Minnesota, US | |
2026485 | 2026485 | 2022-10-17 | US | Minnesota | Jackson | 27063 | 2455 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-10-18 04:22:42 | Jackson, Minnesota, US | |
2163016 | 2163016 | 2022-10-16 | US | West Virginia | Gilmer | 54021 | 2455 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-10-17 04:20:31 | Gilmer, West Virginia, US | |
2161263 | 2161263 | 2022-10-16 | US | Minnesota | Jackson | 27063 | 2455 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-10-17 04:20:31 | Jackson, Minnesota, US | |
519213 | 519213 | 2022-10-15 | US | West Virginia | Gilmer | 54021 | 2455 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-10-16 04:22:39 | Gilmer, West Virginia, US | |
517460 | 517460 | 2022-10-15 | US | Minnesota | Jackson | 27063 | 2455 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-10-16 04:22:39 | Jackson, Minnesota, US | |
2036270 | 2036270 | 2022-10-14 | US | West Virginia | Gilmer | 54021 | 2455 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-10-15 04:22:00 | Gilmer, West Virginia, US | |
2034517 | 2034517 | 2022-10-14 | US | Minnesota | Jackson | 27063 | 2455 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-10-15 04:22:00 | Jackson, Minnesota, US | |
3755205 | 3755205 | 2022-10-13 | US | Minnesota | Jackson | 27063 | 2455 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-10-14 04:22:28 | Jackson, Minnesota, US | |
1626177 | 1626177 | 2022-09-22 | US | Missouri | Carroll | 29033 | 2455 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-09-23 04:23:13 | Carroll, Missouri, US | |
1372381 | 1372381 | 2022-09-21 | US | Missouri | Carroll | 29033 | 2455 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-09-22 04:22:56 | Carroll, Missouri, US | |
2018611 | 2018611 | 2022-09-20 | US | Missouri | Carroll | 29033 | 2455 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-09-21 04:23:22 | Carroll, Missouri, US | |
3572484 | 3572484 | 2022-09-19 | US | Missouri | Carroll | 29033 | 2455 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-09-20 04:22:48 | Carroll, Missouri, US | |
421223 | 421223 | 2022-09-18 | US | Missouri | Carroll | 29033 | 2455 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-09-19 04:21:49 | Carroll, Missouri, US | |
3375247 | 3375247 | 2022-09-17 | US | Missouri | Carroll | 29033 | 2455 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-09-18 04:22:50 | Carroll, Missouri, US | |
2357355 | 2357355 | 2022-09-16 | US | Missouri | Carroll | 29033 | 2455 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-09-17 04:20:19 | Carroll, Missouri, US | |
373194 | 373194 | 2022-09-13 | US | Illinois | Hamilton | 17065 | 2455 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-09-14 04:20:44 | Hamilton, Illinois, US | |
3768971 | 3768971 | 2022-09-11 | US | Texas | Franklin | 48159 | 2455 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-09-12 04:20:58 | Franklin, Texas, US | |
3827546 | 3827546 | 2022-09-10 | US | Texas | Franklin | 48159 | 2455 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-09-11 04:20:50 | Franklin, Texas, US | |
966003 | 966003 | 2022-09-09 | US | Texas | Franklin | 48159 | 2455 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-09-10 04:21:10 | Franklin, Texas, US | |
2829769 | 2829769 | 2022-08-25 | US | Idaho | Owyhee | 16073 | 2455 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-08-26 04:21:02 | Owyhee, Idaho, US | |
2326365 | 2326365 | 2022-08-24 | US | Texas | Archer | 48009 | 2455 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-08-25 04:21:13 | Archer, Texas, US | |
2324302 | 2324302 | 2022-08-24 | US | Idaho | Owyhee | 16073 | 2455 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-08-25 04:21:13 | Owyhee, Idaho, US | |
2366476 | 2366476 | 2022-08-19 | US | Tennessee | Moore | 47127 | 2455 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-08-20 04:21:01 | Moore, Tennessee, US | |
2009629 | 2009629 | 2022-08-04 | US | Idaho | Franklin | 16041 | 2455 | 30 | 0 | 42.18332217 | -111.8149666 | 2022-08-05 04:20:52 | Franklin, Idaho, US | |
1099056 | 1099056 | 2022-08-03 | US | Idaho | Franklin | 16041 | 2455 | 30 | 0 | 42.18332217 | -111.8149666 | 2022-08-04 04:20:58 | Franklin, Idaho, US | |
630702 | 630702 | 2022-07-12 | US | Georgia | Dooly | 13093 | 2455 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-13 04:20:58 | Dooly, Georgia, US | |
1212346 | 1212346 | 2022-07-11 | US | Georgia | Dooly | 13093 | 2455 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-12 04:20:51 | Dooly, Georgia, US | |
2789828 | 2789828 | 2022-07-10 | US | Georgia | Dooly | 13093 | 2455 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-11 04:20:46 | Dooly, Georgia, US | |
142781 | 142781 | 2022-07-09 | US | Georgia | Dooly | 13093 | 2455 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-10 04:20:54 | Dooly, Georgia, US | |
1417881 | 1417881 | 2022-07-08 | US | Georgia | Dooly | 13093 | 2455 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-09 04:20:59 | Dooly, Georgia, US | |
2741806 | 2741806 | 2022-07-07 | US | Georgia | Dooly | 13093 | 2455 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-08 04:20:56 | Dooly, Georgia, US | |
1200601 | 1200601 | 2022-07-06 | US | Georgia | Dooly | 13093 | 2455 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-07 04:20:55 | Dooly, Georgia, US | |
3969762 | 3969762 | 2022-07-05 | US | Texas | Runnels | 48399 | 2455 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-07-06 04:20:58 | Runnels, Texas, US | |
3081212 | 3081212 | 2022-07-04 | US | Texas | La Salle | 48283 | 2455 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-07-05 04:20:45 | La Salle, Texas, US | |
1770494 | 1770494 | 2022-07-03 | US | Texas | La Salle | 48283 | 2455 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-07-04 04:20:54 | La Salle, Texas, US | |
3368480 | 3368480 | 2022-07-02 | US | Texas | La Salle | 48283 | 2455 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-07-03 04:20:59 | La Salle, Texas, US | |
596809 | 596809 | 2022-07-01 | US | Texas | La Salle | 48283 | 2455 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-07-02 04:21:16 | La Salle, Texas, US | |
2150832 | 2150832 | 2022-06-27 | US | Texas | Ochiltree | 48357 | 2455 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-06-28 04:20:58 | Ochiltree, Texas, US | |
478633 | 478633 | 2022-06-26 | US | Texas | Ochiltree | 48357 | 2455 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-06-27 04:21:00 | Ochiltree, Texas, US | |
942008 | 942008 | 2022-06-25 | US | Texas | Ochiltree | 48357 | 2455 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-06-26 04:21:02 | Ochiltree, Texas, US | |
3349828 | 3349828 | 2022-06-24 | US | Texas | Ochiltree | 48357 | 2455 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-06-25 04:20:57 | Ochiltree, Texas, US | |
1651569 | 1651569 | 2022-06-23 | US | Texas | Ochiltree | 48357 | 2455 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-06-24 04:20:58 | Ochiltree, Texas, US | |
2236041 | 2236041 | 2022-06-12 | US | Colorado | San Miguel | 8113 | 2455 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-06-13 04:21:14 | San Miguel, Colorado, US | |
3142239 | 3142239 | 2022-06-11 | US | Colorado | San Miguel | 8113 | 2455 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-06-12 04:20:53 | San Miguel, Colorado, US | |
1945155 | 1945155 | 2022-06-10 | US | Colorado | San Miguel | 8113 | 2455 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-06-11 04:21:01 | San Miguel, Colorado, US | |
3158294 | 3158294 | 2022-06-09 | US | Colorado | San Miguel | 8113 | 2455 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-06-10 04:20:55 | San Miguel, Colorado, US | |
3889811 | 3889811 | 2022-06-06 | US | New Mexico | Colfax | 35007 | 2455 | 65 | 0 | 36.60569702 | -104.6472674 | 2022-06-07 04:21:08 | Colfax, New Mexico, US | |
1187494 | 1187494 | 2022-05-18 | US | Puerto Rico | Hormigueros | 72067 | 2455 | 0 | 0 | 18.134532 | -67.113972 | 2022-05-19 04:20:54 | Hormigueros, Puerto Rico, US | |
3538829 | 3538829 | 2022-05-10 | US | Virginia | Lunenburg | 51111 | 2455 | 39 | 0 | 36.94618528 | -78.24133319 | 2022-05-11 04:20:48 | Lunenburg, Virginia, US | |
1575649 | 1575649 | 2022-05-03 | US | West Virginia | Ritchie | 54085 | 2455 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-05-04 04:20:59 | Ritchie, West Virginia, US | |
2309821 | 2309821 | 2022-04-20 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-21 04:20:46 | Blaine, Oklahoma, US | |
2253960 | 2253960 | 2022-04-19 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-20 04:20:45 | Blaine, Oklahoma, US | |
1848510 | 1848510 | 2022-04-18 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-19 04:21:00 | Blaine, Oklahoma, US | |
3419454 | 3419454 | 2022-04-17 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-18 04:21:12 | Blaine, Oklahoma, US | |
306403 | 306403 | 2022-04-16 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-17 04:20:59 | Blaine, Oklahoma, US | |
2672348 | 2672348 | 2022-04-15 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-16 04:20:48 | Blaine, Oklahoma, US | |
1226133 | 1226133 | 2022-04-14 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-15 04:20:57 | Blaine, Oklahoma, US | |
2445291 | 2445291 | 2022-04-13 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-13 23:21:06 | Blaine, Oklahoma, US | |
1951048 | 1951048 | 2022-04-12 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-13 04:21:03 | Blaine, Oklahoma, US | |
3208801 | 3208801 | 2022-04-11 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-12 04:20:49 | Blaine, Oklahoma, US | |
1578687 | 1578687 | 2022-04-10 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-11 04:21:02 | Blaine, Oklahoma, US | |
1654929 | 1654929 | 2022-04-09 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-10 04:20:52 | Blaine, Oklahoma, US | |
2118251 | 2118251 | 2022-04-08 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-09 04:20:42 | Blaine, Oklahoma, US | |
3322775 | 3322775 | 2022-04-07 | US | Oklahoma | Blaine | 40011 | 2455 | 41 | 0 | 35.87518314 | -98.43307003 | 2022-04-08 04:20:48 | Blaine, Oklahoma, US | |
2802731 | 2802731 | 2022-04-06 | US | Missouri | Ralls | 29173 | 2455 | 26 | 0 | 39.52817427 | -91.51838643 | 2022-04-07 04:20:53 | Ralls, Missouri, US | |
3869500 | 3869500 | 2022-04-05 | US | Missouri | Ralls | 29173 | 2455 | 26 | 0 | 39.52817427 | -91.51838643 | 2022-04-06 04:20:49 | Ralls, Missouri, US | |
2750842 | 2750842 | 2022-04-04 | US | Missouri | Ralls | 29173 | 2455 | 26 | 0 | 39.52817427 | -91.51838643 | 2022-04-05 04:20:48 | Ralls, Missouri, US | |
3732188 | 3732188 | 2022-04-03 | US | Missouri | Ralls | 29173 | 2455 | 26 | 0 | 39.52817427 | -91.51838643 | 2022-04-04 04:20:51 | Ralls, Missouri, US | |
501623 | 501623 | 2022-04-02 | US | Missouri | Ralls | 29173 | 2455 | 26 | 0 | 39.52817427 | -91.51838643 | 2022-04-03 04:20:48 | Ralls, Missouri, US | |
3352608 | 3352608 | 2022-04-01 | US | Missouri | Ralls | 29173 | 2455 | 26 | 0 | 39.52817427 | -91.51838643 | 2022-04-02 04:20:47 | Ralls, Missouri, US | |
1541913 | 1541913 | 2022-03-31 | US | Missouri | Ralls | 29173 | 2455 | 26 | 0 | 39.52817427 | -91.51838643 | 2022-04-01 04:20:28 | Ralls, Missouri, US | |
27741 | 27741 | 2022-03-20 | US | Virginia | Franklin City | 51620 | 2455 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-03-21 04:20:50 | Franklin City, Virginia, US | |
1659751 | 1659751 | 2022-03-19 | US | Virginia | Franklin City | 51620 | 2455 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-03-20 04:20:45 | Franklin City, Virginia, US | |
339277 | 339277 | 2022-03-18 | US | Virginia | Franklin City | 51620 | 2455 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-03-19 04:20:47 | Franklin City, Virginia, US | |
697730 | 697730 | 2022-03-17 | US | Virginia | Franklin City | 51620 | 2455 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-03-18 04:20:55 | Franklin City, Virginia, US | |
2322673 | 2322673 | 2022-03-16 | US | Virginia | Franklin City | 51620 | 2455 | 51 | 0 | 36.6831435 | -76.93859681 | 2022-03-17 04:20:56 | Franklin City, Virginia, US | |
359565 | 359565 | 2022-03-11 | US | Texas | Trinity | 48455 | 2455 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-03-12 04:20:50 | Trinity, Texas, US | |
1646300 | 1646300 | 2022-03-03 | US | Missouri | Montgomery | 29139 | 2455 | 54 | 0 | 38.94022054 | -91.47000721 | 2022-03-04 04:21:09 | Montgomery, Missouri, US | |
2736365 | 2736365 | 2022-02-27 | US | Virginia | Franklin City | 51620 | 2455 | 48 | 0 | 36.6831435 | -76.93859681 | 2022-02-28 04:21:05 | Franklin City, Virginia, US | |
3049518 | 3049518 | 2022-02-26 | US | Virginia | Franklin City | 51620 | 2455 | 48 | 0 | 36.6831435 | -76.93859681 | 2022-02-27 04:21:04 | Franklin City, Virginia, US | |
578173 | 578173 | 2022-02-25 | US | Virginia | Franklin City | 51620 | 2455 | 48 | 0 | 36.6831435 | -76.93859681 | 2022-02-26 04:21:12 | Franklin City, Virginia, 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]);