johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
150 rows where active = 1622 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378689 | 1378689 | 2021-07-25 | Qatar | 225198 | 600 | 222976 | 1622 | 25.3548 | 51.1839 | 2021-07-26 04:21:28 | Qatar | |||
3962142 | 3962142 | 2021-06-26 | Ukraine | Odessa Oblast | 140499 | 2974 | 135903 | 1622 | 46.4846 | 30.7326 | 2021-06-27 04:21:39 | Odessa Oblast, Ukraine | ||
3472483 | 3472483 | 2021-06-08 | Russia | Arkhangelsk Oblast | 64336 | 1000 | 61714 | 1622 | 63.5589686 | 43.1221646 | 2021-06-09 04:23:31 | Arkhangelsk Oblast, Russia | ||
3145485 | 3145485 | 2021-06-07 | Gabon | 24591 | 154 | 22815 | 1622 | -0.8037 | 11.6094 | 2021-06-08 04:22:35 | Gabon | |||
825487 | 825487 | 2021-06-06 | Gabon | 24591 | 154 | 22815 | 1622 | -0.8037 | 11.6094 | 2021-06-07 04:22:51 | Gabon | |||
2585892 | 2585892 | 2021-06-05 | Gabon | 24591 | 154 | 22815 | 1622 | -0.8037 | 11.6094 | 2021-06-06 04:24:03 | Gabon | |||
2315206 | 2315206 | 2021-06-04 | Gabon | 24591 | 154 | 22815 | 1622 | -0.8037 | 11.6094 | 2021-06-05 04:23:03 | Gabon | |||
2315089 | 2315089 | 2021-06-04 | Chile | Coquimbo | 38841 | 716 | 36503 | 1622 | -29.959 | -71.3389 | 2021-06-05 04:23:03 | Coquimbo, Chile | ||
1409299 | 1409299 | 2021-04-23 | Russia | Ulyanovsk Oblast | 52821 | 1122 | 50077 | 1622 | 54.1463177 | 47.2324921 | 2021-04-24 04:20:38 | Ulyanovsk Oblast, Russia | ||
3369188 | 3369188 | 2021-03-21 | Colombia | Santander | 93417 | 3451 | 88344 | 1622 | 6.6437 | -73.6536 | 2021-03-22 05:25:43 | Santander, Colombia | ||
3668668 | 3668668 | 2021-03-06 | US | Illinois | Warren | 17187 | 1666 | 44 | 0 | 1622 | 40.84925021 | -90.6147432 | 2021-03-07 05:21:54 | Warren, Illinois, US |
1091860 | 1091860 | 2021-03-03 | US | Mississippi | Clarke | 28023 | 1693 | 71 | 0 | 1622 | 32.04158545 | -88.68896219999998 | 2021-03-04 05:24:24 | Clarke, Mississippi, US |
3255932 | 3255932 | 2021-03-02 | US | Mississippi | Clarke | 28023 | 1693 | 71 | 0 | 1622 | 32.04158545 | -88.68896219999998 | 2021-03-03 05:23:28 | Clarke, Mississippi, US |
1001662 | 1001662 | 2021-03-01 | US | Texas | Terry | 48445 | 859 | 54 | 0 | 1622 | 33.17402785 | -102.3354521 | 2021-03-02 05:23:30 | Terry, Texas, US |
1000224 | 1000224 | 2021-03-01 | US | Mississippi | Clarke | 28023 | 1693 | 71 | 0 | 1622 | 32.04158545 | -88.68896219999998 | 2021-03-02 05:23:30 | Clarke, Mississippi, US |
998826 | 998826 | 2021-03-01 | US | Alabama | Monroe | 1099 | 1661 | 39 | 0 | 1622 | 31.56729412 | -87.36995001 | 2021-03-02 05:23:30 | Monroe, Alabama, US |
2370720 | 2370720 | 2021-02-28 | US | Texas | Terry | 48445 | 859 | 54 | 0 | 1622 | 33.17402785 | -102.3354521 | 2021-03-01 05:23:01 | Terry, Texas, US |
2369282 | 2369282 | 2021-02-28 | US | Mississippi | Clarke | 28023 | 1693 | 71 | 0 | 1622 | 32.04158545 | -88.68896219999998 | 2021-03-01 05:23:01 | Clarke, Mississippi, US |
2367884 | 2367884 | 2021-02-28 | US | Alabama | Monroe | 1099 | 1661 | 39 | 0 | 1622 | 31.56729412 | -87.36995001 | 2021-03-01 05:23:01 | Monroe, Alabama, US |
3069222 | 3069222 | 2021-02-27 | US | Texas | Terry | 48445 | 859 | 54 | 0 | 1622 | 33.17402785 | -102.3354521 | 2021-02-28 05:22:20 | Terry, Texas, US |
3066896 | 3066896 | 2021-02-27 | US | Georgia | Worth | 13321 | 1684 | 62 | 0 | 1622 | 31.55162306 | -83.85090513 | 2021-02-28 05:22:20 | Worth, Georgia, US |
3066386 | 3066386 | 2021-02-27 | US | Alabama | Monroe | 1099 | 1661 | 39 | 0 | 1622 | 31.56729412 | -87.36995001 | 2021-02-28 05:22:20 | Monroe, Alabama, US |
2186806 | 2186806 | 2021-02-26 | US | Texas | Terry | 48445 | 859 | 54 | 0 | 1622 | 33.17402785 | -102.3354521 | 2021-02-27 05:22:28 | Terry, Texas, US |
2185044 | 2185044 | 2021-02-26 | US | Kentucky | Simpson | 21213 | 1650 | 28 | 0 | 1622 | 36.74058474 | -86.58047435 | 2021-02-27 05:22:28 | Simpson, Kentucky, US |
2183970 | 2183970 | 2021-02-26 | US | Alabama | Monroe | 1099 | 1660 | 38 | 0 | 1622 | 31.56729412 | -87.36995001 | 2021-02-27 05:22:28 | Monroe, Alabama, US |
1861228 | 1861228 | 2021-02-25 | US | Texas | Terry | 48445 | 859 | 54 | 0 | 1622 | 33.17402785 | -102.3354521 | 2021-02-26 05:22:40 | Terry, Texas, US |
1858060 | 1858060 | 2021-02-25 | Kyrgyzstan | 86091 | 1463 | 83006 | 1622 | 41.20438 | 74.766098 | 2021-02-26 05:22:40 | Kyrgyzstan | |||
283406 | 283406 | 2021-02-24 | US | Texas | Terry | 48445 | 859 | 54 | 0 | 1622 | 33.17402785 | -102.3354521 | 2021-02-25 05:24:57 | Terry, Texas, US |
1939674 | 1939674 | 2021-02-23 | US | Texas | Terry | 48445 | 859 | 54 | 0 | 1622 | 33.17402785 | -102.3354521 | 2021-02-24 05:29:16 | Terry, Texas, US |
534338 | 534338 | 2021-02-22 | Ukraine | Rivne Oblast | 48065 | 608 | 45835 | 1622 | 50.6199 | 26.2516 | 2021-02-23 05:23:41 | Rivne Oblast, Ukraine | ||
533929 | 533929 | 2021-02-22 | US | Texas | Terry | 48445 | 859 | 54 | 0 | 1622 | 33.17402785 | -102.3354521 | 2021-02-23 05:23:41 | Terry, Texas, US |
185549 | 185549 | 2021-02-21 | US | West Virginia | Upshur | 54097 | 1652 | 30 | 0 | 1622 | 38.89285061 | -80.23689136 | 2021-02-22 05:24:21 | Upshur, West Virginia, US |
185263 | 185263 | 2021-02-21 | US | Texas | Terry | 48445 | 859 | 54 | 0 | 1622 | 33.17402785 | -102.3354521 | 2021-02-22 05:24:21 | Terry, Texas, US |
184974 | 184974 | 2021-02-21 | US | Tennessee | Grundy | 47061 | 1655 | 29 | 0 | 1622 | 35.38433717 | -85.72142731 | 2021-02-22 05:24:21 | Grundy, Tennessee, US |
745537 | 745537 | 2021-02-20 | US | Texas | Terry | 48445 | 859 | 54 | 0 | 1622 | 33.17402785 | -102.3354521 | 2021-02-21 05:24:33 | Terry, Texas, US |
472438 | 472438 | 2021-02-19 | US | Illinois | Pike | 17149 | 1671 | 49 | 0 | 1622 | 39.62265059 | -90.8877017 | 2021-02-20 05:22:51 | Pike, Illinois, US |
3604033 | 3604033 | 2021-02-17 | US | Tennessee | Union | 47173 | 1650 | 29 | 0 | 1622 | 36.28590426 | -83.83651902 | 2021-02-18 05:22:58 | Union, Tennessee, US |
3602025 | 3602025 | 2021-02-17 | US | Illinois | Hancock | 17067 | 1650 | 28 | 0 | 1622 | 40.40423981 | -91.16313899 | 2021-02-18 05:22:58 | Hancock, Illinois, US |
3539459 | 3539459 | 2021-02-12 | Japan | Aichi | 25097 | 471 | 23004 | 1622 | 35.035551 | 137.211621 | 2021-02-13 05:22:12 | Aichi, Japan | ||
1531152 | 1531152 | 2021-02-09 | US | Texas | Zavala | 48507 | 1774 | 32 | 0 | 1622 | 28.86617238 | -99.76050829 | 2021-02-10 05:22:41 | Zavala, Texas, US |
1530717 | 1530717 | 2021-02-09 | US | South Carolina | Lee | 45061 | 1674 | 52 | 0 | 1622 | 34.16393091 | -80.25690731 | 2021-02-10 05:22:41 | Lee, South Carolina, US |
613456 | 613456 | 2021-02-08 | Canada | Manitoba | 30289 | 850 | 27817 | 1622 | 53.7609 | -98.8139 | 2021-02-09 05:23:30 | Manitoba, Canada | ||
978433 | 978433 | 2021-02-06 | US | West Virginia | Wyoming | 54109 | 1653 | 31 | 0 | 1622 | 37.612327 | -81.54511071 | 2021-02-07 05:23:00 | Wyoming, West Virginia, US |
1686862 | 1686862 | 2021-02-02 | US | North Carolina | Transylvania | 37175 | 1639 | 17 | 0 | 1622 | 35.20383864 | -82.79638423 | 2021-02-03 05:22:52 | Transylvania, North Carolina, US |
1677584 | 1677584 | 2021-02-01 | US | Indiana | Orange | 18117 | 1662 | 40 | 0 | 1622 | 38.54118920000001 | -86.49523093 | 2021-02-02 05:22:49 | Orange, Indiana, US |
1463134 | 1463134 | 2021-01-31 | US | Virginia | Nottoway | 51135 | 1649 | 27 | 0 | 1622 | 37.1435975 | -78.05065922 | 2021-02-01 05:22:53 | Nottoway, Virginia, US |
1461642 | 1461642 | 2021-01-31 | US | Missouri | Cooper | 29053 | 1643 | 21 | 0 | 1622 | 38.844478 | -92.80896081 | 2021-02-01 05:22:53 | Cooper, Missouri, US |
1461163 | 1461163 | 2021-01-31 | US | Kentucky | Hart | 21099 | 1644 | 22 | 0 | 1622 | 37.29943898 | -85.88461055 | 2021-02-01 05:22:53 | Hart, Kentucky, US |
2213565 | 2213565 | 2021-01-30 | US | Missouri | Henry | 29083 | 1650 | 28 | 0 | 1622 | 38.38482826 | -93.79293734 | 2021-01-31 05:22:42 | Henry, Missouri, US |
1899079 | 1899079 | 2021-01-29 | US | Missouri | Moniteau | 29135 | 1649 | 27 | 0 | 1622 | 38.63571781 | -92.57976951 | 2021-01-30 05:22:49 | Moniteau, Missouri, US |
1898398 | 1898398 | 2021-01-29 | US | Iowa | Winneshiek | 19191 | 1642 | 20 | 0 | 1622 | 43.29094334 | -91.84422722 | 2021-01-30 05:22:49 | Winneshiek, Iowa, US |
3153835 | 3153835 | 2021-01-27 | Russia | Novosibirsk Oblast | 31709 | 1191 | 28896 | 1622 | 54.9720169 | 79.48139240000002 | 2021-01-28 05:22:24 | Novosibirsk Oblast, Russia | ||
13161 | 13161 | 2021-01-26 | US | Georgia | Lamar | 13171 | 1661 | 39 | 0 | 1622 | 33.07841647 | -84.14263877 | 2021-01-27 05:23:41 | Lamar, Georgia, US |
1094941 | 1094941 | 2021-01-20 | US | Georgia | Putnam | 13237 | 1658 | 36 | 0 | 1622 | 33.32056115 | -83.37552891 | 2021-01-21 05:22:01 | Putnam, Georgia, US |
910590 | 910590 | 2021-01-19 | US | North Dakota | Richland | 38077 | 1653 | 15 | 0 | 1622 | 46.26440649 | -96.94852979 | 2021-01-20 05:21:54 | Richland, North Dakota, US |
239670 | 239670 | 2021-01-18 | US | Ohio | Adams | 39001 | 1658 | 36 | 0 | 1622 | 38.84541072 | -83.4718964 | 2021-01-19 05:22:15 | Adams, Ohio, US |
3102816 | 3102816 | 2021-01-16 | US | Kentucky | Carter | 21043 | 1640 | 18 | 0 | 1622 | 38.31690743 | -83.05092385 | 2021-01-17 05:22:17 | Carter, Kentucky, US |
3880793 | 3880793 | 2021-01-14 | US | Iowa | O'Brien | 19141 | 1676 | 54 | 0 | 1622 | 43.08310673 | -95.62474482 | 2021-01-15 05:22:24 | O'Brien, Iowa, US |
3880046 | 3880046 | 2021-01-14 | US | Arkansas | Cross | 5037 | 1660 | 38 | 0 | 1622 | 35.29631396 | -90.77185818 | 2021-01-15 05:22:24 | Cross, Arkansas, US |
190264 | 190264 | 2021-01-11 | Russia | Ingushetia Republic | 12911 | 148 | 11141 | 1622 | 43.11542075 | 45.01713552 | 2021-01-12 05:22:15 | Ingushetia Republic, Russia | ||
2627367 | 2627367 | 2021-01-10 | US | Louisiana | Grant | 22043 | 1663 | 41 | 0 | 1622 | 31.59882456 | -92.56124347 | 2021-01-11 05:21:50 | Grant, Louisiana, US |
2543334 | 2543334 | 2021-01-07 | US | Missouri | New Madrid | 29143 | 1660 | 38 | 0 | 1622 | 36.59666326 | -89.66070007 | 2021-01-08 05:22:42 | New Madrid, Missouri, US |
1061918 | 1061918 | 2021-01-04 | Malta | 13230 | 222 | 11386 | 1622 | 35.9375 | 14.3754 | 2021-01-05 05:21:49 | Malta | |||
3233356 | 3233356 | 2021-01-03 | US | Tennessee | Bledsoe | 47007 | 1663 | 9 | 0 | 1622 | 35.59942968 | -85.20611967 | 2021-01-04 05:22:02 | Bledsoe, Tennessee, US |
2230367 | 2230367 | 2021-01-02 | US | South Dakota | Clay | 46027 | 1634 | 12 | 0 | 1622 | 42.91296147 | -96.97656917 | 2021-01-03 05:22:52 | Clay, South Dakota, US |
3696620 | 3696620 | 2020-12-31 | US | Indiana | Sullivan | 18153 | 1650 | 28 | 0 | 1622 | 39.08952258 | -87.41414469 | 2021-01-01 05:23:07 | Sullivan, Indiana, US |
766507 | 766507 | 2020-12-29 | Russia | Belgorod Oblast | 21444 | 247 | 19575 | 1622 | 50.7080119 | 37.5837615 | 2020-12-30 05:22:34 | Belgorod Oblast, Russia | ||
204465 | 204465 | 2020-12-25 | US | New York | Allegany | 36003 | 1693 | 71 | 0 | 1622 | 42.25748406 | -78.02750466 | 2020-12-26 05:22:28 | Allegany, New York, US |
203464 | 203464 | 2020-12-25 | US | Iowa | Mahaska | 19123 | 1654 | 32 | 0 | 1622 | 41.33521503 | -92.64083907 | 2020-12-26 05:22:28 | Mahaska, Iowa, US |
202794 | 202794 | 2020-12-25 | US | California | Glenn | 6021 | 1624 | 9 | 0 | 1622 | 39.59875897 | -122.3938452 | 2020-12-26 05:22:28 | Glenn, California, US |
3693055 | 3693055 | 2020-12-24 | US | Maryland | Somerset | 24039 | 1642 | 20 | 0 | 1622 | 38.1163542 | -75.75118623 | 2020-12-25 05:22:48 | Somerset, Maryland, US |
3772135 | 3772135 | 2020-12-22 | US | New York | St. Lawrence | 36089 | 1657 | 35 | 0 | 1622 | 44.4976179 | -75.06550039 | 2020-12-23 05:22:03 | St. Lawrence, New York, US |
1902555 | 1902555 | 2020-12-18 | US | Kentucky | Floyd | 21071 | 1631 | 9 | 0 | 1622 | 37.56213922 | -82.74750924 | 2020-12-19 05:27:52 | Floyd, Kentucky, US |
2131229 | 2131229 | 2020-12-17 | US | Texas | Waller | 48473 | 1586 | 21 | 0 | 1622 | 30.01058447 | -95.99011759 | 2020-12-18 05:28:18 | Waller, Texas, US |
3151926 | 3151926 | 2020-12-16 | US | North Carolina | Montgomery | 37123 | 1666 | 44 | 0 | 1622 | 35.33155144 | -79.90416657 | 2020-12-17 05:28:12 | Montgomery, North Carolina, US |
1036313 | 1036313 | 2020-12-15 | US | Missouri | Polk | 29167 | 1638 | 16 | 0 | 1622 | 37.6162296 | -93.39828174 | 2020-12-16 05:28:04 | Polk, Missouri, US |
1752389 | 1752389 | 2020-12-14 | US | Indiana | Randolph | 18135 | 1659 | 37 | 0 | 1622 | 40.15734772 | -85.01139319 | 2020-12-15 05:26:38 | Randolph, Indiana, US |
3850309 | 3850309 | 2020-12-13 | US | Oklahoma | Beckham | 40009 | 1640 | 18 | 0 | 1622 | 35.26862449 | -99.68128023 | 2020-12-14 05:26:27 | Beckham, Oklahoma, US |
2349666 | 2349666 | 2020-12-07 | US | New York | Ontario | 36069 | 1659 | 37 | 0 | 1622 | 42.85145728 | -77.30874425 | 2020-12-08 05:27:42 | Ontario, New York, US |
2348323 | 2348323 | 2020-12-07 | US | Hawaii | Hawaii | 15001 | 1665 | 43 | 0 | 1622 | 19.60121157 | -155.5210167 | 2020-12-08 05:27:42 | Hawaii, Hawaii, US |
1009719 | 1009719 | 2020-12-06 | US | Washington | Cowlitz | 53015 | 1636 | 14 | 0 | 1622 | 46.19074721 | -122.6782231 | 2020-12-07 05:26:14 | Cowlitz, Washington, US |
76019 | 76019 | 2020-12-03 | US | Idaho | Jefferson | 16051 | 1633 | 11 | 0 | 1622 | 43.82078483 | -112.3131749 | 2020-12-04 05:27:27 | Jefferson, Idaho, US |
738560 | 738560 | 2020-12-02 | Russia | Voronezh Oblast | 35115 | 632 | 32861 | 1622 | 50.9800393 | 40.15065070000001 | 2020-12-03 05:28:22 | Voronezh Oblast, Russia | ||
2938098 | 2938098 | 2020-11-28 | US | South Dakota | Hughes | 46065 | 1640 | 18 | 0 | 1622 | 44.39091534 | -99.99661148 | 2020-11-29 05:25:55 | Hughes, South Dakota, US |
1353862 | 1353862 | 2020-11-24 | US | Wisconsin | Kewaunee | 55061 | 1637 | 15 | 0 | 1622 | 44.51727459 | -87.61468386 | 2020-11-25 05:27:20 | Kewaunee, Wisconsin, US |
1351192 | 1351192 | 2020-11-24 | US | Georgia | Toombs | 13279 | 1685 | 63 | 0 | 1622 | 32.12059861 | -82.32957247 | 2020-11-25 05:27:20 | Toombs, Georgia, US |
2703528 | 2703528 | 2020-11-20 | US | Montana | Silver Bow | 30093 | 1639 | 17 | 0 | 1622 | 45.90018933 | -112.6620092 | 2020-11-21 05:25:51 | Silver Bow, Montana, US |
3340089 | 3340089 | 2020-11-17 | US | Louisiana | Iberville | 22047 | 1684 | 62 | 0 | 1622 | 30.25734305 | -91.3499598 | 2020-11-18 05:40:31 | Iberville, Louisiana, US |
3172577 | 3172577 | 2020-11-16 | US | Tennessee | Henderson | 47077 | 1636 | 30 | 0 | 1622 | 35.65581134 | -88.38600175 | 2020-11-17 05:25:54 | Henderson, Tennessee, US |
3169858 | 3169858 | 2020-11-16 | Russia | Mordovia Republic | 9517 | 56 | 7839 | 1622 | 54.4419829 | 44.4661144 | 2020-11-17 05:25:54 | Mordovia Republic, Russia | ||
2883789 | 2883789 | 2020-11-15 | US | Wisconsin | Waushara | 55137 | 1628 | 6 | 0 | 1622 | 44.11324419 | -89.24317107 | 2020-11-16 05:25:57 | Waushara, Wisconsin, US |
2880960 | 2880960 | 2020-11-15 | US | Georgia | Camden | 13039 | 1642 | 20 | 0 | 1622 | 30.92951916 | -81.66601818 | 2020-11-16 05:25:57 | Camden, Georgia, US |
2788075 | 2788075 | 2020-11-13 | US | Texas | Erath | 48143 | 1250 | 18 | 0 | 1622 | 32.23602653 | -98.21773417 | 2020-11-14 05:25:37 | Erath, Texas, US |
2787718 | 2787718 | 2020-11-13 | US | Puerto Rico | Caguas | 72025 | 1622 | 0 | 0 | 1622 | 18.211615 | -66.050779 | 2020-11-14 05:25:37 | Caguas, Puerto Rico, US |
2786871 | 2786871 | 2020-11-13 | US | Missouri | Butler | 29023 | 1630 | 8 | 0 | 1622 | 36.71462476 | -90.40421163 | 2020-11-14 05:25:37 | Butler, Missouri, US |
3442726 | 3442726 | 2020-11-11 | US | Missouri | Lincoln | 29113 | 1629 | 7 | 0 | 1622 | 39.05345619 | -90.95588181 | 2020-11-12 05:25:55 | Lincoln, Missouri, US |
3441843 | 3441843 | 2020-11-11 | US | Illinois | Randolph | 17157 | 1641 | 19 | 0 | 1622 | 38.05095369 | -89.82512254 | 2020-11-12 05:25:55 | Randolph, Illinois, US |
1992186 | 1992186 | 2020-11-09 | US | Wisconsin | Monroe | 55081 | 1630 | 8 | 0 | 1622 | 43.94641218 | -90.618819 | 2020-11-10 05:40:07 | Monroe, Wisconsin, US |
1991429 | 1991429 | 2020-11-09 | US | South Carolina | Cherokee | 45021 | 1678 | 56 | 0 | 1622 | 35.05122251 | -81.61828622 | 2020-11-10 05:40:07 | Cherokee, South Carolina, US |
1990246 | 1990246 | 2020-11-09 | US | Michigan | Clinton | 26037 | 1640 | 18 | 0 | 1622 | 42.94400871 | -84.60145248 | 2020-11-10 05:40:07 | Clinton, Michigan, 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]);