ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 36043 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 |
---|---|---|---|---|---|---|---|
2110998 | 2110998 | 2022-01-13 | Herkimer | New York | 36043 | 11603 | 166 |
2107746 | 2107746 | 2022-01-12 | Herkimer | New York | 36043 | 11449 | 165 |
2104495 | 2104495 | 2022-01-11 | Herkimer | New York | 36043 | 11280 | 164 |
2101244 | 2101244 | 2022-01-10 | Herkimer | New York | 36043 | 11220 | 163 |
2097993 | 2097993 | 2022-01-09 | Herkimer | New York | 36043 | 11146 | 163 |
2094741 | 2094741 | 2022-01-08 | Herkimer | New York | 36043 | 11053 | 161 |
2091489 | 2091489 | 2022-01-07 | Herkimer | New York | 36043 | 10893 | 161 |
2088238 | 2088238 | 2022-01-06 | Herkimer | New York | 36043 | 10762 | 160 |
2084986 | 2084986 | 2022-01-05 | Herkimer | New York | 36043 | 10611 | 160 |
2081734 | 2081734 | 2022-01-04 | Herkimer | New York | 36043 | 10453 | 160 |
2078482 | 2078482 | 2022-01-03 | Herkimer | New York | 36043 | 10362 | 160 |
2075231 | 2075231 | 2022-01-02 | Herkimer | New York | 36043 | 10313 | 160 |
2071980 | 2071980 | 2022-01-01 | Herkimer | New York | 36043 | 10246 | 160 |
2068729 | 2068729 | 2021-12-31 | Herkimer | New York | 36043 | 10111 | 159 |
2065478 | 2065478 | 2021-12-30 | Herkimer | New York | 36043 | 10031 | 159 |
2062228 | 2062228 | 2021-12-29 | Herkimer | New York | 36043 | 9928 | 158 |
2058979 | 2058979 | 2021-12-28 | Herkimer | New York | 36043 | 9835 | 157 |
2055730 | 2055730 | 2021-12-27 | Herkimer | New York | 36043 | 9784 | 157 |
2052480 | 2052480 | 2021-12-26 | Herkimer | New York | 36043 | 9779 | 156 |
2049230 | 2049230 | 2021-12-25 | Herkimer | New York | 36043 | 9705 | 155 |
2045980 | 2045980 | 2021-12-24 | Herkimer | New York | 36043 | 9705 | 155 |
2042730 | 2042730 | 2021-12-23 | Herkimer | New York | 36043 | 9649 | 154 |
2039481 | 2039481 | 2021-12-22 | Herkimer | New York | 36043 | 9563 | 153 |
2036231 | 2036231 | 2021-12-21 | Herkimer | New York | 36043 | 9497 | 152 |
2032981 | 2032981 | 2021-12-20 | Herkimer | New York | 36043 | 9447 | 151 |
2029731 | 2029731 | 2021-12-19 | Herkimer | New York | 36043 | 9418 | 151 |
2026480 | 2026480 | 2021-12-18 | Herkimer | New York | 36043 | 9367 | 148 |
2023229 | 2023229 | 2021-12-17 | Herkimer | New York | 36043 | 9321 | 148 |
2019978 | 2019978 | 2021-12-16 | Herkimer | New York | 36043 | 9254 | 148 |
2016727 | 2016727 | 2021-12-15 | Herkimer | New York | 36043 | 9188 | 148 |
2013477 | 2013477 | 2021-12-14 | Herkimer | New York | 36043 | 9116 | 148 |
2010226 | 2010226 | 2021-12-13 | Herkimer | New York | 36043 | 9080 | 148 |
2006975 | 2006975 | 2021-12-12 | Herkimer | New York | 36043 | 9048 | 148 |
2003724 | 2003724 | 2021-12-11 | Herkimer | New York | 36043 | 9011 | 147 |
2000473 | 2000473 | 2021-12-10 | Herkimer | New York | 36043 | 8961 | 147 |
1997223 | 1997223 | 2021-12-09 | Herkimer | New York | 36043 | 8891 | 147 |
1993972 | 1993972 | 2021-12-08 | Herkimer | New York | 36043 | 8838 | 147 |
1990721 | 1990721 | 2021-12-07 | Herkimer | New York | 36043 | 8743 | 147 |
1987470 | 1987470 | 2021-12-06 | Herkimer | New York | 36043 | 8686 | 146 |
1984220 | 1984220 | 2021-12-05 | Herkimer | New York | 36043 | 8647 | 146 |
1980970 | 1980970 | 2021-12-04 | Herkimer | New York | 36043 | 8587 | 145 |
1977720 | 1977720 | 2021-12-03 | Herkimer | New York | 36043 | 8557 | 145 |
1974470 | 1974470 | 2021-12-02 | Herkimer | New York | 36043 | 8477 | 143 |
1971221 | 1971221 | 2021-12-01 | Herkimer | New York | 36043 | 8394 | 143 |
1967971 | 1967971 | 2021-11-30 | Herkimer | New York | 36043 | 8312 | 143 |
1964720 | 1964720 | 2021-11-29 | Herkimer | New York | 36043 | 8273 | 143 |
1961468 | 1961468 | 2021-11-28 | Herkimer | New York | 36043 | 8228 | 143 |
1958217 | 1958217 | 2021-11-27 | Herkimer | New York | 36043 | 8180 | 143 |
1954966 | 1954966 | 2021-11-26 | Herkimer | New York | 36043 | 8165 | 141 |
1951715 | 1951715 | 2021-11-25 | Herkimer | New York | 36043 | 8139 | 141 |
1948464 | 1948464 | 2021-11-24 | Herkimer | New York | 36043 | 8085 | 141 |
1945213 | 1945213 | 2021-11-23 | Herkimer | New York | 36043 | 8045 | 140 |
1941962 | 1941962 | 2021-11-22 | Herkimer | New York | 36043 | 8007 | 140 |
1938712 | 1938712 | 2021-11-21 | Herkimer | New York | 36043 | 7967 | 139 |
1935462 | 1935462 | 2021-11-20 | Herkimer | New York | 36043 | 7914 | 139 |
1932212 | 1932212 | 2021-11-19 | Herkimer | New York | 36043 | 7870 | 138 |
1928961 | 1928961 | 2021-11-18 | Herkimer | New York | 36043 | 7806 | 138 |
1925711 | 1925711 | 2021-11-17 | Herkimer | New York | 36043 | 7748 | 136 |
1922462 | 1922462 | 2021-11-16 | Herkimer | New York | 36043 | 7696 | 136 |
1919212 | 1919212 | 2021-11-15 | Herkimer | New York | 36043 | 7648 | 135 |
1915962 | 1915962 | 2021-11-14 | Herkimer | New York | 36043 | 7630 | 135 |
1912712 | 1912712 | 2021-11-13 | Herkimer | New York | 36043 | 7596 | 135 |
1909462 | 1909462 | 2021-11-12 | Herkimer | New York | 36043 | 7543 | 135 |
1906213 | 1906213 | 2021-11-11 | Herkimer | New York | 36043 | 7504 | 134 |
1902964 | 1902964 | 2021-11-10 | Herkimer | New York | 36043 | 7465 | 134 |
1899714 | 1899714 | 2021-11-09 | Herkimer | New York | 36043 | 7410 | 133 |
1896464 | 1896464 | 2021-11-08 | Herkimer | New York | 36043 | 7375 | 133 |
1893214 | 1893214 | 2021-11-07 | Herkimer | New York | 36043 | 7329 | 133 |
1889964 | 1889964 | 2021-11-06 | Herkimer | New York | 36043 | 7275 | 133 |
1886714 | 1886714 | 2021-11-05 | Herkimer | New York | 36043 | 7247 | 132 |
1883465 | 1883465 | 2021-11-04 | Herkimer | New York | 36043 | 7210 | 131 |
1880216 | 1880216 | 2021-11-03 | Herkimer | New York | 36043 | 7160 | 131 |
1876967 | 1876967 | 2021-11-02 | Herkimer | New York | 36043 | 7117 | 131 |
1873718 | 1873718 | 2021-11-01 | Herkimer | New York | 36043 | 7102 | 131 |
1870469 | 1870469 | 2021-10-31 | Herkimer | New York | 36043 | 7077 | 131 |
1867220 | 1867220 | 2021-10-30 | Herkimer | New York | 36043 | 7055 | 131 |
1863971 | 1863971 | 2021-10-29 | Herkimer | New York | 36043 | 7028 | 129 |
1860722 | 1860722 | 2021-10-28 | Herkimer | New York | 36043 | 6994 | 129 |
1857473 | 1857473 | 2021-10-27 | Herkimer | New York | 36043 | 6967 | 129 |
1854224 | 1854224 | 2021-10-26 | Herkimer | New York | 36043 | 6913 | 129 |
1850975 | 1850975 | 2021-10-25 | Herkimer | New York | 36043 | 6890 | 129 |
1847725 | 1847725 | 2021-10-24 | Herkimer | New York | 36043 | 6875 | 128 |
1844475 | 1844475 | 2021-10-23 | Herkimer | New York | 36043 | 6861 | 128 |
1841225 | 1841225 | 2021-10-22 | Herkimer | New York | 36043 | 6831 | 128 |
1837976 | 1837976 | 2021-10-21 | Herkimer | New York | 36043 | 6806 | 128 |
1834727 | 1834727 | 2021-10-20 | Herkimer | New York | 36043 | 6774 | 128 |
1831478 | 1831478 | 2021-10-19 | Herkimer | New York | 36043 | 6741 | 128 |
1828229 | 1828229 | 2021-10-18 | Herkimer | New York | 36043 | 6694 | 126 |
1824980 | 1824980 | 2021-10-17 | Herkimer | New York | 36043 | 6671 | 125 |
1821731 | 1821731 | 2021-10-16 | Herkimer | New York | 36043 | 6646 | 123 |
1818482 | 1818482 | 2021-10-15 | Herkimer | New York | 36043 | 6606 | 123 |
1815233 | 1815233 | 2021-10-14 | Herkimer | New York | 36043 | 6571 | 122 |
1811985 | 1811985 | 2021-10-13 | Herkimer | New York | 36043 | 6542 | 122 |
1808736 | 1808736 | 2021-10-12 | Herkimer | New York | 36043 | 6501 | 122 |
1805485 | 1805485 | 2021-10-11 | Herkimer | New York | 36043 | 6477 | 122 |
1802236 | 1802236 | 2021-10-10 | Herkimer | New York | 36043 | 6444 | 122 |
1798987 | 1798987 | 2021-10-09 | Herkimer | New York | 36043 | 6431 | 121 |
1795738 | 1795738 | 2021-10-08 | Herkimer | New York | 36043 | 6384 | 121 |
1792489 | 1792489 | 2021-10-07 | Herkimer | New York | 36043 | 6354 | 120 |
1789240 | 1789240 | 2021-10-06 | Herkimer | New York | 36043 | 6327 | 120 |
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);