ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where deaths = 936 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2271337 | 2271337 | 2022-03-03 | Smith | Texas | 48423 | 45193 | 936 |
1786988 | 1786988 | 2021-10-05 | Webb | Texas | 48479 | 56043 | 936 |
1783739 | 1783739 | 2021-10-04 | Webb | Texas | 48479 | 56033 | 936 |
1780490 | 1780490 | 2021-10-03 | Webb | Texas | 48479 | 56033 | 936 |
1777240 | 1777240 | 2021-10-02 | Webb | Texas | 48479 | 56002 | 936 |
1773990 | 1773990 | 2021-10-01 | Webb | Texas | 48479 | 56002 | 936 |
1770740 | 1770740 | 2021-09-30 | Webb | Texas | 48479 | 55848 | 936 |
1767491 | 1767491 | 2021-09-29 | Webb | Texas | 48479 | 55848 | 936 |
1764242 | 1764242 | 2021-09-28 | Webb | Texas | 48479 | 55759 | 936 |
1760993 | 1760993 | 2021-09-27 | Webb | Texas | 48479 | 55593 | 936 |
1757745 | 1757745 | 2021-09-26 | Webb | Texas | 48479 | 55593 | 936 |
1754497 | 1754497 | 2021-09-25 | Webb | Texas | 48479 | 55593 | 936 |
1751249 | 1751249 | 2021-09-24 | Webb | Texas | 48479 | 55538 | 936 |
1748000 | 1748000 | 2021-09-23 | Webb | Texas | 48479 | 55456 | 936 |
1705571 | 1705571 | 2021-09-10 | Collin | Texas | 48085 | 116337 | 936 |
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);