johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
351 rows where confirmed = 1783 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 11
- US 329
- Japan 9
- China 4
- Sierra Leone 2
- Canada 1
- Colombia 1
- Cuba 1
- Malaysia 1
- Mauritania 1
- Netherlands 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3460601 | 3460601 | 2022-11-21 | US | Alaska | Prince of Wales-Hyder | 2198 | 1783 | 10 | 0 | 55.76261984 | -133.0511621 | 2022-11-22 04:20:47 | Prince of Wales-Hyder, Alaska, US | |
1640786 | 1640786 | 2022-11-20 | US | Alaska | Prince of Wales-Hyder | 2198 | 1783 | 10 | 0 | 55.76261984 | -133.0511621 | 2022-11-21 04:21:05 | Prince of Wales-Hyder, Alaska, US | |
2064343 | 2064343 | 2022-11-19 | US | Alaska | Prince of Wales-Hyder | 2198 | 1783 | 10 | 0 | 55.76261984 | -133.0511621 | 2022-11-20 04:21:08 | Prince of Wales-Hyder, Alaska, US | |
1755737 | 1755737 | 2022-11-18 | US | Alaska | Prince of Wales-Hyder | 2198 | 1783 | 10 | 0 | 55.76261984 | -133.0511621 | 2022-11-19 04:21:14 | Prince of Wales-Hyder, Alaska, US | |
3026730 | 3026730 | 2022-11-17 | US | Alaska | Prince of Wales-Hyder | 2198 | 1783 | 10 | 0 | 55.76261984 | -133.0511621 | 2022-11-18 04:21:15 | Prince of Wales-Hyder, Alaska, US | |
2486441 | 2486441 | 2022-11-16 | US | Alaska | Prince of Wales-Hyder | 2198 | 1783 | 10 | 0 | 55.76261984 | -133.0511621 | 2022-11-17 04:21:11 | Prince of Wales-Hyder, Alaska, US | |
292452 | 292452 | 2022-11-15 | US | Alaska | Prince of Wales-Hyder | 2198 | 1783 | 10 | 0 | 55.76261984 | -133.0511621 | 2022-11-16 04:21:09 | Prince of Wales-Hyder, Alaska, US | |
322326 | 322326 | 2022-10-30 | US | North Dakota | Bottineau | 38009 | 1783 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-10-31 04:21:36 | Bottineau, North Dakota, US | |
914602 | 914602 | 2022-10-29 | US | North Dakota | Bottineau | 38009 | 1783 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-10-30 04:22:14 | Bottineau, North Dakota, US | |
1368871 | 1368871 | 2022-10-28 | US | North Dakota | Bottineau | 38009 | 1783 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-10-29 04:21:13 | Bottineau, North Dakota, US | |
3099868 | 3099868 | 2022-10-09 | US | North Dakota | Ransom | 38073 | 1783 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-10-10 04:22:32 | Ransom, North Dakota, US | |
4005093 | 4005093 | 2022-10-08 | US | North Dakota | Ransom | 38073 | 1783 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-10-09 04:21:16 | Ransom, North Dakota, US | |
134421 | 134421 | 2022-10-04 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 1783 | 0 | 0 | -7.9467 | -14.3559 | 2022-10-05 04:23:06 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2395433 | 2395433 | 2022-09-12 | US | Colorado | Kit Carson | 8063 | 1783 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-09-13 04:20:57 | Kit Carson, Colorado, US | |
3766511 | 3766511 | 2022-09-11 | US | Colorado | Kit Carson | 8063 | 1783 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-09-12 04:20:58 | Kit Carson, Colorado, US | |
3825086 | 3825086 | 2022-09-10 | US | Colorado | Kit Carson | 8063 | 1783 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-09-11 04:20:50 | Kit Carson, Colorado, US | |
963543 | 963543 | 2022-09-09 | US | Colorado | Kit Carson | 8063 | 1783 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-09-10 04:21:10 | Kit Carson, Colorado, US | |
1684126 | 1684126 | 2022-08-29 | US | Wyoming | Weston | 56045 | 1783 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-30 04:21:03 | Weston, Wyoming, US | |
1880610 | 1880610 | 2022-08-28 | US | Wyoming | Weston | 56045 | 1783 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-29 04:21:06 | Weston, Wyoming, US | |
2099737 | 2099737 | 2022-08-27 | US | Wyoming | Weston | 56045 | 1783 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-28 04:21:02 | Weston, Wyoming, US | |
1535552 | 1535552 | 2022-08-26 | US | Wyoming | Weston | 56045 | 1783 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-27 04:20:57 | Weston, Wyoming, US | |
2832439 | 2832439 | 2022-08-25 | US | Wyoming | Weston | 56045 | 1783 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-26 04:21:02 | Weston, Wyoming, US | |
2326972 | 2326972 | 2022-08-24 | US | Wyoming | Weston | 56045 | 1783 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-25 04:21:13 | Weston, Wyoming, US | |
1254381 | 1254381 | 2022-08-23 | US | Wyoming | Weston | 56045 | 1783 | 20 | 0 | 43.83961191 | -104.5674881 | 2022-08-24 04:20:46 | Weston, Wyoming, US | |
1069044 | 1069044 | 2022-07-28 | US | Texas | Marion | 48315 | 1783 | 60 | 0 | 32.79868409 | -94.3566123 | 2022-07-29 04:20:45 | Marion, Texas, US | |
3430864 | 3430864 | 2022-07-14 | US | Missouri | Daviess | 29061 | 1783 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-07-15 04:20:53 | Daviess, Missouri, US | |
3430846 | 3430846 | 2022-07-14 | US | Missouri | Caldwell | 29025 | 1783 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-07-15 04:20:53 | Caldwell, Missouri, US | |
3111384 | 3111384 | 2022-07-13 | US | Missouri | Daviess | 29061 | 1783 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-07-14 04:20:57 | Daviess, Missouri, US | |
3111366 | 3111366 | 2022-07-13 | US | Missouri | Caldwell | 29025 | 1783 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-07-14 04:20:57 | Caldwell, Missouri, US | |
631807 | 631807 | 2022-07-12 | US | Missouri | Daviess | 29061 | 1783 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-07-13 04:20:58 | Daviess, Missouri, US | |
631789 | 631789 | 2022-07-12 | US | Missouri | Caldwell | 29025 | 1783 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-07-13 04:20:58 | Caldwell, Missouri, US | |
630422 | 630422 | 2022-07-12 | US | Arkansas | Newton | 5101 | 1783 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-07-13 04:20:58 | Newton, Arkansas, US | |
1213451 | 1213451 | 2022-07-11 | US | Missouri | Daviess | 29061 | 1783 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-07-12 04:20:51 | Daviess, Missouri, US | |
1213433 | 1213433 | 2022-07-11 | US | Missouri | Caldwell | 29025 | 1783 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-07-12 04:20:51 | Caldwell, Missouri, US | |
2790933 | 2790933 | 2022-07-10 | US | Missouri | Daviess | 29061 | 1783 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-07-11 04:20:46 | Daviess, Missouri, US | |
2790915 | 2790915 | 2022-07-10 | US | Missouri | Caldwell | 29025 | 1783 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-07-11 04:20:46 | Caldwell, Missouri, US | |
143886 | 143886 | 2022-07-09 | US | Missouri | Daviess | 29061 | 1783 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-07-10 04:20:54 | Daviess, Missouri, US | |
143868 | 143868 | 2022-07-09 | US | Missouri | Caldwell | 29025 | 1783 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-07-10 04:20:54 | Caldwell, Missouri, US | |
1418986 | 1418986 | 2022-07-08 | US | Missouri | Daviess | 29061 | 1783 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-07-09 04:20:59 | Daviess, Missouri, US | |
1418968 | 1418968 | 2022-07-08 | US | Missouri | Caldwell | 29025 | 1783 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-07-09 04:20:59 | Caldwell, Missouri, US | |
2242280 | 2242280 | 2022-06-28 | US | South Dakota | Hutchinson | 46067 | 1783 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-06-29 04:20:59 | Hutchinson, South Dakota, US | |
2150522 | 2150522 | 2022-06-27 | US | South Dakota | Hutchinson | 46067 | 1783 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-06-28 04:20:58 | Hutchinson, South Dakota, US | |
2149252 | 2149252 | 2022-06-27 | US | Michigan | Alcona | 26001 | 1783 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-28 04:20:58 | Alcona, Michigan, US | |
478323 | 478323 | 2022-06-26 | US | South Dakota | Hutchinson | 46067 | 1783 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-06-27 04:21:00 | Hutchinson, South Dakota, US | |
477053 | 477053 | 2022-06-26 | US | Michigan | Alcona | 26001 | 1783 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-27 04:21:00 | Alcona, Michigan, US | |
941698 | 941698 | 2022-06-25 | US | South Dakota | Hutchinson | 46067 | 1783 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-06-26 04:21:02 | Hutchinson, South Dakota, US | |
940428 | 940428 | 2022-06-25 | US | Michigan | Alcona | 26001 | 1783 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-26 04:21:02 | Alcona, Michigan, US | |
3349518 | 3349518 | 2022-06-24 | US | South Dakota | Hutchinson | 46067 | 1783 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-06-25 04:20:57 | Hutchinson, South Dakota, US | |
3348248 | 3348248 | 2022-06-24 | US | Michigan | Alcona | 26001 | 1783 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-25 04:20:57 | Alcona, Michigan, US | |
1651259 | 1651259 | 2022-06-23 | US | South Dakota | Hutchinson | 46067 | 1783 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-06-24 04:20:58 | Hutchinson, South Dakota, US | |
1649989 | 1649989 | 2022-06-23 | US | Michigan | Alcona | 26001 | 1783 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-24 04:20:58 | Alcona, Michigan, US | |
2190494 | 2190494 | 2022-06-22 | US | South Dakota | Hutchinson | 46067 | 1783 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-06-23 04:20:55 | Hutchinson, South Dakota, US | |
2189224 | 2189224 | 2022-06-22 | US | Michigan | Alcona | 26001 | 1783 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-06-23 04:20:55 | Alcona, Michigan, US | |
1421586 | 1421586 | 2022-06-08 | US | Arkansas | Dallas | 5039 | 1783 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-09 04:20:54 | Dallas, Arkansas, US | |
3726700 | 3726700 | 2022-06-07 | US | Arkansas | Dallas | 5039 | 1783 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-08 04:20:55 | Dallas, Arkansas, US | |
3000563 | 3000563 | 2022-05-24 | US | Iowa | Worth | 19195 | 1783 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-05-25 04:20:56 | Worth, Iowa, US | |
3594284 | 3594284 | 2022-05-23 | US | Iowa | Worth | 19195 | 1783 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-05-24 04:20:57 | Worth, Iowa, US | |
1112782 | 1112782 | 2022-05-21 | US | Texas | Refugio | 48391 | 1783 | 36 | 0 | 28.3238976 | -97.15766311 | 2022-05-22 04:20:52 | Refugio, Texas, US | |
1110832 | 1110832 | 2022-05-21 | US | Iowa | Worth | 19195 | 1783 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-05-22 04:20:52 | Worth, Iowa, US | |
1170456 | 1170456 | 2022-05-20 | US | Iowa | Worth | 19195 | 1783 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-05-21 04:20:58 | Worth, Iowa, US | |
3897219 | 3897219 | 2022-05-19 | US | Iowa | Worth | 19195 | 1783 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-05-20 04:20:57 | Worth, Iowa, US | |
3896572 | 3896572 | 2022-05-19 | US | Colorado | Conejos | 8021 | 1783 | 54 | 0 | 37.201606 | -106.1917488 | 2022-05-20 04:20:57 | Conejos, Colorado, US | |
1186003 | 1186003 | 2022-05-18 | US | Iowa | Worth | 19195 | 1783 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-05-19 04:20:54 | Worth, Iowa, US | |
3919343 | 3919343 | 2022-05-01 | US | Virginia | Bland | 51021 | 1783 | 23 | 0 | 37.13128068 | -81.13599391 | 2022-05-02 04:21:10 | Bland, Virginia, US | |
2844147 | 2844147 | 2022-04-30 | US | Virginia | Bland | 51021 | 1783 | 23 | 0 | 37.13128068 | -81.13599391 | 2022-05-01 04:20:57 | Bland, Virginia, US | |
1160460 | 1160460 | 2022-04-29 | US | Virginia | Bland | 51021 | 1783 | 23 | 0 | 37.13128068 | -81.13599391 | 2022-04-30 04:21:05 | Bland, Virginia, US | |
3855125 | 3855125 | 2022-04-27 | US | Virginia | Bland | 51021 | 1783 | 23 | 0 | 37.13128068 | -81.13599391 | 2022-04-28 04:20:47 | Bland, Virginia, US | |
3419047 | 3419047 | 2022-04-17 | US | Nebraska | Thurston | 31173 | 1783 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-18 04:21:12 | Thurston, Nebraska, US | |
306616 | 306616 | 2022-04-16 | US | Puerto Rico | Hormigueros | 72067 | 1783 | 0 | 0 | 18.134532 | -67.113972 | 2022-04-17 04:20:59 | Hormigueros, Puerto Rico, US | |
305996 | 305996 | 2022-04-16 | US | Nebraska | Thurston | 31173 | 1783 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-17 04:20:59 | Thurston, Nebraska, US | |
2672561 | 2672561 | 2022-04-15 | US | Puerto Rico | Hormigueros | 72067 | 1783 | 0 | 0 | 18.134532 | -67.113972 | 2022-04-16 04:20:48 | Hormigueros, Puerto Rico, US | |
2671941 | 2671941 | 2022-04-15 | US | Nebraska | Thurston | 31173 | 1783 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-16 04:20:48 | Thurston, Nebraska, US | |
1226346 | 1226346 | 2022-04-14 | US | Puerto Rico | Hormigueros | 72067 | 1783 | 0 | 0 | 18.134532 | -67.113972 | 2022-04-15 04:20:57 | Hormigueros, Puerto Rico, US | |
1225726 | 1225726 | 2022-04-14 | US | Nebraska | Thurston | 31173 | 1783 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-15 04:20:57 | Thurston, Nebraska, US | |
2444884 | 2444884 | 2022-04-13 | US | Nebraska | Thurston | 31173 | 1783 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-13 23:21:06 | Thurston, Nebraska, US | |
1950641 | 1950641 | 2022-04-12 | US | Nebraska | Thurston | 31173 | 1783 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-13 04:21:03 | Thurston, Nebraska, US | |
3208394 | 3208394 | 2022-04-11 | US | Nebraska | Thurston | 31173 | 1783 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-12 04:20:49 | Thurston, Nebraska, US | |
1578280 | 1578280 | 2022-04-10 | US | Nebraska | Thurston | 31173 | 1783 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-11 04:21:02 | Thurston, Nebraska, US | |
1654522 | 1654522 | 2022-04-09 | US | Nebraska | Thurston | 31173 | 1783 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-10 04:20:52 | Thurston, Nebraska, US | |
2117844 | 2117844 | 2022-04-08 | US | Nebraska | Thurston | 31173 | 1783 | 23 | 0 | 42.15725356 | -96.54157099 | 2022-04-09 04:20:42 | Thurston, Nebraska, US | |
3321535 | 3321535 | 2022-04-07 | US | Kansas | Greenwood | 20073 | 1783 | 23 | 0 | 37.8774388 | -96.23250453 | 2022-04-08 04:20:48 | Greenwood, Kansas, US | |
2802071 | 2802071 | 2022-04-06 | US | Kansas | Greenwood | 20073 | 1783 | 23 | 0 | 37.8774388 | -96.23250453 | 2022-04-07 04:20:53 | Greenwood, Kansas, US | |
3868840 | 3868840 | 2022-04-05 | US | Kansas | Greenwood | 20073 | 1783 | 23 | 0 | 37.8774388 | -96.23250453 | 2022-04-06 04:20:49 | Greenwood, Kansas, US | |
2750182 | 2750182 | 2022-04-04 | US | Kansas | Greenwood | 20073 | 1783 | 23 | 0 | 37.8774388 | -96.23250453 | 2022-04-05 04:20:48 | Greenwood, Kansas, US | |
3731528 | 3731528 | 2022-04-03 | US | Kansas | Greenwood | 20073 | 1783 | 23 | 0 | 37.8774388 | -96.23250453 | 2022-04-04 04:20:51 | Greenwood, Kansas, US | |
500963 | 500963 | 2022-04-02 | US | Kansas | Greenwood | 20073 | 1783 | 23 | 0 | 37.8774388 | -96.23250453 | 2022-04-03 04:20:48 | Greenwood, Kansas, US | |
3351948 | 3351948 | 2022-04-01 | US | Kansas | Greenwood | 20073 | 1783 | 23 | 0 | 37.8774388 | -96.23250453 | 2022-04-02 04:20:47 | Greenwood, Kansas, US | |
1514785 | 1514785 | 2022-02-24 | US | Virginia | Middlesex | 51119 | 1783 | 43 | 0 | 37.63191998 | -76.55064617 | 2022-02-25 04:21:11 | Middlesex, Virginia, US | |
2449093 | 2449093 | 2022-02-22 | US | North Carolina | Gates | 37073 | 1783 | 19 | 0 | 36.44667547 | -76.69749701 | 2022-02-23 04:21:09 | Gates, North Carolina, US | |
2448784 | 2448784 | 2022-02-22 | US | Montana | Madison | 30057 | 1783 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-02-23 04:21:09 | Madison, Montana, US | |
3720238 | 3720238 | 2022-02-21 | US | Nebraska | Butler | 31023 | 1783 | 11 | 0 | 41.22703692 | -97.13106306 | 2022-02-22 04:21:01 | Butler, Nebraska, US | |
1301278 | 1301278 | 2022-02-17 | US | Texas | Stephens | 48429 | 1783 | 40 | 0 | 32.73553157 | -98.83631615 | 2022-02-18 04:21:04 | Stephens, Texas, US | |
3823308 | 3823308 | 2022-02-16 | US | South Dakota | Fall River | 46047 | 1783 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-02-17 04:20:56 | Fall River, South Dakota, US | |
3673516 | 3673516 | 2022-02-15 | US | Mississippi | Wilkinson | 28157 | 1783 | 44 | 0 | 31.16078225 | -91.31018819 | 2022-02-16 04:21:10 | Wilkinson, Mississippi, US | |
1466137 | 1466137 | 2022-02-10 | US | Nebraska | Butler | 31023 | 1783 | 11 | 0 | 41.22703692 | -97.13106306 | 2022-02-11 04:21:09 | Butler, Nebraska, US | |
460203 | 460203 | 2022-02-02 | US | Georgia | Irwin | 13155 | 1783 | 42 | 0 | 31.60213036 | -83.27501387 | 2022-02-03 04:21:21 | Irwin, Georgia, US | |
982454 | 982454 | 2022-02-01 | US | West Virginia | Pendleton | 54071 | 1783 | 16 | 0 | 38.68314479 | -79.35084086 | 2022-02-02 04:21:09 | Pendleton, West Virginia, US | |
982284 | 982284 | 2022-02-01 | US | Virginia | Falls Church | 51610 | 1783 | 14 | 0 | 38.88485255 | -77.17560759 | 2022-02-02 04:21:09 | Falls Church, Virginia, US | |
3303773 | 3303773 | 2022-01-30 | US | Wisconsin | Menominee | 55078 | 1783 | 12 | 0 | 45.00422544 | -88.70950714 | 2022-01-31 04:21:09 | Menominee, Wisconsin, US | |
3065564 | 3065564 | 2022-01-29 | US | Wisconsin | Menominee | 55078 | 1783 | 12 | 0 | 45.00422544 | -88.70950714 | 2022-01-30 04:21:26 | Menominee, Wisconsin, 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]);