ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 89 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 19
county 19
- Allegany 4
- Delaware 3
- Cattaraugus 2
- Otsego 2
- Seneca 2
- Wyoming 2
- Cayuga 1
- Chautauqua 1
- Cortland 1
- Greene 1
- Livingston 1
- Madison 1
- Montgomery 1
- Orleans 1
- Oswego 1
- St. Lawrence 1
- Steuben 1
- Ulster 1
- Wayne 1
state 1
- New York · 28 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
494212 | 494212 | 2020-09-02 | Allegany | New York | 36003 | 89 | 2 |
490978 | 490978 | 2020-09-01 | Allegany | New York | 36003 | 89 | 2 |
487745 | 487745 | 2020-08-31 | Allegany | New York | 36003 | 89 | 2 |
484512 | 484512 | 2020-08-30 | Allegany | New York | 36003 | 89 | 2 |
416770 | 416770 | 2020-08-09 | Seneca | New York | 36099 | 89 | 1 |
413549 | 413549 | 2020-08-08 | Seneca | New York | 36099 | 89 | 1 |
378121 | 378121 | 2020-07-28 | Cortland | New York | 36023 | 89 | 0 |
330098 | 330098 | 2020-07-13 | Otsego | New York | 36077 | 89 | 6 |
326911 | 326911 | 2020-07-12 | Otsego | New York | 36077 | 89 | 6 |
254358 | 254358 | 2020-06-19 | Delaware | New York | 36025 | 89 | 0 |
251243 | 251243 | 2020-06-18 | Delaware | New York | 36025 | 89 | 0 |
248128 | 248128 | 2020-06-17 | Delaware | New York | 36025 | 89 | 0 |
217131 | 217131 | 2020-06-07 | Wyoming | New York | 36121 | 89 | 3 |
214041 | 214041 | 2020-06-06 | Wyoming | New York | 36121 | 89 | 3 |
204743 | 204743 | 2020-06-03 | Chautauqua | New York | 36013 | 89 | 3 |
201664 | 201664 | 2020-06-02 | Cattaraugus | New York | 36009 | 89 | 3 |
198590 | 198590 | 2020-06-01 | Cattaraugus | New York | 36009 | 89 | 3 |
192470 | 192470 | 2020-05-30 | Montgomery | New York | 36057 | 89 | 4 |
189384 | 189384 | 2020-05-29 | Cayuga | New York | 36011 | 89 | 1 |
158991 | 158991 | 2020-05-19 | Oswego | New York | 36075 | 89 | 0 |
143957 | 143957 | 2020-05-14 | Wayne | New York | 36117 | 89 | 1 |
120018 | 120018 | 2020-05-06 | Livingston | New York | 36051 | 89 | 2 |
102705 | 102705 | 2020-04-30 | Orleans | New York | 36073 | 89 | 5 |
82897 | 82897 | 2020-04-23 | Greene | New York | 36039 | 89 | 0 |
55374 | 55374 | 2020-04-13 | St. Lawrence | New York | 36089 | 89 | 1 |
44751 | 44751 | 2020-04-09 | Steuben | New York | 36101 | 89 | 3 |
34604 | 34604 | 2020-04-05 | Madison | New York | 36053 | 89 | 2 |
13383 | 13383 | 2020-03-26 | Ulster | New York | 36111 | 89 | 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);