latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where state = "Nevada" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Nevada · 17 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Carson City | Nevada | 32510 | 15052 | 218 | 55916 | 3898 | 269189 |
2022-05-13 | Churchill | Nevada | 32001 | 6599 | 110 | 24909 | 4416 | 264924 |
2022-05-13 | Clark | Nevada | 32003 | 543811 | 8458 | 2266715 | 3731 | 239911 |
2022-05-13 | Douglas | Nevada | 32005 | 7410 | 92 | 48905 | 1881 | 151518 |
2022-05-13 | Elko | Nevada | 32007 | 11668 | 138 | 52778 | 2614 | 221076 |
2022-05-13 | Esmeralda | Nevada | 32009 | 109 | 3 | 873 | 3436 | 124856 |
2022-05-13 | Eureka | Nevada | 32011 | 165 | 2 | 2029 | 985 | 81320 |
2022-05-13 | Humboldt | Nevada | 32013 | 2508 | 54 | 16831 | 3208 | 149010 |
2022-05-13 | Lander | Nevada | 32015 | 1181 | 21 | 5532 | 3796 | 213485 |
2022-05-13 | Lincoln | Nevada | 32017 | 550 | 7 | 5183 | 1350 | 106116 |
2022-05-13 | Lyon | Nevada | 32019 | 10135 | 175 | 57510 | 3042 | 176230 |
2022-05-13 | Mineral | Nevada | 32021 | 1267 | 17 | 4505 | 3773 | 281243 |
2022-05-13 | Nye | Nevada | 32023 | 7514 | 241 | 46523 | 5180 | 161511 |
2022-05-13 | Pershing | Nevada | 32027 | 2130 | 29 | 6725 | 4312 | 316728 |
2022-05-13 | Storey | Nevada | 32029 | 133 | 11 | 4123 | 2667 | 32258 |
2022-05-13 | Washoe | Nevada | 32031 | 105973 | 1202 | 471519 | 2549 | 224748 |
2022-05-13 | White Pine | Nevada | 32033 | 1693 | 20 | 9580 | 2087 | 176722 |
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;