latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where state = "Kansas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Kansas · 105 ✖
date | county | state | fips | cases | deaths ▼ | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Saline | Kansas | 20169 | 14159 | 246 | 54224 | 4536 | 261120 |
2022-05-13 | Wyandotte | Kansas | 20209 | 47365 | 508 | 165429 | 3070 | 286316 |
2022-05-13 | Shawnee | Kansas | 20177 | 48858 | 633 | 176875 | 3578 | 276228 |
2022-05-13 | Johnson | Kansas | 20091 | 148890 | 1219 | 602401 | 2023 | 247160 |
2022-05-13 | Sedgwick | Kansas | 20173 | 145517 | 1424 | 516042 | 2759 | 281986 |
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;