johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
150 rows where active = 1602 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3218540 | 3218540 | 2021-07-26 | Russia | Ryazan Oblast | 34522 | 777 | 32143 | 1602 | 54.42267320000001 | 40.57052460000001 | 2021-07-27 04:21:18 | Ryazan Oblast, Russia | ||
3331595 | 3331595 | 2021-07-21 | Luxembourg | 73215 | 821 | 70792 | 1602 | 49.8153 | 6.1296 | 2021-07-22 04:21:19 | Luxembourg | |||
3331479 | 3331479 | 2021-07-21 | India | Jammu and Kashmir | 320256 | 4372 | 314282 | 1602 | 33.75943 | 76.612638 | 2021-07-22 04:21:19 | Jammu and Kashmir, India | ||
2947612 | 2947612 | 2021-07-16 | Russia | Tyumen Oblast | 42538 | 837 | 40099 | 1602 | 58.8206488 | 70.36588370000001 | 2021-07-17 04:22:22 | Tyumen Oblast, Russia | ||
3740942 | 3740942 | 2021-07-12 | Colombia | Tolima | 97685 | 3158 | 92925 | 1602 | 4.0925 | -75.1545 | 2021-07-13 04:21:18 | Tolima, Colombia | ||
1165009 | 1165009 | 2021-07-04 | Colombia | Casanare | 30433 | 733 | 28098 | 1602 | 5.7589 | -71.5724 | 2021-07-05 04:21:28 | Casanare, Colombia | ||
1495526 | 1495526 | 2021-07-03 | Ghana | 96067 | 796 | 93669 | 1602 | 7.9465 | -1.0232 | 2021-07-04 04:21:38 | Ghana | |||
3958769 | 3958769 | 2021-06-26 | Russia | Voronezh Oblast | 89456 | 3169 | 84685 | 1602 | 50.9800393 | 40.15065070000001 | 2021-06-27 04:21:39 | Voronezh Oblast, Russia | ||
1313788 | 1313788 | 2021-05-26 | Ukraine | Crimea Republic* | 43006 | 1331 | 40073 | 1602 | 45.2835 | 34.2008 | 2021-05-27 04:20:59 | Crimea Republic*, Ukraine | ||
380449 | 380449 | 2021-04-30 | Russia | Ulyanovsk Oblast | 53409 | 1176 | 50631 | 1602 | 54.1463177 | 47.2324921 | 2021-05-01 04:20:47 | Ulyanovsk Oblast, Russia | ||
1636533 | 1636533 | 2021-04-29 | Russia | Kursk Oblast | 36366 | 700 | 34064 | 1602 | 51.6568453 | 36.4852695 | 2021-04-30 04:21:03 | Kursk Oblast, Russia | ||
241473 | 241473 | 2021-04-02 | Russia | Leningrad Oblast | 40044 | 941 | 37501 | 1602 | 60.1853296 | 32.3925325 | 2021-04-03 04:20:44 | Leningrad Oblast, Russia | ||
3453005 | 3453005 | 2021-03-18 | Papua New Guinea | 2479 | 31 | 846 | 1602 | -6.314993 | 143.95555 | 2021-03-19 05:26:09 | Papua New Guinea | |||
3669746 | 3669746 | 2021-03-06 | US | Nebraska | York | 31185 | 1611 | 9 | 0 | 1602 | 40.87272618 | -97.59710186 | 2021-03-07 05:21:54 | York, Nebraska, US |
1000399 | 1000399 | 2021-03-01 | US | Missouri | Ste. Genevieve | 29186 | 1617 | 15 | 0 | 1602 | 37.89090059 | -90.1949941 | 2021-03-02 05:23:30 | Ste. Genevieve, Missouri, US |
2369457 | 2369457 | 2021-02-28 | US | Missouri | Ste. Genevieve | 29186 | 1617 | 15 | 0 | 1602 | 37.89090059 | -90.1949941 | 2021-03-01 05:23:01 | Ste. Genevieve, Missouri, US |
2368854 | 2368854 | 2021-02-28 | US | Kentucky | Anderson | 21005 | 1618 | 16 | 0 | 1602 | 38.00671029 | -84.99171713 | 2021-03-01 05:23:01 | Anderson, Kentucky, US |
3067959 | 3067959 | 2021-02-27 | US | Missouri | Ste. Genevieve | 29186 | 1617 | 15 | 0 | 1602 | 37.89090059 | -90.1949941 | 2021-02-28 05:22:20 | Ste. Genevieve, Missouri, US |
2185543 | 2185543 | 2021-02-26 | US | Missouri | Ste. Genevieve | 29186 | 1617 | 15 | 0 | 1602 | 37.89090059 | -90.1949941 | 2021-02-27 05:22:28 | Ste. Genevieve, Missouri, US |
182525 | 182525 | 2021-02-21 | US | Arkansas | Izard | 5065 | 1641 | 39 | 0 | 1602 | 36.09604046 | -91.90847954 | 2021-02-22 05:24:21 | Izard, Arkansas, US |
742091 | 742091 | 2021-02-20 | Canada | Saskatchewan | 27438 | 368 | 25468 | 1602 | 52.9399 | -106.4509 | 2021-02-21 05:24:33 | Saskatchewan, Canada | ||
2284474 | 2284474 | 2021-02-14 | US | Illinois | Wayne | 17191 | 1647 | 45 | 0 | 1602 | 38.42955355 | -88.42586459 | 2021-02-15 05:24:49 | Wayne, Illinois, US |
2284323 | 2284323 | 2021-02-14 | US | Georgia | Worth | 13321 | 1662 | 60 | 0 | 1602 | 31.55162306 | -83.85090513 | 2021-02-15 05:24:49 | Worth, Georgia, US |
2283208 | 2283208 | 2021-02-14 | Chile | Antofagasta | 34988 | 710 | 32676 | 1602 | -23.6509 | -70.3975 | 2021-02-15 05:24:49 | Antofagasta, Chile | ||
2678874 | 2678874 | 2021-02-13 | US | Illinois | Wayne | 17191 | 1647 | 45 | 0 | 1602 | 38.42955355 | -88.42586459 | 2021-02-14 05:23:43 | Wayne, Illinois, US |
1529568 | 1529568 | 2021-02-09 | US | Michigan | Out of MI | 80026 | 1614 | 12 | 0 | 1602 | 47.63197653 | 0.0 | 2021-02-10 05:22:41 | Out of MI, Michigan, US |
1528360 | 1528360 | 2021-02-09 | US | Arkansas | Clay | 5021 | 1644 | 42 | 0 | 1602 | 36.36826212 | -90.4148172 | 2021-02-10 05:22:41 | Clay, Arkansas, US |
614877 | 614877 | 2021-02-08 | US | Iowa | Hardin | 19083 | 1635 | 33 | 0 | 1602 | 42.38353877 | -93.23654611 | 2021-02-09 05:23:30 | Hardin, Iowa, US |
1673503 | 1673503 | 2021-02-07 | US | Illinois | Warren | 17187 | 1645 | 43 | 0 | 1602 | 40.84925021 | -90.6147432 | 2021-02-08 05:22:39 | Warren, Illinois, US |
975964 | 975964 | 2021-02-06 | US | Illinois | Warren | 17187 | 1645 | 43 | 0 | 1602 | 40.84925021 | -90.6147432 | 2021-02-07 05:23:00 | Warren, Illinois, US |
791115 | 791115 | 2021-02-04 | US | Florida | Union | 12125 | 1672 | 70 | 0 | 1602 | 30.04412971 | -82.37497443 | 2021-02-05 05:22:38 | Union, Florida, US |
790889 | 790889 | 2021-02-04 | US | Arkansas | Phillips | 5107 | 1633 | 31 | 0 | 1602 | 34.43268455 | -90.84800154 | 2021-02-05 05:22:38 | Phillips, Arkansas, US |
2212502 | 2212502 | 2021-01-30 | US | Georgia | Meriwether | 13199 | 1635 | 33 | 0 | 1602 | 33.04163534 | -84.68859732 | 2021-01-31 05:22:42 | Meriwether, Georgia, US |
1897635 | 1897635 | 2021-01-29 | US | Arkansas | Hempstead | 5057 | 1616 | 14 | 0 | 1602 | 33.73325583 | -93.66935133 | 2021-01-30 05:22:49 | Hempstead, Arkansas, US |
3155185 | 3155185 | 2021-01-27 | US | Maryland | Talbot | 24041 | 1622 | 20 | 0 | 1602 | 38.76618159 | -76.10882561 | 2021-01-28 05:22:24 | Talbot, Maryland, US |
15008 | 15008 | 2021-01-26 | US | Pennsylvania | Juniata | 42067 | 1678 | 76 | 0 | 1602 | 40.53358749 | -77.39975129999998 | 2021-01-27 05:23:41 | Juniata, Pennsylvania, US |
2568354 | 2568354 | 2021-01-25 | US | Florida | Gulf | 12045 | 1634 | 32 | 0 | 1602 | 29.93543004 | -85.24270990000002 | 2021-01-26 05:22:02 | Gulf, Florida, US |
2430268 | 2430268 | 2021-01-23 | US | Virginia | Mecklenburg | 51117 | 1646 | 44 | 0 | 1602 | 36.67882005 | -78.36131056 | 2021-01-24 05:22:35 | Mecklenburg, Virginia, US |
2428426 | 2428426 | 2021-01-23 | US | Louisiana | St. James | 22093 | 1648 | 46 | 0 | 1602 | 30.02531716 | -90.80212061 | 2021-01-24 05:22:35 | St. James, Louisiana, US |
2427982 | 2427982 | 2021-01-23 | US | Indiana | Fulton | 18049 | 1640 | 38 | 0 | 1602 | 41.0469907 | -86.26252745 | 2021-01-24 05:22:35 | Fulton, Indiana, US |
2468328 | 2468328 | 2021-01-22 | US | Louisiana | St. James | 22093 | 1648 | 46 | 0 | 1602 | 30.02531716 | -90.80212061 | 2021-01-23 05:22:03 | St. James, Louisiana, US |
437635 | 437635 | 2021-01-21 | US | North Carolina | Avery | 37011 | 1618 | 16 | 0 | 1602 | 36.07569796 | -81.92308483 | 2021-01-22 05:22:10 | Avery, North Carolina, US |
436846 | 436846 | 2021-01-21 | US | Louisiana | Concordia | 22029 | 1652 | 50 | 0 | 1602 | 31.44817835 | -91.63814433 | 2021-01-22 05:22:10 | Concordia, Louisiana, US |
908020 | 908020 | 2021-01-19 | Colombia | Cauca | 22745 | 562 | 20581 | 1602 | 2.705 | -76.82600000000002 | 2021-01-20 05:21:54 | Cauca, Colombia | ||
238091 | 238091 | 2021-01-18 | US | Georgia | Pike | 13231 | 1627 | 25 | 0 | 1602 | 33.09310242 | -84.38790389 | 2021-01-19 05:22:15 | Pike, Georgia, US |
3881378 | 3881378 | 2021-01-14 | US | Mississippi | Jasper | 28061 | 1635 | 33 | 0 | 1602 | 32.01922104 | -89.11786866 | 2021-01-15 05:22:24 | Jasper, Mississippi, US |
3881016 | 3881016 | 2021-01-14 | US | Kentucky | Morgan | 21175 | 1602 | 0 | 0 | 1602 | 37.92465657 | -83.25558245 | 2021-01-15 05:22:24 | Morgan, Kentucky, US |
774860 | 774860 | 2021-01-12 | US | Arkansas | Randolph | 5121 | 1646 | 44 | 0 | 1602 | 36.3415714 | -91.02455531 | 2021-01-13 05:22:15 | Randolph, Arkansas, US |
774821 | 774821 | 2021-01-12 | US | Arkansas | Drew | 5043 | 1626 | 24 | 0 | 1602 | 33.59035001 | -91.71777921 | 2021-01-13 05:22:15 | Drew, Arkansas, US |
2627311 | 2627311 | 2021-01-10 | US | Kentucky | Montgomery | 21173 | 1614 | 12 | 0 | 1602 | 38.03253032 | -83.9145241 | 2021-01-11 05:21:50 | Montgomery, Kentucky, US |
3903447 | 3903447 | 2021-01-09 | US | West Virginia | Mingo | 54059 | 1622 | 20 | 0 | 1602 | 37.73048351 | -82.13338365 | 2021-01-10 05:22:12 | Mingo, West Virginia, US |
3901177 | 3901177 | 2021-01-09 | US | Iowa | O'Brien | 19141 | 1656 | 54 | 0 | 1602 | 43.08310673 | -95.62474482 | 2021-01-10 05:22:12 | O'Brien, Iowa, US |
3901127 | 3901127 | 2021-01-09 | US | Iowa | Clay | 19041 | 1619 | 17 | 0 | 1602 | 43.08247182 | -95.15096481 | 2021-01-10 05:22:12 | Clay, Iowa, US |
3901102 | 3901102 | 2021-01-09 | US | Indiana | Washington | 18175 | 1619 | 17 | 0 | 1602 | 38.60219804 | -86.1049363 | 2021-01-10 05:22:12 | Washington, Indiana, US |
2544535 | 2544535 | 2021-01-07 | US | Texas | Kendall | 48259 | 1999 | 36 | 0 | 1602 | 29.94414155 | -98.7113588 | 2021-01-08 05:22:42 | Kendall, Texas, US |
2868241 | 2868241 | 2021-01-06 | US | Wisconsin | Crawford | 55023 | 1614 | 12 | 0 | 1602 | 43.23870316 | -90.93073686 | 2021-01-07 05:22:03 | Crawford, Wisconsin, US |
3037442 | 3037442 | 2021-01-05 | US | Texas | Lamb | 48279 | 2253 | 68 | 0 | 1602 | 34.06859623 | -102.3516289 | 2021-01-06 05:22:16 | Lamb, Texas, US |
1063628 | 1063628 | 2021-01-04 | US | Mississippi | Chickasaw | 28017 | 1639 | 37 | 0 | 1602 | 33.91983202 | -88.9481545 | 2021-01-05 05:21:49 | Chickasaw, Mississippi, US |
3231879 | 3231879 | 2021-01-03 | US | Kentucky | Marshall | 21157 | 1623 | 21 | 0 | 1602 | 36.88007070000001 | -88.32803576 | 2021-01-04 05:22:02 | Marshall, Kentucky, US |
3230632 | 3230632 | 2021-01-03 | Russia | Altai Krai | 33542 | 907 | 31033 | 1602 | 52.6932243 | 82.69314240000001 | 2021-01-04 05:22:02 | Altai Krai, Russia | ||
1137071 | 1137071 | 2021-01-01 | Russia | Belgorod Oblast | 22007 | 262 | 20143 | 1602 | 50.7080119 | 37.5837615 | 2021-01-02 05:22:33 | Belgorod Oblast, Russia | ||
769167 | 769167 | 2020-12-29 | US | South Dakota | Clay | 46027 | 1613 | 11 | 0 | 1602 | 42.91296147 | -96.97656917 | 2020-12-30 05:22:34 | Clay, South Dakota, US |
768286 | 768286 | 2020-12-29 | US | Missouri | Warren | 29219 | 1611 | 9 | 0 | 1602 | 38.76529479 | -91.16124662 | 2020-12-30 05:22:34 | Warren, Missouri, US |
3764027 | 3764027 | 2020-12-28 | US | Ohio | Coshocton | 39031 | 1637 | 35 | 0 | 1602 | 40.30096166 | -81.91729018 | 2020-12-29 05:22:37 | Coshocton, Ohio, US |
3761717 | 3761717 | 2020-12-28 | Nicaragua | 4790 | 164 | 4225 | 1602 | 12.865416 | -85.207229 | 2020-12-29 05:22:37 | Nicaragua | |||
3778037 | 3778037 | 2020-12-27 | Nicaragua | 4790 | 164 | 4225 | 1602 | 12.865416 | -85.207229 | 2020-12-28 05:22:06 | Nicaragua | |||
2223642 | 2223642 | 2020-12-26 | Nicaragua | 4790 | 164 | 4225 | 1602 | 12.865416 | -85.207229 | 2020-12-27 05:22:55 | Nicaragua | |||
202389 | 202389 | 2020-12-25 | Nicaragua | 4790 | 164 | 4225 | 1602 | 12.865416 | -85.207229 | 2020-12-26 05:22:28 | Nicaragua | |||
3691612 | 3691612 | 2020-12-24 | Nicaragua | 4790 | 164 | 4225 | 1602 | 12.865416 | -85.207229 | 2020-12-25 05:22:48 | Nicaragua | |||
2409282 | 2409282 | 2020-12-23 | US | Ohio | Fayette | 39047 | 1629 | 27 | 0 | 1602 | 39.56021306 | -83.4562016 | 2020-12-24 05:23:04 | Fayette, Ohio, US |
2406964 | 2406964 | 2020-12-23 | Nicaragua | 4790 | 164 | 4225 | 1602 | 12.865416 | -85.207229 | 2020-12-24 05:23:04 | Nicaragua | |||
2122364 | 2122364 | 2020-12-20 | US | Pennsylvania | Clinton | 42035 | 1620 | 18 | 0 | 1602 | 41.23255967 | -77.63785995 | 2020-12-21 05:27:58 | Clinton, Pennsylvania, US |
2119422 | 2119422 | 2020-12-20 | Bahrain | 90282 | 349 | 88331 | 1602 | 26.0275 | 50.55 | 2020-12-21 05:27:58 | Bahrain | |||
1036500 | 1036500 | 2020-12-15 | US | Nevada | Douglas | 32005 | 1612 | 10 | 0 | 1602 | 38.912862 | -119.6171333 | 2020-12-16 05:28:04 | Douglas, Nevada, US |
1036185 | 1036185 | 2020-12-15 | US | Mississippi | Leake | 28079 | 1647 | 45 | 0 | 1602 | 32.7536828 | -89.52402044 | 2020-12-16 05:28:04 | Leake, Mississippi, US |
1753569 | 1753569 | 2020-12-14 | US | North Carolina | Davie | 37059 | 1615 | 13 | 0 | 1602 | 35.93099927 | -80.54496571 | 2020-12-15 05:26:38 | Davie, North Carolina, US |
3849727 | 3849727 | 2020-12-13 | US | Missouri | Polk | 29167 | 1617 | 15 | 0 | 1602 | 37.6162296 | -93.39828174 | 2020-12-14 05:26:27 | Polk, Missouri, US |
3848670 | 3848670 | 2020-12-13 | US | Georgia | Upson | 13293 | 1682 | 80 | 0 | 1602 | 32.87920671 | -84.30024826 | 2020-12-14 05:26:27 | Upson, Georgia, US |
847838 | 847838 | 2020-12-12 | US | New York | Wayne | 36117 | 1625 | 23 | 0 | 1602 | 43.15494365 | -77.02976528 | 2020-12-13 05:27:20 | Wayne, New York, US |
846691 | 846691 | 2020-12-12 | US | Indiana | Randolph | 18135 | 1636 | 34 | 0 | 1602 | 40.15734772 | -85.01139319 | 2020-12-13 05:27:20 | Randolph, Indiana, US |
1006363 | 1006363 | 2020-12-06 | Mali | 5135 | 164 | 3369 | 1602 | 17.570692 | -3.996166000000001 | 2020-12-07 05:26:14 | Mali | |||
738710 | 738710 | 2020-12-02 | US | Alaska | Bethel | 2050 | 1607 | 5 | 0 | 1602 | 60.90980451 | -159.8561831 | 2020-12-03 05:28:22 | Bethel, Alaska, US |
678711 | 678711 | 2020-11-23 | US | Alabama | Tallapoosa | 1123 | 1692 | 90 | 0 | 1602 | 32.86698258 | -85.79833053 | 2020-11-24 05:27:31 | Tallapoosa, Alabama, US |
3191748 | 3191748 | 2020-11-22 | US | Minnesota | Todd | 27153 | 1614 | 12 | 0 | 1602 | 46.06996226 | -94.89785296 | 2020-11-23 05:25:26 | Todd, Minnesota, US |
2702448 | 2702448 | 2020-11-20 | US | Idaho | Minidoka | 16067 | 1616 | 14 | 0 | 1602 | 42.85518524 | -113.6357257 | 2020-11-21 05:25:51 | Minidoka, Idaho, US |
3173185 | 3173185 | 2020-11-16 | US | Wisconsin | Lincoln | 55069 | 1621 | 19 | 0 | 1602 | 45.33737523 | -89.73411273 | 2020-11-17 05:25:54 | Lincoln, Wisconsin, US |
3172174 | 3172174 | 2020-11-16 | US | Oklahoma | Delaware | 40041 | 1638 | 36 | 0 | 1602 | 36.40823634 | -94.80325046 | 2020-11-17 05:25:54 | Delaware, Oklahoma, US |
3171610 | 3171610 | 2020-11-16 | US | Montana | Big Horn | 30003 | 1649 | 47 | 0 | 1602 | 45.42335905 | -107.492347 | 2020-11-17 05:25:54 | Big Horn, Montana, US |
2883631 | 2883631 | 2020-11-15 | US | Washington | Douglas | 53017 | 1613 | 11 | 0 | 1602 | 47.7361335 | -119.692937 | 2020-11-16 05:25:57 | Douglas, Washington, US |
2881207 | 2881207 | 2020-11-15 | US | Illinois | Livingston | 17105 | 1617 | 15 | 0 | 1602 | 40.89188292 | -88.55784752 | 2020-11-16 05:25:57 | Livingston, Illinois, US |
2918609 | 2918609 | 2020-11-14 | US | Washington | Douglas | 53017 | 1613 | 11 | 0 | 1602 | 47.7361335 | -119.692937 | 2020-11-15 05:26:53 | Douglas, Washington, US |
274681 | 274681 | 2020-11-10 | US | Oklahoma | Cherokee | 40021 | 1610 | 8 | 0 | 1602 | 35.90692775 | -94.99980896 | 2020-11-11 05:25:30 | Cherokee, Oklahoma, US |
273973 | 273973 | 2020-11-10 | US | Mississippi | Monroe | 28095 | 1678 | 76 | 0 | 1602 | 33.89236763 | -88.4808438 | 2020-11-11 05:25:30 | Monroe, Mississippi, US |
1731281 | 1731281 | 2020-11-08 | US | South Carolina | Cherokee | 45021 | 1658 | 56 | 0 | 1602 | 35.05122251 | -81.61828622 | 2020-11-09 05:25:45 | Cherokee, South Carolina, US |
1728338 | 1728338 | 2020-11-08 | Colombia | Narino | 23123 | 789 | 20732 | 1602 | 1.2892 | -77.3579 | 2020-11-09 05:25:45 | Narino, Colombia | ||
379156 | 379156 | 2020-11-06 | US | Tennessee | Roane | 47145 | 1613 | 10 | 0 | 1602 | 35.84923189 | -84.52458689 | 2020-11-07 05:24:52 | Roane, Tennessee, US |
2922488 | 2922488 | 2020-11-04 | US | Virginia | Charlottesville | 51540 | 1633 | 31 | 0 | 1602 | 38.03527919 | -78.48569588 | 2020-11-05 06:05:03 | Charlottesville, Virginia, US |
2921354 | 2921354 | 2020-11-04 | US | New Jersey | Warren | 34041 | 1773 | 171 | 0 | 1602 | 40.85951833 | -74.99556527 | 2020-11-05 06:05:03 | Warren, New Jersey, US |
3306097 | 3306097 | 2020-11-02 | US | Missouri | Johnson | 29101 | 1612 | 10 | 0 | 1602 | 38.74719601 | -93.80691168 | 2020-11-03 06:00:16 | Johnson, Missouri, US |
3410808 | 3410808 | 2020-11-01 | US | Kentucky | Bullitt | 21029 | 1617 | 15 | 0 | 1602 | 37.97162523 | -85.68955617 | 2020-11-02 05:25:04 | Bullitt, Kentucky, 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]);