ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 3 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117053 | 117053 | 2020-05-05 | Hamilton | New York | 36041 | 3 | 0 |
114173 | 114173 | 2020-05-04 | Hamilton | New York | 36041 | 3 | 0 |
111292 | 111292 | 2020-05-03 | Hamilton | New York | 36041 | 3 | 0 |
108419 | 108419 | 2020-05-02 | Hamilton | New York | 36041 | 3 | 0 |
105552 | 105552 | 2020-05-01 | Hamilton | New York | 36041 | 3 | 0 |
102690 | 102690 | 2020-04-30 | Hamilton | New York | 36041 | 3 | 0 |
99837 | 99837 | 2020-04-29 | Hamilton | New York | 36041 | 3 | 0 |
96990 | 96990 | 2020-04-28 | Hamilton | New York | 36041 | 3 | 0 |
94154 | 94154 | 2020-04-27 | Hamilton | New York | 36041 | 3 | 0 |
91329 | 91329 | 2020-04-26 | Hamilton | New York | 36041 | 3 | 0 |
88514 | 88514 | 2020-04-25 | Hamilton | New York | 36041 | 3 | 0 |
85702 | 85702 | 2020-04-24 | Hamilton | New York | 36041 | 3 | 0 |
82898 | 82898 | 2020-04-23 | Hamilton | New York | 36041 | 3 | 0 |
80099 | 80099 | 2020-04-22 | Hamilton | New York | 36041 | 3 | 0 |
77310 | 77310 | 2020-04-21 | Hamilton | New York | 36041 | 3 | 0 |
74529 | 74529 | 2020-04-20 | Hamilton | New York | 36041 | 3 | 0 |
71754 | 71754 | 2020-04-19 | Hamilton | New York | 36041 | 3 | 0 |
68987 | 68987 | 2020-04-18 | Hamilton | New York | 36041 | 3 | 0 |
66230 | 66230 | 2020-04-17 | Hamilton | New York | 36041 | 3 | 0 |
63488 | 63488 | 2020-04-16 | Hamilton | New York | 36041 | 3 | 0 |
60762 | 60762 | 2020-04-15 | Hamilton | New York | 36041 | 3 | 0 |
58048 | 58048 | 2020-04-14 | Hamilton | New York | 36041 | 3 | 0 |
55348 | 55348 | 2020-04-13 | Hamilton | New York | 36041 | 3 | 0 |
52665 | 52665 | 2020-04-12 | Hamilton | New York | 36041 | 3 | 0 |
52703 | 52703 | 2020-04-12 | Yates | New York | 36123 | 3 | 0 |
49992 | 49992 | 2020-04-11 | Hamilton | New York | 36041 | 3 | 0 |
47337 | 47337 | 2020-04-10 | Hamilton | New York | 36041 | 3 | 0 |
44724 | 44724 | 2020-04-09 | Hamilton | New York | 36041 | 3 | 0 |
29785 | 29785 | 2020-04-03 | Lewis | New York | 36049 | 3 | 0 |
29806 | 29806 | 2020-04-03 | Schuyler | New York | 36097 | 3 | 0 |
27461 | 27461 | 2020-04-02 | Lewis | New York | 36049 | 3 | 0 |
27482 | 27482 | 2020-04-02 | Schuyler | New York | 36097 | 3 | 0 |
25183 | 25183 | 2020-04-01 | Cayuga | New York | 36011 | 3 | 0 |
22989 | 22989 | 2020-03-31 | Cayuga | New York | 36011 | 3 | 0 |
20866 | 20866 | 2020-03-30 | Cayuga | New York | 36011 | 3 | 0 |
18857 | 18857 | 2020-03-29 | Orleans | New York | 36073 | 3 | 0 |
16932 | 16932 | 2020-03-28 | Orleans | New York | 36073 | 3 | 0 |
15090 | 15090 | 2020-03-27 | Jefferson | New York | 36045 | 3 | 0 |
15091 | 15091 | 2020-03-27 | Livingston | New York | 36051 | 3 | 0 |
15102 | 15102 | 2020-03-27 | Orleans | New York | 36073 | 3 | 0 |
15110 | 15110 | 2020-03-27 | Schoharie | New York | 36095 | 3 | 0 |
15111 | 15111 | 2020-03-27 | St. Lawrence | New York | 36089 | 3 | 0 |
13342 | 13342 | 2020-03-26 | Chenango | New York | 36017 | 3 | 0 |
13356 | 13356 | 2020-03-26 | Jefferson | New York | 36045 | 3 | 0 |
13357 | 13357 | 2020-03-26 | Livingston | New York | 36051 | 3 | 0 |
13370 | 13370 | 2020-03-26 | Otsego | New York | 36077 | 3 | 0 |
11739 | 11739 | 2020-03-25 | Chenango | New York | 36017 | 3 | 0 |
11754 | 11754 | 2020-03-25 | Livingston | New York | 36051 | 3 | 0 |
10304 | 10304 | 2020-03-24 | Chenango | New York | 36017 | 3 | 0 |
10308 | 10308 | 2020-03-24 | Delaware | New York | 36025 | 3 | 0 |
10311 | 10311 | 2020-03-24 | Essex | New York | 36031 | 3 | 0 |
10318 | 10318 | 2020-03-24 | Livingston | New York | 36051 | 3 | 0 |
10321 | 10321 | 2020-03-24 | Montgomery | New York | 36057 | 3 | 0 |
10346 | 10346 | 2020-03-24 | Washington | New York | 36115 | 3 | 0 |
8997 | 8997 | 2020-03-23 | Chenango | New York | 36017 | 3 | 0 |
9001 | 9001 | 2020-03-23 | Delaware | New York | 36025 | 3 | 0 |
9004 | 9004 | 2020-03-23 | Essex | New York | 36031 | 3 | 0 |
9011 | 9011 | 2020-03-23 | Livingston | New York | 36051 | 3 | 0 |
9014 | 9014 | 2020-03-23 | Montgomery | New York | 36057 | 3 | 0 |
9038 | 9038 | 2020-03-23 | Washington | New York | 36115 | 3 | 0 |
7798 | 7798 | 2020-03-22 | Broome | New York | 36007 | 3 | 1 |
7799 | 7799 | 2020-03-22 | Chenango | New York | 36017 | 3 | 0 |
7803 | 7803 | 2020-03-22 | Delaware | New York | 36025 | 3 | 0 |
7806 | 7806 | 2020-03-22 | Essex | New York | 36031 | 3 | 0 |
7816 | 7816 | 2020-03-22 | Montgomery | New York | 36057 | 3 | 0 |
7831 | 7831 | 2020-03-22 | Steuben | New York | 36101 | 3 | 0 |
7839 | 7839 | 2020-03-22 | Wayne | New York | 36117 | 3 | 0 |
6717 | 6717 | 2020-03-21 | Herkimer | New York | 36043 | 3 | 0 |
6721 | 6721 | 2020-03-21 | Montgomery | New York | 36057 | 3 | 0 |
6743 | 6743 | 2020-03-21 | Wayne | New York | 36117 | 3 | 0 |
5730 | 5730 | 2020-03-20 | Niagara | New York | 36063 | 3 | 0 |
5733 | 5733 | 2020-03-20 | Ontario | New York | 36069 | 3 | 0 |
2569 | 2569 | 2020-03-15 | Erie | New York | 36029 | 3 | 0 |
2579 | 2579 | 2020-03-15 | Saratoga | New York | 36091 | 3 | 0 |
2167 | 2167 | 2020-03-14 | Saratoga | New York | 36091 | 3 | 0 |
1811 | 1811 | 2020-03-13 | Dutchess | New York | 36027 | 3 | 0 |
1816 | 1816 | 2020-03-13 | Orange | New York | 36071 | 3 | 0 |
1818 | 1818 | 2020-03-13 | Saratoga | New York | 36091 | 3 | 0 |
1525 | 1525 | 2020-03-12 | Saratoga | New York | 36091 | 3 | 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);