ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 92 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
662714 | 662714 | 2020-10-24 | Lewis | New York | 36049 | 92 | 5 |
516846 | 516846 | 2020-09-09 | Allegany | New York | 36003 | 92 | 2 |
513611 | 513611 | 2020-09-08 | Allegany | New York | 36003 | 92 | 2 |
510378 | 510378 | 2020-09-07 | Allegany | New York | 36003 | 92 | 2 |
507145 | 507145 | 2020-09-06 | Allegany | New York | 36003 | 92 | 2 |
503913 | 503913 | 2020-09-05 | Allegany | New York | 36003 | 92 | 2 |
429661 | 429661 | 2020-08-13 | Seneca | New York | 36099 | 92 | 1 |
397423 | 397423 | 2020-08-03 | Cortland | New York | 36023 | 92 | 0 |
394206 | 394206 | 2020-08-02 | Cortland | New York | 36023 | 92 | 0 |
342851 | 342851 | 2020-07-17 | Delaware | New York | 36025 | 92 | 0 |
339653 | 339653 | 2020-07-16 | Delaware | New York | 36025 | 92 | 0 |
339678 | 339678 | 2020-07-16 | Otsego | New York | 36077 | 92 | 6 |
336457 | 336457 | 2020-07-15 | Delaware | New York | 36025 | 92 | 0 |
333263 | 333263 | 2020-07-14 | Delaware | New York | 36025 | 92 | 0 |
330073 | 330073 | 2020-07-13 | Delaware | New York | 36025 | 92 | 0 |
326886 | 326886 | 2020-07-12 | Delaware | New York | 36025 | 92 | 0 |
241948 | 241948 | 2020-06-15 | Wyoming | New York | 36121 | 92 | 3 |
238839 | 238839 | 2020-06-14 | Wyoming | New York | 36121 | 92 | 3 |
213988 | 213988 | 2020-06-06 | Cattaraugus | New York | 36009 | 92 | 4 |
210904 | 210904 | 2020-06-05 | Cattaraugus | New York | 36009 | 92 | 4 |
198591 | 198591 | 2020-06-01 | Cayuga | New York | 36011 | 92 | 1 |
165047 | 165047 | 2020-05-21 | Oswego | New York | 36075 | 92 | 0 |
158976 | 158976 | 2020-05-19 | Herkimer | New York | 36043 | 92 | 1 |
155958 | 155958 | 2020-05-18 | Herkimer | New York | 36043 | 92 | 1 |
152929 | 152929 | 2020-05-17 | Clinton | New York | 36019 | 92 | 4 |
149965 | 149965 | 2020-05-16 | Wayne | New York | 36117 | 92 | 1 |
117083 | 117083 | 2020-05-05 | Tioga | New York | 36107 | 92 | 8 |
108432 | 108432 | 2020-05-02 | Ontario | New York | 36069 | 92 | 4 |
105567 | 105567 | 2020-05-01 | Orleans | New York | 36073 | 92 | 5 |
60788 | 60788 | 2020-04-15 | St. Lawrence | New York | 36089 | 92 | 1 |
58074 | 58074 | 2020-04-14 | St. Lawrence | New York | 36089 | 92 | 1 |
42146 | 42146 | 2020-04-08 | Madison | New York | 36053 | 92 | 1 |
39589 | 39589 | 2020-04-07 | Madison | New York | 36053 | 92 | 2 |
37074 | 37074 | 2020-04-06 | Madison | New York | 36053 | 92 | 2 |
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);