ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36017 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 |
---|---|---|---|---|---|---|---|
2110985 | 2110985 | 2022-01-13 | Chenango | New York | 36017 | 7625 | 104 |
2107733 | 2107733 | 2022-01-12 | Chenango | New York | 36017 | 7534 | 103 |
2104482 | 2104482 | 2022-01-11 | Chenango | New York | 36017 | 7477 | 103 |
2101231 | 2101231 | 2022-01-10 | Chenango | New York | 36017 | 7449 | 103 |
2097980 | 2097980 | 2022-01-09 | Chenango | New York | 36017 | 7408 | 103 |
2094728 | 2094728 | 2022-01-08 | Chenango | New York | 36017 | 7313 | 103 |
2091476 | 2091476 | 2022-01-07 | Chenango | New York | 36017 | 7204 | 102 |
2088225 | 2088225 | 2022-01-06 | Chenango | New York | 36017 | 7120 | 101 |
2084973 | 2084973 | 2022-01-05 | Chenango | New York | 36017 | 7008 | 101 |
2081721 | 2081721 | 2022-01-04 | Chenango | New York | 36017 | 6931 | 101 |
2078469 | 2078469 | 2022-01-03 | Chenango | New York | 36017 | 6868 | 101 |
2075218 | 2075218 | 2022-01-02 | Chenango | New York | 36017 | 6837 | 101 |
2071967 | 2071967 | 2022-01-01 | Chenango | New York | 36017 | 6785 | 101 |
2068716 | 2068716 | 2021-12-31 | Chenango | New York | 36017 | 6717 | 101 |
2065465 | 2065465 | 2021-12-30 | Chenango | New York | 36017 | 6637 | 101 |
2062215 | 2062215 | 2021-12-29 | Chenango | New York | 36017 | 6598 | 101 |
2058966 | 2058966 | 2021-12-28 | Chenango | New York | 36017 | 6559 | 100 |
2055717 | 2055717 | 2021-12-27 | Chenango | New York | 36017 | 6539 | 100 |
2052467 | 2052467 | 2021-12-26 | Chenango | New York | 36017 | 6533 | 100 |
2049217 | 2049217 | 2021-12-25 | Chenango | New York | 36017 | 6493 | 100 |
2045967 | 2045967 | 2021-12-24 | Chenango | New York | 36017 | 6493 | 100 |
2042717 | 2042717 | 2021-12-23 | Chenango | New York | 36017 | 6447 | 99 |
2039468 | 2039468 | 2021-12-22 | Chenango | New York | 36017 | 6413 | 99 |
2036218 | 2036218 | 2021-12-21 | Chenango | New York | 36017 | 6382 | 98 |
2032968 | 2032968 | 2021-12-20 | Chenango | New York | 36017 | 6362 | 98 |
2029718 | 2029718 | 2021-12-19 | Chenango | New York | 36017 | 6334 | 98 |
2026467 | 2026467 | 2021-12-18 | Chenango | New York | 36017 | 6297 | 98 |
2023216 | 2023216 | 2021-12-17 | Chenango | New York | 36017 | 6250 | 98 |
2019965 | 2019965 | 2021-12-16 | Chenango | New York | 36017 | 6190 | 98 |
2016714 | 2016714 | 2021-12-15 | Chenango | New York | 36017 | 6137 | 98 |
2013464 | 2013464 | 2021-12-14 | Chenango | New York | 36017 | 6095 | 98 |
2010213 | 2010213 | 2021-12-13 | Chenango | New York | 36017 | 6070 | 98 |
2006962 | 2006962 | 2021-12-12 | Chenango | New York | 36017 | 6048 | 98 |
2003711 | 2003711 | 2021-12-11 | Chenango | New York | 36017 | 6016 | 98 |
2000460 | 2000460 | 2021-12-10 | Chenango | New York | 36017 | 5953 | 98 |
1997210 | 1997210 | 2021-12-09 | Chenango | New York | 36017 | 5923 | 98 |
1993959 | 1993959 | 2021-12-08 | Chenango | New York | 36017 | 5880 | 98 |
1990708 | 1990708 | 2021-12-07 | Chenango | New York | 36017 | 5844 | 98 |
1987457 | 1987457 | 2021-12-06 | Chenango | New York | 36017 | 5787 | 98 |
1984207 | 1984207 | 2021-12-05 | Chenango | New York | 36017 | 5766 | 97 |
1980957 | 1980957 | 2021-12-04 | Chenango | New York | 36017 | 5727 | 97 |
1977707 | 1977707 | 2021-12-03 | Chenango | New York | 36017 | 5679 | 97 |
1974457 | 1974457 | 2021-12-02 | Chenango | New York | 36017 | 5628 | 97 |
1971208 | 1971208 | 2021-12-01 | Chenango | New York | 36017 | 5587 | 96 |
1967958 | 1967958 | 2021-11-30 | Chenango | New York | 36017 | 5547 | 95 |
1964707 | 1964707 | 2021-11-29 | Chenango | New York | 36017 | 5527 | 95 |
1961455 | 1961455 | 2021-11-28 | Chenango | New York | 36017 | 5508 | 95 |
1958204 | 1958204 | 2021-11-27 | Chenango | New York | 36017 | 5490 | 95 |
1954953 | 1954953 | 2021-11-26 | Chenango | New York | 36017 | 5479 | 95 |
1951702 | 1951702 | 2021-11-25 | Chenango | New York | 36017 | 5452 | 95 |
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 |
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);