johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
414 rows where active = 543 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 340
- Russia 14
- Chile 8
- Colombia 4
- Japan 4
- Malaysia 4
- Mexico 4
- Somalia 4
- Pakistan 3
- Ukraine 3
- Cabo Verde 2
- Gabon 2
- Germany 2
- Australia 1
- Bahamas 1
- Botswana 1
- Comoros 1
- Costa Rica 1
- Cuba 1
- Eswatini 1
- India 1
- Lebanon 1
- Lesotho 1
- Mali 1
- North Macedonia 1
- Peru 1
- Saint Vincent and the Grenadines 1
- Saudi Arabia 1
- Spain 1
- Tajikistan 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36104 | 36104 | 2021-08-25 | Malaysia | W.P. Putrajaya | 5176 | 21 | 4612 | 543 | 2.9264 | 101.6964 | 2021-08-26 04:21:28 | W.P. Putrajaya, Malaysia | ||
1306169 | 1306169 | 2021-07-27 | Japan | Ishikawa | 4692 | 116 | 4033 | 543 | 36.769464 | 136.771027 | 2021-07-28 04:21:39 | Ishikawa, Japan | ||
2371423 | 2371423 | 2021-07-20 | Germany | Hamburg | 77983 | 1605 | 75900 | 543 | 53.5511 | 9.9937 | 2021-07-21 04:21:40 | Hamburg, Germany | ||
2072251 | 2072251 | 2021-07-02 | Tajikistan | 13954 | 93 | 13318 | 543 | 38.861 | 71.2761 | 2021-07-03 04:21:37 | Tajikistan | |||
3381583 | 3381583 | 2021-06-13 | Russia | Kemerovo Oblast | 37783 | 748 | 36492 | 543 | 54.53357809999999 | 87.342861 | 2021-06-14 04:22:46 | Kemerovo Oblast, Russia | ||
1736707 | 1736707 | 2021-06-12 | Russia | Irkutsk Oblast | 71214 | 2535 | 68136 | 543 | 56.6370122 | 104.719221 | 2021-06-13 04:22:44 | Irkutsk Oblast, Russia | ||
3145499 | 3145499 | 2021-06-07 | Germany | Saarland | 41045 | 1012 | 39500 | 543 | 49.3964 | 7.023 | 2021-06-08 04:22:35 | Saarland, Germany | ||
2315310 | 2315310 | 2021-06-04 | Japan | Gifu | 8863 | 167 | 8153 | 543 | 35.778671 | 137.055925 | 2021-06-05 04:23:03 | Gifu, Japan | ||
1448372 | 1448372 | 2021-06-03 | Chile | Aysen | 6200 | 39 | 5618 | 543 | -45.9864 | -73.7669 | 2021-06-04 04:23:37 | Aysen, Chile | ||
82890 | 82890 | 2021-05-25 | Chile | Tarapaca | 36287 | 660 | 35084 | 543 | -19.9232 | -69.5132 | 2021-05-26 04:20:35 | Tarapaca, Chile | ||
2502236 | 2502236 | 2021-05-07 | Russia | Kemerovo Oblast | 35546 | 679 | 34324 | 543 | 54.53357809999999 | 87.342861 | 2021-05-08 04:21:04 | Kemerovo Oblast, Russia | ||
649587 | 649587 | 2021-05-05 | Ukraine | Sevastopol* | 14169 | 635 | 12991 | 543 | 44.6054 | 33.522 | 2021-05-06 04:20:38 | Sevastopol*, Ukraine | ||
646141 | 646141 | 2021-05-05 | Russia | Bryansk Oblast | 38529 | 309 | 37677 | 543 | 52.8873315 | 33.41585300000001 | 2021-05-06 04:20:38 | Bryansk Oblast, Russia | ||
2454450 | 2454450 | 2021-05-02 | Malaysia | Pahang | 5273 | 19 | 4711 | 543 | 3.8126 | 103.3256 | 2021-05-03 04:20:39 | Pahang, Malaysia | ||
958500 | 958500 | 2021-04-25 | Ukraine | Sevastopol* | 13956 | 608 | 12805 | 543 | 44.6054 | 33.522 | 2021-04-26 04:21:04 | Sevastopol*, Ukraine | ||
1571741 | 1571741 | 2021-04-22 | Ukraine | Sevastopol* | 13885 | 600 | 12742 | 543 | 44.6054 | 33.522 | 2021-04-23 04:20:52 | Sevastopol*, Ukraine | ||
2411054 | 2411054 | 2021-04-19 | Russia | Khanty-Mansi Autonomous Okrug | 55370 | 788 | 54039 | 543 | 61.0259025 | 69.0982628 | 2021-04-20 04:20:41 | Khanty-Mansi Autonomous Okrug, Russia | ||
983194 | 983194 | 2021-04-17 | Russia | Smolensk Oblast | 28782 | 819 | 27420 | 543 | 55.03434960000001 | 33.0192065 | 2021-04-18 04:20:41 | Smolensk Oblast, Russia | ||
2251070 | 2251070 | 2021-04-07 | Malaysia | Kelantan | 6620 | 26 | 6051 | 543 | 6.1254 | 102.2381 | 2021-04-08 04:21:13 | Kelantan, Malaysia | ||
638126 | 638126 | 2021-03-31 | Russia | Kalmykia Republic | 19952 | 315 | 19094 | 543 | 46.2313018 | 45.3275745 | 2021-04-01 04:27:05 | Kalmykia Republic, Russia | ||
1980818 | 1980818 | 2021-03-25 | Russia | Kalmykia Republic | 19811 | 310 | 18958 | 543 | 46.2313018 | 45.3275745 | 2021-03-26 05:26:55 | Kalmykia Republic, Russia | ||
702672 | 702672 | 2021-03-16 | Saint Vincent and the Grenadines | 1681 | 9 | 1129 | 543 | 12.9843 | -61.2872 | 2021-03-17 05:25:07 | Saint Vincent and the Grenadines | |||
1579935 | 1579935 | 2021-03-13 | Chile | Arica y Parinacota | 15983 | 319 | 15121 | 543 | -18.594 | -69.4785 | 2021-03-14 05:25:37 | Arica y Parinacota, Chile | ||
54647 | 54647 | 2021-03-07 | Colombia | Cauca | 27538 | 753 | 26242 | 543 | 2.705 | -76.82600000000002 | 2021-03-08 05:24:48 | Cauca, Colombia | ||
3257253 | 3257253 | 2021-03-02 | US | Texas | Hemphill | 48211 | 654 | 2 | 0 | 543 | 35.83764858 | -100.2703577 | 2021-03-03 05:23:28 | Hemphill, Texas, US |
3255634 | 3255634 | 2021-03-02 | US | Louisiana | Cameron | 22023 | 549 | 6 | 0 | 543 | 29.87592238 | -93.19310676 | 2021-03-03 05:23:28 | Cameron, Louisiana, US |
1001545 | 1001545 | 2021-03-01 | US | Texas | Hemphill | 48211 | 654 | 2 | 0 | 543 | 35.83764858 | -100.2703577 | 2021-03-02 05:23:30 | Hemphill, Texas, US |
1000829 | 1000829 | 2021-03-01 | US | North Dakota | Foster | 38031 | 564 | 19 | 0 | 543 | 47.4571084 | -98.88279923 | 2021-03-02 05:23:30 | Foster, North Dakota, US |
2370603 | 2370603 | 2021-02-28 | US | Texas | Hemphill | 48211 | 654 | 2 | 0 | 543 | 35.83764858 | -100.2703577 | 2021-03-01 05:23:01 | Hemphill, Texas, US |
2369887 | 2369887 | 2021-02-28 | US | North Dakota | Foster | 38031 | 562 | 19 | 0 | 543 | 47.4571084 | -98.88279923 | 2021-03-01 05:23:01 | Foster, North Dakota, US |
3069105 | 3069105 | 2021-02-27 | US | Texas | Hemphill | 48211 | 654 | 2 | 0 | 543 | 35.83764858 | -100.2703577 | 2021-02-28 05:22:20 | Hemphill, Texas, US |
3068765 | 3068765 | 2021-02-27 | US | Puerto Rico | Salinas | 72123 | 543 | 0 | 0 | 543 | 18.010386999999994 | -66.256592 | 2021-02-28 05:22:20 | Salinas, Puerto Rico, US |
3068389 | 3068389 | 2021-02-27 | US | North Dakota | Foster | 38031 | 562 | 19 | 0 | 543 | 47.4571084 | -98.88279923 | 2021-02-28 05:22:20 | Foster, North Dakota, US |
3066635 | 3066635 | 2021-02-27 | US | Colorado | Park | 8093 | 577 | 5 | 0 | 543 | 39.120926 | -105.7182065 | 2021-02-28 05:22:20 | Park, Colorado, US |
2186689 | 2186689 | 2021-02-26 | US | Texas | Hemphill | 48211 | 654 | 2 | 0 | 543 | 35.83764858 | -100.2703577 | 2021-02-27 05:22:28 | Hemphill, Texas, US |
2186349 | 2186349 | 2021-02-26 | US | Puerto Rico | Salinas | 72123 | 543 | 0 | 0 | 543 | 18.010386999999994 | -66.256592 | 2021-02-27 05:22:28 | Salinas, Puerto Rico, US |
1860771 | 1860771 | 2021-02-25 | US | Puerto Rico | Salinas | 72123 | 543 | 0 | 0 | 543 | 18.010386999999994 | -66.256592 | 2021-02-26 05:22:40 | Salinas, Puerto Rico, US |
1860316 | 1860316 | 2021-02-25 | US | North Carolina | Graham | 37075 | 555 | 12 | 0 | 543 | 35.3506925 | -83.83369267 | 2021-02-26 05:22:40 | Graham, North Carolina, US |
282494 | 282494 | 2021-02-24 | US | North Carolina | Graham | 37075 | 555 | 12 | 0 | 543 | 35.3506925 | -83.83369267 | 2021-02-25 05:24:57 | Graham, North Carolina, US |
742755 | 742755 | 2021-02-20 | US | Arizona | Greenlee | 4011 | 551 | 8 | 0 | 543 | 33.21498827 | -109.2405279 | 2021-02-21 05:24:33 | Greenlee, Arizona, US |
3051725 | 3051725 | 2021-02-16 | US | Maine | Lincoln | 23015 | 544 | 1 | 0 | 543 | 44.05996956 | -69.54227124 | 2021-02-17 05:23:10 | Lincoln, Maine, US |
1339824 | 1339824 | 2021-02-15 | US | Maine | Lincoln | 23015 | 544 | 1 | 0 | 543 | 44.05996956 | -69.54227124 | 2021-02-16 05:24:38 | Lincoln, Maine, US |
1339030 | 1339030 | 2021-02-15 | US | Georgia | Calhoun | 13037 | 557 | 14 | 0 | 543 | 31.53169785 | -84.62725131 | 2021-02-16 05:24:38 | Calhoun, Georgia, US |
2680537 | 2680537 | 2021-02-13 | US | Puerto Rico | Barceloneta | 72017 | 543 | 0 | 0 | 543 | 18.445533 | -66.56053100000001 | 2021-02-14 05:23:43 | Barceloneta, Puerto Rico, US |
3541016 | 3541016 | 2021-02-12 | US | Maine | Waldo | 23027 | 561 | 18 | 0 | 543 | 44.4858305 | -69.12061935 | 2021-02-13 05:22:12 | Waldo, Maine, US |
3980976 | 3980976 | 2021-02-10 | US | North Dakota | McHenry | 38049 | 567 | 21 | 0 | 543 | 48.23104458 | -100.6324822 | 2021-02-11 05:23:55 | McHenry, North Dakota, US |
1528754 | 1528754 | 2021-02-09 | US | Georgia | Randolph | 13243 | 574 | 31 | 0 | 543 | 31.76622818 | -84.75732369 | 2021-02-10 05:22:41 | Randolph, Georgia, US |
1527763 | 1527763 | 2021-02-09 | Comoros | 3179 | 118 | 2518 | 543 | -11.6455 | 43.3333 | 2021-02-10 05:22:41 | Comoros | |||
617350 | 617350 | 2021-02-08 | Vietnam | 2050 | 35 | 1472 | 543 | 14.058324 | 108.277199 | 2021-02-09 05:23:30 | Vietnam | |||
978086 | 978086 | 2021-02-06 | US | Texas | Mitchell | 48335 | 1122 | 27 | 0 | 543 | 32.30623474 | -100.9212058 | 2021-02-07 05:23:00 | Mitchell, Texas, US |
343596 | 343596 | 2021-02-03 | US | Virginia | Emporia | 51595 | 576 | 33 | 0 | 543 | 36.69455571 | -77.53406129 | 2021-02-04 05:22:26 | Emporia, Virginia, US |
343399 | 343399 | 2021-02-03 | US | Texas | Jim Hogg | 48247 | 635 | 13 | 0 | 543 | 27.04453923 | -98.6968187 | 2021-02-04 05:22:26 | Jim Hogg, Texas, US |
1687557 | 1687557 | 2021-02-02 | US | Texas | Dallam | 48111 | 952 | 21 | 0 | 543 | 36.27787176 | -102.6020725 | 2021-02-03 05:22:52 | Dallam, Texas, US |
1678489 | 1678489 | 2021-02-01 | US | Montana | Sanders | 30089 | 553 | 10 | 0 | 543 | 47.67657534 | -115.1329916 | 2021-02-02 05:22:49 | Sanders, Montana, US |
1678110 | 1678110 | 2021-02-01 | US | Michigan | Kalkaska | 26079 | 557 | 14 | 0 | 543 | 44.68512729 | -85.09085699 | 2021-02-02 05:22:49 | Kalkaska, Michigan, US |
1462481 | 1462481 | 2021-01-31 | US | Puerto Rico | Ciales | 72039 | 543 | 0 | 0 | 543 | 18.28885 | -66.516475 | 2021-02-01 05:22:53 | Ciales, Puerto Rico, US |
1461777 | 1461777 | 2021-01-31 | US | Montana | Sanders | 30089 | 553 | 10 | 0 | 543 | 47.67657534 | -115.1329916 | 2021-02-01 05:22:53 | Sanders, Montana, US |
1461093 | 1461093 | 2021-01-31 | US | Kansas | Scott | 20171 | 557 | 14 | 0 | 543 | 38.48222076 | -100.9066539 | 2021-02-01 05:22:53 | Scott, Kansas, US |
2213001 | 2213001 | 2021-01-30 | US | Kansas | Scott | 20171 | 557 | 14 | 0 | 543 | 38.48222076 | -100.9066539 | 2021-01-31 05:22:42 | Scott, Kansas, US |
1898488 | 1898488 | 2021-01-29 | US | Kansas | Scott | 20171 | 557 | 14 | 0 | 543 | 38.48222076 | -100.9066539 | 2021-01-30 05:22:49 | Scott, Kansas, US |
1897929 | 1897929 | 2021-01-29 | US | Georgia | Crawford | 13079 | 555 | 12 | 0 | 543 | 32.71391813 | -83.98061238 | 2021-01-30 05:22:49 | Crawford, Georgia, US |
2483926 | 2483926 | 2021-01-28 | US | Missouri | St. Clair | 29185 | 549 | 6 | 0 | 543 | 38.03699437 | -93.77631447 | 2021-01-29 05:22:23 | St. Clair, Missouri, US |
2483256 | 2483256 | 2021-01-28 | US | Kansas | Harper | 20077 | 562 | 19 | 0 | 543 | 37.19175361 | -98.07578384 | 2021-01-29 05:22:23 | Harper, Kansas, US |
3155492 | 3155492 | 2021-01-27 | US | Missouri | Daviess | 29061 | 553 | 10 | 0 | 543 | 39.96145298 | -93.98519678 | 2021-01-28 05:22:24 | Daviess, Missouri, US |
3154891 | 3154891 | 2021-01-27 | US | Kansas | Harper | 20077 | 562 | 19 | 0 | 543 | 37.19175361 | -98.07578384 | 2021-01-28 05:22:24 | Harper, Kansas, US |
15713 | 15713 | 2021-01-26 | US | Virginia | Northumberland | 51133 | 556 | 13 | 0 | 543 | 37.89202088 | -76.41949732 | 2021-01-27 05:23:41 | Northumberland, Virginia, US |
2571171 | 2571171 | 2021-01-25 | US | West Virginia | Tyler | 54095 | 546 | 3 | 0 | 543 | 39.46811972 | -80.88772676 | 2021-01-26 05:22:02 | Tyler, West Virginia, US |
2571109 | 2571109 | 2021-01-25 | US | Washington | Pend Oreille | 53051 | 547 | 4 | 0 | 543 | 48.53234021 | -117.2741804 | 2021-01-26 05:22:02 | Pend Oreille, Washington, US |
2430373 | 2430373 | 2021-01-23 | US | West Virginia | Gilmer | 54021 | 549 | 6 | 0 | 543 | 38.9251277 | -80.85952723 | 2021-01-24 05:22:35 | Gilmer, West Virginia, US |
2470346 | 2470346 | 2021-01-22 | US | Wisconsin | Iron | 55051 | 579 | 36 | 0 | 543 | 46.26302338 | -90.24295041 | 2021-01-23 05:22:03 | Iron, Wisconsin, US |
2470075 | 2470075 | 2021-01-22 | US | Vermont | Addison | 50001 | 548 | 5 | 0 | 543 | 44.03217337 | -73.14130877 | 2021-01-23 05:22:03 | Addison, Vermont, US |
437651 | 437651 | 2021-01-21 | US | North Carolina | Clay | 37043 | 548 | 5 | 0 | 543 | 35.05704275 | -83.74353633 | 2021-01-22 05:22:10 | Clay, North Carolina, US |
1097459 | 1097459 | 2021-01-20 | US | Virginia | Northampton | 51131 | 575 | 32 | 0 | 543 | 37.34062933 | -75.87751591 | 2021-01-21 05:22:01 | Northampton, Virginia, US |
1096795 | 1096795 | 2021-01-20 | US | Puerto Rico | Anasco | 72011 | 543 | 0 | 0 | 543 | 18.287985 | -67.120611 | 2021-01-21 05:22:01 | Anasco, Puerto Rico, US |
1095692 | 1095692 | 2021-01-20 | US | Michigan | Baraga | 26013 | 572 | 29 | 0 | 543 | 46.6720582 | -88.36363591 | 2021-01-21 05:22:01 | Baraga, Michigan, US |
910885 | 910885 | 2021-01-19 | US | Puerto Rico | Anasco | 72011 | 543 | 0 | 0 | 543 | 18.287985 | -67.120611 | 2021-01-20 05:21:54 | Anasco, Puerto Rico, US |
239948 | 239948 | 2021-01-18 | US | Puerto Rico | Anasco | 72011 | 543 | 0 | 0 | 543 | 18.287985 | -67.120611 | 2021-01-19 05:22:15 | Anasco, Puerto Rico, US |
237882 | 237882 | 2021-01-18 | US | Colorado | Rio Grande | 8105 | 620 | 12 | 0 | 543 | 37.5836865 | -106.3847838 | 2021-01-19 05:22:15 | Rio Grande, Colorado, US |
3506437 | 3506437 | 2021-01-17 | US | Texas | Franklin | 48159 | 676 | 15 | 0 | 543 | 33.17653242 | -95.21917243 | 2021-01-18 05:22:34 | Franklin, Texas, US |
193220 | 193220 | 2021-01-11 | US | Texas | Lynn | 48305 | 542 | 14 | 0 | 543 | 33.17657705 | -101.8162849 | 2021-01-12 05:22:15 | Lynn, Texas, US |
192921 | 192921 | 2021-01-11 | US | South Dakota | Day | 46037 | 564 | 21 | 0 | 543 | 45.367281 | -97.60737498 | 2021-01-12 05:22:15 | Day, South Dakota, US |
192791 | 192791 | 2021-01-11 | US | Puerto Rico | Coamo | 72043 | 543 | 0 | 0 | 543 | 18.097597 | -66.36014 | 2021-01-12 05:22:15 | Coamo, Puerto Rico, US |
190659 | 190659 | 2021-01-11 | US | Colorado | Archuleta | 8007 | 572 | 1 | 0 | 543 | 37.19474156 | -107.0476867 | 2021-01-12 05:22:15 | Archuleta, Colorado, US |
2629023 | 2629023 | 2021-01-10 | US | Texas | Lynn | 48305 | 542 | 14 | 0 | 543 | 33.17657705 | -101.8162849 | 2021-01-11 05:21:50 | Lynn, Texas, US |
2627209 | 2627209 | 2021-01-10 | US | Kansas | Sherman | 20181 | 552 | 9 | 0 | 543 | 39.35147699 | -101.7197624 | 2021-01-11 05:21:50 | Sherman, Kansas, US |
2626701 | 2626701 | 2021-01-10 | US | Georgia | Macon | 13193 | 559 | 16 | 0 | 543 | 32.35207048 | -84.04234127 | 2021-01-11 05:21:50 | Macon, Georgia, US |
3903111 | 3903111 | 2021-01-09 | US | Texas | Lynn | 48305 | 542 | 14 | 0 | 543 | 33.17657705 | -101.8162849 | 2021-01-10 05:22:12 | Lynn, Texas, US |
3901297 | 3901297 | 2021-01-09 | US | Kansas | Sherman | 20181 | 552 | 9 | 0 | 543 | 39.35147699 | -101.7197624 | 2021-01-10 05:22:12 | Sherman, Kansas, US |
3900786 | 3900786 | 2021-01-09 | US | Georgia | Long | 13183 | 548 | 5 | 0 | 543 | 31.75218791 | -81.74952375 | 2021-01-10 05:22:12 | Long, Georgia, US |
155907 | 155907 | 2021-01-08 | US | Missouri | Monroe | 29137 | 549 | 6 | 0 | 543 | 39.49593978 | -92.00043978 | 2021-01-09 05:22:18 | Monroe, Missouri, US |
155320 | 155320 | 2021-01-08 | US | Kansas | Sherman | 20181 | 552 | 9 | 0 | 543 | 39.35147699 | -101.7197624 | 2021-01-09 05:22:18 | Sherman, Kansas, US |
154931 | 154931 | 2021-01-08 | US | Idaho | Valley | 16085 | 547 | 4 | 0 | 543 | 44.76728382 | -115.5676773 | 2021-01-09 05:22:18 | Valley, Idaho, US |
154816 | 154816 | 2021-01-08 | US | Georgia | McIntosh | 13191 | 553 | 10 | 0 | 543 | 31.49683595 | -81.40163426 | 2021-01-09 05:22:18 | McIntosh, Georgia, US |
2542326 | 2542326 | 2021-01-07 | US | Idaho | Caribou | 16029 | 553 | 10 | 0 | 543 | 42.77149116 | -111.5597683 | 2021-01-08 05:22:42 | Caribou, Idaho, US |
2866590 | 2866590 | 2021-01-06 | US | Missouri | Cedar | 29039 | 552 | 9 | 0 | 543 | 37.72391475 | -93.85445441 | 2021-01-07 05:22:03 | Cedar, Missouri, US |
2865851 | 2865851 | 2021-01-06 | US | Indiana | Union | 18161 | 547 | 4 | 0 | 543 | 39.62550777 | -84.92497066 | 2021-01-07 05:22:03 | Union, Indiana, US |
3036380 | 3036380 | 2021-01-05 | US | Nebraska | Johnson | 31097 | 548 | 5 | 0 | 543 | 40.39257596 | -96.26522753 | 2021-01-06 05:22:16 | Johnson, Nebraska, US |
1065117 | 1065117 | 2021-01-04 | US | Vermont | Bennington | 50003 | 546 | 3 | 0 | 543 | 43.03519828 | -73.09048868 | 2021-01-05 05:21:49 | Bennington, Vermont, US |
1064257 | 1064257 | 2021-01-04 | US | North Dakota | Ransom | 38073 | 550 | 12 | 0 | 543 | 46.45621782 | -97.65742504 | 2021-01-05 05:21:49 | Ransom, North Dakota, US |
1063867 | 1063867 | 2021-01-04 | US | Montana | Stillwater | 30095 | 551 | 8 | 0 | 543 | 45.67071407 | -109.3950061 | 2021-01-05 05:21:49 | Stillwater, Montana, 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]);