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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 | Weston | Wyoming | 56045 | 1588 | 18 | 6927 | 2598 | 229247 |
2022-05-13 | Washakie | Wyoming | 56043 | 2358 | 44 | 7805 | 5637 | 302114 |
2022-05-13 | Uinta | Wyoming | 56041 | 5643 | 39 | 20226 | 1928 | 278997 |
2022-05-13 | Teton | Wyoming | 56039 | 10074 | 16 | 23464 | 681 | 429338 |
2022-05-13 | Sweetwater | Wyoming | 56037 | 11088 | 126 | 42343 | 2975 | 261861 |
2022-05-13 | Sublette | Wyoming | 56035 | 1926 | 27 | 9831 | 2746 | 195910 |
2022-05-13 | Sheridan | Wyoming | 56033 | 8097 | 78 | 30485 | 2558 | 265606 |
2022-05-13 | Platte | Wyoming | 56031 | 1911 | 41 | 8393 | 4885 | 227689 |
2022-05-13 | Park | Wyoming | 56029 | 6801 | 144 | 29194 | 4932 | 232958 |
2022-05-13 | Niobrara | Wyoming | 56027 | 694 | 10 | 2356 | 4244 | 294567 |
2022-05-13 | Natrona | Wyoming | 56025 | 22380 | 273 | 79858 | 3418 | 280247 |
2022-05-13 | Lincoln | Wyoming | 56023 | 3979 | 31 | 19830 | 1563 | 200655 |
2022-05-13 | Laramie | Wyoming | 56021 | 26292 | 290 | 99500 | 2914 | 264241 |
2022-05-13 | Johnson | Wyoming | 56019 | 1845 | 19 | 8445 | 2249 | 218472 |
2022-05-13 | Hot Springs | Wyoming | 56017 | 1159 | 16 | 4413 | 3625 | 262633 |
2022-05-13 | Goshen | Wyoming | 56015 | 3646 | 57 | 13211 | 4314 | 275982 |
2022-05-13 | Fremont | Wyoming | 56013 | 13795 | 193 | 39261 | 4915 | 351366 |
2022-05-13 | Crook | Wyoming | 56011 | 1351 | 29 | 7584 | 3823 | 178138 |
2022-05-13 | Converse | Wyoming | 56009 | 3144 | 55 | 13822 | 3979 | 227463 |
2022-05-13 | Carbon | Wyoming | 56007 | 4627 | 52 | 14800 | 3513 | 312635 |
2022-05-13 | Campbell | Wyoming | 56005 | 12113 | 149 | 46341 | 3215 | 261388 |
2022-05-13 | Big Horn | Wyoming | 56003 | 2586 | 61 | 11790 | 5173 | 219338 |
2022-05-13 | Albany | Wyoming | 56001 | 9934 | 49 | 38880 | 1260 | 255504 |
2022-05-13 | Wood | Wisconsin | 55141 | 21477 | 233 | 72999 | 3191 | 294209 |
2022-05-13 | Winnebago | Wisconsin | 55139 | 53045 | 382 | 171907 | 2222 | 308568 |
2022-05-13 | Waushara | Wisconsin | 55137 | 6522 | 87 | 24443 | 3559 | 266824 |
2022-05-13 | Waupaca | Wisconsin | 55135 | 13835 | 252 | 50990 | 4942 | 271327 |
2022-05-13 | Waukesha | Wisconsin | 55133 | 115887 | 1093 | 404198 | 2704 | 286708 |
2022-05-13 | Washington | Wisconsin | 55131 | 38986 | 343 | 136034 | 2521 | 286590 |
2022-05-13 | Washburn | Wisconsin | 55129 | 4078 | 46 | 15720 | 2926 | 259414 |
2022-05-13 | Walworth | Wisconsin | 55127 | 27341 | 281 | 103868 | 2705 | 263228 |
2022-05-13 | Vilas | Wisconsin | 55125 | 5270 | 89 | 22195 | 4009 | 237440 |
2022-05-13 | Vernon | Wisconsin | 55123 | 6239 | 98 | 30822 | 3179 | 202420 |
2022-05-13 | Trempealeau | Wisconsin | 55121 | 8555 | 65 | 29649 | 2192 | 288542 |
2022-05-13 | Taylor | Wisconsin | 55119 | 4884 | 72 | 20343 | 3539 | 240082 |
2022-05-13 | Sheboygan | Wisconsin | 55117 | 33090 | 319 | 115340 | 2765 | 286890 |
2022-05-13 | Shawano | Wisconsin | 55115 | 11994 | 152 | 40899 | 3716 | 293259 |
2022-05-13 | Sawyer | Wisconsin | 55113 | 4651 | 62 | 16558 | 3744 | 280891 |
2022-05-13 | Sauk | Wisconsin | 55111 | 16479 | 136 | 64442 | 2110 | 255718 |
2022-05-13 | St. Croix | Wisconsin | 55109 | 25656 | 149 | 90687 | 1643 | 282907 |
2022-05-13 | Rusk | Wisconsin | 55107 | 3465 | 55 | 14178 | 3879 | 244392 |
2022-05-13 | Rock | Wisconsin | 55105 | 44315 | 395 | 163354 | 2418 | 271282 |
2022-05-13 | Richland | Wisconsin | 55103 | 3995 | 48 | 17252 | 2782 | 231567 |
2022-05-13 | Racine | Wisconsin | 55101 | 57729 | 690 | 196311 | 3514 | 294069 |
2022-05-13 | Price | Wisconsin | 55099 | 3283 | 33 | 13351 | 2471 | 245899 |
2022-05-13 | Portage | Wisconsin | 55097 | 18469 | 161 | 70772 | 2274 | 260964 |
2022-05-13 | Polk | Wisconsin | 55095 | 12692 | 122 | 43783 | 2786 | 289884 |
2022-05-13 | Pierce | Wisconsin | 55093 | 11879 | 73 | 42754 | 1707 | 277845 |
2022-05-13 | Pepin | Wisconsin | 55091 | 2001 | 18 | 7287 | 2470 | 274598 |
2022-05-13 | Ozaukee | Wisconsin | 55089 | 23174 | 186 | 89221 | 2084 | 259737 |
2022-05-13 | Outagamie | Wisconsin | 55087 | 55321 | 406 | 187885 | 2160 | 294440 |
2022-05-13 | Oneida | Wisconsin | 55085 | 8605 | 139 | 35595 | 3905 | 241747 |
2022-05-13 | Oconto | Wisconsin | 55083 | 11522 | 121 | 37930 | 3190 | 303770 |
2022-05-13 | Monroe | Wisconsin | 55081 | 12305 | 91 | 46253 | 1967 | 266036 |
2022-05-13 | Milwaukee | Wisconsin | 55079 | 277430 | 2292 | 945726 | 2423 | 293351 |
2022-05-13 | Menominee | Wisconsin | 55078 | 1987 | 14 | 4556 | 3072 | 436128 |
2022-05-13 | Marquette | Wisconsin | 55077 | 3873 | 61 | 15574 | 3916 | 248683 |
2022-05-13 | Marinette | Wisconsin | 55075 | 11760 | 127 | 40350 | 3147 | 291449 |
2022-05-13 | Marathon | Wisconsin | 55073 | 40330 | 491 | 135692 | 3618 | 297217 |
2022-05-13 | Manitowoc | Wisconsin | 55071 | 20803 | 189 | 78981 | 2392 | 263392 |
2022-05-13 | Lincoln | Wisconsin | 55069 | 7188 | 148 | 27593 | 5363 | 260500 |
2022-05-13 | Langlade | Wisconsin | 55067 | 5295 | 92 | 19189 | 4794 | 275939 |
2022-05-13 | Lafayette | Wisconsin | 55065 | 3731 | 26 | 16665 | 1560 | 223882 |
2022-05-13 | La Crosse | Wisconsin | 55063 | 35988 | 186 | 118016 | 1576 | 304941 |
2022-05-13 | Kewaunee | Wisconsin | 55061 | 5927 | 59 | 20434 | 2887 | 290055 |
2022-05-13 | Kenosha | Wisconsin | 55059 | 45275 | 631 | 169561 | 3721 | 267013 |
2022-05-13 | Juneau | Wisconsin | 55057 | 7859 | 68 | 26687 | 2548 | 294487 |
2022-05-13 | Jefferson | Wisconsin | 55055 | 22026 | 243 | 84769 | 2866 | 259835 |
2022-05-13 | Jackson | Wisconsin | 55053 | 5736 | 43 | 20643 | 2083 | 277866 |
2022-05-13 | Iron | Wisconsin | 55051 | 1482 | 47 | 5687 | 8264 | 260594 |
2022-05-13 | Iowa | Wisconsin | 55049 | 5424 | 29 | 23678 | 1224 | 229073 |
2022-05-13 | Green Lake | Wisconsin | 55047 | 5268 | 64 | 18913 | 3383 | 278538 |
2022-05-13 | Green | Wisconsin | 55045 | 9528 | 54 | 36960 | 1461 | 257792 |
2022-05-13 | Grant | Wisconsin | 55043 | 12945 | 146 | 51439 | 2838 | 251657 |
2022-05-13 | Forest | Wisconsin | 55041 | 2694 | 52 | 9004 | 5775 | 299200 |
2022-05-13 | Fond du Lac | Wisconsin | 55039 | 32524 | 278 | 103403 | 2688 | 314536 |
2022-05-13 | Florence | Wisconsin | 55037 | 1093 | 17 | 4295 | 3958 | 254481 |
2022-05-13 | Eau Claire | Wisconsin | 55035 | 31318 | 187 | 104646 | 1786 | 299275 |
2022-05-13 | Dunn | Wisconsin | 55033 | 13611 | 75 | 45368 | 1653 | 300013 |
2022-05-13 | Douglas | Wisconsin | 55031 | 11993 | 79 | 43150 | 1830 | 277937 |
2022-05-13 | Door | Wisconsin | 55029 | 7097 | 71 | 27668 | 2566 | 256505 |
2022-05-13 | Dodge | Wisconsin | 55027 | 27570 | 340 | 87839 | 3870 | 313869 |
2022-05-13 | Dane | Wisconsin | 55025 | 134580 | 516 | 546695 | 943 | 246170 |
2022-05-13 | Crawford | Wisconsin | 55023 | 4299 | 28 | 16131 | 1735 | 266505 |
2022-05-13 | Columbia | Wisconsin | 55021 | 15821 | 128 | 57532 | 2224 | 274994 |
2022-05-13 | Clark | Wisconsin | 55019 | 7694 | 122 | 34774 | 3508 | 221257 |
2022-05-13 | Chippewa | Wisconsin | 55017 | 19101 | 187 | 64658 | 2892 | 295415 |
2022-05-13 | Calumet | Wisconsin | 55015 | 14749 | 121 | 50089 | 2415 | 294455 |
2022-05-13 | Burnett | Wisconsin | 55013 | 4062 | 43 | 15414 | 2789 | 263526 |
2022-05-13 | Buffalo | Wisconsin | 55011 | 3608 | 12 | 13031 | 920 | 276878 |
2022-05-13 | Brown | Wisconsin | 55009 | 85688 | 557 | 264542 | 2105 | 323910 |
2022-05-13 | Bayfield | Wisconsin | 55007 | 3425 | 41 | 15036 | 2726 | 227786 |
2022-05-13 | Barron | Wisconsin | 55005 | 13743 | 144 | 45244 | 3182 | 303752 |
2022-05-13 | Ashland | Wisconsin | 55003 | 3364 | 36 | 15562 | 2313 | 216167 |
2022-05-13 | Adams | Wisconsin | 55001 | 4738 | 61 | 20220 | 3016 | 234322 |
2022-05-13 | Wyoming | West Virginia | 54109 | 7044 | 116 | 20394 | 5687 | 345395 |
2022-05-13 | Wood | West Virginia | 54107 | 22312 | 346 | 83518 | 4142 | 267151 |
2022-05-13 | Wirt | West Virginia | 54105 | 1455 | 25 | 5821 | 4294 | 249957 |
2022-05-13 | Wetzel | West Virginia | 54103 | 4367 | 86 | 15065 | 5708 | 289877 |
2022-05-13 | Webster | West Virginia | 54101 | 2274 | 33 | 8114 | 4067 | 280256 |
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;