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 385
- 48157 364
- 48201 364
- 48085 359
- 48339 359
- 48439 359
- 48113 358
- 48183 357
- 48423 356
- 48453 356
- 48027 355
- 48141 355
- 48167 355
- 48209 355
- 48039 354
- 48121 353
- 48321 353
- 48037 352
- 48303 352
- 48041 351
- 48139 351
- 48285 351
- 48309 351
- 48325 351
- 48401 351
- 48479 351
- 48485 351
- 48491 351
- 48251 350
- 48467 350
- …
county >30
- Bexar 385
- Fort Bend 364
- Harris 364
- Collin 359
- Montgomery 359
- Tarrant 359
- Dallas 358
- Gregg 357
- Smith 356
- Travis 356
- Bell 355
- El Paso 355
- Galveston 355
- Hays 355
- Brazoria 354
- Denton 353
- Matagorda 353
- Bowie 352
- Lubbock 352
- Brazos 351
- Ellis 351
- Lavaca 351
- McLennan 351
- Medina 351
- Rusk 351
- Webb 351
- Wichita 351
- Williamson 351
- Johnson 350
- Van Zandt 350
- …
state 1
- Texas · 82,650 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1085438 | 1085438 | 2021-03-03 | Harris | Texas | 48201 | 355065 | 5155 |
1085439 | 1085439 | 2021-03-03 | Harrison | Texas | 48203 | 4566 | 95 |
1085440 | 1085440 | 2021-03-03 | Hartley | Texas | 48205 | 498 | 2 |
1085441 | 1085441 | 2021-03-03 | Haskell | Texas | 48207 | 432 | 23 |
1085442 | 1085442 | 2021-03-03 | Hays | Texas | 48209 | 18244 | 224 |
1085443 | 1085443 | 2021-03-03 | Hemphill | Texas | 48211 | 544 | 2 |
1085444 | 1085444 | 2021-03-03 | Henderson | Texas | 48213 | 5579 | 164 |
1085445 | 1085445 | 2021-03-03 | Hidalgo | Texas | 48215 | 77003 | 2655 |
1085446 | 1085446 | 2021-03-03 | Hill | Texas | 48217 | 4313 | 96 |
1085447 | 1085447 | 2021-03-03 | Hockley | Texas | 48219 | 2332 | 99 |
1085448 | 1085448 | 2021-03-03 | Hood | Texas | 48221 | 6220 | 114 |
1085449 | 1085449 | 2021-03-03 | Hopkins | Texas | 48223 | 2939 | 103 |
1085450 | 1085450 | 2021-03-03 | Houston | Texas | 48225 | 1549 | 42 |
1085451 | 1085451 | 2021-03-03 | Howard | Texas | 48227 | 4498 | 98 |
1085452 | 1085452 | 2021-03-03 | Hudspeth | Texas | 48229 | 499 | 11 |
1085453 | 1085453 | 2021-03-03 | Hunt | Texas | 48231 | 5255 | 148 |
1085454 | 1085454 | 2021-03-03 | Hutchinson | Texas | 48233 | 1536 | 69 |
1085455 | 1085455 | 2021-03-03 | Irion | Texas | 48235 | 114 | 1 |
1085456 | 1085456 | 2021-03-03 | Jack | Texas | 48237 | 600 | 15 |
1085457 | 1085457 | 2021-03-03 | Jackson | Texas | 48239 | 1696 | 30 |
1085458 | 1085458 | 2021-03-03 | Jasper | Texas | 48241 | 2304 | 77 |
1085459 | 1085459 | 2021-03-03 | Jeff Davis | Texas | 48243 | 187 | 2 |
1085460 | 1085460 | 2021-03-03 | Jefferson | Texas | 48245 | 18267 | 351 |
1085461 | 1085461 | 2021-03-03 | Jim Hogg | Texas | 48247 | 604 | 14 |
1085462 | 1085462 | 2021-03-03 | Jim Wells | Texas | 48249 | 3953 | 86 |
1085463 | 1085463 | 2021-03-03 | Johnson | Texas | 48251 | 18655 | 323 |
1085464 | 1085464 | 2021-03-03 | Jones | Texas | 48253 | 2742 | 50 |
1085465 | 1085465 | 2021-03-03 | Karnes | Texas | 48255 | 1789 | 31 |
1085466 | 1085466 | 2021-03-03 | Kaufman | Texas | 48257 | 14871 | 220 |
1085467 | 1085467 | 2021-03-03 | Kendall | Texas | 48259 | 2985 | 61 |
1085468 | 1085468 | 2021-03-03 | Kenedy | Texas | 48261 | 33 | 2 |
1085469 | 1085469 | 2021-03-03 | Kent | Texas | 48263 | 78 | 1 |
1085470 | 1085470 | 2021-03-03 | Kerr | Texas | 48265 | 4213 | 82 |
1085471 | 1085471 | 2021-03-03 | Kimble | Texas | 48267 | 258 | 6 |
1085472 | 1085472 | 2021-03-03 | King | Texas | 48269 | 11 | 0 |
1085473 | 1085473 | 2021-03-03 | Kinney | Texas | 48271 | 338 | 6 |
1085474 | 1085474 | 2021-03-03 | Kleberg | Texas | 48273 | 2380 | 84 |
1085475 | 1085475 | 2021-03-03 | Knox | Texas | 48275 | 254 | 15 |
1085476 | 1085476 | 2021-03-03 | La Salle | Texas | 48283 | 997 | 22 |
1085477 | 1085477 | 2021-03-03 | Lamar | Texas | 48277 | 5665 | 146 |
1085478 | 1085478 | 2021-03-03 | Lamb | Texas | 48279 | 1971 | 79 |
1085479 | 1085479 | 2021-03-03 | Lampasas | Texas | 48281 | 2061 | 30 |
1085480 | 1085480 | 2021-03-03 | Lavaca | Texas | 48285 | 2292 | 72 |
1085481 | 1085481 | 2021-03-03 | Lee | Texas | 48287 | 2022 | 36 |
1085482 | 1085482 | 2021-03-03 | Leon | Texas | 48289 | 1541 | 38 |
1085483 | 1085483 | 2021-03-03 | Liberty | Texas | 48291 | 7047 | 162 |
1085484 | 1085484 | 2021-03-03 | Limestone | Texas | 48293 | 2645 | 63 |
1085485 | 1085485 | 2021-03-03 | Lipscomb | Texas | 48295 | 297 | 11 |
1085486 | 1085486 | 2021-03-03 | Live Oak | Texas | 48297 | 1109 | 20 |
1085487 | 1085487 | 2021-03-03 | Llano | Texas | 48299 | 1521 | 48 |
1085488 | 1085488 | 2021-03-03 | Loving | Texas | 48301 | 1 | 0 |
1085489 | 1085489 | 2021-03-03 | Lubbock | Texas | 48303 | 48196 | 770 |
1085490 | 1085490 | 2021-03-03 | Lynn | Texas | 48305 | 607 | 23 |
1085491 | 1085491 | 2021-03-03 | Madison | Texas | 48313 | 1878 | 27 |
1085492 | 1085492 | 2021-03-03 | Marion | Texas | 48315 | 520 | 28 |
1085493 | 1085493 | 2021-03-03 | Martin | Texas | 48317 | 615 | 18 |
1085494 | 1085494 | 2021-03-03 | Mason | Texas | 48319 | 389 | 5 |
1085495 | 1085495 | 2021-03-03 | Matagorda | Texas | 48321 | 3183 | 89 |
1085496 | 1085496 | 2021-03-03 | Maverick | Texas | 48323 | 10216 | 308 |
1085497 | 1085497 | 2021-03-03 | McCulloch | Texas | 48307 | 544 | 17 |
1085498 | 1085498 | 2021-03-03 | McLennan | Texas | 48309 | 25237 | 440 |
1085499 | 1085499 | 2021-03-03 | McMullen | Texas | 48311 | 82 | 5 |
1085500 | 1085500 | 2021-03-03 | Medina | Texas | 48325 | 4628 | 97 |
1085501 | 1085501 | 2021-03-03 | Menard | Texas | 48327 | 206 | 9 |
1085502 | 1085502 | 2021-03-03 | Midland | Texas | 48329 | 16236 | 247 |
1085503 | 1085503 | 2021-03-03 | Milam | Texas | 48331 | 2357 | 40 |
1085504 | 1085504 | 2021-03-03 | Mills | Texas | 48333 | 631 | 20 |
1085505 | 1085505 | 2021-03-03 | Mitchell | Texas | 48335 | 585 | 30 |
1085506 | 1085506 | 2021-03-03 | Montague | Texas | 48337 | 2010 | 65 |
1085507 | 1085507 | 2021-03-03 | Montgomery | Texas | 48339 | 45872 | 459 |
1085508 | 1085508 | 2021-03-03 | Moore | Texas | 48341 | 2248 | 69 |
1085509 | 1085509 | 2021-03-03 | Morris | Texas | 48343 | 835 | 28 |
1085510 | 1085510 | 2021-03-03 | Motley | Texas | 48345 | 85 | 8 |
1085511 | 1085511 | 2021-03-03 | Nacogdoches | Texas | 48347 | 4128 | 151 |
1085512 | 1085512 | 2021-03-03 | Navarro | Texas | 48349 | 5595 | 133 |
1085513 | 1085513 | 2021-03-03 | Newton | Texas | 48351 | 571 | 30 |
1085514 | 1085514 | 2021-03-03 | Nolan | Texas | 48353 | 1496 | 50 |
1085515 | 1085515 | 2021-03-03 | Nueces | Texas | 48355 | 35951 | 718 |
1085516 | 1085516 | 2021-03-03 | Ochiltree | Texas | 48357 | 1031 | 25 |
1085517 | 1085517 | 2021-03-03 | Oldham | Texas | 48359 | 242 | 4 |
1085518 | 1085518 | 2021-03-03 | Orange | Texas | 48361 | 7587 | 113 |
1085519 | 1085519 | 2021-03-03 | Palo Pinto | Texas | 48363 | 2774 | 67 |
1085520 | 1085520 | 2021-03-03 | Panola | Texas | 48365 | 1504 | 69 |
1085521 | 1085521 | 2021-03-03 | Parker | Texas | 48367 | 14849 | 164 |
1085522 | 1085522 | 2021-03-03 | Parmer | Texas | 48369 | 1172 | 34 |
1085523 | 1085523 | 2021-03-03 | Pecos | Texas | 48371 | 1521 | 34 |
1085524 | 1085524 | 2021-03-03 | Polk | Texas | 48373 | 2975 | 98 |
1085525 | 1085525 | 2021-03-03 | Potter | Texas | 48375 | 16931 | 410 |
1085526 | 1085526 | 2021-03-03 | Presidio | Texas | 48377 | 789 | 24 |
1085527 | 1085527 | 2021-03-03 | Rains | Texas | 48379 | 763 | 24 |
1085528 | 1085528 | 2021-03-03 | Randall | Texas | 48381 | 16241 | 277 |
1085529 | 1085529 | 2021-03-03 | Reagan | Texas | 48383 | 367 | 8 |
1085530 | 1085530 | 2021-03-03 | Real | Texas | 48385 | 307 | 12 |
1085531 | 1085531 | 2021-03-03 | Red River | Texas | 48387 | 650 | 35 |
1085532 | 1085532 | 2021-03-03 | Reeves | Texas | 48389 | 1710 | 39 |
1085533 | 1085533 | 2021-03-03 | Refugio | Texas | 48391 | 622 | 17 |
1085534 | 1085534 | 2021-03-03 | Roberts | Texas | 48393 | 55 | 1 |
1085535 | 1085535 | 2021-03-03 | Robertson | Texas | 48395 | 2015 | 38 |
1085536 | 1085536 | 2021-03-03 | Rockwall | Texas | 48397 | 10636 | 129 |
1085537 | 1085537 | 2021-03-03 | Runnels | Texas | 48399 | 1254 | 36 |
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);