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 | Colorado | Texas | 48089 | 3808 | 64 | 21493 | 2977 | 177173 |
2022-05-13 | Falls | Texas | 48145 | 3797 | 65 | 17297 | 3757 | 219517 |
2022-05-13 | Runnels | Texas | 48399 | 2393 | 66 | 10264 | 6430 | 233144 |
2022-05-13 | Burleson | Texas | 48051 | 5048 | 66 | 18443 | 3578 | 273708 |
2022-05-13 | Red River | Texas | 48387 | 2304 | 67 | 12023 | 5572 | 191632 |
2022-05-13 | Zavala | Texas | 48507 | 4059 | 68 | 11840 | 5743 | 342820 |
2022-05-13 | Duval | Texas | 48131 | 3412 | 70 | 11157 | 6274 | 305816 |
2022-05-13 | Karnes | Texas | 48255 | 5968 | 70 | 15601 | 4486 | 382539 |
2022-05-13 | Bosque | Texas | 48035 | 4130 | 70 | 18685 | 3746 | 221032 |
2022-05-13 | Coleman | Texas | 48083 | 1646 | 71 | 8175 | 8685 | 201345 |
2022-05-13 | Pecos | Texas | 48371 | 2749 | 71 | 15823 | 4487 | 173734 |
2022-05-13 | Callahan | Texas | 48059 | 2920 | 72 | 13943 | 5163 | 209424 |
2022-05-13 | Trinity | Texas | 48455 | 2707 | 72 | 14651 | 4914 | 184765 |
2022-05-13 | Andrews | Texas | 48003 | 3822 | 72 | 18705 | 3849 | 204330 |
2022-05-13 | Morris | Texas | 48343 | 2529 | 73 | 12388 | 5892 | 204149 |
2022-05-13 | Austin | Texas | 48015 | 5818 | 73 | 30032 | 2430 | 193726 |
2022-05-13 | Reeves | Texas | 48389 | 4636 | 74 | 15976 | 4631 | 290185 |
2022-05-13 | Camp | Texas | 48063 | 2873 | 75 | 13094 | 5727 | 219413 |
2022-05-13 | Robertson | Texas | 48395 | 4541 | 77 | 17074 | 4509 | 265959 |
2022-05-13 | Bandera | Texas | 48019 | 3636 | 77 | 23112 | 3331 | 157320 |
2022-05-13 | Comanche | Texas | 48093 | 3698 | 78 | 13635 | 5720 | 271213 |
2022-05-13 | Freestone | Texas | 48161 | 3880 | 82 | 19717 | 4158 | 196784 |
2022-05-13 | Gaines | Texas | 48165 | 2215 | 83 | 21492 | 3861 | 103061 |
2022-05-13 | Terry | Texas | 48445 | 2790 | 84 | 12337 | 6808 | 226148 |
2022-05-13 | Aransas | Texas | 48007 | 4177 | 86 | 23510 | 3658 | 177669 |
2022-05-13 | Wilbarger | Texas | 48487 | 3486 | 87 | 12769 | 6813 | 273004 |
2022-05-13 | Tyler | Texas | 48457 | 3405 | 88 | 21672 | 4060 | 157115 |
2022-05-13 | Sabine | Texas | 48403 | 1254 | 89 | 10542 | 8442 | 118952 |
2022-05-13 | Lampasas | Texas | 48281 | 5556 | 90 | 21428 | 4200 | 259286 |
2022-05-13 | Leon | Texas | 48289 | 3728 | 93 | 17404 | 5343 | 214203 |
2022-05-13 | Jones | Texas | 48253 | 4643 | 93 | 20083 | 4630 | 231190 |
2022-05-13 | Frio | Texas | 48163 | 5935 | 93 | 20306 | 4579 | 292278 |
2022-05-13 | Dawson | Texas | 48115 | 2998 | 94 | 12728 | 7385 | 235543 |
2022-05-13 | Young | Texas | 48503 | 4002 | 94 | 18010 | 5219 | 222209 |
2022-05-13 | Llano | Texas | 48299 | 3933 | 97 | 21795 | 4450 | 180454 |
2022-05-13 | Nolan | Texas | 48353 | 3065 | 99 | 14714 | 6728 | 208305 |
2022-05-13 | DeWitt | Texas | 48123 | 6486 | 99 | 20160 | 4910 | 321726 |
2022-05-13 | Gonzales | Texas | 48177 | 4736 | 99 | 20837 | 4751 | 227287 |
2022-05-13 | Milam | Texas | 48331 | 4950 | 102 | 24823 | 4109 | 199411 |
2022-05-13 | San Jacinto | Texas | 48407 | 5611 | 102 | 28859 | 3534 | 194428 |
2022-05-13 | Scurry | Texas | 48415 | 4983 | 104 | 16703 | 6226 | 298329 |
2022-05-13 | Fayette | Texas | 48149 | 4796 | 105 | 25346 | 4142 | 189221 |
2022-05-13 | Waller | Texas | 48473 | 9695 | 108 | 55246 | 1954 | 175487 |
2022-05-13 | Gillespie | Texas | 48171 | 5426 | 109 | 26988 | 4038 | 201052 |
2022-05-13 | Deaf Smith | Texas | 48117 | 4809 | 111 | 18546 | 5985 | 259301 |
2022-05-13 | Moore | Texas | 48341 | 5604 | 111 | 20940 | 5300 | 267621 |
2022-05-13 | Houston | Texas | 48225 | 4253 | 111 | 22968 | 4832 | 185170 |
2022-05-13 | Chambers | Texas | 48071 | 11706 | 112 | 43837 | 2554 | 267034 |
2022-05-13 | Eastland | Texas | 48133 | 2829 | 113 | 18360 | 6154 | 154084 |
2022-05-13 | Kendall | Texas | 48259 | 8263 | 119 | 47431 | 2508 | 174210 |
2022-05-13 | Lavaca | Texas | 48285 | 4271 | 120 | 20154 | 5954 | 211918 |
2022-05-13 | Grimes | Texas | 48185 | 8511 | 120 | 28880 | 4155 | 294702 |
2022-05-13 | Lamb | Texas | 48279 | 4356 | 122 | 12893 | 9462 | 337857 |
2022-05-13 | Erath | Texas | 48143 | 8790 | 123 | 42698 | 2880 | 205864 |
2022-05-13 | Limestone | Texas | 48293 | 5100 | 124 | 23437 | 5290 | 217604 |
2022-05-13 | Gray | Texas | 48179 | 6195 | 125 | 21886 | 5711 | 283057 |
2022-05-13 | Titus | Texas | 48449 | 8673 | 128 | 32750 | 3908 | 264824 |
2022-05-13 | Montague | Texas | 48337 | 4694 | 129 | 19818 | 6509 | 236855 |
2022-05-13 | Panola | Texas | 48365 | 4609 | 129 | 23194 | 5561 | 198715 |
2022-05-13 | Willacy | Texas | 48489 | 7089 | 130 | 21358 | 6086 | 331913 |
2022-05-13 | Shelby | Texas | 48419 | 4491 | 134 | 25274 | 5301 | 177692 |
2022-05-13 | Cooke | Texas | 48097 | 7409 | 134 | 41257 | 3247 | 179581 |
2022-05-13 | Hutchinson | Texas | 48233 | 6755 | 135 | 20938 | 6447 | 322619 |
2022-05-13 | Uvalde | Texas | 48463 | 10600 | 145 | 26741 | 5422 | 396395 |
2022-05-13 | Kleberg | Texas | 48273 | 7304 | 147 | 30680 | 4791 | 238070 |
2022-05-13 | Washington | Texas | 48477 | 9232 | 148 | 35882 | 4124 | 257287 |
2022-05-13 | Bee | Texas | 48025 | 8418 | 153 | 32565 | 4698 | 258498 |
2022-05-13 | Palo Pinto | Texas | 48363 | 7052 | 154 | 29189 | 5275 | 241597 |
2022-05-13 | Wilson | Texas | 48493 | 11032 | 157 | 51070 | 3074 | 216017 |
2022-05-13 | Hockley | Texas | 48219 | 7750 | 161 | 23021 | 6993 | 336649 |
2022-05-13 | Burnet | Texas | 48053 | 11095 | 171 | 48155 | 3551 | 230401 |
2022-05-13 | Matagorda | Texas | 48321 | 8374 | 175 | 36643 | 4775 | 228529 |
2022-05-13 | Caldwell | Texas | 48055 | 14339 | 176 | 43664 | 4030 | 328394 |
2022-05-13 | Hopkins | Texas | 48223 | 7264 | 180 | 37084 | 4853 | 195879 |
2022-05-13 | Kerr | Texas | 48265 | 9690 | 182 | 52600 | 3460 | 184220 |
2022-05-13 | Fannin | Texas | 48147 | 6897 | 183 | 35514 | 5152 | 194205 |
2022-05-13 | Howard | Texas | 48227 | 6876 | 184 | 36664 | 5018 | 187540 |
2022-05-13 | Upshur | Texas | 48459 | 7926 | 186 | 41753 | 4454 | 189830 |
2022-05-13 | Jasper | Texas | 48241 | 6102 | 187 | 35529 | 5263 | 171747 |
2022-05-13 | Hill | Texas | 48217 | 8991 | 192 | 36649 | 5238 | 245327 |
2022-05-13 | Cass | Texas | 48067 | 7260 | 197 | 30026 | 6560 | 241790 |
2022-05-13 | Medina | Texas | 48325 | 10269 | 199 | 51584 | 3857 | 199073 |
2022-05-13 | Jim Wells | Texas | 48249 | 11411 | 208 | 40482 | 5138 | 281878 |
2022-05-13 | Coryell | Texas | 48099 | 17626 | 211 | 75951 | 2778 | 232070 |
2022-05-13 | Walker | Texas | 48471 | 19223 | 212 | 72971 | 2905 | 263433 |
2022-05-13 | Wharton | Texas | 48481 | 9175 | 214 | 41556 | 5149 | 220786 |
2022-05-13 | Navarro | Texas | 48349 | 12469 | 222 | 50113 | 4429 | 248817 |
2022-05-13 | Harrison | Texas | 48203 | 13370 | 227 | 66553 | 3410 | 200892 |
2022-05-13 | Atascosa | Texas | 48013 | 13647 | 231 | 51153 | 4515 | 266787 |
2022-05-13 | Rusk | Texas | 48401 | 10870 | 233 | 54406 | 4282 | 199794 |
2022-05-13 | Anderson | Texas | 48001 | 9691 | 239 | 57735 | 4139 | 167853 |
2022-05-13 | Bastrop | Texas | 48021 | 21971 | 239 | 88723 | 2693 | 247635 |
2022-05-13 | Hale | Texas | 48189 | 6571 | 245 | 33406 | 7334 | 196701 |
2022-05-13 | Polk | Texas | 48373 | 7896 | 247 | 51353 | 4809 | 153759 |
2022-05-13 | Hardin | Texas | 48199 | 12078 | 251 | 57602 | 4357 | 209680 |
2022-05-13 | Brown | Texas | 48049 | 12056 | 253 | 37864 | 6681 | 318402 |
2022-05-13 | Cherokee | Texas | 48073 | 7989 | 254 | 52646 | 4824 | 151749 |
2022-05-13 | Lamar | Texas | 48277 | 12500 | 256 | 49859 | 5134 | 250706 |
2022-05-13 | Nacogdoches | Texas | 48347 | 12413 | 258 | 65204 | 3956 | 190371 |
2022-05-13 | Rockwall | Texas | 48397 | 26778 | 266 | 104915 | 2535 | 255235 |
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;