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 150
- 48157 129
- 48201 128
- 48085 124
- 48339 124
- 48439 124
- 48113 123
- 48183 122
- 48423 121
- 48453 121
- 48027 120
- 48141 120
- 48167 120
- 48209 120
- 48039 119
- 48121 118
- 48321 118
- 48037 117
- 48303 117
- 48041 116
- 48139 116
- 48285 116
- 48309 116
- 48325 116
- 48401 116
- 48479 116
- 48485 116
- 48491 116
- 48251 115
- 48467 115
- …
county >30
- Bexar 150
- Fort Bend 129
- Harris 128
- Collin 124
- Montgomery 124
- Tarrant 124
- Dallas 123
- Gregg 122
- Smith 121
- Travis 121
- Bell 120
- El Paso 120
- Galveston 120
- Hays 120
- Brazoria 119
- Denton 118
- Matagorda 118
- Bowie 117
- Lubbock 117
- Brazos 116
- Ellis 116
- Lavaca 116
- McLennan 116
- Medina 116
- Rusk 116
- Webb 116
- Wichita 116
- Williamson 116
- Johnson 115
- Van Zandt 115
- …
state 1
- Texas · 23,296 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324559 | 324559 | 2020-07-11 | Harrison | Texas | 48203 | 401 | 31 |
324560 | 324560 | 2020-07-11 | Hartley | Texas | 48205 | 55 | 2 |
324561 | 324561 | 2020-07-11 | Haskell | Texas | 48207 | 6 | 0 |
324562 | 324562 | 2020-07-11 | Hays | Texas | 48209 | 3534 | 11 |
324563 | 324563 | 2020-07-11 | Hemphill | Texas | 48211 | 20 | 0 |
324564 | 324564 | 2020-07-11 | Henderson | Texas | 48213 | 256 | 4 |
324565 | 324565 | 2020-07-11 | Hidalgo | Texas | 48215 | 7669 | 142 |
324566 | 324566 | 2020-07-11 | Hill | Texas | 48217 | 143 | 2 |
324567 | 324567 | 2020-07-11 | Hockley | Texas | 48219 | 108 | 1 |
324568 | 324568 | 2020-07-11 | Hood | Texas | 48221 | 185 | 5 |
324569 | 324569 | 2020-07-11 | Hopkins | Texas | 48223 | 79 | 0 |
324570 | 324570 | 2020-07-11 | Houston | Texas | 48225 | 176 | 0 |
324571 | 324571 | 2020-07-11 | Howard | Texas | 48227 | 67 | 1 |
324572 | 324572 | 2020-07-11 | Hudspeth | Texas | 48229 | 17 | 0 |
324573 | 324573 | 2020-07-11 | Hunt | Texas | 48231 | 697 | 8 |
324574 | 324574 | 2020-07-11 | Hutchinson | Texas | 48233 | 73 | 0 |
324575 | 324575 | 2020-07-11 | Irion | Texas | 48235 | 3 | 0 |
324576 | 324576 | 2020-07-11 | Jack | Texas | 48237 | 12 | 0 |
324577 | 324577 | 2020-07-11 | Jackson | Texas | 48239 | 89 | 1 |
324578 | 324578 | 2020-07-11 | Jasper | Texas | 48241 | 70 | 2 |
324579 | 324579 | 2020-07-11 | Jeff Davis | Texas | 48243 | 5 | 0 |
324580 | 324580 | 2020-07-11 | Jefferson | Texas | 48245 | 3532 | 39 |
324581 | 324581 | 2020-07-11 | Jim Hogg | Texas | 48247 | 32 | 0 |
324582 | 324582 | 2020-07-11 | Jim Wells | Texas | 48249 | 261 | 0 |
324583 | 324583 | 2020-07-11 | Johnson | Texas | 48251 | 788 | 4 |
324584 | 324584 | 2020-07-11 | Jones | Texas | 48253 | 604 | 0 |
324585 | 324585 | 2020-07-11 | Karnes | Texas | 48255 | 80 | 0 |
324586 | 324586 | 2020-07-11 | Kaufman | Texas | 48257 | 971 | 5 |
324587 | 324587 | 2020-07-11 | Kendall | Texas | 48259 | 101 | 0 |
324588 | 324588 | 2020-07-11 | Kenedy | Texas | 48261 | 1 | 0 |
324589 | 324589 | 2020-07-11 | Kerr | Texas | 48265 | 143 | 1 |
324590 | 324590 | 2020-07-11 | Kimble | Texas | 48267 | 9 | 0 |
324591 | 324591 | 2020-07-11 | Kinney | Texas | 48271 | 3 | 0 |
324592 | 324592 | 2020-07-11 | Kleberg | Texas | 48273 | 159 | 1 |
324593 | 324593 | 2020-07-11 | Knox | Texas | 48275 | 6 | 0 |
324594 | 324594 | 2020-07-11 | La Salle | Texas | 48283 | 76 | 0 |
324595 | 324595 | 2020-07-11 | Lamar | Texas | 48277 | 392 | 14 |
324596 | 324596 | 2020-07-11 | Lamb | Texas | 48279 | 75 | 0 |
324597 | 324597 | 2020-07-11 | Lampasas | Texas | 48281 | 39 | 0 |
324598 | 324598 | 2020-07-11 | Lavaca | Texas | 48285 | 238 | 1 |
324599 | 324599 | 2020-07-11 | Lee | Texas | 48287 | 92 | 3 |
324600 | 324600 | 2020-07-11 | Leon | Texas | 48289 | 96 | 0 |
324601 | 324601 | 2020-07-11 | Liberty | Texas | 48291 | 508 | 3 |
324602 | 324602 | 2020-07-11 | Limestone | Texas | 48293 | 102 | 1 |
324603 | 324603 | 2020-07-11 | Lipscomb | Texas | 48295 | 11 | 0 |
324604 | 324604 | 2020-07-11 | Live Oak | Texas | 48297 | 65 | 0 |
324605 | 324605 | 2020-07-11 | Llano | Texas | 48299 | 34 | 0 |
324606 | 324606 | 2020-07-11 | Lubbock | Texas | 48303 | 3668 | 60 |
324607 | 324607 | 2020-07-11 | Lynn | Texas | 48305 | 53 | 1 |
324608 | 324608 | 2020-07-11 | Madison | Texas | 48313 | 107 | 0 |
324609 | 324609 | 2020-07-11 | Marion | Texas | 48315 | 37 | 1 |
324610 | 324610 | 2020-07-11 | Martin | Texas | 48317 | 25 | 1 |
324611 | 324611 | 2020-07-11 | Mason | Texas | 48319 | 35 | 0 |
324612 | 324612 | 2020-07-11 | Matagorda | Texas | 48321 | 348 | 5 |
324613 | 324613 | 2020-07-11 | Maverick | Texas | 48323 | 776 | 7 |
324614 | 324614 | 2020-07-11 | McCulloch | Texas | 48307 | 23 | 0 |
324615 | 324615 | 2020-07-11 | McLennan | Texas | 48309 | 2537 | 16 |
324616 | 324616 | 2020-07-11 | Medina | Texas | 48325 | 343 | 3 |
324617 | 324617 | 2020-07-11 | Menard | Texas | 48327 | 14 | 0 |
324618 | 324618 | 2020-07-11 | Midland | Texas | 48329 | 1104 | 19 |
324619 | 324619 | 2020-07-11 | Milam | Texas | 48331 | 149 | 1 |
324620 | 324620 | 2020-07-11 | Mills | Texas | 48333 | 7 | 0 |
324621 | 324621 | 2020-07-11 | Mitchell | Texas | 48335 | 25 | 0 |
324622 | 324622 | 2020-07-11 | Montague | Texas | 48337 | 26 | 1 |
324623 | 324623 | 2020-07-11 | Montgomery | Texas | 48339 | 3007 | 41 |
324624 | 324624 | 2020-07-11 | Moore | Texas | 48341 | 916 | 15 |
324625 | 324625 | 2020-07-11 | Morris | Texas | 48343 | 48 | 0 |
324626 | 324626 | 2020-07-11 | Motley | Texas | 48345 | 2 | 0 |
324627 | 324627 | 2020-07-11 | Nacogdoches | Texas | 48347 | 554 | 31 |
324628 | 324628 | 2020-07-11 | Navarro | Texas | 48349 | 493 | 7 |
324629 | 324629 | 2020-07-11 | Newton | Texas | 48351 | 12 | 0 |
324630 | 324630 | 2020-07-11 | Nolan | Texas | 48353 | 70 | 0 |
324631 | 324631 | 2020-07-11 | Nueces | Texas | 48355 | 5965 | 50 |
324632 | 324632 | 2020-07-11 | Ochiltree | Texas | 48357 | 63 | 2 |
324633 | 324633 | 2020-07-11 | Oldham | Texas | 48359 | 4 | 1 |
324634 | 324634 | 2020-07-11 | Orange | Texas | 48361 | 498 | 5 |
324635 | 324635 | 2020-07-11 | Palo Pinto | Texas | 48363 | 61 | 2 |
324636 | 324636 | 2020-07-11 | Panola | Texas | 48365 | 228 | 24 |
324637 | 324637 | 2020-07-11 | Parker | Texas | 48367 | 556 | 1 |
324638 | 324638 | 2020-07-11 | Parmer | Texas | 48369 | 236 | 8 |
324639 | 324639 | 2020-07-11 | Pecos | Texas | 48371 | 139 | 1 |
324640 | 324640 | 2020-07-11 | Polk | Texas | 48373 | 321 | 0 |
324641 | 324641 | 2020-07-11 | Potter | Texas | 48375 | 3048 | 39 |
324642 | 324642 | 2020-07-11 | Presidio | Texas | 48377 | 26 | 0 |
324643 | 324643 | 2020-07-11 | Rains | Texas | 48379 | 17 | 0 |
324644 | 324644 | 2020-07-11 | Randall | Texas | 48381 | 1045 | 7 |
324645 | 324645 | 2020-07-11 | Reagan | Texas | 48383 | 31 | 0 |
324646 | 324646 | 2020-07-11 | Real | Texas | 48385 | 6 | 0 |
324647 | 324647 | 2020-07-11 | Red River | Texas | 48387 | 119 | 12 |
324648 | 324648 | 2020-07-11 | Reeves | Texas | 48389 | 77 | 1 |
324649 | 324649 | 2020-07-11 | Refugio | Texas | 48391 | 43 | 0 |
324650 | 324650 | 2020-07-11 | Roberts | Texas | 48393 | 6 | 0 |
324651 | 324651 | 2020-07-11 | Robertson | Texas | 48395 | 111 | 0 |
324652 | 324652 | 2020-07-11 | Rockwall | Texas | 48397 | 433 | 17 |
324653 | 324653 | 2020-07-11 | Runnels | Texas | 48399 | 24 | 0 |
324654 | 324654 | 2020-07-11 | Rusk | Texas | 48401 | 251 | 3 |
324655 | 324655 | 2020-07-11 | Sabine | Texas | 48403 | 31 | 1 |
324656 | 324656 | 2020-07-11 | San Augustine | Texas | 48405 | 126 | 9 |
324657 | 324657 | 2020-07-11 | San Jacinto | Texas | 48407 | 63 | 0 |
324658 | 324658 | 2020-07-11 | San Patricio | Texas | 48409 | 310 | 0 |
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);