Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
This data as json, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: day
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 500084 | 500084 | 2020-08-11 | US | South Carolina | Allendale | 45005 | 232 | 5 | 0 | 227 | 32.98837386 | -81.35321066 | 2020-08-12 04:27:29 | Allendale, South Carolina, US |
| 500083 | 500083 | 2020-08-11 | US | Minnesota | Traverse | 27155 | 11 | 0 | 0 | 11 | 45.77298854 | -96.47062949 | 2020-08-12 04:27:29 | Traverse, Minnesota, US |
| 500082 | 500082 | 2020-08-11 | US | Minnesota | Steele | 27147 | 351 | 2 | 0 | 349 | 44.02240351 | -93.22627088 | 2020-08-12 04:27:29 | Steele, Minnesota, US |
| 500081 | 500081 | 2020-08-11 | US | Minnesota | Roseau | 27135 | 52 | 0 | 0 | 52 | 48.77501878 | -95.81079919 | 2020-08-12 04:27:29 | Roseau, Minnesota, US |
| 500080 | 500080 | 2020-08-11 | US | Minnesota | Red Lake | 27125 | 24 | 0 | 0 | 24 | 47.87197525 | -96.09561104 | 2020-08-12 04:27:29 | Red Lake, Minnesota, US |
| 500079 | 500079 | 2020-08-11 | US | Minnesota | Jackson | 27063 | 79 | 0 | 0 | 79 | 43.67423373 | -95.15398258 | 2020-08-12 04:27:29 | Jackson, Minnesota, US |
| 500078 | 500078 | 2020-08-11 | US | Minnesota | Hennepin | 27053 | 19569 | 839 | 0 | 18730 | 45.00761521 | -93.47694895 | 2020-08-12 04:27:29 | Hennepin, Minnesota, US |
| 500077 | 500077 | 2020-08-11 | Peru | Lima | 244520 | 9993 | 0 | 234527 | -11.766533 | -76.60449799999998 | 2020-08-12 04:27:29 | Lima, Peru | ||
| 500076 | 500076 | 2020-08-11 | Peru | Cusco | 6879 | 152 | 0 | 6727 | -13.191068 | -72.153609 | 2020-08-12 04:27:29 | Cusco, Peru | ||
| 500075 | 500075 | 2020-08-11 | US | Florida | Glades | 12043 | 406 | 3 | 0 | 403 | 26.95635849 | -81.18996211 | 2020-08-12 04:27:29 | Glades, Florida, US |
| 500074 | 500074 | 2020-08-11 | US | Florida | Monroe | 12087 | 1548 | 13 | 0 | 1535 | 25.20904673 | -81.07812416 | 2020-08-12 04:27:29 | Monroe, Florida, US |
| 500073 | 500073 | 2020-08-11 | US | Florida | Lee | 12071 | 16718 | 351 | 0 | 16367 | 26.58410348 | -81.88399313 | 2020-08-12 04:27:29 | Lee, Florida, US |
| 500072 | 500072 | 2020-08-11 | US | Florida | Polk | 12105 | 14645 | 326 | 0 | 14319 | 27.95027105 | -81.69732947 | 2020-08-12 04:27:29 | Polk, Florida, US |
| 500071 | 500071 | 2020-08-11 | US | Florida | Brevard | 12009 | 6190 | 157 | 0 | 6033 | 28.29409504 | -80.73091022 | 2020-08-12 04:27:29 | Brevard, Florida, US |
| 500070 | 500070 | 2020-08-11 | US | Florida | Bradford | 12007 | 519 | 4 | 0 | 515 | 29.95079741 | -82.16611613 | 2020-08-12 04:27:29 | Bradford, Florida, US |
| 500069 | 500069 | 2020-08-11 | US | Florida | Dixie | 12029 | 562 | 4 | 0 | 558 | 29.60631086 | -83.15724673 | 2020-08-12 04:27:29 | Dixie, Florida, US |
| 500068 | 500068 | 2020-08-11 | US | Florida | Bay | 12005 | 4523 | 52 | 0 | 4471 | 30.26548745 | -85.62122584 | 2020-08-12 04:27:29 | Bay, Florida, US |
| 500067 | 500067 | 2020-08-11 | US | Massachusetts | Middlesex | 25017 | 26565 | 2006 | 0 | 24559 | 42.48607732 | -71.39049229 | 2020-08-12 04:27:29 | Middlesex, Massachusetts, US |
| 500066 | 500066 | 2020-08-11 | Russia | Perm Krai | 6637 | 177 | 4722 | 1738 | 58.5951603 | 56.3159546 | 2020-08-12 04:27:29 | Perm Krai, Russia | ||
| 500065 | 500065 | 2020-08-11 | Russia | Chuvashia Republic | 7108 | 64 | 4450 | 2594 | 55.4259922 | 47.0849429 | 2020-08-12 04:27:29 | Chuvashia Republic, Russia | ||
| 500064 | 500064 | 2020-08-11 | Russia | Samara Oblast | 7320 | 110 | 5518 | 1692 | 53.2128813 | 50.8914633 | 2020-08-12 04:27:29 | Samara Oblast, Russia | ||
| 500063 | 500063 | 2020-08-11 | Russia | Orenburg Oblast | 8066 | 57 | 6399 | 1610 | 52.02692620000001 | 54.7276647 | 2020-08-12 04:27:29 | Orenburg Oblast, Russia | ||
| 500062 | 500062 | 2020-08-11 | Russia | Krasnodar Krai | 9465 | 132 | 8158 | 1175 | 45.7684014 | 39.0261044 | 2020-08-12 04:27:29 | Krasnodar Krai, Russia | ||
| 500061 | 500061 | 2020-08-11 | Russia | Altai Krai | 10185 | 95 | 8362 | 1728 | 52.6932243 | 82.69314240000001 | 2020-08-12 04:27:29 | Altai Krai, Russia | ||
| 500060 | 500060 | 2020-08-11 | Russia | Novosibirsk Oblast | 10334 | 292 | 8624 | 1418 | 54.9720169 | 79.48139240000002 | 2020-08-12 04:27:29 | Novosibirsk Oblast, Russia | ||
| 500059 | 500059 | 2020-08-11 | US | New Mexico | McKinley | 35031 | 4067 | 227 | 0 | 3840 | 35.58007720000001 | -108.262245 | 2020-08-12 04:27:29 | McKinley, New Mexico, US |
| 500058 | 500058 | 2020-08-11 | US | New Mexico | Lea | 35025 | 830 | 5 | 0 | 825 | 32.79215361 | -103.4123733 | 2020-08-12 04:27:29 | Lea, New Mexico, US |
| 500057 | 500057 | 2020-08-11 | US | New Mexico | Hidalgo | 35023 | 90 | 0 | 0 | 90 | 31.91383467 | -108.7151824 | 2020-08-12 04:27:29 | Hidalgo, New Mexico, US |
| 500056 | 500056 | 2020-08-11 | US | Tennessee | Hickman | 47081 | 272 | 0 | 0 | 272 | 35.80609681 | -87.47643507 | 2020-08-12 04:27:29 | Hickman, Tennessee, US |
| 500055 | 500055 | 2020-08-11 | Ukraine | Sevastopol* | 391 | 11 | 316 | 64 | 44.6054 | 33.522 | 2020-08-12 04:27:29 | Sevastopol*, Ukraine | ||
| 500054 | 500054 | 2020-08-11 | Ukraine | Odessa Oblast | 4364 | 73 | 1442 | 2849 | 46.4846 | 30.7326 | 2020-08-12 04:27:29 | Odessa Oblast, Ukraine | ||
| 500053 | 500053 | 2020-08-11 | Brazil | Tocantins | 32289 | 461 | 19845 | 11983 | -10.1753 | -48.2982 | 2020-08-12 04:27:29 | Tocantins, Brazil | ||
| 500052 | 500052 | 2020-08-11 | Brazil | Espirito Santo | 93069 | 2764 | 80509 | 9796 | -19.1834 | -40.3089 | 2020-08-12 04:27:29 | Espirito Santo, Brazil | ||
| 500051 | 500051 | 2020-08-11 | Brazil | Distrito Federal | 126069 | 1762 | 109598 | 14709 | -15.7998 | -47.8645 | 2020-08-12 04:27:29 | Distrito Federal, Brazil | ||
| 500050 | 500050 | 2020-08-11 | Brazil | Ceara | 188657 | 7979 | 162744 | 17934 | -5.4984 | -39.3206 | 2020-08-12 04:27:29 | Ceara, Brazil | ||
| 500049 | 500049 | 2020-08-11 | US | New Jersey | Unassigned | 90034 | 660 | 0 | 0 | 660 | 41.13891592 | 0.0 | 2020-08-12 04:27:29 | Unassigned, New Jersey, US |
| 500048 | 500048 | 2020-08-11 | US | New Jersey | Gloucester | 34015 | 3283 | 213 | 0 | 3070 | 39.71581067 | -75.13995546 | 2020-08-12 04:27:29 | Gloucester, New Jersey, US |
| 500047 | 500047 | 2020-08-11 | US | New Jersey | Bergen | 34003 | 20864 | 2038 | 0 | 18826 | 40.96010917 | -74.07164325 | 2020-08-12 04:27:29 | Bergen, New Jersey, US |
| 500046 | 500046 | 2020-08-11 | United Kingdom | Falkland Islands (Malvinas) | 13 | 0 | 13 | 0 | -51.7963 | -59.5236 | 2020-08-12 04:27:29 | Falkland Islands (Malvinas), United Kingdom | ||
| 500045 | 500045 | 2020-08-11 | Grenada | 24 | 0 | 23 | 1 | 12.1165 | -61.679 | 2020-08-12 04:27:29 | Grenada | |||
| 500044 | 500044 | 2020-08-11 | US | Louisiana | Washington | 22117 | 1293 | 58 | 0 | 1235 | 30.85288548 | -90.03866652 | 2020-08-12 04:27:29 | Washington, Louisiana, US |
| 500043 | 500043 | 2020-08-11 | US | Louisiana | Tensas | 22107 | 91 | 0 | 0 | 91 | 32.00760749 | -91.32915234 | 2020-08-12 04:27:29 | Tensas, Louisiana, US |
| 500042 | 500042 | 2020-08-11 | US | Louisiana | St. Helena | 22091 | 275 | 2 | 0 | 273 | 30.82210324 | -90.71013176 | 2020-08-12 04:27:29 | St. Helena, Louisiana, US |
| 500041 | 500041 | 2020-08-11 | US | Louisiana | Richland | 22083 | 604 | 8 | 0 | 596 | 32.41391005 | -91.76634876 | 2020-08-12 04:27:29 | Richland, Louisiana, US |
| 500040 | 500040 | 2020-08-11 | US | Louisiana | Pointe Coupee | 22077 | 810 | 32 | 0 | 778 | 30.71409502 | -91.60209535 | 2020-08-12 04:27:29 | Pointe Coupee, Louisiana, US |
| 500039 | 500039 | 2020-08-11 | US | Louisiana | Madison | 22065 | 618 | 6 | 0 | 612 | 32.36918118 | -91.23973355 | 2020-08-12 04:27:29 | Madison, Louisiana, US |
| 500038 | 500038 | 2020-08-11 | US | Louisiana | Lincoln | 22061 | 806 | 31 | 0 | 775 | 32.6003154 | -92.6659741 | 2020-08-12 04:27:29 | Lincoln, Louisiana, US |
| 500037 | 500037 | 2020-08-11 | US | Louisiana | Iberia | 22045 | 2561 | 73 | 0 | 2488 | 29.86803617 | -91.75871777 | 2020-08-12 04:27:29 | Iberia, Louisiana, US |
| 500036 | 500036 | 2020-08-11 | US | Louisiana | Franklin | 22041 | 940 | 19 | 0 | 921 | 32.13675181 | -91.67589857 | 2020-08-12 04:27:29 | Franklin, Louisiana, US |
| 500035 | 500035 | 2020-08-11 | US | Nevada | Unassigned | 90032 | 0 | 0 | 0 | 0 | 41.40692186 | 0.0 | 2020-08-12 04:27:29 | Unassigned, Nevada, US |
| 500034 | 500034 | 2020-08-11 | US | Nevada | Nye | 32023 | 408 | 9 | 0 | 399 | 38.04264256 | -116.4722702 | 2020-08-12 04:27:29 | Nye, Nevada, US |
| 500033 | 500033 | 2020-08-11 | US | Nevada | Mineral | 32021 | 11 | 0 | 0 | 11 | 38.53841696 | -118.4344506 | 2020-08-12 04:27:29 | Mineral, Nevada, US |
| 500032 | 500032 | 2020-08-11 | US | Nevada | Humboldt | 32013 | 104 | 4 | 0 | 100 | 41.40692186 | -118.1109427 | 2020-08-12 04:27:29 | Humboldt, Nevada, US |
| 500031 | 500031 | 2020-08-11 | US | Nevada | Carson City | 32510 | 357 | 8 | 0 | 349 | 39.15509045 | -119.7480219 | 2020-08-12 04:27:29 | Carson City, Nevada, US |
| 500030 | 500030 | 2020-08-11 | US | Ohio | Gallia | 39053 | 70 | 1 | 0 | 69 | 38.82708533 | -82.31647569 | 2020-08-12 04:27:29 | Gallia, Ohio, US |
| 500029 | 500029 | 2020-08-11 | US | Ohio | Carroll | 39019 | 113 | 5 | 0 | 108 | 40.5789686 | -81.09178213 | 2020-08-12 04:27:29 | Carroll, Ohio, US |
| 500028 | 500028 | 2020-08-11 | US | Ohio | Auglaize | 39011 | 263 | 6 | 0 | 257 | 40.55998859 | -84.22421429999999 | 2020-08-12 04:27:29 | Auglaize, Ohio, US |
| 500027 | 500027 | 2020-08-11 | US | Ohio | Brown | 39015 | 146 | 2 | 0 | 144 | 38.93416837 | -83.86788395 | 2020-08-12 04:27:29 | Brown, Ohio, US |
| 500026 | 500026 | 2020-08-11 | US | Ohio | Hocking | 39073 | 118 | 9 | 0 | 109 | 39.49537927 | -82.47991446 | 2020-08-12 04:27:29 | Hocking, Ohio, US |
| 500025 | 500025 | 2020-08-11 | US | Ohio | Lucas | 39095 | 5448 | 326 | 0 | 5122 | 41.62101218 | -83.65468618 | 2020-08-12 04:27:29 | Lucas, Ohio, US |
| 500024 | 500024 | 2020-08-11 | US | Ohio | Noble | 39121 | 16 | 0 | 0 | 16 | 39.76818851 | -81.45937183 | 2020-08-12 04:27:29 | Noble, Ohio, US |
| 500023 | 500023 | 2020-08-11 | US | Ohio | Morgan | 39115 | 30 | 0 | 0 | 30 | 39.62081738 | -81.85308173 | 2020-08-12 04:27:29 | Morgan, Ohio, US |
| 500022 | 500022 | 2020-08-11 | US | Ohio | Scioto | 39145 | 242 | 1 | 0 | 241 | 38.80270163 | -82.98907345 | 2020-08-12 04:27:29 | Scioto, Ohio, US |
| 500021 | 500021 | 2020-08-11 | US | Ohio | Henry | 39069 | 122 | 2 | 0 | 120 | 41.3339642 | -84.06830637 | 2020-08-12 04:27:29 | Henry, Ohio, US |
| 500020 | 500020 | 2020-08-11 | US | Ohio | Monroe | 39111 | 94 | 18 | 0 | 76 | 39.72984936 | -81.08464734 | 2020-08-12 04:27:29 | Monroe, Ohio, US |
| 500019 | 500019 | 2020-08-11 | US | Ohio | Preble | 39135 | 207 | 2 | 0 | 205 | 39.7420247 | -84.64787018 | 2020-08-12 04:27:29 | Preble, Ohio, US |
| 500018 | 500018 | 2020-08-11 | US | Ohio | Delaware | 39041 | 1344 | 19 | 0 | 1325 | 40.27942393 | -83.00457058 | 2020-08-12 04:27:29 | Delaware, Ohio, US |
| 500017 | 500017 | 2020-08-11 | US | Ohio | Meigs | 39105 | 54 | 0 | 0 | 54 | 39.09224872 | -82.0305041 | 2020-08-12 04:27:29 | Meigs, Ohio, US |
| 500016 | 500016 | 2020-08-11 | US | Ohio | Ross | 39141 | 494 | 4 | 0 | 490 | 39.33705391 | -83.06000914 | 2020-08-12 04:27:29 | Ross, Ohio, US |
| 500015 | 500015 | 2020-08-11 | US | Wisconsin | Milwaukee | 55079 | 21331 | 458 | 0 | 20873 | 43.00486062 | -87.96733172 | 2020-08-12 04:27:29 | Milwaukee, Wisconsin, US |
| 500014 | 500014 | 2020-08-11 | US | Wisconsin | Dane | 55025 | 4578 | 38 | 0 | 4540 | 43.06601594 | -89.41733797 | 2020-08-12 04:27:29 | Dane, Wisconsin, US |
| 500013 | 500013 | 2020-08-11 | US | Wisconsin | Brown | 55009 | 4340 | 54 | 0 | 4286 | 44.4526553 | -88.00411844 | 2020-08-12 04:27:29 | Brown, Wisconsin, US |
| 500012 | 500012 | 2020-08-11 | US | Wisconsin | Washington | 55131 | 1108 | 22 | 0 | 1086 | 43.36863664 | -88.22974712 | 2020-08-12 04:27:29 | Washington, Wisconsin, US |
| 500011 | 500011 | 2020-08-11 | US | Wisconsin | Marathon | 55073 | 662 | 10 | 0 | 652 | 44.89792533 | -89.75863384 | 2020-08-12 04:27:29 | Marathon, Wisconsin, US |
| 500010 | 500010 | 2020-08-11 | US | Wisconsin | Marinette | 55075 | 432 | 4 | 0 | 428 | 45.38553432 | -88.03324599999998 | 2020-08-12 04:27:29 | Marinette, Wisconsin, US |
| 500009 | 500009 | 2020-08-11 | US | Wisconsin | Oconto | 55083 | 259 | 0 | 0 | 259 | 45.02715345 | -88.26807503 | 2020-08-12 04:27:29 | Oconto, Wisconsin, US |
| 500008 | 500008 | 2020-08-11 | US | Wisconsin | Lafayette | 55065 | 147 | 0 | 0 | 147 | 42.66005229 | -90.1317729 | 2020-08-12 04:27:29 | Lafayette, Wisconsin, US |
| 500007 | 500007 | 2020-08-11 | US | Wisconsin | Langlade | 55067 | 63 | 1 | 0 | 62 | 45.26271619 | -89.07483625 | 2020-08-12 04:27:29 | Langlade, Wisconsin, US |
| 500006 | 500006 | 2020-08-11 | US | Missouri | Texas | 29215 | 57 | 0 | 0 | 57 | 37.31728859 | -91.96564727 | 2020-08-12 04:27:29 | Texas, Missouri, US |
| 500005 | 500005 | 2020-08-11 | US | Missouri | Buchanan | 29021 | 1092 | 10 | 0 | 1082 | 39.65816401 | -94.80138942 | 2020-08-12 04:27:29 | Buchanan, Missouri, US |
| 500004 | 500004 | 2020-08-11 | US | Missouri | St. Francois | 29187 | 392 | 2 | 0 | 390 | 37.81214171 | -90.47598685 | 2020-08-12 04:27:29 | St. Francois, Missouri, US |
| 500003 | 500003 | 2020-08-11 | US | Minnesota | Goodhue | 27049 | 199 | 9 | 0 | 190 | 44.40849741 | -92.7234195 | 2020-08-12 04:27:29 | Goodhue, Minnesota, US |
| 500002 | 500002 | 2020-08-11 | US | Minnesota | Faribault | 27043 | 89 | 0 | 0 | 89 | 43.67381499 | -93.94787458 | 2020-08-12 04:27:29 | Faribault, Minnesota, US |
| 500001 | 500001 | 2020-08-11 | US | Minnesota | Clearwater | 27029 | 14 | 0 | 0 | 14 | 47.57992111 | -95.37790562 | 2020-08-12 04:27:29 | Clearwater, Minnesota, US |
| 500000 | 500000 | 2020-08-11 | US | Minnesota | Clay | 27027 | 788 | 40 | 0 | 748 | 46.89289518 | -96.48761922 | 2020-08-12 04:27:29 | Clay, Minnesota, US |
| 499999 | 499999 | 2020-08-11 | US | Minnesota | Cass | 27021 | 74 | 2 | 0 | 72 | 46.95043611 | -94.32603968 | 2020-08-12 04:27:29 | Cass, Minnesota, US |
| 499998 | 499998 | 2020-08-11 | US | Minnesota | Benton | 27009 | 320 | 3 | 0 | 317 | 45.69804958 | -93.99514135 | 2020-08-12 04:27:29 | Benton, Minnesota, US |
| 499997 | 499997 | 2020-08-11 | US | Minnesota | Anoka | 27003 | 3752 | 115 | 0 | 3637 | 45.27476015 | -93.24604565 | 2020-08-12 04:27:29 | Anoka, Minnesota, US |
| 499996 | 499996 | 2020-08-11 | Peru | Unknown | 0 | 0 | 329404 | -329404 | 2020-08-12 04:27:29 | Unknown, Peru | ||||
| 499995 | 499995 | 2020-08-11 | Peru | Ancash | 14068 | 889 | 0 | 13179 | -9.407125 | -77.67179499999997 | 2020-08-12 04:27:29 | Ancash, Peru | ||
| 499994 | 499994 | 2020-08-11 | US | Florida | Collier | 12021 | 10487 | 143 | 0 | 10344 | 26.11091986 | -81.34687065 | 2020-08-12 04:27:29 | Collier, Florida, US |
| 499993 | 499993 | 2020-08-11 | US | Florida | Wakulla | 12129 | 726 | 5 | 0 | 721 | 30.16548905 | -84.39895211 | 2020-08-12 04:27:29 | Wakulla, Florida, US |
| 499992 | 499992 | 2020-08-11 | US | Florida | Lafayette | 12067 | 189 | 2 | 0 | 187 | 29.98484137 | -83.18166636 | 2020-08-12 04:27:29 | Lafayette, Florida, US |
| 499991 | 499991 | 2020-08-11 | US | Florida | Seminole | 12117 | 7219 | 130 | 0 | 7089 | 28.7158582 | -81.24060348 | 2020-08-12 04:27:29 | Seminole, Florida, US |
| 499990 | 499990 | 2020-08-11 | US | Florida | Martin | 12085 | 3852 | 99 | 0 | 3753 | 27.0772071 | -80.43109784 | 2020-08-12 04:27:29 | Martin, Florida, US |
| 499989 | 499989 | 2020-08-11 | US | Florida | Pasco | 12101 | 7172 | 131 | 0 | 7041 | 28.30810945 | -82.40227529 | 2020-08-12 04:27:29 | Pasco, Florida, US |
| 499988 | 499988 | 2020-08-11 | US | Florida | Okaloosa | 12091 | 3587 | 45 | 0 | 3542 | 30.69143028 | -86.59267105 | 2020-08-12 04:27:29 | Okaloosa, Florida, US |
| 499987 | 499987 | 2020-08-11 | US | Massachusetts | Unassigned | 90025 | 326 | 6 | 0 | 320 | 42.6687626 | 0.0 | 2020-08-12 04:27:29 | Unassigned, Massachusetts, US |
| 499986 | 499986 | 2020-08-11 | US | Massachusetts | Worcester | 25027 | 13686 | 1007 | 0 | 12679 | 42.35026951 | -71.90493363 | 2020-08-12 04:27:29 | Worcester, Massachusetts, US |
| 499985 | 499985 | 2020-08-11 | US | Massachusetts | Bristol | 25005 | 9408 | 637 | 0 | 8771 | 41.79228404 | -71.10872211 | 2020-08-12 04:27:29 | Bristol, Massachusetts, US |
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] INTEGER,
[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]);