ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where deaths = 26, fips = 48195 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1994827 | 1994827 | 2021-12-08 | Hansford | Texas | 48195 | 1170 | 26 |
1991576 | 1991576 | 2021-12-07 | Hansford | Texas | 48195 | 1168 | 26 |
1988325 | 1988325 | 2021-12-06 | Hansford | Texas | 48195 | 1168 | 26 |
1985075 | 1985075 | 2021-12-05 | Hansford | Texas | 48195 | 1167 | 26 |
1981825 | 1981825 | 2021-12-04 | Hansford | Texas | 48195 | 1165 | 26 |
1978575 | 1978575 | 2021-12-03 | Hansford | Texas | 48195 | 1165 | 26 |
1975325 | 1975325 | 2021-12-02 | Hansford | Texas | 48195 | 1163 | 26 |
1972076 | 1972076 | 2021-12-01 | Hansford | Texas | 48195 | 1161 | 26 |
1968826 | 1968826 | 2021-11-30 | Hansford | Texas | 48195 | 1159 | 26 |
1965575 | 1965575 | 2021-11-29 | Hansford | Texas | 48195 | 1159 | 26 |
1962323 | 1962323 | 2021-11-28 | Hansford | Texas | 48195 | 1155 | 26 |
1959072 | 1959072 | 2021-11-27 | Hansford | Texas | 48195 | 1155 | 26 |
1955821 | 1955821 | 2021-11-26 | Hansford | Texas | 48195 | 1155 | 26 |
1952570 | 1952570 | 2021-11-25 | Hansford | Texas | 48195 | 1155 | 26 |
1949319 | 1949319 | 2021-11-24 | Hansford | Texas | 48195 | 1155 | 26 |
1946068 | 1946068 | 2021-11-23 | Hansford | Texas | 48195 | 1155 | 26 |
1942817 | 1942817 | 2021-11-22 | Hansford | Texas | 48195 | 1155 | 26 |
1939567 | 1939567 | 2021-11-21 | Hansford | Texas | 48195 | 1155 | 26 |
1936317 | 1936317 | 2021-11-20 | Hansford | Texas | 48195 | 1155 | 26 |
1933067 | 1933067 | 2021-11-19 | Hansford | Texas | 48195 | 1154 | 26 |
1929816 | 1929816 | 2021-11-18 | Hansford | Texas | 48195 | 1151 | 26 |
1861576 | 1861576 | 2021-10-28 | Hansford | Texas | 48195 | 1129 | 26 |
1858327 | 1858327 | 2021-10-27 | Hansford | Texas | 48195 | 1129 | 26 |
1855078 | 1855078 | 2021-10-26 | Hansford | Texas | 48195 | 1129 | 26 |
1851829 | 1851829 | 2021-10-25 | Hansford | Texas | 48195 | 1127 | 26 |
1848579 | 1848579 | 2021-10-24 | Hansford | Texas | 48195 | 1127 | 26 |
1845329 | 1845329 | 2021-10-23 | Hansford | Texas | 48195 | 1127 | 26 |
1842079 | 1842079 | 2021-10-22 | Hansford | Texas | 48195 | 1121 | 26 |
1838830 | 1838830 | 2021-10-21 | Hansford | Texas | 48195 | 1121 | 26 |
1835581 | 1835581 | 2021-10-20 | Hansford | Texas | 48195 | 1119 | 26 |
1832332 | 1832332 | 2021-10-19 | Hansford | Texas | 48195 | 1114 | 26 |
1829083 | 1829083 | 2021-10-18 | Hansford | Texas | 48195 | 1111 | 26 |
1825834 | 1825834 | 2021-10-17 | Hansford | Texas | 48195 | 1111 | 26 |
1822585 | 1822585 | 2021-10-16 | Hansford | Texas | 48195 | 1111 | 26 |
1819336 | 1819336 | 2021-10-15 | Hansford | Texas | 48195 | 1111 | 26 |
1816087 | 1816087 | 2021-10-14 | Hansford | Texas | 48195 | 1111 | 26 |
1812839 | 1812839 | 2021-10-13 | Hansford | Texas | 48195 | 1105 | 26 |
1809590 | 1809590 | 2021-10-12 | Hansford | Texas | 48195 | 1101 | 26 |
1806340 | 1806340 | 2021-10-11 | Hansford | Texas | 48195 | 1101 | 26 |
1803090 | 1803090 | 2021-10-10 | Hansford | Texas | 48195 | 1101 | 26 |
1799841 | 1799841 | 2021-10-09 | Hansford | Texas | 48195 | 1101 | 26 |
1796592 | 1796592 | 2021-10-08 | Hansford | Texas | 48195 | 1101 | 26 |
1793343 | 1793343 | 2021-10-07 | Hansford | Texas | 48195 | 1099 | 26 |
1790094 | 1790094 | 2021-10-06 | Hansford | Texas | 48195 | 1099 | 26 |
1786846 | 1786846 | 2021-10-05 | Hansford | Texas | 48195 | 1097 | 26 |
1783597 | 1783597 | 2021-10-04 | Hansford | Texas | 48195 | 1090 | 26 |
1780348 | 1780348 | 2021-10-03 | Hansford | Texas | 48195 | 1090 | 26 |
1777098 | 1777098 | 2021-10-02 | Hansford | Texas | 48195 | 1090 | 26 |
1773848 | 1773848 | 2021-10-01 | Hansford | Texas | 48195 | 1087 | 26 |
1770598 | 1770598 | 2021-09-30 | Hansford | Texas | 48195 | 1087 | 26 |
1767349 | 1767349 | 2021-09-29 | Hansford | Texas | 48195 | 1082 | 26 |
1764100 | 1764100 | 2021-09-28 | Hansford | Texas | 48195 | 1074 | 26 |
1760851 | 1760851 | 2021-09-27 | Hansford | Texas | 48195 | 1070 | 26 |
1757603 | 1757603 | 2021-09-26 | Hansford | Texas | 48195 | 1070 | 26 |
1754355 | 1754355 | 2021-09-25 | Hansford | Texas | 48195 | 1070 | 26 |
1751107 | 1751107 | 2021-09-24 | Hansford | Texas | 48195 | 1069 | 26 |
1747858 | 1747858 | 2021-09-23 | Hansford | Texas | 48195 | 1069 | 26 |
1744608 | 1744608 | 2021-09-22 | Hansford | Texas | 48195 | 1058 | 26 |
1741359 | 1741359 | 2021-09-21 | Hansford | Texas | 48195 | 1043 | 26 |
1738110 | 1738110 | 2021-09-20 | Hansford | Texas | 48195 | 1043 | 26 |
1734860 | 1734860 | 2021-09-19 | Hansford | Texas | 48195 | 1043 | 26 |
1731610 | 1731610 | 2021-09-18 | Hansford | Texas | 48195 | 1043 | 26 |
1728360 | 1728360 | 2021-09-17 | Hansford | Texas | 48195 | 1043 | 26 |
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);