ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 36027 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 |
---|---|---|---|---|---|---|---|
2110990 | 2110990 | 2022-01-13 | Dutchess | New York | 36027 | 55713 | 556 |
2107738 | 2107738 | 2022-01-12 | Dutchess | New York | 36027 | 55009 | 556 |
2104487 | 2104487 | 2022-01-11 | Dutchess | New York | 36027 | 54355 | 553 |
2101236 | 2101236 | 2022-01-10 | Dutchess | New York | 36027 | 53846 | 552 |
2097985 | 2097985 | 2022-01-09 | Dutchess | New York | 36027 | 53157 | 547 |
2094733 | 2094733 | 2022-01-08 | Dutchess | New York | 36027 | 52215 | 547 |
2091481 | 2091481 | 2022-01-07 | Dutchess | New York | 36027 | 51105 | 544 |
2088230 | 2088230 | 2022-01-06 | Dutchess | New York | 36027 | 50003 | 543 |
2084978 | 2084978 | 2022-01-05 | Dutchess | New York | 36027 | 49214 | 543 |
2081726 | 2081726 | 2022-01-04 | Dutchess | New York | 36027 | 48429 | 541 |
2078474 | 2078474 | 2022-01-03 | Dutchess | New York | 36027 | 47719 | 538 |
2075223 | 2075223 | 2022-01-02 | Dutchess | New York | 36027 | 47166 | 537 |
2071972 | 2071972 | 2022-01-01 | Dutchess | New York | 36027 | 46464 | 536 |
2068721 | 2068721 | 2021-12-31 | Dutchess | New York | 36027 | 45626 | 535 |
2065470 | 2065470 | 2021-12-30 | Dutchess | New York | 36027 | 44904 | 534 |
2062220 | 2062220 | 2021-12-29 | Dutchess | New York | 36027 | 44235 | 533 |
2058971 | 2058971 | 2021-12-28 | Dutchess | New York | 36027 | 43436 | 531 |
2055722 | 2055722 | 2021-12-27 | Dutchess | New York | 36027 | 43158 | 531 |
2052472 | 2052472 | 2021-12-26 | Dutchess | New York | 36027 | 42998 | 528 |
2049222 | 2049222 | 2021-12-25 | Dutchess | New York | 36027 | 42431 | 528 |
2045972 | 2045972 | 2021-12-24 | Dutchess | New York | 36027 | 42431 | 528 |
2042722 | 2042722 | 2021-12-23 | Dutchess | New York | 36027 | 42039 | 527 |
2039473 | 2039473 | 2021-12-22 | Dutchess | New York | 36027 | 41668 | 527 |
2036223 | 2036223 | 2021-12-21 | Dutchess | New York | 36027 | 41375 | 527 |
2032973 | 2032973 | 2021-12-20 | Dutchess | New York | 36027 | 41216 | 526 |
2029723 | 2029723 | 2021-12-19 | Dutchess | New York | 36027 | 41055 | 523 |
2026472 | 2026472 | 2021-12-18 | Dutchess | New York | 36027 | 40839 | 523 |
2023221 | 2023221 | 2021-12-17 | Dutchess | New York | 36027 | 40565 | 523 |
2019970 | 2019970 | 2021-12-16 | Dutchess | New York | 36027 | 40340 | 523 |
2016719 | 2016719 | 2021-12-15 | Dutchess | New York | 36027 | 40109 | 523 |
2013469 | 2013469 | 2021-12-14 | Dutchess | New York | 36027 | 39956 | 521 |
2010218 | 2010218 | 2021-12-13 | Dutchess | New York | 36027 | 39843 | 520 |
2006967 | 2006967 | 2021-12-12 | Dutchess | New York | 36027 | 39719 | 519 |
2003716 | 2003716 | 2021-12-11 | Dutchess | New York | 36027 | 39561 | 518 |
2000465 | 2000465 | 2021-12-10 | Dutchess | New York | 36027 | 39381 | 516 |
1997215 | 1997215 | 2021-12-09 | Dutchess | New York | 36027 | 39239 | 515 |
1993964 | 1993964 | 2021-12-08 | Dutchess | New York | 36027 | 39072 | 515 |
1990713 | 1990713 | 2021-12-07 | Dutchess | New York | 36027 | 38898 | 514 |
1987462 | 1987462 | 2021-12-06 | Dutchess | New York | 36027 | 38792 | 513 |
1984212 | 1984212 | 2021-12-05 | Dutchess | New York | 36027 | 38686 | 513 |
1980962 | 1980962 | 2021-12-04 | Dutchess | New York | 36027 | 38515 | 513 |
1977712 | 1977712 | 2021-12-03 | Dutchess | New York | 36027 | 38356 | 513 |
1974462 | 1974462 | 2021-12-02 | Dutchess | New York | 36027 | 38218 | 513 |
1971213 | 1971213 | 2021-12-01 | Dutchess | New York | 36027 | 38083 | 510 |
1967963 | 1967963 | 2021-11-30 | Dutchess | New York | 36027 | 37964 | 510 |
1964712 | 1964712 | 2021-11-29 | Dutchess | New York | 36027 | 37875 | 510 |
1961460 | 1961460 | 2021-11-28 | Dutchess | New York | 36027 | 37798 | 508 |
1958209 | 1958209 | 2021-11-27 | Dutchess | New York | 36027 | 37733 | 508 |
1954958 | 1954958 | 2021-11-26 | Dutchess | New York | 36027 | 37697 | 507 |
1951707 | 1951707 | 2021-11-25 | Dutchess | New York | 36027 | 37627 | 507 |
1948456 | 1948456 | 2021-11-24 | Dutchess | New York | 36027 | 37547 | 506 |
1945205 | 1945205 | 2021-11-23 | Dutchess | New York | 36027 | 37487 | 506 |
1941954 | 1941954 | 2021-11-22 | Dutchess | New York | 36027 | 37434 | 506 |
1938704 | 1938704 | 2021-11-21 | Dutchess | New York | 36027 | 37367 | 506 |
1935454 | 1935454 | 2021-11-20 | Dutchess | New York | 36027 | 37287 | 505 |
1932204 | 1932204 | 2021-11-19 | Dutchess | New York | 36027 | 37201 | 505 |
1928953 | 1928953 | 2021-11-18 | Dutchess | New York | 36027 | 37100 | 505 |
1925703 | 1925703 | 2021-11-17 | Dutchess | New York | 36027 | 37007 | 505 |
1922454 | 1922454 | 2021-11-16 | Dutchess | New York | 36027 | 36943 | 505 |
1919204 | 1919204 | 2021-11-15 | Dutchess | New York | 36027 | 36889 | 505 |
1915954 | 1915954 | 2021-11-14 | Dutchess | New York | 36027 | 36840 | 505 |
1912704 | 1912704 | 2021-11-13 | Dutchess | New York | 36027 | 36782 | 505 |
1909454 | 1909454 | 2021-11-12 | Dutchess | New York | 36027 | 36702 | 505 |
1906205 | 1906205 | 2021-11-11 | Dutchess | New York | 36027 | 36613 | 505 |
1902956 | 1902956 | 2021-11-10 | Dutchess | New York | 36027 | 36536 | 505 |
1899706 | 1899706 | 2021-11-09 | Dutchess | New York | 36027 | 36492 | 505 |
1896456 | 1896456 | 2021-11-08 | Dutchess | New York | 36027 | 36432 | 505 |
1893206 | 1893206 | 2021-11-07 | Dutchess | New York | 36027 | 36401 | 505 |
1889956 | 1889956 | 2021-11-06 | Dutchess | New York | 36027 | 36352 | 503 |
1886706 | 1886706 | 2021-11-05 | Dutchess | New York | 36027 | 36285 | 502 |
1883457 | 1883457 | 2021-11-04 | Dutchess | New York | 36027 | 36221 | 502 |
1880208 | 1880208 | 2021-11-03 | Dutchess | New York | 36027 | 36170 | 501 |
1876959 | 1876959 | 2021-11-02 | Dutchess | New York | 36027 | 36128 | 501 |
1873710 | 1873710 | 2021-11-01 | Dutchess | New York | 36027 | 36082 | 500 |
1870461 | 1870461 | 2021-10-31 | Dutchess | New York | 36027 | 36057 | 500 |
1867212 | 1867212 | 2021-10-30 | Dutchess | New York | 36027 | 36019 | 500 |
1863963 | 1863963 | 2021-10-29 | Dutchess | New York | 36027 | 35983 | 500 |
1860714 | 1860714 | 2021-10-28 | Dutchess | New York | 36027 | 35929 | 500 |
1857465 | 1857465 | 2021-10-27 | Dutchess | New York | 36027 | 35864 | 500 |
1854216 | 1854216 | 2021-10-26 | Dutchess | New York | 36027 | 35834 | 500 |
1850967 | 1850967 | 2021-10-25 | Dutchess | New York | 36027 | 35811 | 500 |
1847717 | 1847717 | 2021-10-24 | Dutchess | New York | 36027 | 35776 | 500 |
1844467 | 1844467 | 2021-10-23 | Dutchess | New York | 36027 | 35740 | 499 |
1841217 | 1841217 | 2021-10-22 | Dutchess | New York | 36027 | 35671 | 499 |
1837968 | 1837968 | 2021-10-21 | Dutchess | New York | 36027 | 35615 | 499 |
1834719 | 1834719 | 2021-10-20 | Dutchess | New York | 36027 | 35563 | 497 |
1831470 | 1831470 | 2021-10-19 | Dutchess | New York | 36027 | 35490 | 497 |
1828221 | 1828221 | 2021-10-18 | Dutchess | New York | 36027 | 35451 | 497 |
1824972 | 1824972 | 2021-10-17 | Dutchess | New York | 36027 | 35411 | 497 |
1821723 | 1821723 | 2021-10-16 | Dutchess | New York | 36027 | 35358 | 497 |
1818474 | 1818474 | 2021-10-15 | Dutchess | New York | 36027 | 35306 | 497 |
1815225 | 1815225 | 2021-10-14 | Dutchess | New York | 36027 | 35245 | 496 |
1811977 | 1811977 | 2021-10-13 | Dutchess | New York | 36027 | 35177 | 496 |
1808728 | 1808728 | 2021-10-12 | Dutchess | New York | 36027 | 35094 | 496 |
1805477 | 1805477 | 2021-10-11 | Dutchess | New York | 36027 | 35033 | 496 |
1802228 | 1802228 | 2021-10-10 | Dutchess | New York | 36027 | 34946 | 495 |
1798979 | 1798979 | 2021-10-09 | Dutchess | New York | 36027 | 34935 | 495 |
1795730 | 1795730 | 2021-10-08 | Dutchess | New York | 36027 | 34859 | 495 |
1792481 | 1792481 | 2021-10-07 | Dutchess | New York | 36027 | 34772 | 493 |
1789232 | 1789232 | 2021-10-06 | Dutchess | New York | 36027 | 34681 | 493 |
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);