ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Chenango" 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 |
---|---|---|---|---|---|---|---|
1948451 | 1948451 | 2021-11-24 | Chenango | New York | 36017 | 5426 | 95 |
1945200 | 1945200 | 2021-11-23 | Chenango | New York | 36017 | 5398 | 95 |
1941949 | 1941949 | 2021-11-22 | Chenango | New York | 36017 | 5367 | 94 |
1938699 | 1938699 | 2021-11-21 | Chenango | New York | 36017 | 5354 | 94 |
1935449 | 1935449 | 2021-11-20 | Chenango | New York | 36017 | 5321 | 94 |
1932199 | 1932199 | 2021-11-19 | Chenango | New York | 36017 | 5278 | 94 |
1928948 | 1928948 | 2021-11-18 | Chenango | New York | 36017 | 5226 | 94 |
1925698 | 1925698 | 2021-11-17 | Chenango | New York | 36017 | 5193 | 94 |
1922449 | 1922449 | 2021-11-16 | Chenango | New York | 36017 | 5171 | 94 |
1919199 | 1919199 | 2021-11-15 | Chenango | New York | 36017 | 5143 | 94 |
1915949 | 1915949 | 2021-11-14 | Chenango | New York | 36017 | 5127 | 94 |
1912699 | 1912699 | 2021-11-13 | Chenango | New York | 36017 | 5105 | 94 |
1909449 | 1909449 | 2021-11-12 | Chenango | New York | 36017 | 5075 | 94 |
1906200 | 1906200 | 2021-11-11 | Chenango | New York | 36017 | 5042 | 94 |
1902951 | 1902951 | 2021-11-10 | Chenango | New York | 36017 | 5012 | 93 |
1899701 | 1899701 | 2021-11-09 | Chenango | New York | 36017 | 4980 | 92 |
1896451 | 1896451 | 2021-11-08 | Chenango | New York | 36017 | 4959 | 92 |
1893201 | 1893201 | 2021-11-07 | Chenango | New York | 36017 | 4947 | 92 |
1889951 | 1889951 | 2021-11-06 | Chenango | New York | 36017 | 4924 | 92 |
1886701 | 1886701 | 2021-11-05 | Chenango | New York | 36017 | 4905 | 92 |
1883452 | 1883452 | 2021-11-04 | Chenango | New York | 36017 | 4879 | 92 |
1880203 | 1880203 | 2021-11-03 | Chenango | New York | 36017 | 4868 | 92 |
1876954 | 1876954 | 2021-11-02 | Chenango | New York | 36017 | 4856 | 90 |
1873705 | 1873705 | 2021-11-01 | Chenango | New York | 36017 | 4845 | 89 |
1870456 | 1870456 | 2021-10-31 | Chenango | New York | 36017 | 4832 | 88 |
1867207 | 1867207 | 2021-10-30 | Chenango | New York | 36017 | 4816 | 88 |
1863958 | 1863958 | 2021-10-29 | Chenango | New York | 36017 | 4805 | 88 |
1860709 | 1860709 | 2021-10-28 | Chenango | New York | 36017 | 4782 | 88 |
1857460 | 1857460 | 2021-10-27 | Chenango | New York | 36017 | 4762 | 88 |
1854211 | 1854211 | 2021-10-26 | Chenango | New York | 36017 | 4749 | 88 |
1850962 | 1850962 | 2021-10-25 | Chenango | New York | 36017 | 4746 | 88 |
1847712 | 1847712 | 2021-10-24 | Chenango | New York | 36017 | 4733 | 88 |
1844462 | 1844462 | 2021-10-23 | Chenango | New York | 36017 | 4715 | 88 |
1841212 | 1841212 | 2021-10-22 | Chenango | New York | 36017 | 4706 | 86 |
1837963 | 1837963 | 2021-10-21 | Chenango | New York | 36017 | 4689 | 86 |
1834714 | 1834714 | 2021-10-20 | Chenango | New York | 36017 | 4674 | 86 |
1831465 | 1831465 | 2021-10-19 | Chenango | New York | 36017 | 4657 | 86 |
1828216 | 1828216 | 2021-10-18 | Chenango | New York | 36017 | 4649 | 86 |
1824967 | 1824967 | 2021-10-17 | Chenango | New York | 36017 | 4635 | 86 |
1821718 | 1821718 | 2021-10-16 | Chenango | New York | 36017 | 4619 | 86 |
1818469 | 1818469 | 2021-10-15 | Chenango | New York | 36017 | 4594 | 86 |
1815220 | 1815220 | 2021-10-14 | Chenango | New York | 36017 | 4556 | 86 |
1811972 | 1811972 | 2021-10-13 | Chenango | New York | 36017 | 4543 | 86 |
1808723 | 1808723 | 2021-10-12 | Chenango | New York | 36017 | 4516 | 86 |
1805472 | 1805472 | 2021-10-11 | Chenango | New York | 36017 | 4500 | 86 |
1802223 | 1802223 | 2021-10-10 | Chenango | New York | 36017 | 4491 | 86 |
1798974 | 1798974 | 2021-10-09 | Chenango | New York | 36017 | 4475 | 86 |
1795725 | 1795725 | 2021-10-08 | Chenango | New York | 36017 | 4448 | 86 |
1792476 | 1792476 | 2021-10-07 | Chenango | New York | 36017 | 4419 | 86 |
1789227 | 1789227 | 2021-10-06 | Chenango | New York | 36017 | 4401 | 86 |
1785979 | 1785979 | 2021-10-05 | Chenango | New York | 36017 | 4377 | 86 |
1782730 | 1782730 | 2021-10-04 | Chenango | New York | 36017 | 4368 | 86 |
1779481 | 1779481 | 2021-10-03 | Chenango | New York | 36017 | 4359 | 86 |
1776231 | 1776231 | 2021-10-02 | Chenango | New York | 36017 | 4338 | 86 |
1772981 | 1772981 | 2021-10-01 | Chenango | New York | 36017 | 4326 | 86 |
1769731 | 1769731 | 2021-09-30 | Chenango | New York | 36017 | 4306 | 86 |
1766482 | 1766482 | 2021-09-29 | Chenango | New York | 36017 | 4284 | 86 |
1763233 | 1763233 | 2021-09-28 | Chenango | New York | 36017 | 4275 | 86 |
1759984 | 1759984 | 2021-09-27 | Chenango | New York | 36017 | 4267 | 86 |
1756736 | 1756736 | 2021-09-26 | Chenango | New York | 36017 | 4259 | 86 |
1753488 | 1753488 | 2021-09-25 | Chenango | New York | 36017 | 4245 | 86 |
1750240 | 1750240 | 2021-09-24 | Chenango | New York | 36017 | 4233 | 86 |
1746990 | 1746990 | 2021-09-23 | Chenango | New York | 36017 | 4212 | 86 |
1743741 | 1743741 | 2021-09-22 | Chenango | New York | 36017 | 4190 | 86 |
1740492 | 1740492 | 2021-09-21 | Chenango | New York | 36017 | 4168 | 86 |
1737243 | 1737243 | 2021-09-20 | Chenango | New York | 36017 | 4156 | 86 |
1733993 | 1733993 | 2021-09-19 | Chenango | New York | 36017 | 4148 | 86 |
1730743 | 1730743 | 2021-09-18 | Chenango | New York | 36017 | 4133 | 85 |
1727493 | 1727493 | 2021-09-17 | Chenango | New York | 36017 | 4112 | 85 |
1724244 | 1724244 | 2021-09-16 | Chenango | New York | 36017 | 4098 | 85 |
1720995 | 1720995 | 2021-09-15 | Chenango | New York | 36017 | 4080 | 85 |
1717747 | 1717747 | 2021-09-14 | Chenango | New York | 36017 | 4068 | 85 |
1714499 | 1714499 | 2021-09-13 | Chenango | New York | 36017 | 4057 | 85 |
1711253 | 1711253 | 2021-09-12 | Chenango | New York | 36017 | 4046 | 85 |
1708006 | 1708006 | 2021-09-11 | Chenango | New York | 36017 | 4031 | 85 |
1704759 | 1704759 | 2021-09-10 | Chenango | New York | 36017 | 4020 | 85 |
1701509 | 1701509 | 2021-09-09 | Chenango | New York | 36017 | 4002 | 85 |
1698260 | 1698260 | 2021-09-08 | Chenango | New York | 36017 | 3991 | 85 |
1695012 | 1695012 | 2021-09-07 | Chenango | New York | 36017 | 3985 | 84 |
1691764 | 1691764 | 2021-09-06 | Chenango | New York | 36017 | 3977 | 84 |
1688514 | 1688514 | 2021-09-05 | Chenango | New York | 36017 | 3968 | 84 |
1685264 | 1685264 | 2021-09-04 | Chenango | New York | 36017 | 3956 | 84 |
1682013 | 1682013 | 2021-09-03 | Chenango | New York | 36017 | 3938 | 84 |
1678764 | 1678764 | 2021-09-02 | Chenango | New York | 36017 | 3926 | 83 |
1675516 | 1675516 | 2021-09-01 | Chenango | New York | 36017 | 3904 | 83 |
1672269 | 1672269 | 2021-08-31 | Chenango | New York | 36017 | 3887 | 83 |
1669021 | 1669021 | 2021-08-30 | Chenango | New York | 36017 | 3872 | 82 |
1665774 | 1665774 | 2021-08-29 | Chenango | New York | 36017 | 3860 | 82 |
1662526 | 1662526 | 2021-08-28 | Chenango | New York | 36017 | 3849 | 82 |
1659278 | 1659278 | 2021-08-27 | Chenango | New York | 36017 | 3838 | 82 |
1656029 | 1656029 | 2021-08-26 | Chenango | New York | 36017 | 3823 | 82 |
1652782 | 1652782 | 2021-08-25 | Chenango | New York | 36017 | 3809 | 82 |
1649534 | 1649534 | 2021-08-24 | Chenango | New York | 36017 | 3794 | 82 |
1646285 | 1646285 | 2021-08-23 | Chenango | New York | 36017 | 3784 | 81 |
1643036 | 1643036 | 2021-08-22 | Chenango | New York | 36017 | 3777 | 81 |
1639786 | 1639786 | 2021-08-21 | Chenango | New York | 36017 | 3767 | 79 |
1636536 | 1636536 | 2021-08-20 | Chenango | New York | 36017 | 3751 | 79 |
1633286 | 1633286 | 2021-08-19 | Chenango | New York | 36017 | 3738 | 79 |
1630039 | 1630039 | 2021-08-18 | Chenango | New York | 36017 | 3726 | 78 |
1626792 | 1626792 | 2021-08-17 | Chenango | New York | 36017 | 3713 | 78 |
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);