ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193,519 rows where state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 48029 821
- 48157 800
- 48201 799
- 48085 795
- 48439 795
- 48113 794
- 48339 794
- 48183 793
- 48423 792
- 48453 792
- 48027 791
- 48141 791
- 48167 791
- 48039 790
- 48209 790
- 48121 789
- 48037 788
- 48321 788
- 48041 787
- 48139 787
- 48303 787
- 48401 787
- 48479 787
- 48485 787
- 48491 787
- 48285 786
- 48309 786
- 48325 786
- 48467 786
- 48061 785
- …
county >30
- Bexar 821
- Fort Bend 800
- Harris 799
- Collin 795
- Tarrant 795
- Dallas 794
- Montgomery 794
- Gregg 793
- Smith 792
- Travis 792
- Bell 791
- El Paso 791
- Galveston 791
- Brazoria 790
- Hays 790
- Denton 789
- Bowie 788
- Matagorda 788
- Brazos 787
- Ellis 787
- Lubbock 787
- Rusk 787
- Webb 787
- Wichita 787
- Williamson 787
- Lavaca 786
- McLennan 786
- Medina 786
- Van Zandt 786
- Cameron 785
- …
state 1
- Texas · 193,319 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502407 | 2502407 | 2022-05-13 | Runnels | Texas | 48399 | 2393 | 66 |
2502408 | 2502408 | 2022-05-13 | Rusk | Texas | 48401 | 10870 | 233 |
2502409 | 2502409 | 2022-05-13 | Sabine | Texas | 48403 | 1254 | 89 |
2502410 | 2502410 | 2022-05-13 | San Augustine | Texas | 48405 | 1082 | 44 |
2502411 | 2502411 | 2022-05-13 | San Jacinto | Texas | 48407 | 5611 | 102 |
2502412 | 2502412 | 2022-05-13 | San Patricio | Texas | 48409 | 11104 | 341 |
2502413 | 2502413 | 2022-05-13 | San Saba | Texas | 48411 | 1242 | 35 |
2502414 | 2502414 | 2022-05-13 | Schleicher | Texas | 48413 | 528 | 9 |
2502415 | 2502415 | 2022-05-13 | Scurry | Texas | 48415 | 4983 | 104 |
2502416 | 2502416 | 2022-05-13 | Shackelford | Texas | 48417 | 691 | 12 |
2502417 | 2502417 | 2022-05-13 | Shelby | Texas | 48419 | 4491 | 134 |
2502418 | 2502418 | 2022-05-13 | Sherman | Texas | 48421 | 499 | 16 |
2502419 | 2502419 | 2022-05-13 | Smith | Texas | 48423 | 45581 | 968 |
2502420 | 2502420 | 2022-05-13 | Somervell | Texas | 48425 | 2116 | 36 |
2502421 | 2502421 | 2022-05-13 | Starr | Texas | 48427 | 20091 | 366 |
2502422 | 2502422 | 2022-05-13 | Stephens | Texas | 48429 | 1846 | 46 |
2502423 | 2502423 | 2022-05-13 | Sterling | Texas | 48431 | 245 | 6 |
2502424 | 2502424 | 2022-05-13 | Stonewall | Texas | 48433 | 362 | 7 |
2502425 | 2502425 | 2022-05-13 | Sutton | Texas | 48435 | 848 | 12 |
2502426 | 2502426 | 2022-05-13 | Swisher | Texas | 48437 | 2288 | 34 |
2502427 | 2502427 | 2022-05-13 | Tarrant | Texas | 48439 | 569281 | 5925 |
2502428 | 2502428 | 2022-05-13 | Taylor | Texas | 48441 | 35192 | 725 |
2502429 | 2502429 | 2022-05-13 | Terrell | Texas | 48443 | 121 | 3 |
2502430 | 2502430 | 2022-05-13 | Terry | Texas | 48445 | 2790 | 84 |
2502431 | 2502431 | 2022-05-13 | Throckmorton | Texas | 48447 | 271 | 8 |
2502432 | 2502432 | 2022-05-13 | Titus | Texas | 48449 | 8673 | 128 |
2502433 | 2502433 | 2022-05-13 | Tom Green | Texas | 48451 | 41068 | 553 |
2502434 | 2502434 | 2022-05-13 | Travis | Texas | 48453 | 227227 | 1735 |
2502435 | 2502435 | 2022-05-13 | Trinity | Texas | 48455 | 2707 | 72 |
2502436 | 2502436 | 2022-05-13 | Tyler | Texas | 48457 | 3405 | 88 |
2502437 | 2502437 | 2022-05-13 | Upshur | Texas | 48459 | 7926 | 186 |
2502438 | 2502438 | 2022-05-13 | Upton | Texas | 48461 | 833 | 18 |
2502439 | 2502439 | 2022-05-13 | Uvalde | Texas | 48463 | 10600 | 145 |
2502440 | 2502440 | 2022-05-13 | Val Verde | Texas | 48465 | 14368 | 303 |
2502441 | 2502441 | 2022-05-13 | Van Zandt | Texas | 48467 | 10399 | 280 |
2502442 | 2502442 | 2022-05-13 | Victoria | Texas | 48469 | 18919 | 413 |
2502443 | 2502443 | 2022-05-13 | Walker | Texas | 48471 | 19223 | 212 |
2502444 | 2502444 | 2022-05-13 | Waller | Texas | 48473 | 9695 | 108 |
2502445 | 2502445 | 2022-05-13 | Ward | Texas | 48475 | 2830 | 44 |
2502446 | 2502446 | 2022-05-13 | Washington | Texas | 48477 | 9232 | 148 |
2502447 | 2502447 | 2022-05-13 | Webb | Texas | 48479 | 96110 | 1036 |
2502448 | 2502448 | 2022-05-13 | Wharton | Texas | 48481 | 9175 | 214 |
2502449 | 2502449 | 2022-05-13 | Wheeler | Texas | 48483 | 1193 | 23 |
2502450 | 2502450 | 2022-05-13 | Wichita | Texas | 48485 | 34143 | 679 |
2502451 | 2502451 | 2022-05-13 | Wilbarger | Texas | 48487 | 3486 | 87 |
2502452 | 2502452 | 2022-05-13 | Willacy | Texas | 48489 | 7089 | 130 |
2502453 | 2502453 | 2022-05-13 | Williamson | Texas | 48491 | 135522 | 935 |
2502454 | 2502454 | 2022-05-13 | Wilson | Texas | 48493 | 11032 | 157 |
2502455 | 2502455 | 2022-05-13 | Winkler | Texas | 48495 | 1846 | 34 |
2502456 | 2502456 | 2022-05-13 | Wise | Texas | 48497 | 17052 | 270 |
2502457 | 2502457 | 2022-05-13 | Wood | Texas | 48499 | 8031 | 288 |
2502458 | 2502458 | 2022-05-13 | Yoakum | Texas | 48501 | 1317 | 42 |
2502459 | 2502459 | 2022-05-13 | Young | Texas | 48503 | 4002 | 94 |
2502460 | 2502460 | 2022-05-13 | Zapata | Texas | 48505 | 3752 | 55 |
2502461 | 2502461 | 2022-05-13 | Zavala | Texas | 48507 | 4059 | 68 |
2498949 | 2498949 | 2022-05-12 | Anderson | Texas | 48001 | 9691 | 239 |
2498950 | 2498950 | 2022-05-12 | Andrews | Texas | 48003 | 3821 | 72 |
2498951 | 2498951 | 2022-05-12 | Angelina | Texas | 48005 | 15499 | 481 |
2498952 | 2498952 | 2022-05-12 | Aransas | Texas | 48007 | 4175 | 86 |
2498953 | 2498953 | 2022-05-12 | Archer | Texas | 48009 | 2212 | 28 |
2498954 | 2498954 | 2022-05-12 | Armstrong | Texas | 48011 | 555 | 9 |
2498955 | 2498955 | 2022-05-12 | Atascosa | Texas | 48013 | 13647 | 231 |
2498956 | 2498956 | 2022-05-12 | Austin | Texas | 48015 | 5815 | 73 |
2498957 | 2498957 | 2022-05-12 | Bailey | Texas | 48017 | 1511 | 39 |
2498958 | 2498958 | 2022-05-12 | Bandera | Texas | 48019 | 3635 | 77 |
2498959 | 2498959 | 2022-05-12 | Bastrop | Texas | 48021 | 21961 | 239 |
2498960 | 2498960 | 2022-05-12 | Baylor | Texas | 48023 | 818 | 32 |
2498961 | 2498961 | 2022-05-12 | Bee | Texas | 48025 | 8415 | 153 |
2498962 | 2498962 | 2022-05-12 | Bell | Texas | 48027 | 67271 | 900 |
2498963 | 2498963 | 2022-05-12 | Bexar | Texas | 48029 | 564722 | 6129 |
2498964 | 2498964 | 2022-05-12 | Blanco | Texas | 48031 | 2566 | 34 |
2498965 | 2498965 | 2022-05-12 | Borden | Texas | 48033 | 100 | 2 |
2498966 | 2498966 | 2022-05-12 | Bosque | Texas | 48035 | 4126 | 70 |
2498967 | 2498967 | 2022-05-12 | Bowie | Texas | 48037 | 20216 | 432 |
2498968 | 2498968 | 2022-05-12 | Brazoria | Texas | 48039 | 94188 | 983 |
2498969 | 2498969 | 2022-05-12 | Brazos | Texas | 48041 | 60845 | 412 |
2498970 | 2498970 | 2022-05-12 | Brewster | Texas | 48043 | 1076 | 29 |
2498971 | 2498971 | 2022-05-12 | Briscoe | Texas | 48045 | 465 | 8 |
2498972 | 2498972 | 2022-05-12 | Brooks | Texas | 48047 | 1642 | 52 |
2498973 | 2498973 | 2022-05-12 | Brown | Texas | 48049 | 12038 | 253 |
2498974 | 2498974 | 2022-05-12 | Burleson | Texas | 48051 | 5046 | 66 |
2498975 | 2498975 | 2022-05-12 | Burnet | Texas | 48053 | 11091 | 170 |
2498976 | 2498976 | 2022-05-12 | Caldwell | Texas | 48055 | 14331 | 176 |
2498977 | 2498977 | 2022-05-12 | Calhoun | Texas | 48057 | 5729 | 48 |
2498978 | 2498978 | 2022-05-12 | Callahan | Texas | 48059 | 2920 | 72 |
2498979 | 2498979 | 2022-05-12 | Cameron | Texas | 48061 | 104889 | 2032 |
2498980 | 2498980 | 2022-05-12 | Camp | Texas | 48063 | 2872 | 75 |
2498981 | 2498981 | 2022-05-12 | Carson | Texas | 48065 | 1531 | 36 |
2498982 | 2498982 | 2022-05-12 | Cass | Texas | 48067 | 7258 | 197 |
2498983 | 2498983 | 2022-05-12 | Castro | Texas | 48069 | 2297 | 47 |
2498984 | 2498984 | 2022-05-12 | Chambers | Texas | 48071 | 11706 | 112 |
2498985 | 2498985 | 2022-05-12 | Cherokee | Texas | 48073 | 7987 | 254 |
2498986 | 2498986 | 2022-05-12 | Childress | Texas | 48075 | 2638 | 33 |
2498987 | 2498987 | 2022-05-12 | Clay | Texas | 48077 | 2095 | 35 |
2498988 | 2498988 | 2022-05-12 | Cochran | Texas | 48079 | 891 | 23 |
2498989 | 2498989 | 2022-05-12 | Coke | Texas | 48081 | 843 | 20 |
2498990 | 2498990 | 2022-05-12 | Coleman | Texas | 48083 | 1645 | 71 |
2498991 | 2498991 | 2022-05-12 | Collin | Texas | 48085 | 215661 | 1507 |
2498992 | 2498992 | 2022-05-12 | Collingsworth | Texas | 48087 | 702 | 16 |
2498993 | 2498993 | 2022-05-12 | Colorado | Texas | 48089 | 3807 | 64 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);