ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55035 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389078 | 389078 | 2020-07-31 | Eau Claire | Wisconsin | 55035 | 474 | 3 |
385861 | 385861 | 2020-07-30 | Eau Claire | Wisconsin | 55035 | 462 | 3 |
382643 | 382643 | 2020-07-29 | Eau Claire | Wisconsin | 55035 | 448 | 3 |
379426 | 379426 | 2020-07-28 | Eau Claire | Wisconsin | 55035 | 441 | 3 |
376210 | 376210 | 2020-07-27 | Eau Claire | Wisconsin | 55035 | 436 | 3 |
372996 | 372996 | 2020-07-26 | Eau Claire | Wisconsin | 55035 | 433 | 3 |
369784 | 369784 | 2020-07-25 | Eau Claire | Wisconsin | 55035 | 433 | 3 |
366574 | 366574 | 2020-07-24 | Eau Claire | Wisconsin | 55035 | 423 | 3 |
363367 | 363367 | 2020-07-23 | Eau Claire | Wisconsin | 55035 | 421 | 3 |
360161 | 360161 | 2020-07-22 | Eau Claire | Wisconsin | 55035 | 409 | 2 |
356956 | 356956 | 2020-07-21 | Eau Claire | Wisconsin | 55035 | 407 | 2 |
353753 | 353753 | 2020-07-20 | Eau Claire | Wisconsin | 55035 | 402 | 2 |
350551 | 350551 | 2020-07-19 | Eau Claire | Wisconsin | 55035 | 397 | 2 |
347350 | 347350 | 2020-07-18 | Eau Claire | Wisconsin | 55035 | 388 | 2 |
344150 | 344150 | 2020-07-17 | Eau Claire | Wisconsin | 55035 | 371 | 1 |
340951 | 340951 | 2020-07-16 | Eau Claire | Wisconsin | 55035 | 365 | 1 |
337755 | 337755 | 2020-07-15 | Eau Claire | Wisconsin | 55035 | 351 | 1 |
334560 | 334560 | 2020-07-14 | Eau Claire | Wisconsin | 55035 | 346 | 1 |
331367 | 331367 | 2020-07-13 | Eau Claire | Wisconsin | 55035 | 340 | 1 |
328181 | 328181 | 2020-07-12 | Eau Claire | Wisconsin | 55035 | 338 | 1 |
324995 | 324995 | 2020-07-11 | Eau Claire | Wisconsin | 55035 | 332 | 1 |
321814 | 321814 | 2020-07-10 | Eau Claire | Wisconsin | 55035 | 323 | 1 |
318635 | 318635 | 2020-07-09 | Eau Claire | Wisconsin | 55035 | 314 | 1 |
315462 | 315462 | 2020-07-08 | Eau Claire | Wisconsin | 55035 | 307 | 1 |
312287 | 312287 | 2020-07-07 | Eau Claire | Wisconsin | 55035 | 300 | 1 |
309118 | 309118 | 2020-07-06 | Eau Claire | Wisconsin | 55035 | 290 | 1 |
305949 | 305949 | 2020-07-05 | Eau Claire | Wisconsin | 55035 | 284 | 1 |
302785 | 302785 | 2020-07-04 | Eau Claire | Wisconsin | 55035 | 279 | 1 |
299621 | 299621 | 2020-07-03 | Eau Claire | Wisconsin | 55035 | 263 | 1 |
296459 | 296459 | 2020-07-02 | Eau Claire | Wisconsin | 55035 | 249 | 1 |
293304 | 293304 | 2020-07-01 | Eau Claire | Wisconsin | 55035 | 240 | 1 |
290151 | 290151 | 2020-06-30 | Eau Claire | Wisconsin | 55035 | 229 | 1 |
287001 | 287001 | 2020-06-29 | Eau Claire | Wisconsin | 55035 | 218 | 1 |
283855 | 283855 | 2020-06-28 | Eau Claire | Wisconsin | 55035 | 208 | 1 |
280709 | 280709 | 2020-06-27 | Eau Claire | Wisconsin | 55035 | 194 | 1 |
277561 | 277561 | 2020-06-26 | Eau Claire | Wisconsin | 55035 | 180 | 1 |
274413 | 274413 | 2020-06-25 | Eau Claire | Wisconsin | 55035 | 176 | 1 |
271273 | 271273 | 2020-06-24 | Eau Claire | Wisconsin | 55035 | 170 | 1 |
268139 | 268139 | 2020-06-23 | Eau Claire | Wisconsin | 55035 | 167 | 1 |
265010 | 265010 | 2020-06-22 | Eau Claire | Wisconsin | 55035 | 163 | 1 |
261881 | 261881 | 2020-06-21 | Eau Claire | Wisconsin | 55035 | 161 | 0 |
258754 | 258754 | 2020-06-20 | Eau Claire | Wisconsin | 55035 | 156 | 0 |
255627 | 255627 | 2020-06-19 | Eau Claire | Wisconsin | 55035 | 151 | 0 |
252508 | 252508 | 2020-06-18 | Eau Claire | Wisconsin | 55035 | 149 | 0 |
249393 | 249393 | 2020-06-17 | Eau Claire | Wisconsin | 55035 | 140 | 0 |
246281 | 246281 | 2020-06-16 | Eau Claire | Wisconsin | 55035 | 138 | 0 |
243168 | 243168 | 2020-06-15 | Eau Claire | Wisconsin | 55035 | 137 | 0 |
240057 | 240057 | 2020-06-14 | Eau Claire | Wisconsin | 55035 | 137 | 0 |
236949 | 236949 | 2020-06-13 | Eau Claire | Wisconsin | 55035 | 132 | 0 |
233842 | 233842 | 2020-06-12 | Eau Claire | Wisconsin | 55035 | 130 | 0 |
230737 | 230737 | 2020-06-11 | Eau Claire | Wisconsin | 55035 | 126 | 0 |
227633 | 227633 | 2020-06-10 | Eau Claire | Wisconsin | 55035 | 126 | 0 |
224533 | 224533 | 2020-06-09 | Eau Claire | Wisconsin | 55035 | 124 | 0 |
221437 | 221437 | 2020-06-08 | Eau Claire | Wisconsin | 55035 | 124 | 0 |
218345 | 218345 | 2020-06-07 | Eau Claire | Wisconsin | 55035 | 123 | 0 |
215255 | 215255 | 2020-06-06 | Eau Claire | Wisconsin | 55035 | 121 | 0 |
212168 | 212168 | 2020-06-05 | Eau Claire | Wisconsin | 55035 | 119 | 0 |
209083 | 209083 | 2020-06-04 | Eau Claire | Wisconsin | 55035 | 116 | 0 |
206001 | 206001 | 2020-06-03 | Eau Claire | Wisconsin | 55035 | 114 | 0 |
202922 | 202922 | 2020-06-02 | Eau Claire | Wisconsin | 55035 | 114 | 0 |
199846 | 199846 | 2020-06-01 | Eau Claire | Wisconsin | 55035 | 113 | 0 |
196773 | 196773 | 2020-05-31 | Eau Claire | Wisconsin | 55035 | 108 | 0 |
193703 | 193703 | 2020-05-30 | Eau Claire | Wisconsin | 55035 | 108 | 0 |
190637 | 190637 | 2020-05-29 | Eau Claire | Wisconsin | 55035 | 107 | 0 |
187573 | 187573 | 2020-05-28 | Eau Claire | Wisconsin | 55035 | 99 | 0 |
184516 | 184516 | 2020-05-27 | Eau Claire | Wisconsin | 55035 | 99 | 0 |
181465 | 181465 | 2020-05-26 | Eau Claire | Wisconsin | 55035 | 100 | 0 |
178421 | 178421 | 2020-05-25 | Eau Claire | Wisconsin | 55035 | 98 | 0 |
175376 | 175376 | 2020-05-24 | Eau Claire | Wisconsin | 55035 | 96 | 0 |
172333 | 172333 | 2020-05-23 | Eau Claire | Wisconsin | 55035 | 93 | 0 |
169292 | 169292 | 2020-05-22 | Eau Claire | Wisconsin | 55035 | 89 | 0 |
166256 | 166256 | 2020-05-21 | Eau Claire | Wisconsin | 55035 | 82 | 0 |
163227 | 163227 | 2020-05-20 | Eau Claire | Wisconsin | 55035 | 78 | 0 |
160199 | 160199 | 2020-05-19 | Eau Claire | Wisconsin | 55035 | 75 | 0 |
157175 | 157175 | 2020-05-18 | Eau Claire | Wisconsin | 55035 | 70 | 0 |
154159 | 154159 | 2020-05-17 | Eau Claire | Wisconsin | 55035 | 66 | 0 |
151147 | 151147 | 2020-05-16 | Eau Claire | Wisconsin | 55035 | 65 | 0 |
148138 | 148138 | 2020-05-15 | Eau Claire | Wisconsin | 55035 | 65 | 0 |
145135 | 145135 | 2020-05-14 | Eau Claire | Wisconsin | 55035 | 63 | 0 |
142137 | 142137 | 2020-05-13 | Eau Claire | Wisconsin | 55035 | 61 | 0 |
139141 | 139141 | 2020-05-12 | Eau Claire | Wisconsin | 55035 | 60 | 0 |
136150 | 136150 | 2020-05-11 | Eau Claire | Wisconsin | 55035 | 57 | 0 |
133160 | 133160 | 2020-05-10 | Eau Claire | Wisconsin | 55035 | 54 | 0 |
130170 | 130170 | 2020-05-09 | Eau Claire | Wisconsin | 55035 | 54 | 0 |
127180 | 127180 | 2020-05-08 | Eau Claire | Wisconsin | 55035 | 50 | 0 |
124195 | 124195 | 2020-05-07 | Eau Claire | Wisconsin | 55035 | 47 | 0 |
121215 | 121215 | 2020-05-06 | Eau Claire | Wisconsin | 55035 | 45 | 0 |
118250 | 118250 | 2020-05-05 | Eau Claire | Wisconsin | 55035 | 42 | 0 |
115291 | 115291 | 2020-05-04 | Eau Claire | Wisconsin | 55035 | 41 | 0 |
112408 | 112408 | 2020-05-03 | Eau Claire | Wisconsin | 55035 | 36 | 0 |
109533 | 109533 | 2020-05-02 | Eau Claire | Wisconsin | 55035 | 34 | 0 |
106664 | 106664 | 2020-05-01 | Eau Claire | Wisconsin | 55035 | 28 | 0 |
103800 | 103800 | 2020-04-30 | Eau Claire | Wisconsin | 55035 | 28 | 0 |
100945 | 100945 | 2020-04-29 | Eau Claire | Wisconsin | 55035 | 27 | 0 |
98095 | 98095 | 2020-04-28 | Eau Claire | Wisconsin | 55035 | 27 | 0 |
95250 | 95250 | 2020-04-27 | Eau Claire | Wisconsin | 55035 | 25 | 0 |
92420 | 92420 | 2020-04-26 | Eau Claire | Wisconsin | 55035 | 25 | 0 |
89602 | 89602 | 2020-04-25 | Eau Claire | Wisconsin | 55035 | 24 | 0 |
86786 | 86786 | 2020-04-24 | Eau Claire | Wisconsin | 55035 | 23 | 0 |
83979 | 83979 | 2020-04-23 | Eau Claire | Wisconsin | 55035 | 23 | 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);