ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where deaths = 133 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 18
county 18
- Chemung 25
- Rensselaer 18
- Montgomery 16
- Herkimer 4
- Cayuga 3
- Steuben 3
- Broome 2
- Cattaraugus 2
- Chautauqua 2
- Fulton 2
- Genesee 2
- Oneida 2
- Oswego 2
- Wayne 2
- Albany 1
- Allegany 1
- Jefferson 1
- Ontario 1
state 1
- New York · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2328914 | 2328914 | 2022-03-21 | Jefferson | New York | 36045 | 19857 | 133 |
2182551 | 2182551 | 2022-02-04 | Cayuga | New York | 36011 | 15166 | 133 |
2179299 | 2179299 | 2022-02-03 | Cayuga | New York | 36011 | 15128 | 133 |
2176048 | 2176048 | 2022-02-02 | Cayuga | New York | 36011 | 15089 | 133 |
2088272 | 2088272 | 2022-01-06 | Wayne | New York | 36117 | 12998 | 133 |
2085020 | 2085020 | 2022-01-05 | Wayne | New York | 36117 | 12817 | 133 |
2078478 | 2078478 | 2022-01-03 | Fulton | New York | 36035 | 9208 | 133 |
2075227 | 2075227 | 2022-01-02 | Fulton | New York | 36035 | 9163 | 133 |
2042711 | 2042711 | 2021-12-23 | Allegany | New York | 36003 | 6823 | 133 |
2026492 | 2026492 | 2021-12-18 | Ontario | New York | 36069 | 13136 | 133 |
1964735 | 1964735 | 2021-11-29 | Oswego | New York | 36075 | 14083 | 133 |
1961483 | 1961483 | 2021-11-28 | Oswego | New York | 36075 | 14047 | 133 |
1899714 | 1899714 | 2021-11-09 | Herkimer | New York | 36043 | 7410 | 133 |
1896464 | 1896464 | 2021-11-08 | Herkimer | New York | 36043 | 7375 | 133 |
1893197 | 1893197 | 2021-11-07 | Cattaraugus | New York | 36009 | 8503 | 133 |
1893214 | 1893214 | 2021-11-07 | Herkimer | New York | 36043 | 7329 | 133 |
1889947 | 1889947 | 2021-11-06 | Cattaraugus | New York | 36009 | 8466 | 133 |
1889964 | 1889964 | 2021-11-06 | Herkimer | New York | 36043 | 7275 | 133 |
1873715 | 1873715 | 2021-11-01 | Genesee | New York | 36037 | 7362 | 133 |
1870466 | 1870466 | 2021-10-31 | Genesee | New York | 36037 | 7342 | 133 |
1753507 | 1753507 | 2021-09-25 | Montgomery | New York | 36057 | 5189 | 133 |
1750259 | 1750259 | 2021-09-24 | Montgomery | New York | 36057 | 5149 | 133 |
1747009 | 1747009 | 2021-09-23 | Montgomery | New York | 36057 | 5112 | 133 |
1743760 | 1743760 | 2021-09-22 | Montgomery | New York | 36057 | 5094 | 133 |
1740511 | 1740511 | 2021-09-21 | Montgomery | New York | 36057 | 5076 | 133 |
1737262 | 1737262 | 2021-09-20 | Montgomery | New York | 36057 | 5032 | 133 |
1734012 | 1734012 | 2021-09-19 | Montgomery | New York | 36057 | 5023 | 133 |
1730762 | 1730762 | 2021-09-18 | Montgomery | New York | 36057 | 5013 | 133 |
1727512 | 1727512 | 2021-09-17 | Montgomery | New York | 36057 | 4978 | 133 |
1724263 | 1724263 | 2021-09-16 | Montgomery | New York | 36057 | 4966 | 133 |
1721014 | 1721014 | 2021-09-15 | Montgomery | New York | 36057 | 4930 | 133 |
1717766 | 1717766 | 2021-09-14 | Montgomery | New York | 36057 | 4920 | 133 |
1714518 | 1714518 | 2021-09-13 | Montgomery | New York | 36057 | 4899 | 133 |
1711272 | 1711272 | 2021-09-12 | Montgomery | New York | 36057 | 4891 | 133 |
1708025 | 1708025 | 2021-09-11 | Montgomery | New York | 36057 | 4876 | 133 |
1704778 | 1704778 | 2021-09-10 | Montgomery | New York | 36057 | 4865 | 133 |
1282643 | 1282643 | 2021-05-03 | Chemung | New York | 36015 | 7396 | 133 |
1279396 | 1279396 | 2021-05-02 | Chemung | New York | 36015 | 7385 | 133 |
1276149 | 1276149 | 2021-05-01 | Chemung | New York | 36015 | 7361 | 133 |
1272902 | 1272902 | 2021-04-30 | Chemung | New York | 36015 | 7342 | 133 |
1269655 | 1269655 | 2021-04-29 | Chemung | New York | 36015 | 7332 | 133 |
1266408 | 1266408 | 2021-04-28 | Chemung | New York | 36015 | 7312 | 133 |
1263161 | 1263161 | 2021-04-27 | Chemung | New York | 36015 | 7307 | 133 |
1259914 | 1259914 | 2021-04-26 | Chemung | New York | 36015 | 7296 | 133 |
1256667 | 1256667 | 2021-04-25 | Chemung | New York | 36015 | 7279 | 133 |
1253420 | 1253420 | 2021-04-24 | Chemung | New York | 36015 | 7266 | 133 |
1250173 | 1250173 | 2021-04-23 | Chemung | New York | 36015 | 7245 | 133 |
1246926 | 1246926 | 2021-04-22 | Chemung | New York | 36015 | 7227 | 133 |
1243679 | 1243679 | 2021-04-21 | Chemung | New York | 36015 | 7209 | 133 |
1240432 | 1240432 | 2021-04-20 | Chemung | New York | 36015 | 7198 | 133 |
1237185 | 1237185 | 2021-04-19 | Chemung | New York | 36015 | 7183 | 133 |
1233938 | 1233938 | 2021-04-18 | Chemung | New York | 36015 | 7162 | 133 |
1230689 | 1230689 | 2021-04-17 | Chautauqua | New York | 36013 | 8378 | 133 |
1230690 | 1230690 | 2021-04-17 | Chemung | New York | 36015 | 7142 | 133 |
1227441 | 1227441 | 2021-04-16 | Chautauqua | New York | 36013 | 8328 | 133 |
1227442 | 1227442 | 2021-04-16 | Chemung | New York | 36015 | 7098 | 133 |
1224194 | 1224194 | 2021-04-15 | Chemung | New York | 36015 | 7081 | 133 |
1220947 | 1220947 | 2021-04-14 | Chemung | New York | 36015 | 7068 | 133 |
1217699 | 1217699 | 2021-04-13 | Chemung | New York | 36015 | 7052 | 133 |
1214451 | 1214451 | 2021-04-12 | Chemung | New York | 36015 | 7033 | 133 |
1211204 | 1211204 | 2021-04-11 | Chemung | New York | 36015 | 7022 | 133 |
1207955 | 1207955 | 2021-04-10 | Chemung | New York | 36015 | 7001 | 133 |
1204707 | 1204707 | 2021-04-09 | Chemung | New York | 36015 | 6979 | 133 |
1185249 | 1185249 | 2021-04-03 | Rensselaer | New York | 36083 | 10137 | 133 |
1182002 | 1182002 | 2021-04-02 | Rensselaer | New York | 36083 | 10091 | 133 |
1178755 | 1178755 | 2021-04-01 | Rensselaer | New York | 36083 | 10053 | 133 |
1175508 | 1175508 | 2021-03-31 | Rensselaer | New York | 36083 | 10004 | 133 |
1172261 | 1172261 | 2021-03-30 | Rensselaer | New York | 36083 | 9973 | 133 |
1169014 | 1169014 | 2021-03-29 | Rensselaer | New York | 36083 | 9931 | 133 |
1165766 | 1165766 | 2021-03-28 | Rensselaer | New York | 36083 | 9901 | 133 |
1162518 | 1162518 | 2021-03-27 | Rensselaer | New York | 36083 | 9856 | 133 |
1159269 | 1159269 | 2021-03-26 | Rensselaer | New York | 36083 | 9824 | 133 |
1156022 | 1156022 | 2021-03-25 | Rensselaer | New York | 36083 | 9777 | 133 |
1152775 | 1152775 | 2021-03-24 | Rensselaer | New York | 36083 | 9739 | 133 |
1149528 | 1149528 | 2021-03-23 | Rensselaer | New York | 36083 | 9705 | 133 |
1146281 | 1146281 | 2021-03-22 | Rensselaer | New York | 36083 | 9679 | 133 |
1143034 | 1143034 | 2021-03-21 | Rensselaer | New York | 36083 | 9657 | 133 |
1139787 | 1139787 | 2021-03-20 | Rensselaer | New York | 36083 | 9625 | 133 |
1136541 | 1136541 | 2021-03-19 | Rensselaer | New York | 36083 | 9601 | 133 |
1133295 | 1133295 | 2021-03-18 | Rensselaer | New York | 36083 | 9570 | 133 |
1130047 | 1130047 | 2021-03-17 | Rensselaer | New York | 36083 | 9531 | 133 |
974253 | 974253 | 2021-01-28 | Steuben | New York | 36101 | 4914 | 133 |
971008 | 971008 | 2021-01-27 | Steuben | New York | 36101 | 4873 | 133 |
967763 | 967763 | 2021-01-26 | Steuben | New York | 36101 | 4835 | 133 |
760019 | 760019 | 2020-11-23 | Broome | New York | 36007 | 4927 | 133 |
756773 | 756773 | 2020-11-22 | Broome | New York | 36007 | 4859 | 133 |
724316 | 724316 | 2020-11-12 | Albany | New York | 36001 | 4336 | 133 |
711373 | 711373 | 2020-11-08 | Oneida | New York | 36065 | 3082 | 133 |
708129 | 708129 | 2020-11-07 | Oneida | New York | 36065 | 3039 | 133 |
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);