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 |
---|---|---|---|---|---|---|---|
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 |
1485542 | 1485542 | 2021-07-05 | Chaffee | Colorado | 8015 | 1778 | 25 |
1482296 | 1482296 | 2021-07-04 | Chaffee | Colorado | 8015 | 1778 | 25 |
1479049 | 1479049 | 2021-07-03 | Chaffee | Colorado | 8015 | 1778 | 25 |
1475803 | 1475803 | 2021-07-02 | Chaffee | Colorado | 8015 | 1777 | 25 |
1472557 | 1472557 | 2021-07-01 | Chaffee | Colorado | 8015 | 1773 | 25 |
1469311 | 1469311 | 2021-06-30 | Chaffee | Colorado | 8015 | 1773 | 25 |
1466066 | 1466066 | 2021-06-29 | Chaffee | Colorado | 8015 | 1770 | 25 |
1462821 | 1462821 | 2021-06-28 | Chaffee | Colorado | 8015 | 1767 | 25 |
1459576 | 1459576 | 2021-06-27 | Chaffee | Colorado | 8015 | 1766 | 25 |
1456331 | 1456331 | 2021-06-26 | Chaffee | Colorado | 8015 | 1766 | 25 |
1453086 | 1453086 | 2021-06-25 | Chaffee | Colorado | 8015 | 1764 | 25 |
1449840 | 1449840 | 2021-06-24 | Chaffee | Colorado | 8015 | 1762 | 25 |
1446595 | 1446595 | 2021-06-23 | Chaffee | Colorado | 8015 | 1760 | 25 |
1443350 | 1443350 | 2021-06-22 | Chaffee | Colorado | 8015 | 1759 | 25 |
1440105 | 1440105 | 2021-06-21 | Chaffee | Colorado | 8015 | 1756 | 25 |
1436858 | 1436858 | 2021-06-20 | Chaffee | Colorado | 8015 | 1753 | 25 |
1433611 | 1433611 | 2021-06-19 | Chaffee | Colorado | 8015 | 1753 | 25 |
1430365 | 1430365 | 2021-06-18 | Chaffee | Colorado | 8015 | 1752 | 25 |
1427120 | 1427120 | 2021-06-17 | Chaffee | Colorado | 8015 | 1750 | 25 |
1423875 | 1423875 | 2021-06-16 | Chaffee | Colorado | 8015 | 1749 | 26 |
1420627 | 1420627 | 2021-06-15 | Chaffee | Colorado | 8015 | 1748 | 25 |
1417382 | 1417382 | 2021-06-14 | Chaffee | Colorado | 8015 | 1747 | 25 |
1414136 | 1414136 | 2021-06-13 | Chaffee | Colorado | 8015 | 1747 | 25 |
1410891 | 1410891 | 2021-06-12 | Chaffee | Colorado | 8015 | 1747 | 25 |
1407646 | 1407646 | 2021-06-11 | Chaffee | Colorado | 8015 | 1747 | 25 |
1404400 | 1404400 | 2021-06-10 | Chaffee | Colorado | 8015 | 1744 | 25 |
1401155 | 1401155 | 2021-06-09 | Chaffee | Colorado | 8015 | 1743 | 25 |
1397910 | 1397910 | 2021-06-08 | Chaffee | Colorado | 8015 | 1738 | 25 |
1394663 | 1394663 | 2021-06-07 | Chaffee | Colorado | 8015 | 1738 | 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);