ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 36057 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 |
---|---|---|---|---|---|---|---|
2176070 | 2176070 | 2022-02-02 | Montgomery | New York | 36057 | 11198 | 187 |
2172817 | 2172817 | 2022-02-01 | Montgomery | New York | 36057 | 11151 | 187 |
2169564 | 2169564 | 2022-01-31 | Montgomery | New York | 36057 | 11127 | 186 |
2166309 | 2166309 | 2022-01-30 | Montgomery | New York | 36057 | 11103 | 185 |
2163054 | 2163054 | 2022-01-29 | Montgomery | New York | 36057 | 11060 | 184 |
2159799 | 2159799 | 2022-01-28 | Montgomery | New York | 36057 | 11002 | 184 |
2156544 | 2156544 | 2022-01-27 | Montgomery | New York | 36057 | 10936 | 183 |
2153291 | 2153291 | 2022-01-26 | Montgomery | New York | 36057 | 10853 | 183 |
2150039 | 2150039 | 2022-01-25 | Montgomery | New York | 36057 | 10798 | 183 |
2146787 | 2146787 | 2022-01-24 | Montgomery | New York | 36057 | 10724 | 183 |
2143533 | 2143533 | 2022-01-23 | Montgomery | New York | 36057 | 10673 | 183 |
2140278 | 2140278 | 2022-01-22 | Montgomery | New York | 36057 | 10595 | 183 |
2137022 | 2137022 | 2022-01-21 | Montgomery | New York | 36057 | 10486 | 182 |
2133769 | 2133769 | 2022-01-20 | Montgomery | New York | 36057 | 10387 | 182 |
2130517 | 2130517 | 2022-01-19 | Montgomery | New York | 36057 | 10307 | 182 |
2127263 | 2127263 | 2022-01-18 | Montgomery | New York | 36057 | 10251 | 182 |
2124011 | 2124011 | 2022-01-17 | Montgomery | New York | 36057 | 10187 | 182 |
2120759 | 2120759 | 2022-01-16 | Montgomery | New York | 36057 | 10115 | 181 |
2117507 | 2117507 | 2022-01-15 | Montgomery | New York | 36057 | 10027 | 180 |
2114256 | 2114256 | 2022-01-14 | Montgomery | New York | 36057 | 9907 | 179 |
2111004 | 2111004 | 2022-01-13 | Montgomery | New York | 36057 | 9785 | 179 |
2107752 | 2107752 | 2022-01-12 | Montgomery | New York | 36057 | 9671 | 179 |
2104501 | 2104501 | 2022-01-11 | Montgomery | New York | 36057 | 9550 | 179 |
2101250 | 2101250 | 2022-01-10 | Montgomery | New York | 36057 | 9451 | 179 |
2097999 | 2097999 | 2022-01-09 | Montgomery | New York | 36057 | 9380 | 179 |
2094747 | 2094747 | 2022-01-08 | Montgomery | New York | 36057 | 9224 | 178 |
2091495 | 2091495 | 2022-01-07 | Montgomery | New York | 36057 | 9050 | 178 |
2088244 | 2088244 | 2022-01-06 | Montgomery | New York | 36057 | 8883 | 177 |
2084992 | 2084992 | 2022-01-05 | Montgomery | New York | 36057 | 8736 | 177 |
2081740 | 2081740 | 2022-01-04 | Montgomery | New York | 36057 | 8604 | 177 |
2078488 | 2078488 | 2022-01-03 | Montgomery | New York | 36057 | 8567 | 177 |
2075237 | 2075237 | 2022-01-02 | Montgomery | New York | 36057 | 8506 | 177 |
2071986 | 2071986 | 2022-01-01 | Montgomery | New York | 36057 | 8469 | 177 |
2068735 | 2068735 | 2021-12-31 | Montgomery | New York | 36057 | 8386 | 176 |
2065484 | 2065484 | 2021-12-30 | Montgomery | New York | 36057 | 8306 | 176 |
2062234 | 2062234 | 2021-12-29 | Montgomery | New York | 36057 | 8230 | 176 |
2058985 | 2058985 | 2021-12-28 | Montgomery | New York | 36057 | 8150 | 174 |
2055736 | 2055736 | 2021-12-27 | Montgomery | New York | 36057 | 8145 | 173 |
2052486 | 2052486 | 2021-12-26 | Montgomery | New York | 36057 | 8141 | 173 |
2049236 | 2049236 | 2021-12-25 | Montgomery | New York | 36057 | 8124 | 173 |
2045986 | 2045986 | 2021-12-24 | Montgomery | New York | 36057 | 8124 | 173 |
2042736 | 2042736 | 2021-12-23 | Montgomery | New York | 36057 | 8080 | 172 |
2039487 | 2039487 | 2021-12-22 | Montgomery | New York | 36057 | 8044 | 172 |
2036237 | 2036237 | 2021-12-21 | Montgomery | New York | 36057 | 8004 | 171 |
2032987 | 2032987 | 2021-12-20 | Montgomery | New York | 36057 | 7964 | 170 |
2029737 | 2029737 | 2021-12-19 | Montgomery | New York | 36057 | 7945 | 170 |
2026486 | 2026486 | 2021-12-18 | Montgomery | New York | 36057 | 7919 | 170 |
2023235 | 2023235 | 2021-12-17 | Montgomery | New York | 36057 | 7885 | 169 |
2019984 | 2019984 | 2021-12-16 | Montgomery | New York | 36057 | 7834 | 169 |
2016733 | 2016733 | 2021-12-15 | Montgomery | New York | 36057 | 7799 | 169 |
2013483 | 2013483 | 2021-12-14 | Montgomery | New York | 36057 | 7763 | 169 |
2010232 | 2010232 | 2021-12-13 | Montgomery | New York | 36057 | 7735 | 169 |
2006981 | 2006981 | 2021-12-12 | Montgomery | New York | 36057 | 7715 | 168 |
2003730 | 2003730 | 2021-12-11 | Montgomery | New York | 36057 | 7687 | 168 |
2000479 | 2000479 | 2021-12-10 | Montgomery | New York | 36057 | 7649 | 166 |
1997229 | 1997229 | 2021-12-09 | Montgomery | New York | 36057 | 7605 | 166 |
1993978 | 1993978 | 2021-12-08 | Montgomery | New York | 36057 | 7569 | 165 |
1990727 | 1990727 | 2021-12-07 | Montgomery | New York | 36057 | 7519 | 165 |
1987476 | 1987476 | 2021-12-06 | Montgomery | New York | 36057 | 7492 | 165 |
1984226 | 1984226 | 2021-12-05 | Montgomery | New York | 36057 | 7453 | 165 |
1980976 | 1980976 | 2021-12-04 | Montgomery | New York | 36057 | 7406 | 163 |
1977726 | 1977726 | 2021-12-03 | Montgomery | New York | 36057 | 7353 | 163 |
1974476 | 1974476 | 2021-12-02 | Montgomery | New York | 36057 | 7287 | 162 |
1971227 | 1971227 | 2021-12-01 | Montgomery | New York | 36057 | 7246 | 162 |
1967977 | 1967977 | 2021-11-30 | Montgomery | New York | 36057 | 7191 | 162 |
1964726 | 1964726 | 2021-11-29 | Montgomery | New York | 36057 | 7159 | 162 |
1961474 | 1961474 | 2021-11-28 | Montgomery | New York | 36057 | 7110 | 162 |
1958223 | 1958223 | 2021-11-27 | Montgomery | New York | 36057 | 7081 | 162 |
1954972 | 1954972 | 2021-11-26 | Montgomery | New York | 36057 | 7073 | 159 |
1951721 | 1951721 | 2021-11-25 | Montgomery | New York | 36057 | 7027 | 159 |
1948470 | 1948470 | 2021-11-24 | Montgomery | New York | 36057 | 6997 | 159 |
1945219 | 1945219 | 2021-11-23 | Montgomery | New York | 36057 | 6966 | 159 |
1941968 | 1941968 | 2021-11-22 | Montgomery | New York | 36057 | 6936 | 159 |
1938718 | 1938718 | 2021-11-21 | Montgomery | New York | 36057 | 6922 | 159 |
1935468 | 1935468 | 2021-11-20 | Montgomery | New York | 36057 | 6877 | 159 |
1932218 | 1932218 | 2021-11-19 | Montgomery | New York | 36057 | 6849 | 159 |
1928967 | 1928967 | 2021-11-18 | Montgomery | New York | 36057 | 6808 | 159 |
1925717 | 1925717 | 2021-11-17 | Montgomery | New York | 36057 | 6757 | 159 |
1922468 | 1922468 | 2021-11-16 | Montgomery | New York | 36057 | 6707 | 159 |
1919218 | 1919218 | 2021-11-15 | Montgomery | New York | 36057 | 6681 | 159 |
1915968 | 1915968 | 2021-11-14 | Montgomery | New York | 36057 | 6663 | 158 |
1912718 | 1912718 | 2021-11-13 | Montgomery | New York | 36057 | 6625 | 158 |
1909468 | 1909468 | 2021-11-12 | Montgomery | New York | 36057 | 6578 | 158 |
1906219 | 1906219 | 2021-11-11 | Montgomery | New York | 36057 | 6533 | 157 |
1902970 | 1902970 | 2021-11-10 | Montgomery | New York | 36057 | 6477 | 156 |
1899720 | 1899720 | 2021-11-09 | Montgomery | New York | 36057 | 6447 | 156 |
1896470 | 1896470 | 2021-11-08 | Montgomery | New York | 36057 | 6405 | 155 |
1893220 | 1893220 | 2021-11-07 | Montgomery | New York | 36057 | 6387 | 154 |
1889970 | 1889970 | 2021-11-06 | Montgomery | New York | 36057 | 6365 | 153 |
1886720 | 1886720 | 2021-11-05 | Montgomery | New York | 36057 | 6338 | 153 |
1883471 | 1883471 | 2021-11-04 | Montgomery | New York | 36057 | 6325 | 152 |
1880222 | 1880222 | 2021-11-03 | Montgomery | New York | 36057 | 6302 | 152 |
1876973 | 1876973 | 2021-11-02 | Montgomery | New York | 36057 | 6277 | 151 |
1873724 | 1873724 | 2021-11-01 | Montgomery | New York | 36057 | 6264 | 151 |
1870475 | 1870475 | 2021-10-31 | Montgomery | New York | 36057 | 6240 | 150 |
1867226 | 1867226 | 2021-10-30 | Montgomery | New York | 36057 | 6211 | 150 |
1863977 | 1863977 | 2021-10-29 | Montgomery | New York | 36057 | 6184 | 150 |
1860728 | 1860728 | 2021-10-28 | Montgomery | New York | 36057 | 6136 | 149 |
1857479 | 1857479 | 2021-10-27 | Montgomery | New York | 36057 | 6103 | 146 |
1854230 | 1854230 | 2021-10-26 | Montgomery | New York | 36057 | 6074 | 145 |
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);