latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where state = "Wyoming" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Wyoming · 23 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Albany | Wyoming | 56001 | 9934 | 49 | 38880 | 1260 | 255504 |
2022-05-13 | Big Horn | Wyoming | 56003 | 2586 | 61 | 11790 | 5173 | 219338 |
2022-05-13 | Campbell | Wyoming | 56005 | 12113 | 149 | 46341 | 3215 | 261388 |
2022-05-13 | Carbon | Wyoming | 56007 | 4627 | 52 | 14800 | 3513 | 312635 |
2022-05-13 | Converse | Wyoming | 56009 | 3144 | 55 | 13822 | 3979 | 227463 |
2022-05-13 | Crook | Wyoming | 56011 | 1351 | 29 | 7584 | 3823 | 178138 |
2022-05-13 | Fremont | Wyoming | 56013 | 13795 | 193 | 39261 | 4915 | 351366 |
2022-05-13 | Goshen | Wyoming | 56015 | 3646 | 57 | 13211 | 4314 | 275982 |
2022-05-13 | Hot Springs | Wyoming | 56017 | 1159 | 16 | 4413 | 3625 | 262633 |
2022-05-13 | Johnson | Wyoming | 56019 | 1845 | 19 | 8445 | 2249 | 218472 |
2022-05-13 | Laramie | Wyoming | 56021 | 26292 | 290 | 99500 | 2914 | 264241 |
2022-05-13 | Lincoln | Wyoming | 56023 | 3979 | 31 | 19830 | 1563 | 200655 |
2022-05-13 | Natrona | Wyoming | 56025 | 22380 | 273 | 79858 | 3418 | 280247 |
2022-05-13 | Niobrara | Wyoming | 56027 | 694 | 10 | 2356 | 4244 | 294567 |
2022-05-13 | Park | Wyoming | 56029 | 6801 | 144 | 29194 | 4932 | 232958 |
2022-05-13 | Platte | Wyoming | 56031 | 1911 | 41 | 8393 | 4885 | 227689 |
2022-05-13 | Sheridan | Wyoming | 56033 | 8097 | 78 | 30485 | 2558 | 265606 |
2022-05-13 | Sublette | Wyoming | 56035 | 1926 | 27 | 9831 | 2746 | 195910 |
2022-05-13 | Sweetwater | Wyoming | 56037 | 11088 | 126 | 42343 | 2975 | 261861 |
2022-05-13 | Teton | Wyoming | 56039 | 10074 | 16 | 23464 | 681 | 429338 |
2022-05-13 | Uinta | Wyoming | 56041 | 5643 | 39 | 20226 | 1928 | 278997 |
2022-05-13 | Washakie | Wyoming | 56043 | 2358 | 44 | 7805 | 5637 | 302114 |
2022-05-13 | Weston | Wyoming | 56045 | 1588 | 18 | 6927 | 2598 | 229247 |
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;