latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where state = "Missouri" sorted by cases_per_million
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Missouri · 115 ✖
date | county | state | fips | cases | deaths | population | deaths_per_million | cases_per_million ▼ |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Shelby | Missouri | 29205 | 1603 | 15 | 5930 | 2529 | 270320 |
2022-05-13 | Callaway | Missouri | 29027 | 12150 | 130 | 44743 | 2905 | 271550 |
2022-05-13 | Andrew | Missouri | 29003 | 4828 | 58 | 17712 | 3274 | 272583 |
2022-05-13 | Nodaway | Missouri | 29147 | 6089 | 44 | 22092 | 1991 | 275620 |
2022-05-13 | Saline | Missouri | 29195 | 6288 | 107 | 22761 | 4701 | 276262 |
2022-05-13 | Sullivan | Missouri | 29211 | 1715 | 22 | 6089 | 3613 | 281655 |
2022-05-13 | Marion | Missouri | 29127 | 8051 | 118 | 28530 | 4135 | 282194 |
2022-05-13 | St. Francois | Missouri | 29187 | 19117 | 296 | 67215 | 4403 | 284415 |
2022-05-13 | Buchanan | Missouri | 29021 | 24863 | 318 | 87364 | 3639 | 284590 |
2022-05-13 | Lewis | Missouri | 29111 | 2796 | 36 | 9776 | 3682 | 286006 |
2022-05-13 | Scott | Missouri | 29201 | 11133 | 161 | 38280 | 4205 | 290830 |
2022-05-13 | Pettis | Missouri | 29159 | 12392 | 168 | 42339 | 3967 | 292685 |
2022-05-13 | New Madrid | Missouri | 29143 | 5036 | 86 | 17076 | 5036 | 294916 |
2022-05-13 | Madison | Missouri | 29123 | 3622 | 57 | 12088 | 4715 | 299636 |
2022-05-13 | Gentry | Missouri | 29075 | 2172 | 31 | 6571 | 4717 | 330543 |
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;