johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
425 rows where confirmed = 1252 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Kansas 34
- Puerto Rico 30
- Virginia 27
- Iowa 25
- Kentucky 24
- Georgia 21
- Missouri 18
- Texas 18
- Mississippi 17
- Idaho 16
- Tennessee 14
- Oklahoma 12
- Vermont 12
- Alabama 11
- Illinois 11
- Minnesota 11
- Wisconsin 10
- Colorado 9
- North Carolina 9
- Arkansas 8
- Indiana 8
- Ohio 8
- South Dakota 8
- Montana 7
- Nebraska 7
- Florida 6
- California 5
- Washington 5
- Michigan 4
- South Carolina 4
- …
country_or_region 1
- US · 425 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1623564 | 1623564 | 2022-11-22 | US | Vermont | Grand Isle | 50013 | 1252 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-11-23 04:21:06 | Grand Isle, Vermont, US | |
3463452 | 3463452 | 2022-11-21 | US | Vermont | Grand Isle | 50013 | 1252 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-11-22 04:20:47 | Grand Isle, Vermont, US | |
1643637 | 1643637 | 2022-11-20 | US | Vermont | Grand Isle | 50013 | 1252 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-11-21 04:21:05 | Grand Isle, Vermont, US | |
2067194 | 2067194 | 2022-11-19 | US | Vermont | Grand Isle | 50013 | 1252 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-11-20 04:21:08 | Grand Isle, Vermont, US | |
1758588 | 1758588 | 2022-11-18 | US | Vermont | Grand Isle | 50013 | 1252 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-11-19 04:21:14 | Grand Isle, Vermont, US | |
3029581 | 3029581 | 2022-11-17 | US | Vermont | Grand Isle | 50013 | 1252 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-11-18 04:21:15 | Grand Isle, Vermont, US | |
2489292 | 2489292 | 2022-11-16 | US | Vermont | Grand Isle | 50013 | 1252 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-11-17 04:21:11 | Grand Isle, Vermont, US | |
540955 | 540955 | 2022-10-26 | US | New Mexico | Hidalgo | 35023 | 1252 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-10-27 04:22:01 | Hidalgo, New Mexico, US | |
3252348 | 3252348 | 2022-10-11 | US | New Mexico | Guadalupe | 35019 | 1252 | 18 | 0 | 34.86319296 | -104.790669 | 2022-10-12 04:22:51 | Guadalupe, New Mexico, US | |
2261152 | 2261152 | 2022-10-02 | US | Kentucky | Carlisle | 21039 | 1252 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-10-03 04:23:11 | Carlisle, Kentucky, US | |
2996678 | 2996678 | 2022-10-01 | US | Kentucky | Carlisle | 21039 | 1252 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-10-02 04:21:23 | Carlisle, Kentucky, US | |
855004 | 855004 | 2022-09-30 | US | Kentucky | Carlisle | 21039 | 1252 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-10-01 04:23:01 | Carlisle, Kentucky, US | |
2376930 | 2376930 | 2022-09-29 | US | Kentucky | Carlisle | 21039 | 1252 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-30 04:23:09 | Carlisle, Kentucky, US | |
1561481 | 1561481 | 2022-09-28 | US | Kentucky | Carlisle | 21039 | 1252 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-29 04:22:34 | Carlisle, Kentucky, US | |
3996024 | 3996024 | 2022-09-27 | US | Kentucky | Carlisle | 21039 | 1252 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-28 04:23:01 | Carlisle, Kentucky, US | |
2770352 | 2770352 | 2022-09-26 | US | Kentucky | Carlisle | 21039 | 1252 | 21 | 0 | 36.85372876 | -88.9669222 | 2022-09-27 04:23:01 | Carlisle, Kentucky, US | |
2772512 | 2772512 | 2022-09-26 | US | Wisconsin | Florence | 55037 | 1252 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-09-27 04:23:01 | Florence, Wisconsin, US | |
1980165 | 1980165 | 2022-09-25 | US | Wisconsin | Florence | 55037 | 1252 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-09-26 04:20:52 | Florence, Wisconsin, US | |
2653332 | 2653332 | 2022-09-24 | US | Wisconsin | Florence | 55037 | 1252 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-09-25 04:23:31 | Florence, Wisconsin, US | |
387772 | 387772 | 2022-09-23 | US | Wisconsin | Florence | 55037 | 1252 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-09-24 04:21:40 | Florence, Wisconsin, US | |
3769206 | 3769206 | 2022-09-11 | US | Virginia | Craig | 51045 | 1252 | 23 | 0 | 37.48133648 | -80.21072274 | 2022-09-12 04:20:58 | Craig, Virginia, US | |
3827781 | 3827781 | 2022-09-10 | US | Virginia | Craig | 51045 | 1252 | 23 | 0 | 37.48133648 | -80.21072274 | 2022-09-11 04:20:50 | Craig, Virginia, US | |
966238 | 966238 | 2022-09-09 | US | Virginia | Craig | 51045 | 1252 | 23 | 0 | 37.48133648 | -80.21072274 | 2022-09-10 04:21:10 | Craig, Virginia, US | |
254261 | 254261 | 2022-09-08 | US | Idaho | Lewis | 16061 | 1252 | 30 | 0 | 46.23315327 | -116.434146 | 2022-09-09 04:21:11 | Lewis, Idaho, US | |
3746059 | 3746059 | 2022-09-07 | US | Idaho | Lewis | 16061 | 1252 | 30 | 0 | 46.23315327 | -116.434146 | 2022-09-08 04:21:02 | Lewis, Idaho, US | |
3775259 | 3775259 | 2022-08-30 | US | Kansas | Stafford | 20185 | 1252 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-08-31 04:20:57 | Stafford, Kansas, US | |
1681855 | 1681855 | 2022-08-29 | US | Kansas | Stafford | 20185 | 1252 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-08-30 04:21:03 | Stafford, Kansas, US | |
1878339 | 1878339 | 2022-08-28 | US | Kansas | Stafford | 20185 | 1252 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-08-29 04:21:06 | Stafford, Kansas, US | |
2097466 | 2097466 | 2022-08-27 | US | Kansas | Stafford | 20185 | 1252 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-08-28 04:21:02 | Stafford, Kansas, US | |
1533281 | 1533281 | 2022-08-26 | US | Kansas | Stafford | 20185 | 1252 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-08-27 04:20:57 | Stafford, Kansas, US | |
1534690 | 1534690 | 2022-08-26 | US | Puerto Rico | Maricao | 72093 | 1252 | 0 | 0 | 18.171795 | -66.942126 | 2022-08-27 04:20:57 | Maricao, Puerto Rico, US | |
2830168 | 2830168 | 2022-08-25 | US | Kansas | Stafford | 20185 | 1252 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-08-26 04:21:02 | Stafford, Kansas, US | |
2324701 | 2324701 | 2022-08-24 | US | Kansas | Stafford | 20185 | 1252 | 28 | 0 | 38.03100851 | -98.71762001 | 2022-08-25 04:21:13 | Stafford, Kansas, US | |
1406362 | 1406362 | 2022-08-02 | US | Kansas | Meade | 20119 | 1252 | 22 | 0 | 37.23859987 | -100.364831 | 2022-08-03 04:20:59 | Meade, Kansas, US | |
3618400 | 3618400 | 2022-08-01 | US | Kansas | Meade | 20119 | 1252 | 22 | 0 | 37.23859987 | -100.364831 | 2022-08-02 04:20:53 | Meade, Kansas, US | |
3872880 | 3872880 | 2022-07-31 | US | Kansas | Meade | 20119 | 1252 | 22 | 0 | 37.23859987 | -100.364831 | 2022-08-01 04:21:03 | Meade, Kansas, US | |
675634 | 675634 | 2022-07-30 | US | Kansas | Meade | 20119 | 1252 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-31 04:21:02 | Meade, Kansas, US | |
1784833 | 1784833 | 2022-07-29 | US | Kansas | Meade | 20119 | 1252 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-30 04:20:42 | Meade, Kansas, US | |
1067196 | 1067196 | 2022-07-28 | US | Kansas | Meade | 20119 | 1252 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-29 04:20:45 | Meade, Kansas, US | |
2336715 | 2336715 | 2022-07-27 | US | Kansas | Meade | 20119 | 1252 | 22 | 0 | 37.23859987 | -100.364831 | 2022-07-28 04:20:56 | Meade, Kansas, US | |
1488880 | 1488880 | 2022-07-26 | US | Kansas | Gray | 20069 | 1252 | 22 | 0 | 37.73836671 | -100.4369088 | 2022-07-27 04:21:04 | Gray, Kansas, US | |
2595073 | 2595073 | 2022-07-25 | US | Illinois | Putnam | 17155 | 1252 | 10 | 0 | 41.2013541 | -89.2869272 | 2022-07-26 04:20:58 | Putnam, Illinois, US | |
2595326 | 2595326 | 2022-07-25 | US | Kansas | Gray | 20069 | 1252 | 22 | 0 | 37.73836671 | -100.4369088 | 2022-07-26 04:20:58 | Gray, Kansas, US | |
897441 | 897441 | 2022-07-24 | US | Kansas | Gray | 20069 | 1252 | 22 | 0 | 37.73836671 | -100.4369088 | 2022-07-25 04:20:51 | Gray, Kansas, US | |
92435 | 92435 | 2022-07-23 | US | Kansas | Gray | 20069 | 1252 | 22 | 0 | 37.73836671 | -100.4369088 | 2022-07-24 04:20:47 | Gray, Kansas, US | |
901457 | 901457 | 2022-07-22 | US | Kansas | Gray | 20069 | 1252 | 22 | 0 | 37.73836671 | -100.4369088 | 2022-07-23 04:20:53 | Gray, Kansas, US | |
671593 | 671593 | 2022-07-21 | US | Kansas | Gray | 20069 | 1252 | 22 | 0 | 37.73836671 | -100.4369088 | 2022-07-22 04:21:15 | Gray, Kansas, US | |
1609556 | 1609556 | 2022-07-20 | US | Kansas | Gray | 20069 | 1252 | 22 | 0 | 37.73836671 | -100.4369088 | 2022-07-21 04:21:10 | Gray, Kansas, US | |
1201545 | 1201545 | 2022-07-06 | US | Minnesota | Lincoln | 27081 | 1252 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-07 04:20:55 | Lincoln, Minnesota, US | |
3968288 | 3968288 | 2022-07-05 | US | Minnesota | Lincoln | 27081 | 1252 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-06 04:20:58 | Lincoln, Minnesota, US | |
3079799 | 3079799 | 2022-07-04 | US | Minnesota | Lincoln | 27081 | 1252 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-05 04:20:45 | Lincoln, Minnesota, US | |
1769081 | 1769081 | 2022-07-03 | US | Minnesota | Lincoln | 27081 | 1252 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-04 04:20:54 | Lincoln, Minnesota, US | |
3367067 | 3367067 | 2022-07-02 | US | Minnesota | Lincoln | 27081 | 1252 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-03 04:20:59 | Lincoln, Minnesota, US | |
595396 | 595396 | 2022-07-01 | US | Minnesota | Lincoln | 27081 | 1252 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-02 04:21:16 | Lincoln, Minnesota, US | |
3941797 | 3941797 | 2022-06-30 | US | Minnesota | Lincoln | 27081 | 1252 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-07-01 04:21:10 | Lincoln, Minnesota, US | |
2491755 | 2491755 | 2022-06-29 | US | Minnesota | Lincoln | 27081 | 1252 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-06-30 04:21:01 | Lincoln, Minnesota, US | |
941935 | 941935 | 2022-06-25 | US | Texas | Hemphill | 48211 | 1252 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-06-26 04:21:02 | Hemphill, Texas, US | |
3349755 | 3349755 | 2022-06-24 | US | Texas | Hemphill | 48211 | 1252 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-06-25 04:20:57 | Hemphill, Texas, US | |
2190831 | 2190831 | 2022-06-22 | US | Texas | San Saba | 48411 | 1252 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-06-23 04:20:55 | San Saba, Texas, US | |
3142237 | 3142237 | 2022-06-11 | US | Colorado | Saguache | 8109 | 1252 | 12 | 0 | 38.08054629 | -106.282466 | 2022-06-12 04:20:53 | Saguache, Colorado, US | |
1945153 | 1945153 | 2022-06-10 | US | Colorado | Saguache | 8109 | 1252 | 12 | 0 | 38.08054629 | -106.282466 | 2022-06-11 04:21:01 | Saguache, Colorado, US | |
3538673 | 3538673 | 2022-05-10 | US | Texas | Sabine | 48403 | 1252 | 89 | 0 | 31.34318809 | -93.85440451 | 2022-05-11 04:20:48 | Sabine, Texas, US | |
3919327 | 3919327 | 2022-05-01 | US | Vermont | Unassigned | 90050 | 1252 | 1 | 0 | 44.85627605 | 0.0 | 2022-05-02 04:21:10 | Unassigned, Vermont, US | |
2844131 | 2844131 | 2022-04-30 | US | Vermont | Unassigned | 90050 | 1252 | 1 | 0 | 44.85627605 | 0.0 | 2022-05-01 04:20:57 | Unassigned, Vermont, US | |
1160444 | 1160444 | 2022-04-29 | US | Vermont | Unassigned | 90050 | 1252 | 1 | 0 | 44.85627605 | 0.0 | 2022-04-30 04:21:05 | Unassigned, Vermont, US | |
2254157 | 2254157 | 2022-04-19 | US | Puerto Rico | Ceiba | 72037 | 1252 | 0 | 0 | 18.251818 | -65.666416 | 2022-04-20 04:20:45 | Ceiba, Puerto Rico, US | |
1848707 | 1848707 | 2022-04-18 | US | Puerto Rico | Ceiba | 72037 | 1252 | 0 | 0 | 18.251818 | -65.666416 | 2022-04-19 04:21:00 | Ceiba, Puerto Rico, US | |
877210 | 877210 | 2022-03-27 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-28 04:20:33 | Lemhi, Idaho, US | |
2164493 | 2164493 | 2022-03-26 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-27 04:20:47 | Lemhi, Idaho, US | |
1721429 | 1721429 | 2022-03-25 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-26 04:20:23 | Lemhi, Idaho, US | |
1469046 | 1469046 | 2022-03-24 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-25 04:20:46 | Lemhi, Idaho, US | |
1469147 | 1469147 | 2022-03-24 | US | Illinois | Scott | 17171 | 1252 | 11 | 0 | 39.642916899999996 | -90.47814431 | 2022-03-25 04:20:46 | Scott, Illinois, US | |
3023220 | 3023220 | 2022-03-23 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-24 04:20:43 | Lemhi, Idaho, US | |
1906142 | 1906142 | 2022-03-22 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-23 04:20:48 | Lemhi, Idaho, US | |
3239273 | 3239273 | 2022-03-21 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-22 04:20:54 | Lemhi, Idaho, US | |
25346 | 25346 | 2022-03-20 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-21 04:20:50 | Lemhi, Idaho, US | |
1657356 | 1657356 | 2022-03-19 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-20 04:20:45 | Lemhi, Idaho, US | |
336882 | 336882 | 2022-03-18 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-19 04:20:47 | Lemhi, Idaho, US | |
695335 | 695335 | 2022-03-17 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-18 04:20:55 | Lemhi, Idaho, US | |
697485 | 697485 | 2022-03-17 | US | Texas | Garza | 48169 | 1252 | 27 | 0 | 33.17969345 | -101.2984114 | 2022-03-18 04:20:55 | Garza, Texas, US | |
2320278 | 2320278 | 2022-03-16 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-17 04:20:56 | Lemhi, Idaho, US | |
2322428 | 2322428 | 2022-03-16 | US | Texas | Garza | 48169 | 1252 | 27 | 0 | 33.17969345 | -101.2984114 | 2022-03-17 04:20:56 | Garza, Texas, US | |
262478 | 262478 | 2022-03-15 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-16 04:20:50 | Lemhi, Idaho, US | |
264860 | 264860 | 2022-03-15 | US | Virginia | Cumberland | 51049 | 1252 | 24 | 0 | 37.51328851 | -78.24398086 | 2022-03-16 04:20:50 | Cumberland, Virginia, US | |
2264837 | 2264837 | 2022-03-14 | US | Idaho | Lemhi | 16059 | 1252 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-03-15 04:20:47 | Lemhi, Idaho, US | |
1363315 | 1363315 | 2022-02-08 | US | Illinois | Alexander | 17003 | 1252 | 13 | 0 | 37.18049267 | -89.32910838 | 2022-02-09 04:21:04 | Alexander, Illinois, US | |
460827 | 460827 | 2022-02-02 | US | Kentucky | Menifee | 21165 | 1252 | 29 | 0 | 37.94090733 | -83.59985712 | 2022-02-03 04:21:21 | Menifee, Kentucky, US | |
981690 | 981690 | 2022-02-01 | US | Puerto Rico | Guanica | 72055 | 1252 | 0 | 0 | 17.982429 | -66.91964300000001 | 2022-02-02 04:21:09 | Guanica, Puerto Rico, US | |
2660532 | 2660532 | 2022-01-31 | US | Puerto Rico | Guanica | 72055 | 1252 | 0 | 0 | 17.982429 | -66.91964300000001 | 2022-02-01 04:21:11 | Guanica, Puerto Rico, US | |
3303092 | 3303092 | 2022-01-30 | US | South Dakota | Kingsbury | 46077 | 1252 | 20 | 0 | 44.36956169 | -97.4913945 | 2022-01-31 04:21:09 | Kingsbury, South Dakota, US | |
3064883 | 3064883 | 2022-01-29 | US | South Dakota | Kingsbury | 46077 | 1252 | 20 | 0 | 44.36956169 | -97.4913945 | 2022-01-30 04:21:26 | Kingsbury, South Dakota, US | |
3812817 | 3812817 | 2022-01-28 | US | South Dakota | Kingsbury | 46077 | 1252 | 20 | 0 | 44.36956169 | -97.4913945 | 2022-01-29 04:21:10 | Kingsbury, South Dakota, US | |
1321111 | 1321111 | 2022-01-26 | US | South Dakota | Moody | 46101 | 1252 | 26 | 0 | 44.02266214 | -96.67081159 | 2022-01-27 04:21:19 | Moody, South Dakota, US | |
2053215 | 2053215 | 2022-01-25 | US | Kansas | Phillips | 20147 | 1252 | 28 | 0 | 39.78465501 | -99.34668865 | 2022-01-26 04:21:07 | Phillips, Kansas, US | |
1228946 | 1228946 | 2022-01-24 | US | Kansas | Phillips | 20147 | 1252 | 28 | 0 | 39.78465501 | -99.34668865 | 2022-01-25 04:21:05 | Phillips, Kansas, US | |
1142035 | 1142035 | 2022-01-23 | US | Indiana | Ohio | 18115 | 1252 | 16 | 0 | 38.955304999999996 | -84.96515993 | 2022-01-24 04:21:12 | Ohio, Indiana, US | |
2833953 | 2833953 | 2022-01-22 | US | Indiana | Ohio | 18115 | 1252 | 16 | 0 | 38.955304999999996 | -84.96515993 | 2022-01-23 04:21:13 | Ohio, Indiana, US | |
3426071 | 3426071 | 2022-01-21 | US | Indiana | Ohio | 18115 | 1252 | 16 | 0 | 38.955304999999996 | -84.96515993 | 2022-01-22 04:21:13 | Ohio, Indiana, US | |
1961424 | 1961424 | 2022-01-20 | US | Georgia | Randolph | 13243 | 1252 | 45 | 0 | 31.76622818 | -84.75732369 | 2022-01-21 04:21:09 | Randolph, Georgia, US | |
3688830 | 3688830 | 2022-01-13 | US | Kansas | Sherman | 20181 | 1252 | 18 | 0 | 39.35147699 | -101.71976240000001 | 2022-01-14 04:21:54 | Sherman, Kansas, 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]);