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-11-07 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 |
---|---|---|---|---|---|---|---|
708099 | 708099 | 2020-11-07 | Albany | New York | 36001 | 4024 | 131 |
708100 | 708100 | 2020-11-07 | Allegany | New York | 36003 | 455 | 24 |
708101 | 708101 | 2020-11-07 | Broome | New York | 36007 | 3982 | 113 |
708102 | 708102 | 2020-11-07 | Cattaraugus | New York | 36009 | 599 | 20 |
708103 | 708103 | 2020-11-07 | Cayuga | New York | 36011 | 518 | 5 |
708104 | 708104 | 2020-11-07 | Chautauqua | New York | 36013 | 1103 | 5 |
708105 | 708105 | 2020-11-07 | Chemung | New York | 36015 | 2096 | 19 |
708106 | 708106 | 2020-11-07 | Chenango | New York | 36017 | 455 | 7 |
708107 | 708107 | 2020-11-07 | Clinton | New York | 36019 | 297 | 5 |
708108 | 708108 | 2020-11-07 | Columbia | New York | 36021 | 789 | 53 |
708109 | 708109 | 2020-11-07 | Cortland | New York | 36023 | 633 | 1 |
708110 | 708110 | 2020-11-07 | Delaware | New York | 36025 | 227 | 6 |
708111 | 708111 | 2020-11-07 | Dutchess | New York | 36027 | 5739 | 168 |
708112 | 708112 | 2020-11-07 | Erie | New York | 36029 | 14717 | 661 |
708113 | 708113 | 2020-11-07 | Essex | New York | 36031 | 224 | 14 |
708114 | 708114 | 2020-11-07 | Franklin | New York | 36033 | 127 | 1 |
708115 | 708115 | 2020-11-07 | Fulton | New York | 36035 | 372 | 28 |
708116 | 708116 | 2020-11-07 | Genesee | New York | 36037 | 465 | 6 |
708117 | 708117 | 2020-11-07 | Greene | New York | 36039 | 552 | 15 |
708118 | 708118 | 2020-11-07 | Hamilton | New York | 36041 | 19 | 1 |
708119 | 708119 | 2020-11-07 | Herkimer | New York | 36043 | 443 | 10 |
708120 | 708120 | 2020-11-07 | Jefferson | New York | 36045 | 262 | 1 |
708121 | 708121 | 2020-11-07 | Lewis | New York | 36049 | 173 | 5 |
708122 | 708122 | 2020-11-07 | Livingston | New York | 36051 | 402 | 7 |
708123 | 708123 | 2020-11-07 | Madison | New York | 36053 | 643 | 9 |
708124 | 708124 | 2020-11-07 | Monroe | New York | 36055 | 8617 | 262 |
708125 | 708125 | 2020-11-07 | Montgomery | New York | 36057 | 295 | 9 |
708126 | 708126 | 2020-11-07 | Nassau | New York | 36059 | 51418 | 2221 |
708127 | 708127 | 2020-11-07 | New York City | New York | 274551 | 24060 | |
708128 | 708128 | 2020-11-07 | Niagara | New York | 36063 | 2313 | 91 |
708129 | 708129 | 2020-11-07 | Oneida | New York | 36065 | 3039 | 133 |
708130 | 708130 | 2020-11-07 | Onondaga | New York | 36067 | 6396 | 187 |
708131 | 708131 | 2020-11-07 | Ontario | New York | 36069 | 794 | 29 |
708132 | 708132 | 2020-11-07 | Orange | New York | 36071 | 14316 | 421 |
708133 | 708133 | 2020-11-07 | Orleans | New York | 36073 | 434 | 55 |
708134 | 708134 | 2020-11-07 | Oswego | New York | 36075 | 734 | 4 |
708135 | 708135 | 2020-11-07 | Otsego | New York | 36077 | 442 | 5 |
708136 | 708136 | 2020-11-07 | Putnam | New York | 36079 | 1937 | 64 |
708137 | 708137 | 2020-11-07 | Rensselaer | New York | 36083 | 1184 | 44 |
708138 | 708138 | 2020-11-07 | Rockland | New York | 36087 | 18854 | 514 |
708139 | 708139 | 2020-11-07 | Saratoga | New York | 36091 | 1520 | 17 |
708140 | 708140 | 2020-11-07 | Schenectady | New York | 36093 | 1701 | 52 |
708141 | 708141 | 2020-11-07 | Schoharie | New York | 36095 | 121 | 2 |
708142 | 708142 | 2020-11-07 | Schuyler | New York | 36097 | 178 | 3 |
708143 | 708143 | 2020-11-07 | Seneca | New York | 36099 | 171 | 2 |
708144 | 708144 | 2020-11-07 | St. Lawrence | New York | 36089 | 471 | 5 |
708145 | 708145 | 2020-11-07 | Steuben | New York | 36101 | 1200 | 71 |
708146 | 708146 | 2020-11-07 | Suffolk | New York | 36103 | 50469 | 2022 |
708147 | 708147 | 2020-11-07 | Sullivan | New York | 36105 | 1891 | 37 |
708148 | 708148 | 2020-11-07 | Tioga | New York | 36107 | 823 | 38 |
708149 | 708149 | 2020-11-07 | Tompkins | New York | 36109 | 690 | 0 |
708150 | 708150 | 2020-11-07 | Ulster | New York | 36111 | 2607 | 87 |
708151 | 708151 | 2020-11-07 | Warren | New York | 36113 | 480 | 30 |
708152 | 708152 | 2020-11-07 | Washington | New York | 36115 | 380 | 14 |
708153 | 708153 | 2020-11-07 | Wayne | New York | 36117 | 655 | 6 |
708154 | 708154 | 2020-11-07 | Westchester | New York | 36119 | 41953 | 1476 |
708155 | 708155 | 2020-11-07 | Wyoming | New York | 36121 | 243 | 5 |
708156 | 708156 | 2020-11-07 | Yates | New York | 36123 | 161 | 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);