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 2022-01-21 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 |
---|---|---|---|---|---|---|---|
2136996 | 2136996 | 2022-01-21 | Albany | New York | 36001 | 53355 | 472 |
2136997 | 2136997 | 2022-01-21 | Allegany | New York | 36003 | 7941 | 140 |
2136998 | 2136998 | 2022-01-21 | Broome | New York | 36007 | 40747 | 486 |
2136999 | 2136999 | 2022-01-21 | Cattaraugus | New York | 36009 | 13686 | 200 |
2137000 | 2137000 | 2022-01-21 | Cayuga | New York | 36011 | 14303 | 128 |
2137001 | 2137001 | 2022-01-21 | Chautauqua | New York | 36013 | 21345 | 246 |
2137002 | 2137002 | 2022-01-21 | Chemung | New York | 36015 | 19137 | 207 |
2137003 | 2137003 | 2022-01-21 | Chenango | New York | 36017 | 8156 | 107 |
2137004 | 2137004 | 2022-01-21 | Clinton | New York | 36019 | 13570 | 66 |
2137005 | 2137005 | 2022-01-21 | Columbia | New York | 36021 | 8971 | 131 |
2137006 | 2137006 | 2022-01-21 | Cortland | New York | 36023 | 9260 | 96 |
2137007 | 2137007 | 2022-01-21 | Delaware | New York | 36025 | 6843 | 64 |
2137008 | 2137008 | 2022-01-21 | Dutchess | New York | 36027 | 59464 | 585 |
2137009 | 2137009 | 2022-01-21 | Erie | New York | 36029 | 191950 | 2384 |
2137010 | 2137010 | 2022-01-21 | Essex | New York | 36031 | 4765 | 52 |
2137011 | 2137011 | 2022-01-21 | Franklin | New York | 36033 | 7916 | 37 |
2137012 | 2137012 | 2022-01-21 | Fulton | New York | 36035 | 10990 | 143 |
2137013 | 2137013 | 2022-01-21 | Genesee | New York | 36037 | 12589 | 173 |
2137014 | 2137014 | 2022-01-21 | Greene | New York | 36039 | 7793 | 107 |
2137015 | 2137015 | 2022-01-21 | Hamilton | New York | 36041 | 766 | 4 |
2137016 | 2137016 | 2022-01-21 | Herkimer | New York | 36043 | 12353 | 170 |
2137017 | 2137017 | 2022-01-21 | Jefferson | New York | 36045 | 17236 | 121 |
2137018 | 2137018 | 2022-01-21 | Lewis | New York | 36049 | 5619 | 45 |
2137019 | 2137019 | 2022-01-21 | Livingston | New York | 36051 | 10467 | 100 |
2137020 | 2137020 | 2022-01-21 | Madison | New York | 36053 | 11311 | 120 |
2137021 | 2137021 | 2022-01-21 | Monroe | New York | 36055 | 140451 | 1423 |
2137022 | 2137022 | 2022-01-21 | Montgomery | New York | 36057 | 10486 | 182 |
2137023 | 2137023 | 2022-01-21 | Nassau | New York | 36059 | 382820 | 3611 |
2137024 | 2137024 | 2022-01-21 | New York City | New York | 2171659 | 37364 | |
2137025 | 2137025 | 2022-01-21 | Niagara | New York | 36063 | 43976 | 508 |
2137026 | 2137026 | 2022-01-21 | Oneida | New York | 36065 | 47935 | 728 |
2137027 | 2137027 | 2022-01-21 | Onondaga | New York | 36067 | 96720 | 939 |
2137028 | 2137028 | 2022-01-21 | Ontario | New York | 36069 | 17637 | 161 |
2137029 | 2137029 | 2022-01-21 | Orange | New York | 36071 | 100123 | 890 |
2137030 | 2137030 | 2022-01-21 | Orleans | New York | 36073 | 7896 | 105 |
2137031 | 2137031 | 2022-01-21 | Oswego | New York | 36075 | 21963 | 158 |
2137032 | 2137032 | 2022-01-21 | Otsego | New York | 36077 | 8583 | 76 |
2137033 | 2137033 | 2022-01-21 | Putnam | New York | 36079 | 22208 | 115 |
2137034 | 2137034 | 2022-01-21 | Rensselaer | New York | 36083 | 27956 | 230 |
2137035 | 2137035 | 2022-01-21 | Rockland | New York | 36087 | 87552 | 851 |
2137036 | 2137036 | 2022-01-21 | Saratoga | New York | 36091 | 40979 | 293 |
2137037 | 2137037 | 2022-01-21 | Schenectady | New York | 36093 | 29677 | 280 |
2137038 | 2137038 | 2022-01-21 | Schoharie | New York | 36095 | 4393 | 32 |
2137039 | 2137039 | 2022-01-21 | Schuyler | New York | 36097 | 3063 | 23 |
2137040 | 2137040 | 2022-01-21 | Seneca | New York | 36099 | 5078 | 87 |
2137041 | 2137041 | 2022-01-21 | St. Lawrence | New York | 36089 | 18013 | 164 |
2137042 | 2137042 | 2022-01-21 | Steuben | New York | 36101 | 17457 | 225 |
2137043 | 2137043 | 2022-01-21 | Suffolk | New York | 36103 | 406417 | 4097 |
2137044 | 2137044 | 2022-01-21 | Sullivan | New York | 36105 | 16901 | 112 |
2137045 | 2137045 | 2022-01-21 | Tioga | New York | 36107 | 9459 | 79 |
2137046 | 2137046 | 2022-01-21 | Tompkins | New York | 36109 | 15315 | 75 |
2137047 | 2137047 | 2022-01-21 | Ulster | New York | 36111 | 28467 | 329 |
2137048 | 2137048 | 2022-01-21 | Warren | New York | 36113 | 11942 | 115 |
2137049 | 2137049 | 2022-01-21 | Washington | New York | 36115 | 10649 | 102 |
2137050 | 2137050 | 2022-01-21 | Wayne | New York | 36117 | 15266 | 147 |
2137051 | 2137051 | 2022-01-21 | Westchester | New York | 36119 | 236806 | 2545 |
2137052 | 2137052 | 2022-01-21 | Wyoming | New York | 36121 | 7651 | 77 |
2137053 | 2137053 | 2022-01-21 | Yates | New York | 36123 | 2956 | 36 |
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);