ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where deaths = 193 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2329705 | 2329705 | 2022-03-21 | Cass | Texas | 48067 | 7178 | 193 |
2326453 | 2326453 | 2022-03-20 | Cass | Texas | 48067 | 7178 | 193 |
2323200 | 2323200 | 2022-03-19 | Cass | Texas | 48067 | 7178 | 193 |
2319946 | 2319946 | 2022-03-18 | Cass | Texas | 48067 | 7177 | 193 |
2316692 | 2316692 | 2022-03-17 | Cass | Texas | 48067 | 7176 | 193 |
2313439 | 2313439 | 2022-03-16 | Cass | Texas | 48067 | 7169 | 193 |
2310186 | 2310186 | 2022-03-15 | Cass | Texas | 48067 | 7162 | 193 |
2274541 | 2274541 | 2022-03-04 | Medina | Texas | 48325 | 9976 | 193 |
2228910 | 2228910 | 2022-02-18 | Coryell | Texas | 48099 | 17027 | 193 |
2209477 | 2209477 | 2022-02-12 | Jim Wells | Texas | 48249 | 10818 | 193 |
2134721 | 2134721 | 2022-01-20 | Rusk | Texas | 48401 | 9584 | 193 |
2111996 | 2111996 | 2022-01-13 | Wharton | Texas | 48481 | 7118 | 193 |
2108744 | 2108744 | 2022-01-12 | Wharton | Texas | 48481 | 7053 | 193 |
2105493 | 2105493 | 2022-01-11 | Wharton | Texas | 48481 | 7016 | 193 |
2102242 | 2102242 | 2022-01-10 | Wharton | Texas | 48481 | 6963 | 193 |
2098991 | 2098991 | 2022-01-09 | Wharton | Texas | 48481 | 6921 | 193 |
2095739 | 2095739 | 2022-01-08 | Wharton | Texas | 48481 | 6881 | 193 |
2092487 | 2092487 | 2022-01-07 | Wharton | Texas | 48481 | 6834 | 193 |
2089235 | 2089235 | 2022-01-06 | Wharton | Texas | 48481 | 6770 | 193 |
2085754 | 2085754 | 2022-01-05 | Bastrop | Texas | 48021 | 15822 | 193 |
2085984 | 2085984 | 2022-01-05 | Wharton | Texas | 48481 | 6745 | 193 |
2082502 | 2082502 | 2022-01-04 | Bastrop | Texas | 48021 | 15674 | 193 |
2082732 | 2082732 | 2022-01-04 | Wharton | Texas | 48481 | 6714 | 193 |
2079250 | 2079250 | 2022-01-03 | Bastrop | Texas | 48021 | 15538 | 193 |
2079480 | 2079480 | 2022-01-03 | Wharton | Texas | 48481 | 6661 | 193 |
2076229 | 2076229 | 2022-01-02 | Wharton | Texas | 48481 | 6502 | 193 |
2072978 | 2072978 | 2022-01-01 | Wharton | Texas | 48481 | 6502 | 193 |
2069727 | 2069727 | 2021-12-31 | Wharton | Texas | 48481 | 6502 | 193 |
2066476 | 2066476 | 2021-12-30 | Wharton | Texas | 48481 | 6502 | 193 |
2063226 | 2063226 | 2021-12-29 | Wharton | Texas | 48481 | 6492 | 193 |
2059976 | 2059976 | 2021-12-28 | Wharton | Texas | 48481 | 6476 | 193 |
2056727 | 2056727 | 2021-12-27 | Wharton | Texas | 48481 | 6455 | 193 |
2053412 | 2053412 | 2021-12-26 | Navarro | Texas | 48349 | 9123 | 193 |
2050162 | 2050162 | 2021-12-25 | Navarro | Texas | 48349 | 9123 | 193 |
2046912 | 2046912 | 2021-12-24 | Navarro | Texas | 48349 | 9123 | 193 |
2043662 | 2043662 | 2021-12-23 | Navarro | Texas | 48349 | 9123 | 193 |
2040413 | 2040413 | 2021-12-22 | Navarro | Texas | 48349 | 9113 | 193 |
2037163 | 2037163 | 2021-12-21 | Navarro | Texas | 48349 | 9099 | 193 |
2033913 | 2033913 | 2021-12-20 | Navarro | Texas | 48349 | 9092 | 193 |
2030663 | 2030663 | 2021-12-19 | Navarro | Texas | 48349 | 9086 | 193 |
2027412 | 2027412 | 2021-12-18 | Navarro | Texas | 48349 | 9084 | 193 |
2024161 | 2024161 | 2021-12-17 | Navarro | Texas | 48349 | 9080 | 193 |
2020910 | 2020910 | 2021-12-16 | Navarro | Texas | 48349 | 9071 | 193 |
1998005 | 1998005 | 2021-12-09 | Brown | Texas | 48049 | 7208 | 193 |
1994754 | 1994754 | 2021-12-08 | Brown | Texas | 48049 | 7202 | 193 |
1991503 | 1991503 | 2021-12-07 | Brown | Texas | 48049 | 7202 | 193 |
1988252 | 1988252 | 2021-12-06 | Brown | Texas | 48049 | 7202 | 193 |
1985002 | 1985002 | 2021-12-05 | Brown | Texas | 48049 | 7202 | 193 |
1981752 | 1981752 | 2021-12-04 | Brown | Texas | 48049 | 7202 | 193 |
1978502 | 1978502 | 2021-12-03 | Brown | Texas | 48049 | 7202 | 193 |
1929813 | 1929813 | 2021-11-18 | Hale | Texas | 48189 | 8082 | 193 |
1861727 | 1861727 | 2021-10-28 | Wise | Texas | 48497 | 11327 | 193 |
1858478 | 1858478 | 2021-10-27 | Wise | Texas | 48497 | 11317 | 193 |
1835594 | 1835594 | 2021-10-20 | Hood | Texas | 48221 | 9584 | 193 |
1822674 | 1822674 | 2021-10-16 | Polk | Texas | 48373 | 5885 | 193 |
1796728 | 1796728 | 2021-10-08 | Van Zandt | Texas | 48467 | 7739 | 193 |
1793385 | 1793385 | 2021-10-07 | Lamar | Texas | 48277 | 8572 | 193 |
1790136 | 1790136 | 2021-10-06 | Lamar | Texas | 48277 | 8557 | 193 |
1786755 | 1786755 | 2021-10-05 | Atascosa | Texas | 48013 | 8273 | 193 |
1783506 | 1783506 | 2021-10-04 | Atascosa | Texas | 48013 | 8273 | 193 |
1780257 | 1780257 | 2021-10-03 | Atascosa | Texas | 48013 | 8271 | 193 |
1780287 | 1780287 | 2021-10-03 | Cherokee | Texas | 48073 | 6616 | 193 |
1777007 | 1777007 | 2021-10-02 | Atascosa | Texas | 48013 | 8271 | 193 |
1773757 | 1773757 | 2021-10-01 | Atascosa | Texas | 48013 | 8271 | 193 |
1738186 | 1738186 | 2021-09-20 | Nacogdoches | Texas | 48347 | 7086 | 193 |
1734936 | 1734936 | 2021-09-19 | Nacogdoches | Texas | 48347 | 7086 | 193 |
1731686 | 1731686 | 2021-09-18 | Nacogdoches | Texas | 48347 | 7086 | 193 |
1682988 | 1682988 | 2021-09-03 | San Patricio | Texas | 48409 | 5834 | 193 |
1556282 | 1556282 | 2021-07-26 | Parker | Texas | 48367 | 16751 | 193 |
1553035 | 1553035 | 2021-07-25 | Parker | Texas | 48367 | 16751 | 193 |
1549788 | 1549788 | 2021-07-24 | Parker | Texas | 48367 | 16751 | 193 |
1445864 | 1445864 | 2021-06-22 | Liberty | Texas | 48291 | 8106 | 193 |
1397140 | 1397140 | 2021-06-07 | Henderson | Texas | 48213 | 5988 | 193 |
1393893 | 1393893 | 2021-06-06 | Henderson | Texas | 48213 | 5988 | 193 |
1390648 | 1390648 | 2021-06-05 | Henderson | Texas | 48213 | 5988 | 193 |
1387403 | 1387403 | 2021-06-04 | Henderson | Texas | 48213 | 5988 | 193 |
994564 | 994564 | 2021-02-03 | Hays | Texas | 48209 | 16896 | 193 |
945779 | 945779 | 2021-01-19 | Angelina | Texas | 48005 | 6765 | 193 |
929563 | 929563 | 2021-01-14 | Bell | Texas | 48027 | 16247 | 193 |
926350 | 926350 | 2021-01-13 | Comal | Texas | 48091 | 7056 | 193 |
926530 | 926530 | 2021-01-13 | Tom Green | Texas | 48451 | 14305 | 193 |
919978 | 919978 | 2021-01-11 | Midland | Texas | 48329 | 12421 | 193 |
916733 | 916733 | 2021-01-10 | Midland | Texas | 48329 | 12421 | 193 |
913414 | 913414 | 2021-01-09 | Grayson | Texas | 48181 | 7922 | 193 |
913415 | 913415 | 2021-01-09 | Gregg | Texas | 48183 | 7446 | 193 |
913488 | 913488 | 2021-01-09 | Midland | Texas | 48329 | 12421 | 193 |
910243 | 910243 | 2021-01-08 | Midland | Texas | 48329 | 12421 | 193 |
906998 | 906998 | 2021-01-07 | Midland | Texas | 48329 | 12421 | 193 |
897256 | 897256 | 2021-01-04 | Maverick | Texas | 48323 | 6437 | 193 |
894010 | 894010 | 2021-01-03 | Maverick | Texas | 48323 | 6437 | 193 |
822664 | 822664 | 2020-12-12 | Starr | Texas | 48427 | 5033 | 193 |
819418 | 819418 | 2020-12-11 | Starr | Texas | 48427 | 4998 | 193 |
816042 | 816042 | 2020-12-10 | Galveston | Texas | 48167 | 16126 | 193 |
747828 | 747828 | 2020-11-19 | Brazoria | Texas | 48039 | 13516 | 193 |
734994 | 734994 | 2020-11-15 | Montgomery | Texas | 48339 | 14912 | 193 |
731748 | 731748 | 2020-11-14 | Montgomery | Texas | 48339 | 14912 | 193 |
699187 | 699187 | 2020-11-04 | Collin | Texas | 48085 | 19189 | 193 |
440305 | 440305 | 2020-08-16 | Webb | Texas | 48479 | 9552 | 193 |
147726 | 147726 | 2020-05-15 | Harris | Texas | 48201 | 9050 | 193 |
144723 | 144723 | 2020-05-14 | Harris | Texas | 48201 | 8817 | 193 |
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);