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)
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);