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)
fips >30
county >30
- New York City 120
- Westchester 117
- Nassau 116
- Rockland 115
- Saratoga 114
- Suffolk 113
- Ulster 113
- Monroe 110
- Albany 109
- Delaware 109
- Dutchess 109
- Herkimer 109
- Orange 109
- Schenectady 108
- Broome 107
- Tioga 107
- Tompkins 107
- Erie 106
- Greene 106
- Montgomery 106
- Putnam 106
- Allegany 105
- Onondaga 105
- Ontario 105
- Clinton 104
- Rensselaer 104
- Sullivan 104
- Wyoming 104
- Chenango 103
- Essex 103
- …
state 1
- New York · 6,020 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282566 | 282566 | 2020-06-28 | Albany | New York | 36001 | 2097 | 159 |
282567 | 282567 | 2020-06-28 | Allegany | New York | 36003 | 59 | 0 |
282568 | 282568 | 2020-06-28 | Broome | New York | 36007 | 703 | 61 |
282569 | 282569 | 2020-06-28 | Cattaraugus | New York | 36009 | 123 | 5 |
282570 | 282570 | 2020-06-28 | Cayuga | New York | 36011 | 113 | 1 |
282571 | 282571 | 2020-06-28 | Chautauqua | New York | 36013 | 123 | 4 |
282572 | 282572 | 2020-06-28 | Chemung | New York | 36015 | 140 | 5 |
282573 | 282573 | 2020-06-28 | Chenango | New York | 36017 | 146 | 3 |
282574 | 282574 | 2020-06-28 | Clinton | New York | 36019 | 101 | 4 |
282575 | 282575 | 2020-06-28 | Columbia | New York | 36021 | 463 | 43 |
282576 | 282576 | 2020-06-28 | Cortland | New York | 36023 | 46 | 0 |
282577 | 282577 | 2020-06-28 | Delaware | New York | 36025 | 91 | 0 |
282578 | 282578 | 2020-06-28 | Dutchess | New York | 36027 | 4198 | 159 |
282579 | 282579 | 2020-06-28 | Erie | New York | 36029 | 7228 | 594 |
282580 | 282580 | 2020-06-28 | Essex | New York | 36031 | 50 | 0 |
282581 | 282581 | 2020-06-28 | Franklin | New York | 36033 | 29 | 0 |
282582 | 282582 | 2020-06-28 | Fulton | New York | 36035 | 255 | 18 |
282583 | 282583 | 2020-06-28 | Genesee | New York | 36037 | 238 | 6 |
282584 | 282584 | 2020-06-28 | Greene | New York | 36039 | 260 | 5 |
282585 | 282585 | 2020-06-28 | Hamilton | New York | 36041 | 6 | 0 |
282586 | 282586 | 2020-06-28 | Herkimer | New York | 36043 | 158 | 1 |
282587 | 282587 | 2020-06-28 | Jefferson | New York | 36045 | 85 | 0 |
282588 | 282588 | 2020-06-28 | Lewis | New York | 36049 | 29 | 0 |
282589 | 282589 | 2020-06-28 | Livingston | New York | 36051 | 128 | 4 |
282590 | 282590 | 2020-06-28 | Madison | New York | 36053 | 352 | 4 |
282591 | 282591 | 2020-06-28 | Monroe | New York | 36055 | 3691 | 261 |
282592 | 282592 | 2020-06-28 | Montgomery | New York | 36057 | 118 | 5 |
282593 | 282593 | 2020-06-28 | Nassau | New York | 36059 | 41754 | 2692 |
282594 | 282594 | 2020-06-28 | New York City | New York | 219481 | 21940 | |
282595 | 282595 | 2020-06-28 | Niagara | New York | 36063 | 1226 | 66 |
282596 | 282596 | 2020-06-28 | Oneida | New York | 36065 | 1586 | 92 |
282597 | 282597 | 2020-06-28 | Onondaga | New York | 36067 | 2816 | 175 |
282598 | 282598 | 2020-06-28 | Ontario | New York | 36069 | 256 | 25 |
282599 | 282599 | 2020-06-28 | Orange | New York | 36071 | 10728 | 399 |
282600 | 282600 | 2020-06-28 | Orleans | New York | 36073 | 281 | 40 |
282601 | 282601 | 2020-06-28 | Oswego | New York | 36075 | 195 | 0 |
282602 | 282602 | 2020-06-28 | Otsego | New York | 36077 | 84 | 6 |
282603 | 282603 | 2020-06-28 | Putnam | New York | 36079 | 1323 | 61 |
282604 | 282604 | 2020-06-28 | Rensselaer | New York | 36083 | 551 | 37 |
282605 | 282605 | 2020-06-28 | Rockland | New York | 36087 | 13576 | 469 |
282606 | 282606 | 2020-06-28 | Saratoga | New York | 36091 | 548 | 5 |
282607 | 282607 | 2020-06-28 | Schenectady | New York | 36093 | 792 | 34 |
282608 | 282608 | 2020-06-28 | Schoharie | New York | 36095 | 58 | 0 |
282609 | 282609 | 2020-06-28 | Schuyler | New York | 36097 | 12 | 0 |
282610 | 282610 | 2020-06-28 | Seneca | New York | 36099 | 69 | 0 |
282611 | 282611 | 2020-06-28 | St. Lawrence | New York | 36089 | 218 | 3 |
282612 | 282612 | 2020-06-28 | Steuben | New York | 36101 | 266 | 19 |
282613 | 282613 | 2020-06-28 | Suffolk | New York | 36103 | 41306 | 2026 |
282614 | 282614 | 2020-06-28 | Sullivan | New York | 36105 | 1451 | 31 |
282615 | 282615 | 2020-06-28 | Tioga | New York | 36107 | 142 | 18 |
282616 | 282616 | 2020-06-28 | Tompkins | New York | 36109 | 176 | 2 |
282617 | 282617 | 2020-06-28 | Ulster | New York | 36111 | 1778 | 49 |
282618 | 282618 | 2020-06-28 | Warren | New York | 36113 | 263 | 31 |
282619 | 282619 | 2020-06-28 | Washington | New York | 36115 | 246 | 11 |
282620 | 282620 | 2020-06-28 | Wayne | New York | 36117 | 162 | 1 |
282621 | 282621 | 2020-06-28 | Westchester | New York | 36119 | 34779 | 1554 |
282622 | 282622 | 2020-06-28 | Wyoming | New York | 36121 | 95 | 3 |
282623 | 282623 | 2020-06-28 | Yates | New York | 36123 | 45 | 6 |
279420 | 279420 | 2020-06-27 | Albany | New York | 36001 | 2091 | 159 |
279421 | 279421 | 2020-06-27 | Allegany | New York | 36003 | 58 | 0 |
279422 | 279422 | 2020-06-27 | Broome | New York | 36007 | 701 | 61 |
279423 | 279423 | 2020-06-27 | Cattaraugus | New York | 36009 | 123 | 5 |
279424 | 279424 | 2020-06-27 | Cayuga | New York | 36011 | 111 | 1 |
279425 | 279425 | 2020-06-27 | Chautauqua | New York | 36013 | 123 | 4 |
279426 | 279426 | 2020-06-27 | Chemung | New York | 36015 | 139 | 5 |
279427 | 279427 | 2020-06-27 | Chenango | New York | 36017 | 146 | 3 |
279428 | 279428 | 2020-06-27 | Clinton | New York | 36019 | 101 | 4 |
279429 | 279429 | 2020-06-27 | Columbia | New York | 36021 | 461 | 43 |
279430 | 279430 | 2020-06-27 | Cortland | New York | 36023 | 44 | 0 |
279431 | 279431 | 2020-06-27 | Delaware | New York | 36025 | 91 | 0 |
279432 | 279432 | 2020-06-27 | Dutchess | New York | 36027 | 4191 | 159 |
279433 | 279433 | 2020-06-27 | Erie | New York | 36029 | 7206 | 594 |
279434 | 279434 | 2020-06-27 | Essex | New York | 36031 | 50 | 0 |
279435 | 279435 | 2020-06-27 | Franklin | New York | 36033 | 29 | 0 |
279436 | 279436 | 2020-06-27 | Fulton | New York | 36035 | 249 | 18 |
279437 | 279437 | 2020-06-27 | Genesee | New York | 36037 | 237 | 6 |
279438 | 279438 | 2020-06-27 | Greene | New York | 36039 | 260 | 5 |
279439 | 279439 | 2020-06-27 | Hamilton | New York | 36041 | 6 | 0 |
279440 | 279440 | 2020-06-27 | Herkimer | New York | 36043 | 154 | 1 |
279441 | 279441 | 2020-06-27 | Jefferson | New York | 36045 | 85 | 0 |
279442 | 279442 | 2020-06-27 | Lewis | New York | 36049 | 26 | 0 |
279443 | 279443 | 2020-06-27 | Livingston | New York | 36051 | 126 | 4 |
279444 | 279444 | 2020-06-27 | Madison | New York | 36053 | 351 | 4 |
279445 | 279445 | 2020-06-27 | Monroe | New York | 36055 | 3677 | 260 |
279446 | 279446 | 2020-06-27 | Montgomery | New York | 36057 | 116 | 5 |
279447 | 279447 | 2020-06-27 | Nassau | New York | 36059 | 41725 | 2691 |
279448 | 279448 | 2020-06-27 | New York City | New York | 219157 | 21913 | |
279449 | 279449 | 2020-06-27 | Niagara | New York | 36063 | 1223 | 66 |
279450 | 279450 | 2020-06-27 | Oneida | New York | 36065 | 1547 | 92 |
279451 | 279451 | 2020-06-27 | Onondaga | New York | 36067 | 2791 | 175 |
279452 | 279452 | 2020-06-27 | Ontario | New York | 36069 | 254 | 25 |
279453 | 279453 | 2020-06-27 | Orange | New York | 36071 | 10725 | 399 |
279454 | 279454 | 2020-06-27 | Orleans | New York | 36073 | 280 | 40 |
279455 | 279455 | 2020-06-27 | Oswego | New York | 36075 | 194 | 0 |
279456 | 279456 | 2020-06-27 | Otsego | New York | 36077 | 84 | 6 |
279457 | 279457 | 2020-06-27 | Putnam | New York | 36079 | 1319 | 61 |
279458 | 279458 | 2020-06-27 | Rensselaer | New York | 36083 | 550 | 37 |
279459 | 279459 | 2020-06-27 | Rockland | New York | 36087 | 13566 | 469 |
279460 | 279460 | 2020-06-27 | Saratoga | New York | 36091 | 546 | 5 |
279461 | 279461 | 2020-06-27 | Schenectady | New York | 36093 | 786 | 34 |
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);