ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 79 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
665952 | 665952 | 2020-10-25 | Franklin | New York | 36033 | 79 | 1 |
662707 | 662707 | 2020-10-24 | Franklin | New York | 36033 | 79 | 1 |
659463 | 659463 | 2020-10-23 | Franklin | New York | 36033 | 79 | 1 |
656219 | 656219 | 2020-10-22 | Franklin | New York | 36033 | 79 | 1 |
630282 | 630282 | 2020-10-14 | Schuyler | New York | 36097 | 79 | 0 |
416727 | 416727 | 2020-08-09 | Allegany | New York | 36003 | 79 | 2 |
413506 | 413506 | 2020-08-08 | Allegany | New York | 36003 | 79 | 2 |
410286 | 410286 | 2020-08-07 | Allegany | New York | 36003 | 79 | 2 |
229486 | 229486 | 2020-06-11 | Jefferson | New York | 36045 | 79 | 0 |
226382 | 226382 | 2020-06-10 | Jefferson | New York | 36045 | 79 | 0 |
223282 | 223282 | 2020-06-09 | Jefferson | New York | 36045 | 79 | 0 |
195525 | 195525 | 2020-05-31 | Delaware | New York | 36025 | 79 | 0 |
192455 | 192455 | 2020-05-30 | Delaware | New York | 36025 | 79 | 0 |
189391 | 189391 | 2020-05-29 | Delaware | New York | 36025 | 79 | 0 |
177198 | 177198 | 2020-05-25 | Montgomery | New York | 36057 | 79 | 4 |
174154 | 174154 | 2020-05-24 | Montgomery | New York | 36057 | 79 | 4 |
168103 | 168103 | 2020-05-22 | Wyoming | New York | 36121 | 79 | 3 |
165068 | 165068 | 2020-05-21 | Wyoming | New York | 36121 | 79 | 3 |
162039 | 162039 | 2020-05-20 | Wyoming | New York | 36121 | 79 | 3 |
159012 | 159012 | 2020-05-19 | Wyoming | New York | 36121 | 79 | 3 |
155994 | 155994 | 2020-05-18 | Wyoming | New York | 36121 | 79 | 3 |
131951 | 131951 | 2020-05-10 | Herkimer | New York | 36043 | 79 | 1 |
128996 | 128996 | 2020-05-09 | Wayne | New York | 36117 | 79 | 1 |
126007 | 126007 | 2020-05-08 | Wayne | New York | 36117 | 79 | 1 |
108416 | 108416 | 2020-05-02 | Fulton | New York | 36035 | 79 | 1 |
85689 | 85689 | 2020-04-24 | Chemung | New York | 36015 | 79 | 3 |
80087 | 80087 | 2020-04-22 | Chenango | New York | 36017 | 79 | 0 |
77298 | 77298 | 2020-04-21 | Chenango | New York | 36017 | 79 | 0 |
52655 | 52655 | 2020-04-12 | Columbia | New York | 36021 | 79 | 8 |
44743 | 44743 | 2020-04-09 | Rensselaer | New York | 36083 | 79 | 3 |
39611 | 39611 | 2020-04-07 | Steuben | New York | 36101 | 79 | 4 |
2163 | 2163 | 2020-03-14 | Nassau | New York | 36059 | 79 | 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);