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 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
- …
county >30
- 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
- …
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);