ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 37 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
fips 20
county 20
- Yates 4
- Cattaraugus 2
- Chautauqua 2
- Delaware 2
- Herkimer 2
- Lewis 2
- Schuyler 2
- Tioga 2
- Cayuga 1
- Clinton 1
- Cortland 1
- Franklin 1
- Greene 1
- Hamilton 1
- Livingston 1
- Montgomery 1
- New York City 1
- Oswego 1
- Putnam 1
- Washington 1
state 1
- New York · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
756790 | 756790 | 2020-11-22 | Hamilton | New York | 36041 | 37 | 1 |
549253 | 549253 | 2020-09-19 | Schuyler | New York | 36097 | 37 | 0 |
546014 | 546014 | 2020-09-18 | Schuyler | New York | 36097 | 37 | 0 |
403868 | 403868 | 2020-08-05 | Lewis | New York | 36049 | 37 | 0 |
400650 | 400650 | 2020-08-04 | Lewis | New York | 36049 | 37 | 0 |
336461 | 336461 | 2020-07-15 | Franklin | New York | 36033 | 37 | 0 |
180272 | 180272 | 2020-05-26 | Yates | New York | 36123 | 37 | 6 |
177229 | 177229 | 2020-05-25 | Yates | New York | 36123 | 37 | 6 |
174185 | 174185 | 2020-05-24 | Yates | New York | 36123 | 37 | 6 |
171143 | 171143 | 2020-05-23 | Yates | New York | 36123 | 37 | 6 |
168057 | 168057 | 2020-05-22 | Cortland | New York | 36023 | 37 | 0 |
117039 | 117039 | 2020-05-05 | Chautauqua | New York | 36013 | 37 | 2 |
114159 | 114159 | 2020-05-04 | Chautauqua | New York | 36013 | 37 | 2 |
82882 | 82882 | 2020-04-23 | Cattaraugus | New York | 36009 | 37 | 0 |
82883 | 82883 | 2020-04-23 | Cayuga | New York | 36011 | 37 | 1 |
80083 | 80083 | 2020-04-22 | Cattaraugus | New York | 36009 | 37 | 0 |
77317 | 77317 | 2020-04-21 | Montgomery | New York | 36057 | 37 | 1 |
77340 | 77340 | 2020-04-21 | Tioga | New York | 36107 | 37 | 2 |
74559 | 74559 | 2020-04-20 | Tioga | New York | 36107 | 37 | 1 |
68991 | 68991 | 2020-04-18 | Livingston | New York | 36051 | 37 | 1 |
55382 | 55382 | 2020-04-13 | Washington | New York | 36115 | 37 | 0 |
52666 | 52666 | 2020-04-12 | Herkimer | New York | 36043 | 37 | 1 |
49991 | 49991 | 2020-04-11 | Greene | New York | 36039 | 37 | 0 |
49993 | 49993 | 2020-04-11 | Herkimer | New York | 36043 | 37 | 1 |
50008 | 50008 | 2020-04-11 | Oswego | New York | 36075 | 37 | 0 |
44716 | 44716 | 2020-04-09 | Delaware | New York | 36025 | 37 | 0 |
42133 | 42133 | 2020-04-08 | Delaware | New York | 36025 | 37 | 0 |
39573 | 39573 | 2020-04-07 | Clinton | New York | 36019 | 37 | 0 |
7824 | 7824 | 2020-03-22 | Putnam | New York | 36079 | 37 | 0 |
1099 | 1099 | 2020-03-10 | New York City | New York | 37 | 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);