ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
176 rows where deaths = 86 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Chenango 34
- Clinton 21
- Putnam 18
- Broome 10
- Orleans 10
- Allegany 9
- Fulton 9
- Otsego 9
- Greene 6
- Madison 6
- Oswego 6
- Ulster 5
- Cattaraugus 4
- Warren 4
- Seneca 3
- Washington 3
- Cayuga 2
- Ontario 2
- Steuben 2
- Sullivan 2
- Columbia 1
- Cortland 1
- Erie 1
- Genesee 1
- Jefferson 1
- Livingston 1
- Oneida 1
- Rensselaer 1
- Saratoga 1
- Schenectady 1
- …
state 1
- New York · 176 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2400486 | 2400486 | 2022-04-12 | Clinton | New York | 36019 | 16952 | 86 |
2397231 | 2397231 | 2022-04-11 | Clinton | New York | 36019 | 16941 | 86 |
2393976 | 2393976 | 2022-04-10 | Clinton | New York | 36019 | 16920 | 86 |
2390720 | 2390720 | 2022-04-09 | Clinton | New York | 36019 | 16893 | 86 |
2387464 | 2387464 | 2022-04-08 | Clinton | New York | 36019 | 16860 | 86 |
2384209 | 2384209 | 2022-04-07 | Clinton | New York | 36019 | 16825 | 86 |
2380954 | 2380954 | 2022-04-06 | Clinton | New York | 36019 | 16791 | 86 |
2377699 | 2377699 | 2022-04-05 | Clinton | New York | 36019 | 16775 | 86 |
2374446 | 2374446 | 2022-04-04 | Clinton | New York | 36019 | 16757 | 86 |
2371194 | 2371194 | 2022-04-03 | Clinton | New York | 36019 | 16745 | 86 |
2367941 | 2367941 | 2022-04-02 | Clinton | New York | 36019 | 16732 | 86 |
2364688 | 2364688 | 2022-04-01 | Clinton | New York | 36019 | 16717 | 86 |
2361434 | 2361434 | 2022-03-31 | Clinton | New York | 36019 | 16700 | 86 |
2358180 | 2358180 | 2022-03-30 | Clinton | New York | 36019 | 16682 | 86 |
2354926 | 2354926 | 2022-03-29 | Clinton | New York | 36019 | 16668 | 86 |
2351673 | 2351673 | 2022-03-28 | Clinton | New York | 36019 | 16665 | 86 |
2348421 | 2348421 | 2022-03-27 | Clinton | New York | 36019 | 16655 | 86 |
2345168 | 2345168 | 2022-03-26 | Clinton | New York | 36019 | 16641 | 86 |
2341915 | 2341915 | 2022-03-25 | Clinton | New York | 36019 | 16628 | 86 |
2338662 | 2338662 | 2022-03-24 | Clinton | New York | 36019 | 16602 | 86 |
2335408 | 2335408 | 2022-03-23 | Clinton | New York | 36019 | 16574 | 86 |
2250875 | 2250875 | 2022-02-25 | Otsego | New York | 36077 | 9615 | 86 |
2247624 | 2247624 | 2022-02-24 | Otsego | New York | 36077 | 9600 | 86 |
2244373 | 2244373 | 2022-02-23 | Otsego | New York | 36077 | 9587 | 86 |
2241122 | 2241122 | 2022-02-22 | Otsego | New York | 36077 | 9576 | 86 |
2237871 | 2237871 | 2022-02-21 | Otsego | New York | 36077 | 9566 | 86 |
2234620 | 2234620 | 2022-02-20 | Otsego | New York | 36077 | 9563 | 86 |
2231369 | 2231369 | 2022-02-19 | Otsego | New York | 36077 | 9544 | 86 |
2228118 | 2228118 | 2022-02-18 | Otsego | New York | 36077 | 9525 | 86 |
2224867 | 2224867 | 2022-02-17 | Otsego | New York | 36077 | 9510 | 86 |
2133787 | 2133787 | 2022-01-20 | Seneca | New York | 36099 | 5006 | 86 |
2130535 | 2130535 | 2022-01-19 | Seneca | New York | 36099 | 4948 | 86 |
2127281 | 2127281 | 2022-01-18 | Seneca | New York | 36099 | 4912 | 86 |
2023232 | 2023232 | 2021-12-17 | Livingston | New York | 36051 | 7976 | 86 |
2013510 | 2013510 | 2021-12-14 | Washington | New York | 36115 | 7471 | 86 |
2010259 | 2010259 | 2021-12-13 | Washington | New York | 36115 | 7426 | 86 |
2007008 | 2007008 | 2021-12-12 | Washington | New York | 36115 | 7388 | 86 |
1909490 | 1909490 | 2021-11-12 | Sullivan | New York | 36105 | 8942 | 86 |
1906241 | 1906241 | 2021-11-11 | Sullivan | New York | 36105 | 8894 | 86 |
1886704 | 1886704 | 2021-11-05 | Cortland | New York | 36023 | 5641 | 86 |
1876968 | 1876968 | 2021-11-02 | Jefferson | New York | 36045 | 9482 | 86 |
1870501 | 1870501 | 2021-10-31 | Warren | New York | 36113 | 5798 | 86 |
1867252 | 1867252 | 2021-10-30 | Warren | New York | 36113 | 5768 | 86 |
1864003 | 1864003 | 2021-10-29 | Warren | New York | 36113 | 5730 | 86 |
1860754 | 1860754 | 2021-10-28 | Warren | New York | 36113 | 5680 | 86 |
1841212 | 1841212 | 2021-10-22 | Chenango | New York | 36017 | 4706 | 86 |
1841223 | 1841223 | 2021-10-22 | Greene | New York | 36039 | 4401 | 86 |
1837963 | 1837963 | 2021-10-21 | Chenango | New York | 36017 | 4689 | 86 |
1837974 | 1837974 | 2021-10-21 | Greene | New York | 36039 | 4385 | 86 |
1834714 | 1834714 | 2021-10-20 | Chenango | New York | 36017 | 4674 | 86 |
1834725 | 1834725 | 2021-10-20 | Greene | New York | 36039 | 4371 | 86 |
1831465 | 1831465 | 2021-10-19 | Chenango | New York | 36017 | 4657 | 86 |
1831476 | 1831476 | 2021-10-19 | Greene | New York | 36039 | 4353 | 86 |
1828216 | 1828216 | 2021-10-18 | Chenango | New York | 36017 | 4649 | 86 |
1828227 | 1828227 | 2021-10-18 | Greene | New York | 36039 | 4351 | 86 |
1824967 | 1824967 | 2021-10-17 | Chenango | New York | 36017 | 4635 | 86 |
1824978 | 1824978 | 2021-10-17 | Greene | New York | 36039 | 4342 | 86 |
1821718 | 1821718 | 2021-10-16 | Chenango | New York | 36017 | 4619 | 86 |
1818469 | 1818469 | 2021-10-15 | Chenango | New York | 36017 | 4594 | 86 |
1815220 | 1815220 | 2021-10-14 | Chenango | New York | 36017 | 4556 | 86 |
1815247 | 1815247 | 2021-10-14 | Orleans | New York | 36073 | 4217 | 86 |
1811972 | 1811972 | 2021-10-13 | Chenango | New York | 36017 | 4543 | 86 |
1811999 | 1811999 | 2021-10-13 | Orleans | New York | 36073 | 4185 | 86 |
1808723 | 1808723 | 2021-10-12 | Chenango | New York | 36017 | 4516 | 86 |
1808750 | 1808750 | 2021-10-12 | Orleans | New York | 36073 | 4148 | 86 |
1805472 | 1805472 | 2021-10-11 | Chenango | New York | 36017 | 4500 | 86 |
1805499 | 1805499 | 2021-10-11 | Orleans | New York | 36073 | 4144 | 86 |
1802223 | 1802223 | 2021-10-10 | Chenango | New York | 36017 | 4491 | 86 |
1802250 | 1802250 | 2021-10-10 | Orleans | New York | 36073 | 4124 | 86 |
1798974 | 1798974 | 2021-10-09 | Chenango | New York | 36017 | 4475 | 86 |
1799001 | 1799001 | 2021-10-09 | Orleans | New York | 36073 | 4089 | 86 |
1795725 | 1795725 | 2021-10-08 | Chenango | New York | 36017 | 4448 | 86 |
1795752 | 1795752 | 2021-10-08 | Orleans | New York | 36073 | 4067 | 86 |
1792476 | 1792476 | 2021-10-07 | Chenango | New York | 36017 | 4419 | 86 |
1792503 | 1792503 | 2021-10-07 | Orleans | New York | 36073 | 4026 | 86 |
1789227 | 1789227 | 2021-10-06 | Chenango | New York | 36017 | 4401 | 86 |
1789254 | 1789254 | 2021-10-06 | Orleans | New York | 36073 | 4002 | 86 |
1785979 | 1785979 | 2021-10-05 | Chenango | New York | 36017 | 4377 | 86 |
1786006 | 1786006 | 2021-10-05 | Orleans | New York | 36073 | 3963 | 86 |
1782730 | 1782730 | 2021-10-04 | Chenango | New York | 36017 | 4368 | 86 |
1779481 | 1779481 | 2021-10-03 | Chenango | New York | 36017 | 4359 | 86 |
1776231 | 1776231 | 2021-10-02 | Chenango | New York | 36017 | 4338 | 86 |
1772981 | 1772981 | 2021-10-01 | Chenango | New York | 36017 | 4326 | 86 |
1769731 | 1769731 | 2021-09-30 | Chenango | New York | 36017 | 4306 | 86 |
1766482 | 1766482 | 2021-09-29 | Chenango | New York | 36017 | 4284 | 86 |
1763233 | 1763233 | 2021-09-28 | Chenango | New York | 36017 | 4275 | 86 |
1759984 | 1759984 | 2021-09-27 | Chenango | New York | 36017 | 4267 | 86 |
1756736 | 1756736 | 2021-09-26 | Chenango | New York | 36017 | 4259 | 86 |
1753488 | 1753488 | 2021-09-25 | Chenango | New York | 36017 | 4245 | 86 |
1750240 | 1750240 | 2021-09-24 | Chenango | New York | 36017 | 4233 | 86 |
1746990 | 1746990 | 2021-09-23 | Chenango | New York | 36017 | 4212 | 86 |
1743741 | 1743741 | 2021-09-22 | Chenango | New York | 36017 | 4190 | 86 |
1740492 | 1740492 | 2021-09-21 | Chenango | New York | 36017 | 4168 | 86 |
1737243 | 1737243 | 2021-09-20 | Chenango | New York | 36017 | 4156 | 86 |
1733993 | 1733993 | 2021-09-19 | Chenango | New York | 36017 | 4148 | 86 |
1383276 | 1383276 | 2021-06-03 | Allegany | New York | 36003 | 3535 | 86 |
1380030 | 1380030 | 2021-06-02 | Allegany | New York | 36003 | 3533 | 86 |
1376785 | 1376785 | 2021-06-01 | Allegany | New York | 36003 | 3532 | 86 |
1373539 | 1373539 | 2021-05-31 | Allegany | New York | 36003 | 3531 | 86 |
1370294 | 1370294 | 2021-05-30 | Allegany | New York | 36003 | 3529 | 86 |
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);