latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,133 rows sorted by cases_per_million descending
This data as json, yaml, copyable, CSV (advanced)
state
- 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 ▲ |
---|---|---|---|---|---|---|---|---|
2021-01-24 | Crowley | Colorado | 8025 | 1764 | 14 | 6061 | 2309 | 291041 |
2021-01-24 | Dewey | South Dakota | 46041 | 1384 | 18 | 5892 | 3054 | 234894 |
2021-01-24 | Bent | Colorado | 8011 | 1283 | 20 | 5577 | 3586 | 230051 |
2021-01-24 | Lincoln | Arkansas | 5079 | 2996 | 35 | 13024 | 2687 | 230036 |
2021-01-24 | Chattahoochee | Georgia | 13053 | 2483 | 3 | 10907 | 275 | 227651 |
2021-01-24 | Lake | Tennessee | 47095 | 1584 | 21 | 7016 | 2993 | 225769 |
2021-01-24 | Norton | Kansas | 20137 | 1198 | 27 | 5361 | 5036 | 223465 |
2021-01-24 | Bon Homme | South Dakota | 46009 | 1502 | 23 | 6901 | 3332 | 217649 |
2021-01-24 | Buffalo | South Dakota | 46017 | 416 | 12 | 1962 | 6116 | 212028 |
2021-01-24 | Trousdale | Tennessee | 47169 | 2307 | 16 | 11284 | 1417 | 204448 |
2021-01-24 | Buena Vista | Iowa | 19021 | 3963 | 30 | 19620 | 1529 | 201987 |
2021-01-24 | Ellsworth | Kansas | 20053 | 1151 | 4 | 6102 | 655 | 188626 |
2021-01-24 | Dakota | Nebraska | 31043 | 3762 | 67 | 20026 | 3345 | 187855 |
2021-01-24 | Eddy | North Dakota | 38027 | 426 | 6 | 2287 | 2623 | 186270 |
2021-01-24 | Alfalfa | Oklahoma | 40003 | 1062 | 5 | 5702 | 876 | 186250 |
2021-01-24 | Jackson | Arkansas | 5067 | 3028 | 30 | 16719 | 1794 | 181111 |
2021-01-24 | Lafayette | Florida | 12067 | 1515 | 23 | 8422 | 2730 | 179886 |
2021-01-24 | Lee | Arkansas | 5077 | 1587 | 30 | 8857 | 3387 | 179180 |
2021-01-24 | Childress | Texas | 48075 | 1293 | 13 | 7306 | 1779 | 176977 |
2021-01-24 | Seward | Kansas | 20175 | 3731 | 28 | 21428 | 1306 | 174117 |
2021-01-24 | Nobles | Minnesota | 27105 | 3746 | 47 | 21629 | 2173 | 173193 |
2021-01-24 | Bethel Census Area | Alaska | 2050 | 3182 | 14 | 18386 | 761 | 173066 |
2021-01-24 | Hale | Texas | 48189 | 5774 | 140 | 33406 | 4190 | 172843 |
2021-01-24 | Lassen | California | 6035 | 5269 | 16 | 30573 | 523 | 172341 |
2021-01-24 | Menominee | Wisconsin | 55078 | 784 | 11 | 4556 | 2414 | 172080 |
2021-01-24 | Forest | Pennsylvania | 42053 | 1247 | 12 | 7247 | 1655 | 172071 |
2021-01-24 | Pawnee | Kansas | 20145 | 1094 | 8 | 6414 | 1247 | 170564 |
2021-01-24 | Luce | Michigan | 26095 | 1058 | 1 | 6229 | 160 | 169850 |
2021-01-24 | Foster | North Dakota | 38031 | 544 | 19 | 3210 | 5919 | 169470 |
2021-01-24 | Big Horn | Montana | 30003 | 2252 | 69 | 13319 | 5180 | 169081 |
2021-01-24 | Sheridan | Kansas | 20179 | 419 | 0 | 2521 | 0 | 166203 |
2021-01-24 | Texas | Oklahoma | 40139 | 3278 | 20 | 19983 | 1000 | 164039 |
2021-01-24 | Walsh | North Dakota | 38099 | 1726 | 24 | 10641 | 2255 | 162202 |
2021-01-24 | Wayne | Tennessee | 47181 | 2704 | 24 | 16673 | 1439 | 162178 |
2021-01-24 | Aurora | South Dakota | 46003 | 444 | 12 | 2751 | 4362 | 161395 |
2021-01-24 | Ford | Kansas | 20057 | 5424 | 10 | 33619 | 297 | 161337 |
2021-01-24 | Yuma | Arizona | 4027 | 34269 | 673 | 213787 | 3147 | 160295 |
2021-01-24 | Finney | Kansas | 20055 | 5833 | 67 | 36467 | 1837 | 159952 |
2021-01-24 | Potter | South Dakota | 46107 | 343 | 3 | 2153 | 1393 | 159312 |
2021-01-24 | Logan | Colorado | 8075 | 3567 | 58 | 22409 | 2588 | 159177 |
2021-01-24 | McKinley | New Mexico | 35031 | 11237 | 404 | 71367 | 5660 | 157453 |
2021-01-24 | Santa Cruz | Arizona | 4023 | 7297 | 140 | 46498 | 3010 | 156931 |
2021-01-24 | Stutsman | North Dakota | 38093 | 3224 | 75 | 20704 | 3622 | 155718 |
2021-01-24 | Lincoln | Colorado | 8073 | 886 | 3 | 5701 | 526 | 155411 |
2021-01-24 | Lyman | South Dakota | 46085 | 587 | 10 | 3781 | 2644 | 155249 |
2021-01-24 | East Carroll | Louisiana | 22035 | 1064 | 20 | 6861 | 2915 | 155079 |
2021-01-24 | Morton | North Dakota | 38059 | 4815 | 93 | 31364 | 2965 | 153519 |
2021-01-24 | Chicot | Arkansas | 5017 | 1538 | 38 | 10118 | 3755 | 152006 |
2021-01-24 | Nelson | North Dakota | 38063 | 436 | 12 | 2879 | 4168 | 151441 |
2021-01-24 | Lee | Kentucky | 21129 | 1121 | 18 | 7403 | 2431 | 151425 |
2021-01-24 | Sioux | North Dakota | 38085 | 639 | 11 | 4230 | 2600 | 151063 |
2021-01-24 | Benson | North Dakota | 38005 | 1019 | 18 | 6832 | 2634 | 149151 |
2021-01-24 | Galax city | Virginia | 51640 | 946 | 38 | 6347 | 5987 | 149046 |
2021-01-24 | Lubbock | Texas | 48303 | 46241 | 671 | 310569 | 2160 | 148891 |
2021-01-24 | Burleigh | North Dakota | 38015 | 14159 | 184 | 95626 | 1924 | 148066 |
2021-01-24 | Dickey | North Dakota | 38021 | 721 | 32 | 4872 | 6568 | 147988 |
2021-01-24 | Cass | Illinois | 17017 | 1794 | 31 | 12147 | 2552 | 147690 |
2021-01-24 | Culberson | Texas | 48109 | 320 | 4 | 2171 | 1842 | 147397 |
2021-01-24 | Maverick | Texas | 48323 | 8593 | 230 | 58722 | 3916 | 146333 |
2021-01-24 | Toole | Montana | 30101 | 690 | 8 | 4736 | 1689 | 145692 |
2021-01-24 | Davison | South Dakota | 46035 | 2879 | 57 | 19775 | 2882 | 145587 |
2021-01-24 | Madison | Idaho | 16065 | 5760 | 21 | 39907 | 526 | 144335 |
2021-01-24 | Rolette | North Dakota | 38079 | 2045 | 28 | 14176 | 1975 | 144257 |
2021-01-24 | Woodward | Oklahoma | 40153 | 2905 | 12 | 20211 | 593 | 143733 |
2021-01-24 | Faulk | South Dakota | 46049 | 330 | 13 | 2299 | 5654 | 143540 |
2021-01-24 | East Feliciana | Louisiana | 22037 | 2723 | 98 | 19135 | 5121 | 142304 |
2021-01-24 | Haywood | Tennessee | 47075 | 2455 | 48 | 17304 | 2773 | 141874 |
2021-01-24 | Val Verde | Texas | 48465 | 6946 | 169 | 49025 | 3447 | 141682 |
2021-01-24 | Colfax | Nebraska | 31037 | 1517 | 20 | 10709 | 1867 | 141656 |
2021-01-24 | Republic | Kansas | 20157 | 656 | 13 | 4636 | 2804 | 141501 |
2021-01-24 | Kearny | Kansas | 20093 | 543 | 9 | 3838 | 2344 | 141479 |
2021-01-24 | Lamb | Texas | 48279 | 1823 | 76 | 12893 | 5894 | 141394 |
2021-01-24 | Imperial | California | 6025 | 25581 | 492 | 181215 | 2715 | 141163 |
2021-01-24 | Lawrence | Illinois | 17101 | 2207 | 30 | 15678 | 1913 | 140770 |
2021-01-24 | Beadle | South Dakota | 46005 | 2596 | 39 | 18453 | 2113 | 140681 |
2021-01-24 | Douglas | South Dakota | 46043 | 410 | 9 | 2921 | 3081 | 140362 |
2021-01-24 | Plymouth | Iowa | 19149 | 3532 | 70 | 25177 | 2780 | 140286 |
2021-01-24 | Scurry | Texas | 48415 | 2336 | 49 | 16703 | 2933 | 139855 |
2021-01-24 | Whitfield | Georgia | 13313 | 14604 | 165 | 104628 | 1577 | 139580 |
2021-01-24 | Crawford | Iowa | 19047 | 2347 | 24 | 16820 | 1426 | 139536 |
2021-01-24 | Crockett | Texas | 48105 | 483 | 14 | 3464 | 4041 | 139434 |
2021-01-24 | Fayette | Illinois | 17051 | 2967 | 53 | 21336 | 2484 | 139060 |
2021-01-24 | Yell | Arkansas | 5149 | 2966 | 59 | 21341 | 2764 | 138981 |
2021-01-24 | Minnehaha | South Dakota | 46099 | 26760 | 300 | 193134 | 1553 | 138556 |
2021-01-24 | Griggs | North Dakota | 38039 | 308 | 2 | 2231 | 896 | 138054 |
2021-01-24 | Nemaha | Kansas | 20131 | 1412 | 50 | 10231 | 4887 | 138011 |
2021-01-24 | Grand Forks | North Dakota | 38035 | 9578 | 72 | 69451 | 1036 | 137910 |
2021-01-24 | Potter | Texas | 48375 | 16188 | 352 | 117415 | 2997 | 137869 |
2021-01-24 | Sanborn | South Dakota | 46111 | 323 | 3 | 2344 | 1279 | 137798 |
2021-01-24 | Clinton | Illinois | 17027 | 5174 | 86 | 37562 | 2289 | 137745 |
2021-01-24 | Wilbarger | Texas | 48487 | 1755 | 46 | 12769 | 3602 | 137442 |
2021-01-24 | Pickett | Tennessee | 47137 | 692 | 20 | 5048 | 3961 | 137083 |
2021-01-24 | Deaf Smith | Texas | 48117 | 2541 | 61 | 18546 | 3289 | 137010 |
2021-01-24 | Golden Valley | North Dakota | 38033 | 241 | 2 | 1761 | 1135 | 136854 |
2021-01-24 | Okfuskee | Oklahoma | 40107 | 1637 | 16 | 11993 | 1334 | 136496 |
2021-01-24 | Webb | Texas | 48479 | 37761 | 592 | 276652 | 2139 | 136492 |
2021-01-24 | Madison | Louisiana | 22065 | 1494 | 28 | 10951 | 2556 | 136425 |
2021-01-24 | Gove | Kansas | 20063 | 359 | 22 | 2636 | 8345 | 136191 |
2021-01-24 | Sevier | Arkansas | 5133 | 2312 | 24 | 17007 | 1411 | 135944 |
2021-01-24 | Gratiot | Michigan | 26057 | 5530 | 98 | 40711 | 2407 | 135835 |
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;