ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 387 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2271219 | 2271219 | 2022-03-03 | Guadalupe | Texas | 48187 | 36790 | 387 |
2267967 | 2267967 | 2022-03-02 | Guadalupe | Texas | 48187 | 36764 | 387 |
2222504 | 2222504 | 2022-02-16 | Liberty | Texas | 48291 | 17233 | 387 |
2219253 | 2219253 | 2022-02-15 | Liberty | Texas | 48291 | 17212 | 387 |
2216002 | 2216002 | 2022-02-14 | Liberty | Texas | 48291 | 17164 | 387 |
2202953 | 2202953 | 2022-02-10 | Henderson | Texas | 48213 | 14990 | 387 |
2177006 | 2177006 | 2022-02-02 | Parker | Texas | 48367 | 32707 | 387 |
2037179 | 2037179 | 2021-12-21 | Randall | Texas | 48381 | 27648 | 387 |
2033929 | 2033929 | 2021-12-20 | Randall | Texas | 48381 | 27497 | 387 |
2030679 | 2030679 | 2021-12-19 | Randall | Texas | 48381 | 27426 | 387 |
2027428 | 2027428 | 2021-12-18 | Randall | Texas | 48381 | 27426 | 387 |
1975392 | 1975392 | 2021-12-02 | Midland | Texas | 48329 | 29594 | 387 |
1907196 | 1907196 | 2021-11-11 | Tom Green | Texas | 48451 | 25082 | 387 |
1835588 | 1835588 | 2021-10-20 | Hays | Texas | 48209 | 32638 | 387 |
1815992 | 1815992 | 2021-10-14 | Angelina | Texas | 48005 | 13560 | 387 |
1812744 | 1812744 | 2021-10-13 | Angelina | Texas | 48005 | 13560 | 387 |
1699075 | 1699075 | 2021-09-08 | Comal | Texas | 48091 | 16355 | 387 |
1695872 | 1695872 | 2021-09-07 | Grayson | Texas | 48181 | 13482 | 387 |
1692624 | 1692624 | 2021-09-06 | Grayson | Texas | 48181 | 13482 | 387 |
1689375 | 1689375 | 2021-09-05 | Grayson | Texas | 48181 | 13482 | 387 |
1686125 | 1686125 | 2021-09-04 | Grayson | Texas | 48181 | 13482 | 387 |
1673130 | 1673130 | 2021-08-31 | Gregg | Texas | 48183 | 14854 | 387 |
1591957 | 1591957 | 2021-08-06 | Johnson | Texas | 48251 | 21182 | 387 |
1582325 | 1582325 | 2021-08-03 | Wichita | Texas | 48485 | 15807 | 387 |
1169875 | 1169875 | 2021-03-29 | Jefferson | Texas | 48245 | 18852 | 387 |
1166627 | 1166627 | 2021-03-28 | Jefferson | Texas | 48245 | 18852 | 387 |
1163379 | 1163379 | 2021-03-27 | Jefferson | Texas | 48245 | 18852 | 387 |
1160130 | 1160130 | 2021-03-26 | Jefferson | Texas | 48245 | 18785 | 387 |
1101582 | 1101582 | 2021-03-08 | Bell | Texas | 48027 | 20810 | 387 |
1085357 | 1085357 | 2021-03-03 | Brazoria | Texas | 48039 | 33152 | 387 |
1049846 | 1049846 | 2021-02-20 | Smith | Texas | 48423 | 18555 | 387 |
1046599 | 1046599 | 2021-02-19 | Smith | Texas | 48423 | 18555 | 387 |
1043354 | 1043354 | 2021-02-18 | Smith | Texas | 48423 | 18535 | 387 |
1040109 | 1040109 | 2021-02-17 | Smith | Texas | 48423 | 18535 | 387 |
1036864 | 1036864 | 2021-02-16 | Smith | Texas | 48423 | 18476 | 387 |
1033619 | 1033619 | 2021-02-15 | Smith | Texas | 48423 | 18366 | 387 |
1030373 | 1030373 | 2021-02-14 | Smith | Texas | 48423 | 18366 | 387 |
1027126 | 1027126 | 2021-02-13 | Smith | Texas | 48423 | 18366 | 387 |
1014122 | 1014122 | 2021-02-09 | Potter | Texas | 48375 | 16644 | 387 |
754540 | 754540 | 2020-11-21 | Webb | Texas | 48479 | 18705 | 387 |
456274 | 456274 | 2020-08-21 | El Paso | Texas | 48141 | 19177 | 387 |
295983 | 295983 | 2020-07-02 | Dallas | Texas | 48113 | 22590 | 387 |
296026 | 296026 | 2020-07-02 | Harris | Texas | 48201 | 34108 | 387 |
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);