johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
220 rows where active = 1066 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2355125 | 2355125 | 2021-08-10 | Malaysia | W.P. Putrajaya | 4619 | 20 | 3533 | 1066 | 2.9264 | 101.6964 | 2021-08-11 04:21:58 | W.P. Putrajaya, Malaysia | ||
3137782 | 3137782 | 2021-07-23 | Russia | North Ossetia - Alania Republic | 18270 | 246 | 16958 | 1066 | 42.79336110000001 | 44.6324493 | 2021-07-24 00:21:36 | North Ossetia - Alania Republic, Russia | ||
1440530 | 1440530 | 2021-07-07 | India | Haryana | 769093 | 9515 | 758512 | 1066 | 29.20004 | 76.332824 | 2021-07-08 04:21:26 | Haryana, India | ||
2693392 | 2693392 | 2021-07-06 | Azerbaijan | 336557 | 4978 | 330513 | 1066 | 40.1431 | 47.5769 | 2021-07-07 04:21:20 | Azerbaijan | |||
1499226 | 1499226 | 2021-07-03 | Ukraine | Dnipropetrovsk Oblast | 135681 | 4443 | 130172 | 1066 | 48.4647 | 35.0462 | 2021-07-04 04:21:38 | Dnipropetrovsk Oblast, Ukraine | ||
400299 | 400299 | 2021-06-29 | Japan | Saitama | 46325 | 831 | 44428 | 1066 | 35.997101 | 139.347635 | 2021-06-30 04:21:41 | Saitama, Japan | ||
1771454 | 1771454 | 2021-05-23 | Montenegro | 99248 | 1574 | 96608 | 1066 | 42.708678000000006 | 19.37439 | 2021-05-24 04:20:53 | Montenegro | |||
2450559 | 2450559 | 2021-05-02 | Chile | Coquimbo | 32361 | 618 | 30677 | 1066 | -29.959 | -71.3389 | 2021-05-03 04:20:39 | Coquimbo, Chile | ||
3129308 | 3129308 | 2021-04-18 | Chile | Coquimbo | 30090 | 579 | 28445 | 1066 | -29.959 | -71.3389 | 2021-04-19 04:20:57 | Coquimbo, Chile | ||
983016 | 983016 | 2021-04-17 | Malawi | 33919 | 1136 | 31717 | 1066 | -13.2543 | 34.3015 | 2021-04-18 04:20:41 | Malawi | |||
170111 | 170111 | 2021-04-16 | Malawi | 33919 | 1136 | 31717 | 1066 | -13.2543 | 34.3015 | 2021-04-17 04:20:40 | Malawi | |||
2645520 | 2645520 | 2021-04-08 | Canada | Manitoba | 34793 | 946 | 32781 | 1066 | 53.7609 | -98.8139 | 2021-04-09 04:21:13 | Manitoba, Canada | ||
2208580 | 2208580 | 2021-03-04 | US | Idaho | Franklin | 16041 | 1080 | 14 | 0 | 1066 | 42.18332217 | -111.8149666 | 2021-03-05 05:26:29 | Franklin, Idaho, US |
1091001 | 1091001 | 2021-03-03 | US | Idaho | Franklin | 16041 | 1080 | 14 | 0 | 1066 | 42.18332217 | -111.8149666 | 2021-03-04 05:24:24 | Franklin, Idaho, US |
2371002 | 2371002 | 2021-02-28 | US | West Virginia | Taylor | 54091 | 1087 | 21 | 0 | 1066 | 39.33602617 | -80.0421439 | 2021-03-01 05:23:01 | Taylor, West Virginia, US |
1858339 | 1858339 | 2021-02-25 | Togo | 6637 | 82 | 5489 | 1066 | 8.6195 | 0.8248 | 2021-02-26 05:22:40 | Togo | |||
281757 | 281757 | 2021-02-24 | US | Maryland | Kent | 24029 | 1108 | 42 | 0 | 1066 | 39.24976208 | -76.04741541 | 2021-02-25 05:24:57 | Kent, Maryland, US |
531888 | 531888 | 2021-02-22 | US | Iowa | Franklin | 19069 | 1085 | 19 | 0 | 1066 | 42.73270384 | -93.26256925 | 2021-02-23 05:23:41 | Franklin, Iowa, US |
183222 | 183222 | 2021-02-21 | US | Iowa | Franklin | 19069 | 1085 | 19 | 0 | 1066 | 42.73270384 | -93.26256925 | 2021-02-22 05:24:21 | Franklin, Iowa, US |
473188 | 473188 | 2021-02-19 | US | Mississippi | Amite | 28005 | 1098 | 32 | 0 | 1066 | 31.17467303 | -90.80501621 | 2021-02-20 05:22:51 | Amite, Mississippi, US |
1154897 | 1154897 | 2021-02-18 | US | Mississippi | Amite | 28005 | 1098 | 32 | 0 | 1066 | 31.17467303 | -90.80501621 | 2021-02-19 05:24:16 | Amite, Mississippi, US |
2284966 | 2284966 | 2021-02-14 | US | Louisiana | West Feliciana | 22125 | 1096 | 30 | 0 | 1066 | 30.87882871 | -91.4148538 | 2021-02-15 05:24:49 | West Feliciana, Louisiana, US |
2640207 | 2640207 | 2021-02-11 | US | Ohio | Monroe | 39111 | 1106 | 40 | 0 | 1066 | 39.72984936 | -81.08464734 | 2021-02-12 05:23:29 | Monroe, Ohio, US |
2639262 | 2639262 | 2021-02-11 | US | Louisiana | West Feliciana | 22125 | 1096 | 30 | 0 | 1066 | 30.87882871 | -91.4148538 | 2021-02-12 05:23:29 | West Feliciana, Louisiana, US |
1687870 | 1687870 | 2021-02-02 | US | Virginia | New Kent | 51127 | 1073 | 7 | 0 | 1066 | 37.50694406 | -76.99828634 | 2021-02-03 05:22:52 | New Kent, Virginia, US |
1679418 | 1679418 | 2021-02-01 | US | Tennessee | Jackson | 47087 | 1227 | 25 | 0 | 1066 | 36.36380466 | -85.67239905 | 2021-02-02 05:22:49 | Jackson, Tennessee, US |
1898347 | 1898347 | 2021-01-29 | US | Iowa | Humboldt | 19091 | 1085 | 19 | 0 | 1066 | 42.7764426 | -94.20722537 | 2021-01-30 05:22:49 | Humboldt, Iowa, US |
2485648 | 2485648 | 2021-01-28 | Malaysia | Negeri Sembilan | 11382 | 20 | 10296 | 1066 | 2.7258 | 101.9424 | 2021-01-29 05:22:23 | Negeri Sembilan, Malaysia | ||
2483739 | 2483739 | 2021-01-28 | US | Minnesota | Watonwan | 27165 | 1074 | 8 | 0 | 1066 | 43.97823903 | -94.61413846 | 2021-01-29 05:22:23 | Watonwan, Minnesota, US |
2483200 | 2483200 | 2021-01-28 | US | Iowa | Shelby | 19165 | 1093 | 27 | 0 | 1066 | 41.6850066 | -95.31015553 | 2021-01-29 05:22:23 | Shelby, Iowa, US |
3155014 | 3155014 | 2021-01-27 | US | Kentucky | Jackson | 21109 | 1090 | 24 | 0 | 1066 | 37.41866422 | -83.99825483 | 2021-01-28 05:22:24 | Jackson, Kentucky, US |
1094902 | 1094902 | 2021-01-20 | US | Georgia | Jasper | 13159 | 1086 | 20 | 0 | 1066 | 33.31535543 | -83.68844964 | 2021-01-21 05:22:01 | Jasper, Georgia, US |
909413 | 909413 | 2021-01-19 | US | Iowa | Union | 19175 | 1088 | 22 | 0 | 1066 | 41.0277278 | -94.24234847 | 2021-01-20 05:21:54 | Union, Iowa, US |
909236 | 909236 | 2021-01-19 | US | Indiana | Blackford | 18009 | 1092 | 26 | 0 | 1066 | 40.47388153 | -85.32499702 | 2021-01-20 05:21:54 | Blackford, Indiana, US |
908816 | 908816 | 2021-01-19 | US | Colorado | Prowers | 8099 | 1108 | 21 | 0 | 1066 | 37.95544985 | -102.3926052 | 2021-01-20 05:21:54 | Prowers, Colorado, US |
238190 | 238190 | 2021-01-18 | US | Idaho | Washington | 16087 | 1083 | 17 | 0 | 1066 | 44.45275475 | -116.7847688 | 2021-01-19 05:22:15 | Washington, Idaho, US |
3504307 | 3504307 | 2021-01-17 | US | Idaho | Washington | 16087 | 1083 | 17 | 0 | 1066 | 44.45275475 | -116.7847688 | 2021-01-18 05:22:34 | Washington, Idaho, US |
3104915 | 3104915 | 2021-01-16 | US | West Virginia | Hardy | 54031 | 1078 | 12 | 0 | 1066 | 39.00683177 | -78.85855301 | 2021-01-17 05:22:17 | Hardy, West Virginia, US |
776747 | 776747 | 2021-01-12 | US | North Dakota | McKenzie | 38053 | 1072 | 11 | 0 | 1066 | 47.74133370000001 | -103.395905 | 2021-01-13 05:22:15 | McKenzie, North Dakota, US |
775765 | 775765 | 2021-01-12 | US | Kentucky | Lee | 21129 | 1084 | 18 | 0 | 1066 | 37.59645942 | -83.71513901 | 2021-01-13 05:22:15 | Lee, Kentucky, US |
3903315 | 3903315 | 2021-01-09 | US | Virginia | Louisa | 51109 | 1077 | 11 | 0 | 1066 | 37.97850256 | -77.96274807 | 2021-01-10 05:22:12 | Louisa, Virginia, US |
2542336 | 2542336 | 2021-01-07 | US | Idaho | Idaho | 16049 | 1081 | 15 | 0 | 1066 | 45.84721541 | -115.4634436 | 2021-01-08 05:22:42 | Idaho, Idaho, US |
2542145 | 2542145 | 2021-01-07 | US | Georgia | Bacon | 13005 | 1091 | 25 | 0 | 1066 | 31.55456473 | -82.45936528 | 2021-01-08 05:22:42 | Bacon, Georgia, US |
3034945 | 3034945 | 2021-01-05 | US | Colorado | Routt | 8107 | 1191 | 19 | 0 | 1066 | 40.48596505 | -106.9905548 | 2021-01-06 05:22:16 | Routt, Colorado, US |
1065178 | 1065178 | 2021-01-04 | US | Virginia | Fredericksburg | 51630 | 1077 | 11 | 0 | 1066 | 38.2977863 | -77.4922454 | 2021-01-05 05:21:49 | Fredericksburg, Virginia, US |
1063335 | 1063335 | 2021-01-04 | US | Louisiana | Claiborne | 22027 | 1104 | 38 | 0 | 1066 | 32.82308512 | -92.99526883 | 2021-01-05 05:21:49 | Claiborne, Louisiana, US |
3698872 | 3698872 | 2020-12-31 | US | Virginia | Prince Edward | 51147 | 1083 | 17 | 0 | 1066 | 37.22554789 | -78.43597949 | 2021-01-01 05:23:07 | Prince Edward, Virginia, US |
1013885 | 1013885 | 2020-12-30 | US | Wisconsin | Washburn | 55129 | 1080 | 14 | 0 | 1066 | 45.89838588 | -91.79050449 | 2020-12-31 05:22:49 | Washburn, Wisconsin, US |
3762564 | 3762564 | 2020-12-28 | US | Illinois | Greene | 17061 | 1096 | 30 | 0 | 1066 | 39.35907414 | -90.388865 | 2020-12-29 05:22:37 | Greene, Illinois, US |
3779217 | 3779217 | 2020-12-27 | US | Kansas | Neosho | 20133 | 1077 | 11 | 0 | 1066 | 37.55862897 | -95.30670046 | 2020-12-28 05:22:06 | Neosho, Kansas, US |
2224822 | 2224822 | 2020-12-26 | US | Kansas | Neosho | 20133 | 1077 | 11 | 0 | 1066 | 37.55862897 | -95.30670046 | 2020-12-27 05:22:55 | Neosho, Kansas, US |
203569 | 203569 | 2020-12-25 | US | Kansas | Neosho | 20133 | 1077 | 11 | 0 | 1066 | 37.55862897 | -95.30670046 | 2020-12-26 05:22:28 | Neosho, Kansas, US |
3692792 | 3692792 | 2020-12-24 | US | Kansas | Neosho | 20133 | 1077 | 11 | 0 | 1066 | 37.55862897 | -95.30670046 | 2020-12-25 05:22:48 | Neosho, Kansas, US |
2409983 | 2409983 | 2020-12-23 | US | Texas | Madison | 48313 | 1226 | 16 | 0 | 1066 | 30.96694679 | -95.93003775 | 2020-12-24 05:23:04 | Madison, Texas, US |
2409676 | 2409676 | 2020-12-23 | US | South Dakota | Charles Mix | 46023 | 1076 | 10 | 0 | 1066 | 43.20660134 | -98.58856175 | 2020-12-24 05:23:04 | Charles Mix, South Dakota, US |
2408144 | 2408144 | 2020-12-23 | US | Kansas | Neosho | 20133 | 1077 | 11 | 0 | 1066 | 37.55862897 | -95.30670046 | 2020-12-24 05:23:04 | Neosho, Kansas, US |
3771190 | 3771190 | 2020-12-22 | US | Kansas | Neosho | 20133 | 1077 | 11 | 0 | 1066 | 37.55862897 | -95.30670046 | 2020-12-23 05:22:03 | Neosho, Kansas, US |
3770838 | 3770838 | 2020-12-22 | US | Illinois | Clark | 17023 | 1091 | 25 | 0 | 1066 | 39.33425789 | -87.78705622 | 2020-12-23 05:22:03 | Clark, Illinois, US |
930808 | 930808 | 2020-12-21 | US | Texas | Hutchinson | 48233 | 2027 | 40 | 0 | 1066 | 35.84006574 | -101.3546643 | 2020-12-22 05:22:33 | Hutchinson, Texas, US |
930645 | 930645 | 2020-12-21 | US | Tennessee | Lewis | 47101 | 1101 | 19 | 0 | 1066 | 35.52853208 | -87.49022694 | 2020-12-22 05:22:33 | Lewis, Tennessee, US |
2122829 | 2122829 | 2020-12-20 | US | Texas | Hutchinson | 48233 | 2010 | 40 | 0 | 1066 | 35.84006574 | -101.3546643 | 2020-12-21 05:27:58 | Hutchinson, Texas, US |
2120851 | 2120851 | 2020-12-20 | US | Indiana | Vermillion | 18165 | 1091 | 25 | 0 | 1066 | 39.8523352 | -87.46160542 | 2020-12-21 05:27:58 | Vermillion, Indiana, US |
2934336 | 2934336 | 2020-12-19 | US | Texas | Hutchinson | 48233 | 1991 | 40 | 0 | 1066 | 35.84006574 | -101.3546643 | 2020-12-20 05:27:32 | Hutchinson, Texas, US |
1902354 | 1902354 | 2020-12-18 | US | Iowa | Hancock | 19081 | 1088 | 22 | 0 | 1066 | 43.08178477 | -93.73454884 | 2020-12-19 05:27:52 | Hancock, Iowa, US |
2128005 | 2128005 | 2020-12-17 | Japan | Hyogo | 7844 | 128 | 6650 | 1066 | 35.039913 | 134.828057 | 2020-12-18 05:28:18 | Hyogo, Japan | ||
3151524 | 3151524 | 2020-12-16 | US | Missouri | Osage | 29151 | 1072 | 6 | 0 | 1066 | 38.46036182 | -91.8613635 | 2020-12-17 05:28:12 | Osage, Missouri, US |
1754631 | 1754631 | 2020-12-14 | US | Virginia | Mecklenburg | 51117 | 1103 | 37 | 0 | 1066 | 36.67882005 | -78.36131056 | 2020-12-15 05:26:38 | Mecklenburg, Virginia, US |
1753052 | 1753052 | 2020-12-14 | US | Mississippi | Clay | 28025 | 1094 | 28 | 0 | 1066 | 33.65358105 | -88.77784255 | 2020-12-15 05:26:38 | Clay, Mississippi, US |
1752287 | 1752287 | 2020-12-14 | US | Illinois | Moultrie | 17139 | 1079 | 13 | 0 | 1066 | 39.64187451 | -88.62099969 | 2020-12-15 05:26:38 | Moultrie, Illinois, US |
1752196 | 1752196 | 2020-12-14 | US | Idaho | Gooding | 16047 | 1080 | 14 | 0 | 1066 | 42.96927962 | -114.8108306 | 2020-12-15 05:26:38 | Gooding, Idaho, US |
1751752 | 1751752 | 2020-12-14 | US | Arkansas | Izard | 5065 | 1073 | 7 | 0 | 1066 | 36.09604046 | -91.90847954 | 2020-12-15 05:26:38 | Izard, Arkansas, US |
3851464 | 3851464 | 2020-12-13 | Malaysia | Negeri Sembilan | 6265 | 11 | 5188 | 1066 | 2.7258 | 101.9424 | 2020-12-14 05:26:27 | Negeri Sembilan, Malaysia | ||
3851151 | 3851151 | 2020-12-13 | US | Virginia | Mecklenburg | 51117 | 1103 | 37 | 0 | 1066 | 36.67882005 | -78.36131056 | 2020-12-14 05:26:27 | Mecklenburg, Virginia, US |
3847733 | 3847733 | 2020-12-13 | India | Goa | 49362 | 706 | 47590 | 1066 | 15.359682 | 74.057396 | 2020-12-14 05:26:27 | Goa, India | ||
846965 | 846965 | 2020-12-12 | US | Kentucky | Grayson | 21085 | 1091 | 25 | 0 | 1066 | 37.46231118 | -86.34248968 | 2020-12-13 05:27:20 | Grayson, Kentucky, US |
846402 | 846402 | 2020-12-12 | US | Georgia | McDuffie | 13189 | 1089 | 23 | 0 | 1066 | 33.47851918 | -82.48252774 | 2020-12-13 05:27:20 | McDuffie, Georgia, US |
1601383 | 1601383 | 2020-12-10 | US | Iowa | Cherokee | 19035 | 1070 | 4 | 0 | 1066 | 42.73538914 | -95.62389402 | 2020-12-11 05:26:59 | Cherokee, Iowa, US |
1600588 | 1600588 | 2020-12-10 | US | Alabama | Hale | 1065 | 1099 | 33 | 0 | 1066 | 32.76039258 | -87.63284988 | 2020-12-11 05:26:59 | Hale, Alabama, US |
2978354 | 2978354 | 2020-12-09 | US | Texas | Karnes | 48255 | 1077 | 19 | 0 | 1066 | 28.90705334 | -97.85960149 | 2020-12-10 05:26:19 | Karnes, Texas, US |
1820103 | 1820103 | 2020-12-08 | US | Kansas | Norton | 20137 | 1090 | 24 | 0 | 1066 | 39.78443827 | -99.90286639 | 2020-12-09 05:28:01 | Norton, Kansas, US |
2348739 | 2348739 | 2020-12-07 | US | Kansas | Norton | 20137 | 1090 | 24 | 0 | 1066 | 39.78443827 | -99.90286639 | 2020-12-08 05:27:42 | Norton, Kansas, US |
1006787 | 1006787 | 2020-12-06 | US | Arkansas | Logan | 5083 | 1072 | 6 | 0 | 1066 | 35.21413234 | -93.71951016 | 2020-12-07 05:26:14 | Logan, Arkansas, US |
1632649 | 1632649 | 2020-12-05 | US | Alabama | Cherokee | 1019 | 1090 | 24 | 0 | 1066 | 34.17805983 | -85.60638968 | 2020-12-06 05:26:18 | Cherokee, Alabama, US |
76247 | 76247 | 2020-12-03 | US | Iowa | Butler | 19023 | 1074 | 8 | 0 | 1066 | 42.73172833 | -92.79015971 | 2020-12-04 05:27:27 | Butler, Iowa, US |
75627 | 75627 | 2020-12-03 | US | California | Glenn | 6021 | 1071 | 8 | 0 | 1066 | 39.59875897 | -122.3938452 | 2020-12-04 05:27:27 | Glenn, California, US |
739054 | 739054 | 2020-12-02 | US | Georgia | Butts | 13035 | 1112 | 46 | 0 | 1066 | 33.283094500000004 | -83.95435040000002 | 2020-12-03 05:28:22 | Butts, Georgia, US |
2539621 | 2539621 | 2020-12-01 | US | New York | Genesee | 36037 | 1076 | 10 | 0 | 1066 | 43.0022601 | -78.19135193 | 2020-12-02 05:27:41 | Genesee, New York, US |
2538574 | 2538574 | 2020-12-01 | US | Iowa | Fayette | 19065 | 1076 | 10 | 0 | 1066 | 42.86271799 | -91.8441231 | 2020-12-02 05:27:41 | Fayette, Iowa, US |
1587771 | 1587771 | 2020-11-30 | US | Wyoming | Uinta | 56041 | 1070 | 4 | 0 | 1066 | 41.2878183 | -110.54757820000002 | 2020-12-01 05:26:18 | Uinta, Wyoming, US |
1586006 | 1586006 | 2020-11-30 | US | Mississippi | Tishomingo | 28141 | 1108 | 42 | 0 | 1066 | 34.74023475 | -88.23917219 | 2020-12-01 05:26:18 | Tishomingo, Mississippi, US |
926196 | 926196 | 2020-11-26 | US | Ohio | Williams | 39171 | 1079 | 13 | 0 | 1066 | 41.56052014 | -84.58429552 | 2020-11-27 05:26:53 | Williams, Ohio, US |
924850 | 924850 | 2020-11-26 | US | Iowa | Clayton | 19043 | 1071 | 5 | 0 | 1066 | 42.84443388 | -91.34133693 | 2020-11-27 05:26:53 | Clayton, Iowa, US |
923519 | 923519 | 2020-11-26 | Colombia | Bolivar | 37017 | 900 | 35051 | 1066 | 8.6704 | -74.03 | 2020-11-27 05:26:53 | Bolivar, Colombia | ||
1351166 | 1351166 | 2020-11-24 | US | Georgia | Pickens | 13227 | 1081 | 15 | 0 | 1066 | 34.46589159 | -84.46406611 | 2020-11-25 05:27:20 | Pickens, Georgia, US |
679700 | 679700 | 2020-11-23 | US | Kentucky | Floyd | 21071 | 1071 | 5 | 0 | 1066 | 37.56213922 | -82.74750924 | 2020-11-24 05:27:31 | Floyd, Kentucky, US |
3838364 | 3838364 | 2020-11-21 | US | Missouri | Crawford | 29055 | 1077 | 11 | 0 | 1066 | 37.97663738 | -91.30528104 | 2020-11-22 05:25:45 | Crawford, Missouri, US |
824488 | 824488 | 2020-11-19 | US | Tennessee | Crockett | 47033 | 1084 | 25 | 0 | 1066 | 35.81830662 | -89.14916269 | 2020-11-20 05:26:28 | Crockett, Tennessee, US |
823705 | 823705 | 2020-11-19 | US | Nevada | Nye | 32023 | 1088 | 22 | 0 | 1066 | 38.04264256 | -116.4722702 | 2020-11-20 05:26:28 | Nye, Nevada, US |
124066 | 124066 | 2020-11-18 | US | Kentucky | Boyd | 21019 | 1089 | 23 | 0 | 1066 | 38.36176608 | -82.68652187 | 2020-11-19 05:25:23 | Boyd, Kentucky, US |
3342084 | 3342084 | 2020-11-17 | US | West Virginia | Ohio | 54069 | 1079 | 13 | 0 | 1066 | 40.0955451 | -80.62203992 | 2020-11-18 05:40:31 | Ohio, 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]);