ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 255 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 14
county 14
- Washington 5
- Warren 4
- Cattaraugus 2
- Steuben 2
- Clinton 1
- Delaware 1
- Franklin 1
- Fulton 1
- Greene 1
- Madison 1
- Montgomery 1
- Niagara 1
- Orleans 1
- Oswego 1
state 1
- New York · 23 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
769768 | 769768 | 2020-11-26 | Franklin | New York | 36033 | 255 | 7 |
717841 | 717841 | 2020-11-10 | Delaware | New York | 36025 | 255 | 6 |
682160 | 682160 | 2020-10-30 | Clinton | New York | 36019 | 255 | 5 |
646496 | 646496 | 2020-10-19 | Montgomery | New York | 36057 | 255 | 9 |
558926 | 558926 | 2020-09-22 | Cattaraugus | New York | 36009 | 255 | 7 |
555689 | 555689 | 2020-09-21 | Cattaraugus | New York | 36009 | 255 | 7 |
423204 | 423204 | 2020-08-11 | Oswego | New York | 36075 | 255 | 3 |
403899 | 403899 | 2020-08-05 | Washington | New York | 36115 | 255 | 11 |
400681 | 400681 | 2020-08-04 | Washington | New York | 36115 | 255 | 11 |
397466 | 397466 | 2020-08-03 | Washington | New York | 36115 | 255 | 11 |
394249 | 394249 | 2020-08-02 | Washington | New York | 36115 | 255 | 11 |
391033 | 391033 | 2020-08-01 | Washington | New York | 36115 | 255 | 11 |
282582 | 282582 | 2020-06-28 | Fulton | New York | 36035 | 255 | 18 |
257488 | 257488 | 2020-06-20 | Greene | New York | 36039 | 255 | 5 |
238829 | 238829 | 2020-06-14 | Steuben | New York | 36101 | 255 | 19 |
235721 | 235721 | 2020-06-13 | Steuben | New York | 36101 | 255 | 19 |
217109 | 217109 | 2020-06-07 | Orleans | New York | 36073 | 255 | 29 |
201713 | 201713 | 2020-06-02 | Warren | New York | 36113 | 255 | 30 |
198639 | 198639 | 2020-06-01 | Warren | New York | 36113 | 255 | 30 |
195566 | 195566 | 2020-05-31 | Warren | New York | 36113 | 255 | 30 |
192496 | 192496 | 2020-05-30 | Warren | New York | 36113 | 255 | 29 |
143927 | 143927 | 2020-05-14 | Madison | New York | 36053 | 255 | 3 |
74539 | 74539 | 2020-04-20 | Niagara | New York | 36063 | 255 | 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);