ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45,692 rows where state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- New York City 804
- Westchester 801
- Nassau 800
- Rockland 799
- Saratoga 798
- Suffolk 797
- Ulster 797
- Monroe 794
- Albany 793
- Delaware 793
- Dutchess 793
- Herkimer 793
- Orange 793
- Schenectady 792
- Broome 791
- Tioga 791
- Tompkins 791
- Erie 790
- Greene 790
- Montgomery 790
- Putnam 790
- Allegany 789
- Onondaga 789
- Ontario 789
- Clinton 788
- Rensselaer 788
- Sullivan 788
- Wyoming 788
- Chenango 787
- Essex 787
- …
state 1
- New York · 45,692 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501428 | 2501428 | 2022-05-13 | Albany | New York | 36001 | 63461 | 523 |
2501429 | 2501429 | 2022-05-13 | Allegany | New York | 36003 | 9275 | 155 |
2501430 | 2501430 | 2022-05-13 | Broome | New York | 36007 | 48947 | 520 |
2501431 | 2501431 | 2022-05-13 | Cattaraugus | New York | 36009 | 16113 | 222 |
2501432 | 2501432 | 2022-05-13 | Cayuga | New York | 36011 | 17375 | 152 |
2501433 | 2501433 | 2022-05-13 | Chautauqua | New York | 36013 | 24556 | 302 |
2501434 | 2501434 | 2022-05-13 | Chemung | New York | 36015 | 22603 | 233 |
2501435 | 2501435 | 2022-05-13 | Chenango | New York | 36017 | 9858 | 121 |
2501436 | 2501436 | 2022-05-13 | Clinton | New York | 36019 | 18034 | 90 |
2501437 | 2501437 | 2022-05-13 | Columbia | New York | 36021 | 10772 | 141 |
2501438 | 2501438 | 2022-05-13 | Cortland | New York | 36023 | 11365 | 120 |
2501439 | 2501439 | 2022-05-13 | Delaware | New York | 36025 | 8261 | 72 |
2501440 | 2501440 | 2022-05-13 | Dutchess | New York | 36027 | 66962 | 659 |
2501441 | 2501441 | 2022-05-13 | Erie | New York | 36029 | 227059 | 2651 |
2501442 | 2501442 | 2022-05-13 | Essex | New York | 36031 | 6124 | 61 |
2501443 | 2501443 | 2022-05-13 | Franklin | New York | 36033 | 10059 | 46 |
2501444 | 2501444 | 2022-05-13 | Fulton | New York | 36035 | 13428 | 169 |
2501445 | 2501445 | 2022-05-13 | Genesee | New York | 36037 | 14395 | 187 |
2501446 | 2501446 | 2022-05-13 | Greene | New York | 36039 | 9055 | 130 |
2501447 | 2501447 | 2022-05-13 | Hamilton | New York | 36041 | 919 | 5 |
2501448 | 2501448 | 2022-05-13 | Herkimer | New York | 36043 | 14827 | 193 |
2501449 | 2501449 | 2022-05-13 | Jefferson | New York | 36045 | 21422 | 138 |
2501450 | 2501450 | 2022-05-13 | Lewis | New York | 36049 | 6417 | 49 |
2501451 | 2501451 | 2022-05-13 | Livingston | New York | 36051 | 12324 | 118 |
2501452 | 2501452 | 2022-05-13 | Madison | New York | 36053 | 14319 | 127 |
2501453 | 2501453 | 2022-05-13 | Monroe | New York | 36055 | 163464 | 1587 |
2501454 | 2501454 | 2022-05-13 | Montgomery | New York | 36057 | 12471 | 205 |
2501455 | 2501455 | 2022-05-13 | Nassau | New York | 36059 | 425386 | 3853 |
2501456 | 2501456 | 2022-05-13 | New York City | New York | 2422658 | 40267 | |
2501457 | 2501457 | 2022-05-13 | Niagara | New York | 36063 | 51069 | 585 |
2501458 | 2501458 | 2022-05-13 | Oneida | New York | 36065 | 58360 | 803 |
2501459 | 2501459 | 2022-05-13 | Onondaga | New York | 36067 | 121727 | 1073 |
2501460 | 2501460 | 2022-05-13 | Ontario | New York | 36069 | 21586 | 180 |
2501461 | 2501461 | 2022-05-13 | Orange | New York | 36071 | 111228 | 954 |
2501462 | 2501462 | 2022-05-13 | Orleans | New York | 36073 | 9116 | 117 |
2501463 | 2501463 | 2022-05-13 | Oswego | New York | 36075 | 28826 | 194 |
2501464 | 2501464 | 2022-05-13 | Otsego | New York | 36077 | 10667 | 88 |
2501465 | 2501465 | 2022-05-13 | Putnam | New York | 36079 | 24875 | 125 |
2501466 | 2501466 | 2022-05-13 | Rensselaer | New York | 36083 | 33850 | 259 |
2501467 | 2501467 | 2022-05-13 | Rockland | New York | 36087 | 96142 | 897 |
2501468 | 2501468 | 2022-05-13 | Saratoga | New York | 36091 | 49890 | 335 |
2501469 | 2501469 | 2022-05-13 | Schenectady | New York | 36093 | 35317 | 305 |
2501470 | 2501470 | 2022-05-13 | Schoharie | New York | 36095 | 5336 | 36 |
2501471 | 2501471 | 2022-05-13 | Schuyler | New York | 36097 | 3724 | 25 |
2501472 | 2501472 | 2022-05-13 | Seneca | New York | 36099 | 6391 | 91 |
2501473 | 2501473 | 2022-05-13 | St. Lawrence | New York | 36089 | 22454 | 191 |
2501474 | 2501474 | 2022-05-13 | Steuben | New York | 36101 | 21216 | 253 |
2501475 | 2501475 | 2022-05-13 | Suffolk | New York | 36103 | 444799 | 4399 |
2501476 | 2501476 | 2022-05-13 | Sullivan | New York | 36105 | 19217 | 130 |
2501477 | 2501477 | 2022-05-13 | Tioga | New York | 36107 | 11719 | 85 |
2501478 | 2501478 | 2022-05-13 | Tompkins | New York | 36109 | 21144 | 85 |
2501479 | 2501479 | 2022-05-13 | Ulster | New York | 36111 | 33856 | 365 |
2501480 | 2501480 | 2022-05-13 | Warren | New York | 36113 | 14739 | 129 |
2501481 | 2501481 | 2022-05-13 | Washington | New York | 36115 | 12875 | 115 |
2501482 | 2501482 | 2022-05-13 | Wayne | New York | 36117 | 18503 | 179 |
2501483 | 2501483 | 2022-05-13 | Westchester | New York | 36119 | 264447 | 2720 |
2501484 | 2501484 | 2022-05-13 | Wyoming | New York | 36121 | 8692 | 84 |
2501485 | 2501485 | 2022-05-13 | Yates | New York | 36123 | 3704 | 40 |
2498170 | 2498170 | 2022-05-12 | Albany | New York | 36001 | 63461 | 523 |
2498171 | 2498171 | 2022-05-12 | Allegany | New York | 36003 | 9275 | 154 |
2498172 | 2498172 | 2022-05-12 | Broome | New York | 36007 | 48947 | 520 |
2498173 | 2498173 | 2022-05-12 | Cattaraugus | New York | 36009 | 16113 | 222 |
2498174 | 2498174 | 2022-05-12 | Cayuga | New York | 36011 | 17375 | 152 |
2498175 | 2498175 | 2022-05-12 | Chautauqua | New York | 36013 | 24556 | 302 |
2498176 | 2498176 | 2022-05-12 | Chemung | New York | 36015 | 22603 | 233 |
2498177 | 2498177 | 2022-05-12 | Chenango | New York | 36017 | 9858 | 120 |
2498178 | 2498178 | 2022-05-12 | Clinton | New York | 36019 | 18034 | 90 |
2498179 | 2498179 | 2022-05-12 | Columbia | New York | 36021 | 10772 | 140 |
2498180 | 2498180 | 2022-05-12 | Cortland | New York | 36023 | 11365 | 120 |
2498181 | 2498181 | 2022-05-12 | Delaware | New York | 36025 | 8261 | 72 |
2498182 | 2498182 | 2022-05-12 | Dutchess | New York | 36027 | 66962 | 659 |
2498183 | 2498183 | 2022-05-12 | Erie | New York | 36029 | 227059 | 2648 |
2498184 | 2498184 | 2022-05-12 | Essex | New York | 36031 | 6124 | 61 |
2498185 | 2498185 | 2022-05-12 | Franklin | New York | 36033 | 10059 | 46 |
2498186 | 2498186 | 2022-05-12 | Fulton | New York | 36035 | 13428 | 169 |
2498187 | 2498187 | 2022-05-12 | Genesee | New York | 36037 | 14395 | 187 |
2498188 | 2498188 | 2022-05-12 | Greene | New York | 36039 | 9055 | 129 |
2498189 | 2498189 | 2022-05-12 | Hamilton | New York | 36041 | 919 | 5 |
2498190 | 2498190 | 2022-05-12 | Herkimer | New York | 36043 | 14827 | 193 |
2498191 | 2498191 | 2022-05-12 | Jefferson | New York | 36045 | 21422 | 138 |
2498192 | 2498192 | 2022-05-12 | Lewis | New York | 36049 | 6417 | 49 |
2498193 | 2498193 | 2022-05-12 | Livingston | New York | 36051 | 12324 | 118 |
2498194 | 2498194 | 2022-05-12 | Madison | New York | 36053 | 14319 | 127 |
2498195 | 2498195 | 2022-05-12 | Monroe | New York | 36055 | 163464 | 1586 |
2498196 | 2498196 | 2022-05-12 | Montgomery | New York | 36057 | 12471 | 205 |
2498197 | 2498197 | 2022-05-12 | Nassau | New York | 36059 | 425386 | 3852 |
2498198 | 2498198 | 2022-05-12 | New York City | New York | 2417909 | 40261 | |
2498199 | 2498199 | 2022-05-12 | Niagara | New York | 36063 | 51069 | 584 |
2498200 | 2498200 | 2022-05-12 | Oneida | New York | 36065 | 58360 | 802 |
2498201 | 2498201 | 2022-05-12 | Onondaga | New York | 36067 | 121727 | 1073 |
2498202 | 2498202 | 2022-05-12 | Ontario | New York | 36069 | 21586 | 180 |
2498203 | 2498203 | 2022-05-12 | Orange | New York | 36071 | 111228 | 953 |
2498204 | 2498204 | 2022-05-12 | Orleans | New York | 36073 | 9116 | 116 |
2498205 | 2498205 | 2022-05-12 | Oswego | New York | 36075 | 28826 | 194 |
2498206 | 2498206 | 2022-05-12 | Otsego | New York | 36077 | 10667 | 88 |
2498207 | 2498207 | 2022-05-12 | Putnam | New York | 36079 | 24875 | 125 |
2498208 | 2498208 | 2022-05-12 | Rensselaer | New York | 36083 | 33850 | 257 |
2498209 | 2498209 | 2022-05-12 | Rockland | New York | 36087 | 96142 | 897 |
2498210 | 2498210 | 2022-05-12 | Saratoga | New York | 36091 | 49890 | 335 |
2498211 | 2498211 | 2022-05-12 | Schenectady | New York | 36093 | 35317 | 305 |
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);