ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where deaths = 195 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 11
- Schenectady 4
- Steuben 4
- Albany 2
- Broome 2
- Cattaraugus 2
- Chemung 2
- Montgomery 2
- Saratoga 2
- Chautauqua 1
- Dutchess 1
- Rensselaer 1
state 1
- New York · 23 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2241112 | 2241112 | 2022-02-22 | Montgomery | New York | 36057 | 11613 | 195 |
2237861 | 2237861 | 2022-02-21 | Montgomery | New York | 36057 | 11611 | 195 |
2107729 | 2107729 | 2022-01-12 | Cattaraugus | New York | 36009 | 12613 | 195 |
2104478 | 2104478 | 2022-01-11 | Cattaraugus | New York | 36009 | 12456 | 195 |
2088224 | 2088224 | 2022-01-06 | Chemung | New York | 36015 | 15949 | 195 |
2084972 | 2084972 | 2022-01-05 | Chemung | New York | 36015 | 15743 | 195 |
1993998 | 1993998 | 2021-12-08 | Steuben | New York | 36101 | 13264 | 195 |
1990747 | 1990747 | 2021-12-07 | Steuben | New York | 36101 | 13175 | 195 |
1987496 | 1987496 | 2021-12-06 | Steuben | New York | 36101 | 13108 | 195 |
1984246 | 1984246 | 2021-12-05 | Steuben | New York | 36101 | 13064 | 195 |
1974488 | 1974488 | 2021-12-02 | Rensselaer | New York | 36083 | 17633 | 195 |
1967956 | 1967956 | 2021-11-30 | Chautauqua | New York | 36013 | 14985 | 195 |
1808756 | 1808756 | 2021-10-12 | Saratoga | New York | 36091 | 19655 | 195 |
1805505 | 1805505 | 2021-10-11 | Saratoga | New York | 36091 | 19616 | 195 |
1295662 | 1295662 | 2021-05-07 | Schenectady | New York | 36093 | 12835 | 195 |
1292416 | 1292416 | 2021-05-06 | Schenectady | New York | 36093 | 12815 | 195 |
1289170 | 1289170 | 2021-05-05 | Schenectady | New York | 36093 | 12800 | 195 |
1285924 | 1285924 | 2021-05-04 | Schenectady | New York | 36093 | 12778 | 195 |
870358 | 870358 | 2020-12-27 | Albany | New York | 36001 | 10629 | 195 |
867113 | 867113 | 2020-12-26 | Albany | New York | 36001 | 10489 | 195 |
863870 | 863870 | 2020-12-25 | Broome | New York | 36007 | 7540 | 195 |
860625 | 860625 | 2020-12-24 | Broome | New York | 36007 | 7429 | 195 |
798970 | 798970 | 2020-12-05 | Dutchess | New York | 36027 | 7955 | 195 |
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);