johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
233 rows where active = 795 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 233 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3669279 | 3669279 | 2021-03-06 | US | Michigan | Missaukee | 26113 | 813 | 18 | 0 | 795 | 44.33772443 | -85.09256478 | 2021-03-07 05:21:54 | Missaukee, Michigan, US |
1617192 | 1617192 | 2021-03-05 | US | Idaho | Valley | 16085 | 800 | 5 | 0 | 795 | 44.76728382 | -115.5676773 | 2021-03-06 04:23:41 | Valley, Idaho, US |
1618139 | 1618139 | 2021-03-05 | US | Missouri | Grundy | 29079 | 829 | 34 | 0 | 795 | 40.11406587 | -93.56509276 | 2021-03-06 04:23:41 | Grundy, Missouri, US |
2209550 | 2209550 | 2021-03-04 | US | Missouri | Grundy | 29079 | 829 | 34 | 0 | 795 | 40.11406587 | -93.56509276 | 2021-03-05 05:26:29 | Grundy, Missouri, US |
1090902 | 1090902 | 2021-03-03 | US | Georgia | Long | 13183 | 807 | 12 | 0 | 795 | 31.75218791 | -81.74952375 | 2021-03-04 05:24:24 | Long, Georgia, US |
1091971 | 1091971 | 2021-03-03 | US | Missouri | Grundy | 29079 | 829 | 34 | 0 | 795 | 40.11406587 | -93.56509276 | 2021-03-04 05:24:24 | Grundy, Missouri, US |
1092632 | 1092632 | 2021-03-03 | US | Oklahoma | Latimer | 40077 | 804 | 9 | 0 | 795 | 34.87844729 | -95.25215049 | 2021-03-04 05:24:24 | Latimer, Oklahoma, US |
1093173 | 1093173 | 2021-03-03 | US | Texas | Hansford | 48195 | 1008 | 21 | 0 | 795 | 36.27743284 | -101.3545796 | 2021-03-04 05:24:24 | Hansford, Texas, US |
3255396 | 3255396 | 2021-03-02 | US | Kansas | Anderson | 20003 | 813 | 18 | 0 | 795 | 38.21413251 | -95.29272815 | 2021-03-03 05:23:28 | Anderson, Kansas, US |
3256043 | 3256043 | 2021-03-02 | US | Missouri | Grundy | 29079 | 829 | 34 | 0 | 795 | 40.11406587 | -93.56509276 | 2021-03-03 05:23:28 | Grundy, Missouri, US |
999688 | 999688 | 2021-03-01 | US | Kansas | Anderson | 20003 | 813 | 18 | 0 | 795 | 38.21413251 | -95.29272815 | 2021-03-02 05:23:30 | Anderson, Kansas, US |
2185625 | 2185625 | 2021-02-26 | US | Nebraska | Butler | 31023 | 806 | 11 | 0 | 795 | 41.22703692 | -97.13106306 | 2021-02-27 05:22:28 | Butler, Nebraska, US |
473298 | 473298 | 2021-02-19 | US | Missouri | Dallas | 29059 | 817 | 22 | 0 | 795 | 37.6811355 | -93.02127031 | 2021-02-20 05:22:51 | Dallas, Missouri, US |
473439 | 473439 | 2021-02-19 | US | Montana | Valley | 30105 | 806 | 11 | 0 | 795 | 48.36435097 | -106.6669635 | 2021-02-20 05:22:51 | Valley, Montana, US |
474584 | 474584 | 2021-02-19 | US | Texas | Morris | 48343 | 964 | 23 | 0 | 795 | 33.11304005 | -94.73255695 | 2021-02-20 05:22:51 | Morris, Texas, US |
1155007 | 1155007 | 2021-02-18 | US | Missouri | Dallas | 29059 | 817 | 22 | 0 | 795 | 37.6811355 | -93.02127031 | 2021-02-19 05:24:16 | Dallas, Missouri, US |
3602927 | 3602927 | 2021-02-17 | US | Missouri | Dallas | 29059 | 817 | 22 | 0 | 795 | 37.6811355 | -93.02127031 | 2021-02-18 05:22:58 | Dallas, Missouri, US |
3052062 | 3052062 | 2021-02-16 | US | Missouri | Dallas | 29059 | 817 | 22 | 0 | 795 | 37.6811355 | -93.02127031 | 2021-02-17 05:23:10 | Dallas, Missouri, US |
1341016 | 1341016 | 2021-02-15 | US | Puerto Rico | Juana Diaz | 72075 | 795 | 0 | 0 | 795 | 18.050764 | -66.49458100000001 | 2021-02-16 05:24:38 | Juana Diaz, Puerto Rico, US |
2638528 | 2638528 | 2021-02-11 | US | Georgia | Hancock | 13141 | 850 | 55 | 0 | 795 | 33.2721566 | -82.99766919 | 2021-02-12 05:23:29 | Hancock, Georgia, US |
1528801 | 1528801 | 2021-02-09 | US | Hawaii | Out of HI | 80015 | 798 | 3 | 0 | 795 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Out of HI, Hawaii, US |
1530609 | 1530609 | 2021-02-09 | US | Puerto Rico | Barranquitas | 72019 | 795 | 0 | 0 | 795 | 18.201592 | -66.30963 | 2021-02-10 05:22:41 | Barranquitas, Puerto Rico, US |
975287 | 975287 | 2021-02-06 | US | Alabama | Greene | 1063 | 824 | 29 | 0 | 795 | 32.85504247 | -87.95684022 | 2021-02-07 05:23:00 | Greene, Alabama, US |
976807 | 976807 | 2021-02-06 | US | Missouri | Dent | 29065 | 809 | 14 | 0 | 795 | 37.60663134 | -91.50790473 | 2021-02-07 05:23:00 | Dent, Missouri, US |
1590065 | 1590065 | 2021-02-05 | US | Missouri | Dent | 29065 | 809 | 14 | 0 | 795 | 37.60663134 | -91.50790473 | 2021-02-06 05:23:55 | Dent, Missouri, US |
791900 | 791900 | 2021-02-04 | US | Louisiana | Red River | 22081 | 829 | 34 | 0 | 795 | 32.09530039 | -93.34213308 | 2021-02-05 05:22:38 | Red River, Louisiana, US |
792272 | 792272 | 2021-02-04 | US | Missouri | Dent | 29065 | 809 | 14 | 0 | 795 | 37.60663134 | -91.50790473 | 2021-02-05 05:22:38 | Dent, Missouri, US |
793945 | 793945 | 2021-02-04 | US | Wisconsin | Pepin | 55091 | 802 | 7 | 0 | 795 | 44.58307413 | -91.99949611 | 2021-02-05 05:22:38 | Pepin, Wisconsin, US |
343837 | 343837 | 2021-02-03 | US | Wisconsin | Pepin | 55091 | 802 | 7 | 0 | 795 | 44.58307413 | -91.99949611 | 2021-02-04 05:22:26 | Pepin, Wisconsin, US |
1899238 | 1899238 | 2021-01-29 | US | Nebraska | Knox | 31107 | 804 | 9 | 0 | 795 | 42.63758421 | -97.89178836 | 2021-01-30 05:22:49 | Knox, Nebraska, US |
2484054 | 2484054 | 2021-01-28 | US | Nebraska | Knox | 31107 | 804 | 9 | 0 | 795 | 42.63758421 | -97.89178836 | 2021-01-29 05:22:23 | Knox, Nebraska, US |
3154509 | 3154509 | 2021-01-27 | US | Hawaii | Out of HI | 80015 | 798 | 3 | 0 | 795 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Out of HI, Hawaii, US |
13130 | 13130 | 2021-01-26 | US | Georgia | Evans | 13109 | 811 | 16 | 0 | 795 | 32.15328841 | -81.8870105 | 2021-01-27 05:23:41 | Evans, Georgia, US |
13768 | 13768 | 2021-01-26 | US | Kentucky | Magoffin | 21153 | 796 | 1 | 0 | 795 | 37.70820545 | -83.0657714 | 2021-01-27 05:23:41 | Magoffin, Kentucky, US |
14424 | 14424 | 2021-01-26 | US | Nebraska | Knox | 31107 | 803 | 8 | 0 | 795 | 42.63758421 | -97.89178836 | 2021-01-27 05:23:41 | Knox, Nebraska, US |
2570983 | 2570983 | 2021-01-25 | US | Virginia | Dickenson | 51051 | 808 | 13 | 0 | 795 | 37.12560977 | -82.35124171 | 2021-01-26 05:22:02 | Dickenson, Virginia, US |
2469081 | 2469081 | 2021-01-22 | US | North Carolina | Alleghany | 37005 | 798 | 3 | 0 | 795 | 36.49360862 | -81.12857041 | 2021-01-23 05:22:03 | Alleghany, North Carolina, US |
436138 | 436138 | 2021-01-21 | US | Georgia | Dooly | 13093 | 825 | 30 | 0 | 795 | 32.15630737 | -83.79746561 | 2021-01-22 05:22:10 | Dooly, Georgia, US |
436571 | 436571 | 2021-01-21 | US | Iowa | Monroe | 19135 | 814 | 19 | 0 | 795 | 41.02988815 | -92.8690667 | 2021-01-22 05:22:10 | Monroe, Iowa, US |
238762 | 238762 | 2021-01-18 | US | Louisiana | St. Helena | 22091 | 801 | 6 | 0 | 795 | 30.82210324 | -90.71013176 | 2021-01-19 05:22:15 | St. Helena, Louisiana, US |
239018 | 239018 | 2021-01-18 | US | Mississippi | Benton | 28009 | 818 | 23 | 0 | 795 | 34.81681228 | -89.18945516 | 2021-01-19 05:22:15 | Benton, Mississippi, US |
3102319 | 3102319 | 2021-01-16 | US | Georgia | Turner | 13287 | 821 | 26 | 0 | 795 | 31.71612656 | -83.62069378 | 2021-01-17 05:22:17 | Turner, Georgia, US |
3102893 | 3102893 | 2021-01-16 | US | Kentucky | Powell | 21197 | 795 | 0 | 0 | 795 | 37.83218794 | -83.82553961 | 2021-01-17 05:22:17 | Powell, Kentucky, US |
3882136 | 3882136 | 2021-01-14 | US | Oklahoma | Major | 40093 | 799 | 4 | 0 | 795 | 36.31149996 | -98.53467076 | 2021-01-15 05:22:24 | Major, Oklahoma, US |
775563 | 775563 | 2021-01-12 | US | Iowa | Montgomery | 19137 | 817 | 22 | 0 | 795 | 41.03018714 | -95.15642896 | 2021-01-13 05:22:15 | Montgomery, Iowa, US |
2626886 | 2626886 | 2021-01-10 | US | Illinois | Menard | 17129 | 801 | 6 | 0 | 795 | 40.02742725 | -89.80246001 | 2021-01-11 05:21:50 | Menard, Illinois, US |
2627676 | 2627676 | 2021-01-10 | US | Mississippi | Jefferson Davis | 28065 | 819 | 24 | 0 | 795 | 31.56884708 | -89.82670990000003 | 2021-01-11 05:21:50 | Jefferson Davis, Mississippi, US |
2628593 | 2628593 | 2021-01-10 | US | Puerto Rico | Cidra | 72041 | 795 | 0 | 0 | 795 | 18.173559 | -66.161179 | 2021-01-11 05:21:50 | Cidra, Puerto Rico, US |
3903103 | 3903103 | 2021-01-09 | US | Texas | Leon | 48289 | 1178 | 26 | 0 | 795 | 31.29872538 | -95.9936328 | 2021-01-10 05:22:12 | Leon, Texas, US |
3903451 | 3903451 | 2021-01-09 | US | West Virginia | Nicholas | 54067 | 804 | 9 | 0 | 795 | 38.29617706 | -80.79759588 | 2021-01-10 05:22:12 | Nicholas, West Virginia, US |
2542352 | 2542352 | 2021-01-07 | US | Idaho | Teton | 16081 | 798 | 3 | 0 | 795 | 43.75303583 | -111.2056773 | 2021-01-08 05:22:42 | Teton, Idaho, US |
2543267 | 2543267 | 2021-01-07 | US | Missouri | Barton | 29011 | 803 | 8 | 0 | 795 | 37.50207671 | -94.34757022 | 2021-01-08 05:22:42 | Barton, Missouri, US |
2866103 | 2866103 | 2021-01-06 | US | Kentucky | Fleming | 21069 | 797 | 2 | 0 | 795 | 38.36758311 | -83.69657514 | 2021-01-07 05:22:03 | Fleming, Kentucky, US |
2866475 | 2866475 | 2021-01-06 | US | Minnesota | Swift | 27151 | 812 | 17 | 0 | 795 | 45.2829032 | -95.68264092 | 2021-01-07 05:22:03 | Swift, Minnesota, US |
2867927 | 2867927 | 2021-01-06 | US | Texas | Somervell | 48425 | 812 | 8 | 0 | 795 | 32.22236802 | -97.77403489 | 2021-01-07 05:22:03 | Somervell, Texas, US |
1064592 | 1064592 | 2021-01-04 | US | Puerto Rico | Las Piedras | 72085 | 795 | 0 | 0 | 795 | 18.187527 | -65.86946800000001 | 2021-01-05 05:21:49 | Las Piedras, Puerto Rico, US |
1064707 | 1064707 | 2021-01-04 | US | South Dakota | Grant | 46051 | 830 | 35 | 0 | 795 | 45.1723937 | -96.77002276 | 2021-01-05 05:21:49 | Grant, South Dakota, US |
2230219 | 2230219 | 2021-01-02 | US | Pennsylvania | Wyoming | 42131 | 824 | 29 | 0 | 795 | 41.51955538 | -76.01074915 | 2021-01-03 05:22:52 | Wyoming, Pennsylvania, US |
2230316 | 2230316 | 2021-01-02 | US | South Carolina | Calhoun | 45017 | 815 | 20 | 0 | 795 | 33.66926881 | -80.77722168 | 2021-01-03 05:22:52 | Calhoun, South Carolina, US |
3780504 | 3780504 | 2020-12-27 | US | Oregon | Columbia | 41009 | 808 | 13 | 0 | 795 | 45.94464254 | -123.0890898 | 2020-12-28 05:22:06 | Columbia, Oregon, US |
3770993 | 3770993 | 2020-12-22 | US | Indiana | Pike | 18125 | 821 | 26 | 0 | 795 | 38.40112197 | -87.23574907 | 2020-12-23 05:22:03 | Pike, Indiana, US |
1901914 | 1901914 | 2020-12-18 | US | Georgia | Bleckley | 13023 | 828 | 33 | 0 | 795 | 32.43829035 | -83.33035166 | 2020-12-19 05:27:52 | Bleckley, Georgia, US |
1037747 | 1037747 | 2020-12-15 | US | Virginia | Nottoway | 51135 | 819 | 24 | 0 | 795 | 37.1435975 | -78.05065922 | 2020-12-16 05:28:04 | Nottoway, Virginia, US |
1754728 | 1754728 | 2020-12-14 | US | West Virginia | Boone | 54005 | 813 | 18 | 0 | 795 | 38.01974191 | -81.69888019 | 2020-12-15 05:26:38 | Boone, West Virginia, US |
848931 | 848931 | 2020-12-12 | US | Virginia | Martinsville | 51690 | 822 | 27 | 0 | 795 | 36.68212094 | -79.86352771 | 2020-12-13 05:27:20 | Martinsville, Virginia, US |
861422 | 861422 | 2020-12-11 | US | Georgia | Berrien | 13019 | 824 | 29 | 0 | 795 | 31.27590016 | -83.22529920000002 | 2020-12-12 05:26:19 | Berrien, Georgia, US |
861602 | 861602 | 2020-12-11 | US | Idaho | Franklin | 16041 | 802 | 7 | 0 | 795 | 42.18332217 | -111.8149666 | 2020-12-12 05:26:19 | Franklin, Idaho, US |
1601685 | 1601685 | 2020-12-10 | US | Kentucky | Union | 21225 | 802 | 7 | 0 | 795 | 37.66166713 | -87.94300009 | 2020-12-11 05:26:59 | Union, Kentucky, US |
1602338 | 1602338 | 2020-12-10 | US | Nebraska | Wayne | 31179 | 800 | 5 | 0 | 795 | 42.20934475 | -97.11926964 | 2020-12-11 05:26:59 | Wayne, Nebraska, US |
2976154 | 2976154 | 2020-12-09 | US | Idaho | Fremont | 16043 | 806 | 11 | 0 | 795 | 44.22800938 | -111.4809943 | 2020-12-10 05:26:19 | Fremont, Idaho, US |
2976237 | 2976237 | 2020-12-09 | US | Illinois | Mason | 17125 | 824 | 29 | 0 | 795 | 40.23917274 | -89.91824452 | 2020-12-10 05:26:19 | Mason, Illinois, US |
2348609 | 2348609 | 2020-12-07 | US | Iowa | Guthrie | 19077 | 810 | 15 | 0 | 795 | 41.68378965 | -94.50111014 | 2020-12-08 05:27:42 | Guthrie, Iowa, US |
1006981 | 1006981 | 2020-12-06 | US | Florida | Gilchrist | 12041 | 815 | 20 | 0 | 795 | 29.72856978 | -82.79880657 | 2020-12-07 05:26:14 | Gilchrist, Florida, US |
1009009 | 1009009 | 2020-12-06 | US | Puerto Rico | Canovanas | 72029 | 795 | 0 | 0 | 795 | 18.328802 | -65.887612 | 2020-12-07 05:26:14 | Canovanas, Puerto Rico, US |
1632905 | 1632905 | 2020-12-05 | US | Colorado | Delta | 8029 | 1055 | 19 | 0 | 795 | 38.86246243 | -107.8631342 | 2020-12-06 05:26:18 | Delta, Colorado, US |
1633252 | 1633252 | 2020-12-05 | US | Idaho | Washington | 16087 | 807 | 12 | 0 | 795 | 44.45275475 | -116.7847688 | 2020-12-06 05:26:18 | Washington, Idaho, US |
1633841 | 1633841 | 2020-12-05 | US | Louisiana | West Feliciana | 22125 | 820 | 25 | 0 | 795 | 30.87882871 | -91.4148538 | 2020-12-06 05:26:18 | West Feliciana, Louisiana, US |
1634217 | 1634217 | 2020-12-05 | US | Missouri | Livingston | 29117 | 811 | 16 | 0 | 795 | 39.78110272 | -93.54645978 | 2020-12-06 05:26:18 | Livingston, Missouri, US |
3860182 | 3860182 | 2020-12-04 | US | Alabama | Cleburne | 1029 | 809 | 14 | 0 | 795 | 33.67679204 | -85.52005899 | 2020-12-05 05:27:36 | Cleburne, Alabama, US |
3861369 | 3861369 | 2020-12-04 | US | Louisiana | West Feliciana | 22125 | 820 | 25 | 0 | 795 | 30.87882871 | -91.4148538 | 2020-12-05 05:27:36 | West Feliciana, Louisiana, US |
3863425 | 3863425 | 2020-12-04 | US | Wyoming | Goshen | 56015 | 804 | 9 | 0 | 795 | 42.08798185 | -104.3534743 | 2020-12-05 05:27:36 | Goshen, Wyoming, US |
2538356 | 2538356 | 2020-12-01 | US | Illinois | Clark | 17023 | 815 | 20 | 0 | 795 | 39.33425789 | -87.78705622 | 2020-12-02 05:27:41 | Clark, Illinois, US |
1585014 | 1585014 | 2020-11-30 | US | Georgia | Pike | 13231 | 812 | 17 | 0 | 795 | 33.09310242 | -84.38790389 | 2020-12-01 05:26:18 | Pike, Georgia, US |
1585325 | 1585325 | 2020-11-30 | US | Iowa | Cass | 19029 | 818 | 23 | 0 | 795 | 41.33149454 | -94.92792482 | 2020-12-01 05:26:18 | Cass, Iowa, US |
3568062 | 3568062 | 2020-11-29 | US | Louisiana | Grant | 22043 | 827 | 32 | 0 | 795 | 31.59882456 | -92.56124347 | 2020-11-30 05:26:13 | Grant, Louisiana, US |
3568331 | 3568331 | 2020-11-29 | US | Minnesota | Wadena | 27159 | 801 | 6 | 0 | 795 | 46.58589171 | -94.96968506 | 2020-11-30 05:26:13 | Wadena, Minnesota, US |
2936212 | 2936212 | 2020-11-28 | US | Illinois | Greene | 17061 | 821 | 26 | 0 | 795 | 39.35907414 | -90.388865 | 2020-11-29 05:25:55 | Greene, Illinois, US |
2937490 | 2937490 | 2020-11-28 | US | New York | St. Lawrence | 36089 | 805 | 10 | 0 | 795 | 44.4976179 | -75.06550039 | 2020-11-29 05:25:55 | St. Lawrence, New York, US |
393785 | 393785 | 2020-11-27 | US | Maine | Penobscot | 23019 | 802 | 7 | 0 | 795 | 45.40194593 | -68.65020455 | 2020-11-28 05:25:50 | Penobscot, Maine, US |
925232 | 925232 | 2020-11-26 | US | Maine | Penobscot | 23019 | 802 | 7 | 0 | 795 | 45.40194593 | -68.65020455 | 2020-11-27 05:26:53 | Penobscot, Maine, US |
925484 | 925484 | 2020-11-26 | US | Mississippi | Jasper | 28061 | 817 | 22 | 0 | 795 | 32.01922104 | -89.11786866 | 2020-11-27 05:26:53 | Jasper, Mississippi, US |
926555 | 926555 | 2020-11-26 | US | South Dakota | Lake | 46079 | 805 | 10 | 0 | 795 | 44.02193107 | -97.12926365 | 2020-11-27 05:26:53 | Lake, South Dakota, US |
1975460 | 1975460 | 2020-11-25 | US | South Dakota | Lake | 46079 | 805 | 10 | 0 | 795 | 44.02193107 | -97.12926365 | 2020-11-26 05:27:44 | Lake, South Dakota, US |
1352606 | 1352606 | 2020-11-24 | US | North Carolina | Caswell | 37033 | 801 | 6 | 0 | 795 | 36.39312665 | -79.33353281 | 2020-11-25 05:27:20 | Caswell, North Carolina, US |
3192541 | 3192541 | 2020-11-22 | US | Oklahoma | Kingfisher | 40073 | 801 | 6 | 0 | 795 | 35.94530008 | -97.94193268 | 2020-11-23 05:25:26 | Kingfisher, Oklahoma, US |
3837612 | 3837612 | 2020-11-21 | US | Indiana | Sullivan | 18153 | 812 | 17 | 0 | 795 | 39.08952258 | -87.41414469 | 2020-11-22 05:25:45 | Sullivan, Indiana, US |
822170 | 822170 | 2020-11-19 | US | Colorado | Crowley | 8025 | 1028 | 6 | 0 | 795 | 38.32608609 | -103.7844965 | 2020-11-20 05:26:28 | Crowley, Colorado, US |
822342 | 822342 | 2020-11-19 | US | Georgia | Cook | 13075 | 812 | 17 | 0 | 795 | 31.16068491 | -83.42947229 | 2020-11-20 05:26:28 | Cook, Georgia, US |
822997 | 822997 | 2020-11-19 | US | Kentucky | Marion | 21155 | 807 | 12 | 0 | 795 | 37.55218078 | -85.26898542 | 2020-11-20 05:26:28 | Marion, Kentucky, US |
125516 | 125516 | 2020-11-18 | US | South Carolina | Hampton | 45049 | 827 | 32 | 0 | 795 | 32.77419582 | -81.13845571 | 2020-11-19 05:25:23 | Hampton, South Carolina, 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]);