latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where state = "Maine" sorted by cases_per_million descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Maine · 16 ✖
date | county | state | fips | cases | deaths | population | deaths_per_million | cases_per_million ▲ |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Androscoggin | Maine | 23001 | 23257 | 285 | 108277 | 2632 | 214791 |
2022-05-13 | Aroostook | Maine | 23003 | 14393 | 166 | 67055 | 2475 | 214644 |
2022-05-13 | Oxford | Maine | 23017 | 11799 | 148 | 57975 | 2552 | 203518 |
2022-05-13 | Kennebec | Maine | 23011 | 24799 | 240 | 122302 | 1962 | 202768 |
2022-05-13 | Somerset | Maine | 23025 | 10213 | 110 | 50484 | 2178 | 202301 |
2022-05-13 | York | Maine | 23031 | 41973 | 291 | 207641 | 1401 | 202142 |
2022-05-13 | Franklin | Maine | 23007 | 6014 | 60 | 30199 | 1986 | 199145 |
2022-05-13 | Penobscot | Maine | 23019 | 29710 | 331 | 152148 | 2175 | 195270 |
2022-05-13 | Piscataquis | Maine | 23021 | 3112 | 31 | 16785 | 1846 | 185403 |
2022-05-13 | Cumberland | Maine | 23005 | 52557 | 366 | 295003 | 1240 | 178157 |
2022-05-13 | Waldo | Maine | 23027 | 6467 | 58 | 39715 | 1460 | 162835 |
2022-05-13 | Knox | Maine | 23013 | 6414 | 38 | 39772 | 955 | 161269 |
2022-05-13 | Lincoln | Maine | 23015 | 5578 | 35 | 34634 | 1010 | 161055 |
2022-05-13 | Sagadahoc | Maine | 23023 | 5531 | 32 | 35856 | 892 | 154255 |
2022-05-13 | Washington | Maine | 23029 | 4585 | 57 | 31379 | 1816 | 146116 |
2022-05-13 | Hancock | Maine | 23009 | 7983 | 87 | 54987 | 1582 | 145179 |
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;