latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where state = "Texas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Texas · 254 ✖
date | county | state | fips | cases | deaths ▼ | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | King | Texas | 48269 | 51 | 0 | 272 | 0 | 187500 |
2022-05-13 | Loving | Texas | 48301 | 196 | 1 | 169 | 5917 | 1159763 |
2022-05-13 | Kenedy | Texas | 48261 | 86 | 2 | 404 | 4950 | 212871 |
2022-05-13 | Borden | Texas | 48033 | 100 | 2 | 654 | 3058 | 152905 |
2022-05-13 | Roberts | Texas | 48393 | 175 | 2 | 854 | 2341 | 204918 |
2022-05-13 | Terrell | Texas | 48443 | 121 | 3 | 776 | 3865 | 155927 |
2022-05-13 | Glasscock | Texas | 48173 | 199 | 3 | 1409 | 2129 | 141234 |
2022-05-13 | Irion | Texas | 48235 | 445 | 3 | 1536 | 1953 | 289713 |
2022-05-13 | Hartley | Texas | 48205 | 1364 | 3 | 5576 | 538 | 244619 |
2022-05-13 | Kent | Texas | 48263 | 210 | 4 | 762 | 5249 | 275590 |
2022-05-13 | Sterling | Texas | 48431 | 245 | 6 | 1291 | 4647 | 189775 |
2022-05-13 | Oldham | Texas | 48359 | 565 | 6 | 2112 | 2840 | 267518 |
2022-05-13 | Stonewall | Texas | 48433 | 362 | 7 | 1350 | 5185 | 268148 |
2022-05-13 | Hemphill | Texas | 48211 | 1239 | 7 | 3819 | 1832 | 324430 |
2022-05-13 | Throckmorton | Texas | 48447 | 271 | 8 | 1501 | 5329 | 180546 |
2022-05-13 | Briscoe | Texas | 48045 | 465 | 8 | 1546 | 5174 | 300776 |
2022-05-13 | McMullen | Texas | 48311 | 169 | 9 | 743 | 12113 | 227456 |
2022-05-13 | Cottle | Texas | 48101 | 319 | 9 | 1398 | 6437 | 228183 |
2022-05-13 | Armstrong | Texas | 48011 | 555 | 9 | 1887 | 4769 | 294117 |
2022-05-13 | Jeff Davis | Texas | 48243 | 224 | 9 | 2274 | 3957 | 98504 |
2022-05-13 | Schleicher | Texas | 48413 | 528 | 9 | 2793 | 3222 | 189044 |
2022-05-13 | Foard | Texas | 48155 | 209 | 11 | 1155 | 9523 | 180952 |
2022-05-13 | Edwards | Texas | 48137 | 467 | 11 | 1932 | 5693 | 241718 |
2022-05-13 | Concho | Texas | 48095 | 1084 | 11 | 2726 | 4035 | 397652 |
2022-05-13 | Kinney | Texas | 48271 | 741 | 11 | 3667 | 2999 | 202072 |
2022-05-13 | Menard | Texas | 48327 | 513 | 12 | 2138 | 5612 | 239943 |
2022-05-13 | Shackelford | Texas | 48417 | 691 | 12 | 3265 | 3675 | 211638 |
2022-05-13 | Sutton | Texas | 48435 | 848 | 12 | 3776 | 3177 | 224576 |
2022-05-13 | Mason | Texas | 48319 | 787 | 12 | 4274 | 2807 | 184136 |
2022-05-13 | Motley | Texas | 48345 | 286 | 13 | 1200 | 10833 | 238333 |
2022-05-13 | Culberson | Texas | 48109 | 514 | 14 | 2171 | 6448 | 236757 |
2022-05-13 | Reagan | Texas | 48383 | 859 | 14 | 3849 | 3637 | 223174 |
2022-05-13 | Kimble | Texas | 48267 | 714 | 15 | 4337 | 3458 | 164629 |
2022-05-13 | Dickens | Texas | 48125 | 453 | 16 | 2211 | 7236 | 204884 |
2022-05-13 | Collingsworth | Texas | 48087 | 702 | 16 | 2920 | 5479 | 240410 |
2022-05-13 | Sherman | Texas | 48421 | 499 | 16 | 3022 | 5294 | 165122 |
2022-05-13 | Lipscomb | Texas | 48295 | 720 | 16 | 3233 | 4948 | 222703 |
2022-05-13 | Upton | Texas | 48461 | 833 | 18 | 3657 | 4922 | 227782 |
2022-05-13 | Hudspeth | Texas | 48229 | 989 | 18 | 4886 | 3683 | 202415 |
2022-05-13 | Crockett | Texas | 48105 | 1091 | 19 | 3464 | 5484 | 314953 |
2022-05-13 | Hardeman | Texas | 48197 | 556 | 19 | 3933 | 4830 | 141367 |
2022-05-13 | Coke | Texas | 48081 | 843 | 20 | 3387 | 5904 | 248892 |
2022-05-13 | Jim Hogg | Texas | 48247 | 2648 | 22 | 5200 | 4230 | 509230 |
2022-05-13 | Cochran | Texas | 48079 | 891 | 23 | 2853 | 8061 | 312302 |
2022-05-13 | Wheeler | Texas | 48483 | 1193 | 23 | 5056 | 4549 | 235957 |
2022-05-13 | Hall | Texas | 48191 | 1102 | 24 | 2964 | 8097 | 371794 |
2022-05-13 | Fisher | Texas | 48151 | 609 | 24 | 3830 | 6266 | 159007 |
2022-05-13 | Crane | Texas | 48103 | 1285 | 24 | 4797 | 5003 | 267875 |
2022-05-13 | Real | Texas | 48385 | 817 | 25 | 3452 | 7242 | 236674 |
2022-05-13 | Knox | Texas | 48275 | 492 | 25 | 3664 | 6823 | 134279 |
2022-05-13 | Delta | Texas | 48119 | 1820 | 25 | 5331 | 4689 | 341399 |
2022-05-13 | Donley | Texas | 48129 | 1153 | 26 | 3278 | 7931 | 351738 |
2022-05-13 | Martin | Texas | 48317 | 1207 | 26 | 5771 | 4505 | 209149 |
2022-05-13 | Garza | Texas | 48169 | 1279 | 28 | 6229 | 4495 | 205329 |
2022-05-13 | Archer | Texas | 48009 | 2213 | 28 | 8553 | 3273 | 258739 |
2022-05-13 | Jack | Texas | 48237 | 1523 | 28 | 8935 | 3133 | 170453 |
2022-05-13 | Hansford | Texas | 48195 | 1929 | 29 | 5399 | 5371 | 357288 |
2022-05-13 | Brewster | Texas | 48043 | 1079 | 29 | 9203 | 3151 | 117244 |
2022-05-13 | Baylor | Texas | 48023 | 818 | 32 | 3509 | 9119 | 233114 |
2022-05-13 | Goliad | Texas | 48175 | 1216 | 32 | 7658 | 4178 | 158788 |
2022-05-13 | Childress | Texas | 48075 | 2638 | 33 | 7306 | 4516 | 361073 |
2022-05-13 | Hamilton | Texas | 48193 | 1972 | 33 | 8461 | 3900 | 233069 |
2022-05-13 | Swisher | Texas | 48437 | 2288 | 34 | 7397 | 4596 | 309314 |
2022-05-13 | Winkler | Texas | 48495 | 1846 | 34 | 8010 | 4244 | 230461 |
2022-05-13 | Blanco | Texas | 48031 | 2568 | 34 | 11931 | 2849 | 215237 |
2022-05-13 | San Saba | Texas | 48411 | 1242 | 35 | 6055 | 5780 | 205119 |
2022-05-13 | Clay | Texas | 48077 | 2096 | 35 | 10471 | 3342 | 200171 |
2022-05-13 | Carson | Texas | 48065 | 1532 | 36 | 5926 | 6074 | 258521 |
2022-05-13 | Refugio | Texas | 48391 | 1781 | 36 | 6948 | 5181 | 256332 |
2022-05-13 | Somervell | Texas | 48425 | 2116 | 36 | 9128 | 3943 | 231814 |
2022-05-13 | Mills | Texas | 48333 | 1475 | 37 | 4873 | 7592 | 302688 |
2022-05-13 | Lynn | Texas | 48305 | 1556 | 38 | 5951 | 6385 | 261468 |
2022-05-13 | Presidio | Texas | 48377 | 998 | 38 | 6704 | 5668 | 148866 |
2022-05-13 | Haskell | Texas | 48207 | 897 | 39 | 5658 | 6892 | 158536 |
2022-05-13 | Bailey | Texas | 48017 | 1511 | 39 | 7000 | 5571 | 215857 |
2022-05-13 | Dallam | Texas | 48111 | 2155 | 40 | 7287 | 5489 | 295732 |
2022-05-13 | Yoakum | Texas | 48501 | 1317 | 42 | 8713 | 4820 | 151153 |
2022-05-13 | Franklin | Texas | 48159 | 2228 | 42 | 10725 | 3916 | 207738 |
2022-05-13 | Live Oak | Texas | 48297 | 2153 | 42 | 12207 | 3440 | 176374 |
2022-05-13 | San Augustine | Texas | 48405 | 1082 | 44 | 8237 | 5341 | 131358 |
2022-05-13 | Ward | Texas | 48475 | 2830 | 44 | 11998 | 3667 | 235872 |
2022-05-13 | Crosby | Texas | 48107 | 1894 | 45 | 5737 | 7843 | 330137 |
2022-05-13 | Stephens | Texas | 48429 | 1846 | 46 | 9366 | 4911 | 197095 |
2022-05-13 | Castro | Texas | 48069 | 2297 | 47 | 7530 | 6241 | 305046 |
2022-05-13 | McCulloch | Texas | 48307 | 1308 | 47 | 7984 | 5886 | 163827 |
2022-05-13 | Floyd | Texas | 48153 | 1961 | 48 | 5712 | 8403 | 343312 |
2022-05-13 | La Salle | Texas | 48283 | 2421 | 48 | 7520 | 6382 | 321941 |
2022-05-13 | Ochiltree | Texas | 48357 | 2424 | 48 | 9836 | 4880 | 246441 |
2022-05-13 | Calhoun | Texas | 48057 | 5731 | 48 | 21290 | 2254 | 269187 |
2022-05-13 | Mitchell | Texas | 48335 | 1864 | 49 | 8545 | 5734 | 218139 |
2022-05-13 | Dimmit | Texas | 48127 | 5760 | 51 | 10124 | 5037 | 568945 |
2022-05-13 | Brooks | Texas | 48047 | 1642 | 52 | 7093 | 7331 | 231495 |
2022-05-13 | Parmer | Texas | 48369 | 2363 | 52 | 9605 | 5413 | 246017 |
2022-05-13 | Madison | Texas | 48313 | 3778 | 54 | 14284 | 3780 | 264491 |
2022-05-13 | Zapata | Texas | 48505 | 3752 | 55 | 14179 | 3878 | 264616 |
2022-05-13 | Rains | Texas | 48379 | 1839 | 59 | 12514 | 4714 | 146955 |
2022-05-13 | Jackson | Texas | 48239 | 3258 | 59 | 14760 | 3997 | 220731 |
2022-05-13 | Marion | Texas | 48315 | 1690 | 60 | 9854 | 6088 | 171503 |
2022-05-13 | Lee | Texas | 48287 | 4278 | 60 | 17239 | 3480 | 248158 |
2022-05-13 | Newton | Texas | 48351 | 1367 | 61 | 13595 | 4486 | 100551 |
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;