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 date
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 | McMullen | Texas | 48311 | 169 | 9 | 743 | 12113 | 227456 |
2022-05-13 | Motley | Texas | 48345 | 286 | 13 | 1200 | 10833 | 238333 |
2022-05-13 | Foard | Texas | 48155 | 209 | 11 | 1155 | 9523 | 180952 |
2022-05-13 | Lamb | Texas | 48279 | 4356 | 122 | 12893 | 9462 | 337857 |
2022-05-13 | Baylor | Texas | 48023 | 818 | 32 | 3509 | 9119 | 233114 |
2022-05-13 | Coleman | Texas | 48083 | 1646 | 71 | 8175 | 8685 | 201345 |
2022-05-13 | Sabine | Texas | 48403 | 1254 | 89 | 10542 | 8442 | 118952 |
2022-05-13 | Floyd | Texas | 48153 | 1961 | 48 | 5712 | 8403 | 343312 |
2022-05-13 | Hall | Texas | 48191 | 1102 | 24 | 2964 | 8097 | 371794 |
2022-05-13 | Cochran | Texas | 48079 | 891 | 23 | 2853 | 8061 | 312302 |
2022-05-13 | Maverick | Texas | 48323 | 20872 | 469 | 58722 | 7986 | 355437 |
2022-05-13 | Donley | Texas | 48129 | 1153 | 26 | 3278 | 7931 | 351738 |
2022-05-13 | Crosby | Texas | 48107 | 1894 | 45 | 5737 | 7843 | 330137 |
2022-05-13 | Mills | Texas | 48333 | 1475 | 37 | 4873 | 7592 | 302688 |
2022-05-13 | Dawson | Texas | 48115 | 2998 | 94 | 12728 | 7385 | 235543 |
2022-05-13 | Hale | Texas | 48189 | 6571 | 245 | 33406 | 7334 | 196701 |
2022-05-13 | Brooks | Texas | 48047 | 1642 | 52 | 7093 | 7331 | 231495 |
2022-05-13 | Real | Texas | 48385 | 817 | 25 | 3452 | 7242 | 236674 |
2022-05-13 | Dickens | Texas | 48125 | 453 | 16 | 2211 | 7236 | 204884 |
2022-05-13 | Hockley | Texas | 48219 | 7750 | 161 | 23021 | 6993 | 336649 |
2022-05-13 | Haskell | Texas | 48207 | 897 | 39 | 5658 | 6892 | 158536 |
2022-05-13 | Knox | Texas | 48275 | 492 | 25 | 3664 | 6823 | 134279 |
2022-05-13 | Wilbarger | Texas | 48487 | 3486 | 87 | 12769 | 6813 | 273004 |
2022-05-13 | Terry | Texas | 48445 | 2790 | 84 | 12337 | 6808 | 226148 |
2022-05-13 | Nolan | Texas | 48353 | 3065 | 99 | 14714 | 6728 | 208305 |
2022-05-13 | Brown | Texas | 48049 | 12056 | 253 | 37864 | 6681 | 318402 |
2022-05-13 | Cass | Texas | 48067 | 7260 | 197 | 30026 | 6560 | 241790 |
2022-05-13 | Montague | Texas | 48337 | 4694 | 129 | 19818 | 6509 | 236855 |
2022-05-13 | Culberson | Texas | 48109 | 514 | 14 | 2171 | 6448 | 236757 |
2022-05-13 | Hutchinson | Texas | 48233 | 6755 | 135 | 20938 | 6447 | 322619 |
2022-05-13 | Cottle | Texas | 48101 | 319 | 9 | 1398 | 6437 | 228183 |
2022-05-13 | Runnels | Texas | 48399 | 2393 | 66 | 10264 | 6430 | 233144 |
2022-05-13 | Lynn | Texas | 48305 | 1556 | 38 | 5951 | 6385 | 261468 |
2022-05-13 | La Salle | Texas | 48283 | 2421 | 48 | 7520 | 6382 | 321941 |
2022-05-13 | Wood | Texas | 48499 | 8031 | 288 | 45539 | 6324 | 176354 |
2022-05-13 | Potter | Texas | 48375 | 35779 | 739 | 117415 | 6293 | 304722 |
2022-05-13 | Duval | Texas | 48131 | 3412 | 70 | 11157 | 6274 | 305816 |
2022-05-13 | Fisher | Texas | 48151 | 609 | 24 | 3830 | 6266 | 159007 |
2022-05-13 | Castro | Texas | 48069 | 2297 | 47 | 7530 | 6241 | 305046 |
2022-05-13 | Scurry | Texas | 48415 | 4983 | 104 | 16703 | 6226 | 298329 |
2022-05-13 | Val Verde | Texas | 48465 | 14368 | 303 | 49025 | 6180 | 293074 |
2022-05-13 | Eastland | Texas | 48133 | 2829 | 113 | 18360 | 6154 | 154084 |
2022-05-13 | Marion | Texas | 48315 | 1690 | 60 | 9854 | 6088 | 171503 |
2022-05-13 | Willacy | Texas | 48489 | 7089 | 130 | 21358 | 6086 | 331913 |
2022-05-13 | Carson | Texas | 48065 | 1532 | 36 | 5926 | 6074 | 258521 |
2022-05-13 | Deaf Smith | Texas | 48117 | 4809 | 111 | 18546 | 5985 | 259301 |
2022-05-13 | Lavaca | Texas | 48285 | 4271 | 120 | 20154 | 5954 | 211918 |
2022-05-13 | Loving | Texas | 48301 | 196 | 1 | 169 | 5917 | 1159763 |
2022-05-13 | Coke | Texas | 48081 | 843 | 20 | 3387 | 5904 | 248892 |
2022-05-13 | Morris | Texas | 48343 | 2529 | 73 | 12388 | 5892 | 204149 |
2022-05-13 | McCulloch | Texas | 48307 | 1308 | 47 | 7984 | 5886 | 163827 |
2022-05-13 | San Saba | Texas | 48411 | 1242 | 35 | 6055 | 5780 | 205119 |
2022-05-13 | Zavala | Texas | 48507 | 4059 | 68 | 11840 | 5743 | 342820 |
2022-05-13 | Mitchell | Texas | 48335 | 1864 | 49 | 8545 | 5734 | 218139 |
2022-05-13 | Camp | Texas | 48063 | 2873 | 75 | 13094 | 5727 | 219413 |
2022-05-13 | Comanche | Texas | 48093 | 3698 | 78 | 13635 | 5720 | 271213 |
2022-05-13 | Gray | Texas | 48179 | 6195 | 125 | 21886 | 5711 | 283057 |
2022-05-13 | Edwards | Texas | 48137 | 467 | 11 | 1932 | 5693 | 241718 |
2022-05-13 | Presidio | Texas | 48377 | 998 | 38 | 6704 | 5668 | 148866 |
2022-05-13 | Starr | Texas | 48427 | 20091 | 366 | 64633 | 5662 | 310847 |
2022-05-13 | Menard | Texas | 48327 | 513 | 12 | 2138 | 5612 | 239943 |
2022-05-13 | Red River | Texas | 48387 | 2304 | 67 | 12023 | 5572 | 191632 |
2022-05-13 | Bailey | Texas | 48017 | 1511 | 39 | 7000 | 5571 | 215857 |
2022-05-13 | Panola | Texas | 48365 | 4609 | 129 | 23194 | 5561 | 198715 |
2022-05-13 | Angelina | Texas | 48005 | 15501 | 481 | 86715 | 5546 | 178758 |
2022-05-13 | Gregg | Texas | 48183 | 23237 | 687 | 123945 | 5542 | 187478 |
2022-05-13 | Dallam | Texas | 48111 | 2155 | 40 | 7287 | 5489 | 295732 |
2022-05-13 | Crockett | Texas | 48105 | 1091 | 19 | 3464 | 5484 | 314953 |
2022-05-13 | Collingsworth | Texas | 48087 | 702 | 16 | 2920 | 5479 | 240410 |
2022-05-13 | Uvalde | Texas | 48463 | 10600 | 145 | 26741 | 5422 | 396395 |
2022-05-13 | Parmer | Texas | 48369 | 2363 | 52 | 9605 | 5413 | 246017 |
2022-05-13 | Hansford | Texas | 48195 | 1929 | 29 | 5399 | 5371 | 357288 |
2022-05-13 | Leon | Texas | 48289 | 3728 | 93 | 17404 | 5343 | 214203 |
2022-05-13 | San Augustine | Texas | 48405 | 1082 | 44 | 8237 | 5341 | 131358 |
2022-05-13 | Throckmorton | Texas | 48447 | 271 | 8 | 1501 | 5329 | 180546 |
2022-05-13 | Shelby | Texas | 48419 | 4491 | 134 | 25274 | 5301 | 177692 |
2022-05-13 | Moore | Texas | 48341 | 5604 | 111 | 20940 | 5300 | 267621 |
2022-05-13 | Sherman | Texas | 48421 | 499 | 16 | 3022 | 5294 | 165122 |
2022-05-13 | Limestone | Texas | 48293 | 5100 | 124 | 23437 | 5290 | 217604 |
2022-05-13 | Palo Pinto | Texas | 48363 | 7052 | 154 | 29189 | 5275 | 241597 |
2022-05-13 | Jasper | Texas | 48241 | 6102 | 187 | 35529 | 5263 | 171747 |
2022-05-13 | Taylor | Texas | 48441 | 35192 | 725 | 138034 | 5252 | 254951 |
2022-05-13 | Kent | Texas | 48263 | 210 | 4 | 762 | 5249 | 275590 |
2022-05-13 | Hill | Texas | 48217 | 8991 | 192 | 36649 | 5238 | 245327 |
2022-05-13 | Young | Texas | 48503 | 4002 | 94 | 18010 | 5219 | 222209 |
2022-05-13 | Stonewall | Texas | 48433 | 362 | 7 | 1350 | 5185 | 268148 |
2022-05-13 | Refugio | Texas | 48391 | 1781 | 36 | 6948 | 5181 | 256332 |
2022-05-13 | Briscoe | Texas | 48045 | 465 | 8 | 1546 | 5174 | 300776 |
2022-05-13 | Callahan | Texas | 48059 | 2920 | 72 | 13943 | 5163 | 209424 |
2022-05-13 | Fannin | Texas | 48147 | 6897 | 183 | 35514 | 5152 | 194205 |
2022-05-13 | Wharton | Texas | 48481 | 9175 | 214 | 41556 | 5149 | 220786 |
2022-05-13 | Jim Wells | Texas | 48249 | 11411 | 208 | 40482 | 5138 | 281878 |
2022-05-13 | Lamar | Texas | 48277 | 12500 | 256 | 49859 | 5134 | 250706 |
2022-05-13 | Wichita | Texas | 48485 | 34143 | 679 | 132230 | 5134 | 258209 |
2022-05-13 | Henderson | Texas | 48213 | 15410 | 424 | 82737 | 5124 | 186252 |
2022-05-13 | San Patricio | Texas | 48409 | 11104 | 341 | 66730 | 5110 | 166401 |
2022-05-13 | Dimmit | Texas | 48127 | 5760 | 51 | 10124 | 5037 | 568945 |
2022-05-13 | Howard | Texas | 48227 | 6876 | 184 | 36664 | 5018 | 187540 |
2022-05-13 | Crane | Texas | 48103 | 1285 | 24 | 4797 | 5003 | 267875 |
2022-05-13 | Kenedy | Texas | 48261 | 86 | 2 | 404 | 4950 | 212871 |
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;