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 fips
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 | Robertson | Kentucky | 21201 | 672 | 21 | 2108 | 9962 | 318785 |
2022-05-13 | Rockcastle | Kentucky | 21203 | 5059 | 59 | 16695 | 3533 | 303024 |
2022-05-13 | Rowan | Kentucky | 21205 | 6739 | 69 | 24460 | 2820 | 275511 |
2022-05-13 | Russell | Kentucky | 21207 | 6446 | 87 | 17923 | 4854 | 359649 |
2022-05-13 | Scott | Kentucky | 21209 | 17723 | 109 | 57004 | 1912 | 310908 |
2022-05-13 | Shelby | Kentucky | 21211 | 13410 | 162 | 49024 | 3304 | 273539 |
2022-05-13 | Simpson | Kentucky | 21213 | 5635 | 94 | 18572 | 5061 | 303413 |
2022-05-13 | Spencer | Kentucky | 21215 | 5384 | 59 | 19351 | 3048 | 278228 |
2022-05-13 | Taylor | Kentucky | 21217 | 9492 | 124 | 25769 | 4811 | 368349 |
2022-05-13 | Todd | Kentucky | 21219 | 2982 | 43 | 12294 | 3497 | 242557 |
2022-05-13 | Trigg | Kentucky | 21221 | 4016 | 44 | 14651 | 3003 | 274110 |
2022-05-13 | Trimble | Kentucky | 21223 | 2217 | 40 | 8471 | 4721 | 261716 |
2022-05-13 | Union | Kentucky | 21225 | 4341 | 57 | 14381 | 3963 | 301856 |
2022-05-13 | Warren | Kentucky | 21227 | 43102 | 372 | 132896 | 2799 | 324328 |
2022-05-13 | Washington | Kentucky | 21229 | 3967 | 61 | 12095 | 5043 | 327986 |
2022-05-13 | Wayne | Kentucky | 21231 | 6107 | 92 | 20333 | 4524 | 300349 |
2022-05-13 | Webster | Kentucky | 21233 | 3914 | 49 | 12942 | 3786 | 302426 |
2022-05-13 | Whitley | Kentucky | 21235 | 14412 | 199 | 36264 | 5487 | 397418 |
2022-05-13 | Wolfe | Kentucky | 21237 | 2531 | 28 | 7157 | 3912 | 353639 |
2022-05-13 | Woodford | Kentucky | 21239 | 6978 | 49 | 26734 | 1832 | 261015 |
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;