johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7,429 rows where deaths = 99 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 6,889
- Russia 122
- Japan 119
- Spain 29
- Somalia 24
- Central African Republic 17
- Sweden 17
- France 16
- Ukraine 15
- Colombia 14
- Pakistan 14
- Chile 10
- Netherlands 10
- Malaysia 9
- Chad 8
- Gambia 7
- Nicaragua 7
- Peru 7
- United Kingdom 7
- India 6
- Benin 5
- Congo (Brazzaville) 5
- Mozambique 5
- Antigua and Barbuda 4
- China 4
- Mexico 4
- Saint Vincent and the Grenadines 4
- Brazil 3
- Canada 3
- Croatia 3
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756419 | 2756419 | 2022-12-29 | US | West Virginia | Randolph | 54083 | 11794 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-30 04:21:04 | Randolph, West Virginia, US | |
2756068 | 2756068 | 2022-12-29 | US | Texas | Llano | 48299 | 4952 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-30 04:21:04 | Llano, Texas, US | |
2755605 | 2755605 | 2022-12-29 | US | Pennsylvania | Potter | 42105 | 3782 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-30 04:21:04 | Potter, Pennsylvania, US | |
2754606 | 2754606 | 2022-12-29 | US | Minnesota | Becker | 27005 | 10292 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-30 04:21:04 | Becker, Minnesota, US | |
2754553 | 2754553 | 2022-12-29 | US | Michigan | Iron | 26071 | 3469 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-30 04:21:04 | Iron, Michigan, US | |
2754415 | 2754415 | 2022-12-29 | US | Louisiana | Grant | 22043 | 7233 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-30 04:21:04 | Grant, Louisiana, US | |
2753394 | 2753394 | 2022-12-29 | US | Arkansas | Fulton | 5049 | 3062 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-30 04:21:04 | Fulton, Arkansas, US | |
1077425 | 1077425 | 2022-12-28 | US | West Virginia | Randolph | 54083 | 11788 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-29 04:21:01 | Randolph, West Virginia, US | |
1077074 | 1077074 | 2022-12-28 | US | Texas | Llano | 48299 | 4952 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-29 04:21:01 | Llano, Texas, US | |
1076611 | 1076611 | 2022-12-28 | US | Pennsylvania | Potter | 42105 | 3782 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-29 04:21:01 | Potter, Pennsylvania, US | |
1075612 | 1075612 | 2022-12-28 | US | Minnesota | Becker | 27005 | 10270 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-29 04:21:01 | Becker, Minnesota, US | |
1075559 | 1075559 | 2022-12-28 | US | Michigan | Iron | 26071 | 3469 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-29 04:21:01 | Iron, Michigan, US | |
1075421 | 1075421 | 2022-12-28 | US | Louisiana | Grant | 22043 | 7233 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-29 04:21:01 | Grant, Louisiana, US | |
1074400 | 1074400 | 2022-12-28 | US | Arkansas | Fulton | 5049 | 3062 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-29 04:21:01 | Fulton, Arkansas, US | |
331422 | 331422 | 2022-12-27 | US | West Virginia | Randolph | 54083 | 11779 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-28 04:21:04 | Randolph, West Virginia, US | |
331071 | 331071 | 2022-12-27 | US | Texas | Llano | 48299 | 4906 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-28 04:21:04 | Llano, Texas, US | |
330608 | 330608 | 2022-12-27 | US | Pennsylvania | Potter | 42105 | 3778 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-28 04:21:04 | Potter, Pennsylvania, US | |
329609 | 329609 | 2022-12-27 | US | Minnesota | Becker | 27005 | 10270 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-28 04:21:04 | Becker, Minnesota, US | |
329556 | 329556 | 2022-12-27 | US | Michigan | Iron | 26071 | 3469 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-28 04:21:04 | Iron, Michigan, US | |
329418 | 329418 | 2022-12-27 | US | Louisiana | Grant | 22043 | 7168 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-28 04:21:04 | Grant, Louisiana, US | |
328397 | 328397 | 2022-12-27 | US | Arkansas | Fulton | 5049 | 3062 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-28 04:21:04 | Fulton, Arkansas, US | |
221495 | 221495 | 2022-12-26 | US | West Virginia | Randolph | 54083 | 11749 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-27 04:21:07 | Randolph, West Virginia, US | |
221144 | 221144 | 2022-12-26 | US | Texas | Llano | 48299 | 4906 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-27 04:21:07 | Llano, Texas, US | |
220681 | 220681 | 2022-12-26 | US | Pennsylvania | Potter | 42105 | 3778 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-27 04:21:07 | Potter, Pennsylvania, US | |
220198 | 220198 | 2022-12-26 | US | New Mexico | Socorro | 35053 | 4652 | 99 | 0 | 34.00715494 | -106.9298354 | 2022-12-27 04:21:07 | Socorro, New Mexico, US | |
219682 | 219682 | 2022-12-26 | US | Minnesota | Becker | 27005 | 10270 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-27 04:21:07 | Becker, Minnesota, US | |
219629 | 219629 | 2022-12-26 | US | Michigan | Iron | 26071 | 3455 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-27 04:21:07 | Iron, Michigan, US | |
219491 | 219491 | 2022-12-26 | US | Louisiana | Grant | 22043 | 7168 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-27 04:21:07 | Grant, Louisiana, US | |
218470 | 218470 | 2022-12-26 | US | Arkansas | Fulton | 5049 | 3063 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-27 04:21:07 | Fulton, Arkansas, US | |
3225952 | 3225952 | 2022-12-25 | US | West Virginia | Randolph | 54083 | 11749 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-26 04:21:06 | Randolph, West Virginia, US | |
3225601 | 3225601 | 2022-12-25 | US | Texas | Llano | 48299 | 4906 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-26 04:21:06 | Llano, Texas, US | |
3225138 | 3225138 | 2022-12-25 | US | Pennsylvania | Potter | 42105 | 3778 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-26 04:21:06 | Potter, Pennsylvania, US | |
3224655 | 3224655 | 2022-12-25 | US | New Mexico | Socorro | 35053 | 4652 | 99 | 0 | 34.00715494 | -106.9298354 | 2022-12-26 04:21:06 | Socorro, New Mexico, US | |
3224139 | 3224139 | 2022-12-25 | US | Minnesota | Becker | 27005 | 10270 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-26 04:21:06 | Becker, Minnesota, US | |
3224086 | 3224086 | 2022-12-25 | US | Michigan | Iron | 26071 | 3455 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-26 04:21:06 | Iron, Michigan, US | |
3223948 | 3223948 | 2022-12-25 | US | Louisiana | Grant | 22043 | 7168 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-26 04:21:06 | Grant, Louisiana, US | |
3222927 | 3222927 | 2022-12-25 | US | Arkansas | Fulton | 5049 | 3063 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-26 04:21:06 | Fulton, Arkansas, US | |
1021866 | 1021866 | 2022-12-24 | US | West Virginia | Randolph | 54083 | 11749 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-25 04:21:04 | Randolph, West Virginia, US | |
1021515 | 1021515 | 2022-12-24 | US | Texas | Llano | 48299 | 4906 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-25 04:21:04 | Llano, Texas, US | |
1021052 | 1021052 | 2022-12-24 | US | Pennsylvania | Potter | 42105 | 3778 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-25 04:21:04 | Potter, Pennsylvania, US | |
1020569 | 1020569 | 2022-12-24 | US | New Mexico | Socorro | 35053 | 4652 | 99 | 0 | 34.00715494 | -106.9298354 | 2022-12-25 04:21:04 | Socorro, New Mexico, US | |
1020053 | 1020053 | 2022-12-24 | US | Minnesota | Becker | 27005 | 10270 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-25 04:21:04 | Becker, Minnesota, US | |
1020000 | 1020000 | 2022-12-24 | US | Michigan | Iron | 26071 | 3455 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-25 04:21:04 | Iron, Michigan, US | |
1019862 | 1019862 | 2022-12-24 | US | Louisiana | Grant | 22043 | 7168 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-25 04:21:04 | Grant, Louisiana, US | |
1018841 | 1018841 | 2022-12-24 | US | Arkansas | Fulton | 5049 | 3063 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-25 04:21:04 | Fulton, Arkansas, US | |
693889 | 693889 | 2022-12-23 | US | West Virginia | Randolph | 54083 | 11749 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-24 04:21:02 | Randolph, West Virginia, US | |
693538 | 693538 | 2022-12-23 | US | Texas | Llano | 48299 | 4906 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-24 04:21:02 | Llano, Texas, US | |
693075 | 693075 | 2022-12-23 | US | Pennsylvania | Potter | 42105 | 3778 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-24 04:21:02 | Potter, Pennsylvania, US | |
692592 | 692592 | 2022-12-23 | US | New Mexico | Socorro | 35053 | 4652 | 99 | 0 | 34.00715494 | -106.9298354 | 2022-12-24 04:21:02 | Socorro, New Mexico, US | |
692076 | 692076 | 2022-12-23 | US | Minnesota | Becker | 27005 | 10270 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-24 04:21:02 | Becker, Minnesota, US | |
692023 | 692023 | 2022-12-23 | US | Michigan | Iron | 26071 | 3455 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-24 04:21:02 | Iron, Michigan, US | |
691885 | 691885 | 2022-12-23 | US | Louisiana | Grant | 22043 | 7168 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-24 04:21:02 | Grant, Louisiana, US | |
690864 | 690864 | 2022-12-23 | US | Arkansas | Fulton | 5049 | 3063 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-24 04:21:02 | Fulton, Arkansas, US | |
2183099 | 2183099 | 2022-12-22 | US | West Virginia | Randolph | 54083 | 11749 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-23 04:21:04 | Randolph, West Virginia, US | |
2182748 | 2182748 | 2022-12-22 | US | Texas | Llano | 48299 | 4906 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-23 04:21:04 | Llano, Texas, US | |
2182285 | 2182285 | 2022-12-22 | US | Pennsylvania | Potter | 42105 | 3778 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-23 04:21:04 | Potter, Pennsylvania, US | |
2181286 | 2181286 | 2022-12-22 | US | Minnesota | Becker | 27005 | 10270 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-23 04:21:04 | Becker, Minnesota, US | |
2181233 | 2181233 | 2022-12-22 | US | Michigan | Iron | 26071 | 3455 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-23 04:21:04 | Iron, Michigan, US | |
2181095 | 2181095 | 2022-12-22 | US | Louisiana | Grant | 22043 | 7168 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-23 04:21:04 | Grant, Louisiana, US | |
2180074 | 2180074 | 2022-12-22 | US | Arkansas | Fulton | 5049 | 3063 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-23 04:21:04 | Fulton, Arkansas, US | |
454903 | 454903 | 2022-12-21 | US | West Virginia | Randolph | 54083 | 11747 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-22 04:20:56 | Randolph, West Virginia, US | |
454552 | 454552 | 2022-12-21 | US | Texas | Llano | 48299 | 4906 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-22 04:20:56 | Llano, Texas, US | |
454089 | 454089 | 2022-12-21 | US | Pennsylvania | Potter | 42105 | 3778 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-22 04:20:56 | Potter, Pennsylvania, US | |
453090 | 453090 | 2022-12-21 | US | Minnesota | Becker | 27005 | 10256 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-22 04:20:56 | Becker, Minnesota, US | |
453037 | 453037 | 2022-12-21 | US | Michigan | Iron | 26071 | 3455 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-22 04:20:56 | Iron, Michigan, US | |
452899 | 452899 | 2022-12-21 | US | Louisiana | Grant | 22043 | 7168 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-22 04:20:56 | Grant, Louisiana, US | |
451878 | 451878 | 2022-12-21 | US | Arkansas | Fulton | 5049 | 3060 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-22 04:20:56 | Fulton, Arkansas, US | |
2954902 | 2954902 | 2022-12-20 | US | West Virginia | Randolph | 54083 | 11730 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-21 04:21:03 | Randolph, West Virginia, US | |
2954088 | 2954088 | 2022-12-20 | US | Pennsylvania | Potter | 42105 | 3771 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-21 04:21:03 | Potter, Pennsylvania, US | |
2953089 | 2953089 | 2022-12-20 | US | Minnesota | Becker | 27005 | 10256 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-21 04:21:03 | Becker, Minnesota, US | |
2953036 | 2953036 | 2022-12-20 | US | Michigan | Iron | 26071 | 3455 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-21 04:21:03 | Iron, Michigan, US | |
2952898 | 2952898 | 2022-12-20 | US | Louisiana | Grant | 22043 | 7002 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-21 04:21:03 | Grant, Louisiana, US | |
2952633 | 2952633 | 2022-12-20 | US | Iowa | Story | 19169 | 22687 | 99 | 0 | 42.03621213 | -93.46499005 | 2022-12-21 04:21:03 | Story, Iowa, US | |
2951877 | 2951877 | 2022-12-20 | US | Arkansas | Fulton | 5049 | 3058 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-21 04:21:03 | Fulton, Arkansas, US | |
3177304 | 3177304 | 2022-12-19 | US | West Virginia | Randolph | 54083 | 11727 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-20 04:21:04 | Randolph, West Virginia, US | |
3176490 | 3176490 | 2022-12-19 | US | Pennsylvania | Potter | 42105 | 3771 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-20 04:21:04 | Potter, Pennsylvania, US | |
3175491 | 3175491 | 2022-12-19 | US | Minnesota | Becker | 27005 | 10256 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-20 04:21:04 | Becker, Minnesota, US | |
3175438 | 3175438 | 2022-12-19 | US | Michigan | Iron | 26071 | 3433 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-20 04:21:04 | Iron, Michigan, US | |
3175300 | 3175300 | 2022-12-19 | US | Louisiana | Grant | 22043 | 7002 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-20 04:21:04 | Grant, Louisiana, US | |
3175035 | 3175035 | 2022-12-19 | US | Iowa | Story | 19169 | 22687 | 99 | 0 | 42.03621213 | -93.46499005 | 2022-12-20 04:21:04 | Story, Iowa, US | |
3174279 | 3174279 | 2022-12-19 | US | Arkansas | Fulton | 5049 | 3057 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-20 04:21:04 | Fulton, Arkansas, US | |
1631821 | 1631821 | 2022-12-18 | US | West Virginia | Randolph | 54083 | 11718 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-19 04:21:03 | Randolph, West Virginia, US | |
1631007 | 1631007 | 2022-12-18 | US | Pennsylvania | Potter | 42105 | 3771 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-19 04:21:03 | Potter, Pennsylvania, US | |
1630008 | 1630008 | 2022-12-18 | US | Minnesota | Becker | 27005 | 10256 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-19 04:21:03 | Becker, Minnesota, US | |
1629955 | 1629955 | 2022-12-18 | US | Michigan | Iron | 26071 | 3433 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-19 04:21:03 | Iron, Michigan, US | |
1629817 | 1629817 | 2022-12-18 | US | Louisiana | Grant | 22043 | 7002 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-19 04:21:03 | Grant, Louisiana, US | |
1629552 | 1629552 | 2022-12-18 | US | Iowa | Story | 19169 | 22687 | 99 | 0 | 42.03621213 | -93.46499005 | 2022-12-19 04:21:03 | Story, Iowa, US | |
1628796 | 1628796 | 2022-12-18 | US | Arkansas | Fulton | 5049 | 3056 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-19 04:21:03 | Fulton, Arkansas, US | |
507200 | 507200 | 2022-12-17 | US | West Virginia | Randolph | 54083 | 11718 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-18 04:21:03 | Randolph, West Virginia, US | |
506386 | 506386 | 2022-12-17 | US | Pennsylvania | Potter | 42105 | 3771 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-18 04:21:03 | Potter, Pennsylvania, US | |
505387 | 505387 | 2022-12-17 | US | Minnesota | Becker | 27005 | 10256 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-18 04:21:03 | Becker, Minnesota, US | |
505334 | 505334 | 2022-12-17 | US | Michigan | Iron | 26071 | 3433 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-18 04:21:03 | Iron, Michigan, US | |
505196 | 505196 | 2022-12-17 | US | Louisiana | Grant | 22043 | 7002 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-18 04:21:03 | Grant, Louisiana, US | |
504931 | 504931 | 2022-12-17 | US | Iowa | Story | 19169 | 22687 | 99 | 0 | 42.03621213 | -93.46499005 | 2022-12-18 04:21:03 | Story, Iowa, US | |
504175 | 504175 | 2022-12-17 | US | Arkansas | Fulton | 5049 | 3056 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-18 04:21:03 | Fulton, Arkansas, US | |
3327772 | 3327772 | 2022-12-16 | US | West Virginia | Randolph | 54083 | 11718 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-17 04:21:04 | Randolph, West Virginia, US | |
3326958 | 3326958 | 2022-12-16 | US | Pennsylvania | Potter | 42105 | 3771 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-12-17 04:21:04 | Potter, Pennsylvania, US | |
3325959 | 3325959 | 2022-12-16 | US | Minnesota | Becker | 27005 | 10256 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-12-17 04:21:04 | Becker, Minnesota, US | |
3325906 | 3325906 | 2022-12-16 | US | Michigan | Iron | 26071 | 3433 | 99 | 0 | 46.20974132 | -88.53136251 | 2022-12-17 04:21:04 | Iron, Michigan, US | |
3325768 | 3325768 | 2022-12-16 | US | Louisiana | Grant | 22043 | 7002 | 99 | 0 | 31.59882456 | -92.56124347 | 2022-12-17 04:21:04 | Grant, Louisiana, 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]);