ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Albany", 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 |
---|---|---|---|---|---|---|---|
2176044 | 2176044 | 2022-02-02 | Albany | New York | 36001 | 55897 | 484 |
2172791 | 2172791 | 2022-02-01 | Albany | New York | 36001 | 55698 | 481 |
2169538 | 2169538 | 2022-01-31 | Albany | New York | 36001 | 55606 | 481 |
2166283 | 2166283 | 2022-01-30 | Albany | New York | 36001 | 55524 | 481 |
2163028 | 2163028 | 2022-01-29 | Albany | New York | 36001 | 55361 | 480 |
2159773 | 2159773 | 2022-01-28 | Albany | New York | 36001 | 55128 | 479 |
2156518 | 2156518 | 2022-01-27 | Albany | New York | 36001 | 54921 | 477 |
2153265 | 2153265 | 2022-01-26 | Albany | New York | 36001 | 54668 | 477 |
2150013 | 2150013 | 2022-01-25 | Albany | New York | 36001 | 54406 | 475 |
2146761 | 2146761 | 2022-01-24 | Albany | New York | 36001 | 54213 | 475 |
2143507 | 2143507 | 2022-01-23 | Albany | New York | 36001 | 54048 | 473 |
2140252 | 2140252 | 2022-01-22 | Albany | New York | 36001 | 53772 | 473 |
2136996 | 2136996 | 2022-01-21 | Albany | New York | 36001 | 53355 | 472 |
2133743 | 2133743 | 2022-01-20 | Albany | New York | 36001 | 52918 | 469 |
2130491 | 2130491 | 2022-01-19 | Albany | New York | 36001 | 52444 | 467 |
2127237 | 2127237 | 2022-01-18 | Albany | New York | 36001 | 52146 | 465 |
2123985 | 2123985 | 2022-01-17 | Albany | New York | 36001 | 51823 | 463 |
2120733 | 2120733 | 2022-01-16 | Albany | New York | 36001 | 51497 | 459 |
2117481 | 2117481 | 2022-01-15 | Albany | New York | 36001 | 50940 | 456 |
2114230 | 2114230 | 2022-01-14 | Albany | New York | 36001 | 50210 | 456 |
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 |
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);