ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 176 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 |
---|---|---|---|---|---|---|---|
763304 | 763304 | 2020-11-24 | Schoharie | New York | 36095 | 176 | 2 |
760059 | 760059 | 2020-11-23 | Schoharie | New York | 36095 | 176 | 2 |
717887 | 717887 | 2020-11-10 | Yates | New York | 36123 | 176 | 6 |
711387 | 711387 | 2020-11-08 | Seneca | New York | 36099 | 176 | 2 |
633485 | 633485 | 2020-10-15 | Allegany | New York | 36003 | 176 | 5 |
607564 | 607564 | 2020-10-07 | Jefferson | New York | 36045 | 176 | 1 |
604321 | 604321 | 2020-10-06 | Jefferson | New York | 36045 | 176 | 1 |
601079 | 601079 | 2020-10-05 | Jefferson | New York | 36045 | 176 | 1 |
597836 | 597836 | 2020-10-04 | Jefferson | New York | 36045 | 176 | 1 |
594593 | 594593 | 2020-10-03 | Jefferson | New York | 36045 | 176 | 1 |
581623 | 581623 | 2020-09-29 | Essex | New York | 36031 | 176 | 13 |
578383 | 578383 | 2020-09-28 | Essex | New York | 36031 | 176 | 13 |
474814 | 474814 | 2020-08-27 | Cayuga | New York | 36011 | 176 | 2 |
429640 | 429640 | 2020-08-13 | Livingston | New York | 36051 | 176 | 6 |
426415 | 426415 | 2020-08-12 | Livingston | New York | 36051 | 176 | 6 |
423175 | 423175 | 2020-08-11 | Chemung | New York | 36015 | 176 | 2 |
423192 | 423192 | 2020-08-11 | Livingston | New York | 36051 | 176 | 6 |
419969 | 419969 | 2020-08-10 | Livingston | New York | 36051 | 176 | 6 |
416749 | 416749 | 2020-08-09 | Livingston | New York | 36051 | 176 | 6 |
416752 | 416752 | 2020-08-09 | Montgomery | New York | 36057 | 176 | 4 |
413528 | 413528 | 2020-08-08 | Livingston | New York | 36051 | 176 | 6 |
365311 | 365311 | 2020-07-24 | Tioga | New York | 36107 | 176 | 19 |
295222 | 295222 | 2020-07-02 | Wayne | New York | 36117 | 176 | 1 |
282616 | 282616 | 2020-06-28 | Tompkins | New York | 36109 | 176 | 2 |
165044 | 165044 | 2020-05-21 | Ontario | New York | 36069 | 176 | 8 |
108445 | 108445 | 2020-05-02 | St. Lawrence | New York | 36089 | 176 | 2 |
105578 | 105578 | 2020-05-01 | St. Lawrence | New York | 36089 | 176 | 2 |
102723 | 102723 | 2020-04-30 | Warren | New York | 36113 | 176 | 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);