johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
185 rows where active = 1442 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1330390 | 1330390 | 2021-07-24 | Pakistan | Balochistan | 29494 | 322 | 27730 | 1442 | 28.328492 | 65.898403 | 2021-07-25 04:22:12 | Balochistan, Pakistan | ||
295809 | 295809 | 2021-07-15 | Chile | Valparaiso | 118507 | 3104 | 113961 | 1442 | -33.0472 | -71.6127 | 2021-07-16 04:21:22 | Valparaiso, Chile | ||
1309946 | 1309946 | 2021-05-26 | Canada | Saskatchewan | 46001 | 528 | 44031 | 1442 | 52.9399 | -106.4509 | 2021-05-27 04:20:59 | Saskatchewan, Canada | ||
36669 | 36669 | 2021-04-12 | Russia | Ryazan Oblast | 26925 | 402 | 25081 | 1442 | 54.42267320000001 | 40.57052460000001 | 2021-04-13 04:20:37 | Ryazan Oblast, Russia | ||
391896 | 391896 | 2021-04-04 | Malaysia | Johor | 41704 | 106 | 40156 | 1442 | 1.4854 | 103.7618 | 2021-04-05 04:20:35 | Johor, Malaysia | ||
1293623 | 1293623 | 2021-03-29 | Ukraine | Crimea Republic* | 37489 | 1059 | 34988 | 1442 | 45.2835 | 34.2008 | 2021-03-30 04:26:23 | Crimea Republic*, Ukraine | ||
3669054 | 3669054 | 2021-03-06 | US | Kentucky | Mason | 21161 | 1470 | 28 | 0 | 1442 | 38.59471935 | -83.82151043 | 2021-03-07 05:21:54 | Mason, Kentucky, US |
3255772 | 3255772 | 2021-03-02 | US | Michigan | Gladwin | 26051 | 1485 | 43 | 0 | 1442 | 43.98901072 | -84.38774817 | 2021-03-03 05:23:28 | Gladwin, Michigan, US |
1001625 | 1001625 | 2021-03-01 | US | Texas | Pecos | 48371 | 1185 | 34 | 0 | 1442 | 30.78097267 | -102.7241261 | 2021-03-02 05:23:30 | Pecos, Texas, US |
1000041 | 1000041 | 2021-03-01 | US | Michigan | Alpena | 26007 | 1490 | 48 | 0 | 1442 | 45.03477666 | -83.62212411 | 2021-03-02 05:23:30 | Alpena, Michigan, US |
2370683 | 2370683 | 2021-02-28 | US | Texas | Pecos | 48371 | 1185 | 34 | 0 | 1442 | 30.78097267 | -102.7241261 | 2021-03-01 05:23:01 | Pecos, Texas, US |
2369099 | 2369099 | 2021-02-28 | US | Michigan | Alpena | 26007 | 1490 | 48 | 0 | 1442 | 45.03477666 | -83.62212411 | 2021-03-01 05:23:01 | Alpena, Michigan, US |
3067601 | 3067601 | 2021-02-27 | US | Michigan | Alpena | 26007 | 1490 | 48 | 0 | 1442 | 45.03477666 | -83.62212411 | 2021-02-28 05:22:20 | Alpena, Michigan, US |
2186760 | 2186760 | 2021-02-26 | US | Texas | Nolan | 48353 | 1377 | 50 | 0 | 1442 | 32.30365282 | -100.4060208 | 2021-02-27 05:22:28 | Nolan, Texas, US |
1861182 | 1861182 | 2021-02-25 | US | Texas | Nolan | 48353 | 1377 | 50 | 0 | 1442 | 32.30365282 | -100.4060208 | 2021-02-26 05:22:40 | Nolan, Texas, US |
283360 | 283360 | 2021-02-24 | US | Texas | Nolan | 48353 | 1377 | 50 | 0 | 1442 | 32.30365282 | -100.4060208 | 2021-02-25 05:24:57 | Nolan, Texas, US |
282925 | 282925 | 2021-02-24 | US | Puerto Rico | Juncos | 72077 | 1442 | 0 | 0 | 1442 | 18.223793 | -65.909109 | 2021-02-25 05:24:57 | Juncos, Puerto Rico, US |
1939193 | 1939193 | 2021-02-23 | US | Puerto Rico | Juncos | 72077 | 1442 | 0 | 0 | 1442 | 18.223793 | -65.909109 | 2021-02-24 05:29:16 | Juncos, Puerto Rico, US |
1156238 | 1156238 | 2021-02-18 | US | Texas | Hutchinson | 48233 | 2538 | 67 | 0 | 1442 | 35.84006574 | -101.3546643 | 2021-02-19 05:24:16 | Hutchinson, Texas, US |
1155067 | 1155067 | 2021-02-18 | US | Missouri | Ray | 29177 | 1465 | 23 | 0 | 1442 | 39.3537468 | -93.98905745 | 2021-02-19 05:24:16 | Ray, Missouri, US |
3604158 | 3604158 | 2021-02-17 | US | Texas | Hutchinson | 48233 | 2538 | 67 | 0 | 1442 | 35.84006574 | -101.3546643 | 2021-02-18 05:22:58 | Hutchinson, Texas, US |
3603246 | 3603246 | 2021-02-17 | US | New Mexico | Taos | 35055 | 1490 | 48 | 0 | 1442 | 36.58006022 | -105.6310198 | 2021-02-18 05:22:58 | Taos, New Mexico, US |
3053293 | 3053293 | 2021-02-16 | US | Texas | Hutchinson | 48233 | 2538 | 67 | 0 | 1442 | 35.84006574 | -101.3546643 | 2021-02-17 05:23:10 | Hutchinson, Texas, US |
3052911 | 3052911 | 2021-02-16 | US | Puerto Rico | Gurabo | 72063 | 1442 | 0 | 0 | 1442 | 18.266461 | -65.97970500000001 | 2021-02-17 05:23:10 | Gurabo, Puerto Rico, US |
3050438 | 3050438 | 2021-02-16 | Russia | Yaroslavl Oblast | 30947 | 359 | 29146 | 1442 | 57.77819760000001 | 39.0021095 | 2021-02-17 05:23:10 | Yaroslavl Oblast, Russia | ||
1341392 | 1341392 | 2021-02-15 | US | Texas | Hutchinson | 48233 | 2538 | 67 | 0 | 1442 | 35.84006574 | -101.3546643 | 2021-02-16 05:24:38 | Hutchinson, Texas, US |
2286543 | 2286543 | 2021-02-14 | US | Texas | Hutchinson | 48233 | 2538 | 67 | 0 | 1442 | 35.84006574 | -101.3546643 | 2021-02-15 05:24:49 | Hutchinson, Texas, US |
2680943 | 2680943 | 2021-02-13 | US | Texas | Hutchinson | 48233 | 2538 | 67 | 0 | 1442 | 35.84006574 | -101.3546643 | 2021-02-14 05:23:43 | Hutchinson, Texas, US |
2640839 | 2640839 | 2021-02-11 | US | Texas | Hutchinson | 48233 | 2536 | 65 | 0 | 1442 | 35.84006574 | -101.3546643 | 2021-02-12 05:23:29 | Hutchinson, Texas, US |
1529778 | 1529778 | 2021-02-09 | US | Missouri | Clinton | 29049 | 1502 | 60 | 0 | 1442 | 39.6013098 | -94.40465394 | 2021-02-10 05:22:41 | Clinton, Missouri, US |
1528917 | 1528917 | 2021-02-09 | US | Illinois | Moultrie | 17139 | 1463 | 21 | 0 | 1442 | 39.64187451 | -88.62099969 | 2021-02-10 05:22:41 | Moultrie, Illinois, US |
793837 | 793837 | 2021-02-04 | US | Washington | Unassigned | 90053 | 1446 | 4 | 0 | 1442 | 48.82227976 | 0.0 | 2021-02-05 05:22:38 | Unassigned, Washington, US |
2211678 | 2211678 | 2021-01-30 | Japan | Hokkaido | 17341 | 597 | 15302 | 1442 | 43.385711 | 142.552318 | 2021-01-31 05:22:42 | Hokkaido, Japan | ||
13086 | 13086 | 2021-01-26 | US | Georgia | Berrien | 13019 | 1477 | 35 | 0 | 1442 | 31.27590016 | -83.22529920000002 | 2021-01-27 05:23:41 | Berrien, Georgia, US |
2427151 | 2427151 | 2021-01-23 | Russia | Tambov Oblast | 21305 | 247 | 19616 | 1442 | 52.9019574 | 41.3578918 | 2021-01-24 05:22:35 | Tambov Oblast, Russia | ||
3311396 | 3311396 | 2021-01-13 | US | Texas | Reeves | 48389 | 1162 | 33 | 0 | 1442 | 31.32323325 | -103.6903896 | 2021-01-14 05:22:32 | Reeves, Texas, US |
2628391 | 2628391 | 2021-01-10 | US | Oklahoma | Atoka | 40005 | 1445 | 3 | 0 | 1442 | 34.37366573 | -96.03802487 | 2021-01-11 05:21:50 | Atoka, Oklahoma, US |
2626572 | 2626572 | 2021-01-10 | US | Florida | Lafayette | 12067 | 1463 | 21 | 0 | 1442 | 29.98484137 | -83.18166636 | 2021-01-11 05:21:50 | Lafayette, Florida, US |
2625728 | 2625728 | 2021-01-10 | Colombia | Quindio | 25810 | 715 | 23653 | 1442 | 4.461 | -75.6674 | 2021-01-11 05:21:50 | Quindio, Colombia | ||
3902572 | 3902572 | 2021-01-09 | US | Oregon | Josephine | 41033 | 1470 | 28 | 0 | 1442 | 42.3665549 | -123.5561938 | 2021-01-10 05:22:12 | Josephine, Oregon, US |
155172 | 155172 | 2021-01-08 | US | Iowa | Harrison | 19085 | 1501 | 59 | 0 | 1442 | 41.68330137 | -95.81558439 | 2021-01-09 05:22:18 | Harrison, Iowa, US |
3036199 | 3036199 | 2021-01-05 | US | Missouri | Henry | 29083 | 1466 | 24 | 0 | 1442 | 38.38482826 | -93.79293734 | 2021-01-06 05:22:16 | Henry, Missouri, US |
3233004 | 3233004 | 2021-01-03 | US | Oklahoma | Kingfisher | 40073 | 1454 | 12 | 0 | 1442 | 35.94530008 | -97.94193268 | 2021-01-04 05:22:02 | Kingfisher, Oklahoma, US |
3230662 | 3230662 | 2021-01-03 | Russia | Komi Republic | 31109 | 582 | 29085 | 1442 | 63.9881421 | 54.3326073 | 2021-01-04 05:22:02 | Komi Republic, Russia | ||
2230713 | 2230713 | 2021-01-02 | US | Texas | Reeves | 48389 | 1158 | 29 | 0 | 1442 | 31.32323325 | -103.6903896 | 2021-01-03 05:22:52 | Reeves, Texas, US |
2230509 | 2230509 | 2021-01-02 | US | Tennessee | Unicoi | 47171 | 1476 | 40 | 0 | 1442 | 36.10890856 | -82.43709629 | 2021-01-03 05:22:52 | Unicoi, Tennessee, US |
2230313 | 2230313 | 2021-01-02 | US | South Carolina | Barnwell | 45011 | 1472 | 30 | 0 | 1442 | 33.26679302 | -81.43584352 | 2021-01-03 05:22:52 | Barnwell, South Carolina, US |
1138686 | 1138686 | 2021-01-01 | US | Mississippi | Jasper | 28061 | 1467 | 25 | 0 | 1442 | 32.01922104 | -89.11786866 | 2021-01-02 05:22:33 | Jasper, Mississippi, US |
1137377 | 1137377 | 2021-01-01 | US | Arkansas | Logan | 5083 | 1453 | 11 | 0 | 1442 | 35.21413234 | -93.71951016 | 2021-01-02 05:22:33 | Logan, Arkansas, US |
3764930 | 3764930 | 2020-12-28 | US | Virginia | Isle of Wight | 51093 | 1471 | 29 | 0 | 1442 | 36.90579348 | -76.70842863 | 2020-12-29 05:22:37 | Isle of Wight, Virginia, US |
2223515 | 2223515 | 2020-12-26 | Japan | Fukuoka | 8154 | 117 | 6595 | 1442 | 33.526032 | 130.666949 | 2020-12-27 05:22:55 | Fukuoka, Japan | ||
204567 | 204567 | 2020-12-25 | US | North Carolina | Greene | 37079 | 1469 | 27 | 0 | 1442 | 35.48544173 | -77.67578087 | 2020-12-26 05:22:28 | Greene, North Carolina, US |
204098 | 204098 | 2020-12-25 | US | Mississippi | Tishomingo | 28141 | 1493 | 51 | 0 | 1442 | 34.74023475 | -88.23917219 | 2020-12-26 05:22:28 | Tishomingo, Mississippi, US |
203457 | 203457 | 2020-12-25 | US | Iowa | Kossuth | 19109 | 1470 | 28 | 0 | 1442 | 43.20405458 | -94.20691791 | 2020-12-26 05:22:28 | Kossuth, Iowa, US |
3693790 | 3693790 | 2020-12-24 | US | North Carolina | Greene | 37079 | 1469 | 27 | 0 | 1442 | 35.48544173 | -77.67578087 | 2020-12-25 05:22:48 | Greene, North Carolina, US |
3691944 | 3691944 | 2020-12-24 | US | Arkansas | Columbia | 5027 | 1481 | 39 | 0 | 1442 | 33.21230701 | -93.22642793 | 2020-12-25 05:22:48 | Columbia, Arkansas, US |
2409142 | 2409142 | 2020-12-23 | US | North Carolina | Greene | 37079 | 1469 | 27 | 0 | 1442 | 35.48544173 | -77.67578087 | 2020-12-24 05:23:04 | Greene, North Carolina, US |
3772683 | 3772683 | 2020-12-22 | US | South Carolina | Edgefield | 45037 | 1468 | 26 | 0 | 1442 | 33.77221995 | -81.96231108 | 2020-12-23 05:22:03 | Edgefield, South Carolina, US |
928480 | 928480 | 2020-12-21 | US | Georgia | Elbert | 13105 | 1476 | 34 | 0 | 1442 | 34.11302332 | -82.83936148 | 2020-12-22 05:22:33 | Elbert, Georgia, US |
2120680 | 2120680 | 2020-12-20 | US | Illinois | Crawford | 17033 | 1461 | 19 | 0 | 1442 | 39.0032229 | -87.75954624 | 2020-12-21 05:27:58 | Crawford, Illinois, US |
2934635 | 2934635 | 2020-12-19 | US | Virginia | Winchester | 51840 | 1448 | 6 | 0 | 1442 | 39.17054517 | -78.17325058 | 2020-12-20 05:27:32 | Winchester, Virginia, US |
2931853 | 2931853 | 2020-12-19 | US | Colorado | Otero | 8089 | 1590 | 50 | 0 | 1442 | 37.9014485 | -103.7173385 | 2020-12-20 05:27:32 | Otero, Colorado, US |
1902964 | 1902964 | 2020-12-18 | US | Mississippi | Holmes | 28051 | 1505 | 63 | 0 | 1442 | 33.12345854 | -90.08923538 | 2020-12-19 05:27:52 | Holmes, Mississippi, US |
2129721 | 2129721 | 2020-12-17 | US | Minnesota | Martin | 27091 | 1465 | 23 | 0 | 1442 | 43.67429718 | -94.55099908 | 2020-12-18 05:28:18 | Martin, Minnesota, US |
2128858 | 2128858 | 2020-12-17 | US | Georgia | Sumter | 13261 | 1515 | 73 | 0 | 1442 | 32.03650571 | -84.19821492 | 2020-12-18 05:28:18 | Sumter, Georgia, US |
3151559 | 3151559 | 2020-12-16 | US | Missouri | Warren | 29219 | 1448 | 6 | 0 | 1442 | 38.76529479 | -91.16124662 | 2020-12-17 05:28:12 | Warren, Missouri, US |
1751868 | 1751868 | 2020-12-14 | US | Colorado | Crowley | 8025 | 1535 | 13 | 0 | 1442 | 38.32608609 | -103.7844965 | 2020-12-15 05:26:38 | Crowley, Colorado, US |
847926 | 847926 | 2020-12-12 | US | North Carolina | Stokes | 37169 | 1464 | 22 | 0 | 1442 | 36.4017975 | -80.23893369 | 2020-12-13 05:27:20 | Stokes, North Carolina, US |
846651 | 846651 | 2020-12-12 | US | Indiana | Greene | 18055 | 1497 | 55 | 0 | 1442 | 39.03630547 | -86.96223202 | 2020-12-13 05:27:20 | Greene, Indiana, US |
845751 | 845751 | 2020-12-12 | Russia | Altai Krai | 28803 | 676 | 26685 | 1442 | 52.6932243 | 82.69314240000001 | 2020-12-13 05:27:20 | Altai Krai, Russia | ||
845277 | 845277 | 2020-12-12 | Bahamas | 7648 | 163 | 6043 | 1442 | 25.025885 | -78.035889 | 2020-12-13 05:27:20 | Bahamas | |||
864108 | 864108 | 2020-12-11 | US | Washington | Grays Harbor | 53027 | 1462 | 20 | 0 | 1442 | 47.14003705 | -123.7820567 | 2020-12-12 05:26:19 | Grays Harbor, Washington, US |
863816 | 863816 | 2020-12-11 | US | Texas | Lamb | 48279 | 1773 | 56 | 0 | 1442 | 34.06859623 | -102.3516289 | 2020-12-12 05:26:19 | Lamb, Texas, US |
2978669 | 2978669 | 2020-12-09 | US | Washington | Okanogan | 53047 | 1467 | 25 | 0 | 1442 | 48.54855019 | -119.7387224 | 2020-12-10 05:26:19 | Okanogan, Washington, US |
2978000 | 2978000 | 2020-12-09 | US | Puerto Rico | Trujillo Alto | 72139 | 1442 | 0 | 0 | 1442 | 18.336159 | -65.99888399999999 | 2020-12-10 05:26:19 | Trujillo Alto, Puerto Rico, US |
2976034 | 2976034 | 2020-12-09 | US | Georgia | Haralson | 13143 | 1471 | 29 | 0 | 1442 | 33.79602175 | -85.21005667 | 2020-12-10 05:26:19 | Haralson, Georgia, US |
1821000 | 1821000 | 2020-12-08 | US | New York | Cattaraugus | 36009 | 1470 | 28 | 0 | 1442 | 42.24778241 | -78.67923096 | 2020-12-09 05:28:01 | Cattaraugus, New York, US |
1818626 | 1818626 | 2020-12-08 | Colombia | Boyaca | 23432 | 515 | 21475 | 1442 | 5.4545 | -73.362 | 2020-12-09 05:28:01 | Boyaca, Colombia | ||
1633836 | 1633836 | 2020-12-05 | US | Louisiana | Vernon | 22115 | 1508 | 66 | 0 | 1442 | 31.10884837 | -93.18153838 | 2020-12-06 05:26:18 | Vernon, Louisiana, US |
1633424 | 1633424 | 2020-12-05 | US | Indiana | Randolph | 18135 | 1472 | 30 | 0 | 1442 | 40.15734772 | -85.01139319 | 2020-12-06 05:26:18 | Randolph, Indiana, US |
3861596 | 3861596 | 2020-12-04 | US | Minnesota | Waseca | 27161 | 1453 | 11 | 0 | 1442 | 44.02211116 | -93.58720034 | 2020-12-05 05:27:36 | Waseca, Minnesota, US |
3861364 | 3861364 | 2020-12-04 | US | Louisiana | Vernon | 22115 | 1508 | 66 | 0 | 1442 | 31.10884837 | -93.18153838 | 2020-12-05 05:27:36 | Vernon, Louisiana, US |
75543 | 75543 | 2020-12-03 | US | Arkansas | Baxter | 5005 | 1472 | 30 | 0 | 1442 | 36.28784385 | -92.33782872 | 2020-12-04 05:27:27 | Baxter, Arkansas, US |
1585855 | 1585855 | 2020-11-30 | US | Minnesota | Brown | 27015 | 1457 | 15 | 0 | 1442 | 44.24205652 | -94.72562874 | 2020-12-01 05:26:18 | Brown, Minnesota, US |
2935371 | 2935371 | 2020-11-28 | Pakistan | Azad Jammu and Kashmir | 6682 | 164 | 5076 | 1442 | 34.027401 | 73.947253 | 2020-11-29 05:25:55 | Azad Jammu and Kashmir, Pakistan | ||
925603 | 925603 | 2020-11-26 | US | Missouri | Miller | 29131 | 1466 | 24 | 0 | 1442 | 38.21450288 | -92.42610898 | 2020-11-27 05:26:53 | Miller, Missouri, US |
1353122 | 1353122 | 2020-11-24 | US | South Carolina | Dillon | 45033 | 1494 | 52 | 0 | 1442 | 34.39007791 | -79.37741872 | 2020-11-25 05:27:20 | Dillon, South Carolina, US |
1352118 | 1352118 | 2020-11-24 | US | Mississippi | Itawamba | 28057 | 1476 | 34 | 0 | 1442 | 34.27993475 | -88.3606733 | 2020-11-25 05:27:20 | Itawamba, Mississippi, US |
1351392 | 1351392 | 2020-11-24 | US | Indiana | Fayette | 18041 | 1477 | 35 | 0 | 1442 | 39.63684962 | -85.17797541 | 2020-11-25 05:27:20 | Fayette, Indiana, US |
680047 | 680047 | 2020-11-23 | US | Minnesota | Nicollet | 27103 | 1465 | 23 | 0 | 1442 | 44.35291112 | -94.24710352 | 2020-11-24 05:27:31 | Nicollet, Minnesota, US |
679990 | 679990 | 2020-11-23 | US | Michigan | Tuscola | 26157 | 1490 | 48 | 0 | 1442 | 43.46606813 | -83.41897025 | 2020-11-24 05:27:31 | Tuscola, Michigan, US |
3192261 | 3192261 | 2020-11-22 | US | North Carolina | Alexander | 37003 | 1455 | 13 | 0 | 1442 | 35.922379600000006 | -81.17751948 | 2020-11-23 05:25:26 | Alexander, North Carolina, US |
3191239 | 3191239 | 2020-11-22 | US | Kansas | Barton | 20009 | 1455 | 13 | 0 | 1442 | 38.47889676 | -98.75636726 | 2020-11-23 05:25:26 | Barton, Kansas, US |
3838629 | 3838629 | 2020-11-21 | US | New Hampshire | Merrimack | 33013 | 1476 | 34 | 0 | 1442 | 43.29662971 | -71.6811573 | 2020-11-22 05:25:45 | Merrimack, New Hampshire, US |
3838511 | 3838511 | 2020-11-21 | US | Nebraska | Adams | 31001 | 1463 | 21 | 0 | 1442 | 40.52449420000001 | -98.50117804 | 2020-11-22 05:25:45 | Adams, Nebraska, US |
3837733 | 3837733 | 2020-11-21 | US | Kansas | Barton | 20009 | 1455 | 13 | 0 | 1442 | 38.47889676 | -98.75636726 | 2020-11-22 05:25:45 | Barton, Kansas, US |
2704410 | 2704410 | 2020-11-20 | US | South Dakota | Yankton | 46135 | 1450 | 8 | 0 | 1442 | 43.00924485 | -97.39467635 | 2020-11-21 05:25:51 | Yankton, South Dakota, US |
2702761 | 2702761 | 2020-11-20 | US | Kansas | Barton | 20009 | 1455 | 13 | 0 | 1442 | 38.47889676 | -98.75636726 | 2020-11-21 05:25:51 | Barton, Kansas, US |
824680 | 824680 | 2020-11-19 | US | Texas | Hopkins | 48223 | 932 | 50 | 0 | 1442 | 33.14875072 | -95.56351139 | 2020-11-20 05:26:28 | Hopkins, Texas, US |
126201 | 126201 | 2020-11-18 | US | West Virginia | Putnam | 54079 | 1470 | 28 | 0 | 1442 | 38.50782345 | -81.9082131 | 2020-11-19 05:25:23 | Putnam, West Virginia, 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]);