ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-11-23" 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 |
---|---|---|---|---|---|---|---|
1945193 | 1945193 | 2021-11-23 | Albany | New York | 36001 | 33672 | 407 |
1945194 | 1945194 | 2021-11-23 | Allegany | New York | 36003 | 5795 | 118 |
1945195 | 1945195 | 2021-11-23 | Broome | New York | 36007 | 27611 | 431 |
1945196 | 1945196 | 2021-11-23 | Cattaraugus | New York | 36009 | 9584 | 151 |
1945197 | 1945197 | 2021-11-23 | Cayuga | New York | 36011 | 9516 | 112 |
1945198 | 1945198 | 2021-11-23 | Chautauqua | New York | 36013 | 14349 | 188 |
1945199 | 1945199 | 2021-11-23 | Chemung | New York | 36015 | 12482 | 171 |
1945200 | 1945200 | 2021-11-23 | Chenango | New York | 36017 | 5398 | 95 |
1945201 | 1945201 | 2021-11-23 | Clinton | New York | 36019 | 7827 | 45 |
1945202 | 1945202 | 2021-11-23 | Columbia | New York | 36021 | 5548 | 113 |
1945203 | 1945203 | 2021-11-23 | Cortland | New York | 36023 | 5983 | 88 |
1945204 | 1945204 | 2021-11-23 | Delaware | New York | 36025 | 4225 | 51 |
1945205 | 1945205 | 2021-11-23 | Dutchess | New York | 36027 | 37487 | 506 |
1945206 | 1945206 | 2021-11-23 | Erie | New York | 36029 | 120684 | 2024 |
1945207 | 1945207 | 2021-11-23 | Essex | New York | 36031 | 2898 | 37 |
1945208 | 1945208 | 2021-11-23 | Franklin | New York | 36033 | 5191 | 25 |
1945209 | 1945209 | 2021-11-23 | Fulton | New York | 36035 | 7602 | 109 |
1945210 | 1945210 | 2021-11-23 | Genesee | New York | 36037 | 8322 | 142 |
1945211 | 1945211 | 2021-11-23 | Greene | New York | 36039 | 4818 | 88 |
1945212 | 1945212 | 2021-11-23 | Hamilton | New York | 36041 | 507 | 3 |
1945213 | 1945213 | 2021-11-23 | Herkimer | New York | 36043 | 8045 | 140 |
1945214 | 1945214 | 2021-11-23 | Jefferson | New York | 36045 | 10919 | 105 |
1945215 | 1945215 | 2021-11-23 | Lewis | New York | 36049 | 4066 | 39 |
1945216 | 1945216 | 2021-11-23 | Livingston | New York | 36051 | 6936 | 74 |
1945217 | 1945217 | 2021-11-23 | Madison | New York | 36053 | 7146 | 108 |
1945218 | 1945218 | 2021-11-23 | Monroe | New York | 36055 | 95017 | 1241 |
1945219 | 1945219 | 2021-11-23 | Montgomery | New York | 36057 | 6966 | 159 |
1945220 | 1945220 | 2021-11-23 | Nassau | New York | 36059 | 222982 | 3324 |
1945221 | 1945221 | 2021-11-23 | New York City | New York | 1148868 | 34757 | |
1945222 | 1945222 | 2021-11-23 | Niagara | New York | 36063 | 27685 | 413 |
1945223 | 1945223 | 2021-11-23 | Oneida | New York | 36065 | 32265 | 634 |
1945224 | 1945224 | 2021-11-23 | Onondaga | New York | 36067 | 58070 | 806 |
1945225 | 1945225 | 2021-11-23 | Ontario | New York | 36069 | 11292 | 117 |
1945226 | 1945226 | 2021-11-23 | Orange | New York | 36071 | 61112 | 796 |
1945227 | 1945227 | 2021-11-23 | Orleans | New York | 36073 | 5294 | 95 |
1945228 | 1945228 | 2021-11-23 | Oswego | New York | 36075 | 13702 | 132 |
1945229 | 1945229 | 2021-11-23 | Otsego | New York | 36077 | 5171 | 61 |
1945230 | 1945230 | 2021-11-23 | Putnam | New York | 36079 | 12972 | 101 |
1945231 | 1945231 | 2021-11-23 | Rensselaer | New York | 36083 | 16851 | 190 |
1945232 | 1945232 | 2021-11-23 | Rockland | New York | 36087 | 54984 | 782 |
1945233 | 1945233 | 2021-11-23 | Saratoga | New York | 36091 | 23660 | 220 |
1945234 | 1945234 | 2021-11-23 | Schenectady | New York | 36093 | 18813 | 239 |
1945235 | 1945235 | 2021-11-23 | Schoharie | New York | 36095 | 2589 | 24 |
1945236 | 1945236 | 2021-11-23 | Schuyler | New York | 36097 | 1851 | 20 |
1945237 | 1945237 | 2021-11-23 | Seneca | New York | 36099 | 3094 | 67 |
1945238 | 1945238 | 2021-11-23 | St. Lawrence | New York | 36089 | 12390 | 142 |
1945239 | 1945239 | 2021-11-23 | Steuben | New York | 36101 | 11998 | 186 |
1945240 | 1945240 | 2021-11-23 | Suffolk | New York | 36103 | 251472 | 3670 |
1945241 | 1945241 | 2021-11-23 | Sullivan | New York | 36105 | 9277 | 89 |
1945242 | 1945242 | 2021-11-23 | Tioga | New York | 36107 | 6166 | 73 |
1945243 | 1945243 | 2021-11-23 | Tompkins | New York | 36109 | 7215 | 61 |
1945244 | 1945244 | 2021-11-23 | Ulster | New York | 36111 | 18629 | 287 |
1945245 | 1945245 | 2021-11-23 | Warren | New York | 36113 | 6919 | 94 |
1945246 | 1945246 | 2021-11-23 | Washington | New York | 36115 | 6309 | 74 |
1945247 | 1945247 | 2021-11-23 | Wayne | New York | 36117 | 9834 | 101 |
1945248 | 1945248 | 2021-11-23 | Westchester | New York | 36119 | 147018 | 2354 |
1945249 | 1945249 | 2021-11-23 | Wyoming | New York | 36121 | 5076 | 63 |
1945250 | 1945250 | 2021-11-23 | Yates | New York | 36123 | 1932 | 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);