ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2022-02-07 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
2192306 | 2192306 | 2022-02-07 | Albany | New York | 36001 | 56760 | 490 |
2192307 | 2192307 | 2022-02-07 | Allegany | New York | 36003 | 8504 | 145 |
2192308 | 2192308 | 2022-02-07 | Broome | New York | 36007 | 43083 | 497 |
2192309 | 2192309 | 2022-02-07 | Cattaraugus | New York | 36009 | 14756 | 208 |
2192310 | 2192310 | 2022-02-07 | Cayuga | New York | 36011 | 15241 | 136 |
2192311 | 2192311 | 2022-02-07 | Chautauqua | New York | 36013 | 22830 | 265 |
2192312 | 2192312 | 2022-02-07 | Chemung | New York | 36015 | 20474 | 221 |
2192313 | 2192313 | 2022-02-07 | Chenango | New York | 36017 | 8820 | 115 |
2192314 | 2192314 | 2022-02-07 | Clinton | New York | 36019 | 15424 | 73 |
2192315 | 2192315 | 2022-02-07 | Columbia | New York | 36021 | 9594 | 136 |
2192316 | 2192316 | 2022-02-07 | Cortland | New York | 36023 | 10004 | 110 |
2192317 | 2192317 | 2022-02-07 | Delaware | New York | 36025 | 7367 | 68 |
2192318 | 2192318 | 2022-02-07 | Dutchess | New York | 36027 | 62287 | 625 |
2192319 | 2192319 | 2022-02-07 | Erie | New York | 36029 | 202610 | 2506 |
2192320 | 2192320 | 2022-02-07 | Essex | New York | 36031 | 5238 | 52 |
2192321 | 2192321 | 2022-02-07 | Franklin | New York | 36033 | 8650 | 40 |
2192322 | 2192322 | 2022-02-07 | Fulton | New York | 36035 | 11921 | 156 |
2192323 | 2192323 | 2022-02-07 | Genesee | New York | 36037 | 13323 | 180 |
2192324 | 2192324 | 2022-02-07 | Greene | New York | 36039 | 8252 | 115 |
2192325 | 2192325 | 2022-02-07 | Hamilton | New York | 36041 | 804 | 5 |
2192326 | 2192326 | 2022-02-07 | Herkimer | New York | 36043 | 13219 | 183 |
2192327 | 2192327 | 2022-02-07 | Jefferson | New York | 36045 | 18948 | 126 |
2192328 | 2192328 | 2022-02-07 | Lewis | New York | 36049 | 5967 | 46 |
2192329 | 2192329 | 2022-02-07 | Livingston | New York | 36051 | 11206 | 106 |
2192330 | 2192330 | 2022-02-07 | Madison | New York | 36053 | 12316 | 122 |
2192331 | 2192331 | 2022-02-07 | Monroe | New York | 36055 | 147112 | 1503 |
2192332 | 2192332 | 2022-02-07 | Montgomery | New York | 36057 | 11334 | 191 |
2192333 | 2192333 | 2022-02-07 | Nassau | New York | 36059 | 394261 | 3754 |
2192334 | 2192334 | 2022-02-07 | New York City | New York | 2252531 | 38876 | |
2192335 | 2192335 | 2022-02-07 | Niagara | New York | 36063 | 46440 | 543 |
2192336 | 2192336 | 2022-02-07 | Oneida | New York | 36065 | 50904 | 752 |
2192337 | 2192337 | 2022-02-07 | Onondaga | New York | 36067 | 104107 | 989 |
2192338 | 2192338 | 2022-02-07 | Ontario | New York | 36069 | 18937 | 166 |
2192339 | 2192339 | 2022-02-07 | Orange | New York | 36071 | 104059 | 924 |
2192340 | 2192340 | 2022-02-07 | Orleans | New York | 36073 | 8388 | 108 |
2192341 | 2192341 | 2022-02-07 | Oswego | New York | 36075 | 23922 | 165 |
2192342 | 2192342 | 2022-02-07 | Otsego | New York | 36077 | 9305 | 82 |
2192343 | 2192343 | 2022-02-07 | Putnam | New York | 36079 | 22993 | 120 |
2192344 | 2192344 | 2022-02-07 | Rensselaer | New York | 36083 | 30058 | 239 |
2192345 | 2192345 | 2022-02-07 | Rockland | New York | 36087 | 90239 | 884 |
2192346 | 2192346 | 2022-02-07 | Saratoga | New York | 36091 | 43946 | 313 |
2192347 | 2192347 | 2022-02-07 | Schenectady | New York | 36093 | 31597 | 287 |
2192348 | 2192348 | 2022-02-07 | Schoharie | New York | 36095 | 4768 | 34 |
2192349 | 2192349 | 2022-02-07 | Schuyler | New York | 36097 | 3275 | 23 |
2192350 | 2192350 | 2022-02-07 | Seneca | New York | 36099 | 5558 | 89 |
2192351 | 2192351 | 2022-02-07 | St. Lawrence | New York | 36089 | 19579 | 170 |
2192352 | 2192352 | 2022-02-07 | Steuben | New York | 36101 | 18911 | 234 |
2192353 | 2192353 | 2022-02-07 | Suffolk | New York | 36103 | 418796 | 4267 |
2192354 | 2192354 | 2022-02-07 | Sullivan | New York | 36105 | 17830 | 122 |
2192355 | 2192355 | 2022-02-07 | Tioga | New York | 36107 | 10212 | 81 |
2192356 | 2192356 | 2022-02-07 | Tompkins | New York | 36109 | 16721 | 79 |
2192357 | 2192357 | 2022-02-07 | Ulster | New York | 36111 | 30137 | 350 |
2192358 | 2192358 | 2022-02-07 | Warren | New York | 36113 | 12873 | 117 |
2192359 | 2192359 | 2022-02-07 | Washington | New York | 36115 | 11512 | 108 |
2192360 | 2192360 | 2022-02-07 | Wayne | New York | 36117 | 16465 | 160 |
2192361 | 2192361 | 2022-02-07 | Westchester | New York | 36119 | 243877 | 2643 |
2192362 | 2192362 | 2022-02-07 | Wyoming | New York | 36121 | 8092 | 81 |
2192363 | 2192363 | 2022-02-07 | Yates | New York | 36123 | 3193 | 37 |
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);