johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
657 rows where confirmed = 652 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 613
- China 11
- Denmark 6
- Japan 6
- Australia 3
- Netherlands 2
- San Marino 2
- Switzerland 2
- Burkina Faso 1
- Central African Republic 1
- Chile 1
- Colombia 1
- France 1
- Italy 1
- Jamaica 1
- Liberia 1
- Sweden 1
- United Kingdom 1
- Uruguay 1
- Vietnam 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3279278 | 3279278 | 2022-10-23 | US | North Dakota | Griggs | 38039 | 652 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-10-24 04:22:29 | Griggs, North Dakota, US | |
2270316 | 2270316 | 2022-10-22 | US | North Dakota | Griggs | 38039 | 652 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-10-23 04:22:46 | Griggs, North Dakota, US | |
1594616 | 1594616 | 2022-10-21 | US | North Dakota | Griggs | 38039 | 652 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-10-22 04:22:53 | Griggs, North Dakota, US | |
992306 | 992306 | 2022-08-16 | US | Kansas | Lincoln | 20105 | 652 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-17 04:20:59 | Lincoln, Kansas, US | |
2495345 | 2495345 | 2022-08-15 | US | Kansas | Lincoln | 20105 | 652 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-16 04:20:58 | Lincoln, Kansas, US | |
3648895 | 3648895 | 2022-08-14 | US | Kansas | Lincoln | 20105 | 652 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-15 04:20:59 | Lincoln, Kansas, US | |
1969901 | 1969901 | 2022-08-13 | US | Kansas | Lincoln | 20105 | 652 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-14 04:20:55 | Lincoln, Kansas, US | |
2889710 | 2889710 | 2022-08-12 | US | Kansas | Lincoln | 20105 | 652 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-13 04:20:52 | Lincoln, Kansas, US | |
3909315 | 3909315 | 2022-08-11 | US | Kansas | Lincoln | 20105 | 652 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-12 04:20:54 | Lincoln, Kansas, US | |
1347632 | 1347632 | 2022-08-10 | US | Kansas | Lincoln | 20105 | 652 | 11 | 0 | 39.04549684 | -98.20756994 | 2022-08-11 04:20:49 | Lincoln, Kansas, US | |
1088958 | 1088958 | 2022-08-09 | US | South Dakota | Jackson | 46071 | 652 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-08-10 04:20:57 | Jackson, South Dakota, US | |
3546578 | 3546578 | 2022-08-08 | US | Texas | Fisher | 48151 | 652 | 26 | 0 | 32.74281316 | -100.4019302 | 2022-08-09 04:20:34 | Fisher, Texas, US | |
3546373 | 3546373 | 2022-08-08 | US | South Dakota | Jackson | 46071 | 652 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-08-09 04:20:34 | Jackson, South Dakota, US | |
1072776 | 1072776 | 2022-08-07 | US | South Dakota | Jackson | 46071 | 652 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-08-08 04:21:08 | Jackson, South Dakota, US | |
1943364 | 1943364 | 2022-08-06 | US | South Dakota | Jackson | 46071 | 652 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-08-07 04:20:54 | Jackson, South Dakota, US | |
883163 | 883163 | 2022-08-05 | US | South Dakota | Jackson | 46071 | 652 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-08-06 04:20:56 | Jackson, South Dakota, US | |
2011574 | 2011574 | 2022-08-04 | US | South Dakota | Jackson | 46071 | 652 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-08-05 04:20:52 | Jackson, South Dakota, US | |
1101001 | 1101001 | 2022-08-03 | US | South Dakota | Jackson | 46071 | 652 | 21 | 0 | 43.69318385 | -101.6255063 | 2022-08-04 04:20:58 | Jackson, South Dakota, US | |
3726661 | 3726661 | 2022-06-07 | US | Alaska | Yakutat | 2282 | 652 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-06-08 04:20:55 | Yakutat, Alaska, US | |
3888063 | 3888063 | 2022-06-06 | US | Alaska | Yakutat | 2282 | 652 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-06-07 04:21:08 | Yakutat, Alaska, US | |
3507832 | 3507832 | 2022-06-05 | US | Alaska | Yakutat | 2282 | 652 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-06-06 04:20:57 | Yakutat, Alaska, US | |
3527909 | 3527909 | 2022-06-04 | US | Alaska | Yakutat | 2282 | 652 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-06-05 04:20:55 | Yakutat, Alaska, US | |
3133995 | 3133995 | 2022-06-03 | US | Alaska | Yakutat | 2282 | 652 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-06-04 04:20:58 | Yakutat, Alaska, US | |
3579070 | 3579070 | 2022-06-02 | US | Alaska | Yakutat | 2282 | 652 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-06-03 04:20:58 | Yakutat, Alaska, US | |
971363 | 971363 | 2022-06-01 | US | Alaska | Yakutat | 2282 | 652 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-06-02 05:20:39 | Yakutat, Alaska, US | |
3001431 | 3001431 | 2022-05-24 | US | Nebraska | Stanton | 31167 | 652 | 11 | 0 | 41.9169835 | -97.19394708 | 2022-05-25 04:20:56 | Stanton, Nebraska, US | |
3595152 | 3595152 | 2022-05-23 | US | Nebraska | Stanton | 31167 | 652 | 11 | 0 | 41.9169835 | -97.19394708 | 2022-05-24 04:20:57 | Stanton, Nebraska, US | |
3583913 | 3583913 | 2022-05-17 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-18 04:20:50 | Cheyenne, Kansas, US | |
1504870 | 1504870 | 2022-05-16 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-17 04:20:59 | Cheyenne, Kansas, US | |
2085229 | 2085229 | 2022-05-15 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-16 04:20:47 | Cheyenne, Kansas, US | |
3355939 | 3355939 | 2022-05-14 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-15 04:20:53 | Cheyenne, Kansas, US | |
659584 | 659584 | 2022-05-13 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-14 04:20:48 | Cheyenne, Kansas, US | |
2534667 | 2534667 | 2022-05-12 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-13 04:20:51 | Cheyenne, Kansas, US | |
3446113 | 3446113 | 2022-05-11 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-12 04:20:54 | Cheyenne, Kansas, US | |
3536730 | 3536730 | 2022-05-10 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-11 04:20:48 | Cheyenne, Kansas, US | |
223265 | 223265 | 2022-05-09 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-10 04:20:50 | Cheyenne, Kansas, US | |
2332650 | 2332650 | 2022-05-08 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-09 04:20:54 | Cheyenne, Kansas, US | |
361612 | 361612 | 2022-05-07 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-08 04:20:49 | Cheyenne, Kansas, US | |
1398963 | 1398963 | 2022-05-06 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-07 04:21:09 | Cheyenne, Kansas, US | |
2599318 | 2599318 | 2022-05-05 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-06 04:21:00 | Cheyenne, Kansas, US | |
3266767 | 3266767 | 2022-05-04 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-05 04:20:55 | Cheyenne, Kansas, US | |
1573406 | 1573406 | 2022-05-03 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-04 04:20:59 | Cheyenne, Kansas, US | |
464666 | 464666 | 2022-05-02 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-03 04:21:00 | Cheyenne, Kansas, US | |
3917305 | 3917305 | 2022-05-01 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-02 04:21:10 | Cheyenne, Kansas, US | |
2842109 | 2842109 | 2022-04-30 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-05-01 04:20:57 | Cheyenne, Kansas, US | |
1158422 | 1158422 | 2022-04-29 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-30 04:21:05 | Cheyenne, Kansas, US | |
1697604 | 1697604 | 2022-04-28 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-29 04:20:59 | Cheyenne, Kansas, US | |
3853087 | 3853087 | 2022-04-27 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-28 04:20:47 | Cheyenne, Kansas, US | |
1327517 | 1327517 | 2022-04-26 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-27 04:20:52 | Cheyenne, Kansas, US | |
3723471 | 3723471 | 2022-04-25 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-26 04:20:51 | Cheyenne, Kansas, US | |
2030039 | 2030039 | 2022-04-24 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-25 04:20:56 | Cheyenne, Kansas, US | |
747614 | 747614 | 2022-04-23 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-24 04:20:56 | Cheyenne, Kansas, US | |
3438099 | 3438099 | 2022-04-22 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-23 04:20:50 | Cheyenne, Kansas, US | |
2893684 | 2893684 | 2022-04-21 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-22 04:20:45 | Cheyenne, Kansas, US | |
2308556 | 2308556 | 2022-04-20 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-21 04:20:46 | Cheyenne, Kansas, US | |
2252695 | 2252695 | 2022-04-19 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-20 04:20:45 | Cheyenne, Kansas, US | |
1847245 | 1847245 | 2022-04-18 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-19 04:21:00 | Cheyenne, Kansas, US | |
3418189 | 3418189 | 2022-04-17 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-18 04:21:12 | Cheyenne, Kansas, US | |
305138 | 305138 | 2022-04-16 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-17 04:20:59 | Cheyenne, Kansas, US | |
2671083 | 2671083 | 2022-04-15 | US | Kansas | Cheyenne | 20023 | 652 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-04-16 04:20:48 | Cheyenne, Kansas, US | |
24187 | 24187 | 2022-03-20 | China | Gansu | 652 | 2 | 0 | 35.7518 | 104.2861 | 2022-03-21 04:20:50 | Gansu, China | |||
2266768 | 2266768 | 2022-03-14 | US | South Dakota | Hanson | 46061 | 652 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-03-15 04:20:47 | Hanson, South Dakota, US | |
2263676 | 2263676 | 2022-03-14 | China | Chongqing | 652 | 6 | 0 | 30.0572 | 107.874 | 2022-03-15 04:20:47 | Chongqing, China | |||
3630834 | 3630834 | 2022-03-13 | US | South Dakota | Hanson | 46061 | 652 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-03-14 04:20:46 | Hanson, South Dakota, US | |
953742 | 953742 | 2022-03-12 | US | South Dakota | Hanson | 46061 | 652 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-03-13 04:20:49 | Hanson, South Dakota, US | |
359485 | 359485 | 2022-03-11 | US | Texas | Lipscomb | 48295 | 652 | 16 | 0 | 36.27783108 | -100.27331509999999 | 2022-03-12 04:20:50 | Lipscomb, Texas, US | |
359203 | 359203 | 2022-03-11 | US | South Dakota | Hanson | 46061 | 652 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-03-12 04:20:50 | Hanson, South Dakota, US | |
1868355 | 1868355 | 2022-03-10 | US | South Dakota | Hanson | 46061 | 652 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-03-11 04:20:50 | Hanson, South Dakota, US | |
2143050 | 2143050 | 2022-03-09 | US | South Dakota | Hanson | 46061 | 652 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-03-10 04:20:48 | Hanson, South Dakota, US | |
922561 | 922561 | 2022-03-08 | US | South Dakota | Hanson | 46061 | 652 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-03-09 04:20:59 | Hanson, South Dakota, US | |
1550848 | 1550848 | 2022-03-07 | US | South Dakota | Hanson | 46061 | 652 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-03-08 04:20:54 | Hanson, South Dakota, US | |
186683 | 186683 | 2022-02-13 | US | Colorado | Custer | 8027 | 652 | 20 | 0 | 38.10883162 | -105.3683478 | 2022-02-14 04:20:51 | Custer, Colorado, US | |
3077190 | 3077190 | 2022-02-09 | US | Texas | Kimble | 48267 | 652 | 14 | 0 | 30.48678918 | -99.74856473 | 2022-02-10 04:21:14 | Kimble, Texas, US | |
3076456 | 3076456 | 2022-02-09 | US | North Dakota | McIntosh | 38051 | 652 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-02-10 04:21:14 | McIntosh, North Dakota, US | |
1362787 | 1362787 | 2022-02-08 | US | Alaska | Petersburg | 2195 | 652 | 3 | 0 | 57.13978948 | -132.9540995 | 2022-02-09 04:21:04 | Petersburg, Alaska, US | |
73087 | 73087 | 2022-02-07 | US | Montana | Fallon | 30025 | 652 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-02-08 04:21:15 | Fallon, Montana, US | |
71525 | 71525 | 2022-02-07 | US | Alaska | Petersburg | 2195 | 652 | 3 | 0 | 57.13978948 | -132.9540995 | 2022-02-08 04:21:15 | Petersburg, Alaska, US | |
2475221 | 2475221 | 2022-02-03 | US | Kansas | Chase | 20017 | 652 | 7 | 0 | 38.30292938 | -96.59563862 | 2022-02-04 04:21:10 | Chase, Kansas, US | |
460646 | 460646 | 2022-02-02 | US | Kansas | Chase | 20017 | 652 | 7 | 0 | 38.30292938 | -96.59563862 | 2022-02-03 04:21:21 | Chase, Kansas, US | |
2660690 | 2660690 | 2022-01-31 | US | South Dakota | Perkins | 46105 | 652 | 16 | 0 | 45.49049506 | -102.47555859999999 | 2022-02-01 04:21:11 | Perkins, South Dakota, US | |
3811893 | 3811893 | 2022-01-28 | US | Missouri | Schuyler | 29197 | 652 | 24 | 0 | 40.46921489 | -92.52311943 | 2022-01-29 04:21:10 | Schuyler, Missouri, US | |
1143131 | 1143131 | 2022-01-23 | US | New Mexico | Union | 35059 | 652 | 12 | 0 | 36.48126404 | -103.4709624 | 2022-01-24 04:21:12 | Union, New Mexico, US | |
2835049 | 2835049 | 2022-01-22 | US | New Mexico | Union | 35059 | 652 | 12 | 0 | 36.48126404 | -103.4709624 | 2022-01-23 04:21:13 | Union, New Mexico, US | |
2832715 | 2832715 | 2022-01-22 | France | Saint Pierre and Miquelon | 652 | 0 | 0 | 46.8852 | -56.3159 | 2022-01-23 04:21:13 | Saint Pierre and Miquelon, France | |||
3427167 | 3427167 | 2022-01-21 | US | New Mexico | Union | 35059 | 652 | 12 | 0 | 36.48126404 | -103.4709624 | 2022-01-22 04:21:13 | Union, New Mexico, US | |
1474209 | 1474209 | 2022-01-17 | US | Nebraska | Kimball | 31105 | 652 | 1 | 0 | 41.19774275 | -103.7148131 | 2022-01-18 04:21:04 | Kimball, Nebraska, US | |
557206 | 557206 | 2022-01-16 | US | North Dakota | Nelson | 38063 | 652 | 17 | 0 | 47.9226426 | -98.19038437 | 2022-01-17 04:21:08 | Nelson, North Dakota, US | |
1115363 | 1115363 | 2022-01-11 | US | Minnesota | Traverse | 27155 | 652 | 8 | 0 | 45.77298854 | -96.47062949 | 2022-01-12 04:21:44 | Traverse, Minnesota, US | |
1281778 | 1281778 | 2022-01-05 | China | Guangxi | 652 | 2 | 0 | 23.8298 | 108.7881 | 2022-01-06 04:22:09 | Guangxi, China | |||
1288662 | 1288662 | 2022-01-04 | US | Pennsylvania | Cameron | 42023 | 652 | 13 | 0 | 41.43625568 | -78.20376845 | 2022-01-05 04:21:59 | Cameron, Pennsylvania, US | |
1288246 | 1288246 | 2022-01-04 | US | New York | Hamilton | 36041 | 652 | 4 | 0 | 43.66146647 | -74.49721957 | 2022-01-05 04:21:59 | Hamilton, New York, US | |
1670513 | 1670513 | 2021-12-29 | US | Nebraska | Chase | 31029 | 652 | 5 | 0 | 40.523719799999995 | -101.69780259999999 | 2021-12-30 04:21:25 | Chase, Nebraska, US | |
1434622 | 1434622 | 2021-12-28 | US | Nebraska | Chase | 31029 | 652 | 5 | 0 | 40.523719799999995 | -101.69780259999999 | 2021-12-29 03:21:43 | Chase, Nebraska, US | |
3831533 | 3831533 | 2021-12-21 | US | Texas | Crockett | 48105 | 652 | 17 | 0 | 30.72367027 | -101.4134238 | 2021-12-22 04:21:54 | Crockett, Texas, US | |
1257836 | 1257836 | 2021-12-20 | US | Texas | Crockett | 48105 | 652 | 17 | 0 | 30.72367027 | -101.4134238 | 2021-12-21 03:21:27 | Crockett, Texas, US | |
2906779 | 2906779 | 2021-12-19 | US | Texas | Crockett | 48105 | 652 | 17 | 0 | 30.72367027 | -101.4134238 | 2021-12-20 04:21:43 | Crockett, Texas, US | |
1261852 | 1261852 | 2021-12-18 | US | Texas | Crockett | 48105 | 652 | 17 | 0 | 30.72367027 | -101.4134238 | 2021-12-19 04:21:11 | Crockett, Texas, US | |
2401880 | 2401880 | 2021-12-17 | US | Texas | Crockett | 48105 | 652 | 17 | 0 | 30.72367027 | -101.4134238 | 2021-12-18 02:22:20 | Crockett, Texas, US | |
1719418 | 1719418 | 2021-12-16 | US | Texas | Crockett | 48105 | 652 | 17 | 0 | 30.72367027 | -101.4134238 | 2021-12-17 04:22:14 | Crockett, Texas, US | |
3499252 | 3499252 | 2021-12-15 | US | Texas | Crockett | 48105 | 652 | 17 | 0 | 30.72367027 | -101.4134238 | 2021-12-16 04:22:11 | Crockett, Texas, 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]);