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 fips
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 | Washington | Kansas | 20201 | 1400 | 22 | 5406 | 4069 | 258971 |
2022-05-13 | Wichita | Kansas | 20203 | 493 | 8 | 2119 | 3775 | 232656 |
2022-05-13 | Wilson | Kansas | 20205 | 2828 | 43 | 8525 | 5043 | 331730 |
2022-05-13 | Woodson | Kansas | 20207 | 796 | 15 | 3138 | 4780 | 253664 |
2022-05-13 | Wyandotte | Kansas | 20209 | 47365 | 508 | 165429 | 3070 | 286316 |
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;