ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
200 rows where deaths = 34 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2341949 | 2341949 | 2022-03-25 | Schoharie | New York | 36095 | 4967 | 34 |
2338696 | 2338696 | 2022-03-24 | Schoharie | New York | 36095 | 4963 | 34 |
2335442 | 2335442 | 2022-03-23 | Schoharie | New York | 36095 | 4962 | 34 |
2332188 | 2332188 | 2022-03-22 | Schoharie | New York | 36095 | 4952 | 34 |
2328935 | 2328935 | 2022-03-21 | Schoharie | New York | 36095 | 4952 | 34 |
2325683 | 2325683 | 2022-03-20 | Schoharie | New York | 36095 | 4952 | 34 |
2322430 | 2322430 | 2022-03-19 | Schoharie | New York | 36095 | 4952 | 34 |
2319176 | 2319176 | 2022-03-18 | Schoharie | New York | 36095 | 4951 | 34 |
2315922 | 2315922 | 2022-03-17 | Schoharie | New York | 36095 | 4945 | 34 |
2312669 | 2312669 | 2022-03-16 | Schoharie | New York | 36095 | 4941 | 34 |
2309416 | 2309416 | 2022-03-15 | Schoharie | New York | 36095 | 4935 | 34 |
2306163 | 2306163 | 2022-03-14 | Schoharie | New York | 36095 | 4934 | 34 |
2302912 | 2302912 | 2022-03-13 | Schoharie | New York | 36095 | 4932 | 34 |
2299660 | 2299660 | 2022-03-12 | Schoharie | New York | 36095 | 4931 | 34 |
2296408 | 2296408 | 2022-03-11 | Schoharie | New York | 36095 | 4927 | 34 |
2293156 | 2293156 | 2022-03-10 | Schoharie | New York | 36095 | 4921 | 34 |
2289904 | 2289904 | 2022-03-09 | Schoharie | New York | 36095 | 4921 | 34 |
2286652 | 2286652 | 2022-03-08 | Schoharie | New York | 36095 | 4919 | 34 |
2283400 | 2283400 | 2022-03-07 | Schoharie | New York | 36095 | 4919 | 34 |
2280148 | 2280148 | 2022-03-06 | Schoharie | New York | 36095 | 4916 | 34 |
2276895 | 2276895 | 2022-03-05 | Schoharie | New York | 36095 | 4914 | 34 |
2273642 | 2273642 | 2022-03-04 | Schoharie | New York | 36095 | 4909 | 34 |
2270389 | 2270389 | 2022-03-03 | Schoharie | New York | 36095 | 4909 | 34 |
2267137 | 2267137 | 2022-03-02 | Schoharie | New York | 36095 | 4902 | 34 |
2263885 | 2263885 | 2022-03-01 | Schoharie | New York | 36095 | 4899 | 34 |
2260634 | 2260634 | 2022-02-28 | Schoharie | New York | 36095 | 4896 | 34 |
2257383 | 2257383 | 2022-02-27 | Schoharie | New York | 36095 | 4895 | 34 |
2254132 | 2254132 | 2022-02-26 | Schoharie | New York | 36095 | 4894 | 34 |
2250881 | 2250881 | 2022-02-25 | Schoharie | New York | 36095 | 4889 | 34 |
2247630 | 2247630 | 2022-02-24 | Schoharie | New York | 36095 | 4886 | 34 |
2244379 | 2244379 | 2022-02-23 | Schoharie | New York | 36095 | 4886 | 34 |
2241128 | 2241128 | 2022-02-22 | Schoharie | New York | 36095 | 4884 | 34 |
2237877 | 2237877 | 2022-02-21 | Schoharie | New York | 36095 | 4882 | 34 |
2234626 | 2234626 | 2022-02-20 | Schoharie | New York | 36095 | 4876 | 34 |
2231375 | 2231375 | 2022-02-19 | Schoharie | New York | 36095 | 4872 | 34 |
2228124 | 2228124 | 2022-02-18 | Schoharie | New York | 36095 | 4863 | 34 |
2224873 | 2224873 | 2022-02-17 | Schoharie | New York | 36095 | 4856 | 34 |
2221622 | 2221622 | 2022-02-16 | Schoharie | New York | 36095 | 4843 | 34 |
2218371 | 2218371 | 2022-02-15 | Schoharie | New York | 36095 | 4839 | 34 |
2215120 | 2215120 | 2022-02-14 | Schoharie | New York | 36095 | 4834 | 34 |
2211869 | 2211869 | 2022-02-13 | Schoharie | New York | 36095 | 4830 | 34 |
2208616 | 2208616 | 2022-02-12 | Schoharie | New York | 36095 | 4825 | 34 |
2205363 | 2205363 | 2022-02-11 | Schoharie | New York | 36095 | 4821 | 34 |
2202110 | 2202110 | 2022-02-10 | Schoharie | New York | 36095 | 4809 | 34 |
2198856 | 2198856 | 2022-02-09 | Schoharie | New York | 36095 | 4791 | 34 |
2195602 | 2195602 | 2022-02-08 | Schoharie | New York | 36095 | 4782 | 34 |
2192348 | 2192348 | 2022-02-07 | Schoharie | New York | 36095 | 4768 | 34 |
2104490 | 2104490 | 2022-01-11 | Franklin | New York | 36033 | 7203 | 34 |
2101239 | 2101239 | 2022-01-10 | Franklin | New York | 36033 | 7161 | 34 |
2097988 | 2097988 | 2022-01-09 | Franklin | New York | 36033 | 7097 | 34 |
2020015 | 2020015 | 2021-12-16 | Yates | New York | 36123 | 2222 | 34 |
2016764 | 2016764 | 2021-12-15 | Yates | New York | 36123 | 2204 | 34 |
2013514 | 2013514 | 2021-12-14 | Yates | New York | 36123 | 2178 | 34 |
2010263 | 2010263 | 2021-12-13 | Yates | New York | 36123 | 2173 | 34 |
2007012 | 2007012 | 2021-12-12 | Yates | New York | 36123 | 2164 | 34 |
2003761 | 2003761 | 2021-12-11 | Yates | New York | 36123 | 2150 | 34 |
2000510 | 2000510 | 2021-12-10 | Yates | New York | 36123 | 2138 | 34 |
1997260 | 1997260 | 2021-12-09 | Yates | New York | 36123 | 2124 | 34 |
1994009 | 1994009 | 2021-12-08 | Yates | New York | 36123 | 2107 | 34 |
1990758 | 1990758 | 2021-12-07 | Yates | New York | 36123 | 2094 | 34 |
1987507 | 1987507 | 2021-12-06 | Yates | New York | 36123 | 2075 | 34 |
1984257 | 1984257 | 2021-12-05 | Yates | New York | 36123 | 2073 | 34 |
1981007 | 1981007 | 2021-12-04 | Yates | New York | 36123 | 2061 | 34 |
1977757 | 1977757 | 2021-12-03 | Yates | New York | 36123 | 2041 | 34 |
1974507 | 1974507 | 2021-12-02 | Yates | New York | 36123 | 2023 | 34 |
1971258 | 1971258 | 2021-12-01 | Yates | New York | 36123 | 2004 | 34 |
1968008 | 1968008 | 2021-11-30 | Yates | New York | 36123 | 1985 | 34 |
1964757 | 1964757 | 2021-11-29 | Yates | New York | 36123 | 1978 | 34 |
1857467 | 1857467 | 2021-10-27 | Essex | New York | 36031 | 2401 | 34 |
1854218 | 1854218 | 2021-10-26 | Essex | New York | 36031 | 2388 | 34 |
1766483 | 1766483 | 2021-09-29 | Clinton | New York | 36019 | 5980 | 34 |
1763234 | 1763234 | 2021-09-28 | Clinton | New York | 36019 | 5937 | 34 |
1759985 | 1759985 | 2021-09-27 | Clinton | New York | 36019 | 5915 | 34 |
1756737 | 1756737 | 2021-09-26 | Clinton | New York | 36019 | 5866 | 34 |
1753489 | 1753489 | 2021-09-25 | Clinton | New York | 36019 | 5830 | 34 |
1750241 | 1750241 | 2021-09-24 | Clinton | New York | 36019 | 5774 | 34 |
1746991 | 1746991 | 2021-09-23 | Clinton | New York | 36019 | 5716 | 34 |
1743742 | 1743742 | 2021-09-22 | Clinton | New York | 36019 | 5674 | 34 |
1740493 | 1740493 | 2021-09-21 | Clinton | New York | 36019 | 5655 | 34 |
1737244 | 1737244 | 2021-09-20 | Clinton | New York | 36019 | 5615 | 34 |
1733994 | 1733994 | 2021-09-19 | Clinton | New York | 36019 | 5585 | 34 |
1730744 | 1730744 | 2021-09-18 | Clinton | New York | 36019 | 5529 | 34 |
1727494 | 1727494 | 2021-09-17 | Clinton | New York | 36019 | 5464 | 34 |
1724245 | 1724245 | 2021-09-16 | Clinton | New York | 36019 | 5431 | 34 |
1334602 | 1334602 | 2021-05-19 | Lewis | New York | 36049 | 2736 | 34 |
1331355 | 1331355 | 2021-05-18 | Lewis | New York | 36049 | 2719 | 34 |
1328108 | 1328108 | 2021-05-17 | Lewis | New York | 36049 | 2716 | 34 |
1324862 | 1324862 | 2021-05-16 | Lewis | New York | 36049 | 2711 | 34 |
1321616 | 1321616 | 2021-05-15 | Lewis | New York | 36049 | 2707 | 34 |
1318370 | 1318370 | 2021-05-14 | Lewis | New York | 36049 | 2687 | 34 |
1315122 | 1315122 | 2021-05-13 | Lewis | New York | 36049 | 2676 | 34 |
1311876 | 1311876 | 2021-05-12 | Lewis | New York | 36049 | 2659 | 34 |
1308629 | 1308629 | 2021-05-11 | Lewis | New York | 36049 | 2655 | 34 |
1305383 | 1305383 | 2021-05-10 | Lewis | New York | 36049 | 2638 | 34 |
1302137 | 1302137 | 2021-05-09 | Lewis | New York | 36049 | 2634 | 34 |
1298889 | 1298889 | 2021-05-08 | Lewis | New York | 36049 | 2626 | 34 |
1295643 | 1295643 | 2021-05-07 | Lewis | New York | 36049 | 2607 | 34 |
1292397 | 1292397 | 2021-05-06 | Lewis | New York | 36049 | 2590 | 34 |
1289151 | 1289151 | 2021-05-05 | Lewis | New York | 36049 | 2580 | 34 |
1285905 | 1285905 | 2021-05-04 | Lewis | New York | 36049 | 2569 | 34 |
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);