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 340
- 48157 319
- 48201 318
- 48085 314
- 48439 314
- 48113 313
- 48339 313
- 48183 312
- 48423 311
- 48453 311
- 48027 310
- 48141 310
- 48167 310
- 48039 309
- 48209 309
- 48121 308
- 48037 307
- 48321 307
- 48041 306
- 48139 306
- 48303 306
- 48401 306
- 48479 306
- 48485 306
- 48491 306
- 48285 305
- 48309 305
- 48325 305
- 48467 305
- 48061 304
- …
county >30
- Bexar 340
- Fort Bend 319
- Harris 318
- Collin 314
- Tarrant 314
- Dallas 313
- Montgomery 313
- Gregg 312
- Smith 311
- Travis 311
- Bell 310
- El Paso 310
- Galveston 310
- Brazoria 309
- Hays 309
- Denton 308
- Bowie 307
- Matagorda 307
- Brazos 306
- Ellis 306
- Lubbock 306
- Rusk 306
- Webb 306
- Wichita 306
- Williamson 306
- Lavaca 305
- McLennan 305
- Medina 305
- Van Zandt 305
- Cameron 304
- …
state 1
- Texas · 71,140 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
939465 | 939465 | 2021-01-17 | Orange | Texas | 48361 | 5948 | 79 |
939466 | 939466 | 2021-01-17 | Palo Pinto | Texas | 48363 | 2298 | 48 |
939467 | 939467 | 2021-01-17 | Panola | Texas | 48365 | 1207 | 49 |
939468 | 939468 | 2021-01-17 | Parker | Texas | 48367 | 11314 | 114 |
939469 | 939469 | 2021-01-17 | Parmer | Texas | 48369 | 1112 | 32 |
939470 | 939470 | 2021-01-17 | Pecos | Texas | 48371 | 1379 | 26 |
939471 | 939471 | 2021-01-17 | Polk | Texas | 48373 | 2450 | 69 |
939472 | 939472 | 2021-01-17 | Potter | Texas | 48375 | 15947 | 333 |
939473 | 939473 | 2021-01-17 | Presidio | Texas | 48377 | 627 | 19 |
939474 | 939474 | 2021-01-17 | Rains | Texas | 48379 | 632 | 19 |
939475 | 939475 | 2021-01-17 | Randall | Texas | 48381 | 15104 | 224 |
939476 | 939476 | 2021-01-17 | Reagan | Texas | 48383 | 357 | 7 |
939477 | 939477 | 2021-01-17 | Real | Texas | 48385 | 263 | 12 |
939478 | 939478 | 2021-01-17 | Red River | Texas | 48387 | 541 | 31 |
939479 | 939479 | 2021-01-17 | Reeves | Texas | 48389 | 1518 | 33 |
939480 | 939480 | 2021-01-17 | Refugio | Texas | 48391 | 536 | 17 |
939481 | 939481 | 2021-01-17 | Roberts | Texas | 48393 | 48 | 1 |
939482 | 939482 | 2021-01-17 | Robertson | Texas | 48395 | 1069 | 24 |
939483 | 939483 | 2021-01-17 | Rockwall | Texas | 48397 | 8222 | 74 |
939484 | 939484 | 2021-01-17 | Runnels | Texas | 48399 | 1085 | 25 |
939485 | 939485 | 2021-01-17 | Rusk | Texas | 48401 | 2964 | 63 |
939486 | 939486 | 2021-01-17 | Sabine | Texas | 48403 | 446 | 25 |
939487 | 939487 | 2021-01-17 | San Augustine | Texas | 48405 | 489 | 26 |
939488 | 939488 | 2021-01-17 | San Jacinto | Texas | 48407 | 606 | 21 |
939489 | 939489 | 2021-01-17 | San Patricio | Texas | 48409 | 3450 | 111 |
939490 | 939490 | 2021-01-17 | San Saba | Texas | 48411 | 484 | 15 |
939491 | 939491 | 2021-01-17 | Schleicher | Texas | 48413 | 184 | 6 |
939492 | 939492 | 2021-01-17 | Scurry | Texas | 48415 | 2270 | 46 |
939493 | 939493 | 2021-01-17 | Shackelford | Texas | 48417 | 187 | 1 |
939494 | 939494 | 2021-01-17 | Shelby | Texas | 48419 | 1258 | 45 |
939495 | 939495 | 2021-01-17 | Sherman | Texas | 48421 | 117 | 11 |
939496 | 939496 | 2021-01-17 | Smith | Texas | 48423 | 15407 | 307 |
939497 | 939497 | 2021-01-17 | Somervell | Texas | 48425 | 883 | 8 |
939498 | 939498 | 2021-01-17 | Starr | Texas | 48427 | 7433 | 213 |
939499 | 939499 | 2021-01-17 | Stephens | Texas | 48429 | 632 | 19 |
939500 | 939500 | 2021-01-17 | Sterling | Texas | 48431 | 96 | 4 |
939501 | 939501 | 2021-01-17 | Stonewall | Texas | 48433 | 134 | 3 |
939502 | 939502 | 2021-01-17 | Sutton | Texas | 48435 | 398 | 6 |
939503 | 939503 | 2021-01-17 | Swisher | Texas | 48437 | 678 | 14 |
939504 | 939504 | 2021-01-17 | Tarrant | Texas | 48439 | 190886 | 1825 |
939505 | 939505 | 2021-01-17 | Taylor | Texas | 48441 | 13133 | 260 |
939506 | 939506 | 2021-01-17 | Terrell | Texas | 48443 | 72 | 1 |
939507 | 939507 | 2021-01-17 | Terry | Texas | 48445 | 1475 | 46 |
939508 | 939508 | 2021-01-17 | Throckmorton | Texas | 48447 | 56 | 3 |
939509 | 939509 | 2021-01-17 | Titus | Texas | 48449 | 3107 | 55 |
939510 | 939510 | 2021-01-17 | Tom Green | Texas | 48451 | 14743 | 201 |
939511 | 939511 | 2021-01-17 | Travis | Texas | 48453 | 60782 | 614 |
939512 | 939512 | 2021-01-17 | Trinity | Texas | 48455 | 488 | 12 |
939513 | 939513 | 2021-01-17 | Tyler | Texas | 48457 | 982 | 19 |
939514 | 939514 | 2021-01-17 | Upshur | Texas | 48459 | 2540 | 40 |
939515 | 939515 | 2021-01-17 | Upton | Texas | 48461 | 286 | 7 |
939516 | 939516 | 2021-01-17 | Uvalde | Texas | 48463 | 2590 | 47 |
939517 | 939517 | 2021-01-17 | Val Verde | Texas | 48465 | 6331 | 157 |
939518 | 939518 | 2021-01-17 | Van Zandt | Texas | 48467 | 3154 | 76 |
939519 | 939519 | 2021-01-17 | Victoria | Texas | 48469 | 6672 | 134 |
939520 | 939520 | 2021-01-17 | Walker | Texas | 48471 | 6900 | 93 |
939521 | 939521 | 2021-01-17 | Waller | Texas | 48473 | 2585 | 26 |
939522 | 939522 | 2021-01-17 | Ward | Texas | 48475 | 933 | 13 |
939523 | 939523 | 2021-01-17 | Washington | Texas | 48477 | 1665 | 69 |
939524 | 939524 | 2021-01-17 | Webb | Texas | 48479 | 34499 | 563 |
939525 | 939525 | 2021-01-17 | Wharton | Texas | 48481 | 2956 | 83 |
939526 | 939526 | 2021-01-17 | Wheeler | Texas | 48483 | 427 | 9 |
939527 | 939527 | 2021-01-17 | Wichita | Texas | 48485 | 13179 | 258 |
939528 | 939528 | 2021-01-17 | Wilbarger | Texas | 48487 | 1707 | 41 |
939529 | 939529 | 2021-01-17 | Willacy | Texas | 48489 | 1949 | 69 |
939530 | 939530 | 2021-01-17 | Williamson | Texas | 48491 | 29796 | 263 |
939531 | 939531 | 2021-01-17 | Wilson | Texas | 48493 | 2790 | 40 |
939532 | 939532 | 2021-01-17 | Winkler | Texas | 48495 | 634 | 15 |
939533 | 939533 | 2021-01-17 | Wise | Texas | 48497 | 5384 | 82 |
939534 | 939534 | 2021-01-17 | Wood | Texas | 48499 | 2553 | 85 |
939535 | 939535 | 2021-01-17 | Yoakum | Texas | 48501 | 801 | 23 |
939536 | 939536 | 2021-01-17 | Young | Texas | 48503 | 1685 | 32 |
939537 | 939537 | 2021-01-17 | Zapata | Texas | 48505 | 1335 | 20 |
939538 | 939538 | 2021-01-17 | Zavala | Texas | 48507 | 1233 | 28 |
936040 | 936040 | 2021-01-16 | Anderson | Texas | 48001 | 5536 | 74 |
936041 | 936041 | 2021-01-16 | Andrews | Texas | 48003 | 1606 | 36 |
936042 | 936042 | 2021-01-16 | Angelina | Texas | 48005 | 6552 | 190 |
936043 | 936043 | 2021-01-16 | Aransas | Texas | 48007 | 879 | 26 |
936044 | 936044 | 2021-01-16 | Archer | Texas | 48009 | 694 | 8 |
936045 | 936045 | 2021-01-16 | Armstrong | Texas | 48011 | 126 | 6 |
936046 | 936046 | 2021-01-16 | Atascosa | Texas | 48013 | 3781 | 85 |
936047 | 936047 | 2021-01-16 | Austin | Texas | 48015 | 1343 | 17 |
936048 | 936048 | 2021-01-16 | Bailey | Texas | 48017 | 741 | 14 |
936049 | 936049 | 2021-01-16 | Bandera | Texas | 48019 | 820 | 19 |
936050 | 936050 | 2021-01-16 | Bastrop | Texas | 48021 | 4349 | 55 |
936051 | 936051 | 2021-01-16 | Baylor | Texas | 48023 | 274 | 9 |
936052 | 936052 | 2021-01-16 | Bee | Texas | 48025 | 3032 | 53 |
936053 | 936053 | 2021-01-16 | Bell | Texas | 48027 | 16512 | 205 |
936054 | 936054 | 2021-01-16 | Bexar | Texas | 48029 | 146355 | 2008 |
936055 | 936055 | 2021-01-16 | Blanco | Texas | 48031 | 318 | 11 |
936056 | 936056 | 2021-01-16 | Borden | Texas | 48033 | 18 | 0 |
936057 | 936057 | 2021-01-16 | Bosque | Texas | 48035 | 982 | 20 |
936058 | 936058 | 2021-01-16 | Bowie | Texas | 48037 | 4779 | 138 |
936059 | 936059 | 2021-01-16 | Brazoria | Texas | 48039 | 25457 | 273 |
936060 | 936060 | 2021-01-16 | Brazos | Texas | 48041 | 16634 | 159 |
936061 | 936061 | 2021-01-16 | Brewster | Texas | 48043 | 927 | 8 |
936062 | 936062 | 2021-01-16 | Briscoe | Texas | 48045 | 113 | 3 |
936063 | 936063 | 2021-01-16 | Brooks | Texas | 48047 | 679 | 29 |
936064 | 936064 | 2021-01-16 | Brown | Texas | 48049 | 3382 | 93 |
936065 | 936065 | 2021-01-16 | Burleson | Texas | 48051 | 1092 | 21 |
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);