ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where cases = 386 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Reagan 13
- Hardeman 12
- Kinney 4
- San Saba 4
- Dallam 3
- Freestone 3
- Haskell 3
- La Salle 3
- Mason 3
- Collingsworth 2
- Culberson 2
- Donley 2
- Lipscomb 2
- Oldham 2
- Panola 2
- Zapata 2
- Andrews 1
- Archer 1
- Bastrop 1
- Comanche 1
- Fisher 1
- Gray 1
- Hartley 1
- Kimble 1
- Mitchell 1
- Parmer 1
- Robertson 1
- Sutton 1
- Taylor 1
- Upton 1
- …
state 1
- Texas · 78 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2007912 | 2007912 | 2021-12-12 | Oldham | Texas | 48359 | 386 | 6 |
2004661 | 2004661 | 2021-12-11 | Oldham | Texas | 48359 | 386 | 6 |
1842129 | 1842129 | 2021-10-22 | Lipscomb | Texas | 48295 | 386 | 12 |
1838880 | 1838880 | 2021-10-21 | Lipscomb | Texas | 48295 | 386 | 12 |
1822542 | 1822542 | 2021-10-16 | Culberson | Texas | 48109 | 386 | 11 |
1819293 | 1819293 | 2021-10-15 | Culberson | Texas | 48109 | 386 | 11 |
1816033 | 1816033 | 2021-10-14 | Collingsworth | Texas | 48087 | 386 | 11 |
1812785 | 1812785 | 2021-10-13 | Collingsworth | Texas | 48087 | 386 | 11 |
1718592 | 1718592 | 2021-09-14 | Fisher | Texas | 48151 | 386 | 16 |
1702412 | 1702412 | 2021-09-09 | Kimble | Texas | 48267 | 386 | 11 |
1669926 | 1669926 | 2021-08-30 | Kinney | Texas | 48271 | 386 | 7 |
1666679 | 1666679 | 2021-08-29 | Kinney | Texas | 48271 | 386 | 7 |
1663431 | 1663431 | 2021-08-28 | Kinney | Texas | 48271 | 386 | 7 |
1660183 | 1660183 | 2021-08-27 | Kinney | Texas | 48271 | 386 | 7 |
1562824 | 1562824 | 2021-07-28 | Upton | Texas | 48461 | 386 | 10 |
1556197 | 1556197 | 2021-07-26 | Hardeman | Texas | 48197 | 386 | 12 |
1552950 | 1552950 | 2021-07-25 | Hardeman | Texas | 48197 | 386 | 12 |
1549703 | 1549703 | 2021-07-24 | Hardeman | Texas | 48197 | 386 | 12 |
1546456 | 1546456 | 2021-07-23 | Hardeman | Texas | 48197 | 386 | 12 |
1543209 | 1543209 | 2021-07-22 | Hardeman | Texas | 48197 | 386 | 12 |
1539961 | 1539961 | 2021-07-21 | Hardeman | Texas | 48197 | 386 | 12 |
1536714 | 1536714 | 2021-07-20 | Hardeman | Texas | 48197 | 386 | 12 |
1533466 | 1533466 | 2021-07-19 | Hardeman | Texas | 48197 | 386 | 12 |
1530219 | 1530219 | 2021-07-18 | Hardeman | Texas | 48197 | 386 | 12 |
1526972 | 1526972 | 2021-07-17 | Hardeman | Texas | 48197 | 386 | 12 |
1510829 | 1510829 | 2021-07-12 | Reagan | Texas | 48383 | 386 | 8 |
1507582 | 1507582 | 2021-07-11 | Reagan | Texas | 48383 | 386 | 8 |
1504336 | 1504336 | 2021-07-10 | Reagan | Texas | 48383 | 386 | 8 |
1501090 | 1501090 | 2021-07-09 | Reagan | Texas | 48383 | 386 | 8 |
1497844 | 1497844 | 2021-07-08 | Reagan | Texas | 48383 | 386 | 8 |
1494597 | 1494597 | 2021-07-07 | Reagan | Texas | 48383 | 386 | 8 |
1471871 | 1471871 | 2021-06-30 | Reagan | Texas | 48383 | 386 | 8 |
1468626 | 1468626 | 2021-06-29 | Reagan | Texas | 48383 | 386 | 8 |
1465381 | 1465381 | 2021-06-28 | Reagan | Texas | 48383 | 386 | 8 |
1462136 | 1462136 | 2021-06-27 | Reagan | Texas | 48383 | 386 | 8 |
1458891 | 1458891 | 2021-06-26 | Reagan | Texas | 48383 | 386 | 8 |
1455646 | 1455646 | 2021-06-25 | Reagan | Texas | 48383 | 386 | 8 |
1452308 | 1452308 | 2021-06-24 | Hardeman | Texas | 48197 | 386 | 12 |
1452401 | 1452401 | 2021-06-24 | Reagan | Texas | 48383 | 386 | 8 |
1449062 | 1449062 | 2021-06-23 | Hardeman | Texas | 48197 | 386 | 12 |
1267243 | 1267243 | 2021-04-28 | Donley | Texas | 48129 | 386 | 15 |
1263996 | 1263996 | 2021-04-27 | Donley | Texas | 48129 | 386 | 15 |
1082248 | 1082248 | 2021-03-02 | Mason | Texas | 48319 | 386 | 5 |
1079002 | 1079002 | 2021-03-01 | Mason | Texas | 48319 | 386 | 5 |
1075757 | 1075757 | 2021-02-28 | Mason | Texas | 48319 | 386 | 5 |
994562 | 994562 | 2021-02-03 | Hartley | Texas | 48205 | 386 | 2 |
965352 | 965352 | 2021-01-25 | Haskell | Texas | 48207 | 386 | 17 |
962107 | 962107 | 2021-01-24 | Haskell | Texas | 48207 | 386 | 17 |
958862 | 958862 | 2021-01-23 | Haskell | Texas | 48207 | 386 | 17 |
903805 | 903805 | 2021-01-06 | Sutton | Texas | 48435 | 386 | 6 |
855114 | 855114 | 2020-12-22 | San Saba | Texas | 48411 | 386 | 11 |
851869 | 851869 | 2020-12-21 | San Saba | Texas | 48411 | 386 | 11 |
848624 | 848624 | 2020-12-20 | San Saba | Texas | 48411 | 386 | 11 |
845379 | 845379 | 2020-12-19 | San Saba | Texas | 48411 | 386 | 11 |
819209 | 819209 | 2020-12-11 | Archer | Texas | 48009 | 386 | 2 |
809636 | 809636 | 2020-12-08 | Mitchell | Texas | 48335 | 386 | 7 |
731831 | 731831 | 2020-11-14 | Zapata | Texas | 48505 | 386 | 9 |
728586 | 728586 | 2020-11-13 | Zapata | Texas | 48505 | 386 | 9 |
715501 | 715501 | 2020-11-09 | La Salle | Texas | 48283 | 386 | 14 |
712257 | 712257 | 2020-11-08 | La Salle | Texas | 48283 | 386 | 14 |
709013 | 709013 | 2020-11-07 | La Salle | Texas | 48283 | 386 | 14 |
702434 | 702434 | 2020-11-05 | Comanche | Texas | 48093 | 386 | 5 |
692714 | 692714 | 2020-11-02 | Dallam | Texas | 48111 | 386 | 10 |
689470 | 689470 | 2020-11-01 | Dallam | Texas | 48111 | 386 | 10 |
686225 | 686225 | 2020-10-31 | Dallam | Texas | 48111 | 386 | 10 |
640841 | 640841 | 2020-10-17 | Gray | Texas | 48179 | 386 | 9 |
631211 | 631211 | 2020-10-14 | Robertson | Texas | 48395 | 386 | 4 |
611809 | 611809 | 2020-10-08 | Young | Texas | 48503 | 386 | 6 |
582564 | 582564 | 2020-09-29 | Panola | Texas | 48365 | 386 | 26 |
579325 | 579325 | 2020-09-28 | Panola | Texas | 48365 | 386 | 26 |
514465 | 514465 | 2020-09-08 | Freestone | Texas | 48161 | 386 | 1 |
504767 | 504767 | 2020-09-05 | Freestone | Texas | 48161 | 386 | 1 |
501455 | 501455 | 2020-09-04 | Andrews | Texas | 48003 | 386 | 8 |
495066 | 495066 | 2020-09-02 | Freestone | Texas | 48161 | 386 | 1 |
491934 | 491934 | 2020-09-01 | Parmer | Texas | 48369 | 386 | 7 |
469366 | 469366 | 2020-08-25 | Wood | Texas | 48499 | 386 | 13 |
273893 | 273893 | 2020-06-25 | Bastrop | Texas | 48021 | 386 | 6 |
135839 | 135839 | 2020-05-11 | Taylor | Texas | 48441 | 386 | 6 |
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);