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_per_million
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 (date) 1 ✖
- 2022-05-13 3,131
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 | San Juan | Washington | 53055 | 1450 | 2 | 17582 | 113 | 82470 |
2022-05-13 | Aleutians West Census Area | Alaska | 2016 | 1685 | 1 | 5634 | 177 | 299077 |
2022-05-13 | Lake | Colorado | 8065 | 1843 | 2 | 8127 | 246 | 226774 |
2022-05-13 | Pitkin | Colorado | 8097 | 6676 | 7 | 17767 | 393 | 375752 |
2022-05-13 | Haines Borough | Alaska | 2100 | 624 | 1 | 2530 | 395 | 246640 |
2022-05-13 | Wrangell City and Borough | Alaska | 2275 | 579 | 1 | 2502 | 399 | 231414 |
2022-05-13 | Kauai | Hawaii | 15007 | 12864 | 29 | 72293 | 401 | 177942 |
2022-05-13 | Mono | California | 6051 | 3144 | 6 | 14444 | 415 | 217668 |
2022-05-13 | Summit | Colorado | 8117 | 10087 | 14 | 31011 | 451 | 325271 |
2022-05-13 | Denali Borough | Alaska | 2068 | 424 | 1 | 2097 | 476 | 202193 |
2022-05-13 | Orange | Vermont | 50017 | 4420 | 14 | 28892 | 484 | 152983 |
2022-05-13 | Essex | Vermont | 50009 | 1301 | 3 | 6163 | 486 | 211098 |
2022-05-13 | Addison | Vermont | 50001 | 5939 | 18 | 36777 | 489 | 161486 |
2022-05-13 | Judith Basin | Montana | 30045 | 225 | 1 | 2007 | 498 | 112107 |
2022-05-13 | Nome Census Area | Alaska | 2180 | 6245 | 5 | 10004 | 499 | 624250 |
2022-05-13 | Hartley | Texas | 48205 | 1364 | 3 | 5576 | 538 | 244619 |
2022-05-13 | Garden | Nebraska | 31069 | 376 | 1 | 1837 | 544 | 204681 |
2022-05-13 | Sitka City and Borough | Alaska | 2220 | 2681 | 5 | 8493 | 588 | 315671 |
2022-05-13 | Juneau City and Borough | Alaska | 2110 | 8798 | 19 | 31974 | 594 | 275161 |
2022-05-13 | Grand | Utah | 49019 | 2351 | 6 | 9754 | 615 | 241029 |
2022-05-13 | Summit | Utah | 49043 | 13832 | 26 | 42145 | 616 | 328200 |
2022-05-13 | Eagle | Colorado | 8037 | 16274 | 35 | 55127 | 634 | 295209 |
2022-05-13 | Gilpin | Colorado | 8047 | 977 | 4 | 6243 | 640 | 156495 |
2022-05-13 | Lamoille | Vermont | 50015 | 3964 | 17 | 25362 | 670 | 156296 |
2022-05-13 | Teton | Wyoming | 56039 | 10074 | 16 | 23464 | 681 | 429338 |
2022-05-13 | Plumas | California | 6063 | 3379 | 13 | 18807 | 691 | 179667 |
2022-05-13 | Grand Isle | Vermont | 50013 | 1132 | 5 | 7235 | 691 | 156461 |
2022-05-13 | Dare | North Carolina | 37055 | 7565 | 27 | 37009 | 729 | 204409 |
2022-05-13 | Cook | Minnesota | 27031 | 594 | 4 | 5463 | 732 | 108731 |
2022-05-13 | Wabasha | Minnesota | 27157 | 5795 | 16 | 21627 | 739 | 267952 |
2022-05-13 | Teton | Idaho | 16081 | 2723 | 9 | 12142 | 741 | 224262 |
2022-05-13 | Grafton | New Hampshire | 33009 | 19227 | 68 | 89886 | 756 | 213904 |
2022-05-13 | Benton | Oregon | 41003 | 16301 | 71 | 93053 | 763 | 175179 |
2022-05-13 | Gunnison | Colorado | 8051 | 3407 | 14 | 17462 | 801 | 195109 |
2022-05-13 | Los Alamos | New Mexico | 35028 | 2880 | 16 | 19369 | 826 | 148691 |
2022-05-13 | Camden | North Carolina | 37029 | 1786 | 9 | 10867 | 828 | 164350 |
2022-05-13 | Tompkins | New York | 36109 | 21144 | 85 | 102180 | 831 | 206928 |
2022-05-13 | Caledonia | Vermont | 50005 | 5854 | 25 | 29993 | 833 | 195178 |
2022-05-13 | Maui | Hawaii | 15009 | 32000 | 140 | 167417 | 836 | 191139 |
2022-05-13 | Saline | Nebraska | 31151 | 3781 | 12 | 14224 | 843 | 265818 |
2022-05-13 | Greeley | Nebraska | 31077 | 418 | 2 | 2356 | 848 | 177419 |
2022-05-13 | Cache | Utah | 49005 | 37265 | 109 | 128289 | 849 | 290476 |
2022-05-13 | Windham | Vermont | 50025 | 6994 | 36 | 42222 | 852 | 165648 |
2022-05-13 | Sioux | Nebraska | 31165 | 68 | 1 | 1166 | 857 | 58319 |
2022-05-13 | Washington | Vermont | 50023 | 12430 | 51 | 58409 | 873 | 212809 |
2022-05-13 | Harlan | Nebraska | 31083 | 348 | 3 | 3380 | 887 | 102958 |
2022-05-13 | Sagadahoc | Maine | 23023 | 5531 | 32 | 35856 | 892 | 154255 |
2022-05-13 | Island | Washington | 53029 | 10635 | 76 | 85141 | 892 | 124910 |
2022-05-13 | Griggs | North Dakota | 38039 | 583 | 2 | 2231 | 896 | 261317 |
2022-05-13 | Aleutians East Borough | Alaska | 2013 | 1101 | 3 | 3337 | 899 | 329937 |
2022-05-13 | Jefferson | Washington | 53031 | 3198 | 29 | 32221 | 900 | 99252 |
2022-05-13 | Orange | North Carolina | 37135 | 28209 | 134 | 148476 | 902 | 189990 |
2022-05-13 | Modoc | California | 6049 | 1000 | 8 | 8841 | 904 | 113109 |
2022-05-13 | Franklin | New York | 36033 | 10059 | 46 | 50022 | 919 | 201091 |
2022-05-13 | Buffalo | Wisconsin | 55011 | 3608 | 12 | 13031 | 920 | 276878 |
2022-05-13 | Kodiak Island Borough | Alaska | 2150 | 4992 | 12 | 12998 | 923 | 384059 |
2022-05-13 | Story | Iowa | 19169 | 19980 | 90 | 97117 | 926 | 205731 |
2022-05-13 | Loudoun | Virginia | 51107 | 71890 | 383 | 413538 | 926 | 173841 |
2022-05-13 | Hawaii | Hawaii | 15001 | 28425 | 190 | 201513 | 942 | 141057 |
2022-05-13 | Dane | Wisconsin | 55025 | 134580 | 516 | 546695 | 943 | 246170 |
2022-05-13 | Windsor | Vermont | 50027 | 9638 | 52 | 55062 | 944 | 175039 |
2022-05-13 | Knox | Maine | 23013 | 6414 | 38 | 39772 | 955 | 161269 |
2022-05-13 | Santa Cruz | California | 6087 | 52532 | 263 | 273213 | 962 | 192274 |
2022-05-13 | Boone | Nebraska | 31011 | 1074 | 5 | 5192 | 963 | 206856 |
2022-05-13 | Colusa | California | 6011 | 4549 | 21 | 21547 | 974 | 211119 |
2022-05-13 | Routt | Colorado | 8107 | 6562 | 25 | 25638 | 975 | 255948 |
2022-05-13 | Platte | Missouri | 29165 | 10580 | 102 | 104418 | 976 | 101323 |
2022-05-13 | San Miguel | Colorado | 8113 | 2322 | 8 | 8179 | 978 | 283897 |
2022-05-13 | San Francisco | California | 6075 | 143959 | 866 | 881549 | 982 | 163302 |
2022-05-13 | San Mateo | California | 6081 | 137238 | 755 | 766573 | 984 | 179027 |
2022-05-13 | Eureka | Nevada | 32011 | 165 | 2 | 2029 | 985 | 81320 |
2022-05-13 | Washington | Oregon | 41067 | 91092 | 594 | 601592 | 987 | 151418 |
2022-05-13 | Sonoma | California | 6097 | 90191 | 490 | 494336 | 991 | 182448 |
2022-05-13 | Jefferson | Nebraska | 31095 | 1216 | 7 | 7046 | 993 | 172580 |
2022-05-13 | Skamania | Washington | 53059 | 1531 | 12 | 12083 | 993 | 126706 |
2022-05-13 | Dodge | Minnesota | 27039 | 5888 | 21 | 20934 | 1003 | 281264 |
2022-05-13 | Wake | North Carolina | 37183 | 300453 | 1119 | 1111761 | 1006 | 270249 |
2022-05-13 | Solano | California | 6095 | 89419 | 451 | 447643 | 1007 | 199755 |
2022-05-13 | Lincoln | Maine | 23015 | 5578 | 35 | 34634 | 1010 | 161055 |
2022-05-13 | Johnson | Iowa | 19103 | 35541 | 153 | 151140 | 1012 | 235152 |
2022-05-13 | Garfield | Nebraska | 31071 | 403 | 2 | 1969 | 1015 | 204672 |
2022-05-13 | Houston | Minnesota | 27055 | 4660 | 19 | 18600 | 1021 | 250537 |
2022-05-13 | Wasatch | Utah | 49051 | 10804 | 35 | 34091 | 1026 | 316916 |
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;