johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
148 rows where active = 1450 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2911503 | 2911503 | 2021-06-17 | Syria | 24991 | 1832 | 21709 | 1450 | 34.802075 | 38.99681500000001 | 2021-06-18 04:22:16 | Syria | |||
380146 | 380146 | 2021-04-30 | India | Ladakh | 13969 | 143 | 12376 | 1450 | 34.1526 | 77.5771 | 2021-05-01 04:20:47 | Ladakh, India | ||
3702317 | 3702317 | 2021-04-27 | Russia | Karelia Republic | 45593 | 461 | 43682 | 1450 | 62.61940309999999 | 33.4920267 | 2021-04-28 04:20:32 | Karelia Republic, Russia | ||
1744755 | 1744755 | 2021-03-20 | Russia | Kurgan Oblast | 18745 | 342 | 16953 | 1450 | 55.7655302 | 64.5632681 | 2021-03-21 05:25:44 | Kurgan Oblast, Russia | ||
3668848 | 3668848 | 2021-03-06 | US | Iowa | Poweshiek | 19157 | 1480 | 30 | 0 | 1450 | 41.68625425 | -92.53155731 | 2021-03-07 05:21:54 | Poweshiek, Iowa, US |
1619197 | 1619197 | 2021-03-05 | US | Tennessee | Lewis | 47101 | 1499 | 25 | 0 | 1450 | 35.52853208 | -87.49022694 | 2021-03-06 04:23:41 | Lewis, Tennessee, US |
1617469 | 1617469 | 2021-03-05 | US | Iowa | Poweshiek | 19157 | 1480 | 30 | 0 | 1450 | 41.68625425 | -92.53155731 | 2021-03-06 04:23:41 | Poweshiek, Iowa, US |
2211246 | 2211246 | 2021-03-04 | US | Wyoming | Carbon | 56007 | 1472 | 22 | 0 | 1450 | 41.69357844 | -106.9326084 | 2021-03-05 05:26:29 | Carbon, Wyoming, US |
2209279 | 2209279 | 2021-03-04 | US | Michigan | Gladwin | 26051 | 1493 | 43 | 0 | 1450 | 43.98901072 | -84.38774817 | 2021-03-05 05:26:29 | Gladwin, Michigan, US |
2208880 | 2208880 | 2021-03-04 | US | Iowa | Poweshiek | 19157 | 1480 | 30 | 0 | 1450 | 41.68625425 | -92.53155731 | 2021-03-05 05:26:29 | Poweshiek, Iowa, US |
3257510 | 3257510 | 2021-03-02 | US | Virginia | Martinsville | 51690 | 1509 | 59 | 0 | 1450 | 36.68212094 | -79.86352771 | 2021-03-03 05:23:28 | Martinsville, Virginia, US |
3067749 | 3067749 | 2021-02-27 | US | Minnesota | Renville | 27129 | 1490 | 40 | 0 | 1450 | 44.72836381 | -94.94553734 | 2021-02-28 05:22:20 | Renville, Minnesota, US |
1861191 | 1861191 | 2021-02-25 | US | Texas | Pecos | 48371 | 1191 | 32 | 0 | 1450 | 30.78097267 | -102.7241261 | 2021-02-26 05:22:40 | Pecos, Texas, US |
532911 | 532911 | 2021-02-22 | US | New Mexico | Taos | 35055 | 1499 | 49 | 0 | 1450 | 36.58006022 | -105.6310198 | 2021-02-23 05:23:41 | Taos, New Mexico, US |
183662 | 183662 | 2021-02-21 | US | Michigan | Emmet | 26047 | 1488 | 38 | 0 | 1450 | 45.52625509 | -84.89083249 | 2021-02-22 05:24:21 | Emmet, Michigan, US |
743936 | 743936 | 2021-02-20 | US | Michigan | Emmet | 26047 | 1488 | 38 | 0 | 1450 | 45.52625509 | -84.89083249 | 2021-02-21 05:24:33 | Emmet, Michigan, US |
473034 | 473034 | 2021-02-19 | US | Michigan | Emmet | 26047 | 1488 | 38 | 0 | 1450 | 45.52625509 | -84.89083249 | 2021-02-20 05:22:51 | Emmet, Michigan, US |
3602444 | 3602444 | 2021-02-17 | US | Kentucky | Harrison | 21097 | 1459 | 9 | 0 | 1450 | 38.44188174 | -84.32869741 | 2021-02-18 05:22:58 | Harrison, Kentucky, US |
3602061 | 3602061 | 2021-02-17 | US | Illinois | Moultrie | 17139 | 1472 | 22 | 0 | 1450 | 39.64187451 | -88.62099969 | 2021-02-18 05:22:58 | Moultrie, Illinois, US |
3052176 | 3052176 | 2021-02-16 | US | Montana | Lincoln | 30053 | 1462 | 12 | 0 | 1450 | 48.54265777 | -115.4046155 | 2021-02-17 05:23:10 | Lincoln, Montana, US |
3051196 | 3051196 | 2021-02-16 | US | Illinois | Moultrie | 17139 | 1472 | 22 | 0 | 1450 | 39.64187451 | -88.62099969 | 2021-02-17 05:23:10 | Moultrie, Illinois, US |
1341907 | 1341907 | 2021-02-15 | Ukraine | Rivne Oblast | 47268 | 596 | 45222 | 1450 | 50.6199 | 26.2516 | 2021-02-16 05:24:38 | Rivne Oblast, Ukraine | ||
1340156 | 1340156 | 2021-02-15 | US | Missouri | Clinton | 29049 | 1511 | 61 | 0 | 1450 | 39.6013098 | -94.40465394 | 2021-02-16 05:24:38 | Clinton, Missouri, US |
3539721 | 3539721 | 2021-02-12 | Russia | Yaroslavl Oblast | 30274 | 348 | 28476 | 1450 | 57.77819760000001 | 39.0021095 | 2021-02-13 05:22:12 | Yaroslavl Oblast, Russia | ||
3979554 | 3979554 | 2021-02-10 | US | Illinois | Ford | 17053 | 1493 | 43 | 0 | 1450 | 40.59706922 | -88.22350769 | 2021-02-11 05:23:55 | Ford, Illinois, US |
3978541 | 3978541 | 2021-02-10 | India | Rajasthan | 318491 | 2777 | 314264 | 1450 | 26.583423 | 73.847973 | 2021-02-11 05:23:55 | Rajasthan, India | ||
976623 | 976623 | 2021-02-06 | US | Minnesota | Dodge | 27039 | 1454 | 4 | 0 | 1450 | 44.02238415 | -92.86244324 | 2021-02-07 05:23:00 | Dodge, Minnesota, US |
1591289 | 1591289 | 2021-02-05 | US | Texas | Houston | 48225 | 1516 | 35 | 0 | 1450 | 31.31925973 | -95.42226208 | 2021-02-06 05:23:55 | Houston, Texas, US |
343256 | 343256 | 2021-02-03 | US | Tennessee | Sequatchie | 47153 | 1424 | 22 | 0 | 1450 | 35.36979721 | -85.41022136 | 2021-02-04 05:22:26 | Sequatchie, Tennessee, US |
342642 | 342642 | 2021-02-03 | US | North Carolina | Warren | 37185 | 1464 | 14 | 0 | 1450 | 36.39728256 | -78.10652228 | 2021-02-04 05:22:26 | Warren, North Carolina, US |
2485327 | 2485327 | 2021-01-28 | US | Virginia | Louisa | 51109 | 1462 | 12 | 0 | 1450 | 37.97850256 | -77.96274807 | 2021-01-29 05:22:23 | Louisa, Virginia, US |
3156597 | 3156597 | 2021-01-27 | US | Tennessee | Union | 47173 | 1532 | 25 | 0 | 1450 | 36.28590426 | -83.83651902 | 2021-01-28 05:22:24 | Union, Tennessee, US |
1762781 | 1762781 | 2021-01-24 | US | West Virginia | Mason | 54053 | 1478 | 28 | 0 | 1450 | 38.77071799 | -82.02524219 | 2021-01-25 05:22:16 | Mason, West Virginia, US |
2430418 | 2430418 | 2021-01-23 | US | West Virginia | Wyoming | 54109 | 1477 | 27 | 0 | 1450 | 37.612327 | -81.54511071 | 2021-01-24 05:22:35 | Wyoming, West Virginia, US |
2427594 | 2427594 | 2021-01-23 | US | Florida | Hamilton | 12047 | 1465 | 15 | 0 | 1450 | 30.49673973 | -82.94998918 | 2021-01-24 05:22:35 | Hamilton, Florida, US |
436403 | 436403 | 2021-01-21 | US | Illinois | Washington | 17189 | 1469 | 19 | 0 | 1450 | 38.35309213 | -89.40982703 | 2021-01-22 05:22:10 | Washington, Illinois, US |
1097121 | 1097121 | 2021-01-20 | US | Texas | Cass | 48067 | 1486 | 60 | 0 | 1450 | 33.07499881 | -94.34646905 | 2021-01-21 05:22:01 | Cass, Texas, US |
909139 | 909139 | 2021-01-19 | US | Illinois | Clark | 17023 | 1477 | 27 | 0 | 1450 | 39.33425789 | -87.78705622 | 2021-01-20 05:21:54 | Clark, Illinois, US |
907976 | 907976 | 2021-01-19 | Chile | Valparaiso | 40265 | 1323 | 37492 | 1450 | -33.0472 | -71.6127 | 2021-01-20 05:21:54 | Valparaiso, Chile | ||
239541 | 239541 | 2021-01-18 | US | North Carolina | Dare | 37055 | 1456 | 6 | 0 | 1450 | 35.66520691 | -75.71767334 | 2021-01-19 05:22:15 | Dare, North Carolina, US |
3505658 | 3505658 | 2021-01-17 | US | North Carolina | Dare | 37055 | 1456 | 6 | 0 | 1450 | 35.66520691 | -75.71767334 | 2021-01-18 05:22:34 | Dare, North Carolina, US |
3880744 | 3880744 | 2021-01-14 | US | Iowa | Clayton | 19043 | 1498 | 48 | 0 | 1450 | 42.84443388 | -91.34133693 | 2021-01-15 05:22:24 | Clayton, Iowa, US |
2625655 | 2625655 | 2021-01-10 | Chile | Araucania | 25493 | 336 | 23707 | 1450 | -38.9489 | -72.3311 | 2021-01-11 05:21:50 | Araucania, Chile | ||
3902767 | 3902767 | 2021-01-09 | US | South Carolina | Fairfield | 45039 | 1503 | 53 | 0 | 1450 | 34.39287073 | -81.1195624 | 2021-01-10 05:22:12 | Fairfield, South Carolina, US |
2542138 | 2542138 | 2021-01-07 | US | Florida | Union | 12125 | 1515 | 65 | 0 | 1450 | 30.04412971 | -82.37497443 | 2021-01-08 05:22:42 | Union, Florida, US |
2227532 | 2227532 | 2021-01-02 | Japan | Hyogo | 10232 | 221 | 8561 | 1450 | 35.039913 | 134.828057 | 2021-01-03 05:22:52 | Hyogo, Japan | ||
1139418 | 1139418 | 2021-01-01 | US | Oklahoma | Craig | 40035 | 1457 | 7 | 0 | 1450 | 36.76268118 | -95.20916602 | 2021-01-02 05:22:33 | Craig, Oklahoma, US |
1139292 | 1139292 | 2021-01-01 | US | North Dakota | Ramsey | 38071 | 1464 | 21 | 0 | 1450 | 48.26886249 | -98.72223879 | 2021-01-02 05:22:33 | Ramsey, North Dakota, US |
3698024 | 3698024 | 2020-12-31 | US | Oklahoma | Craig | 40035 | 1457 | 7 | 0 | 1450 | 36.76268118 | -95.20916602 | 2021-01-01 05:23:07 | Craig, Oklahoma, US |
769714 | 769714 | 2020-12-29 | US | Virginia | Russell | 51167 | 1466 | 16 | 0 | 1450 | 36.93028320000001 | -82.10095486 | 2020-12-30 05:22:34 | Russell, Virginia, US |
2225272 | 2225272 | 2020-12-26 | US | Minnesota | Wabasha | 27157 | 1452 | 2 | 0 | 1450 | 44.28424356 | -92.23121312 | 2020-12-27 05:22:55 | Wabasha, Minnesota, US |
2224600 | 2224600 | 2020-12-26 | US | Indiana | Jay | 18075 | 1473 | 23 | 0 | 1450 | 40.43781032 | -85.00576229 | 2020-12-27 05:22:55 | Jay, Indiana, US |
202721 | 202721 | 2020-12-25 | US | Arkansas | Columbia | 5027 | 1489 | 39 | 0 | 1450 | 33.21230701 | -93.22642793 | 2020-12-26 05:22:28 | Columbia, Arkansas, US |
3692607 | 3692607 | 2020-12-24 | US | Indiana | Starke | 18149 | 1494 | 44 | 0 | 1450 | 41.27890281 | -86.64686895 | 2020-12-25 05:22:48 | Starke, Indiana, US |
2408611 | 2408611 | 2020-12-23 | US | Mississippi | Chickasaw | 28017 | 1485 | 35 | 0 | 1450 | 33.91983202 | -88.9481545 | 2020-12-24 05:23:04 | Chickasaw, Mississippi, US |
2407537 | 2407537 | 2020-12-23 | US | Florida | Madison | 12079 | 1483 | 33 | 0 | 1450 | 30.44396917 | -83.47398594 | 2020-12-24 05:23:04 | Madison, Florida, US |
929490 | 929490 | 2020-12-21 | US | Mississippi | Holmes | 28051 | 1513 | 63 | 0 | 1450 | 33.12345854 | -90.08923538 | 2020-12-22 05:22:33 | Holmes, Mississippi, US |
2934729 | 2934729 | 2020-12-19 | US | West Virginia | Wayne | 54099 | 1468 | 18 | 0 | 1450 | 38.14901357 | -82.42287994 | 2020-12-20 05:27:32 | Wayne, West Virginia, US |
1904603 | 1904603 | 2020-12-18 | US | Washington | Kittitas | 53037 | 1473 | 23 | 0 | 1450 | 47.12521214 | -120.679439 | 2020-12-19 05:27:52 | Kittitas, Washington, US |
1035886 | 1035886 | 2020-12-15 | US | Louisiana | Plaquemines | 22075 | 1470 | 20 | 0 | 1450 | 29.42245447 | -89.60322085 | 2020-12-16 05:28:04 | Plaquemines, Louisiana, US |
3848584 | 3848584 | 2020-12-13 | US | Georgia | Gilmer | 13123 | 1483 | 33 | 0 | 1450 | 34.69316688 | -84.45802506 | 2020-12-14 05:26:27 | Gilmer, Georgia, US |
847562 | 847562 | 2020-12-12 | US | Montana | Hill | 30041 | 1479 | 29 | 0 | 1450 | 48.62879827 | -110.1129252 | 2020-12-13 05:27:20 | Hill, Montana, US |
1600801 | 1600801 | 2020-12-10 | US | California | Tuolumne | 6109 | 1462 | 8 | 0 | 1450 | 38.02644018 | -119.9525093 | 2020-12-11 05:26:59 | Tuolumne, California, US |
2348940 | 2348940 | 2020-12-07 | US | Louisiana | Richland | 22083 | 1482 | 32 | 0 | 1450 | 32.41391005 | -91.76634876 | 2020-12-08 05:27:42 | Richland, Louisiana, US |
3861624 | 3861624 | 2020-12-04 | US | Mississippi | Grenada | 28043 | 1495 | 45 | 0 | 1450 | 33.77036166 | -89.80245083 | 2020-12-05 05:27:36 | Grenada, Mississippi, US |
3861272 | 3861272 | 2020-12-04 | US | Kentucky | Muhlenberg | 21177 | 1470 | 20 | 0 | 1450 | 37.21425819 | -87.14632053 | 2020-12-05 05:27:36 | Muhlenberg, Kentucky, US |
3860901 | 3860901 | 2020-12-04 | US | Indiana | Decatur | 18031 | 1496 | 46 | 0 | 1450 | 39.30712658 | -85.50087166 | 2020-12-05 05:27:36 | Decatur, Indiana, US |
741986 | 741986 | 2020-12-02 | Malaysia | W.P. Kuala Lumpur | 6314 | 19 | 4845 | 1450 | 3.139 | 101.6869 | 2020-12-03 05:28:22 | W.P. Kuala Lumpur, Malaysia | ||
1587435 | 1587435 | 2020-11-30 | US | Vermont | Chittenden | 50007 | 1489 | 39 | 0 | 1450 | 44.46322849 | -73.08359212 | 2020-12-01 05:26:18 | Chittenden, Vermont, US |
1585858 | 1585858 | 2020-11-30 | US | Minnesota | Cass | 27021 | 1460 | 10 | 0 | 1450 | 46.95043611 | -94.32603968 | 2020-12-01 05:26:18 | Cass, Minnesota, US |
3568402 | 3568402 | 2020-11-29 | US | Mississippi | Simpson | 28127 | 1503 | 53 | 0 | 1450 | 31.91282117 | -89.91716179 | 2020-11-30 05:26:13 | Simpson, Mississippi, US |
3566564 | 3566564 | 2020-11-29 | Italy | Valle d'Aosta | 6463 | 311 | 4702 | 1450 | 45.73750286 | 7.320149366 | 2020-11-30 05:26:13 | Valle d'Aosta, Italy | ||
393319 | 393319 | 2020-11-27 | US | Indiana | Harrison | 18061 | 1476 | 26 | 0 | 1450 | 38.19467379 | -86.10948271 | 2020-11-28 05:25:50 | Harrison, Indiana, US |
1976085 | 1976085 | 2020-11-25 | US | West Virginia | Raleigh | 54081 | 1465 | 15 | 0 | 1450 | 37.76936795 | -81.2456041 | 2020-11-26 05:27:44 | Raleigh, West Virginia, US |
681265 | 681265 | 2020-11-23 | US | Tennessee | Lincoln | 47103 | 1454 | 13 | 0 | 1450 | 35.13738622 | -86.58910106 | 2020-11-24 05:27:31 | Lincoln, Tennessee, US |
3836621 | 3836621 | 2020-11-21 | Pakistan | Azad Jammu and Kashmir | 6000 | 140 | 4410 | 1450 | 34.027401 | 73.947253 | 2020-11-22 05:25:45 | Azad Jammu and Kashmir, Pakistan | ||
124161 | 124161 | 2020-11-18 | US | Kentucky | Scott | 21209 | 1470 | 20 | 0 | 1450 | 38.29622293 | -84.5816631 | 2020-11-19 05:25:23 | Scott, Kentucky, US |
3340760 | 3340760 | 2020-11-17 | US | New Jersey | Salem | 34033 | 1541 | 91 | 0 | 1450 | 39.58719656 | -75.34696629999998 | 2020-11-18 05:40:31 | Salem, New Jersey, US |
2882094 | 2882094 | 2020-11-15 | US | Missouri | Dunklin | 29069 | 1463 | 13 | 0 | 1450 | 36.27167174 | -90.09122243 | 2020-11-16 05:25:57 | Dunklin, Missouri, US |
2881104 | 2881104 | 2020-11-15 | US | Hawaii | Hawaii | 15001 | 1481 | 31 | 0 | 1450 | 19.60121157 | -155.5210167 | 2020-11-16 05:25:57 | Hawaii, Hawaii, US |
2917683 | 2917683 | 2020-11-14 | US | Ohio | Scioto | 39145 | 1468 | 18 | 0 | 1450 | 38.80270163 | -82.98907345 | 2020-11-15 05:26:53 | Scioto, Ohio, US |
2917072 | 2917072 | 2020-11-14 | US | Missouri | Dunklin | 29069 | 1463 | 13 | 0 | 1450 | 36.27167174 | -90.09122243 | 2020-11-15 05:26:53 | Dunklin, Missouri, US |
2916082 | 2916082 | 2020-11-14 | US | Hawaii | Hawaii | 15001 | 1481 | 31 | 0 | 1450 | 19.60121157 | -155.5210167 | 2020-11-15 05:26:53 | Hawaii, Hawaii, US |
2787476 | 2787476 | 2020-11-13 | US | Ohio | Lawrence | 39087 | 1478 | 28 | 0 | 1450 | 38.59743452 | -82.53466552 | 2020-11-14 05:25:37 | Lawrence, Ohio, US |
866977 | 866977 | 2020-11-12 | US | New Mexico | Valencia | 35061 | 1461 | 11 | 0 | 1450 | 34.71669834 | -106.8103733 | 2020-11-13 05:25:30 | Valencia, New Mexico, US |
866678 | 866678 | 2020-11-12 | US | Missouri | Laclede | 29105 | 1478 | 28 | 0 | 1450 | 37.65896829 | -92.5888493 | 2020-11-13 05:25:30 | Laclede, Missouri, US |
3441593 | 3441593 | 2020-11-11 | US | Georgia | Decatur | 13087 | 1492 | 42 | 0 | 1450 | 30.87967778 | -84.57619536 | 2020-11-12 05:25:55 | Decatur, Georgia, US |
1731826 | 1731826 | 2020-11-08 | US | Virginia | Henry | 51089 | 1483 | 33 | 0 | 1450 | 36.68542395 | -79.87634026 | 2020-11-09 05:25:45 | Henry, Virginia, US |
2921744 | 2921744 | 2020-11-04 | US | Oklahoma | McClain | 40087 | 1466 | 16 | 0 | 1450 | 35.01123903 | -97.44572302 | 2020-11-05 06:05:03 | McClain, Oklahoma, US |
3305769 | 3305769 | 2020-11-02 | US | Maryland | St. Mary's | 24037 | 1510 | 60 | 0 | 1450 | 38.30058422 | -76.60629279999998 | 2020-11-03 06:00:16 | St. Mary's, Maryland, US |
3410102 | 3410102 | 2020-11-01 | US | Connecticut | Windham | 9015 | 1469 | 19 | 0 | 1450 | 41.82972709 | -71.98182316 | 2020-11-02 05:25:04 | Windham, Connecticut, US |
2080591 | 2080591 | 2020-10-31 | US | Connecticut | Windham | 9015 | 1469 | 19 | 0 | 1450 | 41.82972709 | -71.98182316 | 2020-11-01 04:36:19 | Windham, Connecticut, US |
2080352 | 2080352 | 2020-10-31 | US | Alaska | Matanuska-Susitna | 2170 | 1453 | 3 | 0 | 1450 | 62.31305045 | -149.5741743 | 2020-11-01 04:36:19 | Matanuska-Susitna, Alaska, US |
2079860 | 2079860 | 2020-10-31 | Guinea | 12072 | 72 | 10550 | 1450 | 9.9456 | -9.6966 | 2020-11-01 04:36:19 | Guinea | |||
2245510 | 2245510 | 2020-10-30 | US | Nevada | Elko | 32007 | 1464 | 14 | 0 | 1450 | 41.14531606 | -115.3577619 | 2020-10-31 04:24:44 | Elko, Nevada, US |
2244044 | 2244044 | 2020-10-30 | US | Connecticut | Windham | 9015 | 1469 | 19 | 0 | 1450 | 41.82972709 | -71.98182316 | 2020-10-31 04:24:44 | Windham, Connecticut, US |
2243313 | 2243313 | 2020-10-30 | Guinea | 12072 | 72 | 10550 | 1450 | 9.9456 | -9.6966 | 2020-10-31 04:24:44 | Guinea | |||
211773 | 211773 | 2020-10-29 | US | Louisiana | Webster | 22119 | 1491 | 41 | 0 | 1450 | 32.70847669 | -93.33121835 | 2020-10-30 04:24:49 | Webster, Louisiana, US |
211112 | 211112 | 2020-10-29 | US | Georgia | Toombs | 13279 | 1506 | 56 | 0 | 1450 | 32.12059861 | -82.32957247 | 2020-10-30 04:24:49 | Toombs, Georgia, US |
754509 | 754509 | 2020-10-28 | Russia | Khakassia Republic | 6538 | 57 | 5031 | 1450 | 53.72258845 | 91.44293627 | 2020-10-29 04:24:49 | Khakassia Republic, Russia |
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]);