johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
429 rows where confirmed = 1080 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 409
- Japan 4
- Sweden 4
- Canada 3
- China 3
- Antigua and Barbuda 2
- Cyprus 1
- India 1
- Netherlands 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1240310 | 1240310 | 2022-11-28 | US | Colorado | Ouray | 8091 | 1080 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-11-29 04:21:05 | Ouray, Colorado, US | |
3552298 | 3552298 | 2022-11-27 | US | Colorado | Ouray | 8091 | 1080 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-11-28 04:21:02 | Ouray, Colorado, US | |
2100778 | 2100778 | 2022-11-26 | US | Colorado | Ouray | 8091 | 1080 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-11-27 04:21:05 | Ouray, Colorado, US | |
488269 | 488269 | 2022-11-25 | US | Colorado | Ouray | 8091 | 1080 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-11-26 04:21:11 | Ouray, Colorado, US | |
3524098 | 3524098 | 2022-11-24 | US | Colorado | Ouray | 8091 | 1080 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-11-25 04:21:06 | Ouray, Colorado, US | |
3312881 | 3312881 | 2022-11-23 | US | Colorado | Ouray | 8091 | 1080 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-11-24 04:21:09 | Ouray, Colorado, US | |
1620922 | 1620922 | 2022-11-22 | US | Colorado | Ouray | 8091 | 1080 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-11-23 04:21:06 | Ouray, Colorado, US | |
2323162 | 2323162 | 2022-08-24 | China | Xinjiang | 1080 | 3 | 0 | 41.1129 | 85.2401 | 2022-08-25 04:21:13 | Xinjiang, China | |||
3874000 | 3874000 | 2022-07-31 | US | North Dakota | Wells | 38103 | 1080 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-08-01 04:21:03 | Wells, North Dakota, US | |
676754 | 676754 | 2022-07-30 | US | North Dakota | Wells | 38103 | 1080 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-07-31 04:21:02 | Wells, North Dakota, US | |
961657 | 961657 | 2022-07-19 | US | Puerto Rico | Maricao | 72093 | 1080 | 0 | 0 | 18.171795 | -66.942126 | 2022-07-20 04:20:59 | Maricao, Puerto Rico, US | |
3213044 | 3213044 | 2022-07-18 | US | Puerto Rico | Maricao | 72093 | 1080 | 0 | 0 | 18.171795 | -66.942126 | 2022-07-19 04:20:58 | Maricao, Puerto Rico, US | |
3211960 | 3211960 | 2022-07-18 | US | Michigan | Ontonagon | 26131 | 1080 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-07-19 04:20:58 | Ontonagon, Michigan, US | |
3408219 | 3408219 | 2022-07-17 | US | Puerto Rico | Maricao | 72093 | 1080 | 0 | 0 | 18.171795 | -66.942126 | 2022-07-18 04:20:59 | Maricao, Puerto Rico, US | |
3407135 | 3407135 | 2022-07-17 | US | Michigan | Ontonagon | 26131 | 1080 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-07-18 04:20:59 | Ontonagon, Michigan, US | |
2153335 | 2153335 | 2022-07-16 | US | Michigan | Ontonagon | 26131 | 1080 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-07-17 04:21:15 | Ontonagon, Michigan, US | |
2420568 | 2420568 | 2022-07-15 | US | Michigan | Ontonagon | 26131 | 1080 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-07-16 04:21:05 | Ontonagon, Michigan, US | |
3430643 | 3430643 | 2022-07-14 | US | Michigan | Ontonagon | 26131 | 1080 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-07-15 04:20:53 | Ontonagon, Michigan, US | |
3111217 | 3111217 | 2022-07-13 | US | Minnesota | Kittson | 27069 | 1080 | 28 | 0 | 48.77754106 | -96.78317184 | 2022-07-14 04:20:57 | Kittson, Minnesota, US | |
3111163 | 3111163 | 2022-07-13 | US | Michigan | Ontonagon | 26131 | 1080 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-07-14 04:20:57 | Ontonagon, Michigan, US | |
631640 | 631640 | 2022-07-12 | US | Minnesota | Kittson | 27069 | 1080 | 28 | 0 | 48.77754106 | -96.78317184 | 2022-07-13 04:20:58 | Kittson, Minnesota, US | |
631586 | 631586 | 2022-07-12 | US | Michigan | Ontonagon | 26131 | 1080 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-07-13 04:20:58 | Ontonagon, Michigan, US | |
1213284 | 1213284 | 2022-07-11 | US | Minnesota | Kittson | 27069 | 1080 | 28 | 0 | 48.77754106 | -96.78317184 | 2022-07-12 04:20:51 | Kittson, Minnesota, US | |
2791433 | 2791433 | 2022-07-10 | US | North Dakota | Dunn | 38025 | 1080 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-07-11 04:20:46 | Dunn, North Dakota, US | |
2790766 | 2790766 | 2022-07-10 | US | Minnesota | Kittson | 27069 | 1080 | 28 | 0 | 48.77754106 | -96.78317184 | 2022-07-11 04:20:46 | Kittson, Minnesota, US | |
144386 | 144386 | 2022-07-09 | US | North Dakota | Dunn | 38025 | 1080 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-07-10 04:20:54 | Dunn, North Dakota, US | |
143719 | 143719 | 2022-07-09 | US | Minnesota | Kittson | 27069 | 1080 | 28 | 0 | 48.77754106 | -96.78317184 | 2022-07-10 04:20:54 | Kittson, Minnesota, US | |
1420214 | 1420214 | 2022-07-08 | US | Texas | Hudspeth | 48229 | 1080 | 18 | 0 | 31.45628381 | -105.388178 | 2022-07-09 04:20:59 | Hudspeth, Texas, US | |
1419486 | 1419486 | 2022-07-08 | US | North Dakota | Dunn | 38025 | 1080 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-07-09 04:20:59 | Dunn, North Dakota, US | |
1418819 | 1418819 | 2022-07-08 | US | Minnesota | Kittson | 27069 | 1080 | 28 | 0 | 48.77754106 | -96.78317184 | 2022-07-09 04:20:59 | Kittson, Minnesota, US | |
1417711 | 1417711 | 2022-07-08 | US | Colorado | Gilpin | 8047 | 1080 | 5 | 0 | 39.85646523 | -105.5252597 | 2022-07-09 04:20:59 | Gilpin, Colorado, US | |
2744139 | 2744139 | 2022-07-07 | US | Texas | Hudspeth | 48229 | 1080 | 18 | 0 | 31.45628381 | -105.388178 | 2022-07-08 04:20:56 | Hudspeth, Texas, US | |
2742744 | 2742744 | 2022-07-07 | US | Minnesota | Kittson | 27069 | 1080 | 28 | 0 | 48.77754106 | -96.78317184 | 2022-07-08 04:20:56 | Kittson, Minnesota, US | |
2741636 | 2741636 | 2022-07-07 | US | Colorado | Gilpin | 8047 | 1080 | 5 | 0 | 39.85646523 | -105.5252597 | 2022-07-08 04:20:56 | Gilpin, Colorado, US | |
1202359 | 1202359 | 2022-07-06 | US | Oklahoma | Dewey | 40043 | 1080 | 32 | 0 | 35.98772922 | -99.00730714 | 2022-07-07 04:20:55 | Dewey, Oklahoma, US | |
1200431 | 1200431 | 2022-07-06 | US | Colorado | Gilpin | 8047 | 1080 | 5 | 0 | 39.85646523 | -105.5252597 | 2022-07-07 04:20:55 | Gilpin, Colorado, US | |
3969413 | 3969413 | 2022-07-05 | US | South Dakota | Corson | 46031 | 1080 | 17 | 0 | 45.70889983 | -101.1970473 | 2022-07-06 04:20:58 | Corson, South Dakota, US | |
3969102 | 3969102 | 2022-07-05 | US | Oklahoma | Dewey | 40043 | 1080 | 32 | 0 | 35.98772922 | -99.00730714 | 2022-07-06 04:20:58 | Dewey, Oklahoma, US | |
3080924 | 3080924 | 2022-07-04 | US | South Dakota | Corson | 46031 | 1080 | 17 | 0 | 45.70889983 | -101.1970473 | 2022-07-05 04:20:45 | Corson, South Dakota, US | |
3080613 | 3080613 | 2022-07-04 | US | Oklahoma | Dewey | 40043 | 1080 | 32 | 0 | 35.98772922 | -99.00730714 | 2022-07-05 04:20:45 | Dewey, Oklahoma, US | |
1770206 | 1770206 | 2022-07-03 | US | South Dakota | Corson | 46031 | 1080 | 17 | 0 | 45.70889983 | -101.1970473 | 2022-07-04 04:20:54 | Corson, South Dakota, US | |
1769895 | 1769895 | 2022-07-03 | US | Oklahoma | Dewey | 40043 | 1080 | 32 | 0 | 35.98772922 | -99.00730714 | 2022-07-04 04:20:54 | Dewey, Oklahoma, US | |
3368192 | 3368192 | 2022-07-02 | US | South Dakota | Corson | 46031 | 1080 | 17 | 0 | 45.70889983 | -101.1970473 | 2022-07-03 04:20:59 | Corson, South Dakota, US | |
3367881 | 3367881 | 2022-07-02 | US | Oklahoma | Dewey | 40043 | 1080 | 32 | 0 | 35.98772922 | -99.00730714 | 2022-07-03 04:20:59 | Dewey, Oklahoma, US | |
596521 | 596521 | 2022-07-01 | US | South Dakota | Corson | 46031 | 1080 | 17 | 0 | 45.70889983 | -101.1970473 | 2022-07-02 04:21:16 | Corson, South Dakota, US | |
596210 | 596210 | 2022-07-01 | US | Oklahoma | Dewey | 40043 | 1080 | 32 | 0 | 35.98772922 | -99.00730714 | 2022-07-02 04:21:16 | Dewey, Oklahoma, US | |
3942922 | 3942922 | 2022-06-30 | US | South Dakota | Corson | 46031 | 1080 | 17 | 0 | 45.70889983 | -101.1970473 | 2022-07-01 04:21:10 | Corson, South Dakota, US | |
3942611 | 3942611 | 2022-06-30 | US | Oklahoma | Dewey | 40043 | 1080 | 32 | 0 | 35.98772922 | -99.00730714 | 2022-07-01 04:21:10 | Dewey, Oklahoma, US | |
2492880 | 2492880 | 2022-06-29 | US | South Dakota | Corson | 46031 | 1080 | 17 | 0 | 45.70889983 | -101.1970473 | 2022-06-30 04:21:01 | Corson, South Dakota, US | |
2491014 | 2491014 | 2022-06-29 | US | Illinois | Hardin | 17069 | 1080 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-06-30 04:21:01 | Hardin, Illinois, US | |
2981678 | 2981678 | 2022-06-13 | US | North Dakota | Pierce | 38069 | 1080 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-06-14 04:20:52 | Pierce, North Dakota, US | |
3509436 | 3509436 | 2022-06-05 | US | Nebraska | Boone | 31011 | 1080 | 5 | 0 | 41.70759415 | -98.06737183 | 2022-06-06 04:20:57 | Boone, Nebraska, US | |
3529513 | 3529513 | 2022-06-04 | US | Nebraska | Boone | 31011 | 1080 | 5 | 0 | 41.70759415 | -98.06737183 | 2022-06-05 04:20:55 | Boone, Nebraska, US | |
1111618 | 1111618 | 2022-05-21 | US | Nebraska | Antelope | 31003 | 1080 | 14 | 0 | 42.17695516 | -98.0666283 | 2022-05-22 04:20:52 | Antelope, Nebraska, US | |
1171242 | 1171242 | 2022-05-20 | US | Nebraska | Antelope | 31003 | 1080 | 14 | 0 | 42.17695516 | -98.0666283 | 2022-05-21 04:20:58 | Antelope, Nebraska, US | |
3898005 | 3898005 | 2022-05-19 | US | Nebraska | Antelope | 31003 | 1080 | 14 | 0 | 42.17695516 | -98.0666283 | 2022-05-20 04:20:57 | Antelope, Nebraska, US | |
1186789 | 1186789 | 2022-05-18 | US | Nebraska | Antelope | 31003 | 1080 | 14 | 0 | 42.17695516 | -98.0666283 | 2022-05-19 04:20:54 | Antelope, Nebraska, US | |
3584686 | 3584686 | 2022-05-17 | US | Nebraska | Antelope | 31003 | 1080 | 14 | 0 | 42.17695516 | -98.0666283 | 2022-05-18 04:20:50 | Antelope, Nebraska, US | |
1505643 | 1505643 | 2022-05-16 | US | Nebraska | Antelope | 31003 | 1080 | 14 | 0 | 42.17695516 | -98.0666283 | 2022-05-17 04:20:59 | Antelope, Nebraska, US | |
2086002 | 2086002 | 2022-05-15 | US | Nebraska | Antelope | 31003 | 1080 | 14 | 0 | 42.17695516 | -98.0666283 | 2022-05-16 04:20:47 | Antelope, Nebraska, US | |
697496 | 697496 | 2022-03-17 | US | Texas | Hall | 48191 | 1080 | 23 | 0 | 34.5307555 | -100.68138520000001 | 2022-03-18 04:20:55 | Hall, Texas, US | |
2322439 | 2322439 | 2022-03-16 | US | Texas | Hall | 48191 | 1080 | 23 | 0 | 34.5307555 | -100.68138520000001 | 2022-03-17 04:20:56 | Hall, Texas, US | |
2643824 | 2643824 | 2022-02-14 | US | Nebraska | Fillmore | 31059 | 1080 | 8 | 0 | 40.52458567 | -97.59646937 | 2022-02-15 04:21:09 | Fillmore, Nebraska, US | |
188141 | 188141 | 2022-02-13 | US | Nebraska | Fillmore | 31059 | 1080 | 8 | 0 | 40.52458567 | -97.59646937 | 2022-02-14 04:20:51 | Fillmore, Nebraska, US | |
317987 | 317987 | 2022-02-12 | US | Nebraska | Fillmore | 31059 | 1080 | 8 | 0 | 40.52458567 | -97.59646937 | 2022-02-13 04:21:00 | Fillmore, Nebraska, US | |
315723 | 315723 | 2022-02-12 | China | Shandong | 1080 | 7 | 0 | 36.3427 | 118.1498 | 2022-02-13 04:21:00 | Shandong, China | |||
235313 | 235313 | 2022-02-11 | US | Nebraska | Fillmore | 31059 | 1080 | 8 | 0 | 40.52458567 | -97.59646937 | 2022-02-12 04:21:06 | Fillmore, Nebraska, US | |
2016314 | 2016314 | 2022-02-06 | US | Wyoming | Hot Springs | 56017 | 1080 | 14 | 0 | 43.71930657 | -108.44231740000001 | 2022-02-07 04:21:05 | Hot Springs, Wyoming, US | |
1297643 | 1297643 | 2022-02-05 | US | Wyoming | Hot Springs | 56017 | 1080 | 14 | 0 | 43.71930657 | -108.44231740000001 | 2022-02-06 04:21:00 | Hot Springs, Wyoming, US | |
2330971 | 2330971 | 2022-02-04 | US | Wyoming | Hot Springs | 56017 | 1080 | 14 | 0 | 43.71930657 | -108.44231740000001 | 2022-02-05 04:21:05 | Hot Springs, Wyoming, US | |
461337 | 461337 | 2022-02-02 | US | Missouri | Reynolds | 29179 | 1080 | 20 | 0 | 37.36085952 | -90.97009925 | 2022-02-03 04:21:21 | Reynolds, Missouri, US | |
2055210 | 2055210 | 2022-01-25 | US | Virginia | Cumberland | 51049 | 1080 | 19 | 0 | 37.51328851 | -78.24398086 | 2022-01-26 04:21:07 | Cumberland, Virginia, US | |
3426818 | 3426818 | 2022-01-21 | US | Missouri | Atchison | 29005 | 1080 | 19 | 0 | 40.43238737 | -95.42970639 | 2022-01-22 04:21:13 | Atchison, Missouri, US | |
1962645 | 1962645 | 2022-01-20 | US | Nebraska | Jefferson | 31095 | 1080 | 1 | 0 | 40.17584531 | -97.142601 | 2022-01-21 04:21:09 | Jefferson, Nebraska, US | |
1475332 | 1475332 | 2022-01-17 | US | Texas | San Saba | 48411 | 1080 | 29 | 0 | 31.1577796 | -98.81758731 | 2022-01-18 04:21:04 | San Saba, Texas, US | |
127324 | 127324 | 2022-01-09 | US | California | Trinity | 6105 | 1080 | 19 | 0 | 40.64917670000001 | -123.114713 | 2022-01-10 04:22:07 | Trinity, California, US | |
1435299 | 1435299 | 2021-12-28 | US | Puerto Rico | Ciales | 72039 | 1080 | 0 | 0 | 18.28885 | -66.516475 | 2021-12-29 03:21:43 | Ciales, Puerto Rico, US | |
1434177 | 1434177 | 2021-12-28 | US | Michigan | Alger | 26003 | 1080 | 11 | 0 | 46.41292944 | -86.60260122 | 2021-12-29 03:21:43 | Alger, Michigan, US | |
732138 | 732138 | 2021-12-27 | US | Michigan | Alger | 26003 | 1080 | 11 | 0 | 46.41292944 | -86.60260122 | 2021-12-28 04:21:47 | Alger, Michigan, US | |
799360 | 799360 | 2021-12-22 | US | Idaho | Caribou | 16029 | 1080 | 23 | 0 | 42.77149116 | -111.5597683 | 2021-12-23 04:21:21 | Caribou, Idaho, US | |
3498153 | 3498153 | 2021-12-15 | US | Missouri | Shelby | 29205 | 1080 | 13 | 0 | 39.79742518 | -92.07634971 | 2021-12-16 04:22:11 | Shelby, Missouri, US | |
1662480 | 1662480 | 2021-12-12 | US | Nebraska | Cedar | 31027 | 1080 | 11 | 0 | 42.598885100000004 | -97.25311951 | 2021-12-13 04:22:02 | Cedar, Nebraska, US | |
1666496 | 1666496 | 2021-12-11 | US | Nebraska | Cedar | 31027 | 1080 | 11 | 0 | 42.598885100000004 | -97.25311951 | 2021-12-12 04:22:12 | Cedar, Nebraska, US | |
3657648 | 3657648 | 2021-12-10 | US | Nebraska | Cedar | 31027 | 1080 | 11 | 0 | 42.598885100000004 | -97.25311951 | 2021-12-11 04:22:45 | Cedar, Nebraska, US | |
407048 | 407048 | 2021-12-07 | US | Puerto Rico | Lares | 72081 | 1080 | 0 | 0 | 18.269035000000002 | -66.867236 | 2021-12-08 04:22:46 | Lares, Puerto Rico, US | |
1033130 | 1033130 | 2021-12-06 | US | Puerto Rico | Lares | 72081 | 1080 | 0 | 0 | 18.269035000000002 | -66.867236 | 2021-12-07 04:22:34 | Lares, Puerto Rico, US | |
1743293 | 1743293 | 2021-12-05 | US | Puerto Rico | Lares | 72081 | 1080 | 0 | 0 | 18.269035000000002 | -66.867236 | 2021-12-06 04:22:34 | Lares, Puerto Rico, US | |
140725 | 140725 | 2021-12-04 | US | Puerto Rico | Lares | 72081 | 1080 | 0 | 0 | 18.269035000000002 | -66.867236 | 2021-12-05 04:22:25 | Lares, Puerto Rico, US | |
2198378 | 2198378 | 2021-12-03 | US | Puerto Rico | Lares | 72081 | 1080 | 0 | 0 | 18.269035000000002 | -66.867236 | 2021-12-04 04:22:18 | Lares, Puerto Rico, US | |
3233 | 3233 | 2021-12-02 | US | South Dakota | Spink | 46115 | 1080 | 29 | 0 | 44.93837606 | -98.34626602 | 2021-12-03 04:23:05 | Spink, South Dakota, US | |
3084 | 3084 | 2021-12-02 | US | Puerto Rico | Lares | 72081 | 1080 | 0 | 0 | 18.269035000000002 | -66.867236 | 2021-12-03 04:23:05 | Lares, Puerto Rico, US | |
1147020 | 1147020 | 2021-12-01 | US | Nebraska | Keith | 31101 | 1080 | 10 | 0 | 41.19930341 | -101.66201640000001 | 2021-12-02 04:22:37 | Keith, Nebraska, US | |
3404315 | 3404315 | 2021-11-30 | US | South Dakota | Hamlin | 46057 | 1080 | 40 | 0 | 44.67385954 | -97.18829593 | 2021-12-01 04:22:29 | Hamlin, South Dakota, US | |
1806108 | 1806108 | 2021-11-25 | US | Virginia | Lancaster | 51103 | 1080 | 23 | 0 | 37.71889653 | -76.46400482 | 2021-11-26 04:22:33 | Lancaster, Virginia, US | |
3345016 | 3345016 | 2021-11-16 | US | North Dakota | Dickey | 38021 | 1080 | 36 | 0 | 46.11017712 | -98.50490079999999 | 2021-11-17 04:21:48 | Dickey, North Dakota, US | |
30543 | 30543 | 2021-11-11 | US | Nebraska | Thurston | 31173 | 1080 | 11 | 0 | 42.15725356 | -96.54157099 | 2021-11-12 04:22:01 | Thurston, Nebraska, US | |
700289 | 700289 | 2021-11-04 | US | Missouri | Carter | 29035 | 1080 | 14 | 0 | 36.94160441 | -90.96051322 | 2021-11-05 04:21:54 | Carter, Missouri, US | |
47015 | 47015 | 2021-11-02 | US | Virginia | Bland | 51021 | 1080 | 17 | 0 | 37.13128068 | -81.13599391 | 2021-11-03 06:22:09 | Bland, Virginia, US | |
568249 | 568249 | 2021-10-29 | US | Indiana | Union | 18161 | 1080 | 16 | 0 | 39.62550777 | -84.92497066 | 2021-10-30 04:22:03 | Union, Indiana, US | |
3493062 | 3493062 | 2021-10-26 | US | Georgia | Twiggs | 13289 | 1080 | 59 | 0 | 32.67435595 | -83.43078662 | 2021-10-27 04:22:32 | Twiggs, Georgia, 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]);