johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
254 rows where active = 943 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683635 | 3683635 | 2021-08-02 | Russia | Adygea Republic | 16405 | 288 | 15174 | 943 | 44.6939006 | 40.1520421 | 2021-08-03 04:21:39 | Adygea Republic, Russia | ||
3137547 | 3137547 | 2021-07-23 | Italy | Umbria | 57499 | 1424 | 55132 | 943 | 43.10675841 | 12.38824698 | 2021-07-24 00:21:36 | Umbria, Italy | ||
778278 | 778278 | 2021-07-08 | Germany | Rheinland-Pfalz | 155483 | 3894 | 150700 | 943 | 50.1183 | 7.309 | 2021-07-09 04:21:21 | Rheinland-Pfalz, Germany | ||
1165085 | 1165085 | 2021-07-04 | Germany | Rheinland-Pfalz | 155262 | 3892 | 150500 | 943 | 50.1183 | 7.309 | 2021-07-05 04:21:28 | Rheinland-Pfalz, Germany | ||
3125752 | 3125752 | 2021-06-28 | Russia | Sakhalin Oblast | 24405 | 62 | 23400 | 943 | 49.7219665 | 143.448533 | 2021-06-29 04:21:28 | Sakhalin Oblast, Russia | ||
2590261 | 2590261 | 2021-06-27 | Russia | Ulyanovsk Oblast | 58453 | 1662 | 55848 | 943 | 54.1463177 | 47.2324921 | 2021-06-28 04:21:29 | Ulyanovsk Oblast, Russia | ||
562876 | 562876 | 2021-06-22 | Germany | Berlin | 179912 | 3545 | 175500 | 943 | 52.52 | 13.405 | 2021-06-23 04:21:46 | Berlin, Germany | ||
1564201 | 1564201 | 2021-06-14 | Moldova | 255830 | 6154 | 248733 | 943 | 47.4116 | 28.3699 | 2021-06-15 04:22:22 | Moldova | |||
1736741 | 1736741 | 2021-06-12 | Russia | Omsk Oblast | 48324 | 1452 | 45929 | 943 | 56.09352629999999 | 73.5099936 | 2021-06-13 04:22:44 | Omsk Oblast, Russia | ||
1771114 | 1771114 | 2021-05-23 | Canada | Nova Scotia | 5286 | 79 | 4264 | 943 | 44.682 | -63.7443 | 2021-05-24 04:20:53 | Nova Scotia, Canada | ||
2760690 | 2760690 | 2021-05-03 | Canada | Nova Scotia | 2854 | 67 | 1844 | 943 | 44.682 | -63.7443 | 2021-05-04 04:20:34 | Nova Scotia, Canada | ||
1636100 | 1636100 | 2021-04-29 | Chile | Atacama | 17983 | 201 | 16839 | 943 | -27.5661 | -70.0503 | 2021-04-30 04:21:03 | Atacama, Chile | ||
36441 | 36441 | 2021-04-12 | Japan | Hokkaido | 21838 | 780 | 20115 | 943 | 43.385711 | 142.552318 | 2021-04-13 04:20:37 | Hokkaido, Japan | ||
3643750 | 3643750 | 2021-03-30 | Russia | Irkutsk Oblast | 61413 | 2002 | 58468 | 943 | 56.6370122 | 104.719221 | 2021-03-31 04:26:25 | Irkutsk Oblast, Russia | ||
3670483 | 3670483 | 2021-03-06 | US | South Dakota | Grant | 46051 | 981 | 38 | 0 | 943 | 45.1723937 | -96.77002276 | 2021-03-07 05:21:54 | Grant, South Dakota, US |
3668974 | 3668974 | 2021-03-06 | US | Kansas | Wilson | 20205 | 956 | 13 | 0 | 943 | 37.55937174 | -95.74323255 | 2021-03-07 05:21:54 | Wilson, Kansas, US |
3668884 | 3668884 | 2021-03-06 | US | Kansas | Cloud | 20029 | 969 | 26 | 0 | 943 | 39.48028352 | -97.64925343 | 2021-03-07 05:21:54 | Cloud, Kansas, US |
1617505 | 1617505 | 2021-03-05 | US | Kansas | Cloud | 20029 | 969 | 26 | 0 | 943 | 39.48028352 | -97.64925343 | 2021-03-06 04:23:41 | Cloud, Kansas, US |
2211145 | 2211145 | 2021-03-04 | US | West Virginia | Monroe | 54063 | 955 | 12 | 0 | 943 | 37.56274716 | -80.54577965 | 2021-03-05 05:26:29 | Monroe, West Virginia, US |
183902 | 183902 | 2021-02-21 | US | Missouri | Barton | 29011 | 955 | 12 | 0 | 943 | 37.50207671 | -94.34757022 | 2021-02-22 05:24:21 | Barton, Missouri, US |
744176 | 744176 | 2021-02-20 | US | Missouri | Barton | 29011 | 955 | 12 | 0 | 943 | 37.50207671 | -94.34757022 | 2021-02-21 05:24:33 | Barton, Missouri, US |
3052639 | 3052639 | 2021-02-16 | US | Ohio | Harrison | 39067 | 978 | 35 | 0 | 943 | 40.29380509 | -81.09068544 | 2021-02-17 05:23:10 | Harrison, Ohio, US |
3052297 | 3052297 | 2021-02-16 | US | Nebraska | Wayne | 31179 | 950 | 7 | 0 | 943 | 42.20934475 | -97.11926964 | 2021-02-17 05:23:10 | Wayne, Nebraska, US |
3050914 | 3050914 | 2021-02-16 | US | Georgia | Atkinson | 13003 | 959 | 16 | 0 | 943 | 31.29633502 | -82.87545866 | 2021-02-17 05:23:10 | Atkinson, Georgia, US |
1340059 | 1340059 | 2021-02-15 | US | Mississippi | Claiborne | 28021 | 972 | 29 | 0 | 943 | 31.97061673 | -90.90702196 | 2021-02-16 05:24:38 | Claiborne, Mississippi, US |
2285210 | 2285210 | 2021-02-14 | US | Mississippi | Claiborne | 28021 | 972 | 29 | 0 | 943 | 31.97061673 | -90.90702196 | 2021-02-15 05:24:49 | Claiborne, Mississippi, US |
2680409 | 2680409 | 2021-02-13 | US | Oklahoma | Pushmataha | 40127 | 956 | 13 | 0 | 943 | 34.41635232 | -95.37603505 | 2021-02-14 05:23:43 | Pushmataha, Oklahoma, US |
3541265 | 3541265 | 2021-02-12 | US | Mississippi | Jefferson Davis | 28065 | 974 | 31 | 0 | 943 | 31.56884708 | -89.82670990000003 | 2021-02-13 05:22:12 | Jefferson Davis, Mississippi, US |
3540873 | 3540873 | 2021-02-12 | US | Kentucky | Knott | 21119 | 958 | 15 | 0 | 943 | 37.35388197 | -82.94981134 | 2021-02-13 05:22:12 | Knott, Kentucky, US |
3981281 | 3981281 | 2021-02-10 | US | Puerto Rico | Aguada | 72003 | 943 | 0 | 0 | 943 | 18.360255 | -67.17513100000001 | 2021-02-11 05:23:55 | Aguada, Puerto Rico, US |
3978367 | 3978367 | 2021-02-10 | Chile | Los Rios | 16260 | 182 | 15135 | 943 | -40.231 | -72.3311 | 2021-02-11 05:23:55 | Los Rios, Chile | ||
1530601 | 1530601 | 2021-02-09 | US | Puerto Rico | Aguada | 72003 | 943 | 0 | 0 | 943 | 18.360255 | -67.17513100000001 | 2021-02-10 05:22:41 | Aguada, Puerto Rico, US |
614909 | 614909 | 2021-02-08 | US | Iowa | Palo Alto | 19147 | 961 | 18 | 0 | 943 | 43.08193849 | -94.67824621 | 2021-02-09 05:23:30 | Palo Alto, Iowa, US |
1672640 | 1672640 | 2021-02-07 | Russia | Altai Republic | 15667 | 135 | 14589 | 943 | 50.7114101 | 86.8572186 | 2021-02-08 05:22:39 | Altai Republic, Russia | ||
977693 | 977693 | 2021-02-06 | US | Puerto Rico | Unassigned | 72999 | 2815 | 1872 | 0 | 943 | 18.459681 | -67.336525 | 2021-02-07 05:23:00 | Unassigned, Puerto Rico, US |
1590951 | 1590951 | 2021-02-05 | US | Puerto Rico | Unassigned | 72999 | 2810 | 1867 | 0 | 943 | 18.459681 | -67.336525 | 2021-02-06 05:23:55 | Unassigned, Puerto Rico, US |
792656 | 792656 | 2021-02-04 | US | New York | Yates | 36123 | 968 | 25 | 0 | 943 | 42.63505484 | -77.10369919 | 2021-02-05 05:22:38 | Yates, New York, US |
1686496 | 1686496 | 2021-02-02 | US | Montana | Jefferson | 30043 | 950 | 7 | 0 | 943 | 46.14907081 | -112.094396 | 2021-02-03 05:22:52 | Jefferson, Montana, US |
1679194 | 1679194 | 2021-02-01 | US | Puerto Rico | Cidra | 72041 | 943 | 0 | 0 | 943 | 18.173559 | -66.161179 | 2021-02-02 05:22:49 | Cidra, Puerto Rico, US |
3156577 | 3156577 | 2021-01-27 | US | Tennessee | Perry | 47135 | 981 | 25 | 0 | 943 | 35.63708728 | -87.86139634 | 2021-01-28 05:22:24 | Perry, Tennessee, US |
3156522 | 3156522 | 2021-01-27 | US | Tennessee | Clay | 47027 | 1027 | 26 | 0 | 943 | 36.55151008 | -85.53930419 | 2021-01-28 05:22:24 | Clay, Tennessee, US |
15876 | 15876 | 2021-01-26 | US | Wisconsin | Forest | 55041 | 968 | 25 | 0 | 943 | 45.66678019 | -88.77084892 | 2021-01-27 05:23:41 | Forest, Wisconsin, US |
15257 | 15257 | 2021-01-26 | US | Tennessee | Clay | 47027 | 1026 | 26 | 0 | 943 | 36.55151008 | -85.53930419 | 2021-01-27 05:23:41 | Clay, Tennessee, US |
13159 | 13159 | 2021-01-26 | US | Georgia | Johnson | 13167 | 980 | 37 | 0 | 943 | 32.70211082 | -82.66166794 | 2021-01-27 05:23:41 | Johnson, Georgia, US |
2568587 | 2568587 | 2021-01-25 | US | Idaho | Clearwater | 16035 | 954 | 11 | 0 | 943 | 46.67459924 | -115.6622393 | 2021-01-26 05:22:02 | Clearwater, Idaho, US |
1760909 | 1760909 | 2021-01-24 | US | Michigan | Charlevoix | 26029 | 955 | 12 | 0 | 943 | 45.37790017 | -85.19614053 | 2021-01-25 05:22:16 | Charlevoix, Michigan, US |
1760664 | 1760664 | 2021-01-24 | US | Kentucky | Breckinridge | 21027 | 948 | 5 | 0 | 943 | 37.77377239 | -86.42885017 | 2021-01-25 05:22:16 | Breckinridge, Kentucky, US |
2428516 | 2428516 | 2021-01-23 | US | Michigan | Charlevoix | 26029 | 955 | 12 | 0 | 943 | 45.37790017 | -85.19614053 | 2021-01-24 05:22:35 | Charlevoix, Michigan, US |
2470482 | 2470482 | 2021-01-22 | Malaysia | Melaka | 2553 | 7 | 1603 | 943 | 2.1896 | 102.2501 | 2021-01-23 05:22:03 | Melaka, Malaysia | ||
438595 | 438595 | 2021-01-21 | US | Texas | Ward | 48475 | 882 | 13 | 0 | 943 | 31.50999644 | -103.0927909 | 2021-01-22 05:22:10 | Ward, Texas, US |
437951 | 437951 | 2021-01-21 | US | Oklahoma | Washita | 40149 | 948 | 5 | 0 | 943 | 35.29071824 | -98.99180434 | 2021-01-22 05:22:10 | Washita, Oklahoma, US |
435970 | 435970 | 2021-01-21 | US | Colorado | Gunnison | 8051 | 1096 | 6 | 0 | 943 | 38.66611652 | -107.0320729 | 2021-01-22 05:22:10 | Gunnison, Colorado, US |
435711 | 435711 | 2021-01-21 | US | Alabama | Conecuh | 1035 | 963 | 20 | 0 | 943 | 31.43401703 | -86.99320044 | 2021-01-22 05:22:10 | Conecuh, Alabama, US |
1097109 | 1097109 | 2021-01-20 | US | Texas | Brewster | 48043 | 772 | 8 | 0 | 943 | 29.81008251 | -103.2520326 | 2021-01-21 05:22:01 | Brewster, Texas, US |
3505582 | 3505582 | 2021-01-17 | US | New York | Essex | 36031 | 959 | 16 | 0 | 943 | 44.11630765 | -73.77297842 | 2021-01-18 05:22:34 | Essex, New York, US |
3103216 | 3103216 | 2021-01-16 | US | Mississippi | Amite | 28005 | 968 | 25 | 0 | 943 | 31.17467303 | -90.80501621 | 2021-01-17 05:22:17 | Amite, Mississippi, US |
3516818 | 3516818 | 2021-01-15 | US | Kentucky | Larue | 21123 | 949 | 6 | 0 | 943 | 37.54567114 | -85.70138352 | 2021-01-16 05:22:40 | Larue, Kentucky, US |
3882323 | 3882323 | 2021-01-14 | US | Puerto Rico | Manati | 72091 | 943 | 0 | 0 | 943 | 18.420473 | -66.490461 | 2021-01-15 05:22:24 | Manati, Puerto Rico, US |
3880980 | 3880980 | 2021-01-14 | US | Kentucky | Henry | 21103 | 948 | 5 | 0 | 943 | 38.44942688 | -85.11587507 | 2021-01-15 05:22:24 | Henry, Kentucky, US |
3879996 | 3879996 | 2021-01-14 | US | Alaska | Kusilvak | 2158 | 946 | 3 | 0 | 943 | 62.15429159999999 | -163.39678830000003 | 2021-01-15 05:22:24 | Kusilvak, Alaska, US |
3879918 | 3879918 | 2021-01-14 | US | Alabama | Bullock | 1011 | 971 | 28 | 0 | 943 | 32.10030533 | -85.71265535 | 2021-01-15 05:22:24 | Bullock, Alabama, US |
3311282 | 3311282 | 2021-01-13 | US | Texas | Freestone | 48161 | 1200 | 27 | 0 | 943 | 31.70422788 | -96.15072516 | 2021-01-14 05:22:32 | Freestone, Texas, US |
777427 | 777427 | 2021-01-12 | US | Texas | Freestone | 48161 | 1199 | 26 | 0 | 943 | 31.70422788 | -96.15072516 | 2021-01-13 05:22:15 | Freestone, Texas, US |
776064 | 776064 | 2021-01-12 | US | Minnesota | Kanabec | 27065 | 961 | 18 | 0 | 943 | 45.9459309 | -93.29275192 | 2021-01-13 05:22:15 | Kanabec, Minnesota, US |
192401 | 192401 | 2021-01-11 | US | North Carolina | Mitchell | 37121 | 953 | 10 | 0 | 943 | 36.01059309 | -82.1582442 | 2021-01-12 05:22:15 | Mitchell, North Carolina, US |
191785 | 191785 | 2021-01-11 | US | Minnesota | Kanabec | 27065 | 961 | 18 | 0 | 943 | 45.9459309 | -93.29275192 | 2021-01-12 05:22:15 | Kanabec, Minnesota, US |
3901942 | 3901942 | 2021-01-09 | US | Montana | Dawson | 30021 | 970 | 27 | 0 | 943 | 47.26584855 | -104.89444170000002 | 2021-01-10 05:22:12 | Dawson, Montana, US |
2544390 | 2544390 | 2021-01-07 | US | Tennessee | Stewart | 47161 | 981 | 20 | 0 | 943 | 36.50235092 | -87.83920548 | 2021-01-08 05:22:42 | Stewart, Tennessee, US |
2865705 | 2865705 | 2021-01-06 | US | Illinois | Jasper | 17079 | 957 | 14 | 0 | 943 | 39.01054275 | -88.15437049 | 2021-01-07 05:22:03 | Jasper, Illinois, US |
3036008 | 3036008 | 2021-01-05 | US | Minnesota | Faribault | 27043 | 954 | 11 | 0 | 943 | 43.67381499 | -93.94787458 | 2021-01-06 05:22:16 | Faribault, Minnesota, US |
1065166 | 1065166 | 2021-01-04 | US | Virginia | Dinwiddie | 51053 | 959 | 16 | 0 | 943 | 37.07544585 | -77.63451754 | 2021-01-05 05:21:49 | Dinwiddie, Virginia, US |
1063033 | 1063033 | 2021-01-04 | US | Iowa | Guthrie | 19077 | 966 | 23 | 0 | 943 | 41.68378965 | -94.50111014 | 2021-01-05 05:21:49 | Guthrie, Iowa, US |
1062205 | 1062205 | 2021-01-04 | US | Alabama | Crenshaw | 1041 | 979 | 36 | 0 | 943 | 31.72941803 | -86.31593104 | 2021-01-05 05:21:49 | Crenshaw, Alabama, US |
2229011 | 2229011 | 2021-01-02 | US | Louisiana | East Carroll | 22035 | 959 | 16 | 0 | 943 | 32.73926954 | -91.23425694 | 2021-01-03 05:22:52 | East Carroll, Louisiana, US |
2228958 | 2228958 | 2021-01-02 | US | Kentucky | Monroe | 21171 | 969 | 26 | 0 | 943 | 36.71225341 | -85.71596443 | 2021-01-03 05:22:52 | Monroe, Kentucky, US |
1138375 | 1138375 | 2021-01-01 | US | Louisiana | East Carroll | 22035 | 959 | 16 | 0 | 943 | 32.73926954 | -91.23425694 | 2021-01-02 05:22:33 | East Carroll, Louisiana, US |
3696981 | 3696981 | 2020-12-31 | US | Louisiana | East Carroll | 22035 | 959 | 16 | 0 | 943 | 32.73926954 | -91.23425694 | 2021-01-01 05:23:07 | East Carroll, Louisiana, US |
1010158 | 1010158 | 2020-12-30 | Colombia | Meta | 33611 | 732 | 31936 | 943 | 3.272 | -73.0877 | 2020-12-31 05:22:49 | Meta, Colombia | ||
768300 | 768300 | 2020-12-29 | US | Montana | Custer | 30017 | 952 | 9 | 0 | 943 | 46.25319932 | -105.57375259999998 | 2020-12-30 05:22:34 | Custer, Montana, US |
768285 | 768285 | 2020-12-29 | US | Missouri | Vernon | 29217 | 960 | 17 | 0 | 943 | 37.8457799 | -94.34127305 | 2020-12-30 05:22:34 | Vernon, Missouri, US |
768112 | 768112 | 2020-12-29 | US | Mississippi | Greene | 28041 | 968 | 25 | 0 | 943 | 31.21444233 | -88.63922281 | 2020-12-30 05:22:34 | Greene, Mississippi, US |
3692676 | 3692676 | 2020-12-24 | US | Iowa | Jefferson | 19101 | 963 | 20 | 0 | 943 | 41.03192394 | -91.94849466 | 2020-12-25 05:22:48 | Jefferson, Iowa, US |
3771791 | 3771791 | 2020-12-22 | US | Missouri | Livingston | 29117 | 963 | 20 | 0 | 943 | 39.78110272 | -93.54645978 | 2020-12-23 05:22:03 | Livingston, Missouri, US |
3771561 | 3771561 | 2020-12-22 | US | Minnesota | Aitkin | 27001 | 975 | 32 | 0 | 943 | 46.60962049 | -93.4116826 | 2020-12-23 05:22:03 | Aitkin, Minnesota, US |
930030 | 930030 | 2020-12-21 | US | North Carolina | Northampton | 37131 | 970 | 27 | 0 | 943 | 36.41736238 | -77.39769443 | 2020-12-22 05:22:33 | Northampton, North Carolina, US |
929929 | 929929 | 2020-12-21 | US | New York | Montgomery | 36057 | 973 | 30 | 0 | 943 | 42.90123494 | -74.44011632 | 2020-12-22 05:22:33 | Montgomery, New York, US |
929377 | 929377 | 2020-12-21 | US | Minnesota | Aitkin | 27001 | 974 | 31 | 0 | 943 | 46.60962049 | -93.4116826 | 2020-12-22 05:22:33 | Aitkin, Minnesota, US |
2121398 | 2121398 | 2020-12-20 | US | Minnesota | Aitkin | 27001 | 974 | 31 | 0 | 943 | 46.60962049 | -93.4116826 | 2020-12-21 05:27:58 | Aitkin, Minnesota, US |
1903979 | 1903979 | 2020-12-18 | US | South Carolina | Hampton | 45049 | 978 | 35 | 0 | 943 | 32.77419582 | -81.13845571 | 2020-12-19 05:27:52 | Hampton, South Carolina, US |
2131331 | 2131331 | 2020-12-17 | US | Virginia | Halifax | 51083 | 969 | 26 | 0 | 943 | 36.76654925 | -78.93512622 | 2020-12-18 05:28:18 | Halifax, Virginia, US |
2127845 | 2127845 | 2020-12-17 | Colombia | Magdalena | 22317 | 1008 | 20366 | 943 | 10.4113 | -74.4057 | 2020-12-18 05:28:18 | Magdalena, Colombia | ||
3152664 | 3152664 | 2020-12-16 | US | Texas | Falls | 48145 | 1026 | 16 | 0 | 943 | 31.25350609 | -96.93630086 | 2020-12-17 05:28:12 | Falls, Texas, US |
1752900 | 1752900 | 2020-12-14 | US | Michigan | Iosco | 26069 | 980 | 37 | 0 | 943 | 44.35486835 | -83.63484895 | 2020-12-15 05:26:38 | Iosco, Michigan, US |
3849644 | 3849644 | 2020-12-13 | US | Missouri | Andrew | 29003 | 956 | 13 | 0 | 943 | 39.98492163 | -94.80163024 | 2020-12-14 05:26:27 | Andrew, Missouri, US |
845773 | 845773 | 2020-12-12 | Russia | Kamchatka Krai | 8606 | 82 | 7581 | 943 | 57.1914882 | 160.03838190000005 | 2020-12-13 05:27:20 | Kamchatka Krai, Russia | ||
862880 | 862880 | 2020-12-11 | US | New Mexico | Taos | 35055 | 976 | 33 | 0 | 943 | 36.58006022 | -105.6310198 | 2020-12-12 05:26:19 | Taos, New Mexico, US |
861093 | 861093 | 2020-12-11 | US | Alaska | Juneau | 2110 | 948 | 5 | 0 | 943 | 58.45031811 | -134.200436 | 2020-12-12 05:26:19 | Juneau, Alaska, US |
1601199 | 1601199 | 2020-12-10 | US | Illinois | Greene | 17061 | 972 | 29 | 0 | 943 | 39.35907414 | -90.388865 | 2020-12-11 05:26:59 | Greene, Illinois, US |
1600893 | 1600893 | 2020-12-10 | US | Florida | Calhoun | 12013 | 965 | 22 | 0 | 943 | 30.40666734 | -85.19394153 | 2020-12-11 05:26:59 | Calhoun, Florida, US |
2977793 | 2977793 | 2020-12-09 | US | Oklahoma | McIntosh | 40091 | 957 | 14 | 0 | 943 | 35.37235506 | -95.66599306 | 2020-12-10 05:26:19 | McIntosh, Oklahoma, 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]);