johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
380 rows where confirmed = 1831 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 354
- United Kingdom 16
- China 3
- Canada 1
- Denmark 1
- India 1
- Japan 1
- Luxembourg 1
- New Zealand 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2488536 | 2488536 | 2022-11-16 | US | Oklahoma | Alfalfa | 40003 | 1831 | 17 | 0 | 36.73090616 | -98.32408495 | 2022-11-17 04:21:11 | Alfalfa, Oklahoma, US | |
294547 | 294547 | 2022-11-15 | US | Oklahoma | Alfalfa | 40003 | 1831 | 17 | 0 | 36.73090616 | -98.32408495 | 2022-11-16 04:21:09 | Alfalfa, Oklahoma, US | |
3599577 | 3599577 | 2022-11-14 | US | Oklahoma | Alfalfa | 40003 | 1831 | 17 | 0 | 36.73090616 | -98.32408495 | 2022-11-15 04:21:16 | Alfalfa, Oklahoma, US | |
314435 | 314435 | 2022-11-13 | US | Oklahoma | Alfalfa | 40003 | 1831 | 17 | 0 | 36.73090616 | -98.32408495 | 2022-11-14 04:21:09 | Alfalfa, Oklahoma, US | |
65596 | 65596 | 2022-11-12 | US | Oklahoma | Alfalfa | 40003 | 1831 | 17 | 0 | 36.73090616 | -98.32408495 | 2022-11-13 04:21:14 | Alfalfa, Oklahoma, US | |
2929758 | 2929758 | 2022-11-11 | US | Oklahoma | Alfalfa | 40003 | 1831 | 17 | 0 | 36.73090616 | -98.32408495 | 2022-11-12 04:20:41 | Alfalfa, Oklahoma, US | |
2927020 | 2927020 | 2022-11-11 | China | Hunan | 1831 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-12 04:20:41 | Hunan, China | |||
2508594 | 2508594 | 2022-11-10 | US | Oklahoma | Alfalfa | 40003 | 1831 | 17 | 0 | 36.73090616 | -98.32408495 | 2022-11-11 04:21:22 | Alfalfa, Oklahoma, US | |
2508247 | 2508247 | 2022-11-10 | US | New Jersey | Unassigned | 90034 | 1831 | 0 | 0 | 41.13891592 | 0.0 | 2022-11-11 04:21:22 | Unassigned, New Jersey, US | |
2830781 | 2830781 | 2022-08-25 | US | Missouri | Shelby | 29205 | 1831 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-08-26 04:21:02 | Shelby, Missouri, US | |
2325314 | 2325314 | 2022-08-24 | US | Missouri | Shelby | 29205 | 1831 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-08-25 04:21:13 | Shelby, Missouri, US | |
1252723 | 1252723 | 2022-08-23 | US | Missouri | Shelby | 29205 | 1831 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-08-24 04:20:46 | Shelby, Missouri, US | |
2854827 | 2854827 | 2022-08-22 | US | Missouri | Shelby | 29205 | 1831 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-08-23 04:20:56 | Shelby, Missouri, US | |
2404799 | 2404799 | 2022-08-21 | US | Missouri | Shelby | 29205 | 1831 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-08-22 04:20:38 | Shelby, Missouri, US | |
3799877 | 3799877 | 2022-08-20 | US | Missouri | Shelby | 29205 | 1831 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-08-21 04:20:44 | Shelby, Missouri, US | |
2365463 | 2365463 | 2022-08-19 | US | Missouri | Shelby | 29205 | 1831 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-08-20 04:21:01 | Shelby, Missouri, US | |
1406239 | 1406239 | 2022-08-02 | US | Iowa | Greene | 19073 | 1831 | 22 | 0 | 42.03614551 | -94.39658081 | 2022-08-03 04:20:59 | Greene, Iowa, US | |
3618277 | 3618277 | 2022-08-01 | US | Iowa | Greene | 19073 | 1831 | 22 | 0 | 42.03614551 | -94.39658081 | 2022-08-02 04:20:53 | Greene, Iowa, US | |
3617595 | 3617595 | 2022-08-01 | US | Arkansas | Newton | 5101 | 1831 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-08-02 04:20:53 | Newton, Arkansas, US | |
3872757 | 3872757 | 2022-07-31 | US | Iowa | Greene | 19073 | 1831 | 22 | 0 | 42.03614551 | -94.39658081 | 2022-08-01 04:21:03 | Greene, Iowa, US | |
675511 | 675511 | 2022-07-30 | US | Iowa | Greene | 19073 | 1831 | 22 | 0 | 42.03614551 | -94.39658081 | 2022-07-31 04:21:02 | Greene, Iowa, US | |
1784710 | 1784710 | 2022-07-29 | US | Iowa | Greene | 19073 | 1831 | 22 | 0 | 42.03614551 | -94.39658081 | 2022-07-30 04:20:42 | Greene, Iowa, US | |
1067823 | 1067823 | 2022-07-28 | US | Missouri | Ozark | 29153 | 1831 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-07-29 04:20:45 | Ozark, Missouri, US | |
1067073 | 1067073 | 2022-07-28 | US | Iowa | Greene | 19073 | 1831 | 22 | 0 | 42.03614551 | -94.39658081 | 2022-07-29 04:20:45 | Greene, Iowa, US | |
2337342 | 2337342 | 2022-07-27 | US | Missouri | Ozark | 29153 | 1831 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-07-28 04:20:56 | Ozark, Missouri, US | |
2336592 | 2336592 | 2022-07-27 | US | Iowa | Greene | 19073 | 1831 | 22 | 0 | 42.03614551 | -94.39658081 | 2022-07-28 04:20:56 | Greene, Iowa, US | |
1489532 | 1489532 | 2022-07-26 | US | Missouri | Ozark | 29153 | 1831 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-07-27 04:21:04 | Ozark, Missouri, US | |
2595978 | 2595978 | 2022-07-25 | US | Missouri | Ozark | 29153 | 1831 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-07-26 04:20:58 | Ozark, Missouri, US | |
898093 | 898093 | 2022-07-24 | US | Missouri | Ozark | 29153 | 1831 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-07-25 04:20:51 | Ozark, Missouri, US | |
93087 | 93087 | 2022-07-23 | US | Missouri | Ozark | 29153 | 1831 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-07-24 04:20:47 | Ozark, Missouri, US | |
902109 | 902109 | 2022-07-22 | US | Missouri | Ozark | 29153 | 1831 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-07-23 04:20:53 | Ozark, Missouri, US | |
673960 | 673960 | 2022-07-21 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-22 04:21:15 | Falkland Islands (Malvinas), United Kingdom | |||
1611923 | 1611923 | 2022-07-20 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-21 04:21:10 | Falkland Islands (Malvinas), United Kingdom | |||
962556 | 962556 | 2022-07-19 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-20 04:20:59 | Falkland Islands (Malvinas), United Kingdom | |||
3213943 | 3213943 | 2022-07-18 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-19 04:20:58 | Falkland Islands (Malvinas), United Kingdom | |||
3409118 | 3409118 | 2022-07-17 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-18 04:20:59 | Falkland Islands (Malvinas), United Kingdom | |||
2155318 | 2155318 | 2022-07-16 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-17 04:21:15 | Falkland Islands (Malvinas), United Kingdom | |||
2422551 | 2422551 | 2022-07-15 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-16 04:21:05 | Falkland Islands (Malvinas), United Kingdom | |||
3432626 | 3432626 | 2022-07-14 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-15 04:20:53 | Falkland Islands (Malvinas), United Kingdom | |||
3113146 | 3113146 | 2022-07-13 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-14 04:20:57 | Falkland Islands (Malvinas), United Kingdom | |||
633569 | 633569 | 2022-07-12 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-13 04:20:58 | Falkland Islands (Malvinas), United Kingdom | |||
1215212 | 1215212 | 2022-07-11 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-12 04:20:51 | Falkland Islands (Malvinas), United Kingdom | |||
1213164 | 1213164 | 2022-07-11 | US | Michigan | Alger | 26003 | 1831 | 14 | 0 | 46.41292944 | -86.60260122 | 2022-07-12 04:20:51 | Alger, Michigan, US | |
2792694 | 2792694 | 2022-07-10 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-11 04:20:46 | Falkland Islands (Malvinas), United Kingdom | |||
2790646 | 2790646 | 2022-07-10 | US | Michigan | Alger | 26003 | 1831 | 14 | 0 | 46.41292944 | -86.60260122 | 2022-07-11 04:20:46 | Alger, Michigan, US | |
145647 | 145647 | 2022-07-09 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-10 04:20:54 | Falkland Islands (Malvinas), United Kingdom | |||
143599 | 143599 | 2022-07-09 | US | Michigan | Alger | 26003 | 1831 | 14 | 0 | 46.41292944 | -86.60260122 | 2022-07-10 04:20:54 | Alger, Michigan, US | |
1420747 | 1420747 | 2022-07-08 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-09 04:20:59 | Falkland Islands (Malvinas), United Kingdom | |||
1418699 | 1418699 | 2022-07-08 | US | Michigan | Alger | 26003 | 1831 | 14 | 0 | 46.41292944 | -86.60260122 | 2022-07-09 04:20:59 | Alger, Michigan, US | |
2744672 | 2744672 | 2022-07-07 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-08 04:20:56 | Falkland Islands (Malvinas), United Kingdom | |||
2742624 | 2742624 | 2022-07-07 | US | Michigan | Alger | 26003 | 1831 | 14 | 0 | 46.41292944 | -86.60260122 | 2022-07-08 04:20:56 | Alger, Michigan, US | |
1203467 | 1203467 | 2022-07-06 | United Kingdom | Falkland Islands (Malvinas) | 1831 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-07 04:20:55 | Falkland Islands (Malvinas), United Kingdom | |||
1201419 | 1201419 | 2022-07-06 | US | Michigan | Alger | 26003 | 1831 | 14 | 0 | 46.41292944 | -86.60260122 | 2022-07-07 04:20:55 | Alger, Michigan, US | |
3968162 | 3968162 | 2022-07-05 | US | Michigan | Alger | 26003 | 1831 | 14 | 0 | 46.41292944 | -86.60260122 | 2022-07-06 04:20:58 | Alger, Michigan, US | |
3985917 | 3985917 | 2022-06-15 | US | Virginia | Bland | 51021 | 1831 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-06-16 04:20:55 | Bland, Virginia, US | |
950158 | 950158 | 2022-06-14 | US | Virginia | Bland | 51021 | 1831 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-06-15 04:20:54 | Bland, Virginia, US | |
3729088 | 3729088 | 2022-06-07 | US | South Dakota | Fall River | 46047 | 1831 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-06-08 04:20:55 | Fall River, South Dakota, US | |
3890490 | 3890490 | 2022-06-06 | US | South Dakota | Fall River | 46047 | 1831 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-06-07 04:21:08 | Fall River, South Dakota, US | |
3510259 | 3510259 | 2022-06-05 | US | South Dakota | Fall River | 46047 | 1831 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-06-06 04:20:57 | Fall River, South Dakota, US | |
3530336 | 3530336 | 2022-06-04 | US | South Dakota | Fall River | 46047 | 1831 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-06-05 04:20:55 | Fall River, South Dakota, US | |
3136422 | 3136422 | 2022-06-03 | US | South Dakota | Fall River | 46047 | 1831 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-06-04 04:20:58 | Fall River, South Dakota, US | |
3581497 | 3581497 | 2022-06-02 | US | South Dakota | Fall River | 46047 | 1831 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-06-03 04:20:58 | Fall River, South Dakota, US | |
973992 | 973992 | 2022-06-01 | US | Texas | Delta | 48119 | 1831 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-06-02 05:20:39 | Delta, Texas, US | |
973790 | 973790 | 2022-06-01 | US | South Dakota | Fall River | 46047 | 1831 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-06-02 05:20:39 | Fall River, South Dakota, US | |
1852004 | 1852004 | 2022-05-26 | US | Montana | Madison | 30057 | 1831 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-05-27 04:20:56 | Madison, Montana, US | |
2049880 | 2049880 | 2022-05-25 | US | Montana | Madison | 30057 | 1831 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-05-26 04:20:50 | Madison, Montana, US | |
3001318 | 3001318 | 2022-05-24 | US | Montana | Madison | 30057 | 1831 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-05-25 04:20:56 | Madison, Montana, US | |
3595039 | 3595039 | 2022-05-23 | US | Montana | Madison | 30057 | 1831 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-05-24 04:20:57 | Madison, Montana, US | |
623891 | 623891 | 2022-05-22 | US | Montana | Madison | 30057 | 1831 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-05-26 04:20:50 | Madison, Montana, US | |
1111636 | 1111636 | 2022-05-21 | US | Nebraska | Cuming | 31039 | 1831 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-05-22 04:20:52 | Cuming, Nebraska, US | |
1111587 | 1111587 | 2022-05-21 | US | Montana | Madison | 30057 | 1831 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-05-22 04:20:52 | Madison, Montana, US | |
1171260 | 1171260 | 2022-05-20 | US | Nebraska | Cuming | 31039 | 1831 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-05-21 04:20:58 | Cuming, Nebraska, US | |
1171211 | 1171211 | 2022-05-20 | US | Montana | Madison | 30057 | 1831 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-05-21 04:20:58 | Madison, Montana, US | |
3898023 | 3898023 | 2022-05-19 | US | Nebraska | Cuming | 31039 | 1831 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-05-20 04:20:57 | Cuming, Nebraska, US | |
1186807 | 1186807 | 2022-05-18 | US | Nebraska | Cuming | 31039 | 1831 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-05-19 04:20:54 | Cuming, Nebraska, US | |
3584704 | 3584704 | 2022-05-17 | US | Nebraska | Cuming | 31039 | 1831 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-05-18 04:20:50 | Cuming, Nebraska, US | |
3583848 | 3583848 | 2022-05-17 | US | Iowa | Ida | 19093 | 1831 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-05-18 04:20:50 | Ida, Iowa, US | |
1505661 | 1505661 | 2022-05-16 | US | Nebraska | Cuming | 31039 | 1831 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-05-17 04:20:59 | Cuming, Nebraska, US | |
1504805 | 1504805 | 2022-05-16 | US | Iowa | Ida | 19093 | 1831 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-05-17 04:20:59 | Ida, Iowa, US | |
2086020 | 2086020 | 2022-05-15 | US | Nebraska | Cuming | 31039 | 1831 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-05-16 04:20:47 | Cuming, Nebraska, US | |
2085164 | 2085164 | 2022-05-15 | US | Iowa | Ida | 19093 | 1831 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-05-16 04:20:47 | Ida, Iowa, US | |
3355874 | 3355874 | 2022-05-14 | US | Iowa | Ida | 19093 | 1831 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-05-15 04:20:53 | Ida, Iowa, US | |
659519 | 659519 | 2022-05-13 | US | Iowa | Ida | 19093 | 1831 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-05-14 04:20:48 | Ida, Iowa, US | |
2536823 | 2536823 | 2022-05-12 | US | Virginia | Williamsburg | 51830 | 1831 | 22 | 0 | 37.28131268 | -76.70905141 | 2022-05-13 04:20:51 | Williamsburg, Virginia, US | |
2534602 | 2534602 | 2022-05-12 | US | Iowa | Ida | 19093 | 1831 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-05-13 04:20:51 | Ida, Iowa, US | |
3446048 | 3446048 | 2022-05-11 | US | Iowa | Ida | 19093 | 1831 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-05-12 04:20:54 | Ida, Iowa, US | |
3853727 | 3853727 | 2022-04-27 | US | Missouri | Hickory | 29085 | 1831 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-04-28 04:20:47 | Hickory, Missouri, US | |
1328157 | 1328157 | 2022-04-26 | US | Missouri | Hickory | 29085 | 1831 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-04-27 04:20:52 | Hickory, Missouri, US | |
3724111 | 3724111 | 2022-04-25 | US | Missouri | Hickory | 29085 | 1831 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-04-26 04:20:51 | Hickory, Missouri, US | |
2032146 | 2032146 | 2022-04-24 | US | Virginia | Middlesex | 51119 | 1831 | 47 | 0 | 37.63191998 | -76.55064617 | 2022-04-25 04:20:56 | Middlesex, Virginia, US | |
2030679 | 2030679 | 2022-04-24 | US | Missouri | Hickory | 29085 | 1831 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-04-25 04:20:56 | Hickory, Missouri, US | |
749721 | 749721 | 2022-04-23 | US | Virginia | Middlesex | 51119 | 1831 | 47 | 0 | 37.63191998 | -76.55064617 | 2022-04-24 04:20:56 | Middlesex, Virginia, US | |
748254 | 748254 | 2022-04-23 | US | Missouri | Hickory | 29085 | 1831 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-04-24 04:20:56 | Hickory, Missouri, US | |
3440206 | 3440206 | 2022-04-22 | US | Virginia | Middlesex | 51119 | 1831 | 47 | 0 | 37.63191998 | -76.55064617 | 2022-04-23 04:20:50 | Middlesex, Virginia, US | |
3438739 | 3438739 | 2022-04-22 | US | Missouri | Hickory | 29085 | 1831 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-04-23 04:20:50 | Hickory, Missouri, US | |
2895791 | 2895791 | 2022-04-21 | US | Virginia | Middlesex | 51119 | 1831 | 47 | 0 | 37.63191998 | -76.55064617 | 2022-04-22 04:20:45 | Middlesex, Virginia, US | |
2894324 | 2894324 | 2022-04-21 | US | Missouri | Hickory | 29085 | 1831 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-04-22 04:20:45 | Hickory, Missouri, US | |
1849352 | 1849352 | 2022-04-18 | US | Virginia | Middlesex | 51119 | 1831 | 46 | 0 | 37.63191998 | -76.55064617 | 2022-04-19 04:21:00 | Middlesex, Virginia, US | |
1223382 | 1223382 | 2022-04-14 | China | Beijing | 1831 | 9 | 0 | 40.1824 | 116.4142 | 2022-04-15 04:20:57 | Beijing, China | |||
1579629 | 1579629 | 2022-04-10 | US | West Virginia | Calhoun | 54013 | 1831 | 13 | 0 | 38.84315422 | -81.11934872 | 2022-04-11 04:21:02 | 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]);