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 descending
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 | Caldwell | Missouri | 29025 | 1700 | 39 | 9020 | 4323 | 188470 |
2022-05-13 | Wayne | Missouri | 29223 | 2406 | 53 | 12873 | 4117 | 186902 |
2022-05-13 | Texas | Missouri | 29215 | 4732 | 102 | 25398 | 4016 | 186313 |
2022-05-13 | Reynolds | Missouri | 29179 | 1165 | 26 | 6270 | 4146 | 185805 |
2022-05-13 | Barry | Missouri | 29009 | 6648 | 132 | 35789 | 3688 | 185755 |
2022-05-13 | Maries | Missouri | 29125 | 1606 | 39 | 8697 | 4484 | 184661 |
2022-05-13 | Stone | Missouri | 29209 | 5829 | 122 | 31952 | 3818 | 182429 |
2022-05-13 | DeKalb | Missouri | 29063 | 2222 | 47 | 12547 | 3745 | 177094 |
2022-05-13 | Jasper | Missouri | 29097 | 20879 | 317 | 121328 | 2612 | 172087 |
2022-05-13 | Pulaski | Missouri | 29169 | 8918 | 116 | 52607 | 2205 | 169521 |
2022-05-13 | Schuyler | Missouri | 29197 | 740 | 26 | 4660 | 5579 | 158798 |
2022-05-13 | Scotland | Missouri | 29199 | 680 | 18 | 4902 | 3671 | 138718 |
2022-05-13 | Jackson | Missouri | 29095 | 97164 | 1217 | 703011 | 1731 | 138211 |
2022-05-13 | Clay | Missouri | 29047 | 27390 | 363 | 249948 | 1452 | 109582 |
2022-05-13 | Platte | Missouri | 29165 | 10580 | 102 | 104418 | 976 | 101323 |
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;