latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8 rows where state = "Connecticut" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Connecticut · 8 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Fairfield | Connecticut | 9001 | 214106 | 2733 | 943332 | 2897 | 226967 |
2022-05-13 | Hartford | Connecticut | 9003 | 187284 | 3157 | 891720 | 3540 | 210025 |
2022-05-13 | Litchfield | Connecticut | 9005 | 33423 | 461 | 180333 | 2556 | 185340 |
2022-05-13 | Middlesex | Connecticut | 9007 | 30049 | 481 | 162436 | 2961 | 184989 |
2022-05-13 | New Haven | Connecticut | 9009 | 205522 | 2839 | 854757 | 3321 | 240444 |
2022-05-13 | New London | Connecticut | 9011 | 58138 | 662 | 265206 | 2496 | 219218 |
2022-05-13 | Tolland | Connecticut | 9013 | 21898 | 275 | 150721 | 1824 | 145288 |
2022-05-13 | Windham | Connecticut | 9015 | 26643 | 305 | 116782 | 2611 | 228143 |
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;