ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where cases = 79 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2248497 | 2248497 | 2022-02-24 | Kenedy | Texas | 48261 | 79 | 2 |
2245246 | 2245246 | 2022-02-23 | Kenedy | Texas | 48261 | 79 | 2 |
1699226 | 1699226 | 2021-09-08 | Roberts | Texas | 48393 | 79 | 1 |
1695978 | 1695978 | 2021-09-07 | Roberts | Texas | 48393 | 79 | 1 |
1692730 | 1692730 | 2021-09-06 | Roberts | Texas | 48393 | 79 | 1 |
1689481 | 1689481 | 2021-09-05 | Roberts | Texas | 48393 | 79 | 1 |
1686231 | 1686231 | 2021-09-04 | Roberts | Texas | 48393 | 79 | 1 |
1682980 | 1682980 | 2021-09-03 | Roberts | Texas | 48393 | 79 | 1 |
1650528 | 1650528 | 2021-08-24 | Throckmorton | Texas | 48447 | 79 | 5 |
1549826 | 1549826 | 2021-07-24 | Terrell | Texas | 48443 | 79 | 2 |
1257659 | 1257659 | 2021-04-25 | Terrell | Texas | 48443 | 79 | 2 |
1101700 | 1101700 | 2021-03-08 | Kent | Texas | 48263 | 79 | 1 |
1098454 | 1098454 | 2021-03-07 | Kent | Texas | 48263 | 79 | 1 |
1095206 | 1095206 | 2021-03-06 | Kent | Texas | 48263 | 79 | 1 |
1091960 | 1091960 | 2021-03-05 | Kent | Texas | 48263 | 79 | 1 |
1088714 | 1088714 | 2021-03-04 | Kent | Texas | 48263 | 79 | 1 |
1040059 | 1040059 | 2021-02-17 | McMullen | Texas | 48311 | 79 | 4 |
1036814 | 1036814 | 2021-02-16 | McMullen | Texas | 48311 | 79 | 4 |
1033569 | 1033569 | 2021-02-15 | McMullen | Texas | 48311 | 79 | 4 |
1030323 | 1030323 | 2021-02-14 | McMullen | Texas | 48311 | 79 | 4 |
1027076 | 1027076 | 2021-02-13 | McMullen | Texas | 48311 | 79 | 4 |
1023831 | 1023831 | 2021-02-12 | McMullen | Texas | 48311 | 79 | 4 |
1001173 | 1001173 | 2021-02-05 | Terrell | Texas | 48443 | 79 | 2 |
997927 | 997927 | 2021-02-04 | Terrell | Texas | 48443 | 79 | 2 |
994681 | 994681 | 2021-02-03 | Terrell | Texas | 48443 | 79 | 2 |
971959 | 971959 | 2021-01-27 | Terrell | Texas | 48443 | 79 | 2 |
968714 | 968714 | 2021-01-26 | Terrell | Texas | 48443 | 79 | 2 |
955685 | 955685 | 2021-01-22 | Motley | Texas | 48345 | 79 | 7 |
952440 | 952440 | 2021-01-21 | Motley | Texas | 48345 | 79 | 7 |
949195 | 949195 | 2021-01-20 | Motley | Texas | 48345 | 79 | 7 |
945949 | 945949 | 2021-01-19 | Motley | Texas | 48345 | 79 | 7 |
942702 | 942702 | 2021-01-18 | Motley | Texas | 48345 | 79 | 6 |
939402 | 939402 | 2021-01-17 | Irion | Texas | 48235 | 79 | 1 |
939457 | 939457 | 2021-01-17 | Motley | Texas | 48345 | 79 | 6 |
936212 | 936212 | 2021-01-16 | Motley | Texas | 48345 | 79 | 6 |
932967 | 932967 | 2021-01-15 | Motley | Texas | 48345 | 79 | 6 |
929722 | 929722 | 2021-01-14 | Motley | Texas | 48345 | 79 | 6 |
926477 | 926477 | 2021-01-13 | Motley | Texas | 48345 | 79 | 5 |
923231 | 923231 | 2021-01-12 | Motley | Texas | 48345 | 79 | 5 |
919986 | 919986 | 2021-01-11 | Motley | Texas | 48345 | 79 | 5 |
916741 | 916741 | 2021-01-10 | Motley | Texas | 48345 | 79 | 5 |
913496 | 913496 | 2021-01-09 | Motley | Texas | 48345 | 79 | 5 |
910251 | 910251 | 2021-01-08 | Motley | Texas | 48345 | 79 | 5 |
907006 | 907006 | 2021-01-07 | Motley | Texas | 48345 | 79 | 5 |
767378 | 767378 | 2020-11-25 | Hall | Texas | 48191 | 79 | 3 |
754434 | 754434 | 2020-11-21 | Kimble | Texas | 48267 | 79 | 2 |
751188 | 751188 | 2020-11-20 | Kimble | Texas | 48267 | 79 | 2 |
741384 | 741384 | 2020-11-17 | Edwards | Texas | 48137 | 79 | 2 |
738138 | 738138 | 2020-11-16 | Edwards | Texas | 48137 | 79 | 2 |
734894 | 734894 | 2020-11-15 | Edwards | Texas | 48137 | 79 | 2 |
731648 | 731648 | 2020-11-14 | Edwards | Texas | 48137 | 79 | 2 |
712254 | 712254 | 2020-11-08 | Kinney | Texas | 48271 | 79 | 1 |
709010 | 709010 | 2020-11-07 | Kinney | Texas | 48271 | 79 | 1 |
705766 | 705766 | 2020-11-06 | Kinney | Texas | 48271 | 79 | 1 |
702523 | 702523 | 2020-11-05 | Kinney | Texas | 48271 | 79 | 1 |
699280 | 699280 | 2020-11-04 | Kinney | Texas | 48271 | 79 | 1 |
699354 | 699354 | 2020-11-04 | Sherman | Texas | 48421 | 79 | 1 |
696036 | 696036 | 2020-11-03 | Kinney | Texas | 48271 | 79 | 1 |
696110 | 696110 | 2020-11-03 | Sherman | Texas | 48421 | 79 | 1 |
692794 | 692794 | 2020-11-02 | Kinney | Texas | 48271 | 79 | 1 |
692824 | 692824 | 2020-11-02 | Mills | Texas | 48333 | 79 | 1 |
689550 | 689550 | 2020-11-01 | Kinney | Texas | 48271 | 79 | 1 |
689580 | 689580 | 2020-11-01 | Mills | Texas | 48333 | 79 | 1 |
686305 | 686305 | 2020-10-31 | Kinney | Texas | 48271 | 79 | 1 |
686335 | 686335 | 2020-10-31 | Mills | Texas | 48333 | 79 | 1 |
683062 | 683062 | 2020-10-30 | Kinney | Texas | 48271 | 79 | 1 |
683092 | 683092 | 2020-10-30 | Mills | Texas | 48333 | 79 | 1 |
679819 | 679819 | 2020-10-29 | Kinney | Texas | 48271 | 79 | 1 |
676576 | 676576 | 2020-10-28 | Kinney | Texas | 48271 | 79 | 1 |
673333 | 673333 | 2020-10-27 | Kinney | Texas | 48271 | 79 | 1 |
637544 | 637544 | 2020-10-16 | Cochran | Texas | 48079 | 79 | 1 |
637693 | 637693 | 2020-10-16 | Rains | Texas | 48379 | 79 | 5 |
634300 | 634300 | 2020-10-15 | Coke | Texas | 48081 | 79 | 4 |
627926 | 627926 | 2020-10-13 | Mason | Texas | 48319 | 79 | 2 |
624683 | 624683 | 2020-10-12 | Mason | Texas | 48319 | 79 | 2 |
621440 | 621440 | 2020-10-11 | Mason | Texas | 48319 | 79 | 2 |
618197 | 618197 | 2020-10-10 | Mason | Texas | 48319 | 79 | 2 |
614954 | 614954 | 2020-10-09 | Martin | Texas | 48317 | 79 | 6 |
614955 | 614955 | 2020-10-09 | Mason | Texas | 48319 | 79 | 2 |
611597 | 611597 | 2020-10-08 | Childress | Texas | 48075 | 79 | 0 |
611713 | 611713 | 2020-10-08 | Martin | Texas | 48317 | 79 | 6 |
611714 | 611714 | 2020-10-08 | Mason | Texas | 48319 | 79 | 2 |
608355 | 608355 | 2020-10-07 | Childress | Texas | 48075 | 79 | 0 |
608471 | 608471 | 2020-10-07 | Martin | Texas | 48317 | 79 | 6 |
608472 | 608472 | 2020-10-07 | Mason | Texas | 48319 | 79 | 2 |
608521 | 608521 | 2020-10-07 | San Saba | Texas | 48411 | 79 | 0 |
605228 | 605228 | 2020-10-06 | Martin | Texas | 48317 | 79 | 6 |
605229 | 605229 | 2020-10-06 | Mason | Texas | 48319 | 79 | 2 |
605278 | 605278 | 2020-10-06 | San Saba | Texas | 48411 | 79 | 0 |
601987 | 601987 | 2020-10-05 | Mason | Texas | 48319 | 79 | 2 |
598744 | 598744 | 2020-10-04 | Mason | Texas | 48319 | 79 | 2 |
595501 | 595501 | 2020-10-03 | Mason | Texas | 48319 | 79 | 2 |
592143 | 592143 | 2020-10-02 | Clay | Texas | 48077 | 79 | 2 |
592146 | 592146 | 2020-10-02 | Coleman | Texas | 48083 | 79 | 4 |
588903 | 588903 | 2020-10-01 | Clay | Texas | 48077 | 79 | 2 |
588906 | 588906 | 2020-10-01 | Coleman | Texas | 48083 | 79 | 4 |
585662 | 585662 | 2020-09-30 | Clay | Texas | 48077 | 79 | 2 |
585665 | 585665 | 2020-09-30 | Coleman | Texas | 48083 | 79 | 4 |
582422 | 582422 | 2020-09-29 | Clay | Texas | 48077 | 79 | 2 |
562940 | 562940 | 2020-09-23 | Archer | Texas | 48009 | 79 | 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);