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 | Pike | Illinois | 17149 | 5050 | 70 | 15561 | 4498 | 324529 |
2022-05-13 | Lawrence | Arkansas | 5075 | 5324 | 78 | 16406 | 4754 | 324515 |
2022-05-13 | Hemphill | Texas | 48211 | 1239 | 7 | 3819 | 1832 | 324430 |
2022-05-13 | Calhoun | Illinois | 17013 | 1537 | 8 | 4739 | 1688 | 324330 |
2022-05-13 | Warren | Kentucky | 21227 | 43102 | 372 | 132896 | 2799 | 324328 |
2022-05-13 | Pulaski | Illinois | 17153 | 1730 | 19 | 5335 | 3561 | 324273 |
2022-05-13 | Warrick | Indiana | 18173 | 20420 | 239 | 62998 | 3793 | 324137 |
2022-05-13 | Brown | Wisconsin | 55009 | 85688 | 557 | 264542 | 2105 | 323910 |
2022-05-13 | Wabash | Illinois | 17185 | 3730 | 31 | 11520 | 2690 | 323784 |
2022-05-13 | Carter | Kentucky | 21043 | 8675 | 107 | 26797 | 3992 | 323730 |
2022-05-13 | Fremont | Colorado | 8043 | 15481 | 187 | 47839 | 3908 | 323606 |
2022-05-13 | Hale | Alabama | 1065 | 4741 | 106 | 14651 | 7235 | 323595 |
2022-05-13 | Grand Forks | North Dakota | 38035 | 22468 | 125 | 69451 | 1799 | 323508 |
2022-05-13 | Carroll | Tennessee | 47017 | 8978 | 156 | 27767 | 5618 | 323333 |
2022-05-13 | Lexington | South Carolina | 45063 | 96569 | 872 | 298750 | 2918 | 323243 |
2022-05-13 | Calhoun | Mississippi | 28013 | 4641 | 71 | 14361 | 4943 | 323166 |
2022-05-13 | Doniphan | Kansas | 20043 | 2456 | 34 | 7600 | 4473 | 323157 |
2022-05-13 | Cocke | Tennessee | 47029 | 11634 | 217 | 36004 | 6027 | 323130 |
2022-05-13 | Matanuska-Susitna Borough | Alaska | 2170 | 34981 | 236 | 108317 | 2178 | 322950 |
2022-05-13 | Neosho | Kansas | 20133 | 5168 | 66 | 16007 | 4123 | 322858 |
2022-05-13 | Hardee | Florida | 12049 | 8696 | 124 | 26937 | 4603 | 322827 |
2022-05-13 | Seward | Kansas | 20175 | 6916 | 61 | 21428 | 2846 | 322755 |
2022-05-13 | Nobles | Minnesota | 27105 | 6980 | 60 | 21629 | 2774 | 322714 |
2022-05-13 | Hutchinson | Texas | 48233 | 6755 | 135 | 20938 | 6447 | 322619 |
2022-05-13 | Major | Oklahoma | 40093 | 2461 | 41 | 7629 | 5374 | 322584 |
2022-05-13 | Allen | Kansas | 20001 | 3989 | 53 | 12369 | 4284 | 322499 |
2022-05-13 | Pontotoc | Mississippi | 28115 | 10364 | 145 | 32174 | 4506 | 322123 |
2022-05-13 | Gila | Arizona | 4007 | 17398 | 381 | 54018 | 7053 | 322077 |
2022-05-13 | Kearny | Kansas | 20093 | 1236 | 20 | 3838 | 5211 | 322042 |
2022-05-13 | La Salle | Texas | 48283 | 2421 | 48 | 7520 | 6382 | 321941 |
2022-05-13 | Overton | Tennessee | 47133 | 7157 | 123 | 22241 | 5530 | 321793 |
2022-05-13 | Turner | Georgia | 13287 | 2569 | 61 | 7985 | 7639 | 321728 |
2022-05-13 | DeWitt | Texas | 48123 | 6486 | 99 | 20160 | 4910 | 321726 |
2022-05-13 | Jackson | Kentucky | 21109 | 4286 | 80 | 13329 | 6001 | 321554 |
2022-05-13 | Yell | Arkansas | 5149 | 6859 | 106 | 21341 | 4966 | 321400 |
2022-05-13 | McDowell | West Virginia | 54047 | 5662 | 75 | 17624 | 4255 | 321266 |
2022-05-13 | Clinton | Illinois | 17027 | 12066 | 122 | 37562 | 3247 | 321228 |
2022-05-13 | Clinch | Georgia | 13065 | 2124 | 42 | 6618 | 6346 | 320942 |
2022-05-13 | Stearns | Minnesota | 27145 | 51693 | 368 | 161075 | 2284 | 320925 |
2022-05-13 | Monroe | West Virginia | 54063 | 4260 | 46 | 13275 | 3465 | 320903 |
2022-05-13 | Marion | Illinois | 17121 | 11933 | 217 | 37205 | 5832 | 320736 |
2022-05-13 | Giles | Tennessee | 47055 | 9448 | 190 | 29464 | 6448 | 320662 |
2022-05-13 | Winston | Alabama | 1133 | 7576 | 131 | 23629 | 5544 | 320622 |
2022-05-13 | Greene | Tennessee | 47059 | 22140 | 374 | 69069 | 5414 | 320549 |
2022-05-13 | Decatur | Tennessee | 47039 | 3738 | 70 | 11663 | 6001 | 320500 |
2022-05-13 | Valdez-Cordova Census Area | Alaska | 2261 | 2948 | 19 | 9202 | 2064 | 320365 |
2022-05-13 | Winn | Louisiana | 22127 | 4452 | 64 | 13904 | 4602 | 320195 |
2022-05-13 | Jackson | Florida | 12063 | 14854 | 280 | 46414 | 6032 | 320032 |
2022-05-13 | Champaign | Illinois | 17019 | 67086 | 296 | 209689 | 1411 | 319930 |
2022-05-13 | Christian | Illinois | 17021 | 10330 | 131 | 32304 | 4055 | 319774 |
2022-05-13 | Utah | Utah | 49049 | 203286 | 791 | 636235 | 1243 | 319514 |
2022-05-13 | Greenwood | South Carolina | 45047 | 22607 | 305 | 70811 | 4307 | 319258 |
2022-05-13 | Dillon | South Carolina | 45033 | 9729 | 144 | 30479 | 4724 | 319203 |
2022-05-13 | Sioux | North Dakota | 38085 | 1350 | 19 | 4230 | 4491 | 319148 |
2022-05-13 | Franklin | Illinois | 17055 | 12272 | 178 | 38469 | 4627 | 319010 |
2022-05-13 | Robertson | Kentucky | 21201 | 672 | 21 | 2108 | 9962 | 318785 |
2022-05-13 | Lyman | South Dakota | 46085 | 1205 | 12 | 3781 | 3173 | 318698 |
2022-05-13 | Vanderburgh | Indiana | 18163 | 57824 | 640 | 181451 | 3527 | 318675 |
2022-05-13 | Tishomingo | Mississippi | 28141 | 6172 | 122 | 19383 | 6294 | 318423 |
2022-05-13 | Brown | Texas | 48049 | 12056 | 253 | 37864 | 6681 | 318402 |
2022-05-13 | Itawamba | Mississippi | 28057 | 7430 | 144 | 23390 | 6156 | 317657 |
2022-05-13 | Madison | Idaho | 16065 | 12674 | 50 | 39907 | 1252 | 317588 |
2022-05-13 | Walsh | North Dakota | 38099 | 3374 | 34 | 10641 | 3195 | 317075 |
2022-05-13 | Chippewa | Michigan | 26033 | 11841 | 120 | 37349 | 3212 | 317036 |
2022-05-13 | Nemaha | Kansas | 20131 | 3243 | 60 | 10231 | 5864 | 316977 |
2022-05-13 | Wasatch | Utah | 49051 | 10804 | 35 | 34091 | 1026 | 316916 |
2022-05-13 | Pontotoc | Oklahoma | 40123 | 12132 | 150 | 38284 | 3918 | 316894 |
2022-05-13 | Huntington | Indiana | 18069 | 11572 | 157 | 36520 | 4299 | 316867 |
2022-05-13 | Grant | Kansas | 20067 | 2265 | 36 | 7150 | 5034 | 316783 |
2022-05-13 | Pershing | Nevada | 32027 | 2130 | 29 | 6725 | 4312 | 316728 |
2022-05-13 | Charles Mix | South Dakota | 46023 | 2942 | 35 | 9292 | 3766 | 316616 |
2022-05-13 | Finney | Kansas | 20055 | 11545 | 115 | 36467 | 3153 | 316587 |
2022-05-13 | Clark | Illinois | 17023 | 4887 | 60 | 15441 | 3885 | 316495 |
2022-05-13 | Madison | Florida | 12079 | 5849 | 97 | 18493 | 5245 | 316281 |
2022-05-13 | Ford | Kansas | 20057 | 10629 | 113 | 33619 | 3361 | 316160 |
2022-05-13 | Buffalo | South Dakota | 46017 | 620 | 18 | 1962 | 9174 | 316004 |
2022-05-13 | Kandiyohi | Minnesota | 27067 | 13649 | 139 | 43199 | 3217 | 315956 |
2022-05-13 | Ramsey | North Dakota | 38071 | 3638 | 57 | 11519 | 4948 | 315826 |
2022-05-13 | Franklin | Alabama | 1059 | 9903 | 139 | 31362 | 4432 | 315764 |
2022-05-13 | Sitka City and Borough | Alaska | 2220 | 2681 | 5 | 8493 | 588 | 315671 |
2022-05-13 | Warren | Tennessee | 47177 | 13028 | 177 | 41277 | 4288 | 315623 |
2022-05-13 | Monroe | Tennessee | 47123 | 14681 | 244 | 46545 | 5242 | 315415 |
2022-05-13 | Van Buren | Tennessee | 47175 | 1852 | 48 | 5872 | 8174 | 315395 |
2022-05-13 | Effingham | Illinois | 17049 | 10711 | 150 | 34008 | 4410 | 314955 |
2022-05-13 | Crockett | Texas | 48105 | 1091 | 19 | 3464 | 5484 | 314953 |
2022-05-13 | Raleigh | West Virginia | 54081 | 23094 | 349 | 73361 | 4757 | 314799 |
2022-05-13 | Mercer | North Dakota | 38057 | 2577 | 24 | 8187 | 2931 | 314767 |
2022-05-13 | Gulf | Florida | 12045 | 4292 | 79 | 13639 | 5792 | 314685 |
2022-05-13 | Broward | Florida | 12011 | 614436 | 5852 | 1952778 | 2996 | 314647 |
2022-05-13 | Fond du Lac | Wisconsin | 55039 | 32524 | 278 | 103403 | 2688 | 314536 |
2022-05-13 | Chester | South Carolina | 45023 | 10134 | 153 | 32244 | 4745 | 314291 |
2022-05-13 | Cumberland | Illinois | 17035 | 3381 | 49 | 10766 | 4551 | 314044 |
2022-05-13 | Clay | Minnesota | 27027 | 20161 | 124 | 64222 | 1930 | 313926 |
2022-05-13 | Dodge | Wisconsin | 55027 | 27570 | 340 | 87839 | 3870 | 313869 |
2022-05-13 | Nelson | Kentucky | 21179 | 14507 | 153 | 46233 | 3309 | 313780 |
2022-05-13 | Putnam | Tennessee | 47141 | 25178 | 304 | 80245 | 3788 | 313764 |
2022-05-13 | Apache | Arizona | 4001 | 22540 | 614 | 71887 | 8541 | 313547 |
2022-05-13 | Nassau | New York | 36059 | 425386 | 3853 | 1356924 | 2839 | 313492 |
2022-05-13 | Lee | Mississippi | 28081 | 26783 | 301 | 85436 | 3523 | 313486 |
2022-05-13 | Mineral | Colorado | 8079 | 241 | 2 | 769 | 2600 | 313394 |
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;