johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
140 rows where active = 1626 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
829780 | 829780 | 2021-07-09 | Romania | 1081174 | 34197 | 1045351 | 1626 | 45.9432 | 24.9668 | 2021-07-10 04:21:25 | Romania | |||
1495865 | 1495865 | 2021-07-03 | Russia | Voronezh Oblast | 91529 | 3220 | 86683 | 1626 | 50.9800393 | 40.15065070000001 | 2021-07-04 04:21:38 | Voronezh Oblast, Russia | ||
1125445 | 1125445 | 2021-06-18 | Colombia | Magdalena | 76303 | 2845 | 71832 | 1626 | 10.4113 | -74.4057 | 2021-06-19 04:22:33 | Magdalena, Colombia | ||
1711931 | 1711931 | 2021-06-02 | Ukraine | Crimea Republic* | 43677 | 1364 | 40687 | 1626 | 45.2835 | 34.2008 | 2021-06-03 04:23:32 | Crimea Republic*, Ukraine | ||
1424874 | 1424874 | 2021-05-09 | Canada | Nova Scotia | 3917 | 71 | 2222 | 1626 | 44.682 | -63.7443 | 2021-05-10 04:20:38 | Nova Scotia, Canada | ||
3675898 | 3675898 | 2021-05-04 | Russia | Stavropol Krai | 53279 | 1377 | 50276 | 1626 | 44.86325770000001 | 43.4406913 | 2021-05-05 04:20:43 | Stavropol Krai, Russia | ||
888347 | 888347 | 2021-04-26 | Russia | Nizhny Novgorod Oblast | 113273 | 3130 | 108517 | 1626 | 55.47180329999999 | 44.0911594 | 2021-04-27 04:20:52 | Nizhny Novgorod Oblast, Russia | ||
955121 | 955121 | 2021-04-25 | Russia | Ulyanovsk Oblast | 52987 | 1136 | 50225 | 1626 | 54.1463177 | 47.2324921 | 2021-04-26 04:21:04 | Ulyanovsk Oblast, Russia | ||
3133196 | 3133196 | 2021-04-18 | Malaysia | Kelantan | 8448 | 28 | 6794 | 1626 | 6.1254 | 102.2381 | 2021-04-19 04:20:57 | Kelantan, Malaysia | ||
3883349 | 3883349 | 2021-04-11 | Cabo Verde | 19005 | 182 | 17197 | 1626 | 16.5388 | -23.0418 | 2021-04-12 04:21:00 | Cabo Verde | |||
388258 | 388258 | 2021-04-04 | Japan | Saitama | 33403 | 704 | 31073 | 1626 | 35.997101 | 139.347635 | 2021-04-05 04:20:35 | Saitama, Japan | ||
1204025 | 1204025 | 2021-03-22 | Russia | Leningrad Oblast | 38911 | 867 | 36418 | 1626 | 60.1853296 | 32.3925325 | 2021-03-23 05:26:18 | Leningrad Oblast, Russia | ||
352548 | 352548 | 2021-03-11 | Russia | Tver Oblast | 35203 | 672 | 32905 | 1626 | 57.1134475 | 35.174442799999994 | 2021-03-12 05:26:50 | Tver Oblast, Russia | ||
3671099 | 3671099 | 2021-03-06 | US | West Virginia | Jackson | 54035 | 1676 | 50 | 0 | 1626 | 38.84263974 | -81.68148753 | 2021-03-07 05:21:54 | Jackson, West Virginia, US |
3670845 | 3670845 | 2021-03-06 | US | Texas | Terry | 48445 | 863 | 54 | 0 | 1626 | 33.17402785 | -102.3354521 | 2021-03-07 05:21:54 | Terry, Texas, US |
1619466 | 1619466 | 2021-03-05 | US | Texas | Terry | 48445 | 863 | 54 | 0 | 1626 | 33.17402785 | -102.3354521 | 2021-03-06 04:23:41 | Terry, Texas, US |
2210877 | 2210877 | 2021-03-04 | US | Texas | Terry | 48445 | 863 | 54 | 0 | 1626 | 33.17402785 | -102.3354521 | 2021-03-05 05:26:29 | Terry, Texas, US |
2207593 | 2207593 | 2021-03-04 | India | Assam | 217613 | 1093 | 214894 | 1626 | 26.357149 | 92.830441 | 2021-03-05 05:26:29 | Assam, India | ||
1093298 | 1093298 | 2021-03-03 | US | Texas | Terry | 48445 | 863 | 54 | 0 | 1626 | 33.17402785 | -102.3354521 | 2021-03-04 05:24:24 | Terry, Texas, US |
3257370 | 3257370 | 2021-03-02 | US | Texas | Terry | 48445 | 863 | 54 | 0 | 1626 | 33.17402785 | -102.3354521 | 2021-03-03 05:23:28 | Terry, Texas, US |
999563 | 999563 | 2021-03-01 | US | Indiana | Rush | 18139 | 1648 | 22 | 0 | 1626 | 39.62002287 | -85.4655599 | 2021-03-02 05:23:30 | Rush, Indiana, US |
999487 | 999487 | 2021-03-01 | US | Illinois | Wayne | 17191 | 1674 | 48 | 0 | 1626 | 38.42955355 | -88.42586459 | 2021-03-02 05:23:30 | Wayne, Illinois, US |
2368545 | 2368545 | 2021-02-28 | US | Illinois | Wayne | 17191 | 1674 | 48 | 0 | 1626 | 38.42955355 | -88.42586459 | 2021-03-01 05:23:01 | Wayne, Illinois, US |
1861388 | 1861388 | 2021-02-25 | US | Virginia | Powhatan | 51145 | 1634 | 8 | 0 | 1626 | 37.55016038 | -77.91267882 | 2021-02-26 05:22:40 | Powhatan, Virginia, US |
283566 | 283566 | 2021-02-24 | US | Virginia | Powhatan | 51145 | 1634 | 8 | 0 | 1626 | 37.55016038 | -77.91267882 | 2021-02-25 05:24:57 | Powhatan, Virginia, US |
1939143 | 1939143 | 2021-02-23 | US | Pennsylvania | Susquehanna | 42115 | 1679 | 53 | 0 | 1626 | 41.82147784 | -75.80071959 | 2021-02-24 05:29:16 | Susquehanna, Pennsylvania, US |
183066 | 183066 | 2021-02-21 | US | Illinois | Pike | 17149 | 1675 | 49 | 0 | 1626 | 39.62265059 | -90.8877017 | 2021-02-22 05:24:21 | Pike, Illinois, US |
743060 | 743060 | 2021-02-20 | US | Georgia | Berrien | 13019 | 1666 | 40 | 0 | 1626 | 31.27590016 | -83.22529920000002 | 2021-02-21 05:24:33 | Berrien, Georgia, US |
1156113 | 1156113 | 2021-02-18 | US | Tennessee | Union | 47173 | 1658 | 30 | 0 | 1626 | 36.28590426 | -83.83651902 | 2021-02-19 05:24:16 | Union, Tennessee, US |
3602261 | 3602261 | 2021-02-17 | US | Iowa | Page | 19145 | 1643 | 17 | 0 | 1626 | 40.7393172 | -95.1497813 | 2021-02-18 05:22:58 | Page, Iowa, US |
3051396 | 3051396 | 2021-02-16 | US | Iowa | Page | 19145 | 1643 | 17 | 0 | 1626 | 40.7393172 | -95.1497813 | 2021-02-17 05:23:10 | Page, Iowa, US |
1339495 | 1339495 | 2021-02-15 | US | Iowa | Page | 19145 | 1643 | 17 | 0 | 1626 | 40.7393172 | -95.1497813 | 2021-02-16 05:24:38 | Page, Iowa, US |
2640976 | 2640976 | 2021-02-11 | US | Texas | Zapata | 48505 | 1888 | 24 | 0 | 1626 | 27.00156391 | -99.16987152 | 2021-02-12 05:23:29 | Zapata, Texas, US |
340471 | 340471 | 2021-02-03 | Russia | Ingushetia Republic | 14067 | 161 | 12280 | 1626 | 43.11542075 | 45.01713552 | 2021-02-04 05:22:26 | Ingushetia Republic, Russia | ||
2214618 | 2214618 | 2021-01-30 | US | Tennessee | Lake | 47095 | 1655 | 22 | 0 | 1626 | 36.34180170000001 | -89.48921915 | 2021-01-31 05:22:42 | Lake, Tennessee, US |
2484248 | 2484248 | 2021-01-28 | US | North Carolina | Ashe | 37009 | 1660 | 34 | 0 | 1626 | 36.43296207 | -81.49862729 | 2021-01-29 05:22:23 | Ashe, North Carolina, US |
12284 | 12284 | 2021-01-26 | India | Delhi | 634229 | 10820 | 621783 | 1626 | 28.646519 | 77.10898 | 2021-01-27 05:23:41 | Delhi, India | ||
1759643 | 1759643 | 2021-01-24 | US | Alabama | Cherokee | 1019 | 1657 | 31 | 0 | 1626 | 34.17805983 | -85.60638968 | 2021-01-25 05:22:16 | Cherokee, Alabama, US |
2470045 | 2470045 | 2021-01-22 | US | Texas | Washington | 48477 | 2293 | 72 | 0 | 1626 | 30.21498498 | -96.40946246 | 2021-01-23 05:22:03 | Washington, Texas, US |
2467985 | 2467985 | 2021-01-22 | US | Iowa | Fayette | 19065 | 1650 | 24 | 0 | 1626 | 42.86271799 | -91.8441231 | 2021-01-23 05:22:03 | Fayette, Iowa, US |
910993 | 910993 | 2021-01-19 | US | South Carolina | Jasper | 45053 | 1654 | 28 | 0 | 1626 | 32.43171982 | -81.02487495 | 2021-01-20 05:21:54 | Jasper, South Carolina, US |
909792 | 909792 | 2021-01-19 | US | Michigan | Chippewa | 26033 | 1644 | 18 | 0 | 1626 | 46.29552653 | -84.54353449 | 2021-01-20 05:21:54 | Chippewa, Michigan, US |
238855 | 238855 | 2021-01-18 | US | Michigan | Chippewa | 26033 | 1644 | 18 | 0 | 1626 | 46.29552653 | -84.54353449 | 2021-01-19 05:22:15 | Chippewa, Michigan, US |
3104780 | 3104780 | 2021-01-16 | US | Virginia | Halifax | 51083 | 1673 | 47 | 0 | 1626 | 36.76654925 | -78.93512622 | 2021-01-17 05:22:17 | Halifax, Virginia, US |
3104738 | 3104738 | 2021-01-16 | US | Virginia | Botetourt | 51023 | 1644 | 18 | 0 | 1626 | 37.55531756 | -79.80982182 | 2021-01-17 05:22:17 | Botetourt, Virginia, US |
3101784 | 3101784 | 2021-01-16 | US | Alabama | Butler | 1013 | 1684 | 58 | 0 | 1626 | 31.75300095 | -86.68057478 | 2021-01-17 05:22:17 | Butler, Alabama, US |
3309954 | 3309954 | 2021-01-13 | US | Minnesota | Roseau | 27135 | 1642 | 16 | 0 | 1626 | 48.77501878 | -95.81079919 | 2021-01-14 05:22:32 | Roseau, Minnesota, US |
776882 | 776882 | 2021-01-12 | US | Oklahoma | Craig | 40035 | 1633 | 7 | 0 | 1626 | 36.76268118 | -95.20916602 | 2021-01-13 05:22:15 | Craig, Oklahoma, US |
190438 | 190438 | 2021-01-11 | US | Alabama | Hale | 1065 | 1667 | 41 | 0 | 1626 | 32.76039258 | -87.63284988 | 2021-01-12 05:22:15 | Hale, Alabama, US |
2627635 | 2627635 | 2021-01-10 | US | Minnesota | Wabasha | 27157 | 1628 | 2 | 0 | 1626 | 44.28424356 | -92.23121312 | 2021-01-11 05:21:50 | Wabasha, Minnesota, US |
2627600 | 2627600 | 2021-01-10 | US | Minnesota | Martin | 27091 | 1652 | 26 | 0 | 1626 | 43.67429718 | -94.55099908 | 2021-01-11 05:21:50 | Martin, Minnesota, US |
2541872 | 2541872 | 2021-01-07 | US | Arkansas | Columbia | 5027 | 1669 | 43 | 0 | 1626 | 33.21230701 | -93.22642793 | 2021-01-08 05:22:42 | Columbia, Arkansas, US |
2867835 | 2867835 | 2021-01-06 | US | Texas | Jasper | 48241 | 2006 | 46 | 0 | 1626 | 30.74685667 | -94.02667579 | 2021-01-07 05:22:03 | Jasper, Texas, US |
2866659 | 2866659 | 2021-01-06 | US | Missouri | Randolph | 29175 | 1645 | 19 | 0 | 1626 | 39.44007257 | -92.4971374 | 2021-01-07 05:22:03 | Randolph, Missouri, US |
2229638 | 2229638 | 2021-01-02 | US | Nebraska | Washington | 31177 | 1643 | 17 | 0 | 1626 | 41.52815707 | -96.22019892 | 2021-01-03 05:22:52 | Washington, Nebraska, US |
2227701 | 2227701 | 2021-01-02 | Russia | Altai Krai | 33334 | 898 | 30810 | 1626 | 52.6932243 | 82.69314240000001 | 2021-01-03 05:22:52 | Altai Krai, Russia | ||
1012979 | 1012979 | 2020-12-30 | US | Pennsylvania | McKean | 42083 | 1646 | 20 | 0 | 1626 | 41.80938602 | -78.56478358 | 2020-12-31 05:22:49 | McKean, Pennsylvania, US |
766920 | 766920 | 2020-12-29 | US | Colorado | Crowley | 8025 | 1658 | 14 | 0 | 1626 | 38.32608609 | -103.7844965 | 2020-12-30 05:22:34 | Crowley, Colorado, US |
3765051 | 3765051 | 2020-12-28 | US | West Virginia | Fayette | 54019 | 1673 | 47 | 0 | 1626 | 38.02974928 | -81.08286634 | 2020-12-29 05:22:37 | Fayette, West Virginia, US |
3781135 | 3781135 | 2020-12-27 | US | Texas | Uvalde | 48463 | 1711 | 40 | 0 | 1626 | 29.35739637 | -99.76229172 | 2020-12-28 05:22:06 | Uvalde, Texas, US |
2226740 | 2226740 | 2020-12-26 | US | Texas | Uvalde | 48463 | 1711 | 40 | 0 | 1626 | 29.35739637 | -99.76229172 | 2020-12-27 05:22:55 | Uvalde, Texas, US |
2224602 | 2224602 | 2020-12-26 | US | Indiana | Jennings | 18079 | 1658 | 32 | 0 | 1626 | 38.99588883 | -85.62710784 | 2020-12-27 05:22:55 | Jennings, Indiana, US |
3770259 | 3770259 | 2020-12-22 | US | Alabama | Marengo | 1091 | 1652 | 26 | 0 | 1626 | 32.24767634 | -87.78796182 | 2020-12-23 05:22:03 | Marengo, Alabama, US |
3770064 | 3770064 | 2020-12-22 | Russia | Belgorod Oblast | 20150 | 211 | 18313 | 1626 | 50.7080119 | 37.5837615 | 2020-12-23 05:22:03 | Belgorod Oblast, Russia | ||
2122152 | 2122152 | 2020-12-20 | US | Ohio | Champaign | 39021 | 1655 | 29 | 0 | 1626 | 40.13923427 | -83.76875242 | 2020-12-21 05:27:58 | Champaign, Ohio, US |
2933908 | 2933908 | 2020-12-19 | US | Pennsylvania | Snyder | 42109 | 1659 | 33 | 0 | 1626 | 40.77129231 | -77.06840691 | 2020-12-20 05:27:32 | Snyder, Pennsylvania, US |
2130119 | 2130119 | 2020-12-17 | US | Nevada | Douglas | 32005 | 1636 | 10 | 0 | 1626 | 38.912862 | -119.6171333 | 2020-12-18 05:28:18 | Douglas, Nevada, US |
2129057 | 2129057 | 2020-12-17 | US | Indiana | Clay | 18021 | 1659 | 33 | 0 | 1626 | 39.39561833 | -87.11723506 | 2020-12-18 05:28:18 | Clay, Indiana, US |
3150264 | 3150264 | 2020-12-16 | US | Florida | Bradford | 12007 | 1648 | 22 | 0 | 1626 | 29.95079741 | -82.16611613 | 2020-12-17 05:28:12 | Bradford, Florida, US |
2977013 | 2977013 | 2020-12-09 | US | Mississippi | Coahoma | 28027 | 1672 | 46 | 0 | 1626 | 34.22772299 | -90.60415045 | 2020-12-10 05:26:19 | Coahoma, Mississippi, US |
2350707 | 2350707 | 2020-12-07 | US | Virgin Islands | 78 | 1649 | 23 | 0 | 1626 | 18.3358 | -64.8963 | 2020-12-08 05:27:42 | Virgin Islands, US | |
2349358 | 2349358 | 2020-12-07 | US | Missouri | Perry | 29157 | 1638 | 12 | 0 | 1626 | 37.70660776 | -89.82741088 | 2020-12-08 05:27:42 | Perry, Missouri, US |
1006474 | 1006474 | 2020-12-06 | Russia | Adygea Republic | 8635 | 69 | 6940 | 1626 | 44.6939006 | 40.1520421 | 2020-12-07 05:26:14 | Adygea Republic, Russia | ||
3861562 | 3861562 | 2020-12-04 | US | Minnesota | Mille Lacs | 27095 | 1660 | 34 | 0 | 1626 | 45.93705297 | -93.63236823 | 2020-12-05 05:27:36 | Mille Lacs, Minnesota, US |
78636 | 78636 | 2020-12-03 | US | Wisconsin | Langlade | 55067 | 1662 | 36 | 0 | 1626 | 45.26271619 | -89.07483625 | 2020-12-04 05:27:27 | Langlade, Wisconsin, US |
78405 | 78405 | 2020-12-03 | US | Virginia | Danville | 51590 | 1677 | 51 | 0 | 1626 | 36.58022376 | -79.40395668 | 2020-12-04 05:27:27 | Danville, Virginia, US |
75276 | 75276 | 2020-12-03 | Russia | Belgorod Oblast | 16722 | 90 | 15006 | 1626 | 50.7080119 | 37.5837615 | 2020-12-04 05:27:27 | Belgorod Oblast, Russia | ||
2540280 | 2540280 | 2020-12-01 | US | South Dakota | Oglala Lakota | 46102 | 1649 | 23 | 0 | 1626 | 43.33749164 | -102.5555498 | 2020-12-02 05:27:41 | Oglala Lakota, South Dakota, US |
824072 | 824072 | 2020-11-19 | US | Ohio | Shelby | 39149 | 1643 | 17 | 0 | 1626 | 40.33163494 | -84.20258189 | 2020-11-20 05:26:28 | Shelby, Ohio, US |
125241 | 125241 | 2020-11-18 | US | Oklahoma | Delaware | 40041 | 1664 | 38 | 0 | 1626 | 36.40823634 | -94.80325046 | 2020-11-19 05:25:23 | Delaware, Oklahoma, US |
123874 | 123874 | 2020-11-18 | US | Iowa | Crawford | 19047 | 1641 | 15 | 0 | 1626 | 42.03718237 | -95.3819718 | 2020-11-19 05:25:23 | Crawford, Iowa, US |
123266 | 123266 | 2020-11-18 | US | California | San Benito | 6069 | 1640 | 15 | 0 | 1626 | 36.60308176 | -121.069975 | 2020-11-19 05:25:23 | San Benito, California, US |
3170614 | 3170614 | 2020-11-16 | US | Illinois | Franklin | 17055 | 1642 | 16 | 0 | 1626 | 37.99189086 | -88.92567818 | 2020-11-17 05:25:54 | Franklin, Illinois, US |
2917629 | 2917629 | 2020-11-14 | US | Ohio | Darke | 39037 | 1678 | 52 | 0 | 1626 | 40.13412966 | -84.6194517 | 2020-11-15 05:26:53 | Darke, Ohio, US |
1730160 | 1730160 | 2020-11-08 | US | Michigan | St. Joseph | 26149 | 1651 | 25 | 0 | 1626 | 41.91441767 | -85.52797979 | 2020-11-09 05:25:45 | St. Joseph, Michigan, US |
1729928 | 1729928 | 2020-11-08 | US | Kentucky | Oldham | 21185 | 1652 | 26 | 0 | 1626 | 38.39791089 | -85.448222 | 2020-11-09 05:25:45 | Oldham, Kentucky, US |
1545620 | 1545620 | 2020-11-07 | US | Michigan | St. Joseph | 26149 | 1651 | 25 | 0 | 1626 | 41.91441767 | -85.52797979 | 2020-11-08 05:24:56 | St. Joseph, Michigan, US |
377914 | 377914 | 2020-11-06 | US | Minnesota | Mower | 27099 | 1647 | 21 | 0 | 1626 | 43.67142874 | -92.75234549 | 2020-11-07 05:24:52 | Mower, Minnesota, US |
2498114 | 2498114 | 2020-11-03 | Mexico | Queretaro | 14370 | 1240 | 11504 | 1626 | 20.5888 | -100.3899 | 2020-11-04 05:25:09 | Queretaro, Mexico | ||
212394 | 212394 | 2020-10-29 | US | New Jersey | Cape May | 34009 | 1726 | 100 | 0 | 1626 | 39.15008829 | -74.80170244 | 2020-10-30 04:24:49 | Cape May, New Jersey, US |
210381 | 210381 | 2020-10-29 | Pakistan | Islamabad | 19594 | 215 | 17753 | 1626 | 33.665087 | 73.121219 | 2020-10-30 04:24:49 | Islamabad, Pakistan | ||
1056173 | 1056173 | 2020-10-23 | US | North Carolina | Rutherford | 37161 | 1678 | 52 | 0 | 1626 | 35.40114178 | -81.92112099 | 2020-10-24 04:24:46 | Rutherford, North Carolina, US |
3992432 | 3992432 | 2020-10-20 | US | Mississippi | Panola | 28107 | 1663 | 37 | 0 | 1626 | 34.36398677 | -89.95064249 | 2020-10-21 04:24:14 | Panola, Mississippi, US |
1028609 | 1028609 | 2020-10-17 | US | New York | Sullivan | 36105 | 1674 | 48 | 0 | 1626 | 41.71579493 | -74.76394559 | 2020-10-18 04:24:25 | Sullivan, New York, US |
1027062 | 1027062 | 2020-10-17 | US | Florida | Okeechobee | 12093 | 1663 | 37 | 0 | 1626 | 27.386336199999995 | -80.88944347 | 2020-10-18 04:24:25 | Okeechobee, Florida, US |
2857629 | 2857629 | 2020-10-16 | US | Georgia | Effingham | 13103 | 1654 | 28 | 0 | 1626 | 32.36616021 | -81.34280942 | 2020-10-17 04:24:12 | Effingham, Georgia, US |
79752 | 79752 | 2020-10-14 | US | Florida | Baker | 12003 | 1642 | 16 | 0 | 1626 | 30.33060121 | -82.28467476 | 2020-10-15 04:24:28 | Baker, Florida, US |
2293686 | 2293686 | 2020-10-12 | US | New York | Putnam | 36079 | 1689 | 63 | 0 | 1626 | 41.42630093 | -73.74965532 | 2020-10-13 04:24:02 | Putnam, New York, US |
819258 | 819258 | 2020-10-09 | US | Minnesota | Clay | 27027 | 1668 | 42 | 0 | 1626 | 46.89289518 | -96.48761922 | 2020-10-10 04:23:57 | Clay, Minnesota, US |
818444 | 818444 | 2020-10-09 | US | Georgia | Walker | 13295 | 1665 | 39 | 0 | 1626 | 34.73376362 | -85.30165174 | 2020-10-10 04:23:57 | Walker, Georgia, 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]);