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 |
---|---|---|---|---|---|---|---|
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 |
1513119 | 1513119 | 2021-07-13 | Erie | New York | 36029 | 89827 | 1813 |
1509873 | 1509873 | 2021-07-12 | Erie | New York | 36029 | 89806 | 1812 |
1506626 | 1506626 | 2021-07-11 | Erie | New York | 36029 | 89795 | 1812 |
1503380 | 1503380 | 2021-07-10 | Erie | New York | 36029 | 89785 | 1812 |
1500134 | 1500134 | 2021-07-09 | Erie | New York | 36029 | 89775 | 1812 |
1496888 | 1496888 | 2021-07-08 | Erie | New York | 36029 | 89755 | 1812 |
1493641 | 1493641 | 2021-07-07 | Erie | New York | 36029 | 89749 | 1812 |
1490394 | 1490394 | 2021-07-06 | Erie | New York | 36029 | 89737 | 1812 |
1487147 | 1487147 | 2021-07-05 | Erie | New York | 36029 | 89729 | 1812 |
1483901 | 1483901 | 2021-07-04 | Erie | New York | 36029 | 89717 | 1812 |
1480655 | 1480655 | 2021-07-03 | Erie | New York | 36029 | 89704 | 1812 |
1477408 | 1477408 | 2021-07-02 | Erie | New York | 36029 | 89695 | 1812 |
1474162 | 1474162 | 2021-07-01 | Erie | New York | 36029 | 89678 | 1812 |
1470916 | 1470916 | 2021-06-30 | Erie | New York | 36029 | 89668 | 1812 |
1467671 | 1467671 | 2021-06-29 | Erie | New York | 36029 | 89665 | 1812 |
1464426 | 1464426 | 2021-06-28 | Erie | New York | 36029 | 89660 | 1812 |
1461181 | 1461181 | 2021-06-27 | Erie | New York | 36029 | 89651 | 1812 |
1457936 | 1457936 | 2021-06-26 | Erie | New York | 36029 | 89638 | 1812 |
1454691 | 1454691 | 2021-06-25 | Erie | New York | 36029 | 89632 | 1811 |
1451446 | 1451446 | 2021-06-24 | Erie | New York | 36029 | 89626 | 1811 |
1448200 | 1448200 | 2021-06-23 | Erie | New York | 36029 | 89620 | 1811 |
1444955 | 1444955 | 2021-06-22 | Erie | New York | 36029 | 89617 | 1810 |
1441710 | 1441710 | 2021-06-21 | Erie | New York | 36029 | 89614 | 1809 |
1438465 | 1438465 | 2021-06-20 | Erie | New York | 36029 | 89607 | 1809 |
1435218 | 1435218 | 2021-06-19 | Erie | New York | 36029 | 89604 | 1809 |
1431971 | 1431971 | 2021-06-18 | Erie | New York | 36029 | 89603 | 1809 |
1428725 | 1428725 | 2021-06-17 | Erie | New York | 36029 | 89595 | 1808 |
1425480 | 1425480 | 2021-06-16 | Erie | New York | 36029 | 89583 | 1808 |
1422233 | 1422233 | 2021-06-15 | Erie | New York | 36029 | 89579 | 1807 |
1418987 | 1418987 | 2021-06-14 | Erie | New York | 36029 | 89572 | 1806 |
1415742 | 1415742 | 2021-06-13 | Erie | New York | 36029 | 89564 | 1806 |
1412496 | 1412496 | 2021-06-12 | Erie | New York | 36029 | 89557 | 1805 |
1409251 | 1409251 | 2021-06-11 | Erie | New York | 36029 | 89541 | 1803 |
1406006 | 1406006 | 2021-06-10 | Erie | New York | 36029 | 89520 | 1802 |
1402760 | 1402760 | 2021-06-09 | Erie | New York | 36029 | 89501 | 1801 |
1399515 | 1399515 | 2021-06-08 | Erie | New York | 36029 | 89488 | 1800 |
1396270 | 1396270 | 2021-06-07 | Erie | New York | 36029 | 89472 | 1800 |
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);