ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Chenango", fips = 36017 and state = "New York" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4137 | 4137 | 2020-03-18 | Chenango | New York | 36017 | 1 | 0 |
4866 | 4866 | 2020-03-19 | Chenango | New York | 36017 | 1 | 0 |
5712 | 5712 | 2020-03-20 | Chenango | New York | 36017 | 2 | 0 |
6706 | 6706 | 2020-03-21 | Chenango | New York | 36017 | 2 | 0 |
7799 | 7799 | 2020-03-22 | Chenango | New York | 36017 | 3 | 0 |
8997 | 8997 | 2020-03-23 | Chenango | New York | 36017 | 3 | 0 |
10304 | 10304 | 2020-03-24 | Chenango | New York | 36017 | 3 | 0 |
11739 | 11739 | 2020-03-25 | Chenango | New York | 36017 | 3 | 0 |
13342 | 13342 | 2020-03-26 | Chenango | New York | 36017 | 3 | 0 |
15076 | 15076 | 2020-03-27 | Chenango | New York | 36017 | 4 | 0 |
16906 | 16906 | 2020-03-28 | Chenango | New York | 36017 | 8 | 0 |
18830 | 18830 | 2020-03-29 | Chenango | New York | 36017 | 15 | 0 |
20869 | 20869 | 2020-03-30 | Chenango | New York | 36017 | 17 | 0 |
22992 | 22992 | 2020-03-31 | Chenango | New York | 36017 | 19 | 0 |
25186 | 25186 | 2020-04-01 | Chenango | New York | 36017 | 26 | 0 |
27446 | 27446 | 2020-04-02 | Chenango | New York | 36017 | 28 | 0 |
29770 | 29770 | 2020-04-03 | Chenango | New York | 36017 | 28 | 0 |
32156 | 32156 | 2020-04-04 | Chenango | New York | 36017 | 39 | 0 |
34587 | 34587 | 2020-04-05 | Chenango | New York | 36017 | 43 | 0 |
37057 | 37057 | 2020-04-06 | Chenango | New York | 36017 | 46 | 0 |
39572 | 39572 | 2020-04-07 | Chenango | New York | 36017 | 51 | 0 |
42129 | 42129 | 2020-04-08 | Chenango | New York | 36017 | 53 | 0 |
44712 | 44712 | 2020-04-09 | Chenango | New York | 36017 | 55 | 0 |
47325 | 47325 | 2020-04-10 | Chenango | New York | 36017 | 60 | 0 |
49980 | 49980 | 2020-04-11 | Chenango | New York | 36017 | 61 | 0 |
52653 | 52653 | 2020-04-12 | Chenango | New York | 36017 | 63 | 0 |
55336 | 55336 | 2020-04-13 | Chenango | New York | 36017 | 65 | 0 |
58036 | 58036 | 2020-04-14 | Chenango | New York | 36017 | 68 | 0 |
60750 | 60750 | 2020-04-15 | Chenango | New York | 36017 | 71 | 0 |
63476 | 63476 | 2020-04-16 | Chenango | New York | 36017 | 73 | 0 |
66218 | 66218 | 2020-04-17 | Chenango | New York | 36017 | 76 | 0 |
68975 | 68975 | 2020-04-18 | Chenango | New York | 36017 | 77 | 0 |
71742 | 71742 | 2020-04-19 | Chenango | New York | 36017 | 78 | 0 |
74517 | 74517 | 2020-04-20 | Chenango | New York | 36017 | 78 | 0 |
77298 | 77298 | 2020-04-21 | Chenango | New York | 36017 | 79 | 0 |
80087 | 80087 | 2020-04-22 | Chenango | New York | 36017 | 79 | 0 |
82886 | 82886 | 2020-04-23 | Chenango | New York | 36017 | 82 | 0 |
85690 | 85690 | 2020-04-24 | Chenango | New York | 36017 | 84 | 0 |
88502 | 88502 | 2020-04-25 | Chenango | New York | 36017 | 91 | 0 |
91317 | 91317 | 2020-04-26 | Chenango | New York | 36017 | 93 | 0 |
94142 | 94142 | 2020-04-27 | Chenango | New York | 36017 | 95 | 0 |
96978 | 96978 | 2020-04-28 | Chenango | New York | 36017 | 95 | 0 |
99825 | 99825 | 2020-04-29 | Chenango | New York | 36017 | 96 | 0 |
102678 | 102678 | 2020-04-30 | Chenango | New York | 36017 | 98 | 0 |
105540 | 105540 | 2020-05-01 | Chenango | New York | 36017 | 99 | 0 |
108407 | 108407 | 2020-05-02 | Chenango | New York | 36017 | 99 | 0 |
111280 | 111280 | 2020-05-03 | Chenango | New York | 36017 | 99 | 0 |
114161 | 114161 | 2020-05-04 | Chenango | New York | 36017 | 100 | 0 |
117041 | 117041 | 2020-05-05 | Chenango | New York | 36017 | 100 | 0 |
120002 | 120002 | 2020-05-06 | Chenango | New York | 36017 | 102 | 2 |
122977 | 122977 | 2020-05-07 | Chenango | New York | 36017 | 105 | 2 |
125960 | 125960 | 2020-05-08 | Chenango | New York | 36017 | 105 | 2 |
128949 | 128949 | 2020-05-09 | Chenango | New York | 36017 | 109 | 2 |
131938 | 131938 | 2020-05-10 | Chenango | New York | 36017 | 109 | 2 |
134929 | 134929 | 2020-05-11 | Chenango | New York | 36017 | 111 | 2 |
137919 | 137919 | 2020-05-12 | Chenango | New York | 36017 | 112 | 2 |
140915 | 140915 | 2020-05-13 | Chenango | New York | 36017 | 112 | 2 |
143910 | 143910 | 2020-05-14 | Chenango | New York | 36017 | 112 | 2 |
146911 | 146911 | 2020-05-15 | Chenango | New York | 36017 | 113 | 2 |
149918 | 149918 | 2020-05-16 | Chenango | New York | 36017 | 115 | 2 |
152928 | 152928 | 2020-05-17 | Chenango | New York | 36017 | 117 | 2 |
155945 | 155945 | 2020-05-18 | Chenango | New York | 36017 | 118 | 2 |
158963 | 158963 | 2020-05-19 | Chenango | New York | 36017 | 118 | 2 |
161990 | 161990 | 2020-05-20 | Chenango | New York | 36017 | 118 | 2 |
165019 | 165019 | 2020-05-21 | Chenango | New York | 36017 | 118 | 2 |
168054 | 168054 | 2020-05-22 | Chenango | New York | 36017 | 118 | 2 |
171093 | 171093 | 2020-05-23 | Chenango | New York | 36017 | 118 | 2 |
174135 | 174135 | 2020-05-24 | Chenango | New York | 36017 | 118 | 2 |
177179 | 177179 | 2020-05-25 | Chenango | New York | 36017 | 119 | 2 |
180222 | 180222 | 2020-05-26 | Chenango | New York | 36017 | 123 | 2 |
183270 | 183270 | 2020-05-27 | Chenango | New York | 36017 | 125 | 2 |
186327 | 186327 | 2020-05-28 | Chenango | New York | 36017 | 126 | 2 |
189387 | 189387 | 2020-05-29 | Chenango | New York | 36017 | 130 | 2 |
192451 | 192451 | 2020-05-30 | Chenango | New York | 36017 | 132 | 2 |
195521 | 195521 | 2020-05-31 | Chenango | New York | 36017 | 133 | 2 |
198594 | 198594 | 2020-06-01 | Chenango | New York | 36017 | 133 | 2 |
201668 | 201668 | 2020-06-02 | Chenango | New York | 36017 | 133 | 2 |
204745 | 204745 | 2020-06-03 | Chenango | New York | 36017 | 133 | 2 |
207826 | 207826 | 2020-06-04 | Chenango | New York | 36017 | 133 | 2 |
210908 | 210908 | 2020-06-05 | Chenango | New York | 36017 | 133 | 2 |
213992 | 213992 | 2020-06-06 | Chenango | New York | 36017 | 133 | 2 |
217082 | 217082 | 2020-06-07 | Chenango | New York | 36017 | 134 | 2 |
220174 | 220174 | 2020-06-08 | Chenango | New York | 36017 | 135 | 2 |
223268 | 223268 | 2020-06-09 | Chenango | New York | 36017 | 135 | 3 |
226368 | 226368 | 2020-06-10 | Chenango | New York | 36017 | 137 | 3 |
229472 | 229472 | 2020-06-11 | Chenango | New York | 36017 | 137 | 3 |
232577 | 232577 | 2020-06-12 | Chenango | New York | 36017 | 138 | 3 |
235682 | 235682 | 2020-06-13 | Chenango | New York | 36017 | 138 | 3 |
238790 | 238790 | 2020-06-14 | Chenango | New York | 36017 | 138 | 3 |
241899 | 241899 | 2020-06-15 | Chenango | New York | 36017 | 138 | 3 |
245011 | 245011 | 2020-06-16 | Chenango | New York | 36017 | 139 | 3 |
248124 | 248124 | 2020-06-17 | Chenango | New York | 36017 | 139 | 3 |
251239 | 251239 | 2020-06-18 | Chenango | New York | 36017 | 139 | 3 |
254354 | 254354 | 2020-06-19 | Chenango | New York | 36017 | 139 | 3 |
257477 | 257477 | 2020-06-20 | Chenango | New York | 36017 | 139 | 3 |
260604 | 260604 | 2020-06-21 | Chenango | New York | 36017 | 139 | 3 |
263732 | 263732 | 2020-06-22 | Chenango | New York | 36017 | 140 | 3 |
266860 | 266860 | 2020-06-23 | Chenango | New York | 36017 | 141 | 3 |
269994 | 269994 | 2020-06-24 | Chenango | New York | 36017 | 142 | 3 |
273133 | 273133 | 2020-06-25 | Chenango | New York | 36017 | 144 | 3 |
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);