johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
431 rows where confirmed = 1246 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 52
- Kansas 31
- Montana 31
- Kentucky 24
- Iowa 21
- Puerto Rico 20
- Wyoming 18
- Missouri 16
- Virginia 16
- Mississippi 14
- Alabama 12
- Georgia 12
- Illinois 12
- Nebraska 12
- Oklahoma 10
- Idaho 9
- Indiana 9
- Louisiana 9
- New Mexico 7
- Tennessee 7
- Arkansas 6
- Michigan 6
- Minnesota 6
- Ohio 6
- West Virginia 6
- Wisconsin 6
- California 5
- Colorado 5
- Florida 4
- Nevada 4
- …
country_or_region 1
- US · 431 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
834194 | 834194 | 2022-12-02 | US | California | Modoc | 6049 | 1246 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-12-03 04:21:02 | Modoc, California, US | |
3998039 | 3998039 | 2022-09-27 | US | Virginia | Rappahannock | 51157 | 1246 | 12 | 0 | 38.68295619 | -78.15826963 | 2022-09-28 04:23:01 | Rappahannock, Virginia, US | |
1978005 | 1978005 | 2022-09-25 | US | Kentucky | Carlisle | 21039 | 1246 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-26 04:20:52 | Carlisle, Kentucky, US | |
1978817 | 1978817 | 2022-09-25 | US | New Mexico | Guadalupe | 35019 | 1246 | 18 | 0 | 34.86319296 | -104.790669 | 2022-09-26 04:20:52 | Guadalupe, New Mexico, US | |
2651172 | 2651172 | 2022-09-24 | US | Kentucky | Carlisle | 21039 | 1246 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-25 04:23:31 | Carlisle, Kentucky, US | |
2651984 | 2651984 | 2022-09-24 | US | New Mexico | Guadalupe | 35019 | 1246 | 18 | 0 | 34.86319296 | -104.790669 | 2022-09-25 04:23:31 | Guadalupe, New Mexico, US | |
385612 | 385612 | 2022-09-23 | US | Kentucky | Carlisle | 21039 | 1246 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-24 04:21:40 | Carlisle, Kentucky, US | |
386424 | 386424 | 2022-09-23 | US | New Mexico | Guadalupe | 35019 | 1246 | 18 | 0 | 34.86319296 | -104.790669 | 2022-09-24 04:21:40 | Guadalupe, New Mexico, US | |
1625678 | 1625678 | 2022-09-22 | US | Kentucky | Carlisle | 21039 | 1246 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-23 04:23:13 | Carlisle, Kentucky, US | |
1626490 | 1626490 | 2022-09-22 | US | New Mexico | Guadalupe | 35019 | 1246 | 18 | 0 | 34.86319296 | -104.790669 | 2022-09-23 04:23:13 | Guadalupe, New Mexico, US | |
1371882 | 1371882 | 2022-09-21 | US | Kentucky | Carlisle | 21039 | 1246 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-22 04:22:56 | Carlisle, Kentucky, US | |
2018112 | 2018112 | 2022-09-20 | US | Kentucky | Carlisle | 21039 | 1246 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-21 04:23:22 | Carlisle, Kentucky, US | |
3571985 | 3571985 | 2022-09-19 | US | Kentucky | Carlisle | 21039 | 1246 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-20 04:22:48 | Carlisle, Kentucky, US | |
422372 | 422372 | 2022-09-18 | US | Texas | Brewster | 48043 | 1246 | 32 | 0 | 29.81008251 | -103.2520326 | 2022-09-19 04:21:49 | Brewster, Texas, US | |
3376396 | 3376396 | 2022-09-17 | US | Texas | Brewster | 48043 | 1246 | 32 | 0 | 29.81008251 | -103.2520326 | 2022-09-18 04:22:50 | Brewster, Texas, US | |
2358504 | 2358504 | 2022-09-16 | US | Texas | Brewster | 48043 | 1246 | 32 | 0 | 29.81008251 | -103.2520326 | 2022-09-17 04:20:19 | Brewster, Texas, US | |
3989661 | 3989661 | 2022-09-15 | US | Texas | Brewster | 48043 | 1246 | 32 | 0 | 29.81008251 | -103.2520326 | 2022-09-16 04:21:19 | Brewster, Texas, US | |
1892178 | 1892178 | 2022-09-14 | US | Texas | Brewster | 48043 | 1246 | 32 | 0 | 29.81008251 | -103.2520326 | 2022-09-15 04:21:02 | Brewster, Texas, US | |
1892690 | 1892690 | 2022-09-14 | US | Wisconsin | Florence | 55037 | 1246 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-09-15 04:21:02 | Florence, Wisconsin, US | |
375745 | 375745 | 2022-09-13 | US | Wisconsin | Florence | 55037 | 1246 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-09-14 04:20:44 | Florence, Wisconsin, US | |
2346753 | 2346753 | 2022-08-31 | US | Virginia | Craig | 51045 | 1246 | 22 | 0 | 37.48133648 | -80.21072274 | 2022-09-01 04:21:03 | Craig, Virginia, US | |
2832233 | 2832233 | 2022-08-25 | US | Virginia | Surry | 51181 | 1246 | 20 | 0 | 37.11781893 | -76.88450012 | 2022-08-26 04:21:02 | Surry, Virginia, US | |
1488905 | 1488905 | 2022-07-26 | US | Kansas | Meade | 20119 | 1246 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-27 04:21:04 | Meade, Kansas, US | |
2595351 | 2595351 | 2022-07-25 | US | Kansas | Meade | 20119 | 1246 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-26 04:20:58 | Meade, Kansas, US | |
897466 | 897466 | 2022-07-24 | US | Kansas | Meade | 20119 | 1246 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-25 04:20:51 | Meade, Kansas, US | |
92460 | 92460 | 2022-07-23 | US | Kansas | Meade | 20119 | 1246 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-24 04:20:47 | Meade, Kansas, US | |
901482 | 901482 | 2022-07-22 | US | Kansas | Meade | 20119 | 1246 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-23 04:20:53 | Meade, Kansas, US | |
671618 | 671618 | 2022-07-21 | US | Kansas | Meade | 20119 | 1246 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-22 04:21:15 | Meade, Kansas, US | |
1609581 | 1609581 | 2022-07-20 | US | Kansas | Meade | 20119 | 1246 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-21 04:21:10 | Meade, Kansas, US | |
959936 | 959936 | 2022-07-19 | US | Illinois | Putnam | 17155 | 1246 | 9 | 0 | 41.2013541 | -89.2869272 | 2022-07-20 04:20:59 | Putnam, Illinois, US | |
1215161 | 1215161 | 2022-07-11 | US | Wyoming | Hot Springs | 56017 | 1246 | 17 | 0 | 43.71930657 | -108.4423174 | 2022-07-12 04:20:51 | Hot Springs, Wyoming, US | |
2790032 | 2790032 | 2022-07-10 | US | Illinois | Henderson | 17071 | 1246 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-07-11 04:20:46 | Henderson, Illinois, US | |
2792643 | 2792643 | 2022-07-10 | US | Wyoming | Hot Springs | 56017 | 1246 | 17 | 0 | 43.71930657 | -108.4423174 | 2022-07-11 04:20:46 | Hot Springs, Wyoming, US | |
142985 | 142985 | 2022-07-09 | US | Illinois | Henderson | 17071 | 1246 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-07-10 04:20:54 | Henderson, Illinois, US | |
145596 | 145596 | 2022-07-09 | US | Wyoming | Hot Springs | 56017 | 1246 | 17 | 0 | 43.71930657 | -108.4423174 | 2022-07-10 04:20:54 | Hot Springs, Wyoming, US | |
1418085 | 1418085 | 2022-07-08 | US | Illinois | Henderson | 17071 | 1246 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-07-09 04:20:59 | Henderson, Illinois, US | |
1420696 | 1420696 | 2022-07-08 | US | Wyoming | Hot Springs | 56017 | 1246 | 17 | 0 | 43.71930657 | -108.4423174 | 2022-07-09 04:20:59 | Hot Springs, Wyoming, US | |
2744621 | 2744621 | 2022-07-07 | US | Wyoming | Hot Springs | 56017 | 1246 | 17 | 0 | 43.71930657 | -108.4423174 | 2022-07-08 04:20:56 | Hot Springs, Wyoming, US | |
1203416 | 1203416 | 2022-07-06 | US | Wyoming | Hot Springs | 56017 | 1246 | 17 | 0 | 43.71930657 | -108.4423174 | 2022-07-07 04:20:55 | Hot Springs, Wyoming, US | |
3970159 | 3970159 | 2022-07-05 | US | Wyoming | Hot Springs | 56017 | 1246 | 17 | 0 | 43.71930657 | -108.4423174 | 2022-07-06 04:20:58 | Hot Springs, Wyoming, US | |
2149379 | 2149379 | 2022-06-27 | US | Minnesota | Lincoln | 27081 | 1246 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-06-28 04:20:58 | Lincoln, Minnesota, US | |
3158292 | 3158292 | 2022-06-09 | US | Colorado | Saguache | 8109 | 1246 | 12 | 0 | 38.08054629 | -106.282466 | 2022-06-10 04:20:55 | Saguache, Colorado, US | |
3189209 | 3189209 | 2022-05-30 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-31 04:20:51 | San Saba, Texas, US | |
3201358 | 3201358 | 2022-05-29 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-30 04:20:50 | San Saba, Texas, US | |
2728236 | 2728236 | 2022-05-28 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-29 04:20:53 | San Saba, Texas, US | |
1317417 | 1317417 | 2022-05-27 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-28 04:21:07 | San Saba, Texas, US | |
1853209 | 1853209 | 2022-05-26 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-27 04:20:56 | San Saba, Texas, US | |
2051085 | 2051085 | 2022-05-25 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-26 04:20:50 | San Saba, Texas, US | |
3002523 | 3002523 | 2022-05-24 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-25 04:20:56 | San Saba, Texas, US | |
3596244 | 3596244 | 2022-05-23 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-24 04:20:57 | San Saba, Texas, US | |
625096 | 625096 | 2022-05-22 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-26 04:20:50 | San Saba, Texas, US | |
1112792 | 1112792 | 2022-05-21 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-22 04:20:52 | San Saba, Texas, US | |
1172416 | 1172416 | 2022-05-20 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-21 04:20:58 | San Saba, Texas, US | |
3899179 | 3899179 | 2022-05-19 | US | Texas | San Saba | 48411 | 1246 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-05-20 04:20:57 | San Saba, Texas, US | |
2535432 | 2535432 | 2022-05-12 | US | Montana | Toole | 30101 | 1246 | 24 | 0 | 48.65577551 | -111.6942414 | 2022-05-13 04:20:51 | Toole, Montana, US | |
3446878 | 3446878 | 2022-05-11 | US | Montana | Toole | 30101 | 1246 | 24 | 0 | 48.65577551 | -111.6942414 | 2022-05-12 04:20:54 | Toole, Montana, US | |
3537495 | 3537495 | 2022-05-10 | US | Montana | Toole | 30101 | 1246 | 24 | 0 | 48.65577551 | -111.6942414 | 2022-05-11 04:20:48 | Toole, Montana, US | |
224030 | 224030 | 2022-05-09 | US | Montana | Toole | 30101 | 1246 | 24 | 0 | 48.65577551 | -111.6942414 | 2022-05-10 04:20:50 | Toole, Montana, US | |
2333415 | 2333415 | 2022-05-08 | US | Montana | Toole | 30101 | 1246 | 24 | 0 | 48.65577551 | -111.6942414 | 2022-05-09 04:20:54 | Toole, Montana, US | |
362377 | 362377 | 2022-05-07 | US | Montana | Toole | 30101 | 1246 | 24 | 0 | 48.65577551 | -111.6942414 | 2022-05-08 04:20:49 | Toole, Montana, US | |
1399728 | 1399728 | 2022-05-06 | US | Montana | Toole | 30101 | 1246 | 24 | 0 | 48.65577551 | -111.6942414 | 2022-05-07 04:21:09 | Toole, Montana, US | |
2600083 | 2600083 | 2022-05-05 | US | Montana | Toole | 30101 | 1246 | 24 | 0 | 48.65577551 | -111.6942414 | 2022-05-06 04:21:00 | Toole, Montana, US | |
3724236 | 3724236 | 2022-04-25 | US | Montana | Toole | 30101 | 1246 | 23 | 0 | 48.65577551 | -111.69424140000001 | 2022-04-26 04:20:51 | Toole, Montana, US | |
3724304 | 3724304 | 2022-04-25 | US | Nebraska | Morrill | 31123 | 1246 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-04-26 04:20:51 | Morrill, Nebraska, US | |
2030804 | 2030804 | 2022-04-24 | US | Montana | Toole | 30101 | 1246 | 23 | 0 | 48.65577551 | -111.69424140000001 | 2022-04-25 04:20:56 | Toole, Montana, US | |
2030872 | 2030872 | 2022-04-24 | US | Nebraska | Morrill | 31123 | 1246 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-04-25 04:20:56 | Morrill, Nebraska, US | |
748379 | 748379 | 2022-04-23 | US | Montana | Toole | 30101 | 1246 | 23 | 0 | 48.65577551 | -111.69424140000001 | 2022-04-24 04:20:56 | Toole, Montana, US | |
748447 | 748447 | 2022-04-23 | US | Nebraska | Morrill | 31123 | 1246 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-04-24 04:20:56 | Morrill, Nebraska, US | |
3438864 | 3438864 | 2022-04-22 | US | Montana | Toole | 30101 | 1246 | 23 | 0 | 48.65577551 | -111.69424140000001 | 2022-04-23 04:20:50 | Toole, Montana, US | |
3438932 | 3438932 | 2022-04-22 | US | Nebraska | Morrill | 31123 | 1246 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-04-23 04:20:50 | Morrill, Nebraska, US | |
2894517 | 2894517 | 2022-04-21 | US | Nebraska | Morrill | 31123 | 1246 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-04-22 04:20:45 | Morrill, Nebraska, US | |
2309389 | 2309389 | 2022-04-20 | US | Nebraska | Morrill | 31123 | 1246 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-04-21 04:20:46 | Morrill, Nebraska, US | |
2253528 | 2253528 | 2022-04-19 | US | Nebraska | Morrill | 31123 | 1246 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-04-20 04:20:45 | Morrill, Nebraska, US | |
306600 | 306600 | 2022-04-16 | US | Puerto Rico | Ceiba | 72037 | 1246 | 0 | 0 | 18.251818 | -65.666416 | 2022-04-17 04:20:59 | Ceiba, Puerto Rico, US | |
2672545 | 2672545 | 2022-04-15 | US | Puerto Rico | Ceiba | 72037 | 1246 | 0 | 0 | 18.251818 | -65.666416 | 2022-04-16 04:20:48 | Ceiba, Puerto Rico, US | |
1225633 | 1225633 | 2022-04-14 | US | Montana | Toole | 30101 | 1246 | 23 | 0 | 48.65577551 | -111.69424140000001 | 2022-04-15 04:20:57 | Toole, Montana, US | |
1226330 | 1226330 | 2022-04-14 | US | Puerto Rico | Ceiba | 72037 | 1246 | 0 | 0 | 18.251818 | -65.666416 | 2022-04-15 04:20:57 | Ceiba, Puerto Rico, US | |
2444791 | 2444791 | 2022-04-13 | US | Montana | Toole | 30101 | 1246 | 23 | 0 | 48.65577551 | -111.69424140000001 | 2022-04-13 23:21:06 | Toole, Montana, US | |
1950548 | 1950548 | 2022-04-12 | US | Montana | Toole | 30101 | 1246 | 23 | 0 | 48.65577551 | -111.69424140000001 | 2022-04-13 04:21:03 | Toole, Montana, US | |
3208301 | 3208301 | 2022-04-11 | US | Montana | Toole | 30101 | 1246 | 23 | 0 | 48.65577551 | -111.69424140000001 | 2022-04-12 04:20:49 | Toole, Montana, US | |
2480733 | 2480733 | 2022-03-30 | US | Puerto Rico | Maunabo | 72095 | 1246 | 0 | 0 | 18.017889 | -65.922235 | 2022-03-31 04:20:56 | Maunabo, Puerto Rico, US | |
160774 | 160774 | 2022-03-29 | US | Puerto Rico | Maunabo | 72095 | 1246 | 0 | 0 | 18.017889 | -65.922235 | 2022-03-30 04:20:45 | Maunabo, Puerto Rico, US | |
1439345 | 1439345 | 2022-03-28 | US | Puerto Rico | Maunabo | 72095 | 1246 | 0 | 0 | 18.017889 | -65.922235 | 2022-03-29 04:20:46 | Maunabo, Puerto Rico, US | |
879026 | 879026 | 2022-03-27 | US | Puerto Rico | Maunabo | 72095 | 1246 | 0 | 0 | 18.017889 | -65.922235 | 2022-03-28 04:20:33 | Maunabo, Puerto Rico, US | |
2166309 | 2166309 | 2022-03-26 | US | Puerto Rico | Maunabo | 72095 | 1246 | 0 | 0 | 18.017889 | -65.922235 | 2022-03-27 04:20:47 | Maunabo, Puerto Rico, US | |
262579 | 262579 | 2022-03-15 | US | Illinois | Scott | 17171 | 1246 | 11 | 0 | 39.642916899999996 | -90.47814431 | 2022-03-16 04:20:50 | Scott, Illinois, US | |
2264938 | 2264938 | 2022-03-14 | US | Illinois | Scott | 17171 | 1246 | 11 | 0 | 39.642916899999996 | -90.47814431 | 2022-03-15 04:20:47 | Scott, Illinois, US | |
3629004 | 3629004 | 2022-03-13 | US | Illinois | Scott | 17171 | 1246 | 11 | 0 | 39.642916899999996 | -90.47814431 | 2022-03-14 04:20:46 | Scott, Illinois, US | |
951912 | 951912 | 2022-03-12 | US | Illinois | Scott | 17171 | 1246 | 11 | 0 | 39.642916899999996 | -90.47814431 | 2022-03-13 04:20:49 | Scott, Illinois, US | |
357373 | 357373 | 2022-03-11 | US | Illinois | Scott | 17171 | 1246 | 11 | 0 | 39.642916899999996 | -90.47814431 | 2022-03-12 04:20:50 | Scott, Illinois, US | |
944202 | 944202 | 2022-02-28 | US | Kentucky | Ballard | 21007 | 1246 | 27 | 0 | 37.05842757 | -88.99427697 | 2022-03-01 04:21:09 | Ballard, Kentucky, US | |
2733970 | 2733970 | 2022-02-27 | US | Idaho | Lemhi | 16059 | 1246 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-02-28 04:21:05 | Lemhi, Idaho, US | |
2734393 | 2734393 | 2022-02-27 | US | Kentucky | Ballard | 21007 | 1246 | 27 | 0 | 37.05842757 | -88.99427697 | 2022-02-28 04:21:05 | Ballard, Kentucky, US | |
3047123 | 3047123 | 2022-02-26 | US | Idaho | Lemhi | 16059 | 1246 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-02-27 04:21:04 | Lemhi, Idaho, US | |
3047546 | 3047546 | 2022-02-26 | US | Kentucky | Ballard | 21007 | 1246 | 27 | 0 | 37.05842757 | -88.99427697 | 2022-02-27 04:21:04 | Ballard, Kentucky, US | |
575778 | 575778 | 2022-02-25 | US | Idaho | Lemhi | 16059 | 1246 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-02-26 04:21:12 | Lemhi, Idaho, US | |
576201 | 576201 | 2022-02-25 | US | Kentucky | Ballard | 21007 | 1246 | 27 | 0 | 37.05842757 | -88.99427697 | 2022-02-26 04:21:12 | Ballard, Kentucky, US | |
3674209 | 3674209 | 2022-02-15 | US | Oklahoma | Greer | 40055 | 1246 | 30 | 0 | 34.93535801 | -99.56056120000001 | 2022-02-16 04:21:10 | Greer, Oklahoma, US | |
2644310 | 2644310 | 2022-02-14 | US | Oklahoma | Greer | 40055 | 1246 | 30 | 0 | 34.93535801 | -99.56056120000001 | 2022-02-15 04:21:09 | Greer, Oklahoma, US | |
2644924 | 2644924 | 2022-02-14 | US | Texas | McCulloch | 48307 | 1246 | 44 | 0 | 31.1925468 | -99.34682807 | 2022-02-15 04:21:09 | McCulloch, 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]);