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 county
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 (date) 1 ✖
- 2022-05-13 3,131
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Abbeville | South Carolina | 45001 | 6655 | 69 | 24527 | 2813 | 271333 |
2022-05-13 | Acadia | Louisiana | 22001 | 15906 | 294 | 62045 | 4738 | 256362 |
2022-05-13 | Accomack | Virginia | 51001 | 7054 | 106 | 32316 | 3280 | 218281 |
2022-05-13 | Ada | Idaho | 16001 | 135259 | 1022 | 481587 | 2122 | 280860 |
2022-05-13 | Adair | Iowa | 19001 | 1588 | 50 | 7152 | 6991 | 222035 |
2022-05-13 | Adair | Kentucky | 21001 | 5929 | 107 | 19202 | 5572 | 308769 |
2022-05-13 | Adair | Oklahoma | 40001 | 8001 | 75 | 22194 | 3379 | 360502 |
2022-05-13 | Adair | Missouri | 29001 | 6095 | 63 | 25343 | 2485 | 240500 |
2022-05-13 | Adams | Ohio | 39001 | 7022 | 148 | 27698 | 5343 | 253520 |
2022-05-13 | Adams | Mississippi | 28001 | 7224 | 143 | 30693 | 4659 | 235363 |
2022-05-13 | Adams | North Dakota | 38001 | 598 | 10 | 2216 | 4512 | 269855 |
2022-05-13 | Adams | Iowa | 19003 | 820 | 14 | 3602 | 3886 | 227651 |
2022-05-13 | Adams | Illinois | 17001 | 22525 | 238 | 65435 | 3637 | 344234 |
2022-05-13 | Adams | Pennsylvania | 42001 | 25114 | 364 | 103009 | 3533 | 243803 |
2022-05-13 | Adams | Idaho | 16003 | 704 | 15 | 4294 | 3493 | 163949 |
2022-05-13 | Adams | Indiana | 18001 | 7288 | 112 | 35777 | 3130 | 203706 |
2022-05-13 | Adams | Wisconsin | 55001 | 4738 | 61 | 20220 | 3016 | 234322 |
2022-05-13 | Adams | Colorado | 8001 | 137720 | 1380 | 517421 | 2667 | 266166 |
2022-05-13 | Adams | Nebraska | 31001 | 6541 | 73 | 31363 | 2327 | 208557 |
2022-05-13 | Adams | Washington | 53001 | 4926 | 39 | 19983 | 1951 | 246509 |
2022-05-13 | Addison | Vermont | 50001 | 5939 | 18 | 36777 | 489 | 161486 |
2022-05-13 | Aiken | South Carolina | 45003 | 41767 | 437 | 170872 | 2557 | 244434 |
2022-05-13 | Aitkin | Minnesota | 27001 | 3049 | 62 | 15886 | 3902 | 191930 |
2022-05-13 | Alachua | Florida | 12001 | 69008 | 665 | 269043 | 2471 | 256494 |
2022-05-13 | Alamance | North Carolina | 37001 | 47756 | 488 | 169509 | 2878 | 281731 |
2022-05-13 | Alameda | California | 6001 | 284054 | 1868 | 1671329 | 1117 | 169956 |
2022-05-13 | Alamosa | Colorado | 8003 | 4560 | 62 | 16233 | 3819 | 280909 |
2022-05-13 | Albany | New York | 36001 | 63461 | 523 | 305506 | 1711 | 207724 |
2022-05-13 | Albany | Wyoming | 56001 | 9934 | 49 | 38880 | 1260 | 255504 |
2022-05-13 | Albemarle | Virginia | 51003 | 18671 | 163 | 109330 | 1490 | 170776 |
2022-05-13 | Alcona | Michigan | 26001 | 1745 | 71 | 10405 | 6823 | 167707 |
2022-05-13 | Alcorn | Mississippi | 28003 | 10080 | 160 | 36953 | 4329 | 272778 |
2022-05-13 | Aleutians East Borough | Alaska | 2013 | 1101 | 3 | 3337 | 899 | 329937 |
2022-05-13 | Aleutians West Census Area | Alaska | 2016 | 1685 | 1 | 5634 | 177 | 299077 |
2022-05-13 | Alexander | North Carolina | 37003 | 10479 | 139 | 37497 | 3706 | 279462 |
2022-05-13 | Alexander | Illinois | 17003 | 1288 | 15 | 5761 | 2603 | 223572 |
2022-05-13 | Alexandria city | Virginia | 51510 | 32647 | 188 | 159428 | 1179 | 204775 |
2022-05-13 | Alfalfa | Oklahoma | 40003 | 1716 | 15 | 5702 | 2630 | 300947 |
2022-05-13 | Alger | Michigan | 26003 | 1880 | 13 | 9108 | 1427 | 206411 |
2022-05-13 | Allamakee | Iowa | 19005 | 2890 | 60 | 13687 | 4383 | 211149 |
2022-05-13 | Allegan | Michigan | 26005 | 27448 | 348 | 118081 | 2947 | 232450 |
2022-05-13 | Allegany | Maryland | 24001 | 17291 | 362 | 70416 | 5140 | 245554 |
2022-05-13 | Allegany | New York | 36003 | 9275 | 155 | 46091 | 3362 | 201232 |
2022-05-13 | Alleghany | Virginia | 51005 | 3364 | 98 | 14860 | 6594 | 226379 |
2022-05-13 | Alleghany | North Carolina | 37005 | 2981 | 16 | 11137 | 1436 | 267666 |
2022-05-13 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 | 1216045 | 2732 | 223204 |
2022-05-13 | Allen | Louisiana | 22003 | 7880 | 141 | 25627 | 5502 | 307488 |
2022-05-13 | Allen | Kentucky | 21003 | 6601 | 107 | 21315 | 5019 | 309688 |
2022-05-13 | Allen | Ohio | 39003 | 27636 | 478 | 102351 | 4670 | 270012 |
2022-05-13 | Allen | Kansas | 20001 | 3989 | 53 | 12369 | 4284 | 322499 |
2022-05-13 | Allen | Indiana | 18003 | 104713 | 1188 | 379299 | 3132 | 276069 |
2022-05-13 | Allendale | South Carolina | 45005 | 2093 | 24 | 8688 | 2762 | 240906 |
2022-05-13 | Alpena | Michigan | 26007 | 5809 | 139 | 28405 | 4893 | 204506 |
2022-05-13 | Alpine | California | 6003 | 126 | 0 | 1129 | 0 | 111603 |
2022-05-13 | Amador | California | 6005 | 9242 | 86 | 39752 | 2163 | 232491 |
2022-05-13 | Amelia | Virginia | 51007 | 2683 | 61 | 13145 | 4640 | 204108 |
2022-05-13 | Amherst | Virginia | 51009 | 7316 | 89 | 31605 | 2816 | 231482 |
2022-05-13 | Amite | Mississippi | 28005 | 3259 | 69 | 12297 | 5611 | 265023 |
2022-05-13 | Anchorage | Alaska | 2020 | 105418 | 526 | 288000 | 1826 | 366034 |
2022-05-13 | Anderson | South Carolina | 45007 | 58025 | 998 | 202558 | 4926 | 286461 |
2022-05-13 | Anderson | Tennessee | 47001 | 22228 | 334 | 76978 | 4338 | 288757 |
2022-05-13 | Anderson | Texas | 48001 | 9691 | 239 | 57735 | 4139 | 167853 |
2022-05-13 | Anderson | Kansas | 20003 | 2133 | 29 | 7858 | 3690 | 271443 |
2022-05-13 | Anderson | Kentucky | 21005 | 6620 | 70 | 22747 | 3077 | 291027 |
2022-05-13 | Andrew | Missouri | 29003 | 4828 | 58 | 17712 | 3274 | 272583 |
2022-05-13 | Andrews | Texas | 48003 | 3822 | 72 | 18705 | 3849 | 204330 |
2022-05-13 | Androscoggin | Maine | 23001 | 23257 | 285 | 108277 | 2632 | 214791 |
2022-05-13 | Angelina | Texas | 48005 | 15501 | 481 | 86715 | 5546 | 178758 |
2022-05-13 | Anne Arundel | Maryland | 24003 | 92830 | 1078 | 579234 | 1861 | 160263 |
2022-05-13 | Anoka | Minnesota | 27003 | 100743 | 797 | 356921 | 2232 | 282255 |
2022-05-13 | Anson | North Carolina | 37007 | 6567 | 101 | 24446 | 4131 | 268632 |
2022-05-13 | Antelope | Nebraska | 31003 | 1081 | 14 | 6298 | 2222 | 171641 |
2022-05-13 | Antrim | Michigan | 26009 | 4470 | 66 | 23324 | 2829 | 191648 |
2022-05-13 | Apache | Arizona | 4001 | 22540 | 614 | 71887 | 8541 | 313547 |
2022-05-13 | Appanoose | Iowa | 19007 | 2927 | 68 | 12426 | 5472 | 235554 |
2022-05-13 | Appling | Georgia | 13001 | 4833 | 128 | 18386 | 6961 | 262863 |
2022-05-13 | Appomattox | Virginia | 51011 | 3817 | 53 | 15911 | 3331 | 239896 |
2022-05-13 | Aransas | Texas | 48007 | 4177 | 86 | 23510 | 3658 | 177669 |
2022-05-13 | Arapahoe | Colorado | 8005 | 158561 | 1284 | 656590 | 1955 | 241491 |
2022-05-13 | Archer | Texas | 48009 | 2213 | 28 | 8553 | 3273 | 258739 |
2022-05-13 | Archuleta | Colorado | 8007 | 2926 | 16 | 14029 | 1140 | 208567 |
2022-05-13 | Arenac | Michigan | 26011 | 3267 | 67 | 14883 | 4501 | 219512 |
2022-05-13 | Arkansas | Arkansas | 5001 | 5696 | 79 | 17486 | 4517 | 325746 |
2022-05-13 | Arlington | Virginia | 51013 | 46198 | 322 | 236842 | 1359 | 195058 |
2022-05-13 | Armstrong | Pennsylvania | 42005 | 15397 | 343 | 64735 | 5298 | 237846 |
2022-05-13 | Armstrong | Texas | 48011 | 555 | 9 | 1887 | 4769 | 294117 |
2022-05-13 | Aroostook | Maine | 23003 | 14393 | 166 | 67055 | 2475 | 214644 |
2022-05-13 | Arthur | Nebraska | 31005 | 31 | 1 | 463 | 2159 | 66954 |
2022-05-13 | Ascension | Louisiana | 22005 | 35030 | 293 | 126604 | 2314 | 276689 |
2022-05-13 | Ashe | North Carolina | 37009 | 6471 | 78 | 27203 | 2867 | 237878 |
2022-05-13 | Ashland | Ohio | 39005 | 12109 | 218 | 53484 | 4075 | 226404 |
2022-05-13 | Ashland | Wisconsin | 55003 | 3364 | 36 | 15562 | 2313 | 216167 |
2022-05-13 | Ashley | Arkansas | 5003 | 5115 | 66 | 19657 | 3357 | 260212 |
2022-05-13 | Ashtabula | Ohio | 39007 | 20537 | 431 | 97241 | 4432 | 211196 |
2022-05-13 | Asotin | Washington | 53003 | 4554 | 66 | 22582 | 2922 | 201665 |
2022-05-13 | Assumption | Louisiana | 22007 | 5575 | 70 | 21891 | 3197 | 254670 |
2022-05-13 | Atascosa | Texas | 48013 | 13647 | 231 | 51153 | 4515 | 266787 |
2022-05-13 | Atchison | Missouri | 29005 | 1387 | 23 | 5143 | 4472 | 269686 |
2022-05-13 | Atchison | Kansas | 20005 | 4323 | 34 | 16073 | 2115 | 268960 |
2022-05-13 | Athens | Ohio | 39009 | 14852 | 142 | 65327 | 2173 | 227348 |
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;