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)
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 | Stanton | Kansas | 20187 | 427 | 8 | 2006 | 3988 | 212861 |
2022-05-13 | Burke | North Dakota | 38013 | 433 | 3 | 2115 | 1418 | 204728 |
2022-05-13 | Logan | North Dakota | 38047 | 435 | 12 | 1850 | 6486 | 235135 |
2022-05-13 | Wallace | Kansas | 20199 | 438 | 5 | 1518 | 3293 | 288537 |
2022-05-13 | Webster | Georgia | 13307 | 439 | 8 | 2607 | 3068 | 168392 |
2022-05-13 | Comanche | Kansas | 20033 | 441 | 16 | 1700 | 9411 | 259411 |
2022-05-13 | Wayne | Utah | 49055 | 444 | 0 | 2711 | 0 | 163777 |
2022-05-13 | Irion | Texas | 48235 | 445 | 3 | 1536 | 1953 | 289713 |
2022-05-13 | Grant | North Dakota | 38037 | 451 | 11 | 2274 | 4837 | 198328 |
2022-05-13 | Haakon | South Dakota | 46055 | 452 | 12 | 1899 | 6319 | 238020 |
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 | Divide | North Dakota | 38023 | 459 | 4 | 2264 | 1766 | 202738 |
2022-05-13 | Hamilton | Kansas | 20075 | 464 | 3 | 2539 | 1181 | 182749 |
2022-05-13 | Briscoe | Texas | 48045 | 465 | 8 | 1546 | 5174 | 300776 |
2022-05-13 | Edwards | Texas | 48137 | 467 | 11 | 1932 | 5693 | 241718 |
2022-05-13 | Butte | Idaho | 16023 | 475 | 9 | 2597 | 3465 | 182903 |
2022-05-13 | Golden Valley | North Dakota | 38033 | 476 | 4 | 1761 | 2271 | 270300 |
2022-05-13 | Sedgwick | Colorado | 8115 | 490 | 11 | 2248 | 4893 | 217971 |
2022-05-13 | Knox | Texas | 48275 | 492 | 25 | 3664 | 6823 | 134279 |
2022-05-13 | Wichita | Kansas | 20203 | 493 | 8 | 2119 | 3775 | 232656 |
2022-05-13 | Sherman | Texas | 48421 | 499 | 16 | 3022 | 5294 | 165122 |
2022-05-13 | Clark | Kansas | 20025 | 504 | 8 | 1994 | 4012 | 252758 |
2022-05-13 | Kidder | North Dakota | 38043 | 510 | 13 | 2480 | 5241 | 205645 |
2022-05-13 | Menard | Texas | 48327 | 513 | 12 | 2138 | 5612 | 239943 |
2022-05-13 | Culberson | Texas | 48109 | 514 | 14 | 2171 | 6448 | 236757 |
2022-05-13 | Brown | Nebraska | 31017 | 515 | 4 | 2955 | 1353 | 174280 |
2022-05-13 | Harmon | Oklahoma | 40057 | 522 | 12 | 2653 | 4523 | 196758 |
2022-05-13 | Keweenaw | Michigan | 26083 | 523 | 14 | 2116 | 6616 | 247164 |
2022-05-13 | Perkins | Nebraska | 31135 | 527 | 12 | 2891 | 4150 | 182289 |
2022-05-13 | Mellette | South Dakota | 46095 | 527 | 8 | 2061 | 3881 | 255701 |
2022-05-13 | Schleicher | Texas | 48413 | 528 | 9 | 2793 | 3222 | 189044 |
2022-05-13 | Custer | Idaho | 16037 | 532 | 9 | 4315 | 2085 | 123290 |
2022-05-13 | Clay | Georgia | 13061 | 533 | 6 | 2834 | 2117 | 188073 |
2022-05-13 | Baker | Georgia | 13007 | 536 | 15 | 3038 | 4937 | 176431 |
2022-05-13 | Granite | Montana | 30039 | 537 | 9 | 3379 | 2663 | 158922 |
2022-05-13 | Wahkiakum | Washington | 53069 | 537 | 7 | 4488 | 1559 | 119652 |
2022-05-13 | Frontier | Nebraska | 31063 | 543 | 3 | 2627 | 1141 | 206699 |
2022-05-13 | Hitchcock | Nebraska | 31087 | 544 | 8 | 2762 | 2896 | 196958 |
2022-05-13 | Cherry | Nebraska | 31031 | 546 | 10 | 5689 | 1757 | 95974 |
2022-05-13 | Lincoln | Nevada | 32017 | 550 | 7 | 5183 | 1350 | 106116 |
2022-05-13 | Armstrong | Texas | 48011 | 555 | 9 | 1887 | 4769 | 294117 |
2022-05-13 | Renville | North Dakota | 38075 | 556 | 15 | 2327 | 6446 | 238934 |
2022-05-13 | Hardeman | Texas | 48197 | 556 | 19 | 3933 | 4830 | 141367 |
2022-05-13 | Edwards | Kansas | 20047 | 556 | 13 | 2798 | 4646 | 198713 |
2022-05-13 | Hand | South Dakota | 46059 | 562 | 12 | 3191 | 3760 | 176120 |
2022-05-13 | Oldham | Texas | 48359 | 565 | 6 | 2112 | 2840 | 267518 |
2022-05-13 | Cimarron | Oklahoma | 40025 | 566 | 7 | 2137 | 3275 | 264857 |
2022-05-13 | Elk | Kansas | 20049 | 571 | 10 | 2530 | 3952 | 225691 |
2022-05-13 | Faulk | South Dakota | 46049 | 572 | 16 | 2299 | 6959 | 248803 |
2022-05-13 | Graham | Kansas | 20065 | 572 | 15 | 2482 | 6043 | 230459 |
2022-05-13 | Sanborn | South Dakota | 46111 | 575 | 6 | 2344 | 2559 | 245307 |
2022-05-13 | Wrangell City and Borough | Alaska | 2275 | 579 | 1 | 2502 | 399 | 231414 |
2022-05-13 | Sherman | Nebraska | 31163 | 581 | 4 | 3001 | 1332 | 193602 |
2022-05-13 | Griggs | North Dakota | 38039 | 583 | 2 | 2231 | 896 | 261317 |
2022-05-13 | De Baca | New Mexico | 35011 | 589 | 6 | 1748 | 3432 | 336956 |
2022-05-13 | Cook | Minnesota | 27031 | 594 | 4 | 5463 | 732 | 108731 |
2022-05-13 | Adams | North Dakota | 38001 | 598 | 10 | 2216 | 4512 | 269855 |
2022-05-13 | Fisher | Texas | 48151 | 609 | 24 | 3830 | 6266 | 159007 |
2022-05-13 | Glascock | Georgia | 13125 | 610 | 25 | 2971 | 8414 | 205318 |
2022-05-13 | Columbia | Washington | 53013 | 613 | 16 | 3985 | 4015 | 153826 |
2022-05-13 | Buffalo | South Dakota | 46017 | 620 | 18 | 1962 | 9174 | 316004 |
2022-05-13 | Decatur | Kansas | 20039 | 620 | 20 | 2827 | 7074 | 219313 |
2022-05-13 | Morton | Kansas | 20129 | 621 | 11 | 2587 | 4252 | 240046 |
2022-05-13 | Lincoln | Kansas | 20105 | 623 | 10 | 2962 | 3376 | 210330 |
2022-05-13 | Haines Borough | Alaska | 2100 | 624 | 1 | 2530 | 395 | 246640 |
2022-05-13 | Jackson | South Dakota | 46071 | 632 | 21 | 3344 | 6279 | 188995 |
2022-05-13 | Stanley | South Dakota | 46117 | 637 | 7 | 3098 | 2259 | 205616 |
2022-05-13 | Towner | North Dakota | 38095 | 641 | 12 | 2189 | 5481 | 292827 |
2022-05-13 | Smith | Kansas | 20183 | 645 | 7 | 3583 | 1953 | 180016 |
2022-05-13 | Stanton | Nebraska | 31167 | 649 | 11 | 5920 | 1858 | 109628 |
2022-05-13 | Cheyenne | Kansas | 20023 | 652 | 14 | 2657 | 5269 | 245389 |
2022-05-13 | Hanson | South Dakota | 46061 | 655 | 6 | 3453 | 1737 | 189690 |
2022-05-13 | Custer | Colorado | 8027 | 656 | 21 | 5068 | 4143 | 129439 |
2022-05-13 | Ziebach | South Dakota | 46137 | 664 | 11 | 2756 | 3991 | 240928 |
2022-05-13 | Kiowa | Kansas | 20097 | 667 | 7 | 2475 | 2828 | 269494 |
2022-05-13 | Robertson | Kentucky | 21201 | 672 | 21 | 2108 | 9962 | 318785 |
2022-05-13 | Chase | Kansas | 20017 | 673 | 7 | 2648 | 2643 | 254154 |
2022-05-13 | Scotland | Missouri | 29199 | 680 | 18 | 4902 | 3671 | 138718 |
2022-05-13 | Fallon | Montana | 30025 | 680 | 10 | 2846 | 3513 | 238931 |
2022-05-13 | Rawlins | Kansas | 20153 | 683 | 9 | 2530 | 3557 | 269960 |
2022-05-13 | Perkins | South Dakota | 46105 | 684 | 18 | 2865 | 6282 | 238743 |
2022-05-13 | Douglas | South Dakota | 46043 | 684 | 16 | 2921 | 5477 | 234166 |
2022-05-13 | McIntosh | North Dakota | 38051 | 688 | 9 | 2497 | 3604 | 275530 |
2022-05-13 | Shackelford | Texas | 48417 | 691 | 12 | 3265 | 3675 | 211638 |
2022-05-13 | Niobrara | Wyoming | 56027 | 694 | 10 | 2356 | 4244 | 294567 |
2022-05-13 | Sheridan | Montana | 30091 | 698 | 11 | 3309 | 3324 | 210939 |
2022-05-13 | Collingsworth | Texas | 48087 | 702 | 16 | 2920 | 5479 | 240410 |
2022-05-13 | Potter | South Dakota | 46107 | 703 | 7 | 2153 | 3251 | 326521 |
2022-05-13 | Mercer | Missouri | 29129 | 704 | 14 | 3617 | 3870 | 194636 |
2022-05-13 | Adams | Idaho | 16003 | 704 | 15 | 4294 | 3493 | 163949 |
2022-05-13 | Costilla | Colorado | 8023 | 708 | 18 | 3887 | 4630 | 182145 |
2022-05-13 | Webster | Nebraska | 31181 | 708 | 11 | 3487 | 3154 | 203039 |
2022-05-13 | Kimble | Texas | 48267 | 714 | 15 | 4337 | 3458 | 164629 |
2022-05-13 | Harper | Oklahoma | 40059 | 714 | 12 | 3688 | 3253 | 193600 |
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 | Valley | Nebraska | 31175 | 731 | 6 | 4158 | 1443 | 175805 |
2022-05-13 | Schuyler | Missouri | 29197 | 740 | 26 | 4660 | 5579 | 158798 |
2022-05-13 | Kinney | Texas | 48271 | 741 | 11 | 3667 | 2999 | 202072 |
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;