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 2021-11-10 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 |
---|---|---|---|---|---|---|---|
1902944 | 1902944 | 2021-11-10 | Albany | New York | 36001 | 32391 | 399 |
1902945 | 1902945 | 2021-11-10 | Allegany | New York | 36003 | 5274 | 107 |
1902946 | 1902946 | 2021-11-10 | Broome | New York | 36007 | 26168 | 421 |
1902947 | 1902947 | 2021-11-10 | Cattaraugus | New York | 36009 | 8657 | 138 |
1902948 | 1902948 | 2021-11-10 | Cayuga | New York | 36011 | 9118 | 108 |
1902949 | 1902949 | 2021-11-10 | Chautauqua | New York | 36013 | 13311 | 184 |
1902950 | 1902950 | 2021-11-10 | Chemung | New York | 36015 | 11747 | 168 |
1902951 | 1902951 | 2021-11-10 | Chenango | New York | 36017 | 5012 | 93 |
1902952 | 1902952 | 2021-11-10 | Clinton | New York | 36019 | 7358 | 43 |
1902953 | 1902953 | 2021-11-10 | Columbia | New York | 36021 | 5237 | 113 |
1902954 | 1902954 | 2021-11-10 | Cortland | New York | 36023 | 5729 | 87 |
1902955 | 1902955 | 2021-11-10 | Delaware | New York | 36025 | 3880 | 49 |
1902956 | 1902956 | 2021-11-10 | Dutchess | New York | 36027 | 36536 | 505 |
1902957 | 1902957 | 2021-11-10 | Erie | New York | 36029 | 113079 | 1992 |
1902958 | 1902958 | 2021-11-10 | Essex | New York | 36031 | 2693 | 36 |
1902959 | 1902959 | 2021-11-10 | Franklin | New York | 36033 | 4693 | 25 |
1902960 | 1902960 | 2021-11-10 | Fulton | New York | 36035 | 7022 | 106 |
1902961 | 1902961 | 2021-11-10 | Genesee | New York | 36037 | 7686 | 138 |
1902962 | 1902962 | 2021-11-10 | Greene | New York | 36039 | 4613 | 87 |
1902963 | 1902963 | 2021-11-10 | Hamilton | New York | 36041 | 474 | 3 |
1902964 | 1902964 | 2021-11-10 | Herkimer | New York | 36043 | 7465 | 134 |
1902965 | 1902965 | 2021-11-10 | Jefferson | New York | 36045 | 9970 | 95 |
1902966 | 1902966 | 2021-11-10 | Lewis | New York | 36049 | 3847 | 39 |
1902967 | 1902967 | 2021-11-10 | Livingston | New York | 36051 | 6282 | 72 |
1902968 | 1902968 | 2021-11-10 | Madison | New York | 36053 | 6701 | 107 |
1902969 | 1902969 | 2021-11-10 | Monroe | New York | 36055 | 89422 | 1220 |
1902970 | 1902970 | 2021-11-10 | Montgomery | New York | 36057 | 6477 | 156 |
1902971 | 1902971 | 2021-11-10 | Nassau | New York | 36059 | 218368 | 3315 |
1902972 | 1902972 | 2021-11-10 | New York City | New York | 1131209 | 34659 | |
1902973 | 1902973 | 2021-11-10 | Niagara | New York | 36063 | 25662 | 406 |
1902974 | 1902974 | 2021-11-10 | Oneida | New York | 36065 | 30376 | 609 |
1902975 | 1902975 | 2021-11-10 | Onondaga | New York | 36067 | 55282 | 791 |
1902976 | 1902976 | 2021-11-10 | Ontario | New York | 36069 | 10258 | 111 |
1902977 | 1902977 | 2021-11-10 | Orange | New York | 36071 | 59321 | 787 |
1902978 | 1902978 | 2021-11-10 | Orleans | New York | 36073 | 4857 | 93 |
1902979 | 1902979 | 2021-11-10 | Oswego | New York | 36075 | 12720 | 123 |
1902980 | 1902980 | 2021-11-10 | Otsego | New York | 36077 | 4893 | 57 |
1902981 | 1902981 | 2021-11-10 | Putnam | New York | 36079 | 12747 | 98 |
1902982 | 1902982 | 2021-11-10 | Rensselaer | New York | 36083 | 15865 | 183 |
1902983 | 1902983 | 2021-11-10 | Rockland | New York | 36087 | 54181 | 782 |
1902984 | 1902984 | 2021-11-10 | Saratoga | New York | 36091 | 21785 | 212 |
1902985 | 1902985 | 2021-11-10 | Schenectady | New York | 36093 | 17802 | 233 |
1902986 | 1902986 | 2021-11-10 | Schoharie | New York | 36095 | 2457 | 24 |
1902987 | 1902987 | 2021-11-10 | Schuyler | New York | 36097 | 1697 | 19 |
1902988 | 1902988 | 2021-11-10 | Seneca | New York | 36099 | 2884 | 65 |
1902989 | 1902989 | 2021-11-10 | St. Lawrence | New York | 36089 | 11609 | 138 |
1902990 | 1902990 | 2021-11-10 | Steuben | New York | 36101 | 11086 | 182 |
1902991 | 1902991 | 2021-11-10 | Suffolk | New York | 36103 | 245247 | 3645 |
1902992 | 1902992 | 2021-11-10 | Sullivan | New York | 36105 | 8859 | 85 |
1902993 | 1902993 | 2021-11-10 | Tioga | New York | 36107 | 5678 | 73 |
1902994 | 1902994 | 2021-11-10 | Tompkins | New York | 36109 | 6831 | 60 |
1902995 | 1902995 | 2021-11-10 | Ulster | New York | 36111 | 17853 | 286 |
1902996 | 1902996 | 2021-11-10 | Warren | New York | 36113 | 6190 | 89 |
1902997 | 1902997 | 2021-11-10 | Washington | New York | 36115 | 5358 | 72 |
1902998 | 1902998 | 2021-11-10 | Wayne | New York | 36117 | 9007 | 94 |
1902999 | 1902999 | 2021-11-10 | Westchester | New York | 36119 | 145179 | 2352 |
1903000 | 1903000 | 2021-11-10 | Wyoming | New York | 36121 | 4710 | 62 |
1903001 | 1903001 | 2021-11-10 | Yates | New York | 36123 | 1797 | 30 |
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);