johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
137 rows where active = 1567 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 16
- US 110
- Russia 5
- Colombia 4
- Germany 3
- Italy 3
- Chile 2
- Burkina Faso 1
- France 1
- India 1
- Japan 1
- Kyrgyzstan 1
- Mauritania 1
- Mexico 1
- Pakistan 1
- Seychelles 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3331603 | 3331603 | 2021-07-21 | Mauritania | 23093 | 516 | 21010 | 1567 | 21.0079 | -10.9408 | 2021-07-22 04:21:19 | Mauritania | |||
2371348 | 2371348 | 2021-07-20 | Colombia | Boyaca | 99015 | 2360 | 95088 | 1567 | 5.4545 | -73.362 | 2021-07-21 04:21:40 | Boyaca, Colombia | ||
296007 | 296007 | 2021-07-15 | Italy | Toscana | 245342 | 6897 | 236878 | 1567 | 43.76923077 | 11.25588885 | 2021-07-16 04:21:22 | Toscana, Italy | ||
1165163 | 1165163 | 2021-07-04 | Italy | Toscana | 244484 | 6875 | 236042 | 1567 | 43.76923077 | 11.25588885 | 2021-07-05 04:21:28 | Toscana, Italy | ||
1125871 | 1125871 | 2021-06-18 | Seychelles | 14123 | 51 | 12505 | 1567 | -4.6796 | 55.492 | 2021-06-19 04:22:33 | Seychelles | |||
2315212 | 2315212 | 2021-06-04 | Germany | Brandenburg | 108462 | 3742 | 103200 | 1567 | 52.4125 | 12.5316 | 2021-06-05 04:23:03 | Brandenburg, Germany | ||
2104083 | 2104083 | 2021-06-01 | India | Lakshadweep | 8166 | 33 | 6566 | 1567 | 13.6999972 | 72.18333259999999 | 2021-06-02 04:24:34 | Lakshadweep, India | ||
3089273 | 3089273 | 2021-05-30 | Colombia | Magdalena | 69936 | 2656 | 65713 | 1567 | 10.4113 | -74.4057 | 2021-05-31 03:08:59 | Magdalena, Colombia | ||
36626 | 36626 | 2021-04-12 | Russia | Ingushetia Republic | 15235 | 182 | 13486 | 1567 | 43.11542075 | 45.01713552 | 2021-04-13 04:20:37 | Ingushetia Republic, Russia | ||
1619705 | 1619705 | 2021-03-05 | US | West Virginia | Boone | 54005 | 1599 | 32 | 0 | 1567 | 38.01974191 | -81.69888019 | 2021-03-06 04:23:41 | Boone, West Virginia, US |
1617956 | 1617956 | 2021-03-05 | US | Minnesota | Houston | 27055 | 1581 | 14 | 0 | 1567 | 43.67129565 | -91.49143057 | 2021-03-06 04:23:41 | Houston, Minnesota, US |
2210146 | 2210146 | 2021-03-04 | US | Ohio | Paulding | 39125 | 1605 | 38 | 0 | 1567 | 41.11676341 | -84.5801017 | 2021-03-05 05:26:29 | Paulding, Ohio, US |
1092567 | 1092567 | 2021-03-03 | US | Ohio | Paulding | 39125 | 1605 | 38 | 0 | 1567 | 41.11676341 | -84.5801017 | 2021-03-04 05:24:24 | Paulding, Ohio, US |
1091789 | 1091789 | 2021-03-03 | US | Minnesota | Hubbard | 27057 | 1607 | 40 | 0 | 1567 | 47.10778564 | -94.91693868 | 2021-03-04 05:24:24 | Hubbard, Minnesota, US |
1090130 | 1090130 | 2021-03-03 | Kyrgyzstan | 86410 | 1468 | 83375 | 1567 | 41.20438 | 74.766098 | 2021-03-04 05:24:24 | Kyrgyzstan | |||
1000698 | 1000698 | 2021-03-01 | US | New York | Seneca | 36099 | 1620 | 53 | 0 | 1567 | 42.78081007 | -76.82497064 | 2021-03-02 05:23:30 | Seneca, New York, US |
998922 | 998922 | 2021-03-01 | US | Arkansas | Howard | 5061 | 1590 | 23 | 0 | 1567 | 34.09007427 | -93.9934871 | 2021-03-02 05:23:30 | Howard, Arkansas, US |
2184258 | 2184258 | 2021-02-26 | US | Florida | Calhoun | 12013 | 1607 | 40 | 0 | 1567 | 30.40666734 | -85.19394153 | 2021-02-27 05:22:28 | Calhoun, Florida, US |
1858680 | 1858680 | 2021-02-25 | US | Florida | Calhoun | 12013 | 1607 | 40 | 0 | 1567 | 30.40666734 | -85.19394153 | 2021-02-26 05:22:40 | Calhoun, Florida, US |
1857787 | 1857787 | 2021-02-25 | Chile | Araucania | 39015 | 509 | 36939 | 1567 | -38.9489 | -72.3311 | 2021-02-26 05:22:40 | Araucania, Chile | ||
3602398 | 3602398 | 2021-02-17 | US | Kentucky | Anderson | 21005 | 1582 | 15 | 0 | 1567 | 38.00671029 | -84.99171713 | 2021-02-18 05:22:58 | Anderson, Kentucky, US |
3602034 | 3602034 | 2021-02-17 | US | Illinois | Jo Daviess | 17085 | 1589 | 22 | 0 | 1567 | 42.36542373 | -90.21094405 | 2021-02-18 05:22:58 | Jo Daviess, Illinois, US |
2286240 | 2286240 | 2021-02-14 | US | South Carolina | Hampton | 45049 | 1608 | 41 | 0 | 1567 | 32.77419582 | -81.13845571 | 2021-02-15 05:24:49 | Hampton, South Carolina, US |
2283209 | 2283209 | 2021-02-14 | Chile | Araucania | 35837 | 460 | 33810 | 1567 | -38.9489 | -72.3311 | 2021-02-15 05:24:49 | Araucania, Chile | ||
1590104 | 1590104 | 2021-02-05 | US | Missouri | Morgan | 29141 | 1603 | 36 | 0 | 1567 | 38.4181765 | -92.88791859 | 2021-02-06 05:23:55 | Morgan, Missouri, US |
792722 | 792722 | 2021-02-04 | US | North Carolina | Northampton | 37131 | 1594 | 27 | 0 | 1567 | 36.41736238 | -77.39769443 | 2021-02-05 05:22:38 | Northampton, North Carolina, US |
1685625 | 1685625 | 2021-02-02 | US | Indiana | Rush | 18139 | 1587 | 20 | 0 | 1567 | 39.62002287 | -85.4655599 | 2021-02-03 05:22:52 | Rush, Indiana, US |
1684992 | 1684992 | 2021-02-02 | US | Arkansas | Lee | 5077 | 1600 | 33 | 0 | 1567 | 34.78498904 | -90.78383866 | 2021-02-03 05:22:52 | Lee, Arkansas, US |
1676655 | 1676655 | 2021-02-01 | Russia | Amur Oblast | 19564 | 140 | 17857 | 1567 | 52.8032368 | 128.437295 | 2021-02-02 05:22:49 | Amur Oblast, Russia | ||
1460575 | 1460575 | 2021-01-31 | US | Georgia | Jeff Davis | 13161 | 1605 | 38 | 0 | 1567 | 31.80405727 | -82.63724870000001 | 2021-02-01 05:22:53 | Jeff Davis, Georgia, US |
2483238 | 2483238 | 2021-01-28 | US | Kansas | Dickinson | 20041 | 1591 | 24 | 0 | 1567 | 38.86600962 | -97.15532383 | 2021-01-29 05:22:23 | Dickinson, Kansas, US |
2483159 | 2483159 | 2021-01-28 | US | Iowa | Hardin | 19083 | 1598 | 31 | 0 | 1567 | 42.38353877 | -93.23654611 | 2021-01-29 05:22:23 | Hardin, Iowa, US |
3156556 | 3156556 | 2021-01-27 | US | Tennessee | Lake | 47095 | 1595 | 22 | 0 | 1567 | 36.34180170000001 | -89.48921915 | 2021-01-28 05:22:24 | Lake, Tennessee, US |
3154873 | 3154873 | 2021-01-27 | US | Kansas | Dickinson | 20041 | 1591 | 24 | 0 | 1567 | 38.86600962 | -97.15532383 | 2021-01-28 05:22:24 | Dickinson, Kansas, US |
3154651 | 3154651 | 2021-01-27 | US | Illinois | Warren | 17187 | 1609 | 42 | 0 | 1567 | 40.84925021 | -90.6147432 | 2021-01-28 05:22:24 | Warren, Illinois, US |
12794 | 12794 | 2021-01-26 | US | Arkansas | Ashley | 5003 | 1594 | 27 | 0 | 1567 | 33.19153461 | -91.7698471 | 2021-01-27 05:23:41 | Ashley, Arkansas, US |
12098 | 12098 | 2021-01-26 | Burkina Faso | 10157 | 118 | 8472 | 1567 | 12.2383 | -1.5616 | 2021-01-27 05:23:41 | Burkina Faso | |||
2568396 | 2568396 | 2021-01-25 | US | Florida | Union | 12125 | 1637 | 70 | 0 | 1567 | 30.04412971 | -82.37497443 | 2021-01-26 05:22:02 | Union, Florida, US |
2469863 | 2469863 | 2021-01-22 | US | Texas | Dawson | 48115 | 1275 | 63 | 0 | 1567 | 32.74255572 | -101.9477242 | 2021-01-23 05:22:03 | Dawson, Texas, US |
3880426 | 3880426 | 2021-01-14 | US | Georgia | Pike | 13231 | 1591 | 24 | 0 | 1567 | 33.09310242 | -84.38790389 | 2021-01-15 05:22:24 | Pike, Georgia, US |
3310696 | 3310696 | 2021-01-13 | US | Ohio | Pike | 39131 | 1588 | 21 | 0 | 1567 | 39.07634001 | -83.06769584 | 2021-01-14 05:22:32 | Pike, Ohio, US |
191160 | 191160 | 2021-01-11 | US | Indiana | Jay | 18075 | 1591 | 24 | 0 | 1567 | 40.43781032 | -85.00576229 | 2021-01-12 05:22:15 | Jay, Indiana, US |
2627485 | 2627485 | 2021-01-10 | US | Michigan | Chippewa | 26033 | 1582 | 15 | 0 | 1567 | 46.29552653 | -84.54353449 | 2021-01-11 05:21:50 | Chippewa, Michigan, US |
2626375 | 2626375 | 2021-01-10 | US | Arkansas | Ouachita | 5103 | 1602 | 35 | 0 | 1567 | 33.58839816 | -92.87795984 | 2021-01-11 05:21:50 | Ouachita, Arkansas, US |
3901573 | 3901573 | 2021-01-09 | US | Michigan | Chippewa | 26033 | 1582 | 15 | 0 | 1567 | 46.29552653 | -84.54353449 | 2021-01-10 05:22:12 | Chippewa, Michigan, US |
3899971 | 3899971 | 2021-01-09 | Japan | Hokkaido | 14525 | 500 | 12458 | 1567 | 43.385711 | 142.552318 | 2021-01-10 05:22:12 | Hokkaido, Japan | ||
2231097 | 2231097 | 2021-01-02 | US | Wisconsin | Vernon | 55123 | 1597 | 30 | 0 | 1567 | 43.59422667 | -90.8324691 | 2021-01-03 05:22:52 | Vernon, Wisconsin, US |
1137842 | 1137842 | 2021-01-01 | US | Illinois | Cass | 17017 | 1586 | 19 | 0 | 1567 | 39.96991073 | -90.24734436 | 2021-01-02 05:22:33 | Cass, Illinois, US |
3696448 | 3696448 | 2020-12-31 | US | Illinois | Cass | 17017 | 1586 | 19 | 0 | 1567 | 39.96991073 | -90.24734436 | 2021-01-01 05:23:07 | Cass, Illinois, US |
3781429 | 3781429 | 2020-12-27 | US | Wisconsin | Crawford | 55023 | 1579 | 12 | 0 | 1567 | 43.23870316 | -90.93073686 | 2020-12-28 05:22:06 | Crawford, Wisconsin, US |
3779753 | 3779753 | 2020-12-27 | US | Mississippi | Wayne | 28153 | 1594 | 27 | 0 | 1567 | 31.64135687 | -88.69573913 | 2020-12-28 05:22:06 | Wayne, Mississippi, US |
3778600 | 3778600 | 2020-12-27 | US | Florida | Holmes | 12059 | 1590 | 23 | 0 | 1567 | 30.86747479 | -85.81319222 | 2020-12-28 05:22:06 | Holmes, Florida, US |
2223876 | 2223876 | 2020-12-26 | US | Alabama | Geneva | 1061 | 1585 | 18 | 0 | 1567 | 31.09389027 | -85.83572839 | 2020-12-27 05:22:55 | Geneva, Alabama, US |
2408872 | 2408872 | 2020-12-23 | US | Nebraska | Cass | 31025 | 1578 | 11 | 0 | 1567 | 40.90899107 | -96.13971217 | 2020-12-24 05:23:04 | Cass, Nebraska, US |
2408088 | 2408088 | 2020-12-23 | US | Kansas | Cherokee | 20021 | 1579 | 12 | 0 | 1567 | 37.16928494 | -94.8462897 | 2020-12-24 05:23:04 | Cherokee, Kansas, US |
3773455 | 3773455 | 2020-12-22 | US | Wisconsin | Vilas | 55125 | 1590 | 23 | 0 | 1567 | 46.05467334 | -89.51719204 | 2020-12-23 05:22:03 | Vilas, Wisconsin, US |
3772724 | 3772724 | 2020-12-22 | US | South Dakota | Clay | 46027 | 1578 | 11 | 0 | 1567 | 42.91296147 | -96.97656917 | 2020-12-23 05:22:03 | Clay, South Dakota, US |
3771694 | 3771694 | 2020-12-22 | US | Mississippi | Marion | 28091 | 1626 | 59 | 0 | 1567 | 31.23132643 | -89.8209217 | 2020-12-23 05:22:03 | Marion, Mississippi, US |
2121175 | 2121175 | 2020-12-20 | US | Kentucky | Taylor | 21217 | 1578 | 11 | 0 | 1567 | 37.3677562 | -85.3329931 | 2020-12-21 05:27:58 | Taylor, Kentucky, US |
2932752 | 2932752 | 2020-12-19 | US | Louisiana | Union | 22111 | 1629 | 62 | 0 | 1567 | 32.83121059 | -92.3749373 | 2020-12-20 05:27:32 | Union, Louisiana, US |
1903987 | 1903987 | 2020-12-18 | US | South Carolina | Marion | 45067 | 1619 | 52 | 0 | 1567 | 34.07859748 | -79.36400756 | 2020-12-19 05:27:52 | Marion, South Carolina, US |
1902698 | 1902698 | 2020-12-18 | US | Louisiana | Union | 22111 | 1629 | 62 | 0 | 1567 | 32.83121059 | -92.3749373 | 2020-12-19 05:27:52 | Union, Louisiana, US |
1902184 | 1902184 | 2020-12-18 | US | Illinois | Montgomery | 17135 | 1587 | 20 | 0 | 1567 | 39.23198845 | -89.47809254 | 2020-12-19 05:27:52 | Montgomery, Illinois, US |
1901654 | 1901654 | 2020-12-18 | US | Arkansas | Johnson | 5071 | 1584 | 17 | 0 | 1567 | 35.56759135 | -93.46036368 | 2020-12-19 05:27:52 | Johnson, Arkansas, US |
2131134 | 2131134 | 2020-12-17 | US | Texas | Lavaca | 48285 | 1528 | 47 | 0 | 1567 | 29.38508402 | -96.93186692 | 2020-12-18 05:28:18 | Lavaca, Texas, US |
1753502 | 1753502 | 2020-12-14 | US | New York | Madison | 36053 | 1592 | 25 | 0 | 1567 | 42.91653905 | -75.67266639 | 2020-12-15 05:26:38 | Madison, New York, US |
849107 | 849107 | 2020-12-12 | US | Wisconsin | Green Lake | 55047 | 1578 | 11 | 0 | 1567 | 43.80025981 | -89.04679553 | 2020-12-13 05:27:20 | Green Lake, Wisconsin, US |
1603820 | 1603820 | 2020-12-10 | US | Wyoming | Park | 56029 | 1574 | 7 | 0 | 1567 | 44.52157546 | -109.5852825 | 2020-12-11 05:26:59 | Park, Wyoming, US |
2978049 | 2978049 | 2020-12-09 | US | South Carolina | Marlboro | 45069 | 1587 | 20 | 0 | 1567 | 34.59905577 | -79.67561152 | 2020-12-10 05:26:19 | Marlboro, South Carolina, US |
1006510 | 1006510 | 2020-12-06 | Russia | Kursk Oblast | 16290 | 220 | 14503 | 1567 | 51.6568453 | 36.4852695 | 2020-12-07 05:26:14 | Kursk Oblast, Russia | ||
1633448 | 1633448 | 2020-12-05 | US | Indiana | White | 18181 | 1593 | 26 | 0 | 1567 | 40.74911165 | -86.86492015 | 2020-12-06 05:26:18 | White, Indiana, US |
3862275 | 3862275 | 2020-12-04 | US | Ohio | Crawford | 39033 | 1613 | 46 | 0 | 1567 | 40.85065156 | -82.91989099 | 2020-12-05 05:27:36 | Crawford, Ohio, US |
77542 | 77542 | 2020-12-03 | US | Ohio | Fulton | 39051 | 1597 | 30 | 0 | 1567 | 41.60213491 | -84.12571393 | 2020-12-04 05:27:27 | Fulton, Ohio, US |
75000 | 75000 | 2020-12-03 | Germany | Bremen | 10425 | 129 | 8805 | 1567 | 53.0793 | 8.8017 | 2020-12-04 05:27:27 | Bremen, Germany | ||
1584414 | 1584414 | 2020-11-30 | Russia | Tula Oblast | 16606 | 481 | 14558 | 1567 | 53.9570701 | 37.3690909 | 2020-12-01 05:26:18 | Tula Oblast, Russia | ||
3570065 | 3570065 | 2020-11-29 | US | West Virginia | Raleigh | 54081 | 1583 | 16 | 0 | 1567 | 37.76936795 | -81.2456041 | 2020-11-30 05:26:13 | Raleigh, West Virginia, US |
924074 | 924074 | 2020-11-26 | US | Alabama | Pike | 1109 | 1581 | 14 | 0 | 1567 | 31.80396383 | -85.9408295 | 2020-11-27 05:26:53 | Pike, Alabama, US |
1351371 | 1351371 | 2020-11-24 | US | Illinois | Woodford | 17203 | 1589 | 22 | 0 | 1567 | 40.78579374 | -89.20973757 | 2020-11-25 05:27:20 | Woodford, Illinois, US |
1350845 | 1350845 | 2020-11-24 | US | Arkansas | Yell | 5149 | 1600 | 33 | 0 | 1567 | 35.00292371 | -93.41171338 | 2020-11-25 05:27:20 | Yell, Arkansas, US |
681251 | 681251 | 2020-11-23 | US | Tennessee | Haywood | 47075 | 1586 | 29 | 0 | 1567 | 35.58332824 | -89.28536625 | 2020-11-24 05:27:31 | Haywood, Tennessee, US |
3193366 | 3193366 | 2020-11-22 | US | Virginia | Pittsylvania | 51143 | 1589 | 22 | 0 | 1567 | 36.81980341 | -79.39731264 | 2020-11-23 05:25:26 | Pittsylvania, Virginia, US |
3172222 | 3172222 | 2020-11-16 | US | Oklahoma | Sequoyah | 40135 | 1581 | 14 | 0 | 1567 | 35.49447108 | -94.75463785 | 2020-11-17 05:25:54 | Sequoyah, Oklahoma, US |
2916718 | 2916718 | 2020-11-14 | US | Louisiana | Webster | 22119 | 1612 | 45 | 0 | 1567 | 32.70847669 | -93.33121835 | 2020-11-15 05:26:53 | Webster, Louisiana, US |
2916138 | 2916138 | 2020-11-14 | US | Illinois | Bureau | 17011 | 1589 | 22 | 0 | 1567 | 41.40385234 | -89.5283051 | 2020-11-15 05:26:53 | Bureau, Illinois, US |
2787347 | 2787347 | 2020-11-13 | US | North Carolina | Pender | 37141 | 1584 | 17 | 0 | 1567 | 34.52265624 | -77.90352133 | 2020-11-14 05:25:37 | Pender, North Carolina, US |
2786540 | 2786540 | 2020-11-13 | US | Louisiana | Webster | 22119 | 1612 | 45 | 0 | 1567 | 32.70847669 | -93.33121835 | 2020-11-14 05:25:37 | Webster, Louisiana, US |
1546586 | 1546586 | 2020-11-07 | US | Pennsylvania | Cambria | 42021 | 1580 | 13 | 0 | 1567 | 40.49527404 | -78.71377428 | 2020-11-08 05:24:56 | Cambria, Pennsylvania, US |
1544049 | 1544049 | 2020-11-07 | Mexico | Zacatecas | 12268 | 1025 | 9676 | 1567 | 22.7709 | -102.5832 | 2020-11-08 05:24:56 | Zacatecas, Mexico | ||
3306374 | 3306374 | 2020-11-02 | US | New Mexico | Eddy | 35015 | 1591 | 24 | 0 | 1567 | 32.47167456 | -104.3053527 | 2020-11-03 06:00:16 | Eddy, New Mexico, US |
3306365 | 3306365 | 2020-11-02 | US | New Jersey | Warren | 34041 | 1738 | 171 | 0 | 1567 | 40.85951833 | -74.99556527 | 2020-11-03 06:00:16 | Warren, New Jersey, US |
1180422 | 1180422 | 2020-10-22 | US | Tennessee | Greene | 47059 | 1627 | 51 | 0 | 1567 | 36.17470125 | -82.84691273 | 2020-10-23 04:24:46 | Greene, Tennessee, US |
1179786 | 1179786 | 2020-10-22 | US | North Carolina | Columbus | 37047 | 1626 | 59 | 0 | 1567 | 34.26744084 | -78.65801424 | 2020-10-23 04:24:46 | Columbus, North Carolina, US |
3990472 | 3990472 | 2020-10-20 | Colombia | Tolima | 16230 | 492 | 14171 | 1567 | 4.0925 | -75.1545 | 2020-10-21 04:24:14 | Tolima, Colombia | ||
1797397 | 1797397 | 2020-10-19 | US | Puerto Rico | Toa Alta | 72135 | 1567 | 0 | 0 | 1567 | 18.362406 | -66.246616 | 2020-10-20 04:24:22 | Toa Alta, Puerto Rico, US |
789068 | 789068 | 2020-10-15 | US | Pennsylvania | Washington | 42125 | 1598 | 31 | 0 | 1567 | 40.19208869 | -80.24582867 | 2020-10-16 04:24:01 | Washington, Pennsylvania, US |
3787368 | 3787368 | 2020-10-11 | US | Louisiana | Avoyelles | 22009 | 1628 | 61 | 0 | 1567 | 31.07796211 | -92.00079449 | 2020-10-12 04:23:45 | Avoyelles, Louisiana, US |
3786676 | 3786676 | 2020-10-11 | US | Georgia | Effingham | 13103 | 1595 | 28 | 0 | 1567 | 32.36616021 | -81.34280942 | 2020-10-12 04:23:45 | Effingham, Georgia, US |
2604507 | 2604507 | 2020-10-10 | US | Ohio | Medina | 39103 | 1616 | 49 | 0 | 1567 | 41.11770589 | -81.89986209999998 | 2020-10-11 04:23:46 | Medina, Ohio, US |
819382 | 819382 | 2020-10-09 | US | Mississippi | Neshoba | 28099 | 1676 | 109 | 0 | 1567 | 32.75339664 | -89.11726492 | 2020-10-10 04:23:57 | Neshoba, Mississippi, US |
1825042 | 1825042 | 2020-10-04 | US | New York | Sullivan | 36105 | 1615 | 48 | 0 | 1567 | 41.71579493 | -74.76394559 | 2020-10-05 04:23:33 | Sullivan, New York, 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]);