ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where deaths = 155 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 16
county 16
- Dutchess 6
- Chautauqua 3
- Genesee 3
- Rensselaer 3
- Saratoga 3
- St. Lawrence 3
- Herkimer 2
- Oswego 2
- Steuben 2
- Allegany 1
- Cattaraugus 1
- Chemung 1
- Montgomery 1
- New York City 1
- Schenectady 1
- Wayne 1
state 1
- New York · 34 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501429 | 2501429 | 2022-05-13 | Allegany | New York | 36003 | 9275 | 155 |
2169592 | 2169592 | 2022-01-31 | Wayne | New York | 36117 | 16150 | 155 |
2114265 | 2114265 | 2022-01-14 | Oswego | New York | 36075 | 20551 | 155 |
2111013 | 2111013 | 2022-01-13 | Oswego | New York | 36075 | 20288 | 155 |
2062225 | 2062225 | 2021-12-29 | Genesee | New York | 36037 | 10024 | 155 |
2058976 | 2058976 | 2021-12-28 | Genesee | New York | 36037 | 9940 | 155 |
2055727 | 2055727 | 2021-12-27 | Genesee | New York | 36037 | 9922 | 155 |
2049230 | 2049230 | 2021-12-25 | Herkimer | New York | 36043 | 9705 | 155 |
2045980 | 2045980 | 2021-12-24 | Herkimer | New York | 36043 | 9705 | 155 |
2029756 | 2029756 | 2021-12-19 | St. Lawrence | New York | 36089 | 14519 | 155 |
2026505 | 2026505 | 2021-12-18 | St. Lawrence | New York | 36089 | 14440 | 155 |
2023254 | 2023254 | 2021-12-17 | St. Lawrence | New York | 36089 | 14361 | 155 |
1958200 | 1958200 | 2021-11-27 | Cattaraugus | New York | 36009 | 9879 | 155 |
1896470 | 1896470 | 2021-11-08 | Montgomery | New York | 36057 | 6405 | 155 |
1834713 | 1834713 | 2021-10-20 | Chemung | New York | 36015 | 10862 | 155 |
1756767 | 1756767 | 2021-09-26 | Rensselaer | New York | 36083 | 13522 | 155 |
1753519 | 1753519 | 2021-09-25 | Rensselaer | New York | 36083 | 13483 | 155 |
1750271 | 1750271 | 2021-09-24 | Rensselaer | New York | 36083 | 13442 | 155 |
1737241 | 1737241 | 2021-09-20 | Chautauqua | New York | 36013 | 10815 | 155 |
1733991 | 1733991 | 2021-09-19 | Chautauqua | New York | 36013 | 10796 | 155 |
1730741 | 1730741 | 2021-09-18 | Chautauqua | New York | 36013 | 10674 | 155 |
1727532 | 1727532 | 2021-09-17 | Steuben | New York | 36101 | 8179 | 155 |
1724283 | 1724283 | 2021-09-16 | Steuben | New York | 36101 | 8125 | 155 |
1178757 | 1178757 | 2021-04-01 | Saratoga | New York | 36091 | 13449 | 155 |
1175510 | 1175510 | 2021-03-31 | Saratoga | New York | 36091 | 13389 | 155 |
1172263 | 1172263 | 2021-03-30 | Saratoga | New York | 36091 | 13338 | 155 |
993725 | 993725 | 2021-02-03 | Schenectady | New York | 36093 | 9881 | 155 |
536273 | 536273 | 2020-09-15 | Dutchess | New York | 36027 | 5006 | 155 |
245016 | 245016 | 2020-06-16 | Dutchess | New York | 36027 | 4075 | 155 |
241904 | 241904 | 2020-06-15 | Dutchess | New York | 36027 | 4068 | 155 |
238795 | 238795 | 2020-06-14 | Dutchess | New York | 36027 | 4056 | 155 |
235687 | 235687 | 2020-06-13 | Dutchess | New York | 36027 | 4049 | 155 |
232582 | 232582 | 2020-06-12 | Dutchess | New York | 36027 | 4035 | 155 |
9016 | 9016 | 2020-03-23 | New York City | New York | 12329 | 155 |
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);