ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55031 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389076 | 389076 | 2020-07-31 | Douglas | Wisconsin | 55031 | 113 | 0 |
385859 | 385859 | 2020-07-30 | Douglas | Wisconsin | 55031 | 110 | 0 |
382641 | 382641 | 2020-07-29 | Douglas | Wisconsin | 55031 | 102 | 0 |
379424 | 379424 | 2020-07-28 | Douglas | Wisconsin | 55031 | 96 | 0 |
376208 | 376208 | 2020-07-27 | Douglas | Wisconsin | 55031 | 92 | 0 |
372994 | 372994 | 2020-07-26 | Douglas | Wisconsin | 55031 | 92 | 0 |
369782 | 369782 | 2020-07-25 | Douglas | Wisconsin | 55031 | 89 | 0 |
366572 | 366572 | 2020-07-24 | Douglas | Wisconsin | 55031 | 87 | 0 |
363365 | 363365 | 2020-07-23 | Douglas | Wisconsin | 55031 | 82 | 0 |
360159 | 360159 | 2020-07-22 | Douglas | Wisconsin | 55031 | 77 | 0 |
356954 | 356954 | 2020-07-21 | Douglas | Wisconsin | 55031 | 75 | 0 |
353751 | 353751 | 2020-07-20 | Douglas | Wisconsin | 55031 | 75 | 0 |
350549 | 350549 | 2020-07-19 | Douglas | Wisconsin | 55031 | 75 | 0 |
347348 | 347348 | 2020-07-18 | Douglas | Wisconsin | 55031 | 74 | 0 |
344148 | 344148 | 2020-07-17 | Douglas | Wisconsin | 55031 | 66 | 0 |
340949 | 340949 | 2020-07-16 | Douglas | Wisconsin | 55031 | 66 | 0 |
337753 | 337753 | 2020-07-15 | Douglas | Wisconsin | 55031 | 64 | 0 |
334558 | 334558 | 2020-07-14 | Douglas | Wisconsin | 55031 | 63 | 0 |
331365 | 331365 | 2020-07-13 | Douglas | Wisconsin | 55031 | 61 | 0 |
328179 | 328179 | 2020-07-12 | Douglas | Wisconsin | 55031 | 60 | 0 |
324993 | 324993 | 2020-07-11 | Douglas | Wisconsin | 55031 | 56 | 0 |
321812 | 321812 | 2020-07-10 | Douglas | Wisconsin | 55031 | 50 | 0 |
318633 | 318633 | 2020-07-09 | Douglas | Wisconsin | 55031 | 48 | 0 |
315460 | 315460 | 2020-07-08 | Douglas | Wisconsin | 55031 | 47 | 0 |
312285 | 312285 | 2020-07-07 | Douglas | Wisconsin | 55031 | 46 | 0 |
309116 | 309116 | 2020-07-06 | Douglas | Wisconsin | 55031 | 41 | 0 |
305947 | 305947 | 2020-07-05 | Douglas | Wisconsin | 55031 | 41 | 0 |
302783 | 302783 | 2020-07-04 | Douglas | Wisconsin | 55031 | 39 | 0 |
299619 | 299619 | 2020-07-03 | Douglas | Wisconsin | 55031 | 39 | 0 |
296457 | 296457 | 2020-07-02 | Douglas | Wisconsin | 55031 | 31 | 0 |
293302 | 293302 | 2020-07-01 | Douglas | Wisconsin | 55031 | 30 | 0 |
290149 | 290149 | 2020-06-30 | Douglas | Wisconsin | 55031 | 25 | 0 |
286999 | 286999 | 2020-06-29 | Douglas | Wisconsin | 55031 | 24 | 0 |
283853 | 283853 | 2020-06-28 | Douglas | Wisconsin | 55031 | 24 | 0 |
280707 | 280707 | 2020-06-27 | Douglas | Wisconsin | 55031 | 22 | 0 |
277559 | 277559 | 2020-06-26 | Douglas | Wisconsin | 55031 | 22 | 0 |
274411 | 274411 | 2020-06-25 | Douglas | Wisconsin | 55031 | 20 | 0 |
271271 | 271271 | 2020-06-24 | Douglas | Wisconsin | 55031 | 20 | 0 |
268137 | 268137 | 2020-06-23 | Douglas | Wisconsin | 55031 | 20 | 0 |
265008 | 265008 | 2020-06-22 | Douglas | Wisconsin | 55031 | 20 | 0 |
261879 | 261879 | 2020-06-21 | Douglas | Wisconsin | 55031 | 20 | 0 |
258752 | 258752 | 2020-06-20 | Douglas | Wisconsin | 55031 | 20 | 0 |
255625 | 255625 | 2020-06-19 | Douglas | Wisconsin | 55031 | 20 | 0 |
252506 | 252506 | 2020-06-18 | Douglas | Wisconsin | 55031 | 20 | 0 |
249391 | 249391 | 2020-06-17 | Douglas | Wisconsin | 55031 | 20 | 0 |
246279 | 246279 | 2020-06-16 | Douglas | Wisconsin | 55031 | 20 | 0 |
243166 | 243166 | 2020-06-15 | Douglas | Wisconsin | 55031 | 20 | 0 |
240055 | 240055 | 2020-06-14 | Douglas | Wisconsin | 55031 | 20 | 0 |
236947 | 236947 | 2020-06-13 | Douglas | Wisconsin | 55031 | 20 | 0 |
233840 | 233840 | 2020-06-12 | Douglas | Wisconsin | 55031 | 20 | 0 |
230735 | 230735 | 2020-06-11 | Douglas | Wisconsin | 55031 | 20 | 0 |
227631 | 227631 | 2020-06-10 | Douglas | Wisconsin | 55031 | 20 | 0 |
224531 | 224531 | 2020-06-09 | Douglas | Wisconsin | 55031 | 20 | 0 |
221435 | 221435 | 2020-06-08 | Douglas | Wisconsin | 55031 | 20 | 0 |
218343 | 218343 | 2020-06-07 | Douglas | Wisconsin | 55031 | 20 | 0 |
215253 | 215253 | 2020-06-06 | Douglas | Wisconsin | 55031 | 20 | 0 |
212166 | 212166 | 2020-06-05 | Douglas | Wisconsin | 55031 | 19 | 0 |
209081 | 209081 | 2020-06-04 | Douglas | Wisconsin | 55031 | 19 | 0 |
205999 | 205999 | 2020-06-03 | Douglas | Wisconsin | 55031 | 19 | 0 |
202920 | 202920 | 2020-06-02 | Douglas | Wisconsin | 55031 | 19 | 0 |
199844 | 199844 | 2020-06-01 | Douglas | Wisconsin | 55031 | 19 | 0 |
196771 | 196771 | 2020-05-31 | Douglas | Wisconsin | 55031 | 19 | 0 |
193701 | 193701 | 2020-05-30 | Douglas | Wisconsin | 55031 | 19 | 0 |
190635 | 190635 | 2020-05-29 | Douglas | Wisconsin | 55031 | 19 | 0 |
187571 | 187571 | 2020-05-28 | Douglas | Wisconsin | 55031 | 19 | 0 |
184514 | 184514 | 2020-05-27 | Douglas | Wisconsin | 55031 | 19 | 0 |
181463 | 181463 | 2020-05-26 | Douglas | Wisconsin | 55031 | 19 | 0 |
178419 | 178419 | 2020-05-25 | Douglas | Wisconsin | 55031 | 18 | 0 |
175374 | 175374 | 2020-05-24 | Douglas | Wisconsin | 55031 | 17 | 0 |
172331 | 172331 | 2020-05-23 | Douglas | Wisconsin | 55031 | 17 | 0 |
169290 | 169290 | 2020-05-22 | Douglas | Wisconsin | 55031 | 16 | 0 |
166254 | 166254 | 2020-05-21 | Douglas | Wisconsin | 55031 | 15 | 0 |
163225 | 163225 | 2020-05-20 | Douglas | Wisconsin | 55031 | 15 | 0 |
160197 | 160197 | 2020-05-19 | Douglas | Wisconsin | 55031 | 15 | 0 |
157173 | 157173 | 2020-05-18 | Douglas | Wisconsin | 55031 | 13 | 0 |
154157 | 154157 | 2020-05-17 | Douglas | Wisconsin | 55031 | 12 | 0 |
151145 | 151145 | 2020-05-16 | Douglas | Wisconsin | 55031 | 12 | 0 |
148136 | 148136 | 2020-05-15 | Douglas | Wisconsin | 55031 | 12 | 0 |
145133 | 145133 | 2020-05-14 | Douglas | Wisconsin | 55031 | 12 | 0 |
142135 | 142135 | 2020-05-13 | Douglas | Wisconsin | 55031 | 11 | 0 |
139139 | 139139 | 2020-05-12 | Douglas | Wisconsin | 55031 | 11 | 0 |
136148 | 136148 | 2020-05-11 | Douglas | Wisconsin | 55031 | 11 | 0 |
133158 | 133158 | 2020-05-10 | Douglas | Wisconsin | 55031 | 11 | 0 |
130168 | 130168 | 2020-05-09 | Douglas | Wisconsin | 55031 | 11 | 0 |
127178 | 127178 | 2020-05-08 | Douglas | Wisconsin | 55031 | 10 | 0 |
124193 | 124193 | 2020-05-07 | Douglas | Wisconsin | 55031 | 10 | 0 |
121213 | 121213 | 2020-05-06 | Douglas | Wisconsin | 55031 | 10 | 0 |
118248 | 118248 | 2020-05-05 | Douglas | Wisconsin | 55031 | 9 | 0 |
115289 | 115289 | 2020-05-04 | Douglas | Wisconsin | 55031 | 9 | 0 |
112406 | 112406 | 2020-05-03 | Douglas | Wisconsin | 55031 | 9 | 0 |
109531 | 109531 | 2020-05-02 | Douglas | Wisconsin | 55031 | 9 | 0 |
106662 | 106662 | 2020-05-01 | Douglas | Wisconsin | 55031 | 9 | 0 |
103798 | 103798 | 2020-04-30 | Douglas | Wisconsin | 55031 | 9 | 0 |
100943 | 100943 | 2020-04-29 | Douglas | Wisconsin | 55031 | 9 | 0 |
98093 | 98093 | 2020-04-28 | Douglas | Wisconsin | 55031 | 9 | 0 |
95248 | 95248 | 2020-04-27 | Douglas | Wisconsin | 55031 | 9 | 0 |
92418 | 92418 | 2020-04-26 | Douglas | Wisconsin | 55031 | 9 | 0 |
89600 | 89600 | 2020-04-25 | Douglas | Wisconsin | 55031 | 9 | 0 |
86784 | 86784 | 2020-04-24 | Douglas | Wisconsin | 55031 | 9 | 0 |
83977 | 83977 | 2020-04-23 | Douglas | Wisconsin | 55031 | 9 | 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);