ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 391 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2251763 | 2251763 | 2022-02-25 | Liberty | Texas | 48291 | 17398 | 391 |
2248512 | 2248512 | 2022-02-24 | Liberty | Texas | 48291 | 17361 | 391 |
2225844 | 2225844 | 2022-02-17 | Victoria | Texas | 48469 | 18286 | 391 |
2222379 | 2222379 | 2022-02-16 | Brazos | Texas | 48041 | 59228 | 391 |
2219128 | 2219128 | 2022-02-15 | Brazos | Texas | 48041 | 59171 | 391 |
2219214 | 2219214 | 2022-02-15 | Henderson | Texas | 48213 | 15173 | 391 |
2180257 | 2180257 | 2022-02-03 | Parker | Texas | 48367 | 32820 | 391 |
2053428 | 2053428 | 2021-12-26 | Randall | Texas | 48381 | 27854 | 391 |
2050178 | 2050178 | 2021-12-25 | Randall | Texas | 48381 | 27854 | 391 |
2046928 | 2046928 | 2021-12-24 | Randall | Texas | 48381 | 27854 | 391 |
2043678 | 2043678 | 2021-12-23 | Randall | Texas | 48381 | 27854 | 391 |
1929944 | 1929944 | 2021-11-18 | Tom Green | Texas | 48451 | 25187 | 391 |
1699120 | 1699120 | 2021-09-08 | Grayson | Texas | 48181 | 13677 | 391 |
1676377 | 1676377 | 2021-09-01 | Gregg | Texas | 48183 | 14854 | 391 |
1611391 | 1611391 | 2021-08-12 | Ector | Texas | 48135 | 19478 | 391 |
1608318 | 1608318 | 2021-08-11 | Wichita | Texas | 48485 | 16117 | 391 |
1179577 | 1179577 | 2021-04-01 | Galveston | Texas | 48167 | 37190 | 391 |
1169973 | 1169973 | 2021-03-29 | Taylor | Texas | 48441 | 15476 | 391 |
1166725 | 1166725 | 2021-03-28 | Taylor | Texas | 48441 | 15466 | 391 |
1163477 | 1163477 | 2021-03-27 | Taylor | Texas | 48441 | 15466 | 391 |
1160228 | 1160228 | 2021-03-26 | Taylor | Texas | 48441 | 15466 | 391 |
1156981 | 1156981 | 2021-03-25 | Taylor | Texas | 48441 | 15467 | 391 |
1088602 | 1088602 | 2021-03-04 | Brazoria | Texas | 48039 | 33169 | 391 |
1066109 | 1066109 | 2021-02-25 | Williamson | Texas | 48491 | 39586 | 391 |
1062830 | 1062830 | 2021-02-24 | Smith | Texas | 48423 | 18634 | 391 |
1062864 | 1062864 | 2021-02-24 | Williamson | Texas | 48491 | 39586 | 391 |
398400 | 398400 | 2020-08-03 | Tarrant | Texas | 48439 | 29357 | 391 |
395184 | 395184 | 2020-08-02 | Tarrant | Texas | 48439 | 29054 | 391 |
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);