ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 260 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
fips 15
county 15
- Greene 6
- Washington 5
- Cattaraugus 2
- Chautauqua 2
- Orleans 2
- St. Lawrence 2
- Cortland 1
- Essex 1
- Fulton 1
- Genesee 1
- Jefferson 1
- Madison 1
- Niagara 1
- Schoharie 1
- Seneca 1
state 1
- New York · 28 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
808735 | 808735 | 2020-12-08 | Schoharie | New York | 36095 | 260 | 2 |
763276 | 763276 | 2020-11-24 | Essex | New York | 36031 | 260 | 14 |
763306 | 763306 | 2020-11-24 | Seneca | New York | 36099 | 260 | 2 |
704877 | 704877 | 2020-11-06 | Jefferson | New York | 36045 | 260 | 1 |
610795 | 610795 | 2020-10-08 | Cortland | New York | 36023 | 260 | 1 |
578372 | 578372 | 2020-09-28 | Cattaraugus | New York | 36009 | 260 | 8 |
575131 | 575131 | 2020-09-27 | Cattaraugus | New York | 36009 | 260 | 8 |
432848 | 432848 | 2020-08-14 | Chautauqua | New York | 36013 | 260 | 4 |
432896 | 432896 | 2020-08-14 | Washington | New York | 36115 | 260 | 14 |
429622 | 429622 | 2020-08-13 | Chautauqua | New York | 36013 | 260 | 4 |
429670 | 429670 | 2020-08-13 | Washington | New York | 36115 | 260 | 14 |
426445 | 426445 | 2020-08-12 | Washington | New York | 36115 | 260 | 14 |
423222 | 423222 | 2020-08-11 | Washington | New York | 36115 | 260 | 14 |
419999 | 419999 | 2020-08-10 | Washington | New York | 36115 | 260 | 14 |
387808 | 387808 | 2020-07-31 | St. Lawrence | New York | 36089 | 260 | 4 |
384591 | 384591 | 2020-07-30 | St. Lawrence | New York | 36089 | 260 | 4 |
362073 | 362073 | 2020-07-23 | Genesee | New York | 36037 | 260 | 6 |
295184 | 295184 | 2020-07-02 | Fulton | New York | 36035 | 260 | 18 |
295186 | 295186 | 2020-07-02 | Greene | New York | 36039 | 260 | 5 |
292031 | 292031 | 2020-07-01 | Greene | New York | 36039 | 260 | 5 |
288879 | 288879 | 2020-06-30 | Greene | New York | 36039 | 260 | 5 |
285729 | 285729 | 2020-06-29 | Greene | New York | 36039 | 260 | 5 |
282584 | 282584 | 2020-06-28 | Greene | New York | 36039 | 260 | 5 |
279438 | 279438 | 2020-06-27 | Greene | New York | 36039 | 260 | 5 |
232604 | 232604 | 2020-06-12 | Orleans | New York | 36073 | 260 | 36 |
229499 | 229499 | 2020-06-11 | Orleans | New York | 36073 | 260 | 35 |
158980 | 158980 | 2020-05-19 | Madison | New York | 36053 | 260 | 3 |
77320 | 77320 | 2020-04-21 | Niagara | New York | 36063 | 260 | 9 |
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);