latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where state = "Missouri" sorted by cases_per_million
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Missouri · 115 ✖
date (date) 1 ✖
- 2022-05-13 115
date | county | state | fips | cases | deaths | population | deaths_per_million | cases_per_million ▼ |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Platte | Missouri | 29165 | 10580 | 102 | 104418 | 976 | 101323 |
2022-05-13 | Clay | Missouri | 29047 | 27390 | 363 | 249948 | 1452 | 109582 |
2022-05-13 | Jackson | Missouri | 29095 | 97164 | 1217 | 703011 | 1731 | 138211 |
2022-05-13 | Scotland | Missouri | 29199 | 680 | 18 | 4902 | 3671 | 138718 |
2022-05-13 | Schuyler | Missouri | 29197 | 740 | 26 | 4660 | 5579 | 158798 |
2022-05-13 | Pulaski | Missouri | 29169 | 8918 | 116 | 52607 | 2205 | 169521 |
2022-05-13 | Jasper | Missouri | 29097 | 20879 | 317 | 121328 | 2612 | 172087 |
2022-05-13 | DeKalb | Missouri | 29063 | 2222 | 47 | 12547 | 3745 | 177094 |
2022-05-13 | Stone | Missouri | 29209 | 5829 | 122 | 31952 | 3818 | 182429 |
2022-05-13 | Maries | Missouri | 29125 | 1606 | 39 | 8697 | 4484 | 184661 |
2022-05-13 | Barry | Missouri | 29009 | 6648 | 132 | 35789 | 3688 | 185755 |
2022-05-13 | Reynolds | Missouri | 29179 | 1165 | 26 | 6270 | 4146 | 185805 |
2022-05-13 | Texas | Missouri | 29215 | 4732 | 102 | 25398 | 4016 | 186313 |
2022-05-13 | Wayne | Missouri | 29223 | 2406 | 53 | 12873 | 4117 | 186902 |
2022-05-13 | Caldwell | Missouri | 29025 | 1700 | 39 | 9020 | 4323 | 188470 |
2022-05-13 | Ozark | Missouri | 29153 | 1735 | 58 | 9174 | 6322 | 189121 |
2022-05-13 | Pemiscot | Missouri | 29155 | 3013 | 74 | 15805 | 4682 | 190635 |
2022-05-13 | Dade | Missouri | 29057 | 1447 | 42 | 7561 | 5554 | 191376 |
2022-05-13 | Oregon | Missouri | 29149 | 2024 | 33 | 10529 | 3134 | 192230 |
2022-05-13 | Hickory | Missouri | 29085 | 1838 | 56 | 9544 | 5867 | 192581 |
2022-05-13 | St. Louis city | Missouri | 29510 | 58089 | 780 | 300576 | 2595 | 193258 |
2022-05-13 | Douglas | Missouri | 29067 | 2560 | 80 | 13185 | 6067 | 194160 |
2022-05-13 | Mercer | Missouri | 29129 | 704 | 14 | 3617 | 3870 | 194636 |
2022-05-13 | Morgan | Missouri | 29141 | 4053 | 115 | 20627 | 5575 | 196490 |
2022-05-13 | Shannon | Missouri | 29203 | 1609 | 40 | 8166 | 4898 | 197036 |
2022-05-13 | Camden | Missouri | 29029 | 9331 | 180 | 46305 | 3887 | 201511 |
2022-05-13 | Newton | Missouri | 29145 | 11768 | 206 | 58236 | 3537 | 202074 |
2022-05-13 | Worth | Missouri | 29227 | 407 | 3 | 2013 | 1490 | 202185 |
2022-05-13 | Ripley | Missouri | 29181 | 2697 | 61 | 13288 | 4590 | 202965 |
2022-05-13 | Lawrence | Missouri | 29109 | 7798 | 164 | 38355 | 4275 | 203311 |
2022-05-13 | Cedar | Missouri | 29039 | 2936 | 57 | 14349 | 3972 | 204613 |
2022-05-13 | Ste. Genevieve | Missouri | 29186 | 3689 | 39 | 17894 | 2179 | 206158 |
2022-05-13 | Daviess | Missouri | 29061 | 1730 | 29 | 8278 | 3503 | 208987 |
2022-05-13 | Dent | Missouri | 29065 | 3263 | 83 | 15573 | 5329 | 209529 |
2022-05-13 | Wright | Missouri | 29229 | 3847 | 84 | 18289 | 4592 | 210345 |
2022-05-13 | Stoddard | Missouri | 29207 | 6139 | 130 | 29025 | 4478 | 211507 |
2022-05-13 | Linn | Missouri | 29115 | 2560 | 65 | 11920 | 5453 | 214765 |
2022-05-13 | Putnam | Missouri | 29171 | 1013 | 24 | 4696 | 5110 | 215715 |
2022-05-13 | Bollinger | Missouri | 29017 | 2635 | 41 | 12133 | 3379 | 217176 |
2022-05-13 | Iron | Missouri | 29093 | 2200 | 44 | 10125 | 4345 | 217283 |
2022-05-13 | Montgomery | Missouri | 29139 | 2522 | 57 | 11551 | 4934 | 218336 |
2022-05-13 | Benton | Missouri | 29015 | 4248 | 107 | 19443 | 5503 | 218484 |
2022-05-13 | St. Clair | Missouri | 29185 | 2102 | 36 | 9397 | 3831 | 223688 |
2022-05-13 | Harrison | Missouri | 29081 | 1876 | 33 | 8352 | 3951 | 224616 |
2022-05-13 | Audrain | Missouri | 29007 | 5717 | 110 | 25388 | 4332 | 225185 |
2022-05-13 | Johnson | Missouri | 29101 | 12251 | 143 | 54062 | 2645 | 226610 |
2022-05-13 | Laclede | Missouri | 29105 | 8096 | 176 | 35723 | 4926 | 226632 |
2022-05-13 | Crawford | Missouri | 29055 | 5422 | 104 | 23920 | 4347 | 226672 |
2022-05-13 | Dallas | Missouri | 29059 | 3826 | 72 | 16878 | 4265 | 226685 |
2022-05-13 | Ray | Missouri | 29177 | 5221 | 94 | 23018 | 4083 | 226822 |
2022-05-13 | Webster | Missouri | 29225 | 9053 | 148 | 39592 | 3738 | 228657 |
2022-05-13 | St. Louis | Missouri | 29189 | 227453 | 3341 | 994205 | 3360 | 228778 |
2022-05-13 | Howell | Missouri | 29091 | 9185 | 215 | 40117 | 5359 | 228955 |
2022-05-13 | Warren | Missouri | 29219 | 8200 | 102 | 35649 | 2861 | 230020 |
2022-05-13 | Gasconade | Missouri | 29073 | 3385 | 102 | 14706 | 6935 | 230178 |
2022-05-13 | Chariton | Missouri | 29041 | 1718 | 38 | 7426 | 5117 | 231349 |
2022-05-13 | Phelps | Missouri | 29161 | 10317 | 243 | 44573 | 5451 | 231462 |
2022-05-13 | Bates | Missouri | 29013 | 3766 | 96 | 16172 | 5936 | 232871 |
2022-05-13 | Pike | Missouri | 29163 | 4264 | 63 | 18302 | 3442 | 232980 |
2022-05-13 | Cooper | Missouri | 29053 | 4138 | 77 | 17709 | 4348 | 233666 |
2022-05-13 | Clark | Missouri | 29045 | 1597 | 37 | 6797 | 5443 | 234956 |
2022-05-13 | Christian | Missouri | 29043 | 20961 | 263 | 88595 | 2968 | 236593 |
2022-05-13 | Clinton | Missouri | 29049 | 4829 | 119 | 20387 | 5837 | 236866 |
2022-05-13 | Osage | Missouri | 29151 | 3230 | 46 | 13615 | 3378 | 237238 |
2022-05-13 | Moniteau | Missouri | 29135 | 3838 | 57 | 16132 | 3533 | 237912 |
2022-05-13 | Cass | Missouri | 29037 | 25249 | 315 | 105780 | 2977 | 238693 |
2022-05-13 | Miller | Missouri | 29131 | 6123 | 123 | 25619 | 4801 | 239002 |
2022-05-13 | Taney | Missouri | 29213 | 13382 | 226 | 55928 | 4040 | 239271 |
2022-05-13 | Lafayette | Missouri | 29107 | 7832 | 134 | 32708 | 4096 | 239452 |
2022-05-13 | Ralls | Missouri | 29173 | 2470 | 28 | 10309 | 2716 | 239596 |
2022-05-13 | Cape Girardeau | Missouri | 29031 | 18923 | 246 | 78871 | 3119 | 239923 |
2022-05-13 | Butler | Missouri | 29023 | 10206 | 169 | 42478 | 3978 | 240265 |
2022-05-13 | Adair | Missouri | 29001 | 6095 | 63 | 25343 | 2485 | 240500 |
2022-05-13 | Holt | Missouri | 29087 | 1060 | 30 | 4403 | 6813 | 240744 |
2022-05-13 | Macon | Missouri | 29121 | 3652 | 58 | 15117 | 3836 | 241582 |
2022-05-13 | Jefferson | Missouri | 29099 | 54493 | 653 | 225081 | 2901 | 242103 |
2022-05-13 | Barton | Missouri | 29011 | 2859 | 52 | 11754 | 4424 | 243236 |
2022-05-13 | Washington | Missouri | 29221 | 6032 | 141 | 24730 | 5701 | 243914 |
2022-05-13 | Randolph | Missouri | 29175 | 6058 | 103 | 24748 | 4161 | 244787 |
2022-05-13 | Greene | Missouri | 29077 | 71775 | 1040 | 293086 | 3548 | 244893 |
2022-05-13 | Livingston | Missouri | 29117 | 3748 | 97 | 15227 | 6370 | 246141 |
2022-05-13 | Vernon | Missouri | 29217 | 5104 | 109 | 20563 | 5300 | 248212 |
2022-05-13 | Franklin | Missouri | 29071 | 25852 | 373 | 103967 | 3587 | 248655 |
2022-05-13 | Boone | Missouri | 29019 | 45035 | 252 | 180463 | 1396 | 249552 |
2022-05-13 | Knox | Missouri | 29103 | 990 | 14 | 3959 | 3536 | 250063 |
2022-05-13 | Carter | Missouri | 29035 | 1500 | 24 | 5982 | 4012 | 250752 |
2022-05-13 | Polk | Missouri | 29167 | 8073 | 108 | 32149 | 3359 | 251112 |
2022-05-13 | Howard | Missouri | 29089 | 2515 | 30 | 10001 | 2999 | 251474 |
2022-05-13 | Monroe | Missouri | 29137 | 2180 | 43 | 8644 | 4974 | 252198 |
2022-05-13 | McDonald | Missouri | 29119 | 5813 | 73 | 22837 | 3196 | 254543 |
2022-05-13 | Carroll | Missouri | 29033 | 2233 | 44 | 8679 | 5069 | 257287 |
2022-05-13 | Lincoln | Missouri | 29113 | 15187 | 138 | 59013 | 2338 | 257350 |
2022-05-13 | Grundy | Missouri | 29079 | 2543 | 69 | 9850 | 7005 | 258172 |
2022-05-13 | St. Charles | Missouri | 29183 | 103932 | 938 | 402022 | 2333 | 258523 |
2022-05-13 | Cole | Missouri | 29051 | 20202 | 286 | 76745 | 3726 | 263235 |
2022-05-13 | Henry | Missouri | 29083 | 5758 | 86 | 21824 | 3940 | 263837 |
2022-05-13 | Perry | Missouri | 29157 | 5059 | 46 | 19136 | 2403 | 264370 |
2022-05-13 | Mississippi | Missouri | 29133 | 3521 | 59 | 13180 | 4476 | 267147 |
2022-05-13 | Dunklin | Missouri | 29069 | 7824 | 117 | 29131 | 4016 | 268579 |
2022-05-13 | Atchison | Missouri | 29005 | 1387 | 23 | 5143 | 4472 | 269686 |
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;