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 248
- 48029 151
- 48157 130
- 48201 129
- 48085 125
- 48113 124
- 48339 124
- 48439 124
- 48183 123
- 48027 121
- 48141 121
- 48167 121
- 48423 121
- 48453 121
- 48039 120
- 48209 120
- 48121 119
- 48037 118
- 48321 118
- 48041 117
- 48139 117
- 48303 117
- 48285 116
- 48309 116
- 48325 116
- 48401 116
- 48479 116
- 48485 116
- 48491 116
- 48061 115
- 48103 115
- 48123 115
- 48251 115
- 48467 115
- 48049 114
- 48067 114
- 48147 114
- 48219 114
- 48459 114
- 48021 113
- 48069 113
- 48117 113
- 48329 113
- 48359 113
- 48375 113
- 48343 111
- 48071 110
- 48091 110
- 48145 110
- 48181 110
- 48215 110
- 48245 110
- 48355 110
- 48367 110
- 48469 110
- 48013 109
- 48015 109
- 48031 109
- 48053 109
- 48099 109
- 48133 109
- 48143 109
- 48149 109
- 48165 109
- 48185 109
- 48187 109
- 48189 109
- 48199 109
- 48223 109
- 48231 109
- 48257 109
- 48259 109
- 48277 109
- 48291 109
- 48293 109
- 48299 109
- 48323 109
- 48331 109
- 48361 109
- 48395 109
- 48409 109
- 48445 109
- 48451 109
- 48471 109
- 48481 109
- 48493 109
- 48005 108
- 48057 108
- 48239 108
- 48255 108
- 48317 108
- 48347 108
- 48397 108
- 48465 108
- 48073 107
- 48203 107
- 48221 107
- 48337 107
- 48349 107
- 48381 107
- 48419 107
- 48427 107
- 48441 107
- 48463 107
- 48489 107
- 48503 107
- 48051 106
- 48055 106
- 48279 106
- 48305 106
- 48477 106
- 48115 105
- 48135 105
- 48159 105
- 48213 105
- 48273 105
- 48373 105
- 48407 105
- 48437 105
- 48473 105
- 48217 104
- 48289 104
- 48341 104
- 48497 104
- 48001 102
- 48063 102
- 48077 102
- 48089 102
- 48093 102
- 48177 102
- 48179 102
- 48265 102
- 48297 102
- 48351 102
- 48405 102
- 48499 102
- 48129 101
- 48171 101
- 48175 101
- 48241 101
- 48249 101
- 48287 101
- 48363 101
- 48365 101
- 48281 100
- 48449 100
- 48003 99
- 48211 99
- 48233 99
- 48319 99
- 48455 99
- 48457 99
- 48007 98
- 48371 97
- 48505 97
- 48059 96
- 48107 96
- 48111 96
- 48193 96
- 48195 96
- 48275 96
- 48335 96
- 48025 95
- 48119 95
- 48125 95
- 48153 95
- 48163 95
- 48253 95
- 48019 94
- 48237 94
- 48307 94
- 48313 94
- 48403 94
- 48415 94
- 48095 93
- 48097 93
- 48227 93
- 48379 93
- 48429 93
- 48495 93
- 48127 92
- 48345 90
- 48011 89
- 48131 89
- 48487 89
- 48035 88
- 48161 88
- 48283 87
- 48315 87
- 48387 87
- 48393 87
- 48421 87
- 48507 86
- 48065 85
- 48501 85
- 48075 84
- 48225 84
- 48369 84
- 48205 83
- 48047 81
- 48483 81
- 48079 80
- 48247 80
- 48353 79
- 48357 79
- 48101 76
- 48295 75
- 48399 75
- 48169 73
- 48173 73
- 48043 72
- 48045 71
- 48083 71
- 48391 69
- 48017 68
- 48081 68
- 48087 68
- 48417 66
- 48267 65
- 48389 65
- 48009 58
- 48151 58
- 48207 58
- 48333 54
- 48411 54
- 48191 53
- 48197 50
- 48475 50
- 48377 48
- 48229 47
- 48383 46
- 48271 43
- 48235 40
- 48023 37
- 48105 37
- 48385 37
- 48425 33
- 48413 29
- 48435 23
- 48461 23
- 48109 22
- 48327 20
- 48443 19
- 48137 17
- 48243 16
- 48261 9
- 48447 9
- 48155 2
- - 1
county 248
- Bexar 151
- Fort Bend 130
- Harris 129
- Collin 125
- Dallas 124
- Montgomery 124
- Tarrant 124
- Gregg 123
- Bell 121
- El Paso 121
- Galveston 121
- Smith 121
- Travis 121
- Brazoria 120
- Hays 120
- Denton 119
- Bowie 118
- Matagorda 118
- Brazos 117
- Ellis 117
- Lubbock 117
- Lavaca 116
- McLennan 116
- Medina 116
- Rusk 116
- Webb 116
- Wichita 116
- Williamson 116
- Cameron 115
- Crane 115
- DeWitt 115
- Johnson 115
- Van Zandt 115
- Brown 114
- Cass 114
- Fannin 114
- Hockley 114
- Upshur 114
- Bastrop 113
- Castro 113
- Deaf Smith 113
- Midland 113
- Oldham 113
- Potter 113
- Morris 111
- Chambers 110
- Comal 110
- Falls 110
- Grayson 110
- Hidalgo 110
- Jefferson 110
- Nueces 110
- Parker 110
- Victoria 110
- Atascosa 109
- Austin 109
- Blanco 109
- Burnet 109
- Coryell 109
- Eastland 109
- Erath 109
- Fayette 109
- Gaines 109
- Grimes 109
- Guadalupe 109
- Hale 109
- Hardin 109
- Hopkins 109
- Hunt 109
- Kaufman 109
- Kendall 109
- Lamar 109
- Liberty 109
- Limestone 109
- Llano 109
- Maverick 109
- Milam 109
- Orange 109
- Robertson 109
- San Patricio 109
- Terry 109
- Tom Green 109
- Walker 109
- Wharton 109
- Wilson 109
- Angelina 108
- Calhoun 108
- Jackson 108
- Karnes 108
- Martin 108
- Nacogdoches 108
- Rockwall 108
- Val Verde 108
- Cherokee 107
- Harrison 107
- Hood 107
- Montague 107
- Navarro 107
- Randall 107
- Shelby 107
- Starr 107
- Taylor 107
- Uvalde 107
- Willacy 107
- Young 107
- Burleson 106
- Caldwell 106
- Lamb 106
- Lynn 106
- Washington 106
- Dawson 105
- Ector 105
- Franklin 105
- Henderson 105
- Kleberg 105
- Polk 105
- San Jacinto 105
- Swisher 105
- Waller 105
- Hill 104
- Leon 104
- Moore 104
- Wise 104
- Anderson 102
- Camp 102
- Clay 102
- Colorado 102
- Comanche 102
- Gonzales 102
- Gray 102
- Kerr 102
- Live Oak 102
- Newton 102
- San Augustine 102
- Wood 102
- Donley 101
- Gillespie 101
- Goliad 101
- Jasper 101
- Jim Wells 101
- Lee 101
- Palo Pinto 101
- Panola 101
- Lampasas 100
- Titus 100
- Andrews 99
- Hemphill 99
- Hutchinson 99
- Mason 99
- Trinity 99
- Tyler 99
- Aransas 98
- Pecos 97
- Zapata 97
- Callahan 96
- Crosby 96
- Dallam 96
- Hamilton 96
- Hansford 96
- Knox 96
- Mitchell 96
- Bee 95
- Delta 95
- Dickens 95
- Floyd 95
- Frio 95
- Jones 95
- Bandera 94
- Jack 94
- Madison 94
- McCulloch 94
- Sabine 94
- Scurry 94
- Concho 93
- Cooke 93
- Howard 93
- Rains 93
- Stephens 93
- Winkler 93
- Dimmit 92
- Motley 90
- Armstrong 89
- Duval 89
- Wilbarger 89
- Bosque 88
- Freestone 88
- La Salle 87
- Marion 87
- Red River 87
- Roberts 87
- Sherman 87
- Zavala 86
- Carson 85
- Yoakum 85
- Childress 84
- Houston 84
- Parmer 84
- Hartley 83
- Brooks 81
- Wheeler 81
- Cochran 80
- Jim Hogg 80
- Nolan 79
- Ochiltree 79
- Cottle 76
- Lipscomb 75
- Runnels 75
- Garza 73
- Glasscock 73
- Brewster 72
- Briscoe 71
- Coleman 71
- Refugio 69
- Bailey 68
- Coke 68
- Collingsworth 68
- Shackelford 66
- Kimble 65
- Reeves 65
- Archer 58
- Fisher 58
- Haskell 58
- Mills 54
- San Saba 54
- Hall 53
- Hardeman 50
- Ward 50
- Presidio 48
- Hudspeth 47
- Reagan 46
- Kinney 43
- Irion 40
- Baylor 37
- Crockett 37
- Real 37
- Somervell 33
- Schleicher 29
- Sutton 23
- Upton 23
- Culberson 22
- Menard 20
- Terrell 19
- Edwards 17
- Jeff Davis 16
- Kenedy 9
- Throckmorton 9
- Foard 2
- Unknown 1
state 1
- Texas · 23,396 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324459 | 324459 | 2020-07-11 | Anderson | Texas | 48001 | 1796 | 3 |
324460 | 324460 | 2020-07-11 | Andrews | Texas | 48003 | 155 | 2 |
324461 | 324461 | 2020-07-11 | Angelina | Texas | 48005 | 743 | 9 |
324462 | 324462 | 2020-07-11 | Aransas | Texas | 48007 | 50 | 0 |
324463 | 324463 | 2020-07-11 | Archer | Texas | 48009 | 10 | 0 |
324464 | 324464 | 2020-07-11 | Armstrong | Texas | 48011 | 3 | 0 |
324465 | 324465 | 2020-07-11 | Atascosa | Texas | 48013 | 207 | 2 |
324466 | 324466 | 2020-07-11 | Austin | Texas | 48015 | 128 | 0 |
324467 | 324467 | 2020-07-11 | Bailey | Texas | 48017 | 112 | 1 |
324468 | 324468 | 2020-07-11 | Bandera | Texas | 48019 | 44 | 0 |
324469 | 324469 | 2020-07-11 | Bastrop | Texas | 48021 | 727 | 11 |
324470 | 324470 | 2020-07-11 | Baylor | Texas | 48023 | 1 | 0 |
324471 | 324471 | 2020-07-11 | Bee | Texas | 48025 | 135 | 0 |
324472 | 324472 | 2020-07-11 | Bell | Texas | 48027 | 2083 | 14 |
324473 | 324473 | 2020-07-11 | Bexar | Texas | 48029 | 19149 | 175 |
324474 | 324474 | 2020-07-11 | Blanco | Texas | 48031 | 49 | 1 |
324475 | 324475 | 2020-07-11 | Bosque | Texas | 48035 | 41 | 0 |
324476 | 324476 | 2020-07-11 | Bowie | Texas | 48037 | 496 | 26 |
324477 | 324477 | 2020-07-11 | Brazoria | Texas | 48039 | 3358 | 25 |
324478 | 324478 | 2020-07-11 | Brazos | Texas | 48041 | 2961 | 35 |
324479 | 324479 | 2020-07-11 | Brewster | Texas | 48043 | 150 | 1 |
324480 | 324480 | 2020-07-11 | Briscoe | Texas | 48045 | 9 | 1 |
324481 | 324481 | 2020-07-11 | Brooks | Texas | 48047 | 37 | 0 |
324482 | 324482 | 2020-07-11 | Brown | Texas | 48049 | 171 | 13 |
324483 | 324483 | 2020-07-11 | Burleson | Texas | 48051 | 148 | 0 |
324484 | 324484 | 2020-07-11 | Burnet | Texas | 48053 | 230 | 3 |
324485 | 324485 | 2020-07-11 | Caldwell | Texas | 48055 | 645 | 5 |
324486 | 324486 | 2020-07-11 | Calhoun | Texas | 48057 | 153 | 3 |
324487 | 324487 | 2020-07-11 | Callahan | Texas | 48059 | 27 | 2 |
324488 | 324488 | 2020-07-11 | Cameron | Texas | 48061 | 3854 | 79 |
324489 | 324489 | 2020-07-11 | Camp | Texas | 48063 | 131 | 2 |
324490 | 324490 | 2020-07-11 | Carson | Texas | 48065 | 10 | 0 |
324491 | 324491 | 2020-07-11 | Cass | Texas | 48067 | 57 | 3 |
324492 | 324492 | 2020-07-11 | Castro | Texas | 48069 | 120 | 1 |
324493 | 324493 | 2020-07-11 | Chambers | Texas | 48071 | 590 | 2 |
324494 | 324494 | 2020-07-11 | Cherokee | Texas | 48073 | 357 | 2 |
324495 | 324495 | 2020-07-11 | Childress | Texas | 48075 | 7 | 0 |
324496 | 324496 | 2020-07-11 | Clay | Texas | 48077 | 16 | 0 |
324497 | 324497 | 2020-07-11 | Cochran | Texas | 48079 | 6 | 0 |
324498 | 324498 | 2020-07-11 | Coke | Texas | 48081 | 6 | 1 |
324499 | 324499 | 2020-07-11 | Coleman | Texas | 48083 | 5 | 0 |
324500 | 324500 | 2020-07-11 | Collin | Texas | 48085 | 4459 | 56 |
324501 | 324501 | 2020-07-11 | Collingsworth | Texas | 48087 | 6 | 0 |
324502 | 324502 | 2020-07-11 | Colorado | Texas | 48089 | 161 | 0 |
324503 | 324503 | 2020-07-11 | Comal | Texas | 48091 | 1282 | 22 |
324504 | 324504 | 2020-07-11 | Comanche | Texas | 48093 | 26 | 1 |
324505 | 324505 | 2020-07-11 | Concho | Texas | 48095 | 13 | 0 |
324506 | 324506 | 2020-07-11 | Cooke | Texas | 48097 | 87 | 0 |
324507 | 324507 | 2020-07-11 | Coryell | Texas | 48099 | 398 | 2 |
324508 | 324508 | 2020-07-11 | Cottle | Texas | 48101 | 4 | 1 |
324509 | 324509 | 2020-07-11 | Crane | Texas | 48103 | 64 | 9 |
324510 | 324510 | 2020-07-11 | Crockett | Texas | 48105 | 35 | 0 |
324511 | 324511 | 2020-07-11 | Crosby | Texas | 48107 | 35 | 2 |
324512 | 324512 | 2020-07-11 | Culberson | Texas | 48109 | 6 | 1 |
324513 | 324513 | 2020-07-11 | Dallam | Texas | 48111 | 116 | 1 |
324514 | 324514 | 2020-07-11 | Dallas | Texas | 48113 | 32626 | 449 |
324515 | 324515 | 2020-07-11 | Dawson | Texas | 48115 | 83 | 1 |
324516 | 324516 | 2020-07-11 | DeWitt | Texas | 48123 | 159 | 3 |
324517 | 324517 | 2020-07-11 | Deaf Smith | Texas | 48117 | 409 | 17 |
324518 | 324518 | 2020-07-11 | Delta | Texas | 48119 | 7 | 0 |
324519 | 324519 | 2020-07-11 | Denton | Texas | 48121 | 3937 | 40 |
324520 | 324520 | 2020-07-11 | Dickens | Texas | 48125 | 2 | 0 |
324521 | 324521 | 2020-07-11 | Dimmit | Texas | 48127 | 31 | 0 |
324522 | 324522 | 2020-07-11 | Donley | Texas | 48129 | 32 | 0 |
324523 | 324523 | 2020-07-11 | Duval | Texas | 48131 | 75 | 0 |
324524 | 324524 | 2020-07-11 | Eastland | Texas | 48133 | 20 | 0 |
324525 | 324525 | 2020-07-11 | Ector | Texas | 48135 | 1829 | 14 |
324526 | 324526 | 2020-07-11 | Edwards | Texas | 48137 | 4 | 0 |
324527 | 324527 | 2020-07-11 | El Paso | Texas | 48141 | 9099 | 150 |
324528 | 324528 | 2020-07-11 | Ellis | Texas | 48139 | 1510 | 20 |
324529 | 324529 | 2020-07-11 | Erath | Texas | 48143 | 216 | 1 |
324530 | 324530 | 2020-07-11 | Falls | Texas | 48145 | 56 | 0 |
324531 | 324531 | 2020-07-11 | Fannin | Texas | 48147 | 137 | 8 |
324532 | 324532 | 2020-07-11 | Fayette | Texas | 48149 | 151 | 3 |
324533 | 324533 | 2020-07-11 | Fisher | Texas | 48151 | 13 | 1 |
324534 | 324534 | 2020-07-11 | Floyd | Texas | 48153 | 52 | 1 |
324535 | 324535 | 2020-07-11 | Foard | Texas | 48155 | 1 | 0 |
324536 | 324536 | 2020-07-11 | Fort Bend | Texas | 48157 | 4758 | 62 |
324537 | 324537 | 2020-07-11 | Franklin | Texas | 48159 | 55 | 1 |
324538 | 324538 | 2020-07-11 | Freestone | Texas | 48161 | 73 | 0 |
324539 | 324539 | 2020-07-11 | Frio | Texas | 48163 | 338 | 0 |
324540 | 324540 | 2020-07-11 | Gaines | Texas | 48165 | 43 | 0 |
324541 | 324541 | 2020-07-11 | Galveston | Texas | 48167 | 5873 | 54 |
324542 | 324542 | 2020-07-11 | Garza | Texas | 48169 | 21 | 1 |
324543 | 324543 | 2020-07-11 | Gillespie | Texas | 48171 | 65 | 0 |
324544 | 324544 | 2020-07-11 | Glasscock | Texas | 48173 | 6 | 0 |
324545 | 324545 | 2020-07-11 | Goliad | Texas | 48175 | 30 | 0 |
324546 | 324546 | 2020-07-11 | Gonzales | Texas | 48177 | 323 | 4 |
324547 | 324547 | 2020-07-11 | Gray | Texas | 48179 | 133 | 4 |
324548 | 324548 | 2020-07-11 | Grayson | Texas | 48181 | 731 | 7 |
324549 | 324549 | 2020-07-11 | Gregg | Texas | 48183 | 788 | 14 |
324550 | 324550 | 2020-07-11 | Grimes | Texas | 48185 | 642 | 2 |
324551 | 324551 | 2020-07-11 | Guadalupe | Texas | 48187 | 1014 | 3 |
324552 | 324552 | 2020-07-11 | Hale | Texas | 48189 | 763 | 11 |
324553 | 324553 | 2020-07-11 | Hall | Texas | 48191 | 2 | 1 |
324554 | 324554 | 2020-07-11 | Hamilton | Texas | 48193 | 32 | 1 |
324555 | 324555 | 2020-07-11 | Hansford | Texas | 48195 | 35 | 2 |
324556 | 324556 | 2020-07-11 | Hardeman | Texas | 48197 | 5 | 0 |
324557 | 324557 | 2020-07-11 | Hardin | Texas | 48199 | 404 | 5 |
324558 | 324558 | 2020-07-11 | Harris | Texas | 48201 | 43939 | 455 |
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);