ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 36029 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1837969 | 1837969 | 2021-10-21 | Erie | New York | 36029 | 106417 | 1949 |
1834720 | 1834720 | 2021-10-20 | Erie | New York | 36029 | 106139 | 1945 |
1831471 | 1831471 | 2021-10-19 | Erie | New York | 36029 | 105791 | 1944 |
1828222 | 1828222 | 2021-10-18 | Erie | New York | 36029 | 105661 | 1940 |
1824973 | 1824973 | 2021-10-17 | Erie | New York | 36029 | 105477 | 1938 |
1821724 | 1821724 | 2021-10-16 | Erie | New York | 36029 | 105215 | 1938 |
1818475 | 1818475 | 2021-10-15 | Erie | New York | 36029 | 104904 | 1934 |
1815226 | 1815226 | 2021-10-14 | Erie | New York | 36029 | 104539 | 1931 |
1811978 | 1811978 | 2021-10-13 | Erie | New York | 36029 | 104339 | 1930 |
1808729 | 1808729 | 2021-10-12 | Erie | New York | 36029 | 104039 | 1927 |
1805478 | 1805478 | 2021-10-11 | Erie | New York | 36029 | 103881 | 1924 |
1802229 | 1802229 | 2021-10-10 | Erie | New York | 36029 | 103604 | 1922 |
1798980 | 1798980 | 2021-10-09 | Erie | New York | 36029 | 103449 | 1920 |
1795731 | 1795731 | 2021-10-08 | Erie | New York | 36029 | 103183 | 1916 |
1792482 | 1792482 | 2021-10-07 | Erie | New York | 36029 | 102820 | 1913 |
1789233 | 1789233 | 2021-10-06 | Erie | New York | 36029 | 102566 | 1911 |
1785985 | 1785985 | 2021-10-05 | Erie | New York | 36029 | 102188 | 1908 |
1782736 | 1782736 | 2021-10-04 | Erie | New York | 36029 | 101993 | 1906 |
1779487 | 1779487 | 2021-10-03 | Erie | New York | 36029 | 101835 | 1905 |
1776237 | 1776237 | 2021-10-02 | Erie | New York | 36029 | 101506 | 1902 |
1772987 | 1772987 | 2021-10-01 | Erie | New York | 36029 | 101292 | 1902 |
1769737 | 1769737 | 2021-09-30 | Erie | New York | 36029 | 101007 | 1900 |
1766488 | 1766488 | 2021-09-29 | Erie | New York | 36029 | 100804 | 1899 |
1763239 | 1763239 | 2021-09-28 | Erie | New York | 36029 | 100521 | 1895 |
1759990 | 1759990 | 2021-09-27 | Erie | New York | 36029 | 100356 | 1894 |
1756742 | 1756742 | 2021-09-26 | Erie | New York | 36029 | 100094 | 1888 |
1753494 | 1753494 | 2021-09-25 | Erie | New York | 36029 | 99889 | 1887 |
1750246 | 1750246 | 2021-09-24 | Erie | New York | 36029 | 99652 | 1884 |
1746996 | 1746996 | 2021-09-23 | Erie | New York | 36029 | 99259 | 1884 |
1743747 | 1743747 | 2021-09-22 | Erie | New York | 36029 | 99069 | 1882 |
1740498 | 1740498 | 2021-09-21 | Erie | New York | 36029 | 98871 | 1881 |
1737249 | 1737249 | 2021-09-20 | Erie | New York | 36029 | 98628 | 1880 |
1733999 | 1733999 | 2021-09-19 | Erie | New York | 36029 | 98475 | 1879 |
1730749 | 1730749 | 2021-09-18 | Erie | New York | 36029 | 98209 | 1876 |
1727499 | 1727499 | 2021-09-17 | Erie | New York | 36029 | 98063 | 1875 |
1724250 | 1724250 | 2021-09-16 | Erie | New York | 36029 | 97813 | 1873 |
1721001 | 1721001 | 2021-09-15 | Erie | New York | 36029 | 97413 | 1871 |
1717753 | 1717753 | 2021-09-14 | Erie | New York | 36029 | 97252 | 1870 |
1714505 | 1714505 | 2021-09-13 | Erie | New York | 36029 | 97137 | 1867 |
1711259 | 1711259 | 2021-09-12 | Erie | New York | 36029 | 96939 | 1866 |
1708012 | 1708012 | 2021-09-11 | Erie | New York | 36029 | 96746 | 1862 |
1704765 | 1704765 | 2021-09-10 | Erie | New York | 36029 | 96432 | 1861 |
1701515 | 1701515 | 2021-09-09 | Erie | New York | 36029 | 96255 | 1859 |
1698266 | 1698266 | 2021-09-08 | Erie | New York | 36029 | 96025 | 1859 |
1695018 | 1695018 | 2021-09-07 | Erie | New York | 36029 | 95853 | 1859 |
1691770 | 1691770 | 2021-09-06 | Erie | New York | 36029 | 95686 | 1858 |
1688520 | 1688520 | 2021-09-05 | Erie | New York | 36029 | 95513 | 1858 |
1685270 | 1685270 | 2021-09-04 | Erie | New York | 36029 | 95380 | 1856 |
1682019 | 1682019 | 2021-09-03 | Erie | New York | 36029 | 95148 | 1854 |
1678770 | 1678770 | 2021-09-02 | Erie | New York | 36029 | 94937 | 1852 |
1675522 | 1675522 | 2021-09-01 | Erie | New York | 36029 | 94706 | 1848 |
1672275 | 1672275 | 2021-08-31 | Erie | New York | 36029 | 94572 | 1846 |
1669027 | 1669027 | 2021-08-30 | Erie | New York | 36029 | 94435 | 1844 |
1665780 | 1665780 | 2021-08-29 | Erie | New York | 36029 | 94277 | 1842 |
1662532 | 1662532 | 2021-08-28 | Erie | New York | 36029 | 94140 | 1839 |
1659284 | 1659284 | 2021-08-27 | Erie | New York | 36029 | 93941 | 1837 |
1656035 | 1656035 | 2021-08-26 | Erie | New York | 36029 | 93668 | 1837 |
1652788 | 1652788 | 2021-08-25 | Erie | New York | 36029 | 93536 | 1836 |
1649540 | 1649540 | 2021-08-24 | Erie | New York | 36029 | 93406 | 1836 |
1646291 | 1646291 | 2021-08-23 | Erie | New York | 36029 | 93310 | 1836 |
1643042 | 1643042 | 2021-08-22 | Erie | New York | 36029 | 93163 | 1836 |
1639792 | 1639792 | 2021-08-21 | Erie | New York | 36029 | 93015 | 1834 |
1636542 | 1636542 | 2021-08-20 | Erie | New York | 36029 | 92828 | 1832 |
1633292 | 1633292 | 2021-08-19 | Erie | New York | 36029 | 92688 | 1830 |
1630045 | 1630045 | 2021-08-18 | Erie | New York | 36029 | 92555 | 1830 |
1626798 | 1626798 | 2021-08-17 | Erie | New York | 36029 | 92424 | 1830 |
1623551 | 1623551 | 2021-08-16 | Erie | New York | 36029 | 92300 | 1828 |
1620304 | 1620304 | 2021-08-15 | Erie | New York | 36029 | 92204 | 1827 |
1617056 | 1617056 | 2021-08-14 | Erie | New York | 36029 | 92076 | 1826 |
1613808 | 1613808 | 2021-08-13 | Erie | New York | 36029 | 91941 | 1823 |
1610559 | 1610559 | 2021-08-12 | Erie | New York | 36029 | 91826 | 1823 |
1607311 | 1607311 | 2021-08-11 | Erie | New York | 36029 | 91690 | 1822 |
1604062 | 1604062 | 2021-08-10 | Erie | New York | 36029 | 91576 | 1822 |
1600813 | 1600813 | 2021-08-09 | Erie | New York | 36029 | 91476 | 1820 |
1597565 | 1597565 | 2021-08-08 | Erie | New York | 36029 | 91409 | 1818 |
1594316 | 1594316 | 2021-08-07 | Erie | New York | 36029 | 91304 | 1817 |
1591067 | 1591067 | 2021-08-06 | Erie | New York | 36029 | 91165 | 1817 |
1587818 | 1587818 | 2021-08-05 | Erie | New York | 36029 | 91075 | 1817 |
1584568 | 1584568 | 2021-08-04 | Erie | New York | 36029 | 91003 | 1816 |
1581318 | 1581318 | 2021-08-03 | Erie | New York | 36029 | 90919 | 1816 |
1578069 | 1578069 | 2021-08-02 | Erie | New York | 36029 | 90820 | 1816 |
1574821 | 1574821 | 2021-08-01 | Erie | New York | 36029 | 90783 | 1816 |
1571573 | 1571573 | 2021-07-31 | Erie | New York | 36029 | 90689 | 1814 |
1568325 | 1568325 | 2021-07-30 | Erie | New York | 36029 | 90598 | 1814 |
1565077 | 1565077 | 2021-07-29 | Erie | New York | 36029 | 90507 | 1814 |
1561829 | 1561829 | 2021-07-28 | Erie | New York | 36029 | 90415 | 1814 |
1558581 | 1558581 | 2021-07-27 | Erie | New York | 36029 | 90347 | 1814 |
1555334 | 1555334 | 2021-07-26 | Erie | New York | 36029 | 90279 | 1814 |
1552087 | 1552087 | 2021-07-25 | Erie | New York | 36029 | 90249 | 1814 |
1548840 | 1548840 | 2021-07-24 | Erie | New York | 36029 | 90185 | 1814 |
1545593 | 1545593 | 2021-07-23 | Erie | New York | 36029 | 90144 | 1814 |
1542346 | 1542346 | 2021-07-22 | Erie | New York | 36029 | 90090 | 1813 |
1539098 | 1539098 | 2021-07-21 | Erie | New York | 36029 | 90050 | 1813 |
1535851 | 1535851 | 2021-07-20 | Erie | New York | 36029 | 90009 | 1813 |
1532603 | 1532603 | 2021-07-19 | Erie | New York | 36029 | 89976 | 1813 |
1529356 | 1529356 | 2021-07-18 | Erie | New York | 36029 | 89961 | 1813 |
1526109 | 1526109 | 2021-07-17 | Erie | New York | 36029 | 89922 | 1813 |
1522862 | 1522862 | 2021-07-16 | Erie | New York | 36029 | 89911 | 1813 |
1519614 | 1519614 | 2021-07-15 | Erie | New York | 36029 | 89882 | 1813 |
1516366 | 1516366 | 2021-07-14 | Erie | New York | 36029 | 89858 | 1813 |
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);