latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where state = "Alaska" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Alaska · 24 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Aleutians East Borough | Alaska | 2013 | 1101 | 3 | 3337 | 899 | 329937 |
2022-05-13 | Aleutians West Census Area | Alaska | 2016 | 1685 | 1 | 5634 | 177 | 299077 |
2022-05-13 | Anchorage | Alaska | 2020 | 105418 | 526 | 288000 | 1826 | 366034 |
2022-05-13 | Bethel Census Area | Alaska | 2050 | 10362 | 41 | 18386 | 2229 | 563580 |
2022-05-13 | Denali Borough | Alaska | 2068 | 424 | 1 | 2097 | 476 | 202193 |
2022-05-13 | Dillingham Census Area | Alaska | 2070 | 1932 | 11 | 4916 | 2237 | 393002 |
2022-05-13 | Fairbanks North Star Borough | Alaska | 2090 | 27763 | 142 | 96849 | 1466 | 286662 |
2022-05-13 | Haines Borough | Alaska | 2100 | 624 | 1 | 2530 | 395 | 246640 |
2022-05-13 | Juneau City and Borough | Alaska | 2110 | 8798 | 19 | 31974 | 594 | 275161 |
2022-05-13 | Kenai Peninsula Borough | Alaska | 2122 | 18091 | 101 | 58708 | 1720 | 308152 |
2022-05-13 | Ketchikan Gateway Borough | Alaska | 2130 | 4154 | 17 | 13901 | 1222 | 298827 |
2022-05-13 | Kodiak Island Borough | Alaska | 2150 | 4992 | 12 | 12998 | 923 | 384059 |
2022-05-13 | Matanuska-Susitna Borough | Alaska | 2170 | 34981 | 236 | 108317 | 2178 | 322950 |
2022-05-13 | Nome Census Area | Alaska | 2180 | 6245 | 5 | 10004 | 499 | 624250 |
2022-05-13 | North Slope Borough | Alaska | 2185 | 4468 | 11 | 9832 | 1118 | 454434 |
2022-05-13 | Northwest Arctic Borough | Alaska | 2188 | 4837 | 13 | 7621 | 1705 | 634693 |
2022-05-13 | Petersburg Borough | Alaska | 2195 | 785 | 4 | 3266 | 1224 | 240355 |
2022-05-13 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1454 | 8 | 6203 | 1289 | 234402 |
2022-05-13 | Sitka City and Borough | Alaska | 2220 | 2681 | 5 | 8493 | 588 | 315671 |
2022-05-13 | Skagway Municipality | Alaska | 2230 | 187 | 0 | 1183 | 0 | 158072 |
2022-05-13 | Southeast Fairbanks Census Area | Alaska | 2240 | 2052 | 20 | 6893 | 2901 | 297693 |
2022-05-13 | Valdez-Cordova Census Area | Alaska | 2261 | 2948 | 19 | 9202 | 2064 | 320365 |
2022-05-13 | Wrangell City and Borough | Alaska | 2275 | 579 | 1 | 2502 | 399 | 231414 |
2022-05-13 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1438 | 10 | 5230 | 1912 | 274952 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW latest_ny_times_counties_with_populations AS select ny_times_us_counties.date, ny_times_us_counties.county, ny_times_us_counties.state, ny_times_us_counties.fips, ny_times_us_counties.cases, ny_times_us_counties.deaths, us_census_county_populations_2019.population, 1000000 * ny_times_us_counties.deaths / us_census_county_populations_2019.population as deaths_per_million, 1000000 * ny_times_us_counties.cases / us_census_county_populations_2019.population as cases_per_million from ny_times_us_counties join us_census_county_populations_2019 on ny_times_us_counties.fips = us_census_county_populations_2019.fips where "date" = ( select max(date) from ny_times_us_counties ) order by deaths_per_million desc;