johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
487 rows where confirmed = 1283 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 18
- US 433
- China 31
- Japan 5
- Sweden 3
- Saint Vincent and the Grenadines 2
- Australia 1
- Azerbaijan 1
- Chile 1
- Georgia 1
- Germany 1
- Italy 1
- Jordan 1
- Mauritania 1
- New Zealand 1
- Russia 1
- Sao Tome and Principe 1
- Uganda 1
- Vietnam 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
218546 | 218546 | 2022-12-26 | US | California | Modoc | 6049 | 1283 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-12-27 04:21:07 | Modoc, California, US | |
3223003 | 3223003 | 2022-12-25 | US | California | Modoc | 6049 | 1283 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-12-26 04:21:06 | Modoc, California, US | |
1018917 | 1018917 | 2022-12-24 | US | California | Modoc | 6049 | 1283 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-12-25 04:21:04 | Modoc, California, US | |
690940 | 690940 | 2022-12-23 | US | California | Modoc | 6049 | 1283 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-12-24 04:21:02 | Modoc, California, US | |
2180150 | 2180150 | 2022-12-22 | US | California | Modoc | 6049 | 1283 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-12-23 04:21:04 | Modoc, California, US | |
451954 | 451954 | 2022-12-21 | US | California | Modoc | 6049 | 1283 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-12-22 04:20:56 | Modoc, California, US | |
2951953 | 2951953 | 2022-12-20 | US | California | Modoc | 6049 | 1283 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-12-21 04:21:03 | Modoc, California, US | |
3554717 | 3554717 | 2022-11-27 | US | Texas | Crockett | 48105 | 1283 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-11-28 04:21:02 | Crockett, Texas, US | |
2103197 | 2103197 | 2022-11-26 | US | Texas | Crockett | 48105 | 1283 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-11-27 04:21:05 | Crockett, Texas, US | |
490688 | 490688 | 2022-11-25 | US | Texas | Crockett | 48105 | 1283 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-11-26 04:21:11 | Crockett, Texas, US | |
3526517 | 3526517 | 2022-11-24 | US | Texas | Crockett | 48105 | 1283 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-11-25 04:21:06 | Crockett, Texas, US | |
3315300 | 3315300 | 2022-11-23 | US | Texas | Crockett | 48105 | 1283 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-11-24 04:21:09 | Crockett, Texas, US | |
3462362 | 3462362 | 2022-11-21 | US | New Mexico | Guadalupe | 35019 | 1283 | 18 | 0 | 34.86319296 | -104.790669 | 2022-11-22 04:20:47 | Guadalupe, New Mexico, US | |
1642547 | 1642547 | 2022-11-20 | US | New Mexico | Guadalupe | 35019 | 1283 | 18 | 0 | 34.86319296 | -104.790669 | 2022-11-21 04:21:05 | Guadalupe, New Mexico, US | |
2066104 | 2066104 | 2022-11-19 | US | New Mexico | Guadalupe | 35019 | 1283 | 18 | 0 | 34.86319296 | -104.790669 | 2022-11-20 04:21:08 | Guadalupe, New Mexico, US | |
1757498 | 1757498 | 2022-11-18 | US | New Mexico | Guadalupe | 35019 | 1283 | 18 | 0 | 34.86319296 | -104.790669 | 2022-11-19 04:21:14 | Guadalupe, New Mexico, US | |
295049 | 295049 | 2022-11-15 | US | Texas | Brewster | 48043 | 1283 | 32 | 0 | 29.81008251 | -103.2520326 | 2022-11-16 04:21:09 | Brewster, Texas, US | |
3600079 | 3600079 | 2022-11-14 | US | Texas | Brewster | 48043 | 1283 | 32 | 0 | 29.81008251 | -103.2520326 | 2022-11-15 04:21:16 | Brewster, Texas, US | |
2530332 | 2530332 | 2022-10-06 | US | Idaho | Lewis | 16061 | 1283 | 30 | 0 | 46.23315327 | -116.434146 | 2022-10-07 04:23:08 | Lewis, Idaho, US | |
1811726 | 1811726 | 2022-10-05 | US | Idaho | Lewis | 16061 | 1283 | 30 | 0 | 46.23315327 | -116.434146 | 2022-10-06 04:21:22 | Lewis, Idaho, US | |
2263184 | 2263184 | 2022-10-02 | US | Virginia | Surry | 51181 | 1283 | 21 | 0 | 37.11781893 | -76.88450012 | 2022-10-03 04:23:11 | Surry, Virginia, US | |
2998710 | 2998710 | 2022-10-01 | US | Virginia | Surry | 51181 | 1283 | 21 | 0 | 37.11781893 | -76.88450012 | 2022-10-02 04:21:23 | Surry, Virginia, US | |
857036 | 857036 | 2022-09-30 | US | Virginia | Surry | 51181 | 1283 | 21 | 0 | 37.11781893 | -76.88450012 | 2022-10-01 04:23:01 | Surry, Virginia, US | |
2378962 | 2378962 | 2022-09-29 | US | Virginia | Surry | 51181 | 1283 | 21 | 0 | 37.11781893 | -76.88450012 | 2022-09-30 04:23:09 | Surry, Virginia, US | |
3911367 | 3911367 | 2022-08-11 | US | Virginia | King and Queen | 51097 | 1283 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-08-12 04:20:54 | King and Queen, Virginia, US | |
1349684 | 1349684 | 2022-08-10 | US | Virginia | King and Queen | 51097 | 1283 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-08-11 04:20:49 | King and Queen, Virginia, US | |
2338564 | 2338564 | 2022-07-27 | US | Texas | Martin | 48317 | 1283 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-07-28 04:20:56 | Martin, Texas, US | |
2595030 | 2595030 | 2022-07-25 | US | Illinois | Henderson | 17071 | 1283 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-07-26 04:20:58 | Henderson, Illinois, US | |
3890261 | 3890261 | 2022-06-06 | US | Oregon | Wallowa | 41063 | 1283 | 16 | 0 | 45.57894064 | -117.183538 | 2022-06-07 04:21:08 | Wallowa, Oregon, US | |
3510030 | 3510030 | 2022-06-05 | US | Oregon | Wallowa | 41063 | 1283 | 16 | 0 | 45.57894064 | -117.183538 | 2022-06-06 04:20:57 | Wallowa, Oregon, US | |
3530107 | 3530107 | 2022-06-04 | US | Oregon | Wallowa | 41063 | 1283 | 16 | 0 | 45.57894064 | -117.183538 | 2022-06-05 04:20:55 | Wallowa, Oregon, US | |
3136648 | 3136648 | 2022-06-03 | US | Texas | Garza | 48169 | 1283 | 28 | 0 | 33.17969345 | -101.2984114 | 2022-06-04 04:20:58 | Garza, Texas, US | |
3136193 | 3136193 | 2022-06-03 | US | Oregon | Wallowa | 41063 | 1283 | 16 | 0 | 45.57894064 | -117.183538 | 2022-06-04 04:20:58 | Wallowa, Oregon, US | |
3581723 | 3581723 | 2022-06-02 | US | Texas | Garza | 48169 | 1283 | 28 | 0 | 33.17969345 | -101.2984114 | 2022-06-03 04:20:58 | Garza, Texas, US | |
3581268 | 3581268 | 2022-06-02 | US | Oregon | Wallowa | 41063 | 1283 | 16 | 0 | 45.57894064 | -117.183538 | 2022-06-03 04:20:58 | Wallowa, Oregon, US | |
3897950 | 3897950 | 2022-05-19 | US | Montana | Broadwater | 30007 | 1283 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-20 04:20:57 | Broadwater, Montana, US | |
1186734 | 1186734 | 2022-05-18 | US | Montana | Broadwater | 30007 | 1283 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-19 04:20:54 | Broadwater, Montana, US | |
1185793 | 1185793 | 2022-05-18 | US | Illinois | Scott | 17171 | 1283 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-05-19 04:20:54 | Scott, Illinois, US | |
3584631 | 3584631 | 2022-05-17 | US | Montana | Broadwater | 30007 | 1283 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-18 04:20:50 | Broadwater, Montana, US | |
1505588 | 1505588 | 2022-05-16 | US | Montana | Broadwater | 30007 | 1283 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-17 04:20:59 | Broadwater, Montana, US | |
2085947 | 2085947 | 2022-05-15 | US | Montana | Broadwater | 30007 | 1283 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-16 04:20:47 | Broadwater, Montana, US | |
3356657 | 3356657 | 2022-05-14 | US | Montana | Broadwater | 30007 | 1283 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-15 04:20:53 | Broadwater, Montana, US | |
660302 | 660302 | 2022-05-13 | US | Montana | Broadwater | 30007 | 1283 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-14 04:20:48 | Broadwater, Montana, US | |
225058 | 225058 | 2022-05-09 | US | Texas | Crane | 48103 | 1283 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-05-10 04:20:50 | Crane, Texas, US | |
2334443 | 2334443 | 2022-05-08 | US | Texas | Crane | 48103 | 1283 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-05-09 04:20:54 | Crane, Texas, US | |
363405 | 363405 | 2022-05-07 | US | Texas | Crane | 48103 | 1283 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-05-08 04:20:49 | Crane, Texas, US | |
1400756 | 1400756 | 2022-05-06 | US | Texas | Crane | 48103 | 1283 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-05-07 04:21:09 | Crane, Texas, US | |
2601111 | 2601111 | 2022-05-05 | US | Texas | Crane | 48103 | 1283 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-05-06 04:21:00 | Crane, Texas, US | |
3268782 | 3268782 | 2022-05-04 | US | Vermont | Essex | 50009 | 1283 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-05-05 04:20:55 | Essex, Vermont, US | |
3268560 | 3268560 | 2022-05-04 | US | Texas | Crane | 48103 | 1283 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-05-05 04:20:55 | Crane, Texas, US | |
1575421 | 1575421 | 2022-05-03 | US | Vermont | Essex | 50009 | 1283 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-05-04 04:20:59 | Essex, Vermont, US | |
1575199 | 1575199 | 2022-05-03 | US | Texas | Crane | 48103 | 1283 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-05-04 04:20:59 | Crane, Texas, US | |
1574170 | 1574170 | 2022-05-03 | US | Montana | Teton | 30099 | 1283 | 23 | 0 | 47.83741052 | -112.2410688 | 2022-05-04 04:20:59 | Teton, Montana, US | |
2310048 | 2310048 | 2022-04-20 | US | Puerto Rico | Maunabo | 72095 | 1283 | 0 | 0 | 18.017889 | -65.922235 | 2022-04-21 04:20:46 | Maunabo, Puerto Rico, US | |
2443719 | 2443719 | 2022-04-13 | US | Illinois | Alexander | 17003 | 1283 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-04-13 23:21:06 | Alexander, Illinois, US | |
1949476 | 1949476 | 2022-04-12 | US | Illinois | Alexander | 17003 | 1283 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-04-13 04:21:03 | Alexander, Illinois, US | |
2267062 | 2267062 | 2022-03-14 | US | Texas | McCulloch | 48307 | 1283 | 46 | 0 | 31.1925468 | -99.34682807 | 2022-03-15 04:20:47 | McCulloch, Texas, US | |
2264390 | 2264390 | 2022-03-14 | US | Arkansas | Lafayette | 5073 | 1283 | 30 | 0 | 33.24116713 | -93.60677071 | 2022-03-15 04:20:47 | Lafayette, Arkansas, US | |
3631128 | 3631128 | 2022-03-13 | US | Texas | McCulloch | 48307 | 1283 | 46 | 0 | 31.1925468 | -99.34682807 | 2022-03-14 04:20:46 | McCulloch, Texas, US | |
2447216 | 2447216 | 2022-02-22 | US | Alaska | Yukon-Koyukuk | 2290 | 1283 | 8 | 0 | 65.50815459 | -151.39073869999999 | 2022-02-23 04:21:09 | Yukon-Koyukuk, Alaska, US | |
3718629 | 3718629 | 2022-02-21 | US | Alaska | Yukon-Koyukuk | 2290 | 1283 | 8 | 0 | 65.50815459 | -151.39073869999999 | 2022-02-22 04:21:01 | Yukon-Koyukuk, Alaska, US | |
3914351 | 3914351 | 2022-02-20 | US | North Carolina | Hyde | 37095 | 1283 | 13 | 0 | 35.42017674 | -76.15180542 | 2022-02-21 04:21:05 | Hyde, North Carolina, US | |
3912463 | 3912463 | 2022-02-20 | US | Alaska | Yukon-Koyukuk | 2290 | 1283 | 8 | 0 | 65.50815459 | -151.39073869999999 | 2022-02-21 04:21:05 | Yukon-Koyukuk, Alaska, US | |
3877909 | 3877909 | 2022-02-19 | US | North Carolina | Hyde | 37095 | 1283 | 13 | 0 | 35.42017674 | -76.15180542 | 2022-02-20 04:21:00 | Hyde, North Carolina, US | |
3876021 | 3876021 | 2022-02-19 | US | Alaska | Yukon-Koyukuk | 2290 | 1283 | 8 | 0 | 65.50815459 | -151.39073869999999 | 2022-02-20 04:21:00 | Yukon-Koyukuk, Alaska, US | |
3858165 | 3858165 | 2022-02-18 | US | North Carolina | Hyde | 37095 | 1283 | 13 | 0 | 35.42017674 | -76.15180542 | 2022-02-19 04:21:11 | Hyde, North Carolina, US | |
3856277 | 3856277 | 2022-02-18 | US | Alaska | Yukon-Koyukuk | 2290 | 1283 | 8 | 0 | 65.50815459 | -151.39073869999999 | 2022-02-19 04:21:11 | Yukon-Koyukuk, Alaska, US | |
1365264 | 1365264 | 2022-02-08 | US | South Dakota | Walworth | 46129 | 1283 | 23 | 0 | 45.43019636 | -100.03075140000001 | 2022-02-09 04:21:04 | Walworth, South Dakota, US | |
2015448 | 2015448 | 2022-02-06 | US | Puerto Rico | Guanica | 72055 | 1283 | 0 | 0 | 17.982429 | -66.91964300000001 | 2022-02-07 04:21:05 | Guanica, Puerto Rico, US | |
2329791 | 2329791 | 2022-02-04 | US | North Dakota | Sioux | 38085 | 1283 | 19 | 0 | 46.11323337 | -101.04401490000001 | 2022-02-05 04:21:05 | Sioux, North Dakota, US | |
2474945 | 2474945 | 2022-02-03 | US | Illinois | Gallatin | 17059 | 1283 | 12 | 0 | 37.76430935 | -88.22953869 | 2022-02-04 04:21:10 | Gallatin, Illinois, US | |
460370 | 460370 | 2022-02-02 | US | Illinois | Gallatin | 17059 | 1283 | 12 | 0 | 37.76430935 | -88.22953869 | 2022-02-03 04:21:21 | Gallatin, Illinois, US | |
3427370 | 3427370 | 2022-01-21 | US | North Dakota | Ransom | 38073 | 1283 | 23 | 0 | 46.45621782 | -97.65742504 | 2022-01-22 04:21:13 | Ransom, North Dakota, US | |
1963576 | 1963576 | 2022-01-20 | US | Texas | Bailey | 48017 | 1283 | 31 | 0 | 34.06854817 | -102.8299707 | 2022-01-21 04:21:09 | Bailey, Texas, US | |
1474736 | 1474736 | 2022-01-17 | US | Oregon | Harney | 41025 | 1283 | 34 | 0 | 43.06422669 | -118.96663059999999 | 2022-01-18 04:21:04 | Harney, Oregon, US | |
1474505 | 1474505 | 2022-01-17 | US | North Dakota | Bottineau | 38009 | 1283 | 24 | 0 | 48.79106111 | -100.8378166 | 2022-01-18 04:21:04 | Bottineau, North Dakota, US | |
557824 | 557824 | 2022-01-16 | US | Texas | Brooks | 48047 | 1283 | 48 | 0 | 27.03103197 | -98.21808402 | 2022-01-17 04:21:08 | Brooks, Texas, US | |
557410 | 557410 | 2022-01-16 | US | Oregon | Harney | 41025 | 1283 | 34 | 0 | 43.06422669 | -118.96663059999999 | 2022-01-17 04:21:08 | Harney, Oregon, US | |
3843131 | 3843131 | 2022-01-15 | US | Oregon | Harney | 41025 | 1283 | 34 | 0 | 43.06422669 | -118.96663059999999 | 2022-01-16 04:21:12 | Harney, Oregon, US | |
101946 | 101946 | 2022-01-14 | US | Oregon | Harney | 41025 | 1283 | 34 | 0 | 43.06422669 | -118.96663059999999 | 2022-01-15 04:21:07 | Harney, Oregon, US | |
3691103 | 3691103 | 2022-01-13 | US | Wyoming | Weston | 56045 | 1283 | 16 | 0 | 43.83961191 | -104.56748809999999 | 2022-01-14 04:21:54 | Weston, Wyoming, US | |
3690101 | 3690101 | 2022-01-13 | US | Oregon | Harney | 41025 | 1283 | 34 | 0 | 43.06422669 | -118.96663059999999 | 2022-01-14 04:21:54 | Harney, Oregon, US | |
1701196 | 1701196 | 2022-01-03 | US | Georgia | Miller | 13201 | 1283 | 24 | 0 | 31.16568912 | -84.73151117 | 2022-01-04 04:22:17 | Miller, Georgia, US | |
3520279 | 3520279 | 2022-01-02 | US | Georgia | Miller | 13201 | 1283 | 24 | 0 | 31.16568912 | -84.73151117 | 2022-01-03 02:22:25 | Miller, Georgia, US | |
2168409 | 2168409 | 2022-01-01 | US | Georgia | Miller | 13201 | 1283 | 24 | 0 | 31.16568912 | -84.73151117 | 2022-01-02 04:20:52 | Miller, Georgia, US | |
2777840 | 2777840 | 2021-12-31 | US | Georgia | Miller | 13201 | 1283 | 24 | 0 | 31.16568912 | -84.73151117 | 2022-01-01 04:22:14 | Miller, Georgia, US | |
1670559 | 1670559 | 2021-12-29 | US | Nebraska | Merrick | 31121 | 1283 | 15 | 0 | 41.16624273 | -98.0374887 | 2021-12-30 04:21:25 | Merrick, Nebraska, US | |
733896 | 733896 | 2021-12-27 | US | Virginia | Lunenburg | 51111 | 1283 | 23 | 0 | 36.94618528 | -78.24133319 | 2021-12-28 04:21:47 | Lunenburg, Virginia, US | |
732415 | 732415 | 2021-12-27 | US | Missouri | Chariton | 29041 | 1283 | 32 | 0 | 39.51499357 | -92.9629191 | 2021-12-28 04:21:47 | Chariton, Missouri, US | |
732308 | 732308 | 2021-12-27 | US | Minnesota | Wilkin | 27167 | 1283 | 17 | 0 | 46.35721532 | -96.4684375 | 2021-12-28 04:21:47 | Wilkin, Minnesota, US | |
731410 | 731410 | 2021-12-27 | US | Georgia | Terrell | 13273 | 1283 | 58 | 0 | 31.77527543 | -84.44069698 | 2021-12-28 04:21:47 | Terrell, Georgia, US | |
731158 | 731158 | 2021-12-27 | US | Colorado | Kit Carson | 8063 | 1283 | 29 | 0 | 39.30497777 | -102.60221990000001 | 2021-12-28 04:21:47 | Kit Carson, Colorado, US | |
1258198 | 1258198 | 2021-12-20 | US | Virginia | Williamsburg | 51830 | 1283 | 13 | 0 | 37.28131268 | -76.70905141 | 2021-12-21 03:21:27 | Williamsburg, Virginia, US | |
1256575 | 1256575 | 2021-12-20 | US | Mississippi | Franklin | 28037 | 1283 | 31 | 0 | 31.47786634 | -90.89672989 | 2021-12-21 03:21:27 | Franklin, Mississippi, US | |
2905518 | 2905518 | 2021-12-19 | US | Mississippi | Franklin | 28037 | 1283 | 31 | 0 | 31.47786634 | -90.89672989 | 2021-12-20 04:21:43 | Franklin, Mississippi, US | |
1260591 | 1260591 | 2021-12-18 | US | Mississippi | Franklin | 28037 | 1283 | 31 | 0 | 31.47786634 | -90.89672989 | 2021-12-19 04:21:11 | Franklin, Mississippi, US | |
2400619 | 2400619 | 2021-12-17 | US | Mississippi | Franklin | 28037 | 1283 | 31 | 0 | 31.47786634 | -90.89672989 | 2021-12-18 02:22:20 | Franklin, Mississippi, US | |
785556 | 785556 | 2021-12-13 | US | Texas | Marion | 48315 | 1283 | 53 | 0 | 32.79868409 | -94.35661230000001 | 2021-12-14 04:22:38 | Marion, Texas, US | |
1663591 | 1663591 | 2021-12-12 | US | Texas | Marion | 48315 | 1283 | 53 | 0 | 32.79868409 | -94.35661230000001 | 2021-12-13 04:22:02 | Marion, Texas, US | |
1660938 | 1660938 | 2021-12-12 | US | Arkansas | Newton | 5101 | 1283 | 41 | 0 | 35.91947491 | -93.21612969 | 2021-12-13 04:22:02 | Newton, Arkansas, 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]);