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 445
- 48157 424
- 48201 424
- 48085 419
- 48339 419
- 48439 419
- 48113 418
- 48183 417
- 48423 416
- 48453 416
- 48027 415
- 48141 415
- 48167 415
- 48209 415
- 48039 414
- 48121 413
- 48321 413
- 48037 412
- 48303 412
- 48041 411
- 48139 411
- 48285 411
- 48309 411
- 48325 411
- 48401 411
- 48479 411
- 48485 411
- 48491 411
- 48251 410
- 48467 410
- …
county >30
- Bexar 445
- Fort Bend 424
- Harris 424
- Collin 419
- Montgomery 419
- Tarrant 419
- Dallas 418
- Gregg 417
- Smith 416
- Travis 416
- Bell 415
- El Paso 415
- Galveston 415
- Hays 415
- Brazoria 414
- Denton 413
- Matagorda 413
- Bowie 412
- Lubbock 412
- Brazos 411
- Ellis 411
- Lavaca 411
- McLennan 411
- Medina 411
- Rusk 411
- Webb 411
- Wichita 411
- Williamson 411
- Johnson 410
- Van Zandt 410
- …
state 1
- Texas · 97,890 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280267 | 1280267 | 2021-05-02 | Harris | Texas | 48201 | 392976 | 6217 |
1280268 | 1280268 | 2021-05-02 | Harrison | Texas | 48203 | 4815 | 107 |
1280269 | 1280269 | 2021-05-02 | Hartley | Texas | 48205 | 632 | 2 |
1280270 | 1280270 | 2021-05-02 | Haskell | Texas | 48207 | 445 | 27 |
1280271 | 1280271 | 2021-05-02 | Hays | Texas | 48209 | 20360 | 239 |
1280272 | 1280272 | 2021-05-02 | Hemphill | Texas | 48211 | 586 | 2 |
1280273 | 1280273 | 2021-05-02 | Henderson | Texas | 48213 | 5839 | 184 |
1280274 | 1280274 | 2021-05-02 | Hidalgo | Texas | 48215 | 87012 | 2824 |
1280275 | 1280275 | 2021-05-02 | Hill | Texas | 48217 | 4483 | 108 |
1280276 | 1280276 | 2021-05-02 | Hockley | Texas | 48219 | 2818 | 102 |
1280277 | 1280277 | 2021-05-02 | Hood | Texas | 48221 | 6517 | 129 |
1280278 | 1280278 | 2021-05-02 | Hopkins | Texas | 48223 | 3082 | 109 |
1280279 | 1280279 | 2021-05-02 | Houston | Texas | 48225 | 1629 | 52 |
1280280 | 1280280 | 2021-05-02 | Howard | Texas | 48227 | 4634 | 101 |
1280281 | 1280281 | 2021-05-02 | Hudspeth | Texas | 48229 | 527 | 11 |
1280282 | 1280282 | 2021-05-02 | Hunt | Texas | 48231 | 5929 | 167 |
1280283 | 1280283 | 2021-05-02 | Hutchinson | Texas | 48233 | 2011 | 71 |
1280284 | 1280284 | 2021-05-02 | Irion | Texas | 48235 | 125 | 1 |
1280285 | 1280285 | 2021-05-02 | Jack | Texas | 48237 | 607 | 16 |
1280286 | 1280286 | 2021-05-02 | Jackson | Texas | 48239 | 1814 | 31 |
1280287 | 1280287 | 2021-05-02 | Jasper | Texas | 48241 | 2466 | 88 |
1280288 | 1280288 | 2021-05-02 | Jeff Davis | Texas | 48243 | 190 | 5 |
1280289 | 1280289 | 2021-05-02 | Jefferson | Texas | 48245 | 19573 | 422 |
1280290 | 1280290 | 2021-05-02 | Jim Hogg | Texas | 48247 | 613 | 16 |
1280291 | 1280291 | 2021-05-02 | Jim Wells | Texas | 48249 | 4258 | 101 |
1280292 | 1280292 | 2021-05-02 | Johnson | Texas | 48251 | 19714 | 366 |
1280293 | 1280293 | 2021-05-02 | Jones | Texas | 48253 | 2641 | 55 |
1280294 | 1280294 | 2021-05-02 | Karnes | Texas | 48255 | 2079 | 37 |
1280295 | 1280295 | 2021-05-02 | Kaufman | Texas | 48257 | 15930 | 256 |
1280296 | 1280296 | 2021-05-02 | Kendall | Texas | 48259 | 3267 | 72 |
1280297 | 1280297 | 2021-05-02 | Kenedy | Texas | 48261 | 38 | 2 |
1280298 | 1280298 | 2021-05-02 | Kent | Texas | 48263 | 106 | 2 |
1280299 | 1280299 | 2021-05-02 | Kerr | Texas | 48265 | 4455 | 88 |
1280300 | 1280300 | 2021-05-02 | Kimble | Texas | 48267 | 267 | 6 |
1280301 | 1280301 | 2021-05-02 | King | Texas | 48269 | 11 | 0 |
1280302 | 1280302 | 2021-05-02 | Kinney | Texas | 48271 | 347 | 6 |
1280303 | 1280303 | 2021-05-02 | Kleberg | Texas | 48273 | 2637 | 93 |
1280304 | 1280304 | 2021-05-02 | Knox | Texas | 48275 | 258 | 17 |
1280305 | 1280305 | 2021-05-02 | La Salle | Texas | 48283 | 1045 | 28 |
1280306 | 1280306 | 2021-05-02 | Lamar | Texas | 48277 | 5813 | 155 |
1280307 | 1280307 | 2021-05-02 | Lamb | Texas | 48279 | 2282 | 82 |
1280308 | 1280308 | 2021-05-02 | Lampasas | Texas | 48281 | 2173 | 32 |
1280309 | 1280309 | 2021-05-02 | Lavaca | Texas | 48285 | 2471 | 76 |
1280310 | 1280310 | 2021-05-02 | Lee | Texas | 48287 | 2177 | 39 |
1280311 | 1280311 | 2021-05-02 | Leon | Texas | 48289 | 1625 | 43 |
1280312 | 1280312 | 2021-05-02 | Liberty | Texas | 48291 | 7762 | 182 |
1280313 | 1280313 | 2021-05-02 | Limestone | Texas | 48293 | 2768 | 76 |
1280314 | 1280314 | 2021-05-02 | Lipscomb | Texas | 48295 | 335 | 12 |
1280315 | 1280315 | 2021-05-02 | Live Oak | Texas | 48297 | 1129 | 22 |
1280316 | 1280316 | 2021-05-02 | Llano | Texas | 48299 | 1650 | 51 |
1280317 | 1280317 | 2021-05-02 | Loving | Texas | 48301 | 2 | 0 |
1280318 | 1280318 | 2021-05-02 | Lubbock | Texas | 48303 | 48910 | 784 |
1280319 | 1280319 | 2021-05-02 | Lynn | Texas | 48305 | 618 | 23 |
1280320 | 1280320 | 2021-05-02 | Madison | Texas | 48313 | 1959 | 29 |
1280321 | 1280321 | 2021-05-02 | Marion | Texas | 48315 | 538 | 33 |
1280322 | 1280322 | 2021-05-02 | Martin | Texas | 48317 | 631 | 18 |
1280323 | 1280323 | 2021-05-02 | Mason | Texas | 48319 | 395 | 6 |
1280324 | 1280324 | 2021-05-02 | Matagorda | Texas | 48321 | 3961 | 109 |
1280325 | 1280325 | 2021-05-02 | Maverick | Texas | 48323 | 10426 | 355 |
1280326 | 1280326 | 2021-05-02 | McCulloch | Texas | 48307 | 574 | 19 |
1280327 | 1280327 | 2021-05-02 | McLennan | Texas | 48309 | 26984 | 470 |
1280328 | 1280328 | 2021-05-02 | McMullen | Texas | 48311 | 83 | 5 |
1280329 | 1280329 | 2021-05-02 | Medina | Texas | 48325 | 4972 | 103 |
1280330 | 1280330 | 2021-05-02 | Menard | Texas | 48327 | 208 | 9 |
1280331 | 1280331 | 2021-05-02 | Midland | Texas | 48329 | 17331 | 266 |
1280332 | 1280332 | 2021-05-02 | Milam | Texas | 48331 | 2522 | 48 |
1280333 | 1280333 | 2021-05-02 | Mills | Texas | 48333 | 656 | 21 |
1280334 | 1280334 | 2021-05-02 | Mitchell | Texas | 48335 | 603 | 30 |
1280335 | 1280335 | 2021-05-02 | Montague | Texas | 48337 | 2083 | 71 |
1280336 | 1280336 | 2021-05-02 | Montgomery | Texas | 48339 | 52540 | 562 |
1280337 | 1280337 | 2021-05-02 | Moore | Texas | 48341 | 2457 | 72 |
1280338 | 1280338 | 2021-05-02 | Morris | Texas | 48343 | 865 | 33 |
1280339 | 1280339 | 2021-05-02 | Motley | Texas | 48345 | 115 | 8 |
1280340 | 1280340 | 2021-05-02 | Nacogdoches | Texas | 48347 | 4513 | 168 |
1280341 | 1280341 | 2021-05-02 | Navarro | Texas | 48349 | 5781 | 154 |
1280342 | 1280342 | 2021-05-02 | Newton | Texas | 48351 | 620 | 35 |
1280343 | 1280343 | 2021-05-02 | Nolan | Texas | 48353 | 1532 | 51 |
1280344 | 1280344 | 2021-05-02 | Nueces | Texas | 48355 | 38686 | 775 |
1280345 | 1280345 | 2021-05-02 | Ochiltree | Texas | 48357 | 1141 | 27 |
1280346 | 1280346 | 2021-05-02 | Oldham | Texas | 48359 | 268 | 4 |
1280347 | 1280347 | 2021-05-02 | Orange | Texas | 48361 | 8416 | 146 |
1280348 | 1280348 | 2021-05-02 | Palo Pinto | Texas | 48363 | 2890 | 75 |
1280349 | 1280349 | 2021-05-02 | Panola | Texas | 48365 | 1600 | 74 |
1280350 | 1280350 | 2021-05-02 | Parker | Texas | 48367 | 15615 | 180 |
1280351 | 1280351 | 2021-05-02 | Parmer | Texas | 48369 | 1268 | 36 |
1280352 | 1280352 | 2021-05-02 | Pecos | Texas | 48371 | 1658 | 34 |
1280353 | 1280353 | 2021-05-02 | Polk | Texas | 48373 | 3282 | 112 |
1280354 | 1280354 | 2021-05-02 | Potter | Texas | 48375 | 17312 | 446 |
1280355 | 1280355 | 2021-05-02 | Presidio | Texas | 48377 | 817 | 24 |
1280356 | 1280356 | 2021-05-02 | Rains | Texas | 48379 | 797 | 25 |
1280357 | 1280357 | 2021-05-02 | Randall | Texas | 48381 | 16678 | 294 |
1280358 | 1280358 | 2021-05-02 | Reagan | Texas | 48383 | 380 | 8 |
1280359 | 1280359 | 2021-05-02 | Real | Texas | 48385 | 311 | 12 |
1280360 | 1280360 | 2021-05-02 | Red River | Texas | 48387 | 691 | 37 |
1280361 | 1280361 | 2021-05-02 | Reeves | Texas | 48389 | 1736 | 43 |
1280362 | 1280362 | 2021-05-02 | Refugio | Texas | 48391 | 661 | 21 |
1280363 | 1280363 | 2021-05-02 | Roberts | Texas | 48393 | 61 | 1 |
1280364 | 1280364 | 2021-05-02 | Robertson | Texas | 48395 | 2117 | 40 |
1280365 | 1280365 | 2021-05-02 | Rockwall | Texas | 48397 | 11446 | 155 |
1280366 | 1280366 | 2021-05-02 | Runnels | Texas | 48399 | 1286 | 37 |
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);