johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
403 rows where confirmed = 2065 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2138199 | 2138199 | 2022-12-01 | US | Montana | Valley | 30105 | 2065 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-12-02 04:21:07 | Valley, Montana, US | |
1966615 | 1966615 | 2022-11-30 | US | Montana | Valley | 30105 | 2065 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-12-01 04:21:03 | Valley, Montana, US | |
1965562 | 1965562 | 2022-11-30 | US | Illinois | Edwards | 17047 | 2065 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-12-01 04:21:03 | Edwards, Illinois, US | |
2558629 | 2558629 | 2022-11-29 | US | Montana | Valley | 30105 | 2065 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-30 04:21:07 | Valley, Montana, US | |
1241703 | 1241703 | 2022-11-28 | US | Montana | Valley | 30105 | 2065 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-29 04:21:05 | Valley, Montana, US | |
3553691 | 3553691 | 2022-11-27 | US | Montana | Valley | 30105 | 2065 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-28 04:21:02 | Valley, Montana, US | |
2102171 | 2102171 | 2022-11-26 | US | Montana | Valley | 30105 | 2065 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-27 04:21:05 | Valley, Montana, US | |
489662 | 489662 | 2022-11-25 | US | Montana | Valley | 30105 | 2065 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-26 04:21:11 | Valley, Montana, US | |
320588 | 320588 | 2022-10-30 | US | Colorado | Rio Blanco | 8103 | 2065 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-10-31 04:21:36 | Rio Blanco, Colorado, US | |
912864 | 912864 | 2022-10-29 | US | Colorado | Rio Blanco | 8103 | 2065 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-10-30 04:22:14 | Rio Blanco, Colorado, US | |
1367133 | 1367133 | 2022-10-28 | US | Colorado | Rio Blanco | 8103 | 2065 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-10-29 04:21:13 | Rio Blanco, Colorado, US | |
3038988 | 3038988 | 2022-10-27 | US | Colorado | Rio Blanco | 8103 | 2065 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-10-28 04:22:31 | Rio Blanco, Colorado, US | |
796582 | 796582 | 2022-10-24 | US | New Hampshire | Unassigned | 90033 | 2065 | 4 | 0 | 44.69063265 | 0.0 | 2022-10-25 04:21:53 | Unassigned, New Hampshire, US | |
3279857 | 3279857 | 2022-10-23 | US | Tennessee | Pickett | 47137 | 2065 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-24 04:22:29 | Pickett, Tennessee, US | |
2270895 | 2270895 | 2022-10-22 | US | Tennessee | Pickett | 47137 | 2065 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-23 04:22:46 | Pickett, Tennessee, US | |
1595195 | 1595195 | 2022-10-21 | US | Tennessee | Pickett | 47137 | 2065 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-22 04:22:53 | Pickett, Tennessee, US | |
2274911 | 2274911 | 2022-10-20 | US | Tennessee | Pickett | 47137 | 2065 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-21 04:22:23 | Pickett, Tennessee, US | |
201246 | 201246 | 2022-10-19 | US | Tennessee | Pickett | 47137 | 2065 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-20 04:22:59 | Pickett, Tennessee, US | |
2026444 | 2026444 | 2022-10-17 | US | Michigan | Schoolcraft | 26153 | 2065 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-18 04:22:42 | Schoolcraft, Michigan, US | |
2161222 | 2161222 | 2022-10-16 | US | Michigan | Schoolcraft | 26153 | 2065 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-17 04:20:31 | Schoolcraft, Michigan, US | |
517419 | 517419 | 2022-10-15 | US | Michigan | Schoolcraft | 26153 | 2065 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-16 04:22:39 | Schoolcraft, Michigan, US | |
2034476 | 2034476 | 2022-10-14 | US | Michigan | Schoolcraft | 26153 | 2065 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-15 04:22:00 | Schoolcraft, Michigan, US | |
3755164 | 3755164 | 2022-10-13 | US | Michigan | Schoolcraft | 26153 | 2065 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-14 04:22:28 | Schoolcraft, Michigan, US | |
3215989 | 3215989 | 2022-10-12 | US | Michigan | Schoolcraft | 26153 | 2065 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-13 04:22:39 | Schoolcraft, Michigan, US | |
3251838 | 3251838 | 2022-10-11 | US | Michigan | Schoolcraft | 26153 | 2065 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-12 04:22:51 | Schoolcraft, Michigan, US | |
3748319 | 3748319 | 2022-09-07 | US | Texas | Refugio | 48391 | 2065 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-09-08 04:21:02 | Refugio, Texas, US | |
2636925 | 2636925 | 2022-09-05 | US | Texas | Rains | 48379 | 2065 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-09-06 04:21:02 | Rains, Texas, US | |
2990489 | 2990489 | 2022-09-04 | US | Texas | Rains | 48379 | 2065 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-09-05 04:21:01 | Rains, Texas, US | |
2716174 | 2716174 | 2022-09-03 | US | Texas | Rains | 48379 | 2065 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-09-04 04:21:22 | Rains, Texas, US | |
1396879 | 1396879 | 2022-09-02 | US | Texas | Rains | 48379 | 2065 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-09-03 04:21:04 | Rains, Texas, US | |
2326414 | 2326414 | 2022-08-24 | US | Texas | Crosby | 48107 | 2065 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-08-25 04:21:13 | Crosby, Texas, US | |
1407102 | 1407102 | 2022-08-02 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-08-03 04:20:59 | Cheyenne, Nebraska, US | |
3619140 | 3619140 | 2022-08-01 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-08-02 04:20:53 | Cheyenne, Nebraska, US | |
3873620 | 3873620 | 2022-07-31 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-08-01 04:21:03 | Cheyenne, Nebraska, US | |
676374 | 676374 | 2022-07-30 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-31 04:21:02 | Cheyenne, Nebraska, US | |
1785573 | 1785573 | 2022-07-29 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-30 04:20:42 | Cheyenne, Nebraska, US | |
1067936 | 1067936 | 2022-07-28 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-29 04:20:45 | Cheyenne, Nebraska, US | |
2337455 | 2337455 | 2022-07-27 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-28 04:20:56 | Cheyenne, Nebraska, US | |
1489645 | 1489645 | 2022-07-26 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-27 04:21:04 | Cheyenne, Nebraska, US | |
2596091 | 2596091 | 2022-07-25 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-26 04:20:58 | Cheyenne, Nebraska, US | |
899525 | 899525 | 2022-07-24 | US | Virginia | Middlesex | 51119 | 2065 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-07-25 04:20:51 | Middlesex, Virginia, US | |
898206 | 898206 | 2022-07-24 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-25 04:20:51 | Cheyenne, Nebraska, US | |
94519 | 94519 | 2022-07-23 | US | Virginia | Middlesex | 51119 | 2065 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-07-24 04:20:47 | Middlesex, Virginia, US | |
93200 | 93200 | 2022-07-23 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-24 04:20:47 | Cheyenne, Nebraska, US | |
903541 | 903541 | 2022-07-22 | US | Virginia | Middlesex | 51119 | 2065 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-07-23 04:20:53 | Middlesex, Virginia, US | |
902222 | 902222 | 2022-07-22 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-23 04:20:53 | Cheyenne, Nebraska, US | |
672358 | 672358 | 2022-07-21 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-22 04:21:15 | Cheyenne, Nebraska, US | |
670821 | 670821 | 2022-07-21 | US | Arkansas | Prairie | 5117 | 2065 | 43 | 0 | 34.83624419 | -91.55162157 | 2022-07-22 04:21:15 | Prairie, Arkansas, US | |
1610321 | 1610321 | 2022-07-20 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-21 04:21:10 | Cheyenne, Nebraska, US | |
960954 | 960954 | 2022-07-19 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-20 04:20:59 | Cheyenne, Nebraska, US | |
960181 | 960181 | 2022-07-19 | US | Kansas | Ellsworth | 20053 | 2065 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-07-20 04:20:59 | Ellsworth, Kansas, US | |
958706 | 958706 | 2022-07-19 | China | Tianjin | 2065 | 3 | 0 | 39.3054 | 117.323 | 2022-07-20 04:20:59 | Tianjin, China | |||
3212341 | 3212341 | 2022-07-18 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-19 04:20:58 | Cheyenne, Nebraska, US | |
3211568 | 3211568 | 2022-07-18 | US | Kansas | Ellsworth | 20053 | 2065 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-07-19 04:20:58 | Ellsworth, Kansas, US | |
3407516 | 3407516 | 2022-07-17 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-18 04:20:59 | Cheyenne, Nebraska, US | |
3406743 | 3406743 | 2022-07-17 | US | Kansas | Ellsworth | 20053 | 2065 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-07-18 04:20:59 | Ellsworth, Kansas, US | |
2153716 | 2153716 | 2022-07-16 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-17 04:21:15 | Cheyenne, Nebraska, US | |
2152943 | 2152943 | 2022-07-16 | US | Kansas | Ellsworth | 20053 | 2065 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-07-17 04:21:15 | Ellsworth, Kansas, US | |
2420949 | 2420949 | 2022-07-15 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-16 04:21:05 | Cheyenne, Nebraska, US | |
2420176 | 2420176 | 2022-07-15 | US | Kansas | Ellsworth | 20053 | 2065 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-07-16 04:21:05 | Ellsworth, Kansas, US | |
3431024 | 3431024 | 2022-07-14 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-15 04:20:53 | Cheyenne, Nebraska, US | |
3430251 | 3430251 | 2022-07-14 | US | Kansas | Ellsworth | 20053 | 2065 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-07-15 04:20:53 | Ellsworth, Kansas, US | |
3111544 | 3111544 | 2022-07-13 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-14 04:20:57 | Cheyenne, Nebraska, US | |
3110771 | 3110771 | 2022-07-13 | US | Kansas | Ellsworth | 20053 | 2065 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-07-14 04:20:57 | Ellsworth, Kansas, US | |
631967 | 631967 | 2022-07-12 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-13 04:20:58 | Cheyenne, Nebraska, US | |
1213611 | 1213611 | 2022-07-11 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-12 04:20:51 | Cheyenne, Nebraska, US | |
2791093 | 2791093 | 2022-07-10 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-11 04:20:46 | Cheyenne, Nebraska, US | |
144046 | 144046 | 2022-07-09 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-10 04:20:54 | Cheyenne, Nebraska, US | |
1419146 | 1419146 | 2022-07-08 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-09 04:20:59 | Cheyenne, Nebraska, US | |
2743071 | 2743071 | 2022-07-07 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-08 04:20:56 | Cheyenne, Nebraska, US | |
1201866 | 1201866 | 2022-07-06 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-07 04:20:55 | Cheyenne, Nebraska, US | |
3968609 | 3968609 | 2022-07-05 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-06 04:20:58 | Cheyenne, Nebraska, US | |
3080120 | 3080120 | 2022-07-04 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-05 04:20:45 | Cheyenne, Nebraska, US | |
1769402 | 1769402 | 2022-07-03 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-04 04:20:54 | Cheyenne, Nebraska, US | |
3367388 | 3367388 | 2022-07-02 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-03 04:20:59 | Cheyenne, Nebraska, US | |
595717 | 595717 | 2022-07-01 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-02 04:21:16 | Cheyenne, Nebraska, US | |
3942118 | 3942118 | 2022-06-30 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-07-01 04:21:10 | Cheyenne, Nebraska, US | |
2492076 | 2492076 | 2022-06-29 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-06-30 04:21:01 | Cheyenne, Nebraska, US | |
2241458 | 2241458 | 2022-06-28 | US | Nebraska | Cheyenne | 31033 | 2065 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-06-29 04:20:59 | Cheyenne, Nebraska, US | |
2149453 | 2149453 | 2022-06-27 | US | Mississippi | Humphreys | 28053 | 2065 | 46 | 0 | 33.12825718 | -90.52252707 | 2022-06-28 04:20:58 | Humphreys, Mississippi, US | |
477254 | 477254 | 2022-06-26 | US | Mississippi | Humphreys | 28053 | 2065 | 46 | 0 | 33.12825718 | -90.52252707 | 2022-06-27 04:21:00 | Humphreys, Mississippi, US | |
940629 | 940629 | 2022-06-25 | US | Mississippi | Humphreys | 28053 | 2065 | 46 | 0 | 33.12825718 | -90.52252707 | 2022-06-26 04:21:02 | Humphreys, Mississippi, US | |
3348449 | 3348449 | 2022-06-24 | US | Mississippi | Humphreys | 28053 | 2065 | 46 | 0 | 33.12825718 | -90.52252707 | 2022-06-25 04:20:57 | Humphreys, Mississippi, US | |
1650190 | 1650190 | 2022-06-23 | US | Mississippi | Humphreys | 28053 | 2065 | 46 | 0 | 33.12825718 | -90.52252707 | 2022-06-24 04:20:58 | Humphreys, Mississippi, US | |
2189425 | 2189425 | 2022-06-22 | US | Mississippi | Humphreys | 28053 | 2065 | 46 | 0 | 33.12825718 | -90.52252707 | 2022-06-23 04:20:55 | Humphreys, Mississippi, US | |
167856 | 167856 | 2022-06-21 | US | Mississippi | Humphreys | 28053 | 2065 | 46 | 0 | 33.12825718 | -90.52252707 | 2022-06-22 04:20:54 | Humphreys, Mississippi, US | |
949722 | 949722 | 2022-06-14 | US | South Dakota | Grant | 46051 | 2065 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-15 04:20:54 | Grant, South Dakota, US | |
2982206 | 2982206 | 2022-06-13 | US | Tennessee | Hancock | 47067 | 2065 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-14 04:20:52 | Hancock, Tennessee, US | |
2982130 | 2982130 | 2022-06-13 | US | South Dakota | Grant | 46051 | 2065 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-14 04:20:52 | Grant, South Dakota, US | |
2238698 | 2238698 | 2022-06-12 | US | Virginia | Buena Vista | 51530 | 2065 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-06-13 04:21:14 | Buena Vista, Virginia, US | |
2238256 | 2238256 | 2022-06-12 | US | South Dakota | Grant | 46051 | 2065 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-13 04:21:14 | Grant, South Dakota, US | |
3144896 | 3144896 | 2022-06-11 | US | Virginia | Buena Vista | 51530 | 2065 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-06-12 04:20:53 | Buena Vista, Virginia, US | |
3144454 | 3144454 | 2022-06-11 | US | South Dakota | Grant | 46051 | 2065 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-12 04:20:53 | Grant, South Dakota, US | |
1947812 | 1947812 | 2022-06-10 | US | Virginia | Buena Vista | 51530 | 2065 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-06-11 04:21:01 | Buena Vista, Virginia, US | |
1947370 | 1947370 | 2022-06-10 | US | South Dakota | Grant | 46051 | 2065 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-11 04:21:01 | Grant, South Dakota, US | |
3160509 | 3160509 | 2022-06-09 | US | South Dakota | Grant | 46051 | 2065 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-10 04:20:55 | Grant, South Dakota, US | |
1423976 | 1423976 | 2022-06-08 | US | South Dakota | Grant | 46051 | 2065 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-09 04:20:54 | Grant, South Dakota, US | |
1421460 | 1421460 | 2022-06-08 | US | Alabama | Choctaw | 1023 | 2065 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-06-09 04:20:54 | Choctaw, Alabama, US | |
1852206 | 1852206 | 2022-05-26 | US | New Mexico | Sierra | 35051 | 2065 | 75 | 0 | 33.13028233 | -107.1925893 | 2022-05-27 04:20:56 | Sierra, New Mexico, US | |
1506935 | 1506935 | 2022-05-16 | US | Virginia | Fairfax City | 51600 | 2065 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-05-17 04:20:59 | Fairfax City, 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]);