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 | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Atkinson | Georgia | 13003 | 2200 | 50 | 8165 | 6123 | 269442 |
2022-05-13 | Atlantic | New Jersey | 34001 | 70482 | 997 | 263670 | 3781 | 267311 |
2022-05-13 | Atoka | Oklahoma | 40005 | 3911 | 54 | 13758 | 3924 | 284270 |
2022-05-13 | Attala | Mississippi | 28007 | 5361 | 113 | 18174 | 6217 | 294981 |
2022-05-13 | Audrain | Missouri | 29007 | 5717 | 110 | 25388 | 4332 | 225185 |
2022-05-13 | Audubon | Iowa | 19009 | 1114 | 19 | 5496 | 3457 | 202692 |
2022-05-13 | Auglaize | Ohio | 39011 | 11642 | 189 | 45656 | 4139 | 254993 |
2022-05-13 | Augusta | Virginia | 51015 | 18922 | 206 | 75558 | 2726 | 250430 |
2022-05-13 | Aurora | South Dakota | 46003 | 805 | 17 | 2751 | 6179 | 292620 |
2022-05-13 | Austin | Texas | 48015 | 5818 | 73 | 30032 | 2430 | 193726 |
2022-05-13 | Autauga | Alabama | 1001 | 15863 | 216 | 55869 | 3866 | 283932 |
2022-05-13 | Avery | North Carolina | 37011 | 4621 | 44 | 17557 | 2506 | 263199 |
2022-05-13 | Avoyelles | Louisiana | 22009 | 11600 | 208 | 40144 | 5181 | 288959 |
2022-05-13 | Baca | Colorado | 8009 | 855 | 13 | 3581 | 3630 | 238760 |
2022-05-13 | Bacon | Georgia | 13005 | 3692 | 78 | 11164 | 6986 | 330705 |
2022-05-13 | Bailey | Texas | 48017 | 1511 | 39 | 7000 | 5571 | 215857 |
2022-05-13 | Baker | Georgia | 13007 | 536 | 15 | 3038 | 4937 | 176431 |
2022-05-13 | Baker | Florida | 12003 | 8712 | 142 | 29210 | 4861 | 298254 |
2022-05-13 | Baker | Oregon | 41001 | 3231 | 48 | 16124 | 2976 | 200384 |
2022-05-13 | Baldwin | Georgia | 13009 | 9574 | 240 | 44890 | 5346 | 213276 |
2022-05-13 | Baldwin | Alabama | 1003 | 55862 | 681 | 223234 | 3050 | 250239 |
2022-05-13 | Ballard | Kentucky | 21007 | 1387 | 29 | 7888 | 3676 | 175836 |
2022-05-13 | Baltimore | Maryland | 24005 | 136295 | 2484 | 827370 | 3002 | 164732 |
2022-05-13 | Baltimore city | Maryland | 24510 | 116724 | 1777 | 593490 | 2994 | 196673 |
2022-05-13 | Bamberg | South Carolina | 45009 | 3446 | 75 | 14066 | 5332 | 244987 |
2022-05-13 | Bandera | Texas | 48019 | 3636 | 77 | 23112 | 3331 | 157320 |
2022-05-13 | Banks | Georgia | 13011 | 3990 | 94 | 19234 | 4887 | 207445 |
2022-05-13 | Banner | Nebraska | 31007 | 87 | 2 | 745 | 2684 | 116778 |
2022-05-13 | Bannock | Idaho | 16005 | 20914 | 247 | 87808 | 2812 | 238178 |
2022-05-13 | Baraga | Michigan | 26013 | 2222 | 54 | 8209 | 6578 | 270678 |
2022-05-13 | Barber | Kansas | 20007 | 1043 | 8 | 4427 | 1807 | 235599 |
2022-05-13 | Barbour | West Virginia | 54001 | 4838 | 73 | 16441 | 4440 | 294264 |
2022-05-13 | Barbour | Alabama | 1005 | 5681 | 98 | 24686 | 3969 | 230130 |
2022-05-13 | Barnes | North Dakota | 38003 | 3024 | 47 | 10415 | 4512 | 290350 |
2022-05-13 | Barnstable | Massachusetts | 25001 | 37644 | 584 | 212990 | 2741 | 176740 |
2022-05-13 | Barnwell | South Carolina | 45011 | 5834 | 103 | 20866 | 4936 | 279593 |
2022-05-13 | Barren | Kentucky | 21009 | 13032 | 219 | 44249 | 4949 | 294515 |
2022-05-13 | Barron | Wisconsin | 55005 | 13743 | 144 | 45244 | 3182 | 303752 |
2022-05-13 | Barrow | Georgia | 13013 | 21998 | 256 | 83240 | 3075 | 264271 |
2022-05-13 | Barry | Missouri | 29009 | 6648 | 132 | 35789 | 3688 | 185755 |
2022-05-13 | Barry | Michigan | 26015 | 14514 | 169 | 61550 | 2745 | 235808 |
2022-05-13 | Bartholomew | Indiana | 18005 | 21574 | 250 | 83779 | 2984 | 257510 |
2022-05-13 | Barton | Missouri | 29011 | 2859 | 52 | 11754 | 4424 | 243236 |
2022-05-13 | Barton | Kansas | 20009 | 6508 | 96 | 25779 | 3723 | 252453 |
2022-05-13 | Bartow | Georgia | 13015 | 29577 | 447 | 107738 | 4148 | 274527 |
2022-05-13 | Bastrop | Texas | 48021 | 21971 | 239 | 88723 | 2693 | 247635 |
2022-05-13 | Bates | Missouri | 29013 | 3766 | 96 | 16172 | 5936 | 232871 |
2022-05-13 | Bath | Virginia | 51017 | 906 | 20 | 4147 | 4822 | 218471 |
2022-05-13 | Bath | Kentucky | 21011 | 3210 | 48 | 12500 | 3840 | 256800 |
2022-05-13 | Baxter | Arkansas | 5005 | 8848 | 247 | 41932 | 5890 | 211008 |
2022-05-13 | Bay | Michigan | 26017 | 27496 | 588 | 103126 | 5701 | 266625 |
2022-05-13 | Bay | Florida | 12005 | 45926 | 827 | 174705 | 4733 | 262877 |
2022-05-13 | Bayfield | Wisconsin | 55007 | 3425 | 41 | 15036 | 2726 | 227786 |
2022-05-13 | Baylor | Texas | 48023 | 818 | 32 | 3509 | 9119 | 233114 |
2022-05-13 | Beadle | South Dakota | 46005 | 4596 | 60 | 18453 | 3251 | 249065 |
2022-05-13 | Bear Lake | Idaho | 16007 | 931 | 16 | 6125 | 2612 | 152000 |
2022-05-13 | Beaufort | North Carolina | 37013 | 12715 | 171 | 46994 | 3638 | 270566 |
2022-05-13 | Beaufort | South Carolina | 45013 | 43530 | 380 | 192122 | 1977 | 226574 |
2022-05-13 | Beauregard | Louisiana | 22011 | 9271 | 143 | 37497 | 3813 | 247246 |
2022-05-13 | Beaver | Pennsylvania | 42007 | 40744 | 745 | 163929 | 4544 | 248546 |
2022-05-13 | Beaver | Utah | 49001 | 1609 | 16 | 6710 | 2384 | 239791 |
2022-05-13 | Beaver | Oklahoma | 40007 | 969 | 11 | 5311 | 2071 | 182451 |
2022-05-13 | Beaverhead | Montana | 30001 | 2137 | 30 | 9453 | 3173 | 226065 |
2022-05-13 | Becker | Minnesota | 27005 | 8934 | 93 | 34423 | 2701 | 259535 |
2022-05-13 | Beckham | Oklahoma | 40009 | 5983 | 106 | 21859 | 4849 | 273708 |
2022-05-13 | Bedford | Pennsylvania | 42009 | 11044 | 275 | 47888 | 5742 | 230621 |
2022-05-13 | Bedford | Tennessee | 47003 | 15004 | 237 | 49713 | 4767 | 301812 |
2022-05-13 | Bedford | Virginia | 51019 | 17276 | 240 | 78997 | 3038 | 218691 |
2022-05-13 | Bee | Texas | 48025 | 8418 | 153 | 32565 | 4698 | 258498 |
2022-05-13 | Belknap | New Hampshire | 33001 | 14152 | 178 | 61303 | 2903 | 230853 |
2022-05-13 | Bell | Kentucky | 21013 | 8868 | 149 | 26032 | 5723 | 340657 |
2022-05-13 | Bell | Texas | 48027 | 67290 | 901 | 362924 | 2482 | 185410 |
2022-05-13 | Belmont | Ohio | 39013 | 15805 | 309 | 67006 | 4611 | 235874 |
2022-05-13 | Beltrami | Minnesota | 27007 | 12179 | 128 | 47188 | 2712 | 258095 |
2022-05-13 | Ben Hill | Georgia | 13017 | 4344 | 122 | 16700 | 7305 | 260119 |
2022-05-13 | Benewah | Idaho | 16009 | 2397 | 41 | 9298 | 4409 | 257797 |
2022-05-13 | Bennett | South Dakota | 46007 | 789 | 14 | 3365 | 4160 | 234472 |
2022-05-13 | Bennington | Vermont | 50003 | 10153 | 71 | 35470 | 2001 | 286241 |
2022-05-13 | Benson | North Dakota | 38005 | 1980 | 23 | 6832 | 3366 | 289812 |
2022-05-13 | Bent | Colorado | 8011 | 2560 | 47 | 5577 | 8427 | 459028 |
2022-05-13 | Benton | Mississippi | 28009 | 2274 | 49 | 8259 | 5932 | 275335 |
2022-05-13 | Benton | Tennessee | 47005 | 4533 | 93 | 16160 | 5754 | 280507 |
2022-05-13 | Benton | Missouri | 29015 | 4248 | 107 | 19443 | 5503 | 218484 |
2022-05-13 | Benton | Minnesota | 27009 | 14298 | 174 | 40889 | 4255 | 349678 |
2022-05-13 | Benton | Arkansas | 5007 | 67110 | 849 | 279141 | 3041 | 240416 |
2022-05-13 | Benton | Iowa | 19011 | 6089 | 77 | 25645 | 3002 | 237434 |
2022-05-13 | Benton | Indiana | 18007 | 2508 | 21 | 8748 | 2400 | 286694 |
2022-05-13 | Benton | Washington | 53005 | 53006 | 472 | 204390 | 2309 | 259337 |
2022-05-13 | Benton | Oregon | 41003 | 16301 | 71 | 93053 | 763 | 175179 |
2022-05-13 | Benzie | Michigan | 26019 | 3514 | 68 | 17766 | 3827 | 197793 |
2022-05-13 | Bergen | New Jersey | 34003 | 239353 | 3458 | 932202 | 3709 | 256760 |
2022-05-13 | Berkeley | West Virginia | 54003 | 36247 | 295 | 119171 | 2475 | 304159 |
2022-05-13 | Berkeley | South Carolina | 45015 | 52240 | 450 | 227907 | 1974 | 229216 |
2022-05-13 | Berks | Pennsylvania | 42011 | 103652 | 1595 | 421164 | 3787 | 246108 |
2022-05-13 | Berkshire | Massachusetts | 25003 | 26169 | 378 | 124944 | 3025 | 209445 |
2022-05-13 | Bernalillo | New Mexico | 35001 | 149543 | 1854 | 679121 | 2729 | 220200 |
2022-05-13 | Berrien | Georgia | 13019 | 4955 | 83 | 19397 | 4279 | 255451 |
2022-05-13 | Berrien | Michigan | 26021 | 35344 | 561 | 153401 | 3657 | 230402 |
2022-05-13 | Bertie | North Carolina | 37015 | 4277 | 68 | 18947 | 3588 | 225734 |
2022-05-13 | Bethel Census Area | Alaska | 2050 | 10362 | 41 | 18386 | 2229 | 563580 |
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;