johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29,774 rows where province_or_state = "Alaska" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, latitude, combined_key, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753321 | 2753321 | 2022-12-29 | US | Alaska | Aleutians East | 2013 | 1321 | 5 | 0 | 55.32222414 | -161.9722021 | 2022-12-30 04:21:04 | Aleutians East, Alaska, US | |
2753322 | 2753322 | 2022-12-29 | US | Alaska | Aleutians West | 2016 | 1897 | 3 | 0 | 52.3233 | -174.1596 | 2022-12-30 04:21:04 | Aleutians West, Alaska, US | |
2753323 | 2753323 | 2022-12-29 | US | Alaska | Anchorage | 2020 | 122244 | 598 | 0 | 61.14998174 | -149.1426986 | 2022-12-30 04:21:04 | Anchorage, Alaska, US | |
2753324 | 2753324 | 2022-12-29 | US | Alaska | Bethel | 2050 | 12469 | 47 | 0 | 60.90980451 | -159.8561831 | 2022-12-30 04:21:04 | Bethel, Alaska, US | |
2753325 | 2753325 | 2022-12-29 | US | Alaska | Bristol Bay | 2060 | 0 | 0 | 0 | 58.74513976 | -156.701064 | 2022-12-30 04:21:04 | Bristol Bay, Alaska, US | |
2753326 | 2753326 | 2022-12-29 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1222 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-12-30 04:21:04 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2753327 | 2753327 | 2022-12-29 | US | Alaska | Chugach | 2063 | 2390 | 13 | 0 | 61.16666 | -149.9 | 2022-12-30 04:21:04 | Chugach, Alaska, US | |
2753328 | 2753328 | 2022-12-29 | US | Alaska | Copper River | 2066 | 1292 | 10 | 0 | 60.3886 | -162.8905196 | 2022-12-30 04:21:04 | Copper River, Alaska, US | |
2753329 | 2753329 | 2022-12-29 | US | Alaska | Denali | 2068 | 1800 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-12-30 04:21:04 | Denali, Alaska, US | |
2753330 | 2753330 | 2022-12-29 | US | Alaska | Dillingham | 2070 | 2214 | 13 | 0 | 59.79603738 | -158.2381942 | 2022-12-30 04:21:04 | Dillingham, Alaska, US | |
2753331 | 2753331 | 2022-12-29 | US | Alaska | Fairbanks North Star | 2090 | 33091 | 166 | 0 | 64.80726247 | -146.5692662 | 2022-12-30 04:21:04 | Fairbanks North Star, Alaska, US | |
2753332 | 2753332 | 2022-12-29 | US | Alaska | Haines | 2100 | 789 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-12-30 04:21:04 | Haines, Alaska, US | |
2753333 | 2753333 | 2022-12-29 | US | Alaska | Juneau | 2110 | 11751 | 29 | 0 | 58.45031811 | -134.200436 | 2022-12-30 04:21:04 | Juneau, Alaska, US | |
2753334 | 2753334 | 2022-12-29 | US | Alaska | Kenai Peninsula | 2122 | 22334 | 126 | 0 | 60.24429722 | -151.5388884 | 2022-12-30 04:21:04 | Kenai Peninsula, Alaska, US | |
2753335 | 2753335 | 2022-12-29 | US | Alaska | Ketchikan Gateway | 2130 | 5093 | 27 | 0 | 55.57445008 | -130.975561 | 2022-12-30 04:21:04 | Ketchikan Gateway, Alaska, US | |
2753336 | 2753336 | 2022-12-29 | US | Alaska | Kodiak Island | 2150 | 5771 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-12-30 04:21:04 | Kodiak Island, Alaska, US | |
2753337 | 2753337 | 2022-12-29 | US | Alaska | Kusilvak | 2158 | 4766 | 15 | 0 | 62.1542916 | -163.3967883 | 2022-12-30 04:21:04 | Kusilvak, Alaska, US | |
2753338 | 2753338 | 2022-12-29 | US | Alaska | Matanuska-Susitna | 2170 | 40324 | 276 | 0 | 62.31305045 | -149.5741743 | 2022-12-30 04:21:04 | Matanuska-Susitna, Alaska, US | |
2753339 | 2753339 | 2022-12-29 | US | Alaska | Nome | 2180 | 6953 | 7 | 0 | 64.90320724 | -164.0353804 | 2022-12-30 04:21:04 | Nome, Alaska, US | |
2753340 | 2753340 | 2022-12-29 | US | Alaska | North Slope | 2185 | 5291 | 17 | 0 | 69.31479216 | -153.4836093 | 2022-12-30 04:21:04 | North Slope, Alaska, US | |
2753341 | 2753341 | 2022-12-29 | US | Alaska | Northwest Arctic | 2188 | 5696 | 21 | 0 | 67.04919196 | -159.7503946 | 2022-12-30 04:21:04 | Northwest Arctic, Alaska, US | |
2753342 | 2753342 | 2022-12-29 | US | Alaska | Petersburg | 2195 | 920 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-12-30 04:21:04 | Petersburg, Alaska, US | |
2753343 | 2753343 | 2022-12-29 | US | Alaska | Prince of Wales-Hyder | 2198 | 1805 | 10 | 0 | 55.76261984 | -133.0511621 | 2022-12-30 04:21:04 | Prince of Wales-Hyder, Alaska, US | |
2753344 | 2753344 | 2022-12-29 | US | Alaska | Sitka | 2220 | 3442 | 10 | 0 | 57.24124555 | -135.3206587 | 2022-12-30 04:21:04 | Sitka, Alaska, US | |
2753345 | 2753345 | 2022-12-29 | US | Alaska | Skagway | 2230 | 675 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-12-30 04:21:04 | Skagway, Alaska, US | |
2753346 | 2753346 | 2022-12-29 | US | Alaska | Southeast Fairbanks | 2240 | 2442 | 21 | 0 | 63.87692095 | -143.2127643 | 2022-12-30 04:21:04 | Southeast Fairbanks, Alaska, US | |
2753347 | 2753347 | 2022-12-29 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Alaska, US | |
2753348 | 2753348 | 2022-12-29 | US | Alaska | Valdez-Cordova | 2261 | 0 | 0 | 0 | 61.47502768 | -144.7126799 | 2022-12-30 04:21:04 | Valdez-Cordova, Alaska, US | |
2753349 | 2753349 | 2022-12-29 | US | Alaska | Wrangell | 2275 | 775 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-30 04:21:04 | Wrangell, Alaska, US | |
2753350 | 2753350 | 2022-12-29 | US | Alaska | Yakutat | 2282 | 954 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-30 04:21:04 | Yakutat, Alaska, US | |
2753351 | 2753351 | 2022-12-29 | US | Alaska | Yukon-Koyukuk | 2290 | 1705 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-12-30 04:21:04 | Yukon-Koyukuk, Alaska, US | |
1074327 | 1074327 | 2022-12-28 | US | Alaska | Aleutians East | 2013 | 1321 | 5 | 0 | 55.32222414 | -161.9722021 | 2022-12-29 04:21:01 | Aleutians East, Alaska, US | |
1074328 | 1074328 | 2022-12-28 | US | Alaska | Aleutians West | 2016 | 1897 | 3 | 0 | 52.3233 | -174.1596 | 2022-12-29 04:21:01 | Aleutians West, Alaska, US | |
1074329 | 1074329 | 2022-12-28 | US | Alaska | Anchorage | 2020 | 122244 | 598 | 0 | 61.14998174 | -149.1426986 | 2022-12-29 04:21:01 | Anchorage, Alaska, US | |
1074330 | 1074330 | 2022-12-28 | US | Alaska | Bethel | 2050 | 12469 | 47 | 0 | 60.90980451 | -159.8561831 | 2022-12-29 04:21:01 | Bethel, Alaska, US | |
1074331 | 1074331 | 2022-12-28 | US | Alaska | Bristol Bay | 2060 | 0 | 0 | 0 | 58.74513976 | -156.701064 | 2022-12-29 04:21:01 | Bristol Bay, Alaska, US | |
1074332 | 1074332 | 2022-12-28 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1222 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-12-29 04:21:01 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1074333 | 1074333 | 2022-12-28 | US | Alaska | Chugach | 2063 | 2390 | 13 | 0 | 61.16666 | -149.9 | 2022-12-29 04:21:01 | Chugach, Alaska, US | |
1074334 | 1074334 | 2022-12-28 | US | Alaska | Copper River | 2066 | 1292 | 10 | 0 | 60.3886 | -162.8905196 | 2022-12-29 04:21:01 | Copper River, Alaska, US | |
1074335 | 1074335 | 2022-12-28 | US | Alaska | Denali | 2068 | 1800 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-12-29 04:21:01 | Denali, Alaska, US | |
1074336 | 1074336 | 2022-12-28 | US | Alaska | Dillingham | 2070 | 2214 | 13 | 0 | 59.79603738 | -158.2381942 | 2022-12-29 04:21:01 | Dillingham, Alaska, US | |
1074337 | 1074337 | 2022-12-28 | US | Alaska | Fairbanks North Star | 2090 | 33091 | 166 | 0 | 64.80726247 | -146.5692662 | 2022-12-29 04:21:01 | Fairbanks North Star, Alaska, US | |
1074338 | 1074338 | 2022-12-28 | US | Alaska | Haines | 2100 | 789 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-12-29 04:21:01 | Haines, Alaska, US | |
1074339 | 1074339 | 2022-12-28 | US | Alaska | Juneau | 2110 | 11751 | 29 | 0 | 58.45031811 | -134.200436 | 2022-12-29 04:21:01 | Juneau, Alaska, US | |
1074340 | 1074340 | 2022-12-28 | US | Alaska | Kenai Peninsula | 2122 | 22334 | 126 | 0 | 60.24429722 | -151.5388884 | 2022-12-29 04:21:01 | Kenai Peninsula, Alaska, US | |
1074341 | 1074341 | 2022-12-28 | US | Alaska | Ketchikan Gateway | 2130 | 5093 | 27 | 0 | 55.57445008 | -130.975561 | 2022-12-29 04:21:01 | Ketchikan Gateway, Alaska, US | |
1074342 | 1074342 | 2022-12-28 | US | Alaska | Kodiak Island | 2150 | 5771 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-12-29 04:21:01 | Kodiak Island, Alaska, US | |
1074343 | 1074343 | 2022-12-28 | US | Alaska | Kusilvak | 2158 | 4766 | 15 | 0 | 62.1542916 | -163.3967883 | 2022-12-29 04:21:01 | Kusilvak, Alaska, US | |
1074344 | 1074344 | 2022-12-28 | US | Alaska | Matanuska-Susitna | 2170 | 40324 | 276 | 0 | 62.31305045 | -149.5741743 | 2022-12-29 04:21:01 | Matanuska-Susitna, Alaska, US | |
1074345 | 1074345 | 2022-12-28 | US | Alaska | Nome | 2180 | 6953 | 7 | 0 | 64.90320724 | -164.0353804 | 2022-12-29 04:21:01 | Nome, Alaska, US | |
1074346 | 1074346 | 2022-12-28 | US | Alaska | North Slope | 2185 | 5291 | 17 | 0 | 69.31479216 | -153.4836093 | 2022-12-29 04:21:01 | North Slope, Alaska, US | |
1074347 | 1074347 | 2022-12-28 | US | Alaska | Northwest Arctic | 2188 | 5696 | 21 | 0 | 67.04919196 | -159.7503946 | 2022-12-29 04:21:01 | Northwest Arctic, Alaska, US | |
1074348 | 1074348 | 2022-12-28 | US | Alaska | Petersburg | 2195 | 920 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-12-29 04:21:01 | Petersburg, Alaska, US | |
1074349 | 1074349 | 2022-12-28 | US | Alaska | Prince of Wales-Hyder | 2198 | 1805 | 10 | 0 | 55.76261984 | -133.0511621 | 2022-12-29 04:21:01 | Prince of Wales-Hyder, Alaska, US | |
1074350 | 1074350 | 2022-12-28 | US | Alaska | Sitka | 2220 | 3442 | 10 | 0 | 57.24124555 | -135.3206587 | 2022-12-29 04:21:01 | Sitka, Alaska, US | |
1074351 | 1074351 | 2022-12-28 | US | Alaska | Skagway | 2230 | 675 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-12-29 04:21:01 | Skagway, Alaska, US | |
1074352 | 1074352 | 2022-12-28 | US | Alaska | Southeast Fairbanks | 2240 | 2442 | 21 | 0 | 63.87692095 | -143.2127643 | 2022-12-29 04:21:01 | Southeast Fairbanks, Alaska, US | |
1074353 | 1074353 | 2022-12-28 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Alaska, US | |
1074354 | 1074354 | 2022-12-28 | US | Alaska | Valdez-Cordova | 2261 | 0 | 0 | 0 | 61.47502768 | -144.7126799 | 2022-12-29 04:21:01 | Valdez-Cordova, Alaska, US | |
1074355 | 1074355 | 2022-12-28 | US | Alaska | Wrangell | 2275 | 775 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-29 04:21:01 | Wrangell, Alaska, US | |
1074356 | 1074356 | 2022-12-28 | US | Alaska | Yakutat | 2282 | 954 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-29 04:21:01 | Yakutat, Alaska, US | |
1074357 | 1074357 | 2022-12-28 | US | Alaska | Yukon-Koyukuk | 2290 | 1705 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-12-29 04:21:01 | Yukon-Koyukuk, Alaska, US | |
328324 | 328324 | 2022-12-27 | US | Alaska | Aleutians East | 2013 | 1321 | 5 | 0 | 55.32222414 | -161.9722021 | 2022-12-28 04:21:04 | Aleutians East, Alaska, US | |
328325 | 328325 | 2022-12-27 | US | Alaska | Aleutians West | 2016 | 1897 | 3 | 0 | 52.3233 | -174.1596 | 2022-12-28 04:21:04 | Aleutians West, Alaska, US | |
328326 | 328326 | 2022-12-27 | US | Alaska | Anchorage | 2020 | 122244 | 598 | 0 | 61.14998174 | -149.1426986 | 2022-12-28 04:21:04 | Anchorage, Alaska, US | |
328327 | 328327 | 2022-12-27 | US | Alaska | Bethel | 2050 | 12469 | 47 | 0 | 60.90980451 | -159.8561831 | 2022-12-28 04:21:04 | Bethel, Alaska, US | |
328328 | 328328 | 2022-12-27 | US | Alaska | Bristol Bay | 2060 | 0 | 0 | 0 | 58.74513976 | -156.701064 | 2022-12-28 04:21:04 | Bristol Bay, Alaska, US | |
328329 | 328329 | 2022-12-27 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1222 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-12-28 04:21:04 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
328330 | 328330 | 2022-12-27 | US | Alaska | Chugach | 2063 | 2390 | 13 | 0 | 61.16666 | -149.9 | 2022-12-28 04:21:04 | Chugach, Alaska, US | |
328331 | 328331 | 2022-12-27 | US | Alaska | Copper River | 2066 | 1292 | 10 | 0 | 60.3886 | -162.8905196 | 2022-12-28 04:21:04 | Copper River, Alaska, US | |
328332 | 328332 | 2022-12-27 | US | Alaska | Denali | 2068 | 1800 | 2 | 0 | 63.67264044 | -150.0076108 | 2022-12-28 04:21:04 | Denali, Alaska, US | |
328333 | 328333 | 2022-12-27 | US | Alaska | Dillingham | 2070 | 2214 | 13 | 0 | 59.79603738 | -158.2381942 | 2022-12-28 04:21:04 | Dillingham, Alaska, US | |
328334 | 328334 | 2022-12-27 | US | Alaska | Fairbanks North Star | 2090 | 33091 | 166 | 0 | 64.80726247 | -146.5692662 | 2022-12-28 04:21:04 | Fairbanks North Star, Alaska, US | |
328335 | 328335 | 2022-12-27 | US | Alaska | Haines | 2100 | 789 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-12-28 04:21:04 | Haines, Alaska, US | |
328336 | 328336 | 2022-12-27 | US | Alaska | Juneau | 2110 | 11751 | 29 | 0 | 58.45031811 | -134.200436 | 2022-12-28 04:21:04 | Juneau, Alaska, US | |
328337 | 328337 | 2022-12-27 | US | Alaska | Kenai Peninsula | 2122 | 22334 | 126 | 0 | 60.24429722 | -151.5388884 | 2022-12-28 04:21:04 | Kenai Peninsula, Alaska, US | |
328338 | 328338 | 2022-12-27 | US | Alaska | Ketchikan Gateway | 2130 | 5093 | 27 | 0 | 55.57445008 | -130.975561 | 2022-12-28 04:21:04 | Ketchikan Gateway, Alaska, US | |
328339 | 328339 | 2022-12-27 | US | Alaska | Kodiak Island | 2150 | 5771 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-12-28 04:21:04 | Kodiak Island, Alaska, US | |
328340 | 328340 | 2022-12-27 | US | Alaska | Kusilvak | 2158 | 4766 | 15 | 0 | 62.1542916 | -163.3967883 | 2022-12-28 04:21:04 | Kusilvak, Alaska, US | |
328341 | 328341 | 2022-12-27 | US | Alaska | Matanuska-Susitna | 2170 | 40324 | 276 | 0 | 62.31305045 | -149.5741743 | 2022-12-28 04:21:04 | Matanuska-Susitna, Alaska, US | |
328342 | 328342 | 2022-12-27 | US | Alaska | Nome | 2180 | 6953 | 7 | 0 | 64.90320724 | -164.0353804 | 2022-12-28 04:21:04 | Nome, Alaska, US | |
328343 | 328343 | 2022-12-27 | US | Alaska | North Slope | 2185 | 5291 | 17 | 0 | 69.31479216 | -153.4836093 | 2022-12-28 04:21:04 | North Slope, Alaska, US | |
328344 | 328344 | 2022-12-27 | US | Alaska | Northwest Arctic | 2188 | 5696 | 21 | 0 | 67.04919196 | -159.7503946 | 2022-12-28 04:21:04 | Northwest Arctic, Alaska, US | |
328345 | 328345 | 2022-12-27 | US | Alaska | Petersburg | 2195 | 920 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-12-28 04:21:04 | Petersburg, Alaska, US | |
328346 | 328346 | 2022-12-27 | US | Alaska | Prince of Wales-Hyder | 2198 | 1805 | 10 | 0 | 55.76261984 | -133.0511621 | 2022-12-28 04:21:04 | Prince of Wales-Hyder, Alaska, US | |
328347 | 328347 | 2022-12-27 | US | Alaska | Sitka | 2220 | 3442 | 10 | 0 | 57.24124555 | -135.3206587 | 2022-12-28 04:21:04 | Sitka, Alaska, US | |
328348 | 328348 | 2022-12-27 | US | Alaska | Skagway | 2230 | 675 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-12-28 04:21:04 | Skagway, Alaska, US | |
328349 | 328349 | 2022-12-27 | US | Alaska | Southeast Fairbanks | 2240 | 2442 | 21 | 0 | 63.87692095 | -143.2127643 | 2022-12-28 04:21:04 | Southeast Fairbanks, Alaska, US | |
328350 | 328350 | 2022-12-27 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Alaska, US | |
328351 | 328351 | 2022-12-27 | US | Alaska | Valdez-Cordova | 2261 | 0 | 0 | 0 | 61.47502768 | -144.7126799 | 2022-12-28 04:21:04 | Valdez-Cordova, Alaska, US | |
328352 | 328352 | 2022-12-27 | US | Alaska | Wrangell | 2275 | 775 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-28 04:21:04 | Wrangell, Alaska, US | |
328353 | 328353 | 2022-12-27 | US | Alaska | Yakutat | 2282 | 954 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-28 04:21:04 | Yakutat, Alaska, US | |
328354 | 328354 | 2022-12-27 | US | Alaska | Yukon-Koyukuk | 2290 | 1705 | 12 | 0 | 65.50815459 | -151.3907387 | 2022-12-28 04:21:04 | Yukon-Koyukuk, Alaska, US | |
218397 | 218397 | 2022-12-26 | US | Alaska | Aleutians East | 2013 | 1321 | 5 | 0 | 55.32222414 | -161.9722021 | 2022-12-27 04:21:07 | Aleutians East, Alaska, US | |
218398 | 218398 | 2022-12-26 | US | Alaska | Aleutians West | 2016 | 1895 | 3 | 0 | 52.3233 | -174.1596 | 2022-12-27 04:21:07 | Aleutians West, Alaska, US | |
218399 | 218399 | 2022-12-26 | US | Alaska | Anchorage | 2020 | 122101 | 598 | 0 | 61.14998174 | -149.1426986 | 2022-12-27 04:21:07 | Anchorage, Alaska, US | |
218400 | 218400 | 2022-12-26 | US | Alaska | Bethel | 2050 | 12439 | 47 | 0 | 60.90980451 | -159.8561831 | 2022-12-27 04:21:07 | Bethel, Alaska, US | |
218401 | 218401 | 2022-12-26 | US | Alaska | Bristol Bay | 2060 | 0 | 0 | 0 | 58.74513976 | -156.701064 | 2022-12-27 04:21:07 | Bristol Bay, Alaska, US | |
218402 | 218402 | 2022-12-26 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1222 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-12-27 04:21:07 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
218403 | 218403 | 2022-12-26 | US | Alaska | Chugach | 2063 | 2389 | 13 | 0 | 61.16666 | -149.9 | 2022-12-27 04:21:07 | Chugach, Alaska, 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]);