johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
367 rows where confirmed = 1807 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1592803 | 1592803 | 2022-10-21 | US | California | Trinity | 6105 | 1807 | 20 | 0 | 40.6491767 | -123.114713 | 2022-10-22 04:22:53 | Trinity, California, US | |
2272519 | 2272519 | 2022-10-20 | US | California | Trinity | 6105 | 1807 | 20 | 0 | 40.6491767 | -123.114713 | 2022-10-21 04:22:23 | Trinity, California, US | |
198854 | 198854 | 2022-10-19 | US | California | Trinity | 6105 | 1807 | 20 | 0 | 40.6491767 | -123.114713 | 2022-10-20 04:22:59 | Trinity, California, US | |
3754108 | 3754108 | 2022-10-13 | US | Colorado | Kit Carson | 8063 | 1807 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-10-14 04:22:28 | Kit Carson, Colorado, US | |
3214933 | 3214933 | 2022-10-12 | US | Colorado | Kit Carson | 8063 | 1807 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-10-13 04:22:39 | Kit Carson, Colorado, US | |
2377435 | 2377435 | 2022-09-29 | US | Missouri | Clark | 29045 | 1807 | 41 | 0 | 40.41040752 | -91.73661677 | 2022-09-30 04:23:09 | Clark, Missouri, US | |
1561986 | 1561986 | 2022-09-28 | US | Missouri | Clark | 29045 | 1807 | 41 | 0 | 40.41040752 | -91.73661677 | 2022-09-29 04:22:34 | Clark, Missouri, US | |
3996529 | 3996529 | 2022-09-27 | US | Missouri | Clark | 29045 | 1807 | 41 | 0 | 40.41040752 | -91.73661677 | 2022-09-28 04:23:01 | Clark, Missouri, US | |
3995873 | 3995873 | 2022-09-27 | US | Iowa | Pocahontas | 19151 | 1807 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-09-28 04:23:01 | Pocahontas, Iowa, US | |
2770857 | 2770857 | 2022-09-26 | US | Missouri | Clark | 29045 | 1807 | 41 | 0 | 40.41040752 | -91.73661677 | 2022-09-27 04:23:01 | Clark, Missouri, US | |
2770201 | 2770201 | 2022-09-26 | US | Iowa | Pocahontas | 19151 | 1807 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-09-27 04:23:01 | Pocahontas, Iowa, US | |
1978510 | 1978510 | 2022-09-25 | US | Missouri | Clark | 29045 | 1807 | 41 | 0 | 40.41040752 | -91.73661677 | 2022-09-26 04:20:52 | Clark, Missouri, US | |
1977854 | 1977854 | 2022-09-25 | US | Iowa | Pocahontas | 19151 | 1807 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-09-26 04:20:52 | Pocahontas, Iowa, US | |
2651677 | 2651677 | 2022-09-24 | US | Missouri | Clark | 29045 | 1807 | 41 | 0 | 40.41040752 | -91.73661677 | 2022-09-25 04:23:31 | Clark, Missouri, US | |
2651021 | 2651021 | 2022-09-24 | US | Iowa | Pocahontas | 19151 | 1807 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-09-25 04:23:31 | Pocahontas, Iowa, US | |
386117 | 386117 | 2022-09-23 | US | Missouri | Clark | 29045 | 1807 | 41 | 0 | 40.41040752 | -91.73661677 | 2022-09-24 04:21:40 | Clark, Missouri, US | |
385461 | 385461 | 2022-09-23 | US | Iowa | Pocahontas | 19151 | 1807 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-09-24 04:21:40 | Pocahontas, Iowa, US | |
1625527 | 1625527 | 2022-09-22 | US | Iowa | Pocahontas | 19151 | 1807 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-09-23 04:23:13 | Pocahontas, Iowa, US | |
1371731 | 1371731 | 2022-09-21 | US | Iowa | Pocahontas | 19151 | 1807 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-09-22 04:22:56 | Pocahontas, Iowa, US | |
2398425 | 2398425 | 2022-09-12 | US | Wyoming | Weston | 56045 | 1807 | 21 | 0 | 43.83961191 | -104.5674881 | 2022-09-13 04:20:57 | Weston, Wyoming, US | |
3769503 | 3769503 | 2022-09-11 | US | Wyoming | Weston | 56045 | 1807 | 21 | 0 | 43.83961191 | -104.5674881 | 2022-09-12 04:20:58 | Weston, Wyoming, US | |
3828078 | 3828078 | 2022-09-10 | US | Wyoming | Weston | 56045 | 1807 | 21 | 0 | 43.83961191 | -104.5674881 | 2022-09-11 04:20:50 | Weston, Wyoming, US | |
966535 | 966535 | 2022-09-09 | US | Wyoming | Weston | 56045 | 1807 | 21 | 0 | 43.83961191 | -104.5674881 | 2022-09-10 04:21:10 | Weston, Wyoming, US | |
256937 | 256937 | 2022-09-08 | US | Wyoming | Weston | 56045 | 1807 | 21 | 0 | 43.83961191 | -104.5674881 | 2022-09-09 04:21:11 | Weston, Wyoming, US | |
3748735 | 3748735 | 2022-09-07 | US | Wyoming | Weston | 56045 | 1807 | 21 | 0 | 43.83961191 | -104.5674881 | 2022-09-08 04:21:02 | Weston, Wyoming, US | |
118375 | 118375 | 2022-09-06 | US | Wyoming | Weston | 56045 | 1807 | 21 | 0 | 43.83961191 | -104.5674881 | 2022-09-07 04:20:59 | Weston, Wyoming, US | |
1348865 | 1348865 | 2022-08-10 | US | Oklahoma | Coal | 40029 | 1807 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-11 04:20:49 | Coal, Oklahoma, US | |
1088620 | 1088620 | 2022-08-09 | US | Oklahoma | Coal | 40029 | 1807 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-10 04:20:57 | Coal, Oklahoma, US | |
3546035 | 3546035 | 2022-08-08 | US | Oklahoma | Coal | 40029 | 1807 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-09 04:20:34 | Coal, Oklahoma, US | |
1072438 | 1072438 | 2022-08-07 | US | Oklahoma | Coal | 40029 | 1807 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-08 04:21:08 | Coal, Oklahoma, US | |
1943026 | 1943026 | 2022-08-06 | US | Oklahoma | Coal | 40029 | 1807 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-07 04:20:54 | Coal, Oklahoma, US | |
882825 | 882825 | 2022-08-05 | US | Oklahoma | Coal | 40029 | 1807 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-06 04:20:56 | Coal, Oklahoma, US | |
2011236 | 2011236 | 2022-08-04 | US | Oklahoma | Coal | 40029 | 1807 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-08-05 04:20:52 | Coal, Oklahoma, US | |
3966966 | 3966966 | 2022-07-05 | US | Alaska | Aleutians West | 2016 | 1807 | 2 | 0 | 52.3233 | -174.1596 | 2022-07-06 04:20:58 | Aleutians West, Alaska, US | |
3078477 | 3078477 | 2022-07-04 | US | Alaska | Aleutians West | 2016 | 1807 | 2 | 0 | 52.3233 | -174.1596 | 2022-07-05 04:20:45 | Aleutians West, Alaska, US | |
1767759 | 1767759 | 2022-07-03 | US | Alaska | Aleutians West | 2016 | 1807 | 2 | 0 | 52.3233 | -174.1596 | 2022-07-04 04:20:54 | Aleutians West, Alaska, US | |
3365745 | 3365745 | 2022-07-02 | US | Alaska | Aleutians West | 2016 | 1807 | 2 | 0 | 52.3233 | -174.1596 | 2022-07-03 04:20:59 | Aleutians West, Alaska, US | |
594074 | 594074 | 2022-07-01 | US | Alaska | Aleutians West | 2016 | 1807 | 2 | 0 | 52.3233 | -174.1596 | 2022-07-02 04:21:16 | Aleutians West, Alaska, US | |
3940475 | 3940475 | 2022-06-30 | US | Alaska | Aleutians West | 2016 | 1807 | 2 | 0 | 52.3233 | -174.1596 | 2022-07-01 04:21:10 | Aleutians West, Alaska, US | |
2490433 | 2490433 | 2022-06-29 | US | Alaska | Aleutians West | 2016 | 1807 | 2 | 0 | 52.3233 | -174.1596 | 2022-06-30 04:21:01 | Aleutians West, Alaska, US | |
2243059 | 2243059 | 2022-06-28 | United Kingdom | Falkland Islands (Malvinas) | 1807 | 0 | 0 | -51.7963 | -59.5236 | 2022-06-29 04:20:59 | Falkland Islands (Malvinas), United Kingdom | |||
2151301 | 2151301 | 2022-06-27 | United Kingdom | Falkland Islands (Malvinas) | 1807 | 0 | 0 | -51.7963 | -59.5236 | 2022-06-28 04:20:58 | Falkland Islands (Malvinas), United Kingdom | |||
479102 | 479102 | 2022-06-26 | United Kingdom | Falkland Islands (Malvinas) | 1807 | 0 | 0 | -51.7963 | -59.5236 | 2022-06-27 04:21:00 | Falkland Islands (Malvinas), United Kingdom | |||
942477 | 942477 | 2022-06-25 | United Kingdom | Falkland Islands (Malvinas) | 1807 | 0 | 0 | -51.7963 | -59.5236 | 2022-06-26 04:21:02 | Falkland Islands (Malvinas), United Kingdom | |||
3350297 | 3350297 | 2022-06-24 | United Kingdom | Falkland Islands (Malvinas) | 1807 | 0 | 0 | -51.7963 | -59.5236 | 2022-06-25 04:20:57 | Falkland Islands (Malvinas), United Kingdom | |||
1652038 | 1652038 | 2022-06-23 | United Kingdom | Falkland Islands (Malvinas) | 1807 | 0 | 0 | -51.7963 | -59.5236 | 2022-06-24 04:20:58 | Falkland Islands (Malvinas), United Kingdom | |||
2191273 | 2191273 | 2022-06-22 | United Kingdom | Falkland Islands (Malvinas) | 1807 | 0 | 0 | -51.7963 | -59.5236 | 2022-06-23 04:20:55 | Falkland Islands (Malvinas), United Kingdom | |||
1763980 | 1763980 | 2022-06-20 | US | Colorado | Rio Blanco | 8103 | 1807 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-06-21 04:20:56 | Rio Blanco, Colorado, US | |
950057 | 950057 | 2022-06-14 | US | Texas | Refugio | 48391 | 1807 | 37 | 0 | 28.3238976 | -97.15766311 | 2022-06-15 04:20:54 | Refugio, Texas, US | |
2982465 | 2982465 | 2022-06-13 | US | Texas | Refugio | 48391 | 1807 | 37 | 0 | 28.3238976 | -97.15766311 | 2022-06-14 04:20:52 | Refugio, Texas, US | |
1424088 | 1424088 | 2022-06-08 | US | Tennessee | Pickett | 47137 | 1807 | 36 | 0 | 36.55606529 | -85.077633 | 2022-06-09 04:20:54 | Pickett, Tennessee, US | |
3000601 | 3000601 | 2022-05-24 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-25 04:20:56 | Greenwood, Kansas, US | |
3594322 | 3594322 | 2022-05-23 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-24 04:20:57 | Greenwood, Kansas, US | |
1110870 | 1110870 | 2022-05-21 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-22 04:20:52 | Greenwood, Kansas, US | |
1170494 | 1170494 | 2022-05-20 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-21 04:20:58 | Greenwood, Kansas, US | |
3899270 | 3899270 | 2022-05-19 | US | Virginia | Bland | 51021 | 1807 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-05-20 04:20:57 | Bland, Virginia, US | |
3897257 | 3897257 | 2022-05-19 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-20 04:20:57 | Greenwood, Kansas, US | |
1186041 | 1186041 | 2022-05-18 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-19 04:20:54 | Greenwood, Kansas, US | |
3585513 | 3585513 | 2022-05-17 | US | South Dakota | Fall River | 46047 | 1807 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-05-18 04:20:50 | Fall River, South Dakota, US | |
3583938 | 3583938 | 2022-05-17 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-18 04:20:50 | Greenwood, Kansas, US | |
1506470 | 1506470 | 2022-05-16 | US | South Dakota | Fall River | 46047 | 1807 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-05-17 04:20:59 | Fall River, South Dakota, US | |
1504895 | 1504895 | 2022-05-16 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-17 04:20:59 | Greenwood, Kansas, US | |
2086829 | 2086829 | 2022-05-15 | US | South Dakota | Fall River | 46047 | 1807 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-05-16 04:20:47 | Fall River, South Dakota, US | |
2085254 | 2085254 | 2022-05-15 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-16 04:20:47 | Greenwood, Kansas, US | |
3357539 | 3357539 | 2022-05-14 | US | South Dakota | Fall River | 46047 | 1807 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-05-15 04:20:53 | Fall River, South Dakota, US | |
3355964 | 3355964 | 2022-05-14 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-15 04:20:53 | Greenwood, Kansas, US | |
661184 | 661184 | 2022-05-13 | US | South Dakota | Fall River | 46047 | 1807 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-05-14 04:20:48 | Fall River, South Dakota, US | |
659609 | 659609 | 2022-05-13 | US | Kansas | Greenwood | 20073 | 1807 | 27 | 0 | 37.8774388 | -96.23250453 | 2022-05-14 04:20:48 | Greenwood, Kansas, US | |
2536267 | 2536267 | 2022-05-12 | US | South Dakota | Fall River | 46047 | 1807 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-05-13 04:20:51 | Fall River, South Dakota, US | |
3447713 | 3447713 | 2022-05-11 | US | South Dakota | Fall River | 46047 | 1807 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-05-12 04:20:54 | Fall River, South Dakota, US | |
3724262 | 3724262 | 2022-04-25 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-04-26 04:20:51 | Cuming, Nebraska, US | |
2030830 | 2030830 | 2022-04-24 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-04-25 04:20:56 | Cuming, Nebraska, US | |
748405 | 748405 | 2022-04-23 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-04-24 04:20:56 | Cuming, Nebraska, US | |
3438890 | 3438890 | 2022-04-22 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-04-23 04:20:50 | Cuming, Nebraska, US | |
2894475 | 2894475 | 2022-04-21 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-04-22 04:20:45 | Cuming, Nebraska, US | |
2309347 | 2309347 | 2022-04-20 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-04-21 04:20:46 | Cuming, Nebraska, US | |
2309298 | 2309298 | 2022-04-20 | US | Montana | Madison | 30057 | 1807 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-04-21 04:20:46 | Madison, Montana, US | |
2253486 | 2253486 | 2022-04-19 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-04-20 04:20:45 | Cuming, Nebraska, US | |
2253437 | 2253437 | 2022-04-19 | US | Montana | Madison | 30057 | 1807 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-04-20 04:20:45 | Madison, Montana, US | |
3208278 | 3208278 | 2022-04-11 | US | Montana | Madison | 30057 | 1807 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-04-12 04:20:49 | Madison, Montana, US | |
3322355 | 3322355 | 2022-04-07 | US | Nebraska | Richardson | 31147 | 1807 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-04-08 04:20:48 | Richardson, Nebraska, US | |
2802891 | 2802891 | 2022-04-06 | US | Nebraska | Richardson | 31147 | 1807 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-04-07 04:20:53 | Richardson, Nebraska, US | |
3869660 | 3869660 | 2022-04-05 | US | Nebraska | Richardson | 31147 | 1807 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-04-06 04:20:49 | Richardson, Nebraska, US | |
2751002 | 2751002 | 2022-04-04 | US | Nebraska | Richardson | 31147 | 1807 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-04-05 04:20:48 | Richardson, Nebraska, US | |
3732348 | 3732348 | 2022-04-03 | US | Nebraska | Richardson | 31147 | 1807 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-04-04 04:20:51 | Richardson, Nebraska, US | |
501783 | 501783 | 2022-04-02 | US | Nebraska | Richardson | 31147 | 1807 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-04-03 04:20:48 | Richardson, Nebraska, US | |
1542073 | 1542073 | 2022-03-31 | US | Nebraska | Richardson | 31147 | 1807 | 19 | 0 | 40.1247415 | -95.71755036 | 2022-04-01 04:20:28 | Richardson, Nebraska, US | |
1542019 | 1542019 | 2022-03-31 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-04-01 04:20:28 | Cuming, Nebraska, US | |
2480086 | 2480086 | 2022-03-30 | US | Nebraska | Richardson | 31147 | 1807 | 19 | 0 | 40.1247415 | -95.71755036 | 2022-03-31 04:20:56 | Richardson, Nebraska, US | |
160127 | 160127 | 2022-03-29 | US | Nebraska | Richardson | 31147 | 1807 | 19 | 0 | 40.1247415 | -95.71755036 | 2022-03-30 04:20:45 | Richardson, Nebraska, US | |
1470161 | 1470161 | 2022-03-24 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-03-25 04:20:46 | Cuming, Nebraska, US | |
3024335 | 3024335 | 2022-03-23 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-03-24 04:20:43 | Cuming, Nebraska, US | |
1907257 | 1907257 | 2022-03-22 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-03-23 04:20:48 | Cuming, Nebraska, US | |
26461 | 26461 | 2022-03-20 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-03-21 04:20:50 | Cuming, Nebraska, US | |
1658471 | 1658471 | 2022-03-19 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-03-20 04:20:45 | Cuming, Nebraska, US | |
337997 | 337997 | 2022-03-18 | US | Nebraska | Cuming | 31039 | 1807 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-03-19 04:20:47 | Cuming, Nebraska, US | |
953609 | 953609 | 2022-03-12 | US | Puerto Rico | Guayanilla | 72059 | 1807 | 0 | 0 | 18.039942 | -66.79186 | 2022-03-13 04:20:49 | Guayanilla, Puerto Rico, US | |
359070 | 359070 | 2022-03-11 | US | Puerto Rico | Guayanilla | 72059 | 1807 | 0 | 0 | 18.039942 | -66.79186 | 2022-03-12 04:20:50 | Guayanilla, Puerto Rico, US | |
2143399 | 2143399 | 2022-03-09 | US | Texas | Stephens | 48429 | 1807 | 45 | 0 | 32.73553157 | -98.83631615 | 2022-03-10 04:20:48 | Stephens, Texas, US | |
1551448 | 1551448 | 2022-03-07 | US | West Virginia | Calhoun | 54013 | 1807 | 13 | 0 | 38.84315422 | -81.11934872 | 2022-03-08 04:20:54 | Calhoun, West Virginia, 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]);