ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
274 rows where deaths = 57 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Seneca 74
- Warren 74
- Essex 31
- Livingston 11
- Otsego 10
- Delaware 9
- Tioga 9
- Washington 7
- Orleans 6
- Wyoming 5
- Sullivan 4
- Chenango 3
- Cortland 3
- Allegany 2
- Broome 2
- Cattaraugus 2
- Clinton 2
- Columbia 2
- Greene 2
- Niagara 2
- Schenectady 2
- Tompkins 2
- Wayne 2
- Dutchess 1
- Genesee 1
- Herkimer 1
- Montgomery 1
- Oneida 1
- Onondaga 1
- Oswego 1
- …
state 1
- New York · 274 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2367947 | 2367947 | 2022-04-02 | Essex | New York | 36031 | 5680 | 57 |
2364694 | 2364694 | 2022-04-01 | Essex | New York | 36031 | 5668 | 57 |
2361440 | 2361440 | 2022-03-31 | Essex | New York | 36031 | 5650 | 57 |
2358186 | 2358186 | 2022-03-30 | Essex | New York | 36031 | 5636 | 57 |
2354932 | 2354932 | 2022-03-29 | Essex | New York | 36031 | 5624 | 57 |
2351679 | 2351679 | 2022-03-28 | Essex | New York | 36031 | 5620 | 57 |
2348427 | 2348427 | 2022-03-27 | Essex | New York | 36031 | 5616 | 57 |
2345174 | 2345174 | 2022-03-26 | Essex | New York | 36031 | 5612 | 57 |
2341921 | 2341921 | 2022-03-25 | Essex | New York | 36031 | 5605 | 57 |
2338668 | 2338668 | 2022-03-24 | Essex | New York | 36031 | 5601 | 57 |
2335414 | 2335414 | 2022-03-23 | Essex | New York | 36031 | 5591 | 57 |
2332160 | 2332160 | 2022-03-22 | Essex | New York | 36031 | 5579 | 57 |
2328907 | 2328907 | 2022-03-21 | Essex | New York | 36031 | 5576 | 57 |
2325655 | 2325655 | 2022-03-20 | Essex | New York | 36031 | 5571 | 57 |
2322402 | 2322402 | 2022-03-19 | Essex | New York | 36031 | 5565 | 57 |
2319148 | 2319148 | 2022-03-18 | Essex | New York | 36031 | 5556 | 57 |
2315894 | 2315894 | 2022-03-17 | Essex | New York | 36031 | 5543 | 57 |
2312641 | 2312641 | 2022-03-16 | Essex | New York | 36031 | 5533 | 57 |
2309388 | 2309388 | 2022-03-15 | Essex | New York | 36031 | 5517 | 57 |
2306135 | 2306135 | 2022-03-14 | Essex | New York | 36031 | 5514 | 57 |
2302884 | 2302884 | 2022-03-13 | Essex | New York | 36031 | 5513 | 57 |
2299632 | 2299632 | 2022-03-12 | Essex | New York | 36031 | 5508 | 57 |
2296380 | 2296380 | 2022-03-11 | Essex | New York | 36031 | 5502 | 57 |
2293128 | 2293128 | 2022-03-10 | Essex | New York | 36031 | 5498 | 57 |
2289876 | 2289876 | 2022-03-09 | Essex | New York | 36031 | 5497 | 57 |
2286624 | 2286624 | 2022-03-08 | Essex | New York | 36031 | 5492 | 57 |
2283372 | 2283372 | 2022-03-07 | Essex | New York | 36031 | 5490 | 57 |
2280120 | 2280120 | 2022-03-06 | Essex | New York | 36031 | 5488 | 57 |
2276867 | 2276867 | 2022-03-05 | Essex | New York | 36031 | 5485 | 57 |
2273614 | 2273614 | 2022-03-04 | Essex | New York | 36031 | 5476 | 57 |
2270361 | 2270361 | 2022-03-03 | Essex | New York | 36031 | 5476 | 57 |
2068717 | 2068717 | 2021-12-31 | Clinton | New York | 36019 | 9900 | 57 |
2065466 | 2065466 | 2021-12-30 | Clinton | New York | 36019 | 9744 | 57 |
2058970 | 2058970 | 2021-12-28 | Delaware | New York | 36025 | 5338 | 57 |
2055721 | 2055721 | 2021-12-27 | Delaware | New York | 36025 | 5332 | 57 |
2052471 | 2052471 | 2021-12-26 | Delaware | New York | 36025 | 5322 | 57 |
2049221 | 2049221 | 2021-12-25 | Delaware | New York | 36025 | 5297 | 57 |
2045971 | 2045971 | 2021-12-24 | Delaware | New York | 36025 | 5297 | 57 |
2042721 | 2042721 | 2021-12-23 | Delaware | New York | 36025 | 5251 | 57 |
2039472 | 2039472 | 2021-12-22 | Delaware | New York | 36025 | 5208 | 57 |
2036222 | 2036222 | 2021-12-21 | Delaware | New York | 36025 | 5172 | 57 |
2032972 | 2032972 | 2021-12-20 | Delaware | New York | 36025 | 5147 | 57 |
1919228 | 1919228 | 2021-11-15 | Otsego | New York | 36077 | 4989 | 57 |
1915978 | 1915978 | 2021-11-14 | Otsego | New York | 36077 | 4983 | 57 |
1912728 | 1912728 | 2021-11-13 | Otsego | New York | 36077 | 4969 | 57 |
1909478 | 1909478 | 2021-11-12 | Otsego | New York | 36077 | 4944 | 57 |
1906229 | 1906229 | 2021-11-11 | Otsego | New York | 36077 | 4919 | 57 |
1902980 | 1902980 | 2021-11-10 | Otsego | New York | 36077 | 4893 | 57 |
1899730 | 1899730 | 2021-11-09 | Otsego | New York | 36077 | 4879 | 57 |
1896480 | 1896480 | 2021-11-08 | Otsego | New York | 36077 | 4857 | 57 |
1893230 | 1893230 | 2021-11-07 | Otsego | New York | 36077 | 4839 | 57 |
1889980 | 1889980 | 2021-11-06 | Otsego | New York | 36077 | 4823 | 57 |
1825016 | 1825016 | 2021-10-17 | Wyoming | New York | 36121 | 4336 | 57 |
1821767 | 1821767 | 2021-10-16 | Wyoming | New York | 36121 | 4326 | 57 |
1818518 | 1818518 | 2021-10-15 | Wyoming | New York | 36121 | 4309 | 57 |
1815269 | 1815269 | 2021-10-14 | Wyoming | New York | 36121 | 4292 | 57 |
1812021 | 1812021 | 2021-10-13 | Wyoming | New York | 36121 | 4276 | 57 |
1717790 | 1717790 | 2021-09-14 | Tompkins | New York | 36109 | 5690 | 57 |
1714542 | 1714542 | 2021-09-13 | Tompkins | New York | 36109 | 5683 | 57 |
1685301 | 1685301 | 2021-09-04 | Seneca | New York | 36099 | 2236 | 57 |
1682050 | 1682050 | 2021-09-03 | Seneca | New York | 36099 | 2217 | 57 |
1678801 | 1678801 | 2021-09-02 | Seneca | New York | 36099 | 2207 | 57 |
1675553 | 1675553 | 2021-09-01 | Seneca | New York | 36099 | 2193 | 57 |
1672306 | 1672306 | 2021-08-31 | Seneca | New York | 36099 | 2185 | 57 |
1669058 | 1669058 | 2021-08-30 | Seneca | New York | 36099 | 2176 | 57 |
1665811 | 1665811 | 2021-08-29 | Seneca | New York | 36099 | 2165 | 57 |
1662563 | 1662563 | 2021-08-28 | Seneca | New York | 36099 | 2159 | 57 |
1659315 | 1659315 | 2021-08-27 | Seneca | New York | 36099 | 2151 | 57 |
1656066 | 1656066 | 2021-08-26 | Seneca | New York | 36099 | 2138 | 57 |
1652819 | 1652819 | 2021-08-25 | Seneca | New York | 36099 | 2134 | 57 |
1649571 | 1649571 | 2021-08-24 | Seneca | New York | 36099 | 2127 | 57 |
1646322 | 1646322 | 2021-08-23 | Seneca | New York | 36099 | 2125 | 57 |
1646331 | 1646331 | 2021-08-23 | Washington | New York | 36115 | 3375 | 57 |
1643073 | 1643073 | 2021-08-22 | Seneca | New York | 36099 | 2118 | 57 |
1643082 | 1643082 | 2021-08-22 | Washington | New York | 36115 | 3370 | 57 |
1639823 | 1639823 | 2021-08-21 | Seneca | New York | 36099 | 2111 | 57 |
1639832 | 1639832 | 2021-08-21 | Washington | New York | 36115 | 3365 | 57 |
1636573 | 1636573 | 2021-08-20 | Seneca | New York | 36099 | 2105 | 57 |
1636582 | 1636582 | 2021-08-20 | Washington | New York | 36115 | 3356 | 57 |
1633323 | 1633323 | 2021-08-19 | Seneca | New York | 36099 | 2099 | 57 |
1633332 | 1633332 | 2021-08-19 | Washington | New York | 36115 | 3353 | 57 |
1630076 | 1630076 | 2021-08-18 | Seneca | New York | 36099 | 2096 | 57 |
1630085 | 1630085 | 2021-08-18 | Washington | New York | 36115 | 3342 | 57 |
1626829 | 1626829 | 2021-08-17 | Seneca | New York | 36099 | 2088 | 57 |
1626838 | 1626838 | 2021-08-17 | Washington | New York | 36115 | 3327 | 57 |
1623582 | 1623582 | 2021-08-16 | Seneca | New York | 36099 | 2086 | 57 |
1620335 | 1620335 | 2021-08-15 | Seneca | New York | 36099 | 2084 | 57 |
1617087 | 1617087 | 2021-08-14 | Seneca | New York | 36099 | 2082 | 57 |
1613839 | 1613839 | 2021-08-13 | Seneca | New York | 36099 | 2077 | 57 |
1610590 | 1610590 | 2021-08-12 | Seneca | New York | 36099 | 2071 | 57 |
1607342 | 1607342 | 2021-08-11 | Seneca | New York | 36099 | 2070 | 57 |
1604093 | 1604093 | 2021-08-10 | Seneca | New York | 36099 | 2065 | 57 |
1600844 | 1600844 | 2021-08-09 | Seneca | New York | 36099 | 2064 | 57 |
1597596 | 1597596 | 2021-08-08 | Seneca | New York | 36099 | 2063 | 57 |
1594347 | 1594347 | 2021-08-07 | Seneca | New York | 36099 | 2061 | 57 |
1591098 | 1591098 | 2021-08-06 | Seneca | New York | 36099 | 2057 | 57 |
1587849 | 1587849 | 2021-08-05 | Seneca | New York | 36099 | 2051 | 57 |
1584599 | 1584599 | 2021-08-04 | Seneca | New York | 36099 | 2046 | 57 |
1581349 | 1581349 | 2021-08-03 | Seneca | New York | 36099 | 2043 | 57 |
1578100 | 1578100 | 2021-08-02 | Seneca | New York | 36099 | 2042 | 57 |
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);