ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71,320 rows where state = "Texas" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
fips
- 48029 341
- 48157 320
- 48201 319
- 48085 315
- 48113 314
- 48339 314
- 48439 314
- 48183 313
- 48027 311
- 48141 311
- 48167 311
- 48423 311
- 48453 311
- 48039 310
- 48209 310
- 48121 309
- 48037 308
- 48321 308
- 48041 307
- 48139 307
- 48303 307
- 48285 306
- 48309 306
- 48325 306
- 48401 306
- 48479 306
- 48485 306
- 48491 306
- 48061 305
- 48103 305
- ...
county
- Bexar 341
- Fort Bend 320
- Harris 319
- Collin 315
- Dallas 314
- Montgomery 314
- Tarrant 314
- Gregg 313
- Bell 311
- El Paso 311
- Galveston 311
- Smith 311
- Travis 311
- Brazoria 310
- Hays 310
- Denton 309
- Bowie 308
- Matagorda 308
- Brazos 307
- Ellis 307
- Lubbock 307
- Lavaca 306
- McLennan 306
- Medina 306
- Rusk 306
- Webb 306
- Wichita 306
- Williamson 306
- Cameron 305
- Crane 305
- ...
state
- Texas · 71,320 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
939365 | 939365 | 2021-01-17 | Anderson | Texas | 48001 | 5575 | 74 |
939366 | 939366 | 2021-01-17 | Andrews | Texas | 48003 | 1606 | 36 |
939367 | 939367 | 2021-01-17 | Angelina | Texas | 48005 | 6552 | 191 |
939368 | 939368 | 2021-01-17 | Aransas | Texas | 48007 | 893 | 26 |
939369 | 939369 | 2021-01-17 | Archer | Texas | 48009 | 694 | 8 |
939370 | 939370 | 2021-01-17 | Armstrong | Texas | 48011 | 126 | 6 |
939371 | 939371 | 2021-01-17 | Atascosa | Texas | 48013 | 3781 | 87 |
939372 | 939372 | 2021-01-17 | Austin | Texas | 48015 | 1368 | 17 |
939373 | 939373 | 2021-01-17 | Bailey | Texas | 48017 | 741 | 14 |
939374 | 939374 | 2021-01-17 | Bandera | Texas | 48019 | 820 | 20 |
939375 | 939375 | 2021-01-17 | Bastrop | Texas | 48021 | 4361 | 55 |
939376 | 939376 | 2021-01-17 | Baylor | Texas | 48023 | 274 | 9 |
939377 | 939377 | 2021-01-17 | Bee | Texas | 48025 | 3060 | 53 |
939378 | 939378 | 2021-01-17 | Bell | Texas | 48027 | 16512 | 208 |
939379 | 939379 | 2021-01-17 | Bexar | Texas | 48029 | 148567 | 2019 |
939380 | 939380 | 2021-01-17 | Blanco | Texas | 48031 | 318 | 11 |
939381 | 939381 | 2021-01-17 | Borden | Texas | 48033 | 18 | 0 |
939382 | 939382 | 2021-01-17 | Bosque | Texas | 48035 | 984 | 20 |
939383 | 939383 | 2021-01-17 | Bowie | Texas | 48037 | 4779 | 138 |
939384 | 939384 | 2021-01-17 | Brazoria | Texas | 48039 | 25714 | 275 |
939385 | 939385 | 2021-01-17 | Brazos | Texas | 48041 | 16634 | 161 |
939386 | 939386 | 2021-01-17 | Brewster | Texas | 48043 | 939 | 8 |
939387 | 939387 | 2021-01-17 | Briscoe | Texas | 48045 | 113 | 3 |
939388 | 939388 | 2021-01-17 | Brooks | Texas | 48047 | 683 | 29 |
939389 | 939389 | 2021-01-17 | Brown | Texas | 48049 | 3382 | 93 |
939390 | 939390 | 2021-01-17 | Burleson | Texas | 48051 | 1092 | 22 |
939391 | 939391 | 2021-01-17 | Burnet | Texas | 48053 | 2193 | 34 |
939392 | 939392 | 2021-01-17 | Caldwell | Texas | 48055 | 2726 | 55 |
939393 | 939393 | 2021-01-17 | Calhoun | Texas | 48057 | 1361 | 12 |
939394 | 939394 | 2021-01-17 | Callahan | Texas | 48059 | 931 | 27 |
939395 | 939395 | 2021-01-17 | Cameron | Texas | 48061 | 32698 | 1225 |
939396 | 939396 | 2021-01-17 | Camp | Texas | 48063 | 961 | 32 |
939397 | 939397 | 2021-01-17 | Carson | Texas | 48065 | 330 | 11 |
939398 | 939398 | 2021-01-17 | Cass | Texas | 48067 | 1476 | 58 |
939399 | 939399 | 2021-01-17 | Castro | Texas | 48069 | 831 | 22 |
939400 | 939400 | 2021-01-17 | Chambers | Texas | 48071 | 3431 | 31 |
939401 | 939401 | 2021-01-17 | Cherokee | Texas | 48073 | 3491 | 88 |
939402 | 939402 | 2021-01-17 | Childress | Texas | 48075 | 1284 | 13 |
939403 | 939403 | 2021-01-17 | Clay | Texas | 48077 | 874 | 13 |
939404 | 939404 | 2021-01-17 | Cochran | Texas | 48079 | 215 | 12 |
939405 | 939405 | 2021-01-17 | Coke | Texas | 48081 | 426 | 10 |
939406 | 939406 | 2021-01-17 | Coleman | Texas | 48083 | 579 | 20 |
939407 | 939407 | 2021-01-17 | Collin | Texas | 48085 | 63239 | 472 |
939408 | 939408 | 2021-01-17 | Collingsworth | Texas | 48087 | 236 | 8 |
939409 | 939409 | 2021-01-17 | Colorado | Texas | 48089 | 1235 | 17 |
939410 | 939410 | 2021-01-17 | Comal | Texas | 48091 | 7314 | 220 |
939411 | 939411 | 2021-01-17 | Comanche | Texas | 48093 | 1118 | 36 |
939412 | 939412 | 2021-01-17 | Concho | Texas | 48095 | 245 | 4 |
939413 | 939413 | 2021-01-17 | Cooke | Texas | 48097 | 2806 | 45 |
939414 | 939414 | 2021-01-17 | Coryell | Texas | 48099 | 4313 | 42 |
939415 | 939415 | 2021-01-17 | Cottle | Texas | 48101 | 176 | 7 |
939416 | 939416 | 2021-01-17 | Crane | Texas | 48103 | 482 | 11 |
939417 | 939417 | 2021-01-17 | Crockett | Texas | 48105 | 468 | 13 |
939418 | 939418 | 2021-01-17 | Crosby | Texas | 48107 | 380 | 22 |
939419 | 939419 | 2021-01-17 | Culberson | Texas | 48109 | 293 | 4 |
939420 | 939420 | 2021-01-17 | Dallam | Texas | 48111 | 465 | 20 |
939421 | 939421 | 2021-01-17 | Dallas | Texas | 48113 | 234625 | 2425 |
939422 | 939422 | 2021-01-17 | Dawson | Texas | 48115 | 1575 | 59 |
939423 | 939423 | 2021-01-17 | DeWitt | Texas | 48123 | 1553 | 50 |
939424 | 939424 | 2021-01-17 | Deaf Smith | Texas | 48117 | 2512 | 60 |
939425 | 939425 | 2021-01-17 | Delta | Texas | 48119 | 208 | 5 |
939426 | 939426 | 2021-01-17 | Denton | Texas | 48121 | 46272 | 433 |
939427 | 939427 | 2021-01-17 | Dickens | Texas | 48125 | 135 | 7 |
939428 | 939428 | 2021-01-17 | Dimmit | Texas | 48127 | 904 | 13 |
939429 | 939429 | 2021-01-17 | Donley | Texas | 48129 | 281 | 7 |
939430 | 939430 | 2021-01-17 | Duval | Texas | 48131 | 1053 | 32 |
939431 | 939431 | 2021-01-17 | Eastland | Texas | 48133 | 972 | 23 |
939432 | 939432 | 2021-01-17 | Ector | Texas | 48135 | 12222 | 267 |
939433 | 939433 | 2021-01-17 | Edwards | Texas | 48137 | 207 | 3 |
939434 | 939434 | 2021-01-17 | El Paso | Texas | 48141 | 106677 | 1935 |
939435 | 939435 | 2021-01-17 | Ellis | Texas | 48139 | 16403 | 199 |
939436 | 939436 | 2021-01-17 | Erath | Texas | 48143 | 3470 | 42 |
939437 | 939437 | 2021-01-17 | Falls | Texas | 48145 | 1308 | 22 |
939438 | 939438 | 2021-01-17 | Fannin | Texas | 48147 | 2439 | 66 |
939439 | 939439 | 2021-01-17 | Fayette | Texas | 48149 | 1431 | 43 |
939440 | 939440 | 2021-01-17 | Fisher | Texas | 48151 | 266 | 10 |
939441 | 939441 | 2021-01-17 | Floyd | Texas | 48153 | 628 | 25 |
939442 | 939442 | 2021-01-17 | Foard | Texas | 48155 | 91 | 5 |
939443 | 939443 | 2021-01-17 | Fort Bend | Texas | 48157 | 43662 | 436 |
939444 | 939444 | 2021-01-17 | Franklin | Texas | 48159 | 558 | 15 |
939445 | 939445 | 2021-01-17 | Freestone | Texas | 48161 | 988 | 29 |
939446 | 939446 | 2021-01-17 | Frio | Texas | 48163 | 2148 | 23 |
939447 | 939447 | 2021-01-17 | Gaines | Texas | 48165 | 1302 | 36 |
939448 | 939448 | 2021-01-17 | Galveston | Texas | 48167 | 26898 | 248 |
939449 | 939449 | 2021-01-17 | Garza | Texas | 48169 | 277 | 18 |
939450 | 939450 | 2021-01-17 | Gillespie | Texas | 48171 | 1830 | 31 |
939451 | 939451 | 2021-01-17 | Glasscock | Texas | 48173 | 94 | 1 |
939452 | 939452 | 2021-01-17 | Goliad | Texas | 48175 | 299 | 9 |
939453 | 939453 | 2021-01-17 | Gonzales | Texas | 48177 | 1962 | 29 |
939454 | 939454 | 2021-01-17 | Gray | Texas | 48179 | 1748 | 40 |
939455 | 939455 | 2021-01-17 | Grayson | Texas | 48181 | 8766 | 220 |
939456 | 939456 | 2021-01-17 | Gregg | Texas | 48183 | 8451 | 217 |
939457 | 939457 | 2021-01-17 | Grimes | Texas | 48185 | 1960 | 51 |
939458 | 939458 | 2021-01-17 | Guadalupe | Texas | 48187 | 9123 | 126 |
939459 | 939459 | 2021-01-17 | Hale | Texas | 48189 | 5636 | 134 |
939460 | 939460 | 2021-01-17 | Hall | Texas | 48191 | 339 | 11 |
939461 | 939461 | 2021-01-17 | Hamilton | Texas | 48193 | 546 | 21 |
939462 | 939462 | 2021-01-17 | Hansford | Texas | 48195 | 671 | 17 |
939463 | 939463 | 2021-01-17 | Hardeman | Texas | 48197 | 319 | 9 |
939464 | 939464 | 2021-01-17 | Hardin | Texas | 48199 | 4080 | 68 |
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]);