ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82,750 rows where state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips
- 48029 386
- 48157 365
- 48201 364
- 48085 360
- 48113 359
- 48339 359
- 48439 359
- 48183 358
- 48027 356
- 48141 356
- 48167 356
- 48423 356
- 48453 356
- 48039 355
- 48209 355
- 48121 354
- 48037 353
- 48321 353
- 48041 352
- 48139 352
- 48303 352
- 48285 351
- 48309 351
- 48325 351
- 48401 351
- 48479 351
- 48485 351
- 48491 351
- 48061 350
- 48103 350
- ...
county
- Bexar 386
- Fort Bend 365
- Harris 364
- Collin 360
- Dallas 359
- Montgomery 359
- Tarrant 359
- Gregg 358
- Bell 356
- El Paso 356
- Galveston 356
- Smith 356
- Travis 356
- Brazoria 355
- Hays 355
- Denton 354
- Bowie 353
- Matagorda 353
- Brazos 352
- Ellis 352
- Lubbock 352
- Lavaca 351
- McLennan 351
- Medina 351
- Rusk 351
- Webb 351
- Wichita 351
- Williamson 351
- Cameron 350
- Crane 350
- ...
state
- Texas · 82,750 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 1085338 | 1085338 | 2021-03-03 | Anderson | Texas | 48001 | 6063 | 107 |
| 1085339 | 1085339 | 2021-03-03 | Andrews | Texas | 48003 | 1694 | 46 |
| 1085340 | 1085340 | 2021-03-03 | Angelina | Texas | 48005 | 7984 | 260 |
| 1085341 | 1085341 | 2021-03-03 | Aransas | Texas | 48007 | 1140 | 35 |
| 1085342 | 1085342 | 2021-03-03 | Archer | Texas | 48009 | 773 | 11 |
| 1085343 | 1085343 | 2021-03-03 | Armstrong | Texas | 48011 | 149 | 6 |
| 1085344 | 1085344 | 2021-03-03 | Atascosa | Texas | 48013 | 5395 | 139 |
| 1085345 | 1085345 | 2021-03-03 | Austin | Texas | 48015 | 1842 | 30 |
| 1085346 | 1085346 | 2021-03-03 | Bailey | Texas | 48017 | 793 | 17 |
| 1085347 | 1085347 | 2021-03-03 | Bandera | Texas | 48019 | 1272 | 24 |
| 1085348 | 1085348 | 2021-03-03 | Bastrop | Texas | 48021 | 8459 | 80 |
| 1085349 | 1085349 | 2021-03-03 | Baylor | Texas | 48023 | 291 | 11 |
| 1085350 | 1085350 | 2021-03-03 | Bee | Texas | 48025 | 3398 | 64 |
| 1085351 | 1085351 | 2021-03-03 | Bell | Texas | 48027 | 20668 | 377 |
| 1085352 | 1085352 | 2021-03-03 | Bexar | Texas | 48029 | 197267 | 2953 |
| 1085353 | 1085353 | 2021-03-03 | Blanco | Texas | 48031 | 684 | 18 |
| 1085354 | 1085354 | 2021-03-03 | Borden | Texas | 48033 | 21 | 2 |
| 1085355 | 1085355 | 2021-03-03 | Bosque | Texas | 48035 | 1597 | 31 |
| 1085356 | 1085356 | 2021-03-03 | Bowie | Texas | 48037 | 6582 | 183 |
| 1085357 | 1085357 | 2021-03-03 | Brazoria | Texas | 48039 | 33152 | 387 |
| 1085358 | 1085358 | 2021-03-03 | Brazos | Texas | 48041 | 21243 | 215 |
| 1085359 | 1085359 | 2021-03-03 | Brewster | Texas | 48043 | 890 | 11 |
| 1085360 | 1085360 | 2021-03-03 | Briscoe | Texas | 48045 | 137 | 4 |
| 1085361 | 1085361 | 2021-03-03 | Brooks | Texas | 48047 | 758 | 32 |
| 1085362 | 1085362 | 2021-03-03 | Brown | Texas | 48049 | 4125 | 129 |
| 1085363 | 1085363 | 2021-03-03 | Burleson | Texas | 48051 | 2211 | 36 |
| 1085364 | 1085364 | 2021-03-03 | Burnet | Texas | 48053 | 4239 | 59 |
| 1085365 | 1085365 | 2021-03-03 | Caldwell | Texas | 48055 | 5212 | 87 |
| 1085366 | 1085366 | 2021-03-03 | Calhoun | Texas | 48057 | 2029 | 20 |
| 1085367 | 1085367 | 2021-03-03 | Callahan | Texas | 48059 | 1145 | 38 |
| 1085368 | 1085368 | 2021-03-03 | Cameron | Texas | 48061 | 37518 | 1484 |
| 1085369 | 1085369 | 2021-03-03 | Camp | Texas | 48063 | 1186 | 41 |
| 1085370 | 1085370 | 2021-03-03 | Carson | Texas | 48065 | 397 | 14 |
| 1085371 | 1085371 | 2021-03-03 | Cass | Texas | 48067 | 1789 | 78 |
| 1085372 | 1085372 | 2021-03-03 | Castro | Texas | 48069 | 899 | 29 |
| 1085373 | 1085373 | 2021-03-03 | Chambers | Texas | 48071 | 4297 | 43 |
| 1085374 | 1085374 | 2021-03-03 | Cherokee | Texas | 48073 | 4036 | 123 |
| 1085375 | 1085375 | 2021-03-03 | Childress | Texas | 48075 | 1333 | 17 |
| 1085376 | 1085376 | 2021-03-03 | Clay | Texas | 48077 | 1001 | 16 |
| 1085377 | 1085377 | 2021-03-03 | Cochran | Texas | 48079 | 250 | 14 |
| 1085378 | 1085378 | 2021-03-03 | Coke | Texas | 48081 | 468 | 11 |
| 1085379 | 1085379 | 2021-03-03 | Coleman | Texas | 48083 | 709 | 30 |
| 1085380 | 1085380 | 2021-03-03 | Collin | Texas | 48085 | 83404 | 732 |
| 1085381 | 1085381 | 2021-03-03 | Collingsworth | Texas | 48087 | 259 | 9 |
| 1085382 | 1085382 | 2021-03-03 | Colorado | Texas | 48089 | 1548 | 25 |
| 1085383 | 1085383 | 2021-03-03 | Comal | Texas | 48091 | 9201 | 294 |
| 1085384 | 1085384 | 2021-03-03 | Comanche | Texas | 48093 | 1486 | 51 |
| 1085385 | 1085385 | 2021-03-03 | Concho | Texas | 48095 | 319 | 8 |
| 1085386 | 1085386 | 2021-03-03 | Cooke | Texas | 48097 | 3469 | 64 |
| 1085387 | 1085387 | 2021-03-03 | Coryell | Texas | 48099 | 6836 | 77 |
| 1085388 | 1085388 | 2021-03-03 | Cottle | Texas | 48101 | 186 | 7 |
| 1085389 | 1085389 | 2021-03-03 | Crane | Texas | 48103 | 512 | 12 |
| 1085390 | 1085390 | 2021-03-03 | Crockett | Texas | 48105 | 571 | 15 |
| 1085391 | 1085391 | 2021-03-03 | Crosby | Texas | 48107 | 518 | 28 |
| 1085392 | 1085392 | 2021-03-03 | Culberson | Texas | 48109 | 346 | 7 |
| 1085393 | 1085393 | 2021-03-03 | Dallam | Texas | 48111 | 751 | 22 |
| 1085394 | 1085394 | 2021-03-03 | Dallas | Texas | 48113 | 282399 | 3477 |
| 1085395 | 1085395 | 2021-03-03 | Dawson | Texas | 48115 | 1710 | 68 |
| 1085396 | 1085396 | 2021-03-03 | DeWitt | Texas | 48123 | 1856 | 57 |
| 1085397 | 1085397 | 2021-03-03 | Deaf Smith | Texas | 48117 | 2714 | 64 |
| 1085398 | 1085398 | 2021-03-03 | Delta | Texas | 48119 | 297 | 10 |
| 1085399 | 1085399 | 2021-03-03 | Denton | Texas | 48121 | 65821 | 654 |
| 1085400 | 1085400 | 2021-03-03 | Dickens | Texas | 48125 | 156 | 10 |
| 1085401 | 1085401 | 2021-03-03 | Dimmit | Texas | 48127 | 1533 | 22 |
| 1085402 | 1085402 | 2021-03-03 | Donley | Texas | 48129 | 346 | 14 |
| 1085403 | 1085403 | 2021-03-03 | Duval | Texas | 48131 | 1160 | 39 |
| 1085404 | 1085404 | 2021-03-03 | Eastland | Texas | 48133 | 1296 | 42 |
| 1085405 | 1085405 | 2021-03-03 | Ector | Texas | 48135 | 16373 | 336 |
| 1085406 | 1085406 | 2021-03-03 | Edwards | Texas | 48137 | 243 | 4 |
| 1085407 | 1085407 | 2021-03-03 | El Paso | Texas | 48141 | 124438 | 2366 |
| 1085408 | 1085408 | 2021-03-03 | Ellis | Texas | 48139 | 20936 | 280 |
| 1085409 | 1085409 | 2021-03-03 | Erath | Texas | 48143 | 3975 | 67 |
| 1085410 | 1085410 | 2021-03-03 | Falls | Texas | 48145 | 1993 | 29 |
| 1085411 | 1085411 | 2021-03-03 | Fannin | Texas | 48147 | 3224 | 101 |
| 1085412 | 1085412 | 2021-03-03 | Fayette | Texas | 48149 | 2285 | 53 |
| 1085413 | 1085413 | 2021-03-03 | Fisher | Texas | 48151 | 290 | 14 |
| 1085414 | 1085414 | 2021-03-03 | Floyd | Texas | 48153 | 765 | 29 |
| 1085415 | 1085415 | 2021-03-03 | Foard | Texas | 48155 | 119 | 8 |
| 1085416 | 1085416 | 2021-03-03 | Fort Bend | Texas | 48157 | 58663 | 569 |
| 1085417 | 1085417 | 2021-03-03 | Franklin | Texas | 48159 | 697 | 25 |
| 1085418 | 1085418 | 2021-03-03 | Freestone | Texas | 48161 | 1752 | 45 |
| 1085419 | 1085419 | 2021-03-03 | Frio | Texas | 48163 | 2665 | 42 |
| 1085420 | 1085420 | 2021-03-03 | Gaines | Texas | 48165 | 1412 | 41 |
| 1085421 | 1085421 | 2021-03-03 | Galveston | Texas | 48167 | 34896 | 347 |
| 1085422 | 1085422 | 2021-03-03 | Garza | Texas | 48169 | 369 | 20 |
| 1085423 | 1085423 | 2021-03-03 | Gillespie | Texas | 48171 | 2452 | 48 |
| 1085424 | 1085424 | 2021-03-03 | Glasscock | Texas | 48173 | 97 | 2 |
| 1085425 | 1085425 | 2021-03-03 | Goliad | Texas | 48175 | 438 | 13 |
| 1085426 | 1085426 | 2021-03-03 | Gonzales | Texas | 48177 | 2616 | 51 |
| 1085427 | 1085427 | 2021-03-03 | Gray | Texas | 48179 | 1992 | 53 |
| 1085428 | 1085428 | 2021-03-03 | Grayson | Texas | 48181 | 10850 | 316 |
| 1085429 | 1085429 | 2021-03-03 | Gregg | Texas | 48183 | 10710 | 313 |
| 1085430 | 1085430 | 2021-03-03 | Grimes | Texas | 48185 | 3439 | 62 |
| 1085431 | 1085431 | 2021-03-03 | Guadalupe | Texas | 48187 | 13423 | 191 |
| 1085432 | 1085432 | 2021-03-03 | Hale | Texas | 48189 | 6048 | 152 |
| 1085433 | 1085433 | 2021-03-03 | Hall | Texas | 48191 | 421 | 14 |
| 1085434 | 1085434 | 2021-03-03 | Hamilton | Texas | 48193 | 743 | 25 |
| 1085435 | 1085435 | 2021-03-03 | Hansford | Texas | 48195 | 816 | 21 |
| 1085436 | 1085436 | 2021-03-03 | Hardeman | Texas | 48197 | 366 | 12 |
| 1085437 | 1085437 | 2021-03-03 | Hardin | Texas | 48199 | 4885 | 95 |
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]);