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-02-20 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 |
---|---|---|---|---|---|---|---|
1048859 | 1048859 | 2021-02-20 | Albany | New York | 36001 | 20336 | 324 |
1048860 | 1048860 | 2021-02-20 | Allegany | New York | 36003 | 2832 | 81 |
1048861 | 1048861 | 2021-02-20 | Broome | New York | 36007 | 14145 | 328 |
1048862 | 1048862 | 2021-02-20 | Cattaraugus | New York | 36009 | 4269 | 76 |
1048863 | 1048863 | 2021-02-20 | Cayuga | New York | 36011 | 5242 | 87 |
1048864 | 1048864 | 2021-02-20 | Chautauqua | New York | 36013 | 7152 | 121 |
1048865 | 1048865 | 2021-02-20 | Chemung | New York | 36015 | 6350 | 129 |
1048866 | 1048866 | 2021-02-20 | Chenango | New York | 36017 | 2359 | 68 |
1048867 | 1048867 | 2021-02-20 | Clinton | New York | 36019 | 3369 | 25 |
1048868 | 1048868 | 2021-02-20 | Columbia | New York | 36021 | 3312 | 93 |
1048869 | 1048869 | 2021-02-20 | Cortland | New York | 36023 | 3074 | 60 |
1048870 | 1048870 | 2021-02-20 | Delaware | New York | 36025 | 1438 | 32 |
1048871 | 1048871 | 2021-02-20 | Dutchess | New York | 36027 | 21452 | 401 |
1048872 | 1048872 | 2021-02-20 | Erie | New York | 36029 | 63248 | 1573 |
1048873 | 1048873 | 2021-02-20 | Essex | New York | 36031 | 1299 | 26 |
1048874 | 1048874 | 2021-02-20 | Franklin | New York | 36033 | 1935 | 12 |
1048875 | 1048875 | 2021-02-20 | Fulton | New York | 36035 | 3170 | 80 |
1048876 | 1048876 | 2021-02-20 | Genesee | New York | 36037 | 4272 | 118 |
1048877 | 1048877 | 2021-02-20 | Greene | New York | 36039 | 2573 | 68 |
1048878 | 1048878 | 2021-02-20 | Hamilton | New York | 36041 | 276 | 2 |
1048879 | 1048879 | 2021-02-20 | Herkimer | New York | 36043 | 4499 | 104 |
1048880 | 1048880 | 2021-02-20 | Jefferson | New York | 36045 | 4582 | 63 |
1048881 | 1048881 | 2021-02-20 | Lewis | New York | 36049 | 1996 | 29 |
1048882 | 1048882 | 2021-02-20 | Livingston | New York | 36051 | 3434 | 54 |
1048883 | 1048883 | 2021-02-20 | Madison | New York | 36053 | 3755 | 84 |
1048884 | 1048884 | 2021-02-20 | Monroe | New York | 36055 | 51424 | 969 |
1048885 | 1048885 | 2021-02-20 | Montgomery | New York | 36057 | 3079 | 102 |
1048886 | 1048886 | 2021-02-20 | Nassau | New York | 36059 | 143069 | 2863 |
1048887 | 1048887 | 2021-02-20 | New York City | New York | 694295 | 28748 | |
1048888 | 1048888 | 2021-02-20 | Niagara | New York | 36063 | 14957 | 303 |
1048889 | 1048889 | 2021-02-20 | Oneida | New York | 36065 | 19351 | 471 |
1048890 | 1048890 | 2021-02-20 | Onondaga | New York | 36067 | 31848 | 616 |
1048891 | 1048891 | 2021-02-20 | Ontario | New York | 36069 | 5626 | 88 |
1048892 | 1048892 | 2021-02-20 | Orange | New York | 36071 | 35511 | 629 |
1048893 | 1048893 | 2021-02-20 | Orleans | New York | 36073 | 2394 | 80 |
1048894 | 1048894 | 2021-02-20 | Oswego | New York | 36075 | 5875 | 89 |
1048895 | 1048895 | 2021-02-20 | Otsego | New York | 36077 | 2238 | 42 |
1048896 | 1048896 | 2021-02-20 | Putnam | New York | 36079 | 8085 | 86 |
1048897 | 1048897 | 2021-02-20 | Rensselaer | New York | 36083 | 8760 | 129 |
1048898 | 1048898 | 2021-02-20 | Rockland | New York | 36087 | 37478 | 679 |
1048899 | 1048899 | 2021-02-20 | Saratoga | New York | 36091 | 11560 | 141 |
1048900 | 1048900 | 2021-02-20 | Schenectady | New York | 36093 | 10593 | 176 |
1048901 | 1048901 | 2021-02-20 | Schoharie | New York | 36095 | 1160 | 11 |
1048902 | 1048902 | 2021-02-20 | Schuyler | New York | 36097 | 847 | 12 |
1048903 | 1048903 | 2021-02-20 | Seneca | New York | 36099 | 1532 | 53 |
1048904 | 1048904 | 2021-02-20 | St. Lawrence | New York | 36089 | 5194 | 76 |
1048905 | 1048905 | 2021-02-20 | Steuben | New York | 36101 | 5415 | 137 |
1048906 | 1048906 | 2021-02-20 | Suffolk | New York | 36103 | 157516 | 3022 |
1048907 | 1048907 | 2021-02-20 | Sullivan | New York | 36105 | 4594 | 58 |
1048908 | 1048908 | 2021-02-20 | Tioga | New York | 36107 | 2740 | 56 |
1048909 | 1048909 | 2021-02-20 | Tompkins | New York | 36109 | 3376 | 42 |
1048910 | 1048910 | 2021-02-20 | Ulster | New York | 36111 | 9698 | 226 |
1048911 | 1048911 | 2021-02-20 | Warren | New York | 36113 | 2763 | 53 |
1048912 | 1048912 | 2021-02-20 | Washington | New York | 36115 | 2232 | 50 |
1048913 | 1048913 | 2021-02-20 | Wayne | New York | 36117 | 4370 | 63 |
1048914 | 1048914 | 2021-02-20 | Westchester | New York | 36119 | 103989 | 2051 |
1048915 | 1048915 | 2021-02-20 | Wyoming | New York | 36121 | 2748 | 48 |
1048916 | 1048916 | 2021-02-20 | Yates | New York | 36123 | 1006 | 26 |
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);