ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 844 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Texas · 28 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2365541 | 2365541 | 2022-04-01 | Galveston | Texas | 48167 | 95448 | 844 |
2362288 | 2362288 | 2022-03-31 | Galveston | Texas | 48167 | 95429 | 844 |
2359034 | 2359034 | 2022-03-30 | Galveston | Texas | 48167 | 95401 | 844 |
2355780 | 2355780 | 2022-03-29 | Galveston | Texas | 48167 | 95380 | 844 |
1686186 | 1686186 | 2021-09-04 | Lubbock | Texas | 48303 | 58105 | 844 |
1471919 | 1471919 | 2021-06-30 | Webb | Texas | 48479 | 46808 | 844 |
1468674 | 1468674 | 2021-06-29 | Webb | Texas | 48479 | 46808 | 844 |
1465429 | 1465429 | 2021-06-28 | Webb | Texas | 48479 | 46808 | 844 |
1462184 | 1462184 | 2021-06-27 | Webb | Texas | 48479 | 46808 | 844 |
1458939 | 1458939 | 2021-06-26 | Webb | Texas | 48479 | 46808 | 844 |
1455497 | 1455497 | 2021-06-25 | Collin | Texas | 48085 | 92752 | 844 |
1455694 | 1455694 | 2021-06-25 | Webb | Texas | 48479 | 46808 | 844 |
1452252 | 1452252 | 2021-06-24 | Collin | Texas | 48085 | 92671 | 844 |
1452449 | 1452449 | 2021-06-24 | Webb | Texas | 48479 | 46808 | 844 |
1449203 | 1449203 | 2021-06-23 | Webb | Texas | 48479 | 46808 | 844 |
1445958 | 1445958 | 2021-06-22 | Webb | Texas | 48479 | 46808 | 844 |
1442713 | 1442713 | 2021-06-21 | Webb | Texas | 48479 | 46808 | 844 |
1439468 | 1439468 | 2021-06-20 | Webb | Texas | 48479 | 46808 | 844 |
1436221 | 1436221 | 2021-06-19 | Webb | Texas | 48479 | 46808 | 844 |
1432974 | 1432974 | 2021-06-18 | Webb | Texas | 48479 | 46808 | 844 |
1429728 | 1429728 | 2021-06-17 | Webb | Texas | 48479 | 46724 | 844 |
1426483 | 1426483 | 2021-06-16 | Webb | Texas | 48479 | 46724 | 844 |
1423236 | 1423236 | 2021-06-15 | Webb | Texas | 48479 | 46724 | 844 |
1419990 | 1419990 | 2021-06-14 | Webb | Texas | 48479 | 46724 | 844 |
1416745 | 1416745 | 2021-06-13 | Webb | Texas | 48479 | 46724 | 844 |
1413499 | 1413499 | 2021-06-12 | Webb | Texas | 48479 | 46724 | 844 |
1410254 | 1410254 | 2021-06-11 | Webb | Texas | 48479 | 46724 | 844 |
1407009 | 1407009 | 2021-06-10 | Webb | Texas | 48479 | 46688 | 844 |
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);