johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
159 rows where active = 1492 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 19
- US 126
- Russia 15
- Germany 2
- Bulgaria 1
- Burundi 1
- Canada 1
- Chile 1
- Colombia 1
- Cote d'Ivoire 1
- Haiti 1
- India 1
- Japan 1
- Kyrgyzstan 1
- Lithuania 1
- Netherlands 1
- Nigeria 1
- Trinidad and Tobago 1
- Turkey 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3218207 | 3218207 | 2021-07-26 | Germany | Berlin | 181714 | 3578 | 176900 | 1492 | 52.52 | 13.405 | 2021-07-27 04:21:18 | Berlin, Germany | ||
1932626 | 1932626 | 2021-07-05 | Russia | Astrakhan Oblast | 36956 | 881 | 34583 | 1492 | 47.1878186 | 47.608851 | 2021-07-06 04:21:32 | Astrakhan Oblast, Russia | ||
1564229 | 1564229 | 2021-06-14 | Nigeria | 167078 | 2117 | 163469 | 1492 | 9.082 | 8.6753 | 2021-06-15 04:22:22 | Nigeria | |||
1552217 | 1552217 | 2021-05-08 | Russia | Stavropol Krai | 53483 | 1397 | 50594 | 1492 | 44.86325770000001 | 43.4406913 | 2021-05-09 04:20:35 | Stavropol Krai, Russia | ||
3113714 | 3113714 | 2021-05-06 | Russia | Novgorod Oblast | 30117 | 126 | 28499 | 1492 | 58.2843833 | 32.5169757 | 2021-05-07 04:20:40 | Novgorod Oblast, Russia | ||
380425 | 380425 | 2021-04-30 | Russia | Orel Oblast | 34125 | 575 | 32058 | 1492 | 52.96854329999999 | 36.0692477 | 2021-05-01 04:20:47 | Orel Oblast, Russia | ||
2247306 | 2247306 | 2021-04-07 | Germany | Bremen | 21550 | 411 | 19790 | 1492 | 53.0793 | 8.8017 | 2021-04-08 04:21:13 | Bremen, Germany | ||
388476 | 388476 | 2021-04-04 | Russia | Tyumen Oblast | 33817 | 414 | 31911 | 1492 | 58.8206488 | 70.36588370000001 | 2021-04-05 04:20:35 | Tyumen Oblast, Russia | ||
3643588 | 3643588 | 2021-03-30 | Japan | Saitama | 32673 | 700 | 30481 | 1492 | 35.997101 | 139.347635 | 2021-03-31 04:26:25 | Saitama, Japan | ||
1884650 | 1884650 | 2021-03-26 | Yemen | 3900 | 820 | 1588 | 1492 | 15.552727 | 48.516388 | 2021-03-27 05:25:04 | Yemen | |||
702621 | 702621 | 2021-03-16 | Russia | Kurgan Oblast | 18557 | 340 | 16725 | 1492 | 55.7655302 | 64.5632681 | 2021-03-17 05:25:07 | Kurgan Oblast, Russia | ||
1732550 | 1732550 | 2021-03-14 | Kyrgyzstan | 86850 | 1483 | 83875 | 1492 | 41.20438 | 74.766098 | 2021-03-15 05:25:51 | Kyrgyzstan | |||
2207413 | 2207413 | 2021-03-04 | Burundi | 2268 | 3 | 773 | 1492 | -3.3731 | 29.9189 | 2021-03-05 05:26:29 | Burundi | |||
1092021 | 1092021 | 2021-03-03 | US | Missouri | Ray | 29177 | 1517 | 25 | 0 | 1492 | 39.3537468 | -93.98905745 | 2021-03-04 05:24:24 | Ray, Missouri, US |
3257211 | 3257211 | 2021-03-02 | US | Texas | Dimmit | 48127 | 1611 | 22 | 0 | 1492 | 28.42270064 | -99.75645095 | 2021-03-03 05:23:28 | Dimmit, Texas, US |
3253924 | 3253924 | 2021-03-02 | Canada | Saskatchewan | 28938 | 387 | 27059 | 1492 | 52.9399 | -106.4509 | 2021-03-03 05:23:28 | Saskatchewan, Canada | ||
2369443 | 2369443 | 2021-02-28 | US | Missouri | Ray | 29177 | 1516 | 24 | 0 | 1492 | 39.3537468 | -93.98905745 | 2021-03-01 05:23:01 | Ray, Missouri, US |
3067945 | 3067945 | 2021-02-27 | US | Missouri | Ray | 29177 | 1516 | 24 | 0 | 1492 | 39.3537468 | -93.98905745 | 2021-02-28 05:22:20 | Ray, Missouri, US |
2186728 | 2186728 | 2021-02-26 | US | Texas | Leon | 48289 | 1885 | 36 | 0 | 1492 | 31.29872538 | -95.9936328 | 2021-02-27 05:22:28 | Leon, Texas, US |
283129 | 283129 | 2021-02-24 | US | Tennessee | Humphreys | 47085 | 1549 | 21 | 0 | 1492 | 36.03958805 | -87.77992872 | 2021-02-25 05:24:57 | Humphreys, Tennessee, US |
281854 | 281854 | 2021-02-24 | US | Michigan | Out of MI | 80026 | 1502 | 10 | 0 | 1492 | 47.63197653 | 0.0 | 2021-02-25 05:24:57 | Out of MI, Michigan, US |
530896 | 530896 | 2021-02-22 | Russia | Buryatia Republic | 33020 | 703 | 30825 | 1492 | 52.7182426 | 109.492143 | 2021-02-23 05:23:41 | Buryatia Republic, Russia | ||
1152991 | 1152991 | 2021-02-18 | Cote d'Ivoire | 31612 | 183 | 29937 | 1492 | 7.54 | -5.5471 | 2021-02-19 05:24:16 | Cote d'Ivoire | |||
2284789 | 2284789 | 2021-02-14 | US | Kentucky | Bourbon | 21017 | 1499 | 7 | 0 | 1492 | 38.2054607 | -84.21827874 | 2021-02-15 05:24:49 | Bourbon, Kentucky, US |
2641120 | 2641120 | 2021-02-11 | US | Virginia | Scott | 51169 | 1538 | 46 | 0 | 1492 | 36.71466456 | -82.60171704 | 2021-02-12 05:23:29 | Scott, Virginia, US |
1529677 | 1529677 | 2021-02-09 | US | Mississippi | Calhoun | 28013 | 1517 | 25 | 0 | 1492 | 33.93683395 | -89.33686647 | 2021-02-10 05:22:41 | Calhoun, Mississippi, US |
1528148 | 1528148 | 2021-02-09 | Russia | Tula Oblast | 30416 | 1094 | 27830 | 1492 | 53.9570701 | 37.3690909 | 2021-02-10 05:22:41 | Tula Oblast, Russia | ||
1674949 | 1674949 | 2021-02-07 | US | Ohio | Paulding | 39125 | 1528 | 36 | 0 | 1492 | 41.11676341 | -84.5801017 | 2021-02-08 05:22:39 | Paulding, Ohio, US |
343784 | 343784 | 2021-02-03 | US | West Virginia | Upshur | 54097 | 1517 | 25 | 0 | 1492 | 38.89285061 | -80.23689136 | 2021-02-04 05:22:26 | Upshur, West Virginia, US |
343267 | 343267 | 2021-02-03 | US | Tennessee | Union | 47173 | 1578 | 25 | 0 | 1492 | 36.28590426 | -83.83651902 | 2021-02-04 05:22:26 | Union, Tennessee, US |
1687821 | 1687821 | 2021-02-02 | US | Virginia | Dinwiddie | 51053 | 1510 | 18 | 0 | 1492 | 37.07544585 | -77.63451754 | 2021-02-03 05:22:52 | Dinwiddie, Virginia, US |
1462098 | 1462098 | 2021-01-31 | US | North Carolina | Northampton | 37131 | 1519 | 27 | 0 | 1492 | 36.41736238 | -77.39769443 | 2021-02-01 05:22:53 | Northampton, North Carolina, US |
2212805 | 2212805 | 2021-01-30 | US | Indiana | Vermillion | 18165 | 1528 | 36 | 0 | 1492 | 39.8523352 | -87.46160542 | 2021-01-31 05:22:42 | Vermillion, Indiana, US |
2568365 | 2568365 | 2021-01-25 | US | Florida | Lafayette | 12067 | 1515 | 23 | 0 | 1492 | 29.98484137 | -83.18166636 | 2021-01-26 05:22:02 | Lafayette, Florida, US |
1759997 | 1759997 | 2021-01-24 | US | Florida | Lafayette | 12067 | 1515 | 23 | 0 | 1492 | 29.98484137 | -83.18166636 | 2021-01-25 05:22:16 | Lafayette, Florida, US |
2467798 | 2467798 | 2021-01-22 | US | Illinois | Jo Daviess | 17085 | 1513 | 21 | 0 | 1492 | 42.36542373 | -90.21094405 | 2021-01-23 05:22:03 | Jo Daviess, Illinois, US |
2467578 | 2467578 | 2021-01-22 | US | Georgia | Cook | 13075 | 1525 | 33 | 0 | 1492 | 31.16068491 | -83.42947229 | 2021-01-23 05:22:03 | Cook, Georgia, US |
909290 | 909290 | 2021-01-19 | US | Indiana | Orange | 18117 | 1529 | 37 | 0 | 1492 | 38.54118920000001 | -86.49523093 | 2021-01-20 05:21:54 | Orange, Indiana, US |
238820 | 238820 | 2021-01-18 | US | Maryland | Talbot | 24041 | 1508 | 16 | 0 | 1492 | 38.76618159 | -76.10882561 | 2021-01-19 05:22:15 | Talbot, Maryland, US |
3504388 | 3504388 | 2021-01-17 | US | Illinois | Richland | 17159 | 1527 | 35 | 0 | 1492 | 38.71240969 | -88.08475366 | 2021-01-18 05:22:34 | Richland, Illinois, US |
3101372 | 3101372 | 2021-01-16 | Haiti | 10635 | 238 | 8905 | 1492 | 18.9712 | -72.2852 | 2021-01-17 05:22:17 | Haiti | |||
3515773 | 3515773 | 2021-01-15 | US | Alabama | Henry | 1067 | 1511 | 19 | 0 | 1492 | 31.51148016 | -85.24267944 | 2021-01-16 05:22:40 | Henry, Alabama, US |
3879791 | 3879791 | 2021-01-14 | Russia | Kurgan Oblast | 13478 | 202 | 11784 | 1492 | 55.7655302 | 64.5632681 | 2021-01-15 05:22:24 | Kurgan Oblast, Russia | ||
3311259 | 3311259 | 2021-01-13 | US | Texas | Dawson | 48115 | 1196 | 59 | 0 | 1492 | 32.74255572 | -101.9477242 | 2021-01-14 05:22:32 | Dawson, Texas, US |
3310161 | 3310161 | 2021-01-13 | US | Missouri | Ste. Genevieve | 29186 | 1503 | 11 | 0 | 1492 | 37.89090059 | -90.1949941 | 2021-01-14 05:22:32 | Ste. Genevieve, Missouri, US |
3308666 | 3308666 | 2021-01-13 | US | Arkansas | Cleburne | 5023 | 1537 | 45 | 0 | 1492 | 35.53864922 | -92.02640019 | 2021-01-14 05:22:32 | Cleburne, Arkansas, US |
775275 | 775275 | 2021-01-12 | US | Idaho | Gem | 16045 | 1514 | 22 | 0 | 1492 | 44.06482372 | -116.398376 | 2021-01-13 05:22:15 | Gem, Idaho, US |
190559 | 190559 | 2021-01-11 | US | Arkansas | Lee | 5077 | 1520 | 28 | 0 | 1492 | 34.78498904 | -90.78383866 | 2021-01-12 05:22:15 | Lee, Arkansas, US |
2626950 | 2626950 | 2021-01-10 | US | Indiana | Fulton | 18049 | 1529 | 37 | 0 | 1492 | 41.0469907 | -86.26252745 | 2021-01-11 05:21:50 | Fulton, Indiana, US |
2626662 | 2626662 | 2021-01-10 | US | Georgia | Fannin | 13111 | 1536 | 44 | 0 | 1492 | 34.86430205 | -84.316964 | 2021-01-11 05:21:50 | Fannin, Georgia, US |
3900421 | 3900421 | 2021-01-09 | US | Arkansas | Clark | 5019 | 1516 | 24 | 0 | 1492 | 34.04613432 | -93.17484713 | 2021-01-10 05:22:12 | Clark, Arkansas, US |
156476 | 156476 | 2021-01-08 | US | Ohio | Pike | 39131 | 1511 | 19 | 0 | 1492 | 39.07634001 | -83.06769584 | 2021-01-09 05:22:18 | Pike, Ohio, US |
2542563 | 2542563 | 2021-01-07 | US | Iowa | Buchanan | 19019 | 1509 | 17 | 0 | 1492 | 42.4709188 | -91.83510825 | 2021-01-08 05:22:42 | Buchanan, Iowa, US |
2541910 | 2541910 | 2021-01-07 | US | Arkansas | Ouachita | 5103 | 1526 | 34 | 0 | 1492 | 33.58839816 | -92.87795984 | 2021-01-08 05:22:42 | Ouachita, Arkansas, US |
2867045 | 2867045 | 2021-01-06 | US | North Carolina | Martin | 37117 | 1517 | 25 | 0 | 1492 | 35.84326734 | -77.10860251 | 2021-01-07 05:22:03 | Martin, North Carolina, US |
3036578 | 3036578 | 2021-01-05 | US | North Carolina | Anson | 37007 | 1519 | 27 | 0 | 1492 | 34.97403241 | -80.09953279 | 2021-01-06 05:22:16 | Anson, North Carolina, US |
3035916 | 3035916 | 2021-01-05 | US | Michigan | Chippewa | 26033 | 1507 | 15 | 0 | 1492 | 46.29552653 | -84.54353449 | 2021-01-06 05:22:16 | Chippewa, Michigan, US |
1062592 | 1062592 | 2021-01-04 | US | Georgia | Ben Hill | 13017 | 1536 | 44 | 0 | 1492 | 31.76095874 | -83.22145359 | 2021-01-05 05:21:49 | Ben Hill, Georgia, US |
1139579 | 1139579 | 2021-01-01 | US | Pennsylvania | Warren | 42123 | 1528 | 36 | 0 | 1492 | 41.81304978 | -79.26969577 | 2021-01-02 05:22:33 | Warren, Pennsylvania, US |
3762073 | 3762073 | 2020-12-28 | US | Arkansas | Lawrence | 5075 | 1526 | 34 | 0 | 1492 | 36.04188196 | -91.10867198 | 2020-12-29 05:22:37 | Lawrence, Arkansas, US |
3694176 | 3694176 | 2020-12-24 | US | Pennsylvania | Wayne | 42127 | 1508 | 16 | 0 | 1492 | 41.64938475 | -75.29956506 | 2020-12-25 05:22:48 | Wayne, Pennsylvania, US |
3773344 | 3773344 | 2020-12-22 | US | West Virginia | Fayette | 54019 | 1536 | 44 | 0 | 1492 | 38.02974928 | -81.08286634 | 2020-12-23 05:22:03 | Fayette, West Virginia, US |
1903094 | 1903094 | 2020-12-18 | US | Missouri | New Madrid | 29143 | 1518 | 26 | 0 | 1492 | 36.59666326 | -89.66070007 | 2020-12-19 05:27:52 | New Madrid, Missouri, US |
2131132 | 2131132 | 2020-12-17 | US | Texas | Lamb | 48279 | 1894 | 60 | 0 | 1492 | 34.06859623 | -102.3516289 | 2020-12-18 05:28:18 | Lamb, Texas, US |
2129985 | 2129985 | 2020-12-17 | US | Montana | Hill | 30041 | 1521 | 29 | 0 | 1492 | 48.62879827 | -110.1129252 | 2020-12-18 05:28:18 | Hill, Montana, US |
1034578 | 1034578 | 2020-12-15 | Russia | Karachay-Cherkess Republic | 13652 | 37 | 12123 | 1492 | 43.7368326 | 41.7267991 | 2020-12-16 05:28:04 | Karachay-Cherkess Republic, Russia | ||
1753706 | 1753706 | 2020-12-14 | US | Ohio | Champaign | 39021 | 1516 | 24 | 0 | 1492 | 40.13923427 | -83.76875242 | 2020-12-15 05:26:38 | Champaign, Ohio, US |
3849640 | 3849640 | 2020-12-13 | US | Mississippi | Winston | 28159 | 1529 | 37 | 0 | 1492 | 33.08747908 | -89.03391385 | 2020-12-14 05:26:27 | Winston, Mississippi, US |
864095 | 864095 | 2020-12-11 | US | Washington | Adams | 53001 | 1505 | 13 | 0 | 1492 | 46.98299757 | -118.5601734 | 2020-12-12 05:26:19 | Adams, Washington, US |
1009096 | 1009096 | 2020-12-06 | US | South Carolina | Colleton | 45029 | 1543 | 51 | 0 | 1492 | 32.87582989 | -80.67641292 | 2020-12-07 05:26:14 | Colleton, South Carolina, US |
78230 | 78230 | 2020-12-03 | US | Texas | Lavaca | 48285 | 1417 | 44 | 0 | 1492 | 29.38508402 | -96.93186692 | 2020-12-04 05:27:27 | Lavaca, Texas, US |
394068 | 394068 | 2020-11-27 | US | Mississippi | Scott | 28123 | 1521 | 29 | 0 | 1492 | 32.406704100000006 | -89.53789439 | 2020-11-28 05:25:50 | Scott, Mississippi, US |
926590 | 926590 | 2020-11-26 | US | Tennessee | Campbell | 47013 | 1492 | 23 | 0 | 1492 | 36.40355516 | -84.15108559999999 | 2020-11-27 05:26:53 | Campbell, Tennessee, US |
925244 | 925244 | 2020-11-26 | US | Maryland | Calvert | 24009 | 1528 | 36 | 0 | 1492 | 38.53961642 | -76.56820632 | 2020-11-27 05:26:53 | Calvert, Maryland, US |
1975499 | 1975499 | 2020-11-25 | US | Tennessee | Cheatham | 47021 | 1497 | 16 | 0 | 1492 | 36.26136216 | -87.08903581 | 2020-11-26 05:27:44 | Cheatham, Tennessee, US |
1974764 | 1974764 | 2020-11-25 | US | New Mexico | Cibola | 35006 | 1532 | 40 | 0 | 1492 | 34.91131525 | -107.998876 | 2020-11-26 05:27:44 | Cibola, New Mexico, US |
1352258 | 1352258 | 2020-11-24 | US | Missouri | Pulaski | 29169 | 1509 | 17 | 0 | 1492 | 37.82462075 | -92.20783203 | 2020-11-25 05:27:20 | Pulaski, Missouri, US |
680811 | 680811 | 2020-11-23 | US | Ohio | Sandusky | 39143 | 1523 | 31 | 0 | 1492 | 41.35624126 | -83.137872 | 2020-11-24 05:27:31 | Sandusky, Ohio, US |
680212 | 680212 | 2020-11-23 | US | Missouri | Howell | 29091 | 1518 | 26 | 0 | 1492 | 36.77383887 | -91.88683935 | 2020-11-24 05:27:31 | Howell, Missouri, US |
824980 | 824980 | 2020-11-19 | US | Virginia | Washington | 51191 | 1521 | 29 | 0 | 1492 | 36.72341572 | -81.95666289 | 2020-11-20 05:26:28 | Washington, Virginia, US |
823064 | 823064 | 2020-11-19 | US | Louisiana | Franklin | 22041 | 1548 | 56 | 0 | 1492 | 32.13675181 | -91.67589857 | 2020-11-20 05:26:28 | Franklin, Louisiana, US |
124544 | 124544 | 2020-11-18 | US | Mississippi | Tate | 28137 | 1539 | 47 | 0 | 1492 | 34.65133709 | -89.94485778 | 2020-11-19 05:25:23 | Tate, Mississippi, US |
123053 | 123053 | 2020-11-18 | US | Alabama | Clarke | 1025 | 1511 | 19 | 0 | 1492 | 31.68099859 | -87.83548597 | 2020-11-19 05:25:23 | Clarke, Alabama, US |
2882483 | 2882483 | 2020-11-15 | US | North Carolina | Beaufort | 37013 | 1544 | 52 | 0 | 1492 | 35.48531943 | -76.84325809 | 2020-11-16 05:25:57 | Beaufort, North Carolina, US |
2918477 | 2918477 | 2020-11-14 | US | Virginia | Bedford | 51019 | 1510 | 18 | 0 | 1492 | 37.3080028 | -79.5281964 | 2020-11-15 05:26:53 | Bedford, Virginia, US |
2916121 | 2916121 | 2020-11-14 | US | Idaho | Minidoka | 16067 | 1504 | 12 | 0 | 1492 | 42.85518524 | -113.6357257 | 2020-11-15 05:26:53 | Minidoka, Idaho, US |
2785615 | 2785615 | 2020-11-13 | US | Colorado | Garfield | 8045 | 1819 | 11 | 0 | 1492 | 39.59921777 | -107.902708 | 2020-11-14 05:25:37 | Garfield, Colorado, US |
275109 | 275109 | 2020-11-10 | US | Tennessee | Macon | 47111 | 1518 | 26 | 0 | 1492 | 36.53157855 | -86.00778595 | 2020-11-11 05:25:30 | Macon, Tennessee, US |
272716 | 272716 | 2020-11-10 | US | California | San Benito | 6069 | 1507 | 15 | 0 | 1492 | 36.60308176 | -121.069975 | 2020-11-11 05:25:30 | San Benito, California, US |
1545809 | 1545809 | 2020-11-07 | US | Missouri | Butler | 29023 | 1500 | 8 | 0 | 1492 | 36.71462476 | -90.40421163 | 2020-11-08 05:24:56 | Butler, Missouri, US |
377220 | 377220 | 2020-11-06 | US | Illinois | Stephenson | 17177 | 1504 | 12 | 0 | 1492 | 42.35129217 | -89.662598 | 2020-11-07 05:24:52 | Stephenson, Illinois, US |
895189 | 895189 | 2020-11-05 | US | Texas | Erath | 48143 | 1113 | 18 | 0 | 1492 | 32.23602653 | -98.21773417 | 2020-11-06 05:24:55 | Erath, Texas, US |
894919 | 894919 | 2020-11-05 | US | South Carolina | Chesterfield | 45025 | 1540 | 48 | 0 | 1492 | 34.64137396 | -80.15640140000002 | 2020-11-06 05:24:55 | Chesterfield, South Carolina, US |
213201 | 213201 | 2020-10-29 | US | Tennessee | Monroe | 47123 | 1508 | 29 | 0 | 1492 | 35.44550387 | -84.24902965 | 2020-10-30 04:24:49 | Monroe, Tennessee, US |
757503 | 757503 | 2020-10-28 | US | Texas | San Patricio | 48409 | 1796 | 80 | 0 | 1492 | 28.00880118 | -97.51763891 | 2020-10-29 04:24:49 | San Patricio, Texas, US |
1455787 | 1455787 | 2020-10-27 | US | Texas | San Patricio | 48409 | 1793 | 80 | 0 | 1492 | 28.00880118 | -97.51763891 | 2020-10-28 04:24:39 | San Patricio, Texas, US |
3483511 | 3483511 | 2020-10-26 | US | Texas | San Patricio | 48409 | 1792 | 80 | 0 | 1492 | 28.00880118 | -97.51763891 | 2020-10-27 04:24:45 | San Patricio, Texas, US |
11532 | 11532 | 2020-10-25 | US | Texas | San Patricio | 48409 | 1790 | 80 | 0 | 1492 | 28.00880118 | -97.51763891 | 2020-10-26 04:25:02 | San Patricio, Texas, US |
11101 | 11101 | 2020-10-25 | US | Puerto Rico | Trujillo Alto | 72139 | 1492 | 0 | 0 | 1492 | 18.336159 | -65.99888399999999 | 2020-10-26 04:25:02 | Trujillo Alto, Puerto Rico, US |
3654769 | 3654769 | 2020-10-24 | US | Texas | San Patricio | 48409 | 1790 | 80 | 0 | 1492 | 28.00880118 | -97.51763891 | 2020-10-25 04:24:36 | San Patricio, Texas, 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]);