johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
397 rows where active = 591 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3299812 | 3299812 | 2021-07-30 | Ukraine | Lviv Oblast | 138116 | 3686 | 133839 | 591 | 49.8397 | 24.0297 | 2021-07-31 04:21:35 | Lviv Oblast, Ukraine | ||
400057 | 400057 | 2021-06-29 | Chile | Nuble | 33939 | 565 | 32783 | 591 | -36.7226 | -71.7622 | 2021-06-30 04:21:41 | Nuble, Chile | ||
3358589 | 3358589 | 2021-06-21 | Germany | Sachsen-Anhalt | 99177 | 3414 | 95210 | 591 | 51.9503 | 11.6923 | 2021-06-22 04:21:34 | Sachsen-Anhalt, Germany | ||
2911384 | 2911384 | 2021-06-17 | Russia | Khakassia Republic | 23816 | 565 | 22660 | 591 | 53.72258845 | 91.44293627 | 2021-06-18 04:22:16 | Khakassia Republic, Russia | ||
2315152 | 2315152 | 2021-06-04 | Colombia | La Guajira | 36757 | 1157 | 35009 | 591 | 11.3548 | -72.5205 | 2021-06-05 04:23:03 | La Guajira, Colombia | ||
1956128 | 1956128 | 2021-05-21 | Uganda | 43370 | 350 | 42429 | 591 | 1.373333 | 32.290275 | 2021-05-22 04:20:45 | Uganda | |||
1872969 | 1872969 | 2021-05-15 | Japan | Ibaraki | 8946 | 137 | 8218 | 591 | 36.303588 | 140.319591 | 2021-05-16 04:20:49 | Ibaraki, Japan | ||
2824795 | 2824795 | 2021-05-01 | Japan | Hiroshima | 6082 | 110 | 5381 | 591 | 34.605309000000005 | 132.788719 | 2021-05-02 04:20:48 | Hiroshima, Japan | ||
1636566 | 1636566 | 2021-04-29 | Russia | Tomsk Oblast | 32101 | 395 | 31115 | 591 | 58.6124279 | 82.04753149999998 | 2021-04-30 04:21:03 | Tomsk Oblast, Russia | ||
3924042 | 3924042 | 2021-04-24 | Japan | Okayama | 3536 | 38 | 2907 | 591 | 34.89246 | 133.826252 | 2021-04-25 04:20:32 | Okayama, Japan | ||
2247249 | 2247249 | 2021-04-07 | Colombia | Norte de Santander | 52322 | 2773 | 48958 | 591 | 7.9463 | -72.8988 | 2021-04-08 04:21:13 | Norte de Santander, Colombia | ||
3003559 | 3003559 | 2021-04-06 | Russia | Tyva Republic | 15770 | 200 | 14979 | 591 | 51.4017149 | 93.8582593 | 2021-04-07 04:20:53 | Tyva Republic, Russia | ||
388077 | 388077 | 2021-04-04 | Colombia | Norte de Santander | 52127 | 2769 | 48767 | 591 | 7.9463 | -72.8988 | 2021-04-05 04:20:35 | Norte de Santander, Colombia | ||
3643389 | 3643389 | 2021-03-30 | Colombia | Bolivar | 69458 | 1406 | 67461 | 591 | 8.6704 | -74.03 | 2021-03-31 04:26:25 | Bolivar, Colombia | ||
3670778 | 3670778 | 2021-03-06 | US | Texas | Martin | 48317 | 565 | 18 | 0 | 591 | 32.30600051 | -101.9513518 | 2021-03-07 05:21:54 | Martin, Texas, US |
3670746 | 3670746 | 2021-03-06 | US | Texas | Jim Hogg | 48247 | 684 | 14 | 0 | 591 | 27.04453923 | -98.6968187 | 2021-03-07 05:21:54 | Jim Hogg, Texas, US |
3669910 | 3669910 | 2021-03-06 | US | North Carolina | Camden | 37029 | 596 | 5 | 0 | 591 | 36.33804939 | -76.15568396 | 2021-03-07 05:21:54 | Camden, North Carolina, US |
3669171 | 3669171 | 2021-03-06 | US | Maine | Lincoln | 23015 | 593 | 2 | 0 | 591 | 44.05996956 | -69.54227124 | 2021-03-07 05:21:54 | Lincoln, Maine, US |
1619367 | 1619367 | 2021-03-05 | US | Texas | Jim Hogg | 48247 | 684 | 14 | 0 | 591 | 27.04453923 | -98.6968187 | 2021-03-06 04:23:41 | Jim Hogg, Texas, US |
1618337 | 1618337 | 2021-03-05 | US | Nebraska | Nemaha | 31127 | 604 | 13 | 0 | 591 | 40.38514847 | -95.85433992 | 2021-03-06 04:23:41 | Nemaha, Nebraska, US |
1092953 | 1092953 | 2021-03-03 | US | South Dakota | Lyman | 46085 | 601 | 10 | 0 | 591 | 43.89522709 | -99.85201878 | 2021-03-04 05:24:24 | Lyman, South Dakota, US |
998628 | 998628 | 2021-03-01 | Russia | Bryansk Oblast | 32993 | 257 | 32145 | 591 | 52.8873315 | 33.41585300000001 | 2021-03-02 05:23:30 | Bryansk Oblast, Russia | ||
2370259 | 2370259 | 2021-02-28 | US | Puerto Rico | Quebradillas | 72115 | 591 | 0 | 0 | 591 | 18.439692 | -66.926113 | 2021-03-01 05:23:01 | Quebradillas, Puerto Rico, US |
2367290 | 2367290 | 2021-02-28 | Chile | Nuble | 16916 | 322 | 16003 | 591 | -36.7226 | -71.7622 | 2021-03-01 05:23:01 | Nuble, Chile | ||
1861201 | 1861201 | 2021-02-25 | US | Texas | Refugio | 48391 | 650 | 17 | 0 | 591 | 28.3238976 | -97.15766311 | 2021-02-26 05:22:40 | Refugio, Texas, US |
279966 | 279966 | 2021-02-24 | Chile | Arica y Parinacota | 14862 | 286 | 13985 | 591 | -18.594 | -69.4785 | 2021-02-25 05:24:57 | Arica y Parinacota, Chile | ||
1155162 | 1155162 | 2021-02-18 | US | Nebraska | Burt | 31021 | 601 | 10 | 0 | 591 | 41.85056773 | -96.32605633 | 2021-02-19 05:24:16 | Burt, Nebraska, US |
1154460 | 1154460 | 2021-02-18 | US | Kansas | Sherman | 20181 | 602 | 11 | 0 | 591 | 39.35147699 | -101.7197624 | 2021-02-19 05:24:16 | Sherman, Kansas, US |
1152977 | 1152977 | 2021-02-18 | Colombia | Quindio | 31441 | 918 | 29932 | 591 | 4.461 | -75.6674 | 2021-02-19 05:24:16 | Quindio, Colombia | ||
3604543 | 3604543 | 2021-02-17 | US | West Virginia | Ritchie | 54085 | 600 | 9 | 0 | 591 | 39.18094587 | -81.06356878 | 2021-02-18 05:22:58 | Ritchie, West Virginia, US |
3602380 | 3602380 | 2021-02-17 | US | Kansas | Sherman | 20181 | 602 | 11 | 0 | 591 | 39.35147699 | -101.7197624 | 2021-02-18 05:22:58 | Sherman, Kansas, US |
3049960 | 3049960 | 2021-02-16 | Chile | Arica y Parinacota | 14228 | 277 | 13360 | 591 | -18.594 | -69.4785 | 2021-02-17 05:23:10 | Arica y Parinacota, Chile | ||
1340128 | 1340128 | 2021-02-15 | US | Mississippi | Wilkinson | 28157 | 617 | 26 | 0 | 591 | 31.16078225 | -91.31018819 | 2021-02-16 05:24:38 | Wilkinson, Mississippi, US |
2285279 | 2285279 | 2021-02-14 | US | Mississippi | Wilkinson | 28157 | 617 | 26 | 0 | 591 | 31.16078225 | -91.31018819 | 2021-02-15 05:24:49 | Wilkinson, Mississippi, US |
2679679 | 2679679 | 2021-02-13 | US | Mississippi | Wilkinson | 28157 | 617 | 26 | 0 | 591 | 31.16078225 | -91.31018819 | 2021-02-14 05:23:43 | Wilkinson, Mississippi, US |
2638249 | 2638249 | 2021-02-11 | US | Arkansas | Woodruff | 5147 | 599 | 8 | 0 | 591 | 35.18902527 | -91.2439489 | 2021-02-12 05:23:29 | Woodruff, Arkansas, US |
1591671 | 1591671 | 2021-02-05 | US | West Virginia | Pendleton | 54071 | 595 | 4 | 0 | 591 | 38.68314479 | -79.35084086 | 2021-02-06 05:23:55 | Pendleton, West Virginia, US |
1590497 | 1590497 | 2021-02-05 | US | North Carolina | Hyde | 37095 | 597 | 6 | 0 | 591 | 35.42017674 | -76.15180542 | 2021-02-06 05:23:55 | Hyde, North Carolina, US |
792704 | 792704 | 2021-02-04 | US | North Carolina | Hyde | 37095 | 597 | 6 | 0 | 591 | 35.42017674 | -76.15180542 | 2021-02-05 05:22:38 | Hyde, North Carolina, US |
342600 | 342600 | 2021-02-03 | US | North Carolina | Jones | 37103 | 607 | 16 | 0 | 591 | 35.02254606 | -77.35870791 | 2021-02-04 05:22:26 | Jones, North Carolina, US |
1463140 | 1463140 | 2021-01-31 | US | Virginia | Poquoson | 51735 | 599 | 8 | 0 | 591 | 37.14259351 | -76.35798148 | 2021-02-01 05:22:53 | Poquoson, Virginia, US |
1462054 | 1462054 | 2021-01-31 | US | North Carolina | Clay | 37043 | 596 | 5 | 0 | 591 | 35.05704275 | -83.74353633 | 2021-02-01 05:22:53 | Clay, North Carolina, US |
1461089 | 1461089 | 2021-01-31 | US | Kansas | Rooks | 20163 | 602 | 11 | 0 | 591 | 39.35022773 | -99.32484567 | 2021-02-01 05:22:53 | Rooks, Kansas, US |
2212997 | 2212997 | 2021-01-30 | US | Kansas | Rooks | 20163 | 602 | 11 | 0 | 591 | 39.35022773 | -99.32484567 | 2021-01-31 05:22:42 | Rooks, Kansas, US |
1900526 | 1900526 | 2021-01-29 | US | Virginia | Northampton | 51131 | 624 | 33 | 0 | 591 | 37.34062933 | -75.87751591 | 2021-01-30 05:22:49 | Northampton, Virginia, US |
1898484 | 1898484 | 2021-01-29 | US | Kansas | Rooks | 20163 | 602 | 11 | 0 | 591 | 39.35022773 | -99.32484567 | 2021-01-30 05:22:49 | Rooks, Kansas, US |
2484844 | 2484844 | 2021-01-28 | US | South Dakota | Kingsbury | 46077 | 604 | 13 | 0 | 591 | 44.36956169 | -97.4913945 | 2021-01-29 05:22:23 | Kingsbury, South Dakota, US |
2483318 | 2483318 | 2021-01-28 | US | Kansas | Wabaunsee | 20197 | 603 | 12 | 0 | 591 | 38.95471985 | -96.20350509 | 2021-01-29 05:22:23 | Wabaunsee, Kansas, US |
2482914 | 2482914 | 2021-01-28 | US | Idaho | Power | 16077 | 597 | 6 | 0 | 591 | 42.69254894 | -112.83957420000002 | 2021-01-29 05:22:23 | Power, Idaho, US |
3156913 | 3156913 | 2021-01-27 | US | Virginia | Charlotte | 51037 | 601 | 10 | 0 | 591 | 37.01909701 | -78.66314092 | 2021-01-28 05:22:24 | Charlotte, Virginia, US |
3156902 | 3156902 | 2021-01-27 | US | Virginia | Bland | 51021 | 599 | 8 | 0 | 591 | 37.13128068 | -81.13599391 | 2021-01-28 05:22:24 | Bland, Virginia, US |
3155163 | 3155163 | 2021-01-27 | US | Maine | Washington | 23029 | 600 | 9 | 0 | 591 | 45.01607142 | -67.62813524 | 2021-01-28 05:22:24 | Washington, Maine, US |
3154953 | 3154953 | 2021-01-27 | US | Kansas | Wabaunsee | 20197 | 603 | 12 | 0 | 591 | 38.95471985 | -96.20350509 | 2021-01-28 05:22:24 | Wabaunsee, Kansas, US |
3154549 | 3154549 | 2021-01-27 | US | Idaho | Power | 16077 | 597 | 6 | 0 | 591 | 42.69254894 | -112.83957420000002 | 2021-01-28 05:22:24 | Power, Idaho, US |
2568898 | 2568898 | 2021-01-25 | US | Iowa | Taylor | 19173 | 600 | 9 | 0 | 591 | 40.73710579 | -94.69778563 | 2021-01-26 05:22:02 | Taylor, Iowa, US |
1760559 | 1760559 | 2021-01-24 | US | Kansas | Coffey | 20031 | 605 | 14 | 0 | 591 | 38.2365018 | -95.73379515 | 2021-01-25 05:22:16 | Coffey, Kansas, US |
1759887 | 1759887 | 2021-01-24 | US | Colorado | Archuleta | 8007 | 609 | 1 | 0 | 591 | 37.19474156 | -107.0476867 | 2021-01-25 05:22:16 | Archuleta, Colorado, US |
2428327 | 2428327 | 2021-01-23 | US | Kentucky | Livingston | 21139 | 606 | 15 | 0 | 591 | 37.21137452 | -88.34797529 | 2021-01-24 05:22:35 | Livingston, Kentucky, US |
2428166 | 2428166 | 2021-01-23 | US | Kansas | Coffey | 20031 | 605 | 14 | 0 | 591 | 38.2365018 | -95.73379515 | 2021-01-24 05:22:35 | Coffey, Kansas, US |
2427494 | 2427494 | 2021-01-23 | US | Colorado | Archuleta | 8007 | 607 | 1 | 0 | 591 | 37.19474156 | -107.0476867 | 2021-01-24 05:22:35 | Archuleta, Colorado, US |
2468068 | 2468068 | 2021-01-22 | US | Kansas | Coffey | 20031 | 605 | 14 | 0 | 591 | 38.2365018 | -95.73379515 | 2021-01-23 05:22:03 | Coffey, Kansas, US |
2467725 | 2467725 | 2021-01-22 | US | Idaho | Caribou | 16029 | 602 | 11 | 0 | 591 | 42.77149116 | -111.5597683 | 2021-01-23 05:22:03 | Caribou, Idaho, US |
435366 | 435366 | 2021-01-21 | Japan | Hiroshima | 4533 | 79 | 3863 | 591 | 34.605309000000005 | 132.788719 | 2021-01-22 05:22:10 | Hiroshima, Japan | ||
1095956 | 1095956 | 2021-01-20 | US | Missouri | Caldwell | 29025 | 599 | 8 | 0 | 591 | 39.65620858 | -93.98308093 | 2021-01-21 05:22:01 | Caldwell, Missouri, US |
911775 | 911775 | 2021-01-19 | US | Wyoming | Johnson | 56019 | 600 | 9 | 0 | 591 | 44.04057166 | -106.5845174 | 2021-01-20 05:21:54 | Johnson, Wyoming, US |
910046 | 910046 | 2021-01-19 | US | Missouri | Caldwell | 29025 | 599 | 8 | 0 | 591 | 39.65620858 | -93.98308093 | 2021-01-20 05:21:54 | Caldwell, Missouri, US |
240684 | 240684 | 2021-01-18 | US | Washington | Pacific | 53049 | 599 | 8 | 0 | 591 | 46.55418369 | -123.7285716 | 2021-01-19 05:22:15 | Pacific, Washington, US |
3506801 | 3506801 | 2021-01-17 | US | Washington | Pacific | 53049 | 599 | 8 | 0 | 591 | 46.55418369 | -123.7285716 | 2021-01-18 05:22:34 | Pacific, Washington, US |
3517582 | 3517582 | 2021-01-15 | US | New Mexico | Colfax | 35007 | 619 | 28 | 0 | 591 | 36.60569702 | -104.64726740000002 | 2021-01-16 05:22:40 | Colfax, New Mexico, US |
3516648 | 3516648 | 2021-01-15 | US | Iowa | Worth | 19195 | 594 | 3 | 0 | 591 | 43.37750768 | -93.26087602 | 2021-01-16 05:22:40 | Worth, Iowa, US |
777423 | 777423 | 2021-01-12 | US | Texas | Floyd | 48153 | 838 | 25 | 0 | 591 | 34.07227468 | -101.3031546 | 2021-01-13 05:22:15 | Floyd, Texas, US |
776426 | 776426 | 2021-01-12 | US | Nebraska | Kearney | 31099 | 595 | 4 | 0 | 591 | 40.50663314 | -98.94877182 | 2021-01-13 05:22:15 | Kearney, Nebraska, US |
774463 | 774463 | 2021-01-12 | Netherlands | Aruba | 6154 | 52 | 5511 | 591 | 12.5211 | -69.9683 | 2021-01-13 05:22:15 | Aruba, Netherlands | ||
192843 | 192843 | 2021-01-11 | US | Puerto Rico | Utuado | 72141 | 591 | 0 | 0 | 591 | 18.271214 | -66.702984 | 2021-01-12 05:22:15 | Utuado, Puerto Rico, US |
156845 | 156845 | 2021-01-08 | US | South Dakota | Hamlin | 46057 | 627 | 36 | 0 | 591 | 44.67385954 | -97.18829593 | 2021-01-09 05:22:18 | Hamlin, South Dakota, US |
154876 | 154876 | 2021-01-08 | US | Georgia | Wilcox | 13315 | 628 | 37 | 0 | 591 | 31.97496928 | -83.43438555 | 2021-01-09 05:22:18 | Wilcox, Georgia, US |
2543962 | 2543962 | 2021-01-07 | US | Oklahoma | Latimer | 40077 | 597 | 6 | 0 | 591 | 34.87844729 | -95.25215049 | 2021-01-08 05:22:42 | Latimer, Oklahoma, US |
2865619 | 2865619 | 2021-01-06 | US | Hawaii | Out of HI | 80015 | 593 | 2 | 0 | 591 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Out of HI, Hawaii, US |
1062349 | 1062349 | 2021-01-04 | US | Arkansas | Nevada | 5099 | 611 | 20 | 0 | 591 | 33.66340119 | -93.30632432 | 2021-01-05 05:21:49 | Nevada, Arkansas, US |
3230142 | 3230142 | 2021-01-03 | Andorra | 8192 | 84 | 7517 | 591 | 42.5063 | 1.5218 | 2021-01-04 05:22:02 | Andorra | |||
1140488 | 1140488 | 2021-01-01 | US | Wyoming | Sublette | 56035 | 597 | 6 | 0 | 591 | 42.76558279 | -109.9130922 | 2021-01-02 05:22:33 | Sublette, Wyoming, US |
1137950 | 1137950 | 2021-01-01 | US | Indiana | Crawford | 18025 | 602 | 11 | 0 | 591 | 38.28814402 | -86.44518825 | 2021-01-02 05:22:33 | Crawford, Indiana, US |
1137866 | 1137866 | 2021-01-01 | US | Illinois | Hamilton | 17065 | 601 | 10 | 0 | 591 | 38.08163641 | -88.53883373 | 2021-01-02 05:22:33 | Hamilton, Illinois, US |
3699094 | 3699094 | 2020-12-31 | US | Wyoming | Sublette | 56035 | 597 | 6 | 0 | 591 | 42.76558279 | -109.9130922 | 2021-01-01 05:23:07 | Sublette, Wyoming, US |
3696472 | 3696472 | 2020-12-31 | US | Illinois | Hamilton | 17065 | 601 | 10 | 0 | 591 | 38.08163641 | -88.53883373 | 2021-01-01 05:23:07 | Hamilton, Illinois, US |
1013637 | 1013637 | 2020-12-30 | US | Virginia | Giles | 51071 | 593 | 2 | 0 | 591 | 37.31234791 | -80.70636931 | 2020-12-31 05:22:49 | Giles, Virginia, US |
3781238 | 3781238 | 2020-12-27 | US | Virginia | Goochland | 51075 | 598 | 7 | 0 | 591 | 37.71714806 | -77.90381514 | 2020-12-28 05:22:06 | Goochland, Virginia, US |
3778798 | 3778798 | 2020-12-27 | US | Georgia | Wilkes | 13317 | 601 | 10 | 0 | 591 | 33.78290391 | -82.74286107 | 2020-12-28 05:22:06 | Wilkes, Georgia, US |
2224403 | 2224403 | 2020-12-26 | US | Georgia | Wilkes | 13317 | 601 | 10 | 0 | 591 | 33.78290391 | -82.74286107 | 2020-12-27 05:22:55 | Wilkes, Georgia, US |
204614 | 204614 | 2020-12-25 | US | North Carolina | Swain | 37173 | 597 | 6 | 0 | 591 | 35.48665845 | -83.48748932 | 2020-12-26 05:22:28 | Swain, North Carolina, US |
204151 | 204151 | 2020-12-25 | US | Missouri | Harrison | 29081 | 598 | 7 | 0 | 591 | 40.35570088 | -93.99222144 | 2020-12-26 05:22:28 | Harrison, Missouri, US |
203470 | 203470 | 2020-12-25 | US | Iowa | Monroe | 19135 | 607 | 16 | 0 | 591 | 41.02988815 | -92.8690667 | 2020-12-26 05:22:28 | Monroe, Iowa, US |
3693837 | 3693837 | 2020-12-24 | US | North Carolina | Swain | 37173 | 597 | 6 | 0 | 591 | 35.48665845 | -83.48748932 | 2020-12-25 05:22:48 | Swain, North Carolina, US |
3692246 | 3692246 | 2020-12-24 | US | Georgia | Clinch | 13065 | 605 | 14 | 0 | 591 | 30.91395822 | -82.70432472 | 2020-12-25 05:22:48 | Clinch, Georgia, US |
2409353 | 2409353 | 2020-12-23 | US | Oklahoma | Blaine | 40011 | 594 | 3 | 0 | 591 | 35.87518314 | -98.43307003 | 2020-12-24 05:23:04 | Blaine, Oklahoma, US |
2409189 | 2409189 | 2020-12-23 | US | North Carolina | Swain | 37173 | 597 | 6 | 0 | 591 | 35.48665845 | -83.48748932 | 2020-12-24 05:23:04 | Swain, North Carolina, US |
2408003 | 2408003 | 2020-12-23 | US | Iowa | Davis | 19051 | 609 | 18 | 0 | 591 | 40.74773536 | -92.41005468 | 2020-12-24 05:23:04 | Davis, Iowa, US |
928511 | 928511 | 2020-12-21 | US | Georgia | Johnson | 13167 | 623 | 32 | 0 | 591 | 32.70211082 | -82.66166794 | 2020-12-22 05:22:33 | Johnson, Georgia, US |
2119603 | 2119603 | 2020-12-20 | Eswatini | 7427 | 140 | 6696 | 591 | -26.5225 | 31.4659 | 2020-12-21 05:27:58 | Eswatini | |||
2130710 | 2130710 | 2020-12-17 | US | Puerto Rico | Catano | 72033 | 591 | 0 | 0 | 591 | 18.437269 | -66.14330600000001 | 2020-12-18 05:28:18 | Catano, Puerto Rico, 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]);