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_per_million descending
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 | Dyer | Tennessee | 47045 | 12826 | 203 | 37159 | 5463 | 345165 |
2022-05-13 | Moore | Tennessee | 47127 | 2239 | 40 | 6488 | 6165 | 345098 |
2022-05-13 | Elliott | Kentucky | 21063 | 2594 | 19 | 7517 | 2527 | 345084 |
2022-05-13 | Guadalupe | New Mexico | 35019 | 1482 | 17 | 4300 | 3953 | 344651 |
2022-05-13 | Macon | Tennessee | 47111 | 8478 | 145 | 24602 | 5893 | 344606 |
2022-05-13 | Tom Green | Texas | 48451 | 41068 | 553 | 119200 | 4639 | 344530 |
2022-05-13 | Adams | Illinois | 17001 | 22525 | 238 | 65435 | 3637 | 344234 |
2022-05-13 | Green | Kentucky | 21087 | 3761 | 45 | 10941 | 4112 | 343752 |
2022-05-13 | Stutsman | North Dakota | 38093 | 7113 | 97 | 20704 | 4685 | 343556 |
2022-05-13 | Floyd | Texas | 48153 | 1961 | 48 | 5712 | 8403 | 343312 |
2022-05-13 | Franklin | Washington | 53021 | 32668 | 214 | 95222 | 2247 | 343071 |
2022-05-13 | Zavala | Texas | 48507 | 4059 | 68 | 11840 | 5743 | 342820 |
2022-05-13 | Williamson | Illinois | 17199 | 22816 | 263 | 66597 | 3949 | 342598 |
2022-05-13 | Craighead | Arkansas | 5031 | 37767 | 329 | 110332 | 2981 | 342303 |
2022-05-13 | Poinsett | Arkansas | 5111 | 8052 | 127 | 23528 | 5397 | 342230 |
2022-05-13 | Dakota | Nebraska | 31043 | 6849 | 82 | 20026 | 4094 | 342005 |
2022-05-13 | Wayne | Tennessee | 47181 | 5700 | 72 | 16673 | 4318 | 341870 |
2022-05-13 | Hardin | Tennessee | 47071 | 8765 | 145 | 25652 | 5652 | 341688 |
2022-05-13 | Delta | Texas | 48119 | 1820 | 25 | 5331 | 4689 | 341399 |
2022-05-13 | Lewis | Kentucky | 21135 | 4529 | 86 | 13275 | 6478 | 341167 |
2022-05-13 | Bell | Kentucky | 21013 | 8868 | 149 | 26032 | 5723 | 340657 |
2022-05-13 | Gratiot | Michigan | 26057 | 13864 | 191 | 40711 | 4691 | 340546 |
2022-05-13 | Monroe | Kentucky | 21171 | 3624 | 77 | 10650 | 7230 | 340281 |
2022-05-13 | Mingo | West Virginia | 54059 | 7968 | 123 | 23424 | 5251 | 340163 |
2022-05-13 | Yalobusha | Mississippi | 28161 | 4114 | 57 | 12108 | 4707 | 339775 |
2022-05-13 | Harrison | Kentucky | 21097 | 6417 | 76 | 18886 | 4024 | 339775 |
2022-05-13 | Douglas | Illinois | 17041 | 6609 | 61 | 19465 | 3133 | 339532 |
2022-05-13 | Chester | Tennessee | 47023 | 5870 | 99 | 17297 | 5723 | 339365 |
2022-05-13 | Cumberland | Kentucky | 21057 | 2238 | 33 | 6614 | 4989 | 338373 |
2022-05-13 | Craig | Oklahoma | 40035 | 4785 | 55 | 14142 | 3889 | 338353 |
2022-05-13 | Labette | Kansas | 20099 | 6636 | 74 | 19618 | 3772 | 338260 |
2022-05-13 | Lamb | Texas | 48279 | 4356 | 122 | 12893 | 9462 | 337857 |
2022-05-13 | Saline | Illinois | 17165 | 7935 | 111 | 23491 | 4725 | 337788 |
2022-05-13 | Mercer | Kentucky | 21167 | 7401 | 106 | 21933 | 4832 | 337436 |
2022-05-13 | Chaves | New Mexico | 35005 | 21774 | 328 | 64615 | 5076 | 336980 |
2022-05-13 | De Baca | New Mexico | 35011 | 589 | 6 | 1748 | 3432 | 336956 |
2022-05-13 | Lewis | West Virginia | 54041 | 5359 | 86 | 15907 | 5406 | 336895 |
2022-05-13 | Hockley | Texas | 48219 | 7750 | 161 | 23021 | 6993 | 336649 |
2022-05-13 | Fountain | Indiana | 18045 | 5491 | 103 | 16346 | 6301 | 335923 |
2022-05-13 | Fayette | Illinois | 17051 | 7155 | 104 | 21336 | 4874 | 335348 |
2022-05-13 | Hopkins | Kentucky | 21107 | 14975 | 255 | 44686 | 5706 | 335116 |
2022-05-13 | West Carroll | Louisiana | 22123 | 3629 | 66 | 10830 | 6094 | 335087 |
2022-05-13 | Crawford | Illinois | 17033 | 6249 | 61 | 18667 | 3267 | 334761 |
2022-05-13 | Mississippi | Arkansas | 5093 | 13608 | 210 | 40651 | 5165 | 334751 |
2022-05-13 | Richland | Louisiana | 22083 | 6732 | 97 | 20122 | 4820 | 334559 |
2022-05-13 | Tippah | Mississippi | 28139 | 7361 | 109 | 22015 | 4951 | 334362 |
2022-05-13 | Laurel | Kentucky | 21125 | 20315 | 242 | 60813 | 3979 | 334056 |
2022-05-13 | Logan | Colorado | 8075 | 7480 | 109 | 22409 | 4864 | 333794 |
2022-05-13 | Marion | Kentucky | 21155 | 6433 | 85 | 19273 | 4410 | 333783 |
2022-05-13 | Pawnee | Kansas | 20145 | 2138 | 24 | 6414 | 3741 | 333333 |
2022-05-13 | Richland | Illinois | 17159 | 5167 | 83 | 15513 | 5350 | 333075 |
2022-05-13 | Muhlenberg | Kentucky | 21177 | 10190 | 121 | 30622 | 3951 | 332767 |
2022-05-13 | Eddy | North Dakota | 38027 | 761 | 6 | 2287 | 2623 | 332750 |
2022-05-13 | Hot Spring | Arkansas | 5059 | 11237 | 136 | 33771 | 4027 | 332741 |
2022-05-13 | Scott | Indiana | 18143 | 7943 | 106 | 23873 | 4440 | 332718 |
2022-05-13 | Randolph | Illinois | 17157 | 10567 | 132 | 31782 | 4153 | 332483 |
2022-05-13 | McCreary | Kentucky | 21147 | 5727 | 82 | 17231 | 4758 | 332366 |
2022-05-13 | Randolph | West Virginia | 54083 | 9533 | 89 | 28695 | 3101 | 332218 |
2022-05-13 | Bon Homme | South Dakota | 46009 | 2292 | 39 | 6901 | 5651 | 332125 |
2022-05-13 | Willacy | Texas | 48489 | 7089 | 130 | 21358 | 6086 | 331913 |
2022-05-13 | Wilson | Kansas | 20205 | 2828 | 43 | 8525 | 5043 | 331730 |
2022-05-13 | Hettinger | North Dakota | 38041 | 828 | 8 | 2499 | 3201 | 331332 |
2022-05-13 | Letcher | Kentucky | 21133 | 7140 | 114 | 21553 | 5289 | 331276 |
2022-05-13 | Ouachita | Louisiana | 22073 | 50769 | 754 | 153279 | 4919 | 331219 |
2022-05-13 | Greenville | South Carolina | 45045 | 173338 | 2008 | 523542 | 3835 | 331087 |
2022-05-13 | Bacon | Georgia | 13005 | 3692 | 78 | 11164 | 6986 | 330705 |
2022-05-13 | Gentry | Missouri | 29075 | 2172 | 31 | 6571 | 4717 | 330543 |
2022-05-13 | Ellsworth | Kansas | 20053 | 2016 | 32 | 6102 | 5244 | 330383 |
2022-05-13 | San Juan | New Mexico | 35045 | 40943 | 755 | 123958 | 6090 | 330297 |
2022-05-13 | Crosby | Texas | 48107 | 1894 | 45 | 5737 | 7843 | 330137 |
2022-05-13 | Lafayette | Florida | 12067 | 2780 | 61 | 8422 | 7242 | 330087 |
2022-05-13 | Pike | Kentucky | 21195 | 19099 | 307 | 57876 | 5304 | 329998 |
2022-05-13 | Aleutians East Borough | Alaska | 2013 | 1101 | 3 | 3337 | 899 | 329937 |
2022-05-13 | Carroll | Kentucky | 21041 | 3504 | 45 | 10631 | 4232 | 329602 |
2022-05-13 | Cass | North Dakota | 38017 | 59940 | 333 | 181923 | 1830 | 329480 |
2022-05-13 | Union | Mississippi | 28145 | 9487 | 122 | 28815 | 4233 | 329238 |
2022-05-13 | Norton city | Virginia | 51720 | 1310 | 22 | 3981 | 5526 | 329063 |
2022-05-13 | Lee | Arkansas | 5077 | 2912 | 59 | 8857 | 6661 | 328779 |
2022-05-13 | Caldwell | Texas | 48055 | 14339 | 176 | 43664 | 4030 | 328394 |
2022-05-13 | Summit | Utah | 49043 | 13832 | 26 | 42145 | 616 | 328200 |
2022-05-13 | Prentiss | Mississippi | 28117 | 8245 | 103 | 25126 | 4099 | 328146 |
2022-05-13 | Wayne | Illinois | 17191 | 5320 | 85 | 16215 | 5242 | 328091 |
2022-05-13 | Washington | Kentucky | 21229 | 3967 | 61 | 12095 | 5043 | 327986 |
2022-05-13 | Houston | Tennessee | 47083 | 2689 | 62 | 8201 | 7560 | 327886 |
2022-05-13 | Chickasaw | Mississippi | 28017 | 5603 | 96 | 17103 | 5613 | 327603 |
2022-05-13 | Grant | West Virginia | 54023 | 3786 | 56 | 11568 | 4840 | 327282 |
2022-05-13 | Potter | South Dakota | 46107 | 703 | 7 | 2153 | 3251 | 326521 |
2022-05-13 | Buena Vista | Iowa | 19021 | 6404 | 58 | 19620 | 2956 | 326401 |
2022-05-13 | Whitfield | Georgia | 13313 | 34132 | 439 | 104628 | 4195 | 326222 |
2022-05-13 | Mahnomen | Minnesota | 27087 | 1803 | 18 | 5527 | 3256 | 326216 |
2022-05-13 | Caldwell | Kentucky | 21033 | 4158 | 61 | 12747 | 4785 | 326194 |
2022-05-13 | White | Illinois | 17193 | 4413 | 59 | 13537 | 4358 | 325995 |
2022-05-13 | Arkansas | Arkansas | 5001 | 5696 | 79 | 17486 | 4517 | 325746 |
2022-05-13 | Henderson | Tennessee | 47077 | 9150 | 160 | 28117 | 5690 | 325425 |
2022-05-13 | Summit | Colorado | 8117 | 10087 | 14 | 31011 | 451 | 325271 |
2022-05-13 | Taylor | Florida | 12123 | 7015 | 101 | 21569 | 4682 | 325235 |
2022-05-13 | Union | Illinois | 17181 | 5415 | 68 | 16653 | 4083 | 325166 |
2022-05-13 | Kershaw | South Carolina | 45055 | 21623 | 261 | 66551 | 3921 | 324908 |
2022-05-13 | Magoffin | Kentucky | 21153 | 3950 | 51 | 12161 | 4193 | 324808 |
2022-05-13 | Lawrence | Tennessee | 47099 | 14329 | 203 | 44142 | 4598 | 324611 |
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;