ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where deaths = 242 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2329766 | 2329766 | 2022-03-21 | Hale | Texas | 48189 | 6532 | 242 |
2326514 | 2326514 | 2022-03-20 | Hale | Texas | 48189 | 6532 | 242 |
2323261 | 2323261 | 2022-03-19 | Hale | Texas | 48189 | 6530 | 242 |
2320007 | 2320007 | 2022-03-18 | Hale | Texas | 48189 | 6530 | 242 |
2271312 | 2271312 | 2022-03-03 | Polk | Texas | 48373 | 7779 | 242 |
2248466 | 2248466 | 2022-02-24 | Hardin | Texas | 48199 | 11979 | 242 |
2245215 | 2245215 | 2022-02-23 | Hardin | Texas | 48199 | 11976 | 242 |
2219144 | 2219144 | 2022-02-15 | Cherokee | Texas | 48073 | 7873 | 242 |
2215996 | 2215996 | 2022-02-14 | Lamar | Texas | 48277 | 12313 | 242 |
2216105 | 2216105 | 2022-02-14 | Wise | Texas | 48497 | 16628 | 242 |
2212745 | 2212745 | 2022-02-13 | Lamar | Texas | 48277 | 12269 | 242 |
2212854 | 2212854 | 2022-02-13 | Wise | Texas | 48497 | 16619 | 242 |
2209492 | 2209492 | 2022-02-12 | Lamar | Texas | 48277 | 12269 | 242 |
2196537 | 2196537 | 2022-02-08 | Rockwall | Texas | 48397 | 25614 | 242 |
2193283 | 2193283 | 2022-02-07 | Rockwall | Texas | 48397 | 25588 | 242 |
2190029 | 2190029 | 2022-02-06 | Rockwall | Texas | 48397 | 25557 | 242 |
2186776 | 2186776 | 2022-02-05 | Rockwall | Texas | 48397 | 25511 | 242 |
2183524 | 2183524 | 2022-02-04 | Rockwall | Texas | 48397 | 25443 | 242 |
2180272 | 2180272 | 2022-02-03 | Rockwall | Texas | 48397 | 25376 | 242 |
2177021 | 2177021 | 2022-02-02 | Rockwall | Texas | 48397 | 25304 | 242 |
2173767 | 2173767 | 2022-02-01 | Rockwall | Texas | 48397 | 25217 | 242 |
2154217 | 2154217 | 2022-01-26 | Nacogdoches | Texas | 48347 | 10939 | 242 |
2150965 | 2150965 | 2022-01-25 | Nacogdoches | Texas | 48347 | 10891 | 242 |
2147713 | 2147713 | 2022-01-24 | Nacogdoches | Texas | 48347 | 10842 | 242 |
2144459 | 2144459 | 2022-01-23 | Nacogdoches | Texas | 48347 | 10758 | 242 |
2141204 | 2141204 | 2022-01-22 | Nacogdoches | Texas | 48347 | 10668 | 242 |
2137948 | 2137948 | 2022-01-21 | Nacogdoches | Texas | 48347 | 10545 | 242 |
2134694 | 2134694 | 2022-01-20 | Nacogdoches | Texas | 48347 | 10407 | 242 |
2131442 | 2131442 | 2022-01-19 | Nacogdoches | Texas | 48347 | 10311 | 242 |
2124997 | 2124997 | 2022-01-17 | Van Zandt | Texas | 48467 | 8686 | 242 |
2121745 | 2121745 | 2022-01-16 | Van Zandt | Texas | 48467 | 8576 | 242 |
2118493 | 2118493 | 2022-01-15 | Van Zandt | Texas | 48467 | 8549 | 242 |
2115241 | 2115241 | 2022-01-14 | Van Zandt | Texas | 48467 | 8488 | 242 |
2089244 | 2089244 | 2022-01-06 | Wood | Texas | 48499 | 7180 | 242 |
1829218 | 1829218 | 2021-10-18 | Val Verde | Texas | 48465 | 10521 | 242 |
1825969 | 1825969 | 2021-10-17 | Val Verde | Texas | 48465 | 10521 | 242 |
1822720 | 1822720 | 2021-10-16 | Val Verde | Texas | 48465 | 10521 | 242 |
1819471 | 1819471 | 2021-10-15 | Val Verde | Texas | 48465 | 10521 | 242 |
1816222 | 1816222 | 2021-10-14 | Val Verde | Texas | 48465 | 10521 | 242 |
1812974 | 1812974 | 2021-10-13 | Val Verde | Texas | 48465 | 10521 | 242 |
1747876 | 1747876 | 2021-09-23 | Hunt | Texas | 48231 | 9950 | 242 |
1699136 | 1699136 | 2021-09-08 | Henderson | Texas | 48213 | 8361 | 242 |
1679679 | 1679679 | 2021-09-02 | Liberty | Texas | 48291 | 10481 | 242 |
1643900 | 1643900 | 2021-08-22 | Guadalupe | Texas | 48187 | 18962 | 242 |
1640650 | 1640650 | 2021-08-21 | Guadalupe | Texas | 48187 | 18962 | 242 |
1208746 | 1208746 | 2021-04-10 | Brazos | Texas | 48041 | 25507 | 242 |
1205498 | 1205498 | 2021-04-09 | Brazos | Texas | 48041 | 25507 | 242 |
1202250 | 1202250 | 2021-04-08 | Brazos | Texas | 48041 | 25464 | 242 |
1199001 | 1199001 | 2021-04-07 | Brazos | Texas | 48041 | 25408 | 242 |
1195752 | 1195752 | 2021-04-06 | Brazos | Texas | 48041 | 25326 | 242 |
1173128 | 1173128 | 2021-03-30 | Kaufman | Texas | 48257 | 15461 | 242 |
1020650 | 1020650 | 2021-02-11 | Tom Green | Texas | 48451 | 16101 | 242 |
994530 | 994530 | 2021-02-03 | Ellis | Texas | 48139 | 19104 | 242 |
978273 | 978273 | 2021-01-29 | Comal | Texas | 48091 | 8073 | 242 |
975028 | 975028 | 2021-01-28 | Comal | Texas | 48091 | 7986 | 242 |
971751 | 971751 | 2021-01-27 | Bell | Texas | 48027 | 17931 | 242 |
971783 | 971783 | 2021-01-27 | Comal | Texas | 48091 | 7878 | 242 |
968538 | 968538 | 2021-01-26 | Comal | Texas | 48091 | 7761 | 242 |
965339 | 965339 | 2021-01-25 | Grayson | Texas | 48181 | 9271 | 242 |
962094 | 962094 | 2021-01-24 | Grayson | Texas | 48181 | 9271 | 242 |
958849 | 958849 | 2021-01-23 | Grayson | Texas | 48181 | 9271 | 242 |
920056 | 920056 | 2021-01-11 | Wichita | Texas | 48485 | 12595 | 242 |
887378 | 887378 | 2021-01-01 | Brazoria | Texas | 48039 | 21553 | 242 |
803040 | 803040 | 2020-12-06 | Denton | Texas | 48121 | 26034 | 242 |
799795 | 799795 | 2020-12-05 | Denton | Texas | 48121 | 26034 | 242 |
482288 | 482288 | 2020-08-29 | Webb | Texas | 48479 | 10733 | 242 |
479054 | 479054 | 2020-08-28 | Webb | Texas | 48479 | 10482 | 242 |
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);