ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where deaths = 70 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 30
county 30
- Jefferson 22
- Chenango 13
- Wayne 10
- Delaware 7
- Tompkins 7
- Steuben 6
- Otsego 5
- Seneca 5
- Sullivan 5
- Rensselaer 4
- Tioga 4
- Cortland 3
- Putnam 3
- Allegany 2
- Cattaraugus 2
- Greene 2
- Wyoming 2
- Albany 1
- Broome 1
- Cayuga 1
- Chautauqua 1
- Chemung 1
- Dutchess 1
- Herkimer 1
- Montgomery 1
- Oneida 1
- Ontario 1
- Schenectady 1
- St. Lawrence 1
- Washington 1
state 1
- New York · 115 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426536 | 2426536 | 2022-04-20 | Delaware | New York | 36025 | 7950 | 70 |
2423280 | 2423280 | 2022-04-19 | Delaware | New York | 36025 | 7929 | 70 |
2420023 | 2420023 | 2022-04-18 | Delaware | New York | 36025 | 7924 | 70 |
2416768 | 2416768 | 2022-04-17 | Delaware | New York | 36025 | 7923 | 70 |
2413512 | 2413512 | 2022-04-16 | Delaware | New York | 36025 | 7906 | 70 |
2410256 | 2410256 | 2022-04-15 | Delaware | New York | 36025 | 7895 | 70 |
2407000 | 2407000 | 2022-04-14 | Delaware | New York | 36025 | 7883 | 70 |
2059009 | 2059009 | 2021-12-28 | Tompkins | New York | 36109 | 11030 | 70 |
2055760 | 2055760 | 2021-12-27 | Tompkins | New York | 36109 | 11010 | 70 |
2052510 | 2052510 | 2021-12-26 | Tompkins | New York | 36109 | 10997 | 70 |
2049260 | 2049260 | 2021-12-25 | Tompkins | New York | 36109 | 10812 | 70 |
2046010 | 2046010 | 2021-12-24 | Tompkins | New York | 36109 | 10812 | 70 |
2042760 | 2042760 | 2021-12-23 | Tompkins | New York | 36109 | 10694 | 70 |
2039511 | 2039511 | 2021-12-22 | Tompkins | New York | 36109 | 10511 | 70 |
2013493 | 2013493 | 2021-12-14 | Otsego | New York | 36077 | 6011 | 70 |
2010242 | 2010242 | 2021-12-13 | Otsego | New York | 36077 | 5975 | 70 |
2006991 | 2006991 | 2021-12-12 | Otsego | New York | 36077 | 5948 | 70 |
2003740 | 2003740 | 2021-12-11 | Otsego | New York | 36077 | 5914 | 70 |
2000489 | 2000489 | 2021-12-10 | Otsego | New York | 36077 | 5863 | 70 |
1997247 | 1997247 | 2021-12-09 | Seneca | New York | 36099 | 3500 | 70 |
1993996 | 1993996 | 2021-12-08 | Seneca | New York | 36099 | 3468 | 70 |
1990745 | 1990745 | 2021-12-07 | Seneca | New York | 36099 | 3456 | 70 |
1990757 | 1990757 | 2021-12-07 | Wyoming | New York | 36121 | 5583 | 70 |
1987494 | 1987494 | 2021-12-06 | Seneca | New York | 36099 | 3429 | 70 |
1987506 | 1987506 | 2021-12-06 | Wyoming | New York | 36121 | 5566 | 70 |
1984244 | 1984244 | 2021-12-05 | Seneca | New York | 36099 | 3415 | 70 |
1880249 | 1880249 | 2021-11-03 | Washington | New York | 36115 | 4986 | 70 |
1812014 | 1812014 | 2021-10-13 | Tioga | New York | 36107 | 4871 | 70 |
1808765 | 1808765 | 2021-10-12 | Tioga | New York | 36107 | 4845 | 70 |
1805514 | 1805514 | 2021-10-11 | Tioga | New York | 36107 | 4834 | 70 |
1802265 | 1802265 | 2021-10-10 | Tioga | New York | 36107 | 4807 | 70 |
1746993 | 1746993 | 2021-09-23 | Cortland | New York | 36023 | 4840 | 70 |
1743744 | 1743744 | 2021-09-22 | Cortland | New York | 36023 | 4824 | 70 |
1740495 | 1740495 | 2021-09-21 | Cortland | New York | 36023 | 4811 | 70 |
1721009 | 1721009 | 2021-09-15 | Jefferson | New York | 36045 | 7158 | 70 |
1717761 | 1717761 | 2021-09-14 | Jefferson | New York | 36045 | 7137 | 70 |
1714513 | 1714513 | 2021-09-13 | Jefferson | New York | 36045 | 7118 | 70 |
1711267 | 1711267 | 2021-09-12 | Jefferson | New York | 36045 | 7085 | 70 |
1708020 | 1708020 | 2021-09-11 | Jefferson | New York | 36045 | 7042 | 70 |
1704773 | 1704773 | 2021-09-10 | Jefferson | New York | 36045 | 6984 | 70 |
1701523 | 1701523 | 2021-09-09 | Jefferson | New York | 36045 | 6945 | 70 |
1698274 | 1698274 | 2021-09-08 | Jefferson | New York | 36045 | 6899 | 70 |
1695026 | 1695026 | 2021-09-07 | Jefferson | New York | 36045 | 6872 | 70 |
1691778 | 1691778 | 2021-09-06 | Jefferson | New York | 36045 | 6856 | 70 |
1688528 | 1688528 | 2021-09-05 | Jefferson | New York | 36045 | 6809 | 70 |
1685278 | 1685278 | 2021-09-04 | Jefferson | New York | 36045 | 6793 | 70 |
1682027 | 1682027 | 2021-09-03 | Jefferson | New York | 36045 | 6761 | 70 |
1678778 | 1678778 | 2021-09-02 | Jefferson | New York | 36045 | 6724 | 70 |
1675530 | 1675530 | 2021-09-01 | Jefferson | New York | 36045 | 6698 | 70 |
1672283 | 1672283 | 2021-08-31 | Jefferson | New York | 36045 | 6671 | 70 |
1669035 | 1669035 | 2021-08-30 | Jefferson | New York | 36045 | 6646 | 70 |
1665788 | 1665788 | 2021-08-29 | Jefferson | New York | 36045 | 6629 | 70 |
1662540 | 1662540 | 2021-08-28 | Jefferson | New York | 36045 | 6611 | 70 |
1659292 | 1659292 | 2021-08-27 | Jefferson | New York | 36045 | 6580 | 70 |
1656043 | 1656043 | 2021-08-26 | Jefferson | New York | 36045 | 6549 | 70 |
1652796 | 1652796 | 2021-08-25 | Jefferson | New York | 36045 | 6524 | 70 |
1438506 | 1438506 | 2021-06-20 | Wayne | New York | 36117 | 5785 | 70 |
1435259 | 1435259 | 2021-06-19 | Wayne | New York | 36117 | 5785 | 70 |
1432012 | 1432012 | 2021-06-18 | Wayne | New York | 36117 | 5783 | 70 |
1428766 | 1428766 | 2021-06-17 | Wayne | New York | 36117 | 5783 | 70 |
1425521 | 1425521 | 2021-06-16 | Wayne | New York | 36117 | 5783 | 70 |
1422274 | 1422274 | 2021-06-15 | Wayne | New York | 36117 | 5783 | 70 |
1419028 | 1419028 | 2021-06-14 | Wayne | New York | 36117 | 5782 | 70 |
1415783 | 1415783 | 2021-06-13 | Wayne | New York | 36117 | 5781 | 70 |
1412537 | 1412537 | 2021-06-12 | Wayne | New York | 36117 | 5778 | 70 |
1409292 | 1409292 | 2021-06-11 | Wayne | New York | 36117 | 5775 | 70 |
1253462 | 1253462 | 2021-04-24 | Sullivan | New York | 36105 | 6295 | 70 |
1250215 | 1250215 | 2021-04-23 | Sullivan | New York | 36105 | 6264 | 70 |
1246968 | 1246968 | 2021-04-22 | Sullivan | New York | 36105 | 6235 | 70 |
1243721 | 1243721 | 2021-04-21 | Sullivan | New York | 36105 | 6210 | 70 |
1240474 | 1240474 | 2021-04-20 | Sullivan | New York | 36105 | 6192 | 70 |
1126769 | 1126769 | 2021-03-16 | Chenango | New York | 36017 | 2585 | 70 |
1123523 | 1123523 | 2021-03-15 | Chenango | New York | 36017 | 2570 | 70 |
1120277 | 1120277 | 2021-03-14 | Chenango | New York | 36017 | 2563 | 70 |
1117030 | 1117030 | 2021-03-13 | Chenango | New York | 36017 | 2554 | 70 |
1113783 | 1113783 | 2021-03-12 | Chenango | New York | 36017 | 2541 | 70 |
1110537 | 1110537 | 2021-03-11 | Chenango | New York | 36017 | 2531 | 70 |
1107291 | 1107291 | 2021-03-10 | Chenango | New York | 36017 | 2527 | 70 |
1104045 | 1104045 | 2021-03-09 | Chenango | New York | 36017 | 2510 | 70 |
1100799 | 1100799 | 2021-03-08 | Chenango | New York | 36017 | 2505 | 70 |
1097553 | 1097553 | 2021-03-07 | Chenango | New York | 36017 | 2502 | 70 |
1094305 | 1094305 | 2021-03-06 | Chenango | New York | 36017 | 2487 | 70 |
1091059 | 1091059 | 2021-03-05 | Chenango | New York | 36017 | 2474 | 70 |
1087814 | 1087814 | 2021-03-04 | Chenango | New York | 36017 | 2461 | 70 |
1068351 | 1068351 | 2021-02-26 | Greene | New York | 36039 | 2622 | 70 |
1065106 | 1065106 | 2021-02-25 | Greene | New York | 36039 | 2609 | 70 |
1000179 | 1000179 | 2021-02-05 | Cattaraugus | New York | 36009 | 3928 | 70 |
996933 | 996933 | 2021-02-04 | Cattaraugus | New York | 36009 | 3881 | 70 |
996975 | 996975 | 2021-02-04 | St. Lawrence | New York | 36089 | 4539 | 70 |
958003 | 958003 | 2021-01-23 | Herkimer | New York | 36043 | 3896 | 70 |
954742 | 954742 | 2021-01-22 | Chautauqua | New York | 36013 | 5844 | 70 |
945004 | 945004 | 2021-01-19 | Cayuga | New York | 36011 | 4432 | 70 |
932056 | 932056 | 2021-01-15 | Putnam | New York | 36079 | 6203 | 70 |
928800 | 928800 | 2021-01-14 | Montgomery | New York | 36057 | 1986 | 70 |
928811 | 928811 | 2021-01-14 | Putnam | New York | 36079 | 6067 | 70 |
925566 | 925566 | 2021-01-13 | Putnam | New York | 36079 | 6014 | 70 |
902844 | 902844 | 2021-01-06 | Ontario | New York | 36069 | 3810 | 70 |
857379 | 857379 | 2020-12-23 | Allegany | New York | 36003 | 1627 | 70 |
854134 | 854134 | 2020-12-22 | Allegany | New York | 36003 | 1607 | 70 |
847681 | 847681 | 2020-12-20 | Rensselaer | New York | 36083 | 3168 | 70 |
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);