ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where deaths = 154 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 19
county 19
- Allegany 52
- Rensselaer 17
- Dutchess 9
- Saratoga 8
- Fulton 5
- Albany 2
- Cattaraugus 2
- Chautauqua 2
- Ontario 2
- Wayne 2
- Chemung 1
- Genesee 1
- Herkimer 1
- Monroe 1
- Montgomery 1
- Oneida 1
- Oswego 1
- Steuben 1
- Ulster 1
state 1
- New York · 110 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498171 | 2498171 | 2022-05-12 | Allegany | New York | 36003 | 9275 | 154 |
2494913 | 2494913 | 2022-05-11 | Allegany | New York | 36003 | 9258 | 154 |
2491655 | 2491655 | 2022-05-10 | Allegany | New York | 36003 | 9243 | 154 |
2488397 | 2488397 | 2022-05-09 | Allegany | New York | 36003 | 9234 | 154 |
2485140 | 2485140 | 2022-05-08 | Allegany | New York | 36003 | 9226 | 154 |
2481882 | 2481882 | 2022-05-07 | Allegany | New York | 36003 | 9212 | 154 |
2478624 | 2478624 | 2022-05-06 | Allegany | New York | 36003 | 9185 | 154 |
2475366 | 2475366 | 2022-05-05 | Allegany | New York | 36003 | 9168 | 154 |
2472109 | 2472109 | 2022-05-04 | Allegany | New York | 36003 | 9147 | 154 |
2468853 | 2468853 | 2022-05-03 | Allegany | New York | 36003 | 9123 | 154 |
2465597 | 2465597 | 2022-05-02 | Allegany | New York | 36003 | 9109 | 154 |
2462342 | 2462342 | 2022-05-01 | Allegany | New York | 36003 | 9108 | 154 |
2459086 | 2459086 | 2022-04-30 | Allegany | New York | 36003 | 9100 | 154 |
2455830 | 2455830 | 2022-04-29 | Allegany | New York | 36003 | 9091 | 154 |
2452574 | 2452574 | 2022-04-28 | Allegany | New York | 36003 | 9077 | 154 |
2449318 | 2449318 | 2022-04-27 | Allegany | New York | 36003 | 9063 | 154 |
2446061 | 2446061 | 2022-04-26 | Allegany | New York | 36003 | 9054 | 154 |
2442806 | 2442806 | 2022-04-25 | Allegany | New York | 36003 | 9053 | 154 |
2439550 | 2439550 | 2022-04-24 | Allegany | New York | 36003 | 9047 | 154 |
2436294 | 2436294 | 2022-04-23 | Allegany | New York | 36003 | 9037 | 154 |
2433038 | 2433038 | 2022-04-22 | Allegany | New York | 36003 | 9027 | 154 |
2429782 | 2429782 | 2022-04-21 | Allegany | New York | 36003 | 9015 | 154 |
2426526 | 2426526 | 2022-04-20 | Allegany | New York | 36003 | 9004 | 154 |
2423270 | 2423270 | 2022-04-19 | Allegany | New York | 36003 | 8999 | 154 |
2420013 | 2420013 | 2022-04-18 | Allegany | New York | 36003 | 8988 | 154 |
2416758 | 2416758 | 2022-04-17 | Allegany | New York | 36003 | 8986 | 154 |
2413502 | 2413502 | 2022-04-16 | Allegany | New York | 36003 | 8984 | 154 |
2410246 | 2410246 | 2022-04-15 | Allegany | New York | 36003 | 8972 | 154 |
2406990 | 2406990 | 2022-04-14 | Allegany | New York | 36003 | 8966 | 154 |
2403734 | 2403734 | 2022-04-13 | Allegany | New York | 36003 | 8959 | 154 |
2400479 | 2400479 | 2022-04-12 | Allegany | New York | 36003 | 8955 | 154 |
2397224 | 2397224 | 2022-04-11 | Allegany | New York | 36003 | 8955 | 154 |
2393969 | 2393969 | 2022-04-10 | Allegany | New York | 36003 | 8954 | 154 |
2390713 | 2390713 | 2022-04-09 | Allegany | New York | 36003 | 8952 | 154 |
2387457 | 2387457 | 2022-04-08 | Allegany | New York | 36003 | 8948 | 154 |
2384202 | 2384202 | 2022-04-07 | Allegany | New York | 36003 | 8938 | 154 |
2380947 | 2380947 | 2022-04-06 | Allegany | New York | 36003 | 8931 | 154 |
2377692 | 2377692 | 2022-04-05 | Allegany | New York | 36003 | 8929 | 154 |
2374439 | 2374439 | 2022-04-04 | Allegany | New York | 36003 | 8929 | 154 |
2371187 | 2371187 | 2022-04-03 | Allegany | New York | 36003 | 8927 | 154 |
2367934 | 2367934 | 2022-04-02 | Allegany | New York | 36003 | 8926 | 154 |
2364681 | 2364681 | 2022-04-01 | Allegany | New York | 36003 | 8923 | 154 |
2361427 | 2361427 | 2022-03-31 | Allegany | New York | 36003 | 8914 | 154 |
2358173 | 2358173 | 2022-03-30 | Allegany | New York | 36003 | 8910 | 154 |
2354919 | 2354919 | 2022-03-29 | Allegany | New York | 36003 | 8907 | 154 |
2351666 | 2351666 | 2022-03-28 | Allegany | New York | 36003 | 8907 | 154 |
2348414 | 2348414 | 2022-03-27 | Allegany | New York | 36003 | 8903 | 154 |
2345161 | 2345161 | 2022-03-26 | Allegany | New York | 36003 | 8899 | 154 |
2341908 | 2341908 | 2022-03-25 | Allegany | New York | 36003 | 8896 | 154 |
2338655 | 2338655 | 2022-03-24 | Allegany | New York | 36003 | 8891 | 154 |
2335401 | 2335401 | 2022-03-23 | Allegany | New York | 36003 | 8886 | 154 |
2332147 | 2332147 | 2022-03-22 | Allegany | New York | 36003 | 8878 | 154 |
2185815 | 2185815 | 2022-02-05 | Fulton | New York | 36035 | 11857 | 154 |
2182563 | 2182563 | 2022-02-04 | Fulton | New York | 36035 | 11828 | 154 |
2179311 | 2179311 | 2022-02-03 | Fulton | New York | 36035 | 11793 | 154 |
2176060 | 2176060 | 2022-02-02 | Fulton | New York | 36035 | 11740 | 154 |
2172807 | 2172807 | 2022-02-01 | Fulton | New York | 36035 | 11689 | 154 |
2166337 | 2166337 | 2022-01-30 | Wayne | New York | 36117 | 16110 | 154 |
2163082 | 2163082 | 2022-01-29 | Wayne | New York | 36117 | 16052 | 154 |
2114262 | 2114262 | 2022-01-14 | Ontario | New York | 36069 | 16644 | 154 |
2111010 | 2111010 | 2022-01-13 | Ontario | New York | 36069 | 16385 | 154 |
2107761 | 2107761 | 2022-01-12 | Oswego | New York | 36075 | 20002 | 154 |
2052477 | 2052477 | 2021-12-26 | Genesee | New York | 36037 | 9903 | 154 |
2042730 | 2042730 | 2021-12-23 | Herkimer | New York | 36043 | 9649 | 154 |
1954949 | 1954949 | 2021-11-26 | Cattaraugus | New York | 36009 | 9824 | 154 |
1951698 | 1951698 | 2021-11-25 | Cattaraugus | New York | 36009 | 9777 | 154 |
1893220 | 1893220 | 2021-11-07 | Montgomery | New York | 36057 | 6387 | 154 |
1831464 | 1831464 | 2021-10-19 | Chemung | New York | 36015 | 10798 | 154 |
1747021 | 1747021 | 2021-09-23 | Rensselaer | New York | 36083 | 13364 | 154 |
1743772 | 1743772 | 2021-09-22 | Rensselaer | New York | 36083 | 13319 | 154 |
1740523 | 1740523 | 2021-09-21 | Rensselaer | New York | 36083 | 13276 | 154 |
1737274 | 1737274 | 2021-09-20 | Rensselaer | New York | 36083 | 13209 | 154 |
1734024 | 1734024 | 2021-09-19 | Rensselaer | New York | 36083 | 13180 | 154 |
1730774 | 1730774 | 2021-09-18 | Rensselaer | New York | 36083 | 13126 | 154 |
1727491 | 1727491 | 2021-09-17 | Chautauqua | New York | 36013 | 10622 | 154 |
1727524 | 1727524 | 2021-09-17 | Rensselaer | New York | 36083 | 13084 | 154 |
1724242 | 1724242 | 2021-09-16 | Chautauqua | New York | 36013 | 10537 | 154 |
1724275 | 1724275 | 2021-09-16 | Rensselaer | New York | 36083 | 13038 | 154 |
1721026 | 1721026 | 2021-09-15 | Rensselaer | New York | 36083 | 12971 | 154 |
1721034 | 1721034 | 2021-09-15 | Steuben | New York | 36101 | 8053 | 154 |
1717778 | 1717778 | 2021-09-14 | Rensselaer | New York | 36083 | 12944 | 154 |
1714530 | 1714530 | 2021-09-13 | Rensselaer | New York | 36083 | 12913 | 154 |
1711284 | 1711284 | 2021-09-12 | Rensselaer | New York | 36083 | 12874 | 154 |
1708037 | 1708037 | 2021-09-11 | Rensselaer | New York | 36083 | 12838 | 154 |
1704790 | 1704790 | 2021-09-10 | Rensselaer | New York | 36083 | 12780 | 154 |
1701540 | 1701540 | 2021-09-09 | Rensselaer | New York | 36083 | 12738 | 154 |
1698291 | 1698291 | 2021-09-08 | Rensselaer | New York | 36083 | 12694 | 154 |
1695043 | 1695043 | 2021-09-07 | Rensselaer | New York | 36083 | 12667 | 154 |
1169016 | 1169016 | 2021-03-29 | Saratoga | New York | 36091 | 13275 | 154 |
1165768 | 1165768 | 2021-03-28 | Saratoga | New York | 36091 | 13217 | 154 |
1162520 | 1162520 | 2021-03-27 | Saratoga | New York | 36091 | 13162 | 154 |
1159271 | 1159271 | 2021-03-26 | Saratoga | New York | 36091 | 13101 | 154 |
1156024 | 1156024 | 2021-03-25 | Saratoga | New York | 36091 | 13034 | 154 |
1152777 | 1152777 | 2021-03-24 | Saratoga | New York | 36091 | 12973 | 154 |
1149530 | 1149530 | 2021-03-23 | Saratoga | New York | 36091 | 12924 | 154 |
1146283 | 1146283 | 2021-03-22 | Saratoga | New York | 36091 | 12870 | 154 |
906109 | 906109 | 2021-01-07 | Ulster | New York | 36111 | 6417 | 154 |
802203 | 802203 | 2020-12-06 | Albany | New York | 36001 | 6711 | 154 |
786008 | 786008 | 2020-12-01 | Oneida | New York | 36065 | 5084 | 154 |
533037 | 533037 | 2020-09-14 | Dutchess | New York | 36027 | 4994 | 154 |
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);