latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where state = "Kentucky" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Kentucky · 120 ✖
date | county | state | fips | cases | deaths ▼ | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Graves | Kentucky | 21083 | 11355 | 181 | 37266 | 4856 | 304701 |
2022-05-13 | Whitley | Kentucky | 21235 | 14412 | 199 | 36264 | 5487 | 397418 |
2022-05-13 | Floyd | Kentucky | 21071 | 12571 | 206 | 35589 | 5788 | 353227 |
2022-05-13 | Christian | Kentucky | 21047 | 16376 | 210 | 70461 | 2980 | 232412 |
2022-05-13 | Harlan | Kentucky | 21095 | 9222 | 211 | 26010 | 8112 | 354555 |
2022-05-13 | Barren | Kentucky | 21009 | 13032 | 219 | 44249 | 4949 | 294515 |
2022-05-13 | Bullitt | Kentucky | 21029 | 21805 | 223 | 81676 | 2730 | 266969 |
2022-05-13 | Laurel | Kentucky | 21125 | 20315 | 242 | 60813 | 3979 | 334056 |
2022-05-13 | Hopkins | Kentucky | 21107 | 14975 | 255 | 44686 | 5706 | 335116 |
2022-05-13 | McCracken | Kentucky | 21145 | 18502 | 263 | 65418 | 4020 | 282827 |
2022-05-13 | Madison | Kentucky | 21151 | 27833 | 280 | 92987 | 3011 | 299321 |
2022-05-13 | Pulaski | Kentucky | 21199 | 18157 | 293 | 64979 | 4509 | 279428 |
2022-05-13 | Boone | Kentucky | 21015 | 40084 | 297 | 133581 | 2223 | 300072 |
2022-05-13 | Pike | Kentucky | 21195 | 19099 | 307 | 57876 | 5304 | 329998 |
2022-05-13 | Warren | Kentucky | 21227 | 43102 | 372 | 132896 | 2799 | 324328 |
2022-05-13 | Daviess | Kentucky | 21059 | 31176 | 391 | 101511 | 3851 | 307119 |
2022-05-13 | Kenton | Kentucky | 21117 | 46264 | 415 | 166998 | 2485 | 277033 |
2022-05-13 | Hardin | Kentucky | 21093 | 32778 | 434 | 110958 | 3911 | 295409 |
2022-05-13 | Fayette | Kentucky | 21067 | 95993 | 609 | 323152 | 1884 | 297052 |
2022-05-13 | Jefferson | Kentucky | 21111 | 234899 | 2357 | 766757 | 3073 | 306353 |
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;