ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36121 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 |
---|---|---|---|---|---|---|---|
1812021 | 1812021 | 2021-10-13 | Wyoming | New York | 36121 | 4276 | 57 |
1808772 | 1808772 | 2021-10-12 | Wyoming | New York | 36121 | 4252 | 56 |
1805521 | 1805521 | 2021-10-11 | Wyoming | New York | 36121 | 4240 | 56 |
1802272 | 1802272 | 2021-10-10 | Wyoming | New York | 36121 | 4217 | 55 |
1799023 | 1799023 | 2021-10-09 | Wyoming | New York | 36121 | 4199 | 55 |
1795774 | 1795774 | 2021-10-08 | Wyoming | New York | 36121 | 4178 | 55 |
1792525 | 1792525 | 2021-10-07 | Wyoming | New York | 36121 | 4153 | 55 |
1789276 | 1789276 | 2021-10-06 | Wyoming | New York | 36121 | 4127 | 55 |
1786028 | 1786028 | 2021-10-05 | Wyoming | New York | 36121 | 4097 | 55 |
1782779 | 1782779 | 2021-10-04 | Wyoming | New York | 36121 | 4085 | 55 |
1779530 | 1779530 | 2021-10-03 | Wyoming | New York | 36121 | 4079 | 55 |
1776280 | 1776280 | 2021-10-02 | Wyoming | New York | 36121 | 4055 | 54 |
1773030 | 1773030 | 2021-10-01 | Wyoming | New York | 36121 | 4044 | 54 |
1769780 | 1769780 | 2021-09-30 | Wyoming | New York | 36121 | 4024 | 54 |
1766531 | 1766531 | 2021-09-29 | Wyoming | New York | 36121 | 4005 | 54 |
1763282 | 1763282 | 2021-09-28 | Wyoming | New York | 36121 | 3984 | 54 |
1760033 | 1760033 | 2021-09-27 | Wyoming | New York | 36121 | 3976 | 54 |
1756785 | 1756785 | 2021-09-26 | Wyoming | New York | 36121 | 3964 | 54 |
1753537 | 1753537 | 2021-09-25 | Wyoming | New York | 36121 | 3956 | 54 |
1750289 | 1750289 | 2021-09-24 | Wyoming | New York | 36121 | 3939 | 54 |
1747039 | 1747039 | 2021-09-23 | Wyoming | New York | 36121 | 3923 | 54 |
1743790 | 1743790 | 2021-09-22 | Wyoming | New York | 36121 | 3912 | 54 |
1740541 | 1740541 | 2021-09-21 | Wyoming | New York | 36121 | 3901 | 54 |
1737292 | 1737292 | 2021-09-20 | Wyoming | New York | 36121 | 3891 | 54 |
1734042 | 1734042 | 2021-09-19 | Wyoming | New York | 36121 | 3884 | 54 |
1730792 | 1730792 | 2021-09-18 | Wyoming | New York | 36121 | 3877 | 54 |
1727542 | 1727542 | 2021-09-17 | Wyoming | New York | 36121 | 3868 | 54 |
1724293 | 1724293 | 2021-09-16 | Wyoming | New York | 36121 | 3855 | 54 |
1721044 | 1721044 | 2021-09-15 | Wyoming | New York | 36121 | 3836 | 54 |
1717796 | 1717796 | 2021-09-14 | Wyoming | New York | 36121 | 3824 | 54 |
1714548 | 1714548 | 2021-09-13 | Wyoming | New York | 36121 | 3818 | 54 |
1711302 | 1711302 | 2021-09-12 | Wyoming | New York | 36121 | 3814 | 54 |
1708055 | 1708055 | 2021-09-11 | Wyoming | New York | 36121 | 3804 | 54 |
1704808 | 1704808 | 2021-09-10 | Wyoming | New York | 36121 | 3788 | 54 |
1701558 | 1701558 | 2021-09-09 | Wyoming | New York | 36121 | 3770 | 54 |
1698309 | 1698309 | 2021-09-08 | Wyoming | New York | 36121 | 3757 | 54 |
1695061 | 1695061 | 2021-09-07 | Wyoming | New York | 36121 | 3750 | 54 |
1691813 | 1691813 | 2021-09-06 | Wyoming | New York | 36121 | 3747 | 54 |
1688563 | 1688563 | 2021-09-05 | Wyoming | New York | 36121 | 3742 | 54 |
1685313 | 1685313 | 2021-09-04 | Wyoming | New York | 36121 | 3741 | 54 |
1682062 | 1682062 | 2021-09-03 | Wyoming | New York | 36121 | 3725 | 54 |
1678813 | 1678813 | 2021-09-02 | Wyoming | New York | 36121 | 3719 | 54 |
1675565 | 1675565 | 2021-09-01 | Wyoming | New York | 36121 | 3709 | 54 |
1672318 | 1672318 | 2021-08-31 | Wyoming | New York | 36121 | 3699 | 54 |
1669070 | 1669070 | 2021-08-30 | Wyoming | New York | 36121 | 3697 | 53 |
1665823 | 1665823 | 2021-08-29 | Wyoming | New York | 36121 | 3696 | 53 |
1662575 | 1662575 | 2021-08-28 | Wyoming | New York | 36121 | 3693 | 53 |
1659327 | 1659327 | 2021-08-27 | Wyoming | New York | 36121 | 3690 | 53 |
1656078 | 1656078 | 2021-08-26 | Wyoming | New York | 36121 | 3686 | 53 |
1652831 | 1652831 | 2021-08-25 | Wyoming | New York | 36121 | 3681 | 53 |
1649583 | 1649583 | 2021-08-24 | Wyoming | New York | 36121 | 3676 | 53 |
1646334 | 1646334 | 2021-08-23 | Wyoming | New York | 36121 | 3673 | 53 |
1643085 | 1643085 | 2021-08-22 | Wyoming | New York | 36121 | 3672 | 53 |
1639835 | 1639835 | 2021-08-21 | Wyoming | New York | 36121 | 3669 | 53 |
1636585 | 1636585 | 2021-08-20 | Wyoming | New York | 36121 | 3667 | 53 |
1633335 | 1633335 | 2021-08-19 | Wyoming | New York | 36121 | 3664 | 53 |
1630088 | 1630088 | 2021-08-18 | Wyoming | New York | 36121 | 3660 | 53 |
1626841 | 1626841 | 2021-08-17 | Wyoming | New York | 36121 | 3655 | 53 |
1623594 | 1623594 | 2021-08-16 | Wyoming | New York | 36121 | 3652 | 53 |
1620347 | 1620347 | 2021-08-15 | Wyoming | New York | 36121 | 3651 | 53 |
1617099 | 1617099 | 2021-08-14 | Wyoming | New York | 36121 | 3649 | 53 |
1613851 | 1613851 | 2021-08-13 | Wyoming | New York | 36121 | 3648 | 53 |
1610602 | 1610602 | 2021-08-12 | Wyoming | New York | 36121 | 3644 | 53 |
1607354 | 1607354 | 2021-08-11 | Wyoming | New York | 36121 | 3641 | 53 |
1604105 | 1604105 | 2021-08-10 | Wyoming | New York | 36121 | 3639 | 53 |
1600856 | 1600856 | 2021-08-09 | Wyoming | New York | 36121 | 3638 | 53 |
1597608 | 1597608 | 2021-08-08 | Wyoming | New York | 36121 | 3637 | 53 |
1594359 | 1594359 | 2021-08-07 | Wyoming | New York | 36121 | 3635 | 53 |
1591110 | 1591110 | 2021-08-06 | Wyoming | New York | 36121 | 3633 | 53 |
1587861 | 1587861 | 2021-08-05 | Wyoming | New York | 36121 | 3632 | 53 |
1584611 | 1584611 | 2021-08-04 | Wyoming | New York | 36121 | 3632 | 53 |
1581361 | 1581361 | 2021-08-03 | Wyoming | New York | 36121 | 3631 | 53 |
1578112 | 1578112 | 2021-08-02 | Wyoming | New York | 36121 | 3631 | 53 |
1574864 | 1574864 | 2021-08-01 | Wyoming | New York | 36121 | 3628 | 53 |
1571616 | 1571616 | 2021-07-31 | Wyoming | New York | 36121 | 3628 | 53 |
1568368 | 1568368 | 2021-07-30 | Wyoming | New York | 36121 | 3622 | 53 |
1565120 | 1565120 | 2021-07-29 | Wyoming | New York | 36121 | 3620 | 53 |
1561872 | 1561872 | 2021-07-28 | Wyoming | New York | 36121 | 3620 | 53 |
1558624 | 1558624 | 2021-07-27 | Wyoming | New York | 36121 | 3618 | 53 |
1555377 | 1555377 | 2021-07-26 | Wyoming | New York | 36121 | 3616 | 53 |
1552130 | 1552130 | 2021-07-25 | Wyoming | New York | 36121 | 3616 | 53 |
1548883 | 1548883 | 2021-07-24 | Wyoming | New York | 36121 | 3614 | 53 |
1545636 | 1545636 | 2021-07-23 | Wyoming | New York | 36121 | 3614 | 53 |
1542389 | 1542389 | 2021-07-22 | Wyoming | New York | 36121 | 3612 | 53 |
1539141 | 1539141 | 2021-07-21 | Wyoming | New York | 36121 | 3608 | 53 |
1535894 | 1535894 | 2021-07-20 | Wyoming | New York | 36121 | 3608 | 53 |
1532646 | 1532646 | 2021-07-19 | Wyoming | New York | 36121 | 3608 | 53 |
1529399 | 1529399 | 2021-07-18 | Wyoming | New York | 36121 | 3608 | 53 |
1526152 | 1526152 | 2021-07-17 | Wyoming | New York | 36121 | 3607 | 53 |
1522905 | 1522905 | 2021-07-16 | Wyoming | New York | 36121 | 3607 | 53 |
1519657 | 1519657 | 2021-07-15 | Wyoming | New York | 36121 | 3607 | 53 |
1516409 | 1516409 | 2021-07-14 | Wyoming | New York | 36121 | 3605 | 53 |
1513162 | 1513162 | 2021-07-13 | Wyoming | New York | 36121 | 3603 | 53 |
1509916 | 1509916 | 2021-07-12 | Wyoming | New York | 36121 | 3603 | 53 |
1506669 | 1506669 | 2021-07-11 | Wyoming | New York | 36121 | 3603 | 53 |
1503423 | 1503423 | 2021-07-10 | Wyoming | New York | 36121 | 3603 | 53 |
1500177 | 1500177 | 2021-07-09 | Wyoming | New York | 36121 | 3601 | 53 |
1496931 | 1496931 | 2021-07-08 | Wyoming | New York | 36121 | 3599 | 53 |
1493684 | 1493684 | 2021-07-07 | Wyoming | New York | 36121 | 3597 | 53 |
1490437 | 1490437 | 2021-07-06 | Wyoming | New York | 36121 | 3597 | 53 |
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);