ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 40 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Essex 7
- Yates 6
- Chautauqua 3
- Franklin 3
- Schuyler 2
- Tioga 2
- Clinton 1
- Hamilton 1
- Herkimer 1
- Jefferson 1
- Oneida 1
- Rensselaer 1
- Warren 1
- Washington 1
- Wyoming 1
state 1
- New York · 32 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
763281 | 763281 | 2020-11-24 | Hamilton | New York | 36041 | 40 | 1 |
565444 | 565444 | 2020-09-24 | Schuyler | New York | 36097 | 40 | 0 |
562203 | 562203 | 2020-09-23 | Schuyler | New York | 36097 | 40 | 0 |
352458 | 352458 | 2020-07-20 | Franklin | New York | 36033 | 40 | 1 |
349255 | 349255 | 2020-07-19 | Franklin | New York | 36033 | 40 | 1 |
346054 | 346054 | 2020-07-18 | Franklin | New York | 36033 | 40 | 1 |
254404 | 254404 | 2020-06-19 | Yates | New York | 36123 | 40 | 6 |
251289 | 251289 | 2020-06-18 | Yates | New York | 36123 | 40 | 6 |
248174 | 248174 | 2020-06-17 | Yates | New York | 36123 | 40 | 6 |
245061 | 245061 | 2020-06-16 | Yates | New York | 36123 | 40 | 6 |
241949 | 241949 | 2020-06-15 | Yates | New York | 36123 | 40 | 6 |
238840 | 238840 | 2020-06-14 | Yates | New York | 36123 | 40 | 6 |
149925 | 149925 | 2020-05-16 | Essex | New York | 36031 | 40 | 0 |
146918 | 146918 | 2020-05-15 | Essex | New York | 36031 | 40 | 0 |
143917 | 143917 | 2020-05-14 | Essex | New York | 36031 | 40 | 0 |
140922 | 140922 | 2020-05-13 | Essex | New York | 36031 | 40 | 0 |
137926 | 137926 | 2020-05-12 | Essex | New York | 36031 | 40 | 0 |
134936 | 134936 | 2020-05-11 | Essex | New York | 36031 | 40 | 0 |
131945 | 131945 | 2020-05-10 | Essex | New York | 36031 | 40 | 0 |
128947 | 128947 | 2020-05-09 | Chautauqua | New York | 36013 | 40 | 2 |
125958 | 125958 | 2020-05-08 | Chautauqua | New York | 36013 | 40 | 2 |
122975 | 122975 | 2020-05-07 | Chautauqua | New York | 36013 | 40 | 2 |
85732 | 85732 | 2020-04-24 | Tioga | New York | 36107 | 40 | 2 |
82928 | 82928 | 2020-04-23 | Tioga | New York | 36107 | 40 | 2 |
80136 | 80136 | 2020-04-22 | Wyoming | New York | 36121 | 40 | 3 |
60763 | 60763 | 2020-04-15 | Herkimer | New York | 36043 | 40 | 1 |
58082 | 58082 | 2020-04-14 | Washington | New York | 36115 | 40 | 0 |
44713 | 44713 | 2020-04-09 | Clinton | New York | 36019 | 40 | 0 |
44757 | 44757 | 2020-04-09 | Warren | New York | 36113 | 40 | 1 |
42143 | 42143 | 2020-04-08 | Jefferson | New York | 36045 | 40 | 0 |
23015 | 23015 | 2020-03-31 | Oneida | New York | 36065 | 40 | 0 |
20900 | 20900 | 2020-03-30 | Rensselaer | New York | 36083 | 40 | 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);