johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
366 rows where confirmed = 1795 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 350
- Colombia 4
- China 3
- Russia 3
- Argentina 1
- Belgium 1
- Canada 1
- Iceland 1
- Netherlands 1
- New Zealand 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3225765 | 3225765 | 2022-12-25 | US | Virginia | Covington | 51580 | 1795 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-12-26 04:21:06 | Covington, Virginia, US | |
1021679 | 1021679 | 2022-12-24 | US | Virginia | Covington | 51580 | 1795 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-12-25 04:21:04 | Covington, Virginia, US | |
693702 | 693702 | 2022-12-23 | US | Virginia | Covington | 51580 | 1795 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-12-24 04:21:02 | Covington, Virginia, US | |
314294 | 314294 | 2022-11-13 | US | North Dakota | Bottineau | 38009 | 1795 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-11-14 04:21:09 | Bottineau, North Dakota, US | |
312872 | 312872 | 2022-11-13 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-14 04:21:09 | Calhoun, Illinois, US | |
65455 | 65455 | 2022-11-12 | US | North Dakota | Bottineau | 38009 | 1795 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-11-13 04:21:14 | Bottineau, North Dakota, US | |
64033 | 64033 | 2022-11-12 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-13 04:21:14 | Calhoun, Illinois, US | |
2929617 | 2929617 | 2022-11-11 | US | North Dakota | Bottineau | 38009 | 1795 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-11-12 04:20:41 | Bottineau, North Dakota, US | |
2928195 | 2928195 | 2022-11-11 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-12 04:20:41 | Calhoun, Illinois, US | |
2507031 | 2507031 | 2022-11-10 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-11 04:21:22 | Calhoun, Illinois, US | |
2431906 | 2431906 | 2022-11-09 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-10 04:21:16 | Calhoun, Illinois, US | |
480562 | 480562 | 2022-11-08 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-09 04:21:22 | Calhoun, Illinois, US | |
2439712 | 2439712 | 2022-11-07 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-08 04:21:21 | Calhoun, Illinois, US | |
2438537 | 2438537 | 2022-11-07 | China | Hunan | 1795 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-08 04:21:21 | Hunan, China | |||
1050810 | 1050810 | 2022-11-06 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-07 04:21:26 | Calhoun, Illinois, US | |
618834 | 618834 | 2022-11-05 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-06 04:21:24 | Calhoun, Illinois, US | |
1023338 | 1023338 | 2022-11-04 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-05 04:21:52 | Calhoun, Illinois, US | |
432329 | 432329 | 2022-11-03 | US | Illinois | Calhoun | 17013 | 1795 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-11-04 04:22:11 | Calhoun, Illinois, US | |
200684 | 200684 | 2022-10-19 | US | North Dakota | Ransom | 38073 | 1795 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-10-20 04:22:59 | Ransom, North Dakota, US | |
131175 | 131175 | 2022-10-04 | US | Alaska | Denali | 2068 | 1795 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-10-05 04:23:06 | Denali, Alaska, US | |
2686122 | 2686122 | 2022-10-03 | US | Alaska | Denali | 2068 | 1795 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-10-04 04:22:55 | Denali, Alaska, US | |
2260189 | 2260189 | 2022-10-02 | US | Alaska | Denali | 2068 | 1795 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-10-03 04:23:11 | Denali, Alaska, US | |
2995715 | 2995715 | 2022-10-01 | US | Alaska | Denali | 2068 | 1795 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-10-02 04:21:23 | Denali, Alaska, US | |
854041 | 854041 | 2022-09-30 | US | Alaska | Denali | 2068 | 1795 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-10-01 04:23:01 | Denali, Alaska, US | |
2375967 | 2375967 | 2022-09-29 | US | Alaska | Denali | 2068 | 1795 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-09-30 04:23:09 | Denali, Alaska, US | |
1560518 | 1560518 | 2022-09-28 | US | Alaska | Denali | 2068 | 1795 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-09-29 04:22:34 | Denali, Alaska, US | |
1626257 | 1626257 | 2022-09-22 | US | Missouri | Shannon | 29203 | 1795 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-09-23 04:23:13 | Shannon, Missouri, US | |
1372461 | 1372461 | 2022-09-21 | US | Missouri | Shannon | 29203 | 1795 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-09-22 04:22:56 | Shannon, Missouri, US | |
2018691 | 2018691 | 2022-09-20 | US | Missouri | Shannon | 29203 | 1795 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-09-21 04:23:22 | Shannon, Missouri, US | |
2017358 | 2017358 | 2022-09-20 | US | Colorado | Kit Carson | 8063 | 1795 | 34 | 0 | 39.30497777 | -102.6022199 | 2022-09-21 04:23:22 | Kit Carson, Colorado, US | |
3572564 | 3572564 | 2022-09-19 | US | Missouri | Shannon | 29203 | 1795 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-09-20 04:22:48 | Shannon, Missouri, US | |
3571231 | 3571231 | 2022-09-19 | US | Colorado | Kit Carson | 8063 | 1795 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-09-20 04:22:48 | Kit Carson, Colorado, US | |
421303 | 421303 | 2022-09-18 | US | Missouri | Shannon | 29203 | 1795 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-09-19 04:21:49 | Shannon, Missouri, US | |
3375327 | 3375327 | 2022-09-17 | US | Missouri | Shannon | 29203 | 1795 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-09-18 04:22:50 | Shannon, Missouri, US | |
2357435 | 2357435 | 2022-09-16 | US | Missouri | Shannon | 29203 | 1795 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-09-17 04:20:19 | Shannon, Missouri, US | |
2345208 | 2345208 | 2022-08-31 | US | Minnesota | Wilkin | 27167 | 1795 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-09-01 04:21:03 | Wilkin, Minnesota, US | |
3775688 | 3775688 | 2022-08-30 | US | Minnesota | Wilkin | 27167 | 1795 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-31 04:20:57 | Wilkin, Minnesota, US | |
1682284 | 1682284 | 2022-08-29 | US | Minnesota | Wilkin | 27167 | 1795 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-30 04:21:03 | Wilkin, Minnesota, US | |
1878768 | 1878768 | 2022-08-28 | US | Minnesota | Wilkin | 27167 | 1795 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-29 04:21:06 | Wilkin, Minnesota, US | |
2097895 | 2097895 | 2022-08-27 | US | Minnesota | Wilkin | 27167 | 1795 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-28 04:21:02 | Wilkin, Minnesota, US | |
1533710 | 1533710 | 2022-08-26 | US | Minnesota | Wilkin | 27167 | 1795 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-27 04:20:57 | Wilkin, Minnesota, US | |
2830597 | 2830597 | 2022-08-25 | US | Minnesota | Wilkin | 27167 | 1795 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-08-26 04:21:02 | Wilkin, Minnesota, US | |
2497087 | 2497087 | 2022-08-15 | US | Texas | Coleman | 48083 | 1795 | 72 | 0 | 31.76736834 | -99.45240766 | 2022-08-16 04:20:58 | Coleman, Texas, US | |
1408210 | 1408210 | 2022-08-02 | US | Texas | Marion | 48315 | 1795 | 60 | 0 | 32.79868409 | -94.3566123 | 2022-08-03 04:20:59 | Marion, Texas, US | |
1068913 | 1068913 | 2022-07-28 | US | Texas | Brooks | 48047 | 1795 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-07-29 04:20:45 | Brooks, Texas, US | |
670909 | 670909 | 2022-07-21 | US | Colorado | Clear Creek | 8019 | 1795 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-07-22 04:21:15 | Clear Creek, Colorado, US | |
3210796 | 3210796 | 2022-07-18 | US | Arkansas | Newton | 5101 | 1795 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-07-19 04:20:58 | Newton, Arkansas, US | |
3967088 | 3967088 | 2022-07-05 | US | Arkansas | Woodruff | 5147 | 1795 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-07-06 04:20:58 | Woodruff, Arkansas, US | |
3079510 | 3079510 | 2022-07-04 | US | Kentucky | Menifee | 21165 | 1795 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-05 04:20:45 | Menifee, Kentucky, US | |
3078599 | 3078599 | 2022-07-04 | US | Arkansas | Woodruff | 5147 | 1795 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-07-05 04:20:45 | Woodruff, Arkansas, US | |
1768792 | 1768792 | 2022-07-03 | US | Kentucky | Menifee | 21165 | 1795 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-04 04:20:54 | Menifee, Kentucky, US | |
3366778 | 3366778 | 2022-07-02 | US | Kentucky | Menifee | 21165 | 1795 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-03 04:20:59 | Menifee, Kentucky, US | |
595107 | 595107 | 2022-07-01 | US | Kentucky | Menifee | 21165 | 1795 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-02 04:21:16 | Menifee, Kentucky, US | |
3941508 | 3941508 | 2022-06-30 | US | Kentucky | Menifee | 21165 | 1795 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-01 04:21:10 | Menifee, Kentucky, US | |
2491466 | 2491466 | 2022-06-29 | US | Kentucky | Menifee | 21165 | 1795 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-06-30 04:21:01 | Menifee, Kentucky, US | |
2240848 | 2240848 | 2022-06-28 | US | Kentucky | Menifee | 21165 | 1795 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-06-29 04:20:59 | Menifee, Kentucky, US | |
2149090 | 2149090 | 2022-06-27 | US | Kentucky | Menifee | 21165 | 1795 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-06-28 04:20:58 | Menifee, Kentucky, US | |
559289 | 559289 | 2022-06-16 | US | Arkansas | Dallas | 5039 | 1795 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-17 04:20:56 | Dallas, Arkansas, US | |
948107 | 948107 | 2022-06-14 | US | Iowa | Worth | 19195 | 1795 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-06-15 04:20:54 | Worth, Iowa, US | |
2980515 | 2980515 | 2022-06-13 | US | Iowa | Worth | 19195 | 1795 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-06-14 04:20:52 | Worth, Iowa, US | |
2979910 | 2979910 | 2022-06-13 | US | Colorado | Rio Blanco | 8103 | 1795 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-06-14 04:20:52 | Rio Blanco, Colorado, US | |
2236641 | 2236641 | 2022-06-12 | US | Iowa | Worth | 19195 | 1795 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-06-13 04:21:14 | Worth, Iowa, US | |
3142839 | 3142839 | 2022-06-11 | US | Iowa | Worth | 19195 | 1795 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-06-12 04:20:53 | Worth, Iowa, US | |
1945755 | 1945755 | 2022-06-10 | US | Iowa | Worth | 19195 | 1795 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-06-11 04:21:01 | Worth, Iowa, US | |
3158894 | 3158894 | 2022-06-09 | US | Iowa | Worth | 19195 | 1795 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-06-10 04:20:55 | Worth, Iowa, US | |
1422361 | 1422361 | 2022-06-08 | US | Iowa | Worth | 19195 | 1795 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-06-09 04:20:54 | Worth, Iowa, US | |
3510596 | 3510596 | 2022-06-05 | US | Texas | Refugio | 48391 | 1795 | 36 | 0 | 28.3238976 | -97.15766311 | 2022-06-06 04:20:57 | Refugio, Texas, US | |
3509122 | 3509122 | 2022-06-05 | US | Minnesota | Lac qui Parle | 27073 | 1795 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-06-06 04:20:57 | Lac qui Parle, Minnesota, US | |
3530673 | 3530673 | 2022-06-04 | US | Texas | Refugio | 48391 | 1795 | 36 | 0 | 28.3238976 | -97.15766311 | 2022-06-05 04:20:55 | Refugio, Texas, US | |
3529199 | 3529199 | 2022-06-04 | US | Minnesota | Lac qui Parle | 27073 | 1795 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-06-05 04:20:55 | Lac qui Parle, Minnesota, US | |
3135285 | 3135285 | 2022-06-03 | US | Minnesota | Lac qui Parle | 27073 | 1795 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-06-04 04:20:58 | Lac qui Parle, Minnesota, US | |
2048478 | 2048478 | 2022-05-25 | US | Colorado | Conejos | 8021 | 1795 | 54 | 0 | 37.201606 | -106.1917488 | 2022-05-26 04:20:50 | Conejos, Colorado, US | |
2599343 | 2599343 | 2022-05-05 | US | Kansas | Greenwood | 20073 | 1795 | 26 | 0 | 37.8774388 | -96.23250453 | 2022-05-06 04:21:00 | Greenwood, Kansas, US | |
3266792 | 3266792 | 2022-05-04 | US | Kansas | Greenwood | 20073 | 1795 | 26 | 0 | 37.8774388 | -96.23250453 | 2022-05-05 04:20:55 | Greenwood, Kansas, US | |
1573431 | 1573431 | 2022-05-03 | US | Kansas | Greenwood | 20073 | 1795 | 26 | 0 | 37.8774388 | -96.23250453 | 2022-05-04 04:20:59 | Greenwood, Kansas, US | |
464691 | 464691 | 2022-05-02 | US | Kansas | Greenwood | 20073 | 1795 | 26 | 0 | 37.8774388 | -96.23250453 | 2022-05-03 04:21:00 | Greenwood, Kansas, US | |
3917330 | 3917330 | 2022-05-01 | US | Kansas | Greenwood | 20073 | 1795 | 26 | 0 | 37.8774388 | -96.23250453 | 2022-05-02 04:21:10 | Greenwood, Kansas, US | |
2842134 | 2842134 | 2022-04-30 | US | Kansas | Greenwood | 20073 | 1795 | 26 | 0 | 37.8774388 | -96.23250453 | 2022-05-01 04:20:57 | Greenwood, Kansas, US | |
1158447 | 1158447 | 2022-04-29 | US | Kansas | Greenwood | 20073 | 1795 | 26 | 0 | 37.8774388 | -96.23250453 | 2022-04-30 04:21:05 | Greenwood, Kansas, US | |
3867329 | 3867329 | 2022-04-05 | China | Beijing | 1795 | 9 | 0 | 40.1824 | 116.4142 | 2022-04-06 04:20:49 | Beijing, China | |||
3732097 | 3732097 | 2022-04-03 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-04-04 04:20:51 | Wilkinson, Mississippi, US | |
501532 | 501532 | 2022-04-02 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-04-03 04:20:48 | Wilkinson, Mississippi, US | |
3352517 | 3352517 | 2022-04-01 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-04-02 04:20:47 | Wilkinson, Mississippi, US | |
1541822 | 1541822 | 2022-03-31 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-04-01 04:20:28 | Wilkinson, Mississippi, US | |
2479835 | 2479835 | 2022-03-30 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-03-31 04:20:56 | Wilkinson, Mississippi, US | |
159876 | 159876 | 2022-03-29 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-03-30 04:20:45 | Wilkinson, Mississippi, US | |
1438447 | 1438447 | 2022-03-28 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-03-29 04:20:46 | Wilkinson, Mississippi, US | |
878128 | 878128 | 2022-03-27 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-03-28 04:20:33 | Wilkinson, Mississippi, US | |
2165411 | 2165411 | 2022-03-26 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-03-27 04:20:47 | Wilkinson, Mississippi, US | |
1722347 | 1722347 | 2022-03-25 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-03-26 04:20:23 | Wilkinson, Mississippi, US | |
1469964 | 1469964 | 2022-03-24 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-03-25 04:20:46 | Wilkinson, Mississippi, US | |
3024138 | 3024138 | 2022-03-23 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-03-24 04:20:43 | Wilkinson, Mississippi, US | |
1907060 | 1907060 | 2022-03-22 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-03-23 04:20:48 | Wilkinson, Mississippi, US | |
3240191 | 3240191 | 2022-03-21 | US | Mississippi | Wilkinson | 28157 | 1795 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-03-22 04:20:54 | Wilkinson, Mississippi, US | |
2202712 | 2202712 | 2022-03-06 | US | Texas | Delta | 48119 | 1795 | 24 | 0 | 33.38570922 | -95.66921122 | 2022-03-07 04:20:47 | Delta, Texas, US | |
2095169 | 2095169 | 2022-03-05 | US | Texas | Delta | 48119 | 1795 | 24 | 0 | 33.38570922 | -95.66921122 | 2022-03-06 04:20:49 | Delta, Texas, US | |
2668869 | 2668869 | 2022-03-04 | US | Texas | Delta | 48119 | 1795 | 24 | 0 | 33.38570922 | -95.66921122 | 2022-03-05 04:21:10 | Delta, Texas, US | |
2528109 | 2528109 | 2022-03-02 | US | Puerto Rico | Guayanilla | 72059 | 1795 | 0 | 0 | 18.039942 | -66.79186 | 2022-03-03 04:21:01 | Guayanilla, Puerto Rico, US | |
1996136 | 1996136 | 2022-03-01 | US | West Virginia | Calhoun | 54013 | 1795 | 12 | 0 | 38.84315422 | -81.11934872 | 2022-03-02 04:21:07 | Calhoun, West Virginia, US | |
1995403 | 1995403 | 2022-03-01 | US | Puerto Rico | Guayanilla | 72059 | 1795 | 0 | 0 | 18.039942 | -66.79186 | 2022-03-02 04:21:07 | Guayanilla, Puerto Rico, 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]);