johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12,870 rows where deaths = 65 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 11,982
- Canada 208
- Japan 161
- Russia 144
- Monaco 65
- United Kingdom 32
- San Marino 18
- Chile 16
- Germany 16
- Pakistan 16
- France 14
- India 14
- Niger 12
- Ukraine 12
- Burkina Faso 11
- Peru 11
- Sweden 11
- Dominica 9
- Malaysia 8
- Togo 8
- Colombia 7
- Mexico 7
- Guinea 6
- Sao Tome and Principe 5
- Benin 4
- Chad 4
- Lesotho 4
- Spain 4
- Estonia 3
- Sierra Leone 3
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756237 | 2756237 | 2022-12-29 | US | Virginia | Dickenson | 51051 | 4653 | 65 | 0 | 37.12560977 | -82.35124171 | 2022-12-30 04:21:04 | Dickenson, Virginia, US | |
2755490 | 2755490 | 2022-12-29 | US | Oklahoma | Okfuskee | 40107 | 4138 | 65 | 0 | 35.46485198 | -96.32639984 | 2022-12-30 04:21:04 | Okfuskee, Oklahoma, US | |
2755050 | 2755050 | 2022-12-29 | US | Nevada | Humboldt | 32013 | 2758 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-12-30 04:21:04 | Humboldt, Nevada, US | |
2754857 | 2754857 | 2022-12-29 | US | Missouri | Pike | 29163 | 5099 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-30 04:21:04 | Pike, Missouri, US | |
2754835 | 2754835 | 2022-12-29 | US | Missouri | Macon | 29121 | 4203 | 65 | 0 | 39.83049768 | -92.56453089 | 2022-12-30 04:21:04 | Macon, Missouri, US | |
2754747 | 2754747 | 2022-12-29 | US | Mississippi | Perry | 28111 | 3622 | 65 | 0 | 31.17161885 | -88.99281835 | 2022-12-30 04:21:04 | Perry, Mississippi, US | |
2754684 | 2754684 | 2022-12-29 | US | Minnesota | Wadena | 27159 | 5089 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-30 04:21:04 | Wadena, Minnesota, US | |
2754656 | 2754656 | 2022-12-29 | US | Minnesota | Nobles | 27105 | 7809 | 65 | 0 | 43.67434621 | -95.75329576 | 2022-12-30 04:21:04 | Nobles, Minnesota, US | |
2754604 | 2754604 | 2022-12-29 | US | Minnesota | Aitkin | 27001 | 3623 | 65 | 0 | 46.60962049 | -93.4116826 | 2022-12-30 04:21:04 | Aitkin, Minnesota, US | |
2754342 | 2754342 | 2022-12-29 | US | Kentucky | Livingston | 21139 | 3036 | 65 | 0 | 37.21137452 | -88.34797529 | 2022-12-30 04:21:04 | Livingston, Kentucky, US | |
2754289 | 2754289 | 2022-12-29 | US | Kentucky | Caldwell | 21033 | 4904 | 65 | 0 | 37.14749129 | -87.86948214 | 2022-12-30 04:21:04 | Caldwell, Kentucky, US | |
2754144 | 2754144 | 2022-12-29 | US | Iowa | Poweshiek | 19157 | 4524 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-30 04:21:04 | Poweshiek, Iowa, US | |
2754123 | 2754123 | 2022-12-29 | US | Iowa | Louisa | 19115 | 2900 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-12-30 04:21:04 | Louisa, Iowa, US | |
2753797 | 2753797 | 2022-12-29 | US | Georgia | Turner | 13287 | 3065 | 65 | 0 | 31.71612656 | -83.62069378 | 2022-12-30 04:21:04 | Turner, Georgia, US | |
2753703 | 2753703 | 2022-12-29 | US | Georgia | Early | 13099 | 3068 | 65 | 0 | 31.32155345 | -84.90255207 | 2022-12-30 04:21:04 | Early, Georgia, US | |
2753678 | 2753678 | 2022-12-29 | US | Georgia | Charlton | 13049 | 3417 | 65 | 0 | 30.78371028 | -82.13951596 | 2022-12-30 04:21:04 | Charlton, Georgia, US | |
2753396 | 2753396 | 2022-12-29 | US | Arkansas | Grant | 5053 | 5121 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-30 04:21:04 | Grant, Arkansas, US | |
2753016 | 2753016 | 2022-12-29 | Monaco | 15941 | 65 | 0 | 43.7333 | 7.4167 | 2022-12-30 04:21:04 | Monaco | ||||
1077243 | 1077243 | 2022-12-28 | US | Virginia | Dickenson | 51051 | 4653 | 65 | 0 | 37.12560977 | -82.35124171 | 2022-12-29 04:21:01 | Dickenson, Virginia, US | |
1076496 | 1076496 | 2022-12-28 | US | Oklahoma | Okfuskee | 40107 | 4114 | 65 | 0 | 35.46485198 | -96.32639984 | 2022-12-29 04:21:01 | Okfuskee, Oklahoma, US | |
1076056 | 1076056 | 2022-12-28 | US | Nevada | Humboldt | 32013 | 2758 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-12-29 04:21:01 | Humboldt, Nevada, US | |
1075863 | 1075863 | 2022-12-28 | US | Missouri | Pike | 29163 | 5099 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-29 04:21:01 | Pike, Missouri, US | |
1075841 | 1075841 | 2022-12-28 | US | Missouri | Macon | 29121 | 4203 | 65 | 0 | 39.83049768 | -92.56453089 | 2022-12-29 04:21:01 | Macon, Missouri, US | |
1075753 | 1075753 | 2022-12-28 | US | Mississippi | Perry | 28111 | 3622 | 65 | 0 | 31.17161885 | -88.99281835 | 2022-12-29 04:21:01 | Perry, Mississippi, US | |
1075690 | 1075690 | 2022-12-28 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-29 04:21:01 | Wadena, Minnesota, US | |
1075662 | 1075662 | 2022-12-28 | US | Minnesota | Nobles | 27105 | 7794 | 65 | 0 | 43.67434621 | -95.75329576 | 2022-12-29 04:21:01 | Nobles, Minnesota, US | |
1075610 | 1075610 | 2022-12-28 | US | Minnesota | Aitkin | 27001 | 3612 | 65 | 0 | 46.60962049 | -93.4116826 | 2022-12-29 04:21:01 | Aitkin, Minnesota, US | |
1075348 | 1075348 | 2022-12-28 | US | Kentucky | Livingston | 21139 | 3036 | 65 | 0 | 37.21137452 | -88.34797529 | 2022-12-29 04:21:01 | Livingston, Kentucky, US | |
1075295 | 1075295 | 2022-12-28 | US | Kentucky | Caldwell | 21033 | 4904 | 65 | 0 | 37.14749129 | -87.86948214 | 2022-12-29 04:21:01 | Caldwell, Kentucky, US | |
1075150 | 1075150 | 2022-12-28 | US | Iowa | Poweshiek | 19157 | 4524 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-29 04:21:01 | Poweshiek, Iowa, US | |
1075129 | 1075129 | 2022-12-28 | US | Iowa | Louisa | 19115 | 2900 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-12-29 04:21:01 | Louisa, Iowa, US | |
1074803 | 1074803 | 2022-12-28 | US | Georgia | Turner | 13287 | 3065 | 65 | 0 | 31.71612656 | -83.62069378 | 2022-12-29 04:21:01 | Turner, Georgia, US | |
1074709 | 1074709 | 2022-12-28 | US | Georgia | Early | 13099 | 3068 | 65 | 0 | 31.32155345 | -84.90255207 | 2022-12-29 04:21:01 | Early, Georgia, US | |
1074684 | 1074684 | 2022-12-28 | US | Georgia | Charlton | 13049 | 3417 | 65 | 0 | 30.78371028 | -82.13951596 | 2022-12-29 04:21:01 | Charlton, Georgia, US | |
1074402 | 1074402 | 2022-12-28 | US | Arkansas | Grant | 5053 | 5121 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-29 04:21:01 | Grant, Arkansas, US | |
1074022 | 1074022 | 2022-12-28 | Monaco | 15935 | 65 | 0 | 43.7333 | 7.4167 | 2022-12-29 04:21:01 | Monaco | ||||
331493 | 331493 | 2022-12-27 | US | Wisconsin | Sawyer | 55113 | 5835 | 65 | 0 | 45.87931905 | -91.14504927 | 2022-12-28 04:21:04 | Sawyer, Wisconsin, US | |
331240 | 331240 | 2022-12-27 | US | Virginia | Dickenson | 51051 | 4651 | 65 | 0 | 37.12560977 | -82.35124171 | 2022-12-28 04:21:04 | Dickenson, Virginia, US | |
330493 | 330493 | 2022-12-27 | US | Oklahoma | Okfuskee | 40107 | 4114 | 65 | 0 | 35.46485198 | -96.32639984 | 2022-12-28 04:21:04 | Okfuskee, Oklahoma, US | |
330053 | 330053 | 2022-12-27 | US | Nevada | Humboldt | 32013 | 2755 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-12-28 04:21:04 | Humboldt, Nevada, US | |
329860 | 329860 | 2022-12-27 | US | Missouri | Pike | 29163 | 5099 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-28 04:21:04 | Pike, Missouri, US | |
329838 | 329838 | 2022-12-27 | US | Missouri | Macon | 29121 | 4203 | 65 | 0 | 39.83049768 | -92.56453089 | 2022-12-28 04:21:04 | Macon, Missouri, US | |
329750 | 329750 | 2022-12-27 | US | Mississippi | Perry | 28111 | 3622 | 65 | 0 | 31.17161885 | -88.99281835 | 2022-12-28 04:21:04 | Perry, Mississippi, US | |
329687 | 329687 | 2022-12-27 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-28 04:21:04 | Wadena, Minnesota, US | |
329659 | 329659 | 2022-12-27 | US | Minnesota | Nobles | 27105 | 7794 | 65 | 0 | 43.67434621 | -95.75329576 | 2022-12-28 04:21:04 | Nobles, Minnesota, US | |
329607 | 329607 | 2022-12-27 | US | Minnesota | Aitkin | 27001 | 3612 | 65 | 0 | 46.60962049 | -93.4116826 | 2022-12-28 04:21:04 | Aitkin, Minnesota, US | |
329345 | 329345 | 2022-12-27 | US | Kentucky | Livingston | 21139 | 3036 | 65 | 0 | 37.21137452 | -88.34797529 | 2022-12-28 04:21:04 | Livingston, Kentucky, US | |
329292 | 329292 | 2022-12-27 | US | Kentucky | Caldwell | 21033 | 4904 | 65 | 0 | 37.14749129 | -87.86948214 | 2022-12-28 04:21:04 | Caldwell, Kentucky, US | |
329147 | 329147 | 2022-12-27 | US | Iowa | Poweshiek | 19157 | 4516 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-28 04:21:04 | Poweshiek, Iowa, US | |
329126 | 329126 | 2022-12-27 | US | Iowa | Louisa | 19115 | 2890 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-12-28 04:21:04 | Louisa, Iowa, US | |
328800 | 328800 | 2022-12-27 | US | Georgia | Turner | 13287 | 3053 | 65 | 0 | 31.71612656 | -83.62069378 | 2022-12-28 04:21:04 | Turner, Georgia, US | |
328706 | 328706 | 2022-12-27 | US | Georgia | Early | 13099 | 3059 | 65 | 0 | 31.32155345 | -84.90255207 | 2022-12-28 04:21:04 | Early, Georgia, US | |
328681 | 328681 | 2022-12-27 | US | Georgia | Charlton | 13049 | 3407 | 65 | 0 | 30.78371028 | -82.13951596 | 2022-12-28 04:21:04 | Charlton, Georgia, US | |
328399 | 328399 | 2022-12-27 | US | Arkansas | Grant | 5053 | 5118 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-28 04:21:04 | Grant, Arkansas, US | |
328019 | 328019 | 2022-12-27 | Monaco | 15929 | 65 | 0 | 43.7333 | 7.4167 | 2022-12-28 04:21:04 | Monaco | ||||
221566 | 221566 | 2022-12-26 | US | Wisconsin | Sawyer | 55113 | 5833 | 65 | 0 | 45.87931905 | -91.14504927 | 2022-12-27 04:21:07 | Sawyer, Wisconsin, US | |
221313 | 221313 | 2022-12-26 | US | Virginia | Dickenson | 51051 | 4650 | 65 | 0 | 37.12560977 | -82.35124171 | 2022-12-27 04:21:07 | Dickenson, Virginia, US | |
220566 | 220566 | 2022-12-26 | US | Oklahoma | Okfuskee | 40107 | 4114 | 65 | 0 | 35.46485198 | -96.32639984 | 2022-12-27 04:21:07 | Okfuskee, Oklahoma, US | |
220126 | 220126 | 2022-12-26 | US | Nevada | Humboldt | 32013 | 2755 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-12-27 04:21:07 | Humboldt, Nevada, US | |
219933 | 219933 | 2022-12-26 | US | Missouri | Pike | 29163 | 5080 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-27 04:21:07 | Pike, Missouri, US | |
219911 | 219911 | 2022-12-26 | US | Missouri | Macon | 29121 | 4197 | 65 | 0 | 39.83049768 | -92.56453089 | 2022-12-27 04:21:07 | Macon, Missouri, US | |
219823 | 219823 | 2022-12-26 | US | Mississippi | Perry | 28111 | 3601 | 65 | 0 | 31.17161885 | -88.99281835 | 2022-12-27 04:21:07 | Perry, Mississippi, US | |
219760 | 219760 | 2022-12-26 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-27 04:21:07 | Wadena, Minnesota, US | |
219732 | 219732 | 2022-12-26 | US | Minnesota | Nobles | 27105 | 7794 | 65 | 0 | 43.67434621 | -95.75329576 | 2022-12-27 04:21:07 | Nobles, Minnesota, US | |
219680 | 219680 | 2022-12-26 | US | Minnesota | Aitkin | 27001 | 3612 | 65 | 0 | 46.60962049 | -93.4116826 | 2022-12-27 04:21:07 | Aitkin, Minnesota, US | |
219418 | 219418 | 2022-12-26 | US | Kentucky | Livingston | 21139 | 3013 | 65 | 0 | 37.21137452 | -88.34797529 | 2022-12-27 04:21:07 | Livingston, Kentucky, US | |
219365 | 219365 | 2022-12-26 | US | Kentucky | Caldwell | 21033 | 4869 | 65 | 0 | 37.14749129 | -87.86948214 | 2022-12-27 04:21:07 | Caldwell, Kentucky, US | |
219220 | 219220 | 2022-12-26 | US | Iowa | Poweshiek | 19157 | 4516 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-27 04:21:07 | Poweshiek, Iowa, US | |
219199 | 219199 | 2022-12-26 | US | Iowa | Louisa | 19115 | 2890 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-12-27 04:21:07 | Louisa, Iowa, US | |
218873 | 218873 | 2022-12-26 | US | Georgia | Turner | 13287 | 3053 | 65 | 0 | 31.71612656 | -83.62069378 | 2022-12-27 04:21:07 | Turner, Georgia, US | |
218779 | 218779 | 2022-12-26 | US | Georgia | Early | 13099 | 3059 | 65 | 0 | 31.32155345 | -84.90255207 | 2022-12-27 04:21:07 | Early, Georgia, US | |
218754 | 218754 | 2022-12-26 | US | Georgia | Charlton | 13049 | 3407 | 65 | 0 | 30.78371028 | -82.13951596 | 2022-12-27 04:21:07 | Charlton, Georgia, US | |
218472 | 218472 | 2022-12-26 | US | Arkansas | Grant | 5053 | 5116 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-27 04:21:07 | Grant, Arkansas, US | |
218092 | 218092 | 2022-12-26 | Monaco | 15911 | 65 | 0 | 43.7333 | 7.4167 | 2022-12-27 04:21:07 | Monaco | ||||
3226023 | 3226023 | 2022-12-25 | US | Wisconsin | Sawyer | 55113 | 5828 | 65 | 0 | 45.87931905 | -91.14504927 | 2022-12-26 04:21:06 | Sawyer, Wisconsin, US | |
3225770 | 3225770 | 2022-12-25 | US | Virginia | Dickenson | 51051 | 4647 | 65 | 0 | 37.12560977 | -82.35124171 | 2022-12-26 04:21:06 | Dickenson, Virginia, US | |
3225023 | 3225023 | 2022-12-25 | US | Oklahoma | Okfuskee | 40107 | 4114 | 65 | 0 | 35.46485198 | -96.32639984 | 2022-12-26 04:21:06 | Okfuskee, Oklahoma, US | |
3224583 | 3224583 | 2022-12-25 | US | Nevada | Humboldt | 32013 | 2755 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-12-26 04:21:06 | Humboldt, Nevada, US | |
3224390 | 3224390 | 2022-12-25 | US | Missouri | Pike | 29163 | 5080 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-26 04:21:06 | Pike, Missouri, US | |
3224368 | 3224368 | 2022-12-25 | US | Missouri | Macon | 29121 | 4197 | 65 | 0 | 39.83049768 | -92.56453089 | 2022-12-26 04:21:06 | Macon, Missouri, US | |
3224280 | 3224280 | 2022-12-25 | US | Mississippi | Perry | 28111 | 3601 | 65 | 0 | 31.17161885 | -88.99281835 | 2022-12-26 04:21:06 | Perry, Mississippi, US | |
3224217 | 3224217 | 2022-12-25 | US | Minnesota | Wadena | 27159 | 5069 | 65 | 0 | 46.58589171 | -94.96968506 | 2022-12-26 04:21:06 | Wadena, Minnesota, US | |
3224189 | 3224189 | 2022-12-25 | US | Minnesota | Nobles | 27105 | 7794 | 65 | 0 | 43.67434621 | -95.75329576 | 2022-12-26 04:21:06 | Nobles, Minnesota, US | |
3224137 | 3224137 | 2022-12-25 | US | Minnesota | Aitkin | 27001 | 3612 | 65 | 0 | 46.60962049 | -93.4116826 | 2022-12-26 04:21:06 | Aitkin, Minnesota, US | |
3223875 | 3223875 | 2022-12-25 | US | Kentucky | Livingston | 21139 | 3013 | 65 | 0 | 37.21137452 | -88.34797529 | 2022-12-26 04:21:06 | Livingston, Kentucky, US | |
3223822 | 3223822 | 2022-12-25 | US | Kentucky | Caldwell | 21033 | 4869 | 65 | 0 | 37.14749129 | -87.86948214 | 2022-12-26 04:21:06 | Caldwell, Kentucky, US | |
3223677 | 3223677 | 2022-12-25 | US | Iowa | Poweshiek | 19157 | 4516 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-26 04:21:06 | Poweshiek, Iowa, US | |
3223656 | 3223656 | 2022-12-25 | US | Iowa | Louisa | 19115 | 2890 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-12-26 04:21:06 | Louisa, Iowa, US | |
3223330 | 3223330 | 2022-12-25 | US | Georgia | Turner | 13287 | 3053 | 65 | 0 | 31.71612656 | -83.62069378 | 2022-12-26 04:21:06 | Turner, Georgia, US | |
3223236 | 3223236 | 2022-12-25 | US | Georgia | Early | 13099 | 3059 | 65 | 0 | 31.32155345 | -84.90255207 | 2022-12-26 04:21:06 | Early, Georgia, US | |
3223211 | 3223211 | 2022-12-25 | US | Georgia | Charlton | 13049 | 3407 | 65 | 0 | 30.78371028 | -82.13951596 | 2022-12-26 04:21:06 | Charlton, Georgia, US | |
3222929 | 3222929 | 2022-12-25 | US | Arkansas | Grant | 5053 | 5115 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-26 04:21:06 | Grant, Arkansas, US | |
3222549 | 3222549 | 2022-12-25 | Monaco | 15911 | 65 | 0 | 43.7333 | 7.4167 | 2022-12-26 04:21:06 | Monaco | ||||
1021937 | 1021937 | 2022-12-24 | US | Wisconsin | Sawyer | 55113 | 5828 | 65 | 0 | 45.87931905 | -91.14504927 | 2022-12-25 04:21:04 | Sawyer, Wisconsin, US | |
1021684 | 1021684 | 2022-12-24 | US | Virginia | Dickenson | 51051 | 4647 | 65 | 0 | 37.12560977 | -82.35124171 | 2022-12-25 04:21:04 | Dickenson, Virginia, US | |
1020937 | 1020937 | 2022-12-24 | US | Oklahoma | Okfuskee | 40107 | 4114 | 65 | 0 | 35.46485198 | -96.32639984 | 2022-12-25 04:21:04 | Okfuskee, Oklahoma, US | |
1020497 | 1020497 | 2022-12-24 | US | Nevada | Humboldt | 32013 | 2755 | 65 | 0 | 41.40692186 | -118.1109427 | 2022-12-25 04:21:04 | Humboldt, Nevada, US | |
1020304 | 1020304 | 2022-12-24 | US | Missouri | Pike | 29163 | 5080 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-25 04:21:04 | Pike, Missouri, US | |
1020282 | 1020282 | 2022-12-24 | US | Missouri | Macon | 29121 | 4197 | 65 | 0 | 39.83049768 | -92.56453089 | 2022-12-25 04:21:04 | Macon, Missouri, US | |
1020194 | 1020194 | 2022-12-24 | US | Mississippi | Perry | 28111 | 3601 | 65 | 0 | 31.17161885 | -88.99281835 | 2022-12-25 04:21:04 | Perry, Mississippi, 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]);