ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Lewis" and state = "New York" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
18845 | 18845 | 2020-03-29 | Lewis | New York | 36049 | 2 | 0 |
20884 | 20884 | 2020-03-30 | Lewis | New York | 36049 | 2 | 0 |
23007 | 23007 | 2020-03-31 | Lewis | New York | 36049 | 2 | 0 |
25201 | 25201 | 2020-04-01 | Lewis | New York | 36049 | 2 | 0 |
27461 | 27461 | 2020-04-02 | Lewis | New York | 36049 | 3 | 0 |
29785 | 29785 | 2020-04-03 | Lewis | New York | 36049 | 3 | 0 |
32171 | 32171 | 2020-04-04 | Lewis | New York | 36049 | 5 | 0 |
34602 | 34602 | 2020-04-05 | Lewis | New York | 36049 | 8 | 0 |
37072 | 37072 | 2020-04-06 | Lewis | New York | 36049 | 8 | 0 |
39587 | 39587 | 2020-04-07 | Lewis | New York | 36049 | 8 | 0 |
42144 | 42144 | 2020-04-08 | Lewis | New York | 36049 | 8 | 0 |
44727 | 44727 | 2020-04-09 | Lewis | New York | 36049 | 6 | 0 |
47340 | 47340 | 2020-04-10 | Lewis | New York | 36049 | 6 | 0 |
49995 | 49995 | 2020-04-11 | Lewis | New York | 36049 | 6 | 0 |
52668 | 52668 | 2020-04-12 | Lewis | New York | 36049 | 6 | 0 |
55351 | 55351 | 2020-04-13 | Lewis | New York | 36049 | 6 | 0 |
58051 | 58051 | 2020-04-14 | Lewis | New York | 36049 | 7 | 0 |
60765 | 60765 | 2020-04-15 | Lewis | New York | 36049 | 7 | 0 |
63491 | 63491 | 2020-04-16 | Lewis | New York | 36049 | 8 | 0 |
66233 | 66233 | 2020-04-17 | Lewis | New York | 36049 | 8 | 0 |
68990 | 68990 | 2020-04-18 | Lewis | New York | 36049 | 8 | 0 |
71757 | 71757 | 2020-04-19 | Lewis | New York | 36049 | 8 | 0 |
74532 | 74532 | 2020-04-20 | Lewis | New York | 36049 | 9 | 0 |
77313 | 77313 | 2020-04-21 | Lewis | New York | 36049 | 9 | 0 |
80102 | 80102 | 2020-04-22 | Lewis | New York | 36049 | 9 | 0 |
82901 | 82901 | 2020-04-23 | Lewis | New York | 36049 | 9 | 0 |
85705 | 85705 | 2020-04-24 | Lewis | New York | 36049 | 9 | 0 |
88517 | 88517 | 2020-04-25 | Lewis | New York | 36049 | 9 | 0 |
91332 | 91332 | 2020-04-26 | Lewis | New York | 36049 | 9 | 0 |
94157 | 94157 | 2020-04-27 | Lewis | New York | 36049 | 9 | 0 |
96993 | 96993 | 2020-04-28 | Lewis | New York | 36049 | 9 | 0 |
99840 | 99840 | 2020-04-29 | Lewis | New York | 36049 | 9 | 0 |
102693 | 102693 | 2020-04-30 | Lewis | New York | 36049 | 9 | 0 |
105555 | 105555 | 2020-05-01 | Lewis | New York | 36049 | 9 | 0 |
108422 | 108422 | 2020-05-02 | Lewis | New York | 36049 | 9 | 0 |
111295 | 111295 | 2020-05-03 | Lewis | New York | 36049 | 9 | 0 |
114176 | 114176 | 2020-05-04 | Lewis | New York | 36049 | 9 | 0 |
117056 | 117056 | 2020-05-05 | Lewis | New York | 36049 | 9 | 0 |
120017 | 120017 | 2020-05-06 | Lewis | New York | 36049 | 9 | 0 |
122992 | 122992 | 2020-05-07 | Lewis | New York | 36049 | 10 | 0 |
125975 | 125975 | 2020-05-08 | Lewis | New York | 36049 | 10 | 0 |
128964 | 128964 | 2020-05-09 | Lewis | New York | 36049 | 11 | 0 |
131953 | 131953 | 2020-05-10 | Lewis | New York | 36049 | 11 | 0 |
134944 | 134944 | 2020-05-11 | Lewis | New York | 36049 | 11 | 0 |
137934 | 137934 | 2020-05-12 | Lewis | New York | 36049 | 11 | 0 |
140930 | 140930 | 2020-05-13 | Lewis | New York | 36049 | 11 | 0 |
143925 | 143925 | 2020-05-14 | Lewis | New York | 36049 | 12 | 0 |
146926 | 146926 | 2020-05-15 | Lewis | New York | 36049 | 12 | 0 |
149933 | 149933 | 2020-05-16 | Lewis | New York | 36049 | 13 | 0 |
152943 | 152943 | 2020-05-17 | Lewis | New York | 36049 | 16 | 0 |
155960 | 155960 | 2020-05-18 | Lewis | New York | 36049 | 17 | 0 |
158978 | 158978 | 2020-05-19 | Lewis | New York | 36049 | 18 | 0 |
162005 | 162005 | 2020-05-20 | Lewis | New York | 36049 | 18 | 0 |
165034 | 165034 | 2020-05-21 | Lewis | New York | 36049 | 18 | 0 |
168069 | 168069 | 2020-05-22 | Lewis | New York | 36049 | 19 | 0 |
171108 | 171108 | 2020-05-23 | Lewis | New York | 36049 | 19 | 0 |
174150 | 174150 | 2020-05-24 | Lewis | New York | 36049 | 19 | 0 |
177194 | 177194 | 2020-05-25 | Lewis | New York | 36049 | 19 | 0 |
180237 | 180237 | 2020-05-26 | Lewis | New York | 36049 | 20 | 0 |
183285 | 183285 | 2020-05-27 | Lewis | New York | 36049 | 20 | 0 |
186342 | 186342 | 2020-05-28 | Lewis | New York | 36049 | 20 | 0 |
189402 | 189402 | 2020-05-29 | Lewis | New York | 36049 | 20 | 0 |
192466 | 192466 | 2020-05-30 | Lewis | New York | 36049 | 20 | 0 |
195536 | 195536 | 2020-05-31 | Lewis | New York | 36049 | 20 | 0 |
198609 | 198609 | 2020-06-01 | Lewis | New York | 36049 | 20 | 0 |
201683 | 201683 | 2020-06-02 | Lewis | New York | 36049 | 20 | 0 |
204760 | 204760 | 2020-06-03 | Lewis | New York | 36049 | 20 | 0 |
207841 | 207841 | 2020-06-04 | Lewis | New York | 36049 | 20 | 0 |
210923 | 210923 | 2020-06-05 | Lewis | New York | 36049 | 20 | 0 |
214007 | 214007 | 2020-06-06 | Lewis | New York | 36049 | 20 | 0 |
217097 | 217097 | 2020-06-07 | Lewis | New York | 36049 | 20 | 0 |
220189 | 220189 | 2020-06-08 | Lewis | New York | 36049 | 20 | 0 |
223283 | 223283 | 2020-06-09 | Lewis | New York | 36049 | 20 | 0 |
226383 | 226383 | 2020-06-10 | Lewis | New York | 36049 | 20 | 0 |
229487 | 229487 | 2020-06-11 | Lewis | New York | 36049 | 20 | 0 |
232592 | 232592 | 2020-06-12 | Lewis | New York | 36049 | 20 | 0 |
235697 | 235697 | 2020-06-13 | Lewis | New York | 36049 | 20 | 0 |
238805 | 238805 | 2020-06-14 | Lewis | New York | 36049 | 20 | 0 |
241914 | 241914 | 2020-06-15 | Lewis | New York | 36049 | 20 | 0 |
245026 | 245026 | 2020-06-16 | Lewis | New York | 36049 | 20 | 0 |
248139 | 248139 | 2020-06-17 | Lewis | New York | 36049 | 21 | 0 |
251254 | 251254 | 2020-06-18 | Lewis | New York | 36049 | 21 | 0 |
254369 | 254369 | 2020-06-19 | Lewis | New York | 36049 | 21 | 0 |
257492 | 257492 | 2020-06-20 | Lewis | New York | 36049 | 22 | 0 |
260619 | 260619 | 2020-06-21 | Lewis | New York | 36049 | 23 | 0 |
263747 | 263747 | 2020-06-22 | Lewis | New York | 36049 | 23 | 0 |
266875 | 266875 | 2020-06-23 | Lewis | New York | 36049 | 24 | 0 |
270009 | 270009 | 2020-06-24 | Lewis | New York | 36049 | 24 | 0 |
273148 | 273148 | 2020-06-25 | Lewis | New York | 36049 | 25 | 0 |
276294 | 276294 | 2020-06-26 | Lewis | New York | 36049 | 26 | 0 |
279442 | 279442 | 2020-06-27 | Lewis | New York | 36049 | 26 | 0 |
282588 | 282588 | 2020-06-28 | Lewis | New York | 36049 | 29 | 0 |
285733 | 285733 | 2020-06-29 | Lewis | New York | 36049 | 30 | 0 |
288883 | 288883 | 2020-06-30 | Lewis | New York | 36049 | 30 | 0 |
292035 | 292035 | 2020-07-01 | Lewis | New York | 36049 | 30 | 0 |
295190 | 295190 | 2020-07-02 | Lewis | New York | 36049 | 30 | 0 |
298350 | 298350 | 2020-07-03 | Lewis | New York | 36049 | 30 | 0 |
301513 | 301513 | 2020-07-04 | Lewis | New York | 36049 | 31 | 0 |
304676 | 304676 | 2020-07-05 | Lewis | New York | 36049 | 31 | 0 |
307843 | 307843 | 2020-07-06 | Lewis | New York | 36049 | 31 | 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);