latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6 rows where deaths = 150 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Bradford | Florida | 12007 | 7538 | 150 | 28201 | 5318 | 267295 |
2022-05-13 | DeSoto | Florida | 12027 | 9455 | 150 | 38001 | 3947 | 248809 |
2022-05-13 | Effingham | Illinois | 17049 | 10711 | 150 | 34008 | 4410 | 314955 |
2022-05-13 | Henry | Illinois | 17073 | 12884 | 150 | 48913 | 3066 | 263406 |
2022-05-13 | Pontotoc | Oklahoma | 40123 | 12132 | 150 | 38284 | 3918 | 316894 |
2022-05-13 | Union | South Carolina | 45087 | 7750 | 150 | 27316 | 5491 | 283716 |
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;