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 cases_per_million
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 | Jeff Davis | Texas | 48243 | 224 | 9 | 2274 | 3957 | 98504 |
2022-05-13 | Newton | Texas | 48351 | 1367 | 61 | 13595 | 4486 | 100551 |
2022-05-13 | Gaines | Texas | 48165 | 2215 | 83 | 21492 | 3861 | 103061 |
2022-05-13 | Brewster | Texas | 48043 | 1079 | 29 | 9203 | 3151 | 117244 |
2022-05-13 | Sabine | Texas | 48403 | 1254 | 89 | 10542 | 8442 | 118952 |
2022-05-13 | San Augustine | Texas | 48405 | 1082 | 44 | 8237 | 5341 | 131358 |
2022-05-13 | Knox | Texas | 48275 | 492 | 25 | 3664 | 6823 | 134279 |
2022-05-13 | Glasscock | Texas | 48173 | 199 | 3 | 1409 | 2129 | 141234 |
2022-05-13 | Hardeman | Texas | 48197 | 556 | 19 | 3933 | 4830 | 141367 |
2022-05-13 | Rains | Texas | 48379 | 1839 | 59 | 12514 | 4714 | 146955 |
2022-05-13 | Presidio | Texas | 48377 | 998 | 38 | 6704 | 5668 | 148866 |
2022-05-13 | Yoakum | Texas | 48501 | 1317 | 42 | 8713 | 4820 | 151153 |
2022-05-13 | Cherokee | Texas | 48073 | 7989 | 254 | 52646 | 4824 | 151749 |
2022-05-13 | Borden | Texas | 48033 | 100 | 2 | 654 | 3058 | 152905 |
2022-05-13 | Polk | Texas | 48373 | 7896 | 247 | 51353 | 4809 | 153759 |
2022-05-13 | Eastland | Texas | 48133 | 2829 | 113 | 18360 | 6154 | 154084 |
2022-05-13 | Terrell | Texas | 48443 | 121 | 3 | 776 | 3865 | 155927 |
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 | Haskell | Texas | 48207 | 897 | 39 | 5658 | 6892 | 158536 |
2022-05-13 | Goliad | Texas | 48175 | 1216 | 32 | 7658 | 4178 | 158788 |
2022-05-13 | Fisher | Texas | 48151 | 609 | 24 | 3830 | 6266 | 159007 |
2022-05-13 | Hunt | Texas | 48231 | 15811 | 363 | 98594 | 3681 | 160364 |
2022-05-13 | McCulloch | Texas | 48307 | 1308 | 47 | 7984 | 5886 | 163827 |
2022-05-13 | Kimble | Texas | 48267 | 714 | 15 | 4337 | 3458 | 164629 |
2022-05-13 | Sherman | Texas | 48421 | 499 | 16 | 3022 | 5294 | 165122 |
2022-05-13 | San Patricio | Texas | 48409 | 11104 | 341 | 66730 | 5110 | 166401 |
2022-05-13 | Anderson | Texas | 48001 | 9691 | 239 | 57735 | 4139 | 167853 |
2022-05-13 | Jack | Texas | 48237 | 1523 | 28 | 8935 | 3133 | 170453 |
2022-05-13 | Marion | Texas | 48315 | 1690 | 60 | 9854 | 6088 | 171503 |
2022-05-13 | Jasper | Texas | 48241 | 6102 | 187 | 35529 | 5263 | 171747 |
2022-05-13 | Pecos | Texas | 48371 | 2749 | 71 | 15823 | 4487 | 173734 |
2022-05-13 | Kendall | Texas | 48259 | 8263 | 119 | 47431 | 2508 | 174210 |
2022-05-13 | Waller | Texas | 48473 | 9695 | 108 | 55246 | 1954 | 175487 |
2022-05-13 | Wood | Texas | 48499 | 8031 | 288 | 45539 | 6324 | 176354 |
2022-05-13 | Live Oak | Texas | 48297 | 2153 | 42 | 12207 | 3440 | 176374 |
2022-05-13 | Colorado | Texas | 48089 | 3808 | 64 | 21493 | 2977 | 177173 |
2022-05-13 | Aransas | Texas | 48007 | 4177 | 86 | 23510 | 3658 | 177669 |
2022-05-13 | Shelby | Texas | 48419 | 4491 | 134 | 25274 | 5301 | 177692 |
2022-05-13 | Travis | Texas | 48453 | 227227 | 1735 | 1273954 | 1361 | 178363 |
2022-05-13 | Angelina | Texas | 48005 | 15501 | 481 | 86715 | 5546 | 178758 |
2022-05-13 | Orange | Texas | 48361 | 14968 | 355 | 83396 | 4256 | 179481 |
2022-05-13 | Cooke | Texas | 48097 | 7409 | 134 | 41257 | 3247 | 179581 |
2022-05-13 | Llano | Texas | 48299 | 3933 | 97 | 21795 | 4450 | 180454 |
2022-05-13 | Throckmorton | Texas | 48447 | 271 | 8 | 1501 | 5329 | 180546 |
2022-05-13 | Foard | Texas | 48155 | 209 | 11 | 1155 | 9523 | 180952 |
2022-05-13 | Van Zandt | Texas | 48467 | 10399 | 280 | 56590 | 4947 | 183760 |
2022-05-13 | Mason | Texas | 48319 | 787 | 12 | 4274 | 2807 | 184136 |
2022-05-13 | Kerr | Texas | 48265 | 9690 | 182 | 52600 | 3460 | 184220 |
2022-05-13 | Trinity | Texas | 48455 | 2707 | 72 | 14651 | 4914 | 184765 |
2022-05-13 | Houston | Texas | 48225 | 4253 | 111 | 22968 | 4832 | 185170 |
2022-05-13 | Bell | Texas | 48027 | 67290 | 901 | 362924 | 2482 | 185410 |
2022-05-13 | Henderson | Texas | 48213 | 15410 | 424 | 82737 | 5124 | 186252 |
2022-05-13 | Gregg | Texas | 48183 | 23237 | 687 | 123945 | 5542 | 187478 |
2022-05-13 | King | Texas | 48269 | 51 | 0 | 272 | 0 | 187500 |
2022-05-13 | Howard | Texas | 48227 | 6876 | 184 | 36664 | 5018 | 187540 |
2022-05-13 | Schleicher | Texas | 48413 | 528 | 9 | 2793 | 3222 | 189044 |
2022-05-13 | Fayette | Texas | 48149 | 4796 | 105 | 25346 | 4142 | 189221 |
2022-05-13 | Sterling | Texas | 48431 | 245 | 6 | 1291 | 4647 | 189775 |
2022-05-13 | Upshur | Texas | 48459 | 7926 | 186 | 41753 | 4454 | 189830 |
2022-05-13 | Nacogdoches | Texas | 48347 | 12413 | 258 | 65204 | 3956 | 190371 |
2022-05-13 | Red River | Texas | 48387 | 2304 | 67 | 12023 | 5572 | 191632 |
2022-05-13 | Austin | Texas | 48015 | 5818 | 73 | 30032 | 2430 | 193726 |
2022-05-13 | Fannin | Texas | 48147 | 6897 | 183 | 35514 | 5152 | 194205 |
2022-05-13 | San Jacinto | Texas | 48407 | 5611 | 102 | 28859 | 3534 | 194428 |
2022-05-13 | Smith | Texas | 48423 | 45581 | 968 | 232751 | 4158 | 195835 |
2022-05-13 | Hopkins | Texas | 48223 | 7264 | 180 | 37084 | 4853 | 195879 |
2022-05-13 | Jefferson | Texas | 48245 | 49316 | 843 | 251565 | 3351 | 196036 |
2022-05-13 | Hale | Texas | 48189 | 6571 | 245 | 33406 | 7334 | 196701 |
2022-05-13 | Freestone | Texas | 48161 | 3880 | 82 | 19717 | 4158 | 196784 |
2022-05-13 | Stephens | Texas | 48429 | 1846 | 46 | 9366 | 4911 | 197095 |
2022-05-13 | Panola | Texas | 48365 | 4609 | 129 | 23194 | 5561 | 198715 |
2022-05-13 | Medina | Texas | 48325 | 10269 | 199 | 51584 | 3857 | 199073 |
2022-05-13 | Milam | Texas | 48331 | 4950 | 102 | 24823 | 4109 | 199411 |
2022-05-13 | Grayson | Texas | 48181 | 27166 | 636 | 136212 | 4669 | 199439 |
2022-05-13 | Rusk | Texas | 48401 | 10870 | 233 | 54406 | 4282 | 199794 |
2022-05-13 | Clay | Texas | 48077 | 2096 | 35 | 10471 | 3342 | 200171 |
2022-05-13 | Harrison | Texas | 48203 | 13370 | 227 | 66553 | 3410 | 200892 |
2022-05-13 | Gillespie | Texas | 48171 | 5426 | 109 | 26988 | 4038 | 201052 |
2022-05-13 | Coleman | Texas | 48083 | 1646 | 71 | 8175 | 8685 | 201345 |
2022-05-13 | Kinney | Texas | 48271 | 741 | 11 | 3667 | 2999 | 202072 |
2022-05-13 | Hudspeth | Texas | 48229 | 989 | 18 | 4886 | 3683 | 202415 |
2022-05-13 | Morris | Texas | 48343 | 2529 | 73 | 12388 | 5892 | 204149 |
2022-05-13 | Denton | Texas | 48121 | 181158 | 1354 | 887207 | 1526 | 204189 |
2022-05-13 | Andrews | Texas | 48003 | 3822 | 72 | 18705 | 3849 | 204330 |
2022-05-13 | Dickens | Texas | 48125 | 453 | 16 | 2211 | 7236 | 204884 |
2022-05-13 | Roberts | Texas | 48393 | 175 | 2 | 854 | 2341 | 204918 |
2022-05-13 | San Saba | Texas | 48411 | 1242 | 35 | 6055 | 5780 | 205119 |
2022-05-13 | Garza | Texas | 48169 | 1279 | 28 | 6229 | 4495 | 205329 |
2022-05-13 | Victoria | Texas | 48469 | 18919 | 413 | 92084 | 4485 | 205453 |
2022-05-13 | Erath | Texas | 48143 | 8790 | 123 | 42698 | 2880 | 205864 |
2022-05-13 | Liberty | Texas | 48291 | 18210 | 404 | 88219 | 4579 | 206418 |
2022-05-13 | Franklin | Texas | 48159 | 2228 | 42 | 10725 | 3916 | 207738 |
2022-05-13 | Nolan | Texas | 48353 | 3065 | 99 | 14714 | 6728 | 208305 |
2022-05-13 | Collin | Texas | 48085 | 215831 | 1507 | 1034730 | 1456 | 208586 |
2022-05-13 | Martin | Texas | 48317 | 1207 | 26 | 5771 | 4505 | 209149 |
2022-05-13 | Callahan | Texas | 48059 | 2920 | 72 | 13943 | 5163 | 209424 |
2022-05-13 | Hardin | Texas | 48199 | 12078 | 251 | 57602 | 4357 | 209680 |
2022-05-13 | Shackelford | Texas | 48417 | 691 | 12 | 3265 | 3675 | 211638 |
2022-05-13 | Lavaca | Texas | 48285 | 4271 | 120 | 20154 | 5954 | 211918 |
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;