ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Chaffee" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810370 | 1810370 | 2021-10-13 | Chaffee | Colorado | 8015 | 2159 | 30 |
1807121 | 1807121 | 2021-10-12 | Chaffee | Colorado | 8015 | 2154 | 30 |
1803870 | 1803870 | 2021-10-11 | Chaffee | Colorado | 8015 | 2148 | 30 |
1800621 | 1800621 | 2021-10-10 | Chaffee | Colorado | 8015 | 2135 | 30 |
1797372 | 1797372 | 2021-10-09 | Chaffee | Colorado | 8015 | 2135 | 30 |
1794123 | 1794123 | 2021-10-08 | Chaffee | Colorado | 8015 | 2135 | 30 |
1790875 | 1790875 | 2021-10-07 | Chaffee | Colorado | 8015 | 2133 | 29 |
1787626 | 1787626 | 2021-10-06 | Chaffee | Colorado | 8015 | 2126 | 28 |
1784377 | 1784377 | 2021-10-05 | Chaffee | Colorado | 8015 | 2111 | 28 |
1781128 | 1781128 | 2021-10-04 | Chaffee | Colorado | 8015 | 2109 | 28 |
1777878 | 1777878 | 2021-10-03 | Chaffee | Colorado | 8015 | 2103 | 28 |
1774628 | 1774628 | 2021-10-02 | Chaffee | Colorado | 8015 | 2103 | 28 |
1771378 | 1771378 | 2021-10-01 | Chaffee | Colorado | 8015 | 2103 | 28 |
1768129 | 1768129 | 2021-09-30 | Chaffee | Colorado | 8015 | 2089 | 28 |
1764880 | 1764880 | 2021-09-29 | Chaffee | Colorado | 8015 | 2081 | 28 |
1761631 | 1761631 | 2021-09-28 | Chaffee | Colorado | 8015 | 2075 | 28 |
1758383 | 1758383 | 2021-09-27 | Chaffee | Colorado | 8015 | 2068 | 28 |
1755135 | 1755135 | 2021-09-26 | Chaffee | Colorado | 8015 | 2056 | 28 |
1751887 | 1751887 | 2021-09-25 | Chaffee | Colorado | 8015 | 2056 | 28 |
1748638 | 1748638 | 2021-09-24 | Chaffee | Colorado | 8015 | 2056 | 28 |
1745388 | 1745388 | 2021-09-23 | Chaffee | Colorado | 8015 | 2054 | 28 |
1742139 | 1742139 | 2021-09-22 | Chaffee | Colorado | 8015 | 2050 | 28 |
1738890 | 1738890 | 2021-09-21 | Chaffee | Colorado | 8015 | 2044 | 27 |
1735641 | 1735641 | 2021-09-20 | Chaffee | Colorado | 8015 | 2039 | 27 |
1732391 | 1732391 | 2021-09-19 | Chaffee | Colorado | 8015 | 2027 | 27 |
1729141 | 1729141 | 2021-09-18 | Chaffee | Colorado | 8015 | 2027 | 27 |
1725891 | 1725891 | 2021-09-17 | Chaffee | Colorado | 8015 | 2027 | 27 |
1722642 | 1722642 | 2021-09-16 | Chaffee | Colorado | 8015 | 2021 | 26 |
1719393 | 1719393 | 2021-09-15 | Chaffee | Colorado | 8015 | 2015 | 26 |
1716145 | 1716145 | 2021-09-14 | Chaffee | Colorado | 8015 | 2010 | 26 |
1712899 | 1712899 | 2021-09-13 | Chaffee | Colorado | 8015 | 2007 | 26 |
1709652 | 1709652 | 2021-09-12 | Chaffee | Colorado | 8015 | 1992 | 26 |
1706405 | 1706405 | 2021-09-11 | Chaffee | Colorado | 8015 | 1992 | 26 |
1703157 | 1703157 | 2021-09-10 | Chaffee | Colorado | 8015 | 1992 | 26 |
1699907 | 1699907 | 2021-09-09 | Chaffee | Colorado | 8015 | 1985 | 26 |
1696658 | 1696658 | 2021-09-08 | Chaffee | Colorado | 8015 | 1978 | 26 |
1693410 | 1693410 | 2021-09-07 | Chaffee | Colorado | 8015 | 1970 | 26 |
1690161 | 1690161 | 2021-09-06 | Chaffee | Colorado | 8015 | 1967 | 26 |
1686911 | 1686911 | 2021-09-05 | Chaffee | Colorado | 8015 | 1963 | 26 |
1683661 | 1683661 | 2021-09-04 | Chaffee | Colorado | 8015 | 1963 | 26 |
1680410 | 1680410 | 2021-09-03 | Chaffee | Colorado | 8015 | 1963 | 26 |
1677162 | 1677162 | 2021-09-02 | Chaffee | Colorado | 8015 | 1959 | 26 |
1673915 | 1673915 | 2021-09-01 | Chaffee | Colorado | 8015 | 1956 | 26 |
1670667 | 1670667 | 2021-08-31 | Chaffee | Colorado | 8015 | 1950 | 26 |
1667420 | 1667420 | 2021-08-30 | Chaffee | Colorado | 8015 | 1944 | 26 |
1664173 | 1664173 | 2021-08-29 | Chaffee | Colorado | 8015 | 1934 | 26 |
1660925 | 1660925 | 2021-08-28 | Chaffee | Colorado | 8015 | 1934 | 26 |
1657677 | 1657677 | 2021-08-27 | Chaffee | Colorado | 8015 | 1934 | 26 |
1654429 | 1654429 | 2021-08-26 | Chaffee | Colorado | 8015 | 1931 | 26 |
1651182 | 1651182 | 2021-08-25 | Chaffee | Colorado | 8015 | 1924 | 25 |
1647933 | 1647933 | 2021-08-24 | Chaffee | Colorado | 8015 | 1919 | 25 |
1644685 | 1644685 | 2021-08-23 | Chaffee | Colorado | 8015 | 1913 | 25 |
1641435 | 1641435 | 2021-08-22 | Chaffee | Colorado | 8015 | 1894 | 25 |
1638185 | 1638185 | 2021-08-21 | Chaffee | Colorado | 8015 | 1894 | 25 |
1634935 | 1634935 | 2021-08-20 | Chaffee | Colorado | 8015 | 1894 | 25 |
1631686 | 1631686 | 2021-08-19 | Chaffee | Colorado | 8015 | 1889 | 25 |
1628439 | 1628439 | 2021-08-18 | Chaffee | Colorado | 8015 | 1886 | 25 |
1625192 | 1625192 | 2021-08-17 | Chaffee | Colorado | 8015 | 1884 | 25 |
1621945 | 1621945 | 2021-08-16 | Chaffee | Colorado | 8015 | 1879 | 25 |
1618698 | 1618698 | 2021-08-15 | Chaffee | Colorado | 8015 | 1873 | 25 |
1615450 | 1615450 | 2021-08-14 | Chaffee | Colorado | 8015 | 1873 | 25 |
1612201 | 1612201 | 2021-08-13 | Chaffee | Colorado | 8015 | 1873 | 25 |
1608953 | 1608953 | 2021-08-12 | Chaffee | Colorado | 8015 | 1870 | 25 |
1605704 | 1605704 | 2021-08-11 | Chaffee | Colorado | 8015 | 1866 | 25 |
1602455 | 1602455 | 2021-08-10 | Chaffee | Colorado | 8015 | 1862 | 25 |
1599206 | 1599206 | 2021-08-09 | Chaffee | Colorado | 8015 | 1859 | 25 |
1595957 | 1595957 | 2021-08-08 | Chaffee | Colorado | 8015 | 1857 | 25 |
1592708 | 1592708 | 2021-08-07 | Chaffee | Colorado | 8015 | 1857 | 25 |
1589459 | 1589459 | 2021-08-06 | Chaffee | Colorado | 8015 | 1857 | 25 |
1586210 | 1586210 | 2021-08-05 | Chaffee | Colorado | 8015 | 1855 | 25 |
1582960 | 1582960 | 2021-08-04 | Chaffee | Colorado | 8015 | 1854 | 25 |
1579710 | 1579710 | 2021-08-03 | Chaffee | Colorado | 8015 | 1849 | 25 |
1576462 | 1576462 | 2021-08-02 | Chaffee | Colorado | 8015 | 1848 | 25 |
1573214 | 1573214 | 2021-08-01 | Chaffee | Colorado | 8015 | 1837 | 25 |
1569966 | 1569966 | 2021-07-31 | Chaffee | Colorado | 8015 | 1837 | 25 |
1566718 | 1566718 | 2021-07-30 | Chaffee | Colorado | 8015 | 1837 | 25 |
1563470 | 1563470 | 2021-07-29 | Chaffee | Colorado | 8015 | 1831 | 25 |
1560222 | 1560222 | 2021-07-28 | Chaffee | Colorado | 8015 | 1828 | 25 |
1556975 | 1556975 | 2021-07-27 | Chaffee | Colorado | 8015 | 1819 | 25 |
1553728 | 1553728 | 2021-07-26 | Chaffee | Colorado | 8015 | 1819 | 25 |
1550481 | 1550481 | 2021-07-25 | Chaffee | Colorado | 8015 | 1812 | 25 |
1547234 | 1547234 | 2021-07-24 | Chaffee | Colorado | 8015 | 1812 | 25 |
1543987 | 1543987 | 2021-07-23 | Chaffee | Colorado | 8015 | 1812 | 25 |
1540739 | 1540739 | 2021-07-22 | Chaffee | Colorado | 8015 | 1808 | 25 |
1537492 | 1537492 | 2021-07-21 | Chaffee | Colorado | 8015 | 1807 | 25 |
1534244 | 1534244 | 2021-07-20 | Chaffee | Colorado | 8015 | 1799 | 25 |
1530997 | 1530997 | 2021-07-19 | Chaffee | Colorado | 8015 | 1799 | 25 |
1527750 | 1527750 | 2021-07-18 | Chaffee | Colorado | 8015 | 1795 | 25 |
1524503 | 1524503 | 2021-07-17 | Chaffee | Colorado | 8015 | 1795 | 25 |
1521255 | 1521255 | 2021-07-16 | Chaffee | Colorado | 8015 | 1795 | 25 |
1518007 | 1518007 | 2021-07-15 | Chaffee | Colorado | 8015 | 1795 | 25 |
1514760 | 1514760 | 2021-07-14 | Chaffee | Colorado | 8015 | 1791 | 25 |
1511514 | 1511514 | 2021-07-13 | Chaffee | Colorado | 8015 | 1787 | 25 |
1508267 | 1508267 | 2021-07-12 | Chaffee | Colorado | 8015 | 1785 | 25 |
1505021 | 1505021 | 2021-07-11 | Chaffee | Colorado | 8015 | 1783 | 25 |
1501775 | 1501775 | 2021-07-10 | Chaffee | Colorado | 8015 | 1783 | 25 |
1498529 | 1498529 | 2021-07-09 | Chaffee | Colorado | 8015 | 1782 | 25 |
1495282 | 1495282 | 2021-07-08 | Chaffee | Colorado | 8015 | 1780 | 25 |
1492036 | 1492036 | 2021-07-07 | Chaffee | Colorado | 8015 | 1779 | 25 |
1488789 | 1488789 | 2021-07-06 | Chaffee | Colorado | 8015 | 1778 | 25 |
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);