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-11 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 |
---|---|---|---|---|---|---|---|
1019649 | 1019649 | 2021-02-11 | Albany | New York | 36001 | 19748 | 316 |
1019650 | 1019650 | 2021-02-11 | Allegany | New York | 36003 | 2721 | 80 |
1019651 | 1019651 | 2021-02-11 | Broome | New York | 36007 | 13532 | 317 |
1019652 | 1019652 | 2021-02-11 | Cattaraugus | New York | 36009 | 4075 | 72 |
1019653 | 1019653 | 2021-02-11 | Cayuga | New York | 36011 | 5094 | 86 |
1019654 | 1019654 | 2021-02-11 | Chautauqua | New York | 36013 | 6940 | 118 |
1019655 | 1019655 | 2021-02-11 | Chemung | New York | 36015 | 6240 | 123 |
1019656 | 1019656 | 2021-02-11 | Chenango | New York | 36017 | 2285 | 61 |
1019657 | 1019657 | 2021-02-11 | Clinton | New York | 36019 | 3103 | 22 |
1019658 | 1019658 | 2021-02-11 | Columbia | New York | 36021 | 3178 | 90 |
1019659 | 1019659 | 2021-02-11 | Cortland | New York | 36023 | 2981 | 60 |
1019660 | 1019660 | 2021-02-11 | Delaware | New York | 36025 | 1321 | 31 |
1019661 | 1019661 | 2021-02-11 | Dutchess | New York | 36027 | 20477 | 388 |
1019662 | 1019662 | 2021-02-11 | Erie | New York | 36029 | 60736 | 1526 |
1019663 | 1019663 | 2021-02-11 | Essex | New York | 36031 | 1210 | 24 |
1019664 | 1019664 | 2021-02-11 | Franklin | New York | 36033 | 1753 | 11 |
1019665 | 1019665 | 2021-02-11 | Fulton | New York | 36035 | 2917 | 74 |
1019666 | 1019666 | 2021-02-11 | Genesee | New York | 36037 | 4159 | 117 |
1019667 | 1019667 | 2021-02-11 | Greene | New York | 36039 | 2493 | 67 |
1019668 | 1019668 | 2021-02-11 | Hamilton | New York | 36041 | 261 | 1 |
1019669 | 1019669 | 2021-02-11 | Herkimer | New York | 36043 | 4401 | 101 |
1019670 | 1019670 | 2021-02-11 | Jefferson | New York | 36045 | 4352 | 55 |
1019671 | 1019671 | 2021-02-11 | Lewis | New York | 36049 | 1891 | 28 |
1019672 | 1019672 | 2021-02-11 | Livingston | New York | 36051 | 3278 | 52 |
1019673 | 1019673 | 2021-02-11 | Madison | New York | 36053 | 3657 | 81 |
1019674 | 1019674 | 2021-02-11 | Monroe | New York | 36055 | 50081 | 946 |
1019675 | 1019675 | 2021-02-11 | Montgomery | New York | 36057 | 2906 | 96 |
1019676 | 1019676 | 2021-02-11 | Nassau | New York | 36059 | 137196 | 2790 |
1019677 | 1019677 | 2021-02-11 | New York City | New York | 655228 | 28021 | |
1019678 | 1019678 | 2021-02-11 | Niagara | New York | 36063 | 14557 | 293 |
1019679 | 1019679 | 2021-02-11 | Oneida | New York | 36065 | 19031 | 452 |
1019680 | 1019680 | 2021-02-11 | Onondaga | New York | 36067 | 31167 | 603 |
1019681 | 1019681 | 2021-02-11 | Ontario | New York | 36069 | 5446 | 88 |
1019682 | 1019682 | 2021-02-11 | Orange | New York | 36071 | 34072 | 607 |
1019683 | 1019683 | 2021-02-11 | Orleans | New York | 36073 | 2336 | 79 |
1019684 | 1019684 | 2021-02-11 | Oswego | New York | 36075 | 5710 | 86 |
1019685 | 1019685 | 2021-02-11 | Otsego | New York | 36077 | 2132 | 39 |
1019686 | 1019686 | 2021-02-11 | Putnam | New York | 36079 | 7746 | 84 |
1019687 | 1019687 | 2021-02-11 | Rensselaer | New York | 36083 | 8459 | 121 |
1019688 | 1019688 | 2021-02-11 | Rockland | New York | 36087 | 36247 | 666 |
1019689 | 1019689 | 2021-02-11 | Saratoga | New York | 36091 | 11212 | 138 |
1019690 | 1019690 | 2021-02-11 | Schenectady | New York | 36093 | 10320 | 170 |
1019691 | 1019691 | 2021-02-11 | Schoharie | New York | 36095 | 1089 | 9 |
1019692 | 1019692 | 2021-02-11 | Schuyler | New York | 36097 | 837 | 11 |
1019693 | 1019693 | 2021-02-11 | Seneca | New York | 36099 | 1472 | 50 |
1019694 | 1019694 | 2021-02-11 | St. Lawrence | New York | 36089 | 4833 | 74 |
1019695 | 1019695 | 2021-02-11 | Steuben | New York | 36101 | 5303 | 137 |
1019696 | 1019696 | 2021-02-11 | Suffolk | New York | 36103 | 151793 | 2923 |
1019697 | 1019697 | 2021-02-11 | Sullivan | New York | 36105 | 4444 | 58 |
1019698 | 1019698 | 2021-02-11 | Tioga | New York | 36107 | 2631 | 56 |
1019699 | 1019699 | 2021-02-11 | Tompkins | New York | 36109 | 3274 | 39 |
1019700 | 1019700 | 2021-02-11 | Ulster | New York | 36111 | 9345 | 220 |
1019701 | 1019701 | 2021-02-11 | Warren | New York | 36113 | 2654 | 53 |
1019702 | 1019702 | 2021-02-11 | Washington | New York | 36115 | 2110 | 48 |
1019703 | 1019703 | 2021-02-11 | Wayne | New York | 36117 | 4273 | 59 |
1019704 | 1019704 | 2021-02-11 | Westchester | New York | 36119 | 99983 | 2002 |
1019705 | 1019705 | 2021-02-11 | Wyoming | New York | 36121 | 2643 | 48 |
1019706 | 1019706 | 2021-02-11 | Yates | New York | 36123 | 994 | 25 |
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);