ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
743 rows where county = "Lincoln" and state = "Wisconsin" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
106679 | 106679 | 2020-05-01 | Lincoln | Wisconsin | 55069 | 1 | 0 |
109548 | 109548 | 2020-05-02 | Lincoln | Wisconsin | 55069 | 1 | 0 |
112423 | 112423 | 2020-05-03 | Lincoln | Wisconsin | 55069 | 1 | 0 |
115306 | 115306 | 2020-05-04 | Lincoln | Wisconsin | 55069 | 1 | 0 |
118265 | 118265 | 2020-05-05 | Lincoln | Wisconsin | 55069 | 1 | 0 |
121231 | 121231 | 2020-05-06 | Lincoln | Wisconsin | 55069 | 1 | 0 |
124211 | 124211 | 2020-05-07 | Lincoln | Wisconsin | 55069 | 1 | 0 |
127196 | 127196 | 2020-05-08 | Lincoln | Wisconsin | 55069 | 1 | 0 |
130186 | 130186 | 2020-05-09 | Lincoln | Wisconsin | 55069 | 1 | 0 |
133176 | 133176 | 2020-05-10 | Lincoln | Wisconsin | 55069 | 1 | 0 |
136166 | 136166 | 2020-05-11 | Lincoln | Wisconsin | 55069 | 1 | 0 |
139157 | 139157 | 2020-05-12 | Lincoln | Wisconsin | 55069 | 1 | 0 |
142153 | 142153 | 2020-05-13 | Lincoln | Wisconsin | 55069 | 1 | 0 |
145151 | 145151 | 2020-05-14 | Lincoln | Wisconsin | 55069 | 2 | 0 |
148154 | 148154 | 2020-05-15 | Lincoln | Wisconsin | 55069 | 2 | 0 |
151163 | 151163 | 2020-05-16 | Lincoln | Wisconsin | 55069 | 3 | 0 |
154175 | 154175 | 2020-05-17 | Lincoln | Wisconsin | 55069 | 3 | 0 |
157191 | 157191 | 2020-05-18 | Lincoln | Wisconsin | 55069 | 3 | 0 |
160215 | 160215 | 2020-05-19 | Lincoln | Wisconsin | 55069 | 3 | 0 |
163243 | 163243 | 2020-05-20 | Lincoln | Wisconsin | 55069 | 3 | 0 |
166273 | 166273 | 2020-05-21 | Lincoln | Wisconsin | 55069 | 3 | 0 |
169309 | 169309 | 2020-05-22 | Lincoln | Wisconsin | 55069 | 3 | 0 |
172350 | 172350 | 2020-05-23 | Lincoln | Wisconsin | 55069 | 3 | 0 |
175393 | 175393 | 2020-05-24 | Lincoln | Wisconsin | 55069 | 4 | 0 |
178438 | 178438 | 2020-05-25 | Lincoln | Wisconsin | 55069 | 4 | 0 |
181482 | 181482 | 2020-05-26 | Lincoln | Wisconsin | 55069 | 5 | 0 |
184533 | 184533 | 2020-05-27 | Lincoln | Wisconsin | 55069 | 5 | 0 |
187590 | 187590 | 2020-05-28 | Lincoln | Wisconsin | 55069 | 7 | 0 |
190654 | 190654 | 2020-05-29 | Lincoln | Wisconsin | 55069 | 7 | 0 |
193720 | 193720 | 2020-05-30 | Lincoln | Wisconsin | 55069 | 7 | 0 |
196790 | 196790 | 2020-05-31 | Lincoln | Wisconsin | 55069 | 7 | 0 |
199863 | 199863 | 2020-06-01 | Lincoln | Wisconsin | 55069 | 7 | 0 |
202939 | 202939 | 2020-06-02 | Lincoln | Wisconsin | 55069 | 7 | 0 |
206018 | 206018 | 2020-06-03 | Lincoln | Wisconsin | 55069 | 7 | 0 |
209100 | 209100 | 2020-06-04 | Lincoln | Wisconsin | 55069 | 7 | 0 |
212185 | 212185 | 2020-06-05 | Lincoln | Wisconsin | 55069 | 7 | 0 |
215272 | 215272 | 2020-06-06 | Lincoln | Wisconsin | 55069 | 7 | 0 |
218362 | 218362 | 2020-06-07 | Lincoln | Wisconsin | 55069 | 7 | 0 |
221454 | 221454 | 2020-06-08 | Lincoln | Wisconsin | 55069 | 7 | 0 |
224550 | 224550 | 2020-06-09 | Lincoln | Wisconsin | 55069 | 7 | 0 |
227650 | 227650 | 2020-06-10 | Lincoln | Wisconsin | 55069 | 7 | 0 |
230754 | 230754 | 2020-06-11 | Lincoln | Wisconsin | 55069 | 7 | 0 |
233859 | 233859 | 2020-06-12 | Lincoln | Wisconsin | 55069 | 7 | 0 |
236966 | 236966 | 2020-06-13 | Lincoln | Wisconsin | 55069 | 7 | 0 |
246298 | 246298 | 2020-06-16 | Lincoln | Wisconsin | 55069 | 7 | 0 |
240074 | 240074 | 2020-06-14 | Lincoln | Wisconsin | 55069 | 8 | 0 |
243185 | 243185 | 2020-06-15 | Lincoln | Wisconsin | 55069 | 8 | 0 |
249410 | 249410 | 2020-06-17 | Lincoln | Wisconsin | 55069 | 8 | 0 |
252525 | 252525 | 2020-06-18 | Lincoln | Wisconsin | 55069 | 8 | 0 |
255644 | 255644 | 2020-06-19 | Lincoln | Wisconsin | 55069 | 8 | 0 |
258771 | 258771 | 2020-06-20 | Lincoln | Wisconsin | 55069 | 8 | 0 |
261898 | 261898 | 2020-06-21 | Lincoln | Wisconsin | 55069 | 8 | 0 |
265027 | 265027 | 2020-06-22 | Lincoln | Wisconsin | 55069 | 8 | 0 |
268156 | 268156 | 2020-06-23 | Lincoln | Wisconsin | 55069 | 8 | 0 |
271290 | 271290 | 2020-06-24 | Lincoln | Wisconsin | 55069 | 8 | 0 |
274430 | 274430 | 2020-06-25 | Lincoln | Wisconsin | 55069 | 8 | 0 |
277578 | 277578 | 2020-06-26 | Lincoln | Wisconsin | 55069 | 9 | 0 |
280726 | 280726 | 2020-06-27 | Lincoln | Wisconsin | 55069 | 9 | 0 |
283872 | 283872 | 2020-06-28 | Lincoln | Wisconsin | 55069 | 9 | 0 |
287018 | 287018 | 2020-06-29 | Lincoln | Wisconsin | 55069 | 9 | 0 |
290168 | 290168 | 2020-06-30 | Lincoln | Wisconsin | 55069 | 10 | 0 |
293321 | 293321 | 2020-07-01 | Lincoln | Wisconsin | 55069 | 10 | 0 |
296476 | 296476 | 2020-07-02 | Lincoln | Wisconsin | 55069 | 11 | 0 |
299638 | 299638 | 2020-07-03 | Lincoln | Wisconsin | 55069 | 12 | 0 |
302802 | 302802 | 2020-07-04 | Lincoln | Wisconsin | 55069 | 14 | 0 |
305966 | 305966 | 2020-07-05 | Lincoln | Wisconsin | 55069 | 15 | 0 |
309135 | 309135 | 2020-07-06 | Lincoln | Wisconsin | 55069 | 15 | 0 |
312304 | 312304 | 2020-07-07 | Lincoln | Wisconsin | 55069 | 17 | 0 |
315479 | 315479 | 2020-07-08 | Lincoln | Wisconsin | 55069 | 18 | 0 |
321831 | 321831 | 2020-07-10 | Lincoln | Wisconsin | 55069 | 20 | 0 |
318652 | 318652 | 2020-07-09 | Lincoln | Wisconsin | 55069 | 21 | 0 |
325012 | 325012 | 2020-07-11 | Lincoln | Wisconsin | 55069 | 21 | 0 |
328198 | 328198 | 2020-07-12 | Lincoln | Wisconsin | 55069 | 22 | 0 |
334577 | 334577 | 2020-07-14 | Lincoln | Wisconsin | 55069 | 22 | 0 |
331384 | 331384 | 2020-07-13 | Lincoln | Wisconsin | 55069 | 23 | 0 |
337772 | 337772 | 2020-07-15 | Lincoln | Wisconsin | 55069 | 24 | 0 |
340968 | 340968 | 2020-07-16 | Lincoln | Wisconsin | 55069 | 25 | 0 |
344167 | 344167 | 2020-07-17 | Lincoln | Wisconsin | 55069 | 31 | 0 |
347367 | 347367 | 2020-07-18 | Lincoln | Wisconsin | 55069 | 33 | 0 |
350568 | 350568 | 2020-07-19 | Lincoln | Wisconsin | 55069 | 35 | 0 |
353770 | 353770 | 2020-07-20 | Lincoln | Wisconsin | 55069 | 37 | 0 |
356973 | 356973 | 2020-07-21 | Lincoln | Wisconsin | 55069 | 40 | 0 |
360178 | 360178 | 2020-07-22 | Lincoln | Wisconsin | 55069 | 46 | 0 |
363384 | 363384 | 2020-07-23 | Lincoln | Wisconsin | 55069 | 49 | 0 |
366591 | 366591 | 2020-07-24 | Lincoln | Wisconsin | 55069 | 50 | 0 |
369801 | 369801 | 2020-07-25 | Lincoln | Wisconsin | 55069 | 52 | 0 |
373013 | 373013 | 2020-07-26 | Lincoln | Wisconsin | 55069 | 52 | 0 |
376227 | 376227 | 2020-07-27 | Lincoln | Wisconsin | 55069 | 55 | 0 |
379443 | 379443 | 2020-07-28 | Lincoln | Wisconsin | 55069 | 56 | 0 |
382660 | 382660 | 2020-07-29 | Lincoln | Wisconsin | 55069 | 56 | 0 |
385878 | 385878 | 2020-07-30 | Lincoln | Wisconsin | 55069 | 60 | 0 |
389095 | 389095 | 2020-07-31 | Lincoln | Wisconsin | 55069 | 60 | 0 |
392312 | 392312 | 2020-08-01 | Lincoln | Wisconsin | 55069 | 61 | 0 |
395528 | 395528 | 2020-08-02 | Lincoln | Wisconsin | 55069 | 63 | 0 |
398744 | 398744 | 2020-08-03 | Lincoln | Wisconsin | 55069 | 64 | 0 |
401960 | 401960 | 2020-08-04 | Lincoln | Wisconsin | 55069 | 65 | 0 |
408398 | 408398 | 2020-08-06 | Lincoln | Wisconsin | 55069 | 65 | 0 |
405178 | 405178 | 2020-08-05 | Lincoln | Wisconsin | 55069 | 66 | 0 |
411617 | 411617 | 2020-08-07 | Lincoln | Wisconsin | 55069 | 67 | 0 |
414837 | 414837 | 2020-08-08 | Lincoln | Wisconsin | 55069 | 68 | 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);