ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 8051 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946867 | 1946867 | 2021-11-24 | Gunnison | Colorado | 8051 | 1974 | 12 |
1943616 | 1943616 | 2021-11-23 | Gunnison | Colorado | 8051 | 1966 | 12 |
1940366 | 1940366 | 2021-11-22 | Gunnison | Colorado | 8051 | 1961 | 12 |
1937116 | 1937116 | 2021-11-21 | Gunnison | Colorado | 8051 | 1939 | 12 |
1933866 | 1933866 | 2021-11-20 | Gunnison | Colorado | 8051 | 1939 | 12 |
1930614 | 1930614 | 2021-11-19 | Gunnison | Colorado | 8051 | 1939 | 12 |
1927364 | 1927364 | 2021-11-18 | Gunnison | Colorado | 8051 | 1935 | 12 |
1924114 | 1924114 | 2021-11-17 | Gunnison | Colorado | 8051 | 1919 | 12 |
1920865 | 1920865 | 2021-11-16 | Gunnison | Colorado | 8051 | 1910 | 12 |
1917615 | 1917615 | 2021-11-15 | Gunnison | Colorado | 8051 | 1907 | 12 |
1914365 | 1914365 | 2021-11-14 | Gunnison | Colorado | 8051 | 1895 | 12 |
1911115 | 1911115 | 2021-11-13 | Gunnison | Colorado | 8051 | 1895 | 12 |
1907866 | 1907866 | 2021-11-12 | Gunnison | Colorado | 8051 | 1895 | 12 |
1904617 | 1904617 | 2021-11-11 | Gunnison | Colorado | 8051 | 1891 | 12 |
1901367 | 1901367 | 2021-11-10 | Gunnison | Colorado | 8051 | 1883 | 12 |
1898117 | 1898117 | 2021-11-09 | Gunnison | Colorado | 8051 | 1879 | 12 |
1894867 | 1894867 | 2021-11-08 | Gunnison | Colorado | 8051 | 1872 | 12 |
1891617 | 1891617 | 2021-11-07 | Gunnison | Colorado | 8051 | 1863 | 12 |
1888367 | 1888367 | 2021-11-06 | Gunnison | Colorado | 8051 | 1863 | 12 |
1885117 | 1885117 | 2021-11-05 | Gunnison | Colorado | 8051 | 1863 | 12 |
1881868 | 1881868 | 2021-11-04 | Gunnison | Colorado | 8051 | 1858 | 12 |
1878619 | 1878619 | 2021-11-03 | Gunnison | Colorado | 8051 | 1852 | 12 |
1875370 | 1875370 | 2021-11-02 | Gunnison | Colorado | 8051 | 1847 | 12 |
1872121 | 1872121 | 2021-11-01 | Gunnison | Colorado | 8051 | 1847 | 12 |
1868872 | 1868872 | 2021-10-31 | Gunnison | Colorado | 8051 | 1840 | 12 |
1865623 | 1865623 | 2021-10-30 | Gunnison | Colorado | 8051 | 1840 | 12 |
1862374 | 1862374 | 2021-10-29 | Gunnison | Colorado | 8051 | 1840 | 12 |
1859125 | 1859125 | 2021-10-28 | Gunnison | Colorado | 8051 | 1838 | 12 |
1855876 | 1855876 | 2021-10-27 | Gunnison | Colorado | 8051 | 1830 | 12 |
1852627 | 1852627 | 2021-10-26 | Gunnison | Colorado | 8051 | 1827 | 12 |
1849378 | 1849378 | 2021-10-25 | Gunnison | Colorado | 8051 | 1824 | 12 |
1846128 | 1846128 | 2021-10-24 | Gunnison | Colorado | 8051 | 1817 | 12 |
1842878 | 1842878 | 2021-10-23 | Gunnison | Colorado | 8051 | 1817 | 12 |
1839628 | 1839628 | 2021-10-22 | Gunnison | Colorado | 8051 | 1817 | 12 |
1836379 | 1836379 | 2021-10-21 | Gunnison | Colorado | 8051 | 1814 | 11 |
1833130 | 1833130 | 2021-10-20 | Gunnison | Colorado | 8051 | 1809 | 11 |
1829881 | 1829881 | 2021-10-19 | Gunnison | Colorado | 8051 | 1808 | 11 |
1826632 | 1826632 | 2021-10-18 | Gunnison | Colorado | 8051 | 1808 | 11 |
1823383 | 1823383 | 2021-10-17 | Gunnison | Colorado | 8051 | 1803 | 10 |
1820134 | 1820134 | 2021-10-16 | Gunnison | Colorado | 8051 | 1803 | 10 |
1816885 | 1816885 | 2021-10-15 | Gunnison | Colorado | 8051 | 1803 | 10 |
1813637 | 1813637 | 2021-10-14 | Gunnison | Colorado | 8051 | 1799 | 10 |
1810388 | 1810388 | 2021-10-13 | Gunnison | Colorado | 8051 | 1794 | 10 |
1807139 | 1807139 | 2021-10-12 | Gunnison | Colorado | 8051 | 1788 | 10 |
1803888 | 1803888 | 2021-10-11 | Gunnison | Colorado | 8051 | 1785 | 9 |
1800639 | 1800639 | 2021-10-10 | Gunnison | Colorado | 8051 | 1778 | 9 |
1797390 | 1797390 | 2021-10-09 | Gunnison | Colorado | 8051 | 1778 | 9 |
1794141 | 1794141 | 2021-10-08 | Gunnison | Colorado | 8051 | 1778 | 9 |
1790893 | 1790893 | 2021-10-07 | Gunnison | Colorado | 8051 | 1772 | 9 |
1787644 | 1787644 | 2021-10-06 | Gunnison | Colorado | 8051 | 1762 | 9 |
1784395 | 1784395 | 2021-10-05 | Gunnison | Colorado | 8051 | 1759 | 9 |
1781146 | 1781146 | 2021-10-04 | Gunnison | Colorado | 8051 | 1756 | 9 |
1777896 | 1777896 | 2021-10-03 | Gunnison | Colorado | 8051 | 1746 | 9 |
1774646 | 1774646 | 2021-10-02 | Gunnison | Colorado | 8051 | 1746 | 9 |
1771396 | 1771396 | 2021-10-01 | Gunnison | Colorado | 8051 | 1746 | 9 |
1768147 | 1768147 | 2021-09-30 | Gunnison | Colorado | 8051 | 1737 | 9 |
1764898 | 1764898 | 2021-09-29 | Gunnison | Colorado | 8051 | 1735 | 9 |
1761649 | 1761649 | 2021-09-28 | Gunnison | Colorado | 8051 | 1734 | 8 |
1758401 | 1758401 | 2021-09-27 | Gunnison | Colorado | 8051 | 1730 | 8 |
1755153 | 1755153 | 2021-09-26 | Gunnison | Colorado | 8051 | 1716 | 8 |
1751905 | 1751905 | 2021-09-25 | Gunnison | Colorado | 8051 | 1716 | 8 |
1748656 | 1748656 | 2021-09-24 | Gunnison | Colorado | 8051 | 1716 | 8 |
1745406 | 1745406 | 2021-09-23 | Gunnison | Colorado | 8051 | 1711 | 8 |
1742157 | 1742157 | 2021-09-22 | Gunnison | Colorado | 8051 | 1697 | 8 |
1738908 | 1738908 | 2021-09-21 | Gunnison | Colorado | 8051 | 1694 | 8 |
1735659 | 1735659 | 2021-09-20 | Gunnison | Colorado | 8051 | 1691 | 8 |
1732409 | 1732409 | 2021-09-19 | Gunnison | Colorado | 8051 | 1676 | 8 |
1729159 | 1729159 | 2021-09-18 | Gunnison | Colorado | 8051 | 1676 | 8 |
1725909 | 1725909 | 2021-09-17 | Gunnison | Colorado | 8051 | 1676 | 8 |
1722660 | 1722660 | 2021-09-16 | Gunnison | Colorado | 8051 | 1669 | 8 |
1719411 | 1719411 | 2021-09-15 | Gunnison | Colorado | 8051 | 1659 | 8 |
1716163 | 1716163 | 2021-09-14 | Gunnison | Colorado | 8051 | 1657 | 8 |
1712917 | 1712917 | 2021-09-13 | Gunnison | Colorado | 8051 | 1651 | 8 |
1709670 | 1709670 | 2021-09-12 | Gunnison | Colorado | 8051 | 1611 | 8 |
1706423 | 1706423 | 2021-09-11 | Gunnison | Colorado | 8051 | 1611 | 8 |
1703175 | 1703175 | 2021-09-10 | Gunnison | Colorado | 8051 | 1611 | 8 |
1699925 | 1699925 | 2021-09-09 | Gunnison | Colorado | 8051 | 1610 | 8 |
1696676 | 1696676 | 2021-09-08 | Gunnison | Colorado | 8051 | 1612 | 8 |
1693428 | 1693428 | 2021-09-07 | Gunnison | Colorado | 8051 | 1609 | 8 |
1690179 | 1690179 | 2021-09-06 | Gunnison | Colorado | 8051 | 1601 | 8 |
1686929 | 1686929 | 2021-09-05 | Gunnison | Colorado | 8051 | 1578 | 8 |
1683679 | 1683679 | 2021-09-04 | Gunnison | Colorado | 8051 | 1578 | 8 |
1680428 | 1680428 | 2021-09-03 | Gunnison | Colorado | 8051 | 1578 | 8 |
1677180 | 1677180 | 2021-09-02 | Gunnison | Colorado | 8051 | 1575 | 8 |
1673933 | 1673933 | 2021-09-01 | Gunnison | Colorado | 8051 | 1570 | 7 |
1670685 | 1670685 | 2021-08-31 | Gunnison | Colorado | 8051 | 1560 | 7 |
1667438 | 1667438 | 2021-08-30 | Gunnison | Colorado | 8051 | 1550 | 7 |
1664191 | 1664191 | 2021-08-29 | Gunnison | Colorado | 8051 | 1535 | 7 |
1660943 | 1660943 | 2021-08-28 | Gunnison | Colorado | 8051 | 1535 | 7 |
1657695 | 1657695 | 2021-08-27 | Gunnison | Colorado | 8051 | 1535 | 7 |
1654447 | 1654447 | 2021-08-26 | Gunnison | Colorado | 8051 | 1534 | 7 |
1651200 | 1651200 | 2021-08-25 | Gunnison | Colorado | 8051 | 1516 | 7 |
1647951 | 1647951 | 2021-08-24 | Gunnison | Colorado | 8051 | 1511 | 7 |
1644703 | 1644703 | 2021-08-23 | Gunnison | Colorado | 8051 | 1506 | 7 |
1641453 | 1641453 | 2021-08-22 | Gunnison | Colorado | 8051 | 1484 | 7 |
1638203 | 1638203 | 2021-08-21 | Gunnison | Colorado | 8051 | 1484 | 7 |
1634953 | 1634953 | 2021-08-20 | Gunnison | Colorado | 8051 | 1484 | 7 |
1631704 | 1631704 | 2021-08-19 | Gunnison | Colorado | 8051 | 1477 | 7 |
1628457 | 1628457 | 2021-08-18 | Gunnison | Colorado | 8051 | 1476 | 7 |
1625210 | 1625210 | 2021-08-17 | Gunnison | Colorado | 8051 | 1473 | 7 |
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);