johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
142 rows where active = 1687 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20623 | 20623 | 2021-05-28 | Russia | Tver Oblast | 41937 | 1027 | 39223 | 1687 | 57.1134475 | 35.174442799999994 | 2021-05-29 04:20:41 | Tver Oblast, Russia | ||
83282 | 83282 | 2021-05-25 | Russia | Bashkortostan Republic | 37664 | 512 | 35465 | 1687 | 54.8573563 | 57.1439682 | 2021-05-26 04:20:35 | Bashkortostan Republic, Russia | ||
2825014 | 2825014 | 2021-05-01 | Russia | Novgorod Oblast | 29932 | 123 | 28122 | 1687 | 58.2843833 | 32.5169757 | 2021-05-02 04:20:48 | Novgorod Oblast, Russia | ||
888366 | 888366 | 2021-04-26 | Russia | Stavropol Krai | 52723 | 1339 | 49697 | 1687 | 44.86325770000001 | 43.4406913 | 2021-04-27 04:20:52 | Stavropol Krai, Russia | ||
3667411 | 3667411 | 2021-03-06 | Chile | Los Rios | 20896 | 244 | 18965 | 1687 | -40.231 | -72.3311 | 2021-03-07 05:21:54 | Los Rios, Chile | ||
3257813 | 3257813 | 2021-03-02 | Zimbabwe | 36148 | 1472 | 32989 | 1687 | -19.015438 | 29.154857 | 2021-03-03 05:23:28 | Zimbabwe | |||
3255310 | 3255310 | 2021-03-02 | US | Iowa | Cedar | 19031 | 1710 | 23 | 0 | 1687 | 41.77233777 | -91.13246684 | 2021-03-03 05:23:28 | Cedar, Iowa, US |
3254893 | 3254893 | 2021-03-02 | US | Georgia | Berrien | 13019 | 1728 | 41 | 0 | 1687 | 31.27590016 | -83.22529920000002 | 2021-03-03 05:23:28 | Berrien, Georgia, US |
280388 | 280388 | 2021-02-24 | Russia | Karachay-Cherkess Republic | 18891 | 62 | 17142 | 1687 | 43.7368326 | 41.7267991 | 2021-02-25 05:24:57 | Karachay-Cherkess Republic, Russia | ||
1937638 | 1937638 | 2021-02-23 | US | Iowa | Hamilton | 19079 | 1728 | 41 | 0 | 1687 | 42.38382428 | -93.70197703 | 2021-02-24 05:29:16 | Hamilton, Iowa, US |
531522 | 531522 | 2021-02-22 | US | Georgia | Jeff Davis | 13161 | 1730 | 43 | 0 | 1687 | 31.80405727 | -82.63724870000001 | 2021-02-23 05:23:41 | Jeff Davis, Georgia, US |
183354 | 183354 | 2021-02-21 | US | Kansas | Neosho | 20133 | 1708 | 21 | 0 | 1687 | 37.55862897 | -95.30670046 | 2021-02-22 05:24:21 | Neosho, Kansas, US |
182279 | 182279 | 2021-02-21 | Russia | Ryazan Oblast | 23958 | 278 | 21993 | 1687 | 54.42267320000001 | 40.57052460000001 | 2021-02-22 05:24:21 | Ryazan Oblast, Russia | ||
743628 | 743628 | 2021-02-20 | US | Kansas | Neosho | 20133 | 1708 | 21 | 0 | 1687 | 37.55862897 | -95.30670046 | 2021-02-21 05:24:33 | Neosho, Kansas, US |
472726 | 472726 | 2021-02-19 | US | Kansas | Neosho | 20133 | 1708 | 21 | 0 | 1687 | 37.55862897 | -95.30670046 | 2021-02-20 05:22:51 | Neosho, Kansas, US |
471247 | 471247 | 2021-02-19 | Colombia | Atlantico | 121100 | 3980 | 115433 | 1687 | 10.6966 | -74.8741 | 2021-02-20 05:22:51 | Atlantico, Colombia | ||
2286758 | 2286758 | 2021-02-14 | US | Virginia | Fredericksburg | 51630 | 1701 | 14 | 0 | 1687 | 38.2977863 | -77.4922454 | 2021-02-15 05:24:49 | Fredericksburg, Virginia, US |
2678016 | 2678016 | 2021-02-13 | Russia | Buryatia Republic | 32086 | 688 | 29711 | 1687 | 52.7182426 | 109.492143 | 2021-02-14 05:23:43 | Buryatia Republic, Russia | ||
1530888 | 1530888 | 2021-02-09 | US | Tennessee | Unicoi | 47171 | 1725 | 48 | 0 | 1687 | 36.10890856 | -82.43709629 | 2021-02-10 05:22:41 | Unicoi, Tennessee, US |
1530418 | 1530418 | 2021-02-09 | US | Oklahoma | Atoka | 40005 | 1697 | 10 | 0 | 1687 | 34.37366573 | -96.03802487 | 2021-02-10 05:22:41 | Atoka, Oklahoma, US |
614767 | 614767 | 2021-02-08 | US | Indiana | Fulton | 18049 | 1725 | 38 | 0 | 1687 | 41.0469907 | -86.26252745 | 2021-02-09 05:23:30 | Fulton, Indiana, US |
614528 | 614528 | 2021-02-08 | US | Georgia | Morgan | 13211 | 1700 | 13 | 0 | 1687 | 33.59232073 | -83.49129491 | 2021-02-09 05:23:30 | Morgan, Georgia, US |
792955 | 792955 | 2021-02-04 | US | Oklahoma | Okfuskee | 40107 | 1703 | 16 | 0 | 1687 | 35.46485198 | -96.32639984 | 2021-02-05 05:22:38 | Okfuskee, Oklahoma, US |
792662 | 792662 | 2021-02-04 | US | North Carolina | Avery | 37011 | 1703 | 16 | 0 | 1687 | 36.07569796 | -81.92308483 | 2021-02-05 05:22:38 | Avery, North Carolina, US |
792054 | 792054 | 2021-02-04 | US | Michigan | Out of MI | 80026 | 1699 | 12 | 0 | 1687 | 47.63197653 | 0.0 | 2021-02-05 05:22:38 | Out of MI, Michigan, US |
790730 | 790730 | 2021-02-04 | US | Alabama | Cherokee | 1019 | 1723 | 36 | 0 | 1687 | 34.17805983 | -85.60638968 | 2021-02-05 05:22:38 | Cherokee, Alabama, US |
343676 | 343676 | 2021-02-03 | US | Virginia | Southampton | 51175 | 1733 | 46 | 0 | 1687 | 36.72231125 | -77.10642712 | 2021-02-04 05:22:26 | Southampton, Virginia, US |
341890 | 341890 | 2021-02-03 | US | Michigan | Chippewa | 26033 | 1711 | 24 | 0 | 1687 | 46.29552653 | -84.54353449 | 2021-02-04 05:22:26 | Chippewa, Michigan, US |
3155534 | 3155534 | 2021-01-27 | US | Missouri | New Madrid | 29143 | 1728 | 41 | 0 | 1687 | 36.59666326 | -89.66070007 | 2021-01-28 05:22:24 | New Madrid, Missouri, US |
14269 | 14269 | 2021-01-26 | US | Missouri | New Madrid | 29143 | 1728 | 41 | 0 | 1687 | 36.59666326 | -89.66070007 | 2021-01-27 05:23:41 | New Madrid, Missouri, US |
437086 | 437086 | 2021-01-21 | US | Minnesota | Martin | 27091 | 1713 | 26 | 0 | 1687 | 43.67429718 | -94.55099908 | 2021-01-22 05:22:10 | Martin, Minnesota, US |
1096903 | 1096903 | 2021-01-20 | US | South Carolina | Jasper | 45053 | 1716 | 29 | 0 | 1687 | 32.43171982 | -81.02487495 | 2021-01-21 05:22:01 | Jasper, South Carolina, US |
1096700 | 1096700 | 2021-01-20 | US | Oregon | Jefferson | 41031 | 1712 | 25 | 0 | 1687 | 44.62806839 | -121.17832 | 2021-01-21 05:22:01 | Jefferson, Oregon, US |
910303 | 910303 | 2021-01-19 | US | Nevada | Churchill | 32001 | 1732 | 45 | 0 | 1687 | 39.58105744 | -118.3394607 | 2021-01-20 05:21:54 | Churchill, Nevada, US |
909648 | 909648 | 2021-01-19 | US | Kentucky | Wayne | 21231 | 1707 | 20 | 0 | 1687 | 36.80310688 | -84.8251971 | 2021-01-20 05:21:54 | Wayne, Kentucky, US |
239665 | 239665 | 2021-01-18 | US | North Dakota | Walsh | 38099 | 1693 | 23 | 0 | 1687 | 48.36876964 | -97.72574783 | 2021-01-19 05:22:15 | Walsh, North Dakota, US |
3504532 | 3504532 | 2021-01-17 | US | Iowa | Delaware | 19055 | 1723 | 36 | 0 | 1687 | 42.47104597 | -91.3664492 | 2021-01-18 05:22:34 | Delaware, Iowa, US |
3503870 | 3503870 | 2021-01-17 | US | Arkansas | Randolph | 5121 | 1731 | 44 | 0 | 1687 | 36.3415714 | -91.02455531 | 2021-01-18 05:22:34 | Randolph, Arkansas, US |
3101780 | 3101780 | 2021-01-16 | US | Alabama | Barbour | 1005 | 1723 | 36 | 0 | 1687 | 31.868263 | -85.3871286 | 2021-01-17 05:22:17 | Barbour, Alabama, US |
3882994 | 3882994 | 2021-01-14 | US | Washington | Adams | 53001 | 1704 | 17 | 0 | 1687 | 46.98299757 | -118.5601734 | 2021-01-15 05:22:24 | Adams, Washington, US |
3881238 | 3881238 | 2021-01-14 | US | Michigan | Oceana | 26127 | 1731 | 44 | 0 | 1687 | 43.64124435 | -86.26726673 | 2021-01-15 05:22:24 | Oceana, Michigan, US |
3880208 | 3880208 | 2021-01-14 | US | Colorado | Otero | 8089 | 1779 | 59 | 0 | 1687 | 37.9014485 | -103.7173385 | 2021-01-15 05:22:24 | Otero, Colorado, US |
155763 | 155763 | 2021-01-08 | US | Mississippi | Chickasaw | 28017 | 1728 | 41 | 0 | 1687 | 33.91983202 | -88.9481545 | 2021-01-09 05:22:18 | Chickasaw, Mississippi, US |
154791 | 154791 | 2021-01-08 | US | Georgia | Hart | 13147 | 1721 | 34 | 0 | 1687 | 34.34626973 | -82.96567682 | 2021-01-09 05:22:18 | Hart, Georgia, US |
2231000 | 2231000 | 2021-01-02 | US | West Virginia | Logan | 54045 | 1746 | 59 | 0 | 1687 | 37.8299889 | -81.93528571 | 2021-01-03 05:22:52 | Logan, West Virginia, US |
2229032 | 2229032 | 2021-01-02 | US | Louisiana | Plaquemines | 22075 | 1708 | 21 | 0 | 1687 | 29.42245447 | -89.60322085 | 2021-01-03 05:22:52 | Plaquemines, Louisiana, US |
1138396 | 1138396 | 2021-01-01 | US | Louisiana | Plaquemines | 22075 | 1708 | 21 | 0 | 1687 | 29.42245447 | -89.60322085 | 2021-01-02 05:22:33 | Plaquemines, Louisiana, US |
3697372 | 3697372 | 2020-12-31 | US | Missouri | Crawford | 29055 | 1706 | 19 | 0 | 1687 | 37.97663738 | -91.30528104 | 2021-01-01 05:23:07 | Crawford, Missouri, US |
3697002 | 3697002 | 2020-12-31 | US | Louisiana | Plaquemines | 22075 | 1708 | 21 | 0 | 1687 | 29.42245447 | -89.60322085 | 2021-01-01 05:23:07 | Plaquemines, Louisiana, US |
1011794 | 1011794 | 2020-12-30 | US | Louisiana | De Soto | 22031 | 1738 | 51 | 0 | 1687 | 32.05457447 | -93.74130302 | 2020-12-31 05:22:49 | De Soto, Louisiana, US |
768782 | 768782 | 2020-12-29 | US | Ohio | Henry | 39069 | 1736 | 49 | 0 | 1687 | 41.3339642 | -84.06830637 | 2020-12-30 05:22:34 | Henry, Ohio, US |
767108 | 767108 | 2020-12-29 | US | Georgia | Emanuel | 13107 | 1740 | 53 | 0 | 1687 | 32.59221302 | -82.30239915 | 2020-12-30 05:22:34 | Emanuel, Georgia, US |
3779871 | 3779871 | 2020-12-27 | US | Missouri | Washington | 29221 | 1726 | 39 | 0 | 1687 | 37.96130078 | -90.87948158 | 2020-12-28 05:22:06 | Washington, Missouri, US |
2225274 | 2225274 | 2020-12-26 | US | Minnesota | Waseca | 27161 | 1699 | 12 | 0 | 1687 | 44.02211116 | -93.58720034 | 2020-12-27 05:22:55 | Waseca, Minnesota, US |
2224303 | 2224303 | 2020-12-26 | US | Georgia | Franklin | 13119 | 1713 | 26 | 0 | 1687 | 34.37525597 | -83.23159927 | 2020-12-27 05:22:55 | Franklin, Georgia, US |
204028 | 204028 | 2020-12-25 | US | Mississippi | Adams | 28001 | 1744 | 57 | 0 | 1687 | 31.47669768 | -91.35326037 | 2020-12-26 05:22:28 | Adams, Mississippi, US |
2407637 | 2407637 | 2020-12-23 | US | Georgia | Haralson | 13143 | 1725 | 38 | 0 | 1687 | 33.79602175 | -85.21005667 | 2020-12-24 05:23:04 | Haralson, Georgia, US |
931076 | 931076 | 2020-12-21 | US | Virginia | Prince George | 51149 | 1694 | 7 | 0 | 1687 | 37.18497668 | -77.22922187 | 2020-12-22 05:22:33 | Prince George, Virginia, US |
2120835 | 2120835 | 2020-12-20 | US | Indiana | Randolph | 18135 | 1732 | 45 | 0 | 1687 | 40.15734772 | -85.01139319 | 2020-12-21 05:27:58 | Randolph, Indiana, US |
2128743 | 2128743 | 2020-12-17 | US | Georgia | Bryan | 13029 | 1706 | 19 | 0 | 1687 | 32.00979311 | -81.44002948 | 2020-12-18 05:28:18 | Bryan, Georgia, US |
3150223 | 3150223 | 2020-12-16 | US | Colorado | Montrose | 8085 | 2014 | 33 | 0 | 1687 | 38.40214114 | -108.26390220000002 | 2020-12-17 05:28:12 | Montrose, Colorado, US |
1752850 | 1752850 | 2020-12-14 | US | Maryland | Worcester | 24047 | 1727 | 40 | 0 | 1687 | 38.21274277 | -75.33200012 | 2020-12-15 05:26:38 | Worcester, Maryland, US |
1751462 | 1751462 | 2020-12-14 | Russia | Dagestan Republic | 20823 | 1034 | 18102 | 1687 | 43.05749160000001 | 47.1332224 | 2020-12-15 05:26:38 | Dagestan Republic, Russia | ||
849055 | 849055 | 2020-12-12 | US | West Virginia | Mercer | 54055 | 1732 | 45 | 0 | 1687 | 37.40481169 | -81.11023142 | 2020-12-13 05:27:20 | Mercer, West Virginia, US |
1819876 | 1819876 | 2020-12-08 | US | Indiana | Huntington | 18069 | 1700 | 13 | 0 | 1687 | 40.82907273 | -85.48822092 | 2020-12-09 05:28:01 | Huntington, Indiana, US |
1009233 | 1009233 | 2020-12-06 | US | Tennessee | Haywood | 47075 | 1703 | 30 | 0 | 1687 | 35.58332824 | -89.28536625 | 2020-12-07 05:26:14 | Haywood, Tennessee, US |
1007168 | 1007168 | 2020-12-06 | US | Georgia | Toombs | 13279 | 1757 | 70 | 0 | 1687 | 32.12059861 | -82.32957247 | 2020-12-07 05:26:14 | Toombs, Georgia, US |
3860953 | 3860953 | 2020-12-04 | US | Indiana | Ripley | 18137 | 1713 | 26 | 0 | 1687 | 39.10235626 | -85.26212744 | 2020-12-05 05:27:36 | Ripley, Indiana, US |
77557 | 77557 | 2020-12-03 | US | Ohio | Jefferson | 39081 | 1723 | 36 | 0 | 1687 | 40.38614126 | -80.76259514 | 2020-12-04 05:27:27 | Jefferson, Ohio, US |
77029 | 77029 | 2020-12-03 | US | Missouri | Pulaski | 29169 | 1710 | 23 | 0 | 1687 | 37.82462075 | -92.20783203 | 2020-12-04 05:27:27 | Pulaski, Missouri, US |
739753 | 739753 | 2020-12-02 | US | Kentucky | Pulaski | 21199 | 1700 | 13 | 0 | 1687 | 37.10466131 | -84.57629079 | 2020-12-03 05:28:22 | Pulaski, Kentucky, US |
3567719 | 3567719 | 2020-11-29 | US | Iowa | Benton | 19011 | 1706 | 19 | 0 | 1687 | 42.08011739 | -92.06463573 | 2020-11-30 05:26:13 | Benton, Iowa, US |
3566298 | 3566298 | 2020-11-29 | Brazil | Alagoas | 94859 | 2336 | 90836 | 1687 | -9.5713 | -36.782 | 2020-11-30 05:26:13 | Alagoas, Brazil | ||
394403 | 394403 | 2020-11-27 | US | New Jersey | Salem | 34033 | 1779 | 92 | 0 | 1687 | 39.58719656 | -75.34696629999998 | 2020-11-28 05:25:50 | Salem, New Jersey, US |
1352890 | 1352890 | 2020-11-24 | US | Oklahoma | Okmulgee | 40111 | 1707 | 20 | 0 | 1687 | 35.64661916 | -95.96432828 | 2020-11-25 05:27:20 | Okmulgee, Oklahoma, US |
3193282 | 3193282 | 2020-11-22 | US | Virginia | Bedford | 51019 | 1706 | 19 | 0 | 1687 | 37.3080028 | -79.5281964 | 2020-11-23 05:25:26 | Bedford, Virginia, US |
3191067 | 3191067 | 2020-11-22 | US | Indiana | Gibson | 18051 | 1716 | 29 | 0 | 1687 | 38.30393723 | -87.58054938 | 2020-11-23 05:25:26 | Gibson, Indiana, US |
3837442 | 3837442 | 2020-11-21 | US | Illinois | Christian | 17021 | 1719 | 32 | 0 | 1687 | 39.54581621 | -89.27780482 | 2020-11-22 05:25:45 | Christian, Illinois, US |
824899 | 824899 | 2020-11-19 | US | Virginia | Frederick | 51069 | 1704 | 17 | 0 | 1687 | 39.20172582 | -78.25974949 | 2020-11-20 05:26:28 | Frederick, Virginia, US |
3341165 | 3341165 | 2020-11-17 | US | Oklahoma | Osage | 40113 | 1705 | 18 | 0 | 1687 | 36.62888819 | -96.39635704 | 2020-11-18 05:40:31 | Osage, Oklahoma, US |
2883199 | 2883199 | 2020-11-15 | US | Tennessee | Wayne | 47181 | 1714 | 8 | 0 | 1687 | 35.23868267 | -87.78644456 | 2020-11-16 05:25:57 | Wayne, Tennessee, US |
2918497 | 2918497 | 2020-11-14 | US | Virginia | Culpeper | 51047 | 1705 | 18 | 0 | 1687 | 38.48199985 | -77.95630870000002 | 2020-11-15 05:26:53 | Culpeper, Virginia, US |
1730321 | 1730321 | 2020-11-08 | US | Mississippi | Sunflower | 28133 | 1740 | 53 | 0 | 1687 | 33.60192578 | -90.58882684 | 2020-11-09 05:25:45 | Sunflower, Mississippi, US |
1544623 | 1544623 | 2020-11-07 | US | Florida | DeSoto | 12027 | 1717 | 30 | 0 | 1687 | 27.18677893 | -81.80941373 | 2020-11-08 05:24:56 | DeSoto, Florida, US |
895706 | 895706 | 2020-11-05 | US | Wyoming | Albany | 56001 | 1693 | 6 | 0 | 1687 | 41.65498705 | -105.7235415 | 2020-11-06 05:24:55 | Albany, Wyoming, US |
2920169 | 2920169 | 2020-11-04 | US | Illinois | Jackson | 17077 | 1713 | 26 | 0 | 1687 | 37.78595185 | -89.38232563 | 2020-11-05 06:05:03 | Jackson, Illinois, US |
2500789 | 2500789 | 2020-11-03 | US | Puerto Rico | Trujillo Alto | 72139 | 1687 | 0 | 0 | 1687 | 18.336159 | -65.99888399999999 | 2020-11-04 05:25:09 | Trujillo Alto, Puerto Rico, US |
3305726 | 3305726 | 2020-11-02 | US | Louisiana | Washington | 22117 | 1759 | 72 | 0 | 1687 | 30.85288548 | -90.03866652 | 2020-11-03 06:00:16 | Washington, Louisiana, US |
213189 | 213189 | 2020-10-29 | US | Tennessee | Lawrence | 47099 | 1700 | 20 | 0 | 1687 | 35.21675201 | -87.39787695 | 2020-10-30 04:24:49 | Lawrence, Tennessee, US |
3652609 | 3652609 | 2020-10-24 | US | Illinois | Vermilion | 17183 | 1697 | 10 | 0 | 1687 | 40.18417171 | -87.73384359 | 2020-10-25 04:24:36 | Vermilion, Illinois, US |
1056838 | 1056838 | 2020-10-23 | US | Texas | Bowie | 48037 | 1994 | 72 | 0 | 1687 | 33.44626922 | -94.41834132 | 2020-10-24 04:24:46 | Bowie, Texas, US |
1177739 | 1177739 | 2020-10-22 | Russia | Tambov Oblast | 9082 | 46 | 7349 | 1687 | 52.9019574 | 41.3578918 | 2020-10-23 04:24:46 | Tambov Oblast, Russia | ||
3992422 | 3992422 | 2020-10-20 | US | Mississippi | Lowndes | 28087 | 1749 | 62 | 0 | 1687 | 33.47386518 | -88.44191529999998 | 2020-10-21 04:24:14 | Lowndes, Mississippi, US |
3990811 | 3990811 | 2020-10-20 | Russia | Kamchatka Krai | 5216 | 70 | 3459 | 1687 | 57.1914882 | 160.03838190000005 | 2020-10-21 04:24:14 | Kamchatka Krai, Russia | ||
3990377 | 3990377 | 2020-10-20 | Canada | British Columbia | 11854 | 254 | 9913 | 1687 | 53.7267 | -127.6476 | 2020-10-21 04:24:14 | British Columbia, Canada | ||
2291231 | 2291231 | 2020-10-12 | Chile | Biobio | 25761 | 383 | 23691 | 1687 | -37.4464 | -72.1416 | 2020-10-13 04:24:02 | Biobio, Chile | ||
3787473 | 3787473 | 2020-10-11 | US | Massachusetts | Barnstable | 25001 | 1863 | 160 | 0 | 1687 | 41.72980578 | -70.28854339 | 2020-10-12 04:23:45 | Barnstable, Massachusetts, US |
2603520 | 2603520 | 2020-10-10 | US | Louisiana | East Feliciana | 22037 | 1761 | 74 | 0 | 1687 | 30.84425359 | -91.04976723 | 2020-10-11 04:23:46 | East Feliciana, Louisiana, US |
820176 | 820176 | 2020-10-09 | US | Oregon | Lane | 41039 | 1708 | 21 | 0 | 1687 | 43.93727035 | -122.847753 | 2020-10-10 04:23:57 | Lane, Oregon, US |
819053 | 819053 | 2020-10-09 | US | Louisiana | East Feliciana | 22037 | 1761 | 74 | 0 | 1687 | 30.84425359 | -91.04976723 | 2020-10-10 04:23:57 | East Feliciana, Louisiana, 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]);