ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where deaths = 134 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 18
county 18
- Chemung 7
- Jefferson 6
- Allegany 3
- Fulton 3
- Montgomery 3
- Oneida 3
- Herkimer 2
- Wayne 2
- Albany 1
- Cayuga 1
- Chautauqua 1
- Dutchess 1
- Niagara 1
- Ontario 1
- Rensselaer 1
- Schenectady 1
- Steuben 1
- Ulster 1
state 1
- New York · 39 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2348434 | 2348434 | 2022-03-27 | Jefferson | New York | 36045 | 19932 | 134 |
2345181 | 2345181 | 2022-03-26 | Jefferson | New York | 36045 | 19927 | 134 |
2341928 | 2341928 | 2022-03-25 | Jefferson | New York | 36045 | 19913 | 134 |
2338675 | 2338675 | 2022-03-24 | Jefferson | New York | 36045 | 19902 | 134 |
2335421 | 2335421 | 2022-03-23 | Jefferson | New York | 36045 | 19888 | 134 |
2332167 | 2332167 | 2022-03-22 | Jefferson | New York | 36045 | 19866 | 134 |
2185803 | 2185803 | 2022-02-05 | Cayuga | New York | 36011 | 15208 | 134 |
2094775 | 2094775 | 2022-01-08 | Wayne | New York | 36117 | 13386 | 134 |
2091523 | 2091523 | 2022-01-07 | Wayne | New York | 36117 | 13186 | 134 |
2088234 | 2088234 | 2022-01-06 | Fulton | New York | 36035 | 9477 | 134 |
2084982 | 2084982 | 2022-01-05 | Fulton | New York | 36035 | 9366 | 134 |
2081730 | 2081730 | 2022-01-04 | Fulton | New York | 36035 | 9246 | 134 |
2052461 | 2052461 | 2021-12-26 | Allegany | New York | 36003 | 6861 | 134 |
2049211 | 2049211 | 2021-12-25 | Allegany | New York | 36003 | 6839 | 134 |
2045961 | 2045961 | 2021-12-24 | Allegany | New York | 36003 | 6839 | 134 |
2029743 | 2029743 | 2021-12-19 | Ontario | New York | 36069 | 13203 | 134 |
1906213 | 1906213 | 2021-11-11 | Herkimer | New York | 36043 | 7504 | 134 |
1902964 | 1902964 | 2021-11-10 | Herkimer | New York | 36043 | 7465 | 134 |
1763252 | 1763252 | 2021-09-28 | Montgomery | New York | 36057 | 5253 | 134 |
1760003 | 1760003 | 2021-09-27 | Montgomery | New York | 36057 | 5232 | 134 |
1756755 | 1756755 | 2021-09-26 | Montgomery | New York | 36057 | 5213 | 134 |
1305367 | 1305367 | 2021-05-10 | Chemung | New York | 36015 | 7476 | 134 |
1302121 | 1302121 | 2021-05-09 | Chemung | New York | 36015 | 7467 | 134 |
1298873 | 1298873 | 2021-05-08 | Chemung | New York | 36015 | 7452 | 134 |
1295627 | 1295627 | 2021-05-07 | Chemung | New York | 36015 | 7435 | 134 |
1292381 | 1292381 | 2021-05-06 | Chemung | New York | 36015 | 7423 | 134 |
1289135 | 1289135 | 2021-05-05 | Chemung | New York | 36015 | 7416 | 134 |
1285889 | 1285889 | 2021-05-04 | Chemung | New York | 36015 | 7408 | 134 |
1233937 | 1233937 | 2021-04-18 | Chautauqua | New York | 36013 | 8419 | 134 |
1188496 | 1188496 | 2021-04-04 | Rensselaer | New York | 36083 | 10181 | 134 |
977498 | 977498 | 2021-01-29 | Steuben | New York | 36101 | 4940 | 134 |
951533 | 951533 | 2021-01-21 | Schenectady | New York | 36093 | 8869 | 134 |
854184 | 854184 | 2020-12-22 | Ulster | New York | 36111 | 5001 | 134 |
824951 | 824951 | 2020-12-13 | Niagara | New York | 36063 | 5906 | 134 |
721103 | 721103 | 2020-11-11 | Oneida | New York | 36065 | 3251 | 134 |
717860 | 717860 | 2020-11-10 | Oneida | New York | 36065 | 3177 | 134 |
714617 | 714617 | 2020-11-09 | Oneida | New York | 36065 | 3121 | 134 |
165012 | 165012 | 2020-05-21 | Albany | New York | 36001 | 1700 | 134 |
161995 | 161995 | 2020-05-20 | Dutchess | New York | 36027 | 3724 | 134 |
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);