latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10 rows where state = "New Hampshire" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- New Hampshire · 10 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Belknap | New Hampshire | 33001 | 14152 | 178 | 61303 | 2903 | 230853 |
2022-05-13 | Carroll | New Hampshire | 33003 | 9865 | 62 | 48910 | 1267 | 201696 |
2022-05-13 | Cheshire | New Hampshire | 33005 | 15674 | 112 | 76085 | 1472 | 206006 |
2022-05-13 | Coos | New Hampshire | 33007 | 7140 | 113 | 31563 | 3580 | 226214 |
2022-05-13 | Grafton | New Hampshire | 33009 | 19227 | 68 | 89886 | 756 | 213904 |
2022-05-13 | Hillsborough | New Hampshire | 33011 | 101728 | 916 | 417025 | 2196 | 243937 |
2022-05-13 | Merrimack | New Hampshire | 33013 | 33415 | 230 | 151391 | 1519 | 220719 |
2022-05-13 | Rockingham | New Hampshire | 33015 | 70405 | 542 | 309769 | 1749 | 227282 |
2022-05-13 | Strafford | New Hampshire | 33017 | 30978 | 210 | 130633 | 1607 | 237137 |
2022-05-13 | Sullivan | New Hampshire | 33019 | 9725 | 67 | 43146 | 1552 | 225397 |
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;