ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where county = "Lewis" and fips = 29111 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
68765 | 68765 | 2020-04-18 | Lewis | Missouri | 29111 | 1 | 0 |
71532 | 71532 | 2020-04-19 | Lewis | Missouri | 29111 | 1 | 0 |
74305 | 74305 | 2020-04-20 | Lewis | Missouri | 29111 | 1 | 0 |
77086 | 77086 | 2020-04-21 | Lewis | Missouri | 29111 | 1 | 0 |
79872 | 79872 | 2020-04-22 | Lewis | Missouri | 29111 | 1 | 1 |
82668 | 82668 | 2020-04-23 | Lewis | Missouri | 29111 | 6 | 1 |
85472 | 85472 | 2020-04-24 | Lewis | Missouri | 29111 | 6 | 1 |
88282 | 88282 | 2020-04-25 | Lewis | Missouri | 29111 | 6 | 1 |
91098 | 91098 | 2020-04-26 | Lewis | Missouri | 29111 | 6 | 1 |
93919 | 93919 | 2020-04-27 | Lewis | Missouri | 29111 | 6 | 1 |
96755 | 96755 | 2020-04-28 | Lewis | Missouri | 29111 | 6 | 1 |
99601 | 99601 | 2020-04-29 | Lewis | Missouri | 29111 | 6 | 1 |
102453 | 102453 | 2020-04-30 | Lewis | Missouri | 29111 | 6 | 1 |
105314 | 105314 | 2020-05-01 | Lewis | Missouri | 29111 | 6 | 1 |
108179 | 108179 | 2020-05-02 | Lewis | Missouri | 29111 | 6 | 1 |
111051 | 111051 | 2020-05-03 | Lewis | Missouri | 29111 | 6 | 1 |
113930 | 113930 | 2020-05-04 | Lewis | Missouri | 29111 | 6 | 1 |
116812 | 116812 | 2020-05-05 | Lewis | Missouri | 29111 | 6 | 1 |
119772 | 119772 | 2020-05-06 | Lewis | Missouri | 29111 | 6 | 1 |
122746 | 122746 | 2020-05-07 | Lewis | Missouri | 29111 | 6 | 1 |
125728 | 125728 | 2020-05-08 | Lewis | Missouri | 29111 | 6 | 1 |
128716 | 128716 | 2020-05-09 | Lewis | Missouri | 29111 | 6 | 1 |
131706 | 131706 | 2020-05-10 | Lewis | Missouri | 29111 | 6 | 1 |
134697 | 134697 | 2020-05-11 | Lewis | Missouri | 29111 | 6 | 1 |
137687 | 137687 | 2020-05-12 | Lewis | Missouri | 29111 | 6 | 1 |
140681 | 140681 | 2020-05-13 | Lewis | Missouri | 29111 | 6 | 1 |
143676 | 143676 | 2020-05-14 | Lewis | Missouri | 29111 | 6 | 1 |
146677 | 146677 | 2020-05-15 | Lewis | Missouri | 29111 | 7 | 1 |
149682 | 149682 | 2020-05-16 | Lewis | Missouri | 29111 | 7 | 1 |
152693 | 152693 | 2020-05-17 | Lewis | Missouri | 29111 | 7 | 1 |
155707 | 155707 | 2020-05-18 | Lewis | Missouri | 29111 | 7 | 1 |
158725 | 158725 | 2020-05-19 | Lewis | Missouri | 29111 | 7 | 1 |
161751 | 161751 | 2020-05-20 | Lewis | Missouri | 29111 | 7 | 1 |
164780 | 164780 | 2020-05-21 | Lewis | Missouri | 29111 | 7 | 1 |
167816 | 167816 | 2020-05-22 | Lewis | Missouri | 29111 | 7 | 1 |
170855 | 170855 | 2020-05-23 | Lewis | Missouri | 29111 | 7 | 1 |
173897 | 173897 | 2020-05-24 | Lewis | Missouri | 29111 | 7 | 1 |
176940 | 176940 | 2020-05-25 | Lewis | Missouri | 29111 | 7 | 1 |
179984 | 179984 | 2020-05-26 | Lewis | Missouri | 29111 | 7 | 1 |
183030 | 183030 | 2020-05-27 | Lewis | Missouri | 29111 | 7 | 1 |
186086 | 186086 | 2020-05-28 | Lewis | Missouri | 29111 | 7 | 1 |
189144 | 189144 | 2020-05-29 | Lewis | Missouri | 29111 | 7 | 1 |
192208 | 192208 | 2020-05-30 | Lewis | Missouri | 29111 | 7 | 1 |
195277 | 195277 | 2020-05-31 | Lewis | Missouri | 29111 | 7 | 1 |
198348 | 198348 | 2020-06-01 | Lewis | Missouri | 29111 | 7 | 1 |
201421 | 201421 | 2020-06-02 | Lewis | Missouri | 29111 | 7 | 1 |
204498 | 204498 | 2020-06-03 | Lewis | Missouri | 29111 | 7 | 1 |
207579 | 207579 | 2020-06-04 | Lewis | Missouri | 29111 | 7 | 1 |
210660 | 210660 | 2020-06-05 | Lewis | Missouri | 29111 | 7 | 1 |
213744 | 213744 | 2020-06-06 | Lewis | Missouri | 29111 | 7 | 1 |
216832 | 216832 | 2020-06-07 | Lewis | Missouri | 29111 | 7 | 1 |
219924 | 219924 | 2020-06-08 | Lewis | Missouri | 29111 | 7 | 1 |
223019 | 223019 | 2020-06-09 | Lewis | Missouri | 29111 | 7 | 1 |
226118 | 226118 | 2020-06-10 | Lewis | Missouri | 29111 | 7 | 1 |
229221 | 229221 | 2020-06-11 | Lewis | Missouri | 29111 | 7 | 1 |
232325 | 232325 | 2020-06-12 | Lewis | Missouri | 29111 | 7 | 1 |
235431 | 235431 | 2020-06-13 | Lewis | Missouri | 29111 | 7 | 1 |
238538 | 238538 | 2020-06-14 | Lewis | Missouri | 29111 | 7 | 1 |
241648 | 241648 | 2020-06-15 | Lewis | Missouri | 29111 | 7 | 1 |
244759 | 244759 | 2020-06-16 | Lewis | Missouri | 29111 | 7 | 1 |
247872 | 247872 | 2020-06-17 | Lewis | Missouri | 29111 | 7 | 1 |
250985 | 250985 | 2020-06-18 | Lewis | Missouri | 29111 | 7 | 1 |
254100 | 254100 | 2020-06-19 | Lewis | Missouri | 29111 | 7 | 1 |
257220 | 257220 | 2020-06-20 | Lewis | Missouri | 29111 | 7 | 1 |
260346 | 260346 | 2020-06-21 | Lewis | Missouri | 29111 | 7 | 1 |
263474 | 263474 | 2020-06-22 | Lewis | Missouri | 29111 | 7 | 1 |
266600 | 266600 | 2020-06-23 | Lewis | Missouri | 29111 | 7 | 1 |
269733 | 269733 | 2020-06-24 | Lewis | Missouri | 29111 | 7 | 1 |
272872 | 272872 | 2020-06-25 | Lewis | Missouri | 29111 | 7 | 1 |
276015 | 276015 | 2020-06-26 | Lewis | Missouri | 29111 | 7 | 1 |
279163 | 279163 | 2020-06-27 | Lewis | Missouri | 29111 | 7 | 1 |
282311 | 282311 | 2020-06-28 | Lewis | Missouri | 29111 | 7 | 1 |
285456 | 285456 | 2020-06-29 | Lewis | Missouri | 29111 | 7 | 1 |
288606 | 288606 | 2020-06-30 | Lewis | Missouri | 29111 | 7 | 1 |
291757 | 291757 | 2020-07-01 | Lewis | Missouri | 29111 | 7 | 1 |
294911 | 294911 | 2020-07-02 | Lewis | Missouri | 29111 | 7 | 1 |
298069 | 298069 | 2020-07-03 | Lewis | Missouri | 29111 | 7 | 1 |
301232 | 301232 | 2020-07-04 | Lewis | Missouri | 29111 | 7 | 1 |
304396 | 304396 | 2020-07-05 | Lewis | Missouri | 29111 | 8 | 1 |
307563 | 307563 | 2020-07-06 | Lewis | Missouri | 29111 | 8 | 1 |
310731 | 310731 | 2020-07-07 | Lewis | Missouri | 29111 | 8 | 1 |
313902 | 313902 | 2020-07-08 | Lewis | Missouri | 29111 | 8 | 1 |
317076 | 317076 | 2020-07-09 | Lewis | Missouri | 29111 | 8 | 1 |
320251 | 320251 | 2020-07-10 | Lewis | Missouri | 29111 | 8 | 1 |
323430 | 323430 | 2020-07-11 | Lewis | Missouri | 29111 | 8 | 1 |
326613 | 326613 | 2020-07-12 | Lewis | Missouri | 29111 | 8 | 1 |
329799 | 329799 | 2020-07-13 | Lewis | Missouri | 29111 | 9 | 1 |
332986 | 332986 | 2020-07-14 | Lewis | Missouri | 29111 | 9 | 1 |
336179 | 336179 | 2020-07-15 | Lewis | Missouri | 29111 | 8 | 1 |
339375 | 339375 | 2020-07-16 | Lewis | Missouri | 29111 | 10 | 1 |
342571 | 342571 | 2020-07-17 | Lewis | Missouri | 29111 | 10 | 1 |
345771 | 345771 | 2020-07-18 | Lewis | Missouri | 29111 | 10 | 1 |
348972 | 348972 | 2020-07-19 | Lewis | Missouri | 29111 | 12 | 1 |
352172 | 352172 | 2020-07-20 | Lewis | Missouri | 29111 | 12 | 1 |
355374 | 355374 | 2020-07-21 | Lewis | Missouri | 29111 | 12 | 1 |
358577 | 358577 | 2020-07-22 | Lewis | Missouri | 29111 | 13 | 1 |
361782 | 361782 | 2020-07-23 | Lewis | Missouri | 29111 | 13 | 1 |
364989 | 364989 | 2020-07-24 | Lewis | Missouri | 29111 | 13 | 1 |
368197 | 368197 | 2020-07-25 | Lewis | Missouri | 29111 | 20 | 1 |
371408 | 371408 | 2020-07-26 | Lewis | Missouri | 29111 | 21 | 1 |
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);