ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 257 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Warren 12
- Steuben 4
- Greene 2
- Broome 1
- Chautauqua 1
- Chenango 1
- Fulton 1
- Genesee 1
- Montgomery 1
- Ontario 1
- Orleans 1
- Oswego 1
- Saratoga 1
- St. Lawrence 1
- Washington 1
state 1
- New York · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
652985 | 652985 | 2020-10-21 | Montgomery | New York | 36057 | 257 | 9 |
591338 | 591338 | 2020-10-02 | Chenango | New York | 36017 | 257 | 6 |
426427 | 426427 | 2020-08-12 | Oswego | New York | 36075 | 257 | 3 |
419951 | 419951 | 2020-08-10 | Chautauqua | New York | 36013 | 257 | 4 |
413558 | 413558 | 2020-08-08 | Washington | New York | 36115 | 257 | 14 |
368516 | 368516 | 2020-07-25 | St. Lawrence | New York | 36089 | 257 | 4 |
349257 | 349257 | 2020-07-19 | Genesee | New York | 36037 | 257 | 6 |
292029 | 292029 | 2020-07-01 | Fulton | New York | 36035 | 257 | 18 |
285743 | 285743 | 2020-06-29 | Ontario | New York | 36069 | 257 | 25 |
276290 | 276290 | 2020-06-26 | Greene | New York | 36039 | 257 | 5 |
273144 | 273144 | 2020-06-25 | Greene | New York | 36039 | 257 | 5 |
254393 | 254393 | 2020-06-19 | Steuben | New York | 36101 | 257 | 19 |
251278 | 251278 | 2020-06-18 | Steuben | New York | 36101 | 257 | 19 |
248163 | 248163 | 2020-06-17 | Steuben | New York | 36101 | 257 | 19 |
248169 | 248169 | 2020-06-17 | Warren | New York | 36113 | 257 | 31 |
245050 | 245050 | 2020-06-16 | Steuben | New York | 36101 | 257 | 19 |
245056 | 245056 | 2020-06-16 | Warren | New York | 36113 | 257 | 31 |
241944 | 241944 | 2020-06-15 | Warren | New York | 36113 | 257 | 31 |
238835 | 238835 | 2020-06-14 | Warren | New York | 36113 | 257 | 31 |
235727 | 235727 | 2020-06-13 | Warren | New York | 36113 | 257 | 31 |
232622 | 232622 | 2020-06-12 | Warren | New York | 36113 | 257 | 31 |
229517 | 229517 | 2020-06-11 | Warren | New York | 36113 | 257 | 31 |
226413 | 226413 | 2020-06-10 | Warren | New York | 36113 | 257 | 31 |
223295 | 223295 | 2020-06-09 | Orleans | New York | 36073 | 257 | 33 |
223313 | 223313 | 2020-06-09 | Warren | New York | 36113 | 257 | 31 |
220219 | 220219 | 2020-06-08 | Warren | New York | 36113 | 257 | 31 |
217127 | 217127 | 2020-06-07 | Warren | New York | 36113 | 257 | 31 |
214037 | 214037 | 2020-06-06 | Warren | New York | 36113 | 257 | 31 |
91312 | 91312 | 2020-04-26 | Broome | New York | 36007 | 257 | 13 |
77331 | 77331 | 2020-04-21 | Saratoga | New York | 36091 | 257 | 2 |
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);