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 cases_per_million descending
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 | Menifee | Kentucky | 21165 | 1706 | 32 | 6489 | 4931 | 262906 |
2022-05-13 | Trimble | Kentucky | 21223 | 2217 | 40 | 8471 | 4721 | 261716 |
2022-05-13 | Woodford | Kentucky | 21239 | 6978 | 49 | 26734 | 1832 | 261015 |
2022-05-13 | Casey | Kentucky | 21045 | 4216 | 74 | 16159 | 4579 | 260907 |
2022-05-13 | Crittenden | Kentucky | 21055 | 2292 | 50 | 8806 | 5677 | 260277 |
2022-05-13 | Larue | Kentucky | 21123 | 3741 | 73 | 14398 | 5070 | 259827 |
2022-05-13 | Bath | Kentucky | 21011 | 3210 | 48 | 12500 | 3840 | 256800 |
2022-05-13 | Breckinridge | Kentucky | 21027 | 5170 | 78 | 20477 | 3809 | 252478 |
2022-05-13 | Gallatin | Kentucky | 21077 | 2221 | 51 | 8869 | 5750 | 250422 |
2022-05-13 | Todd | Kentucky | 21219 | 2982 | 43 | 12294 | 3497 | 242557 |
2022-05-13 | Pendleton | Kentucky | 21191 | 3498 | 38 | 14590 | 2604 | 239753 |
2022-05-13 | Christian | Kentucky | 21047 | 16376 | 210 | 70461 | 2980 | 232412 |
2022-05-13 | Carlisle | Kentucky | 21039 | 1076 | 20 | 4760 | 4201 | 226050 |
2022-05-13 | Owen | Kentucky | 21187 | 2370 | 34 | 10901 | 3118 | 217411 |
2022-05-13 | Calloway | Kentucky | 21035 | 8414 | 94 | 39001 | 2410 | 215738 |
2022-05-13 | Edmonson | Kentucky | 21061 | 2563 | 47 | 12150 | 3868 | 210946 |
2022-05-13 | Fulton | Kentucky | 21075 | 1218 | 31 | 5969 | 5193 | 204054 |
2022-05-13 | Meade | Kentucky | 21163 | 5821 | 66 | 28572 | 2309 | 203730 |
2022-05-13 | Hickman | Kentucky | 21105 | 879 | 27 | 4380 | 6164 | 200684 |
2022-05-13 | Ballard | Kentucky | 21007 | 1387 | 29 | 7888 | 3676 | 175836 |
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;