latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 12 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 14
- Nebraska 4
- South Dakota 4
- Texas 4
- North Dakota 3
- Colorado 2
- Oklahoma 2
- Alaska 1
- Georgia 1
- Illinois 1
- Kansas 1
- Minnesota 1
- Virginia 1
- Washington 1
- Wisconsin 1
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Buffalo | Wisconsin | 55011 | 3608 | 12 | 13031 | 920 | 276878 |
2022-05-13 | Clear Creek | Colorado | 8019 | 1601 | 12 | 9700 | 1237 | 165051 |
2022-05-13 | Deuel | South Dakota | 46039 | 1043 | 12 | 4351 | 2757 | 239715 |
2022-05-13 | Echols | Georgia | 13101 | 937 | 12 | 4006 | 2995 | 233899 |
2022-05-13 | Franklin | Nebraska | 31061 | 413 | 12 | 2979 | 4028 | 138637 |
2022-05-13 | Grant | Minnesota | 27051 | 1506 | 12 | 5972 | 2009 | 252176 |
2022-05-13 | Haakon | South Dakota | 46055 | 452 | 12 | 1899 | 6319 | 238020 |
2022-05-13 | Hand | South Dakota | 46059 | 562 | 12 | 3191 | 3760 | 176120 |
2022-05-13 | Harmon | Oklahoma | 40057 | 522 | 12 | 2653 | 4523 | 196758 |
2022-05-13 | Harper | Oklahoma | 40059 | 714 | 12 | 3688 | 3253 | 193600 |
2022-05-13 | King and Queen | Virginia | 51097 | 1146 | 12 | 7025 | 1708 | 163131 |
2022-05-13 | Kodiak Island Borough | Alaska | 2150 | 4992 | 12 | 12998 | 923 | 384059 |
2022-05-13 | Lane | Kansas | 20101 | 296 | 12 | 1535 | 7817 | 192833 |
2022-05-13 | Logan | North Dakota | 38047 | 435 | 12 | 1850 | 6486 | 235135 |
2022-05-13 | Lyman | South Dakota | 46085 | 1205 | 12 | 3781 | 3173 | 318698 |
2022-05-13 | Mason | Texas | 48319 | 787 | 12 | 4274 | 2807 | 184136 |
2022-05-13 | Menard | Texas | 48327 | 513 | 12 | 2138 | 5612 | 239943 |
2022-05-13 | Nance | Nebraska | 31125 | 775 | 12 | 3519 | 3410 | 220233 |
2022-05-13 | Perkins | Nebraska | 31135 | 527 | 12 | 2891 | 4150 | 182289 |
2022-05-13 | Saguache | Colorado | 8109 | 1203 | 12 | 6824 | 1758 | 176289 |
2022-05-13 | Saline | Nebraska | 31151 | 3781 | 12 | 14224 | 843 | 265818 |
2022-05-13 | Scott | Illinois | 17171 | 1276 | 12 | 4951 | 2423 | 257725 |
2022-05-13 | Shackelford | Texas | 48417 | 691 | 12 | 3265 | 3675 | 211638 |
2022-05-13 | Skamania | Washington | 53059 | 1531 | 12 | 12083 | 993 | 126706 |
2022-05-13 | Sutton | Texas | 48435 | 848 | 12 | 3776 | 3177 | 224576 |
2022-05-13 | Towner | North Dakota | 38095 | 641 | 12 | 2189 | 5481 | 292827 |
2022-05-13 | Wells | North Dakota | 38103 | 1018 | 12 | 3834 | 3129 | 265519 |
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;