ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 36007 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 |
---|---|---|---|---|---|---|---|
1948446 | 1948446 | 2021-11-24 | Broome | New York | 36007 | 27729 | 431 |
1945195 | 1945195 | 2021-11-23 | Broome | New York | 36007 | 27611 | 431 |
1941944 | 1941944 | 2021-11-22 | Broome | New York | 36007 | 27542 | 430 |
1938694 | 1938694 | 2021-11-21 | Broome | New York | 36007 | 27463 | 430 |
1935444 | 1935444 | 2021-11-20 | Broome | New York | 36007 | 27338 | 430 |
1932194 | 1932194 | 2021-11-19 | Broome | New York | 36007 | 27208 | 429 |
1928943 | 1928943 | 2021-11-18 | Broome | New York | 36007 | 27059 | 425 |
1925693 | 1925693 | 2021-11-17 | Broome | New York | 36007 | 26933 | 425 |
1922444 | 1922444 | 2021-11-16 | Broome | New York | 36007 | 26804 | 424 |
1919194 | 1919194 | 2021-11-15 | Broome | New York | 36007 | 26738 | 423 |
1915944 | 1915944 | 2021-11-14 | Broome | New York | 36007 | 26654 | 423 |
1912694 | 1912694 | 2021-11-13 | Broome | New York | 36007 | 26521 | 423 |
1909444 | 1909444 | 2021-11-12 | Broome | New York | 36007 | 26395 | 423 |
1906195 | 1906195 | 2021-11-11 | Broome | New York | 36007 | 26298 | 422 |
1902946 | 1902946 | 2021-11-10 | Broome | New York | 36007 | 26168 | 421 |
1899696 | 1899696 | 2021-11-09 | Broome | New York | 36007 | 26048 | 420 |
1896446 | 1896446 | 2021-11-08 | Broome | New York | 36007 | 25968 | 419 |
1893196 | 1893196 | 2021-11-07 | Broome | New York | 36007 | 25900 | 419 |
1889946 | 1889946 | 2021-11-06 | Broome | New York | 36007 | 25802 | 417 |
1886696 | 1886696 | 2021-11-05 | Broome | New York | 36007 | 25720 | 416 |
1883447 | 1883447 | 2021-11-04 | Broome | New York | 36007 | 25599 | 414 |
1880198 | 1880198 | 2021-11-03 | Broome | New York | 36007 | 25514 | 413 |
1876949 | 1876949 | 2021-11-02 | Broome | New York | 36007 | 25416 | 412 |
1873700 | 1873700 | 2021-11-01 | Broome | New York | 36007 | 25381 | 412 |
1870451 | 1870451 | 2021-10-31 | Broome | New York | 36007 | 25320 | 412 |
1867202 | 1867202 | 2021-10-30 | Broome | New York | 36007 | 25238 | 410 |
1863953 | 1863953 | 2021-10-29 | Broome | New York | 36007 | 25166 | 410 |
1860704 | 1860704 | 2021-10-28 | Broome | New York | 36007 | 25058 | 409 |
1857455 | 1857455 | 2021-10-27 | Broome | New York | 36007 | 24931 | 409 |
1854206 | 1854206 | 2021-10-26 | Broome | New York | 36007 | 24862 | 409 |
1850957 | 1850957 | 2021-10-25 | Broome | New York | 36007 | 24801 | 409 |
1847707 | 1847707 | 2021-10-24 | Broome | New York | 36007 | 24729 | 409 |
1844457 | 1844457 | 2021-10-23 | Broome | New York | 36007 | 24657 | 408 |
1841207 | 1841207 | 2021-10-22 | Broome | New York | 36007 | 24552 | 407 |
1837958 | 1837958 | 2021-10-21 | Broome | New York | 36007 | 24451 | 405 |
1834709 | 1834709 | 2021-10-20 | Broome | New York | 36007 | 24353 | 405 |
1831460 | 1831460 | 2021-10-19 | Broome | New York | 36007 | 24233 | 404 |
1828211 | 1828211 | 2021-10-18 | Broome | New York | 36007 | 24183 | 403 |
1824962 | 1824962 | 2021-10-17 | Broome | New York | 36007 | 24121 | 403 |
1821713 | 1821713 | 2021-10-16 | Broome | New York | 36007 | 24026 | 401 |
1818464 | 1818464 | 2021-10-15 | Broome | New York | 36007 | 23903 | 401 |
1815215 | 1815215 | 2021-10-14 | Broome | New York | 36007 | 23788 | 400 |
1811967 | 1811967 | 2021-10-13 | Broome | New York | 36007 | 23669 | 399 |
1808718 | 1808718 | 2021-10-12 | Broome | New York | 36007 | 23543 | 399 |
1805467 | 1805467 | 2021-10-11 | Broome | New York | 36007 | 23472 | 398 |
1802218 | 1802218 | 2021-10-10 | Broome | New York | 36007 | 23372 | 397 |
1798969 | 1798969 | 2021-10-09 | Broome | New York | 36007 | 23334 | 396 |
1795720 | 1795720 | 2021-10-08 | Broome | New York | 36007 | 23213 | 396 |
1792471 | 1792471 | 2021-10-07 | Broome | New York | 36007 | 23108 | 395 |
1789222 | 1789222 | 2021-10-06 | Broome | New York | 36007 | 22994 | 395 |
1785974 | 1785974 | 2021-10-05 | Broome | New York | 36007 | 22900 | 394 |
1782725 | 1782725 | 2021-10-04 | Broome | New York | 36007 | 22847 | 394 |
1779476 | 1779476 | 2021-10-03 | Broome | New York | 36007 | 22780 | 394 |
1776226 | 1776226 | 2021-10-02 | Broome | New York | 36007 | 22702 | 394 |
1772976 | 1772976 | 2021-10-01 | Broome | New York | 36007 | 22611 | 392 |
1769726 | 1769726 | 2021-09-30 | Broome | New York | 36007 | 22517 | 391 |
1766477 | 1766477 | 2021-09-29 | Broome | New York | 36007 | 22436 | 388 |
1763228 | 1763228 | 2021-09-28 | Broome | New York | 36007 | 22335 | 388 |
1759979 | 1759979 | 2021-09-27 | Broome | New York | 36007 | 22263 | 388 |
1756731 | 1756731 | 2021-09-26 | Broome | New York | 36007 | 22200 | 387 |
1753483 | 1753483 | 2021-09-25 | Broome | New York | 36007 | 22102 | 386 |
1750235 | 1750235 | 2021-09-24 | Broome | New York | 36007 | 21988 | 385 |
1746985 | 1746985 | 2021-09-23 | Broome | New York | 36007 | 21898 | 385 |
1743736 | 1743736 | 2021-09-22 | Broome | New York | 36007 | 21773 | 385 |
1740487 | 1740487 | 2021-09-21 | Broome | New York | 36007 | 21664 | 385 |
1737238 | 1737238 | 2021-09-20 | Broome | New York | 36007 | 21606 | 385 |
1733988 | 1733988 | 2021-09-19 | Broome | New York | 36007 | 21557 | 384 |
1730738 | 1730738 | 2021-09-18 | Broome | New York | 36007 | 21486 | 382 |
1727488 | 1727488 | 2021-09-17 | Broome | New York | 36007 | 21369 | 381 |
1724239 | 1724239 | 2021-09-16 | Broome | New York | 36007 | 21269 | 380 |
1720990 | 1720990 | 2021-09-15 | Broome | New York | 36007 | 21178 | 379 |
1717742 | 1717742 | 2021-09-14 | Broome | New York | 36007 | 21081 | 379 |
1714494 | 1714494 | 2021-09-13 | Broome | New York | 36007 | 21020 | 379 |
1711248 | 1711248 | 2021-09-12 | Broome | New York | 36007 | 20961 | 377 |
1708001 | 1708001 | 2021-09-11 | Broome | New York | 36007 | 20883 | 376 |
1704754 | 1704754 | 2021-09-10 | Broome | New York | 36007 | 20808 | 376 |
1701504 | 1701504 | 2021-09-09 | Broome | New York | 36007 | 20702 | 375 |
1698255 | 1698255 | 2021-09-08 | Broome | New York | 36007 | 20618 | 374 |
1695007 | 1695007 | 2021-09-07 | Broome | New York | 36007 | 20560 | 374 |
1691759 | 1691759 | 2021-09-06 | Broome | New York | 36007 | 20525 | 373 |
1688509 | 1688509 | 2021-09-05 | Broome | New York | 36007 | 20471 | 373 |
1685259 | 1685259 | 2021-09-04 | Broome | New York | 36007 | 20406 | 373 |
1682008 | 1682008 | 2021-09-03 | Broome | New York | 36007 | 20312 | 372 |
1678759 | 1678759 | 2021-09-02 | Broome | New York | 36007 | 20201 | 372 |
1675511 | 1675511 | 2021-09-01 | Broome | New York | 36007 | 20109 | 371 |
1672264 | 1672264 | 2021-08-31 | Broome | New York | 36007 | 20041 | 371 |
1669016 | 1669016 | 2021-08-30 | Broome | New York | 36007 | 19991 | 371 |
1665769 | 1665769 | 2021-08-29 | Broome | New York | 36007 | 19937 | 371 |
1662521 | 1662521 | 2021-08-28 | Broome | New York | 36007 | 19881 | 371 |
1659273 | 1659273 | 2021-08-27 | Broome | New York | 36007 | 19809 | 371 |
1656024 | 1656024 | 2021-08-26 | Broome | New York | 36007 | 19726 | 370 |
1652777 | 1652777 | 2021-08-25 | Broome | New York | 36007 | 19667 | 370 |
1649529 | 1649529 | 2021-08-24 | Broome | New York | 36007 | 19597 | 370 |
1646280 | 1646280 | 2021-08-23 | Broome | New York | 36007 | 19560 | 370 |
1643031 | 1643031 | 2021-08-22 | Broome | New York | 36007 | 19523 | 370 |
1639781 | 1639781 | 2021-08-21 | Broome | New York | 36007 | 19480 | 369 |
1636531 | 1636531 | 2021-08-20 | Broome | New York | 36007 | 19437 | 369 |
1633281 | 1633281 | 2021-08-19 | Broome | New York | 36007 | 19414 | 369 |
1630034 | 1630034 | 2021-08-18 | Broome | New York | 36007 | 19365 | 369 |
1626787 | 1626787 | 2021-08-17 | Broome | New York | 36007 | 19322 | 369 |
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);