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 county descending
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 | Ziebach | South Dakota | 46137 | 664 | 11 | 2756 | 3991 | 240928 |
2022-05-13 | Zavala | Texas | 48507 | 4059 | 68 | 11840 | 5743 | 342820 |
2022-05-13 | Zapata | Texas | 48505 | 3752 | 55 | 14179 | 3878 | 264616 |
2022-05-13 | Yuma | Arizona | 4027 | 62751 | 1181 | 213787 | 5524 | 293521 |
2022-05-13 | Yuma | Colorado | 8125 | 1886 | 23 | 10019 | 2295 | 188242 |
2022-05-13 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1438 | 10 | 5230 | 1912 | 274952 |
2022-05-13 | Yuba | California | 6115 | 17944 | 122 | 78668 | 1550 | 228097 |
2022-05-13 | Young | Texas | 48503 | 4002 | 94 | 18010 | 5219 | 222209 |
2022-05-13 | York | Pennsylvania | 42133 | 120372 | 1502 | 449058 | 3344 | 268054 |
2022-05-13 | York | South Carolina | 45091 | 78263 | 678 | 280979 | 2412 | 278536 |
2022-05-13 | York | Virginia | 51199 | 10189 | 109 | 68280 | 1596 | 149223 |
2022-05-13 | York | Nebraska | 31185 | 3924 | 21 | 13679 | 1535 | 286863 |
2022-05-13 | York | Maine | 23031 | 41973 | 291 | 207641 | 1401 | 202142 |
2022-05-13 | Yolo | California | 6113 | 41061 | 316 | 220500 | 1433 | 186217 |
2022-05-13 | Yoakum | Texas | 48501 | 1317 | 42 | 8713 | 4820 | 151153 |
2022-05-13 | Yellowstone | Montana | 30111 | 43099 | 551 | 161300 | 3415 | 267197 |
2022-05-13 | Yellow Medicine | Minnesota | 27173 | 2580 | 29 | 9709 | 2986 | 265732 |
2022-05-13 | Yell | Arkansas | 5149 | 6859 | 106 | 21341 | 4966 | 321400 |
2022-05-13 | Yazoo | Mississippi | 28163 | 8054 | 107 | 29690 | 3603 | 271269 |
2022-05-13 | Yavapai | Arizona | 4025 | 48293 | 1212 | 235099 | 5155 | 205415 |
2022-05-13 | Yates | New York | 36123 | 3704 | 40 | 24913 | 1605 | 148677 |
2022-05-13 | Yankton | South Dakota | 46135 | 5929 | 59 | 22814 | 2586 | 259884 |
2022-05-13 | Yancey | North Carolina | 37199 | 5353 | 57 | 18069 | 3154 | 296253 |
2022-05-13 | Yamhill | Oregon | 41071 | 18265 | 222 | 107100 | 2072 | 170541 |
2022-05-13 | Yalobusha | Mississippi | 28161 | 4114 | 57 | 12108 | 4707 | 339775 |
2022-05-13 | Yakima | Washington | 53077 | 73887 | 790 | 250873 | 3149 | 294519 |
2022-05-13 | Yadkin | North Carolina | 37197 | 11048 | 120 | 37667 | 3185 | 293307 |
2022-05-13 | Wythe | Virginia | 51197 | 7557 | 149 | 28684 | 5194 | 263456 |
2022-05-13 | Wyoming | West Virginia | 54109 | 7044 | 116 | 20394 | 5687 | 345395 |
2022-05-13 | Wyoming | Pennsylvania | 42131 | 5257 | 106 | 26794 | 3956 | 196200 |
2022-05-13 | Wyoming | New York | 36121 | 8692 | 84 | 39859 | 2107 | 218068 |
2022-05-13 | Wyandotte | Kansas | 20209 | 47365 | 508 | 165429 | 3070 | 286316 |
2022-05-13 | Wyandot | Ohio | 39175 | 5441 | 105 | 21772 | 4822 | 249908 |
2022-05-13 | Wright | Iowa | 19197 | 3626 | 63 | 12562 | 5015 | 288648 |
2022-05-13 | Wright | Missouri | 29229 | 3847 | 84 | 18289 | 4592 | 210345 |
2022-05-13 | Wright | Minnesota | 27171 | 37182 | 305 | 138377 | 2204 | 268700 |
2022-05-13 | Wrangell City and Borough | Alaska | 2275 | 579 | 1 | 2502 | 399 | 231414 |
2022-05-13 | Worth | Georgia | 13321 | 4677 | 119 | 20247 | 5877 | 230997 |
2022-05-13 | Worth | Iowa | 19195 | 1781 | 17 | 7381 | 2303 | 241295 |
2022-05-13 | Worth | Missouri | 29227 | 407 | 3 | 2013 | 1490 | 202185 |
2022-05-13 | Worcester | Massachusetts | 25027 | 201669 | 2596 | 830622 | 3125 | 242792 |
2022-05-13 | Worcester | Maryland | 24047 | 8826 | 160 | 52276 | 3060 | 168834 |
2022-05-13 | Woodward | Oklahoma | 40153 | 5172 | 76 | 20211 | 3760 | 255900 |
2022-05-13 | Woodson | Kansas | 20207 | 796 | 15 | 3138 | 4780 | 253664 |
2022-05-13 | Woods | Oklahoma | 40151 | 2352 | 38 | 8793 | 4321 | 267485 |
2022-05-13 | Woodruff | Arkansas | 5147 | 1732 | 31 | 6320 | 4905 | 274050 |
2022-05-13 | Woodford | Illinois | 17203 | 10578 | 124 | 38459 | 3224 | 275046 |
2022-05-13 | Woodford | Kentucky | 21239 | 6978 | 49 | 26734 | 1832 | 261015 |
2022-05-13 | Woodbury | Iowa | 19193 | 28838 | 339 | 103107 | 3287 | 279690 |
2022-05-13 | Wood | Texas | 48499 | 8031 | 288 | 45539 | 6324 | 176354 |
2022-05-13 | Wood | West Virginia | 54107 | 22312 | 346 | 83518 | 4142 | 267151 |
2022-05-13 | Wood | Wisconsin | 55141 | 21477 | 233 | 72999 | 3191 | 294209 |
2022-05-13 | Wood | Ohio | 39173 | 32072 | 355 | 130817 | 2713 | 245166 |
2022-05-13 | Wolfe | Kentucky | 21237 | 2531 | 28 | 7157 | 3912 | 353639 |
2022-05-13 | Wise | Virginia | 51195 | 10306 | 199 | 37383 | 5323 | 275686 |
2022-05-13 | Wise | Texas | 48497 | 17052 | 270 | 69984 | 3858 | 243655 |
2022-05-13 | Wirt | West Virginia | 54105 | 1455 | 25 | 5821 | 4294 | 249957 |
2022-05-13 | Winston | Mississippi | 28159 | 5231 | 104 | 17955 | 5792 | 291339 |
2022-05-13 | Winston | Alabama | 1133 | 7576 | 131 | 23629 | 5544 | 320622 |
2022-05-13 | Winona | Minnesota | 27169 | 13109 | 72 | 50484 | 1426 | 259666 |
2022-05-13 | Winneshiek | Iowa | 19191 | 3906 | 50 | 19991 | 2501 | 195387 |
2022-05-13 | Winnebago | Iowa | 19189 | 2984 | 47 | 10354 | 4539 | 288197 |
2022-05-13 | Winnebago | Illinois | 17201 | 79104 | 855 | 282572 | 3025 | 279942 |
2022-05-13 | Winnebago | Wisconsin | 55139 | 53045 | 382 | 171907 | 2222 | 308568 |
2022-05-13 | Winn | Louisiana | 22127 | 4452 | 64 | 13904 | 4602 | 320195 |
2022-05-13 | Winkler | Texas | 48495 | 1846 | 34 | 8010 | 4244 | 230461 |
2022-05-13 | Windsor | Vermont | 50027 | 9638 | 52 | 55062 | 944 | 175039 |
2022-05-13 | Windham | Connecticut | 9015 | 26643 | 305 | 116782 | 2611 | 228143 |
2022-05-13 | Windham | Vermont | 50025 | 6994 | 36 | 42222 | 852 | 165648 |
2022-05-13 | Winchester city | Virginia | 51840 | 6440 | 80 | 28078 | 2849 | 229361 |
2022-05-13 | Wilson | Kansas | 20205 | 2828 | 43 | 8525 | 5043 | 331730 |
2022-05-13 | Wilson | North Carolina | 37195 | 21886 | 316 | 81801 | 3863 | 267551 |
2022-05-13 | Wilson | Tennessee | 47189 | 41970 | 484 | 144657 | 3345 | 290134 |
2022-05-13 | Wilson | Texas | 48493 | 11032 | 157 | 51070 | 3074 | 216017 |
2022-05-13 | Williamson | Illinois | 17199 | 22816 | 263 | 66597 | 3949 | 342598 |
2022-05-13 | Williamson | Tennessee | 47187 | 62833 | 406 | 238412 | 1702 | 263547 |
2022-05-13 | Williamson | Texas | 48491 | 135522 | 935 | 590551 | 1583 | 229483 |
2022-05-13 | Williamsburg city | Virginia | 51830 | 1837 | 22 | 14954 | 1471 | 122843 |
2022-05-13 | Williamsburg | South Carolina | 45089 | 8557 | 146 | 30368 | 4807 | 281776 |
2022-05-13 | Williams | Ohio | 39171 | 9090 | 164 | 36692 | 4469 | 247737 |
2022-05-13 | Williams | North Dakota | 38105 | 10496 | 68 | 37589 | 1809 | 279230 |
2022-05-13 | Willacy | Texas | 48489 | 7089 | 130 | 21358 | 6086 | 331913 |
2022-05-13 | Will | Illinois | 17197 | 169447 | 1612 | 690743 | 2333 | 245311 |
2022-05-13 | Wilkinson | Georgia | 13319 | 2247 | 56 | 8954 | 6254 | 250949 |
2022-05-13 | Wilkinson | Mississippi | 28157 | 1804 | 46 | 8630 | 5330 | 209038 |
2022-05-13 | Wilkin | Minnesota | 27167 | 1662 | 22 | 6207 | 3544 | 267762 |
2022-05-13 | Wilkes | Georgia | 13317 | 2246 | 53 | 9777 | 5420 | 229722 |
2022-05-13 | Wilkes | North Carolina | 37193 | 17625 | 264 | 68412 | 3858 | 257630 |
2022-05-13 | Wilcox | Georgia | 13315 | 2014 | 71 | 8635 | 8222 | 233236 |
2022-05-13 | Wilcox | Alabama | 1131 | 2892 | 46 | 10373 | 4434 | 278800 |
2022-05-13 | Wilbarger | Texas | 48487 | 3486 | 87 | 12769 | 6813 | 273004 |
2022-05-13 | Wicomico | Maryland | 24045 | 20013 | 328 | 103609 | 3165 | 193158 |
2022-05-13 | Wichita | Texas | 48485 | 34143 | 679 | 132230 | 5134 | 258209 |
2022-05-13 | Wichita | Kansas | 20203 | 493 | 8 | 2119 | 3775 | 232656 |
2022-05-13 | Wibaux | Montana | 30109 | 204 | 8 | 969 | 8255 | 210526 |
2022-05-13 | Whitman | Washington | 53075 | 8806 | 90 | 50104 | 1796 | 175754 |
2022-05-13 | Whitley | Kentucky | 21235 | 14412 | 199 | 36264 | 5487 | 397418 |
2022-05-13 | Whitley | Indiana | 18183 | 9740 | 84 | 33964 | 2473 | 286774 |
2022-05-13 | Whitfield | Georgia | 13313 | 34132 | 439 | 104628 | 4195 | 326222 |
2022-05-13 | Whiteside | Illinois | 17195 | 15768 | 268 | 55175 | 4857 | 285781 |
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;