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 fips
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 | Shannon | Missouri | 29203 | 1609 | 40 | 8166 | 4898 | 197036 |
2022-05-13 | Shelby | Missouri | 29205 | 1603 | 15 | 5930 | 2529 | 270320 |
2022-05-13 | Stoddard | Missouri | 29207 | 6139 | 130 | 29025 | 4478 | 211507 |
2022-05-13 | Stone | Missouri | 29209 | 5829 | 122 | 31952 | 3818 | 182429 |
2022-05-13 | Sullivan | Missouri | 29211 | 1715 | 22 | 6089 | 3613 | 281655 |
2022-05-13 | Taney | Missouri | 29213 | 13382 | 226 | 55928 | 4040 | 239271 |
2022-05-13 | Texas | Missouri | 29215 | 4732 | 102 | 25398 | 4016 | 186313 |
2022-05-13 | Vernon | Missouri | 29217 | 5104 | 109 | 20563 | 5300 | 248212 |
2022-05-13 | Warren | Missouri | 29219 | 8200 | 102 | 35649 | 2861 | 230020 |
2022-05-13 | Washington | Missouri | 29221 | 6032 | 141 | 24730 | 5701 | 243914 |
2022-05-13 | Wayne | Missouri | 29223 | 2406 | 53 | 12873 | 4117 | 186902 |
2022-05-13 | Webster | Missouri | 29225 | 9053 | 148 | 39592 | 3738 | 228657 |
2022-05-13 | Worth | Missouri | 29227 | 407 | 3 | 2013 | 1490 | 202185 |
2022-05-13 | Wright | Missouri | 29229 | 3847 | 84 | 18289 | 4592 | 210345 |
2022-05-13 | St. Louis city | Missouri | 29510 | 58089 | 780 | 300576 | 2595 | 193258 |
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;