ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 164 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
- Cayuga 6
- Cattaraugus 4
- Tompkins 3
- Jefferson 2
- Clinton 1
- Cortland 1
- Delaware 1
- Herkimer 1
- Livingston 1
- Rensselaer 1
- Schuyler 1
state 1
- New York · 22 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
698412 | 698412 | 2020-11-04 | Schuyler | New York | 36097 | 164 | 3 |
656215 | 656215 | 2020-10-22 | Delaware | New York | 36025 | 164 | 5 |
591339 | 591339 | 2020-10-02 | Clinton | New York | 36019 | 164 | 5 |
562170 | 562170 | 2020-09-23 | Cortland | New York | 36023 | 164 | 1 |
562181 | 562181 | 2020-09-23 | Jefferson | New York | 36045 | 164 | 1 |
558944 | 558944 | 2020-09-22 | Jefferson | New York | 36045 | 164 | 1 |
455435 | 455435 | 2020-08-21 | Cayuga | New York | 36011 | 164 | 2 |
452207 | 452207 | 2020-08-20 | Cayuga | New York | 36011 | 164 | 2 |
448979 | 448979 | 2020-08-19 | Cayuga | New York | 36011 | 164 | 2 |
445751 | 445751 | 2020-08-18 | Cayuga | New York | 36011 | 164 | 2 |
442525 | 442525 | 2020-08-17 | Cayuga | New York | 36011 | 164 | 2 |
439298 | 439298 | 2020-08-16 | Cayuga | New York | 36011 | 164 | 2 |
410288 | 410288 | 2020-08-07 | Cattaraugus | New York | 36009 | 164 | 6 |
407068 | 407068 | 2020-08-06 | Cattaraugus | New York | 36009 | 164 | 6 |
403849 | 403849 | 2020-08-05 | Cattaraugus | New York | 36009 | 164 | 5 |
400631 | 400631 | 2020-08-04 | Cattaraugus | New York | 36009 | 164 | 5 |
384569 | 384569 | 2020-07-30 | Livingston | New York | 36051 | 164 | 4 |
295188 | 295188 | 2020-07-02 | Herkimer | New York | 36043 | 164 | 1 |
201711 | 201711 | 2020-06-02 | Tompkins | New York | 36109 | 164 | 2 |
198637 | 198637 | 2020-06-01 | Tompkins | New York | 36109 | 164 | 2 |
195564 | 195564 | 2020-05-31 | Tompkins | New York | 36109 | 164 | 2 |
69006 | 69006 | 2020-04-18 | Rensselaer | New York | 36083 | 164 | 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);