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 374
- 48157 353
- 48201 352
- 48085 348
- 48113 347
- 48339 347
- 48439 347
- 48183 346
- 48027 344
- 48141 344
- 48167 344
- 48423 344
- 48453 344
- 48039 343
- 48209 343
- 48121 342
- 48037 341
- 48321 341
- 48041 340
- 48139 340
- 48303 340
- 48285 339
- 48309 339
- 48325 339
- 48401 339
- 48479 339
- 48485 339
- 48491 339
- 48061 338
- 48103 338
- …
county >30
- Bexar 374
- Fort Bend 353
- Harris 352
- Collin 348
- Dallas 347
- Montgomery 347
- Tarrant 347
- Gregg 346
- Bell 344
- El Paso 344
- Galveston 344
- Smith 344
- Travis 344
- Brazoria 343
- Hays 343
- Denton 342
- Bowie 341
- Matagorda 341
- Brazos 340
- Ellis 340
- Lubbock 340
- Lavaca 339
- McLennan 339
- Medina 339
- Rusk 339
- Webb 339
- Wichita 339
- Williamson 339
- Cameron 338
- Crane 338
- …
state 1
- Texas · 79,702 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1046388 | 1046388 | 2021-02-19 | Anderson | Texas | 48001 | 6018 | 103 |
1046389 | 1046389 | 2021-02-19 | Andrews | Texas | 48003 | 1679 | 45 |
1046390 | 1046390 | 2021-02-19 | Angelina | Texas | 48005 | 7656 | 243 |
1046391 | 1046391 | 2021-02-19 | Aransas | Texas | 48007 | 1107 | 33 |
1046392 | 1046392 | 2021-02-19 | Archer | Texas | 48009 | 760 | 11 |
1046393 | 1046393 | 2021-02-19 | Armstrong | Texas | 48011 | 148 | 6 |
1046394 | 1046394 | 2021-02-19 | Atascosa | Texas | 48013 | 5056 | 128 |
1046395 | 1046395 | 2021-02-19 | Austin | Texas | 48015 | 1775 | 27 |
1046396 | 1046396 | 2021-02-19 | Bailey | Texas | 48017 | 782 | 16 |
1046397 | 1046397 | 2021-02-19 | Bandera | Texas | 48019 | 1173 | 23 |
1046398 | 1046398 | 2021-02-19 | Bastrop | Texas | 48021 | 8300 | 75 |
1046399 | 1046399 | 2021-02-19 | Baylor | Texas | 48023 | 290 | 11 |
1046400 | 1046400 | 2021-02-19 | Bee | Texas | 48025 | 3398 | 61 |
1046401 | 1046401 | 2021-02-19 | Bell | Texas | 48027 | 20148 | 320 |
1046402 | 1046402 | 2021-02-19 | Bexar | Texas | 48029 | 187758 | 2713 |
1046403 | 1046403 | 2021-02-19 | Blanco | Texas | 48031 | 677 | 17 |
1046404 | 1046404 | 2021-02-19 | Borden | Texas | 48033 | 21 | 2 |
1046405 | 1046405 | 2021-02-19 | Bosque | Texas | 48035 | 1571 | 28 |
1046406 | 1046406 | 2021-02-19 | Bowie | Texas | 48037 | 6417 | 171 |
1046407 | 1046407 | 2021-02-19 | Brazoria | Texas | 48039 | 31331 | 353 |
1046408 | 1046408 | 2021-02-19 | Brazos | Texas | 48041 | 20054 | 202 |
1046409 | 1046409 | 2021-02-19 | Brewster | Texas | 48043 | 874 | 10 |
1046410 | 1046410 | 2021-02-19 | Briscoe | Texas | 48045 | 132 | 4 |
1046411 | 1046411 | 2021-02-19 | Brooks | Texas | 48047 | 744 | 32 |
1046412 | 1046412 | 2021-02-19 | Brown | Texas | 48049 | 4063 | 125 |
1046413 | 1046413 | 2021-02-19 | Burleson | Texas | 48051 | 2182 | 32 |
1046414 | 1046414 | 2021-02-19 | Burnet | Texas | 48053 | 4108 | 53 |
1046415 | 1046415 | 2021-02-19 | Caldwell | Texas | 48055 | 5107 | 74 |
1046416 | 1046416 | 2021-02-19 | Calhoun | Texas | 48057 | 1740 | 16 |
1046417 | 1046417 | 2021-02-19 | Callahan | Texas | 48059 | 1119 | 37 |
1046418 | 1046418 | 2021-02-19 | Cameron | Texas | 48061 | 36902 | 1415 |
1046419 | 1046419 | 2021-02-19 | Camp | Texas | 48063 | 1160 | 40 |
1046420 | 1046420 | 2021-02-19 | Carson | Texas | 48065 | 378 | 13 |
1046421 | 1046421 | 2021-02-19 | Cass | Texas | 48067 | 1754 | 74 |
1046422 | 1046422 | 2021-02-19 | Castro | Texas | 48069 | 897 | 28 |
1046423 | 1046423 | 2021-02-19 | Chambers | Texas | 48071 | 4119 | 36 |
1046424 | 1046424 | 2021-02-19 | Cherokee | Texas | 48073 | 4003 | 119 |
1046425 | 1046425 | 2021-02-19 | Childress | Texas | 48075 | 1324 | 15 |
1046426 | 1046426 | 2021-02-19 | Clay | Texas | 48077 | 988 | 16 |
1046427 | 1046427 | 2021-02-19 | Cochran | Texas | 48079 | 240 | 13 |
1046428 | 1046428 | 2021-02-19 | Coke | Texas | 48081 | 436 | 11 |
1046429 | 1046429 | 2021-02-19 | Coleman | Texas | 48083 | 702 | 27 |
1046430 | 1046430 | 2021-02-19 | Collin | Texas | 48085 | 81062 | 688 |
1046431 | 1046431 | 2021-02-19 | Collingsworth | Texas | 48087 | 258 | 9 |
1046432 | 1046432 | 2021-02-19 | Colorado | Texas | 48089 | 1507 | 24 |
1046433 | 1046433 | 2021-02-19 | Comal | Texas | 48091 | 8843 | 278 |
1046434 | 1046434 | 2021-02-19 | Comanche | Texas | 48093 | 1285 | 47 |
1046435 | 1046435 | 2021-02-19 | Concho | Texas | 48095 | 292 | 7 |
1046436 | 1046436 | 2021-02-19 | Cooke | Texas | 48097 | 3399 | 59 |
1046437 | 1046437 | 2021-02-19 | Coryell | Texas | 48099 | 6712 | 70 |
1046438 | 1046438 | 2021-02-19 | Cottle | Texas | 48101 | 182 | 7 |
1046439 | 1046439 | 2021-02-19 | Crane | Texas | 48103 | 505 | 11 |
1046440 | 1046440 | 2021-02-19 | Crockett | Texas | 48105 | 565 | 15 |
1046441 | 1046441 | 2021-02-19 | Crosby | Texas | 48107 | 499 | 25 |
1046442 | 1046442 | 2021-02-19 | Culberson | Texas | 48109 | 341 | 7 |
1046443 | 1046443 | 2021-02-19 | Dallam | Texas | 48111 | 567 | 22 |
1046444 | 1046444 | 2021-02-19 | Dallas | Texas | 48113 | 276339 | 3236 |
1046445 | 1046445 | 2021-02-19 | Dawson | Texas | 48115 | 1706 | 68 |
1046446 | 1046446 | 2021-02-19 | DeWitt | Texas | 48123 | 1843 | 56 |
1046447 | 1046447 | 2021-02-19 | Deaf Smith | Texas | 48117 | 2672 | 63 |
1046448 | 1046448 | 2021-02-19 | Delta | Texas | 48119 | 289 | 10 |
1046449 | 1046449 | 2021-02-19 | Denton | Texas | 48121 | 60167 | 597 |
1046450 | 1046450 | 2021-02-19 | Dickens | Texas | 48125 | 152 | 9 |
1046451 | 1046451 | 2021-02-19 | Dimmit | Texas | 48127 | 1436 | 19 |
1046452 | 1046452 | 2021-02-19 | Donley | Texas | 48129 | 343 | 13 |
1046453 | 1046453 | 2021-02-19 | Duval | Texas | 48131 | 1142 | 36 |
1046454 | 1046454 | 2021-02-19 | Eastland | Texas | 48133 | 1212 | 41 |
1046455 | 1046455 | 2021-02-19 | Ector | Texas | 48135 | 15616 | 316 |
1046456 | 1046456 | 2021-02-19 | Edwards | Texas | 48137 | 236 | 4 |
1046457 | 1046457 | 2021-02-19 | El Paso | Texas | 48141 | 120769 | 2281 |
1046458 | 1046458 | 2021-02-19 | Ellis | Texas | 48139 | 20331 | 267 |
1046459 | 1046459 | 2021-02-19 | Erath | Texas | 48143 | 3906 | 64 |
1046460 | 1046460 | 2021-02-19 | Falls | Texas | 48145 | 1996 | 28 |
1046461 | 1046461 | 2021-02-19 | Fannin | Texas | 48147 | 3133 | 95 |
1046462 | 1046462 | 2021-02-19 | Fayette | Texas | 48149 | 2229 | 50 |
1046463 | 1046463 | 2021-02-19 | Fisher | Texas | 48151 | 290 | 13 |
1046464 | 1046464 | 2021-02-19 | Floyd | Texas | 48153 | 749 | 29 |
1046465 | 1046465 | 2021-02-19 | Foard | Texas | 48155 | 117 | 8 |
1046466 | 1046466 | 2021-02-19 | Fort Bend | Texas | 48157 | 55548 | 534 |
1046467 | 1046467 | 2021-02-19 | Franklin | Texas | 48159 | 676 | 22 |
1046468 | 1046468 | 2021-02-19 | Freestone | Texas | 48161 | 1756 | 40 |
1046469 | 1046469 | 2021-02-19 | Frio | Texas | 48163 | 2576 | 38 |
1046470 | 1046470 | 2021-02-19 | Gaines | Texas | 48165 | 1411 | 39 |
1046471 | 1046471 | 2021-02-19 | Galveston | Texas | 48167 | 33525 | 327 |
1046472 | 1046472 | 2021-02-19 | Garza | Texas | 48169 | 351 | 19 |
1046473 | 1046473 | 2021-02-19 | Gillespie | Texas | 48171 | 2298 | 46 |
1046474 | 1046474 | 2021-02-19 | Glasscock | Texas | 48173 | 97 | 2 |
1046475 | 1046475 | 2021-02-19 | Goliad | Texas | 48175 | 405 | 13 |
1046476 | 1046476 | 2021-02-19 | Gonzales | Texas | 48177 | 2480 | 47 |
1046477 | 1046477 | 2021-02-19 | Gray | Texas | 48179 | 2043 | 50 |
1046478 | 1046478 | 2021-02-19 | Grayson | Texas | 48181 | 10613 | 297 |
1046479 | 1046479 | 2021-02-19 | Gregg | Texas | 48183 | 10561 | 292 |
1046480 | 1046480 | 2021-02-19 | Grimes | Texas | 48185 | 3363 | 60 |
1046481 | 1046481 | 2021-02-19 | Guadalupe | Texas | 48187 | 12571 | 180 |
1046482 | 1046482 | 2021-02-19 | Hale | Texas | 48189 | 6008 | 151 |
1046483 | 1046483 | 2021-02-19 | Hall | Texas | 48191 | 416 | 14 |
1046484 | 1046484 | 2021-02-19 | Hamilton | Texas | 48193 | 737 | 24 |
1046485 | 1046485 | 2021-02-19 | Hansford | Texas | 48195 | 789 | 19 |
1046486 | 1046486 | 2021-02-19 | Hardeman | Texas | 48197 | 362 | 12 |
1046487 | 1046487 | 2021-02-19 | Hardin | Texas | 48199 | 4766 | 89 |
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);