johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11,021 rows where deaths = 79 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 10,289
- Sierra Leone 130
- Japan 116
- Russia 101
- Chile 46
- United Kingdom 28
- Australia 26
- Sweden 23
- France 19
- Netherlands 17
- Colombia 16
- India 16
- Ukraine 16
- Seychelles 12
- Peru 10
- Cuba 8
- Liechtenstein 8
- Spain 8
- Guinea 7
- Chad 6
- Guinea-Bissau 6
- Tajikistan 6
- Thailand 6
- Togo 6
- Andorra 5
- Canada 5
- Italy 5
- Somalia 5
- Liberia 4
- San Marino 4
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756116 | 2756116 | 2022-12-29 | US | Texas | Robertson | 48395 | 5227 | 79 | 0 | 31.02539637 | -96.51272246 | 2022-12-30 04:21:04 | Robertson, Texas, US | |
2755965 | 2755965 | 2022-12-29 | US | Texas | Comanche | 48093 | 3942 | 79 | 0 | 31.94854689 | -98.55876441 | 2022-12-30 04:21:04 | Comanche, Texas, US | |
2755852 | 2755852 | 2022-12-29 | US | Tennessee | Grundy | 47061 | 4522 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-12-30 04:21:04 | Grundy, Tennessee, US | |
2755007 | 2755007 | 2022-12-29 | US | Nebraska | Madison | 31119 | 11045 | 79 | 0 | 41.91676024 | -97.6005481 | 2022-12-30 04:21:04 | Madison, Nebraska, US | |
2754722 | 2754722 | 2022-12-29 | US | Mississippi | Jasper | 28061 | 5908 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-30 04:21:04 | Jasper, Mississippi, US | |
2754441 | 2754441 | 2022-12-29 | US | Louisiana | St. James | 22093 | 7150 | 79 | 0 | 30.02531716 | -90.80212061 | 2022-12-30 04:21:04 | St. James, Louisiana, US | |
2754375 | 2754375 | 2022-12-29 | US | Kentucky | Rowan | 21205 | 9404 | 79 | 0 | 38.19484205 | -83.42088935 | 2022-12-30 04:21:04 | Rowan, Kentucky, US | |
2754275 | 2754275 | 2022-12-29 | US | Kentucky | Anderson | 21005 | 8252 | 79 | 0 | 38.00671029 | -84.99171713 | 2022-12-30 04:21:04 | Anderson, Kentucky, US | |
2754087 | 2754087 | 2022-12-29 | US | Iowa | Clayton | 19043 | 3974 | 79 | 0 | 42.84443388 | -91.34133693 | 2022-12-30 04:21:04 | Clayton, Iowa, US | |
2754049 | 2754049 | 2022-12-29 | US | Indiana | Sullivan | 18153 | 6167 | 79 | 0 | 39.08952258 | -87.41414469 | 2022-12-30 04:21:04 | Sullivan, Indiana, US | |
2753398 | 2753398 | 2022-12-29 | US | Arkansas | Hempstead | 5057 | 5513 | 79 | 0 | 33.73325583 | -93.66935133 | 2022-12-30 04:21:04 | Hempstead, Arkansas, US | |
2753391 | 2753391 | 2022-12-29 | US | Arkansas | Drew | 5043 | 5460 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-12-30 04:21:04 | Drew, Arkansas, US | |
2753285 | 2753285 | 2022-12-29 | US | Alabama | Henry | 1067 | 5574 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-12-30 04:21:04 | Henry, Alabama, US | |
1077122 | 1077122 | 2022-12-28 | US | Texas | Robertson | 48395 | 5227 | 79 | 0 | 31.02539637 | -96.51272246 | 2022-12-29 04:21:01 | Robertson, Texas, US | |
1076971 | 1076971 | 2022-12-28 | US | Texas | Comanche | 48093 | 3942 | 79 | 0 | 31.94854689 | -98.55876441 | 2022-12-29 04:21:01 | Comanche, Texas, US | |
1076858 | 1076858 | 2022-12-28 | US | Tennessee | Grundy | 47061 | 4522 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-12-29 04:21:01 | Grundy, Tennessee, US | |
1076013 | 1076013 | 2022-12-28 | US | Nebraska | Madison | 31119 | 11045 | 79 | 0 | 41.91676024 | -97.6005481 | 2022-12-29 04:21:01 | Madison, Nebraska, US | |
1075728 | 1075728 | 2022-12-28 | US | Mississippi | Jasper | 28061 | 5908 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-29 04:21:01 | Jasper, Mississippi, US | |
1075447 | 1075447 | 2022-12-28 | US | Louisiana | St. James | 22093 | 7150 | 79 | 0 | 30.02531716 | -90.80212061 | 2022-12-29 04:21:01 | St. James, Louisiana, US | |
1075381 | 1075381 | 2022-12-28 | US | Kentucky | Rowan | 21205 | 9404 | 79 | 0 | 38.19484205 | -83.42088935 | 2022-12-29 04:21:01 | Rowan, Kentucky, US | |
1075281 | 1075281 | 2022-12-28 | US | Kentucky | Anderson | 21005 | 8252 | 79 | 0 | 38.00671029 | -84.99171713 | 2022-12-29 04:21:01 | Anderson, Kentucky, US | |
1075093 | 1075093 | 2022-12-28 | US | Iowa | Clayton | 19043 | 3974 | 79 | 0 | 42.84443388 | -91.34133693 | 2022-12-29 04:21:01 | Clayton, Iowa, US | |
1075055 | 1075055 | 2022-12-28 | US | Indiana | Sullivan | 18153 | 6167 | 79 | 0 | 39.08952258 | -87.41414469 | 2022-12-29 04:21:01 | Sullivan, Indiana, US | |
1074404 | 1074404 | 2022-12-28 | US | Arkansas | Hempstead | 5057 | 5513 | 79 | 0 | 33.73325583 | -93.66935133 | 2022-12-29 04:21:01 | Hempstead, Arkansas, US | |
1074397 | 1074397 | 2022-12-28 | US | Arkansas | Drew | 5043 | 5460 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-12-29 04:21:01 | Drew, Arkansas, US | |
1074291 | 1074291 | 2022-12-28 | US | Alabama | Henry | 1067 | 5574 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-12-29 04:21:01 | Henry, Alabama, US | |
331342 | 331342 | 2022-12-27 | US | Washington | Asotin | 53003 | 5425 | 79 | 0 | 46.18894415 | -117.2022851 | 2022-12-28 04:21:04 | Asotin, Washington, US | |
331119 | 331119 | 2022-12-27 | US | Texas | Robertson | 48395 | 5218 | 79 | 0 | 31.02539637 | -96.51272246 | 2022-12-28 04:21:04 | Robertson, Texas, US | |
330968 | 330968 | 2022-12-27 | US | Texas | Comanche | 48093 | 3933 | 79 | 0 | 31.94854689 | -98.55876441 | 2022-12-28 04:21:04 | Comanche, Texas, US | |
330855 | 330855 | 2022-12-27 | US | Tennessee | Grundy | 47061 | 4522 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-12-28 04:21:04 | Grundy, Tennessee, US | |
330010 | 330010 | 2022-12-27 | US | Nebraska | Madison | 31119 | 11045 | 79 | 0 | 41.91676024 | -97.6005481 | 2022-12-28 04:21:04 | Madison, Nebraska, US | |
329725 | 329725 | 2022-12-27 | US | Mississippi | Jasper | 28061 | 5908 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-28 04:21:04 | Jasper, Mississippi, US | |
329444 | 329444 | 2022-12-27 | US | Louisiana | St. James | 22093 | 7118 | 79 | 0 | 30.02531716 | -90.80212061 | 2022-12-28 04:21:04 | St. James, Louisiana, US | |
329378 | 329378 | 2022-12-27 | US | Kentucky | Rowan | 21205 | 9404 | 79 | 0 | 38.19484205 | -83.42088935 | 2022-12-28 04:21:04 | Rowan, Kentucky, US | |
329278 | 329278 | 2022-12-27 | US | Kentucky | Anderson | 21005 | 8252 | 79 | 0 | 38.00671029 | -84.99171713 | 2022-12-28 04:21:04 | Anderson, Kentucky, US | |
329090 | 329090 | 2022-12-27 | US | Iowa | Clayton | 19043 | 3969 | 79 | 0 | 42.84443388 | -91.34133693 | 2022-12-28 04:21:04 | Clayton, Iowa, US | |
329052 | 329052 | 2022-12-27 | US | Indiana | Sullivan | 18153 | 6167 | 79 | 0 | 39.08952258 | -87.41414469 | 2022-12-28 04:21:04 | Sullivan, Indiana, US | |
328401 | 328401 | 2022-12-27 | US | Arkansas | Hempstead | 5057 | 5510 | 79 | 0 | 33.73325583 | -93.66935133 | 2022-12-28 04:21:04 | Hempstead, Arkansas, US | |
328394 | 328394 | 2022-12-27 | US | Arkansas | Drew | 5043 | 5457 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-12-28 04:21:04 | Drew, Arkansas, US | |
328288 | 328288 | 2022-12-27 | US | Alabama | Henry | 1067 | 5574 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-12-28 04:21:04 | Henry, Alabama, US | |
221415 | 221415 | 2022-12-26 | US | Washington | Asotin | 53003 | 5425 | 79 | 0 | 46.18894415 | -117.2022851 | 2022-12-27 04:21:07 | Asotin, Washington, US | |
221192 | 221192 | 2022-12-26 | US | Texas | Robertson | 48395 | 5218 | 79 | 0 | 31.02539637 | -96.51272246 | 2022-12-27 04:21:07 | Robertson, Texas, US | |
221041 | 221041 | 2022-12-26 | US | Texas | Comanche | 48093 | 3933 | 79 | 0 | 31.94854689 | -98.55876441 | 2022-12-27 04:21:07 | Comanche, Texas, US | |
220928 | 220928 | 2022-12-26 | US | Tennessee | Grundy | 47061 | 4522 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-12-27 04:21:07 | Grundy, Tennessee, US | |
220083 | 220083 | 2022-12-26 | US | Nebraska | Madison | 31119 | 11045 | 79 | 0 | 41.91676024 | -97.6005481 | 2022-12-27 04:21:07 | Madison, Nebraska, US | |
219798 | 219798 | 2022-12-26 | US | Mississippi | Jasper | 28061 | 5892 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-27 04:21:07 | Jasper, Mississippi, US | |
219517 | 219517 | 2022-12-26 | US | Louisiana | St. James | 22093 | 7118 | 79 | 0 | 30.02531716 | -90.80212061 | 2022-12-27 04:21:07 | St. James, Louisiana, US | |
219451 | 219451 | 2022-12-26 | US | Kentucky | Rowan | 21205 | 9317 | 79 | 0 | 38.19484205 | -83.42088935 | 2022-12-27 04:21:07 | Rowan, Kentucky, US | |
219351 | 219351 | 2022-12-26 | US | Kentucky | Anderson | 21005 | 8214 | 79 | 0 | 38.00671029 | -84.99171713 | 2022-12-27 04:21:07 | Anderson, Kentucky, US | |
219163 | 219163 | 2022-12-26 | US | Iowa | Clayton | 19043 | 3969 | 79 | 0 | 42.84443388 | -91.34133693 | 2022-12-27 04:21:07 | Clayton, Iowa, US | |
219125 | 219125 | 2022-12-26 | US | Indiana | Sullivan | 18153 | 6167 | 79 | 0 | 39.08952258 | -87.41414469 | 2022-12-27 04:21:07 | Sullivan, Indiana, US | |
218474 | 218474 | 2022-12-26 | US | Arkansas | Hempstead | 5057 | 5510 | 79 | 0 | 33.73325583 | -93.66935133 | 2022-12-27 04:21:07 | Hempstead, Arkansas, US | |
218467 | 218467 | 2022-12-26 | US | Arkansas | Drew | 5043 | 5455 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-12-27 04:21:07 | Drew, Arkansas, US | |
218361 | 218361 | 2022-12-26 | US | Alabama | Henry | 1067 | 5574 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-12-27 04:21:07 | Henry, Alabama, US | |
3225872 | 3225872 | 2022-12-25 | US | Washington | Asotin | 53003 | 5425 | 79 | 0 | 46.18894415 | -117.2022851 | 2022-12-26 04:21:06 | Asotin, Washington, US | |
3225649 | 3225649 | 2022-12-25 | US | Texas | Robertson | 48395 | 5218 | 79 | 0 | 31.02539637 | -96.51272246 | 2022-12-26 04:21:06 | Robertson, Texas, US | |
3225498 | 3225498 | 2022-12-25 | US | Texas | Comanche | 48093 | 3933 | 79 | 0 | 31.94854689 | -98.55876441 | 2022-12-26 04:21:06 | Comanche, Texas, US | |
3225385 | 3225385 | 2022-12-25 | US | Tennessee | Grundy | 47061 | 4522 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-12-26 04:21:06 | Grundy, Tennessee, US | |
3224540 | 3224540 | 2022-12-25 | US | Nebraska | Madison | 31119 | 11045 | 79 | 0 | 41.91676024 | -97.6005481 | 2022-12-26 04:21:06 | Madison, Nebraska, US | |
3224255 | 3224255 | 2022-12-25 | US | Mississippi | Jasper | 28061 | 5892 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-26 04:21:06 | Jasper, Mississippi, US | |
3223974 | 3223974 | 2022-12-25 | US | Louisiana | St. James | 22093 | 7118 | 79 | 0 | 30.02531716 | -90.80212061 | 2022-12-26 04:21:06 | St. James, Louisiana, US | |
3223908 | 3223908 | 2022-12-25 | US | Kentucky | Rowan | 21205 | 9317 | 79 | 0 | 38.19484205 | -83.42088935 | 2022-12-26 04:21:06 | Rowan, Kentucky, US | |
3223808 | 3223808 | 2022-12-25 | US | Kentucky | Anderson | 21005 | 8214 | 79 | 0 | 38.00671029 | -84.99171713 | 2022-12-26 04:21:06 | Anderson, Kentucky, US | |
3223620 | 3223620 | 2022-12-25 | US | Iowa | Clayton | 19043 | 3969 | 79 | 0 | 42.84443388 | -91.34133693 | 2022-12-26 04:21:06 | Clayton, Iowa, US | |
3223582 | 3223582 | 2022-12-25 | US | Indiana | Sullivan | 18153 | 6167 | 79 | 0 | 39.08952258 | -87.41414469 | 2022-12-26 04:21:06 | Sullivan, Indiana, US | |
3222931 | 3222931 | 2022-12-25 | US | Arkansas | Hempstead | 5057 | 5510 | 79 | 0 | 33.73325583 | -93.66935133 | 2022-12-26 04:21:06 | Hempstead, Arkansas, US | |
3222924 | 3222924 | 2022-12-25 | US | Arkansas | Drew | 5043 | 5453 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-12-26 04:21:06 | Drew, Arkansas, US | |
3222818 | 3222818 | 2022-12-25 | US | Alabama | Henry | 1067 | 5574 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-12-26 04:21:06 | Henry, Alabama, US | |
1021786 | 1021786 | 2022-12-24 | US | Washington | Asotin | 53003 | 5425 | 79 | 0 | 46.18894415 | -117.2022851 | 2022-12-25 04:21:04 | Asotin, Washington, US | |
1021563 | 1021563 | 2022-12-24 | US | Texas | Robertson | 48395 | 5218 | 79 | 0 | 31.02539637 | -96.51272246 | 2022-12-25 04:21:04 | Robertson, Texas, US | |
1021412 | 1021412 | 2022-12-24 | US | Texas | Comanche | 48093 | 3933 | 79 | 0 | 31.94854689 | -98.55876441 | 2022-12-25 04:21:04 | Comanche, Texas, US | |
1021299 | 1021299 | 2022-12-24 | US | Tennessee | Grundy | 47061 | 4522 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-12-25 04:21:04 | Grundy, Tennessee, US | |
1020454 | 1020454 | 2022-12-24 | US | Nebraska | Madison | 31119 | 11045 | 79 | 0 | 41.91676024 | -97.6005481 | 2022-12-25 04:21:04 | Madison, Nebraska, US | |
1020169 | 1020169 | 2022-12-24 | US | Mississippi | Jasper | 28061 | 5892 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-25 04:21:04 | Jasper, Mississippi, US | |
1019888 | 1019888 | 2022-12-24 | US | Louisiana | St. James | 22093 | 7118 | 79 | 0 | 30.02531716 | -90.80212061 | 2022-12-25 04:21:04 | St. James, Louisiana, US | |
1019822 | 1019822 | 2022-12-24 | US | Kentucky | Rowan | 21205 | 9317 | 79 | 0 | 38.19484205 | -83.42088935 | 2022-12-25 04:21:04 | Rowan, Kentucky, US | |
1019722 | 1019722 | 2022-12-24 | US | Kentucky | Anderson | 21005 | 8214 | 79 | 0 | 38.00671029 | -84.99171713 | 2022-12-25 04:21:04 | Anderson, Kentucky, US | |
1019534 | 1019534 | 2022-12-24 | US | Iowa | Clayton | 19043 | 3969 | 79 | 0 | 42.84443388 | -91.34133693 | 2022-12-25 04:21:04 | Clayton, Iowa, US | |
1019496 | 1019496 | 2022-12-24 | US | Indiana | Sullivan | 18153 | 6167 | 79 | 0 | 39.08952258 | -87.41414469 | 2022-12-25 04:21:04 | Sullivan, Indiana, US | |
1018845 | 1018845 | 2022-12-24 | US | Arkansas | Hempstead | 5057 | 5510 | 79 | 0 | 33.73325583 | -93.66935133 | 2022-12-25 04:21:04 | Hempstead, Arkansas, US | |
1018838 | 1018838 | 2022-12-24 | US | Arkansas | Drew | 5043 | 5453 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-12-25 04:21:04 | Drew, Arkansas, US | |
1018732 | 1018732 | 2022-12-24 | US | Alabama | Henry | 1067 | 5574 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-12-25 04:21:04 | Henry, Alabama, US | |
693809 | 693809 | 2022-12-23 | US | Washington | Asotin | 53003 | 5425 | 79 | 0 | 46.18894415 | -117.2022851 | 2022-12-24 04:21:02 | Asotin, Washington, US | |
693586 | 693586 | 2022-12-23 | US | Texas | Robertson | 48395 | 5218 | 79 | 0 | 31.02539637 | -96.51272246 | 2022-12-24 04:21:02 | Robertson, Texas, US | |
693435 | 693435 | 2022-12-23 | US | Texas | Comanche | 48093 | 3933 | 79 | 0 | 31.94854689 | -98.55876441 | 2022-12-24 04:21:02 | Comanche, Texas, US | |
693322 | 693322 | 2022-12-23 | US | Tennessee | Grundy | 47061 | 4522 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-12-24 04:21:02 | Grundy, Tennessee, US | |
692477 | 692477 | 2022-12-23 | US | Nebraska | Madison | 31119 | 11045 | 79 | 0 | 41.91676024 | -97.6005481 | 2022-12-24 04:21:02 | Madison, Nebraska, US | |
692192 | 692192 | 2022-12-23 | US | Mississippi | Jasper | 28061 | 5892 | 79 | 0 | 32.01922104 | -89.11786866 | 2022-12-24 04:21:02 | Jasper, Mississippi, US | |
691911 | 691911 | 2022-12-23 | US | Louisiana | St. James | 22093 | 7118 | 79 | 0 | 30.02531716 | -90.80212061 | 2022-12-24 04:21:02 | St. James, Louisiana, US | |
691845 | 691845 | 2022-12-23 | US | Kentucky | Rowan | 21205 | 9317 | 79 | 0 | 38.19484205 | -83.42088935 | 2022-12-24 04:21:02 | Rowan, Kentucky, US | |
691745 | 691745 | 2022-12-23 | US | Kentucky | Anderson | 21005 | 8214 | 79 | 0 | 38.00671029 | -84.99171713 | 2022-12-24 04:21:02 | Anderson, Kentucky, US | |
691557 | 691557 | 2022-12-23 | US | Iowa | Clayton | 19043 | 3969 | 79 | 0 | 42.84443388 | -91.34133693 | 2022-12-24 04:21:02 | Clayton, Iowa, US | |
691519 | 691519 | 2022-12-23 | US | Indiana | Sullivan | 18153 | 6167 | 79 | 0 | 39.08952258 | -87.41414469 | 2022-12-24 04:21:02 | Sullivan, Indiana, US | |
690868 | 690868 | 2022-12-23 | US | Arkansas | Hempstead | 5057 | 5507 | 79 | 0 | 33.73325583 | -93.66935133 | 2022-12-24 04:21:02 | Hempstead, Arkansas, US | |
690861 | 690861 | 2022-12-23 | US | Arkansas | Drew | 5043 | 5448 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-12-24 04:21:02 | Drew, Arkansas, US | |
690755 | 690755 | 2022-12-23 | US | Alabama | Henry | 1067 | 5574 | 79 | 0 | 31.51148016 | -85.24267944 | 2022-12-24 04:21:02 | Henry, Alabama, US | |
2183019 | 2183019 | 2022-12-22 | US | Washington | Asotin | 53003 | 5425 | 79 | 0 | 46.18894415 | -117.2022851 | 2022-12-23 04:21:04 | Asotin, Washington, US | |
2182796 | 2182796 | 2022-12-22 | US | Texas | Robertson | 48395 | 5218 | 79 | 0 | 31.02539637 | -96.51272246 | 2022-12-23 04:21:04 | Robertson, Texas, US | |
2182645 | 2182645 | 2022-12-22 | US | Texas | Comanche | 48093 | 3933 | 79 | 0 | 31.94854689 | -98.55876441 | 2022-12-23 04:21:04 | Comanche, Texas, US | |
2182532 | 2182532 | 2022-12-22 | US | Tennessee | Grundy | 47061 | 4519 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-12-23 04:21:04 | Grundy, Tennessee, 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]);