ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where deaths = 78 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 29
county 29
- Greene 16
- Chenango 10
- Broome 8
- Tioga 8
- Wayne 8
- Clinton 6
- Orleans 6
- Jefferson 4
- Madison 4
- Warren 4
- Allegany 3
- Otsego 3
- Sullivan 3
- Schenectady 2
- Wyoming 2
- Cattaraugus 1
- Cayuga 1
- Chemung 1
- Cortland 1
- Livingston 1
- Monroe 1
- Montgomery 1
- Oneida 1
- Oswego 1
- Rensselaer 1
- Saratoga 1
- Seneca 1
- Steuben 1
- Washington 1
state 1
- New York · 101 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2234592 | 2234592 | 2022-02-20 | Clinton | New York | 36019 | 16100 | 78 |
2231341 | 2231341 | 2022-02-19 | Clinton | New York | 36019 | 16066 | 78 |
2228090 | 2228090 | 2022-02-18 | Clinton | New York | 36019 | 16034 | 78 |
2224839 | 2224839 | 2022-02-17 | Clinton | New York | 36019 | 15981 | 78 |
2221588 | 2221588 | 2022-02-16 | Clinton | New York | 36019 | 15914 | 78 |
2218337 | 2218337 | 2022-02-15 | Clinton | New York | 36019 | 15882 | 78 |
2150049 | 2150049 | 2022-01-25 | Otsego | New York | 36077 | 8797 | 78 |
2146797 | 2146797 | 2022-01-24 | Otsego | New York | 36077 | 8754 | 78 |
2143543 | 2143543 | 2022-01-23 | Otsego | New York | 36077 | 8713 | 78 |
2143563 | 2143563 | 2022-01-23 | Wyoming | New York | 36121 | 7767 | 78 |
2140308 | 2140308 | 2022-01-22 | Wyoming | New York | 36121 | 7717 | 78 |
2078511 | 2078511 | 2022-01-03 | Tioga | New York | 36107 | 7873 | 78 |
2075260 | 2075260 | 2022-01-02 | Tioga | New York | 36107 | 7827 | 78 |
2072009 | 2072009 | 2022-01-01 | Tioga | New York | 36107 | 7761 | 78 |
2068758 | 2068758 | 2021-12-31 | Tioga | New York | 36107 | 7660 | 78 |
2065507 | 2065507 | 2021-12-30 | Tioga | New York | 36107 | 7585 | 78 |
2062257 | 2062257 | 2021-12-29 | Tioga | New York | 36107 | 7504 | 78 |
2059003 | 2059003 | 2021-12-28 | Seneca | New York | 36099 | 3819 | 78 |
2059008 | 2059008 | 2021-12-28 | Tioga | New York | 36107 | 7416 | 78 |
2055759 | 2055759 | 2021-12-27 | Tioga | New York | 36107 | 7405 | 78 |
1984223 | 1984223 | 2021-12-05 | Livingston | New York | 36051 | 7513 | 78 |
1961501 | 1961501 | 2021-11-28 | Washington | New York | 36115 | 6606 | 78 |
1857474 | 1857474 | 2021-10-27 | Jefferson | New York | 36045 | 9157 | 78 |
1854225 | 1854225 | 2021-10-26 | Jefferson | New York | 36045 | 9086 | 78 |
1850976 | 1850976 | 2021-10-25 | Jefferson | New York | 36045 | 9035 | 78 |
1847726 | 1847726 | 2021-10-24 | Jefferson | New York | 36045 | 9003 | 78 |
1818472 | 1818472 | 2021-10-15 | Cortland | New York | 36023 | 5237 | 78 |
1766527 | 1766527 | 2021-09-29 | Warren | New York | 36113 | 4852 | 78 |
1763278 | 1763278 | 2021-09-28 | Warren | New York | 36113 | 4815 | 78 |
1763280 | 1763280 | 2021-09-28 | Wayne | New York | 36117 | 7195 | 78 |
1760029 | 1760029 | 2021-09-27 | Warren | New York | 36113 | 4797 | 78 |
1760031 | 1760031 | 2021-09-27 | Wayne | New York | 36117 | 7167 | 78 |
1756781 | 1756781 | 2021-09-26 | Warren | New York | 36113 | 4784 | 78 |
1756783 | 1756783 | 2021-09-26 | Wayne | New York | 36117 | 7128 | 78 |
1753535 | 1753535 | 2021-09-25 | Wayne | New York | 36117 | 7099 | 78 |
1750287 | 1750287 | 2021-09-24 | Wayne | New York | 36117 | 7043 | 78 |
1747037 | 1747037 | 2021-09-23 | Wayne | New York | 36117 | 7013 | 78 |
1743788 | 1743788 | 2021-09-22 | Wayne | New York | 36117 | 6973 | 78 |
1740539 | 1740539 | 2021-09-21 | Wayne | New York | 36117 | 6939 | 78 |
1685305 | 1685305 | 2021-09-04 | Sullivan | New York | 36105 | 7423 | 78 |
1682054 | 1682054 | 2021-09-03 | Sullivan | New York | 36105 | 7397 | 78 |
1678805 | 1678805 | 2021-09-02 | Sullivan | New York | 36105 | 7373 | 78 |
1630039 | 1630039 | 2021-08-18 | Chenango | New York | 36017 | 3726 | 78 |
1626792 | 1626792 | 2021-08-17 | Chenango | New York | 36017 | 3713 | 78 |
1623545 | 1623545 | 2021-08-16 | Chenango | New York | 36017 | 3705 | 78 |
1620298 | 1620298 | 2021-08-15 | Chenango | New York | 36017 | 3694 | 78 |
1617050 | 1617050 | 2021-08-14 | Chenango | New York | 36017 | 3684 | 78 |
1613802 | 1613802 | 2021-08-13 | Chenango | New York | 36017 | 3672 | 78 |
1610553 | 1610553 | 2021-08-12 | Chenango | New York | 36017 | 3648 | 78 |
1607305 | 1607305 | 2021-08-11 | Chenango | New York | 36017 | 3644 | 78 |
1604056 | 1604056 | 2021-08-10 | Chenango | New York | 36017 | 3630 | 78 |
1600807 | 1600807 | 2021-08-09 | Chenango | New York | 36017 | 3621 | 78 |
1383293 | 1383293 | 2021-06-03 | Greene | New York | 36039 | 3398 | 78 |
1380047 | 1380047 | 2021-06-02 | Greene | New York | 36039 | 3398 | 78 |
1376802 | 1376802 | 2021-06-01 | Greene | New York | 36039 | 3398 | 78 |
1373556 | 1373556 | 2021-05-31 | Greene | New York | 36039 | 3398 | 78 |
1370311 | 1370311 | 2021-05-30 | Greene | New York | 36039 | 3397 | 78 |
1367065 | 1367065 | 2021-05-29 | Greene | New York | 36039 | 3395 | 78 |
1363819 | 1363819 | 2021-05-28 | Greene | New York | 36039 | 3394 | 78 |
1360573 | 1360573 | 2021-05-27 | Greene | New York | 36039 | 3391 | 78 |
1357327 | 1357327 | 2021-05-26 | Greene | New York | 36039 | 3388 | 78 |
1354081 | 1354081 | 2021-05-25 | Greene | New York | 36039 | 3386 | 78 |
1350835 | 1350835 | 2021-05-24 | Greene | New York | 36039 | 3386 | 78 |
1347589 | 1347589 | 2021-05-23 | Greene | New York | 36039 | 3383 | 78 |
1344341 | 1344341 | 2021-05-22 | Greene | New York | 36039 | 3382 | 78 |
1341093 | 1341093 | 2021-05-21 | Greene | New York | 36039 | 3381 | 78 |
1337845 | 1337845 | 2021-05-20 | Greene | New York | 36039 | 3378 | 78 |
1334598 | 1334598 | 2021-05-19 | Greene | New York | 36039 | 3377 | 78 |
1110533 | 1110533 | 2021-03-11 | Cattaraugus | New York | 36009 | 4528 | 78 |
1000210 | 1000210 | 2021-02-05 | Orleans | New York | 36073 | 2281 | 78 |
996964 | 996964 | 2021-02-04 | Orleans | New York | 36073 | 2250 | 78 |
993718 | 993718 | 2021-02-03 | Orleans | New York | 36073 | 2215 | 78 |
990472 | 990472 | 2021-02-02 | Orleans | New York | 36073 | 2190 | 78 |
987226 | 987226 | 2021-02-01 | Orleans | New York | 36073 | 2180 | 78 |
983946 | 983946 | 2021-01-31 | Allegany | New York | 36003 | 2578 | 78 |
983979 | 983979 | 2021-01-31 | Orleans | New York | 36073 | 2173 | 78 |
980699 | 980699 | 2021-01-30 | Allegany | New York | 36003 | 2553 | 78 |
980722 | 980722 | 2021-01-30 | Madison | New York | 36053 | 3458 | 78 |
977453 | 977453 | 2021-01-29 | Allegany | New York | 36003 | 2541 | 78 |
977476 | 977476 | 2021-01-29 | Madison | New York | 36053 | 3426 | 78 |
974231 | 974231 | 2021-01-28 | Madison | New York | 36053 | 3403 | 78 |
970966 | 970966 | 2021-01-27 | Cayuga | New York | 36011 | 4779 | 78 |
970986 | 970986 | 2021-01-27 | Madison | New York | 36053 | 3379 | 78 |
964508 | 964508 | 2021-01-25 | Oswego | New York | 36075 | 5201 | 78 |
958009 | 958009 | 2021-01-23 | Montgomery | New York | 36057 | 2400 | 78 |
935304 | 935304 | 2021-01-16 | Saratoga | New York | 36091 | 8839 | 78 |
876886 | 876886 | 2020-12-29 | Rensselaer | New York | 36083 | 4015 | 78 |
873644 | 873644 | 2020-12-28 | Schenectady | New York | 36093 | 5454 | 78 |
870399 | 870399 | 2020-12-27 | Schenectady | New York | 36093 | 5360 | 78 |
831421 | 831421 | 2020-12-15 | Chemung | New York | 36015 | 3803 | 78 |
753570 | 753570 | 2020-11-21 | Steuben | New York | 36101 | 1525 | 78 |
442523 | 442523 | 2020-08-17 | Broome | New York | 36007 | 1172 | 78 |
439296 | 439296 | 2020-08-16 | Broome | New York | 36007 | 1166 | 78 |
436071 | 436071 | 2020-08-15 | Broome | New York | 36007 | 1165 | 78 |
432845 | 432845 | 2020-08-14 | Broome | New York | 36007 | 1165 | 78 |
429619 | 429619 | 2020-08-13 | Broome | New York | 36007 | 1153 | 78 |
403848 | 403848 | 2020-08-05 | Broome | New York | 36007 | 1082 | 78 |
400630 | 400630 | 2020-08-04 | Broome | New York | 36007 | 1078 | 78 |
397415 | 397415 | 2020-08-03 | Broome | New York | 36007 | 1064 | 78 |
235705 | 235705 | 2020-06-13 | Oneida | New York | 36065 | 1253 | 78 |
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);