ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36031 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 |
---|---|---|---|---|---|---|---|
1717754 | 1717754 | 2021-09-14 | Essex | New York | 36031 | 1884 | 29 |
1714506 | 1714506 | 2021-09-13 | Essex | New York | 36031 | 1876 | 29 |
1711260 | 1711260 | 2021-09-12 | Essex | New York | 36031 | 1870 | 29 |
1708013 | 1708013 | 2021-09-11 | Essex | New York | 36031 | 1866 | 29 |
1704766 | 1704766 | 2021-09-10 | Essex | New York | 36031 | 1858 | 29 |
1701516 | 1701516 | 2021-09-09 | Essex | New York | 36031 | 1844 | 28 |
1698267 | 1698267 | 2021-09-08 | Essex | New York | 36031 | 1837 | 28 |
1695019 | 1695019 | 2021-09-07 | Essex | New York | 36031 | 1832 | 27 |
1691771 | 1691771 | 2021-09-06 | Essex | New York | 36031 | 1826 | 27 |
1688521 | 1688521 | 2021-09-05 | Essex | New York | 36031 | 1822 | 27 |
1685271 | 1685271 | 2021-09-04 | Essex | New York | 36031 | 1817 | 27 |
1682020 | 1682020 | 2021-09-03 | Essex | New York | 36031 | 1807 | 27 |
1678771 | 1678771 | 2021-09-02 | Essex | New York | 36031 | 1790 | 27 |
1675523 | 1675523 | 2021-09-01 | Essex | New York | 36031 | 1787 | 27 |
1672276 | 1672276 | 2021-08-31 | Essex | New York | 36031 | 1781 | 26 |
1669028 | 1669028 | 2021-08-30 | Essex | New York | 36031 | 1780 | 26 |
1665781 | 1665781 | 2021-08-29 | Essex | New York | 36031 | 1780 | 26 |
1662533 | 1662533 | 2021-08-28 | Essex | New York | 36031 | 1773 | 26 |
1659285 | 1659285 | 2021-08-27 | Essex | New York | 36031 | 1769 | 26 |
1656036 | 1656036 | 2021-08-26 | Essex | New York | 36031 | 1761 | 26 |
1652789 | 1652789 | 2021-08-25 | Essex | New York | 36031 | 1759 | 26 |
1649541 | 1649541 | 2021-08-24 | Essex | New York | 36031 | 1753 | 26 |
1646292 | 1646292 | 2021-08-23 | Essex | New York | 36031 | 1748 | 26 |
1643043 | 1643043 | 2021-08-22 | Essex | New York | 36031 | 1745 | 26 |
1639793 | 1639793 | 2021-08-21 | Essex | New York | 36031 | 1741 | 26 |
1636543 | 1636543 | 2021-08-20 | Essex | New York | 36031 | 1738 | 26 |
1633293 | 1633293 | 2021-08-19 | Essex | New York | 36031 | 1728 | 26 |
1630046 | 1630046 | 2021-08-18 | Essex | New York | 36031 | 1714 | 26 |
1626799 | 1626799 | 2021-08-17 | Essex | New York | 36031 | 1709 | 26 |
1623552 | 1623552 | 2021-08-16 | Essex | New York | 36031 | 1703 | 26 |
1620305 | 1620305 | 2021-08-15 | Essex | New York | 36031 | 1693 | 26 |
1617057 | 1617057 | 2021-08-14 | Essex | New York | 36031 | 1687 | 26 |
1613809 | 1613809 | 2021-08-13 | Essex | New York | 36031 | 1678 | 26 |
1610560 | 1610560 | 2021-08-12 | Essex | New York | 36031 | 1674 | 26 |
1607312 | 1607312 | 2021-08-11 | Essex | New York | 36031 | 1668 | 26 |
1604063 | 1604063 | 2021-08-10 | Essex | New York | 36031 | 1662 | 26 |
1600814 | 1600814 | 2021-08-09 | Essex | New York | 36031 | 1659 | 26 |
1597566 | 1597566 | 2021-08-08 | Essex | New York | 36031 | 1658 | 26 |
1594317 | 1594317 | 2021-08-07 | Essex | New York | 36031 | 1657 | 26 |
1591068 | 1591068 | 2021-08-06 | Essex | New York | 36031 | 1653 | 26 |
1587819 | 1587819 | 2021-08-05 | Essex | New York | 36031 | 1647 | 26 |
1584569 | 1584569 | 2021-08-04 | Essex | New York | 36031 | 1645 | 26 |
1581319 | 1581319 | 2021-08-03 | Essex | New York | 36031 | 1644 | 26 |
1578070 | 1578070 | 2021-08-02 | Essex | New York | 36031 | 1644 | 26 |
1574822 | 1574822 | 2021-08-01 | Essex | New York | 36031 | 1640 | 26 |
1571574 | 1571574 | 2021-07-31 | Essex | New York | 36031 | 1640 | 26 |
1568326 | 1568326 | 2021-07-30 | Essex | New York | 36031 | 1637 | 26 |
1565078 | 1565078 | 2021-07-29 | Essex | New York | 36031 | 1637 | 26 |
1561830 | 1561830 | 2021-07-28 | Essex | New York | 36031 | 1636 | 26 |
1558582 | 1558582 | 2021-07-27 | Essex | New York | 36031 | 1633 | 26 |
1555335 | 1555335 | 2021-07-26 | Essex | New York | 36031 | 1631 | 26 |
1552088 | 1552088 | 2021-07-25 | Essex | New York | 36031 | 1629 | 26 |
1548841 | 1548841 | 2021-07-24 | Essex | New York | 36031 | 1628 | 26 |
1545594 | 1545594 | 2021-07-23 | Essex | New York | 36031 | 1626 | 26 |
1542347 | 1542347 | 2021-07-22 | Essex | New York | 36031 | 1623 | 26 |
1539099 | 1539099 | 2021-07-21 | Essex | New York | 36031 | 1623 | 26 |
1535852 | 1535852 | 2021-07-20 | Essex | New York | 36031 | 1622 | 26 |
1532604 | 1532604 | 2021-07-19 | Essex | New York | 36031 | 1622 | 26 |
1529357 | 1529357 | 2021-07-18 | Essex | New York | 36031 | 1620 | 26 |
1526110 | 1526110 | 2021-07-17 | Essex | New York | 36031 | 1618 | 26 |
1522863 | 1522863 | 2021-07-16 | Essex | New York | 36031 | 1616 | 26 |
1519615 | 1519615 | 2021-07-15 | Essex | New York | 36031 | 1610 | 26 |
1516367 | 1516367 | 2021-07-14 | Essex | New York | 36031 | 1609 | 26 |
1513120 | 1513120 | 2021-07-13 | Essex | New York | 36031 | 1608 | 26 |
1509874 | 1509874 | 2021-07-12 | Essex | New York | 36031 | 1607 | 26 |
1506627 | 1506627 | 2021-07-11 | Essex | New York | 36031 | 1606 | 26 |
1503381 | 1503381 | 2021-07-10 | Essex | New York | 36031 | 1606 | 26 |
1500135 | 1500135 | 2021-07-09 | Essex | New York | 36031 | 1606 | 26 |
1496889 | 1496889 | 2021-07-08 | Essex | New York | 36031 | 1606 | 26 |
1493642 | 1493642 | 2021-07-07 | Essex | New York | 36031 | 1606 | 26 |
1490395 | 1490395 | 2021-07-06 | Essex | New York | 36031 | 1605 | 26 |
1487148 | 1487148 | 2021-07-05 | Essex | New York | 36031 | 1605 | 26 |
1483902 | 1483902 | 2021-07-04 | Essex | New York | 36031 | 1605 | 26 |
1480656 | 1480656 | 2021-07-03 | Essex | New York | 36031 | 1605 | 26 |
1477409 | 1477409 | 2021-07-02 | Essex | New York | 36031 | 1605 | 26 |
1474163 | 1474163 | 2021-07-01 | Essex | New York | 36031 | 1605 | 26 |
1470917 | 1470917 | 2021-06-30 | Essex | New York | 36031 | 1603 | 26 |
1467672 | 1467672 | 2021-06-29 | Essex | New York | 36031 | 1603 | 26 |
1464427 | 1464427 | 2021-06-28 | Essex | New York | 36031 | 1603 | 26 |
1461182 | 1461182 | 2021-06-27 | Essex | New York | 36031 | 1603 | 26 |
1457937 | 1457937 | 2021-06-26 | Essex | New York | 36031 | 1603 | 26 |
1454692 | 1454692 | 2021-06-25 | Essex | New York | 36031 | 1603 | 26 |
1451447 | 1451447 | 2021-06-24 | Essex | New York | 36031 | 1602 | 26 |
1448201 | 1448201 | 2021-06-23 | Essex | New York | 36031 | 1601 | 26 |
1444956 | 1444956 | 2021-06-22 | Essex | New York | 36031 | 1601 | 26 |
1441711 | 1441711 | 2021-06-21 | Essex | New York | 36031 | 1601 | 26 |
1438466 | 1438466 | 2021-06-20 | Essex | New York | 36031 | 1601 | 26 |
1435219 | 1435219 | 2021-06-19 | Essex | New York | 36031 | 1601 | 26 |
1431972 | 1431972 | 2021-06-18 | Essex | New York | 36031 | 1601 | 26 |
1428726 | 1428726 | 2021-06-17 | Essex | New York | 36031 | 1601 | 26 |
1425481 | 1425481 | 2021-06-16 | Essex | New York | 36031 | 1601 | 26 |
1422234 | 1422234 | 2021-06-15 | Essex | New York | 36031 | 1601 | 26 |
1418988 | 1418988 | 2021-06-14 | Essex | New York | 36031 | 1601 | 26 |
1415743 | 1415743 | 2021-06-13 | Essex | New York | 36031 | 1601 | 26 |
1412497 | 1412497 | 2021-06-12 | Essex | New York | 36031 | 1601 | 26 |
1409252 | 1409252 | 2021-06-11 | Essex | New York | 36031 | 1600 | 26 |
1406007 | 1406007 | 2021-06-10 | Essex | New York | 36031 | 1600 | 26 |
1402761 | 1402761 | 2021-06-09 | Essex | New York | 36031 | 1600 | 26 |
1399516 | 1399516 | 2021-06-08 | Essex | New York | 36031 | 1600 | 26 |
1396271 | 1396271 | 2021-06-07 | Essex | New York | 36031 | 1599 | 26 |
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);