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 fips
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 | Madera | California | 6039 | 43685 | 365 | 157327 | 2320 | 277670 |
2022-05-13 | Marin | California | 6041 | 38685 | 293 | 258826 | 1132 | 149463 |
2022-05-13 | Mariposa | California | 6043 | 3145 | 35 | 17203 | 2034 | 182816 |
2022-05-13 | Mendocino | California | 6045 | 16568 | 124 | 86749 | 1429 | 190987 |
2022-05-13 | Merced | California | 6047 | 72959 | 823 | 277680 | 2963 | 262744 |
2022-05-13 | Modoc | California | 6049 | 1000 | 8 | 8841 | 904 | 113109 |
2022-05-13 | Mono | California | 6051 | 3144 | 6 | 14444 | 415 | 217668 |
2022-05-13 | Monterey | California | 6053 | 95140 | 744 | 434061 | 1714 | 219185 |
2022-05-13 | Napa | California | 6055 | 27765 | 143 | 137744 | 1038 | 201569 |
2022-05-13 | Nevada | California | 6057 | 17503 | 127 | 99755 | 1273 | 175459 |
2022-05-13 | Orange | California | 6059 | 600384 | 7023 | 3175692 | 2211 | 189056 |
2022-05-13 | Placer | California | 6061 | 71527 | 628 | 398329 | 1576 | 179567 |
2022-05-13 | Plumas | California | 6063 | 3379 | 13 | 18807 | 691 | 179667 |
2022-05-13 | Riverside | California | 6065 | 626695 | 6527 | 2470546 | 2641 | 253666 |
2022-05-13 | Sacramento | California | 6067 | 314407 | 3159 | 1552058 | 2035 | 202574 |
2022-05-13 | San Benito | California | 6069 | 13636 | 98 | 62808 | 1560 | 217106 |
2022-05-13 | San Bernardino | California | 6071 | 597377 | 7423 | 2180085 | 3404 | 274015 |
2022-05-13 | San Diego | California | 6073 | 824586 | 5271 | 3338330 | 1578 | 247005 |
2022-05-13 | San Francisco | California | 6075 | 143959 | 866 | 881549 | 982 | 163302 |
2022-05-13 | San Joaquin | California | 6077 | 178501 | 2236 | 762148 | 2933 | 234207 |
2022-05-13 | San Luis Obispo | California | 6079 | 57556 | 478 | 283111 | 1688 | 203298 |
2022-05-13 | San Mateo | California | 6081 | 137238 | 755 | 766573 | 984 | 179027 |
2022-05-13 | Santa Barbara | California | 6083 | 92683 | 693 | 446499 | 1552 | 207577 |
2022-05-13 | Santa Clara | California | 6085 | 342015 | 2298 | 1927852 | 1192 | 177407 |
2022-05-13 | Santa Cruz | California | 6087 | 52532 | 263 | 273213 | 962 | 192274 |
2022-05-13 | Shasta | California | 6089 | 36988 | 648 | 180080 | 3598 | 205397 |
2022-05-13 | Sierra | California | 6091 | 324 | 4 | 3005 | 1331 | 107820 |
2022-05-13 | Siskiyou | California | 6093 | 7478 | 105 | 43539 | 2411 | 171754 |
2022-05-13 | Solano | California | 6095 | 89419 | 451 | 447643 | 1007 | 199755 |
2022-05-13 | Sonoma | California | 6097 | 90191 | 490 | 494336 | 991 | 182448 |
2022-05-13 | Stanislaus | California | 6099 | 136645 | 1694 | 550660 | 3076 | 248147 |
2022-05-13 | Sutter | California | 6101 | 23045 | 234 | 96971 | 2413 | 237648 |
2022-05-13 | Tehama | California | 6103 | 14753 | 201 | 65084 | 3088 | 226676 |
2022-05-13 | Trinity | California | 6105 | 1485 | 20 | 12285 | 1628 | 120879 |
2022-05-13 | Tulare | California | 6107 | 136125 | 1469 | 466195 | 3151 | 291991 |
2022-05-13 | Tuolumne | California | 6109 | 13758 | 182 | 54478 | 3340 | 252542 |
2022-05-13 | Ventura | California | 6111 | 186062 | 1498 | 846006 | 1770 | 219929 |
2022-05-13 | Yolo | California | 6113 | 41061 | 316 | 220500 | 1433 | 186217 |
2022-05-13 | Yuba | California | 6115 | 17944 | 122 | 78668 | 1550 | 228097 |
2022-05-13 | Adams | Colorado | 8001 | 137720 | 1380 | 517421 | 2667 | 266166 |
2022-05-13 | Alamosa | Colorado | 8003 | 4560 | 62 | 16233 | 3819 | 280909 |
2022-05-13 | Arapahoe | Colorado | 8005 | 158561 | 1284 | 656590 | 1955 | 241491 |
2022-05-13 | Archuleta | Colorado | 8007 | 2926 | 16 | 14029 | 1140 | 208567 |
2022-05-13 | Baca | Colorado | 8009 | 855 | 13 | 3581 | 3630 | 238760 |
2022-05-13 | Bent | Colorado | 8011 | 2560 | 47 | 5577 | 8427 | 459028 |
2022-05-13 | Boulder | Colorado | 8013 | 68435 | 373 | 326196 | 1143 | 209797 |
2022-05-13 | Broomfield | Colorado | 8014 | 13997 | 116 | 70465 | 1646 | 198637 |
2022-05-13 | Chaffee | Colorado | 8015 | 4749 | 47 | 20356 | 2308 | 233297 |
2022-05-13 | Cheyenne | Colorado | 8017 | 322 | 9 | 1831 | 4915 | 175860 |
2022-05-13 | Clear Creek | Colorado | 8019 | 1601 | 12 | 9700 | 1237 | 165051 |
2022-05-13 | Conejos | Colorado | 8021 | 1763 | 54 | 8205 | 6581 | 214868 |
2022-05-13 | Costilla | Colorado | 8023 | 708 | 18 | 3887 | 4630 | 182145 |
2022-05-13 | Crowley | Colorado | 8025 | 3347 | 30 | 6061 | 4949 | 552219 |
2022-05-13 | Custer | Colorado | 8027 | 656 | 21 | 5068 | 4143 | 129439 |
2022-05-13 | Delta | Colorado | 8029 | 6232 | 140 | 31162 | 4492 | 199987 |
2022-05-13 | Denver | Colorado | 8031 | 177033 | 1360 | 727211 | 1870 | 243441 |
2022-05-13 | Dolores | Colorado | 8033 | 367 | 8 | 2055 | 3892 | 178588 |
2022-05-13 | Douglas | Colorado | 8035 | 81400 | 460 | 351154 | 1309 | 231807 |
2022-05-13 | Eagle | Colorado | 8037 | 16274 | 35 | 55127 | 634 | 295209 |
2022-05-13 | Elbert | Colorado | 8039 | 4880 | 40 | 26729 | 1496 | 182573 |
2022-05-13 | El Paso | Colorado | 8041 | 190541 | 1695 | 720403 | 2352 | 264492 |
2022-05-13 | Fremont | Colorado | 8043 | 15481 | 187 | 47839 | 3908 | 323606 |
2022-05-13 | Garfield | Colorado | 8045 | 15076 | 91 | 60061 | 1515 | 251011 |
2022-05-13 | Gilpin | Colorado | 8047 | 977 | 4 | 6243 | 640 | 156495 |
2022-05-13 | Grand | Colorado | 8049 | 3599 | 28 | 15734 | 1779 | 228740 |
2022-05-13 | Gunnison | Colorado | 8051 | 3407 | 14 | 17462 | 801 | 195109 |
2022-05-13 | Hinsdale | Colorado | 8053 | 131 | 0 | 820 | 0 | 159756 |
2022-05-13 | Huerfano | Colorado | 8055 | 1452 | 35 | 6897 | 5074 | 210526 |
2022-05-13 | Jackson | Colorado | 8057 | 166 | 0 | 1392 | 0 | 119252 |
2022-05-13 | Jefferson | Colorado | 8059 | 128067 | 1356 | 582881 | 2326 | 219713 |
2022-05-13 | Kiowa | Colorado | 8061 | 336 | 6 | 1406 | 4267 | 238975 |
2022-05-13 | Kit Carson | Colorado | 8063 | 1621 | 33 | 7097 | 4649 | 228406 |
2022-05-13 | Lake | Colorado | 8065 | 1843 | 2 | 8127 | 246 | 226774 |
2022-05-13 | La Plata | Colorado | 8067 | 13002 | 86 | 56221 | 1529 | 231265 |
2022-05-13 | Larimer | Colorado | 8069 | 81210 | 505 | 356899 | 1414 | 227543 |
2022-05-13 | Las Animas | Colorado | 8071 | 3635 | 43 | 14506 | 2964 | 250585 |
2022-05-13 | Lincoln | Colorado | 8073 | 2199 | 9 | 5701 | 1578 | 385721 |
2022-05-13 | Logan | Colorado | 8075 | 7480 | 109 | 22409 | 4864 | 333794 |
2022-05-13 | Mesa | Colorado | 8077 | 43093 | 565 | 154210 | 3663 | 279443 |
2022-05-13 | Mineral | Colorado | 8079 | 241 | 2 | 769 | 2600 | 313394 |
2022-05-13 | Moffat | Colorado | 8081 | 3062 | 52 | 13283 | 3914 | 230520 |
2022-05-13 | Montezuma | Colorado | 8083 | 6229 | 81 | 26183 | 3093 | 237902 |
2022-05-13 | Montrose | Colorado | 8085 | 9398 | 160 | 42758 | 3741 | 219795 |
2022-05-13 | Morgan | Colorado | 8087 | 5735 | 138 | 29068 | 4747 | 197295 |
2022-05-13 | Otero | Colorado | 8089 | 4322 | 130 | 18278 | 7112 | 236459 |
2022-05-13 | Ouray | Colorado | 8091 | 884 | 6 | 4952 | 1211 | 178513 |
2022-05-13 | Park | Colorado | 8093 | 2913 | 20 | 18845 | 1061 | 154576 |
2022-05-13 | Phillips | Colorado | 8095 | 894 | 19 | 4265 | 4454 | 209613 |
2022-05-13 | Pitkin | Colorado | 8097 | 6676 | 7 | 17767 | 393 | 375752 |
2022-05-13 | Prowers | Colorado | 8099 | 2654 | 51 | 12172 | 4189 | 218041 |
2022-05-13 | Pueblo | Colorado | 8101 | 47690 | 802 | 168424 | 4761 | 283154 |
2022-05-13 | Rio Blanco | Colorado | 8103 | 1696 | 13 | 6324 | 2055 | 268184 |
2022-05-13 | Rio Grande | Colorado | 8105 | 2856 | 46 | 11267 | 4082 | 253483 |
2022-05-13 | Routt | Colorado | 8107 | 6562 | 25 | 25638 | 975 | 255948 |
2022-05-13 | Saguache | Colorado | 8109 | 1203 | 12 | 6824 | 1758 | 176289 |
2022-05-13 | San Juan | Colorado | 8111 | 203 | 0 | 728 | 0 | 278846 |
2022-05-13 | San Miguel | Colorado | 8113 | 2322 | 8 | 8179 | 978 | 283897 |
2022-05-13 | Sedgwick | Colorado | 8115 | 490 | 11 | 2248 | 4893 | 217971 |
2022-05-13 | Summit | Colorado | 8117 | 10087 | 14 | 31011 | 451 | 325271 |
2022-05-13 | Teller | Colorado | 8119 | 4897 | 57 | 25388 | 2245 | 192886 |
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;