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 684
- Westchester 681
- Nassau 680
- Rockland 679
- Saratoga 678
- Suffolk 677
- Ulster 677
- Monroe 674
- Albany 673
- Delaware 673
- Dutchess 673
- Herkimer 673
- Orange 673
- Schenectady 672
- Broome 671
- Tioga 671
- Tompkins 671
- Erie 670
- Greene 670
- Montgomery 670
- Putnam 670
- Allegany 669
- Onondaga 669
- Ontario 669
- Clinton 668
- Rensselaer 668
- Sullivan 668
- Wyoming 668
- Chenango 667
- Essex 667
- …
state 1
- New York · 38,732 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110978 | 2110978 | 2022-01-13 | Albany | New York | 36001 | 49387 | 452 |
2110979 | 2110979 | 2022-01-13 | Allegany | New York | 36003 | 7563 | 140 |
2110980 | 2110980 | 2022-01-13 | Broome | New York | 36007 | 38583 | 479 |
2110981 | 2110981 | 2022-01-13 | Cattaraugus | New York | 36009 | 12732 | 196 |
2110982 | 2110982 | 2022-01-13 | Cayuga | New York | 36011 | 13354 | 124 |
2110983 | 2110983 | 2022-01-13 | Chautauqua | New York | 36013 | 19947 | 233 |
2110984 | 2110984 | 2022-01-13 | Chemung | New York | 36015 | 17786 | 199 |
2110985 | 2110985 | 2022-01-13 | Chenango | New York | 36017 | 7625 | 104 |
2110986 | 2110986 | 2022-01-13 | Clinton | New York | 36019 | 12130 | 61 |
2110987 | 2110987 | 2022-01-13 | Columbia | New York | 36021 | 8281 | 126 |
2110988 | 2110988 | 2022-01-13 | Cortland | New York | 36023 | 8490 | 93 |
2110989 | 2110989 | 2022-01-13 | Delaware | New York | 36025 | 6402 | 61 |
2110990 | 2110990 | 2022-01-13 | Dutchess | New York | 36027 | 55713 | 556 |
2110991 | 2110991 | 2022-01-13 | Erie | New York | 36029 | 179275 | 2321 |
2110992 | 2110992 | 2022-01-13 | Essex | New York | 36031 | 4446 | 50 |
2110993 | 2110993 | 2022-01-13 | Franklin | New York | 36033 | 7379 | 35 |
2110994 | 2110994 | 2022-01-13 | Fulton | New York | 36035 | 10216 | 136 |
2110995 | 2110995 | 2022-01-13 | Genesee | New York | 36037 | 11698 | 165 |
2110996 | 2110996 | 2022-01-13 | Greene | New York | 36039 | 7277 | 104 |
2110997 | 2110997 | 2022-01-13 | Hamilton | New York | 36041 | 729 | 4 |
2110998 | 2110998 | 2022-01-13 | Herkimer | New York | 36043 | 11603 | 166 |
2110999 | 2110999 | 2022-01-13 | Jefferson | New York | 36045 | 15671 | 119 |
2111000 | 2111000 | 2022-01-13 | Lewis | New York | 36049 | 5333 | 43 |
2111001 | 2111001 | 2022-01-13 | Livingston | New York | 36051 | 9722 | 97 |
2111002 | 2111002 | 2022-01-13 | Madison | New York | 36053 | 10528 | 118 |
2111003 | 2111003 | 2022-01-13 | Monroe | New York | 36055 | 132655 | 1386 |
2111004 | 2111004 | 2022-01-13 | Montgomery | New York | 36057 | 9785 | 179 |
2111005 | 2111005 | 2022-01-13 | Nassau | New York | 36059 | 365524 | 3518 |
2111006 | 2111006 | 2022-01-13 | New York City | New York | 2038543 | 36374 | |
2111007 | 2111007 | 2022-01-13 | Niagara | New York | 36063 | 41190 | 494 |
2111008 | 2111008 | 2022-01-13 | Oneida | New York | 36065 | 44995 | 717 |
2111009 | 2111009 | 2022-01-13 | Onondaga | New York | 36067 | 88707 | 915 |
2111010 | 2111010 | 2022-01-13 | Ontario | New York | 36069 | 16385 | 154 |
2111011 | 2111011 | 2022-01-13 | Orange | New York | 36071 | 94116 | 868 |
2111012 | 2111012 | 2022-01-13 | Orleans | New York | 36073 | 7372 | 104 |
2111013 | 2111013 | 2022-01-13 | Oswego | New York | 36075 | 20288 | 155 |
2111014 | 2111014 | 2022-01-13 | Otsego | New York | 36077 | 7919 | 73 |
2111015 | 2111015 | 2022-01-13 | Putnam | New York | 36079 | 20931 | 110 |
2111016 | 2111016 | 2022-01-13 | Rensselaer | New York | 36083 | 25800 | 226 |
2111017 | 2111017 | 2022-01-13 | Rockland | New York | 36087 | 82015 | 830 |
2111018 | 2111018 | 2022-01-13 | Saratoga | New York | 36091 | 37866 | 285 |
2111019 | 2111019 | 2022-01-13 | Schenectady | New York | 36093 | 27282 | 277 |
2111020 | 2111020 | 2022-01-13 | Schoharie | New York | 36095 | 3992 | 31 |
2111021 | 2111021 | 2022-01-13 | Schuyler | New York | 36097 | 2818 | 23 |
2111022 | 2111022 | 2022-01-13 | Seneca | New York | 36099 | 4629 | 84 |
2111023 | 2111023 | 2022-01-13 | St. Lawrence | New York | 36089 | 16872 | 164 |
2111024 | 2111024 | 2022-01-13 | Steuben | New York | 36101 | 16418 | 224 |
2111025 | 2111025 | 2022-01-13 | Suffolk | New York | 36103 | 388229 | 3974 |
2111026 | 2111026 | 2022-01-13 | Sullivan | New York | 36105 | 15636 | 108 |
2111027 | 2111027 | 2022-01-13 | Tioga | New York | 36107 | 8862 | 79 |
2111028 | 2111028 | 2022-01-13 | Tompkins | New York | 36109 | 14013 | 74 |
2111029 | 2111029 | 2022-01-13 | Ulster | New York | 36111 | 26406 | 319 |
2111030 | 2111030 | 2022-01-13 | Warren | New York | 36113 | 11065 | 113 |
2111031 | 2111031 | 2022-01-13 | Washington | New York | 36115 | 9828 | 96 |
2111032 | 2111032 | 2022-01-13 | Wayne | New York | 36117 | 14116 | 139 |
2111033 | 2111033 | 2022-01-13 | Westchester | New York | 36119 | 225085 | 2490 |
2111034 | 2111034 | 2022-01-13 | Wyoming | New York | 36121 | 7168 | 75 |
2111035 | 2111035 | 2022-01-13 | Yates | New York | 36123 | 2735 | 36 |
2107726 | 2107726 | 2022-01-12 | Albany | New York | 36001 | 48640 | 450 |
2107727 | 2107727 | 2022-01-12 | Allegany | New York | 36003 | 7502 | 140 |
2107728 | 2107728 | 2022-01-12 | Broome | New York | 36007 | 38090 | 477 |
2107729 | 2107729 | 2022-01-12 | Cattaraugus | New York | 36009 | 12613 | 195 |
2107730 | 2107730 | 2022-01-12 | Cayuga | New York | 36011 | 13218 | 124 |
2107731 | 2107731 | 2022-01-12 | Chautauqua | New York | 36013 | 19761 | 232 |
2107732 | 2107732 | 2022-01-12 | Chemung | New York | 36015 | 17405 | 198 |
2107733 | 2107733 | 2022-01-12 | Chenango | New York | 36017 | 7534 | 103 |
2107734 | 2107734 | 2022-01-12 | Clinton | New York | 36019 | 11909 | 60 |
2107735 | 2107735 | 2022-01-12 | Columbia | New York | 36021 | 8156 | 125 |
2107736 | 2107736 | 2022-01-12 | Cortland | New York | 36023 | 8373 | 93 |
2107737 | 2107737 | 2022-01-12 | Delaware | New York | 36025 | 6324 | 61 |
2107738 | 2107738 | 2022-01-12 | Dutchess | New York | 36027 | 55009 | 556 |
2107739 | 2107739 | 2022-01-12 | Erie | New York | 36029 | 177332 | 2314 |
2107740 | 2107740 | 2022-01-12 | Essex | New York | 36031 | 4378 | 50 |
2107741 | 2107741 | 2022-01-12 | Franklin | New York | 36033 | 7285 | 35 |
2107742 | 2107742 | 2022-01-12 | Fulton | New York | 36035 | 10112 | 136 |
2107743 | 2107743 | 2022-01-12 | Genesee | New York | 36037 | 11532 | 164 |
2107744 | 2107744 | 2022-01-12 | Greene | New York | 36039 | 7134 | 103 |
2107745 | 2107745 | 2022-01-12 | Hamilton | New York | 36041 | 724 | 4 |
2107746 | 2107746 | 2022-01-12 | Herkimer | New York | 36043 | 11449 | 165 |
2107747 | 2107747 | 2022-01-12 | Jefferson | New York | 36045 | 15433 | 119 |
2107748 | 2107748 | 2022-01-12 | Lewis | New York | 36049 | 5279 | 43 |
2107749 | 2107749 | 2022-01-12 | Livingston | New York | 36051 | 9594 | 96 |
2107750 | 2107750 | 2022-01-12 | Madison | New York | 36053 | 10412 | 118 |
2107751 | 2107751 | 2022-01-12 | Monroe | New York | 36055 | 131210 | 1379 |
2107752 | 2107752 | 2022-01-12 | Montgomery | New York | 36057 | 9671 | 179 |
2107753 | 2107753 | 2022-01-12 | Nassau | New York | 36059 | 361426 | 3505 |
2107754 | 2107754 | 2022-01-12 | New York City | New York | 2005338 | 36224 | |
2107755 | 2107755 | 2022-01-12 | Niagara | New York | 36063 | 40675 | 493 |
2107756 | 2107756 | 2022-01-12 | Oneida | New York | 36065 | 44484 | 716 |
2107757 | 2107757 | 2022-01-12 | Onondaga | New York | 36067 | 87307 | 910 |
2107758 | 2107758 | 2022-01-12 | Ontario | New York | 36069 | 16175 | 153 |
2107759 | 2107759 | 2022-01-12 | Orange | New York | 36071 | 92502 | 866 |
2107760 | 2107760 | 2022-01-12 | Orleans | New York | 36073 | 7262 | 104 |
2107761 | 2107761 | 2022-01-12 | Oswego | New York | 36075 | 20002 | 154 |
2107762 | 2107762 | 2022-01-12 | Otsego | New York | 36077 | 7812 | 73 |
2107763 | 2107763 | 2022-01-12 | Putnam | New York | 36079 | 20671 | 110 |
2107764 | 2107764 | 2022-01-12 | Rensselaer | New York | 36083 | 25358 | 224 |
2107765 | 2107765 | 2022-01-12 | Rockland | New York | 36087 | 80991 | 827 |
2107766 | 2107766 | 2022-01-12 | Saratoga | New York | 36091 | 37305 | 281 |
2107767 | 2107767 | 2022-01-12 | Schenectady | New York | 36093 | 26871 | 277 |
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);