latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,131 rows sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 254
- Georgia 159
- Virginia 133
- Kentucky 120
- Missouri 115
- Kansas 105
- Illinois 102
- North Carolina 100
- Iowa 99
- Tennessee 95
- Nebraska 93
- Indiana 92
- Ohio 88
- Minnesota 87
- Michigan 83
- Mississippi 82
- Oklahoma 77
- Arkansas 75
- Wisconsin 72
- Alabama 67
- Florida 67
- Pennsylvania 67
- South Dakota 65
- Colorado 64
- Louisiana 64
- California 58
- New York 57
- Montana 56
- West Virginia 55
- North Dakota 53
- …
date | county | state | fips | cases | deaths ▼ | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Skagway Municipality | Alaska | 2230 | 187 | 0 | 1183 | 0 | 158072 |
2022-05-13 | Alpine | California | 6003 | 126 | 0 | 1129 | 0 | 111603 |
2022-05-13 | Hinsdale | Colorado | 8053 | 131 | 0 | 820 | 0 | 159756 |
2022-05-13 | Jackson | Colorado | 8057 | 166 | 0 | 1392 | 0 | 119252 |
2022-05-13 | San Juan | Colorado | 8111 | 203 | 0 | 728 | 0 | 278846 |
2022-05-13 | Kalawao | Hawaii | 15005 | 1 | 0 | 86 | 0 | 11627 |
2022-05-13 | Dukes | Massachusetts | 25007 | 3587 | 0 | 17332 | 0 | 206958 |
2022-05-13 | Nantucket | Massachusetts | 25019 | 3481 | 0 | 11399 | 0 | 305377 |
2022-05-13 | Hayes | Nebraska | 31085 | 96 | 0 | 922 | 0 | 104121 |
2022-05-13 | Keya Paha | Nebraska | 31103 | 119 | 0 | 806 | 0 | 147642 |
2022-05-13 | Logan | Nebraska | 31113 | 138 | 0 | 748 | 0 | 184491 |
2022-05-13 | Loup | Nebraska | 31115 | 79 | 0 | 664 | 0 | 118975 |
2022-05-13 | Slope | North Dakota | 38087 | 63 | 0 | 750 | 0 | 84000 |
2022-05-13 | King | Texas | 48269 | 51 | 0 | 272 | 0 | 187500 |
2022-05-13 | Daggett | Utah | 49009 | 153 | 0 | 950 | 0 | 161052 |
2022-05-13 | Rich | Utah | 49033 | 343 | 0 | 2483 | 0 | 138139 |
2022-05-13 | Wayne | Utah | 49055 | 444 | 0 | 2711 | 0 | 163777 |
2022-05-13 | Loving | Texas | 48301 | 196 | 1 | 169 | 5917 | 1159763 |
2022-05-13 | Arthur | Nebraska | 31005 | 31 | 1 | 463 | 2159 | 66954 |
2022-05-13 | Petroleum | Montana | 30069 | 35 | 1 | 487 | 2053 | 71868 |
2022-05-13 | McPherson | Nebraska | 31117 | 68 | 1 | 494 | 2024 | 137651 |
2022-05-13 | Treasure | Montana | 30103 | 133 | 1 | 696 | 1436 | 191091 |
2022-05-13 | Thomas | Nebraska | 31171 | 99 | 1 | 722 | 1385 | 137119 |
2022-05-13 | Clark | Idaho | 16033 | 109 | 1 | 845 | 1183 | 128994 |
2022-05-13 | Billings | North Dakota | 38007 | 145 | 1 | 928 | 1077 | 156250 |
2022-05-13 | Sioux | Nebraska | 31165 | 68 | 1 | 1166 | 857 | 58319 |
2022-05-13 | Garden | Nebraska | 31069 | 376 | 1 | 1837 | 544 | 204681 |
2022-05-13 | Judith Basin | Montana | 30045 | 225 | 1 | 2007 | 498 | 112107 |
2022-05-13 | Denali Borough | Alaska | 2068 | 424 | 1 | 2097 | 476 | 202193 |
2022-05-13 | Wrangell City and Borough | Alaska | 2275 | 579 | 1 | 2502 | 399 | 231414 |
2022-05-13 | Haines Borough | Alaska | 2100 | 624 | 1 | 2530 | 395 | 246640 |
2022-05-13 | Aleutians West Census Area | Alaska | 2016 | 1685 | 1 | 5634 | 177 | 299077 |
2022-05-13 | Kenedy | Texas | 48261 | 86 | 2 | 404 | 4950 | 212871 |
2022-05-13 | Borden | Texas | 48033 | 100 | 2 | 654 | 3058 | 152905 |
2022-05-13 | Banner | Nebraska | 31007 | 87 | 2 | 745 | 2684 | 116778 |
2022-05-13 | Mineral | Colorado | 8079 | 241 | 2 | 769 | 2600 | 313394 |
2022-05-13 | Wheeler | Nebraska | 31183 | 123 | 2 | 783 | 2554 | 157088 |
2022-05-13 | Roberts | Texas | 48393 | 175 | 2 | 854 | 2341 | 204918 |
2022-05-13 | Jones | South Dakota | 46075 | 177 | 2 | 903 | 2214 | 196013 |
2022-05-13 | Camas | Idaho | 16025 | 158 | 2 | 1106 | 1808 | 142857 |
2022-05-13 | Rock | Nebraska | 31149 | 179 | 2 | 1357 | 1473 | 131908 |
2022-05-13 | Deuel | Nebraska | 31049 | 317 | 2 | 1794 | 1114 | 176700 |
2022-05-13 | Steele | North Dakota | 38091 | 388 | 2 | 1890 | 1058 | 205291 |
2022-05-13 | Garfield | Nebraska | 31071 | 403 | 2 | 1969 | 1015 | 204672 |
2022-05-13 | Eureka | Nevada | 32011 | 165 | 2 | 2029 | 985 | 81320 |
2022-05-13 | Griggs | North Dakota | 38039 | 583 | 2 | 2231 | 896 | 261317 |
2022-05-13 | Greeley | Nebraska | 31077 | 418 | 2 | 2356 | 848 | 177419 |
2022-05-13 | Lake | Colorado | 8065 | 1843 | 2 | 8127 | 246 | 226774 |
2022-05-13 | San Juan | Washington | 53055 | 1450 | 2 | 17582 | 113 | 82470 |
2022-05-13 | Blaine | Nebraska | 31009 | 65 | 3 | 465 | 6451 | 139784 |
2022-05-13 | Terrell | Texas | 48443 | 121 | 3 | 776 | 3865 | 155927 |
2022-05-13 | Esmeralda | Nevada | 32009 | 109 | 3 | 873 | 3436 | 124856 |
2022-05-13 | Prairie | Montana | 30079 | 263 | 3 | 1077 | 2785 | 244196 |
2022-05-13 | Greeley | Kansas | 20071 | 331 | 3 | 1232 | 2435 | 268668 |
2022-05-13 | Garfield | Montana | 30033 | 225 | 3 | 1258 | 2384 | 178855 |
2022-05-13 | Harding | South Dakota | 46063 | 201 | 3 | 1298 | 2311 | 154853 |
2022-05-13 | Wheeler | Oregon | 41069 | 246 | 3 | 1332 | 2252 | 184684 |
2022-05-13 | Sully | South Dakota | 46119 | 245 | 3 | 1391 | 2156 | 176132 |
2022-05-13 | Glasscock | Texas | 48173 | 199 | 3 | 1409 | 2129 | 141234 |
2022-05-13 | Irion | Texas | 48235 | 445 | 3 | 1536 | 1953 | 289713 |
2022-05-13 | Taliaferro | Georgia | 13265 | 268 | 3 | 1537 | 1951 | 174365 |
2022-05-13 | Worth | Missouri | 29227 | 407 | 3 | 2013 | 1490 | 202185 |
2022-05-13 | Burke | North Dakota | 38013 | 433 | 3 | 2115 | 1418 | 204728 |
2022-05-13 | Hamilton | Kansas | 20075 | 464 | 3 | 2539 | 1181 | 182749 |
2022-05-13 | Frontier | Nebraska | 31063 | 543 | 3 | 2627 | 1141 | 206699 |
2022-05-13 | Aleutians East Borough | Alaska | 2013 | 1101 | 3 | 3337 | 899 | 329937 |
2022-05-13 | Harlan | Nebraska | 31083 | 348 | 3 | 3380 | 887 | 102958 |
2022-05-13 | Hartley | Texas | 48205 | 1364 | 3 | 5576 | 538 | 244619 |
2022-05-13 | Essex | Vermont | 50009 | 1301 | 3 | 6163 | 486 | 211098 |
2022-05-13 | Harding | New Mexico | 35021 | 85 | 4 | 625 | 6400 | 136000 |
2022-05-13 | Kent | Texas | 48263 | 210 | 4 | 762 | 5249 | 275590 |
2022-05-13 | Golden Valley | North Dakota | 38033 | 476 | 4 | 1761 | 2271 | 270300 |
2022-05-13 | Divide | North Dakota | 38023 | 459 | 4 | 2264 | 1766 | 202738 |
2022-05-13 | Quitman | Georgia | 13239 | 426 | 4 | 2299 | 1739 | 185297 |
2022-05-13 | Liberty | Montana | 30051 | 398 | 4 | 2337 | 1711 | 170303 |
2022-05-13 | Pawnee | Nebraska | 31133 | 415 | 4 | 2613 | 1530 | 158821 |
2022-05-13 | Brown | Nebraska | 31017 | 515 | 4 | 2955 | 1353 | 174280 |
2022-05-13 | Sherman | Nebraska | 31163 | 581 | 4 | 3001 | 1332 | 193602 |
2022-05-13 | Sierra | California | 6091 | 324 | 4 | 3005 | 1331 | 107820 |
2022-05-13 | Petersburg Borough | Alaska | 2195 | 785 | 4 | 3266 | 1224 | 240355 |
2022-05-13 | Cook | Minnesota | 27031 | 594 | 4 | 5463 | 732 | 108731 |
2022-05-13 | Gilpin | Colorado | 8047 | 977 | 4 | 6243 | 640 | 156495 |
2022-05-13 | Grant | Nebraska | 31075 | 100 | 5 | 623 | 8025 | 160513 |
2022-05-13 | Hooker | Nebraska | 31091 | 113 | 5 | 682 | 7331 | 165689 |
2022-05-13 | Golden Valley | Montana | 30037 | 150 | 5 | 821 | 6090 | 182704 |
2022-05-13 | Carter | Montana | 30011 | 252 | 5 | 1252 | 3993 | 201277 |
2022-05-13 | Wallace | Kansas | 20199 | 438 | 5 | 1518 | 3293 | 288537 |
2022-05-13 | Gilliam | Oregon | 41021 | 284 | 5 | 1912 | 2615 | 148535 |
2022-05-13 | Oliver | North Dakota | 38065 | 329 | 5 | 1959 | 2552 | 167942 |
2022-05-13 | Hamilton | New York | 36041 | 919 | 5 | 4416 | 1132 | 208106 |
2022-05-13 | Boone | Nebraska | 31011 | 1074 | 5 | 5192 | 963 | 206856 |
2022-05-13 | Grand Isle | Vermont | 50013 | 1132 | 5 | 7235 | 691 | 156461 |
2022-05-13 | Sitka City and Borough | Alaska | 2220 | 2681 | 5 | 8493 | 588 | 315671 |
2022-05-13 | Nome Census Area | Alaska | 2180 | 6245 | 5 | 10004 | 499 | 624250 |
2022-05-13 | Sterling | Texas | 48431 | 245 | 6 | 1291 | 4647 | 189775 |
2022-05-13 | Kiowa | Colorado | 8061 | 336 | 6 | 1406 | 4267 | 238975 |
2022-05-13 | Dundy | Nebraska | 31057 | 335 | 6 | 1693 | 3544 | 197873 |
2022-05-13 | De Baca | New Mexico | 35011 | 589 | 6 | 1748 | 3432 | 336956 |
2022-05-13 | Sherman | Oregon | 41055 | 321 | 6 | 1780 | 3370 | 180337 |
2022-05-13 | Oldham | Texas | 48359 | 565 | 6 | 2112 | 2840 | 267518 |
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;