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 population
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 | county | state | fips | cases | deaths | population ▼ | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Oldham | Texas | 48359 | 565 | 6 | 2112 | 2840 | 267518 |
2022-05-13 | Burke | North Dakota | 38013 | 433 | 3 | 2115 | 1418 | 204728 |
2022-05-13 | Keweenaw | Michigan | 26083 | 523 | 14 | 2116 | 6616 | 247164 |
2022-05-13 | Wichita | Kansas | 20203 | 493 | 8 | 2119 | 3775 | 232656 |
2022-05-13 | Wheatland | Montana | 30107 | 386 | 14 | 2126 | 6585 | 181561 |
2022-05-13 | Cimarron | Oklahoma | 40025 | 566 | 7 | 2137 | 3275 | 264857 |
2022-05-13 | Menard | Texas | 48327 | 513 | 12 | 2138 | 5612 | 239943 |
2022-05-13 | Potter | South Dakota | 46107 | 703 | 7 | 2153 | 3251 | 326521 |
2022-05-13 | Culberson | Texas | 48109 | 514 | 14 | 2171 | 6448 | 236757 |
2022-05-13 | Towner | North Dakota | 38095 | 641 | 12 | 2189 | 5481 | 292827 |
2022-05-13 | Highland | Virginia | 51091 | 387 | 7 | 2190 | 3196 | 176712 |
2022-05-13 | Dickens | Texas | 48125 | 453 | 16 | 2211 | 7236 | 204884 |
2022-05-13 | Miner | South Dakota | 46097 | 457 | 13 | 2216 | 5866 | 206227 |
2022-05-13 | Adams | North Dakota | 38001 | 598 | 10 | 2216 | 4512 | 269855 |
2022-05-13 | Garfield | Washington | 53023 | 389 | 7 | 2225 | 3146 | 174831 |
2022-05-13 | Griggs | North Dakota | 38039 | 583 | 2 | 2231 | 896 | 261317 |
2022-05-13 | Sedgwick | Colorado | 8115 | 490 | 11 | 2248 | 4893 | 217971 |
2022-05-13 | Divide | North Dakota | 38023 | 459 | 4 | 2264 | 1766 | 202738 |
2022-05-13 | Grant | North Dakota | 38037 | 451 | 11 | 2274 | 4837 | 198328 |
2022-05-13 | Jeff Davis | Texas | 48243 | 224 | 9 | 2274 | 3957 | 98504 |
2022-05-13 | Eddy | North Dakota | 38027 | 761 | 6 | 2287 | 2623 | 332750 |
2022-05-13 | Faulk | South Dakota | 46049 | 572 | 16 | 2299 | 6959 | 248803 |
2022-05-13 | Quitman | Georgia | 13239 | 426 | 4 | 2299 | 1739 | 185297 |
2022-05-13 | Renville | North Dakota | 38075 | 556 | 15 | 2327 | 6446 | 238934 |
2022-05-13 | Liberty | Montana | 30051 | 398 | 4 | 2337 | 1711 | 170303 |
2022-05-13 | Sanborn | South Dakota | 46111 | 575 | 6 | 2344 | 2559 | 245307 |
2022-05-13 | Niobrara | Wyoming | 56027 | 694 | 10 | 2356 | 4244 | 294567 |
2022-05-13 | Greeley | Nebraska | 31077 | 418 | 2 | 2356 | 848 | 177419 |
2022-05-13 | McPherson | South Dakota | 46089 | 426 | 9 | 2379 | 3783 | 179066 |
2022-05-13 | Kiowa | Kansas | 20097 | 667 | 7 | 2475 | 2828 | 269494 |
2022-05-13 | Kidder | North Dakota | 38043 | 510 | 13 | 2480 | 5241 | 205645 |
2022-05-13 | Graham | Kansas | 20065 | 572 | 15 | 2482 | 6043 | 230459 |
2022-05-13 | Rich | Utah | 49033 | 343 | 0 | 2483 | 0 | 138139 |
2022-05-13 | McIntosh | North Dakota | 38051 | 688 | 9 | 2497 | 3604 | 275530 |
2022-05-13 | Hettinger | North Dakota | 38041 | 828 | 8 | 2499 | 3201 | 331332 |
2022-05-13 | Wrangell City and Borough | Alaska | 2275 | 579 | 1 | 2502 | 399 | 231414 |
2022-05-13 | Sheridan | Kansas | 20179 | 786 | 18 | 2521 | 7140 | 311781 |
2022-05-13 | Elk | Kansas | 20049 | 571 | 10 | 2530 | 3952 | 225691 |
2022-05-13 | Rawlins | Kansas | 20153 | 683 | 9 | 2530 | 3557 | 269960 |
2022-05-13 | Haines Borough | Alaska | 2100 | 624 | 1 | 2530 | 395 | 246640 |
2022-05-13 | Hamilton | Kansas | 20075 | 464 | 3 | 2539 | 1181 | 182749 |
2022-05-13 | Morton | Kansas | 20129 | 621 | 11 | 2587 | 4252 | 240046 |
2022-05-13 | Butte | Idaho | 16023 | 475 | 9 | 2597 | 3465 | 182903 |
2022-05-13 | Webster | Georgia | 13307 | 439 | 8 | 2607 | 3068 | 168392 |
2022-05-13 | Pawnee | Nebraska | 31133 | 415 | 4 | 2613 | 1530 | 158821 |
2022-05-13 | Frontier | Nebraska | 31063 | 543 | 3 | 2627 | 1141 | 206699 |
2022-05-13 | Gove | Kansas | 20063 | 790 | 23 | 2636 | 8725 | 299696 |
2022-05-13 | Chase | Kansas | 20017 | 673 | 7 | 2648 | 2643 | 254154 |
2022-05-13 | Harmon | Oklahoma | 40057 | 522 | 12 | 2653 | 4523 | 196758 |
2022-05-13 | Cheyenne | Kansas | 20023 | 652 | 14 | 2657 | 5269 | 245389 |
2022-05-13 | Wayne | Utah | 49055 | 444 | 0 | 2711 | 0 | 163777 |
2022-05-13 | Concho | Texas | 48095 | 1084 | 11 | 2726 | 4035 | 397652 |
2022-05-13 | Ness | Kansas | 20135 | 780 | 18 | 2750 | 6545 | 283636 |
2022-05-13 | Aurora | South Dakota | 46003 | 805 | 17 | 2751 | 6179 | 292620 |
2022-05-13 | Ziebach | South Dakota | 46137 | 664 | 11 | 2756 | 3991 | 240928 |
2022-05-13 | Hitchcock | Nebraska | 31087 | 544 | 8 | 2762 | 2896 | 196958 |
2022-05-13 | Schleicher | Texas | 48413 | 528 | 9 | 2793 | 3222 | 189044 |
2022-05-13 | Logan | Kansas | 20109 | 844 | 13 | 2794 | 4652 | 302075 |
2022-05-13 | Edwards | Kansas | 20047 | 556 | 13 | 2798 | 4646 | 198713 |
2022-05-13 | Trego | Kansas | 20195 | 756 | 10 | 2803 | 3567 | 269711 |
2022-05-13 | Decatur | Kansas | 20039 | 620 | 20 | 2827 | 7074 | 219313 |
2022-05-13 | Clay | Georgia | 13061 | 533 | 6 | 2834 | 2117 | 188073 |
2022-05-13 | Fallon | Montana | 30025 | 680 | 10 | 2846 | 3513 | 238931 |
2022-05-13 | Cochran | Texas | 48079 | 891 | 23 | 2853 | 8061 | 312302 |
2022-05-13 | Perkins | South Dakota | 46105 | 684 | 18 | 2865 | 6282 | 238743 |
2022-05-13 | Nelson | North Dakota | 38063 | 768 | 18 | 2879 | 6252 | 266759 |
2022-05-13 | Jewell | Kansas | 20089 | 788 | 13 | 2879 | 4515 | 273706 |
2022-05-13 | Perkins | Nebraska | 31135 | 527 | 12 | 2891 | 4150 | 182289 |
2022-05-13 | Collingsworth | Texas | 48087 | 702 | 16 | 2920 | 5479 | 240410 |
2022-05-13 | Douglas | South Dakota | 46043 | 684 | 16 | 2921 | 5477 | 234166 |
2022-05-13 | Brown | Nebraska | 31017 | 515 | 4 | 2955 | 1353 | 174280 |
2022-05-13 | Lincoln | Kansas | 20105 | 623 | 10 | 2962 | 3376 | 210330 |
2022-05-13 | Hall | Texas | 48191 | 1102 | 24 | 2964 | 8097 | 371794 |
2022-05-13 | Glascock | Georgia | 13125 | 610 | 25 | 2971 | 8414 | 205318 |
2022-05-13 | Franklin | Nebraska | 31061 | 413 | 12 | 2979 | 4028 | 138637 |
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 | Sherman | Texas | 48421 | 499 | 16 | 3022 | 5294 | 165122 |
2022-05-13 | Bowman | North Dakota | 38011 | 828 | 9 | 3024 | 2976 | 273809 |
2022-05-13 | Rush | Kansas | 20165 | 808 | 18 | 3036 | 5928 | 266139 |
2022-05-13 | Baker | Georgia | 13007 | 536 | 15 | 3038 | 4937 | 176431 |
2022-05-13 | Stanley | South Dakota | 46117 | 637 | 7 | 3098 | 2259 | 205616 |
2022-05-13 | Woodson | Kansas | 20207 | 796 | 15 | 3138 | 4780 | 253664 |
2022-05-13 | Hand | South Dakota | 46059 | 562 | 12 | 3191 | 3760 | 176120 |
2022-05-13 | Foster | North Dakota | 38031 | 992 | 23 | 3210 | 7165 | 309034 |
2022-05-13 | Lipscomb | Texas | 48295 | 720 | 16 | 3233 | 4948 | 222703 |
2022-05-13 | Emmons | North Dakota | 38029 | 728 | 18 | 3241 | 5553 | 224622 |
2022-05-13 | Chautauqua | Kansas | 20019 | 844 | 17 | 3250 | 5230 | 259692 |
2022-05-13 | Traverse | Minnesota | 27155 | 871 | 10 | 3259 | 3068 | 267259 |
2022-05-13 | Shackelford | Texas | 48417 | 691 | 12 | 3265 | 3675 | 211638 |
2022-05-13 | Petersburg Borough | Alaska | 2195 | 785 | 4 | 3266 | 1224 | 240355 |
2022-05-13 | Donley | Texas | 48129 | 1153 | 26 | 3278 | 7931 | 351738 |
2022-05-13 | Sheridan | Montana | 30091 | 698 | 11 | 3309 | 3324 | 210939 |
2022-05-13 | Aleutians East Borough | Alaska | 2013 | 1101 | 3 | 3337 | 899 | 329937 |
2022-05-13 | Jackson | South Dakota | 46071 | 632 | 21 | 3344 | 6279 | 188995 |
2022-05-13 | Bennett | South Dakota | 46007 | 789 | 14 | 3365 | 4160 | 234472 |
2022-05-13 | Granite | Montana | 30039 | 537 | 9 | 3379 | 2663 | 158922 |
2022-05-13 | Harlan | Nebraska | 31083 | 348 | 3 | 3380 | 887 | 102958 |
2022-05-13 | Coke | Texas | 48081 | 843 | 20 | 3387 | 5904 | 248892 |
2022-05-13 | Osborne | Kansas | 20141 | 803 | 17 | 3421 | 4969 | 234726 |
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;