latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where deaths = 55 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 12
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Caldwell | Louisiana | 22021 | 3625 | 55 | 9918 | 5545 | 365497 |
2022-05-13 | Catahoula | Louisiana | 22025 | 2700 | 55 | 9494 | 5793 | 284390 |
2022-05-13 | Converse | Wyoming | 56009 | 3144 | 55 | 13822 | 3979 | 227463 |
2022-05-13 | Craig | Oklahoma | 40035 | 4785 | 55 | 14142 | 3889 | 338353 |
2022-05-13 | Crawford | Georgia | 13079 | 1780 | 55 | 12404 | 4434 | 143502 |
2022-05-13 | Emporia city | Virginia | 51595 | 1187 | 55 | 5346 | 10288 | 222035 |
2022-05-13 | Gooding | Idaho | 16047 | 3297 | 55 | 15179 | 3623 | 217207 |
2022-05-13 | Leelanau | Michigan | 26089 | 3697 | 55 | 21761 | 2527 | 169891 |
2022-05-13 | Montgomery | Iowa | 19137 | 2216 | 55 | 9917 | 5546 | 223454 |
2022-05-13 | Rusk | Wisconsin | 55107 | 3465 | 55 | 14178 | 3879 | 244392 |
2022-05-13 | Vinton | Ohio | 39163 | 2918 | 55 | 13085 | 4203 | 223003 |
2022-05-13 | Wadena | Minnesota | 27159 | 4261 | 55 | 13682 | 4019 | 311431 |
2022-05-13 | Zapata | Texas | 48505 | 3752 | 55 | 14179 | 3878 | 264616 |
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;