johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16,323 rows where deaths = 46 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 15,411
- Saint Kitts and Nevis 162
- Russia 150
- Japan 128
- Canada 71
- Sweden 35
- India 25
- Ukraine 23
- Colombia 20
- Chile 18
- Guinea-Bissau 17
- Gabon 16
- Australia 15
- France 14
- Netherlands 11
- Benin 10
- Peru 10
- Maldives 9
- South Sudan 8
- United Kingdom 8
- Guinea 7
- Nicaragua 7
- Spain 7
- Barbados 6
- Iceland 6
- Malaysia 6
- Monaco 6
- Uruguay 6
- Honduras 5
- Pakistan 5
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756201 | 2756201 | 2022-12-29 | US | Vermont | Windham | 50025 | 8712 | 46 | 0 | 42.986982 | -72.71268875 | 2022-12-30 04:21:04 | Windham, Vermont, US | |
2755998 | 2755998 | 2022-12-29 | US | Texas | Franklin | 48159 | 2595 | 46 | 0 | 33.17653242 | -95.21917243 | 2022-12-30 04:21:04 | Franklin, Texas, US | |
2755972 | 2755972 | 2022-12-29 | US | Texas | Crosby | 48107 | 2208 | 46 | 0 | 33.61431553 | -101.3000364 | 2022-12-30 04:21:04 | Crosby, Texas, US | |
2755869 | 2755869 | 2022-12-29 | US | Tennessee | Lake | 47095 | 3066 | 46 | 0 | 36.3418017 | -89.48921915 | 2022-12-30 04:21:04 | Lake, Tennessee, US | |
2755774 | 2755774 | 2022-12-29 | US | South Dakota | Dewey | 46041 | 3358 | 46 | 0 | 45.15639647 | -100.8709139 | 2022-12-30 04:21:04 | Dewey, South Dakota, US | |
2755489 | 2755489 | 2022-12-29 | US | Oklahoma | Nowata | 40105 | 3167 | 46 | 0 | 36.79843529 | -95.61902331 | 2022-12-30 04:21:04 | Nowata, Oklahoma, US | |
2755488 | 2755488 | 2022-12-29 | US | Oklahoma | Noble | 40103 | 3533 | 46 | 0 | 36.38953329 | -97.22928674 | 2022-12-30 04:21:04 | Noble, Oklahoma, US | |
2754797 | 2754797 | 2022-12-29 | US | Missouri | Clark | 29045 | 1871 | 46 | 0 | 40.41040752 | -91.73661677 | 2022-12-30 04:21:04 | Clark, Missouri, US | |
2754771 | 2754771 | 2022-12-29 | US | Mississippi | Wilkinson | 28157 | 1924 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-30 04:21:04 | Wilkinson, Mississippi, US | |
2754130 | 2754130 | 2022-12-29 | US | Iowa | Mills | 19129 | 3944 | 46 | 0 | 41.03299766 | -95.61920963 | 2022-12-30 04:21:04 | Mills, Iowa, US | |
2753820 | 2753820 | 2022-12-29 | US | Hawaii | Kauai | 15007 | 18678 | 46 | 0 | 22.03935037 | -159.5966786 | 2022-12-30 04:21:04 | Kauai, Hawaii, US | |
2753527 | 2753527 | 2022-12-29 | US | Colorado | Elbert | 8039 | 5766 | 46 | 0 | 39.28656773 | -104.1358721 | 2022-12-30 04:21:04 | Elbert, Colorado, US | |
2753428 | 2753428 | 2022-12-29 | US | Arkansas | Prairie | 5117 | 2373 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-30 04:21:04 | Prairie, Arkansas, US | |
2753419 | 2753419 | 2022-12-29 | US | Arkansas | Nevada | 5099 | 2690 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-12-30 04:21:04 | Nevada, Arkansas, US | |
2753176 | 2753176 | 2022-12-29 | Saint Kitts and Nevis | 6562 | 46 | 0 | 17.357822 | -62.782998 | 2022-12-30 04:21:04 | Saint Kitts and Nevis | ||||
1077207 | 1077207 | 2022-12-28 | US | Vermont | Windham | 50025 | 8712 | 46 | 0 | 42.986982 | -72.71268875 | 2022-12-29 04:21:01 | Windham, Vermont, US | |
1077004 | 1077004 | 2022-12-28 | US | Texas | Franklin | 48159 | 2595 | 46 | 0 | 33.17653242 | -95.21917243 | 2022-12-29 04:21:01 | Franklin, Texas, US | |
1076978 | 1076978 | 2022-12-28 | US | Texas | Crosby | 48107 | 2208 | 46 | 0 | 33.61431553 | -101.3000364 | 2022-12-29 04:21:01 | Crosby, Texas, US | |
1076875 | 1076875 | 2022-12-28 | US | Tennessee | Lake | 47095 | 3066 | 46 | 0 | 36.3418017 | -89.48921915 | 2022-12-29 04:21:01 | Lake, Tennessee, US | |
1076780 | 1076780 | 2022-12-28 | US | South Dakota | Dewey | 46041 | 3358 | 46 | 0 | 45.15639647 | -100.8709139 | 2022-12-29 04:21:01 | Dewey, South Dakota, US | |
1076494 | 1076494 | 2022-12-28 | US | Oklahoma | Noble | 40103 | 3521 | 46 | 0 | 36.38953329 | -97.22928674 | 2022-12-29 04:21:01 | Noble, Oklahoma, US | |
1075803 | 1075803 | 2022-12-28 | US | Missouri | Clark | 29045 | 1871 | 46 | 0 | 40.41040752 | -91.73661677 | 2022-12-29 04:21:01 | Clark, Missouri, US | |
1075777 | 1075777 | 2022-12-28 | US | Mississippi | Wilkinson | 28157 | 1924 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-29 04:21:01 | Wilkinson, Mississippi, US | |
1075136 | 1075136 | 2022-12-28 | US | Iowa | Mills | 19129 | 3944 | 46 | 0 | 41.03299766 | -95.61920963 | 2022-12-29 04:21:01 | Mills, Iowa, US | |
1074826 | 1074826 | 2022-12-28 | US | Hawaii | Kauai | 15007 | 18678 | 46 | 0 | 22.03935037 | -159.5966786 | 2022-12-29 04:21:01 | Kauai, Hawaii, US | |
1074566 | 1074566 | 2022-12-28 | US | Colorado | Rio Grande | 8105 | 3516 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-12-29 04:21:01 | Rio Grande, Colorado, US | |
1074533 | 1074533 | 2022-12-28 | US | Colorado | Elbert | 8039 | 5763 | 46 | 0 | 39.28656773 | -104.1358721 | 2022-12-29 04:21:01 | Elbert, Colorado, US | |
1074434 | 1074434 | 2022-12-28 | US | Arkansas | Prairie | 5117 | 2373 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-29 04:21:01 | Prairie, Arkansas, US | |
1074425 | 1074425 | 2022-12-28 | US | Arkansas | Nevada | 5099 | 2690 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-12-29 04:21:01 | Nevada, Arkansas, US | |
1074182 | 1074182 | 2022-12-28 | Saint Kitts and Nevis | 6562 | 46 | 0 | 17.357822 | -62.782998 | 2022-12-29 04:21:01 | Saint Kitts and Nevis | ||||
331204 | 331204 | 2022-12-27 | US | Vermont | Windham | 50025 | 8685 | 46 | 0 | 42.986982 | -72.71268875 | 2022-12-28 04:21:04 | Windham, Vermont, US | |
330975 | 330975 | 2022-12-27 | US | Texas | Crosby | 48107 | 2202 | 46 | 0 | 33.61431553 | -101.3000364 | 2022-12-28 04:21:04 | Crosby, Texas, US | |
330872 | 330872 | 2022-12-27 | US | Tennessee | Lake | 47095 | 3066 | 46 | 0 | 36.3418017 | -89.48921915 | 2022-12-28 04:21:04 | Lake, Tennessee, US | |
330777 | 330777 | 2022-12-27 | US | South Dakota | Dewey | 46041 | 3355 | 46 | 0 | 45.15639647 | -100.8709139 | 2022-12-28 04:21:04 | Dewey, South Dakota, US | |
330491 | 330491 | 2022-12-27 | US | Oklahoma | Noble | 40103 | 3521 | 46 | 0 | 36.38953329 | -97.22928674 | 2022-12-28 04:21:04 | Noble, Oklahoma, US | |
329800 | 329800 | 2022-12-27 | US | Missouri | Clark | 29045 | 1871 | 46 | 0 | 40.41040752 | -91.73661677 | 2022-12-28 04:21:04 | Clark, Missouri, US | |
329774 | 329774 | 2022-12-27 | US | Mississippi | Wilkinson | 28157 | 1924 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-28 04:21:04 | Wilkinson, Mississippi, US | |
329133 | 329133 | 2022-12-27 | US | Iowa | Mills | 19129 | 3931 | 46 | 0 | 41.03299766 | -95.61920963 | 2022-12-28 04:21:04 | Mills, Iowa, US | |
328823 | 328823 | 2022-12-27 | US | Hawaii | Kauai | 15007 | 18599 | 46 | 0 | 22.03935037 | -159.5966786 | 2022-12-28 04:21:04 | Kauai, Hawaii, US | |
328563 | 328563 | 2022-12-27 | US | Colorado | Rio Grande | 8105 | 3514 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-12-28 04:21:04 | Rio Grande, Colorado, US | |
328530 | 328530 | 2022-12-27 | US | Colorado | Elbert | 8039 | 5762 | 46 | 0 | 39.28656773 | -104.1358721 | 2022-12-28 04:21:04 | Elbert, Colorado, US | |
328431 | 328431 | 2022-12-27 | US | Arkansas | Prairie | 5117 | 2373 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-28 04:21:04 | Prairie, Arkansas, US | |
328422 | 328422 | 2022-12-27 | US | Arkansas | Nevada | 5099 | 2690 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-12-28 04:21:04 | Nevada, Arkansas, US | |
328179 | 328179 | 2022-12-27 | Saint Kitts and Nevis | 6562 | 46 | 0 | 17.357822 | -62.782998 | 2022-12-28 04:21:04 | Saint Kitts and Nevis | ||||
221277 | 221277 | 2022-12-26 | US | Vermont | Windham | 50025 | 8685 | 46 | 0 | 42.986982 | -72.71268875 | 2022-12-27 04:21:07 | Windham, Vermont, US | |
221048 | 221048 | 2022-12-26 | US | Texas | Crosby | 48107 | 2202 | 46 | 0 | 33.61431553 | -101.3000364 | 2022-12-27 04:21:07 | Crosby, Texas, US | |
220945 | 220945 | 2022-12-26 | US | Tennessee | Lake | 47095 | 3066 | 46 | 0 | 36.3418017 | -89.48921915 | 2022-12-27 04:21:07 | Lake, Tennessee, US | |
220850 | 220850 | 2022-12-26 | US | South Dakota | Dewey | 46041 | 3355 | 46 | 0 | 45.15639647 | -100.8709139 | 2022-12-27 04:21:07 | Dewey, South Dakota, US | |
220564 | 220564 | 2022-12-26 | US | Oklahoma | Noble | 40103 | 3521 | 46 | 0 | 36.38953329 | -97.22928674 | 2022-12-27 04:21:07 | Noble, Oklahoma, US | |
219879 | 219879 | 2022-12-26 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-27 04:21:07 | Dade, Missouri, US | |
219873 | 219873 | 2022-12-26 | US | Missouri | Clark | 29045 | 1865 | 46 | 0 | 40.41040752 | -91.73661677 | 2022-12-27 04:21:07 | Clark, Missouri, US | |
219847 | 219847 | 2022-12-26 | US | Mississippi | Wilkinson | 28157 | 1918 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-27 04:21:07 | Wilkinson, Mississippi, US | |
219206 | 219206 | 2022-12-26 | US | Iowa | Mills | 19129 | 3931 | 46 | 0 | 41.03299766 | -95.61920963 | 2022-12-27 04:21:07 | Mills, Iowa, US | |
218896 | 218896 | 2022-12-26 | US | Hawaii | Kauai | 15007 | 18599 | 46 | 0 | 22.03935037 | -159.5966786 | 2022-12-27 04:21:07 | Kauai, Hawaii, US | |
218636 | 218636 | 2022-12-26 | US | Colorado | Rio Grande | 8105 | 3514 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-12-27 04:21:07 | Rio Grande, Colorado, US | |
218603 | 218603 | 2022-12-26 | US | Colorado | Elbert | 8039 | 5761 | 46 | 0 | 39.28656773 | -104.1358721 | 2022-12-27 04:21:07 | Elbert, Colorado, US | |
218504 | 218504 | 2022-12-26 | US | Arkansas | Prairie | 5117 | 2372 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-27 04:21:07 | Prairie, Arkansas, US | |
218495 | 218495 | 2022-12-26 | US | Arkansas | Nevada | 5099 | 2690 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-12-27 04:21:07 | Nevada, Arkansas, US | |
218252 | 218252 | 2022-12-26 | Saint Kitts and Nevis | 6562 | 46 | 0 | 17.357822 | -62.782998 | 2022-12-27 04:21:07 | Saint Kitts and Nevis | ||||
3225734 | 3225734 | 2022-12-25 | US | Vermont | Windham | 50025 | 8685 | 46 | 0 | 42.986982 | -72.71268875 | 2022-12-26 04:21:06 | Windham, Vermont, US | |
3225505 | 3225505 | 2022-12-25 | US | Texas | Crosby | 48107 | 2202 | 46 | 0 | 33.61431553 | -101.3000364 | 2022-12-26 04:21:06 | Crosby, Texas, US | |
3225402 | 3225402 | 2022-12-25 | US | Tennessee | Lake | 47095 | 3066 | 46 | 0 | 36.3418017 | -89.48921915 | 2022-12-26 04:21:06 | Lake, Tennessee, US | |
3225307 | 3225307 | 2022-12-25 | US | South Dakota | Dewey | 46041 | 3355 | 46 | 0 | 45.15639647 | -100.8709139 | 2022-12-26 04:21:06 | Dewey, South Dakota, US | |
3225021 | 3225021 | 2022-12-25 | US | Oklahoma | Noble | 40103 | 3521 | 46 | 0 | 36.38953329 | -97.22928674 | 2022-12-26 04:21:06 | Noble, Oklahoma, US | |
3224336 | 3224336 | 2022-12-25 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-26 04:21:06 | Dade, Missouri, US | |
3224330 | 3224330 | 2022-12-25 | US | Missouri | Clark | 29045 | 1865 | 46 | 0 | 40.41040752 | -91.73661677 | 2022-12-26 04:21:06 | Clark, Missouri, US | |
3224304 | 3224304 | 2022-12-25 | US | Mississippi | Wilkinson | 28157 | 1918 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-26 04:21:06 | Wilkinson, Mississippi, US | |
3223663 | 3223663 | 2022-12-25 | US | Iowa | Mills | 19129 | 3931 | 46 | 0 | 41.03299766 | -95.61920963 | 2022-12-26 04:21:06 | Mills, Iowa, US | |
3223353 | 3223353 | 2022-12-25 | US | Hawaii | Kauai | 15007 | 18599 | 46 | 0 | 22.03935037 | -159.5966786 | 2022-12-26 04:21:06 | Kauai, Hawaii, US | |
3223093 | 3223093 | 2022-12-25 | US | Colorado | Rio Grande | 8105 | 3514 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-12-26 04:21:06 | Rio Grande, Colorado, US | |
3223060 | 3223060 | 2022-12-25 | US | Colorado | Elbert | 8039 | 5757 | 46 | 0 | 39.28656773 | -104.1358721 | 2022-12-26 04:21:06 | Elbert, Colorado, US | |
3222961 | 3222961 | 2022-12-25 | US | Arkansas | Prairie | 5117 | 2371 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-26 04:21:06 | Prairie, Arkansas, US | |
3222952 | 3222952 | 2022-12-25 | US | Arkansas | Nevada | 5099 | 2690 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-12-26 04:21:06 | Nevada, Arkansas, US | |
3222709 | 3222709 | 2022-12-25 | Saint Kitts and Nevis | 6562 | 46 | 0 | 17.357822 | -62.782998 | 2022-12-26 04:21:06 | Saint Kitts and Nevis | ||||
1021648 | 1021648 | 2022-12-24 | US | Vermont | Windham | 50025 | 8685 | 46 | 0 | 42.986982 | -72.71268875 | 2022-12-25 04:21:04 | Windham, Vermont, US | |
1021419 | 1021419 | 2022-12-24 | US | Texas | Crosby | 48107 | 2202 | 46 | 0 | 33.61431553 | -101.3000364 | 2022-12-25 04:21:04 | Crosby, Texas, US | |
1021316 | 1021316 | 2022-12-24 | US | Tennessee | Lake | 47095 | 3066 | 46 | 0 | 36.3418017 | -89.48921915 | 2022-12-25 04:21:04 | Lake, Tennessee, US | |
1021221 | 1021221 | 2022-12-24 | US | South Dakota | Dewey | 46041 | 3355 | 46 | 0 | 45.15639647 | -100.8709139 | 2022-12-25 04:21:04 | Dewey, South Dakota, US | |
1020935 | 1020935 | 2022-12-24 | US | Oklahoma | Noble | 40103 | 3521 | 46 | 0 | 36.38953329 | -97.22928674 | 2022-12-25 04:21:04 | Noble, Oklahoma, US | |
1020250 | 1020250 | 2022-12-24 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-25 04:21:04 | Dade, Missouri, US | |
1020244 | 1020244 | 2022-12-24 | US | Missouri | Clark | 29045 | 1865 | 46 | 0 | 40.41040752 | -91.73661677 | 2022-12-25 04:21:04 | Clark, Missouri, US | |
1020218 | 1020218 | 2022-12-24 | US | Mississippi | Wilkinson | 28157 | 1918 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-25 04:21:04 | Wilkinson, Mississippi, US | |
1019577 | 1019577 | 2022-12-24 | US | Iowa | Mills | 19129 | 3931 | 46 | 0 | 41.03299766 | -95.61920963 | 2022-12-25 04:21:04 | Mills, Iowa, US | |
1019267 | 1019267 | 2022-12-24 | US | Hawaii | Kauai | 15007 | 18599 | 46 | 0 | 22.03935037 | -159.5966786 | 2022-12-25 04:21:04 | Kauai, Hawaii, US | |
1019007 | 1019007 | 2022-12-24 | US | Colorado | Rio Grande | 8105 | 3514 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-12-25 04:21:04 | Rio Grande, Colorado, US | |
1018974 | 1018974 | 2022-12-24 | US | Colorado | Elbert | 8039 | 5757 | 46 | 0 | 39.28656773 | -104.1358721 | 2022-12-25 04:21:04 | Elbert, Colorado, US | |
1018875 | 1018875 | 2022-12-24 | US | Arkansas | Prairie | 5117 | 2371 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-25 04:21:04 | Prairie, Arkansas, US | |
1018866 | 1018866 | 2022-12-24 | US | Arkansas | Nevada | 5099 | 2690 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-12-25 04:21:04 | Nevada, Arkansas, US | |
1018623 | 1018623 | 2022-12-24 | Saint Kitts and Nevis | 6562 | 46 | 0 | 17.357822 | -62.782998 | 2022-12-25 04:21:04 | Saint Kitts and Nevis | ||||
693671 | 693671 | 2022-12-23 | US | Vermont | Windham | 50025 | 8685 | 46 | 0 | 42.986982 | -72.71268875 | 2022-12-24 04:21:02 | Windham, Vermont, US | |
693442 | 693442 | 2022-12-23 | US | Texas | Crosby | 48107 | 2202 | 46 | 0 | 33.61431553 | -101.3000364 | 2022-12-24 04:21:02 | Crosby, Texas, US | |
693339 | 693339 | 2022-12-23 | US | Tennessee | Lake | 47095 | 3066 | 46 | 0 | 36.3418017 | -89.48921915 | 2022-12-24 04:21:02 | Lake, Tennessee, US | |
693244 | 693244 | 2022-12-23 | US | South Dakota | Dewey | 46041 | 3355 | 46 | 0 | 45.15639647 | -100.8709139 | 2022-12-24 04:21:02 | Dewey, South Dakota, US | |
692958 | 692958 | 2022-12-23 | US | Oklahoma | Noble | 40103 | 3521 | 46 | 0 | 36.38953329 | -97.22928674 | 2022-12-24 04:21:02 | Noble, Oklahoma, US | |
692273 | 692273 | 2022-12-23 | US | Missouri | Dade | 29057 | 1765 | 46 | 0 | 37.431814 | -93.8503345 | 2022-12-24 04:21:02 | Dade, Missouri, US | |
692267 | 692267 | 2022-12-23 | US | Missouri | Clark | 29045 | 1865 | 46 | 0 | 40.41040752 | -91.73661677 | 2022-12-24 04:21:02 | Clark, Missouri, US | |
692241 | 692241 | 2022-12-23 | US | Mississippi | Wilkinson | 28157 | 1918 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-12-24 04:21:02 | Wilkinson, Mississippi, US | |
691600 | 691600 | 2022-12-23 | US | Iowa | Mills | 19129 | 3931 | 46 | 0 | 41.03299766 | -95.61920963 | 2022-12-24 04:21:02 | Mills, Iowa, US | |
691290 | 691290 | 2022-12-23 | US | Hawaii | Kauai | 15007 | 18599 | 46 | 0 | 22.03935037 | -159.5966786 | 2022-12-24 04:21:02 | Kauai, Hawaii, US | |
691030 | 691030 | 2022-12-23 | US | Colorado | Rio Grande | 8105 | 3514 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-12-24 04:21:02 | Rio Grande, Colorado, 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]);