ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 46 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 |
---|---|---|---|---|---|---|---|
782753 | 782753 | 2020-11-30 | Hamilton | New York | 36041 | 46 | 1 |
426414 | 426414 | 2020-08-12 | Lewis | New York | 36049 | 46 | 5 |
298385 | 298385 | 2020-07-03 | Yates | New York | 36123 | 46 | 6 |
295225 | 295225 | 2020-07-02 | Yates | New York | 36123 | 46 | 6 |
292070 | 292070 | 2020-07-01 | Yates | New York | 36123 | 46 | 6 |
288918 | 288918 | 2020-06-30 | Yates | New York | 36123 | 46 | 6 |
285768 | 285768 | 2020-06-29 | Yates | New York | 36123 | 46 | 6 |
282576 | 282576 | 2020-06-28 | Cortland | New York | 36023 | 46 | 0 |
217089 | 217089 | 2020-06-07 | Essex | New York | 36031 | 46 | 0 |
213999 | 213999 | 2020-06-06 | Essex | New York | 36031 | 46 | 0 |
210915 | 210915 | 2020-06-05 | Essex | New York | 36031 | 46 | 0 |
207833 | 207833 | 2020-06-04 | Essex | New York | 36031 | 46 | 0 |
204752 | 204752 | 2020-06-03 | Essex | New York | 36031 | 46 | 0 |
201675 | 201675 | 2020-06-02 | Essex | New York | 36031 | 46 | 0 |
137954 | 137954 | 2020-05-12 | Schoharie | New York | 36095 | 46 | 0 |
134964 | 134964 | 2020-05-11 | Schoharie | New York | 36095 | 46 | 0 |
131973 | 131973 | 2020-05-10 | Schoharie | New York | 36095 | 46 | 0 |
128984 | 128984 | 2020-05-09 | Schoharie | New York | 36095 | 46 | 0 |
125997 | 125997 | 2020-05-08 | Seneca | New York | 36099 | 46 | 0 |
123014 | 123014 | 2020-05-07 | Seneca | New York | 36099 | 46 | 0 |
120039 | 120039 | 2020-05-06 | Seneca | New York | 36099 | 46 | 0 |
117078 | 117078 | 2020-05-05 | Seneca | New York | 36099 | 46 | 1 |
88521 | 88521 | 2020-04-25 | Montgomery | New York | 36057 | 46 | 1 |
74544 | 74544 | 2020-04-20 | Orleans | New York | 36073 | 46 | 1 |
71769 | 71769 | 2020-04-19 | Orleans | New York | 36073 | 46 | 1 |
66231 | 66231 | 2020-04-17 | Herkimer | New York | 36043 | 46 | 1 |
63477 | 63477 | 2020-04-16 | Clinton | New York | 36019 | 46 | 3 |
63522 | 63522 | 2020-04-16 | Washington | New York | 36115 | 46 | 0 |
60754 | 60754 | 2020-04-15 | Delaware | New York | 36025 | 46 | 0 |
55350 | 55350 | 2020-04-13 | Jefferson | New York | 36045 | 46 | 0 |
52667 | 52667 | 2020-04-12 | Jefferson | New York | 36045 | 46 | 0 |
52698 | 52698 | 2020-04-12 | Warren | New York | 36113 | 46 | 1 |
37057 | 37057 | 2020-04-06 | Chenango | New York | 36017 | 46 | 0 |
29765 | 29765 | 2020-04-03 | Broome | New York | 36007 | 46 | 4 |
27441 | 27441 | 2020-04-02 | Broome | New York | 36007 | 46 | 4 |
25208 | 25208 | 2020-04-01 | Niagara | New York | 36063 | 46 | 0 |
10336 | 10336 | 2020-03-24 | Schenectady | New York | 36093 | 46 | 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);