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 cases_per_million
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 | Eastland | Texas | 48133 | 2829 | 113 | 18360 | 6154 | 154084 |
2022-05-13 | Sagadahoc | Maine | 23023 | 5531 | 32 | 35856 | 892 | 154255 |
2022-05-13 | Harford | Maryland | 24025 | 39423 | 582 | 255441 | 2278 | 154333 |
2022-05-13 | Humboldt | California | 6023 | 20952 | 146 | 135558 | 1077 | 154561 |
2022-05-13 | Park | Colorado | 8093 | 2913 | 20 | 18845 | 1061 | 154576 |
2022-05-13 | Cecil | Maryland | 24015 | 15906 | 259 | 102855 | 2518 | 154644 |
2022-05-13 | Harding | South Dakota | 46063 | 201 | 3 | 1298 | 2311 | 154853 |
2022-05-13 | Terrell | Texas | 48443 | 121 | 3 | 776 | 3865 | 155927 |
2022-05-13 | Billings | North Dakota | 38007 | 145 | 1 | 928 | 1077 | 156250 |
2022-05-13 | Lamoille | Vermont | 50015 | 3964 | 17 | 25362 | 670 | 156296 |
2022-05-13 | Grand Isle | Vermont | 50013 | 1132 | 5 | 7235 | 691 | 156461 |
2022-05-13 | Gilpin | Colorado | 8047 | 977 | 4 | 6243 | 640 | 156495 |
2022-05-13 | Lane | Oregon | 41039 | 59853 | 541 | 382067 | 1415 | 156655 |
2022-05-13 | Wheeler | Nebraska | 31183 | 123 | 2 | 783 | 2554 | 157088 |
2022-05-13 | Lemhi | Idaho | 16059 | 1261 | 25 | 8027 | 3114 | 157094 |
2022-05-13 | Tyler | Texas | 48457 | 3405 | 88 | 21672 | 4060 | 157115 |
2022-05-13 | Bandera | Texas | 48019 | 3636 | 77 | 23112 | 3331 | 157320 |
2022-05-13 | Dawes | Nebraska | 31045 | 1356 | 21 | 8589 | 2444 | 157876 |
2022-05-13 | Skagway Municipality | Alaska | 2230 | 187 | 0 | 1183 | 0 | 158072 |
2022-05-13 | Hood River | Oregon | 41027 | 3698 | 44 | 23382 | 1881 | 158155 |
2022-05-13 | El Dorado | California | 6017 | 30508 | 212 | 192843 | 1099 | 158201 |
2022-05-13 | Haskell | Texas | 48207 | 897 | 39 | 5658 | 6892 | 158536 |
2022-05-13 | Goliad | Texas | 48175 | 1216 | 32 | 7658 | 4178 | 158788 |
2022-05-13 | Schuyler | Missouri | 29197 | 740 | 26 | 4660 | 5579 | 158798 |
2022-05-13 | Pawnee | Nebraska | 31133 | 415 | 4 | 2613 | 1530 | 158821 |
2022-05-13 | Granite | Montana | 30039 | 537 | 9 | 3379 | 2663 | 158922 |
2022-05-13 | Fisher | Texas | 48151 | 609 | 24 | 3830 | 6266 | 159007 |
2022-05-13 | Stillwater | Montana | 30095 | 1538 | 32 | 9642 | 3318 | 159510 |
2022-05-13 | Lake | Michigan | 26085 | 1893 | 37 | 11853 | 3121 | 159706 |
2022-05-13 | Hinsdale | Colorado | 8053 | 131 | 0 | 820 | 0 | 159756 |
2022-05-13 | Anne Arundel | Maryland | 24003 | 92830 | 1078 | 579234 | 1861 | 160263 |
2022-05-13 | Hunt | Texas | 48231 | 15811 | 363 | 98594 | 3681 | 160364 |
2022-05-13 | Grant | Nebraska | 31075 | 100 | 5 | 623 | 8025 | 160513 |
2022-05-13 | Kent | Maryland | 24029 | 3122 | 66 | 19422 | 3398 | 160745 |
2022-05-13 | Daggett | Utah | 49009 | 153 | 0 | 950 | 0 | 161052 |
2022-05-13 | Lincoln | Maine | 23015 | 5578 | 35 | 34634 | 1010 | 161055 |
2022-05-13 | Klickitat | Washington | 53039 | 3612 | 47 | 22425 | 2095 | 161070 |
2022-05-13 | Knox | Maine | 23013 | 6414 | 38 | 39772 | 955 | 161269 |
2022-05-13 | Marshall | South Dakota | 46091 | 796 | 13 | 4935 | 2634 | 161296 |
2022-05-13 | Addison | Vermont | 50001 | 5939 | 18 | 36777 | 489 | 161486 |
2022-05-13 | Nye | Nevada | 32023 | 7514 | 241 | 46523 | 5180 | 161511 |
2022-05-13 | Ravalli | Montana | 30081 | 7089 | 164 | 43806 | 3743 | 161827 |
2022-05-13 | Franklin | Massachusetts | 25011 | 11403 | 140 | 70180 | 1994 | 162482 |
2022-05-13 | Waldo | Maine | 23027 | 6467 | 58 | 39715 | 1460 | 162835 |
2022-05-13 | Choctaw | Alabama | 1023 | 2051 | 36 | 12589 | 2859 | 162920 |
2022-05-13 | King and Queen | Virginia | 51097 | 1146 | 12 | 7025 | 1708 | 163131 |
2022-05-13 | San Francisco | California | 6075 | 143959 | 866 | 881549 | 982 | 163302 |
2022-05-13 | Wayne | Utah | 49055 | 444 | 0 | 2711 | 0 | 163777 |
2022-05-13 | McCulloch | Texas | 48307 | 1308 | 47 | 7984 | 5886 | 163827 |
2022-05-13 | Adams | Idaho | 16003 | 704 | 15 | 4294 | 3493 | 163949 |
2022-05-13 | Fairfax | Virginia | 51059 | 188156 | 1453 | 1147532 | 1266 | 163965 |
2022-05-13 | Floyd | Virginia | 51063 | 2587 | 49 | 15749 | 3111 | 164264 |
2022-05-13 | Camden | North Carolina | 37029 | 1786 | 9 | 10867 | 828 | 164350 |
2022-05-13 | Kimble | Texas | 48267 | 714 | 15 | 4337 | 3458 | 164629 |
2022-05-13 | Baltimore | Maryland | 24005 | 136295 | 2484 | 827370 | 3002 | 164732 |
2022-05-13 | Fremont | Idaho | 16043 | 2158 | 28 | 13099 | 2137 | 164745 |
2022-05-13 | Clear Creek | Colorado | 8019 | 1601 | 12 | 9700 | 1237 | 165051 |
2022-05-13 | Sherman | Texas | 48421 | 499 | 16 | 3022 | 5294 | 165122 |
2022-05-13 | Gage | Nebraska | 31067 | 3562 | 44 | 21513 | 2045 | 165574 |
2022-05-13 | Presque Isle | Michigan | 26141 | 2085 | 58 | 12592 | 4606 | 165581 |
2022-05-13 | Windham | Vermont | 50025 | 6994 | 36 | 42222 | 852 | 165648 |
2022-05-13 | Hooker | Nebraska | 31091 | 113 | 5 | 682 | 7331 | 165689 |
2022-05-13 | Taos | New Mexico | 35055 | 5425 | 90 | 32723 | 2750 | 165785 |
2022-05-13 | Essex | New York | 36031 | 6124 | 61 | 36885 | 1653 | 166029 |
2022-05-13 | Macon | Georgia | 13193 | 2151 | 50 | 12947 | 3861 | 166138 |
2022-05-13 | San Patricio | Texas | 48409 | 11104 | 341 | 66730 | 5110 | 166401 |
2022-05-13 | Gates | North Carolina | 37073 | 1926 | 20 | 11562 | 1729 | 166580 |
2022-05-13 | Alcona | Michigan | 26001 | 1745 | 71 | 10405 | 6823 | 167707 |
2022-05-13 | Anderson | Texas | 48001 | 9691 | 239 | 57735 | 4139 | 167853 |
2022-05-13 | Oliver | North Dakota | 38065 | 329 | 5 | 1959 | 2552 | 167942 |
2022-05-13 | Franklin | Idaho | 16041 | 2331 | 29 | 13876 | 2089 | 167987 |
2022-05-13 | Coos | Oregon | 41011 | 10849 | 153 | 64487 | 2372 | 168235 |
2022-05-13 | Webster | Georgia | 13307 | 439 | 8 | 2607 | 3068 | 168392 |
2022-05-13 | Sumter | Florida | 12119 | 22305 | 576 | 132420 | 4349 | 168441 |
2022-05-13 | Worcester | Maryland | 24047 | 8826 | 160 | 52276 | 3060 | 168834 |
2022-05-13 | Pacific | Washington | 53049 | 3795 | 57 | 22471 | 2536 | 168884 |
2022-05-13 | Thurston | Washington | 53067 | 49071 | 417 | 290536 | 1435 | 168898 |
2022-05-13 | Calaveras | California | 6009 | 7754 | 120 | 45905 | 2614 | 168914 |
2022-05-13 | Montgomery | Maryland | 24031 | 178052 | 2044 | 1050688 | 1945 | 169462 |
2022-05-13 | Pulaski | Missouri | 29169 | 8918 | 116 | 52607 | 2205 | 169521 |
2022-05-13 | Latah | Idaho | 16057 | 6801 | 49 | 40108 | 1221 | 169567 |
2022-05-13 | Montgomery | Arkansas | 5097 | 1525 | 57 | 8986 | 6343 | 169708 |
2022-05-13 | Leelanau | Michigan | 26089 | 3697 | 55 | 21761 | 2527 | 169891 |
2022-05-13 | Alameda | California | 6001 | 284054 | 1868 | 1671329 | 1117 | 169956 |
2022-05-13 | St. Mary's | Maryland | 24037 | 19329 | 217 | 113510 | 1911 | 170284 |
2022-05-13 | Liberty | Montana | 30051 | 398 | 4 | 2337 | 1711 | 170303 |
2022-05-13 | Jack | Texas | 48237 | 1523 | 28 | 8935 | 3133 | 170453 |
2022-05-13 | Yamhill | Oregon | 41071 | 18265 | 222 | 107100 | 2072 | 170541 |
2022-05-13 | Mora | New Mexico | 35033 | 772 | 18 | 4521 | 3981 | 170758 |
2022-05-13 | Albemarle | Virginia | 51003 | 18671 | 163 | 109330 | 1490 | 170776 |
2022-05-13 | Charles City | Virginia | 51036 | 1191 | 27 | 6963 | 3877 | 171046 |
2022-05-13 | Marion | Texas | 48315 | 1690 | 60 | 9854 | 6088 | 171503 |
2022-05-13 | Whatcom | Washington | 53073 | 39343 | 301 | 229247 | 1312 | 171618 |
2022-05-13 | Antelope | Nebraska | 31003 | 1081 | 14 | 6298 | 2222 | 171641 |
2022-05-13 | McIntosh | Georgia | 13191 | 2469 | 37 | 14378 | 2573 | 171720 |
2022-05-13 | Jasper | Texas | 48241 | 6102 | 187 | 35529 | 5263 | 171747 |
2022-05-13 | Siskiyou | California | 6093 | 7478 | 105 | 43539 | 2411 | 171754 |
2022-05-13 | Kane | Utah | 49025 | 1355 | 15 | 7886 | 1902 | 171823 |
2022-05-13 | Cameron | Louisiana | 22023 | 1199 | 8 | 6973 | 1147 | 171948 |
2022-05-13 | Boundary | Idaho | 16021 | 2107 | 62 | 12245 | 5063 | 172070 |
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;