johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5,302 rows where country_or_region = "US" and deaths = 123 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 507
- Virginia 390
- Georgia 372
- Ohio 298
- New York 217
- Kentucky 212
- North Carolina 203
- Tennessee 202
- Wisconsin 180
- Indiana 178
- Mississippi 176
- Kansas 173
- Illinois 171
- Missouri 169
- Michigan 168
- Louisiana 162
- Minnesota 113
- Maryland 107
- Alabama 105
- Florida 105
- West Virginia 100
- Oklahoma 88
- Pennsylvania 74
- California 72
- Colorado 70
- Arkansas 68
- Washington 58
- Nevada 55
- Montana 54
- South Carolina 53
- …
country_or_region 1
- US · 5,302 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753650 | 2753650 | 2022-12-29 | US | Florida | Union | 12125 | 4967 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-30 04:21:04 | Union, Florida, US | |
2753663 | 2753663 | 2022-12-29 | US | Georgia | Ben Hill | 13017 | 4896 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-30 04:21:04 | Ben Hill, Georgia, US | |
2753794 | 2753794 | 2022-12-29 | US | Georgia | Towns | 13281 | 2968 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-30 04:21:04 | Towns, Georgia, US | |
2754170 | 2754170 | 2022-12-29 | US | Kansas | Barton | 20009 | 7553 | 123 | 0 | 38.47889676 | -98.75636726 | 2022-12-30 04:21:04 | Barton, Kansas, US | |
2754194 | 2754194 | 2022-12-29 | US | Kansas | Ford | 20057 | 11997 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-30 04:21:04 | Ford, Kansas, US | |
2754695 | 2754695 | 2022-12-29 | US | Mississippi | Attala | 28007 | 6557 | 123 | 0 | 33.08658803 | -89.57838564 | 2022-12-30 04:21:04 | Attala, Mississippi, US | |
2754762 | 2754762 | 2022-12-29 | US | Mississippi | Tishomingo | 28141 | 7465 | 123 | 0 | 34.74023475 | -88.23917219 | 2022-12-30 04:21:04 | Tishomingo, Mississippi, US | |
2755221 | 2755221 | 2022-12-29 | US | North Carolina | Davie | 37059 | 14070 | 123 | 0 | 35.93099927 | -80.54496571 | 2022-12-30 04:21:04 | Davie, North Carolina, US | |
2756061 | 2756061 | 2022-12-29 | US | Texas | Lavaca | 48285 | 4770 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-12-30 04:21:04 | Lavaca, Texas, US | |
2756265 | 2756265 | 2022-12-29 | US | Virginia | Hopewell | 51670 | 7530 | 123 | 0 | 37.29186313 | -77.29754684 | 2022-12-30 04:21:04 | Hopewell, Virginia, US | |
2756281 | 2756281 | 2022-12-29 | US | Virginia | Martinsville | 51690 | 4403 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-30 04:21:04 | Martinsville, Virginia, US | |
1074656 | 1074656 | 2022-12-28 | US | Florida | Union | 12125 | 4967 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-29 04:21:01 | Union, Florida, US | |
1074669 | 1074669 | 2022-12-28 | US | Georgia | Ben Hill | 13017 | 4896 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-29 04:21:01 | Ben Hill, Georgia, US | |
1074800 | 1074800 | 2022-12-28 | US | Georgia | Towns | 13281 | 2968 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-29 04:21:01 | Towns, Georgia, US | |
1075176 | 1075176 | 2022-12-28 | US | Kansas | Barton | 20009 | 7553 | 123 | 0 | 38.47889676 | -98.75636726 | 2022-12-29 04:21:01 | Barton, Kansas, US | |
1075200 | 1075200 | 2022-12-28 | US | Kansas | Ford | 20057 | 11997 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-29 04:21:01 | Ford, Kansas, US | |
1075701 | 1075701 | 2022-12-28 | US | Mississippi | Attala | 28007 | 6557 | 123 | 0 | 33.08658803 | -89.57838564 | 2022-12-29 04:21:01 | Attala, Mississippi, US | |
1075768 | 1075768 | 2022-12-28 | US | Mississippi | Tishomingo | 28141 | 7465 | 123 | 0 | 34.74023475 | -88.23917219 | 2022-12-29 04:21:01 | Tishomingo, Mississippi, US | |
1076227 | 1076227 | 2022-12-28 | US | North Carolina | Davie | 37059 | 14070 | 123 | 0 | 35.93099927 | -80.54496571 | 2022-12-29 04:21:01 | Davie, North Carolina, US | |
1077067 | 1077067 | 2022-12-28 | US | Texas | Lavaca | 48285 | 4770 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-12-29 04:21:01 | Lavaca, Texas, US | |
1077271 | 1077271 | 2022-12-28 | US | Virginia | Hopewell | 51670 | 7530 | 123 | 0 | 37.29186313 | -77.29754684 | 2022-12-29 04:21:01 | Hopewell, Virginia, US | |
1077287 | 1077287 | 2022-12-28 | US | Virginia | Martinsville | 51690 | 4403 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-29 04:21:01 | Martinsville, Virginia, US | |
328653 | 328653 | 2022-12-27 | US | Florida | Union | 12125 | 4967 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-28 04:21:04 | Union, Florida, US | |
328666 | 328666 | 2022-12-27 | US | Georgia | Ben Hill | 13017 | 4893 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-28 04:21:04 | Ben Hill, Georgia, US | |
328797 | 328797 | 2022-12-27 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-28 04:21:04 | Towns, Georgia, US | |
329173 | 329173 | 2022-12-27 | US | Kansas | Barton | 20009 | 7539 | 123 | 0 | 38.47889676 | -98.75636726 | 2022-12-28 04:21:04 | Barton, Kansas, US | |
329197 | 329197 | 2022-12-27 | US | Kansas | Ford | 20057 | 11959 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-28 04:21:04 | Ford, Kansas, US | |
329698 | 329698 | 2022-12-27 | US | Mississippi | Attala | 28007 | 6557 | 123 | 0 | 33.08658803 | -89.57838564 | 2022-12-28 04:21:04 | Attala, Mississippi, US | |
329765 | 329765 | 2022-12-27 | US | Mississippi | Tishomingo | 28141 | 7465 | 123 | 0 | 34.74023475 | -88.23917219 | 2022-12-28 04:21:04 | Tishomingo, Mississippi, US | |
330224 | 330224 | 2022-12-27 | US | North Carolina | Davie | 37059 | 14070 | 123 | 0 | 35.93099927 | -80.54496571 | 2022-12-28 04:21:04 | Davie, North Carolina, US | |
331064 | 331064 | 2022-12-27 | US | Texas | Lavaca | 48285 | 4751 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-12-28 04:21:04 | Lavaca, Texas, US | |
331268 | 331268 | 2022-12-27 | US | Virginia | Hopewell | 51670 | 7528 | 123 | 0 | 37.29186313 | -77.29754684 | 2022-12-28 04:21:04 | Hopewell, Virginia, US | |
331284 | 331284 | 2022-12-27 | US | Virginia | Martinsville | 51690 | 4395 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-28 04:21:04 | Martinsville, Virginia, US | |
218726 | 218726 | 2022-12-26 | US | Florida | Union | 12125 | 4967 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-27 04:21:07 | Union, Florida, US | |
218739 | 218739 | 2022-12-26 | US | Georgia | Ben Hill | 13017 | 4893 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-27 04:21:07 | Ben Hill, Georgia, US | |
218870 | 218870 | 2022-12-26 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-27 04:21:07 | Towns, Georgia, US | |
219246 | 219246 | 2022-12-26 | US | Kansas | Barton | 20009 | 7539 | 123 | 0 | 38.47889676 | -98.75636726 | 2022-12-27 04:21:07 | Barton, Kansas, US | |
219270 | 219270 | 2022-12-26 | US | Kansas | Ford | 20057 | 11959 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-27 04:21:07 | Ford, Kansas, US | |
219647 | 219647 | 2022-12-26 | US | Michigan | Mecosta | 26107 | 10001 | 123 | 0 | 43.64064262 | -85.32463223 | 2022-12-27 04:21:07 | Mecosta, Michigan, US | |
220297 | 220297 | 2022-12-26 | US | North Carolina | Davie | 37059 | 14070 | 123 | 0 | 35.93099927 | -80.54496571 | 2022-12-27 04:21:07 | Davie, North Carolina, US | |
221137 | 221137 | 2022-12-26 | US | Texas | Lavaca | 48285 | 4751 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-12-27 04:21:07 | Lavaca, Texas, US | |
221341 | 221341 | 2022-12-26 | US | Virginia | Hopewell | 51670 | 7522 | 123 | 0 | 37.29186313 | -77.29754684 | 2022-12-27 04:21:07 | Hopewell, Virginia, US | |
221357 | 221357 | 2022-12-26 | US | Virginia | Martinsville | 51690 | 4394 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-27 04:21:07 | Martinsville, Virginia, US | |
3223183 | 3223183 | 2022-12-25 | US | Florida | Union | 12125 | 4967 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-26 04:21:06 | Union, Florida, US | |
3223196 | 3223196 | 2022-12-25 | US | Georgia | Ben Hill | 13017 | 4893 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-26 04:21:06 | Ben Hill, Georgia, US | |
3223327 | 3223327 | 2022-12-25 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-26 04:21:06 | Towns, Georgia, US | |
3223703 | 3223703 | 2022-12-25 | US | Kansas | Barton | 20009 | 7539 | 123 | 0 | 38.47889676 | -98.75636726 | 2022-12-26 04:21:06 | Barton, Kansas, US | |
3223727 | 3223727 | 2022-12-25 | US | Kansas | Ford | 20057 | 11959 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-26 04:21:06 | Ford, Kansas, US | |
3224104 | 3224104 | 2022-12-25 | US | Michigan | Mecosta | 26107 | 10001 | 123 | 0 | 43.64064262 | -85.32463223 | 2022-12-26 04:21:06 | Mecosta, Michigan, US | |
3224754 | 3224754 | 2022-12-25 | US | North Carolina | Davie | 37059 | 14070 | 123 | 0 | 35.93099927 | -80.54496571 | 2022-12-26 04:21:06 | Davie, North Carolina, US | |
3225594 | 3225594 | 2022-12-25 | US | Texas | Lavaca | 48285 | 4751 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-12-26 04:21:06 | Lavaca, Texas, US | |
3225798 | 3225798 | 2022-12-25 | US | Virginia | Hopewell | 51670 | 7498 | 123 | 0 | 37.29186313 | -77.29754684 | 2022-12-26 04:21:06 | Hopewell, Virginia, US | |
3225814 | 3225814 | 2022-12-25 | US | Virginia | Martinsville | 51690 | 4394 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-26 04:21:06 | Martinsville, Virginia, US | |
1019097 | 1019097 | 2022-12-24 | US | Florida | Union | 12125 | 4967 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-25 04:21:04 | Union, Florida, US | |
1019110 | 1019110 | 2022-12-24 | US | Georgia | Ben Hill | 13017 | 4893 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-25 04:21:04 | Ben Hill, Georgia, US | |
1019241 | 1019241 | 2022-12-24 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-25 04:21:04 | Towns, Georgia, US | |
1019617 | 1019617 | 2022-12-24 | US | Kansas | Barton | 20009 | 7539 | 123 | 0 | 38.47889676 | -98.75636726 | 2022-12-25 04:21:04 | Barton, Kansas, US | |
1019641 | 1019641 | 2022-12-24 | US | Kansas | Ford | 20057 | 11959 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-25 04:21:04 | Ford, Kansas, US | |
1020018 | 1020018 | 2022-12-24 | US | Michigan | Mecosta | 26107 | 10001 | 123 | 0 | 43.64064262 | -85.32463223 | 2022-12-25 04:21:04 | Mecosta, Michigan, US | |
1020668 | 1020668 | 2022-12-24 | US | North Carolina | Davie | 37059 | 14070 | 123 | 0 | 35.93099927 | -80.54496571 | 2022-12-25 04:21:04 | Davie, North Carolina, US | |
1021508 | 1021508 | 2022-12-24 | US | Texas | Lavaca | 48285 | 4751 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-12-25 04:21:04 | Lavaca, Texas, US | |
1021712 | 1021712 | 2022-12-24 | US | Virginia | Hopewell | 51670 | 7498 | 123 | 0 | 37.29186313 | -77.29754684 | 2022-12-25 04:21:04 | Hopewell, Virginia, US | |
1021728 | 1021728 | 2022-12-24 | US | Virginia | Martinsville | 51690 | 4394 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-25 04:21:04 | Martinsville, Virginia, US | |
691120 | 691120 | 2022-12-23 | US | Florida | Union | 12125 | 4967 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-24 04:21:02 | Union, Florida, US | |
691133 | 691133 | 2022-12-23 | US | Georgia | Ben Hill | 13017 | 4893 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-24 04:21:02 | Ben Hill, Georgia, US | |
691264 | 691264 | 2022-12-23 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-24 04:21:02 | Towns, Georgia, US | |
691640 | 691640 | 2022-12-23 | US | Kansas | Barton | 20009 | 7539 | 123 | 0 | 38.47889676 | -98.75636726 | 2022-12-24 04:21:02 | Barton, Kansas, US | |
691664 | 691664 | 2022-12-23 | US | Kansas | Ford | 20057 | 11959 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-24 04:21:02 | Ford, Kansas, US | |
692041 | 692041 | 2022-12-23 | US | Michigan | Mecosta | 26107 | 10001 | 123 | 0 | 43.64064262 | -85.32463223 | 2022-12-24 04:21:02 | Mecosta, Michigan, US | |
692691 | 692691 | 2022-12-23 | US | North Carolina | Davie | 37059 | 14070 | 123 | 0 | 35.93099927 | -80.54496571 | 2022-12-24 04:21:02 | Davie, North Carolina, US | |
693531 | 693531 | 2022-12-23 | US | Texas | Lavaca | 48285 | 4751 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-12-24 04:21:02 | Lavaca, Texas, US | |
693735 | 693735 | 2022-12-23 | US | Virginia | Hopewell | 51670 | 7498 | 123 | 0 | 37.29186313 | -77.29754684 | 2022-12-24 04:21:02 | Hopewell, Virginia, US | |
693751 | 693751 | 2022-12-23 | US | Virginia | Martinsville | 51690 | 4394 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-24 04:21:02 | Martinsville, Virginia, US | |
2180330 | 2180330 | 2022-12-22 | US | Florida | Union | 12125 | 4967 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-23 04:21:04 | Union, Florida, US | |
2180343 | 2180343 | 2022-12-22 | US | Georgia | Ben Hill | 13017 | 4893 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-23 04:21:04 | Ben Hill, Georgia, US | |
2180474 | 2180474 | 2022-12-22 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-23 04:21:04 | Towns, Georgia, US | |
2180850 | 2180850 | 2022-12-22 | US | Kansas | Barton | 20009 | 7539 | 123 | 0 | 38.47889676 | -98.75636726 | 2022-12-23 04:21:04 | Barton, Kansas, US | |
2180874 | 2180874 | 2022-12-22 | US | Kansas | Ford | 20057 | 11959 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-23 04:21:04 | Ford, Kansas, US | |
2181251 | 2181251 | 2022-12-22 | US | Michigan | Mecosta | 26107 | 10001 | 123 | 0 | 43.64064262 | -85.32463223 | 2022-12-23 04:21:04 | Mecosta, Michigan, US | |
2181901 | 2181901 | 2022-12-22 | US | North Carolina | Davie | 37059 | 14070 | 123 | 0 | 35.93099927 | -80.54496571 | 2022-12-23 04:21:04 | Davie, North Carolina, US | |
2182741 | 2182741 | 2022-12-22 | US | Texas | Lavaca | 48285 | 4751 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-12-23 04:21:04 | Lavaca, Texas, US | |
2182945 | 2182945 | 2022-12-22 | US | Virginia | Hopewell | 51670 | 7493 | 123 | 0 | 37.29186313 | -77.29754684 | 2022-12-23 04:21:04 | Hopewell, Virginia, US | |
2182961 | 2182961 | 2022-12-22 | US | Virginia | Martinsville | 51690 | 4394 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-23 04:21:04 | Martinsville, Virginia, US | |
452134 | 452134 | 2022-12-21 | US | Florida | Union | 12125 | 4967 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-22 04:20:56 | Union, Florida, US | |
452147 | 452147 | 2022-12-21 | US | Georgia | Ben Hill | 13017 | 4893 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-22 04:20:56 | Ben Hill, Georgia, US | |
452278 | 452278 | 2022-12-21 | US | Georgia | Towns | 13281 | 2952 | 123 | 0 | 34.91369188 | -83.7410746 | 2022-12-22 04:20:56 | Towns, Georgia, US | |
452654 | 452654 | 2022-12-21 | US | Kansas | Barton | 20009 | 7539 | 123 | 0 | 38.47889676 | -98.75636726 | 2022-12-22 04:20:56 | Barton, Kansas, US | |
452678 | 452678 | 2022-12-21 | US | Kansas | Ford | 20057 | 11959 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-22 04:20:56 | Ford, Kansas, US | |
453055 | 453055 | 2022-12-21 | US | Michigan | Mecosta | 26107 | 10001 | 123 | 0 | 43.64064262 | -85.32463223 | 2022-12-22 04:20:56 | Mecosta, Michigan, US | |
453135 | 453135 | 2022-12-21 | US | Minnesota | Mille Lacs | 27095 | 8173 | 123 | 0 | 45.93705297 | -93.63236823 | 2022-12-22 04:20:56 | Mille Lacs, Minnesota, US | |
453705 | 453705 | 2022-12-21 | US | North Carolina | Davie | 37059 | 14070 | 123 | 0 | 35.93099927 | -80.54496571 | 2022-12-22 04:20:56 | Davie, North Carolina, US | |
454545 | 454545 | 2022-12-21 | US | Texas | Lavaca | 48285 | 4751 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-12-22 04:20:56 | Lavaca, Texas, US | |
454749 | 454749 | 2022-12-21 | US | Virginia | Hopewell | 51670 | 7483 | 123 | 0 | 37.29186313 | -77.29754684 | 2022-12-22 04:20:56 | Hopewell, Virginia, US | |
454765 | 454765 | 2022-12-21 | US | Virginia | Martinsville | 51690 | 4393 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-22 04:20:56 | Martinsville, Virginia, US | |
2952133 | 2952133 | 2022-12-20 | US | Florida | Union | 12125 | 4967 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-21 04:21:03 | Union, Florida, US | |
2952146 | 2952146 | 2022-12-20 | US | Georgia | Ben Hill | 13017 | 4881 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-21 04:21:03 | Ben Hill, Georgia, US | |
2952653 | 2952653 | 2022-12-20 | US | Kansas | Barton | 20009 | 7508 | 123 | 0 | 38.47889676 | -98.75636726 | 2022-12-21 04:21:03 | Barton, Kansas, US | |
2952677 | 2952677 | 2022-12-20 | US | Kansas | Ford | 20057 | 11893 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-21 04:21:03 | Ford, Kansas, US | |
2953054 | 2953054 | 2022-12-20 | US | Michigan | Mecosta | 26107 | 10001 | 123 | 0 | 43.64064262 | -85.32463223 | 2022-12-21 04:21:03 | Mecosta, Michigan, US | |
2953134 | 2953134 | 2022-12-20 | US | Minnesota | Mille Lacs | 27095 | 8173 | 123 | 0 | 45.93705297 | -93.63236823 | 2022-12-21 04:21:03 | Mille Lacs, Minnesota, 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]);