ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where deaths = 144 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 16
county 16
- Rensselaer 25
- Cayuga 22
- Allegany 6
- Chautauqua 4
- Genesee 4
- Steuben 4
- Orange 3
- Ontario 2
- Oswego 2
- Albany 1
- Chemung 1
- Niagara 1
- Oneida 1
- Schenectady 1
- St. Lawrence 1
- Wayne 1
state 1
- New York · 79 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2335404 | 2335404 | 2022-03-23 | Cayuga | New York | 36011 | 15951 | 144 |
2332150 | 2332150 | 2022-03-22 | Cayuga | New York | 36011 | 15890 | 144 |
2328897 | 2328897 | 2022-03-21 | Cayuga | New York | 36011 | 15880 | 144 |
2325645 | 2325645 | 2022-03-20 | Cayuga | New York | 36011 | 15876 | 144 |
2322392 | 2322392 | 2022-03-19 | Cayuga | New York | 36011 | 15871 | 144 |
2319138 | 2319138 | 2022-03-18 | Cayuga | New York | 36011 | 15854 | 144 |
2315884 | 2315884 | 2022-03-17 | Cayuga | New York | 36011 | 15830 | 144 |
2312631 | 2312631 | 2022-03-16 | Cayuga | New York | 36011 | 15801 | 144 |
2309378 | 2309378 | 2022-03-15 | Cayuga | New York | 36011 | 15772 | 144 |
2306125 | 2306125 | 2022-03-14 | Cayuga | New York | 36011 | 15760 | 144 |
2302874 | 2302874 | 2022-03-13 | Cayuga | New York | 36011 | 15754 | 144 |
2299622 | 2299622 | 2022-03-12 | Cayuga | New York | 36011 | 15739 | 144 |
2296370 | 2296370 | 2022-03-11 | Cayuga | New York | 36011 | 15729 | 144 |
2293118 | 2293118 | 2022-03-10 | Cayuga | New York | 36011 | 15715 | 144 |
2289866 | 2289866 | 2022-03-09 | Cayuga | New York | 36011 | 15711 | 144 |
2286614 | 2286614 | 2022-03-08 | Cayuga | New York | 36011 | 15706 | 144 |
2283362 | 2283362 | 2022-03-07 | Cayuga | New York | 36011 | 15699 | 144 |
2280110 | 2280110 | 2022-03-06 | Cayuga | New York | 36011 | 15696 | 144 |
2276857 | 2276857 | 2022-03-05 | Cayuga | New York | 36011 | 15686 | 144 |
2273604 | 2273604 | 2022-03-04 | Cayuga | New York | 36011 | 15653 | 144 |
2270351 | 2270351 | 2022-03-03 | Cayuga | New York | 36011 | 15653 | 144 |
2267099 | 2267099 | 2022-03-02 | Cayuga | New York | 36011 | 15637 | 144 |
2189053 | 2189053 | 2022-02-06 | Allegany | New York | 36003 | 8486 | 144 |
2185800 | 2185800 | 2022-02-05 | Allegany | New York | 36003 | 8459 | 144 |
2182548 | 2182548 | 2022-02-04 | Allegany | New York | 36003 | 8432 | 144 |
2179296 | 2179296 | 2022-02-03 | Allegany | New York | 36003 | 8406 | 144 |
2176045 | 2176045 | 2022-02-02 | Allegany | New York | 36003 | 8362 | 144 |
2172792 | 2172792 | 2022-02-01 | Allegany | New York | 36003 | 8337 | 144 |
2127291 | 2127291 | 2022-01-18 | Wayne | New York | 36117 | 14851 | 144 |
2071992 | 2071992 | 2022-01-01 | Ontario | New York | 36069 | 14302 | 144 |
2068741 | 2068741 | 2021-12-31 | Ontario | New York | 36069 | 14122 | 144 |
2058994 | 2058994 | 2021-12-28 | Oswego | New York | 36075 | 16628 | 144 |
2055745 | 2055745 | 2021-12-27 | Oswego | New York | 36075 | 16593 | 144 |
1974495 | 1974495 | 2021-12-02 | St. Lawrence | New York | 36089 | 13072 | 144 |
1971218 | 1971218 | 2021-12-01 | Genesee | New York | 36037 | 8711 | 144 |
1967968 | 1967968 | 2021-11-30 | Genesee | New York | 36037 | 8633 | 144 |
1964717 | 1964717 | 2021-11-29 | Genesee | New York | 36037 | 8576 | 144 |
1961465 | 1961465 | 2021-11-28 | Genesee | New York | 36037 | 8556 | 144 |
1733992 | 1733992 | 2021-09-19 | Chemung | New York | 36015 | 8956 | 144 |
1548865 | 1548865 | 2021-07-24 | Rensselaer | New York | 36083 | 11333 | 144 |
1545618 | 1545618 | 2021-07-23 | Rensselaer | New York | 36083 | 11329 | 144 |
1542371 | 1542371 | 2021-07-22 | Rensselaer | New York | 36083 | 11320 | 144 |
1539123 | 1539123 | 2021-07-21 | Rensselaer | New York | 36083 | 11314 | 144 |
1535876 | 1535876 | 2021-07-20 | Rensselaer | New York | 36083 | 11311 | 144 |
1532628 | 1532628 | 2021-07-19 | Rensselaer | New York | 36083 | 11305 | 144 |
1529381 | 1529381 | 2021-07-18 | Rensselaer | New York | 36083 | 11302 | 144 |
1526134 | 1526134 | 2021-07-17 | Rensselaer | New York | 36083 | 11293 | 144 |
1522887 | 1522887 | 2021-07-16 | Rensselaer | New York | 36083 | 11288 | 144 |
1519639 | 1519639 | 2021-07-15 | Rensselaer | New York | 36083 | 11282 | 144 |
1516391 | 1516391 | 2021-07-14 | Rensselaer | New York | 36083 | 11277 | 144 |
1513144 | 1513144 | 2021-07-13 | Rensselaer | New York | 36083 | 11273 | 144 |
1509898 | 1509898 | 2021-07-12 | Rensselaer | New York | 36083 | 11271 | 144 |
1506651 | 1506651 | 2021-07-11 | Rensselaer | New York | 36083 | 11264 | 144 |
1503405 | 1503405 | 2021-07-10 | Rensselaer | New York | 36083 | 11262 | 144 |
1500159 | 1500159 | 2021-07-09 | Rensselaer | New York | 36083 | 11259 | 144 |
1496913 | 1496913 | 2021-07-08 | Rensselaer | New York | 36083 | 11254 | 144 |
1493666 | 1493666 | 2021-07-07 | Rensselaer | New York | 36083 | 11253 | 144 |
1490419 | 1490419 | 2021-07-06 | Rensselaer | New York | 36083 | 11253 | 144 |
1487172 | 1487172 | 2021-07-05 | Rensselaer | New York | 36083 | 11253 | 144 |
1483926 | 1483926 | 2021-07-04 | Rensselaer | New York | 36083 | 11252 | 144 |
1480680 | 1480680 | 2021-07-03 | Rensselaer | New York | 36083 | 11252 | 144 |
1477433 | 1477433 | 2021-07-02 | Rensselaer | New York | 36083 | 11252 | 144 |
1474187 | 1474187 | 2021-07-01 | Rensselaer | New York | 36083 | 11251 | 144 |
1470941 | 1470941 | 2021-06-30 | Rensselaer | New York | 36083 | 11249 | 144 |
1419020 | 1419020 | 2021-06-14 | Steuben | New York | 36101 | 6952 | 144 |
1415775 | 1415775 | 2021-06-13 | Steuben | New York | 36101 | 6952 | 144 |
1412529 | 1412529 | 2021-06-12 | Steuben | New York | 36101 | 6950 | 144 |
1409243 | 1409243 | 2021-06-11 | Chautauqua | New York | 36013 | 8948 | 144 |
1409284 | 1409284 | 2021-06-11 | Steuben | New York | 36101 | 6946 | 144 |
1405998 | 1405998 | 2021-06-10 | Chautauqua | New York | 36013 | 8945 | 144 |
1402752 | 1402752 | 2021-06-09 | Chautauqua | New York | 36013 | 8940 | 144 |
1399507 | 1399507 | 2021-06-08 | Chautauqua | New York | 36013 | 8938 | 144 |
964514 | 964514 | 2021-01-25 | Schenectady | New York | 36093 | 9299 | 144 |
834690 | 834690 | 2020-12-16 | Niagara | New York | 36063 | 6258 | 144 |
772998 | 772998 | 2020-11-27 | Albany | New York | 36001 | 5555 | 144 |
753554 | 753554 | 2020-11-21 | Oneida | New York | 36065 | 4038 | 144 |
69001 | 69001 | 2020-04-18 | Orange | New York | 36071 | 6281 | 144 |
66244 | 66244 | 2020-04-17 | Orange | New York | 36071 | 6084 | 144 |
63502 | 63502 | 2020-04-16 | Orange | New York | 36071 | 5888 | 144 |
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);