ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where cases = 225 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Red River 5
- Trinity 5
- Sherman 4
- Culberson 3
- Andrews 2
- Brazoria 2
- Colorado 2
- Frio 2
- San Jacinto 2
- Armstrong 1
- Brewster 1
- Cass 1
- Coryell 1
- Donley 1
- Ector 1
- El Paso 1
- Franklin 1
- Gaines 1
- Hansford 1
- Henderson 1
- Hidalgo 1
- Kerr 1
- Leon 1
- McCulloch 1
- Montague 1
- Schleicher 1
- Somervell 1
- Stephens 1
- Throckmorton 1
- Upton 1
- …
state 1
- Texas · 49 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2124986 | 2124986 | 2022-01-17 | Throckmorton | Texas | 48447 | 225 | 7 |
1604832 | 1604832 | 2021-08-10 | Armstrong | Texas | 48011 | 225 | 7 |
1306348 | 1306348 | 2021-05-10 | Sherman | Texas | 48421 | 225 | 12 |
1303102 | 1303102 | 2021-05-09 | Sherman | Texas | 48421 | 225 | 12 |
1299855 | 1299855 | 2021-05-08 | Sherman | Texas | 48421 | 225 | 12 |
1296608 | 1296608 | 2021-05-07 | Sherman | Texas | 48421 | 225 | 12 |
1027121 | 1027121 | 2021-02-13 | Schleicher | Texas | 48413 | 225 | 6 |
854973 | 854973 | 2020-12-22 | Donley | Texas | 48129 | 225 | 6 |
838913 | 838913 | 2020-12-17 | Upton | Texas | 48461 | 225 | 6 |
790053 | 790053 | 2020-12-02 | Culberson | Texas | 48109 | 225 | 3 |
786808 | 786808 | 2020-12-01 | Culberson | Texas | 48109 | 225 | 3 |
783564 | 783564 | 2020-11-30 | Culberson | Texas | 48109 | 225 | 3 |
783703 | 783703 | 2020-11-30 | Red River | Texas | 48387 | 225 | 18 |
780458 | 780458 | 2020-11-29 | Red River | Texas | 48387 | 225 | 18 |
777212 | 777212 | 2020-11-28 | Red River | Texas | 48387 | 225 | 18 |
773967 | 773967 | 2020-11-27 | Red River | Texas | 48387 | 225 | 18 |
770722 | 770722 | 2020-11-26 | Red River | Texas | 48387 | 225 | 18 |
761020 | 761020 | 2020-11-23 | Trinity | Texas | 48455 | 225 | 8 |
757775 | 757775 | 2020-11-22 | Trinity | Texas | 48455 | 225 | 8 |
754528 | 754528 | 2020-11-21 | Trinity | Texas | 48455 | 225 | 8 |
751267 | 751267 | 2020-11-20 | Somervell | Texas | 48425 | 225 | 5 |
751269 | 751269 | 2020-11-20 | Stephens | Texas | 48429 | 225 | 7 |
751282 | 751282 | 2020-11-20 | Trinity | Texas | 48455 | 225 | 8 |
747906 | 747906 | 2020-11-19 | Hansford | Texas | 48195 | 225 | 9 |
748036 | 748036 | 2020-11-19 | Trinity | Texas | 48455 | 225 | 8 |
702546 | 702546 | 2020-11-05 | McCulloch | Texas | 48307 | 225 | 5 |
692738 | 692738 | 2020-11-02 | Franklin | Texas | 48159 | 225 | 7 |
637672 | 637672 | 2020-10-16 | Montague | Texas | 48337 | 225 | 4 |
614822 | 614822 | 2020-10-09 | Brewster | Texas | 48043 | 225 | 5 |
563137 | 563137 | 2020-09-23 | San Jacinto | Texas | 48407 | 225 | 9 |
556662 | 556662 | 2020-09-21 | San Jacinto | Texas | 48407 | 225 | 9 |
540416 | 540416 | 2020-09-16 | Leon | Texas | 48289 | 225 | 5 |
462694 | 462694 | 2020-08-23 | Cass | Texas | 48067 | 225 | 9 |
456287 | 456287 | 2020-08-21 | Gaines | Texas | 48165 | 225 | 5 |
372456 | 372456 | 2020-07-26 | Andrews | Texas | 48003 | 225 | 4 |
372498 | 372498 | 2020-07-26 | Colorado | Texas | 48089 | 225 | 1 |
369244 | 369244 | 2020-07-25 | Andrews | Texas | 48003 | 225 | 4 |
369286 | 369286 | 2020-07-25 | Colorado | Texas | 48089 | 225 | 0 |
366279 | 366279 | 2020-07-24 | Wood | Texas | 48499 | 225 | 6 |
343742 | 343742 | 2020-07-17 | Kerr | Texas | 48265 | 225 | 1 |
318204 | 318204 | 2020-07-09 | Henderson | Texas | 48213 | 225 | 4 |
299167 | 299167 | 2020-07-03 | Frio | Texas | 48163 | 225 | 0 |
296007 | 296007 | 2020-07-02 | Frio | Texas | 48163 | 225 | 0 |
220984 | 220984 | 2020-06-08 | Ector | Texas | 48135 | 225 | 6 |
162766 | 162766 | 2020-05-20 | Coryell | Texas | 48099 | 225 | 2 |
64167 | 64167 | 2020-04-16 | Hidalgo | Texas | 48215 | 225 | 3 |
53264 | 53264 | 2020-04-12 | Brazoria | Texas | 48039 | 225 | 2 |
50589 | 50589 | 2020-04-11 | Brazoria | Texas | 48039 | 225 | 2 |
45347 | 45347 | 2020-04-09 | El Paso | Texas | 48141 | 225 | 1 |
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);