johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11,412 rows where deaths = 72 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,743
- Russia 118
- Japan 116
- Sweden 80
- United Kingdom 62
- Sierra Leone 36
- Sao Tome and Principe 26
- Chile 22
- Ukraine 18
- Canada 17
- India 12
- San Marino 12
- Spain 10
- Colombia 9
- Peru 8
- France 6
- Malaysia 6
- Mexico 5
- Tajikistan 5
- Thailand 5
- Afghanistan 4
- Central African Republic 4
- Chad 4
- Liberia 4
- Liechtenstein 4
- Netherlands 4
- Togo 4
- Andorra 3
- Australia 3
- Congo (Kinshasa) 3
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756495 | 2756495 | 2022-12-29 | US | Wisconsin | Trempealeau | 55121 | 9740 | 72 | 0 | 44.30360275 | -91.35893614 | 2022-12-30 04:21:04 | Trempealeau, Wisconsin, US | |
2756104 | 2756104 | 2022-12-29 | US | Texas | Pecos | 48371 | 3539 | 72 | 0 | 30.78097267 | -102.7241261 | 2022-12-30 04:21:04 | Pecos, Texas, US | |
2755899 | 2755899 | 2022-12-29 | US | Tennessee | Sequatchie | 47153 | 4988 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-30 04:21:04 | Sequatchie, Tennessee, US | |
2755842 | 2755842 | 2022-12-29 | US | Tennessee | Decatur | 47039 | 4350 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-30 04:21:04 | Decatur, Tennessee, US | |
2755708 | 2755708 | 2022-12-29 | US | South Carolina | Abbeville | 45001 | 7597 | 72 | 0 | 34.22333378 | -82.46170658 | 2022-12-30 04:21:04 | Abbeville, South Carolina, US | |
2754814 | 2754814 | 2022-12-29 | US | Missouri | Grundy | 29079 | 3041 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-30 04:21:04 | Grundy, Missouri, US | |
2754756 | 2754756 | 2022-12-29 | US | Mississippi | Smith | 28129 | 4863 | 72 | 0 | 32.01744532 | -89.50644846 | 2022-12-30 04:21:04 | Smith, Mississippi, US | |
2754680 | 2754680 | 2022-12-29 | US | Minnesota | Todd | 27153 | 8269 | 72 | 0 | 46.06996226 | -94.89785296 | 2022-12-30 04:21:04 | Todd, Minnesota, US | |
2754397 | 2754397 | 2022-12-29 | US | Louisiana | Assumption | 22007 | 6521 | 72 | 0 | 29.89946234 | -91.06461642 | 2022-12-30 04:21:04 | Assumption, Louisiana, US | |
2754034 | 2754034 | 2022-12-29 | US | Indiana | Perry | 18123 | 5662 | 72 | 0 | 38.07809328 | -86.63741946 | 2022-12-30 04:21:04 | Perry, Indiana, US | |
2753980 | 2753980 | 2022-12-29 | US | Indiana | Carroll | 18015 | 4791 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-12-30 04:21:04 | Carroll, Indiana, US | |
2753929 | 2753929 | 2022-12-29 | US | Illinois | Massac | 17127 | 4539 | 72 | 0 | 37.22078441 | -88.71036614 | 2022-12-30 04:21:04 | Massac, Illinois, US | |
2753812 | 2753812 | 2022-12-29 | US | Georgia | Wilcox | 13315 | 2345 | 72 | 0 | 31.97496928 | -83.43438555 | 2022-12-30 04:21:04 | Wilcox, Georgia, US | |
1077110 | 1077110 | 2022-12-28 | US | Texas | Pecos | 48371 | 3539 | 72 | 0 | 30.78097267 | -102.7241261 | 2022-12-29 04:21:01 | Pecos, Texas, US | |
1076905 | 1076905 | 2022-12-28 | US | Tennessee | Sequatchie | 47153 | 4988 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-29 04:21:01 | Sequatchie, Tennessee, US | |
1076848 | 1076848 | 2022-12-28 | US | Tennessee | Decatur | 47039 | 4350 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-29 04:21:01 | Decatur, Tennessee, US | |
1076714 | 1076714 | 2022-12-28 | US | South Carolina | Abbeville | 45001 | 7597 | 72 | 0 | 34.22333378 | -82.46170658 | 2022-12-29 04:21:01 | Abbeville, South Carolina, US | |
1075820 | 1075820 | 2022-12-28 | US | Missouri | Grundy | 29079 | 3041 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-29 04:21:01 | Grundy, Missouri, US | |
1075762 | 1075762 | 2022-12-28 | US | Mississippi | Smith | 28129 | 4863 | 72 | 0 | 32.01744532 | -89.50644846 | 2022-12-29 04:21:01 | Smith, Mississippi, US | |
1075686 | 1075686 | 2022-12-28 | US | Minnesota | Todd | 27153 | 8240 | 72 | 0 | 46.06996226 | -94.89785296 | 2022-12-29 04:21:01 | Todd, Minnesota, US | |
1075403 | 1075403 | 2022-12-28 | US | Louisiana | Assumption | 22007 | 6521 | 72 | 0 | 29.89946234 | -91.06461642 | 2022-12-29 04:21:01 | Assumption, Louisiana, US | |
1075040 | 1075040 | 2022-12-28 | US | Indiana | Perry | 18123 | 5662 | 72 | 0 | 38.07809328 | -86.63741946 | 2022-12-29 04:21:01 | Perry, Indiana, US | |
1074986 | 1074986 | 2022-12-28 | US | Indiana | Carroll | 18015 | 4791 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-12-29 04:21:01 | Carroll, Indiana, US | |
1074935 | 1074935 | 2022-12-28 | US | Illinois | Massac | 17127 | 4536 | 72 | 0 | 37.22078441 | -88.71036614 | 2022-12-29 04:21:01 | Massac, Illinois, US | |
1074818 | 1074818 | 2022-12-28 | US | Georgia | Wilcox | 13315 | 2345 | 72 | 0 | 31.97496928 | -83.43438555 | 2022-12-29 04:21:01 | Wilcox, Georgia, US | |
331107 | 331107 | 2022-12-27 | US | Texas | Pecos | 48371 | 3504 | 72 | 0 | 30.78097267 | -102.7241261 | 2022-12-28 04:21:04 | Pecos, Texas, US | |
330902 | 330902 | 2022-12-27 | US | Tennessee | Sequatchie | 47153 | 4988 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-28 04:21:04 | Sequatchie, Tennessee, US | |
330845 | 330845 | 2022-12-27 | US | Tennessee | Decatur | 47039 | 4350 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-28 04:21:04 | Decatur, Tennessee, US | |
330711 | 330711 | 2022-12-27 | US | South Carolina | Abbeville | 45001 | 7597 | 72 | 0 | 34.22333378 | -82.46170658 | 2022-12-28 04:21:04 | Abbeville, South Carolina, US | |
329817 | 329817 | 2022-12-27 | US | Missouri | Grundy | 29079 | 3041 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-28 04:21:04 | Grundy, Missouri, US | |
329759 | 329759 | 2022-12-27 | US | Mississippi | Smith | 28129 | 4863 | 72 | 0 | 32.01744532 | -89.50644846 | 2022-12-28 04:21:04 | Smith, Mississippi, US | |
329683 | 329683 | 2022-12-27 | US | Minnesota | Todd | 27153 | 8240 | 72 | 0 | 46.06996226 | -94.89785296 | 2022-12-28 04:21:04 | Todd, Minnesota, US | |
329400 | 329400 | 2022-12-27 | US | Louisiana | Assumption | 22007 | 6499 | 72 | 0 | 29.89946234 | -91.06461642 | 2022-12-28 04:21:04 | Assumption, Louisiana, US | |
329086 | 329086 | 2022-12-27 | US | Iowa | Cherokee | 19035 | 3509 | 72 | 0 | 42.73538914 | -95.62389402 | 2022-12-28 04:21:04 | Cherokee, Iowa, US | |
329037 | 329037 | 2022-12-27 | US | Indiana | Perry | 18123 | 5662 | 72 | 0 | 38.07809328 | -86.63741946 | 2022-12-28 04:21:04 | Perry, Indiana, US | |
328983 | 328983 | 2022-12-27 | US | Indiana | Carroll | 18015 | 4791 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-12-28 04:21:04 | Carroll, Indiana, US | |
328932 | 328932 | 2022-12-27 | US | Illinois | Massac | 17127 | 4535 | 72 | 0 | 37.22078441 | -88.71036614 | 2022-12-28 04:21:04 | Massac, Illinois, US | |
328815 | 328815 | 2022-12-27 | US | Georgia | Wilcox | 13315 | 2335 | 72 | 0 | 31.97496928 | -83.43438555 | 2022-12-28 04:21:04 | Wilcox, Georgia, US | |
221180 | 221180 | 2022-12-26 | US | Texas | Pecos | 48371 | 3504 | 72 | 0 | 30.78097267 | -102.7241261 | 2022-12-27 04:21:07 | Pecos, Texas, US | |
220975 | 220975 | 2022-12-26 | US | Tennessee | Sequatchie | 47153 | 4988 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-27 04:21:07 | Sequatchie, Tennessee, US | |
220918 | 220918 | 2022-12-26 | US | Tennessee | Decatur | 47039 | 4350 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-27 04:21:07 | Decatur, Tennessee, US | |
220784 | 220784 | 2022-12-26 | US | South Carolina | Abbeville | 45001 | 7552 | 72 | 0 | 34.22333378 | -82.46170658 | 2022-12-27 04:21:07 | Abbeville, South Carolina, US | |
219890 | 219890 | 2022-12-26 | US | Missouri | Grundy | 29079 | 3027 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-27 04:21:07 | Grundy, Missouri, US | |
219832 | 219832 | 2022-12-26 | US | Mississippi | Smith | 28129 | 4837 | 72 | 0 | 32.01744532 | -89.50644846 | 2022-12-27 04:21:07 | Smith, Mississippi, US | |
219756 | 219756 | 2022-12-26 | US | Minnesota | Todd | 27153 | 8240 | 72 | 0 | 46.06996226 | -94.89785296 | 2022-12-27 04:21:07 | Todd, Minnesota, US | |
219473 | 219473 | 2022-12-26 | US | Louisiana | Assumption | 22007 | 6499 | 72 | 0 | 29.89946234 | -91.06461642 | 2022-12-27 04:21:07 | Assumption, Louisiana, US | |
219159 | 219159 | 2022-12-26 | US | Iowa | Cherokee | 19035 | 3509 | 72 | 0 | 42.73538914 | -95.62389402 | 2022-12-27 04:21:07 | Cherokee, Iowa, US | |
219110 | 219110 | 2022-12-26 | US | Indiana | Perry | 18123 | 5662 | 72 | 0 | 38.07809328 | -86.63741946 | 2022-12-27 04:21:07 | Perry, Indiana, US | |
219056 | 219056 | 2022-12-26 | US | Indiana | Carroll | 18015 | 4791 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-12-27 04:21:07 | Carroll, Indiana, US | |
219005 | 219005 | 2022-12-26 | US | Illinois | Massac | 17127 | 4519 | 72 | 0 | 37.22078441 | -88.71036614 | 2022-12-27 04:21:07 | Massac, Illinois, US | |
218888 | 218888 | 2022-12-26 | US | Georgia | Wilcox | 13315 | 2335 | 72 | 0 | 31.97496928 | -83.43438555 | 2022-12-27 04:21:07 | Wilcox, Georgia, US | |
3225637 | 3225637 | 2022-12-25 | US | Texas | Pecos | 48371 | 3504 | 72 | 0 | 30.78097267 | -102.7241261 | 2022-12-26 04:21:06 | Pecos, Texas, US | |
3225432 | 3225432 | 2022-12-25 | US | Tennessee | Sequatchie | 47153 | 4988 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-26 04:21:06 | Sequatchie, Tennessee, US | |
3225375 | 3225375 | 2022-12-25 | US | Tennessee | Decatur | 47039 | 4350 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-26 04:21:06 | Decatur, Tennessee, US | |
3225241 | 3225241 | 2022-12-25 | US | South Carolina | Abbeville | 45001 | 7552 | 72 | 0 | 34.22333378 | -82.46170658 | 2022-12-26 04:21:06 | Abbeville, South Carolina, US | |
3224347 | 3224347 | 2022-12-25 | US | Missouri | Grundy | 29079 | 3027 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-26 04:21:06 | Grundy, Missouri, US | |
3224289 | 3224289 | 2022-12-25 | US | Mississippi | Smith | 28129 | 4837 | 72 | 0 | 32.01744532 | -89.50644846 | 2022-12-26 04:21:06 | Smith, Mississippi, US | |
3224213 | 3224213 | 2022-12-25 | US | Minnesota | Todd | 27153 | 8240 | 72 | 0 | 46.06996226 | -94.89785296 | 2022-12-26 04:21:06 | Todd, Minnesota, US | |
3223930 | 3223930 | 2022-12-25 | US | Louisiana | Assumption | 22007 | 6499 | 72 | 0 | 29.89946234 | -91.06461642 | 2022-12-26 04:21:06 | Assumption, Louisiana, US | |
3223616 | 3223616 | 2022-12-25 | US | Iowa | Cherokee | 19035 | 3509 | 72 | 0 | 42.73538914 | -95.62389402 | 2022-12-26 04:21:06 | Cherokee, Iowa, US | |
3223567 | 3223567 | 2022-12-25 | US | Indiana | Perry | 18123 | 5662 | 72 | 0 | 38.07809328 | -86.63741946 | 2022-12-26 04:21:06 | Perry, Indiana, US | |
3223513 | 3223513 | 2022-12-25 | US | Indiana | Carroll | 18015 | 4791 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-12-26 04:21:06 | Carroll, Indiana, US | |
3223462 | 3223462 | 2022-12-25 | US | Illinois | Massac | 17127 | 4519 | 72 | 0 | 37.22078441 | -88.71036614 | 2022-12-26 04:21:06 | Massac, Illinois, US | |
3223345 | 3223345 | 2022-12-25 | US | Georgia | Wilcox | 13315 | 2335 | 72 | 0 | 31.97496928 | -83.43438555 | 2022-12-26 04:21:06 | Wilcox, Georgia, US | |
1021551 | 1021551 | 2022-12-24 | US | Texas | Pecos | 48371 | 3504 | 72 | 0 | 30.78097267 | -102.7241261 | 2022-12-25 04:21:04 | Pecos, Texas, US | |
1021346 | 1021346 | 2022-12-24 | US | Tennessee | Sequatchie | 47153 | 4988 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-25 04:21:04 | Sequatchie, Tennessee, US | |
1021289 | 1021289 | 2022-12-24 | US | Tennessee | Decatur | 47039 | 4350 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-25 04:21:04 | Decatur, Tennessee, US | |
1021155 | 1021155 | 2022-12-24 | US | South Carolina | Abbeville | 45001 | 7552 | 72 | 0 | 34.22333378 | -82.46170658 | 2022-12-25 04:21:04 | Abbeville, South Carolina, US | |
1020261 | 1020261 | 2022-12-24 | US | Missouri | Grundy | 29079 | 3027 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-25 04:21:04 | Grundy, Missouri, US | |
1020203 | 1020203 | 2022-12-24 | US | Mississippi | Smith | 28129 | 4837 | 72 | 0 | 32.01744532 | -89.50644846 | 2022-12-25 04:21:04 | Smith, Mississippi, US | |
1020127 | 1020127 | 2022-12-24 | US | Minnesota | Todd | 27153 | 8240 | 72 | 0 | 46.06996226 | -94.89785296 | 2022-12-25 04:21:04 | Todd, Minnesota, US | |
1019844 | 1019844 | 2022-12-24 | US | Louisiana | Assumption | 22007 | 6499 | 72 | 0 | 29.89946234 | -91.06461642 | 2022-12-25 04:21:04 | Assumption, Louisiana, US | |
1019530 | 1019530 | 2022-12-24 | US | Iowa | Cherokee | 19035 | 3509 | 72 | 0 | 42.73538914 | -95.62389402 | 2022-12-25 04:21:04 | Cherokee, Iowa, US | |
1019481 | 1019481 | 2022-12-24 | US | Indiana | Perry | 18123 | 5662 | 72 | 0 | 38.07809328 | -86.63741946 | 2022-12-25 04:21:04 | Perry, Indiana, US | |
1019427 | 1019427 | 2022-12-24 | US | Indiana | Carroll | 18015 | 4791 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-12-25 04:21:04 | Carroll, Indiana, US | |
1019376 | 1019376 | 2022-12-24 | US | Illinois | Massac | 17127 | 4519 | 72 | 0 | 37.22078441 | -88.71036614 | 2022-12-25 04:21:04 | Massac, Illinois, US | |
1019259 | 1019259 | 2022-12-24 | US | Georgia | Wilcox | 13315 | 2335 | 72 | 0 | 31.97496928 | -83.43438555 | 2022-12-25 04:21:04 | Wilcox, Georgia, US | |
693574 | 693574 | 2022-12-23 | US | Texas | Pecos | 48371 | 3504 | 72 | 0 | 30.78097267 | -102.7241261 | 2022-12-24 04:21:02 | Pecos, Texas, US | |
693369 | 693369 | 2022-12-23 | US | Tennessee | Sequatchie | 47153 | 4987 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-24 04:21:02 | Sequatchie, Tennessee, US | |
693312 | 693312 | 2022-12-23 | US | Tennessee | Decatur | 47039 | 4350 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-24 04:21:02 | Decatur, Tennessee, US | |
693178 | 693178 | 2022-12-23 | US | South Carolina | Abbeville | 45001 | 7552 | 72 | 0 | 34.22333378 | -82.46170658 | 2022-12-24 04:21:02 | Abbeville, South Carolina, US | |
692284 | 692284 | 2022-12-23 | US | Missouri | Grundy | 29079 | 3027 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-24 04:21:02 | Grundy, Missouri, US | |
692226 | 692226 | 2022-12-23 | US | Mississippi | Smith | 28129 | 4837 | 72 | 0 | 32.01744532 | -89.50644846 | 2022-12-24 04:21:02 | Smith, Mississippi, US | |
692150 | 692150 | 2022-12-23 | US | Minnesota | Todd | 27153 | 8240 | 72 | 0 | 46.06996226 | -94.89785296 | 2022-12-24 04:21:02 | Todd, Minnesota, US | |
691867 | 691867 | 2022-12-23 | US | Louisiana | Assumption | 22007 | 6499 | 72 | 0 | 29.89946234 | -91.06461642 | 2022-12-24 04:21:02 | Assumption, Louisiana, US | |
691553 | 691553 | 2022-12-23 | US | Iowa | Cherokee | 19035 | 3509 | 72 | 0 | 42.73538914 | -95.62389402 | 2022-12-24 04:21:02 | Cherokee, Iowa, US | |
691504 | 691504 | 2022-12-23 | US | Indiana | Perry | 18123 | 5662 | 72 | 0 | 38.07809328 | -86.63741946 | 2022-12-24 04:21:02 | Perry, Indiana, US | |
691450 | 691450 | 2022-12-23 | US | Indiana | Carroll | 18015 | 4791 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-12-24 04:21:02 | Carroll, Indiana, US | |
691399 | 691399 | 2022-12-23 | US | Illinois | Massac | 17127 | 4519 | 72 | 0 | 37.22078441 | -88.71036614 | 2022-12-24 04:21:02 | Massac, Illinois, US | |
691282 | 691282 | 2022-12-23 | US | Georgia | Wilcox | 13315 | 2335 | 72 | 0 | 31.97496928 | -83.43438555 | 2022-12-24 04:21:02 | Wilcox, Georgia, US | |
2182784 | 2182784 | 2022-12-22 | US | Texas | Pecos | 48371 | 3504 | 72 | 0 | 30.78097267 | -102.7241261 | 2022-12-23 04:21:04 | Pecos, Texas, US | |
2182579 | 2182579 | 2022-12-22 | US | Tennessee | Sequatchie | 47153 | 4982 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-23 04:21:04 | Sequatchie, Tennessee, US | |
2182522 | 2182522 | 2022-12-22 | US | Tennessee | Decatur | 47039 | 4342 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-23 04:21:04 | Decatur, Tennessee, US | |
2182388 | 2182388 | 2022-12-22 | US | South Carolina | Abbeville | 45001 | 7552 | 72 | 0 | 34.22333378 | -82.46170658 | 2022-12-23 04:21:04 | Abbeville, South Carolina, US | |
2181494 | 2181494 | 2022-12-22 | US | Missouri | Grundy | 29079 | 3027 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-23 04:21:04 | Grundy, Missouri, US | |
2181436 | 2181436 | 2022-12-22 | US | Mississippi | Smith | 28129 | 4837 | 72 | 0 | 32.01744532 | -89.50644846 | 2022-12-23 04:21:04 | Smith, Mississippi, US | |
2181360 | 2181360 | 2022-12-22 | US | Minnesota | Todd | 27153 | 8240 | 72 | 0 | 46.06996226 | -94.89785296 | 2022-12-23 04:21:04 | Todd, Minnesota, US | |
2181077 | 2181077 | 2022-12-22 | US | Louisiana | Assumption | 22007 | 6499 | 72 | 0 | 29.89946234 | -91.06461642 | 2022-12-23 04:21:04 | Assumption, Louisiana, US | |
2180763 | 2180763 | 2022-12-22 | US | Iowa | Cherokee | 19035 | 3509 | 72 | 0 | 42.73538914 | -95.62389402 | 2022-12-23 04:21:04 | Cherokee, Iowa, US | |
2180714 | 2180714 | 2022-12-22 | US | Indiana | Perry | 18123 | 5662 | 72 | 0 | 38.07809328 | -86.63741946 | 2022-12-23 04:21:04 | Perry, Indiana, 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]);