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 2020-12-18 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 |
---|---|---|---|---|---|---|---|
841152 | 841152 | 2020-12-18 | Albany | New York | 36001 | 8821 | 177 |
841153 | 841153 | 2020-12-18 | Allegany | New York | 36003 | 1502 | 66 |
841154 | 841154 | 2020-12-18 | Broome | New York | 36007 | 6893 | 184 |
841155 | 841155 | 2020-12-18 | Cattaraugus | New York | 36009 | 1976 | 30 |
841156 | 841156 | 2020-12-18 | Cayuga | New York | 36011 | 1884 | 14 |
841157 | 841157 | 2020-12-18 | Chautauqua | New York | 36013 | 2624 | 13 |
841158 | 841158 | 2020-12-18 | Chemung | New York | 36015 | 3991 | 82 |
841159 | 841159 | 2020-12-18 | Chenango | New York | 36017 | 945 | 14 |
841160 | 841160 | 2020-12-18 | Clinton | New York | 36019 | 749 | 5 |
841161 | 841161 | 2020-12-18 | Columbia | New York | 36021 | 1315 | 59 |
841162 | 841162 | 2020-12-18 | Cortland | New York | 36023 | 1655 | 14 |
841163 | 841163 | 2020-12-18 | Delaware | New York | 36025 | 547 | 7 |
841164 | 841164 | 2020-12-18 | Dutchess | New York | 36027 | 9959 | 210 |
841165 | 841165 | 2020-12-18 | Erie | New York | 36029 | 35507 | 1029 |
841166 | 841166 | 2020-12-18 | Essex | New York | 36031 | 430 | 15 |
841167 | 841167 | 2020-12-18 | Franklin | New York | 36033 | 540 | 9 |
841168 | 841168 | 2020-12-18 | Fulton | New York | 36035 | 981 | 29 |
841169 | 841169 | 2020-12-18 | Genesee | New York | 36037 | 1823 | 26 |
841170 | 841170 | 2020-12-18 | Greene | New York | 36039 | 953 | 18 |
841171 | 841171 | 2020-12-18 | Hamilton | New York | 36041 | 77 | 1 |
841172 | 841172 | 2020-12-18 | Herkimer | New York | 36043 | 1367 | 15 |
841173 | 841173 | 2020-12-18 | Jefferson | New York | 36045 | 1216 | 6 |
841174 | 841174 | 2020-12-18 | Lewis | New York | 36049 | 630 | 11 |
841175 | 841175 | 2020-12-18 | Livingston | New York | 36051 | 1318 | 20 |
841176 | 841176 | 2020-12-18 | Madison | New York | 36053 | 1761 | 36 |
841177 | 841177 | 2020-12-18 | Monroe | New York | 36055 | 26390 | 403 |
841178 | 841178 | 2020-12-18 | Montgomery | New York | 36057 | 892 | 24 |
841179 | 841179 | 2020-12-18 | Nassau | New York | 36059 | 74658 | 2314 |
841180 | 841180 | 2020-12-18 | New York City | New York | 377728 | 24652 | |
841181 | 841181 | 2020-12-18 | Niagara | New York | 36063 | 6582 | 152 |
841182 | 841182 | 2020-12-18 | Oneida | New York | 36065 | 8912 | 205 |
841183 | 841183 | 2020-12-18 | Onondaga | New York | 36067 | 16860 | 309 |
841184 | 841184 | 2020-12-18 | Ontario | New York | 36069 | 2367 | 42 |
841185 | 841185 | 2020-12-18 | Orange | New York | 36071 | 20732 | 474 |
841186 | 841186 | 2020-12-18 | Orleans | New York | 36073 | 988 | 59 |
841187 | 841187 | 2020-12-18 | Oswego | New York | 36075 | 2675 | 22 |
841188 | 841188 | 2020-12-18 | Otsego | New York | 36077 | 969 | 8 |
841189 | 841189 | 2020-12-18 | Putnam | New York | 36079 | 4035 | 66 |
841190 | 841190 | 2020-12-18 | Rensselaer | New York | 36083 | 2991 | 70 |
841191 | 841191 | 2020-12-18 | Rockland | New York | 36087 | 24983 | 557 |
841192 | 841192 | 2020-12-18 | Saratoga | New York | 36091 | 3908 | 27 |
841193 | 841193 | 2020-12-18 | Schenectady | New York | 36093 | 4268 | 67 |
841194 | 841194 | 2020-12-18 | Schoharie | New York | 36095 | 401 | 2 |
841195 | 841195 | 2020-12-18 | Schuyler | New York | 36097 | 420 | 8 |
841196 | 841196 | 2020-12-18 | Seneca | New York | 36099 | 551 | 17 |
841197 | 841197 | 2020-12-18 | St. Lawrence | New York | 36089 | 1511 | 31 |
841198 | 841198 | 2020-12-18 | Steuben | New York | 36101 | 2663 | 106 |
841199 | 841199 | 2020-12-18 | Suffolk | New York | 36103 | 80047 | 2153 |
841200 | 841200 | 2020-12-18 | Sullivan | New York | 36105 | 2601 | 40 |
841201 | 841201 | 2020-12-18 | Tioga | New York | 36107 | 1439 | 54 |
841202 | 841202 | 2020-12-18 | Tompkins | New York | 36109 | 1710 | 9 |
841203 | 841203 | 2020-12-18 | Ulster | New York | 36111 | 4736 | 125 |
841204 | 841204 | 2020-12-18 | Warren | New York | 36113 | 812 | 30 |
841205 | 841205 | 2020-12-18 | Washington | New York | 36115 | 625 | 14 |
841206 | 841206 | 2020-12-18 | Wayne | New York | 36117 | 1881 | 28 |
841207 | 841207 | 2020-12-18 | Westchester | New York | 36119 | 61826 | 1594 |
841208 | 841208 | 2020-12-18 | Wyoming | New York | 36121 | 1013 | 14 |
841209 | 841209 | 2020-12-18 | Yates | New York | 36123 | 395 | 9 |
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);