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)
county 59
- New York City 802
- Westchester 800
- Nassau 798
- Rockland 797
- Saratoga 796
- Suffolk 796
- Ulster 796
- Monroe 792
- Albany 791
- Delaware 791
- Dutchess 791
- Herkimer 791
- Orange 791
- Schenectady 790
- Tioga 790
- Tompkins 790
- Broome 789
- Erie 788
- Greene 788
- Montgomery 788
- Putnam 788
- Allegany 787
- Onondaga 787
- Ontario 787
- Sullivan 787
- Wyoming 787
- Clinton 786
- Rensselaer 786
- Warren 786
- Washington 786
- Chenango 785
- Essex 785
- Hamilton 785
- Jefferson 785
- Livingston 785
- Schoharie 785
- Wayne 785
- Columbia 783
- Fulton 783
- Genesee 783
- Niagara 783
- Oneida 783
- Steuben 783
- St. Lawrence 782
- Cortland 781
- Madison 781
- Cayuga 780
- Oswego 780
- Otsego 780
- Chemung 779
- Orleans 779
- Chautauqua 778
- Franklin 778
- Schuyler 776
- Cattaraugus 775
- Lewis 774
- Seneca 773
- Yates 771
- Unknown 10
fips 58
- - 812
- 36119 800
- 36059 798
- 36087 797
- 36091 796
- 36103 796
- 36111 796
- 36055 792
- 36001 791
- 36025 791
- 36027 791
- 36043 791
- 36071 791
- 36093 790
- 36107 790
- 36109 790
- 36007 789
- 36029 788
- 36039 788
- 36057 788
- 36079 788
- 36003 787
- 36067 787
- 36069 787
- 36105 787
- 36121 787
- 36019 786
- 36083 786
- 36113 786
- 36115 786
- 36017 785
- 36031 785
- 36041 785
- 36045 785
- 36051 785
- 36095 785
- 36117 785
- 36021 783
- 36035 783
- 36037 783
- 36063 783
- 36065 783
- 36101 783
- 36089 782
- 36023 781
- 36053 781
- 36011 780
- 36075 780
- 36077 780
- 36015 779
- 36073 779
- 36013 778
- 36033 778
- 36097 776
- 36009 775
- 36049 774
- 36099 773
- 36123 771
state 1
- New York · 45,592 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498212 | 2498212 | 2022-05-12 | Schoharie | New York | 36095 | 5336 | 36 |
2498213 | 2498213 | 2022-05-12 | Schuyler | New York | 36097 | 3724 | 25 |
2498214 | 2498214 | 2022-05-12 | Seneca | New York | 36099 | 6391 | 91 |
2498215 | 2498215 | 2022-05-12 | St. Lawrence | New York | 36089 | 22454 | 191 |
2498216 | 2498216 | 2022-05-12 | Steuben | New York | 36101 | 21216 | 253 |
2498217 | 2498217 | 2022-05-12 | Suffolk | New York | 36103 | 444799 | 4397 |
2498218 | 2498218 | 2022-05-12 | Sullivan | New York | 36105 | 19217 | 130 |
2498219 | 2498219 | 2022-05-12 | Tioga | New York | 36107 | 11719 | 84 |
2498220 | 2498220 | 2022-05-12 | Tompkins | New York | 36109 | 21144 | 85 |
2498221 | 2498221 | 2022-05-12 | Ulster | New York | 36111 | 33856 | 364 |
2498222 | 2498222 | 2022-05-12 | Warren | New York | 36113 | 14739 | 129 |
2498223 | 2498223 | 2022-05-12 | Washington | New York | 36115 | 12875 | 115 |
2498224 | 2498224 | 2022-05-12 | Wayne | New York | 36117 | 18503 | 179 |
2498225 | 2498225 | 2022-05-12 | Westchester | New York | 36119 | 264447 | 2720 |
2498226 | 2498226 | 2022-05-12 | Wyoming | New York | 36121 | 8692 | 84 |
2498227 | 2498227 | 2022-05-12 | Yates | New York | 36123 | 3704 | 40 |
2494912 | 2494912 | 2022-05-11 | Albany | New York | 36001 | 63241 | 522 |
2494913 | 2494913 | 2022-05-11 | Allegany | New York | 36003 | 9258 | 154 |
2494914 | 2494914 | 2022-05-11 | Broome | New York | 36007 | 48812 | 519 |
2494915 | 2494915 | 2022-05-11 | Cattaraugus | New York | 36009 | 16081 | 222 |
2494916 | 2494916 | 2022-05-11 | Cayuga | New York | 36011 | 17345 | 152 |
2494917 | 2494917 | 2022-05-11 | Chautauqua | New York | 36013 | 24499 | 302 |
2494918 | 2494918 | 2022-05-11 | Chemung | New York | 36015 | 22545 | 232 |
2494919 | 2494919 | 2022-05-11 | Chenango | New York | 36017 | 9836 | 120 |
2494920 | 2494920 | 2022-05-11 | Clinton | New York | 36019 | 17976 | 90 |
2494921 | 2494921 | 2022-05-11 | Columbia | New York | 36021 | 10734 | 140 |
2494922 | 2494922 | 2022-05-11 | Cortland | New York | 36023 | 11346 | 120 |
2494923 | 2494923 | 2022-05-11 | Delaware | New York | 36025 | 8239 | 72 |
2494924 | 2494924 | 2022-05-11 | Dutchess | New York | 36027 | 66790 | 659 |
2494925 | 2494925 | 2022-05-11 | Erie | New York | 36029 | 226159 | 2647 |
2494926 | 2494926 | 2022-05-11 | Essex | New York | 36031 | 6103 | 60 |
2494927 | 2494927 | 2022-05-11 | Franklin | New York | 36033 | 10026 | 46 |
2494928 | 2494928 | 2022-05-11 | Fulton | New York | 36035 | 13402 | 169 |
2494929 | 2494929 | 2022-05-11 | Genesee | New York | 36037 | 14363 | 187 |
2494930 | 2494930 | 2022-05-11 | Greene | New York | 36039 | 9044 | 129 |
2494931 | 2494931 | 2022-05-11 | Hamilton | New York | 36041 | 919 | 5 |
2494932 | 2494932 | 2022-05-11 | Herkimer | New York | 36043 | 14798 | 193 |
2494933 | 2494933 | 2022-05-11 | Jefferson | New York | 36045 | 21358 | 137 |
2494934 | 2494934 | 2022-05-11 | Lewis | New York | 36049 | 6397 | 49 |
2494935 | 2494935 | 2022-05-11 | Livingston | New York | 36051 | 12295 | 118 |
2494936 | 2494936 | 2022-05-11 | Madison | New York | 36053 | 14290 | 127 |
2494937 | 2494937 | 2022-05-11 | Monroe | New York | 36055 | 163022 | 1583 |
2494938 | 2494938 | 2022-05-11 | Montgomery | New York | 36057 | 12444 | 205 |
2494939 | 2494939 | 2022-05-11 | Nassau | New York | 36059 | 424236 | 3851 |
2494940 | 2494940 | 2022-05-11 | New York City | New York | 2411431 | 40256 | |
2494941 | 2494941 | 2022-05-11 | Niagara | New York | 36063 | 50889 | 583 |
2494942 | 2494942 | 2022-05-11 | Oneida | New York | 36065 | 58246 | 801 |
2494943 | 2494943 | 2022-05-11 | Onondaga | New York | 36067 | 121517 | 1073 |
2494944 | 2494944 | 2022-05-11 | Ontario | New York | 36069 | 21538 | 180 |
2494945 | 2494945 | 2022-05-11 | Orange | New York | 36071 | 111001 | 953 |
2494946 | 2494946 | 2022-05-11 | Orleans | New York | 36073 | 9084 | 116 |
2494947 | 2494947 | 2022-05-11 | Oswego | New York | 36075 | 28774 | 194 |
2494948 | 2494948 | 2022-05-11 | Otsego | New York | 36077 | 10636 | 88 |
2494949 | 2494949 | 2022-05-11 | Putnam | New York | 36079 | 24801 | 125 |
2494950 | 2494950 | 2022-05-11 | Rensselaer | New York | 36083 | 33730 | 257 |
2494951 | 2494951 | 2022-05-11 | Rockland | New York | 36087 | 95943 | 897 |
2494952 | 2494952 | 2022-05-11 | Saratoga | New York | 36091 | 49695 | 333 |
2494953 | 2494953 | 2022-05-11 | Schenectady | New York | 36093 | 35186 | 305 |
2494954 | 2494954 | 2022-05-11 | Schoharie | New York | 36095 | 5325 | 36 |
2494955 | 2494955 | 2022-05-11 | Schuyler | New York | 36097 | 3714 | 25 |
2494956 | 2494956 | 2022-05-11 | Seneca | New York | 36099 | 6369 | 91 |
2494957 | 2494957 | 2022-05-11 | St. Lawrence | New York | 36089 | 22424 | 191 |
2494958 | 2494958 | 2022-05-11 | Steuben | New York | 36101 | 21156 | 253 |
2494959 | 2494959 | 2022-05-11 | Suffolk | New York | 36103 | 443819 | 4397 |
2494960 | 2494960 | 2022-05-11 | Sullivan | New York | 36105 | 19175 | 130 |
2494961 | 2494961 | 2022-05-11 | Tioga | New York | 36107 | 11686 | 84 |
2494962 | 2494962 | 2022-05-11 | Tompkins | New York | 36109 | 21071 | 85 |
2494963 | 2494963 | 2022-05-11 | Ulster | New York | 36111 | 33727 | 363 |
2494964 | 2494964 | 2022-05-11 | Warren | New York | 36113 | 14693 | 129 |
2494965 | 2494965 | 2022-05-11 | Washington | New York | 36115 | 12823 | 115 |
2494966 | 2494966 | 2022-05-11 | Wayne | New York | 36117 | 18451 | 179 |
2494967 | 2494967 | 2022-05-11 | Westchester | New York | 36119 | 263806 | 2719 |
2494968 | 2494968 | 2022-05-11 | Wyoming | New York | 36121 | 8677 | 84 |
2494969 | 2494969 | 2022-05-11 | Yates | New York | 36123 | 3696 | 40 |
2491654 | 2491654 | 2022-05-10 | Albany | New York | 36001 | 63093 | 522 |
2491655 | 2491655 | 2022-05-10 | Allegany | New York | 36003 | 9243 | 154 |
2491656 | 2491656 | 2022-05-10 | Broome | New York | 36007 | 48673 | 519 |
2491657 | 2491657 | 2022-05-10 | Cattaraugus | New York | 36009 | 16040 | 222 |
2491658 | 2491658 | 2022-05-10 | Cayuga | New York | 36011 | 17321 | 152 |
2491659 | 2491659 | 2022-05-10 | Chautauqua | New York | 36013 | 24433 | 301 |
2491660 | 2491660 | 2022-05-10 | Chemung | New York | 36015 | 22497 | 232 |
2491661 | 2491661 | 2022-05-10 | Chenango | New York | 36017 | 9805 | 120 |
2491662 | 2491662 | 2022-05-10 | Clinton | New York | 36019 | 17948 | 90 |
2491663 | 2491663 | 2022-05-10 | Columbia | New York | 36021 | 10698 | 140 |
2491664 | 2491664 | 2022-05-10 | Cortland | New York | 36023 | 11320 | 120 |
2491665 | 2491665 | 2022-05-10 | Delaware | New York | 36025 | 8221 | 72 |
2491666 | 2491666 | 2022-05-10 | Dutchess | New York | 36027 | 66665 | 659 |
2491667 | 2491667 | 2022-05-10 | Erie | New York | 36029 | 225534 | 2644 |
2491668 | 2491668 | 2022-05-10 | Essex | New York | 36031 | 6081 | 59 |
2491669 | 2491669 | 2022-05-10 | Franklin | New York | 36033 | 10015 | 46 |
2491670 | 2491670 | 2022-05-10 | Fulton | New York | 36035 | 13385 | 169 |
2491671 | 2491671 | 2022-05-10 | Genesee | New York | 36037 | 14331 | 187 |
2491672 | 2491672 | 2022-05-10 | Greene | New York | 36039 | 9025 | 129 |
2491673 | 2491673 | 2022-05-10 | Hamilton | New York | 36041 | 916 | 5 |
2491674 | 2491674 | 2022-05-10 | Herkimer | New York | 36043 | 14774 | 192 |
2491675 | 2491675 | 2022-05-10 | Jefferson | New York | 36045 | 21305 | 137 |
2491676 | 2491676 | 2022-05-10 | Lewis | New York | 36049 | 6389 | 49 |
2491677 | 2491677 | 2022-05-10 | Livingston | New York | 36051 | 12268 | 118 |
2491678 | 2491678 | 2022-05-10 | Madison | New York | 36053 | 14264 | 127 |
2491679 | 2491679 | 2022-05-10 | Monroe | New York | 36055 | 162669 | 1582 |
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);