ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-11-22" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Albany 1
- Allegany 1
- Broome 1
- Cattaraugus 1
- Cayuga 1
- Chautauqua 1
- Chemung 1
- Chenango 1
- Clinton 1
- Columbia 1
- Cortland 1
- Delaware 1
- Dutchess 1
- Erie 1
- Essex 1
- Franklin 1
- Fulton 1
- Genesee 1
- Greene 1
- Hamilton 1
- Herkimer 1
- Jefferson 1
- Lewis 1
- Livingston 1
- Madison 1
- Monroe 1
- Montgomery 1
- Nassau 1
- New York City 1
- Niagara 1
- …
state 1
- New York · 58 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1941942 | 1941942 | 2021-11-22 | Albany | New York | 36001 | 33612 | 407 |
1941943 | 1941943 | 2021-11-22 | Allegany | New York | 36003 | 5765 | 118 |
1941944 | 1941944 | 2021-11-22 | Broome | New York | 36007 | 27542 | 430 |
1941945 | 1941945 | 2021-11-22 | Cattaraugus | New York | 36009 | 9532 | 149 |
1941946 | 1941946 | 2021-11-22 | Cayuga | New York | 36011 | 9494 | 112 |
1941947 | 1941947 | 2021-11-22 | Chautauqua | New York | 36013 | 14290 | 187 |
1941948 | 1941948 | 2021-11-22 | Chemung | New York | 36015 | 12445 | 171 |
1941949 | 1941949 | 2021-11-22 | Chenango | New York | 36017 | 5367 | 94 |
1941950 | 1941950 | 2021-11-22 | Clinton | New York | 36019 | 7806 | 44 |
1941951 | 1941951 | 2021-11-22 | Columbia | New York | 36021 | 5531 | 113 |
1941952 | 1941952 | 2021-11-22 | Cortland | New York | 36023 | 5974 | 87 |
1941953 | 1941953 | 2021-11-22 | Delaware | New York | 36025 | 4211 | 51 |
1941954 | 1941954 | 2021-11-22 | Dutchess | New York | 36027 | 37434 | 506 |
1941955 | 1941955 | 2021-11-22 | Erie | New York | 36029 | 120085 | 2022 |
1941956 | 1941956 | 2021-11-22 | Essex | New York | 36031 | 2890 | 37 |
1941957 | 1941957 | 2021-11-22 | Franklin | New York | 36033 | 5160 | 25 |
1941958 | 1941958 | 2021-11-22 | Fulton | New York | 36035 | 7572 | 109 |
1941959 | 1941959 | 2021-11-22 | Genesee | New York | 36037 | 8283 | 142 |
1941960 | 1941960 | 2021-11-22 | Greene | New York | 36039 | 4787 | 88 |
1941961 | 1941961 | 2021-11-22 | Hamilton | New York | 36041 | 506 | 3 |
1941962 | 1941962 | 2021-11-22 | Herkimer | New York | 36043 | 8007 | 140 |
1941963 | 1941963 | 2021-11-22 | Jefferson | New York | 36045 | 10839 | 105 |
1941964 | 1941964 | 2021-11-22 | Lewis | New York | 36049 | 4045 | 39 |
1941965 | 1941965 | 2021-11-22 | Livingston | New York | 36051 | 6905 | 74 |
1941966 | 1941966 | 2021-11-22 | Madison | New York | 36053 | 7118 | 108 |
1941967 | 1941967 | 2021-11-22 | Monroe | New York | 36055 | 94695 | 1239 |
1941968 | 1941968 | 2021-11-22 | Montgomery | New York | 36057 | 6936 | 159 |
1941969 | 1941969 | 2021-11-22 | Nassau | New York | 36059 | 222638 | 3323 |
1941970 | 1941970 | 2021-11-22 | New York City | New York | 1147379 | 34747 | |
1941971 | 1941971 | 2021-11-22 | Niagara | New York | 36063 | 27501 | 413 |
1941972 | 1941972 | 2021-11-22 | Oneida | New York | 36065 | 32143 | 629 |
1941973 | 1941973 | 2021-11-22 | Onondaga | New York | 36067 | 57914 | 806 |
1941974 | 1941974 | 2021-11-22 | Ontario | New York | 36069 | 11219 | 116 |
1941975 | 1941975 | 2021-11-22 | Orange | New York | 36071 | 61012 | 796 |
1941976 | 1941976 | 2021-11-22 | Orleans | New York | 36073 | 5271 | 95 |
1941977 | 1941977 | 2021-11-22 | Oswego | New York | 36075 | 13628 | 132 |
1941978 | 1941978 | 2021-11-22 | Otsego | New York | 36077 | 5146 | 61 |
1941979 | 1941979 | 2021-11-22 | Putnam | New York | 36079 | 12954 | 101 |
1941980 | 1941980 | 2021-11-22 | Rensselaer | New York | 36083 | 16790 | 190 |
1941981 | 1941981 | 2021-11-22 | Rockland | New York | 36087 | 54921 | 782 |
1941982 | 1941982 | 2021-11-22 | Saratoga | New York | 36091 | 23523 | 220 |
1941983 | 1941983 | 2021-11-22 | Schenectady | New York | 36093 | 18769 | 237 |
1941984 | 1941984 | 2021-11-22 | Schoharie | New York | 36095 | 2573 | 24 |
1941985 | 1941985 | 2021-11-22 | Schuyler | New York | 36097 | 1842 | 20 |
1941986 | 1941986 | 2021-11-22 | Seneca | New York | 36099 | 3082 | 66 |
1941987 | 1941987 | 2021-11-22 | St. Lawrence | New York | 36089 | 12358 | 142 |
1941988 | 1941988 | 2021-11-22 | Steuben | New York | 36101 | 11959 | 186 |
1941989 | 1941989 | 2021-11-22 | Suffolk | New York | 36103 | 251064 | 3669 |
1941990 | 1941990 | 2021-11-22 | Sullivan | New York | 36105 | 9249 | 89 |
1941991 | 1941991 | 2021-11-22 | Tioga | New York | 36107 | 6155 | 73 |
1941992 | 1941992 | 2021-11-22 | Tompkins | New York | 36109 | 7189 | 61 |
1941993 | 1941993 | 2021-11-22 | Ulster | New York | 36111 | 18592 | 287 |
1941994 | 1941994 | 2021-11-22 | Warren | New York | 36113 | 6877 | 93 |
1941995 | 1941995 | 2021-11-22 | Washington | New York | 36115 | 6257 | 74 |
1941996 | 1941996 | 2021-11-22 | Wayne | New York | 36117 | 9779 | 100 |
1941997 | 1941997 | 2021-11-22 | Westchester | New York | 36119 | 146871 | 2354 |
1941998 | 1941998 | 2021-11-22 | Wyoming | New York | 36121 | 5055 | 63 |
1941999 | 1941999 | 2021-11-22 | Yates | New York | 36123 | 1924 | 33 |
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);