johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
134 rows where active = 1694 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015614 | 3015614 | 2021-08-01 | Russia | Yamalo-Nenets Autonomous Okrug | 43757 | 480 | 41583 | 1694 | 67.1471631 | 74.3415488 | 2021-08-02 04:21:36 | Yamalo-Nenets Autonomous Okrug, Russia | ||
2299129 | 2299129 | 2021-06-24 | Malaysia | Perak | 25467 | 124 | 23649 | 1694 | 4.5921 | 101.0901 | 2021-06-25 04:21:33 | Perak, Malaysia | ||
3358456 | 3358456 | 2021-06-21 | Chile | Coquimbo | 43475 | 783 | 40998 | 1694 | -29.959 | -71.3389 | 2021-06-22 04:21:34 | Coquimbo, Chile | ||
51044 | 51044 | 2021-05-29 | Russia | Tver Oblast | 42010 | 1036 | 39280 | 1694 | 57.1134475 | 35.174442799999994 | 2021-05-30 04:20:55 | Tver Oblast, Russia | ||
3675848 | 3675848 | 2021-05-04 | Russia | Ingushetia Republic | 15476 | 187 | 13595 | 1694 | 43.11542075 | 45.01713552 | 2021-05-05 04:20:43 | Ingushetia Republic, Russia | ||
958484 | 958484 | 2021-04-25 | Ukraine | Crimea Republic* | 39973 | 1190 | 37089 | 1694 | 45.2835 | 34.2008 | 2021-04-26 04:21:04 | Crimea Republic*, Ukraine | ||
2020741 | 2020741 | 2021-04-20 | Japan | Kanagawa | 51177 | 802 | 48681 | 1694 | 35.415312 | 139.338983 | 2021-04-21 04:21:14 | Kanagawa, Japan | ||
1798578 | 1798578 | 2021-03-23 | India | Assam | 218058 | 1102 | 215262 | 1694 | 26.357149 | 92.830441 | 2021-03-24 05:25:40 | Assam, India | ||
3621018 | 3621018 | 2021-03-17 | India | Andhra Pradesh | 892522 | 7186 | 883642 | 1694 | 15.9129 | 79.74 | 2021-03-18 05:26:22 | Andhra Pradesh, India | ||
1091238 | 1091238 | 2021-03-03 | US | Iowa | Cedar | 19031 | 1717 | 23 | 0 | 1694 | 41.77233777 | -91.13246684 | 2021-03-04 05:24:24 | Cedar, Iowa, US |
2185727 | 2185727 | 2021-02-26 | US | New Hampshire | Carroll | 33003 | 1700 | 6 | 0 | 1694 | 43.87498583 | -71.20430216 | 2021-02-27 05:22:28 | Carroll, New Hampshire, US |
2183822 | 2183822 | 2021-02-26 | Russia | Ryazan Oblast | 24346 | 294 | 22358 | 1694 | 54.42267320000001 | 40.57052460000001 | 2021-02-27 05:22:28 | Ryazan Oblast, Russia | ||
1858037 | 1858037 | 2021-02-25 | Japan | Osaka | 46921 | 1106 | 44121 | 1694 | 34.620965000000005 | 135.507481 | 2021-02-26 05:22:40 | Osaka, Japan | ||
282864 | 282864 | 2021-02-24 | US | Pennsylvania | Montour | 42093 | 1752 | 58 | 0 | 1694 | 41.03023987 | -76.66345939 | 2021-02-25 05:24:57 | Montour, Pennsylvania, US |
1937267 | 1937267 | 2021-02-23 | US | Georgia | Jeff Davis | 13161 | 1738 | 44 | 0 | 1694 | 31.80405727 | -82.63724870000001 | 2021-02-24 05:29:16 | Jeff Davis, Georgia, US |
530945 | 530945 | 2021-02-22 | Russia | Ryazan Oblast | 24046 | 278 | 22074 | 1694 | 54.42267320000001 | 40.57052460000001 | 2021-02-23 05:23:41 | Ryazan Oblast, Russia | ||
185567 | 185567 | 2021-02-21 | US | Wisconsin | Crawford | 55023 | 1711 | 17 | 0 | 1694 | 43.23870316 | -90.93073686 | 2021-02-22 05:24:21 | Crawford, Wisconsin, US |
743814 | 743814 | 2021-02-20 | US | Louisiana | Jackson | 22049 | 1739 | 45 | 0 | 1694 | 32.30251776 | -92.55692092 | 2021-02-21 05:24:33 | Jackson, Louisiana, US |
472912 | 472912 | 2021-02-19 | US | Louisiana | Jackson | 22049 | 1739 | 45 | 0 | 1694 | 32.30251776 | -92.55692092 | 2021-02-20 05:22:51 | Jackson, Louisiana, US |
3602656 | 3602656 | 2021-02-17 | US | Michigan | Chippewa | 26033 | 1719 | 25 | 0 | 1694 | 46.29552653 | -84.54353449 | 2021-02-18 05:22:58 | Chippewa, Michigan, US |
3601280 | 3601280 | 2021-02-17 | Russia | Ryazan Oblast | 23605 | 269 | 21642 | 1694 | 54.42267320000001 | 40.57052460000001 | 2021-02-18 05:22:58 | Ryazan Oblast, Russia | ||
3051791 | 3051791 | 2021-02-16 | US | Michigan | Chippewa | 26033 | 1719 | 25 | 0 | 1694 | 46.29552653 | -84.54353449 | 2021-02-17 05:23:10 | Chippewa, Michigan, US |
1341186 | 1341186 | 2021-02-15 | US | Tennessee | Cannon | 47015 | 1714 | 28 | 0 | 1694 | 35.80990797 | -86.05738983 | 2021-02-16 05:24:38 | Cannon, Tennessee, US |
1339890 | 1339890 | 2021-02-15 | US | Michigan | Chippewa | 26033 | 1718 | 24 | 0 | 1694 | 46.29552653 | -84.54353449 | 2021-02-16 05:24:38 | Chippewa, Michigan, US |
2285041 | 2285041 | 2021-02-14 | US | Michigan | Chippewa | 26033 | 1718 | 24 | 0 | 1694 | 46.29552653 | -84.54353449 | 2021-02-15 05:24:49 | Chippewa, Michigan, US |
2284926 | 2284926 | 2021-02-14 | US | Louisiana | Jackson | 22049 | 1739 | 45 | 0 | 1694 | 32.30251776 | -92.55692092 | 2021-02-15 05:24:49 | Jackson, Louisiana, US |
2284583 | 2284583 | 2021-02-14 | US | Iowa | Buchanan | 19019 | 1720 | 26 | 0 | 1694 | 42.4709188 | -91.83510825 | 2021-02-15 05:24:49 | Buchanan, Iowa, US |
2679441 | 2679441 | 2021-02-13 | US | Michigan | Chippewa | 26033 | 1718 | 24 | 0 | 1694 | 46.29552653 | -84.54353449 | 2021-02-14 05:23:43 | Chippewa, Michigan, US |
3542450 | 3542450 | 2021-02-12 | US | Tennessee | Unicoi | 47171 | 1736 | 46 | 0 | 1694 | 36.10890856 | -82.43709629 | 2021-02-13 05:22:12 | Unicoi, Tennessee, US |
3542127 | 3542127 | 2021-02-12 | US | Pennsylvania | Juniata | 42067 | 1773 | 79 | 0 | 1694 | 40.53358749 | -77.39975129999998 | 2021-02-13 05:22:12 | Juniata, Pennsylvania, US |
3541898 | 3541898 | 2021-02-12 | US | Ohio | Carroll | 39019 | 1738 | 44 | 0 | 1694 | 40.5789686 | -81.09178213 | 2021-02-13 05:22:12 | Carroll, Ohio, US |
3541074 | 3541074 | 2021-02-12 | US | Michigan | Chippewa | 26033 | 1718 | 24 | 0 | 1694 | 46.29552653 | -84.54353449 | 2021-02-13 05:22:12 | Chippewa, Michigan, US |
3980192 | 3980192 | 2021-02-10 | US | Michigan | Chippewa | 26033 | 1718 | 24 | 0 | 1694 | 46.29552653 | -84.54353449 | 2021-02-11 05:23:55 | Chippewa, Michigan, US |
1528959 | 1528959 | 2021-02-09 | US | Indiana | Carroll | 18015 | 1711 | 17 | 0 | 1694 | 40.580783200000006 | -86.56198812 | 2021-02-10 05:22:41 | Carroll, Indiana, US |
613927 | 613927 | 2021-02-08 | Russia | Ryazan Oblast | 22748 | 246 | 20808 | 1694 | 54.42267320000001 | 40.57052460000001 | 2021-02-09 05:23:30 | Ryazan Oblast, Russia | ||
1672804 | 1672804 | 2021-02-07 | US | Alabama | Cherokee | 1019 | 1730 | 36 | 0 | 1694 | 34.17805983 | -85.60638968 | 2021-02-08 05:22:39 | Cherokee, Alabama, US |
1589962 | 1589962 | 2021-02-05 | US | Mississippi | Clay | 28025 | 1739 | 45 | 0 | 1694 | 33.65358105 | -88.77784255 | 2021-02-06 05:23:55 | Clay, Mississippi, US |
1588415 | 1588415 | 2021-02-05 | Russia | Ryazan Oblast | 22438 | 243 | 20501 | 1694 | 54.42267320000001 | 40.57052460000001 | 2021-02-06 05:23:55 | Ryazan Oblast, Russia | ||
341711 | 341711 | 2021-02-03 | US | Kentucky | Meade | 21163 | 1703 | 9 | 0 | 1694 | 37.96163597 | -86.21028219 | 2021-02-04 05:22:26 | Meade, Kentucky, US |
1686300 | 1686300 | 2021-02-02 | US | Mississippi | Holmes | 28051 | 1763 | 69 | 0 | 1694 | 33.12345854 | -90.08923538 | 2021-02-03 05:22:52 | Holmes, Mississippi, US |
1686091 | 1686091 | 2021-02-02 | US | Massachusetts | Franklin | 25011 | 1792 | 68 | 0 | 1694 | 42.58119713 | -72.58602547 | 2021-02-03 05:22:52 | Franklin, Massachusetts, US |
2213957 | 2213957 | 2021-01-30 | US | North Carolina | Caswell | 37033 | 1708 | 14 | 0 | 1694 | 36.39312665 | -79.33353281 | 2021-01-31 05:22:42 | Caswell, North Carolina, US |
2212131 | 2212131 | 2021-01-30 | US | Arkansas | Cleburne | 5023 | 1753 | 59 | 0 | 1694 | 35.53864922 | -92.02640019 | 2021-01-31 05:22:42 | Cleburne, Arkansas, US |
1899444 | 1899444 | 2021-01-29 | US | North Carolina | Caswell | 37033 | 1708 | 14 | 0 | 1694 | 36.39312665 | -79.33353281 | 2021-01-30 05:22:49 | Caswell, North Carolina, US |
2482423 | 2482423 | 2021-01-28 | US | Arkansas | Arkansas | 5001 | 1730 | 36 | 0 | 1694 | 34.29145151 | -91.37277296 | 2021-01-29 05:22:23 | Arkansas, Arkansas, US |
2569394 | 2569394 | 2021-01-25 | US | Minnesota | Martin | 27091 | 1720 | 26 | 0 | 1694 | 43.67429718 | -94.55099908 | 2021-01-26 05:22:02 | Martin, Minnesota, US |
2567608 | 2567608 | 2021-01-25 | India | Delhi | 634072 | 10813 | 621565 | 1694 | 28.646519 | 77.10898 | 2021-01-26 05:22:02 | Delhi, India | ||
2467267 | 2467267 | 2021-01-22 | US | Arkansas | Clark | 5019 | 1725 | 31 | 0 | 1694 | 34.04613432 | -93.17484713 | 2021-01-23 05:22:03 | Clark, Arkansas, US |
436700 | 436700 | 2021-01-21 | US | Kansas | Sumner | 20191 | 1726 | 32 | 0 | 1694 | 37.23682549 | -97.47721621 | 2021-01-22 05:22:10 | Sumner, Kansas, US |
1095431 | 1095431 | 2021-01-20 | US | Kansas | Sumner | 20191 | 1726 | 32 | 0 | 1694 | 37.23682549 | -97.47721621 | 2021-01-21 05:22:01 | Sumner, Kansas, US |
911756 | 911756 | 2021-01-19 | US | Wisconsin | Vernon | 55123 | 1728 | 34 | 0 | 1694 | 43.59422667 | -90.8324691 | 2021-01-20 05:21:54 | Vernon, Wisconsin, US |
908815 | 908815 | 2021-01-19 | US | Colorado | Pitkin | 8097 | 1799 | 4 | 0 | 1694 | 39.21720112 | -106.9310027 | 2021-01-20 05:21:54 | Pitkin, Colorado, US |
240819 | 240819 | 2021-01-18 | US | Wisconsin | Vernon | 55123 | 1728 | 34 | 0 | 1694 | 43.59422667 | -90.8324691 | 2021-01-19 05:22:15 | Vernon, Wisconsin, US |
238415 | 238415 | 2021-01-18 | US | Iowa | Delaware | 19055 | 1730 | 36 | 0 | 1694 | 42.47104597 | -91.3664492 | 2021-01-19 05:22:15 | Delaware, Iowa, US |
237580 | 237580 | 2021-01-18 | US | Alabama | Barbour | 1005 | 1730 | 36 | 0 | 1694 | 31.868263 | -85.3871286 | 2021-01-19 05:22:15 | Barbour, Alabama, US |
3504854 | 3504854 | 2021-01-17 | US | Louisiana | Grant | 22043 | 1736 | 42 | 0 | 1694 | 31.59882456 | -92.56124347 | 2021-01-18 05:22:34 | Grant, Louisiana, US |
3102863 | 3102863 | 2021-01-16 | US | Kentucky | Lincoln | 21137 | 1722 | 28 | 0 | 1694 | 37.45475628 | -84.6565327 | 2021-01-17 05:22:17 | Lincoln, Kentucky, US |
774543 | 774543 | 2021-01-12 | Russia | Ingushetia Republic | 12991 | 149 | 11148 | 1694 | 43.11542075 | 45.01713552 | 2021-01-13 05:22:15 | Ingushetia Republic, Russia | ||
2543399 | 2543399 | 2021-01-07 | US | Montana | Hill | 30041 | 1728 | 34 | 0 | 1694 | 48.62879827 | -110.1129252 | 2021-01-08 05:22:42 | Hill, Montana, US |
1136728 | 1136728 | 2021-01-01 | Colombia | Cesar | 33637 | 996 | 30947 | 1694 | 9.3373 | -73.6536 | 2021-01-02 05:22:33 | Cesar, Colombia | ||
3697307 | 3697307 | 2020-12-31 | US | Mississippi | Marion | 28091 | 1757 | 63 | 0 | 1694 | 31.23132643 | -89.8209217 | 2021-01-01 05:23:07 | Marion, Mississippi, US |
1010696 | 1010696 | 2020-12-30 | US | Alabama | Pickens | 1107 | 1720 | 26 | 0 | 1694 | 33.28094866 | -88.08818103 | 2020-12-31 05:22:49 | Pickens, Alabama, US |
3779440 | 3779440 | 2020-12-27 | US | Louisiana | West Baton Rouge | 22121 | 1741 | 47 | 0 | 1694 | 30.46058217 | -91.30989571 | 2020-12-28 05:22:06 | West Baton Rouge, Louisiana, US |
2121933 | 2121933 | 2020-12-20 | US | New York | Cortland | 36023 | 1713 | 19 | 0 | 1694 | 42.59509207 | -76.07048931 | 2020-12-21 05:27:58 | Cortland, New York, US |
1904275 | 1904275 | 2020-12-18 | US | Texas | Hockley | 48219 | 2480 | 67 | 0 | 1694 | 33.60771256 | -102.3431676 | 2020-12-19 05:27:52 | Hockley, Texas, US |
1903988 | 1903988 | 2020-12-18 | US | South Carolina | Marlboro | 45069 | 1716 | 22 | 0 | 1694 | 34.59905577 | -79.67561152 | 2020-12-19 05:27:52 | Marlboro, South Carolina, US |
1902406 | 1902406 | 2020-12-18 | US | Iowa | Washington | 19183 | 1720 | 26 | 0 | 1694 | 41.33577126 | -91.71725711 | 2020-12-19 05:27:52 | Washington, Iowa, US |
2130055 | 2130055 | 2020-12-17 | US | Nebraska | Gage | 31067 | 1704 | 10 | 0 | 1694 | 40.26186809 | -96.68946704 | 2020-12-18 05:28:18 | Gage, Nebraska, US |
3150047 | 3150047 | 2020-12-16 | US | Arkansas | Baxter | 5005 | 1736 | 42 | 0 | 1694 | 36.28784385 | -92.33782872 | 2020-12-17 05:28:12 | Baxter, Arkansas, US |
847782 | 847782 | 2020-12-12 | US | New York | Cattaraugus | 36009 | 1722 | 28 | 0 | 1694 | 42.24778241 | -78.67923096 | 2020-12-13 05:27:20 | Cattaraugus, New York, US |
860627 | 860627 | 2020-12-11 | India | Jharkhand | 111177 | 995 | 108488 | 1694 | 23.654536 | 85.557631 | 2020-12-12 05:26:19 | Jharkhand, India | ||
1600469 | 1600469 | 2020-12-10 | Russia | Tula Oblast | 18493 | 535 | 16264 | 1694 | 53.9570701 | 37.3690909 | 2020-12-11 05:26:59 | Tula Oblast, Russia | ||
1006941 | 1006941 | 2020-12-06 | US | Colorado | Summit | 8117 | 1798 | 5 | 0 | 1694 | 39.63803232 | -106.1150762 | 2020-12-07 05:26:14 | Summit, Colorado, US |
1586053 | 1586053 | 2020-11-30 | US | Missouri | Dunklin | 29069 | 1708 | 14 | 0 | 1694 | 36.27167174 | -90.09122243 | 2020-12-01 05:26:18 | Dunklin, Missouri, US |
1585782 | 1585782 | 2020-11-30 | US | Michigan | Dickinson | 26043 | 1740 | 46 | 0 | 1694 | 46.00999672 | -87.86961634 | 2020-12-01 05:26:18 | Dickinson, Michigan, US |
1585097 | 1585097 | 2020-11-30 | US | Idaho | Latah | 16057 | 1697 | 3 | 0 | 1694 | 46.81587887 | -116.7113698 | 2020-12-01 05:26:18 | Latah, Idaho, US |
3569977 | 3569977 | 2020-11-29 | US | Virginia | Washington | 51191 | 1725 | 31 | 0 | 1694 | 36.72341572 | -81.95666289 | 2020-11-30 05:26:13 | Washington, Virginia, US |
3569033 | 3569033 | 2020-11-29 | US | Ohio | Huron | 39077 | 1727 | 33 | 0 | 1694 | 41.14651175 | -82.59867951 | 2020-11-30 05:26:13 | Huron, Ohio, US |
925088 | 925088 | 2020-11-26 | US | Kentucky | Hopkins | 21107 | 1739 | 45 | 0 | 1694 | 37.30939025 | -87.54670406 | 2020-11-27 05:26:53 | Hopkins, Kentucky, US |
1973993 | 1973993 | 2020-11-25 | US | Kentucky | Hopkins | 21107 | 1739 | 45 | 0 | 1694 | 37.30939025 | -87.54670406 | 2020-11-26 05:27:44 | Hopkins, Kentucky, US |
1351158 | 1351158 | 2020-11-24 | US | Georgia | Murray | 13213 | 1715 | 21 | 0 | 1694 | 34.78897608 | -84.74993177 | 2020-11-25 05:27:20 | Murray, Georgia, US |
680970 | 680970 | 2020-11-23 | US | Pennsylvania | Fayette | 42051 | 1711 | 17 | 0 | 1694 | 39.92041012 | -79.64291195 | 2020-11-24 05:27:31 | Fayette, Pennsylvania, US |
3192573 | 3192573 | 2020-11-22 | US | Oklahoma | Sequoyah | 40135 | 1708 | 14 | 0 | 1694 | 35.49447108 | -94.75463785 | 2020-11-23 05:25:26 | Sequoyah, Oklahoma, US |
3838849 | 3838849 | 2020-11-21 | US | North Carolina | Watauga | 37189 | 1700 | 6 | 0 | 1694 | 36.23103603 | -81.70033724 | 2020-11-22 05:25:45 | Watauga, North Carolina, US |
2786562 | 2786562 | 2020-11-13 | US | Maine | York | 23031 | 1717 | 23 | 0 | 1694 | 43.47808377 | -70.71052375 | 2020-11-14 05:25:37 | York, Maine, US |
273972 | 273972 | 2020-11-10 | US | Mississippi | Marshall | 28093 | 1731 | 37 | 0 | 1694 | 34.76216286 | -89.50299462 | 2020-11-11 05:25:30 | Marshall, Mississippi, US |
1988818 | 1988818 | 2020-11-09 | Russia | Belgorod Oblast | 12758 | 61 | 11003 | 1694 | 50.7080119 | 37.5837615 | 2020-11-10 05:40:07 | Belgorod Oblast, Russia | ||
1988737 | 1988737 | 2020-11-09 | Mexico | Zacatecas | 12664 | 1063 | 9907 | 1694 | 22.7709 | -102.5832 | 2020-11-10 05:40:07 | Zacatecas, Mexico | ||
1730837 | 1730837 | 2020-11-08 | US | North Carolina | Scotland | 37165 | 1725 | 31 | 0 | 1694 | 34.8386299 | -79.4757978 | 2020-11-09 05:25:45 | Scotland, North Carolina, US |
2498497 | 2498497 | 2020-11-03 | US | Arkansas | Greene | 5055 | 1714 | 20 | 0 | 1694 | 36.11735460000001 | -90.55832668 | 2020-11-04 05:25:09 | Greene, Arkansas, US |
3305670 | 3305670 | 2020-11-02 | US | Louisiana | Avoyelles | 22009 | 1756 | 62 | 0 | 1694 | 31.07796211 | -92.00079449 | 2020-11-03 06:00:16 | Avoyelles, Louisiana, US |
8848 | 8848 | 2020-10-25 | US | Arkansas | St. Francis | 5123 | 1704 | 10 | 0 | 1694 | 35.02201976 | -90.74828138 | 2020-10-26 04:25:02 | St. Francis, Arkansas, US |
1054185 | 1054185 | 2020-10-23 | US | Alabama | Escambia | 1053 | 1724 | 30 | 0 | 1694 | 31.1256789 | -87.15918694 | 2020-10-24 04:24:46 | Escambia, Alabama, US |
1026763 | 1026763 | 2020-10-17 | US | Alaska | Fairbanks North Star | 2090 | 1707 | 13 | 0 | 1694 | 64.80726247 | -146.5692662 | 2020-10-18 04:24:25 | Fairbanks North Star, Alaska, US |
2859430 | 2859430 | 2020-10-16 | US | Oklahoma | Texas | 40139 | 1704 | 10 | 0 | 1694 | 36.74777635 | -101.4889765 | 2020-10-17 04:24:12 | Texas, Oklahoma, US |
2692353 | 2692353 | 2020-10-08 | US | Pennsylvania | Monroe | 42089 | 1828 | 134 | 0 | 1694 | 41.05934058 | -75.34031025 | 2020-10-09 04:23:59 | Monroe, Pennsylvania, US |
970463 | 970463 | 2020-09-29 | US | Wisconsin | Sheboygan | 55117 | 1710 | 16 | 0 | 1694 | 43.72099677 | -87.94579284 | 2020-09-30 04:23:33 | Sheboygan, Wisconsin, US |
968661 | 968661 | 2020-09-29 | US | Minnesota | Wright | 27171 | 1701 | 7 | 0 | 1694 | 45.17297924 | -93.96234781 | 2020-09-30 04:23:33 | Wright, Minnesota, US |
2457750 | 2457750 | 2020-09-19 | US | Tennessee | Tipton | 47167 | 1727 | 17 | 0 | 1694 | 35.501942 | -89.73694895 | 2020-09-20 04:22:00 | Tipton, Tennessee, US |
1122382 | 1122382 | 2020-09-17 | US | Georgia | Gordon | 13129 | 1729 | 35 | 0 | 1694 | 34.50487351 | -84.87296253 | 2020-09-18 05:05:00 | Gordon, 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]);