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 2021-10-30 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 |
---|---|---|---|---|---|---|---|
1867200 | 1867200 | 2021-10-30 | Albany | New York | 36001 | 31574 | 393 |
1867201 | 1867201 | 2021-10-30 | Allegany | New York | 36003 | 4883 | 101 |
1867202 | 1867202 | 2021-10-30 | Broome | New York | 36007 | 25238 | 410 |
1867203 | 1867203 | 2021-10-30 | Cattaraugus | New York | 36009 | 8163 | 125 |
1867204 | 1867204 | 2021-10-30 | Cayuga | New York | 36011 | 8845 | 107 |
1867205 | 1867205 | 2021-10-30 | Chautauqua | New York | 36013 | 12772 | 178 |
1867206 | 1867206 | 2021-10-30 | Chemung | New York | 36015 | 11315 | 164 |
1867207 | 1867207 | 2021-10-30 | Chenango | New York | 36017 | 4816 | 88 |
1867208 | 1867208 | 2021-10-30 | Clinton | New York | 36019 | 6994 | 41 |
1867209 | 1867209 | 2021-10-30 | Columbia | New York | 36021 | 5118 | 112 |
1867210 | 1867210 | 2021-10-30 | Cortland | New York | 36023 | 5520 | 83 |
1867211 | 1867211 | 2021-10-30 | Delaware | New York | 36025 | 3671 | 48 |
1867212 | 1867212 | 2021-10-30 | Dutchess | New York | 36027 | 36019 | 500 |
1867213 | 1867213 | 2021-10-30 | Erie | New York | 36029 | 109071 | 1968 |
1867214 | 1867214 | 2021-10-30 | Essex | New York | 36031 | 2456 | 35 |
1867215 | 1867215 | 2021-10-30 | Franklin | New York | 36033 | 4462 | 22 |
1867216 | 1867216 | 2021-10-30 | Fulton | New York | 36035 | 6634 | 104 |
1867217 | 1867217 | 2021-10-30 | Genesee | New York | 36037 | 7311 | 132 |
1867218 | 1867218 | 2021-10-30 | Greene | New York | 36039 | 4492 | 87 |
1867219 | 1867219 | 2021-10-30 | Hamilton | New York | 36041 | 457 | 3 |
1867220 | 1867220 | 2021-10-30 | Herkimer | New York | 36043 | 7055 | 131 |
1867221 | 1867221 | 2021-10-30 | Jefferson | New York | 36045 | 9356 | 81 |
1867222 | 1867222 | 2021-10-30 | Lewis | New York | 36049 | 3717 | 39 |
1867223 | 1867223 | 2021-10-30 | Livingston | New York | 36051 | 5935 | 71 |
1867224 | 1867224 | 2021-10-30 | Madison | New York | 36053 | 6418 | 106 |
1867225 | 1867225 | 2021-10-30 | Monroe | New York | 36055 | 86230 | 1198 |
1867226 | 1867226 | 2021-10-30 | Montgomery | New York | 36057 | 6211 | 150 |
1867227 | 1867227 | 2021-10-30 | Nassau | New York | 36059 | 216060 | 3308 |
1867228 | 1867228 | 2021-10-30 | New York City | New York | 1119470 | 34557 | |
1867229 | 1867229 | 2021-10-30 | Niagara | New York | 36063 | 24695 | 400 |
1867230 | 1867230 | 2021-10-30 | Oneida | New York | 36065 | 29334 | 598 |
1867231 | 1867231 | 2021-10-30 | Onondaga | New York | 36067 | 53532 | 771 |
1867232 | 1867232 | 2021-10-30 | Ontario | New York | 36069 | 9627 | 111 |
1867233 | 1867233 | 2021-10-30 | Orange | New York | 36071 | 58280 | 780 |
1867234 | 1867234 | 2021-10-30 | Orleans | New York | 36073 | 4534 | 90 |
1867235 | 1867235 | 2021-10-30 | Oswego | New York | 36075 | 12172 | 119 |
1867236 | 1867236 | 2021-10-30 | Otsego | New York | 36077 | 4717 | 55 |
1867237 | 1867237 | 2021-10-30 | Putnam | New York | 36079 | 12632 | 98 |
1867238 | 1867238 | 2021-10-30 | Rensselaer | New York | 36083 | 15274 | 172 |
1867239 | 1867239 | 2021-10-30 | Rockland | New York | 36087 | 53632 | 780 |
1867240 | 1867240 | 2021-10-30 | Saratoga | New York | 36091 | 20934 | 208 |
1867241 | 1867241 | 2021-10-30 | Schenectady | New York | 36093 | 17259 | 230 |
1867242 | 1867242 | 2021-10-30 | Schoharie | New York | 36095 | 2379 | 23 |
1867243 | 1867243 | 2021-10-30 | Schuyler | New York | 36097 | 1597 | 17 |
1867244 | 1867244 | 2021-10-30 | Seneca | New York | 36099 | 2801 | 63 |
1867245 | 1867245 | 2021-10-30 | St. Lawrence | New York | 36089 | 11026 | 131 |
1867246 | 1867246 | 2021-10-30 | Steuben | New York | 36101 | 10530 | 175 |
1867247 | 1867247 | 2021-10-30 | Suffolk | New York | 36103 | 242050 | 3630 |
1867248 | 1867248 | 2021-10-30 | Sullivan | New York | 36105 | 8649 | 83 |
1867249 | 1867249 | 2021-10-30 | Tioga | New York | 36107 | 5346 | 72 |
1867250 | 1867250 | 2021-10-30 | Tompkins | New York | 36109 | 6662 | 59 |
1867251 | 1867251 | 2021-10-30 | Ulster | New York | 36111 | 17530 | 284 |
1867252 | 1867252 | 2021-10-30 | Warren | New York | 36113 | 5768 | 86 |
1867253 | 1867253 | 2021-10-30 | Washington | New York | 36115 | 4864 | 69 |
1867254 | 1867254 | 2021-10-30 | Wayne | New York | 36117 | 8506 | 87 |
1867255 | 1867255 | 2021-10-30 | Westchester | New York | 36119 | 144342 | 2348 |
1867256 | 1867256 | 2021-10-30 | Wyoming | New York | 36121 | 4488 | 59 |
1867257 | 1867257 | 2021-10-30 | Yates | New York | 36123 | 1713 | 29 |
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);