latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where state = "Washington" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Washington · 39 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Adams | Washington | 53001 | 4926 | 39 | 19983 | 1951 | 246509 |
2022-05-13 | Asotin | Washington | 53003 | 4554 | 66 | 22582 | 2922 | 201665 |
2022-05-13 | Benton | Washington | 53005 | 53006 | 472 | 204390 | 2309 | 259337 |
2022-05-13 | Chelan | Washington | 53007 | 20463 | 162 | 77200 | 2098 | 265064 |
2022-05-13 | Clallam | Washington | 53009 | 11901 | 141 | 77331 | 1823 | 153896 |
2022-05-13 | Clark | Washington | 53011 | 91435 | 804 | 488241 | 1646 | 187274 |
2022-05-13 | Columbia | Washington | 53013 | 613 | 16 | 3985 | 4015 | 153826 |
2022-05-13 | Cowlitz | Washington | 53015 | 23312 | 347 | 110593 | 3137 | 210790 |
2022-05-13 | Douglas | Washington | 53017 | 11269 | 70 | 43429 | 1611 | 259480 |
2022-05-13 | Ferry | Washington | 53019 | 1420 | 29 | 7627 | 3802 | 186180 |
2022-05-13 | Franklin | Washington | 53021 | 32668 | 214 | 95222 | 2247 | 343071 |
2022-05-13 | Garfield | Washington | 53023 | 389 | 7 | 2225 | 3146 | 174831 |
2022-05-13 | Grant | Washington | 53025 | 27251 | 259 | 97733 | 2650 | 278831 |
2022-05-13 | Grays Harbor | Washington | 53027 | 16620 | 198 | 75061 | 2637 | 221419 |
2022-05-13 | Island | Washington | 53029 | 10635 | 76 | 85141 | 892 | 124910 |
2022-05-13 | Jefferson | Washington | 53031 | 3198 | 29 | 32221 | 900 | 99252 |
2022-05-13 | King | Washington | 53033 | 410322 | 2774 | 2252782 | 1231 | 182140 |
2022-05-13 | Kitsap | Washington | 53035 | 41506 | 344 | 271473 | 1267 | 152891 |
2022-05-13 | Kittitas | Washington | 53037 | 8607 | 66 | 47935 | 1376 | 179555 |
2022-05-13 | Klickitat | Washington | 53039 | 3612 | 47 | 22425 | 2095 | 161070 |
2022-05-13 | Lewis | Washington | 53041 | 17798 | 254 | 80707 | 3147 | 220526 |
2022-05-13 | Lincoln | Washington | 53043 | 2224 | 28 | 10939 | 2559 | 203309 |
2022-05-13 | Mason | Washington | 53045 | 12661 | 139 | 66768 | 2081 | 189626 |
2022-05-13 | Okanogan | Washington | 53047 | 8660 | 125 | 42243 | 2959 | 205004 |
2022-05-13 | Pacific | Washington | 53049 | 3795 | 57 | 22471 | 2536 | 168884 |
2022-05-13 | Pend Oreille | Washington | 53051 | 2508 | 36 | 13724 | 2623 | 182745 |
2022-05-13 | Pierce | Washington | 53053 | 198375 | 1409 | 904980 | 1556 | 219203 |
2022-05-13 | San Juan | Washington | 53055 | 1450 | 2 | 17582 | 113 | 82470 |
2022-05-13 | Skagit | Washington | 53057 | 22747 | 204 | 129205 | 1578 | 176053 |
2022-05-13 | Skamania | Washington | 53059 | 1531 | 12 | 12083 | 993 | 126706 |
2022-05-13 | Snohomish | Washington | 53061 | 159246 | 1145 | 822083 | 1392 | 193710 |
2022-05-13 | Spokane | Washington | 53063 | 126131 | 1378 | 522798 | 2635 | 241261 |
2022-05-13 | Stevens | Washington | 53065 | 8277 | 147 | 45723 | 3215 | 181024 |
2022-05-13 | Thurston | Washington | 53067 | 49071 | 417 | 290536 | 1435 | 168898 |
2022-05-13 | Wahkiakum | Washington | 53069 | 537 | 7 | 4488 | 1559 | 119652 |
2022-05-13 | Walla Walla | Washington | 53071 | 16305 | 142 | 60760 | 2337 | 268350 |
2022-05-13 | Whatcom | Washington | 53073 | 39343 | 301 | 229247 | 1312 | 171618 |
2022-05-13 | Whitman | Washington | 53075 | 8806 | 90 | 50104 | 1796 | 175754 |
2022-05-13 | Yakima | Washington | 53077 | 73887 | 790 | 250873 | 3149 | 294519 |
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;