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_per_million
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Texas · 254 ✖
date (date) 1 ✖
- 2022-05-13 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 | Hartley | Texas | 48205 | 1364 | 3 | 5576 | 538 | 244619 |
2022-05-13 | Travis | Texas | 48453 | 227227 | 1735 | 1273954 | 1361 | 178363 |
2022-05-13 | Collin | Texas | 48085 | 215831 | 1507 | 1034730 | 1456 | 208586 |
2022-05-13 | Denton | Texas | 48121 | 181158 | 1354 | 887207 | 1526 | 204189 |
2022-05-13 | Fort Bend | Texas | 48157 | 189442 | 1260 | 811688 | 1552 | 233392 |
2022-05-13 | Williamson | Texas | 48491 | 135522 | 935 | 590551 | 1583 | 229483 |
2022-05-13 | Brazos | Texas | 48041 | 60873 | 413 | 229211 | 1801 | 265576 |
2022-05-13 | Hemphill | Texas | 48211 | 1239 | 7 | 3819 | 1832 | 324430 |
2022-05-13 | Irion | Texas | 48235 | 445 | 3 | 1536 | 1953 | 289713 |
2022-05-13 | Waller | Texas | 48473 | 9695 | 108 | 55246 | 1954 | 175487 |
2022-05-13 | Montgomery | Texas | 48339 | 141687 | 1291 | 607391 | 2125 | 233271 |
2022-05-13 | Glasscock | Texas | 48173 | 199 | 3 | 1409 | 2129 | 141234 |
2022-05-13 | Hays | Texas | 48209 | 60893 | 498 | 230191 | 2163 | 264532 |
2022-05-13 | Calhoun | Texas | 48057 | 5731 | 48 | 21290 | 2254 | 269187 |
2022-05-13 | Harris | Texas | 48201 | 1032781 | 10972 | 4713325 | 2327 | 219119 |
2022-05-13 | Roberts | Texas | 48393 | 175 | 2 | 854 | 2341 | 204918 |
2022-05-13 | Guadalupe | Texas | 48187 | 38361 | 398 | 166847 | 2385 | 229917 |
2022-05-13 | Austin | Texas | 48015 | 5818 | 73 | 30032 | 2430 | 193726 |
2022-05-13 | Bell | Texas | 48027 | 67290 | 901 | 362924 | 2482 | 185410 |
2022-05-13 | Galveston | Texas | 48167 | 96616 | 853 | 342139 | 2493 | 282388 |
2022-05-13 | Kendall | Texas | 48259 | 8263 | 119 | 47431 | 2508 | 174210 |
2022-05-13 | Rockwall | Texas | 48397 | 26778 | 266 | 104915 | 2535 | 255235 |
2022-05-13 | Chambers | Texas | 48071 | 11706 | 112 | 43837 | 2554 | 267034 |
2022-05-13 | Dallas | Texas | 48113 | 573644 | 6772 | 2635516 | 2569 | 217659 |
2022-05-13 | Brazoria | Texas | 48039 | 94245 | 983 | 374264 | 2626 | 251814 |
2022-05-13 | Bastrop | Texas | 48021 | 21971 | 239 | 88723 | 2693 | 247635 |
2022-05-13 | Coryell | Texas | 48099 | 17626 | 211 | 75951 | 2778 | 232070 |
2022-05-13 | Midland | Texas | 48329 | 40910 | 496 | 176832 | 2804 | 231349 |
2022-05-13 | Mason | Texas | 48319 | 787 | 12 | 4274 | 2807 | 184136 |
2022-05-13 | Tarrant | Texas | 48439 | 569281 | 5925 | 2102515 | 2818 | 270761 |
2022-05-13 | Oldham | Texas | 48359 | 565 | 6 | 2112 | 2840 | 267518 |
2022-05-13 | Blanco | Texas | 48031 | 2568 | 34 | 11931 | 2849 | 215237 |
2022-05-13 | Erath | Texas | 48143 | 8790 | 123 | 42698 | 2880 | 205864 |
2022-05-13 | Walker | Texas | 48471 | 19223 | 212 | 72971 | 2905 | 263433 |
2022-05-13 | Colorado | Texas | 48089 | 3808 | 64 | 21493 | 2977 | 177173 |
2022-05-13 | Kinney | Texas | 48271 | 741 | 11 | 3667 | 2999 | 202072 |
2022-05-13 | Borden | Texas | 48033 | 100 | 2 | 654 | 3058 | 152905 |
2022-05-13 | Bexar | Texas | 48029 | 565111 | 6131 | 2003554 | 3060 | 282054 |
2022-05-13 | Wilson | Texas | 48493 | 11032 | 157 | 51070 | 3074 | 216017 |
2022-05-13 | Jack | Texas | 48237 | 1523 | 28 | 8935 | 3133 | 170453 |
2022-05-13 | Ellis | Texas | 48139 | 49172 | 582 | 184826 | 3148 | 266044 |
2022-05-13 | Parker | Texas | 48367 | 34819 | 450 | 142878 | 3149 | 243697 |
2022-05-13 | Brewster | Texas | 48043 | 1079 | 29 | 9203 | 3151 | 117244 |
2022-05-13 | Sutton | Texas | 48435 | 848 | 12 | 3776 | 3177 | 224576 |
2022-05-13 | Schleicher | Texas | 48413 | 528 | 9 | 2793 | 3222 | 189044 |
2022-05-13 | Cooke | Texas | 48097 | 7409 | 134 | 41257 | 3247 | 179581 |
2022-05-13 | Archer | Texas | 48009 | 2213 | 28 | 8553 | 3273 | 258739 |
2022-05-13 | Bandera | Texas | 48019 | 3636 | 77 | 23112 | 3331 | 157320 |
2022-05-13 | Clay | Texas | 48077 | 2096 | 35 | 10471 | 3342 | 200171 |
2022-05-13 | Jefferson | Texas | 48245 | 49316 | 843 | 251565 | 3351 | 196036 |
2022-05-13 | Harrison | Texas | 48203 | 13370 | 227 | 66553 | 3410 | 200892 |
2022-05-13 | Live Oak | Texas | 48297 | 2153 | 42 | 12207 | 3440 | 176374 |
2022-05-13 | Kimble | Texas | 48267 | 714 | 15 | 4337 | 3458 | 164629 |
2022-05-13 | Kerr | Texas | 48265 | 9690 | 182 | 52600 | 3460 | 184220 |
2022-05-13 | Lee | Texas | 48287 | 4278 | 60 | 17239 | 3480 | 248158 |
2022-05-13 | McLennan | Texas | 48309 | 60473 | 902 | 256623 | 3514 | 235649 |
2022-05-13 | Comal | Texas | 48091 | 34812 | 551 | 156209 | 3527 | 222855 |
2022-05-13 | San Jacinto | Texas | 48407 | 5611 | 102 | 28859 | 3534 | 194428 |
2022-05-13 | Burnet | Texas | 48053 | 11095 | 171 | 48155 | 3551 | 230401 |
2022-05-13 | Burleson | Texas | 48051 | 5048 | 66 | 18443 | 3578 | 273708 |
2022-05-13 | Reagan | Texas | 48383 | 859 | 14 | 3849 | 3637 | 223174 |
2022-05-13 | Aransas | Texas | 48007 | 4177 | 86 | 23510 | 3658 | 177669 |
2022-05-13 | Ward | Texas | 48475 | 2830 | 44 | 11998 | 3667 | 235872 |
2022-05-13 | Shackelford | Texas | 48417 | 691 | 12 | 3265 | 3675 | 211638 |
2022-05-13 | Hunt | Texas | 48231 | 15811 | 363 | 98594 | 3681 | 160364 |
2022-05-13 | Hudspeth | Texas | 48229 | 989 | 18 | 4886 | 3683 | 202415 |
2022-05-13 | Webb | Texas | 48479 | 96110 | 1036 | 276652 | 3744 | 347403 |
2022-05-13 | Bosque | Texas | 48035 | 4130 | 70 | 18685 | 3746 | 221032 |
2022-05-13 | Randall | Texas | 48381 | 38234 | 516 | 137713 | 3746 | 277635 |
2022-05-13 | Falls | Texas | 48145 | 3797 | 65 | 17297 | 3757 | 219517 |
2022-05-13 | Madison | Texas | 48313 | 3778 | 54 | 14284 | 3780 | 264491 |
2022-05-13 | Andrews | Texas | 48003 | 3822 | 72 | 18705 | 3849 | 204330 |
2022-05-13 | Medina | Texas | 48325 | 10269 | 199 | 51584 | 3857 | 199073 |
2022-05-13 | Wise | Texas | 48497 | 17052 | 270 | 69984 | 3858 | 243655 |
2022-05-13 | Gaines | Texas | 48165 | 2215 | 83 | 21492 | 3861 | 103061 |
2022-05-13 | Terrell | Texas | 48443 | 121 | 3 | 776 | 3865 | 155927 |
2022-05-13 | Zapata | Texas | 48505 | 3752 | 55 | 14179 | 3878 | 264616 |
2022-05-13 | Hamilton | Texas | 48193 | 1972 | 33 | 8461 | 3900 | 233069 |
2022-05-13 | Titus | Texas | 48449 | 8673 | 128 | 32750 | 3908 | 264824 |
2022-05-13 | Franklin | Texas | 48159 | 2228 | 42 | 10725 | 3916 | 207738 |
2022-05-13 | Kaufman | Texas | 48257 | 35680 | 536 | 136154 | 3936 | 262056 |
2022-05-13 | Somervell | Texas | 48425 | 2116 | 36 | 9128 | 3943 | 231814 |
2022-05-13 | Nacogdoches | Texas | 48347 | 12413 | 258 | 65204 | 3956 | 190371 |
2022-05-13 | Jeff Davis | Texas | 48243 | 224 | 9 | 2274 | 3957 | 98504 |
2022-05-13 | Jackson | Texas | 48239 | 3258 | 59 | 14760 | 3997 | 220731 |
2022-05-13 | Caldwell | Texas | 48055 | 14339 | 176 | 43664 | 4030 | 328394 |
2022-05-13 | Concho | Texas | 48095 | 1084 | 11 | 2726 | 4035 | 397652 |
2022-05-13 | Gillespie | Texas | 48171 | 5426 | 109 | 26988 | 4038 | 201052 |
2022-05-13 | Tyler | Texas | 48457 | 3405 | 88 | 21672 | 4060 | 157115 |
2022-05-13 | Milam | Texas | 48331 | 4950 | 102 | 24823 | 4109 | 199411 |
2022-05-13 | Nueces | Texas | 48355 | 93429 | 1494 | 362294 | 4123 | 257881 |
2022-05-13 | Washington | Texas | 48477 | 9232 | 148 | 35882 | 4124 | 257287 |
2022-05-13 | Anderson | Texas | 48001 | 9691 | 239 | 57735 | 4139 | 167853 |
2022-05-13 | Fayette | Texas | 48149 | 4796 | 105 | 25346 | 4142 | 189221 |
2022-05-13 | Grimes | Texas | 48185 | 8511 | 120 | 28880 | 4155 | 294702 |
2022-05-13 | Freestone | Texas | 48161 | 3880 | 82 | 19717 | 4158 | 196784 |
2022-05-13 | Smith | Texas | 48423 | 45581 | 968 | 232751 | 4158 | 195835 |
2022-05-13 | Goliad | Texas | 48175 | 1216 | 32 | 7658 | 4178 | 158788 |
2022-05-13 | Johnson | Texas | 48251 | 43903 | 735 | 175817 | 4180 | 249708 |
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;