johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
111 rows where active = 1618 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 83
- Russia 11
- Colombia 4
- Germany 2
- Togo 2
- Azerbaijan 1
- Bahrain 1
- India 1
- Italy 1
- Kyrgyzstan 1
- Mozambique 1
- Pakistan 1
- Rwanda 1
- Senegal 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683289 | 3683289 | 2021-08-02 | Colombia | Caldas | 98409 | 2168 | 94623 | 1618 | 5.2983 | -75.2479 | 2021-08-03 04:21:39 | Caldas, Colombia | ||
778636 | 778636 | 2021-07-08 | Senegal | 44790 | 1184 | 41988 | 1618 | 14.4974 | -14.4524 | 2021-07-09 04:21:21 | Senegal | |||
3358660 | 3358660 | 2021-06-21 | Italy | Piemonte | 362614 | 11691 | 349305 | 1618 | 45.0732745 | 7.680687483 | 2021-06-22 04:21:34 | Piemonte, Italy | ||
3970736 | 3970736 | 2021-06-11 | Russia | Arkhangelsk Oblast | 64555 | 1004 | 61933 | 1618 | 63.5589686 | 43.1221646 | 2021-06-12 04:22:22 | Arkhangelsk Oblast, Russia | ||
3970401 | 3970401 | 2021-06-11 | Colombia | Magdalena | 74117 | 2793 | 69706 | 1618 | 10.4113 | -74.4057 | 2021-06-12 04:22:22 | Magdalena, Colombia | ||
2717158 | 2717158 | 2021-06-10 | Russia | Arkhangelsk Oblast | 64477 | 1001 | 61858 | 1618 | 63.5589686 | 43.1221646 | 2021-06-11 04:23:20 | Arkhangelsk Oblast, Russia | ||
2586174 | 2586174 | 2021-06-05 | Russia | Arkhangelsk Oblast | 64125 | 997 | 61510 | 1618 | 63.5589686 | 43.1221646 | 2021-06-06 04:24:03 | Arkhangelsk Oblast, Russia | ||
1413309 | 1413309 | 2021-05-24 | Russia | Tver Oblast | 41636 | 989 | 39029 | 1618 | 57.1134475 | 35.174442799999994 | 2021-05-25 04:21:08 | Tver Oblast, Russia | ||
1771483 | 1771483 | 2021-05-23 | Pakistan | Azad Jammu and Kashmir | 18808 | 532 | 16658 | 1618 | 34.027401 | 73.947253 | 2021-05-24 04:20:53 | Azad Jammu and Kashmir, Pakistan | ||
2761253 | 2761253 | 2021-05-03 | Togo | 13010 | 123 | 11269 | 1618 | 8.6195 | 0.8248 | 2021-05-04 04:20:34 | Togo | |||
2451106 | 2451106 | 2021-05-02 | Togo | 13010 | 123 | 11269 | 1618 | 8.6195 | 0.8248 | 2021-05-03 04:20:39 | Togo | |||
2411045 | 2411045 | 2021-04-19 | Russia | Kaliningrad Oblast | 31156 | 375 | 29163 | 1618 | 54.7293041 | 21.1489473 | 2021-04-20 04:20:41 | Kaliningrad Oblast, Russia | ||
2549139 | 2549139 | 2021-04-15 | Rwanda | 23744 | 321 | 21805 | 1618 | -1.9403 | 29.8739 | 2021-04-16 04:20:46 | Rwanda | |||
638142 | 638142 | 2021-03-31 | Russia | Leningrad Oblast | 39866 | 932 | 37316 | 1618 | 60.1853296 | 32.3925325 | 2021-04-01 04:27:05 | Leningrad Oblast, Russia | ||
3643771 | 3643771 | 2021-03-30 | Russia | Leningrad Oblast | 39772 | 927 | 37227 | 1618 | 60.1853296 | 32.3925325 | 2021-03-31 04:26:25 | Leningrad Oblast, Russia | ||
2370974 | 2370974 | 2021-02-28 | US | West Virginia | Jackson | 54035 | 1668 | 50 | 0 | 1618 | 38.84263974 | -81.68148753 | 2021-03-01 05:23:01 | Jackson, West Virginia, US |
2185368 | 2185368 | 2021-02-26 | US | Mississippi | Clarke | 28023 | 1689 | 71 | 0 | 1618 | 32.04158545 | -88.68896219999998 | 2021-02-27 05:22:28 | Clarke, Mississippi, US |
2183638 | 2183638 | 2021-02-26 | Kyrgyzstan | 86142 | 1463 | 83061 | 1618 | 41.20438 | 74.766098 | 2021-02-27 05:22:28 | Kyrgyzstan | |||
1859466 | 1859466 | 2021-02-25 | US | Kentucky | Simpson | 21213 | 1646 | 28 | 0 | 1618 | 36.74058474 | -86.58047435 | 2021-02-26 05:22:40 | Simpson, Kentucky, US |
280570 | 280570 | 2021-02-24 | US | Alabama | Monroe | 1099 | 1656 | 38 | 0 | 1618 | 31.56729412 | -87.36995001 | 2021-02-25 05:24:57 | Monroe, Alabama, US |
1937026 | 1937026 | 2021-02-23 | US | California | Siskiyou | 6093 | 1600 | 4 | 0 | 1618 | 41.59198861 | -122.5407434 | 2021-02-24 05:29:16 | Siskiyou, California, US |
534089 | 534089 | 2021-02-22 | US | Virginia | Powhatan | 51145 | 1625 | 7 | 0 | 1618 | 37.55016038 | -77.91267882 | 2021-02-23 05:23:41 | Powhatan, Virginia, US |
183086 | 183086 | 2021-02-21 | US | Illinois | Warren | 17187 | 1661 | 43 | 0 | 1618 | 40.84925021 | -90.6147432 | 2021-02-22 05:24:21 | Warren, Illinois, US |
743056 | 743056 | 2021-02-20 | US | Georgia | Banks | 13011 | 1649 | 31 | 0 | 1618 | 34.35607081 | -83.49644388 | 2021-02-21 05:24:33 | Banks, Georgia, US |
471622 | 471622 | 2021-02-19 | Russia | Khanty-Mansi Autonomous Okrug | 50355 | 722 | 48015 | 1618 | 61.0259025 | 69.0982628 | 2021-02-20 05:22:51 | Khanty-Mansi Autonomous Okrug, Russia | ||
471351 | 471351 | 2021-02-19 | India | Assam | 217367 | 1091 | 214658 | 1618 | 26.357149 | 92.830441 | 2021-02-20 05:22:51 | Assam, India | ||
3602067 | 3602067 | 2021-02-17 | US | Illinois | Pike | 17149 | 1666 | 48 | 0 | 1618 | 39.62265059 | -90.8877017 | 2021-02-18 05:22:58 | Pike, Illinois, US |
3053533 | 3053533 | 2021-02-16 | US | Virginia | Louisa | 51109 | 1631 | 13 | 0 | 1618 | 37.97850256 | -77.96274807 | 2021-02-17 05:23:10 | Louisa, Virginia, US |
3053168 | 3053168 | 2021-02-16 | US | Tennessee | Union | 47173 | 1649 | 29 | 0 | 1618 | 36.28590426 | -83.83651902 | 2021-02-17 05:23:10 | Union, Tennessee, US |
1341632 | 1341632 | 2021-02-15 | US | Virginia | Louisa | 51109 | 1631 | 13 | 0 | 1618 | 37.97850256 | -77.96274807 | 2021-02-16 05:24:38 | Louisa, Virginia, US |
1339464 | 1339464 | 2021-02-15 | US | Iowa | Hardin | 19083 | 1652 | 34 | 0 | 1618 | 42.38353877 | -93.23654611 | 2021-02-16 05:24:38 | Hardin, Iowa, US |
617020 | 617020 | 2021-02-08 | US | Virginia | Fredericksburg | 51630 | 1632 | 14 | 0 | 1618 | 38.2977863 | -77.4922454 | 2021-02-09 05:23:30 | Fredericksburg, Virginia, US |
975114 | 975114 | 2021-02-06 | Russia | Ingushetia Republic | 14169 | 162 | 12389 | 1618 | 43.11542075 | 45.01713552 | 2021-02-07 05:23:00 | Ingushetia Republic, Russia | ||
1591691 | 1591691 | 2021-02-05 | US | West Virginia | Wyoming | 54109 | 1649 | 31 | 0 | 1618 | 37.612327 | -81.54511071 | 2021-02-06 05:23:55 | Wyoming, West Virginia, US |
1588992 | 1588992 | 2021-02-05 | US | Georgia | Jeff Davis | 13161 | 1657 | 39 | 0 | 1618 | 31.80405727 | -82.63724870000001 | 2021-02-06 05:23:55 | Jeff Davis, Georgia, US |
343333 | 343333 | 2021-02-03 | US | Texas | Dawson | 48115 | 1329 | 66 | 0 | 1618 | 32.74255572 | -101.9477242 | 2021-02-04 05:22:26 | Dawson, Texas, US |
1460240 | 1460240 | 2021-01-31 | US | Arkansas | Hempstead | 5057 | 1632 | 14 | 0 | 1618 | 33.73325583 | -93.66935133 | 2021-02-01 05:22:53 | Hempstead, Arkansas, US |
2483127 | 2483127 | 2021-01-28 | US | Iowa | Buchanan | 19019 | 1642 | 24 | 0 | 1618 | 42.4709188 | -91.83510825 | 2021-01-29 05:22:23 | Buchanan, Iowa, US |
3156126 | 3156126 | 2021-01-27 | US | Oklahoma | Atoka | 40005 | 1626 | 8 | 0 | 1618 | 34.37366573 | -96.03802487 | 2021-01-28 05:22:24 | Atoka, Oklahoma, US |
3154684 | 3154684 | 2021-01-27 | US | Indiana | Fulton | 18049 | 1656 | 38 | 0 | 1618 | 41.0469907 | -86.26252745 | 2021-01-28 05:22:24 | Fulton, Indiana, US |
436536 | 436536 | 2021-01-21 | US | Iowa | Fayette | 19065 | 1641 | 23 | 0 | 1618 | 42.86271799 | -91.8441231 | 2021-01-22 05:22:10 | Fayette, Iowa, US |
240049 | 240049 | 2021-01-18 | US | South Carolina | Fairfield | 45039 | 1676 | 58 | 0 | 1618 | 34.39287073 | -81.1195624 | 2021-01-19 05:22:15 | Fairfield, South Carolina, US |
237097 | 237097 | 2021-01-18 | Colombia | Quindio | 27840 | 775 | 25447 | 1618 | 4.461 | -75.6674 | 2021-01-19 05:22:15 | Quindio, Colombia | ||
3505156 | 3505156 | 2021-01-17 | US | Mississippi | Holmes | 28051 | 1685 | 67 | 0 | 1618 | 33.12345854 | -90.08923538 | 2021-01-18 05:22:34 | Holmes, Mississippi, US |
2627000 | 2627000 | 2021-01-10 | US | Indiana | Starke | 18149 | 1665 | 47 | 0 | 1618 | 41.27890281 | -86.64686895 | 2021-01-11 05:21:50 | Starke, Indiana, US |
2626405 | 2626405 | 2021-01-10 | US | California | Colusa | 6011 | 1620 | 7 | 0 | 1618 | 39.17881957 | -122.2331726 | 2021-01-11 05:21:50 | Colusa, California, US |
155410 | 155410 | 2021-01-08 | US | Kentucky | Marion | 21155 | 1638 | 20 | 0 | 1618 | 37.55218078 | -85.26898542 | 2021-01-09 05:22:18 | Marion, Kentucky, US |
2544239 | 2544239 | 2021-01-07 | US | South Carolina | Union | 45087 | 1663 | 45 | 0 | 1618 | 34.68835752 | -81.61730349 | 2021-01-08 05:22:42 | Union, South Carolina, US |
3232273 | 3232273 | 2021-01-03 | US | Mississippi | Newton | 28101 | 1655 | 37 | 0 | 1618 | 32.40021118 | -89.11843336 | 2021-01-04 05:22:02 | Newton, Mississippi, US |
2229943 | 2229943 | 2021-01-02 | US | North Dakota | Walsh | 38099 | 1617 | 21 | 0 | 1618 | 48.36876964 | -97.72574783 | 2021-01-03 05:22:52 | Walsh, North Dakota, US |
1139102 | 1139102 | 2021-01-01 | US | New York | Columbia | 36021 | 1678 | 60 | 0 | 1618 | 42.24819348 | -73.63089095 | 2021-01-02 05:22:33 | Columbia, New York, US |
1137671 | 1137671 | 2021-01-01 | US | Georgia | Elbert | 13105 | 1651 | 33 | 0 | 1618 | 34.11302332 | -82.83936148 | 2021-01-02 05:22:33 | Elbert, Georgia, US |
3779786 | 3779786 | 2020-12-27 | US | Missouri | Crawford | 29055 | 1637 | 19 | 0 | 1618 | 37.97663738 | -91.30528104 | 2020-12-28 05:22:06 | Crawford, Missouri, US |
3779556 | 3779556 | 2020-12-27 | US | Michigan | Menominee | 26109 | 1643 | 25 | 0 | 1618 | 45.58038692 | -87.55370409 | 2020-12-28 05:22:06 | Menominee, Michigan, US |
2225161 | 2225161 | 2020-12-26 | US | Michigan | Menominee | 26109 | 1643 | 25 | 0 | 1618 | 45.58038692 | -87.55370409 | 2020-12-27 05:22:55 | Menominee, Michigan, US |
2224109 | 2224109 | 2020-12-26 | US | Colorado | Crowley | 8025 | 1653 | 14 | 0 | 1618 | 38.32608609 | -103.7844965 | 2020-12-27 05:22:55 | Crowley, Colorado, US |
3770217 | 3770217 | 2020-12-22 | US | Alabama | Bibb | 1007 | 1660 | 42 | 0 | 1618 | 32.99642064 | -87.12511459999997 | 2020-12-23 05:22:03 | Bibb, Alabama, US |
3769585 | 3769585 | 2020-12-22 | Bahrain | 90634 | 350 | 88666 | 1618 | 26.0275 | 50.55 | 2020-12-23 05:22:03 | Bahrain | |||
1903134 | 1903134 | 2020-12-18 | US | Missouri | Washington | 29221 | 1652 | 34 | 0 | 1618 | 37.96130078 | -90.87948158 | 2020-12-19 05:27:52 | Washington, Missouri, US |
3150717 | 3150717 | 2020-12-16 | US | Indiana | Scott | 18143 | 1653 | 35 | 0 | 1618 | 38.68672078 | -85.74627859 | 2020-12-17 05:28:12 | Scott, Indiana, US |
2975340 | 2975340 | 2020-12-09 | Mozambique | 16440 | 138 | 14684 | 1618 | -18.665695 | 35.529562 | 2020-12-10 05:26:19 | Mozambique | |||
3860842 | 3860842 | 2020-12-04 | US | Illinois | McDonough | 17109 | 1651 | 33 | 0 | 1618 | 40.45674722 | -90.67775541 | 2020-12-05 05:27:36 | McDonough, Illinois, US |
74927 | 74927 | 2020-12-03 | Colombia | Boyaca | 22411 | 487 | 20306 | 1618 | 5.4545 | -73.362 | 2020-12-04 05:27:27 | Boyaca, Colombia | ||
2537306 | 2537306 | 2020-12-01 | Germany | Bremen | 10094 | 123 | 8514 | 1618 | 53.0793 | 8.8017 | 2020-12-02 05:27:41 | Bremen, Germany | ||
925522 | 925522 | 2020-11-26 | US | Mississippi | Tate | 28137 | 1669 | 51 | 0 | 1618 | 34.65133709 | -89.94485778 | 2020-11-27 05:26:53 | Tate, Mississippi, US |
679186 | 679186 | 2020-11-23 | US | Georgia | Toombs | 13279 | 1681 | 63 | 0 | 1618 | 32.12059861 | -82.32957247 | 2020-11-24 05:27:31 | Toombs, Georgia, US |
3172592 | 3172592 | 2020-11-16 | US | Tennessee | Macon | 47111 | 1650 | 26 | 0 | 1618 | 36.53157855 | -86.00778595 | 2020-11-17 05:25:54 | Macon, Tennessee, US |
3171844 | 3171844 | 2020-11-16 | US | New Mexico | Valencia | 35061 | 1631 | 13 | 0 | 1618 | 34.71669834 | -106.8103733 | 2020-11-17 05:25:54 | Valencia, New Mexico, US |
2918110 | 2918110 | 2020-11-14 | US | Tennessee | Franklin | 47051 | 1653 | 29 | 0 | 1618 | 35.15634626 | -86.09201039 | 2020-11-15 05:26:53 | Franklin, Tennessee, US |
865930 | 865930 | 2020-11-12 | US | Iowa | Carroll | 19027 | 1632 | 14 | 0 | 1618 | 42.03617207 | -94.86032705 | 2020-11-13 05:25:30 | Carroll, Iowa, US |
3443341 | 3443341 | 2020-11-11 | US | Oklahoma | Cherokee | 40021 | 1627 | 9 | 0 | 1618 | 35.90692775 | -94.99980896 | 2020-11-12 05:25:55 | Cherokee, Oklahoma, US |
3442010 | 3442010 | 2020-11-11 | US | Iowa | Jasper | 19099 | 1652 | 34 | 0 | 1618 | 41.68576082 | -93.05567785 | 2020-11-12 05:25:55 | Jasper, Iowa, US |
2922774 | 2922774 | 2020-11-04 | US | Wyoming | Fremont | 56013 | 1636 | 18 | 0 | 1618 | 43.04183996 | -108.6296893 | 2020-11-05 06:05:03 | Fremont, Wyoming, US |
2245059 | 2245059 | 2020-10-30 | US | Michigan | St. Clair | 26147 | 1683 | 65 | 0 | 1618 | 42.92655373 | -82.67937954 | 2020-10-31 04:24:44 | St. Clair, Michigan, US |
756113 | 756113 | 2020-10-28 | US | Mississippi | Leflore | 28083 | 1706 | 88 | 0 | 1618 | 33.55545125 | -90.29900733 | 2020-10-29 04:24:49 | Leflore, Mississippi, US |
10529 | 10529 | 2020-10-25 | US | New Mexico | Santa Fe | 35049 | 1631 | 13 | 0 | 1618 | 35.50708973 | -105.9774716 | 2020-10-26 04:25:02 | Santa Fe, New Mexico, US |
1795577 | 1795577 | 2020-10-19 | US | Illinois | Adams | 17001 | 1633 | 15 | 0 | 1618 | 39.98815591 | -91.18786813 | 2020-10-20 04:24:22 | Adams, Illinois, US |
3785291 | 3785291 | 2020-10-13 | US | Virginia | Rockingham | 51165 | 1640 | 22 | 0 | 1618 | 38.51006137 | -78.87260325 | 2020-10-14 04:24:05 | Rockingham, Virginia, US |
3782417 | 3782417 | 2020-10-13 | US | Arkansas | St. Francis | 5123 | 1626 | 8 | 0 | 1618 | 35.02201976 | -90.74828138 | 2020-10-14 04:24:05 | St. Francis, Arkansas, US |
3789062 | 3789062 | 2020-10-11 | US | Texas | Nacogdoches | 48347 | 2041 | 65 | 0 | 1618 | 31.62017125 | -94.61803994 | 2020-10-12 04:23:45 | Nacogdoches, Texas, US |
3787711 | 3787711 | 2020-10-11 | US | Mississippi | Neshoba | 28099 | 1727 | 109 | 0 | 1618 | 32.75339664 | -89.11726492 | 2020-10-12 04:23:45 | Neshoba, Mississippi, US |
2605200 | 2605200 | 2020-10-10 | US | Texas | Nacogdoches | 48347 | 2039 | 65 | 0 | 1618 | 31.62017125 | -94.61803994 | 2020-10-11 04:23:46 | Nacogdoches, Texas, US |
820733 | 820733 | 2020-10-09 | US | Texas | Nacogdoches | 48347 | 2035 | 65 | 0 | 1618 | 31.62017125 | -94.61803994 | 2020-10-10 04:23:57 | Nacogdoches, Texas, US |
1042033 | 1042033 | 2020-10-07 | Russia | Komi Republic | 9080 | 126 | 7336 | 1618 | 63.9881421 | 54.3326073 | 2020-10-08 04:23:56 | Komi Republic, Russia | ||
3117203 | 3117203 | 2020-10-06 | Azerbaijan | 40931 | 600 | 38713 | 1618 | 40.1431 | 47.5769 | 2020-10-07 04:23:40 | Azerbaijan | |||
3802257 | 3802257 | 2020-10-05 | US | Alabama | Escambia | 1053 | 1644 | 26 | 0 | 1618 | 31.1256789 | -87.15918694 | 2020-10-06 04:23:33 | Escambia, Alabama, US |
2514423 | 2514423 | 2020-10-03 | Russia | Udmurt Republic | 5594 | 73 | 3903 | 1618 | 57.1961165 | 52.69598320000001 | 2020-10-04 04:23:44 | Udmurt Republic, Russia | ||
2383174 | 2383174 | 2020-10-01 | US | Wisconsin | Marathon | 55073 | 1633 | 15 | 0 | 1618 | 44.89792533 | -89.75863384 | 2020-10-02 04:23:51 | Marathon, Wisconsin, US |
2382094 | 2382094 | 2020-10-01 | US | Ohio | Lake | 39085 | 1677 | 59 | 0 | 1618 | 41.69710807 | -81.23676539 | 2020-10-02 04:23:51 | Lake, Ohio, US |
967235 | 967235 | 2020-09-29 | US | Alabama | Blount | 1009 | 1633 | 15 | 0 | 1618 | 33.98210918 | -86.56790593 | 2020-09-30 04:23:33 | Blount, Alabama, US |
1517143 | 1517143 | 2020-09-28 | US | Minnesota | St. Louis | 27137 | 1659 | 41 | 0 | 1618 | 47.6048407 | -92.46879855 | 2020-09-29 04:23:42 | St. Louis, Minnesota, US |
2614526 | 2614526 | 2020-09-26 | US | Arkansas | Mississippi | 5093 | 1668 | 50 | 0 | 1618 | 35.76271485 | -90.0519437 | 2020-09-27 04:23:00 | Mississippi, Arkansas, US |
1123892 | 1123892 | 2020-09-17 | US | North Carolina | Granville | 37077 | 1666 | 48 | 0 | 1618 | 36.30337451 | -78.65184241 | 2020-09-18 05:05:00 | Granville, North Carolina, US |
668948 | 668948 | 2020-09-16 | US | Pennsylvania | Monroe | 42089 | 1747 | 129 | 0 | 1618 | 41.05934058 | -75.34031025 | 2020-09-17 04:22:00 | Monroe, Pennsylvania, US |
668924 | 668924 | 2020-09-16 | US | Pennsylvania | Cumberland | 42041 | 1691 | 73 | 0 | 1618 | 40.1625372 | -77.26130755 | 2020-09-17 04:22:00 | Cumberland, Pennsylvania, US |
2060237 | 2060237 | 2020-09-01 | US | Alabama | Cullman | 1043 | 1632 | 14 | 0 | 1618 | 34.13020303 | -86.86888037 | 2020-09-02 04:28:25 | Cullman, Alabama, US |
194795 | 194795 | 2020-08-31 | US | Florida | Walton | 12131 | 1638 | 20 | 0 | 1618 | 30.64204028 | -86.16935664 | 2020-09-01 04:28:31 | Walton, Florida, US |
1482214 | 1482214 | 2020-08-21 | US | Pennsylvania | Lebanon | 42075 | 1674 | 56 | 0 | 1618 | 40.36680311 | -76.45651841 | 2020-08-22 04:27:49 | Lebanon, Pennsylvania, US |
2738204 | 2738204 | 2020-08-03 | US | Illinois | Kankakee | 17091 | 1686 | 68 | 0 | 1618 | 41.13746989 | -87.86205334 | 2020-08-04 04:41:59 | Kankakee, Illinois, US |
750769 | 750769 | 2020-08-01 | US | North Carolina | Davidson | 37057 | 1635 | 17 | 0 | 1618 | 35.79115496 | -80.21256572 | 2020-08-02 04:34:47 | Davidson, North Carolina, 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]);