ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
225 rows where deaths = 8, fips = 48345 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1793418 | 1793418 | 2021-10-07 | Motley | Texas | 48345 | 150 | 8 |
1790169 | 1790169 | 2021-10-06 | Motley | Texas | 48345 | 149 | 8 |
1786921 | 1786921 | 2021-10-05 | Motley | Texas | 48345 | 149 | 8 |
1783672 | 1783672 | 2021-10-04 | Motley | Texas | 48345 | 148 | 8 |
1780423 | 1780423 | 2021-10-03 | Motley | Texas | 48345 | 148 | 8 |
1777173 | 1777173 | 2021-10-02 | Motley | Texas | 48345 | 148 | 8 |
1773923 | 1773923 | 2021-10-01 | Motley | Texas | 48345 | 147 | 8 |
1770673 | 1770673 | 2021-09-30 | Motley | Texas | 48345 | 147 | 8 |
1767424 | 1767424 | 2021-09-29 | Motley | Texas | 48345 | 147 | 8 |
1764175 | 1764175 | 2021-09-28 | Motley | Texas | 48345 | 146 | 8 |
1760926 | 1760926 | 2021-09-27 | Motley | Texas | 48345 | 146 | 8 |
1757678 | 1757678 | 2021-09-26 | Motley | Texas | 48345 | 146 | 8 |
1754430 | 1754430 | 2021-09-25 | Motley | Texas | 48345 | 146 | 8 |
1751182 | 1751182 | 2021-09-24 | Motley | Texas | 48345 | 146 | 8 |
1747933 | 1747933 | 2021-09-23 | Motley | Texas | 48345 | 146 | 8 |
1744683 | 1744683 | 2021-09-22 | Motley | Texas | 48345 | 146 | 8 |
1741434 | 1741434 | 2021-09-21 | Motley | Texas | 48345 | 145 | 8 |
1738185 | 1738185 | 2021-09-20 | Motley | Texas | 48345 | 145 | 8 |
1734935 | 1734935 | 2021-09-19 | Motley | Texas | 48345 | 145 | 8 |
1731685 | 1731685 | 2021-09-18 | Motley | Texas | 48345 | 145 | 8 |
1728435 | 1728435 | 2021-09-17 | Motley | Texas | 48345 | 144 | 8 |
1725186 | 1725186 | 2021-09-16 | Motley | Texas | 48345 | 144 | 8 |
1721937 | 1721937 | 2021-09-15 | Motley | Texas | 48345 | 144 | 8 |
1718689 | 1718689 | 2021-09-14 | Motley | Texas | 48345 | 144 | 8 |
1715441 | 1715441 | 2021-09-13 | Motley | Texas | 48345 | 143 | 8 |
1712195 | 1712195 | 2021-09-12 | Motley | Texas | 48345 | 143 | 8 |
1708948 | 1708948 | 2021-09-11 | Motley | Texas | 48345 | 143 | 8 |
1705701 | 1705701 | 2021-09-10 | Motley | Texas | 48345 | 143 | 8 |
1702451 | 1702451 | 2021-09-09 | Motley | Texas | 48345 | 143 | 8 |
1699202 | 1699202 | 2021-09-08 | Motley | Texas | 48345 | 143 | 8 |
1695954 | 1695954 | 2021-09-07 | Motley | Texas | 48345 | 143 | 8 |
1692706 | 1692706 | 2021-09-06 | Motley | Texas | 48345 | 143 | 8 |
1689457 | 1689457 | 2021-09-05 | Motley | Texas | 48345 | 143 | 8 |
1686207 | 1686207 | 2021-09-04 | Motley | Texas | 48345 | 143 | 8 |
1682956 | 1682956 | 2021-09-03 | Motley | Texas | 48345 | 143 | 8 |
1679706 | 1679706 | 2021-09-02 | Motley | Texas | 48345 | 143 | 8 |
1676458 | 1676458 | 2021-09-01 | Motley | Texas | 48345 | 142 | 8 |
1673211 | 1673211 | 2021-08-31 | Motley | Texas | 48345 | 141 | 8 |
1669963 | 1669963 | 2021-08-30 | Motley | Texas | 48345 | 141 | 8 |
1666716 | 1666716 | 2021-08-29 | Motley | Texas | 48345 | 141 | 8 |
1663468 | 1663468 | 2021-08-28 | Motley | Texas | 48345 | 141 | 8 |
1660220 | 1660220 | 2021-08-27 | Motley | Texas | 48345 | 141 | 8 |
1656971 | 1656971 | 2021-08-26 | Motley | Texas | 48345 | 141 | 8 |
1653724 | 1653724 | 2021-08-25 | Motley | Texas | 48345 | 141 | 8 |
1650477 | 1650477 | 2021-08-24 | Motley | Texas | 48345 | 141 | 8 |
1647228 | 1647228 | 2021-08-23 | Motley | Texas | 48345 | 141 | 8 |
1643979 | 1643979 | 2021-08-22 | Motley | Texas | 48345 | 141 | 8 |
1640729 | 1640729 | 2021-08-21 | Motley | Texas | 48345 | 141 | 8 |
1637479 | 1637479 | 2021-08-20 | Motley | Texas | 48345 | 141 | 8 |
1634229 | 1634229 | 2021-08-19 | Motley | Texas | 48345 | 141 | 8 |
1630982 | 1630982 | 2021-08-18 | Motley | Texas | 48345 | 141 | 8 |
1627735 | 1627735 | 2021-08-17 | Motley | Texas | 48345 | 141 | 8 |
1624488 | 1624488 | 2021-08-16 | Motley | Texas | 48345 | 141 | 8 |
1621241 | 1621241 | 2021-08-15 | Motley | Texas | 48345 | 141 | 8 |
1617993 | 1617993 | 2021-08-14 | Motley | Texas | 48345 | 141 | 8 |
1614745 | 1614745 | 2021-08-13 | Motley | Texas | 48345 | 141 | 8 |
1611496 | 1611496 | 2021-08-12 | Motley | Texas | 48345 | 141 | 8 |
1608248 | 1608248 | 2021-08-11 | Motley | Texas | 48345 | 141 | 8 |
1604999 | 1604999 | 2021-08-10 | Motley | Texas | 48345 | 122 | 8 |
1601750 | 1601750 | 2021-08-09 | Motley | Texas | 48345 | 122 | 8 |
1598502 | 1598502 | 2021-08-08 | Motley | Texas | 48345 | 122 | 8 |
1595253 | 1595253 | 2021-08-07 | Motley | Texas | 48345 | 122 | 8 |
1592004 | 1592004 | 2021-08-06 | Motley | Texas | 48345 | 122 | 8 |
1588755 | 1588755 | 2021-08-05 | Motley | Texas | 48345 | 122 | 8 |
1585505 | 1585505 | 2021-08-04 | Motley | Texas | 48345 | 122 | 8 |
1582255 | 1582255 | 2021-08-03 | Motley | Texas | 48345 | 122 | 8 |
1579006 | 1579006 | 2021-08-02 | Motley | Texas | 48345 | 123 | 8 |
1575758 | 1575758 | 2021-08-01 | Motley | Texas | 48345 | 123 | 8 |
1572510 | 1572510 | 2021-07-31 | Motley | Texas | 48345 | 123 | 8 |
1569262 | 1569262 | 2021-07-30 | Motley | Texas | 48345 | 122 | 8 |
1566014 | 1566014 | 2021-07-29 | Motley | Texas | 48345 | 122 | 8 |
1562766 | 1562766 | 2021-07-28 | Motley | Texas | 48345 | 121 | 8 |
1559518 | 1559518 | 2021-07-27 | Motley | Texas | 48345 | 119 | 8 |
1556271 | 1556271 | 2021-07-26 | Motley | Texas | 48345 | 119 | 8 |
1553024 | 1553024 | 2021-07-25 | Motley | Texas | 48345 | 119 | 8 |
1549777 | 1549777 | 2021-07-24 | Motley | Texas | 48345 | 119 | 8 |
1546530 | 1546530 | 2021-07-23 | Motley | Texas | 48345 | 118 | 8 |
1543283 | 1543283 | 2021-07-22 | Motley | Texas | 48345 | 118 | 8 |
1540035 | 1540035 | 2021-07-21 | Motley | Texas | 48345 | 118 | 8 |
1536788 | 1536788 | 2021-07-20 | Motley | Texas | 48345 | 118 | 8 |
1533540 | 1533540 | 2021-07-19 | Motley | Texas | 48345 | 118 | 8 |
1530293 | 1530293 | 2021-07-18 | Motley | Texas | 48345 | 118 | 8 |
1527046 | 1527046 | 2021-07-17 | Motley | Texas | 48345 | 118 | 8 |
1523799 | 1523799 | 2021-07-16 | Motley | Texas | 48345 | 118 | 8 |
1520551 | 1520551 | 2021-07-15 | Motley | Texas | 48345 | 118 | 8 |
1517303 | 1517303 | 2021-07-14 | Motley | Texas | 48345 | 118 | 8 |
1514056 | 1514056 | 2021-07-13 | Motley | Texas | 48345 | 118 | 8 |
1510810 | 1510810 | 2021-07-12 | Motley | Texas | 48345 | 118 | 8 |
1507563 | 1507563 | 2021-07-11 | Motley | Texas | 48345 | 118 | 8 |
1504317 | 1504317 | 2021-07-10 | Motley | Texas | 48345 | 118 | 8 |
1501071 | 1501071 | 2021-07-09 | Motley | Texas | 48345 | 118 | 8 |
1497825 | 1497825 | 2021-07-08 | Motley | Texas | 48345 | 118 | 8 |
1494578 | 1494578 | 2021-07-07 | Motley | Texas | 48345 | 118 | 8 |
1491331 | 1491331 | 2021-07-06 | Motley | Texas | 48345 | 118 | 8 |
1488084 | 1488084 | 2021-07-05 | Motley | Texas | 48345 | 118 | 8 |
1484837 | 1484837 | 2021-07-04 | Motley | Texas | 48345 | 118 | 8 |
1481591 | 1481591 | 2021-07-03 | Motley | Texas | 48345 | 118 | 8 |
1478344 | 1478344 | 2021-07-02 | Motley | Texas | 48345 | 118 | 8 |
1475098 | 1475098 | 2021-07-01 | Motley | Texas | 48345 | 118 | 8 |
1471852 | 1471852 | 2021-06-30 | Motley | Texas | 48345 | 118 | 8 |
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);