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)
state 1
- Texas · 254 ✖
date | county | state | fips | cases | deaths ▼ | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Wise | Texas | 48497 | 17052 | 270 | 69984 | 3858 | 243655 |
2022-05-13 | Hood | Texas | 48221 | 13472 | 274 | 61643 | 4444 | 218548 |
2022-05-13 | Van Zandt | Texas | 48467 | 10399 | 280 | 56590 | 4947 | 183760 |
2022-05-13 | Wood | Texas | 48499 | 8031 | 288 | 45539 | 6324 | 176354 |
2022-05-13 | Val Verde | Texas | 48465 | 14368 | 303 | 49025 | 6180 | 293074 |
2022-05-13 | San Patricio | Texas | 48409 | 11104 | 341 | 66730 | 5110 | 166401 |
2022-05-13 | Orange | Texas | 48361 | 14968 | 355 | 83396 | 4256 | 179481 |
2022-05-13 | Hunt | Texas | 48231 | 15811 | 363 | 98594 | 3681 | 160364 |
2022-05-13 | Starr | Texas | 48427 | 20091 | 366 | 64633 | 5662 | 310847 |
2022-05-13 | Guadalupe | Texas | 48187 | 38361 | 398 | 166847 | 2385 | 229917 |
2022-05-13 | Liberty | Texas | 48291 | 18210 | 404 | 88219 | 4579 | 206418 |
2022-05-13 | Victoria | Texas | 48469 | 18919 | 413 | 92084 | 4485 | 205453 |
2022-05-13 | Brazos | Texas | 48041 | 60873 | 413 | 229211 | 1801 | 265576 |
2022-05-13 | Henderson | Texas | 48213 | 15410 | 424 | 82737 | 5124 | 186252 |
2022-05-13 | Bowie | Texas | 48037 | 20222 | 432 | 93245 | 4632 | 216869 |
2022-05-13 | Parker | Texas | 48367 | 34819 | 450 | 142878 | 3149 | 243697 |
2022-05-13 | Maverick | Texas | 48323 | 20872 | 469 | 58722 | 7986 | 355437 |
2022-05-13 | Angelina | Texas | 48005 | 15501 | 481 | 86715 | 5546 | 178758 |
2022-05-13 | Midland | Texas | 48329 | 40910 | 496 | 176832 | 2804 | 231349 |
2022-05-13 | Hays | Texas | 48209 | 60893 | 498 | 230191 | 2163 | 264532 |
2022-05-13 | Randall | Texas | 48381 | 38234 | 516 | 137713 | 3746 | 277635 |
2022-05-13 | Kaufman | Texas | 48257 | 35680 | 536 | 136154 | 3936 | 262056 |
2022-05-13 | Comal | Texas | 48091 | 34812 | 551 | 156209 | 3527 | 222855 |
2022-05-13 | Tom Green | Texas | 48451 | 41068 | 553 | 119200 | 4639 | 344530 |
2022-05-13 | Ellis | Texas | 48139 | 49172 | 582 | 184826 | 3148 | 266044 |
2022-05-13 | Grayson | Texas | 48181 | 27166 | 636 | 136212 | 4669 | 199439 |
2022-05-13 | Wichita | Texas | 48485 | 34143 | 679 | 132230 | 5134 | 258209 |
2022-05-13 | Gregg | Texas | 48183 | 23237 | 687 | 123945 | 5542 | 187478 |
2022-05-13 | Ector | Texas | 48135 | 37544 | 703 | 166223 | 4229 | 225865 |
2022-05-13 | Taylor | Texas | 48441 | 35192 | 725 | 138034 | 5252 | 254951 |
2022-05-13 | Johnson | Texas | 48251 | 43903 | 735 | 175817 | 4180 | 249708 |
2022-05-13 | Potter | Texas | 48375 | 35779 | 739 | 117415 | 6293 | 304722 |
2022-05-13 | Jefferson | Texas | 48245 | 49316 | 843 | 251565 | 3351 | 196036 |
2022-05-13 | Galveston | Texas | 48167 | 96616 | 853 | 342139 | 2493 | 282388 |
2022-05-13 | Bell | Texas | 48027 | 67290 | 901 | 362924 | 2482 | 185410 |
2022-05-13 | McLennan | Texas | 48309 | 60473 | 902 | 256623 | 3514 | 235649 |
2022-05-13 | Williamson | Texas | 48491 | 135522 | 935 | 590551 | 1583 | 229483 |
2022-05-13 | Smith | Texas | 48423 | 45581 | 968 | 232751 | 4158 | 195835 |
2022-05-13 | Brazoria | Texas | 48039 | 94245 | 983 | 374264 | 2626 | 251814 |
2022-05-13 | Webb | Texas | 48479 | 96110 | 1036 | 276652 | 3744 | 347403 |
2022-05-13 | Fort Bend | Texas | 48157 | 189442 | 1260 | 811688 | 1552 | 233392 |
2022-05-13 | Montgomery | Texas | 48339 | 141687 | 1291 | 607391 | 2125 | 233271 |
2022-05-13 | Lubbock | Texas | 48303 | 93789 | 1329 | 310569 | 4279 | 301990 |
2022-05-13 | Denton | Texas | 48121 | 181158 | 1354 | 887207 | 1526 | 204189 |
2022-05-13 | Nueces | Texas | 48355 | 93429 | 1494 | 362294 | 4123 | 257881 |
2022-05-13 | Collin | Texas | 48085 | 215831 | 1507 | 1034730 | 1456 | 208586 |
2022-05-13 | Travis | Texas | 48453 | 227227 | 1735 | 1273954 | 1361 | 178363 |
2022-05-13 | Cameron | Texas | 48061 | 105092 | 2032 | 423163 | 4801 | 248348 |
2022-05-13 | El Paso | Texas | 48141 | 208635 | 3734 | 839238 | 4449 | 248600 |
2022-05-13 | Hidalgo | Texas | 48215 | 207289 | 3909 | 868707 | 4499 | 238617 |
2022-05-13 | Tarrant | Texas | 48439 | 569281 | 5925 | 2102515 | 2818 | 270761 |
2022-05-13 | Bexar | Texas | 48029 | 565111 | 6131 | 2003554 | 3060 | 282054 |
2022-05-13 | Dallas | Texas | 48113 | 573644 | 6772 | 2635516 | 2569 | 217659 |
2022-05-13 | Harris | Texas | 48201 | 1032781 | 10972 | 4713325 | 2327 | 219119 |
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;