johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
453 rows where active = 483 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 29
- US 384
- Russia 14
- Congo (Brazzaville) 6
- Ukraine 6
- Japan 5
- Mexico 5
- Colombia 4
- Sao Tome and Principe 3
- Chile 2
- Germany 2
- India 2
- Italy 2
- Sierra Leone 2
- Brazil 1
- Canada 1
- Estonia 1
- Jordan 1
- Liberia 1
- Malaysia 1
- Mozambique 1
- Netherlands 1
- Niger 1
- Norway 1
- Pakistan 1
- Paraguay 1
- Singapore 1
- Spain 1
- Sweden 1
- Uruguay 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331683 | 331683 | 2021-08-04 | Canada | Saskatchewan | 50181 | 579 | 49119 | 483 | 52.9399 | -106.4509 | 2021-08-05 04:21:51 | Saskatchewan, Canada | ||
1378426 | 1378426 | 2021-07-25 | Germany | Sachsen | 286293 | 10128 | 275800 | 483 | 51.1045 | 13.2017 | 2021-07-26 04:21:28 | Sachsen, Germany | ||
1330166 | 1330166 | 2021-07-24 | Germany | Sachsen | 286293 | 10128 | 275800 | 483 | 51.1045 | 13.2017 | 2021-07-25 04:22:12 | Sachsen, Germany | ||
3141185 | 3141185 | 2021-07-23 | Ukraine | Lviv Oblast | 137920 | 3676 | 133761 | 483 | 49.8397 | 24.0297 | 2021-07-24 00:21:36 | Lviv Oblast, Ukraine | ||
3335161 | 3335161 | 2021-07-21 | Ukraine | Kiev Oblast | 127991 | 2762 | 124746 | 483 | 50.053 | 30.7667 | 2021-07-22 04:21:19 | Kiev Oblast, Ukraine | ||
3631969 | 3631969 | 2021-07-14 | Japan | Hyogo | 41463 | 1310 | 39670 | 483 | 35.039913 | 134.828057 | 2021-07-15 04:21:48 | Hyogo, Japan | ||
829781 | 829781 | 2021-07-09 | Russia | Adygea Republic | 15302 | 263 | 14556 | 483 | 44.6939006 | 40.1520421 | 2021-07-10 04:21:25 | Adygea Republic, Russia | ||
1896773 | 1896773 | 2021-06-30 | Ukraine | Kirovohrad Oblast | 20615 | 841 | 19291 | 483 | 48.5079 | 32.2623 | 2021-07-01 04:21:19 | Kirovohrad Oblast, Ukraine | ||
2884380 | 2884380 | 2021-06-20 | Japan | Hyogo | 40713 | 1272 | 38958 | 483 | 35.039913 | 134.828057 | 2021-06-21 04:21:41 | Hyogo, Japan | ||
1129226 | 1129226 | 2021-06-18 | Ukraine | Luhansk Oblast | 26472 | 931 | 25058 | 483 | 48.574 | 39.3078 | 2021-06-19 04:22:33 | Luhansk Oblast, Ukraine | ||
3472574 | 3472574 | 2021-06-08 | Singapore | 62219 | 34 | 61702 | 483 | 1.2833 | 103.8333 | 2021-06-09 04:23:31 | Singapore | |||
2104165 | 2104165 | 2021-06-01 | Japan | Shiga | 5136 | 80 | 4573 | 483 | 35.21582700000001 | 136.138064 | 2021-06-02 04:24:34 | Shiga, Japan | ||
1413267 | 1413267 | 2021-05-24 | Russia | Khanty-Mansi Autonomous Okrug | 57143 | 797 | 55863 | 483 | 61.0259025 | 69.0982628 | 2021-05-25 04:21:08 | Khanty-Mansi Autonomous Okrug, Russia | ||
2390980 | 2390980 | 2021-05-18 | Russia | Khakassia Republic | 22767 | 542 | 21742 | 483 | 53.72258845 | 91.44293627 | 2021-05-19 04:20:42 | Khakassia Republic, Russia | ||
1425313 | 1425313 | 2021-05-09 | Russia | Khanty-Mansi Autonomous Okrug | 56457 | 793 | 55181 | 483 | 61.0259025 | 69.0982628 | 2021-05-10 04:20:38 | Khanty-Mansi Autonomous Okrug, Russia | ||
1552181 | 1552181 | 2021-05-08 | Russia | Khanty-Mansi Autonomous Okrug | 56410 | 793 | 55134 | 483 | 61.0259025 | 69.0982628 | 2021-05-09 04:20:35 | Khanty-Mansi Autonomous Okrug, Russia | ||
2502239 | 2502239 | 2021-05-07 | Russia | Khanty-Mansi Autonomous Okrug | 56361 | 793 | 55085 | 483 | 61.0259025 | 69.0982628 | 2021-05-08 04:21:04 | Khanty-Mansi Autonomous Okrug, Russia | ||
3702301 | 3702301 | 2021-04-27 | Russia | Buryatia Republic | 37064 | 840 | 35741 | 483 | 52.7182426 | 109.492143 | 2021-04-28 04:20:32 | Buryatia Republic, Russia | ||
986626 | 986626 | 2021-04-17 | Malaysia | Negeri Sembilan | 17874 | 31 | 17360 | 483 | 2.7258 | 101.9424 | 2021-04-18 04:20:41 | Negeri Sembilan, Malaysia | ||
2983246 | 2983246 | 2021-04-10 | Italy | P.A. Bolzano | 69944 | 1150 | 68311 | 483 | 46.49933453 | 11.35662422 | 2021-04-11 04:20:56 | P.A. Bolzano, Italy | ||
1219574 | 1219574 | 2021-03-27 | Japan | Fukuoka | 18919 | 331 | 18105 | 483 | 33.526032 | 130.666949 | 2021-03-28 05:28:10 | Fukuoka, Japan | ||
3620933 | 3620933 | 2021-03-17 | Colombia | Meta | 43100 | 987 | 41630 | 483 | 3.272 | -73.0877 | 2021-03-18 05:26:22 | Meta, Colombia | ||
1732337 | 1732337 | 2021-03-14 | Colombia | Cauca | 27660 | 758 | 26419 | 483 | 2.705 | -76.82600000000002 | 2021-03-15 05:25:51 | Cauca, Colombia | ||
1617954 | 1617954 | 2021-03-05 | US | Minnesota | Grant | 27051 | 491 | 8 | 0 | 483 | 45.93424769 | -96.01139609 | 2021-03-06 04:23:41 | Grant, Minnesota, US |
1616452 | 1616452 | 2021-03-05 | Russia | Khakassia Republic | 21399 | 465 | 20451 | 483 | 53.72258845 | 91.44293627 | 2021-03-06 04:23:41 | Khakassia Republic, Russia | ||
2209365 | 2209365 | 2021-03-04 | US | Minnesota | Grant | 27051 | 491 | 8 | 0 | 483 | 45.93424769 | -96.01139609 | 2021-03-05 05:26:29 | Grant, Minnesota, US |
1091786 | 1091786 | 2021-03-03 | US | Minnesota | Grant | 27051 | 491 | 8 | 0 | 483 | 45.93424769 | -96.01139609 | 2021-03-04 05:24:24 | Grant, Minnesota, US |
3257084 | 3257084 | 2021-03-02 | US | Tennessee | Hancock | 47067 | 510 | 12 | 0 | 483 | 36.52692871 | -83.22375847 | 2021-03-03 05:23:28 | Hancock, Tennessee, US |
3255858 | 3255858 | 2021-03-02 | US | Minnesota | Grant | 27051 | 491 | 8 | 0 | 483 | 45.93424769 | -96.01139609 | 2021-03-03 05:23:28 | Grant, Minnesota, US |
3255454 | 3255454 | 2021-03-02 | US | Kansas | Meade | 20119 | 493 | 10 | 0 | 483 | 37.23859987 | -100.364831 | 2021-03-03 05:23:28 | Meade, Kansas, US |
1001376 | 1001376 | 2021-03-01 | US | Tennessee | Hancock | 47067 | 508 | 12 | 0 | 483 | 36.52692871 | -83.22375847 | 2021-03-02 05:23:30 | Hancock, Tennessee, US |
1000150 | 1000150 | 2021-03-01 | US | Minnesota | Grant | 27051 | 491 | 8 | 0 | 483 | 45.93424769 | -96.01139609 | 2021-03-02 05:23:30 | Grant, Minnesota, US |
999746 | 999746 | 2021-03-01 | US | Kansas | Meade | 20119 | 493 | 10 | 0 | 483 | 37.23859987 | -100.364831 | 2021-03-02 05:23:30 | Meade, Kansas, US |
2369208 | 2369208 | 2021-02-28 | US | Minnesota | Grant | 27051 | 491 | 8 | 0 | 483 | 45.93424769 | -96.01139609 | 2021-03-01 05:23:01 | Grant, Minnesota, US |
2368804 | 2368804 | 2021-02-28 | US | Kansas | Meade | 20119 | 493 | 10 | 0 | 483 | 37.23859987 | -100.364831 | 2021-03-01 05:23:01 | Meade, Kansas, US |
3067980 | 3067980 | 2021-02-27 | US | Montana | Chouteau | 30015 | 488 | 5 | 0 | 483 | 47.88084126 | -110.4353362 | 2021-02-28 05:22:20 | Chouteau, Montana, US |
3067306 | 3067306 | 2021-02-27 | US | Kansas | Meade | 20119 | 493 | 10 | 0 | 483 | 37.23859987 | -100.364831 | 2021-02-28 05:22:20 | Meade, Kansas, US |
2186637 | 2186637 | 2021-02-26 | US | Texas | Crosby | 48107 | 807 | 26 | 0 | 483 | 33.61431553 | -101.3000364 | 2021-02-27 05:22:28 | Crosby, Texas, US |
2184890 | 2184890 | 2021-02-26 | US | Kansas | Meade | 20119 | 493 | 10 | 0 | 483 | 37.23859987 | -100.364831 | 2021-02-27 05:22:28 | Meade, Kansas, US |
1861059 | 1861059 | 2021-02-25 | US | Texas | Crosby | 48107 | 807 | 26 | 0 | 483 | 33.61431553 | -101.3000364 | 2021-02-26 05:22:40 | Crosby, Texas, US |
283237 | 283237 | 2021-02-24 | US | Texas | Crosby | 48107 | 807 | 26 | 0 | 483 | 33.61431553 | -101.3000364 | 2021-02-25 05:24:57 | Crosby, Texas, US |
281169 | 281169 | 2021-02-24 | US | Illinois | Henderson | 17071 | 497 | 14 | 0 | 483 | 40.81908672 | -90.92491462 | 2021-02-25 05:24:57 | Henderson, Illinois, US |
1938514 | 1938514 | 2021-02-23 | US | Nebraska | Furnas | 31065 | 487 | 4 | 0 | 483 | 40.17642064 | -99.91247454 | 2021-02-24 05:29:16 | Furnas, Nebraska, US |
534209 | 534209 | 2021-02-22 | US | West Virginia | Roane | 54087 | 490 | 7 | 0 | 483 | 38.71622686 | -81.35243568 | 2021-02-23 05:23:41 | Roane, West Virginia, US |
532769 | 532769 | 2021-02-22 | US | Nebraska | Furnas | 31065 | 487 | 4 | 0 | 483 | 40.17642064 | -99.91247454 | 2021-02-23 05:23:41 | Furnas, Nebraska, US |
531641 | 531641 | 2021-02-22 | US | Idaho | Lemhi | 16059 | 492 | 9 | 0 | 483 | 44.9438088 | -113.9309747 | 2021-02-23 05:23:41 | Lemhi, Idaho, US |
184103 | 184103 | 2021-02-21 | US | Nebraska | Furnas | 31065 | 487 | 4 | 0 | 483 | 40.17642064 | -99.91247454 | 2021-02-22 05:24:21 | Furnas, Nebraska, US |
182975 | 182975 | 2021-02-21 | US | Idaho | Lemhi | 16059 | 492 | 9 | 0 | 483 | 44.9438088 | -113.9309747 | 2021-02-22 05:24:21 | Lemhi, Idaho, US |
745429 | 745429 | 2021-02-20 | US | Texas | Hudspeth | 48229 | 646 | 11 | 0 | 483 | 31.45628381 | -105.388178 | 2021-02-21 05:24:33 | Hudspeth, Texas, US |
745062 | 745062 | 2021-02-20 | US | Puerto Rico | Luquillo | 72089 | 483 | 0 | 0 | 483 | 18.342114 | -65.72509699999999 | 2021-02-21 05:24:33 | Luquillo, Puerto Rico, US |
744377 | 744377 | 2021-02-20 | US | Nebraska | Furnas | 31065 | 487 | 4 | 0 | 483 | 40.17642064 | -99.91247454 | 2021-02-21 05:24:33 | Furnas, Nebraska, US |
743249 | 743249 | 2021-02-20 | US | Idaho | Lemhi | 16059 | 492 | 9 | 0 | 483 | 44.9438088 | -113.9309747 | 2021-02-21 05:24:33 | Lemhi, Idaho, US |
472398 | 472398 | 2021-02-19 | US | Illinois | Henderson | 17071 | 491 | 8 | 0 | 483 | 40.81908672 | -90.92491462 | 2021-02-20 05:22:51 | Henderson, Illinois, US |
472347 | 472347 | 2021-02-19 | US | Idaho | Lemhi | 16059 | 492 | 9 | 0 | 483 | 44.9438088 | -113.9309747 | 2021-02-20 05:22:51 | Lemhi, Idaho, US |
1154107 | 1154107 | 2021-02-18 | US | Illinois | Henderson | 17071 | 491 | 8 | 0 | 483 | 40.81908672 | -90.92491462 | 2021-02-19 05:24:16 | Henderson, Illinois, US |
1154056 | 1154056 | 2021-02-18 | US | Idaho | Lemhi | 16059 | 492 | 9 | 0 | 483 | 44.9438088 | -113.9309747 | 2021-02-19 05:24:16 | Lemhi, Idaho, US |
1340377 | 1340377 | 2021-02-15 | US | Nebraska | Polk | 31143 | 492 | 9 | 0 | 483 | 41.18813488 | -97.56630712 | 2021-02-16 05:24:38 | Polk, Nebraska, US |
2285528 | 2285528 | 2021-02-14 | US | Nebraska | Polk | 31143 | 492 | 9 | 0 | 483 | 41.18813488 | -97.56630712 | 2021-02-15 05:24:49 | Polk, Nebraska, US |
2679928 | 2679928 | 2021-02-13 | US | Nebraska | Polk | 31143 | 492 | 9 | 0 | 483 | 41.18813488 | -97.56630712 | 2021-02-14 05:23:43 | Polk, Nebraska, US |
1529588 | 1529588 | 2021-02-09 | US | Minnesota | Big Stone | 27011 | 486 | 3 | 0 | 483 | 45.42712824 | -96.41403739 | 2021-02-10 05:22:41 | Big Stone, Minnesota, US |
975053 | 975053 | 2021-02-06 | Niger | 4598 | 165 | 3950 | 483 | 17.607789 | 8.081666 | 2021-02-07 05:23:00 | Niger | |||
341314 | 341314 | 2021-02-03 | US | Illinois | Stark | 17175 | 504 | 21 | 0 | 483 | 41.09309773 | -89.79745866 | 2021-02-04 05:22:26 | Stark, Illinois, US |
340135 | 340135 | 2021-02-03 | Colombia | Sucre | 19482 | 717 | 18282 | 483 | 8.814 | -74.7233 | 2021-02-04 05:22:26 | Sucre, Colombia | ||
1685540 | 1685540 | 2021-02-02 | US | Illinois | Stark | 17175 | 504 | 21 | 0 | 483 | 41.09309773 | -89.79745866 | 2021-02-03 05:22:52 | Stark, Illinois, US |
1684247 | 1684247 | 2021-02-02 | Brazil | Piaui | 160252 | 3087 | 156186 | 483 | -7.7183 | -42.7289 | 2021-02-03 05:22:52 | Piaui, Brazil | ||
1679674 | 1679674 | 2021-02-01 | US | Texas | San Augustine | 48405 | 383 | 28 | 0 | 483 | 31.39457611 | -94.17000399 | 2021-02-02 05:22:49 | San Augustine, Texas, US |
1677510 | 1677510 | 2021-02-01 | US | Illinois | Stark | 17175 | 504 | 21 | 0 | 483 | 41.09309773 | -89.79745866 | 2021-02-02 05:22:49 | Stark, Illinois, US |
1677445 | 1677445 | 2021-02-01 | US | Illinois | Edwards | 17047 | 491 | 8 | 0 | 483 | 38.41353228 | -88.05720863 | 2021-02-02 05:22:49 | Edwards, Illinois, US |
1462962 | 1462962 | 2021-01-31 | US | Texas | San Augustine | 48405 | 383 | 28 | 0 | 483 | 31.39457611 | -94.17000399 | 2021-02-01 05:22:53 | San Augustine, Texas, US |
1460798 | 1460798 | 2021-01-31 | US | Illinois | Stark | 17175 | 504 | 21 | 0 | 483 | 41.09309773 | -89.79745866 | 2021-02-01 05:22:53 | Stark, Illinois, US |
1460733 | 1460733 | 2021-01-31 | US | Illinois | Edwards | 17047 | 491 | 8 | 0 | 483 | 38.41353228 | -88.05720863 | 2021-02-01 05:22:53 | Edwards, Illinois, US |
2214870 | 2214870 | 2021-01-30 | US | Texas | San Augustine | 48405 | 383 | 28 | 0 | 483 | 31.39457611 | -94.17000399 | 2021-01-31 05:22:42 | San Augustine, Texas, US |
2212641 | 2212641 | 2021-01-30 | US | Illinois | Edwards | 17047 | 491 | 8 | 0 | 483 | 38.41353228 | -88.05720863 | 2021-01-31 05:22:42 | Edwards, Illinois, US |
1900357 | 1900357 | 2021-01-29 | US | Texas | San Augustine | 48405 | 383 | 28 | 0 | 483 | 31.39457611 | -94.17000399 | 2021-01-30 05:22:49 | San Augustine, Texas, US |
2485173 | 2485173 | 2021-01-28 | US | Texas | San Augustine | 48405 | 383 | 28 | 0 | 483 | 31.39457611 | -94.17000399 | 2021-01-29 05:22:23 | San Augustine, Texas, US |
3153460 | 3153460 | 2021-01-27 | Colombia | Putumayo | 7220 | 279 | 6458 | 483 | 0.436 | -75.5277 | 2021-01-28 05:22:24 | Putumayo, Colombia | ||
2569046 | 2569046 | 2021-01-25 | US | Kentucky | Crittenden | 21055 | 494 | 11 | 0 | 483 | 37.35839237 | -88.08826090000002 | 2021-01-26 05:22:02 | Crittenden, Kentucky, US |
2429312 | 2429312 | 2021-01-23 | US | North Dakota | Pierce | 38069 | 506 | 24 | 0 | 483 | 48.24977025 | -99.96407787 | 2021-01-24 05:22:35 | Pierce, North Dakota, US |
2469345 | 2469345 | 2021-01-22 | US | Oklahoma | Dewey | 40043 | 487 | 4 | 0 | 483 | 35.98772922 | -99.00730714 | 2021-01-23 05:22:03 | Dewey, Oklahoma, US |
2468187 | 2468187 | 2021-01-22 | US | Kentucky | Crittenden | 21055 | 489 | 6 | 0 | 483 | 37.35839237 | -88.08826090000002 | 2021-01-23 05:22:03 | Crittenden, Kentucky, US |
2467662 | 2467662 | 2021-01-22 | US | Georgia | Randolph | 13243 | 514 | 31 | 0 | 483 | 31.76622818 | -84.75732369 | 2021-01-23 05:22:03 | Randolph, Georgia, US |
1096496 | 1096496 | 2021-01-20 | US | North Dakota | Pierce | 38069 | 505 | 22 | 0 | 483 | 48.24977025 | -99.96407787 | 2021-01-21 05:22:01 | Pierce, North Dakota, US |
911301 | 911301 | 2021-01-19 | US | Texas | Jim Hogg | 48247 | 573 | 11 | 0 | 483 | 27.04453923 | -98.6968187 | 2021-01-20 05:21:54 | Jim Hogg, Texas, US |
911292 | 911292 | 2021-01-19 | US | Texas | Hudspeth | 48229 | 643 | 8 | 0 | 483 | 31.45628381 | -105.388178 | 2021-01-20 05:21:54 | Hudspeth, Texas, US |
910586 | 910586 | 2021-01-19 | US | North Dakota | Pierce | 38069 | 504 | 22 | 0 | 483 | 48.24977025 | -99.96407787 | 2021-01-20 05:21:54 | Pierce, North Dakota, US |
909903 | 909903 | 2021-01-19 | US | Minnesota | Lincoln | 27081 | 484 | 1 | 0 | 483 | 44.41311883 | -96.26688165 | 2021-01-20 05:21:54 | Lincoln, Minnesota, US |
908618 | 908618 | 2021-01-19 | US | Arizona | Greenlee | 4011 | 487 | 4 | 0 | 483 | 33.21498827 | -109.2405279 | 2021-01-20 05:21:54 | Greenlee, Arizona, US |
239649 | 239649 | 2021-01-18 | US | North Dakota | Pierce | 38069 | 504 | 22 | 0 | 483 | 48.24977025 | -99.96407787 | 2021-01-19 05:22:15 | Pierce, North Dakota, US |
239551 | 239551 | 2021-01-18 | US | North Carolina | Graham | 37075 | 495 | 12 | 0 | 483 | 35.3506925 | -83.83369267 | 2021-01-19 05:22:15 | Graham, North Carolina, US |
3505766 | 3505766 | 2021-01-17 | US | North Dakota | Pierce | 38069 | 504 | 22 | 0 | 483 | 48.24977025 | -99.96407787 | 2021-01-18 05:22:34 | Pierce, North Dakota, US |
3505668 | 3505668 | 2021-01-17 | US | North Carolina | Graham | 37075 | 495 | 12 | 0 | 483 | 35.3506925 | -83.83369267 | 2021-01-18 05:22:34 | Graham, North Carolina, US |
3882340 | 3882340 | 2021-01-14 | US | Puerto Rico | Salinas | 72123 | 483 | 0 | 0 | 483 | 18.010386999999994 | -66.256592 | 2021-01-15 05:22:24 | Salinas, Puerto Rico, US |
3309594 | 3309594 | 2021-01-13 | US | Kentucky | Gallatin | 21077 | 494 | 11 | 0 | 483 | 38.75398691 | -84.8558382 | 2021-01-14 05:22:32 | Gallatin, Kentucky, US |
776265 | 776265 | 2021-01-12 | US | Missouri | Maries | 29125 | 490 | 7 | 0 | 483 | 38.16193985 | -91.92249662 | 2021-01-13 05:22:15 | Maries, Missouri, US |
193263 | 193263 | 2021-01-11 | US | Texas | Refugio | 48391 | 542 | 17 | 0 | 483 | 28.3238976 | -97.15766311 | 2021-01-12 05:22:15 | Refugio, Texas, US |
190948 | 190948 | 2021-01-11 | US | Georgia | Twiggs | 13289 | 503 | 20 | 0 | 483 | 32.67435595 | -83.43078662 | 2021-01-12 05:22:15 | Twiggs, Georgia, US |
2629066 | 2629066 | 2021-01-10 | US | Texas | Refugio | 48391 | 542 | 17 | 0 | 483 | 28.3238976 | -97.15766311 | 2021-01-11 05:21:50 | Refugio, Texas, US |
2626296 | 2626296 | 2021-01-10 | US | Alaska | Northwest Arctic | 2188 | 483 | 0 | 0 | 483 | 67.04919196 | -159.7503946 | 2021-01-11 05:21:50 | Northwest Arctic, Alaska, US |
3903055 | 3903055 | 2021-01-09 | US | Texas | Hamilton | 48193 | 534 | 18 | 0 | 483 | 31.70470573 | -98.11083887 | 2021-01-10 05:22:12 | Hamilton, Texas, US |
155937 | 155937 | 2021-01-08 | US | Missouri | St. Clair | 29185 | 488 | 5 | 0 | 483 | 38.03699437 | -93.77631447 | 2021-01-09 05:22:18 | St. Clair, Missouri, 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]);