ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 55131 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389128 | 389128 | 2020-07-31 | Washington | Wisconsin | 55131 | 854 | 23 |
385911 | 385911 | 2020-07-30 | Washington | Wisconsin | 55131 | 804 | 23 |
382693 | 382693 | 2020-07-29 | Washington | Wisconsin | 55131 | 789 | 23 |
379476 | 379476 | 2020-07-28 | Washington | Wisconsin | 55131 | 753 | 23 |
376260 | 376260 | 2020-07-27 | Washington | Wisconsin | 55131 | 717 | 23 |
373046 | 373046 | 2020-07-26 | Washington | Wisconsin | 55131 | 700 | 20 |
369834 | 369834 | 2020-07-25 | Washington | Wisconsin | 55131 | 679 | 20 |
366624 | 366624 | 2020-07-24 | Washington | Wisconsin | 55131 | 679 | 20 |
363417 | 363417 | 2020-07-23 | Washington | Wisconsin | 55131 | 666 | 20 |
360211 | 360211 | 2020-07-22 | Washington | Wisconsin | 55131 | 641 | 20 |
357006 | 357006 | 2020-07-21 | Washington | Wisconsin | 55131 | 616 | 20 |
353803 | 353803 | 2020-07-20 | Washington | Wisconsin | 55131 | 599 | 19 |
350601 | 350601 | 2020-07-19 | Washington | Wisconsin | 55131 | 570 | 19 |
347400 | 347400 | 2020-07-18 | Washington | Wisconsin | 55131 | 558 | 19 |
344200 | 344200 | 2020-07-17 | Washington | Wisconsin | 55131 | 558 | 19 |
341001 | 341001 | 2020-07-16 | Washington | Wisconsin | 55131 | 537 | 19 |
337805 | 337805 | 2020-07-15 | Washington | Wisconsin | 55131 | 523 | 19 |
334610 | 334610 | 2020-07-14 | Washington | Wisconsin | 55131 | 514 | 19 |
331417 | 331417 | 2020-07-13 | Washington | Wisconsin | 55131 | 498 | 19 |
328231 | 328231 | 2020-07-12 | Washington | Wisconsin | 55131 | 490 | 19 |
325045 | 325045 | 2020-07-11 | Washington | Wisconsin | 55131 | 482 | 19 |
321864 | 321864 | 2020-07-10 | Washington | Wisconsin | 55131 | 480 | 19 |
318685 | 318685 | 2020-07-09 | Washington | Wisconsin | 55131 | 470 | 19 |
315512 | 315512 | 2020-07-08 | Washington | Wisconsin | 55131 | 461 | 19 |
312337 | 312337 | 2020-07-07 | Washington | Wisconsin | 55131 | 449 | 19 |
309168 | 309168 | 2020-07-06 | Washington | Wisconsin | 55131 | 440 | 17 |
305999 | 305999 | 2020-07-05 | Washington | Wisconsin | 55131 | 430 | 16 |
302835 | 302835 | 2020-07-04 | Washington | Wisconsin | 55131 | 422 | 16 |
299671 | 299671 | 2020-07-03 | Washington | Wisconsin | 55131 | 411 | 16 |
296509 | 296509 | 2020-07-02 | Washington | Wisconsin | 55131 | 403 | 16 |
293354 | 293354 | 2020-07-01 | Washington | Wisconsin | 55131 | 388 | 16 |
290201 | 290201 | 2020-06-30 | Washington | Wisconsin | 55131 | 373 | 16 |
287051 | 287051 | 2020-06-29 | Washington | Wisconsin | 55131 | 366 | 16 |
283905 | 283905 | 2020-06-28 | Washington | Wisconsin | 55131 | 354 | 16 |
280759 | 280759 | 2020-06-27 | Washington | Wisconsin | 55131 | 348 | 16 |
277611 | 277611 | 2020-06-26 | Washington | Wisconsin | 55131 | 344 | 16 |
274463 | 274463 | 2020-06-25 | Washington | Wisconsin | 55131 | 335 | 16 |
271323 | 271323 | 2020-06-24 | Washington | Wisconsin | 55131 | 331 | 16 |
268189 | 268189 | 2020-06-23 | Washington | Wisconsin | 55131 | 327 | 14 |
265060 | 265060 | 2020-06-22 | Washington | Wisconsin | 55131 | 323 | 13 |
261931 | 261931 | 2020-06-21 | Washington | Wisconsin | 55131 | 321 | 13 |
258804 | 258804 | 2020-06-20 | Washington | Wisconsin | 55131 | 318 | 13 |
255677 | 255677 | 2020-06-19 | Washington | Wisconsin | 55131 | 311 | 13 |
252558 | 252558 | 2020-06-18 | Washington | Wisconsin | 55131 | 304 | 12 |
249443 | 249443 | 2020-06-17 | Washington | Wisconsin | 55131 | 301 | 12 |
246331 | 246331 | 2020-06-16 | Washington | Wisconsin | 55131 | 296 | 12 |
243218 | 243218 | 2020-06-15 | Washington | Wisconsin | 55131 | 294 | 12 |
240107 | 240107 | 2020-06-14 | Washington | Wisconsin | 55131 | 292 | 12 |
236999 | 236999 | 2020-06-13 | Washington | Wisconsin | 55131 | 290 | 12 |
233892 | 233892 | 2020-06-12 | Washington | Wisconsin | 55131 | 289 | 12 |
230787 | 230787 | 2020-06-11 | Washington | Wisconsin | 55131 | 287 | 12 |
227683 | 227683 | 2020-06-10 | Washington | Wisconsin | 55131 | 283 | 11 |
224582 | 224582 | 2020-06-09 | Washington | Wisconsin | 55131 | 281 | 10 |
221486 | 221486 | 2020-06-08 | Washington | Wisconsin | 55131 | 279 | 10 |
218394 | 218394 | 2020-06-07 | Washington | Wisconsin | 55131 | 277 | 9 |
215304 | 215304 | 2020-06-06 | Washington | Wisconsin | 55131 | 277 | 9 |
212217 | 212217 | 2020-06-05 | Washington | Wisconsin | 55131 | 272 | 9 |
209132 | 209132 | 2020-06-04 | Washington | Wisconsin | 55131 | 267 | 9 |
206050 | 206050 | 2020-06-03 | Washington | Wisconsin | 55131 | 261 | 9 |
202971 | 202971 | 2020-06-02 | Washington | Wisconsin | 55131 | 260 | 8 |
199895 | 199895 | 2020-06-01 | Washington | Wisconsin | 55131 | 257 | 7 |
196822 | 196822 | 2020-05-31 | Washington | Wisconsin | 55131 | 252 | 7 |
193752 | 193752 | 2020-05-30 | Washington | Wisconsin | 55131 | 248 | 7 |
190686 | 190686 | 2020-05-29 | Washington | Wisconsin | 55131 | 238 | 6 |
187622 | 187622 | 2020-05-28 | Washington | Wisconsin | 55131 | 233 | 4 |
184565 | 184565 | 2020-05-27 | Washington | Wisconsin | 55131 | 212 | 4 |
181514 | 181514 | 2020-05-26 | Washington | Wisconsin | 55131 | 209 | 4 |
178470 | 178470 | 2020-05-25 | Washington | Wisconsin | 55131 | 206 | 4 |
175425 | 175425 | 2020-05-24 | Washington | Wisconsin | 55131 | 193 | 4 |
172382 | 172382 | 2020-05-23 | Washington | Wisconsin | 55131 | 181 | 4 |
169341 | 169341 | 2020-05-22 | Washington | Wisconsin | 55131 | 178 | 4 |
166305 | 166305 | 2020-05-21 | Washington | Wisconsin | 55131 | 171 | 4 |
163274 | 163274 | 2020-05-20 | Washington | Wisconsin | 55131 | 163 | 4 |
160246 | 160246 | 2020-05-19 | Washington | Wisconsin | 55131 | 155 | 4 |
157222 | 157222 | 2020-05-18 | Washington | Wisconsin | 55131 | 149 | 4 |
154206 | 154206 | 2020-05-17 | Washington | Wisconsin | 55131 | 148 | 4 |
151194 | 151194 | 2020-05-16 | Washington | Wisconsin | 55131 | 140 | 4 |
148185 | 148185 | 2020-05-15 | Washington | Wisconsin | 55131 | 129 | 4 |
145182 | 145182 | 2020-05-14 | Washington | Wisconsin | 55131 | 125 | 4 |
142183 | 142183 | 2020-05-13 | Washington | Wisconsin | 55131 | 122 | 4 |
139187 | 139187 | 2020-05-12 | Washington | Wisconsin | 55131 | 119 | 4 |
136196 | 136196 | 2020-05-11 | Washington | Wisconsin | 55131 | 118 | 4 |
133206 | 133206 | 2020-05-10 | Washington | Wisconsin | 55131 | 117 | 4 |
130216 | 130216 | 2020-05-09 | Washington | Wisconsin | 55131 | 116 | 4 |
127226 | 127226 | 2020-05-08 | Washington | Wisconsin | 55131 | 114 | 4 |
124241 | 124241 | 2020-05-07 | Washington | Wisconsin | 55131 | 113 | 4 |
121261 | 121261 | 2020-05-06 | Washington | Wisconsin | 55131 | 107 | 4 |
118295 | 118295 | 2020-05-05 | Washington | Wisconsin | 55131 | 106 | 4 |
115336 | 115336 | 2020-05-04 | Washington | Wisconsin | 55131 | 104 | 4 |
112453 | 112453 | 2020-05-03 | Washington | Wisconsin | 55131 | 101 | 4 |
109578 | 109578 | 2020-05-02 | Washington | Wisconsin | 55131 | 100 | 4 |
106709 | 106709 | 2020-05-01 | Washington | Wisconsin | 55131 | 99 | 4 |
103844 | 103844 | 2020-04-30 | Washington | Wisconsin | 55131 | 98 | 4 |
100989 | 100989 | 2020-04-29 | Washington | Wisconsin | 55131 | 97 | 4 |
98139 | 98139 | 2020-04-28 | Washington | Wisconsin | 55131 | 96 | 4 |
95294 | 95294 | 2020-04-27 | Washington | Wisconsin | 55131 | 94 | 4 |
92464 | 92464 | 2020-04-26 | Washington | Wisconsin | 55131 | 92 | 4 |
89646 | 89646 | 2020-04-25 | Washington | Wisconsin | 55131 | 92 | 4 |
86830 | 86830 | 2020-04-24 | Washington | Wisconsin | 55131 | 91 | 4 |
84022 | 84022 | 2020-04-23 | Washington | Wisconsin | 55131 | 90 | 4 |
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);