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 date
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 | Galax city | Virginia | 51640 | 2561 | 78 | 6347 | 12289 | 403497 |
2022-05-13 | McMullen | Texas | 48311 | 169 | 9 | 743 | 12113 | 227456 |
2022-05-13 | Motley | Texas | 48345 | 286 | 13 | 1200 | 10833 | 238333 |
2022-05-13 | Hancock | Georgia | 13141 | 1587 | 90 | 8457 | 10642 | 187655 |
2022-05-13 | Emporia city | Virginia | 51595 | 1187 | 55 | 5346 | 10288 | 222035 |
2022-05-13 | Robertson | Kentucky | 21201 | 672 | 21 | 2108 | 9962 | 318785 |
2022-05-13 | Jerauld | South Dakota | 46073 | 415 | 20 | 2013 | 9935 | 206159 |
2022-05-13 | Martinsville city | Virginia | 51690 | 3478 | 124 | 12554 | 9877 | 277043 |
2022-05-13 | Towns | Georgia | 13281 | 2400 | 116 | 12037 | 9636 | 199385 |
2022-05-13 | Foard | Texas | 48155 | 209 | 11 | 1155 | 9523 | 180952 |
2022-05-13 | Lamb | Texas | 48279 | 4356 | 122 | 12893 | 9462 | 337857 |
2022-05-13 | Comanche | Kansas | 20033 | 441 | 16 | 1700 | 9411 | 259411 |
2022-05-13 | Buffalo | South Dakota | 46017 | 620 | 18 | 1962 | 9174 | 316004 |
2022-05-13 | Baylor | Texas | 48023 | 818 | 32 | 3509 | 9119 | 233114 |
2022-05-13 | Upson | Georgia | 13293 | 7803 | 235 | 26320 | 8928 | 296466 |
2022-05-13 | Franklin | Louisiana | 22041 | 7352 | 178 | 20015 | 8893 | 367324 |
2022-05-13 | Candler | Georgia | 13043 | 2194 | 96 | 10803 | 8886 | 203091 |
2022-05-13 | East Feliciana | Louisiana | 22037 | 7324 | 170 | 19135 | 8884 | 382754 |
2022-05-13 | Treutlen | Georgia | 13283 | 1634 | 61 | 6901 | 8839 | 236777 |
2022-05-13 | Gove | Kansas | 20063 | 790 | 23 | 2636 | 8725 | 299696 |
2022-05-13 | Coleman | Texas | 48083 | 1646 | 71 | 8175 | 8685 | 201345 |
2022-05-13 | Twiggs | Georgia | 13289 | 1543 | 70 | 8120 | 8620 | 190024 |
2022-05-13 | Apache | Arizona | 4001 | 22540 | 614 | 71887 | 8541 | 313547 |
2022-05-13 | Little River | Arkansas | 5081 | 3281 | 104 | 12259 | 8483 | 267640 |
2022-05-13 | Sabine | Texas | 48403 | 1254 | 89 | 10542 | 8442 | 118952 |
2022-05-13 | Bent | Colorado | 8011 | 2560 | 47 | 5577 | 8427 | 459028 |
2022-05-13 | Glascock | Georgia | 13125 | 610 | 25 | 2971 | 8414 | 205318 |
2022-05-13 | Floyd | Texas | 48153 | 1961 | 48 | 5712 | 8403 | 343312 |
2022-05-13 | Bienville | Louisiana | 22013 | 3992 | 110 | 13241 | 8307 | 301487 |
2022-05-13 | Neshoba | Mississippi | 28099 | 10622 | 241 | 29118 | 8276 | 364791 |
2022-05-13 | Iron | Wisconsin | 55051 | 1482 | 47 | 5687 | 8264 | 260594 |
2022-05-13 | Wibaux | Montana | 30109 | 204 | 8 | 969 | 8255 | 210526 |
2022-05-13 | McKinley | New Mexico | 35031 | 26007 | 589 | 71367 | 8253 | 364412 |
2022-05-13 | Wilcox | Georgia | 13315 | 2014 | 71 | 8635 | 8222 | 233236 |
2022-05-13 | Navajo | Arizona | 4017 | 38394 | 909 | 110924 | 8194 | 346128 |
2022-05-13 | Van Buren | Tennessee | 47175 | 1852 | 48 | 5872 | 8174 | 315395 |
2022-05-13 | Gregory | South Dakota | 46053 | 1065 | 34 | 4185 | 8124 | 254480 |
2022-05-13 | Harlan | Kentucky | 21095 | 9222 | 211 | 26010 | 8112 | 354555 |
2022-05-13 | Hall | Texas | 48191 | 1102 | 24 | 2964 | 8097 | 371794 |
2022-05-13 | Cochran | Texas | 48079 | 891 | 23 | 2853 | 8061 | 312302 |
2022-05-13 | Pierce | North Dakota | 38069 | 1065 | 32 | 3975 | 8050 | 267924 |
2022-05-13 | Grant | Nebraska | 31075 | 100 | 5 | 623 | 8025 | 160513 |
2022-05-13 | Dickey | North Dakota | 38021 | 1496 | 39 | 4872 | 8004 | 307060 |
2022-05-13 | Maverick | Texas | 48323 | 20872 | 469 | 58722 | 7986 | 355437 |
2022-05-13 | Donley | Texas | 48129 | 1153 | 26 | 3278 | 7931 | 351738 |
2022-05-13 | Lowndes | Alabama | 1085 | 2628 | 77 | 9726 | 7916 | 270203 |
2022-05-13 | Montgomery | Mississippi | 28097 | 2963 | 77 | 9775 | 7877 | 303120 |
2022-05-13 | Terrell | Georgia | 13273 | 2057 | 67 | 8531 | 7853 | 241120 |
2022-05-13 | Crosby | Texas | 48107 | 1894 | 45 | 5737 | 7843 | 330137 |
2022-05-13 | Ware | Georgia | 13299 | 10121 | 280 | 35734 | 7835 | 283231 |
2022-05-13 | Lane | Kansas | 20101 | 296 | 12 | 1535 | 7817 | 192833 |
2022-05-13 | Iron | Michigan | 26071 | 2673 | 86 | 11066 | 7771 | 241550 |
2022-05-13 | Bleckley | Georgia | 13023 | 3353 | 100 | 12873 | 7768 | 260467 |
2022-05-13 | Turner | Georgia | 13287 | 2569 | 61 | 7985 | 7639 | 321728 |
2022-05-13 | Union | Florida | 12125 | 4321 | 116 | 15237 | 7613 | 283586 |
2022-05-13 | Jenkins | Georgia | 13165 | 1504 | 66 | 8676 | 7607 | 173351 |
2022-05-13 | Mills | Texas | 48333 | 1475 | 37 | 4873 | 7592 | 302688 |
2022-05-13 | Johnson | Georgia | 13167 | 2258 | 73 | 9643 | 7570 | 234159 |
2022-05-13 | Houston | Tennessee | 47083 | 2689 | 62 | 8201 | 7560 | 327886 |
2022-05-13 | Lewis | Idaho | 16061 | 1134 | 29 | 3838 | 7556 | 295466 |
2022-05-13 | Toombs | Georgia | 13279 | 7114 | 202 | 26830 | 7528 | 265150 |
2022-05-13 | Dodge | Georgia | 13091 | 5244 | 154 | 20605 | 7473 | 254501 |
2022-05-13 | Dewey | South Dakota | 46041 | 3139 | 44 | 5892 | 7467 | 532756 |
2022-05-13 | Polk | Arkansas | 5113 | 4146 | 149 | 19964 | 7463 | 207673 |
2022-05-13 | Turner | South Dakota | 46125 | 1969 | 62 | 8384 | 7395 | 234852 |
2022-05-13 | Dawson | Texas | 48115 | 2998 | 94 | 12728 | 7385 | 235543 |
2022-05-13 | Jefferson | Georgia | 13163 | 3668 | 113 | 15362 | 7355 | 238770 |
2022-05-13 | Hale | Texas | 48189 | 6571 | 245 | 33406 | 7334 | 196701 |
2022-05-13 | Hooker | Nebraska | 31091 | 113 | 5 | 682 | 7331 | 165689 |
2022-05-13 | Brooks | Texas | 48047 | 1642 | 52 | 7093 | 7331 | 231495 |
2022-05-13 | Ben Hill | Georgia | 13017 | 4344 | 122 | 16700 | 7305 | 260119 |
2022-05-13 | Crenshaw | Alabama | 1041 | 3834 | 100 | 13772 | 7261 | 278390 |
2022-05-13 | Lafayette | Florida | 12067 | 2780 | 61 | 8422 | 7242 | 330087 |
2022-05-13 | Real | Texas | 48385 | 817 | 25 | 3452 | 7242 | 236674 |
2022-05-13 | Dickens | Texas | 48125 | 453 | 16 | 2211 | 7236 | 204884 |
2022-05-13 | Hale | Alabama | 1065 | 4741 | 106 | 14651 | 7235 | 323595 |
2022-05-13 | Grant | South Dakota | 46051 | 2047 | 51 | 7052 | 7231 | 290272 |
2022-05-13 | Monroe | Kentucky | 21171 | 3624 | 77 | 10650 | 7230 | 340281 |
2022-05-13 | Webster | Mississippi | 28155 | 3388 | 70 | 9689 | 7224 | 349674 |
2022-05-13 | Fulton | Arkansas | 5049 | 2696 | 90 | 12477 | 7213 | 216077 |
2022-05-13 | Big Horn | Montana | 30003 | 4980 | 96 | 13319 | 7207 | 373901 |
2022-05-13 | Foster | North Dakota | 38031 | 992 | 23 | 3210 | 7165 | 309034 |
2022-05-13 | Ida | Iowa | 19093 | 1831 | 49 | 6860 | 7142 | 266909 |
2022-05-13 | Sheridan | Kansas | 20179 | 786 | 18 | 2521 | 7140 | 311781 |
2022-05-13 | Pickett | Tennessee | 47137 | 1774 | 36 | 5048 | 7131 | 351426 |
2022-05-13 | Otero | Colorado | 8089 | 4322 | 130 | 18278 | 7112 | 236459 |
2022-05-13 | Juniata | Pennsylvania | 42067 | 4797 | 176 | 24763 | 7107 | 193716 |
2022-05-13 | Suwannee | Florida | 12121 | 12972 | 315 | 44417 | 7091 | 292050 |
2022-05-13 | Cibola | New Mexico | 35006 | 8048 | 189 | 26675 | 7085 | 301705 |
2022-05-13 | Randolph | Georgia | 13243 | 1490 | 48 | 6778 | 7081 | 219828 |
2022-05-13 | Phillips | Montana | 30071 | 1060 | 28 | 3954 | 7081 | 268082 |
2022-05-13 | Decatur | Kansas | 20039 | 620 | 20 | 2827 | 7074 | 219313 |
2022-05-13 | Emanuel | Georgia | 13107 | 5924 | 160 | 22646 | 7065 | 261591 |
2022-05-13 | Gila | Arizona | 4007 | 17398 | 381 | 54018 | 7053 | 322077 |
2022-05-13 | Scott | Kansas | 20171 | 1277 | 34 | 4823 | 7049 | 264772 |
2022-05-13 | Danville city | Virginia | 51590 | 11226 | 282 | 40044 | 7042 | 280341 |
2022-05-13 | Walker | Alabama | 1127 | 18767 | 447 | 63521 | 7037 | 295445 |
2022-05-13 | Lee | Kentucky | 21129 | 2951 | 52 | 7403 | 7024 | 398622 |
2022-05-13 | Grundy | Missouri | 29079 | 2543 | 69 | 9850 | 7005 | 258172 |
2022-05-13 | Pulaski | Georgia | 13235 | 2180 | 78 | 11137 | 7003 | 195743 |
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;