latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where "date" is on date 2022-05-13 and state = "Arizona" sorted by cases_per_million descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Arizona · 15 ✖
date | county | state | fips | cases | deaths | population | deaths_per_million | cases_per_million ▲ |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Santa Cruz | Arizona | 4023 | 16683 | 232 | 46498 | 4989 | 358789 |
2022-05-13 | Navajo | Arizona | 4017 | 38394 | 909 | 110924 | 8194 | 346128 |
2022-05-13 | Gila | Arizona | 4007 | 17398 | 381 | 54018 | 7053 | 322077 |
2022-05-13 | Apache | Arizona | 4001 | 22540 | 614 | 71887 | 8541 | 313547 |
2022-05-13 | Graham | Arizona | 4009 | 12051 | 177 | 38837 | 4557 | 310296 |
2022-05-13 | Coconino | Arizona | 4005 | 44091 | 478 | 143476 | 3331 | 307305 |
2022-05-13 | Yuma | Arizona | 4027 | 62751 | 1181 | 213787 | 5524 | 293521 |
2022-05-13 | Pinal | Arizona | 4021 | 132748 | 1666 | 462789 | 3599 | 286843 |
2022-05-13 | Maricopa | Arizona | 4013 | 1283590 | 17326 | 4485414 | 3862 | 286169 |
2022-05-13 | Mohave | Arizona | 4015 | 57631 | 1454 | 212181 | 6852 | 271612 |
2022-05-13 | Cochise | Arizona | 4003 | 31614 | 573 | 125922 | 4550 | 251060 |
2022-05-13 | La Paz | Arizona | 4012 | 5227 | 144 | 21108 | 6822 | 247631 |
2022-05-13 | Pima | Arizona | 4019 | 255688 | 3850 | 1047279 | 3676 | 244145 |
2022-05-13 | Greenlee | Arizona | 4011 | 2226 | 33 | 9498 | 3474 | 234365 |
2022-05-13 | Yavapai | Arizona | 4025 | 48293 | 1212 | 235099 | 5155 | 205415 |
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;