ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 167 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 |
---|---|---|---|---|---|---|---|
704900 | 704900 | 2020-11-06 | Seneca | New York | 36099 | 167 | 2 |
701635 | 701635 | 2020-11-05 | Lewis | New York | 36049 | 167 | 5 |
649770 | 649770 | 2020-10-20 | Wyoming | New York | 36121 | 167 | 5 |
646526 | 646526 | 2020-10-19 | Wyoming | New York | 36121 | 167 | 5 |
571905 | 571905 | 2020-09-26 | Jefferson | New York | 36045 | 167 | 1 |
568663 | 568663 | 2020-09-25 | Jefferson | New York | 36045 | 167 | 1 |
565411 | 565411 | 2020-09-24 | Cortland | New York | 36023 | 167 | 1 |
465120 | 465120 | 2020-08-24 | Cayuga | New York | 36011 | 167 | 2 |
461891 | 461891 | 2020-08-23 | Cayuga | New York | 36011 | 167 | 2 |
397436 | 397436 | 2020-08-03 | Livingston | New York | 36051 | 167 | 6 |
394219 | 394219 | 2020-08-02 | Livingston | New York | 36051 | 167 | 6 |
254382 | 254382 | 2020-06-19 | Oswego | New York | 36075 | 167 | 0 |
210951 | 210951 | 2020-06-05 | Tompkins | New York | 36109 | 167 | 2 |
155972 | 155972 | 2020-05-18 | Orleans | New York | 36073 | 167 | 18 |
152955 | 152955 | 2020-05-17 | Orleans | New York | 36073 | 167 | 18 |
91355 | 91355 | 2020-04-26 | St. Lawrence | New York | 36089 | 167 | 1 |
74556 | 74556 | 2020-04-20 | Steuben | New York | 36101 | 167 | 9 |
71781 | 71781 | 2020-04-19 | Steuben | New York | 36101 | 167 | 7 |
63471 | 63471 | 2020-04-16 | Broome | New York | 36007 | 167 | 6 |
50002 | 50002 | 2020-04-11 | Niagara | New York | 36063 | 167 | 2 |
44746 | 44746 | 2020-04-09 | Schenectady | New York | 36093 | 167 | 9 |
42162 | 42162 | 2020-04-08 | Saratoga | New York | 36091 | 167 | 1 |
20899 | 20899 | 2020-03-30 | Putnam | New York | 36079 | 167 | 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);