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 date
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 | Hockley | Texas | 48219 | 7750 | 161 | 23021 | 6993 | 336649 |
2022-05-13 | Adair | Iowa | 19001 | 1588 | 50 | 7152 | 6991 | 222035 |
2022-05-13 | Bacon | Georgia | 13005 | 3692 | 78 | 11164 | 6986 | 330705 |
2022-05-13 | Appling | Georgia | 13001 | 4833 | 128 | 18386 | 6961 | 262863 |
2022-05-13 | Pulaski | Indiana | 18131 | 3086 | 86 | 12353 | 6961 | 249817 |
2022-05-13 | Faulk | South Dakota | 46049 | 572 | 16 | 2299 | 6959 | 248803 |
2022-05-13 | Clarke | Mississippi | 28023 | 4239 | 108 | 15541 | 6949 | 272762 |
2022-05-13 | Calhoun | Florida | 12013 | 4103 | 98 | 14105 | 6947 | 290889 |
2022-05-13 | Ringgold | Iowa | 19159 | 1135 | 34 | 4894 | 6947 | 231916 |
2022-05-13 | Gasconade | Missouri | 29073 | 3385 | 102 | 14706 | 6935 | 230178 |
2022-05-13 | Perry | Tennessee | 47135 | 2332 | 56 | 8076 | 6934 | 288756 |
2022-05-13 | Perry | Kentucky | 21193 | 11040 | 178 | 25758 | 6910 | 428604 |
2022-05-13 | Fentress | Tennessee | 47049 | 5722 | 128 | 18523 | 6910 | 308913 |
2022-05-13 | Norton | Kansas | 20137 | 2153 | 37 | 5361 | 6901 | 401604 |
2022-05-13 | Haskell | Texas | 48207 | 897 | 39 | 5658 | 6892 | 158536 |
2022-05-13 | Mohave | Arizona | 4015 | 57631 | 1454 | 212181 | 6852 | 271612 |
2022-05-13 | Meriwether | Georgia | 13199 | 4487 | 145 | 21167 | 6850 | 211980 |
2022-05-13 | Wayne | Georgia | 13305 | 7817 | 205 | 29927 | 6850 | 261202 |
2022-05-13 | Alcona | Michigan | 26001 | 1745 | 71 | 10405 | 6823 | 167707 |
2022-05-13 | Knox | Texas | 48275 | 492 | 25 | 3664 | 6823 | 134279 |
2022-05-13 | La Paz | Arizona | 4012 | 5227 | 144 | 21108 | 6822 | 247631 |
2022-05-13 | Holt | Missouri | 29087 | 1060 | 30 | 4403 | 6813 | 240744 |
2022-05-13 | Wilbarger | Texas | 48487 | 3486 | 87 | 12769 | 6813 | 273004 |
2022-05-13 | Terry | Texas | 48445 | 2790 | 84 | 12337 | 6808 | 226148 |
2022-05-13 | Oscoda | Michigan | 26135 | 1450 | 56 | 8241 | 6795 | 175949 |
2022-05-13 | Buena Vista city | Virginia | 51530 | 2017 | 44 | 6478 | 6792 | 311361 |
2022-05-13 | Issaquena | Mississippi | 28055 | 262 | 9 | 1327 | 6782 | 197437 |
2022-05-13 | Sierra | New Mexico | 35051 | 2048 | 73 | 10791 | 6764 | 189787 |
2022-05-13 | Harrison | Iowa | 19085 | 3437 | 95 | 14049 | 6762 | 244643 |
2022-05-13 | Dawson | Montana | 30021 | 2357 | 58 | 8613 | 6734 | 273656 |
2022-05-13 | Taylor | Georgia | 13269 | 2003 | 54 | 8020 | 6733 | 249750 |
2022-05-13 | Nolan | Texas | 48353 | 3065 | 99 | 14714 | 6728 | 208305 |
2022-05-13 | Washington | Georgia | 13303 | 4411 | 137 | 20374 | 6724 | 216501 |
2022-05-13 | Roosevelt | Montana | 30085 | 3279 | 74 | 11004 | 6724 | 297982 |
2022-05-13 | Rosebud | Montana | 30087 | 2633 | 60 | 8937 | 6713 | 294617 |
2022-05-13 | Musselshell | Montana | 30065 | 917 | 31 | 4633 | 6691 | 197927 |
2022-05-13 | Brown | Texas | 48049 | 12056 | 253 | 37864 | 6681 | 318402 |
2022-05-13 | Pierce | Georgia | 13229 | 5694 | 130 | 19465 | 6678 | 292525 |
2022-05-13 | Lee | Arkansas | 5077 | 2912 | 59 | 8857 | 6661 | 328779 |
2022-05-13 | Hamlin | South Dakota | 46057 | 1508 | 41 | 6164 | 6651 | 244646 |
2022-05-13 | Ontonagon | Michigan | 26131 | 1008 | 38 | 5720 | 6643 | 176223 |
2022-05-13 | Livingston | Kentucky | 21139 | 2482 | 61 | 9194 | 6634 | 269958 |
2022-05-13 | Butler | Alabama | 1013 | 5068 | 129 | 19448 | 6633 | 260592 |
2022-05-13 | Keweenaw | Michigan | 26083 | 523 | 14 | 2116 | 6616 | 247164 |
2022-05-13 | Alleghany | Virginia | 51005 | 3364 | 98 | 14860 | 6594 | 226379 |
2022-05-13 | Wheatland | Montana | 30107 | 386 | 14 | 2126 | 6585 | 181561 |
2022-05-13 | Conejos | Colorado | 8021 | 1763 | 54 | 8205 | 6581 | 214868 |
2022-05-13 | Baraga | Michigan | 26013 | 2222 | 54 | 8209 | 6578 | 270678 |
2022-05-13 | Clay | Tennessee | 47027 | 2300 | 50 | 7615 | 6565 | 302035 |
2022-05-13 | Cass | Texas | 48067 | 7260 | 197 | 30026 | 6560 | 241790 |
2022-05-13 | Dallas | Alabama | 1047 | 8429 | 244 | 37196 | 6559 | 226610 |
2022-05-13 | Ness | Kansas | 20135 | 780 | 18 | 2750 | 6545 | 283636 |
2022-05-13 | Quay | New Mexico | 35037 | 2006 | 54 | 8253 | 6543 | 243063 |
2022-05-13 | Dewey | Oklahoma | 40043 | 1064 | 32 | 4891 | 6542 | 217542 |
2022-05-13 | Franklin city | Virginia | 51620 | 2395 | 52 | 7967 | 6526 | 300615 |
2022-05-13 | Citrus | Florida | 12017 | 29988 | 976 | 149657 | 6521 | 200378 |
2022-05-13 | Coffee | Georgia | 13069 | 10872 | 282 | 43273 | 6516 | 251242 |
2022-05-13 | Montague | Texas | 48337 | 4694 | 129 | 19818 | 6509 | 236855 |
2022-05-13 | Union | Georgia | 13291 | 4888 | 159 | 24511 | 6486 | 199420 |
2022-05-13 | Logan | North Dakota | 38047 | 435 | 12 | 1850 | 6486 | 235135 |
2022-05-13 | Obion | Tennessee | 47131 | 10786 | 195 | 30069 | 6485 | 358708 |
2022-05-13 | Lewis | Kentucky | 21135 | 4529 | 86 | 13275 | 6478 | 341167 |
2022-05-13 | Greer | Oklahoma | 40055 | 1296 | 37 | 5712 | 6477 | 226890 |
2022-05-13 | Highlands | Florida | 12055 | 24304 | 686 | 106221 | 6458 | 228805 |
2022-05-13 | Day | South Dakota | 46037 | 1295 | 35 | 5424 | 6452 | 238753 |
2022-05-13 | Blaine | Nebraska | 31009 | 65 | 3 | 465 | 6451 | 139784 |
2022-05-13 | Giles | Tennessee | 47055 | 9448 | 190 | 29464 | 6448 | 320662 |
2022-05-13 | Culberson | Texas | 48109 | 514 | 14 | 2171 | 6448 | 236757 |
2022-05-13 | Hutchinson | Texas | 48233 | 6755 | 135 | 20938 | 6447 | 322619 |
2022-05-13 | Renville | North Dakota | 38075 | 556 | 15 | 2327 | 6446 | 238934 |
2022-05-13 | Cottle | Texas | 48101 | 319 | 9 | 1398 | 6437 | 228183 |
2022-05-13 | Runnels | Texas | 48399 | 2393 | 66 | 10264 | 6430 | 233144 |
2022-05-13 | Harding | New Mexico | 35021 | 85 | 4 | 625 | 6400 | 136000 |
2022-05-13 | Clay | Arkansas | 5021 | 4154 | 93 | 14551 | 6391 | 285478 |
2022-05-13 | Lynn | Texas | 48305 | 1556 | 38 | 5951 | 6385 | 261468 |
2022-05-13 | La Salle | Texas | 48283 | 2421 | 48 | 7520 | 6382 | 321941 |
2022-05-13 | Livingston | Missouri | 29117 | 3748 | 97 | 15227 | 6370 | 246141 |
2022-05-13 | Etowah | Alabama | 1055 | 28779 | 651 | 102268 | 6365 | 281407 |
2022-05-13 | Monroe | Iowa | 19135 | 1882 | 49 | 7707 | 6357 | 244193 |
2022-05-13 | Metcalfe | Kentucky | 21169 | 2875 | 64 | 10071 | 6354 | 285473 |
2022-05-13 | Clinch | Georgia | 13065 | 2124 | 42 | 6618 | 6346 | 320942 |
2022-05-13 | Montgomery | Arkansas | 5097 | 1525 | 57 | 8986 | 6343 | 169708 |
2022-05-13 | McIntosh | Oklahoma | 40091 | 4864 | 124 | 19596 | 6327 | 248213 |
2022-05-13 | Wood | Texas | 48499 | 8031 | 288 | 45539 | 6324 | 176354 |
2022-05-13 | Ozark | Missouri | 29153 | 1735 | 58 | 9174 | 6322 | 189121 |
2022-05-13 | Fayette | Indiana | 18041 | 6751 | 146 | 23102 | 6319 | 292225 |
2022-05-13 | Haakon | South Dakota | 46055 | 452 | 12 | 1899 | 6319 | 238020 |
2022-05-13 | Spalding | Georgia | 13255 | 15968 | 421 | 66703 | 6311 | 239389 |
2022-05-13 | Grenada | Mississippi | 28043 | 5533 | 131 | 20758 | 6310 | 266547 |
2022-05-13 | Monroe | Georgia | 13207 | 5927 | 174 | 27578 | 6309 | 214917 |
2022-05-13 | Fountain | Indiana | 18045 | 5491 | 103 | 16346 | 6301 | 335923 |
2022-05-13 | Butts | Georgia | 13035 | 6556 | 157 | 24936 | 6296 | 262913 |
2022-05-13 | Tishomingo | Mississippi | 28141 | 6172 | 122 | 19383 | 6294 | 318423 |
2022-05-13 | Potter | Texas | 48375 | 35779 | 739 | 117415 | 6293 | 304722 |
2022-05-13 | Laurens | Georgia | 13175 | 13827 | 299 | 47546 | 6288 | 290813 |
2022-05-13 | Perkins | South Dakota | 46105 | 684 | 18 | 2865 | 6282 | 238743 |
2022-05-13 | Kittson | Minnesota | 27069 | 1051 | 27 | 4298 | 6281 | 244532 |
2022-05-13 | Jackson | South Dakota | 46071 | 632 | 21 | 3344 | 6279 | 188995 |
2022-05-13 | Red River | Louisiana | 22081 | 2112 | 53 | 8442 | 6278 | 250177 |
2022-05-13 | Duval | Texas | 48131 | 3412 | 70 | 11157 | 6274 | 305816 |
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;