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 = "Vermont" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Vermont · 14 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Addison | Vermont | 50001 | 5939 | 18 | 36777 | 489 | 161486 |
2022-05-13 | Bennington | Vermont | 50003 | 10153 | 71 | 35470 | 2001 | 286241 |
2022-05-13 | Caledonia | Vermont | 50005 | 5854 | 25 | 29993 | 833 | 195178 |
2022-05-13 | Chittenden | Vermont | 50007 | 34629 | 175 | 163774 | 1068 | 211443 |
2022-05-13 | Essex | Vermont | 50009 | 1301 | 3 | 6163 | 486 | 211098 |
2022-05-13 | Franklin | Vermont | 50011 | 10325 | 67 | 49402 | 1356 | 208999 |
2022-05-13 | Grand Isle | Vermont | 50013 | 1132 | 5 | 7235 | 691 | 156461 |
2022-05-13 | Lamoille | Vermont | 50015 | 3964 | 17 | 25362 | 670 | 156296 |
2022-05-13 | Orange | Vermont | 50017 | 4420 | 14 | 28892 | 484 | 152983 |
2022-05-13 | Orleans | Vermont | 50019 | 6610 | 38 | 27037 | 1405 | 244479 |
2022-05-13 | Rutland | Vermont | 50021 | 13586 | 74 | 58191 | 1271 | 233472 |
2022-05-13 | Washington | Vermont | 50023 | 12430 | 51 | 58409 | 873 | 212809 |
2022-05-13 | Windham | Vermont | 50025 | 6994 | 36 | 42222 | 852 | 165648 |
2022-05-13 | Windsor | Vermont | 50027 | 9638 | 52 | 55062 | 944 | 175039 |
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;