ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Anderson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812646 | 1812646 | 2021-10-13 | Anderson | Tennessee | 47001 | 12684 | 211 |
1809397 | 1809397 | 2021-10-12 | Anderson | Tennessee | 47001 | 12648 | 209 |
1806147 | 1806147 | 2021-10-11 | Anderson | Tennessee | 47001 | 12608 | 209 |
1802897 | 1802897 | 2021-10-10 | Anderson | Tennessee | 47001 | 12548 | 208 |
1799648 | 1799648 | 2021-10-09 | Anderson | Tennessee | 47001 | 12548 | 208 |
1796399 | 1796399 | 2021-10-08 | Anderson | Tennessee | 47001 | 12548 | 208 |
1793150 | 1793150 | 2021-10-07 | Anderson | Tennessee | 47001 | 12483 | 208 |
1789901 | 1789901 | 2021-10-06 | Anderson | Tennessee | 47001 | 12456 | 207 |
1786653 | 1786653 | 2021-10-05 | Anderson | Tennessee | 47001 | 12430 | 205 |
1783404 | 1783404 | 2021-10-04 | Anderson | Tennessee | 47001 | 12411 | 204 |
1780155 | 1780155 | 2021-10-03 | Anderson | Tennessee | 47001 | 12333 | 199 |
1776905 | 1776905 | 2021-10-02 | Anderson | Tennessee | 47001 | 12333 | 199 |
1773655 | 1773655 | 2021-10-01 | Anderson | Tennessee | 47001 | 12333 | 199 |
1770405 | 1770405 | 2021-09-30 | Anderson | Tennessee | 47001 | 12273 | 199 |
1767156 | 1767156 | 2021-09-29 | Anderson | Tennessee | 47001 | 12236 | 198 |
1763907 | 1763907 | 2021-09-28 | Anderson | Tennessee | 47001 | 12190 | 198 |
1760658 | 1760658 | 2021-09-27 | Anderson | Tennessee | 47001 | 12132 | 197 |
1757410 | 1757410 | 2021-09-26 | Anderson | Tennessee | 47001 | 12065 | 194 |
1754162 | 1754162 | 2021-09-25 | Anderson | Tennessee | 47001 | 12065 | 194 |
1750914 | 1750914 | 2021-09-24 | Anderson | Tennessee | 47001 | 12065 | 194 |
1747665 | 1747665 | 2021-09-23 | Anderson | Tennessee | 47001 | 11992 | 192 |
1744415 | 1744415 | 2021-09-22 | Anderson | Tennessee | 47001 | 11954 | 192 |
1741166 | 1741166 | 2021-09-21 | Anderson | Tennessee | 47001 | 11839 | 191 |
1737917 | 1737917 | 2021-09-20 | Anderson | Tennessee | 47001 | 11839 | 191 |
1734667 | 1734667 | 2021-09-19 | Anderson | Tennessee | 47001 | 11678 | 191 |
1731417 | 1731417 | 2021-09-18 | Anderson | Tennessee | 47001 | 11678 | 191 |
1728167 | 1728167 | 2021-09-17 | Anderson | Tennessee | 47001 | 11678 | 191 |
1724918 | 1724918 | 2021-09-16 | Anderson | Tennessee | 47001 | 11593 | 191 |
1721669 | 1721669 | 2021-09-15 | Anderson | Tennessee | 47001 | 11535 | 191 |
1718421 | 1718421 | 2021-09-14 | Anderson | Tennessee | 47001 | 11490 | 190 |
1715173 | 1715173 | 2021-09-13 | Anderson | Tennessee | 47001 | 11411 | 186 |
1711927 | 1711927 | 2021-09-12 | Anderson | Tennessee | 47001 | 11107 | 185 |
1708680 | 1708680 | 2021-09-11 | Anderson | Tennessee | 47001 | 11107 | 185 |
1705433 | 1705433 | 2021-09-10 | Anderson | Tennessee | 47001 | 11107 | 185 |
1702183 | 1702183 | 2021-09-09 | Anderson | Tennessee | 47001 | 11052 | 185 |
1698934 | 1698934 | 2021-09-08 | Anderson | Tennessee | 47001 | 10997 | 185 |
1695686 | 1695686 | 2021-09-07 | Anderson | Tennessee | 47001 | 10960 | 185 |
1692438 | 1692438 | 2021-09-06 | Anderson | Tennessee | 47001 | 10604 | 185 |
1689189 | 1689189 | 2021-09-05 | Anderson | Tennessee | 47001 | 10604 | 185 |
1685939 | 1685939 | 2021-09-04 | Anderson | Tennessee | 47001 | 10604 | 185 |
1682688 | 1682688 | 2021-09-03 | Anderson | Tennessee | 47001 | 10604 | 185 |
1679438 | 1679438 | 2021-09-02 | Anderson | Tennessee | 47001 | 10542 | 184 |
1676190 | 1676190 | 2021-09-01 | Anderson | Tennessee | 47001 | 10510 | 184 |
1672943 | 1672943 | 2021-08-31 | Anderson | Tennessee | 47001 | 10375 | 184 |
1669695 | 1669695 | 2021-08-30 | Anderson | Tennessee | 47001 | 10303 | 184 |
1666448 | 1666448 | 2021-08-29 | Anderson | Tennessee | 47001 | 10115 | 184 |
1663200 | 1663200 | 2021-08-28 | Anderson | Tennessee | 47001 | 10115 | 184 |
1659952 | 1659952 | 2021-08-27 | Anderson | Tennessee | 47001 | 10115 | 184 |
1656703 | 1656703 | 2021-08-26 | Anderson | Tennessee | 47001 | 10038 | 183 |
1653456 | 1653456 | 2021-08-25 | Anderson | Tennessee | 47001 | 9922 | 182 |
1650209 | 1650209 | 2021-08-24 | Anderson | Tennessee | 47001 | 9922 | 182 |
1646960 | 1646960 | 2021-08-23 | Anderson | Tennessee | 47001 | 9873 | 182 |
1643711 | 1643711 | 2021-08-22 | Anderson | Tennessee | 47001 | 9709 | 182 |
1640461 | 1640461 | 2021-08-21 | Anderson | Tennessee | 47001 | 9709 | 182 |
1637211 | 1637211 | 2021-08-20 | Anderson | Tennessee | 47001 | 9709 | 182 |
1633961 | 1633961 | 2021-08-19 | Anderson | Tennessee | 47001 | 9635 | 182 |
1630714 | 1630714 | 2021-08-18 | Anderson | Tennessee | 47001 | 9582 | 182 |
1627467 | 1627467 | 2021-08-17 | Anderson | Tennessee | 47001 | 9535 | 181 |
1624220 | 1624220 | 2021-08-16 | Anderson | Tennessee | 47001 | 9500 | 181 |
1620973 | 1620973 | 2021-08-15 | Anderson | Tennessee | 47001 | 9360 | 179 |
1617725 | 1617725 | 2021-08-14 | Anderson | Tennessee | 47001 | 9360 | 179 |
1614477 | 1614477 | 2021-08-13 | Anderson | Tennessee | 47001 | 9360 | 179 |
1611228 | 1611228 | 2021-08-12 | Anderson | Tennessee | 47001 | 9310 | 179 |
1607980 | 1607980 | 2021-08-11 | Anderson | Tennessee | 47001 | 9256 | 179 |
1604731 | 1604731 | 2021-08-10 | Anderson | Tennessee | 47001 | 9222 | 179 |
1601482 | 1601482 | 2021-08-09 | Anderson | Tennessee | 47001 | 9186 | 179 |
1598234 | 1598234 | 2021-08-08 | Anderson | Tennessee | 47001 | 9132 | 179 |
1594985 | 1594985 | 2021-08-07 | Anderson | Tennessee | 47001 | 9132 | 179 |
1591736 | 1591736 | 2021-08-06 | Anderson | Tennessee | 47001 | 9132 | 179 |
1588487 | 1588487 | 2021-08-05 | Anderson | Tennessee | 47001 | 9107 | 179 |
1585237 | 1585237 | 2021-08-04 | Anderson | Tennessee | 47001 | 9083 | 179 |
1581987 | 1581987 | 2021-08-03 | Anderson | Tennessee | 47001 | 9058 | 179 |
1578738 | 1578738 | 2021-08-02 | Anderson | Tennessee | 47001 | 9048 | 179 |
1575490 | 1575490 | 2021-08-01 | Anderson | Tennessee | 47001 | 8986 | 179 |
1572242 | 1572242 | 2021-07-31 | Anderson | Tennessee | 47001 | 8986 | 179 |
1568994 | 1568994 | 2021-07-30 | Anderson | Tennessee | 47001 | 8986 | 179 |
1565746 | 1565746 | 2021-07-29 | Anderson | Tennessee | 47001 | 8975 | 179 |
1562498 | 1562498 | 2021-07-28 | Anderson | Tennessee | 47001 | 8959 | 179 |
1559250 | 1559250 | 2021-07-27 | Anderson | Tennessee | 47001 | 8938 | 179 |
1556003 | 1556003 | 2021-07-26 | Anderson | Tennessee | 47001 | 8921 | 177 |
1552756 | 1552756 | 2021-07-25 | Anderson | Tennessee | 47001 | 8897 | 177 |
1549509 | 1549509 | 2021-07-24 | Anderson | Tennessee | 47001 | 8897 | 177 |
1546262 | 1546262 | 2021-07-23 | Anderson | Tennessee | 47001 | 8897 | 177 |
1543015 | 1543015 | 2021-07-22 | Anderson | Tennessee | 47001 | 8889 | 177 |
1539767 | 1539767 | 2021-07-21 | Anderson | Tennessee | 47001 | 8883 | 177 |
1536520 | 1536520 | 2021-07-20 | Anderson | Tennessee | 47001 | 8867 | 177 |
1533272 | 1533272 | 2021-07-19 | Anderson | Tennessee | 47001 | 8862 | 176 |
1530025 | 1530025 | 2021-07-18 | Anderson | Tennessee | 47001 | 8844 | 176 |
1526778 | 1526778 | 2021-07-17 | Anderson | Tennessee | 47001 | 8844 | 176 |
1523531 | 1523531 | 2021-07-16 | Anderson | Tennessee | 47001 | 8844 | 176 |
1520283 | 1520283 | 2021-07-15 | Anderson | Tennessee | 47001 | 8840 | 176 |
1517035 | 1517035 | 2021-07-14 | Anderson | Tennessee | 47001 | 8835 | 176 |
1513788 | 1513788 | 2021-07-13 | Anderson | Tennessee | 47001 | 8833 | 176 |
1510542 | 1510542 | 2021-07-12 | Anderson | Tennessee | 47001 | 8826 | 176 |
1507295 | 1507295 | 2021-07-11 | Anderson | Tennessee | 47001 | 8822 | 176 |
1504049 | 1504049 | 2021-07-10 | Anderson | Tennessee | 47001 | 8822 | 176 |
1500803 | 1500803 | 2021-07-09 | Anderson | Tennessee | 47001 | 8822 | 176 |
1497557 | 1497557 | 2021-07-08 | Anderson | Tennessee | 47001 | 8821 | 176 |
1494310 | 1494310 | 2021-07-07 | Anderson | Tennessee | 47001 | 8820 | 176 |
1491063 | 1491063 | 2021-07-06 | Anderson | Tennessee | 47001 | 8820 | 175 |
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);