ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Herkimer" 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 |
---|---|---|---|---|---|---|---|
2176064 | 2176064 | 2022-02-02 | Herkimer | New York | 36043 | 13071 | 181 |
2172811 | 2172811 | 2022-02-01 | Herkimer | New York | 36043 | 13010 | 179 |
2169558 | 2169558 | 2022-01-31 | Herkimer | New York | 36043 | 12970 | 179 |
2166303 | 2166303 | 2022-01-30 | Herkimer | New York | 36043 | 12925 | 179 |
2163048 | 2163048 | 2022-01-29 | Herkimer | New York | 36043 | 12892 | 178 |
2159793 | 2159793 | 2022-01-28 | Herkimer | New York | 36043 | 12852 | 176 |
2156538 | 2156538 | 2022-01-27 | Herkimer | New York | 36043 | 12784 | 176 |
2153285 | 2153285 | 2022-01-26 | Herkimer | New York | 36043 | 12706 | 176 |
2150033 | 2150033 | 2022-01-25 | Herkimer | New York | 36043 | 12599 | 176 |
2146781 | 2146781 | 2022-01-24 | Herkimer | New York | 36043 | 12532 | 174 |
2143527 | 2143527 | 2022-01-23 | Herkimer | New York | 36043 | 12498 | 174 |
2140272 | 2140272 | 2022-01-22 | Herkimer | New York | 36043 | 12434 | 171 |
2137016 | 2137016 | 2022-01-21 | Herkimer | New York | 36043 | 12353 | 170 |
2133763 | 2133763 | 2022-01-20 | Herkimer | New York | 36043 | 12270 | 170 |
2130511 | 2130511 | 2022-01-19 | Herkimer | New York | 36043 | 12140 | 170 |
2127257 | 2127257 | 2022-01-18 | Herkimer | New York | 36043 | 12081 | 168 |
2124005 | 2124005 | 2022-01-17 | Herkimer | New York | 36043 | 12009 | 168 |
2120753 | 2120753 | 2022-01-16 | Herkimer | New York | 36043 | 11947 | 167 |
2117501 | 2117501 | 2022-01-15 | Herkimer | New York | 36043 | 11860 | 167 |
2114250 | 2114250 | 2022-01-14 | Herkimer | New York | 36043 | 11724 | 166 |
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 |
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);