ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 49 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
789242 | 789242 | 2020-12-02 | Hamilton | New York | 36041 | 49 | 1 |
594615 | 594615 | 2020-10-03 | Schuyler | New York | 36097 | 49 | 0 |
591374 | 591374 | 2020-10-02 | Schuyler | New York | 36097 | 49 | 0 |
513632 | 513632 | 2020-09-08 | Lewis | New York | 36049 | 49 | 5 |
510399 | 510399 | 2020-09-07 | Lewis | New York | 36049 | 49 | 5 |
507166 | 507166 | 2020-09-06 | Lewis | New York | 36049 | 49 | 5 |
503934 | 503934 | 2020-09-05 | Lewis | New York | 36049 | 49 | 5 |
500700 | 500700 | 2020-09-04 | Lewis | New York | 36049 | 49 | 5 |
497466 | 497466 | 2020-09-03 | Lewis | New York | 36049 | 49 | 5 |
494233 | 494233 | 2020-09-02 | Lewis | New York | 36049 | 49 | 5 |
490999 | 490999 | 2020-09-01 | Lewis | New York | 36049 | 49 | 5 |
487766 | 487766 | 2020-08-31 | Lewis | New York | 36049 | 49 | 5 |
484533 | 484533 | 2020-08-30 | Lewis | New York | 36049 | 49 | 5 |
333309 | 333309 | 2020-07-14 | Yates | New York | 36123 | 49 | 6 |
276286 | 276286 | 2020-06-26 | Essex | New York | 36031 | 49 | 0 |
273140 | 273140 | 2020-06-25 | Essex | New York | 36031 | 49 | 0 |
270001 | 270001 | 2020-06-24 | Essex | New York | 36031 | 49 | 0 |
266867 | 266867 | 2020-06-23 | Essex | New York | 36031 | 49 | 0 |
263739 | 263739 | 2020-06-22 | Essex | New York | 36031 | 49 | 0 |
260611 | 260611 | 2020-06-21 | Essex | New York | 36031 | 49 | 0 |
257484 | 257484 | 2020-06-20 | Essex | New York | 36031 | 49 | 0 |
207820 | 207820 | 2020-06-04 | Allegany | New York | 36003 | 49 | 0 |
204739 | 204739 | 2020-06-03 | Allegany | New York | 36003 | 49 | 0 |
189422 | 189422 | 2020-05-29 | Schoharie | New York | 36095 | 49 | 0 |
186362 | 186362 | 2020-05-28 | Schoharie | New York | 36095 | 49 | 0 |
183305 | 183305 | 2020-05-27 | Schoharie | New York | 36095 | 49 | 0 |
180257 | 180257 | 2020-05-26 | Schoharie | New York | 36095 | 49 | 0 |
177214 | 177214 | 2020-05-25 | Schoharie | New York | 36095 | 49 | 0 |
174170 | 174170 | 2020-05-24 | Schoharie | New York | 36095 | 49 | 0 |
171128 | 171128 | 2020-05-23 | Schoharie | New York | 36095 | 49 | 0 |
168089 | 168089 | 2020-05-22 | Schoharie | New York | 36095 | 49 | 0 |
165054 | 165054 | 2020-05-21 | Schoharie | New York | 36095 | 49 | 0 |
158961 | 158961 | 2020-05-19 | Chautauqua | New York | 36013 | 49 | 3 |
155943 | 155943 | 2020-05-18 | Chautauqua | New York | 36013 | 49 | 3 |
146948 | 146948 | 2020-05-15 | Seneca | New York | 36099 | 49 | 0 |
143947 | 143947 | 2020-05-14 | Seneca | New York | 36099 | 49 | 0 |
140952 | 140952 | 2020-05-13 | Seneca | New York | 36099 | 49 | 0 |
137956 | 137956 | 2020-05-12 | Seneca | New York | 36099 | 49 | 0 |
134966 | 134966 | 2020-05-11 | Seneca | New York | 36099 | 49 | 0 |
131975 | 131975 | 2020-05-10 | Seneca | New York | 36099 | 49 | 0 |
105536 | 105536 | 2020-05-01 | Cattaraugus | New York | 36009 | 49 | 1 |
96997 | 96997 | 2020-04-28 | Montgomery | New York | 36057 | 49 | 1 |
82914 | 82914 | 2020-04-23 | Oswego | New York | 36075 | 49 | 0 |
80115 | 80115 | 2020-04-22 | Oswego | New York | 36075 | 49 | 0 |
80116 | 80116 | 2020-04-22 | Otsego | New York | 36077 | 49 | 5 |
77302 | 77302 | 2020-04-21 | Delaware | New York | 36025 | 49 | 0 |
77326 | 77326 | 2020-04-21 | Oswego | New York | 36075 | 49 | 0 |
77327 | 77327 | 2020-04-21 | Otsego | New York | 36077 | 49 | 5 |
74521 | 74521 | 2020-04-20 | Delaware | New York | 36025 | 49 | 0 |
74530 | 74530 | 2020-04-20 | Herkimer | New York | 36043 | 49 | 1 |
74546 | 74546 | 2020-04-20 | Otsego | New York | 36077 | 49 | 5 |
71743 | 71743 | 2020-04-19 | Clinton | New York | 36019 | 49 | 3 |
71746 | 71746 | 2020-04-19 | Delaware | New York | 36025 | 49 | 0 |
71755 | 71755 | 2020-04-19 | Herkimer | New York | 36043 | 49 | 1 |
68979 | 68979 | 2020-04-18 | Delaware | New York | 36025 | 49 | 0 |
69023 | 69023 | 2020-04-18 | Wayne | New York | 36117 | 49 | 0 |
66266 | 66266 | 2020-04-17 | Wayne | New York | 36117 | 49 | 0 |
63523 | 63523 | 2020-04-16 | Wayne | New York | 36117 | 49 | 0 |
39571 | 39571 | 2020-04-07 | Chemung | New York | 36015 | 49 | 0 |
29809 | 29809 | 2020-04-03 | Steuben | New York | 36101 | 49 | 1 |
27485 | 27485 | 2020-04-02 | Steuben | New York | 36101 | 49 | 1 |
6710 | 6710 | 2020-03-21 | Dutchess | New York | 36027 | 49 | 0 |
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);