latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where state = "Massachusetts" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, deaths_per_million, date (date)
state 1
- Massachusetts · 14 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Barnstable | Massachusetts | 25001 | 37644 | 584 | 212990 | 2741 | 176740 |
2022-05-13 | Berkshire | Massachusetts | 25003 | 26169 | 378 | 124944 | 3025 | 209445 |
2022-05-13 | Bristol | Massachusetts | 25005 | 154820 | 2163 | 565217 | 3826 | 273912 |
2022-05-13 | Dukes | Massachusetts | 25007 | 3587 | 0 | 17332 | 0 | 206958 |
2022-05-13 | Essex | Massachusetts | 25009 | 214332 | 2758 | 789034 | 3495 | 271638 |
2022-05-13 | Franklin | Massachusetts | 25011 | 11403 | 140 | 70180 | 1994 | 162482 |
2022-05-13 | Hampden | Massachusetts | 25013 | 139047 | 1804 | 466372 | 3868 | 298146 |
2022-05-13 | Hampshire | Massachusetts | 25015 | 30837 | 358 | 160830 | 2225 | 191736 |
2022-05-13 | Middlesex | Massachusetts | 25017 | 352032 | 3998 | 1611699 | 2480 | 218422 |
2022-05-13 | Nantucket | Massachusetts | 25019 | 3481 | 0 | 11399 | 0 | 305377 |
2022-05-13 | Norfolk | Massachusetts | 25021 | 141128 | 1901 | 706775 | 2689 | 199678 |
2022-05-13 | Plymouth | Massachusetts | 25023 | 120081 | 1685 | 521202 | 3232 | 230392 |
2022-05-13 | Suffolk | Massachusetts | 25025 | 226017 | 2006 | 803907 | 2495 | 281148 |
2022-05-13 | Worcester | Massachusetts | 25027 | 201669 | 2596 | 830622 | 3125 | 242792 |
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;