ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Schoharie" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
cases 481 ✖
- 69 26
- 1692 13
- 54 11
- 62 11
- 68 11
- 83 11
- 20 9
- 49 9
- 12 7
- 57 7
- 58 7
- 1 6
- 45 6
- 85 6
- 47 5
- 1705 5
- 1710 5
- 46 4
- 51 4
- 73 4
- 100 4
- 1689 4
- 1694 4
- 1719 4
- 8 3
- 11 3
- 48 3
- 50 3
- 55 3
- 59 3
- 70 3
- 87 3
- 101 3
- 1680 3
- 1714 3
- 2 2
- 5 2
- 6 2
- 21 2
- 35 2
- 43 2
- 64 2
- 67 2
- 86 2
- 94 2
- 95 2
- 109 2
- 116 2
- 141 2
- 162 2
- 176 2
- 1585 2
- 1685 2
- 1693 2
- 1696 2
- 1701 2
- 1711 2
- 1743 2
- 3295 2
- 3 1
- 33 1
- 38 1
- 39 1
- 42 1
- 56 1
- 60 1
- 61 1
- 66 1
- 71 1
- 72 1
- 74 1
- 75 1
- 77 1
- 78 1
- 82 1
- 84 1
- 88 1
- 90 1
- 93 1
- 97 1
- 104 1
- 107 1
- 110 1
- 111 1
- 112 1
- 113 1
- 114 1
- 115 1
- 117 1
- 119 1
- 120 1
- 121 1
- 122 1
- 124 1
- 130 1
- 133 1
- 137 1
- 143 1
- 145 1
- 155 1
- 160 1
- 166 1
- 169 1
- 179 1
- 183 1
- 190 1
- 194 1
- 196 1
- 197 1
- 208 1
- 212 1
- 217 1
- 220 1
- 235 1
- 245 1
- 250 1
- 260 1
- 275 1
- 279 1
- 293 1
- 306 1
- 326 1
- 342 1
- 356 1
- 378 1
- 392 1
- 401 1
- 408 1
- 418 1
- 426 1
- 438 1
- 449 1
- 456 1
- 471 1
- 493 1
- 507 1
- 516 1
- 527 1
- 542 1
- 554 1
- 572 1
- 589 1
- 611 1
- 628 1
- 638 1
- 654 1
- 679 1
- 701 1
- 728 1
- 742 1
- 756 1
- 780 1
- 799 1
- 818 1
- 851 1
- 873 1
- 882 1
- 889 1
- 897 1
- 914 1
- 926 1
- 943 1
- 960 1
- 975 1
- 981 1
- 990 1
- 998 1
- 1003 1
- 1012 1
- 1018 1
- 1029 1
- 1033 1
- 1043 1
- 1045 1
- 1047 1
- 1051 1
- 1056 1
- 1071 1
- 1074 1
- 1079 1
- 1087 1
- 1089 1
- 1095 1
- 1106 1
- 1113 1
- 1121 1
- 1125 1
- 1132 1
- 1143 1
- 1154 1
- 1160 1
- 1168 1
- 1173 1
- 1175 1
- 1176 1
- 1183 1
- 1187 1
- 1190 1
- 1200 1
- 1210 1
- 1215 1
- 1223 1
- 1229 1
- 1241 1
- 1243 1
- 1251 1
- 1254 1
- 1259 1
- 1263 1
- 1268 1
- 1279 1
- 1284 1
- 1291 1
- 1300 1
- 1301 1
- 1312 1
- 1323 1
- 1330 1
- 1339 1
- 1348 1
- 1359 1
- 1368 1
- 1372 1
- 1376 1
- 1384 1
- 1389 1
- 1392 1
- 1399 1
- 1401 1
- 1411 1
- 1417 1
- 1424 1
- 1434 1
- 1443 1
- 1445 1
- 1453 1
- 1462 1
- 1470 1
- 1478 1
- 1488 1
- 1493 1
- 1498 1
- 1503 1
- 1520 1
- 1538 1
- 1543 1
- 1548 1
- 1552 1
- 1555 1
- 1562 1
- 1568 1
- 1573 1
- 1579 1
- 1581 1
- 1583 1
- 1588 1
- 1591 1
- 1600 1
- 1609 1
- 1614 1
- 1615 1
- 1616 1
- 1623 1
- 1625 1
- 1632 1
- 1640 1
- 1643 1
- 1645 1
- 1648 1
- 1652 1
- 1655 1
- 1660 1
- 1662 1
- 1663 1
- 1667 1
- 1669 1
- 1670 1
- 1671 1
- 1679 1
- 1682 1
- 1686 1
- 1687 1
- 1688 1
- 1690 1
- 1691 1
- 1697 1
- 1699 1
- 1702 1
- 1704 1
- 1706 1
- 1715 1
- 1716 1
- 1720 1
- 1721 1
- 1722 1
- 1725 1
- 1730 1
- 1733 1
- 1736 1
- 1742 1
- 1747 1
- 1751 1
- 1757 1
- 1761 1
- 1768 1
- 1772 1
- 1781 1
- 1787 1
- 1792 1
- 1800 1
- 1806 1
- 1809 1
- 1812 1
- 1814 1
- 1816 1
- 1820 1
- 1823 1
- 1827 1
- 1832 1
- 1833 1
- 1838 1
- 1842 1
- 1851 1
- 1862 1
- 1872 1
- 1879 1
- 1886 1
- 1888 1
- 1895 1
- 1899 1
- 1912 1
- 1926 1
- 1934 1
- 1944 1
- 1951 1
- 1963 1
- 1973 1
- 1988 1
- 1997 1
- 2008 1
- 2016 1
- 2023 1
- 2028 1
- 2035 1
- 2041 1
- 2050 1
- 2054 1
- 2065 1
- 2072 1
- 2076 1
- 2083 1
- 2092 1
- 2103 1
- 2109 1
- 2116 1
- 2122 1
- 2133 1
- 2145 1
- 2155 1
- 2164 1
- 2181 1
- 2182 1
- 2185 1
- 2194 1
- 2197 1
- 2207 1
- 2214 1
- 2217 1
- 2229 1
- 2231 1
- 2237 1
- 2246 1
- 2254 1
- 2262 1
- 2272 1
- 2276 1
- 2277 1
- 2289 1
- 2295 1
- 2301 1
- 2322 1
- 2328 1
- 2337 1
- 2342 1
- 2350 1
- 2360 1
- 2368 1
- 2379 1
- 2382 1
- 2387 1
- 2393 1
- 2400 1
- 2415 1
- 2426 1
- 2429 1
- 2439 1
- 2445 1
- 2452 1
- 2457 1
- 2467 1
- 2475 1
- 2480 1
- 2485 1
- 2494 1
- 2500 1
- 2511 1
- 2518 1
- 2532 1
- 2538 1
- 2558 1
- 2573 1
- 2589 1
- 2603 1
- 2615 1
- 2623 1
- 2637 1
- 2654 1
- 2658 1
- 2681 1
- 2723 1
- 2746 1
- 2794 1
- 2816 1
- 2847 1
- 2879 1
- 2904 1
- 2938 1
- 2960 1
- 2987 1
- 3008 1
- 3028 1
- 3048 1
- 3061 1
- 3089 1
- 3112 1
- 3140 1
- 3180 1
- 3199 1
- 3210 1
- 3221 1
- 3242 1
- 3269 1
- 3302 1
- 3306 1
- 3310 1
- 3353 1
- 3388 1
- 3429 1
- 3470 1
- 3503 1
- 3515 1
- 3533 1
- 3577 1
- 3623 1
- 3669 1
- 3736 1
- 3812 1
- 3838 1
- 3871 1
- 3926 1
- 3992 1
- 4054 1
- 4111 1
- 4166 1
- 4198 1
- 4237 1
- 4269 1
- 4328 1
- 4393 1
- 4435 1
- 4463 1
- 4479 1
- 4513 1
- 4542 1
- 4571 1
- 4609 1
- 4628 1
- 4638 1
- 4656 1
- 4671 1
- 4688 1
state 1
- New York 686
fips 1
- 36095 686
county 1
- Schoharie · 686 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176086 | 2176086 | 2022-02-02 | Schoharie | New York | 36095 | 4688 | 33 |
2172833 | 2172833 | 2022-02-01 | Schoharie | New York | 36095 | 4671 | 33 |
2169580 | 2169580 | 2022-01-31 | Schoharie | New York | 36095 | 4656 | 33 |
2166325 | 2166325 | 2022-01-30 | Schoharie | New York | 36095 | 4638 | 33 |
2163070 | 2163070 | 2022-01-29 | Schoharie | New York | 36095 | 4628 | 33 |
2159815 | 2159815 | 2022-01-28 | Schoharie | New York | 36095 | 4609 | 33 |
2156560 | 2156560 | 2022-01-27 | Schoharie | New York | 36095 | 4571 | 33 |
2153307 | 2153307 | 2022-01-26 | Schoharie | New York | 36095 | 4542 | 33 |
2150055 | 2150055 | 2022-01-25 | Schoharie | New York | 36095 | 4513 | 33 |
2146803 | 2146803 | 2022-01-24 | Schoharie | New York | 36095 | 4479 | 33 |
2143549 | 2143549 | 2022-01-23 | Schoharie | New York | 36095 | 4463 | 33 |
2140294 | 2140294 | 2022-01-22 | Schoharie | New York | 36095 | 4435 | 32 |
2137038 | 2137038 | 2022-01-21 | Schoharie | New York | 36095 | 4393 | 32 |
2133785 | 2133785 | 2022-01-20 | Schoharie | New York | 36095 | 4328 | 32 |
2130533 | 2130533 | 2022-01-19 | Schoharie | New York | 36095 | 4269 | 32 |
2127279 | 2127279 | 2022-01-18 | Schoharie | New York | 36095 | 4237 | 32 |
2124027 | 2124027 | 2022-01-17 | Schoharie | New York | 36095 | 4198 | 31 |
2120775 | 2120775 | 2022-01-16 | Schoharie | New York | 36095 | 4166 | 31 |
2117523 | 2117523 | 2022-01-15 | Schoharie | New York | 36095 | 4111 | 31 |
2114272 | 2114272 | 2022-01-14 | Schoharie | New York | 36095 | 4054 | 31 |
2111020 | 2111020 | 2022-01-13 | Schoharie | New York | 36095 | 3992 | 31 |
2107768 | 2107768 | 2022-01-12 | Schoharie | New York | 36095 | 3926 | 31 |
2104517 | 2104517 | 2022-01-11 | Schoharie | New York | 36095 | 3871 | 30 |
2101266 | 2101266 | 2022-01-10 | Schoharie | New York | 36095 | 3838 | 30 |
2098015 | 2098015 | 2022-01-09 | Schoharie | New York | 36095 | 3812 | 30 |
2094763 | 2094763 | 2022-01-08 | Schoharie | New York | 36095 | 3736 | 30 |
2091511 | 2091511 | 2022-01-07 | Schoharie | New York | 36095 | 3669 | 30 |
2088260 | 2088260 | 2022-01-06 | Schoharie | New York | 36095 | 3623 | 29 |
2085008 | 2085008 | 2022-01-05 | Schoharie | New York | 36095 | 3577 | 29 |
2081756 | 2081756 | 2022-01-04 | Schoharie | New York | 36095 | 3533 | 29 |
2078504 | 2078504 | 2022-01-03 | Schoharie | New York | 36095 | 3515 | 29 |
2075253 | 2075253 | 2022-01-02 | Schoharie | New York | 36095 | 3503 | 29 |
2072002 | 2072002 | 2022-01-01 | Schoharie | New York | 36095 | 3470 | 29 |
2068751 | 2068751 | 2021-12-31 | Schoharie | New York | 36095 | 3429 | 29 |
2065500 | 2065500 | 2021-12-30 | Schoharie | New York | 36095 | 3388 | 29 |
2062250 | 2062250 | 2021-12-29 | Schoharie | New York | 36095 | 3353 | 29 |
2059001 | 2059001 | 2021-12-28 | Schoharie | New York | 36095 | 3310 | 29 |
2055752 | 2055752 | 2021-12-27 | Schoharie | New York | 36095 | 3306 | 29 |
2052502 | 2052502 | 2021-12-26 | Schoharie | New York | 36095 | 3302 | 29 |
2049252 | 2049252 | 2021-12-25 | Schoharie | New York | 36095 | 3295 | 29 |
2046002 | 2046002 | 2021-12-24 | Schoharie | New York | 36095 | 3295 | 29 |
2042752 | 2042752 | 2021-12-23 | Schoharie | New York | 36095 | 3269 | 29 |
2039503 | 2039503 | 2021-12-22 | Schoharie | New York | 36095 | 3242 | 29 |
2036253 | 2036253 | 2021-12-21 | Schoharie | New York | 36095 | 3221 | 29 |
2033003 | 2033003 | 2021-12-20 | Schoharie | New York | 36095 | 3210 | 29 |
2029753 | 2029753 | 2021-12-19 | Schoharie | New York | 36095 | 3199 | 29 |
2026502 | 2026502 | 2021-12-18 | Schoharie | New York | 36095 | 3180 | 29 |
2023251 | 2023251 | 2021-12-17 | Schoharie | New York | 36095 | 3140 | 27 |
2020000 | 2020000 | 2021-12-16 | Schoharie | New York | 36095 | 3112 | 27 |
2016749 | 2016749 | 2021-12-15 | Schoharie | New York | 36095 | 3089 | 27 |
2013499 | 2013499 | 2021-12-14 | Schoharie | New York | 36095 | 3061 | 27 |
2010248 | 2010248 | 2021-12-13 | Schoharie | New York | 36095 | 3048 | 27 |
2006997 | 2006997 | 2021-12-12 | Schoharie | New York | 36095 | 3028 | 26 |
2003746 | 2003746 | 2021-12-11 | Schoharie | New York | 36095 | 3008 | 26 |
2000495 | 2000495 | 2021-12-10 | Schoharie | New York | 36095 | 2987 | 26 |
1997245 | 1997245 | 2021-12-09 | Schoharie | New York | 36095 | 2960 | 26 |
1993994 | 1993994 | 2021-12-08 | Schoharie | New York | 36095 | 2938 | 26 |
1990743 | 1990743 | 2021-12-07 | Schoharie | New York | 36095 | 2904 | 26 |
1987492 | 1987492 | 2021-12-06 | Schoharie | New York | 36095 | 2879 | 25 |
1984242 | 1984242 | 2021-12-05 | Schoharie | New York | 36095 | 2847 | 25 |
1980992 | 1980992 | 2021-12-04 | Schoharie | New York | 36095 | 2816 | 24 |
1977742 | 1977742 | 2021-12-03 | Schoharie | New York | 36095 | 2794 | 24 |
1974492 | 1974492 | 2021-12-02 | Schoharie | New York | 36095 | 2746 | 24 |
1971243 | 1971243 | 2021-12-01 | Schoharie | New York | 36095 | 2723 | 24 |
1967993 | 1967993 | 2021-11-30 | Schoharie | New York | 36095 | 2681 | 24 |
1964742 | 1964742 | 2021-11-29 | Schoharie | New York | 36095 | 2658 | 24 |
1961490 | 1961490 | 2021-11-28 | Schoharie | New York | 36095 | 2654 | 24 |
1958239 | 1958239 | 2021-11-27 | Schoharie | New York | 36095 | 2637 | 24 |
1954988 | 1954988 | 2021-11-26 | Schoharie | New York | 36095 | 2623 | 24 |
1951737 | 1951737 | 2021-11-25 | Schoharie | New York | 36095 | 2615 | 24 |
1948486 | 1948486 | 2021-11-24 | Schoharie | New York | 36095 | 2603 | 24 |
1945235 | 1945235 | 2021-11-23 | Schoharie | New York | 36095 | 2589 | 24 |
1941984 | 1941984 | 2021-11-22 | Schoharie | New York | 36095 | 2573 | 24 |
1938734 | 1938734 | 2021-11-21 | Schoharie | New York | 36095 | 2558 | 24 |
1935484 | 1935484 | 2021-11-20 | Schoharie | New York | 36095 | 2538 | 24 |
1932234 | 1932234 | 2021-11-19 | Schoharie | New York | 36095 | 2532 | 24 |
1928983 | 1928983 | 2021-11-18 | Schoharie | New York | 36095 | 2518 | 24 |
1925733 | 1925733 | 2021-11-17 | Schoharie | New York | 36095 | 2511 | 24 |
1922484 | 1922484 | 2021-11-16 | Schoharie | New York | 36095 | 2500 | 24 |
1919234 | 1919234 | 2021-11-15 | Schoharie | New York | 36095 | 2494 | 24 |
1915984 | 1915984 | 2021-11-14 | Schoharie | New York | 36095 | 2485 | 24 |
1912734 | 1912734 | 2021-11-13 | Schoharie | New York | 36095 | 2480 | 24 |
1909484 | 1909484 | 2021-11-12 | Schoharie | New York | 36095 | 2475 | 24 |
1906235 | 1906235 | 2021-11-11 | Schoharie | New York | 36095 | 2467 | 24 |
1902986 | 1902986 | 2021-11-10 | Schoharie | New York | 36095 | 2457 | 24 |
1899736 | 1899736 | 2021-11-09 | Schoharie | New York | 36095 | 2452 | 24 |
1896486 | 1896486 | 2021-11-08 | Schoharie | New York | 36095 | 2445 | 24 |
1893236 | 1893236 | 2021-11-07 | Schoharie | New York | 36095 | 2439 | 24 |
1889986 | 1889986 | 2021-11-06 | Schoharie | New York | 36095 | 2429 | 24 |
1886736 | 1886736 | 2021-11-05 | Schoharie | New York | 36095 | 2426 | 23 |
1883487 | 1883487 | 2021-11-04 | Schoharie | New York | 36095 | 2415 | 23 |
1880238 | 1880238 | 2021-11-03 | Schoharie | New York | 36095 | 2400 | 23 |
1876989 | 1876989 | 2021-11-02 | Schoharie | New York | 36095 | 2393 | 23 |
1873740 | 1873740 | 2021-11-01 | Schoharie | New York | 36095 | 2387 | 23 |
1870491 | 1870491 | 2021-10-31 | Schoharie | New York | 36095 | 2382 | 23 |
1867242 | 1867242 | 2021-10-30 | Schoharie | New York | 36095 | 2379 | 23 |
1863993 | 1863993 | 2021-10-29 | Schoharie | New York | 36095 | 2368 | 23 |
1860744 | 1860744 | 2021-10-28 | Schoharie | New York | 36095 | 2360 | 23 |
1857495 | 1857495 | 2021-10-27 | Schoharie | New York | 36095 | 2350 | 23 |
1854246 | 1854246 | 2021-10-26 | Schoharie | New York | 36095 | 2342 | 23 |
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);