ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 36001 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 |
---|---|---|---|---|---|---|---|
2110978 | 2110978 | 2022-01-13 | Albany | New York | 36001 | 49387 | 452 |
2107726 | 2107726 | 2022-01-12 | Albany | New York | 36001 | 48640 | 450 |
2104475 | 2104475 | 2022-01-11 | Albany | New York | 36001 | 48065 | 449 |
2101224 | 2101224 | 2022-01-10 | Albany | New York | 36001 | 47555 | 448 |
2097973 | 2097973 | 2022-01-09 | Albany | New York | 36001 | 46933 | 447 |
2094721 | 2094721 | 2022-01-08 | Albany | New York | 36001 | 46262 | 447 |
2091469 | 2091469 | 2022-01-07 | Albany | New York | 36001 | 45231 | 446 |
2088218 | 2088218 | 2022-01-06 | Albany | New York | 36001 | 44357 | 444 |
2084966 | 2084966 | 2022-01-05 | Albany | New York | 36001 | 43499 | 443 |
2081714 | 2081714 | 2022-01-04 | Albany | New York | 36001 | 42841 | 442 |
2078462 | 2078462 | 2022-01-03 | Albany | New York | 36001 | 42607 | 441 |
2075211 | 2075211 | 2022-01-02 | Albany | New York | 36001 | 42229 | 439 |
2071960 | 2071960 | 2022-01-01 | Albany | New York | 36001 | 41708 | 439 |
2068709 | 2068709 | 2021-12-31 | Albany | New York | 36001 | 41133 | 439 |
2065458 | 2065458 | 2021-12-30 | Albany | New York | 36001 | 40432 | 439 |
2062208 | 2062208 | 2021-12-29 | Albany | New York | 36001 | 39936 | 439 |
2058959 | 2058959 | 2021-12-28 | Albany | New York | 36001 | 39492 | 438 |
2055710 | 2055710 | 2021-12-27 | Albany | New York | 36001 | 39276 | 438 |
2052460 | 2052460 | 2021-12-26 | Albany | New York | 36001 | 39158 | 438 |
2049210 | 2049210 | 2021-12-25 | Albany | New York | 36001 | 38669 | 437 |
2045960 | 2045960 | 2021-12-24 | Albany | New York | 36001 | 38669 | 437 |
2042710 | 2042710 | 2021-12-23 | Albany | New York | 36001 | 38391 | 435 |
2039461 | 2039461 | 2021-12-22 | Albany | New York | 36001 | 38114 | 434 |
2036211 | 2036211 | 2021-12-21 | Albany | New York | 36001 | 37882 | 433 |
2032961 | 2032961 | 2021-12-20 | Albany | New York | 36001 | 37701 | 431 |
2029711 | 2029711 | 2021-12-19 | Albany | New York | 36001 | 37566 | 428 |
2026460 | 2026460 | 2021-12-18 | Albany | New York | 36001 | 37379 | 427 |
2023209 | 2023209 | 2021-12-17 | Albany | New York | 36001 | 37161 | 425 |
2019958 | 2019958 | 2021-12-16 | Albany | New York | 36001 | 36959 | 423 |
2016707 | 2016707 | 2021-12-15 | Albany | New York | 36001 | 36773 | 423 |
2013457 | 2013457 | 2021-12-14 | Albany | New York | 36001 | 36612 | 423 |
2010206 | 2010206 | 2021-12-13 | Albany | New York | 36001 | 36489 | 423 |
2006955 | 2006955 | 2021-12-12 | Albany | New York | 36001 | 36401 | 423 |
2003704 | 2003704 | 2021-12-11 | Albany | New York | 36001 | 36288 | 422 |
2000453 | 2000453 | 2021-12-10 | Albany | New York | 36001 | 36117 | 422 |
1997203 | 1997203 | 2021-12-09 | Albany | New York | 36001 | 35905 | 422 |
1993952 | 1993952 | 2021-12-08 | Albany | New York | 36001 | 35729 | 421 |
1990701 | 1990701 | 2021-12-07 | Albany | New York | 36001 | 35586 | 421 |
1987450 | 1987450 | 2021-12-06 | Albany | New York | 36001 | 35437 | 421 |
1984200 | 1984200 | 2021-12-05 | Albany | New York | 36001 | 35325 | 420 |
1980950 | 1980950 | 2021-12-04 | Albany | New York | 36001 | 35159 | 419 |
1977700 | 1977700 | 2021-12-03 | Albany | New York | 36001 | 34983 | 417 |
1974450 | 1974450 | 2021-12-02 | Albany | New York | 36001 | 34764 | 416 |
1971201 | 1971201 | 2021-12-01 | Albany | New York | 36001 | 34583 | 414 |
1967951 | 1967951 | 2021-11-30 | Albany | New York | 36001 | 34399 | 413 |
1964700 | 1964700 | 2021-11-29 | Albany | New York | 36001 | 34293 | 412 |
1961448 | 1961448 | 2021-11-28 | Albany | New York | 36001 | 34221 | 411 |
1958197 | 1958197 | 2021-11-27 | Albany | New York | 36001 | 34116 | 411 |
1954946 | 1954946 | 2021-11-26 | Albany | New York | 36001 | 34056 | 409 |
1951695 | 1951695 | 2021-11-25 | Albany | New York | 36001 | 33929 | 409 |
1948444 | 1948444 | 2021-11-24 | Albany | New York | 36001 | 33776 | 408 |
1945193 | 1945193 | 2021-11-23 | Albany | New York | 36001 | 33672 | 407 |
1941942 | 1941942 | 2021-11-22 | Albany | New York | 36001 | 33612 | 407 |
1938692 | 1938692 | 2021-11-21 | Albany | New York | 36001 | 33536 | 406 |
1935442 | 1935442 | 2021-11-20 | Albany | New York | 36001 | 33432 | 406 |
1932192 | 1932192 | 2021-11-19 | Albany | New York | 36001 | 33316 | 405 |
1928941 | 1928941 | 2021-11-18 | Albany | New York | 36001 | 33202 | 404 |
1925691 | 1925691 | 2021-11-17 | Albany | New York | 36001 | 33023 | 404 |
1922442 | 1922442 | 2021-11-16 | Albany | New York | 36001 | 32929 | 404 |
1919192 | 1919192 | 2021-11-15 | Albany | New York | 36001 | 32874 | 403 |
1915942 | 1915942 | 2021-11-14 | Albany | New York | 36001 | 32814 | 402 |
1912692 | 1912692 | 2021-11-13 | Albany | New York | 36001 | 32720 | 402 |
1909442 | 1909442 | 2021-11-12 | Albany | New York | 36001 | 32606 | 402 |
1906193 | 1906193 | 2021-11-11 | Albany | New York | 36001 | 32516 | 402 |
1902944 | 1902944 | 2021-11-10 | Albany | New York | 36001 | 32391 | 399 |
1899694 | 1899694 | 2021-11-09 | Albany | New York | 36001 | 32292 | 398 |
1896444 | 1896444 | 2021-11-08 | Albany | New York | 36001 | 32205 | 398 |
1893194 | 1893194 | 2021-11-07 | Albany | New York | 36001 | 32146 | 398 |
1889944 | 1889944 | 2021-11-06 | Albany | New York | 36001 | 32078 | 396 |
1886694 | 1886694 | 2021-11-05 | Albany | New York | 36001 | 31992 | 396 |
1883445 | 1883445 | 2021-11-04 | Albany | New York | 36001 | 31915 | 396 |
1880196 | 1880196 | 2021-11-03 | Albany | New York | 36001 | 31821 | 396 |
1876947 | 1876947 | 2021-11-02 | Albany | New York | 36001 | 31750 | 394 |
1873698 | 1873698 | 2021-11-01 | Albany | New York | 36001 | 31696 | 394 |
1870449 | 1870449 | 2021-10-31 | Albany | New York | 36001 | 31649 | 393 |
1867200 | 1867200 | 2021-10-30 | Albany | New York | 36001 | 31574 | 393 |
1863951 | 1863951 | 2021-10-29 | Albany | New York | 36001 | 31485 | 392 |
1860702 | 1860702 | 2021-10-28 | Albany | New York | 36001 | 31373 | 392 |
1857453 | 1857453 | 2021-10-27 | Albany | New York | 36001 | 31274 | 392 |
1854204 | 1854204 | 2021-10-26 | Albany | New York | 36001 | 31174 | 392 |
1850955 | 1850955 | 2021-10-25 | Albany | New York | 36001 | 31130 | 390 |
1847705 | 1847705 | 2021-10-24 | Albany | New York | 36001 | 31074 | 390 |
1844455 | 1844455 | 2021-10-23 | Albany | New York | 36001 | 31020 | 390 |
1841205 | 1841205 | 2021-10-22 | Albany | New York | 36001 | 30915 | 390 |
1837956 | 1837956 | 2021-10-21 | Albany | New York | 36001 | 30838 | 390 |
1834707 | 1834707 | 2021-10-20 | Albany | New York | 36001 | 30760 | 389 |
1831458 | 1831458 | 2021-10-19 | Albany | New York | 36001 | 30633 | 388 |
1828209 | 1828209 | 2021-10-18 | Albany | New York | 36001 | 30581 | 388 |
1824960 | 1824960 | 2021-10-17 | Albany | New York | 36001 | 30510 | 386 |
1821711 | 1821711 | 2021-10-16 | Albany | New York | 36001 | 30443 | 385 |
1818462 | 1818462 | 2021-10-15 | Albany | New York | 36001 | 30319 | 383 |
1815213 | 1815213 | 2021-10-14 | Albany | New York | 36001 | 30214 | 383 |
1811965 | 1811965 | 2021-10-13 | Albany | New York | 36001 | 30119 | 380 |
1808716 | 1808716 | 2021-10-12 | Albany | New York | 36001 | 30035 | 380 |
1805465 | 1805465 | 2021-10-11 | Albany | New York | 36001 | 29993 | 379 |
1802216 | 1802216 | 2021-10-10 | Albany | New York | 36001 | 29893 | 378 |
1798967 | 1798967 | 2021-10-09 | Albany | New York | 36001 | 29852 | 377 |
1795718 | 1795718 | 2021-10-08 | Albany | New York | 36001 | 29773 | 376 |
1792469 | 1792469 | 2021-10-07 | Albany | New York | 36001 | 29671 | 375 |
1789220 | 1789220 | 2021-10-06 | Albany | New York | 36001 | 29577 | 374 |
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);