ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
269 rows where deaths = 92 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 26
county 26
- Cayuga 100
- Ontario 35
- Cattaraugus 31
- Putnam 18
- Oswego 15
- Cortland 8
- St. Lawrence 8
- Chenango 7
- Allegany 6
- Fulton 6
- Oneida 5
- Greene 4
- Columbia 3
- Livingston 3
- Madison 3
- Sullivan 3
- Herkimer 2
- Niagara 2
- Orleans 2
- Washington 2
- Chautauqua 1
- Jefferson 1
- Montgomery 1
- Rensselaer 1
- Ulster 1
- Wayne 1
state 1
- New York · 269 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2091479 | 2091479 | 2022-01-07 | Cortland | New York | 36023 | 7836 | 92 |
2088228 | 2088228 | 2022-01-06 | Cortland | New York | 36023 | 7729 | 92 |
2084976 | 2084976 | 2022-01-05 | Cortland | New York | 36023 | 7613 | 92 |
2081724 | 2081724 | 2022-01-04 | Cortland | New York | 36023 | 7531 | 92 |
2081767 | 2081767 | 2022-01-04 | Washington | New York | 36115 | 8641 | 92 |
2078472 | 2078472 | 2022-01-03 | Cortland | New York | 36023 | 7495 | 92 |
2078515 | 2078515 | 2022-01-03 | Washington | New York | 36115 | 8582 | 92 |
2075221 | 2075221 | 2022-01-02 | Cortland | New York | 36023 | 7444 | 92 |
2071970 | 2071970 | 2022-01-01 | Cortland | New York | 36023 | 7377 | 92 |
2068719 | 2068719 | 2021-12-31 | Cortland | New York | 36023 | 7256 | 92 |
2058982 | 2058982 | 2021-12-28 | Livingston | New York | 36051 | 8299 | 92 |
2055733 | 2055733 | 2021-12-27 | Livingston | New York | 36051 | 8291 | 92 |
2052483 | 2052483 | 2021-12-26 | Livingston | New York | 36051 | 8284 | 92 |
2016755 | 2016755 | 2021-12-15 | Sullivan | New York | 36105 | 10464 | 92 |
2013475 | 2013475 | 2021-12-14 | Greene | New York | 36039 | 5322 | 92 |
2013505 | 2013505 | 2021-12-14 | Sullivan | New York | 36105 | 10388 | 92 |
2010224 | 2010224 | 2021-12-13 | Greene | New York | 36039 | 5297 | 92 |
2010254 | 2010254 | 2021-12-13 | Sullivan | New York | 36105 | 10355 | 92 |
2006973 | 2006973 | 2021-12-12 | Greene | New York | 36039 | 5278 | 92 |
2003722 | 2003722 | 2021-12-11 | Greene | New York | 36039 | 5265 | 92 |
1899701 | 1899701 | 2021-11-09 | Chenango | New York | 36017 | 4980 | 92 |
1896451 | 1896451 | 2021-11-08 | Chenango | New York | 36017 | 4959 | 92 |
1896498 | 1896498 | 2021-11-08 | Wayne | New York | 36117 | 8895 | 92 |
1893201 | 1893201 | 2021-11-07 | Chenango | New York | 36017 | 4947 | 92 |
1893215 | 1893215 | 2021-11-07 | Jefferson | New York | 36045 | 9788 | 92 |
1893228 | 1893228 | 2021-11-07 | Orleans | New York | 36073 | 4773 | 92 |
1889951 | 1889951 | 2021-11-06 | Chenango | New York | 36017 | 4924 | 92 |
1889978 | 1889978 | 2021-11-06 | Orleans | New York | 36073 | 4749 | 92 |
1886701 | 1886701 | 2021-11-05 | Chenango | New York | 36017 | 4905 | 92 |
1883452 | 1883452 | 2021-11-04 | Chenango | New York | 36017 | 4879 | 92 |
1880203 | 1880203 | 2021-11-03 | Chenango | New York | 36017 | 4868 | 92 |
1740486 | 1740486 | 2021-09-21 | Allegany | New York | 36003 | 4000 | 92 |
1737237 | 1737237 | 2021-09-20 | Allegany | New York | 36003 | 3986 | 92 |
1733987 | 1733987 | 2021-09-19 | Allegany | New York | 36003 | 3981 | 92 |
1730737 | 1730737 | 2021-09-18 | Allegany | New York | 36003 | 3967 | 92 |
1727487 | 1727487 | 2021-09-17 | Allegany | New York | 36003 | 3946 | 92 |
1724238 | 1724238 | 2021-09-16 | Allegany | New York | 36003 | 3926 | 92 |
1704776 | 1704776 | 2021-09-10 | Madison | New York | 36053 | 5170 | 92 |
1701526 | 1701526 | 2021-09-09 | Madison | New York | 36053 | 5143 | 92 |
1698277 | 1698277 | 2021-09-08 | Madison | New York | 36053 | 5116 | 92 |
1591058 | 1591058 | 2021-08-06 | Cayuga | New York | 36011 | 6455 | 92 |
1587809 | 1587809 | 2021-08-05 | Cayuga | New York | 36011 | 6446 | 92 |
1584559 | 1584559 | 2021-08-04 | Cayuga | New York | 36011 | 6442 | 92 |
1581309 | 1581309 | 2021-08-03 | Cayuga | New York | 36011 | 6435 | 92 |
1578060 | 1578060 | 2021-08-02 | Cayuga | New York | 36011 | 6430 | 92 |
1574812 | 1574812 | 2021-08-01 | Cayuga | New York | 36011 | 6426 | 92 |
1571564 | 1571564 | 2021-07-31 | Cayuga | New York | 36011 | 6421 | 92 |
1568316 | 1568316 | 2021-07-30 | Cayuga | New York | 36011 | 6420 | 92 |
1565068 | 1565068 | 2021-07-29 | Cayuga | New York | 36011 | 6417 | 92 |
1561820 | 1561820 | 2021-07-28 | Cayuga | New York | 36011 | 6411 | 92 |
1558572 | 1558572 | 2021-07-27 | Cayuga | New York | 36011 | 6403 | 92 |
1555325 | 1555325 | 2021-07-26 | Cayuga | New York | 36011 | 6396 | 92 |
1552077 | 1552077 | 2021-07-25 | Cattaraugus | New York | 36009 | 5766 | 92 |
1552078 | 1552078 | 2021-07-25 | Cayuga | New York | 36011 | 6395 | 92 |
1548830 | 1548830 | 2021-07-24 | Cattaraugus | New York | 36009 | 5765 | 92 |
1548831 | 1548831 | 2021-07-24 | Cayuga | New York | 36011 | 6386 | 92 |
1545583 | 1545583 | 2021-07-23 | Cattaraugus | New York | 36009 | 5764 | 92 |
1545584 | 1545584 | 2021-07-23 | Cayuga | New York | 36011 | 6385 | 92 |
1542336 | 1542336 | 2021-07-22 | Cattaraugus | New York | 36009 | 5762 | 92 |
1542337 | 1542337 | 2021-07-22 | Cayuga | New York | 36011 | 6383 | 92 |
1539088 | 1539088 | 2021-07-21 | Cattaraugus | New York | 36009 | 5758 | 92 |
1539089 | 1539089 | 2021-07-21 | Cayuga | New York | 36011 | 6380 | 92 |
1535841 | 1535841 | 2021-07-20 | Cattaraugus | New York | 36009 | 5756 | 92 |
1535842 | 1535842 | 2021-07-20 | Cayuga | New York | 36011 | 6377 | 92 |
1532593 | 1532593 | 2021-07-19 | Cattaraugus | New York | 36009 | 5749 | 92 |
1532594 | 1532594 | 2021-07-19 | Cayuga | New York | 36011 | 6373 | 92 |
1529346 | 1529346 | 2021-07-18 | Cattaraugus | New York | 36009 | 5749 | 92 |
1529347 | 1529347 | 2021-07-18 | Cayuga | New York | 36011 | 6373 | 92 |
1526099 | 1526099 | 2021-07-17 | Cattaraugus | New York | 36009 | 5738 | 92 |
1526100 | 1526100 | 2021-07-17 | Cayuga | New York | 36011 | 6369 | 92 |
1522852 | 1522852 | 2021-07-16 | Cattaraugus | New York | 36009 | 5736 | 92 |
1522853 | 1522853 | 2021-07-16 | Cayuga | New York | 36011 | 6368 | 92 |
1519604 | 1519604 | 2021-07-15 | Cattaraugus | New York | 36009 | 5735 | 92 |
1519605 | 1519605 | 2021-07-15 | Cayuga | New York | 36011 | 6366 | 92 |
1516356 | 1516356 | 2021-07-14 | Cattaraugus | New York | 36009 | 5733 | 92 |
1516357 | 1516357 | 2021-07-14 | Cayuga | New York | 36011 | 6364 | 92 |
1513109 | 1513109 | 2021-07-13 | Cattaraugus | New York | 36009 | 5730 | 92 |
1513110 | 1513110 | 2021-07-13 | Cayuga | New York | 36011 | 6363 | 92 |
1509863 | 1509863 | 2021-07-12 | Cattaraugus | New York | 36009 | 5730 | 92 |
1509864 | 1509864 | 2021-07-12 | Cayuga | New York | 36011 | 6362 | 92 |
1506616 | 1506616 | 2021-07-11 | Cattaraugus | New York | 36009 | 5730 | 92 |
1506617 | 1506617 | 2021-07-11 | Cayuga | New York | 36011 | 6362 | 92 |
1503370 | 1503370 | 2021-07-10 | Cattaraugus | New York | 36009 | 5730 | 92 |
1503371 | 1503371 | 2021-07-10 | Cayuga | New York | 36011 | 6362 | 92 |
1500124 | 1500124 | 2021-07-09 | Cattaraugus | New York | 36009 | 5730 | 92 |
1500125 | 1500125 | 2021-07-09 | Cayuga | New York | 36011 | 6360 | 92 |
1496878 | 1496878 | 2021-07-08 | Cattaraugus | New York | 36009 | 5729 | 92 |
1496879 | 1496879 | 2021-07-08 | Cayuga | New York | 36011 | 6359 | 92 |
1493631 | 1493631 | 2021-07-07 | Cattaraugus | New York | 36009 | 5729 | 92 |
1493632 | 1493632 | 2021-07-07 | Cayuga | New York | 36011 | 6358 | 92 |
1490384 | 1490384 | 2021-07-06 | Cattaraugus | New York | 36009 | 5728 | 92 |
1490385 | 1490385 | 2021-07-06 | Cayuga | New York | 36011 | 6357 | 92 |
1487137 | 1487137 | 2021-07-05 | Cattaraugus | New York | 36009 | 5728 | 92 |
1487138 | 1487138 | 2021-07-05 | Cayuga | New York | 36011 | 6357 | 92 |
1483891 | 1483891 | 2021-07-04 | Cattaraugus | New York | 36009 | 5728 | 92 |
1483892 | 1483892 | 2021-07-04 | Cayuga | New York | 36011 | 6354 | 92 |
1480645 | 1480645 | 2021-07-03 | Cattaraugus | New York | 36009 | 5728 | 92 |
1480646 | 1480646 | 2021-07-03 | Cayuga | New York | 36011 | 6354 | 92 |
1477398 | 1477398 | 2021-07-02 | Cattaraugus | New York | 36009 | 5727 | 92 |
1477399 | 1477399 | 2021-07-02 | Cayuga | New York | 36011 | 6353 | 92 |
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);