johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
154 rows where active = 1538 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3335169 | 3335169 | 2021-07-21 | Ukraine | Sevastopol* | 19177 | 807 | 16832 | 1538 | 44.6054 | 33.522 | 2021-07-22 04:21:19 | Sevastopol*, Ukraine | ||
2693659 | 2693659 | 2021-07-06 | India | Uttarakhand | 340882 | 7338 | 332006 | 1538 | 30.156447 | 79.197608 | 2021-07-07 04:21:20 | Uttarakhand, India | ||
562998 | 562998 | 2021-06-22 | Japan | Okinawa | 20206 | 171 | 18497 | 1538 | 25.768923 | 126.668016 | 2021-06-23 04:21:46 | Okinawa, Japan | ||
1711945 | 1711945 | 2021-06-02 | Ukraine | Poltava Oblast | 77076 | 1801 | 73737 | 1538 | 49.5883 | 34.5514 | 2021-06-03 04:23:32 | Poltava Oblast, Ukraine | ||
50979 | 50979 | 2021-05-29 | Russia | Bashkortostan Republic | 38021 | 519 | 35964 | 1538 | 54.8573563 | 57.1439682 | 2021-05-30 04:20:55 | Bashkortostan Republic, Russia | ||
86777 | 86777 | 2021-05-25 | Malaysia | Sabah | 60829 | 459 | 58832 | 1538 | 5.9788 | 116.0753 | 2021-05-26 04:20:35 | Sabah, Malaysia | ||
1913464 | 1913464 | 2021-05-20 | Russia | Tver Oblast | 41330 | 977 | 38815 | 1538 | 57.1134475 | 35.174442799999994 | 2021-05-21 04:20:43 | Tver Oblast, Russia | ||
1551742 | 1551742 | 2021-05-08 | Canada | Nova Scotia | 3754 | 71 | 2145 | 1538 | 44.682 | -63.7443 | 2021-05-09 04:20:35 | Nova Scotia, Canada | ||
2502285 | 2502285 | 2021-05-07 | Russia | Ulyanovsk Oblast | 54020 | 1228 | 51254 | 1538 | 54.1463177 | 47.2324921 | 2021-05-08 04:21:04 | Ulyanovsk Oblast, Russia | ||
3702343 | 3702343 | 2021-04-27 | Russia | Orel Oblast | 33968 | 564 | 31866 | 1538 | 52.96854329999999 | 36.0692477 | 2021-04-28 04:20:32 | Orel Oblast, Russia | ||
2645776 | 2645776 | 2021-04-08 | Japan | Miyagi | 6864 | 41 | 5285 | 1538 | 38.446859 | 140.927086 | 2021-04-09 04:21:13 | Miyagi, Japan | ||
1302064 | 1302064 | 2021-04-01 | Japan | Hyogo | 20257 | 594 | 18125 | 1538 | 35.039913 | 134.828057 | 2021-04-02 04:20:36 | Hyogo, Japan | ||
3669812 | 3669812 | 2021-03-06 | US | New Mexico | Lincoln | 35027 | 1554 | 16 | 0 | 1538 | 33.74526079 | -105.4586166 | 2021-03-07 05:21:54 | Lincoln, New Mexico, US |
1618433 | 1618433 | 2021-03-05 | US | New Mexico | Lincoln | 35027 | 1554 | 16 | 0 | 1538 | 33.74526079 | -105.4586166 | 2021-03-06 04:23:41 | Lincoln, New Mexico, US |
1617099 | 1617099 | 2021-03-05 | US | Georgia | Rabun | 13241 | 1583 | 45 | 0 | 1538 | 34.88389445 | -83.40304637 | 2021-03-06 04:23:41 | Rabun, Georgia, US |
2369113 | 2369113 | 2021-02-28 | US | Michigan | Clare | 26035 | 1607 | 69 | 0 | 1538 | 43.98794227 | -84.84819859999998 | 2021-03-01 05:23:01 | Clare, Michigan, US |
3067615 | 3067615 | 2021-02-27 | US | Michigan | Clare | 26035 | 1607 | 69 | 0 | 1538 | 43.98794227 | -84.84819859999998 | 2021-02-28 05:22:20 | Clare, Michigan, US |
280874 | 280874 | 2021-02-24 | US | Florida | Hamilton | 12047 | 1559 | 21 | 0 | 1538 | 30.49673973 | -82.94998918 | 2021-02-25 05:24:57 | Hamilton, Florida, US |
531875 | 531875 | 2021-02-22 | US | Iowa | Clayton | 19043 | 1591 | 53 | 0 | 1538 | 42.84443388 | -91.34133693 | 2021-02-23 05:23:41 | Clayton, Iowa, US |
184532 | 184532 | 2021-02-21 | US | Ohio | Paulding | 39125 | 1576 | 38 | 0 | 1538 | 41.11676341 | -84.5801017 | 2021-02-22 05:24:21 | Paulding, Ohio, US |
183209 | 183209 | 2021-02-21 | US | Iowa | Clayton | 19043 | 1591 | 53 | 0 | 1538 | 42.84443388 | -91.34133693 | 2021-02-22 05:24:21 | Clayton, Iowa, US |
743452 | 743452 | 2021-02-20 | US | Indiana | Vermillion | 18165 | 1578 | 40 | 0 | 1538 | 39.8523352 | -87.46160542 | 2021-02-21 05:24:33 | Vermillion, Indiana, US |
1156139 | 1156139 | 2021-02-18 | US | Texas | Bosque | 48035 | 1836 | 28 | 0 | 1538 | 31.89978581 | -97.63613524 | 2021-02-19 05:24:16 | Bosque, Texas, US |
1154834 | 1154834 | 2021-02-18 | US | Minnesota | Houston | 27055 | 1552 | 14 | 0 | 1538 | 43.67129565 | -91.49143057 | 2021-02-19 05:24:16 | Houston, Minnesota, US |
1154579 | 1154579 | 2021-02-18 | US | Kentucky | Russell | 21207 | 1574 | 36 | 0 | 1538 | 36.99308373 | -85.06070117 | 2021-02-19 05:24:16 | Russell, Kentucky, US |
3604059 | 3604059 | 2021-02-17 | US | Texas | Bosque | 48035 | 1836 | 28 | 0 | 1538 | 31.89978581 | -97.63613524 | 2021-02-18 05:22:58 | Bosque, Texas, US |
1338976 | 1338976 | 2021-02-15 | US | Florida | Lafayette | 12067 | 1562 | 24 | 0 | 1538 | 29.98484137 | -83.18166636 | 2021-02-16 05:24:38 | Lafayette, Florida, US |
2678220 | 2678220 | 2021-02-13 | US | Alabama | Randolph | 1111 | 1576 | 38 | 0 | 1538 | 33.29526734 | -85.45708831 | 2021-02-14 05:23:43 | Randolph, Alabama, US |
2639013 | 2639013 | 2021-02-11 | US | Kansas | Jefferson | 20087 | 1568 | 30 | 0 | 1538 | 39.2347941 | -95.38289232 | 2021-02-12 05:23:29 | Jefferson, Kansas, US |
2638397 | 2638397 | 2021-02-11 | US | Florida | Calhoun | 12013 | 1574 | 36 | 0 | 1538 | 30.40666734 | -85.19394153 | 2021-02-12 05:23:29 | Calhoun, Florida, US |
3979868 | 3979868 | 2021-02-10 | US | Kansas | Jefferson | 20087 | 1568 | 30 | 0 | 1538 | 39.2347941 | -95.38289232 | 2021-02-11 05:23:55 | Jefferson, Kansas, US |
1530889 | 1530889 | 2021-02-09 | US | Tennessee | Union | 47173 | 1608 | 28 | 0 | 1538 | 36.28590426 | -83.83651902 | 2021-02-10 05:22:41 | Union, Tennessee, US |
976703 | 976703 | 2021-02-06 | US | Mississippi | Clarke | 28023 | 1604 | 66 | 0 | 1538 | 32.04158545 | -88.68896219999998 | 2021-02-07 05:23:00 | Clarke, Mississippi, US |
790636 | 790636 | 2021-02-04 | Russia | Tyumen Oblast | 28779 | 253 | 26988 | 1538 | 58.8206488 | 70.36588370000001 | 2021-02-05 05:22:38 | Tyumen Oblast, Russia | ||
341268 | 341268 | 2021-02-03 | US | Illinois | Jo Daviess | 17085 | 1560 | 22 | 0 | 1538 | 42.36542373 | -90.21094405 | 2021-02-04 05:22:26 | Jo Daviess, Illinois, US |
1900349 | 1900349 | 2021-01-29 | US | Texas | Reeves | 48389 | 1261 | 36 | 0 | 1538 | 31.32323325 | -103.6903896 | 2021-01-30 05:22:49 | Reeves, Texas, US |
3157287 | 3157287 | 2021-01-27 | Malaysia | Pulau Pinang | 7478 | 12 | 5928 | 1538 | 5.4141 | 100.3288 | 2021-01-28 05:22:24 | Pulau Pinang, Malaysia | ||
3154721 | 3154721 | 2021-01-27 | US | Indiana | Perry | 18123 | 1569 | 31 | 0 | 1538 | 38.07809328 | -86.63741946 | 2021-01-28 05:22:24 | Perry, Indiana, US |
2568695 | 2568695 | 2021-01-25 | US | Illinois | Richland | 17159 | 1575 | 37 | 0 | 1538 | 38.71240969 | -88.08475366 | 2021-01-26 05:22:02 | Richland, Illinois, US |
1760610 | 1760610 | 2021-01-24 | US | Kansas | Neosho | 20133 | 1553 | 15 | 0 | 1538 | 37.55862897 | -95.30670046 | 2021-01-25 05:22:16 | Neosho, Kansas, US |
1760420 | 1760420 | 2021-01-24 | US | Indiana | Rush | 18139 | 1558 | 20 | 0 | 1538 | 39.62002287 | -85.4655599 | 2021-01-25 05:22:16 | Rush, Indiana, US |
2428217 | 2428217 | 2021-01-23 | US | Kansas | Neosho | 20133 | 1553 | 15 | 0 | 1538 | 37.55862897 | -95.30670046 | 2021-01-24 05:22:35 | Neosho, Kansas, US |
2428092 | 2428092 | 2021-01-23 | US | Iowa | Hardin | 19083 | 1569 | 31 | 0 | 1538 | 42.38353877 | -93.23654611 | 2021-01-24 05:22:35 | Hardin, Iowa, US |
2468733 | 2468733 | 2021-01-22 | US | Missouri | Morgan | 29141 | 1572 | 34 | 0 | 1538 | 38.4181765 | -92.88791859 | 2021-01-23 05:22:03 | Morgan, Missouri, US |
2468119 | 2468119 | 2021-01-22 | US | Kansas | Neosho | 20133 | 1553 | 15 | 0 | 1538 | 37.55862897 | -95.30670046 | 2021-01-23 05:22:03 | Neosho, Kansas, US |
2467831 | 2467831 | 2021-01-22 | US | Illinois | Pike | 17149 | 1583 | 45 | 0 | 1538 | 39.62265059 | -90.8877017 | 2021-01-23 05:22:03 | Pike, Illinois, US |
2467259 | 2467259 | 2021-01-22 | US | Arkansas | Ashley | 5003 | 1565 | 27 | 0 | 1538 | 33.19153461 | -91.7698471 | 2021-01-23 05:22:03 | Ashley, Arkansas, US |
436177 | 436177 | 2021-01-21 | US | Georgia | Lamar | 13171 | 1577 | 39 | 0 | 1538 | 33.07841647 | -84.14263877 | 2021-01-22 05:22:10 | Lamar, Georgia, US |
1096015 | 1096015 | 2021-01-20 | US | Missouri | Morgan | 29141 | 1569 | 31 | 0 | 1538 | 38.4181765 | -92.88791859 | 2021-01-21 05:22:01 | Morgan, Missouri, US |
909421 | 909421 | 2021-01-19 | US | Iowa | Winneshiek | 19191 | 1557 | 19 | 0 | 1538 | 43.29094334 | -91.84422722 | 2021-01-20 05:21:54 | Winneshiek, Iowa, US |
238057 | 238057 | 2021-01-18 | US | Georgia | Jefferson | 13163 | 1582 | 44 | 0 | 1538 | 33.05867328 | -82.41609057 | 2021-01-19 05:22:15 | Jefferson, Georgia, US |
3517650 | 3517650 | 2021-01-15 | US | New York | Otsego | 36077 | 1559 | 21 | 0 | 1538 | 42.63492579 | -75.03151402 | 2021-01-16 05:22:40 | Otsego, New York, US |
3882992 | 3882992 | 2021-01-14 | US | Virginia | Wythe | 51197 | 1568 | 30 | 0 | 1538 | 36.91582035 | -81.07834059 | 2021-01-15 05:22:24 | Wythe, Virginia, US |
3309680 | 3309680 | 2021-01-13 | US | Louisiana | Assumption | 22007 | 1567 | 29 | 0 | 1538 | 29.89946234 | -91.06461642 | 2021-01-14 05:22:32 | Assumption, Louisiana, US |
3902513 | 3902513 | 2021-01-09 | US | Oklahoma | Kingfisher | 40073 | 1550 | 12 | 0 | 1538 | 35.94530008 | -97.94193268 | 2021-01-10 05:22:12 | Kingfisher, Oklahoma, US |
3233146 | 3233146 | 2021-01-03 | US | Pennsylvania | Warren | 42123 | 1574 | 36 | 0 | 1538 | 41.81304978 | -79.26969577 | 2021-01-04 05:22:02 | Warren, Pennsylvania, US |
3231577 | 3231577 | 2021-01-03 | US | Indiana | Spencer | 18147 | 1552 | 14 | 0 | 1538 | 38.01519732 | -87.0079644 | 2021-01-04 05:22:02 | Spencer, Indiana, US |
2230905 | 2230905 | 2021-01-02 | US | Virginia | Pulaski | 51155 | 1572 | 34 | 0 | 1538 | 37.06474963 | -80.71229738 | 2021-01-03 05:22:52 | Pulaski, Virginia, US |
1138312 | 1138312 | 2021-01-01 | US | Kentucky | Marshall | 21157 | 1558 | 20 | 0 | 1538 | 36.88007070000001 | -88.32803576 | 2021-01-02 05:22:33 | Marshall, Kentucky, US |
1138101 | 1138101 | 2021-01-01 | US | Iowa | O'Brien | 19141 | 1591 | 53 | 0 | 1538 | 43.08310673 | -95.62474482 | 2021-01-02 05:22:33 | O'Brien, Iowa, US |
3696918 | 3696918 | 2020-12-31 | US | Kentucky | Marshall | 21157 | 1558 | 20 | 0 | 1538 | 36.88007070000001 | -88.32803576 | 2021-01-01 05:23:07 | Marshall, Kentucky, US |
1011733 | 1011733 | 2020-12-30 | US | Kentucky | Marshall | 21157 | 1558 | 20 | 0 | 1538 | 36.88007070000001 | -88.32803576 | 2020-12-31 05:22:49 | Marshall, Kentucky, US |
2226427 | 2226427 | 2020-12-26 | US | Tennessee | Crockett | 47033 | 1584 | 30 | 0 | 1538 | 35.81830662 | -89.14916269 | 2020-12-27 05:22:55 | Crockett, Tennessee, US |
2225436 | 2225436 | 2020-12-26 | US | Missouri | New Madrid | 29143 | 1567 | 29 | 0 | 1538 | 36.59666326 | -89.66070007 | 2020-12-27 05:22:55 | New Madrid, Missouri, US |
2407035 | 2407035 | 2020-12-23 | Russia | Karachay-Cherkess Republic | 14396 | 38 | 12820 | 1538 | 43.7368326 | 41.7267991 | 2020-12-24 05:23:04 | Karachay-Cherkess Republic, Russia | ||
930153 | 930153 | 2020-12-21 | US | Ohio | Hardin | 39065 | 1581 | 43 | 0 | 1538 | 40.66015414 | -83.65929931 | 2020-12-22 05:22:33 | Hardin, Ohio, US |
929834 | 929834 | 2020-12-21 | US | New Hampshire | Belknap | 33001 | 1579 | 41 | 0 | 1538 | 43.51637314 | -71.41684235 | 2020-12-22 05:22:33 | Belknap, New Hampshire, US |
1903832 | 1903832 | 2020-12-18 | US | Pennsylvania | Jefferson | 42065 | 1563 | 25 | 0 | 1538 | 41.12913106 | -78.9986361 | 2020-12-19 05:27:52 | Jefferson, Pennsylvania, US |
2131434 | 2131434 | 2020-12-17 | US | Washington | Okanogan | 53047 | 1564 | 26 | 0 | 1538 | 48.54855019 | -119.7387224 | 2020-12-18 05:28:18 | Okanogan, Washington, US |
2129167 | 2129167 | 2020-12-17 | US | Iowa | Delaware | 19055 | 1565 | 27 | 0 | 1538 | 42.47104597 | -91.3664492 | 2020-12-18 05:28:18 | Delaware, Iowa, US |
2128188 | 2128188 | 2020-12-17 | Russia | Ingushetia Republic | 10902 | 123 | 9241 | 1538 | 43.11542075 | 45.01713552 | 2020-12-18 05:28:18 | Ingushetia Republic, Russia | ||
3851326 | 3851326 | 2020-12-13 | US | Wisconsin | Iowa | 55049 | 1544 | 6 | 0 | 1538 | 43.00050278 | -90.13469017 | 2020-12-14 05:26:27 | Iowa, Wisconsin, US |
1602012 | 1602012 | 2020-12-10 | US | Mississippi | Grenada | 28043 | 1587 | 49 | 0 | 1538 | 33.77036166 | -89.80245083 | 2020-12-11 05:26:59 | Grenada, Mississippi, US |
1822171 | 1822171 | 2020-12-08 | US | Virginia | Prince George | 51149 | 1545 | 7 | 0 | 1538 | 37.18497668 | -77.22922187 | 2020-12-09 05:28:01 | Prince George, Virginia, US |
2350245 | 2350245 | 2020-12-07 | US | South Carolina | Marlboro | 45069 | 1558 | 20 | 0 | 1538 | 34.59905577 | -79.67561152 | 2020-12-08 05:27:42 | Marlboro, South Carolina, US |
1634545 | 1634545 | 2020-12-05 | US | New York | Ontario | 36069 | 1575 | 37 | 0 | 1538 | 42.85145728 | -77.30874425 | 2020-12-06 05:26:18 | Ontario, New York, US |
3862760 | 3862760 | 2020-12-04 | US | Tennessee | Giles | 47055 | 1612 | 51 | 0 | 1538 | 35.20222469 | -87.03992678 | 2020-12-05 05:27:36 | Giles, Tennessee, US |
3861063 | 3861063 | 2020-12-04 | US | Iowa | Tama | 19171 | 1580 | 42 | 0 | 1538 | 42.07991767 | -92.53266945 | 2020-12-05 05:27:36 | Tama, Iowa, US |
77740 | 77740 | 2020-12-03 | US | Pennsylvania | Columbia | 42037 | 1589 | 51 | 0 | 1538 | 41.04821986 | -76.40565017 | 2020-12-04 05:27:27 | Columbia, Pennsylvania, US |
75824 | 75824 | 2020-12-03 | US | Florida | Washington | 12133 | 1565 | 27 | 0 | 1538 | 30.61359259 | -85.66002461 | 2020-12-04 05:27:27 | Washington, Florida, US |
3568193 | 3568193 | 2020-11-29 | US | Michigan | Gratiot | 26057 | 1567 | 29 | 0 | 1538 | 43.29265605 | -84.60505416 | 2020-11-30 05:26:13 | Gratiot, Michigan, US |
2936858 | 2936858 | 2020-11-28 | US | Michigan | Gratiot | 26057 | 1567 | 29 | 0 | 1538 | 43.29265605 | -84.60505416 | 2020-11-29 05:25:55 | Gratiot, Michigan, US |
1975697 | 1975697 | 2020-11-25 | US | Texas | Hopkins | 48223 | 1049 | 52 | 0 | 1538 | 33.14875072 | -95.56351139 | 2020-11-26 05:27:44 | Hopkins, Texas, US |
1973590 | 1973590 | 2020-11-25 | US | Illinois | Logan | 17107 | 1548 | 10 | 0 | 1538 | 40.12581572 | -89.36638784 | 2020-11-26 05:27:44 | Logan, Illinois, US |
1351680 | 1351680 | 2020-11-24 | US | Kentucky | Boyd | 21019 | 1562 | 24 | 0 | 1538 | 38.36176608 | -82.68652187 | 2020-11-25 05:27:20 | Boyd, Kentucky, US |
3189697 | 3189697 | 2020-11-22 | Bahrain | 85705 | 338 | 83829 | 1538 | 26.0275 | 50.55 | 2020-11-23 05:25:26 | Bahrain | |||
3838310 | 3838310 | 2020-11-21 | US | Mississippi | Pike | 28113 | 1596 | 58 | 0 | 1538 | 31.17507789 | -90.40392572 | 2020-11-22 05:25:45 | Pike, Mississippi, US |
2704343 | 2704343 | 2020-11-20 | US | South Carolina | Williamsburg | 45089 | 1588 | 50 | 0 | 1538 | 33.62190129 | -79.72767442 | 2020-11-21 05:25:51 | Williamsburg, South Carolina, US |
821812 | 821812 | 2020-11-19 | Russia | Samara Oblast | 19728 | 369 | 17821 | 1538 | 53.2128813 | 50.8914633 | 2020-11-20 05:26:28 | Samara Oblast, Russia | ||
821414 | 821414 | 2020-11-19 | Colombia | Cesar | 28294 | 870 | 25886 | 1538 | 9.3373 | -73.6536 | 2020-11-20 05:26:28 | Cesar, Colombia | ||
123783 | 123783 | 2020-11-18 | US | Indiana | Gibson | 18051 | 1561 | 23 | 0 | 1538 | 38.30393723 | -87.58054938 | 2020-11-19 05:25:23 | Gibson, Indiana, US |
123290 | 123290 | 2020-11-18 | US | California | Yuba | 6115 | 1547 | 10 | 0 | 1538 | 39.26255932 | -121.3535644 | 2020-11-19 05:25:23 | Yuba, California, US |
3341100 | 3341100 | 2020-11-17 | US | Ohio | Union | 39159 | 1548 | 10 | 0 | 1538 | 40.30016061 | -83.37239023 | 2020-11-18 05:40:31 | Union, Ohio, US |
2917768 | 2917768 | 2020-11-14 | US | Oklahoma | Sequoyah | 40135 | 1552 | 14 | 0 | 1538 | 35.49447108 | -94.75463785 | 2020-11-15 05:26:53 | Sequoyah, Oklahoma, US |
867137 | 867137 | 2020-11-12 | US | North Carolina | Watauga | 37189 | 1544 | 6 | 0 | 1538 | 36.23103603 | -81.70033724 | 2020-11-13 05:25:30 | Watauga, North Carolina, US |
3442553 | 3442553 | 2020-11-11 | US | Minnesota | Otter Tail | 27111 | 1547 | 9 | 0 | 1538 | 46.40846929 | -95.70835255 | 2020-11-12 05:25:55 | Otter Tail, Minnesota, US |
274496 | 274496 | 2020-11-10 | US | North Carolina | Pender | 37141 | 1555 | 17 | 0 | 1538 | 34.52265624 | -77.90352133 | 2020-11-11 05:25:30 | Pender, North Carolina, US |
1990497 | 1990497 | 2020-11-09 | US | Missouri | Butler | 29023 | 1546 | 8 | 0 | 1538 | 36.71462476 | -90.40421163 | 2020-11-10 05:40:07 | Butler, Missouri, US |
1988560 | 1988560 | 2020-11-09 | Guinea | 12459 | 74 | 10847 | 1538 | 9.9456 | -9.6966 | 2020-11-10 05:40:07 | Guinea | |||
1729512 | 1729512 | 2020-11-08 | US | Illinois | Randolph | 17157 | 1557 | 19 | 0 | 1538 | 38.05095369 | -89.82512254 | 2020-11-09 05:25:45 | Randolph, Illinois, 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]);