johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
112 rows where active = 1943 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
829394 | 829394 | 2021-07-09 | Chile | Valparaiso | 117292 | 3058 | 112291 | 1943 | -33.0472 | -71.6127 | 2021-07-10 04:21:25 | Valparaiso, Chile | ||
1412978 | 1412978 | 2021-05-24 | Germany | Schleswig-Holstein | 62542 | 1578 | 59100 | 1943 | 54.2194 | 9.6961 | 2021-05-25 04:21:08 | Schleswig-Holstein, Germany | ||
955094 | 955094 | 2021-04-25 | Russia | Novgorod Oblast | 29722 | 121 | 27658 | 1943 | 58.2843833 | 32.5169757 | 2021-04-26 04:21:04 | Novgorod Oblast, Russia | ||
1305716 | 1305716 | 2021-04-01 | Yemen | 4531 | 906 | 1682 | 1943 | 15.552727 | 48.516388 | 2021-04-02 04:20:36 | Yemen | |||
3643784 | 3643784 | 2021-03-30 | Russia | Omsk Oblast | 43683 | 1313 | 40427 | 1943 | 56.09352629999999 | 73.5099936 | 2021-03-31 04:26:25 | Omsk Oblast, Russia | ||
1219799 | 1219799 | 2021-03-27 | Russia | Omsk Oblast | 43395 | 1304 | 40148 | 1943 | 56.09352629999999 | 73.5099936 | 2021-03-28 05:28:10 | Omsk Oblast, Russia | ||
2056114 | 2056114 | 2021-03-15 | Russia | Omsk Oblast | 42278 | 1270 | 39065 | 1943 | 56.09352629999999 | 73.5099936 | 2021-03-16 05:25:13 | Omsk Oblast, Russia | ||
3671006 | 3671006 | 2021-03-06 | US | Virginia | Prince Edward | 51147 | 1972 | 29 | 0 | 1943 | 37.22554789 | -78.43597949 | 2021-03-07 05:21:54 | Prince Edward, Virginia, US |
2211194 | 2211194 | 2021-03-04 | US | Wisconsin | Iowa | 55049 | 1954 | 11 | 0 | 1943 | 43.00050278 | -90.13469017 | 2021-03-05 05:26:29 | Iowa, Wisconsin, US |
2183949 | 2183949 | 2021-02-26 | US | Alabama | Fayette | 1057 | 1999 | 56 | 0 | 1943 | 33.72076938 | -87.73886638 | 2021-02-27 05:22:28 | Fayette, Alabama, US |
1939006 | 1939006 | 2021-02-23 | US | Oklahoma | Kingfisher | 40073 | 1964 | 21 | 0 | 1943 | 35.94530008 | -97.94193268 | 2021-02-24 05:29:16 | Kingfisher, Oklahoma, US |
1937827 | 1937827 | 2021-02-23 | US | Kentucky | Carter | 21043 | 1965 | 22 | 0 | 1943 | 38.31690743 | -83.05092385 | 2021-02-24 05:29:16 | Carter, Kentucky, US |
531344 | 531344 | 2021-02-22 | US | Colorado | Pitkin | 8097 | 2009 | 4 | 0 | 1943 | 39.21720112 | -106.9310027 | 2021-02-23 05:23:41 | Pitkin, Colorado, US |
742915 | 742915 | 2021-02-20 | US | Colorado | Crowley | 8025 | 1994 | 14 | 0 | 1943 | 38.32608609 | -103.7844965 | 2021-02-21 05:24:33 | Crowley, Colorado, US |
2285208 | 2285208 | 2021-02-14 | US | Mississippi | Chickasaw | 28017 | 1993 | 50 | 0 | 1943 | 33.91983202 | -88.9481545 | 2021-02-15 05:24:49 | Chickasaw, Mississippi, US |
2284308 | 2284308 | 2021-02-14 | US | Georgia | Union | 13291 | 2008 | 65 | 0 | 1943 | 34.82995757 | -83.98967069 | 2021-02-15 05:24:49 | Union, Georgia, US |
3542855 | 3542855 | 2021-02-12 | US | Virginia | Russell | 51167 | 1969 | 26 | 0 | 1943 | 36.93028320000001 | -82.10095486 | 2021-02-13 05:22:12 | Russell, Virginia, US |
3981875 | 3981875 | 2021-02-10 | US | Virginia | Botetourt | 51023 | 1965 | 22 | 0 | 1943 | 37.55531756 | -79.80982182 | 2021-02-11 05:23:55 | Botetourt, Virginia, US |
615130 | 615130 | 2021-02-08 | US | Kentucky | Morgan | 21175 | 1943 | 0 | 0 | 1943 | 37.92465657 | -83.25558245 | 2021-02-09 05:23:30 | Morgan, Kentucky, US |
1673899 | 1673899 | 2021-02-07 | US | Kentucky | Morgan | 21175 | 1943 | 0 | 0 | 1943 | 37.92465657 | -83.25558245 | 2021-02-08 05:22:39 | Morgan, Kentucky, US |
976722 | 976722 | 2021-02-06 | US | Mississippi | Jasper | 28061 | 1983 | 40 | 0 | 1943 | 32.01922104 | -89.11786866 | 2021-02-07 05:23:00 | Jasper, Mississippi, US |
1461536 | 1461536 | 2021-01-31 | US | Mississippi | Attala | 28007 | 2008 | 65 | 0 | 1943 | 33.08658803 | -89.57838564 | 2021-02-01 05:22:53 | Attala, Mississippi, US |
3155489 | 3155489 | 2021-01-27 | US | Missouri | Crawford | 29055 | 1967 | 24 | 0 | 1943 | 37.97663738 | -91.30528104 | 2021-01-28 05:22:24 | Crawford, Missouri, US |
1762933 | 1762933 | 2021-01-24 | Ukraine | Volyn Oblast | 36048 | 564 | 33541 | 1943 | 50.7472 | 25.3254 | 2021-01-25 05:22:16 | Volyn Oblast, Ukraine | ||
1759365 | 1759365 | 2021-01-24 | Mali | 7983 | 323 | 5717 | 1943 | 17.570692 | -3.996166000000001 | 2021-01-25 05:22:16 | Mali | |||
1095124 | 1095124 | 2021-01-20 | US | Illinois | Shelby | 17173 | 1975 | 32 | 0 | 1943 | 39.39133527 | -88.80611122 | 2021-01-21 05:22:01 | Shelby, Illinois, US |
908874 | 908874 | 2021-01-19 | US | Florida | Holmes | 12059 | 1975 | 32 | 0 | 1943 | 30.86747479 | -85.81319222 | 2021-01-20 05:21:54 | Holmes, Florida, US |
238283 | 238283 | 2021-01-18 | US | Illinois | Union | 17181 | 1973 | 30 | 0 | 1943 | 37.47119609 | -89.25548938 | 2021-01-19 05:22:15 | Union, Illinois, US |
3506135 | 3506135 | 2021-01-17 | US | Puerto Rico | Vega Baja | 72145 | 1943 | 0 | 0 | 1943 | 18.428262 | -66.397924 | 2021-01-18 05:22:34 | Vega Baja, Puerto Rico, US |
3504400 | 3504400 | 2021-01-17 | US | Illinois | Union | 17181 | 1973 | 30 | 0 | 1943 | 37.47119609 | -89.25548938 | 2021-01-18 05:22:34 | Union, Illinois, US |
3518821 | 3518821 | 2021-01-15 | US | Virginia | York | 51199 | 1956 | 13 | 0 | 1943 | 37.24374789 | -76.54412815 | 2021-01-16 05:22:40 | York, Virginia, US |
3515770 | 3515770 | 2021-01-15 | US | Alabama | Geneva | 1061 | 1974 | 31 | 0 | 1943 | 31.09389027 | -85.83572839 | 2021-01-16 05:22:40 | Geneva, Alabama, US |
190030 | 190030 | 2021-01-11 | India | Odisha | 332106 | 1892 | 328271 | 1943 | 20.505428 | 84.418059 | 2021-01-12 05:22:15 | Odisha, India | ||
2627448 | 2627448 | 2021-01-10 | US | Maryland | Somerset | 24039 | 1965 | 22 | 0 | 1943 | 38.1163542 | -75.75118623 | 2021-01-11 05:21:50 | Somerset, Maryland, US |
3902622 | 3902622 | 2021-01-09 | US | Pennsylvania | Greene | 42059 | 1964 | 21 | 0 | 1943 | 39.85746531 | -80.22357106 | 2021-01-10 05:22:12 | Greene, Pennsylvania, US |
3036968 | 3036968 | 2021-01-05 | US | Pennsylvania | Jefferson | 42065 | 1990 | 47 | 0 | 1943 | 41.12913106 | -78.9986361 | 2021-01-06 05:22:16 | Jefferson, Pennsylvania, US |
3035427 | 3035427 | 2021-01-05 | US | Indiana | Scott | 18143 | 1982 | 39 | 0 | 1943 | 38.68672078 | -85.74627859 | 2021-01-06 05:22:16 | Scott, Indiana, US |
1062929 | 1062929 | 2021-01-04 | US | Indiana | Greene | 18055 | 2005 | 62 | 0 | 1943 | 39.03630547 | -86.96223202 | 2021-01-05 05:21:49 | Greene, Indiana, US |
1062552 | 1062552 | 2021-01-04 | US | Florida | Levy | 12075 | 1963 | 20 | 0 | 1943 | 29.31829741 | -82.74007147 | 2021-01-05 05:21:49 | Levy, Florida, US |
1137895 | 1137895 | 2021-01-01 | US | Illinois | McDonough | 17109 | 1978 | 35 | 0 | 1943 | 40.45674722 | -90.67775541 | 2021-01-02 05:22:33 | McDonough, Illinois, US |
3696501 | 3696501 | 2020-12-31 | US | Illinois | McDonough | 17109 | 1978 | 35 | 0 | 1943 | 40.45674722 | -90.67775541 | 2021-01-01 05:23:07 | McDonough, Illinois, US |
1013554 | 1013554 | 2020-12-30 | US | Texas | Wood | 48499 | 1266 | 65 | 0 | 1943 | 32.78722382 | -95.38236368 | 2020-12-31 05:22:49 | Wood, Texas, US |
1012661 | 1012661 | 2020-12-30 | US | North Carolina | Stokes | 37169 | 1970 | 27 | 0 | 1943 | 36.4017975 | -80.23893369 | 2020-12-31 05:22:49 | Stokes, North Carolina, US |
2225200 | 2225200 | 2020-12-26 | US | Minnesota | Brown | 27015 | 1973 | 30 | 0 | 1943 | 44.24205652 | -94.72562874 | 2020-12-27 05:22:55 | Brown, Minnesota, US |
202639 | 202639 | 2020-12-25 | US | Alabama | Marion | 1093 | 1986 | 43 | 0 | 1943 | 34.13697363 | -87.88704173 | 2020-12-26 05:22:28 | Marion, Alabama, US |
3772710 | 3772710 | 2020-12-22 | US | South Carolina | Williamsburg | 45089 | 2001 | 58 | 0 | 1943 | 33.62190129 | -79.72767442 | 2020-12-23 05:22:03 | Williamsburg, South Carolina, US |
3770548 | 3770548 | 2020-12-22 | US | Florida | Bradford | 12007 | 1965 | 22 | 0 | 1943 | 29.95079741 | -82.16611613 | 2020-12-23 05:22:03 | Bradford, Florida, US |
2933915 | 2933915 | 2020-12-19 | US | Pennsylvania | Venango | 42121 | 1974 | 31 | 0 | 1943 | 41.40323442 | -79.75845449 | 2020-12-20 05:27:32 | Venango, Pennsylvania, US |
3151379 | 3151379 | 2020-12-16 | US | Mississippi | Copiah | 28029 | 1985 | 42 | 0 | 1943 | 31.86977774 | -90.44565118 | 2020-12-17 05:28:12 | Copiah, Mississippi, US |
3849288 | 3849288 | 2020-12-13 | US | Louisiana | Jefferson Davis | 22053 | 1999 | 56 | 0 | 1943 | 30.26896765 | -92.81210004 | 2020-12-14 05:26:27 | Jefferson Davis, Louisiana, US |
861076 | 861076 | 2020-12-11 | US | Alabama | Tallapoosa | 1123 | 2036 | 93 | 0 | 1943 | 32.86698258 | -85.79833053 | 2020-12-12 05:26:19 | Tallapoosa, Alabama, US |
1602804 | 1602804 | 2020-12-10 | US | Oklahoma | Sequoyah | 40135 | 1957 | 14 | 0 | 1943 | 35.49447108 | -94.75463785 | 2020-12-11 05:26:59 | Sequoyah, Oklahoma, US |
2350802 | 2350802 | 2020-12-07 | US | Virginia | Pittsylvania | 51143 | 1968 | 25 | 0 | 1943 | 36.81980341 | -79.39731264 | 2020-12-08 05:27:42 | Pittsylvania, Virginia, US |
2350379 | 2350379 | 2020-12-07 | US | Tennessee | Macon | 47111 | 1973 | 31 | 0 | 1943 | 36.53157855 | -86.00778595 | 2020-12-08 05:27:42 | Macon, Tennessee, US |
77765 | 77765 | 2020-12-03 | US | Pennsylvania | Mifflin | 42087 | 1988 | 45 | 0 | 1943 | 40.61116939 | -77.61070738 | 2020-12-04 05:27:27 | Mifflin, Pennsylvania, US |
2936311 | 2936311 | 2020-11-28 | US | Indiana | Gibson | 18051 | 1982 | 39 | 0 | 1943 | 38.30393723 | -87.58054938 | 2020-11-29 05:25:55 | Gibson, Indiana, US |
1975835 | 1975835 | 2020-11-25 | US | Texas | Wise | 48497 | 2028 | 34 | 0 | 1943 | 33.21570665 | -97.65460265 | 2020-11-26 05:27:44 | Wise, Texas, US |
1974605 | 1974605 | 2020-11-25 | US | Montana | Silver Bow | 30093 | 1964 | 21 | 0 | 1943 | 45.90018933 | -112.6620092 | 2020-11-26 05:27:44 | Silver Bow, Montana, US |
1972950 | 1972950 | 2020-11-25 | US | Alabama | Escambia | 1053 | 1974 | 31 | 0 | 1943 | 31.1256789 | -87.15918694 | 2020-11-26 05:27:44 | Escambia, Alabama, US |
1352643 | 1352643 | 2020-11-24 | US | North Carolina | Lenoir | 37107 | 1993 | 50 | 0 | 1943 | 35.24032589999999 | -77.64245615 | 2020-11-25 05:27:20 | Lenoir, North Carolina, US |
3190749 | 3190749 | 2020-11-22 | US | Georgia | Chattahoochee | 13053 | 1946 | 3 | 0 | 1943 | 32.34341231 | -84.78809239 | 2020-11-23 05:25:26 | Chattahoochee, Georgia, US |
2703594 | 2703594 | 2020-11-20 | US | Nebraska | Lincoln | 31111 | 1956 | 13 | 0 | 1943 | 41.04658298 | -100.7475374 | 2020-11-21 05:25:51 | Lincoln, Nebraska, US |
3338781 | 3338781 | 2020-11-17 | Russia | Buryatia Republic | 15378 | 295 | 13140 | 1943 | 52.7182426 | 109.492143 | 2020-11-18 05:40:31 | Buryatia Republic, Russia | ||
2882769 | 2882769 | 2020-11-15 | US | Oklahoma | McCurtain | 40089 | 1986 | 43 | 0 | 1943 | 34.11664328 | -94.77222373 | 2020-11-16 05:25:57 | McCurtain, Oklahoma, US |
865842 | 865842 | 2020-11-12 | US | Indiana | Dubois | 18037 | 1973 | 30 | 0 | 1943 | 38.36597551 | -86.87924170000002 | 2020-11-13 05:25:30 | Dubois, Indiana, US |
3442333 | 3442333 | 2020-11-11 | US | Louisiana | St. Charles | 22089 | 2008 | 65 | 0 | 1943 | 29.90709658 | -90.35555967 | 2020-11-12 05:25:55 | St. Charles, Louisiana, US |
273673 | 273673 | 2020-11-10 | US | Louisiana | St. Charles | 22089 | 2008 | 65 | 0 | 1943 | 29.90709658 | -90.35555967 | 2020-11-11 05:25:30 | St. Charles, Louisiana, US |
1728904 | 1728904 | 2020-11-08 | US | Alaska | Matanuska-Susitna | 2170 | 1946 | 3 | 0 | 1943 | 62.31305045 | -149.5741743 | 2020-11-09 05:25:45 | Matanuska-Susitna, Alaska, US |
2498365 | 2498365 | 2020-11-03 | US | Alabama | Chilton | 1021 | 1976 | 33 | 0 | 1943 | 32.85044126 | -86.7173256 | 2020-11-04 05:25:09 | Chilton, Alabama, US |
3481707 | 3481707 | 2020-10-26 | US | Kentucky | Hardin | 21093 | 1956 | 13 | 0 | 1943 | 37.6976111 | -85.96319251 | 2020-10-27 04:24:45 | Hardin, Kentucky, US |
1178146 | 1178146 | 2020-10-22 | US | Connecticut | Litchfield | 9005 | 2086 | 143 | 0 | 1943 | 41.7937534 | -73.2451475 | 2020-10-23 04:24:46 | Litchfield, Connecticut, US |
3990454 | 3990454 | 2020-10-20 | Colombia | Cesar | 23894 | 743 | 21208 | 1943 | 9.3373 | -73.6536 | 2020-10-21 04:24:14 | Cesar, Colombia | ||
1797056 | 1797056 | 2020-10-19 | US | Ohio | Allen | 39003 | 2013 | 70 | 0 | 1943 | 40.77285242 | -84.10802343 | 2020-10-20 04:24:22 | Allen, Ohio, US |
1796951 | 1796951 | 2020-10-19 | US | North Carolina | Lee | 37105 | 1959 | 16 | 0 | 1943 | 35.47623147 | -79.17569362 | 2020-10-20 04:24:22 | Lee, North Carolina, US |
1026716 | 1026716 | 2020-10-17 | US | Alabama | Franklin | 1059 | 1974 | 31 | 0 | 1943 | 34.44235334 | -87.84289505 | 2020-10-18 04:24:25 | Franklin, Alabama, US |
2857182 | 2857182 | 2020-10-16 | US | Alabama | Autauga | 1001 | 1971 | 28 | 0 | 1943 | 32.53952745 | -86.64408227 | 2020-10-17 04:24:12 | Autauga, Alabama, US |
787230 | 787230 | 2020-10-15 | US | Georgia | Rockdale | 13247 | 1983 | 40 | 0 | 1943 | 33.65145002 | -84.02202167 | 2020-10-16 04:24:01 | Rockdale, Georgia, US |
79314 | 79314 | 2020-10-14 | Russia | Novgorod Oblast | 6072 | 87 | 4042 | 1943 | 58.2843833 | 32.5169757 | 2020-10-15 04:24:28 | Novgorod Oblast, Russia | ||
3786991 | 3786991 | 2020-10-11 | US | Indiana | Madison | 18095 | 2029 | 86 | 0 | 1943 | 40.16143691 | -85.71964711 | 2020-10-12 04:23:45 | Madison, Indiana, US |
2603592 | 2603592 | 2020-10-10 | US | Maryland | Carroll | 24013 | 2069 | 126 | 0 | 1943 | 39.56453592 | -77.02373735 | 2020-10-11 04:23:46 | Carroll, Maryland, US |
1516450 | 1516450 | 2020-09-28 | US | Indiana | Cass | 18017 | 1955 | 12 | 0 | 1943 | 40.76135835 | -86.34830753 | 2020-09-29 04:23:42 | Cass, Indiana, US |
2657251 | 2657251 | 2020-09-23 | US | West Virginia | Monongalia | 54061 | 1948 | 5 | 0 | 1943 | 39.63218457 | -80.04766838 | 2020-09-24 04:23:00 | Monongalia, West Virginia, US |
3317369 | 3317369 | 2020-09-22 | US | Iowa | Buena Vista | 19021 | 1955 | 12 | 0 | 1943 | 42.73545875 | -95.15100162 | 2020-09-23 04:23:00 | Buena Vista, Iowa, US |
666984 | 666984 | 2020-09-16 | US | Florida | Nassau | 12089 | 1978 | 35 | 0 | 1943 | 30.61037141 | -81.80297522 | 2020-09-17 04:22:00 | Nassau, Florida, US |
666781 | 666781 | 2020-09-16 | US | Arkansas | Pope | 5115 | 1971 | 28 | 0 | 1943 | 35.44871474 | -93.03212219 | 2020-09-17 04:22:00 | Pope, Arkansas, US |
1447665 | 1447665 | 2020-09-11 | US | Texas | Gregg | 48183 | 1378 | 56 | 0 | 1943 | 32.47940482 | -94.81591935 | 2020-09-12 04:25:05 | Gregg, Texas, US |
2664770 | 2664770 | 2020-09-04 | US | Texas | Angelina | 48005 | 1751 | 70 | 0 | 1943 | 31.25457347 | -94.60901487 | 2020-09-05 04:28:19 | Angelina, Texas, US |
1997314 | 1997314 | 2020-08-26 | US | Florida | Citrus | 12017 | 1996 | 53 | 0 | 1943 | 28.84804315 | -82.47614748 | 2020-08-27 04:28:15 | Citrus, Florida, US |
3484664 | 3484664 | 2020-08-20 | US | Alabama | Elmore | 1051 | 1983 | 40 | 0 | 1943 | 32.59785413 | -86.14415284 | 2020-08-21 04:27:41 | Elmore, Alabama, US |
837580 | 837580 | 2020-08-17 | India | Tripura | 7409 | 62 | 5404 | 1943 | 23.746783 | 91.743565 | 2020-08-18 04:27:56 | Tripura, India | ||
3533112 | 3533112 | 2020-08-12 | US | Michigan | Saginaw | 26145 | 2071 | 128 | 0 | 1943 | 43.33433923 | -84.05131209999998 | 2020-08-13 04:29:15 | Saginaw, Michigan, US |
3532129 | 3532129 | 2020-08-12 | US | Florida | Gadsden | 12039 | 1964 | 21 | 0 | 1943 | 30.57796289 | -84.61915825 | 2020-08-13 04:29:15 | Gadsden, Florida, US |
663905 | 663905 | 2020-08-11 | US | Maryland | Harford | 24025 | 2012 | 69 | 0 | 1943 | 39.55010644 | -76.30775940000002 | 2020-08-12 04:27:29 | Harford, Maryland, US |
1917182 | 1917182 | 2020-08-10 | US | Tennessee | Bradley | 47011 | 2020 | 13 | 0 | 1943 | 35.15739424 | -84.857186 | 2020-08-11 04:35:08 | Bradley, Tennessee, US |
95268 | 95268 | 2020-08-04 | US | North Carolina | Catawba | 37035 | 1972 | 29 | 0 | 1943 | 35.66211129 | -81.2132617 | 2020-08-05 04:34:43 | Catawba, North Carolina, US |
94892 | 94892 | 2020-08-04 | US | Alaska | Anchorage | 2020 | 1956 | 13 | 0 | 1943 | 61.14998174 | -149.14269860000005 | 2020-08-05 04:34:43 | Anchorage, Alaska, US |
2737151 | 2737151 | 2020-08-03 | US | North Carolina | Catawba | 37035 | 1972 | 29 | 0 | 1943 | 35.66211129 | -81.2132617 | 2020-08-04 04:41:59 | Catawba, North Carolina, US |
2958712 | 2958712 | 2020-07-29 | Russia | Samara Oblast | 6761 | 85 | 4733 | 1943 | 53.2128813 | 50.8914633 | 2020-07-30 04:35:05 | Samara Oblast, Russia | ||
3184938 | 3184938 | 2020-07-28 | Russia | Altai Krai | 8786 | 64 | 6779 | 1943 | 52.693224300000004 | 82.69314240000001 | 2020-07-29 04:35:11 | Altai Krai, Russia | ||
442817 | 442817 | 2020-07-26 | Albania | 4763 | 138 | 2682 | 1943 | 41.1533 | 20.1683 | 2020-07-27 04:35:02 | Albania |
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]);