ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Broome" 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 |
---|---|---|---|---|---|---|---|
2110980 | 2110980 | 2022-01-13 | Broome | New York | 36007 | 38583 | 479 |
2107728 | 2107728 | 2022-01-12 | Broome | New York | 36007 | 38090 | 477 |
2104477 | 2104477 | 2022-01-11 | Broome | New York | 36007 | 37726 | 477 |
2101226 | 2101226 | 2022-01-10 | Broome | New York | 36007 | 37444 | 477 |
2097975 | 2097975 | 2022-01-09 | Broome | New York | 36007 | 37225 | 476 |
2094723 | 2094723 | 2022-01-08 | Broome | New York | 36007 | 36704 | 475 |
2091471 | 2091471 | 2022-01-07 | Broome | New York | 36007 | 36196 | 473 |
2088220 | 2088220 | 2022-01-06 | Broome | New York | 36007 | 35619 | 472 |
2084968 | 2084968 | 2022-01-05 | Broome | New York | 36007 | 35100 | 471 |
2081716 | 2081716 | 2022-01-04 | Broome | New York | 36007 | 34773 | 470 |
2078464 | 2078464 | 2022-01-03 | Broome | New York | 36007 | 34536 | 469 |
2075213 | 2075213 | 2022-01-02 | Broome | New York | 36007 | 34296 | 467 |
2071962 | 2071962 | 2022-01-01 | Broome | New York | 36007 | 33926 | 466 |
2068711 | 2068711 | 2021-12-31 | Broome | New York | 36007 | 33512 | 463 |
2065460 | 2065460 | 2021-12-30 | Broome | New York | 36007 | 33130 | 462 |
2062210 | 2062210 | 2021-12-29 | Broome | New York | 36007 | 32837 | 461 |
2058961 | 2058961 | 2021-12-28 | Broome | New York | 36007 | 32524 | 459 |
2055712 | 2055712 | 2021-12-27 | Broome | New York | 36007 | 32396 | 459 |
2052462 | 2052462 | 2021-12-26 | Broome | New York | 36007 | 32356 | 459 |
2049212 | 2049212 | 2021-12-25 | Broome | New York | 36007 | 31990 | 457 |
2045962 | 2045962 | 2021-12-24 | Broome | New York | 36007 | 31990 | 457 |
2042712 | 2042712 | 2021-12-23 | Broome | New York | 36007 | 31836 | 456 |
2039463 | 2039463 | 2021-12-22 | Broome | New York | 36007 | 31606 | 455 |
2036213 | 2036213 | 2021-12-21 | Broome | New York | 36007 | 31494 | 454 |
2032963 | 2032963 | 2021-12-20 | Broome | New York | 36007 | 31380 | 454 |
2029713 | 2029713 | 2021-12-19 | Broome | New York | 36007 | 31273 | 452 |
2026462 | 2026462 | 2021-12-18 | Broome | New York | 36007 | 31080 | 452 |
2023211 | 2023211 | 2021-12-17 | Broome | New York | 36007 | 30867 | 451 |
2019960 | 2019960 | 2021-12-16 | Broome | New York | 36007 | 30617 | 451 |
2016709 | 2016709 | 2021-12-15 | Broome | New York | 36007 | 30403 | 450 |
2013459 | 2013459 | 2021-12-14 | Broome | New York | 36007 | 30242 | 449 |
2010208 | 2010208 | 2021-12-13 | Broome | New York | 36007 | 30165 | 447 |
2006957 | 2006957 | 2021-12-12 | Broome | New York | 36007 | 30087 | 446 |
2003706 | 2003706 | 2021-12-11 | Broome | New York | 36007 | 29937 | 444 |
2000455 | 2000455 | 2021-12-10 | Broome | New York | 36007 | 29703 | 443 |
1997205 | 1997205 | 2021-12-09 | Broome | New York | 36007 | 29536 | 441 |
1993954 | 1993954 | 2021-12-08 | Broome | New York | 36007 | 29358 | 441 |
1990703 | 1990703 | 2021-12-07 | Broome | New York | 36007 | 29230 | 441 |
1987452 | 1987452 | 2021-12-06 | Broome | New York | 36007 | 29061 | 440 |
1984202 | 1984202 | 2021-12-05 | Broome | New York | 36007 | 29007 | 438 |
1980952 | 1980952 | 2021-12-04 | Broome | New York | 36007 | 28853 | 437 |
1977702 | 1977702 | 2021-12-03 | Broome | New York | 36007 | 28730 | 437 |
1974452 | 1974452 | 2021-12-02 | Broome | New York | 36007 | 28549 | 436 |
1971203 | 1971203 | 2021-12-01 | Broome | New York | 36007 | 28368 | 435 |
1967953 | 1967953 | 2021-11-30 | Broome | New York | 36007 | 28212 | 434 |
1964702 | 1964702 | 2021-11-29 | Broome | New York | 36007 | 28142 | 433 |
1961450 | 1961450 | 2021-11-28 | Broome | New York | 36007 | 28056 | 432 |
1958199 | 1958199 | 2021-11-27 | Broome | New York | 36007 | 27982 | 432 |
1954948 | 1954948 | 2021-11-26 | Broome | New York | 36007 | 27944 | 432 |
1951697 | 1951697 | 2021-11-25 | Broome | New York | 36007 | 27865 | 432 |
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 |
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);