ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36019 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 |
---|---|---|---|---|---|---|---|
2110986 | 2110986 | 2022-01-13 | Clinton | New York | 36019 | 12130 | 61 |
2107734 | 2107734 | 2022-01-12 | Clinton | New York | 36019 | 11909 | 60 |
2104483 | 2104483 | 2022-01-11 | Clinton | New York | 36019 | 11771 | 59 |
2101232 | 2101232 | 2022-01-10 | Clinton | New York | 36019 | 11655 | 59 |
2097981 | 2097981 | 2022-01-09 | Clinton | New York | 36019 | 11401 | 59 |
2094729 | 2094729 | 2022-01-08 | Clinton | New York | 36019 | 11178 | 59 |
2091477 | 2091477 | 2022-01-07 | Clinton | New York | 36019 | 10889 | 59 |
2088226 | 2088226 | 2022-01-06 | Clinton | New York | 36019 | 10640 | 59 |
2084974 | 2084974 | 2022-01-05 | Clinton | New York | 36019 | 10404 | 58 |
2081722 | 2081722 | 2022-01-04 | Clinton | New York | 36019 | 10294 | 58 |
2078470 | 2078470 | 2022-01-03 | Clinton | New York | 36019 | 10259 | 58 |
2075219 | 2075219 | 2022-01-02 | Clinton | New York | 36019 | 10170 | 58 |
2071968 | 2071968 | 2022-01-01 | Clinton | New York | 36019 | 10057 | 58 |
2068717 | 2068717 | 2021-12-31 | Clinton | New York | 36019 | 9900 | 57 |
2065466 | 2065466 | 2021-12-30 | Clinton | New York | 36019 | 9744 | 57 |
2062216 | 2062216 | 2021-12-29 | Clinton | New York | 36019 | 9615 | 56 |
2058967 | 2058967 | 2021-12-28 | Clinton | New York | 36019 | 9568 | 55 |
2055718 | 2055718 | 2021-12-27 | Clinton | New York | 36019 | 9533 | 54 |
2052468 | 2052468 | 2021-12-26 | Clinton | New York | 36019 | 9519 | 54 |
2049218 | 2049218 | 2021-12-25 | Clinton | New York | 36019 | 9400 | 54 |
2045968 | 2045968 | 2021-12-24 | Clinton | New York | 36019 | 9400 | 54 |
2042718 | 2042718 | 2021-12-23 | Clinton | New York | 36019 | 9333 | 53 |
2039469 | 2039469 | 2021-12-22 | Clinton | New York | 36019 | 9240 | 53 |
2036219 | 2036219 | 2021-12-21 | Clinton | New York | 36019 | 9204 | 53 |
2032969 | 2032969 | 2021-12-20 | Clinton | New York | 36019 | 9152 | 53 |
2029719 | 2029719 | 2021-12-19 | Clinton | New York | 36019 | 9109 | 53 |
2026468 | 2026468 | 2021-12-18 | Clinton | New York | 36019 | 9046 | 53 |
2023217 | 2023217 | 2021-12-17 | Clinton | New York | 36019 | 8969 | 53 |
2019966 | 2019966 | 2021-12-16 | Clinton | New York | 36019 | 8917 | 53 |
2016715 | 2016715 | 2021-12-15 | Clinton | New York | 36019 | 8847 | 53 |
2013465 | 2013465 | 2021-12-14 | Clinton | New York | 36019 | 8809 | 52 |
2010214 | 2010214 | 2021-12-13 | Clinton | New York | 36019 | 8785 | 50 |
2006963 | 2006963 | 2021-12-12 | Clinton | New York | 36019 | 8746 | 50 |
2003712 | 2003712 | 2021-12-11 | Clinton | New York | 36019 | 8676 | 50 |
2000461 | 2000461 | 2021-12-10 | Clinton | New York | 36019 | 8619 | 50 |
1997211 | 1997211 | 2021-12-09 | Clinton | New York | 36019 | 8567 | 50 |
1993960 | 1993960 | 2021-12-08 | Clinton | New York | 36019 | 8503 | 50 |
1990709 | 1990709 | 2021-12-07 | Clinton | New York | 36019 | 8469 | 50 |
1987458 | 1987458 | 2021-12-06 | Clinton | New York | 36019 | 8441 | 48 |
1984208 | 1984208 | 2021-12-05 | Clinton | New York | 36019 | 8408 | 48 |
1980958 | 1980958 | 2021-12-04 | Clinton | New York | 36019 | 8349 | 48 |
1977708 | 1977708 | 2021-12-03 | Clinton | New York | 36019 | 8279 | 48 |
1974458 | 1974458 | 2021-12-02 | Clinton | New York | 36019 | 8218 | 48 |
1971209 | 1971209 | 2021-12-01 | Clinton | New York | 36019 | 8146 | 48 |
1967959 | 1967959 | 2021-11-30 | Clinton | New York | 36019 | 8099 | 48 |
1964708 | 1964708 | 2021-11-29 | Clinton | New York | 36019 | 8063 | 48 |
1961456 | 1961456 | 2021-11-28 | Clinton | New York | 36019 | 8017 | 47 |
1958205 | 1958205 | 2021-11-27 | Clinton | New York | 36019 | 7980 | 47 |
1954954 | 1954954 | 2021-11-26 | Clinton | New York | 36019 | 7953 | 46 |
1951703 | 1951703 | 2021-11-25 | Clinton | New York | 36019 | 7904 | 46 |
1948452 | 1948452 | 2021-11-24 | Clinton | New York | 36019 | 7853 | 45 |
1945201 | 1945201 | 2021-11-23 | Clinton | New York | 36019 | 7827 | 45 |
1941950 | 1941950 | 2021-11-22 | Clinton | New York | 36019 | 7806 | 44 |
1938700 | 1938700 | 2021-11-21 | Clinton | New York | 36019 | 7772 | 44 |
1935450 | 1935450 | 2021-11-20 | Clinton | New York | 36019 | 7727 | 44 |
1932200 | 1932200 | 2021-11-19 | Clinton | New York | 36019 | 7684 | 44 |
1928949 | 1928949 | 2021-11-18 | Clinton | New York | 36019 | 7640 | 44 |
1925699 | 1925699 | 2021-11-17 | Clinton | New York | 36019 | 7582 | 44 |
1922450 | 1922450 | 2021-11-16 | Clinton | New York | 36019 | 7565 | 44 |
1919200 | 1919200 | 2021-11-15 | Clinton | New York | 36019 | 7537 | 44 |
1915950 | 1915950 | 2021-11-14 | Clinton | New York | 36019 | 7507 | 44 |
1912700 | 1912700 | 2021-11-13 | Clinton | New York | 36019 | 7487 | 44 |
1909450 | 1909450 | 2021-11-12 | Clinton | New York | 36019 | 7447 | 44 |
1906201 | 1906201 | 2021-11-11 | Clinton | New York | 36019 | 7401 | 44 |
1902952 | 1902952 | 2021-11-10 | Clinton | New York | 36019 | 7358 | 43 |
1899702 | 1899702 | 2021-11-09 | Clinton | New York | 36019 | 7330 | 43 |
1896452 | 1896452 | 2021-11-08 | Clinton | New York | 36019 | 7300 | 43 |
1893202 | 1893202 | 2021-11-07 | Clinton | New York | 36019 | 7239 | 43 |
1889952 | 1889952 | 2021-11-06 | Clinton | New York | 36019 | 7217 | 43 |
1886702 | 1886702 | 2021-11-05 | Clinton | New York | 36019 | 7175 | 42 |
1883453 | 1883453 | 2021-11-04 | Clinton | New York | 36019 | 7134 | 42 |
1880204 | 1880204 | 2021-11-03 | Clinton | New York | 36019 | 7095 | 41 |
1876955 | 1876955 | 2021-11-02 | Clinton | New York | 36019 | 7063 | 41 |
1873706 | 1873706 | 2021-11-01 | Clinton | New York | 36019 | 7052 | 41 |
1870457 | 1870457 | 2021-10-31 | Clinton | New York | 36019 | 7029 | 41 |
1867208 | 1867208 | 2021-10-30 | Clinton | New York | 36019 | 6994 | 41 |
1863959 | 1863959 | 2021-10-29 | Clinton | New York | 36019 | 6962 | 41 |
1860710 | 1860710 | 2021-10-28 | Clinton | New York | 36019 | 6909 | 41 |
1857461 | 1857461 | 2021-10-27 | Clinton | New York | 36019 | 6880 | 41 |
1854212 | 1854212 | 2021-10-26 | Clinton | New York | 36019 | 6853 | 41 |
1850963 | 1850963 | 2021-10-25 | Clinton | New York | 36019 | 6837 | 40 |
1847713 | 1847713 | 2021-10-24 | Clinton | New York | 36019 | 6807 | 40 |
1844463 | 1844463 | 2021-10-23 | Clinton | New York | 36019 | 6787 | 40 |
1841213 | 1841213 | 2021-10-22 | Clinton | New York | 36019 | 6750 | 40 |
1837964 | 1837964 | 2021-10-21 | Clinton | New York | 36019 | 6725 | 40 |
1834715 | 1834715 | 2021-10-20 | Clinton | New York | 36019 | 6679 | 39 |
1831466 | 1831466 | 2021-10-19 | Clinton | New York | 36019 | 6665 | 38 |
1828217 | 1828217 | 2021-10-18 | Clinton | New York | 36019 | 6654 | 38 |
1824968 | 1824968 | 2021-10-17 | Clinton | New York | 36019 | 6631 | 38 |
1821719 | 1821719 | 2021-10-16 | Clinton | New York | 36019 | 6603 | 38 |
1818470 | 1818470 | 2021-10-15 | Clinton | New York | 36019 | 6561 | 38 |
1815221 | 1815221 | 2021-10-14 | Clinton | New York | 36019 | 6530 | 38 |
1811973 | 1811973 | 2021-10-13 | Clinton | New York | 36019 | 6507 | 38 |
1808724 | 1808724 | 2021-10-12 | Clinton | New York | 36019 | 6480 | 38 |
1805473 | 1805473 | 2021-10-11 | Clinton | New York | 36019 | 6455 | 37 |
1802224 | 1802224 | 2021-10-10 | Clinton | New York | 36019 | 6396 | 37 |
1798975 | 1798975 | 2021-10-09 | Clinton | New York | 36019 | 6386 | 36 |
1795726 | 1795726 | 2021-10-08 | Clinton | New York | 36019 | 6339 | 36 |
1792477 | 1792477 | 2021-10-07 | Clinton | New York | 36019 | 6288 | 36 |
1789228 | 1789228 | 2021-10-06 | Clinton | New York | 36019 | 6255 | 36 |
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);