latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
5 rows where state = "Rhode Island" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Rhode Island · 5 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Bristol | Rhode Island | 44001 | 14360 | 169 | 48479 | 3486 | 296210 |
2022-05-13 | Kent | Rhode Island | 44003 | 50938 | 513 | 164292 | 3122 | 310045 |
2022-05-13 | Newport | Rhode Island | 44005 | 21237 | 94 | 82082 | 1145 | 258729 |
2022-05-13 | Providence | Rhode Island | 44007 | 229262 | 2535 | 638931 | 3967 | 358821 |
2022-05-13 | Washington | Rhode Island | 44009 | 34243 | 224 | 125577 | 1783 | 272685 |
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;