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 619
- 48157 598
- 48201 598
- 48085 593
- 48339 593
- 48439 593
- 48113 592
- 48183 591
- 48423 590
- 48453 590
- 48027 589
- 48141 589
- 48167 589
- 48209 589
- 48039 588
- 48121 587
- 48321 587
- 48037 586
- 48303 586
- 48041 585
- 48139 585
- 48285 585
- 48309 585
- 48325 585
- 48401 585
- 48479 585
- 48485 585
- 48491 585
- 48251 584
- 48467 584
- …
county >30
- Bexar 619
- Fort Bend 598
- Harris 598
- Collin 593
- Montgomery 593
- Tarrant 593
- Dallas 592
- Gregg 591
- Smith 590
- Travis 590
- Bell 589
- El Paso 589
- Galveston 589
- Hays 589
- Brazoria 588
- Denton 587
- Matagorda 587
- Bowie 586
- Lubbock 586
- Brazos 585
- Ellis 585
- Lavaca 585
- McLennan 585
- Medina 585
- Rusk 585
- Webb 585
- Wichita 585
- Williamson 585
- Johnson 584
- Van Zandt 584
- …
state 1
- Texas · 142,086 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1845332 | 1845332 | 2021-10-23 | Harris | Texas | 48201 | 572797 | 9004 |
1845333 | 1845333 | 2021-10-23 | Harrison | Texas | 48203 | 9114 | 177 |
1845334 | 1845334 | 2021-10-23 | Hartley | Texas | 48205 | 851 | 2 |
1845335 | 1845335 | 2021-10-23 | Haskell | Texas | 48207 | 618 | 31 |
1845336 | 1845336 | 2021-10-23 | Hays | Texas | 48209 | 32709 | 389 |
1845337 | 1845337 | 2021-10-23 | Hemphill | Texas | 48211 | 699 | 3 |
1845338 | 1845338 | 2021-10-23 | Henderson | Texas | 48213 | 9661 | 331 |
1845339 | 1845339 | 2021-10-23 | Hidalgo | Texas | 48215 | 114450 | 3429 |
1845340 | 1845340 | 2021-10-23 | Hill | Texas | 48217 | 5790 | 156 |
1845341 | 1845341 | 2021-10-23 | Hockley | Texas | 48219 | 4226 | 130 |
1845342 | 1845342 | 2021-10-23 | Hood | Texas | 48221 | 9640 | 196 |
1845343 | 1845343 | 2021-10-23 | Hopkins | Texas | 48223 | 5335 | 144 |
1845344 | 1845344 | 2021-10-23 | Houston | Texas | 48225 | 2842 | 79 |
1845345 | 1845345 | 2021-10-23 | Howard | Texas | 48227 | 5748 | 132 |
1845346 | 1845346 | 2021-10-23 | Hudspeth | Texas | 48229 | 583 | 14 |
1845347 | 1845347 | 2021-10-23 | Hunt | Texas | 48231 | 10879 | 288 |
1845348 | 1845348 | 2021-10-23 | Hutchinson | Texas | 48233 | 3632 | 86 |
1845349 | 1845349 | 2021-10-23 | Irion | Texas | 48235 | 187 | 2 |
1845350 | 1845350 | 2021-10-23 | Jack | Texas | 48237 | 934 | 20 |
1845351 | 1845351 | 2021-10-23 | Jackson | Texas | 48239 | 2778 | 50 |
1845352 | 1845352 | 2021-10-23 | Jasper | Texas | 48241 | 4009 | 149 |
1845353 | 1845353 | 2021-10-23 | Jeff Davis | Texas | 48243 | 208 | 6 |
1845354 | 1845354 | 2021-10-23 | Jefferson | Texas | 48245 | 31593 | 688 |
1845355 | 1845355 | 2021-10-23 | Jim Hogg | Texas | 48247 | 902 | 20 |
1845356 | 1845356 | 2021-10-23 | Jim Wells | Texas | 48249 | 7119 | 174 |
1845357 | 1845357 | 2021-10-23 | Johnson | Texas | 48251 | 28219 | 532 |
1845358 | 1845358 | 2021-10-23 | Jones | Texas | 48253 | 3261 | 73 |
1845359 | 1845359 | 2021-10-23 | Karnes | Texas | 48255 | 4037 | 56 |
1845360 | 1845360 | 2021-10-23 | Kaufman | Texas | 48257 | 23800 | 413 |
1845361 | 1845361 | 2021-10-23 | Kendall | Texas | 48259 | 5076 | 97 |
1845362 | 1845362 | 2021-10-23 | Kenedy | Texas | 48261 | 60 | 2 |
1845363 | 1845363 | 2021-10-23 | Kent | Texas | 48263 | 123 | 3 |
1845364 | 1845364 | 2021-10-23 | Kerr | Texas | 48265 | 6544 | 132 |
1845365 | 1845365 | 2021-10-23 | Kimble | Texas | 48267 | 441 | 11 |
1845366 | 1845366 | 2021-10-23 | King | Texas | 48269 | 16 | 0 |
1845367 | 1845367 | 2021-10-23 | Kinney | Texas | 48271 | 509 | 9 |
1845368 | 1845368 | 2021-10-23 | Kleberg | Texas | 48273 | 4303 | 126 |
1845369 | 1845369 | 2021-10-23 | Knox | Texas | 48275 | 341 | 20 |
1845370 | 1845370 | 2021-10-23 | La Salle | Texas | 48283 | 1221 | 40 |
1845371 | 1845371 | 2021-10-23 | Lamar | Texas | 48277 | 8779 | 204 |
1845372 | 1845372 | 2021-10-23 | Lamb | Texas | 48279 | 2972 | 88 |
1845373 | 1845373 | 2021-10-23 | Lampasas | Texas | 48281 | 3513 | 62 |
1845374 | 1845374 | 2021-10-23 | Lavaca | Texas | 48285 | 3154 | 95 |
1845375 | 1845375 | 2021-10-23 | Lee | Texas | 48287 | 2932 | 50 |
1845376 | 1845376 | 2021-10-23 | Leon | Texas | 48289 | 2444 | 65 |
1845377 | 1845377 | 2021-10-23 | Liberty | Texas | 48291 | 12682 | 342 |
1845378 | 1845378 | 2021-10-23 | Limestone | Texas | 48293 | 3637 | 107 |
1845379 | 1845379 | 2021-10-23 | Lipscomb | Texas | 48295 | 388 | 12 |
1845380 | 1845380 | 2021-10-23 | Live Oak | Texas | 48297 | 1758 | 38 |
1845381 | 1845381 | 2021-10-23 | Llano | Texas | 48299 | 2588 | 72 |
1845382 | 1845382 | 2021-10-23 | Loving | Texas | 48301 | 8 | 0 |
1845383 | 1845383 | 2021-10-23 | Lubbock | Texas | 48303 | 65334 | 993 |
1845384 | 1845384 | 2021-10-23 | Lynn | Texas | 48305 | 837 | 27 |
1845385 | 1845385 | 2021-10-23 | Madison | Texas | 48313 | 2474 | 43 |
1845386 | 1845386 | 2021-10-23 | Marion | Texas | 48315 | 1167 | 50 |
1845387 | 1845387 | 2021-10-23 | Martin | Texas | 48317 | 834 | 24 |
1845388 | 1845388 | 2021-10-23 | Mason | Texas | 48319 | 565 | 7 |
1845389 | 1845389 | 2021-10-23 | Matagorda | Texas | 48321 | 6046 | 156 |
1845390 | 1845390 | 2021-10-23 | Maverick | Texas | 48323 | 12740 | 403 |
1845391 | 1845391 | 2021-10-23 | McCulloch | Texas | 48307 | 927 | 36 |
1845392 | 1845392 | 2021-10-23 | McLennan | Texas | 48309 | 42082 | 707 |
1845393 | 1845393 | 2021-10-23 | McMullen | Texas | 48311 | 116 | 8 |
1845394 | 1845394 | 2021-10-23 | Medina | Texas | 48325 | 6880 | 162 |
1845395 | 1845395 | 2021-10-23 | Menard | Texas | 48327 | 339 | 11 |
1845396 | 1845396 | 2021-10-23 | Midland | Texas | 48329 | 27925 | 363 |
1845397 | 1845397 | 2021-10-23 | Milam | Texas | 48331 | 3721 | 82 |
1845398 | 1845398 | 2021-10-23 | Mills | Texas | 48333 | 863 | 27 |
1845399 | 1845399 | 2021-10-23 | Mitchell | Texas | 48335 | 919 | 39 |
1845400 | 1845400 | 2021-10-23 | Montague | Texas | 48337 | 3062 | 90 |
1845401 | 1845401 | 2021-10-23 | Montgomery | Texas | 48339 | 87429 | 1047 |
1845402 | 1845402 | 2021-10-23 | Moore | Texas | 48341 | 3457 | 85 |
1845403 | 1845403 | 2021-10-23 | Morris | Texas | 48343 | 1646 | 52 |
1845404 | 1845404 | 2021-10-23 | Motley | Texas | 48345 | 161 | 9 |
1845405 | 1845405 | 2021-10-23 | Nacogdoches | Texas | 48347 | 7770 | 225 |
1845406 | 1845406 | 2021-10-23 | Navarro | Texas | 48349 | 8685 | 182 |
1845407 | 1845407 | 2021-10-23 | Newton | Texas | 48351 | 940 | 51 |
1845408 | 1845408 | 2021-10-23 | Nolan | Texas | 48353 | 2464 | 75 |
1845409 | 1845409 | 2021-10-23 | Nueces | Texas | 48355 | 61305 | 1245 |
1845410 | 1845410 | 2021-10-23 | Ochiltree | Texas | 48357 | 1515 | 37 |
1845411 | 1845411 | 2021-10-23 | Oldham | Texas | 48359 | 349 | 6 |
1845412 | 1845412 | 2021-10-23 | Orange | Texas | 48361 | 13670 | 280 |
1845413 | 1845413 | 2021-10-23 | Palo Pinto | Texas | 48363 | 4679 | 113 |
1845414 | 1845414 | 2021-10-23 | Panola | Texas | 48365 | 2943 | 108 |
1845415 | 1845415 | 2021-10-23 | Parker | Texas | 48367 | 24096 | 309 |
1845416 | 1845416 | 2021-10-23 | Parmer | Texas | 48369 | 1526 | 35 |
1845417 | 1845417 | 2021-10-23 | Pecos | Texas | 48371 | 2294 | 49 |
1845418 | 1845418 | 2021-10-23 | Polk | Texas | 48373 | 5900 | 197 |
1845419 | 1845419 | 2021-10-23 | Potter | Texas | 48375 | 23274 | 544 |
1845420 | 1845420 | 2021-10-23 | Presidio | Texas | 48377 | 898 | 28 |
1845421 | 1845421 | 2021-10-23 | Rains | Texas | 48379 | 1504 | 44 |
1845422 | 1845422 | 2021-10-23 | Randall | Texas | 48381 | 23535 | 358 |
1845423 | 1845423 | 2021-10-23 | Reagan | Texas | 48383 | 596 | 10 |
1845424 | 1845424 | 2021-10-23 | Real | Texas | 48385 | 533 | 18 |
1845425 | 1845425 | 2021-10-23 | Red River | Texas | 48387 | 1378 | 49 |
1845426 | 1845426 | 2021-10-23 | Reeves | Texas | 48389 | 3521 | 53 |
1845427 | 1845427 | 2021-10-23 | Refugio | Texas | 48391 | 1198 | 31 |
1845428 | 1845428 | 2021-10-23 | Roberts | Texas | 48393 | 96 | 1 |
1845429 | 1845429 | 2021-10-23 | Robertson | Texas | 48395 | 2938 | 63 |
1845430 | 1845430 | 2021-10-23 | Rockwall | Texas | 48397 | 17519 | 218 |
1845431 | 1845431 | 2021-10-23 | Runnels | Texas | 48399 | 1701 | 54 |
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);