ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 61 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
526568 | 526568 | 2020-09-12 | Franklin | New York | 36033 | 61 | 1 |
484568 | 484568 | 2020-08-30 | Yates | New York | 36123 | 61 | 6 |
481333 | 481333 | 2020-08-29 | Yates | New York | 36123 | 61 | 6 |
336456 | 336456 | 2020-07-15 | Cortland | New York | 36023 | 61 | 0 |
317376 | 317376 | 2020-07-09 | Schoharie | New York | 36095 | 61 | 0 |
292014 | 292014 | 2020-07-01 | Allegany | New York | 36003 | 61 | 0 |
226405 | 226405 | 2020-06-10 | Seneca | New York | 36099 | 61 | 0 |
223305 | 223305 | 2020-06-09 | Seneca | New York | 36099 | 61 | 0 |
220211 | 220211 | 2020-06-08 | Seneca | New York | 36099 | 61 | 0 |
217119 | 217119 | 2020-06-07 | Seneca | New York | 36099 | 61 | 0 |
214029 | 214029 | 2020-06-06 | Seneca | New York | 36099 | 61 | 0 |
210945 | 210945 | 2020-06-05 | Seneca | New York | 36099 | 61 | 0 |
146908 | 146908 | 2020-05-15 | Cayuga | New York | 36011 | 61 | 1 |
140911 | 140911 | 2020-05-13 | Cattaraugus | New York | 36009 | 61 | 1 |
137915 | 137915 | 2020-05-12 | Cattaraugus | New York | 36009 | 61 | 1 |
134925 | 134925 | 2020-05-11 | Cattaraugus | New York | 36009 | 61 | 1 |
117060 | 117060 | 2020-05-05 | Montgomery | New York | 36057 | 61 | 1 |
111284 | 111284 | 2020-05-03 | Delaware | New York | 36025 | 61 | 0 |
108411 | 108411 | 2020-05-02 | Delaware | New York | 36025 | 61 | 0 |
108420 | 108420 | 2020-05-02 | Herkimer | New York | 36043 | 61 | 1 |
105541 | 105541 | 2020-05-01 | Clinton | New York | 36019 | 61 | 4 |
105544 | 105544 | 2020-05-01 | Delaware | New York | 36025 | 61 | 0 |
105554 | 105554 | 2020-05-01 | Jefferson | New York | 36045 | 61 | 0 |
102682 | 102682 | 2020-04-30 | Delaware | New York | 36025 | 61 | 0 |
102692 | 102692 | 2020-04-30 | Jefferson | New York | 36045 | 61 | 0 |
94170 | 94170 | 2020-04-27 | Oswego | New York | 36075 | 61 | 0 |
91345 | 91345 | 2020-04-26 | Oswego | New York | 36075 | 61 | 0 |
88511 | 88511 | 2020-04-25 | Fulton | New York | 36035 | 61 | 1 |
58061 | 58061 | 2020-04-14 | Ontario | New York | 36069 | 61 | 2 |
49980 | 49980 | 2020-04-11 | Chenango | New York | 36017 | 61 | 0 |
34589 | 34589 | 2020-04-05 | Columbia | New York | 36021 | 61 | 3 |
32158 | 32158 | 2020-04-04 | Columbia | New York | 36021 | 61 | 3 |
5709 | 5709 | 2020-03-20 | Albany | New York | 36001 | 61 | 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);