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 255
- 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
- 48103 304
- 48123 304
- 48251 304
- 48459 304
- 48049 303
- 48067 303
- 48147 303
- 48219 303
- 48375 303
- 48021 302
- 48069 302
- 48117 302
- 48329 302
- 48359 302
- 48343 300
- 48367 300
- 48469 300
- 48071 299
- 48091 299
- 48145 299
- 48181 299
- 48215 299
- 48245 299
- 48355 299
- 48361 299
- 48395 299
- 48409 299
- 48445 299
- 48451 299
- 48471 299
- 48481 299
- 48493 299
- 48013 298
- 48015 298
- 48031 298
- 48053 298
- 48099 298
- 48133 298
- 48143 298
- 48149 298
- 48165 298
- 48185 298
- 48187 298
- 48189 298
- 48199 298
- 48223 298
- 48231 298
- 48257 298
- 48259 298
- 48277 298
- 48291 298
- 48293 298
- 48299 298
- 48323 298
- 48331 298
- 48397 298
- 48465 298
- 48005 297
- 48057 297
- 48239 297
- 48255 297
- 48317 297
- 48347 297
- 48381 297
- 48419 297
- 48427 297
- 48441 297
- 48463 297
- 48489 297
- 48503 297
- 48073 296
- 48203 296
- 48221 296
- 48337 296
- 48349 296
- 48477 296
- 48051 295
- 48055 295
- 48279 295
- 48305 295
- 48373 295
- 48407 295
- 48437 295
- 48473 295
- 48115 294
- 48135 294
- 48159 294
- 48213 294
- 48273 294
- 48497 294
- 48217 293
- 48289 293
- 48341 293
- 48405 292
- 48499 292
- 48001 291
- 48063 291
- 48077 291
- 48089 291
- 48093 291
- 48177 291
- 48179 291
- 48265 291
- 48297 291
- 48351 291
- 48363 291
- 48365 291
- 48129 290
- 48171 290
- 48175 290
- 48241 290
- 48249 290
- 48287 290
- 48449 290
- 48281 289
- 48455 289
- 48457 289
- 48003 288
- 48211 288
- 48233 288
- 48319 288
- 48007 287
- 48371 287
- 48505 287
- 48059 285
- 48107 285
- 48111 285
- 48193 285
- 48195 285
- 48275 285
- 48335 285
- 48025 284
- 48119 284
- 48125 284
- 48153 284
- 48163 284
- 48253 284
- 48403 284
- 48415 284
- 48019 283
- 48237 283
- 48307 283
- 48313 283
- 48379 283
- 48429 283
- 48495 283
- 48095 282
- 48097 282
- 48227 282
- 48127 281
- 48345 279
- 48487 279
- 48011 278
- 48131 278
- 48035 277
- 48161 277
- 48387 277
- 48393 277
- 48421 277
- 48283 276
- 48315 276
- 48507 276
- 48501 275
- 48065 274
- 48369 274
- 48075 273
- 48225 273
- 48205 272
- 48483 271
- 48047 270
- 48079 269
- 48247 269
- 48353 268
- 48357 268
- 48101 265
- 48399 265
- 48295 264
- 48169 262
- 48173 262
- 48043 261
- 48045 260
- 48083 260
- 48391 259
- 48017 257
- 48081 257
- 48087 257
- 48417 256
- 48389 255
- 48267 254
- 48009 247
- 48151 247
- 48207 247
- 48411 244
- 48333 243
- 48191 242
- 48475 240
- 48197 239
- 48377 238
- 48229 236
- 48383 236
- 48271 232
- 48235 229
- 48385 227
- 48023 226
- 48105 226
- 48425 223
- 48413 219
- 48435 213
- 48461 213
- 48109 211
- 48327 209
- 48443 209
- 48137 206
- 48243 205
- 48447 199
- 48261 198
- 48155 191
- 48263 187
- 48311 187
- 48433 184
- 48431 158
- 48033 116
- 48269 96
- 48301 61
- - 1
county 255
- 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
- Crane 304
- DeWitt 304
- Johnson 304
- Upshur 304
- Brown 303
- Cass 303
- Fannin 303
- Hockley 303
- Potter 303
- Bastrop 302
- Castro 302
- Deaf Smith 302
- Midland 302
- Oldham 302
- Morris 300
- Parker 300
- Victoria 300
- Chambers 299
- Comal 299
- Falls 299
- Grayson 299
- Hidalgo 299
- Jefferson 299
- Nueces 299
- Orange 299
- Robertson 299
- San Patricio 299
- Terry 299
- Tom Green 299
- Walker 299
- Wharton 299
- Wilson 299
- Atascosa 298
- Austin 298
- Blanco 298
- Burnet 298
- Coryell 298
- Eastland 298
- Erath 298
- Fayette 298
- Gaines 298
- Grimes 298
- Guadalupe 298
- Hale 298
- Hardin 298
- Hopkins 298
- Hunt 298
- Kaufman 298
- Kendall 298
- Lamar 298
- Liberty 298
- Limestone 298
- Llano 298
- Maverick 298
- Milam 298
- Rockwall 298
- Val Verde 298
- Angelina 297
- Calhoun 297
- Jackson 297
- Karnes 297
- Martin 297
- Nacogdoches 297
- Randall 297
- Shelby 297
- Starr 297
- Taylor 297
- Uvalde 297
- Willacy 297
- Young 297
- Cherokee 296
- Harrison 296
- Hood 296
- Montague 296
- Navarro 296
- Washington 296
- Burleson 295
- Caldwell 295
- Lamb 295
- Lynn 295
- Polk 295
- San Jacinto 295
- Swisher 295
- Waller 295
- Dawson 294
- Ector 294
- Franklin 294
- Henderson 294
- Kleberg 294
- Wise 294
- Hill 293
- Leon 293
- Moore 293
- San Augustine 292
- Wood 292
- Anderson 291
- Camp 291
- Clay 291
- Colorado 291
- Comanche 291
- Gonzales 291
- Gray 291
- Kerr 291
- Live Oak 291
- Newton 291
- Palo Pinto 291
- Panola 291
- Donley 290
- Gillespie 290
- Goliad 290
- Jasper 290
- Jim Wells 290
- Lee 290
- Titus 290
- Lampasas 289
- Trinity 289
- Tyler 289
- Andrews 288
- Hemphill 288
- Hutchinson 288
- Mason 288
- Aransas 287
- Pecos 287
- Zapata 287
- Callahan 285
- Crosby 285
- Dallam 285
- Hamilton 285
- Hansford 285
- Knox 285
- Mitchell 285
- Bee 284
- Delta 284
- Dickens 284
- Floyd 284
- Frio 284
- Jones 284
- Sabine 284
- Scurry 284
- Bandera 283
- Jack 283
- Madison 283
- McCulloch 283
- Rains 283
- Stephens 283
- Winkler 283
- Concho 282
- Cooke 282
- Howard 282
- Dimmit 281
- Motley 279
- Wilbarger 279
- Armstrong 278
- Duval 278
- Bosque 277
- Freestone 277
- Red River 277
- Roberts 277
- Sherman 277
- La Salle 276
- Marion 276
- Zavala 276
- Yoakum 275
- Carson 274
- Parmer 274
- Childress 273
- Houston 273
- Hartley 272
- Wheeler 271
- Brooks 270
- Cochran 269
- Jim Hogg 269
- Nolan 268
- Ochiltree 268
- Cottle 265
- Runnels 265
- Lipscomb 264
- Garza 262
- Glasscock 262
- Brewster 261
- Briscoe 260
- Coleman 260
- Refugio 259
- Bailey 257
- Coke 257
- Collingsworth 257
- Shackelford 256
- Reeves 255
- Kimble 254
- Archer 247
- Fisher 247
- Haskell 247
- San Saba 244
- Mills 243
- Hall 242
- Ward 240
- Hardeman 239
- Presidio 238
- Hudspeth 236
- Reagan 236
- Kinney 232
- Irion 229
- Real 227
- Baylor 226
- Crockett 226
- Somervell 223
- Schleicher 219
- Sutton 213
- Upton 213
- Culberson 211
- Menard 209
- Terrell 209
- Edwards 206
- Jeff Davis 205
- Throckmorton 199
- Kenedy 198
- Foard 191
- Kent 187
- McMullen 187
- Stonewall 184
- Sterling 158
- Borden 116
- King 96
- Loving 61
- Unknown 1
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);