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 2020-10-12 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 |
---|---|---|---|---|---|---|---|
623753 | 623753 | 2020-10-12 | Albany | New York | 36001 | 3304 | 124 |
623754 | 623754 | 2020-10-12 | Allegany | New York | 36003 | 151 | 4 |
623755 | 623755 | 2020-10-12 | Broome | New York | 36007 | 2485 | 86 |
623756 | 623756 | 2020-10-12 | Cattaraugus | New York | 36009 | 362 | 13 |
623757 | 623757 | 2020-10-12 | Cayuga | New York | 36011 | 246 | 3 |
623758 | 623758 | 2020-10-12 | Chautauqua | New York | 36013 | 695 | 4 |
623759 | 623759 | 2020-10-12 | Chemung | New York | 36015 | 985 | 7 |
623760 | 623760 | 2020-10-12 | Chenango | New York | 36017 | 277 | 6 |
623761 | 623761 | 2020-10-12 | Clinton | New York | 36019 | 179 | 5 |
623762 | 623762 | 2020-10-12 | Columbia | New York | 36021 | 624 | 47 |
623763 | 623763 | 2020-10-12 | Cortland | New York | 36023 | 317 | 1 |
623764 | 623764 | 2020-10-12 | Delaware | New York | 36025 | 149 | 5 |
623765 | 623765 | 2020-10-12 | Dutchess | New York | 36027 | 5259 | 162 |
623766 | 623766 | 2020-10-12 | Erie | New York | 36029 | 12154 | 639 |
623767 | 623767 | 2020-10-12 | Essex | New York | 36031 | 187 | 14 |
623768 | 623768 | 2020-10-12 | Franklin | New York | 36033 | 71 | 1 |
623769 | 623769 | 2020-10-12 | Fulton | New York | 36035 | 352 | 28 |
623770 | 623770 | 2020-10-12 | Genesee | New York | 36037 | 359 | 6 |
623771 | 623771 | 2020-10-12 | Greene | New York | 36039 | 388 | 15 |
623772 | 623772 | 2020-10-12 | Hamilton | New York | 36041 | 15 | 1 |
623773 | 623773 | 2020-10-12 | Herkimer | New York | 36043 | 361 | 10 |
623774 | 623774 | 2020-10-12 | Jefferson | New York | 36045 | 185 | 1 |
623775 | 623775 | 2020-10-12 | Lewis | New York | 36049 | 55 | 5 |
623776 | 623776 | 2020-10-12 | Livingston | New York | 36051 | 225 | 6 |
623777 | 623777 | 2020-10-12 | Madison | New York | 36053 | 511 | 9 |
623778 | 623778 | 2020-10-12 | Monroe | New York | 36055 | 6454 | 260 |
623779 | 623779 | 2020-10-12 | Montgomery | New York | 36057 | 245 | 9 |
623780 | 623780 | 2020-10-12 | Nassau | New York | 36059 | 47998 | 2204 |
623781 | 623781 | 2020-10-12 | New York City | New York | 255464 | 23890 | |
623782 | 623782 | 2020-10-12 | Niagara | New York | 36063 | 1902 | 89 |
623783 | 623783 | 2020-10-12 | Oneida | New York | 36065 | 2549 | 126 |
623784 | 623784 | 2020-10-12 | Onondaga | New York | 36067 | 4807 | 182 |
623785 | 623785 | 2020-10-12 | Ontario | New York | 36069 | 519 | 28 |
623786 | 623786 | 2020-10-12 | Orange | New York | 36071 | 12884 | 416 |
623787 | 623787 | 2020-10-12 | Orleans | New York | 36073 | 352 | 55 |
623788 | 623788 | 2020-10-12 | Oswego | New York | 36075 | 552 | 3 |
623789 | 623789 | 2020-10-12 | Otsego | New York | 36077 | 360 | 4 |
623790 | 623790 | 2020-10-12 | Putnam | New York | 36079 | 1689 | 63 |
623791 | 623791 | 2020-10-12 | Rensselaer | New York | 36083 | 985 | 42 |
623792 | 623792 | 2020-10-12 | Rockland | New York | 36087 | 16760 | 509 |
623793 | 623793 | 2020-10-12 | Saratoga | New York | 36091 | 1158 | 15 |
623794 | 623794 | 2020-10-12 | Schenectady | New York | 36093 | 1459 | 47 |
623795 | 623795 | 2020-10-12 | Schoharie | New York | 36095 | 94 | 2 |
623796 | 623796 | 2020-10-12 | Schuyler | New York | 36097 | 72 | 0 |
623797 | 623797 | 2020-10-12 | Seneca | New York | 36099 | 120 | 2 |
623798 | 623798 | 2020-10-12 | St. Lawrence | New York | 36089 | 345 | 4 |
623799 | 623799 | 2020-10-12 | Steuben | New York | 36101 | 702 | 63 |
623800 | 623800 | 2020-10-12 | Suffolk | New York | 36103 | 47493 | 2017 |
623801 | 623801 | 2020-10-12 | Sullivan | New York | 36105 | 1650 | 37 |
623802 | 623802 | 2020-10-12 | Tioga | New York | 36107 | 352 | 23 |
623803 | 623803 | 2020-10-12 | Tompkins | New York | 36109 | 481 | 0 |
623804 | 623804 | 2020-10-12 | Ulster | New York | 36111 | 2366 | 84 |
623805 | 623805 | 2020-10-12 | Warren | New York | 36113 | 430 | 30 |
623806 | 623806 | 2020-10-12 | Washington | New York | 36115 | 318 | 14 |
623807 | 623807 | 2020-10-12 | Wayne | New York | 36117 | 365 | 3 |
623808 | 623808 | 2020-10-12 | Westchester | New York | 36119 | 39000 | 1462 |
623809 | 623809 | 2020-10-12 | Wyoming | New York | 36121 | 152 | 5 |
623810 | 623810 | 2020-10-12 | Yates | New York | 36123 | 72 | 6 |
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);