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 256
- 48029 821
- 48157 800
- 48201 800
- 48085 795
- 48339 795
- 48439 795
- 48113 794
- 48183 793
- 48423 792
- 48453 792
- 48027 791
- 48141 791
- 48167 791
- 48209 791
- 48039 790
- 48121 789
- 48321 789
- 48037 788
- 48303 788
- 48041 787
- 48139 787
- 48285 787
- 48309 787
- 48325 787
- 48401 787
- 48479 787
- 48485 787
- 48491 787
- 48251 786
- 48467 786
- 48061 785
- 48103 785
- 48123 785
- 48219 785
- 48459 785
- 48049 784
- 48067 784
- 48147 784
- 48329 784
- 48359 784
- 48375 784
- 48021 783
- 48069 783
- 48117 783
- 48343 782
- 48215 781
- 48245 781
- 48355 781
- 48367 781
- 48469 781
- 48071 780
- 48091 780
- 48145 780
- 48181 780
- 48223 780
- 48231 780
- 48257 780
- 48259 780
- 48277 780
- 48291 780
- 48293 780
- 48299 780
- 48323 780
- 48331 780
- 48361 780
- 48395 780
- 48409 780
- 48445 780
- 48451 780
- 48471 780
- 48481 780
- 48493 780
- 48013 779
- 48015 779
- 48031 779
- 48053 779
- 48099 779
- 48133 779
- 48143 779
- 48149 779
- 48165 779
- 48185 779
- 48187 779
- 48189 779
- 48199 779
- 48239 779
- 48255 779
- 48317 779
- 48347 779
- 48397 779
- 48465 779
- 48005 778
- 48057 778
- 48203 778
- 48221 778
- 48337 778
- 48349 778
- 48381 778
- 48419 778
- 48427 778
- 48441 778
- 48463 778
- 48489 778
- 48503 778
- 48073 777
- 48279 777
- 48305 777
- 48477 777
- 48051 776
- 48055 776
- 48213 776
- 48273 776
- 48373 776
- 48407 776
- 48437 776
- 48473 776
- 48115 775
- 48135 775
- 48159 775
- 48217 775
- 48289 775
- 48341 775
- 48497 775
- 48265 773
- 48297 773
- 48351 773
- 48405 773
- 48499 773
- 48001 772
- 48063 772
- 48077 772
- 48089 772
- 48093 772
- 48177 772
- 48179 772
- 48241 772
- 48249 772
- 48287 772
- 48363 772
- 48365 772
- 48129 771
- 48171 771
- 48175 771
- 48281 771
- 48449 771
- 48211 770
- 48233 770
- 48319 770
- 48455 770
- 48457 770
- 48003 769
- 48007 768
- 48371 768
- 48505 768
- 48275 767
- 48335 767
- 48059 766
- 48107 766
- 48111 766
- 48193 766
- 48195 766
- 48253 766
- 48025 765
- 48119 765
- 48125 765
- 48153 765
- 48163 765
- 48237 765
- 48307 765
- 48313 765
- 48403 765
- 48415 765
- 48019 764
- 48227 764
- 48379 764
- 48429 764
- 48495 764
- 48095 763
- 48097 763
- 48127 762
- 48345 761
- 48487 760
- 48011 759
- 48131 759
- 48035 758
- 48161 758
- 48283 758
- 48315 758
- 48387 758
- 48393 758
- 48421 758
- 48507 757
- 48501 756
- 48065 755
- 48225 755
- 48369 755
- 48075 754
- 48205 754
- 48483 752
- 48047 751
- 48247 751
- 48079 750
- 48353 750
- 48357 750
- 48101 746
- 48295 746
- 48399 746
- 48169 743
- 48173 743
- 48043 742
- 48045 741
- 48083 741
- 48391 740
- 48017 738
- 48081 738
- 48087 738
- 48417 737
- 48267 736
- 48389 736
- 48207 729
- 48009 728
- 48151 728
- 48333 725
- 48411 725
- 48191 723
- 48475 721
- 48197 720
- 48377 719
- 48229 718
- 48383 717
- 48271 714
- 48235 711
- 48385 708
- 48023 707
- 48105 707
- 48425 704
- 48413 700
- 48435 694
- 48461 694
- 48109 692
- 48327 691
- 48443 690
- 48137 687
- 48243 687
- 48261 680
- 48447 680
- 48155 672
- 48263 669
- 48311 669
- 48433 665
- 48431 639
- 48033 597
- 48269 578
- 48301 543
- - 21
- 48999 5
county 256
- Bexar 821
- Fort Bend 800
- Harris 800
- Collin 795
- Montgomery 795
- Tarrant 795
- Dallas 794
- Gregg 793
- Smith 792
- Travis 792
- Bell 791
- El Paso 791
- Galveston 791
- Hays 791
- Brazoria 790
- Denton 789
- Matagorda 789
- Bowie 788
- Lubbock 788
- Brazos 787
- Ellis 787
- Lavaca 787
- McLennan 787
- Medina 787
- Rusk 787
- Webb 787
- Wichita 787
- Williamson 787
- Johnson 786
- Van Zandt 786
- Cameron 785
- Crane 785
- DeWitt 785
- Hockley 785
- Upshur 785
- Brown 784
- Cass 784
- Fannin 784
- Midland 784
- Oldham 784
- Potter 784
- Bastrop 783
- Castro 783
- Deaf Smith 783
- Morris 782
- Hidalgo 781
- Jefferson 781
- Nueces 781
- Parker 781
- Victoria 781
- Chambers 780
- Comal 780
- Falls 780
- Grayson 780
- Hopkins 780
- Hunt 780
- Kaufman 780
- Kendall 780
- Lamar 780
- Liberty 780
- Limestone 780
- Llano 780
- Maverick 780
- Milam 780
- Orange 780
- Robertson 780
- San Patricio 780
- Terry 780
- Tom Green 780
- Walker 780
- Wharton 780
- Wilson 780
- Atascosa 779
- Austin 779
- Blanco 779
- Burnet 779
- Coryell 779
- Eastland 779
- Erath 779
- Fayette 779
- Gaines 779
- Grimes 779
- Guadalupe 779
- Hale 779
- Hardin 779
- Jackson 779
- Karnes 779
- Martin 779
- Nacogdoches 779
- Rockwall 779
- Val Verde 779
- Angelina 778
- Calhoun 778
- Harrison 778
- Hood 778
- Montague 778
- Navarro 778
- Randall 778
- Shelby 778
- Starr 778
- Taylor 778
- Uvalde 778
- Willacy 778
- Young 778
- Cherokee 777
- Lamb 777
- Lynn 777
- Washington 777
- Burleson 776
- Caldwell 776
- Henderson 776
- Kleberg 776
- Polk 776
- San Jacinto 776
- Swisher 776
- Waller 776
- Dawson 775
- Ector 775
- Franklin 775
- Hill 775
- Leon 775
- Moore 775
- Wise 775
- Kerr 773
- Live Oak 773
- Newton 773
- San Augustine 773
- Wood 773
- Anderson 772
- Camp 772
- Clay 772
- Colorado 772
- Comanche 772
- Gonzales 772
- Gray 772
- Jasper 772
- Jim Wells 772
- Lee 772
- Palo Pinto 772
- Panola 772
- Donley 771
- Gillespie 771
- Goliad 771
- Lampasas 771
- Titus 771
- Hemphill 770
- Hutchinson 770
- Mason 770
- Trinity 770
- Tyler 770
- Andrews 769
- Aransas 768
- Pecos 768
- Zapata 768
- Knox 767
- Mitchell 767
- Callahan 766
- Crosby 766
- Dallam 766
- Hamilton 766
- Hansford 766
- Jones 766
- Bee 765
- Delta 765
- Dickens 765
- Floyd 765
- Frio 765
- Jack 765
- Madison 765
- McCulloch 765
- Sabine 765
- Scurry 765
- Bandera 764
- Howard 764
- Rains 764
- Stephens 764
- Winkler 764
- Concho 763
- Cooke 763
- Dimmit 762
- Motley 761
- Wilbarger 760
- Armstrong 759
- Duval 759
- Bosque 758
- Freestone 758
- La Salle 758
- Marion 758
- Red River 758
- Roberts 758
- Sherman 758
- Zavala 757
- Yoakum 756
- Carson 755
- Houston 755
- Parmer 755
- Childress 754
- Hartley 754
- Wheeler 752
- Brooks 751
- Jim Hogg 751
- Cochran 750
- Nolan 750
- Ochiltree 750
- Cottle 746
- Lipscomb 746
- Runnels 746
- Garza 743
- Glasscock 743
- Brewster 742
- Briscoe 741
- Coleman 741
- Refugio 740
- Bailey 738
- Coke 738
- Collingsworth 738
- Shackelford 737
- Kimble 736
- Reeves 736
- Haskell 729
- Archer 728
- Fisher 728
- Mills 725
- San Saba 725
- Hall 723
- Ward 721
- Hardeman 720
- Presidio 719
- Hudspeth 718
- Reagan 717
- Kinney 714
- Irion 711
- Real 708
- Baylor 707
- Crockett 707
- Somervell 704
- Schleicher 700
- Sutton 694
- Upton 694
- Culberson 692
- Menard 691
- Terrell 690
- Edwards 687
- Jeff Davis 687
- Kenedy 680
- Throckmorton 680
- Foard 672
- Kent 669
- McMullen 669
- Stonewall 665
- Sterling 639
- Borden 597
- King 578
- Loving 543
- Unknown 21
- Pending County Assignment 5
state 1
- Texas · 193,419 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502307 | 2502307 | 2022-05-13 | Harris | Texas | 48201 | 1032781 | 10972 |
2502308 | 2502308 | 2022-05-13 | Harrison | Texas | 48203 | 13370 | 227 |
2502309 | 2502309 | 2022-05-13 | Hartley | Texas | 48205 | 1364 | 3 |
2502310 | 2502310 | 2022-05-13 | Haskell | Texas | 48207 | 897 | 39 |
2502311 | 2502311 | 2022-05-13 | Hays | Texas | 48209 | 60893 | 498 |
2502312 | 2502312 | 2022-05-13 | Hemphill | Texas | 48211 | 1239 | 7 |
2502313 | 2502313 | 2022-05-13 | Henderson | Texas | 48213 | 15410 | 424 |
2502314 | 2502314 | 2022-05-13 | Hidalgo | Texas | 48215 | 207289 | 3909 |
2502315 | 2502315 | 2022-05-13 | Hill | Texas | 48217 | 8991 | 192 |
2502316 | 2502316 | 2022-05-13 | Hockley | Texas | 48219 | 7750 | 161 |
2502317 | 2502317 | 2022-05-13 | Hood | Texas | 48221 | 13472 | 274 |
2502318 | 2502318 | 2022-05-13 | Hopkins | Texas | 48223 | 7264 | 180 |
2502319 | 2502319 | 2022-05-13 | Houston | Texas | 48225 | 4253 | 111 |
2502320 | 2502320 | 2022-05-13 | Howard | Texas | 48227 | 6876 | 184 |
2502321 | 2502321 | 2022-05-13 | Hudspeth | Texas | 48229 | 989 | 18 |
2502322 | 2502322 | 2022-05-13 | Hunt | Texas | 48231 | 15811 | 363 |
2502323 | 2502323 | 2022-05-13 | Hutchinson | Texas | 48233 | 6755 | 135 |
2502324 | 2502324 | 2022-05-13 | Irion | Texas | 48235 | 445 | 3 |
2502325 | 2502325 | 2022-05-13 | Jack | Texas | 48237 | 1523 | 28 |
2502326 | 2502326 | 2022-05-13 | Jackson | Texas | 48239 | 3258 | 59 |
2502327 | 2502327 | 2022-05-13 | Jasper | Texas | 48241 | 6102 | 187 |
2502328 | 2502328 | 2022-05-13 | Jeff Davis | Texas | 48243 | 224 | 9 |
2502329 | 2502329 | 2022-05-13 | Jefferson | Texas | 48245 | 49316 | 843 |
2502330 | 2502330 | 2022-05-13 | Jim Hogg | Texas | 48247 | 2648 | 22 |
2502331 | 2502331 | 2022-05-13 | Jim Wells | Texas | 48249 | 11411 | 208 |
2502332 | 2502332 | 2022-05-13 | Johnson | Texas | 48251 | 43903 | 735 |
2502333 | 2502333 | 2022-05-13 | Jones | Texas | 48253 | 4643 | 93 |
2502334 | 2502334 | 2022-05-13 | Karnes | Texas | 48255 | 5968 | 70 |
2502335 | 2502335 | 2022-05-13 | Kaufman | Texas | 48257 | 35680 | 536 |
2502336 | 2502336 | 2022-05-13 | Kendall | Texas | 48259 | 8263 | 119 |
2502337 | 2502337 | 2022-05-13 | Kenedy | Texas | 48261 | 86 | 2 |
2502338 | 2502338 | 2022-05-13 | Kent | Texas | 48263 | 210 | 4 |
2502339 | 2502339 | 2022-05-13 | Kerr | Texas | 48265 | 9690 | 182 |
2502340 | 2502340 | 2022-05-13 | Kimble | Texas | 48267 | 714 | 15 |
2502341 | 2502341 | 2022-05-13 | King | Texas | 48269 | 51 | 0 |
2502342 | 2502342 | 2022-05-13 | Kinney | Texas | 48271 | 741 | 11 |
2502343 | 2502343 | 2022-05-13 | Kleberg | Texas | 48273 | 7304 | 147 |
2502344 | 2502344 | 2022-05-13 | Knox | Texas | 48275 | 492 | 25 |
2502345 | 2502345 | 2022-05-13 | La Salle | Texas | 48283 | 2421 | 48 |
2502346 | 2502346 | 2022-05-13 | Lamar | Texas | 48277 | 12500 | 256 |
2502347 | 2502347 | 2022-05-13 | Lamb | Texas | 48279 | 4356 | 122 |
2502348 | 2502348 | 2022-05-13 | Lampasas | Texas | 48281 | 5556 | 90 |
2502349 | 2502349 | 2022-05-13 | Lavaca | Texas | 48285 | 4271 | 120 |
2502350 | 2502350 | 2022-05-13 | Lee | Texas | 48287 | 4278 | 60 |
2502351 | 2502351 | 2022-05-13 | Leon | Texas | 48289 | 3728 | 93 |
2502352 | 2502352 | 2022-05-13 | Liberty | Texas | 48291 | 18210 | 404 |
2502353 | 2502353 | 2022-05-13 | Limestone | Texas | 48293 | 5100 | 124 |
2502354 | 2502354 | 2022-05-13 | Lipscomb | Texas | 48295 | 720 | 16 |
2502355 | 2502355 | 2022-05-13 | Live Oak | Texas | 48297 | 2153 | 42 |
2502356 | 2502356 | 2022-05-13 | Llano | Texas | 48299 | 3933 | 97 |
2502357 | 2502357 | 2022-05-13 | Loving | Texas | 48301 | 196 | 1 |
2502358 | 2502358 | 2022-05-13 | Lubbock | Texas | 48303 | 93789 | 1329 |
2502359 | 2502359 | 2022-05-13 | Lynn | Texas | 48305 | 1556 | 38 |
2502360 | 2502360 | 2022-05-13 | Madison | Texas | 48313 | 3778 | 54 |
2502361 | 2502361 | 2022-05-13 | Marion | Texas | 48315 | 1690 | 60 |
2502362 | 2502362 | 2022-05-13 | Martin | Texas | 48317 | 1207 | 26 |
2502363 | 2502363 | 2022-05-13 | Mason | Texas | 48319 | 787 | 12 |
2502364 | 2502364 | 2022-05-13 | Matagorda | Texas | 48321 | 8374 | 175 |
2502365 | 2502365 | 2022-05-13 | Maverick | Texas | 48323 | 20872 | 469 |
2502366 | 2502366 | 2022-05-13 | McCulloch | Texas | 48307 | 1308 | 47 |
2502367 | 2502367 | 2022-05-13 | McLennan | Texas | 48309 | 60473 | 902 |
2502368 | 2502368 | 2022-05-13 | McMullen | Texas | 48311 | 169 | 9 |
2502369 | 2502369 | 2022-05-13 | Medina | Texas | 48325 | 10269 | 199 |
2502370 | 2502370 | 2022-05-13 | Menard | Texas | 48327 | 513 | 12 |
2502371 | 2502371 | 2022-05-13 | Midland | Texas | 48329 | 40910 | 496 |
2502372 | 2502372 | 2022-05-13 | Milam | Texas | 48331 | 4950 | 102 |
2502373 | 2502373 | 2022-05-13 | Mills | Texas | 48333 | 1475 | 37 |
2502374 | 2502374 | 2022-05-13 | Mitchell | Texas | 48335 | 1864 | 49 |
2502375 | 2502375 | 2022-05-13 | Montague | Texas | 48337 | 4694 | 129 |
2502376 | 2502376 | 2022-05-13 | Montgomery | Texas | 48339 | 141687 | 1291 |
2502377 | 2502377 | 2022-05-13 | Moore | Texas | 48341 | 5604 | 111 |
2502378 | 2502378 | 2022-05-13 | Morris | Texas | 48343 | 2529 | 73 |
2502379 | 2502379 | 2022-05-13 | Motley | Texas | 48345 | 286 | 13 |
2502380 | 2502380 | 2022-05-13 | Nacogdoches | Texas | 48347 | 12413 | 258 |
2502381 | 2502381 | 2022-05-13 | Navarro | Texas | 48349 | 12469 | 222 |
2502382 | 2502382 | 2022-05-13 | Newton | Texas | 48351 | 1367 | 61 |
2502383 | 2502383 | 2022-05-13 | Nolan | Texas | 48353 | 3065 | 99 |
2502384 | 2502384 | 2022-05-13 | Nueces | Texas | 48355 | 93429 | 1494 |
2502385 | 2502385 | 2022-05-13 | Ochiltree | Texas | 48357 | 2424 | 48 |
2502386 | 2502386 | 2022-05-13 | Oldham | Texas | 48359 | 565 | 6 |
2502387 | 2502387 | 2022-05-13 | Orange | Texas | 48361 | 14968 | 355 |
2502388 | 2502388 | 2022-05-13 | Palo Pinto | Texas | 48363 | 7052 | 154 |
2502389 | 2502389 | 2022-05-13 | Panola | Texas | 48365 | 4609 | 129 |
2502390 | 2502390 | 2022-05-13 | Parker | Texas | 48367 | 34819 | 450 |
2502391 | 2502391 | 2022-05-13 | Parmer | Texas | 48369 | 2363 | 52 |
2502392 | 2502392 | 2022-05-13 | Pecos | Texas | 48371 | 2749 | 71 |
2502393 | 2502393 | 2022-05-13 | Pending County Assignment | Texas | 48999 | 65 | 0 |
2502394 | 2502394 | 2022-05-13 | Polk | Texas | 48373 | 7896 | 247 |
2502395 | 2502395 | 2022-05-13 | Potter | Texas | 48375 | 35779 | 739 |
2502396 | 2502396 | 2022-05-13 | Presidio | Texas | 48377 | 998 | 38 |
2502397 | 2502397 | 2022-05-13 | Rains | Texas | 48379 | 1839 | 59 |
2502398 | 2502398 | 2022-05-13 | Randall | Texas | 48381 | 38234 | 516 |
2502399 | 2502399 | 2022-05-13 | Reagan | Texas | 48383 | 859 | 14 |
2502400 | 2502400 | 2022-05-13 | Real | Texas | 48385 | 817 | 25 |
2502401 | 2502401 | 2022-05-13 | Red River | Texas | 48387 | 2304 | 67 |
2502402 | 2502402 | 2022-05-13 | Reeves | Texas | 48389 | 4636 | 74 |
2502403 | 2502403 | 2022-05-13 | Refugio | Texas | 48391 | 1781 | 36 |
2502404 | 2502404 | 2022-05-13 | Roberts | Texas | 48393 | 175 | 2 |
2502405 | 2502405 | 2022-05-13 | Robertson | Texas | 48395 | 4541 | 77 |
2502406 | 2502406 | 2022-05-13 | Rockwall | Texas | 48397 | 26778 | 266 |
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);