johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
128 rows where active = 1754 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
295854 | 295854 | 2021-07-15 | Colombia | Cauca | 47475 | 1233 | 44488 | 1754 | 2.705 | -76.82600000000002 | 2021-07-16 04:21:22 | Cauca, Colombia | ||
2589950 | 2589950 | 2021-06-27 | India | Himachal Pradesh | 201665 | 3473 | 196438 | 1754 | 31.927213 | 77.233081 | 2021-06-28 04:21:29 | Himachal Pradesh, India | ||
2423155 | 2423155 | 2021-06-23 | Russia | Yaroslavl Oblast | 43003 | 679 | 40570 | 1754 | 57.77819760000001 | 39.0021095 | 2021-06-24 04:21:55 | Yaroslavl Oblast, Russia | ||
522766 | 522766 | 2021-06-09 | Germany | Berlin | 179343 | 3512 | 174200 | 1754 | 52.52 | 13.405 | 2021-06-10 04:23:17 | Berlin, Germany | ||
522645 | 522645 | 2021-06-09 | Chile | Los Lagos | 80124 | 1088 | 77282 | 1754 | -41.9198 | -72.1416 | 2021-06-10 04:23:17 | Los Lagos, Chile | ||
3675582 | 3675582 | 2021-05-04 | Guyana | 13656 | 306 | 11596 | 1754 | 4.860416000000002 | -58.93018000000001 | 2021-05-05 04:20:43 | Guyana | |||
3129743 | 3129743 | 2021-04-18 | Russia | Mordovia Republic | 19693 | 229 | 17710 | 1754 | 54.4419829 | 44.4661144 | 2021-04-19 04:20:57 | Mordovia Republic, Russia | ||
388074 | 388074 | 2021-04-04 | Colombia | Magdalena | 45859 | 1671 | 42434 | 1754 | 10.4113 | -74.4057 | 2021-04-05 04:20:35 | Magdalena, Colombia | ||
55057 | 55057 | 2021-03-07 | Russia | Tver Oblast | 34686 | 654 | 32278 | 1754 | 57.1134475 | 35.174442799999994 | 2021-03-08 05:24:48 | Tver Oblast, Russia | ||
1092596 | 1092596 | 2021-03-03 | US | Oklahoma | Atoka | 40005 | 1767 | 13 | 0 | 1754 | 34.37366573 | -96.03802487 | 2021-03-04 05:24:24 | Atoka, Oklahoma, US |
1001107 | 1001107 | 2021-03-01 | US | Pennsylvania | Juniata | 42067 | 1834 | 80 | 0 | 1754 | 40.53358749 | -77.39975129999998 | 2021-03-02 05:23:30 | Juniata, Pennsylvania, US |
1000960 | 1000960 | 2021-03-01 | US | Oklahoma | Atoka | 40005 | 1766 | 12 | 0 | 1754 | 34.37366573 | -96.03802487 | 2021-03-02 05:23:30 | Atoka, Oklahoma, US |
2183712 | 2183712 | 2021-02-26 | Netherlands | Unknown | 2204 | 19 | 0 | 1754 | 2021-02-27 05:22:28 | Unknown, Netherlands | ||||
745691 | 745691 | 2021-02-20 | US | Virginia | Page | 51139 | 1796 | 42 | 0 | 1754 | 38.61807452 | -78.48797204 | 2021-02-21 05:24:33 | Page, Virginia, US |
1154365 | 1154365 | 2021-02-18 | US | Iowa | Winneshiek | 19191 | 1780 | 26 | 0 | 1754 | 43.29094334 | -91.84422722 | 2021-02-19 05:24:16 | Winneshiek, Iowa, US |
1153956 | 1153956 | 2021-02-18 | US | Georgia | Meriwether | 13199 | 1805 | 51 | 0 | 1754 | 33.04163534 | -84.68859732 | 2021-02-19 05:24:16 | Meriwether, Georgia, US |
1341676 | 1341676 | 2021-02-15 | US | Virginia | Southampton | 51175 | 1803 | 49 | 0 | 1754 | 36.72231125 | -77.10642712 | 2021-02-16 05:24:38 | Southampton, Virginia, US |
3540280 | 3540280 | 2021-02-12 | US | Georgia | Lamar | 13171 | 1797 | 43 | 0 | 1754 | 33.07841647 | -84.14263877 | 2021-02-13 05:22:12 | Lamar, Georgia, US |
3540102 | 3540102 | 2021-02-12 | US | Colorado | Routt | 8107 | 1808 | 19 | 0 | 1754 | 40.48596505 | -106.9905548 | 2021-02-13 05:22:12 | Routt, Colorado, US |
2639158 | 2639158 | 2021-02-11 | US | Kentucky | Meade | 21163 | 1767 | 13 | 0 | 1754 | 37.96163597 | -86.21028219 | 2021-02-12 05:23:29 | Meade, Kentucky, US |
2638836 | 2638836 | 2021-02-11 | US | Indiana | Owen | 18119 | 1804 | 50 | 0 | 1754 | 39.31145587 | -86.83900724 | 2021-02-12 05:23:29 | Owen, Indiana, US |
1529627 | 1529627 | 2021-02-09 | US | Minnesota | Martin | 27091 | 1781 | 27 | 0 | 1754 | 43.67429718 | -94.55099908 | 2021-02-10 05:22:41 | Martin, Minnesota, US |
1589344 | 1589344 | 2021-02-05 | US | Iowa | Clay | 19041 | 1778 | 24 | 0 | 1754 | 43.08247182 | -95.15096481 | 2021-02-06 05:23:55 | Clay, Iowa, US |
1686967 | 1686967 | 2021-02-02 | US | Ohio | Hocking | 39073 | 1808 | 54 | 0 | 1754 | 39.49537927 | -82.47991446 | 2021-02-03 05:22:52 | Hocking, Ohio, US |
1460934 | 1460934 | 2021-01-31 | US | Iowa | Delaware | 19055 | 1790 | 36 | 0 | 1754 | 42.47104597 | -91.3664492 | 2021-02-01 05:22:53 | Delaware, Iowa, US |
3155269 | 3155269 | 2021-01-27 | US | Michigan | Oceana | 26127 | 1801 | 47 | 0 | 1754 | 43.64124435 | -86.26726673 | 2021-01-28 05:22:24 | Oceana, Michigan, US |
14285 | 14285 | 2021-01-26 | US | Missouri | Randolph | 29175 | 1778 | 24 | 0 | 1754 | 39.44007257 | -92.4971374 | 2021-01-27 05:23:41 | Randolph, Missouri, US |
13047 | 13047 | 2021-01-26 | US | Florida | Madison | 12079 | 1791 | 37 | 0 | 1754 | 30.44396917 | -83.47398594 | 2021-01-27 05:23:41 | Madison, Florida, US |
2568138 | 2568138 | 2021-01-25 | US | Arkansas | Drew | 5043 | 1784 | 30 | 0 | 1754 | 33.59035001 | -91.71777921 | 2021-01-26 05:22:02 | Drew, Arkansas, US |
1760775 | 1760775 | 2021-01-24 | US | Louisiana | Assumption | 22007 | 1785 | 31 | 0 | 1754 | 29.89946234 | -91.06461642 | 2021-01-25 05:22:16 | Assumption, Louisiana, US |
2467758 | 2467758 | 2021-01-22 | US | Illinois | Bond | 17005 | 1774 | 20 | 0 | 1754 | 38.88829622 | -89.43534887 | 2021-01-23 05:22:03 | Bond, Illinois, US |
1097551 | 1097551 | 2021-01-20 | US | West Virginia | Brooke | 54009 | 1801 | 47 | 0 | 1754 | 40.27367263 | -80.57915332 | 2021-01-21 05:22:01 | Brooke, West Virginia, US |
1096032 | 1096032 | 2021-01-20 | US | Missouri | Randolph | 29175 | 1774 | 20 | 0 | 1754 | 39.44007257 | -92.4971374 | 2021-01-21 05:22:01 | Randolph, Missouri, US |
2628678 | 2628678 | 2021-01-10 | US | South Carolina | Edgefield | 45037 | 1780 | 26 | 0 | 1754 | 33.77221995 | -81.96231108 | 2021-01-11 05:21:50 | Edgefield, South Carolina, US |
155949 | 155949 | 2021-01-08 | US | Missouri | Warren | 29219 | 1763 | 9 | 0 | 1754 | 38.76529479 | -91.16124662 | 2021-01-09 05:22:18 | Warren, Missouri, US |
3037840 | 3037840 | 2021-01-05 | US | Wisconsin | Green Lake | 55047 | 1767 | 13 | 0 | 1754 | 43.80025981 | -89.04679553 | 2021-01-06 05:22:16 | Green Lake, Wisconsin, US |
2229292 | 2229292 | 2021-01-02 | US | Mississippi | Adams | 28001 | 1812 | 58 | 0 | 1754 | 31.47669768 | -91.35326037 | 2021-01-03 05:22:52 | Adams, Mississippi, US |
1011153 | 1011153 | 2020-12-30 | US | Georgia | Pickens | 13227 | 1774 | 20 | 0 | 1754 | 34.46589159 | -84.46406611 | 2020-12-31 05:22:49 | Pickens, Georgia, US |
768553 | 768553 | 2020-12-29 | US | New York | Livingston | 36051 | 1778 | 24 | 0 | 1754 | 42.72596275 | -77.77966158 | 2020-12-30 05:22:34 | Livingston, New York, US |
768259 | 768259 | 2020-12-29 | US | Missouri | Polk | 29167 | 1775 | 21 | 0 | 1754 | 37.6162296 | -93.39828174 | 2020-12-30 05:22:34 | Polk, Missouri, US |
3779383 | 3779383 | 2020-12-27 | US | Louisiana | Beauregard | 22011 | 1808 | 54 | 0 | 1754 | 30.64836518 | -93.34173616 | 2020-12-28 05:22:06 | Beauregard, Louisiana, US |
2407079 | 2407079 | 2020-12-23 | Russia | Tatarstan Republic | 12480 | 171 | 10555 | 1754 | 55.7648572 | 52.43104273 | 2020-12-24 05:23:04 | Tatarstan Republic, Russia | ||
3771318 | 3771318 | 2020-12-22 | US | Kentucky | Muhlenberg | 21177 | 1780 | 26 | 0 | 1754 | 37.21425819 | -87.14632053 | 2020-12-23 05:22:03 | Muhlenberg, Kentucky, US |
928837 | 928837 | 2020-12-21 | US | Indiana | Wells | 18179 | 1805 | 51 | 0 | 1754 | 40.72934187 | -85.22132966 | 2020-12-22 05:22:33 | Wells, Indiana, US |
2122179 | 2122179 | 2020-12-20 | US | Ohio | Holmes | 39075 | 1825 | 71 | 0 | 1754 | 40.56163713 | -81.92635677 | 2020-12-21 05:27:58 | Holmes, Ohio, US |
2120596 | 2120596 | 2020-12-20 | US | Georgia | Upson | 13293 | 1835 | 81 | 0 | 1754 | 32.87920671 | -84.30024826 | 2020-12-21 05:27:58 | Upson, Georgia, US |
1902960 | 1902960 | 2020-12-18 | US | Mississippi | Grenada | 28043 | 1807 | 53 | 0 | 1754 | 33.77036166 | -89.80245083 | 2020-12-19 05:27:52 | Grenada, Mississippi, US |
1901354 | 1901354 | 2020-12-18 | Russia | Belgorod Oblast | 19426 | 191 | 17481 | 1754 | 50.7080119 | 37.5837615 | 2020-12-19 05:27:52 | Belgorod Oblast, Russia | ||
1037068 | 1037068 | 2020-12-15 | US | Pennsylvania | Venango | 42121 | 1779 | 25 | 0 | 1754 | 41.40323442 | -79.75845449 | 2020-12-16 05:28:04 | Venango, Pennsylvania, US |
1753480 | 1753480 | 2020-12-14 | US | New York | Cattaraugus | 36009 | 1783 | 29 | 0 | 1754 | 42.24778241 | -78.67923096 | 2020-12-15 05:26:38 | Cattaraugus, New York, US |
3850277 | 3850277 | 2020-12-13 | US | Ohio | Ottawa | 39123 | 1799 | 45 | 0 | 1754 | 41.53781826 | -83.0940185 | 2020-12-14 05:26:27 | Ottawa, Ohio, US |
845820 | 845820 | 2020-12-12 | Russia | Tula Oblast | 18902 | 552 | 16596 | 1754 | 53.9570701 | 37.3690909 | 2020-12-13 05:27:20 | Tula Oblast, Russia | ||
2975064 | 2975064 | 2020-12-09 | Colombia | Atlantico | 80958 | 3243 | 75961 | 1754 | 10.6966 | -74.8741 | 2020-12-10 05:26:19 | Atlantico, Colombia | ||
1818977 | 1818977 | 2020-12-08 | Russia | Buryatia Republic | 20887 | 485 | 18648 | 1754 | 52.7182426 | 109.492143 | 2020-12-09 05:28:01 | Buryatia Republic, Russia | ||
77027 | 77027 | 2020-12-03 | US | Missouri | Platte | 29165 | 1771 | 17 | 0 | 1754 | 39.38154439 | -94.77068479 | 2020-12-04 05:27:27 | Platte, Missouri, US |
741845 | 741845 | 2020-12-02 | US | Wisconsin | Kewaunee | 55061 | 1771 | 17 | 0 | 1754 | 44.51727459 | -87.61468386 | 2020-12-03 05:28:22 | Kewaunee, Wisconsin, US |
2540935 | 2540935 | 2020-12-01 | US | Wisconsin | Jackson | 55053 | 1758 | 4 | 0 | 1754 | 44.31864893 | -90.80566792 | 2020-12-02 05:27:41 | Jackson, Wisconsin, US |
3569667 | 3569667 | 2020-11-29 | US | Texas | Harrison | 48203 | 1686 | 44 | 0 | 1754 | 32.54935988 | -94.36934071 | 2020-11-30 05:26:13 | Harrison, Texas, US |
2938332 | 2938332 | 2020-11-28 | US | Texas | Harrison | 48203 | 1668 | 44 | 0 | 1754 | 32.54935988 | -94.36934071 | 2020-11-29 05:25:55 | Harrison, Texas, US |
2936626 | 2936626 | 2020-11-28 | US | Kentucky | Graves | 21083 | 1790 | 36 | 0 | 1754 | 36.72292505 | -88.65143315 | 2020-11-29 05:25:55 | Graves, Kentucky, US |
395335 | 395335 | 2020-11-27 | US | Texas | Harrison | 48203 | 1624 | 44 | 0 | 1754 | 32.54935988 | -94.36934071 | 2020-11-28 05:25:50 | Harrison, Texas, US |
678533 | 678533 | 2020-11-23 | Russia | Mordovia Republic | 10127 | 59 | 8314 | 1754 | 54.4419829 | 44.4661144 | 2020-11-24 05:27:31 | Mordovia Republic, Russia | ||
678424 | 678424 | 2020-11-23 | Mozambique | 15109 | 126 | 13229 | 1754 | -18.665695 | 35.529562 | 2020-11-24 05:27:31 | Mozambique | |||
3191898 | 3191898 | 2020-11-22 | US | Missouri | Lawrence | 29109 | 1787 | 33 | 0 | 1754 | 37.10626634 | -93.83293097 | 2020-11-23 05:25:26 | Lawrence, Missouri, US |
3191004 | 3191004 | 2020-11-22 | US | Illinois | Monroe | 17133 | 1797 | 43 | 0 | 1754 | 38.27594376 | -90.17761038 | 2020-11-23 05:25:26 | Monroe, Illinois, US |
2704504 | 2704504 | 2020-11-20 | US | Tennessee | Wayne | 47181 | 1796 | 10 | 0 | 1754 | 35.23868267 | -87.78644456 | 2020-11-21 05:25:51 | Wayne, Tennessee, US |
821682 | 821682 | 2020-11-19 | Mozambique | 14723 | 120 | 12849 | 1754 | -18.665695 | 35.529562 | 2020-11-20 05:26:28 | Mozambique | |||
125058 | 125058 | 2020-11-18 | US | North Carolina | Scotland | 37165 | 1791 | 37 | 0 | 1754 | 34.8386299 | -79.4757978 | 2020-11-19 05:25:23 | Scotland, North Carolina, US |
2883766 | 2883766 | 2020-11-15 | US | Wisconsin | Pierce | 55093 | 1765 | 11 | 0 | 1754 | 44.71850291 | -92.4224416 | 2020-11-16 05:25:57 | Pierce, Wisconsin, US |
2917012 | 2917012 | 2020-11-14 | US | Mississippi | Pontotoc | 28115 | 1779 | 25 | 0 | 1754 | 34.226046000000004 | -89.03636807 | 2020-11-15 05:26:53 | Pontotoc, Mississippi, US |
1990046 | 1990046 | 2020-11-09 | US | Kentucky | Laurel | 21125 | 1765 | 11 | 0 | 1754 | 37.10975748 | -84.11321779 | 2020-11-10 05:40:07 | Laurel, Kentucky, US |
2919502 | 2919502 | 2020-11-04 | Sweden | Varmland | 1830 | 76 | 0 | 1754 | 59.7294 | 13.2354 | 2020-11-05 06:05:03 | Varmland, Sweden | ||
1452944 | 1452944 | 2020-10-27 | US | Alabama | Dale | 1045 | 1806 | 52 | 0 | 1754 | 31.43037123 | -85.61095742 | 2020-10-28 04:24:39 | Dale, Alabama, US |
1452812 | 1452812 | 2020-10-27 | Russia | North Ossetia - Alania Republic | 6974 | 70 | 5150 | 1754 | 42.79336110000001 | 44.6324493 | 2020-10-28 04:24:39 | North Ossetia - Alania Republic, Russia | ||
1452555 | 1452555 | 2020-10-27 | India | Tripura | 30453 | 344 | 28355 | 1754 | 23.746783 | 91.743565 | 2020-10-28 04:24:39 | Tripura, India | ||
1177338 | 1177338 | 2020-10-22 | Colombia | Cesar | 24108 | 756 | 21598 | 1754 | 9.3373 | -73.6536 | 2020-10-23 04:24:46 | Cesar, Colombia | ||
3993524 | 3993524 | 2020-10-20 | US | Tennessee | Coffee | 47031 | 1759 | 20 | 0 | 1754 | 35.49090731 | -86.07311784 | 2020-10-21 04:24:14 | Coffee, Tennessee, US |
1795430 | 1795430 | 2020-10-19 | US | Georgia | Habersham | 13137 | 1829 | 75 | 0 | 1754 | 34.63331566 | -83.53094677 | 2020-10-20 04:24:22 | Habersham, Georgia, US |
763113 | 763113 | 2020-10-18 | US | Georgia | Habersham | 13137 | 1828 | 74 | 0 | 1754 | 34.63331566 | -83.53094677 | 2020-10-19 04:24:16 | Habersham, Georgia, US |
1028535 | 1028535 | 2020-10-17 | US | New Mexico | Lea | 35025 | 1782 | 28 | 0 | 1754 | 32.79215361 | -103.4123733 | 2020-10-18 04:24:25 | Lea, New Mexico, US |
2858499 | 2858499 | 2020-10-16 | US | Michigan | Monroe | 26115 | 1784 | 30 | 0 | 1754 | 41.92734151 | -83.53749864 | 2020-10-17 04:24:12 | Monroe, Michigan, US |
2856834 | 2856834 | 2020-10-16 | Italy | Marche | 9133 | 992 | 6387 | 1754 | 43.61675973 | 13.5188753 | 2020-10-17 04:24:12 | Marche, Italy | ||
3784516 | 3784516 | 2020-10-13 | US | Oregon | Malheur | 41045 | 1788 | 34 | 0 | 1754 | 43.1937027 | -117.6227395 | 2020-10-14 04:24:05 | Malheur, Oregon, US |
3788547 | 3788547 | 2020-10-11 | US | Pennsylvania | Erie | 42049 | 1793 | 39 | 0 | 1754 | 41.99253829 | -80.03301954 | 2020-10-12 04:23:45 | Erie, Pennsylvania, US |
2691915 | 2691915 | 2020-10-08 | US | New York | Niagara | 36063 | 1855 | 101 | 0 | 1754 | 43.19898042 | -78.74777412 | 2020-10-09 04:23:59 | Niagara, New York, US |
3805520 | 3805520 | 2020-10-05 | Ukraine | Poltava Oblast | 2965 | 47 | 1164 | 1754 | 49.5883 | 34.5514 | 2020-10-06 04:23:33 | Poltava Oblast, Ukraine | ||
3802446 | 3802446 | 2020-10-05 | US | California | Napa | 6055 | 1768 | 11 | 0 | 1754 | 38.50735751 | -122.332839 | 2020-10-06 04:23:33 | Napa, California, US |
3390113 | 3390113 | 2020-10-02 | US | Florida | Unassigned | 90012 | 1754 | 0 | 0 | 1754 | 30.86747479 | 0.0 | 2020-10-03 04:23:40 | Unassigned, Florida, US |
1516813 | 1516813 | 2020-09-28 | US | Kentucky | Madison | 21151 | 1761 | 7 | 0 | 1754 | 37.71659336 | -84.27220275 | 2020-09-29 04:23:42 | Madison, Kentucky, US |
2582213 | 2582213 | 2020-09-27 | Russia | Penza Oblast | 10607 | 128 | 8725 | 1754 | 53.1655415 | 44.7879181 | 2020-09-28 04:23:00 | Penza Oblast, Russia | ||
2616681 | 2616681 | 2020-09-26 | US | Pennsylvania | Cumberland | 42041 | 1831 | 77 | 0 | 1754 | 40.1625372 | -77.26130755 | 2020-09-27 04:23:00 | Cumberland, Pennsylvania, US |
2653822 | 2653822 | 2020-09-23 | Kosovo | 15270 | 616 | 12900 | 1754 | 42.602636 | 20.902977 | 2020-09-24 04:23:00 | Kosovo | |||
3319305 | 3319305 | 2020-09-22 | US | Texas | Hale | 48189 | 715 | 53 | 0 | 1754 | 34.07044901 | -101.8268114 | 2020-09-23 04:23:00 | Hale, Texas, US |
3316335 | 3316335 | 2020-09-22 | Netherlands | Flevoland | 1855 | 98 | 0 | 1754 | 52.550383 | 5.515162 | 2020-09-23 04:23:00 | Flevoland, Netherlands | ||
2839904 | 2839904 | 2020-09-21 | US | Texas | Hale | 48189 | 714 | 53 | 0 | 1754 | 34.07044901 | -101.8268114 | 2020-09-22 04:23:00 | Hale, Texas, US |
549062 | 549062 | 2020-09-12 | US | North Carolina | Henderson | 37089 | 1814 | 60 | 0 | 1754 | 35.33788927 | -82.4766782 | 2020-09-13 04:30:52 | Henderson, North Carolina, US |
1173387 | 1173387 | 2020-09-10 | Russia | Kemerovo Oblast | 7304 | 49 | 5501 | 1754 | 54.53357809999999 | 87.342861 | 2020-09-11 04:46:23 | Kemerovo Oblast, Russia | ||
2172033 | 2172033 | 2020-09-09 | US | Arkansas | Lincoln | 5079 | 1767 | 13 | 0 | 1754 | 33.95317155 | -91.74002806 | 2020-09-10 04:29:01 | Lincoln, Arkansas, US |
1244242 | 1244242 | 2020-09-08 | US | Arkansas | Lincoln | 5079 | 1767 | 13 | 0 | 1754 | 33.95317155 | -91.74002806 | 2020-09-09 04:28:48 | Lincoln, Arkansas, US |
429139 | 429139 | 2020-09-07 | US | Mississippi | Lauderdale | 28075 | 1867 | 113 | 0 | 1754 | 32.40419769 | -88.66229662 | 2020-09-08 04:28:25 | Lauderdale, Mississippi, 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]);