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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 51
- 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
- South Carolina 46
- Idaho 44
- Washington 39
- Oregon 36
- New Mexico 33
- Utah 29
- Alaska 24
- Maryland 24
- Wyoming 23
- New Jersey 21
- Nevada 17
- Maine 16
- Arizona 15
- Massachusetts 14
- Vermont 14
- New Hampshire 10
- Connecticut 8
- Hawaii 5
- Rhode Island 5
- Delaware 3
- District of Columbia 1
date | county | state | fips | cases ▼ | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Kalawao | Hawaii | 15005 | 1 | 0 | 86 | 0 | 11627 |
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 | King | Texas | 48269 | 51 | 0 | 272 | 0 | 187500 |
2022-05-13 | Slope | North Dakota | 38087 | 63 | 0 | 750 | 0 | 84000 |
2022-05-13 | Blaine | Nebraska | 31009 | 65 | 3 | 465 | 6451 | 139784 |
2022-05-13 | McPherson | Nebraska | 31117 | 68 | 1 | 494 | 2024 | 137651 |
2022-05-13 | Sioux | Nebraska | 31165 | 68 | 1 | 1166 | 857 | 58319 |
2022-05-13 | Loup | Nebraska | 31115 | 79 | 0 | 664 | 0 | 118975 |
2022-05-13 | Harding | New Mexico | 35021 | 85 | 4 | 625 | 6400 | 136000 |
2022-05-13 | Kenedy | Texas | 48261 | 86 | 2 | 404 | 4950 | 212871 |
2022-05-13 | Banner | Nebraska | 31007 | 87 | 2 | 745 | 2684 | 116778 |
2022-05-13 | Hayes | Nebraska | 31085 | 96 | 0 | 922 | 0 | 104121 |
2022-05-13 | Thomas | Nebraska | 31171 | 99 | 1 | 722 | 1385 | 137119 |
2022-05-13 | Grant | Nebraska | 31075 | 100 | 5 | 623 | 8025 | 160513 |
2022-05-13 | Borden | Texas | 48033 | 100 | 2 | 654 | 3058 | 152905 |
2022-05-13 | Esmeralda | Nevada | 32009 | 109 | 3 | 873 | 3436 | 124856 |
2022-05-13 | Clark | Idaho | 16033 | 109 | 1 | 845 | 1183 | 128994 |
2022-05-13 | Hooker | Nebraska | 31091 | 113 | 5 | 682 | 7331 | 165689 |
2022-05-13 | Keya Paha | Nebraska | 31103 | 119 | 0 | 806 | 0 | 147642 |
2022-05-13 | Terrell | Texas | 48443 | 121 | 3 | 776 | 3865 | 155927 |
2022-05-13 | Wheeler | Nebraska | 31183 | 123 | 2 | 783 | 2554 | 157088 |
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 | Storey | Nevada | 32029 | 133 | 11 | 4123 | 2667 | 32258 |
2022-05-13 | Treasure | Montana | 30103 | 133 | 1 | 696 | 1436 | 191091 |
2022-05-13 | Logan | Nebraska | 31113 | 138 | 0 | 748 | 0 | 184491 |
2022-05-13 | Billings | North Dakota | 38007 | 145 | 1 | 928 | 1077 | 156250 |
2022-05-13 | Golden Valley | Montana | 30037 | 150 | 5 | 821 | 6090 | 182704 |
2022-05-13 | Daggett | Utah | 49009 | 153 | 0 | 950 | 0 | 161052 |
2022-05-13 | Camas | Idaho | 16025 | 158 | 2 | 1106 | 1808 | 142857 |
2022-05-13 | Eureka | Nevada | 32011 | 165 | 2 | 2029 | 985 | 81320 |
2022-05-13 | Jackson | Colorado | 8057 | 166 | 0 | 1392 | 0 | 119252 |
2022-05-13 | McMullen | Texas | 48311 | 169 | 9 | 743 | 12113 | 227456 |
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 | Rock | Nebraska | 31149 | 179 | 2 | 1357 | 1473 | 131908 |
2022-05-13 | Skagway Municipality | Alaska | 2230 | 187 | 0 | 1183 | 0 | 158072 |
2022-05-13 | Loving | Texas | 48301 | 196 | 1 | 169 | 5917 | 1159763 |
2022-05-13 | Glasscock | Texas | 48173 | 199 | 3 | 1409 | 2129 | 141234 |
2022-05-13 | Harding | South Dakota | 46063 | 201 | 3 | 1298 | 2311 | 154853 |
2022-05-13 | San Juan | Colorado | 8111 | 203 | 0 | 728 | 0 | 278846 |
2022-05-13 | Wibaux | Montana | 30109 | 204 | 8 | 969 | 8255 | 210526 |
2022-05-13 | Foard | Texas | 48155 | 209 | 11 | 1155 | 9523 | 180952 |
2022-05-13 | Kent | Texas | 48263 | 210 | 4 | 762 | 5249 | 275590 |
2022-05-13 | Jeff Davis | Texas | 48243 | 224 | 9 | 2274 | 3957 | 98504 |
2022-05-13 | Garfield | Montana | 30033 | 225 | 3 | 1258 | 2384 | 178855 |
2022-05-13 | Judith Basin | Montana | 30045 | 225 | 1 | 2007 | 498 | 112107 |
2022-05-13 | Mineral | Colorado | 8079 | 241 | 2 | 769 | 2600 | 313394 |
2022-05-13 | Sterling | Texas | 48431 | 245 | 6 | 1291 | 4647 | 189775 |
2022-05-13 | Sully | South Dakota | 46119 | 245 | 3 | 1391 | 2156 | 176132 |
2022-05-13 | Wheeler | Oregon | 41069 | 246 | 3 | 1332 | 2252 | 184684 |
2022-05-13 | Carter | Montana | 30011 | 252 | 5 | 1252 | 3993 | 201277 |
2022-05-13 | Issaquena | Mississippi | 28055 | 262 | 9 | 1327 | 6782 | 197437 |
2022-05-13 | Prairie | Montana | 30079 | 263 | 3 | 1077 | 2785 | 244196 |
2022-05-13 | Campbell | South Dakota | 46021 | 268 | 7 | 1376 | 5087 | 194767 |
2022-05-13 | Taliaferro | Georgia | 13265 | 268 | 3 | 1537 | 1951 | 174365 |
2022-05-13 | Throckmorton | Texas | 48447 | 271 | 8 | 1501 | 5329 | 180546 |
2022-05-13 | Gilliam | Oregon | 41021 | 284 | 5 | 1912 | 2615 | 148535 |
2022-05-13 | Motley | Texas | 48345 | 286 | 13 | 1200 | 10833 | 238333 |
2022-05-13 | Lane | Kansas | 20101 | 296 | 12 | 1535 | 7817 | 192833 |
2022-05-13 | Sheridan | North Dakota | 38083 | 299 | 7 | 1315 | 5323 | 227376 |
2022-05-13 | Piute | Utah | 49031 | 304 | 7 | 1479 | 4732 | 205544 |
2022-05-13 | Hyde | South Dakota | 46069 | 307 | 8 | 1301 | 6149 | 235972 |
2022-05-13 | Deuel | Nebraska | 31049 | 317 | 2 | 1794 | 1114 | 176700 |
2022-05-13 | Cottle | Texas | 48101 | 319 | 9 | 1398 | 6437 | 228183 |
2022-05-13 | Sherman | Oregon | 41055 | 321 | 6 | 1780 | 3370 | 180337 |
2022-05-13 | Cheyenne | Colorado | 8017 | 322 | 9 | 1831 | 4915 | 175860 |
2022-05-13 | Sierra | California | 6091 | 324 | 4 | 3005 | 1331 | 107820 |
2022-05-13 | Oliver | North Dakota | 38065 | 329 | 5 | 1959 | 2552 | 167942 |
2022-05-13 | Greeley | Kansas | 20071 | 331 | 3 | 1232 | 2435 | 268668 |
2022-05-13 | Dundy | Nebraska | 31057 | 335 | 6 | 1693 | 3544 | 197873 |
2022-05-13 | Kiowa | Colorado | 8061 | 336 | 6 | 1406 | 4267 | 238975 |
2022-05-13 | Powder River | Montana | 30075 | 343 | 10 | 1682 | 5945 | 203923 |
2022-05-13 | Rich | Utah | 49033 | 343 | 0 | 2483 | 0 | 138139 |
2022-05-13 | Harlan | Nebraska | 31083 | 348 | 3 | 3380 | 887 | 102958 |
2022-05-13 | Stonewall | Texas | 48433 | 362 | 7 | 1350 | 5185 | 268148 |
2022-05-13 | Dolores | Colorado | 8033 | 367 | 8 | 2055 | 3892 | 178588 |
2022-05-13 | Garden | Nebraska | 31069 | 376 | 1 | 1837 | 544 | 204681 |
2022-05-13 | Gosper | Nebraska | 31073 | 381 | 7 | 1990 | 3517 | 191457 |
2022-05-13 | McCone | Montana | 30055 | 383 | 9 | 1664 | 5408 | 230168 |
2022-05-13 | Wheatland | Montana | 30107 | 386 | 14 | 2126 | 6585 | 181561 |
2022-05-13 | Daniels | Montana | 30019 | 386 | 9 | 1690 | 5325 | 228402 |
2022-05-13 | Highland | Virginia | 51091 | 387 | 7 | 2190 | 3196 | 176712 |
2022-05-13 | Steele | North Dakota | 38091 | 388 | 2 | 1890 | 1058 | 205291 |
2022-05-13 | Garfield | Washington | 53023 | 389 | 7 | 2225 | 3146 | 174831 |
2022-05-13 | Liberty | Montana | 30051 | 398 | 4 | 2337 | 1711 | 170303 |
2022-05-13 | Boyd | Nebraska | 31015 | 402 | 7 | 1919 | 3647 | 209484 |
2022-05-13 | Garfield | Nebraska | 31071 | 403 | 2 | 1969 | 1015 | 204672 |
2022-05-13 | Worth | Missouri | 29227 | 407 | 3 | 2013 | 1490 | 202185 |
2022-05-13 | Hodgeman | Kansas | 20083 | 411 | 10 | 1794 | 5574 | 229096 |
2022-05-13 | Meagher | Montana | 30059 | 412 | 10 | 1862 | 5370 | 221267 |
2022-05-13 | Franklin | Nebraska | 31061 | 413 | 12 | 2979 | 4028 | 138637 |
2022-05-13 | Jerauld | South Dakota | 46073 | 415 | 20 | 2013 | 9935 | 206159 |
2022-05-13 | Pawnee | Nebraska | 31133 | 415 | 4 | 2613 | 1530 | 158821 |
2022-05-13 | Greeley | Nebraska | 31077 | 418 | 2 | 2356 | 848 | 177419 |
2022-05-13 | Catron | New Mexico | 35003 | 420 | 14 | 3527 | 3969 | 119081 |
2022-05-13 | Denali Borough | Alaska | 2068 | 424 | 1 | 2097 | 476 | 202193 |
2022-05-13 | McPherson | South Dakota | 46089 | 426 | 9 | 2379 | 3783 | 179066 |
2022-05-13 | Quitman | Georgia | 13239 | 426 | 4 | 2299 | 1739 | 185297 |
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;