ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 26, fips = 48333 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 |
---|---|---|---|---|---|---|---|
1835650 | 1835650 | 2021-10-20 | Mills | Texas | 48333 | 862 | 26 |
1832401 | 1832401 | 2021-10-19 | Mills | Texas | 48333 | 862 | 26 |
1829152 | 1829152 | 2021-10-18 | Mills | Texas | 48333 | 862 | 26 |
1825903 | 1825903 | 2021-10-17 | Mills | Texas | 48333 | 862 | 26 |
1822654 | 1822654 | 2021-10-16 | Mills | Texas | 48333 | 862 | 26 |
1819405 | 1819405 | 2021-10-15 | Mills | Texas | 48333 | 862 | 26 |
1816156 | 1816156 | 2021-10-14 | Mills | Texas | 48333 | 861 | 26 |
1812908 | 1812908 | 2021-10-13 | Mills | Texas | 48333 | 860 | 26 |
1809659 | 1809659 | 2021-10-12 | Mills | Texas | 48333 | 859 | 26 |
1806409 | 1806409 | 2021-10-11 | Mills | Texas | 48333 | 857 | 26 |
1803159 | 1803159 | 2021-10-10 | Mills | Texas | 48333 | 855 | 26 |
1799910 | 1799910 | 2021-10-09 | Mills | Texas | 48333 | 855 | 26 |
1796661 | 1796661 | 2021-10-08 | Mills | Texas | 48333 | 854 | 26 |
1793412 | 1793412 | 2021-10-07 | Mills | Texas | 48333 | 846 | 26 |
1790163 | 1790163 | 2021-10-06 | Mills | Texas | 48333 | 844 | 26 |
1786915 | 1786915 | 2021-10-05 | Mills | Texas | 48333 | 844 | 26 |
1783666 | 1783666 | 2021-10-04 | Mills | Texas | 48333 | 843 | 26 |
1780417 | 1780417 | 2021-10-03 | Mills | Texas | 48333 | 840 | 26 |
1777167 | 1777167 | 2021-10-02 | Mills | Texas | 48333 | 840 | 26 |
1773917 | 1773917 | 2021-10-01 | Mills | Texas | 48333 | 840 | 26 |
1770667 | 1770667 | 2021-09-30 | Mills | Texas | 48333 | 837 | 26 |
1767418 | 1767418 | 2021-09-29 | Mills | Texas | 48333 | 830 | 26 |
1764169 | 1764169 | 2021-09-28 | Mills | Texas | 48333 | 827 | 26 |
1760920 | 1760920 | 2021-09-27 | Mills | Texas | 48333 | 821 | 26 |
1757672 | 1757672 | 2021-09-26 | Mills | Texas | 48333 | 814 | 26 |
1754424 | 1754424 | 2021-09-25 | Mills | Texas | 48333 | 814 | 26 |
1751176 | 1751176 | 2021-09-24 | Mills | Texas | 48333 | 805 | 26 |
1747927 | 1747927 | 2021-09-23 | Mills | Texas | 48333 | 805 | 26 |
1744677 | 1744677 | 2021-09-22 | Mills | Texas | 48333 | 805 | 26 |
1741428 | 1741428 | 2021-09-21 | Mills | Texas | 48333 | 801 | 26 |
1738179 | 1738179 | 2021-09-20 | Mills | Texas | 48333 | 801 | 26 |
1734929 | 1734929 | 2021-09-19 | Mills | Texas | 48333 | 801 | 26 |
1731679 | 1731679 | 2021-09-18 | Mills | Texas | 48333 | 801 | 26 |
1728429 | 1728429 | 2021-09-17 | Mills | Texas | 48333 | 800 | 26 |
1725180 | 1725180 | 2021-09-16 | Mills | Texas | 48333 | 800 | 26 |
1721931 | 1721931 | 2021-09-15 | Mills | Texas | 48333 | 797 | 26 |
1718683 | 1718683 | 2021-09-14 | Mills | Texas | 48333 | 793 | 26 |
1715435 | 1715435 | 2021-09-13 | Mills | Texas | 48333 | 788 | 26 |
1712189 | 1712189 | 2021-09-12 | Mills | Texas | 48333 | 783 | 26 |
1708942 | 1708942 | 2021-09-11 | Mills | Texas | 48333 | 783 | 26 |
1705695 | 1705695 | 2021-09-10 | Mills | Texas | 48333 | 777 | 26 |
1702445 | 1702445 | 2021-09-09 | Mills | Texas | 48333 | 775 | 26 |
1699196 | 1699196 | 2021-09-08 | Mills | Texas | 48333 | 773 | 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);