ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Dutchess" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- …
state 1
- New York · 693 ✖
fips 1
- 36027 693
county 1
- Dutchess · 693 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176056 | 2176056 | 2022-02-02 | Dutchess | New York | 36027 | 61839 | 615 |
2172803 | 2172803 | 2022-02-01 | Dutchess | New York | 36027 | 61735 | 611 |
2169550 | 2169550 | 2022-01-31 | Dutchess | New York | 36027 | 61646 | 606 |
2166295 | 2166295 | 2022-01-30 | Dutchess | New York | 36027 | 61525 | 605 |
2163040 | 2163040 | 2022-01-29 | Dutchess | New York | 36027 | 61390 | 603 |
2159785 | 2159785 | 2022-01-28 | Dutchess | New York | 36027 | 61200 | 603 |
2156530 | 2156530 | 2022-01-27 | Dutchess | New York | 36027 | 61028 | 598 |
2153277 | 2153277 | 2022-01-26 | Dutchess | New York | 36027 | 60725 | 597 |
2150025 | 2150025 | 2022-01-25 | Dutchess | New York | 36027 | 60535 | 594 |
2146773 | 2146773 | 2022-01-24 | Dutchess | New York | 36027 | 60300 | 590 |
2143519 | 2143519 | 2022-01-23 | Dutchess | New York | 36027 | 60085 | 587 |
2140264 | 2140264 | 2022-01-22 | Dutchess | New York | 36027 | 59798 | 587 |
2137008 | 2137008 | 2022-01-21 | Dutchess | New York | 36027 | 59464 | 585 |
2133755 | 2133755 | 2022-01-20 | Dutchess | New York | 36027 | 59146 | 581 |
2130503 | 2130503 | 2022-01-19 | Dutchess | New York | 36027 | 58736 | 579 |
2127249 | 2127249 | 2022-01-18 | Dutchess | New York | 36027 | 58418 | 570 |
2123997 | 2123997 | 2022-01-17 | Dutchess | New York | 36027 | 58133 | 568 |
2120745 | 2120745 | 2022-01-16 | Dutchess | New York | 36027 | 57818 | 567 |
2117493 | 2117493 | 2022-01-15 | Dutchess | New York | 36027 | 57058 | 565 |
2114242 | 2114242 | 2022-01-14 | Dutchess | New York | 36027 | 56421 | 558 |
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 |
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);