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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, deaths_per_million, date (date)
state 1
- Texas · 254 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Anderson | Texas | 48001 | 9691 | 239 | 57735 | 4139 | 167853 |
2022-05-13 | Andrews | Texas | 48003 | 3822 | 72 | 18705 | 3849 | 204330 |
2022-05-13 | Angelina | Texas | 48005 | 15501 | 481 | 86715 | 5546 | 178758 |
2022-05-13 | Aransas | Texas | 48007 | 4177 | 86 | 23510 | 3658 | 177669 |
2022-05-13 | Archer | Texas | 48009 | 2213 | 28 | 8553 | 3273 | 258739 |
2022-05-13 | Armstrong | Texas | 48011 | 555 | 9 | 1887 | 4769 | 294117 |
2022-05-13 | Atascosa | Texas | 48013 | 13647 | 231 | 51153 | 4515 | 266787 |
2022-05-13 | Austin | Texas | 48015 | 5818 | 73 | 30032 | 2430 | 193726 |
2022-05-13 | Bailey | Texas | 48017 | 1511 | 39 | 7000 | 5571 | 215857 |
2022-05-13 | Bandera | Texas | 48019 | 3636 | 77 | 23112 | 3331 | 157320 |
2022-05-13 | Bastrop | Texas | 48021 | 21971 | 239 | 88723 | 2693 | 247635 |
2022-05-13 | Baylor | Texas | 48023 | 818 | 32 | 3509 | 9119 | 233114 |
2022-05-13 | Bee | Texas | 48025 | 8418 | 153 | 32565 | 4698 | 258498 |
2022-05-13 | Bell | Texas | 48027 | 67290 | 901 | 362924 | 2482 | 185410 |
2022-05-13 | Bexar | Texas | 48029 | 565111 | 6131 | 2003554 | 3060 | 282054 |
2022-05-13 | Blanco | Texas | 48031 | 2568 | 34 | 11931 | 2849 | 215237 |
2022-05-13 | Borden | Texas | 48033 | 100 | 2 | 654 | 3058 | 152905 |
2022-05-13 | Bosque | Texas | 48035 | 4130 | 70 | 18685 | 3746 | 221032 |
2022-05-13 | Bowie | Texas | 48037 | 20222 | 432 | 93245 | 4632 | 216869 |
2022-05-13 | Brazoria | Texas | 48039 | 94245 | 983 | 374264 | 2626 | 251814 |
2022-05-13 | Brazos | Texas | 48041 | 60873 | 413 | 229211 | 1801 | 265576 |
2022-05-13 | Brewster | Texas | 48043 | 1079 | 29 | 9203 | 3151 | 117244 |
2022-05-13 | Briscoe | Texas | 48045 | 465 | 8 | 1546 | 5174 | 300776 |
2022-05-13 | Brooks | Texas | 48047 | 1642 | 52 | 7093 | 7331 | 231495 |
2022-05-13 | Brown | Texas | 48049 | 12056 | 253 | 37864 | 6681 | 318402 |
2022-05-13 | Burleson | Texas | 48051 | 5048 | 66 | 18443 | 3578 | 273708 |
2022-05-13 | Burnet | Texas | 48053 | 11095 | 171 | 48155 | 3551 | 230401 |
2022-05-13 | Caldwell | Texas | 48055 | 14339 | 176 | 43664 | 4030 | 328394 |
2022-05-13 | Calhoun | Texas | 48057 | 5731 | 48 | 21290 | 2254 | 269187 |
2022-05-13 | Callahan | Texas | 48059 | 2920 | 72 | 13943 | 5163 | 209424 |
2022-05-13 | Cameron | Texas | 48061 | 105092 | 2032 | 423163 | 4801 | 248348 |
2022-05-13 | Camp | Texas | 48063 | 2873 | 75 | 13094 | 5727 | 219413 |
2022-05-13 | Carson | Texas | 48065 | 1532 | 36 | 5926 | 6074 | 258521 |
2022-05-13 | Cass | Texas | 48067 | 7260 | 197 | 30026 | 6560 | 241790 |
2022-05-13 | Castro | Texas | 48069 | 2297 | 47 | 7530 | 6241 | 305046 |
2022-05-13 | Chambers | Texas | 48071 | 11706 | 112 | 43837 | 2554 | 267034 |
2022-05-13 | Cherokee | Texas | 48073 | 7989 | 254 | 52646 | 4824 | 151749 |
2022-05-13 | Childress | Texas | 48075 | 2638 | 33 | 7306 | 4516 | 361073 |
2022-05-13 | Clay | Texas | 48077 | 2096 | 35 | 10471 | 3342 | 200171 |
2022-05-13 | Cochran | Texas | 48079 | 891 | 23 | 2853 | 8061 | 312302 |
2022-05-13 | Coke | Texas | 48081 | 843 | 20 | 3387 | 5904 | 248892 |
2022-05-13 | Coleman | Texas | 48083 | 1646 | 71 | 8175 | 8685 | 201345 |
2022-05-13 | Collin | Texas | 48085 | 215831 | 1507 | 1034730 | 1456 | 208586 |
2022-05-13 | Collingsworth | Texas | 48087 | 702 | 16 | 2920 | 5479 | 240410 |
2022-05-13 | Colorado | Texas | 48089 | 3808 | 64 | 21493 | 2977 | 177173 |
2022-05-13 | Comal | Texas | 48091 | 34812 | 551 | 156209 | 3527 | 222855 |
2022-05-13 | Comanche | Texas | 48093 | 3698 | 78 | 13635 | 5720 | 271213 |
2022-05-13 | Concho | Texas | 48095 | 1084 | 11 | 2726 | 4035 | 397652 |
2022-05-13 | Cooke | Texas | 48097 | 7409 | 134 | 41257 | 3247 | 179581 |
2022-05-13 | Coryell | Texas | 48099 | 17626 | 211 | 75951 | 2778 | 232070 |
2022-05-13 | Cottle | Texas | 48101 | 319 | 9 | 1398 | 6437 | 228183 |
2022-05-13 | Crane | Texas | 48103 | 1285 | 24 | 4797 | 5003 | 267875 |
2022-05-13 | Crockett | Texas | 48105 | 1091 | 19 | 3464 | 5484 | 314953 |
2022-05-13 | Crosby | Texas | 48107 | 1894 | 45 | 5737 | 7843 | 330137 |
2022-05-13 | Culberson | Texas | 48109 | 514 | 14 | 2171 | 6448 | 236757 |
2022-05-13 | Dallam | Texas | 48111 | 2155 | 40 | 7287 | 5489 | 295732 |
2022-05-13 | Dallas | Texas | 48113 | 573644 | 6772 | 2635516 | 2569 | 217659 |
2022-05-13 | Dawson | Texas | 48115 | 2998 | 94 | 12728 | 7385 | 235543 |
2022-05-13 | DeWitt | Texas | 48123 | 6486 | 99 | 20160 | 4910 | 321726 |
2022-05-13 | Deaf Smith | Texas | 48117 | 4809 | 111 | 18546 | 5985 | 259301 |
2022-05-13 | Delta | Texas | 48119 | 1820 | 25 | 5331 | 4689 | 341399 |
2022-05-13 | Denton | Texas | 48121 | 181158 | 1354 | 887207 | 1526 | 204189 |
2022-05-13 | Dickens | Texas | 48125 | 453 | 16 | 2211 | 7236 | 204884 |
2022-05-13 | Dimmit | Texas | 48127 | 5760 | 51 | 10124 | 5037 | 568945 |
2022-05-13 | Donley | Texas | 48129 | 1153 | 26 | 3278 | 7931 | 351738 |
2022-05-13 | Duval | Texas | 48131 | 3412 | 70 | 11157 | 6274 | 305816 |
2022-05-13 | Eastland | Texas | 48133 | 2829 | 113 | 18360 | 6154 | 154084 |
2022-05-13 | Ector | Texas | 48135 | 37544 | 703 | 166223 | 4229 | 225865 |
2022-05-13 | Edwards | Texas | 48137 | 467 | 11 | 1932 | 5693 | 241718 |
2022-05-13 | El Paso | Texas | 48141 | 208635 | 3734 | 839238 | 4449 | 248600 |
2022-05-13 | Ellis | Texas | 48139 | 49172 | 582 | 184826 | 3148 | 266044 |
2022-05-13 | Erath | Texas | 48143 | 8790 | 123 | 42698 | 2880 | 205864 |
2022-05-13 | Falls | Texas | 48145 | 3797 | 65 | 17297 | 3757 | 219517 |
2022-05-13 | Fannin | Texas | 48147 | 6897 | 183 | 35514 | 5152 | 194205 |
2022-05-13 | Fayette | Texas | 48149 | 4796 | 105 | 25346 | 4142 | 189221 |
2022-05-13 | Fisher | Texas | 48151 | 609 | 24 | 3830 | 6266 | 159007 |
2022-05-13 | Floyd | Texas | 48153 | 1961 | 48 | 5712 | 8403 | 343312 |
2022-05-13 | Foard | Texas | 48155 | 209 | 11 | 1155 | 9523 | 180952 |
2022-05-13 | Fort Bend | Texas | 48157 | 189442 | 1260 | 811688 | 1552 | 233392 |
2022-05-13 | Franklin | Texas | 48159 | 2228 | 42 | 10725 | 3916 | 207738 |
2022-05-13 | Freestone | Texas | 48161 | 3880 | 82 | 19717 | 4158 | 196784 |
2022-05-13 | Frio | Texas | 48163 | 5935 | 93 | 20306 | 4579 | 292278 |
2022-05-13 | Gaines | Texas | 48165 | 2215 | 83 | 21492 | 3861 | 103061 |
2022-05-13 | Galveston | Texas | 48167 | 96616 | 853 | 342139 | 2493 | 282388 |
2022-05-13 | Garza | Texas | 48169 | 1279 | 28 | 6229 | 4495 | 205329 |
2022-05-13 | Gillespie | Texas | 48171 | 5426 | 109 | 26988 | 4038 | 201052 |
2022-05-13 | Glasscock | Texas | 48173 | 199 | 3 | 1409 | 2129 | 141234 |
2022-05-13 | Goliad | Texas | 48175 | 1216 | 32 | 7658 | 4178 | 158788 |
2022-05-13 | Gonzales | Texas | 48177 | 4736 | 99 | 20837 | 4751 | 227287 |
2022-05-13 | Gray | Texas | 48179 | 6195 | 125 | 21886 | 5711 | 283057 |
2022-05-13 | Grayson | Texas | 48181 | 27166 | 636 | 136212 | 4669 | 199439 |
2022-05-13 | Gregg | Texas | 48183 | 23237 | 687 | 123945 | 5542 | 187478 |
2022-05-13 | Grimes | Texas | 48185 | 8511 | 120 | 28880 | 4155 | 294702 |
2022-05-13 | Guadalupe | Texas | 48187 | 38361 | 398 | 166847 | 2385 | 229917 |
2022-05-13 | Hale | Texas | 48189 | 6571 | 245 | 33406 | 7334 | 196701 |
2022-05-13 | Hall | Texas | 48191 | 1102 | 24 | 2964 | 8097 | 371794 |
2022-05-13 | Hamilton | Texas | 48193 | 1972 | 33 | 8461 | 3900 | 233069 |
2022-05-13 | Hansford | Texas | 48195 | 1929 | 29 | 5399 | 5371 | 357288 |
2022-05-13 | Hardeman | Texas | 48197 | 556 | 19 | 3933 | 4830 | 141367 |
2022-05-13 | Hardin | Texas | 48199 | 12078 | 251 | 57602 | 4357 | 209680 |
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;