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 fips
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 | Harris | Texas | 48201 | 1032781 | 10972 | 4713325 | 2327 | 219119 |
2022-05-13 | Harrison | Texas | 48203 | 13370 | 227 | 66553 | 3410 | 200892 |
2022-05-13 | Hartley | Texas | 48205 | 1364 | 3 | 5576 | 538 | 244619 |
2022-05-13 | Haskell | Texas | 48207 | 897 | 39 | 5658 | 6892 | 158536 |
2022-05-13 | Hays | Texas | 48209 | 60893 | 498 | 230191 | 2163 | 264532 |
2022-05-13 | Hemphill | Texas | 48211 | 1239 | 7 | 3819 | 1832 | 324430 |
2022-05-13 | Henderson | Texas | 48213 | 15410 | 424 | 82737 | 5124 | 186252 |
2022-05-13 | Hidalgo | Texas | 48215 | 207289 | 3909 | 868707 | 4499 | 238617 |
2022-05-13 | Hill | Texas | 48217 | 8991 | 192 | 36649 | 5238 | 245327 |
2022-05-13 | Hockley | Texas | 48219 | 7750 | 161 | 23021 | 6993 | 336649 |
2022-05-13 | Hood | Texas | 48221 | 13472 | 274 | 61643 | 4444 | 218548 |
2022-05-13 | Hopkins | Texas | 48223 | 7264 | 180 | 37084 | 4853 | 195879 |
2022-05-13 | Houston | Texas | 48225 | 4253 | 111 | 22968 | 4832 | 185170 |
2022-05-13 | Howard | Texas | 48227 | 6876 | 184 | 36664 | 5018 | 187540 |
2022-05-13 | Hudspeth | Texas | 48229 | 989 | 18 | 4886 | 3683 | 202415 |
2022-05-13 | Hunt | Texas | 48231 | 15811 | 363 | 98594 | 3681 | 160364 |
2022-05-13 | Hutchinson | Texas | 48233 | 6755 | 135 | 20938 | 6447 | 322619 |
2022-05-13 | Irion | Texas | 48235 | 445 | 3 | 1536 | 1953 | 289713 |
2022-05-13 | Jack | Texas | 48237 | 1523 | 28 | 8935 | 3133 | 170453 |
2022-05-13 | Jackson | Texas | 48239 | 3258 | 59 | 14760 | 3997 | 220731 |
2022-05-13 | Jasper | Texas | 48241 | 6102 | 187 | 35529 | 5263 | 171747 |
2022-05-13 | Jeff Davis | Texas | 48243 | 224 | 9 | 2274 | 3957 | 98504 |
2022-05-13 | Jefferson | Texas | 48245 | 49316 | 843 | 251565 | 3351 | 196036 |
2022-05-13 | Jim Hogg | Texas | 48247 | 2648 | 22 | 5200 | 4230 | 509230 |
2022-05-13 | Jim Wells | Texas | 48249 | 11411 | 208 | 40482 | 5138 | 281878 |
2022-05-13 | Johnson | Texas | 48251 | 43903 | 735 | 175817 | 4180 | 249708 |
2022-05-13 | Jones | Texas | 48253 | 4643 | 93 | 20083 | 4630 | 231190 |
2022-05-13 | Karnes | Texas | 48255 | 5968 | 70 | 15601 | 4486 | 382539 |
2022-05-13 | Kaufman | Texas | 48257 | 35680 | 536 | 136154 | 3936 | 262056 |
2022-05-13 | Kendall | Texas | 48259 | 8263 | 119 | 47431 | 2508 | 174210 |
2022-05-13 | Kenedy | Texas | 48261 | 86 | 2 | 404 | 4950 | 212871 |
2022-05-13 | Kent | Texas | 48263 | 210 | 4 | 762 | 5249 | 275590 |
2022-05-13 | Kerr | Texas | 48265 | 9690 | 182 | 52600 | 3460 | 184220 |
2022-05-13 | Kimble | Texas | 48267 | 714 | 15 | 4337 | 3458 | 164629 |
2022-05-13 | King | Texas | 48269 | 51 | 0 | 272 | 0 | 187500 |
2022-05-13 | Kinney | Texas | 48271 | 741 | 11 | 3667 | 2999 | 202072 |
2022-05-13 | Kleberg | Texas | 48273 | 7304 | 147 | 30680 | 4791 | 238070 |
2022-05-13 | Knox | Texas | 48275 | 492 | 25 | 3664 | 6823 | 134279 |
2022-05-13 | Lamar | Texas | 48277 | 12500 | 256 | 49859 | 5134 | 250706 |
2022-05-13 | Lamb | Texas | 48279 | 4356 | 122 | 12893 | 9462 | 337857 |
2022-05-13 | Lampasas | Texas | 48281 | 5556 | 90 | 21428 | 4200 | 259286 |
2022-05-13 | La Salle | Texas | 48283 | 2421 | 48 | 7520 | 6382 | 321941 |
2022-05-13 | Lavaca | Texas | 48285 | 4271 | 120 | 20154 | 5954 | 211918 |
2022-05-13 | Lee | Texas | 48287 | 4278 | 60 | 17239 | 3480 | 248158 |
2022-05-13 | Leon | Texas | 48289 | 3728 | 93 | 17404 | 5343 | 214203 |
2022-05-13 | Liberty | Texas | 48291 | 18210 | 404 | 88219 | 4579 | 206418 |
2022-05-13 | Limestone | Texas | 48293 | 5100 | 124 | 23437 | 5290 | 217604 |
2022-05-13 | Lipscomb | Texas | 48295 | 720 | 16 | 3233 | 4948 | 222703 |
2022-05-13 | Live Oak | Texas | 48297 | 2153 | 42 | 12207 | 3440 | 176374 |
2022-05-13 | Llano | Texas | 48299 | 3933 | 97 | 21795 | 4450 | 180454 |
2022-05-13 | Loving | Texas | 48301 | 196 | 1 | 169 | 5917 | 1159763 |
2022-05-13 | Lubbock | Texas | 48303 | 93789 | 1329 | 310569 | 4279 | 301990 |
2022-05-13 | Lynn | Texas | 48305 | 1556 | 38 | 5951 | 6385 | 261468 |
2022-05-13 | McCulloch | Texas | 48307 | 1308 | 47 | 7984 | 5886 | 163827 |
2022-05-13 | McLennan | Texas | 48309 | 60473 | 902 | 256623 | 3514 | 235649 |
2022-05-13 | McMullen | Texas | 48311 | 169 | 9 | 743 | 12113 | 227456 |
2022-05-13 | Madison | Texas | 48313 | 3778 | 54 | 14284 | 3780 | 264491 |
2022-05-13 | Marion | Texas | 48315 | 1690 | 60 | 9854 | 6088 | 171503 |
2022-05-13 | Martin | Texas | 48317 | 1207 | 26 | 5771 | 4505 | 209149 |
2022-05-13 | Mason | Texas | 48319 | 787 | 12 | 4274 | 2807 | 184136 |
2022-05-13 | Matagorda | Texas | 48321 | 8374 | 175 | 36643 | 4775 | 228529 |
2022-05-13 | Maverick | Texas | 48323 | 20872 | 469 | 58722 | 7986 | 355437 |
2022-05-13 | Medina | Texas | 48325 | 10269 | 199 | 51584 | 3857 | 199073 |
2022-05-13 | Menard | Texas | 48327 | 513 | 12 | 2138 | 5612 | 239943 |
2022-05-13 | Midland | Texas | 48329 | 40910 | 496 | 176832 | 2804 | 231349 |
2022-05-13 | Milam | Texas | 48331 | 4950 | 102 | 24823 | 4109 | 199411 |
2022-05-13 | Mills | Texas | 48333 | 1475 | 37 | 4873 | 7592 | 302688 |
2022-05-13 | Mitchell | Texas | 48335 | 1864 | 49 | 8545 | 5734 | 218139 |
2022-05-13 | Montague | Texas | 48337 | 4694 | 129 | 19818 | 6509 | 236855 |
2022-05-13 | Montgomery | Texas | 48339 | 141687 | 1291 | 607391 | 2125 | 233271 |
2022-05-13 | Moore | Texas | 48341 | 5604 | 111 | 20940 | 5300 | 267621 |
2022-05-13 | Morris | Texas | 48343 | 2529 | 73 | 12388 | 5892 | 204149 |
2022-05-13 | Motley | Texas | 48345 | 286 | 13 | 1200 | 10833 | 238333 |
2022-05-13 | Nacogdoches | Texas | 48347 | 12413 | 258 | 65204 | 3956 | 190371 |
2022-05-13 | Navarro | Texas | 48349 | 12469 | 222 | 50113 | 4429 | 248817 |
2022-05-13 | Newton | Texas | 48351 | 1367 | 61 | 13595 | 4486 | 100551 |
2022-05-13 | Nolan | Texas | 48353 | 3065 | 99 | 14714 | 6728 | 208305 |
2022-05-13 | Nueces | Texas | 48355 | 93429 | 1494 | 362294 | 4123 | 257881 |
2022-05-13 | Ochiltree | Texas | 48357 | 2424 | 48 | 9836 | 4880 | 246441 |
2022-05-13 | Oldham | Texas | 48359 | 565 | 6 | 2112 | 2840 | 267518 |
2022-05-13 | Orange | Texas | 48361 | 14968 | 355 | 83396 | 4256 | 179481 |
2022-05-13 | Palo Pinto | Texas | 48363 | 7052 | 154 | 29189 | 5275 | 241597 |
2022-05-13 | Panola | Texas | 48365 | 4609 | 129 | 23194 | 5561 | 198715 |
2022-05-13 | Parker | Texas | 48367 | 34819 | 450 | 142878 | 3149 | 243697 |
2022-05-13 | Parmer | Texas | 48369 | 2363 | 52 | 9605 | 5413 | 246017 |
2022-05-13 | Pecos | Texas | 48371 | 2749 | 71 | 15823 | 4487 | 173734 |
2022-05-13 | Polk | Texas | 48373 | 7896 | 247 | 51353 | 4809 | 153759 |
2022-05-13 | Potter | Texas | 48375 | 35779 | 739 | 117415 | 6293 | 304722 |
2022-05-13 | Presidio | Texas | 48377 | 998 | 38 | 6704 | 5668 | 148866 |
2022-05-13 | Rains | Texas | 48379 | 1839 | 59 | 12514 | 4714 | 146955 |
2022-05-13 | Randall | Texas | 48381 | 38234 | 516 | 137713 | 3746 | 277635 |
2022-05-13 | Reagan | Texas | 48383 | 859 | 14 | 3849 | 3637 | 223174 |
2022-05-13 | Real | Texas | 48385 | 817 | 25 | 3452 | 7242 | 236674 |
2022-05-13 | Red River | Texas | 48387 | 2304 | 67 | 12023 | 5572 | 191632 |
2022-05-13 | Reeves | Texas | 48389 | 4636 | 74 | 15976 | 4631 | 290185 |
2022-05-13 | Refugio | Texas | 48391 | 1781 | 36 | 6948 | 5181 | 256332 |
2022-05-13 | Roberts | Texas | 48393 | 175 | 2 | 854 | 2341 | 204918 |
2022-05-13 | Robertson | Texas | 48395 | 4541 | 77 | 17074 | 4509 | 265959 |
2022-05-13 | Rockwall | Texas | 48397 | 26778 | 266 | 104915 | 2535 | 255235 |
2022-05-13 | Runnels | Texas | 48399 | 2393 | 66 | 10264 | 6430 | 233144 |
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;