ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 329 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2248571 | 2248571 | 2022-02-24 | San Patricio | Texas | 48409 | 10933 | 329 |
2173684 | 2173684 | 2022-02-01 | Hunt | Texas | 48231 | 15094 | 329 |
2170432 | 2170432 | 2022-01-31 | Hunt | Texas | 48231 | 14972 | 329 |
2167178 | 2167178 | 2022-01-30 | Hunt | Texas | 48231 | 14904 | 329 |
2163923 | 2163923 | 2022-01-29 | Hunt | Texas | 48231 | 14852 | 329 |
1880991 | 1880991 | 2021-11-03 | Bowie | Texas | 48037 | 12740 | 329 |
1816135 | 1816135 | 2021-10-14 | Liberty | Texas | 48291 | 12587 | 329 |
1816224 | 1816224 | 2021-10-14 | Victoria | Texas | 48469 | 13008 | 329 |
1812887 | 1812887 | 2021-10-13 | Liberty | Texas | 48291 | 12565 | 329 |
1812976 | 1812976 | 2021-10-13 | Victoria | Texas | 48469 | 13003 | 329 |
1809727 | 1809727 | 2021-10-12 | Victoria | Texas | 48469 | 12983 | 329 |
1793459 | 1793459 | 2021-10-07 | Starr | Texas | 48427 | 11447 | 329 |
1790210 | 1790210 | 2021-10-06 | Starr | Texas | 48427 | 11428 | 329 |
1760918 | 1760918 | 2021-09-27 | Midland | Texas | 48329 | 26194 | 329 |
1757670 | 1757670 | 2021-09-26 | Midland | Texas | 48329 | 25601 | 329 |
1715494 | 1715494 | 2021-09-13 | Tom Green | Texas | 48451 | 23271 | 329 |
1712151 | 1712151 | 2021-09-12 | Kaufman | Texas | 48257 | 21117 | 329 |
1712248 | 1712248 | 2021-09-12 | Tom Green | Texas | 48451 | 22996 | 329 |
1708904 | 1708904 | 2021-09-11 | Kaufman | Texas | 48257 | 21117 | 329 |
1614643 | 1614643 | 2021-08-13 | Ellis | Texas | 48139 | 24892 | 329 |
1611394 | 1611394 | 2021-08-12 | Ellis | Texas | 48139 | 24820 | 329 |
1608146 | 1608146 | 2021-08-11 | Ellis | Texas | 48139 | 24684 | 329 |
1517176 | 1517176 | 2021-07-14 | Comal | Texas | 48091 | 11635 | 329 |
1513929 | 1513929 | 2021-07-13 | Comal | Texas | 48091 | 11601 | 329 |
1510683 | 1510683 | 2021-07-12 | Comal | Texas | 48091 | 11557 | 329 |
1507436 | 1507436 | 2021-07-11 | Comal | Texas | 48091 | 11557 | 329 |
1504190 | 1504190 | 2021-07-10 | Comal | Texas | 48091 | 11557 | 329 |
1150425 | 1150425 | 2021-03-23 | Maverick | Texas | 48323 | 10301 | 329 |
1147178 | 1147178 | 2021-03-22 | Maverick | Texas | 48323 | 10295 | 329 |
1143931 | 1143931 | 2021-03-21 | Maverick | Texas | 48323 | 10295 | 329 |
1036775 | 1036775 | 2021-02-16 | Jefferson | Texas | 48245 | 17827 | 329 |
1033530 | 1033530 | 2021-02-15 | Jefferson | Texas | 48245 | 17812 | 329 |
1030284 | 1030284 | 2021-02-14 | Jefferson | Texas | 48245 | 17812 | 329 |
968704 | 968704 | 2021-01-26 | Smith | Texas | 48423 | 16779 | 329 |
929710 | 929710 | 2021-01-14 | McLennan | Texas | 48309 | 21598 | 329 |
767361 | 767361 | 2020-11-25 | Fort Bend | Texas | 48157 | 21588 | 329 |
621523 | 621523 | 2020-10-11 | Webb | Texas | 48479 | 14364 | 329 |
618280 | 618280 | 2020-10-10 | Webb | Texas | 48479 | 14364 | 329 |
615038 | 615038 | 2020-10-09 | Webb | Texas | 48479 | 14364 | 329 |
366249 | 366249 | 2020-07-24 | Tarrant | Texas | 48439 | 24562 | 329 |
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);