ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Oswego" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176079 | 2176079 | 2022-02-02 | Oswego | New York | 36075 | 23537 | 162 |
2172826 | 2172826 | 2022-02-01 | Oswego | New York | 36075 | 23423 | 161 |
2169573 | 2169573 | 2022-01-31 | Oswego | New York | 36075 | 23327 | 161 |
2166318 | 2166318 | 2022-01-30 | Oswego | New York | 36075 | 23258 | 161 |
2163063 | 2163063 | 2022-01-29 | Oswego | New York | 36075 | 23165 | 161 |
2159808 | 2159808 | 2022-01-28 | Oswego | New York | 36075 | 23019 | 161 |
2156553 | 2156553 | 2022-01-27 | Oswego | New York | 36075 | 22876 | 161 |
2153300 | 2153300 | 2022-01-26 | Oswego | New York | 36075 | 22719 | 160 |
2150048 | 2150048 | 2022-01-25 | Oswego | New York | 36075 | 22530 | 160 |
2146796 | 2146796 | 2022-01-24 | Oswego | New York | 36075 | 22409 | 160 |
2143542 | 2143542 | 2022-01-23 | Oswego | New York | 36075 | 22327 | 160 |
2140287 | 2140287 | 2022-01-22 | Oswego | New York | 36075 | 22169 | 159 |
2137031 | 2137031 | 2022-01-21 | Oswego | New York | 36075 | 21963 | 158 |
2133778 | 2133778 | 2022-01-20 | Oswego | New York | 36075 | 21765 | 157 |
2130526 | 2130526 | 2022-01-19 | Oswego | New York | 36075 | 21509 | 157 |
2127272 | 2127272 | 2022-01-18 | Oswego | New York | 36075 | 21389 | 157 |
2124020 | 2124020 | 2022-01-17 | Oswego | New York | 36075 | 21220 | 157 |
2120768 | 2120768 | 2022-01-16 | Oswego | New York | 36075 | 21066 | 157 |
2117516 | 2117516 | 2022-01-15 | Oswego | New York | 36075 | 20814 | 156 |
2114265 | 2114265 | 2022-01-14 | Oswego | New York | 36075 | 20551 | 155 |
2111013 | 2111013 | 2022-01-13 | Oswego | New York | 36075 | 20288 | 155 |
2107761 | 2107761 | 2022-01-12 | Oswego | New York | 36075 | 20002 | 154 |
2104510 | 2104510 | 2022-01-11 | Oswego | New York | 36075 | 19791 | 153 |
2101259 | 2101259 | 2022-01-10 | Oswego | New York | 36075 | 19526 | 153 |
2098008 | 2098008 | 2022-01-09 | Oswego | New York | 36075 | 19323 | 153 |
2094756 | 2094756 | 2022-01-08 | Oswego | New York | 36075 | 19048 | 151 |
2091504 | 2091504 | 2022-01-07 | Oswego | New York | 36075 | 18675 | 151 |
2088253 | 2088253 | 2022-01-06 | Oswego | New York | 36075 | 18422 | 151 |
2085001 | 2085001 | 2022-01-05 | Oswego | New York | 36075 | 18144 | 150 |
2081749 | 2081749 | 2022-01-04 | Oswego | New York | 36075 | 17952 | 149 |
2078497 | 2078497 | 2022-01-03 | Oswego | New York | 36075 | 17764 | 148 |
2075246 | 2075246 | 2022-01-02 | Oswego | New York | 36075 | 17574 | 148 |
2071995 | 2071995 | 2022-01-01 | Oswego | New York | 36075 | 17454 | 148 |
2068744 | 2068744 | 2021-12-31 | Oswego | New York | 36075 | 17204 | 147 |
2065493 | 2065493 | 2021-12-30 | Oswego | New York | 36075 | 17021 | 147 |
2062243 | 2062243 | 2021-12-29 | Oswego | New York | 36075 | 16844 | 146 |
2058994 | 2058994 | 2021-12-28 | Oswego | New York | 36075 | 16628 | 144 |
2055745 | 2055745 | 2021-12-27 | Oswego | New York | 36075 | 16593 | 144 |
2052495 | 2052495 | 2021-12-26 | Oswego | New York | 36075 | 16565 | 143 |
2049245 | 2049245 | 2021-12-25 | Oswego | New York | 36075 | 16491 | 143 |
2045995 | 2045995 | 2021-12-24 | Oswego | New York | 36075 | 16491 | 143 |
2042745 | 2042745 | 2021-12-23 | Oswego | New York | 36075 | 16370 | 143 |
2039496 | 2039496 | 2021-12-22 | Oswego | New York | 36075 | 16278 | 140 |
2036246 | 2036246 | 2021-12-21 | Oswego | New York | 36075 | 16165 | 139 |
2032996 | 2032996 | 2021-12-20 | Oswego | New York | 36075 | 16106 | 139 |
2029746 | 2029746 | 2021-12-19 | Oswego | New York | 36075 | 16039 | 139 |
2026495 | 2026495 | 2021-12-18 | Oswego | New York | 36075 | 15970 | 139 |
2023244 | 2023244 | 2021-12-17 | Oswego | New York | 36075 | 15862 | 138 |
2019993 | 2019993 | 2021-12-16 | Oswego | New York | 36075 | 15742 | 138 |
2016742 | 2016742 | 2021-12-15 | Oswego | New York | 36075 | 15599 | 138 |
2013492 | 2013492 | 2021-12-14 | Oswego | New York | 36075 | 15495 | 138 |
2010241 | 2010241 | 2021-12-13 | Oswego | New York | 36075 | 15421 | 138 |
2006990 | 2006990 | 2021-12-12 | Oswego | New York | 36075 | 15348 | 138 |
2003739 | 2003739 | 2021-12-11 | Oswego | New York | 36075 | 15263 | 138 |
2000488 | 2000488 | 2021-12-10 | Oswego | New York | 36075 | 15177 | 138 |
1997238 | 1997238 | 2021-12-09 | Oswego | New York | 36075 | 15050 | 138 |
1993987 | 1993987 | 2021-12-08 | Oswego | New York | 36075 | 14943 | 138 |
1990736 | 1990736 | 2021-12-07 | Oswego | New York | 36075 | 14855 | 138 |
1987485 | 1987485 | 2021-12-06 | Oswego | New York | 36075 | 14784 | 138 |
1984235 | 1984235 | 2021-12-05 | Oswego | New York | 36075 | 14725 | 138 |
1980985 | 1980985 | 2021-12-04 | Oswego | New York | 36075 | 14611 | 138 |
1977735 | 1977735 | 2021-12-03 | Oswego | New York | 36075 | 14513 | 138 |
1974485 | 1974485 | 2021-12-02 | Oswego | New York | 36075 | 14409 | 135 |
1971236 | 1971236 | 2021-12-01 | Oswego | New York | 36075 | 14282 | 135 |
1967986 | 1967986 | 2021-11-30 | Oswego | New York | 36075 | 14170 | 135 |
1964735 | 1964735 | 2021-11-29 | Oswego | New York | 36075 | 14083 | 133 |
1961483 | 1961483 | 2021-11-28 | Oswego | New York | 36075 | 14047 | 133 |
1958232 | 1958232 | 2021-11-27 | Oswego | New York | 36075 | 14008 | 132 |
1954981 | 1954981 | 2021-11-26 | Oswego | New York | 36075 | 13956 | 132 |
1951730 | 1951730 | 2021-11-25 | Oswego | New York | 36075 | 13890 | 132 |
1948479 | 1948479 | 2021-11-24 | Oswego | New York | 36075 | 13796 | 132 |
1945228 | 1945228 | 2021-11-23 | Oswego | New York | 36075 | 13702 | 132 |
1941977 | 1941977 | 2021-11-22 | Oswego | New York | 36075 | 13628 | 132 |
1938727 | 1938727 | 2021-11-21 | Oswego | New York | 36075 | 13587 | 130 |
1935477 | 1935477 | 2021-11-20 | Oswego | New York | 36075 | 13516 | 129 |
1932227 | 1932227 | 2021-11-19 | Oswego | New York | 36075 | 13437 | 129 |
1928976 | 1928976 | 2021-11-18 | Oswego | New York | 36075 | 13357 | 128 |
1925726 | 1925726 | 2021-11-17 | Oswego | New York | 36075 | 13247 | 127 |
1922477 | 1922477 | 2021-11-16 | Oswego | New York | 36075 | 13149 | 127 |
1919227 | 1919227 | 2021-11-15 | Oswego | New York | 36075 | 13085 | 126 |
1915977 | 1915977 | 2021-11-14 | Oswego | New York | 36075 | 13046 | 126 |
1912727 | 1912727 | 2021-11-13 | Oswego | New York | 36075 | 12966 | 126 |
1909477 | 1909477 | 2021-11-12 | Oswego | New York | 36075 | 12898 | 126 |
1906228 | 1906228 | 2021-11-11 | Oswego | New York | 36075 | 12806 | 123 |
1902979 | 1902979 | 2021-11-10 | Oswego | New York | 36075 | 12720 | 123 |
1899729 | 1899729 | 2021-11-09 | Oswego | New York | 36075 | 12642 | 122 |
1896479 | 1896479 | 2021-11-08 | Oswego | New York | 36075 | 12588 | 122 |
1893229 | 1893229 | 2021-11-07 | Oswego | New York | 36075 | 12550 | 122 |
1889979 | 1889979 | 2021-11-06 | Oswego | New York | 36075 | 12512 | 122 |
1886729 | 1886729 | 2021-11-05 | Oswego | New York | 36075 | 12435 | 122 |
1883480 | 1883480 | 2021-11-04 | Oswego | New York | 36075 | 12395 | 121 |
1880231 | 1880231 | 2021-11-03 | Oswego | New York | 36075 | 12340 | 120 |
1876982 | 1876982 | 2021-11-02 | Oswego | New York | 36075 | 12284 | 120 |
1873733 | 1873733 | 2021-11-01 | Oswego | New York | 36075 | 12251 | 120 |
1870484 | 1870484 | 2021-10-31 | Oswego | New York | 36075 | 12202 | 120 |
1867235 | 1867235 | 2021-10-30 | Oswego | New York | 36075 | 12172 | 119 |
1863986 | 1863986 | 2021-10-29 | Oswego | New York | 36075 | 12108 | 117 |
1860737 | 1860737 | 2021-10-28 | Oswego | New York | 36075 | 12028 | 116 |
1857488 | 1857488 | 2021-10-27 | Oswego | New York | 36075 | 11988 | 116 |
1854239 | 1854239 | 2021-10-26 | Oswego | New York | 36075 | 11913 | 116 |
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);