johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
108 rows where active = 2145 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2947199 | 2947199 | 2021-07-16 | Colombia | Cesar | 84134 | 2316 | 79673 | 2145 | 9.3373 | -73.6536 | 2021-07-17 04:22:22 | Cesar, Colombia | ||
2697357 | 2697357 | 2021-07-06 | West Bank and Gaza | 314780 | 3576 | 309059 | 2145 | 31.9522 | 35.2332 | 2021-07-07 04:21:20 | West Bank and Gaza | |||
2884630 | 2884630 | 2021-06-20 | Russia | Vologda Oblast | 47108 | 1137 | 43826 | 2145 | 60.0391461 | 43.1215213 | 2021-06-21 04:21:41 | Vologda Oblast, Russia | ||
1563867 | 1563867 | 2021-06-14 | Canada | Quebec | 373512 | 11173 | 360194 | 2145 | 52.9399 | -73.5491 | 2021-06-15 04:22:22 | Quebec, Canada | ||
3145345 | 3145345 | 2021-06-07 | Canada | British Columbia | 145530 | 1722 | 141663 | 2145 | 53.7267 | -127.6476 | 2021-06-08 04:22:35 | British Columbia, Canada | ||
3621150 | 3621150 | 2021-03-17 | Mali | 9066 | 365 | 6556 | 2145 | 17.570692 | -3.996166000000001 | 2021-03-18 05:26:22 | Mali | |||
3620995 | 3620995 | 2021-03-17 | Germany | Mecklenburg-Vorpommern | 27094 | 816 | 24329 | 2145 | 53.6127 | 12.4296 | 2021-03-18 05:26:22 | Mecklenburg-Vorpommern, Germany | ||
3671065 | 3671065 | 2021-03-06 | US | Washington | Okanogan | 53047 | 2181 | 36 | 0 | 2145 | 48.54855019 | -119.7387224 | 2021-03-07 05:21:54 | Okanogan, Washington, US |
1619686 | 1619686 | 2021-03-05 | US | Washington | Okanogan | 53047 | 2181 | 36 | 0 | 2145 | 48.54855019 | -119.7387224 | 2021-03-06 04:23:41 | Okanogan, Washington, US |
2368234 | 2368234 | 2021-02-28 | US | Georgia | Appling | 13001 | 2207 | 62 | 0 | 2145 | 31.74847232 | -82.28909114 | 2021-03-01 05:23:01 | Appling, Georgia, US |
3066787 | 3066787 | 2021-02-27 | US | Georgia | Elbert | 13105 | 2207 | 62 | 0 | 2145 | 34.11302332 | -82.83936148 | 2021-02-28 05:22:20 | Elbert, Georgia, US |
2183840 | 2183840 | 2021-02-26 | Russia | Vladimir Oblast | 27166 | 858 | 24163 | 2145 | 56.0503336 | 40.6561633 | 2021-02-27 05:22:28 | Vladimir Oblast, Russia | ||
1936945 | 1936945 | 2021-02-23 | US | Arkansas | Logan | 5083 | 2163 | 18 | 0 | 2145 | 35.21413234 | -93.71951016 | 2021-02-24 05:29:16 | Logan, Arkansas, US |
533877 | 533877 | 2021-02-22 | US | Texas | Moore | 48341 | 2779 | 68 | 0 | 2145 | 35.83769242 | -101.8930281 | 2021-02-23 05:23:41 | Moore, Texas, US |
533162 | 533162 | 2021-02-22 | US | Ohio | Gallia | 39053 | 2191 | 46 | 0 | 2145 | 38.82708533 | -82.31647569 | 2021-02-23 05:23:41 | Gallia, Ohio, US |
185211 | 185211 | 2021-02-21 | US | Texas | Moore | 48341 | 2779 | 68 | 0 | 2145 | 35.83769242 | -101.8930281 | 2021-02-22 05:24:21 | Moore, Texas, US |
183736 | 183736 | 2021-02-21 | US | Minnesota | Cass | 27021 | 2169 | 24 | 0 | 2145 | 46.95043611 | -94.32603968 | 2021-02-22 05:24:21 | Cass, Minnesota, US |
745485 | 745485 | 2021-02-20 | US | Texas | Moore | 48341 | 2779 | 68 | 0 | 2145 | 35.83769242 | -101.8930281 | 2021-02-21 05:24:33 | Moore, Texas, US |
3602492 | 3602492 | 2021-02-17 | US | Kentucky | Perry | 21193 | 2177 | 32 | 0 | 2145 | 37.25023553 | -83.22922731 | 2021-02-18 05:22:58 | Perry, Kentucky, US |
3051627 | 3051627 | 2021-02-16 | US | Kentucky | Perry | 21193 | 2177 | 32 | 0 | 2145 | 37.25023553 | -83.22922731 | 2021-02-17 05:23:10 | Perry, Kentucky, US |
3050568 | 3050568 | 2021-02-16 | US | Alabama | Pickens | 1107 | 2195 | 50 | 0 | 2145 | 33.28094866 | -88.08818103 | 2021-02-17 05:23:10 | Pickens, Alabama, US |
1341855 | 1341855 | 2021-02-15 | US | Wisconsin | Vilas | 55125 | 2183 | 38 | 0 | 2145 | 46.05467334 | -89.51719204 | 2021-02-16 05:24:38 | Vilas, Wisconsin, US |
1341686 | 1341686 | 2021-02-15 | US | Virginia | Warren | 51187 | 2185 | 40 | 0 | 2145 | 38.90847745 | -78.20280433 | 2021-02-16 05:24:38 | Warren, Virginia, US |
2286040 | 2286040 | 2021-02-14 | US | Oregon | Josephine | 41033 | 2192 | 47 | 0 | 2145 | 42.3665549 | -123.5561938 | 2021-02-15 05:24:49 | Josephine, Oregon, US |
2680103 | 2680103 | 2021-02-13 | US | North Carolina | Anson | 37007 | 2193 | 48 | 0 | 2145 | 34.97403241 | -80.09953279 | 2021-02-14 05:23:43 | Anson, North Carolina, US |
976432 | 976432 | 2021-02-06 | US | Louisiana | Plaquemines | 22075 | 2167 | 22 | 0 | 2145 | 29.42245447 | -89.60322085 | 2021-02-07 05:23:00 | Plaquemines, Louisiana, US |
1590621 | 1590621 | 2021-02-05 | US | Ohio | Coshocton | 39031 | 2197 | 52 | 0 | 2145 | 40.30096166 | -81.91729018 | 2021-02-06 05:23:55 | Coshocton, Ohio, US |
1589690 | 1589690 | 2021-02-05 | US | Louisiana | Plaquemines | 22075 | 2167 | 22 | 0 | 2145 | 29.42245447 | -89.60322085 | 2021-02-06 05:23:55 | Plaquemines, Louisiana, US |
1589209 | 1589209 | 2021-02-05 | US | Illinois | Saline | 17165 | 2188 | 43 | 0 | 2145 | 37.75332999 | -88.54119706 | 2021-02-06 05:23:55 | Saline, Illinois, US |
342984 | 342984 | 2021-02-03 | US | Puerto Rico | Arecibo | 72013 | 2145 | 0 | 0 | 2145 | 18.406631 | -66.675077 | 2021-02-04 05:22:26 | Arecibo, Puerto Rico, US |
1678245 | 1678245 | 2021-02-01 | US | Mississippi | Adams | 28001 | 2217 | 72 | 0 | 2145 | 31.47669768 | -91.35326037 | 2021-02-02 05:22:49 | Adams, Mississippi, US |
1677909 | 1677909 | 2021-02-01 | US | Kentucky | Mercer | 21167 | 2159 | 14 | 0 | 2145 | 37.81474237 | -84.87488475 | 2021-02-02 05:22:49 | Mercer, Kentucky, US |
1677371 | 1677371 | 2021-02-01 | US | Hawaii | Hawaii | 15001 | 2198 | 53 | 0 | 2145 | 19.60121157 | -155.5210167 | 2021-02-02 05:22:49 | Hawaii, Hawaii, US |
1461292 | 1461292 | 2021-01-31 | US | Louisiana | Union | 22111 | 2217 | 72 | 0 | 2145 | 32.83121059 | -92.3749373 | 2021-02-01 05:22:53 | Union, Louisiana, US |
2481824 | 2481824 | 2021-01-28 | Colombia | Norte de Santander | 48193 | 2492 | 43556 | 2145 | 7.9463 | -72.8988 | 2021-01-29 05:22:23 | Norte de Santander, Colombia | ||
3156533 | 3156533 | 2021-01-27 | US | Tennessee | Fentress | 47049 | 2279 | 37 | 0 | 2145 | 36.38128818 | -84.92870012 | 2021-01-28 05:22:24 | Fentress, Tennessee, US |
2467629 | 2467629 | 2021-01-22 | US | Georgia | Lee | 13177 | 2183 | 38 | 0 | 2145 | 31.779330600000005 | -84.14324253 | 2021-01-23 05:22:03 | Lee, Georgia, US |
911463 | 911463 | 2021-01-19 | US | Virginia | Accomack | 51001 | 2176 | 31 | 0 | 2145 | 37.76707161 | -75.63234615 | 2021-01-20 05:21:54 | Accomack, Virginia, US |
909302 | 909302 | 2021-01-19 | US | Indiana | Scott | 18143 | 2185 | 40 | 0 | 2145 | 38.68672078 | -85.74627859 | 2021-01-20 05:21:54 | Scott, Indiana, US |
3102595 | 3102595 | 2021-01-16 | US | Iowa | Boone | 19015 | 2162 | 17 | 0 | 2145 | 42.03657094 | -93.9313999 | 2021-01-17 05:22:17 | Boone, Iowa, US |
191457 | 191457 | 2021-01-11 | US | Kentucky | Floyd | 21071 | 2161 | 16 | 0 | 2145 | 37.56213922 | -82.74750924 | 2021-01-12 05:22:15 | Floyd, Kentucky, US |
2628393 | 2628393 | 2021-01-10 | US | Oklahoma | Beckham | 40009 | 2168 | 23 | 0 | 2145 | 35.26862449 | -99.68128023 | 2021-01-11 05:21:50 | Beckham, Oklahoma, US |
154896 | 154896 | 2021-01-08 | US | Idaho | Bonner | 16017 | 2162 | 17 | 0 | 2145 | 48.29996017 | -116.6017932 | 2021-01-09 05:22:18 | Bonner, Idaho, US |
2544592 | 2544592 | 2021-01-07 | US | Texas | Polk | 48373 | 2244 | 61 | 0 | 2145 | 30.79472531 | -94.8276624 | 2021-01-08 05:22:42 | Polk, Texas, US |
2867901 | 2867901 | 2021-01-06 | US | Texas | Polk | 48373 | 2244 | 61 | 0 | 2145 | 30.79472531 | -94.8276624 | 2021-01-07 05:22:03 | Polk, Texas, US |
3232670 | 3232670 | 2021-01-03 | US | New York | Cortland | 36023 | 2183 | 38 | 0 | 2145 | 42.59509207 | -76.07048931 | 2021-01-04 05:22:02 | Cortland, New York, US |
1011168 | 1011168 | 2020-12-30 | US | Georgia | Stephens | 13257 | 2195 | 50 | 0 | 2145 | 34.55151201 | -83.29405315 | 2020-12-31 05:22:49 | Stephens, Georgia, US |
203916 | 203916 | 2020-12-25 | US | Michigan | Newaygo | 26123 | 2174 | 29 | 0 | 2145 | 43.554374 | -85.80070107 | 2020-12-26 05:22:28 | Newaygo, Michigan, US |
3693139 | 3693139 | 2020-12-24 | US | Michigan | Newaygo | 26123 | 2174 | 29 | 0 | 2145 | 43.554374 | -85.80070107 | 2020-12-25 05:22:48 | Newaygo, Michigan, US |
2408491 | 2408491 | 2020-12-23 | US | Michigan | Newaygo | 26123 | 2174 | 29 | 0 | 2145 | 43.554374 | -85.80070107 | 2020-12-24 05:23:04 | Newaygo, Michigan, US |
3771906 | 3771906 | 2020-12-22 | US | Nebraska | Adams | 31001 | 2177 | 32 | 0 | 2145 | 40.52449420000001 | -98.50117804 | 2020-12-23 05:22:03 | Adams, Nebraska, US |
928781 | 928781 | 2020-12-21 | US | Indiana | Huntington | 18069 | 2173 | 28 | 0 | 2145 | 40.82907273 | -85.48822092 | 2020-12-22 05:22:33 | Huntington, Indiana, US |
2127855 | 2127855 | 2020-12-17 | Colombia | Tolima | 35846 | 1072 | 32629 | 2145 | 4.0925 | -75.1545 | 2020-12-18 05:28:18 | Tolima, Colombia | ||
2127848 | 2127848 | 2020-12-17 | Colombia | Norte de Santander | 34704 | 1633 | 30926 | 2145 | 7.9463 | -72.8988 | 2020-12-18 05:28:18 | Norte de Santander, Colombia | ||
3151533 | 3151533 | 2020-12-16 | US | Missouri | Pulaski | 29169 | 2171 | 26 | 0 | 2145 | 37.82462075 | -92.20783203 | 2020-12-17 05:28:12 | Pulaski, Missouri, US |
3149810 | 3149810 | 2020-12-16 | Russia | Leningrad Oblast | 20400 | 183 | 18072 | 2145 | 60.1853296 | 32.3925325 | 2020-12-17 05:28:12 | Leningrad Oblast, Russia | ||
1753082 | 1753082 | 2020-12-14 | US | Mississippi | Lincoln | 28085 | 2216 | 71 | 0 | 2145 | 31.53288662 | -90.45391915 | 2020-12-15 05:26:38 | Lincoln, Mississippi, US |
846239 | 846239 | 2020-12-12 | US | Florida | Baker | 12003 | 2179 | 34 | 0 | 2145 | 30.33060121 | -82.28467476 | 2020-12-13 05:27:20 | Baker, Florida, US |
1603629 | 1603629 | 2020-12-10 | US | Virginia | Washington | 51191 | 2179 | 34 | 0 | 2145 | 36.72341572 | -81.95666289 | 2020-12-11 05:26:59 | Washington, Virginia, US |
1601358 | 1601358 | 2020-12-10 | US | Indiana | Wabash | 18169 | 2181 | 36 | 0 | 2145 | 40.84704239 | -85.79328272 | 2020-12-11 05:26:59 | Wabash, Indiana, US |
1601273 | 1601273 | 2020-12-10 | US | Indiana | Adams | 18001 | 2176 | 31 | 0 | 2145 | 40.7457653 | -84.93671406 | 2020-12-11 05:26:59 | Adams, Indiana, US |
740953 | 740953 | 2020-12-02 | US | Pennsylvania | Crawford | 42039 | 2169 | 24 | 0 | 2145 | 41.68447709 | -80.10760592 | 2020-12-03 05:28:22 | Crawford, Pennsylvania, US |
739256 | 739256 | 2020-12-02 | US | Illinois | Bureau | 17011 | 2192 | 47 | 0 | 2145 | 41.40385234 | -89.5283051 | 2020-12-03 05:28:22 | Bureau, Illinois, US |
393843 | 393843 | 2020-11-27 | US | Michigan | Branch | 26023 | 2174 | 29 | 0 | 2145 | 41.91600556 | -85.05929476 | 2020-11-28 05:25:50 | Branch, Michigan, US |
1973373 | 1973373 | 2020-11-25 | US | Georgia | Effingham | 13103 | 2178 | 33 | 0 | 2145 | 32.36616021 | -81.34280942 | 2020-11-26 05:27:44 | Effingham, Georgia, US |
2701289 | 2701289 | 2020-11-20 | Canada | Saskatchewan | 5804 | 33 | 3626 | 2145 | 52.9399 | -106.4509 | 2020-11-21 05:25:51 | Saskatchewan, Canada | ||
824157 | 824157 | 2020-11-19 | US | Oklahoma | Texas | 40139 | 2156 | 11 | 0 | 2145 | 36.74777635 | -101.4889765 | 2020-11-20 05:26:28 | Texas, Oklahoma, US |
3341697 | 3341697 | 2020-11-17 | US | Texas | Henderson | 48213 | 935 | 45 | 0 | 2145 | 32.21128872 | -95.85846587 | 2020-11-18 05:40:31 | Henderson, Texas, US |
3340117 | 3340117 | 2020-11-17 | US | Louisiana | St. Mary | 22101 | 2239 | 94 | 0 | 2145 | 29.69262097 | -91.44702164 | 2020-11-18 05:40:31 | St. Mary, Louisiana, US |
3338819 | 3338819 | 2020-11-17 | Russia | North Ossetia - Alania Republic | 8390 | 72 | 6173 | 2145 | 42.79336110000001 | 44.6324493 | 2020-11-18 05:40:31 | North Ossetia - Alania Republic, Russia | ||
3173167 | 3173167 | 2020-11-16 | US | Wisconsin | Dunn | 55033 | 2148 | 3 | 0 | 2145 | 44.94562799 | -91.8962481 | 2020-11-17 05:25:54 | Dunn, Wisconsin, US |
865653 | 865653 | 2020-11-12 | US | Georgia | Walker | 13295 | 2193 | 48 | 0 | 2145 | 34.73376362 | -85.30165174 | 2020-11-13 05:25:30 | Walker, Georgia, US |
1990236 | 1990236 | 2020-11-09 | US | Michigan | Bay | 26017 | 2216 | 71 | 0 | 2145 | 43.70639106 | -83.98731479 | 2020-11-10 05:40:07 | Bay, Michigan, US |
2922732 | 2922732 | 2020-11-04 | US | Wisconsin | Marinette | 55075 | 2163 | 18 | 0 | 2145 | 45.38553432 | -88.03324599999998 | 2020-11-05 06:05:03 | Marinette, Wisconsin, US |
3410394 | 3410394 | 2020-11-01 | US | Illinois | Boone | 17007 | 2171 | 26 | 0 | 2145 | 42.32359279 | -88.82345779 | 2020-11-02 05:25:04 | Boone, Illinois, US |
755959 | 755959 | 2020-10-28 | US | Michigan | Muskegon | 26121 | 2227 | 82 | 0 | 2145 | 43.29123859 | -86.15176712 | 2020-10-29 04:24:49 | Muskegon, Michigan, US |
1454587 | 1454587 | 2020-10-27 | US | Montana | Missoula | 30063 | 2155 | 10 | 0 | 2145 | 47.03728583 | -113.92135079999998 | 2020-10-28 04:24:39 | Missoula, Montana, US |
9853 | 9853 | 2020-10-25 | US | Louisiana | St. Martin | 22099 | 2208 | 63 | 0 | 2145 | 30.13112107 | -91.61403569 | 2020-10-26 04:25:02 | St. Martin, Louisiana, US |
3652258 | 3652258 | 2020-10-24 | US | Florida | Hendry | 12051 | 2188 | 43 | 0 | 2145 | 26.55386945 | -81.16469006 | 2020-10-25 04:24:36 | Hendry, Florida, US |
786863 | 786863 | 2020-10-15 | US | Arkansas | Lincoln | 5079 | 2162 | 17 | 0 | 2145 | 33.95317155 | -91.74002806 | 2020-10-16 04:24:01 | Lincoln, Arkansas, US |
3785080 | 3785080 | 2020-10-13 | US | Texas | Parker | 48367 | 2079 | 40 | 0 | 2145 | 32.77757172 | -97.80500621 | 2020-10-14 04:24:05 | Parker, Texas, US |
2291301 | 2291301 | 2020-10-12 | Colombia | Risaralda | 13520 | 294 | 11081 | 2145 | 5.3158 | -75.9928 | 2020-10-13 04:24:02 | Risaralda, Colombia | ||
820076 | 820076 | 2020-10-09 | US | Ohio | Wood | 39173 | 2212 | 67 | 0 | 2145 | 41.36224827 | -83.62285108 | 2020-10-10 04:23:57 | Wood, Ohio, US |
3117400 | 3117400 | 2020-10-06 | Germany | Niedersachsen | 21284 | 691 | 18620 | 2145 | 52.6367 | 9.8451 | 2020-10-07 04:23:40 | Niedersachsen, Germany | ||
3805422 | 3805422 | 2020-10-05 | US | Wisconsin | Eau Claire | 55035 | 2152 | 7 | 0 | 2145 | 44.726614 | -91.28609183 | 2020-10-06 04:23:33 | Eau Claire, Wisconsin, US |
3805291 | 3805291 | 2020-10-05 | US | Virginia | Spotsylvania | 51177 | 2191 | 46 | 0 | 2145 | 38.18574462 | -77.655399 | 2020-10-06 04:23:33 | Spotsylvania, Virginia, US |
1046211 | 1046211 | 2020-09-30 | US | Alabama | Talladega | 1121 | 2175 | 30 | 0 | 2145 | 33.37823223 | -86.16886178 | 2020-10-01 04:23:42 | Talladega, Alabama, US |
3934841 | 3934841 | 2020-08-30 | US | South Carolina | Pickens | 45077 | 2180 | 35 | 0 | 2145 | 34.88807695 | -82.72791551 | 2020-08-31 04:28:27 | Pickens, South Carolina, US |
3933015 | 3933015 | 2020-08-30 | US | Illinois | Kankakee | 17091 | 2216 | 71 | 0 | 2145 | 41.13746989 | -87.86205334 | 2020-08-31 04:28:27 | Kankakee, Illinois, US |
3931957 | 3931957 | 2020-08-30 | Haiti | 8174 | 201 | 5828 | 2145 | 18.9712 | -72.2852 | 2020-08-31 04:28:27 | Haiti | |||
1525415 | 1525415 | 2020-08-28 | US | New York | Oneida | 36065 | 2265 | 120 | 0 | 2145 | 43.24375382 | -75.43710392 | 2020-08-29 04:28:19 | Oneida, New York, US |
2300028 | 2300028 | 2020-08-22 | US | California | Yolo | 6113 | 2192 | 47 | 0 | 2145 | 38.68278902 | -121.9018288 | 2020-08-23 04:27:48 | Yolo, California, US |
1480000 | 1480000 | 2020-08-21 | US | Arizona | Yavapai | 4025 | 2221 | 76 | 0 | 2145 | 34.59933926 | -112.5538588 | 2020-08-22 04:27:49 | Yavapai, Arizona, US |
3533206 | 3533206 | 2020-08-12 | US | Minnesota | Washington | 27163 | 2192 | 47 | 0 | 2145 | 45.03864533 | -92.88429635 | 2020-08-13 04:29:15 | Washington, Minnesota, US |
1919645 | 1919645 | 2020-08-10 | US | Texas | Starr | 48427 | 2246 | 68 | 0 | 2145 | 26.56150059 | -98.73892358 | 2020-08-11 04:35:08 | Starr, Texas, US |
3919786 | 3919786 | 2020-08-09 | US | Alaska | Anchorage | 2020 | 2159 | 14 | 0 | 2145 | 61.14998174 | -149.14269860000005 | 2020-08-10 04:34:55 | Anchorage, Alaska, US |
121509 | 121509 | 2020-07-19 | US | Wisconsin | Waukesha | 55133 | 2185 | 40 | 0 | 2145 | 43.01833055 | -88.30431188 | 2020-07-20 05:34:40 | Waukesha, Wisconsin, US |
120881 | 120881 | 2020-07-19 | US | Georgia | Richmond | 13245 | 2208 | 63 | 0 | 2145 | 33.35777107 | -82.07026432 | 2020-07-20 05:34:40 | Richmond, Georgia, US |
2746559 | 2746559 | 2020-07-15 | US | California | Merced | 6047 | 2158 | 12 | 0 | 2145 | 37.18922369 | -120.7209035 | 2020-07-16 04:44:59 | Merced, California, US |
3434365 | 3434365 | 2020-07-11 | US | Alabama | Madison | 1089 | 2154 | 9 | 0 | 2145 | 34.76327133 | -86.55069633 | 2020-07-12 04:34:30 | Madison, Alabama, 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]);