latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8 rows where deaths = 138 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 | Elko | Nevada | 32007 | 11668 | 138 | 52778 | 2614 | 221076 |
2022-05-13 | Harrison | Indiana | 18061 | 10889 | 138 | 40515 | 3406 | 268764 |
2022-05-13 | Jefferson | New York | 36045 | 21422 | 138 | 109834 | 1256 | 195039 |
2022-05-13 | Lincoln | Missouri | 29113 | 15187 | 138 | 59013 | 2338 | 257350 |
2022-05-13 | Morgan | Colorado | 8087 | 5735 | 138 | 29068 | 4747 | 197295 |
2022-05-13 | Ottawa | Ohio | 39123 | 8618 | 138 | 40525 | 3405 | 212658 |
2022-05-13 | Pulaski | Virginia | 51155 | 7343 | 138 | 34027 | 4055 | 215799 |
2022-05-13 | Ripley | Indiana | 18137 | 8360 | 138 | 28324 | 4872 | 295156 |
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;