ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Saratoga" 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 |
---|---|---|---|---|---|---|---|
2111018 | 2111018 | 2022-01-13 | Saratoga | New York | 36091 | 37866 | 285 |
2107766 | 2107766 | 2022-01-12 | Saratoga | New York | 36091 | 37305 | 281 |
2104515 | 2104515 | 2022-01-11 | Saratoga | New York | 36091 | 36834 | 280 |
2101264 | 2101264 | 2022-01-10 | Saratoga | New York | 36091 | 36475 | 280 |
2098013 | 2098013 | 2022-01-09 | Saratoga | New York | 36091 | 35955 | 278 |
2094761 | 2094761 | 2022-01-08 | Saratoga | New York | 36091 | 35300 | 277 |
2091509 | 2091509 | 2022-01-07 | Saratoga | New York | 36091 | 34555 | 277 |
2088258 | 2088258 | 2022-01-06 | Saratoga | New York | 36091 | 33850 | 275 |
2085006 | 2085006 | 2022-01-05 | Saratoga | New York | 36091 | 33075 | 271 |
2081754 | 2081754 | 2022-01-04 | Saratoga | New York | 36091 | 32415 | 268 |
2078502 | 2078502 | 2022-01-03 | Saratoga | New York | 36091 | 32202 | 268 |
2075251 | 2075251 | 2022-01-02 | Saratoga | New York | 36091 | 31796 | 267 |
2072000 | 2072000 | 2022-01-01 | Saratoga | New York | 36091 | 31400 | 267 |
2068749 | 2068749 | 2021-12-31 | Saratoga | New York | 36091 | 30952 | 267 |
2065498 | 2065498 | 2021-12-30 | Saratoga | New York | 36091 | 30360 | 267 |
2062248 | 2062248 | 2021-12-29 | Saratoga | New York | 36091 | 29973 | 266 |
2058999 | 2058999 | 2021-12-28 | Saratoga | New York | 36091 | 29483 | 265 |
2055750 | 2055750 | 2021-12-27 | Saratoga | New York | 36091 | 29357 | 263 |
2052500 | 2052500 | 2021-12-26 | Saratoga | New York | 36091 | 29297 | 260 |
2049250 | 2049250 | 2021-12-25 | Saratoga | New York | 36091 | 28897 | 259 |
2046000 | 2046000 | 2021-12-24 | Saratoga | New York | 36091 | 28897 | 259 |
2042750 | 2042750 | 2021-12-23 | Saratoga | New York | 36091 | 28679 | 259 |
2039501 | 2039501 | 2021-12-22 | Saratoga | New York | 36091 | 28394 | 259 |
2036251 | 2036251 | 2021-12-21 | Saratoga | New York | 36091 | 28188 | 259 |
2033001 | 2033001 | 2021-12-20 | Saratoga | New York | 36091 | 28047 | 258 |
2029751 | 2029751 | 2021-12-19 | Saratoga | New York | 36091 | 27915 | 258 |
2026500 | 2026500 | 2021-12-18 | Saratoga | New York | 36091 | 27776 | 257 |
2023249 | 2023249 | 2021-12-17 | Saratoga | New York | 36091 | 27568 | 253 |
2019998 | 2019998 | 2021-12-16 | Saratoga | New York | 36091 | 27399 | 251 |
2016747 | 2016747 | 2021-12-15 | Saratoga | New York | 36091 | 27214 | 249 |
2013497 | 2013497 | 2021-12-14 | Saratoga | New York | 36091 | 27053 | 248 |
2010246 | 2010246 | 2021-12-13 | Saratoga | New York | 36091 | 26955 | 246 |
2006995 | 2006995 | 2021-12-12 | Saratoga | New York | 36091 | 26876 | 244 |
2003744 | 2003744 | 2021-12-11 | Saratoga | New York | 36091 | 26713 | 243 |
2000493 | 2000493 | 2021-12-10 | Saratoga | New York | 36091 | 26517 | 240 |
1997243 | 1997243 | 2021-12-09 | Saratoga | New York | 36091 | 26350 | 239 |
1993992 | 1993992 | 2021-12-08 | Saratoga | New York | 36091 | 26181 | 236 |
1990741 | 1990741 | 2021-12-07 | Saratoga | New York | 36091 | 26027 | 234 |
1987490 | 1987490 | 2021-12-06 | Saratoga | New York | 36091 | 25874 | 231 |
1984240 | 1984240 | 2021-12-05 | Saratoga | New York | 36091 | 25756 | 229 |
1980990 | 1980990 | 2021-12-04 | Saratoga | New York | 36091 | 25582 | 228 |
1977740 | 1977740 | 2021-12-03 | Saratoga | New York | 36091 | 25383 | 228 |
1974490 | 1974490 | 2021-12-02 | Saratoga | New York | 36091 | 25167 | 228 |
1971241 | 1971241 | 2021-12-01 | Saratoga | New York | 36091 | 24878 | 227 |
1967991 | 1967991 | 2021-11-30 | Saratoga | New York | 36091 | 24658 | 225 |
1964740 | 1964740 | 2021-11-29 | Saratoga | New York | 36091 | 24504 | 225 |
1961488 | 1961488 | 2021-11-28 | Saratoga | New York | 36091 | 24400 | 224 |
1958237 | 1958237 | 2021-11-27 | Saratoga | New York | 36091 | 24261 | 223 |
1954986 | 1954986 | 2021-11-26 | Saratoga | New York | 36091 | 24180 | 222 |
1951735 | 1951735 | 2021-11-25 | Saratoga | New York | 36091 | 24009 | 222 |
1948484 | 1948484 | 2021-11-24 | Saratoga | New York | 36091 | 23823 | 220 |
1945233 | 1945233 | 2021-11-23 | Saratoga | New York | 36091 | 23660 | 220 |
1941982 | 1941982 | 2021-11-22 | Saratoga | New York | 36091 | 23523 | 220 |
1938732 | 1938732 | 2021-11-21 | Saratoga | New York | 36091 | 23402 | 220 |
1935482 | 1935482 | 2021-11-20 | Saratoga | New York | 36091 | 23236 | 218 |
1932232 | 1932232 | 2021-11-19 | Saratoga | New York | 36091 | 23037 | 218 |
1928981 | 1928981 | 2021-11-18 | Saratoga | New York | 36091 | 22854 | 218 |
1925731 | 1925731 | 2021-11-17 | Saratoga | New York | 36091 | 22666 | 218 |
1922482 | 1922482 | 2021-11-16 | Saratoga | New York | 36091 | 22544 | 217 |
1919232 | 1919232 | 2021-11-15 | Saratoga | New York | 36091 | 22448 | 216 |
1915982 | 1915982 | 2021-11-14 | Saratoga | New York | 36091 | 22365 | 215 |
1912732 | 1912732 | 2021-11-13 | Saratoga | New York | 36091 | 22244 | 214 |
1909482 | 1909482 | 2021-11-12 | Saratoga | New York | 36091 | 22093 | 214 |
1906233 | 1906233 | 2021-11-11 | Saratoga | New York | 36091 | 21960 | 213 |
1902984 | 1902984 | 2021-11-10 | Saratoga | New York | 36091 | 21785 | 212 |
1899734 | 1899734 | 2021-11-09 | Saratoga | New York | 36091 | 21697 | 212 |
1896484 | 1896484 | 2021-11-08 | Saratoga | New York | 36091 | 21624 | 212 |
1893234 | 1893234 | 2021-11-07 | Saratoga | New York | 36091 | 21555 | 211 |
1889984 | 1889984 | 2021-11-06 | Saratoga | New York | 36091 | 21455 | 211 |
1886734 | 1886734 | 2021-11-05 | Saratoga | New York | 36091 | 21366 | 210 |
1883485 | 1883485 | 2021-11-04 | Saratoga | New York | 36091 | 21282 | 210 |
1880236 | 1880236 | 2021-11-03 | Saratoga | New York | 36091 | 21190 | 209 |
1876987 | 1876987 | 2021-11-02 | Saratoga | New York | 36091 | 21108 | 208 |
1873738 | 1873738 | 2021-11-01 | Saratoga | New York | 36091 | 21055 | 208 |
1870489 | 1870489 | 2021-10-31 | Saratoga | New York | 36091 | 21003 | 208 |
1867240 | 1867240 | 2021-10-30 | Saratoga | New York | 36091 | 20934 | 208 |
1863991 | 1863991 | 2021-10-29 | Saratoga | New York | 36091 | 20842 | 208 |
1860742 | 1860742 | 2021-10-28 | Saratoga | New York | 36091 | 20720 | 207 |
1857493 | 1857493 | 2021-10-27 | Saratoga | New York | 36091 | 20661 | 206 |
1854244 | 1854244 | 2021-10-26 | Saratoga | New York | 36091 | 20582 | 205 |
1850995 | 1850995 | 2021-10-25 | Saratoga | New York | 36091 | 20545 | 205 |
1847745 | 1847745 | 2021-10-24 | Saratoga | New York | 36091 | 20485 | 204 |
1844495 | 1844495 | 2021-10-23 | Saratoga | New York | 36091 | 20424 | 202 |
1841245 | 1841245 | 2021-10-22 | Saratoga | New York | 36091 | 20342 | 201 |
1837996 | 1837996 | 2021-10-21 | Saratoga | New York | 36091 | 20287 | 200 |
1834747 | 1834747 | 2021-10-20 | Saratoga | New York | 36091 | 20195 | 199 |
1831498 | 1831498 | 2021-10-19 | Saratoga | New York | 36091 | 20111 | 198 |
1828249 | 1828249 | 2021-10-18 | Saratoga | New York | 36091 | 20080 | 198 |
1825000 | 1825000 | 2021-10-17 | Saratoga | New York | 36091 | 20034 | 197 |
1821751 | 1821751 | 2021-10-16 | Saratoga | New York | 36091 | 19975 | 197 |
1818502 | 1818502 | 2021-10-15 | Saratoga | New York | 36091 | 19884 | 197 |
1815253 | 1815253 | 2021-10-14 | Saratoga | New York | 36091 | 19803 | 196 |
1812005 | 1812005 | 2021-10-13 | Saratoga | New York | 36091 | 19728 | 196 |
1808756 | 1808756 | 2021-10-12 | Saratoga | New York | 36091 | 19655 | 195 |
1805505 | 1805505 | 2021-10-11 | Saratoga | New York | 36091 | 19616 | 195 |
1802256 | 1802256 | 2021-10-10 | Saratoga | New York | 36091 | 19549 | 194 |
1799007 | 1799007 | 2021-10-09 | Saratoga | New York | 36091 | 19498 | 194 |
1795758 | 1795758 | 2021-10-08 | Saratoga | New York | 36091 | 19440 | 193 |
1792509 | 1792509 | 2021-10-07 | Saratoga | New York | 36091 | 19360 | 193 |
1789260 | 1789260 | 2021-10-06 | Saratoga | New York | 36091 | 19289 | 193 |
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);