ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 55087 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
334587 | 334587 | 2020-07-14 | Outagamie | Wisconsin | 55087 | 695 | 9 |
331394 | 331394 | 2020-07-13 | Outagamie | Wisconsin | 55087 | 665 | 9 |
328208 | 328208 | 2020-07-12 | Outagamie | Wisconsin | 55087 | 654 | 9 |
325022 | 325022 | 2020-07-11 | Outagamie | Wisconsin | 55087 | 633 | 9 |
321841 | 321841 | 2020-07-10 | Outagamie | Wisconsin | 55087 | 615 | 9 |
318662 | 318662 | 2020-07-09 | Outagamie | Wisconsin | 55087 | 597 | 9 |
315489 | 315489 | 2020-07-08 | Outagamie | Wisconsin | 55087 | 581 | 9 |
312314 | 312314 | 2020-07-07 | Outagamie | Wisconsin | 55087 | 577 | 9 |
309145 | 309145 | 2020-07-06 | Outagamie | Wisconsin | 55087 | 552 | 9 |
305976 | 305976 | 2020-07-05 | Outagamie | Wisconsin | 55087 | 540 | 9 |
302812 | 302812 | 2020-07-04 | Outagamie | Wisconsin | 55087 | 524 | 9 |
299648 | 299648 | 2020-07-03 | Outagamie | Wisconsin | 55087 | 508 | 9 |
296486 | 296486 | 2020-07-02 | Outagamie | Wisconsin | 55087 | 500 | 9 |
293331 | 293331 | 2020-07-01 | Outagamie | Wisconsin | 55087 | 491 | 9 |
290178 | 290178 | 2020-06-30 | Outagamie | Wisconsin | 55087 | 476 | 9 |
287028 | 287028 | 2020-06-29 | Outagamie | Wisconsin | 55087 | 463 | 8 |
283882 | 283882 | 2020-06-28 | Outagamie | Wisconsin | 55087 | 454 | 8 |
280736 | 280736 | 2020-06-27 | Outagamie | Wisconsin | 55087 | 447 | 8 |
277588 | 277588 | 2020-06-26 | Outagamie | Wisconsin | 55087 | 436 | 8 |
274440 | 274440 | 2020-06-25 | Outagamie | Wisconsin | 55087 | 428 | 8 |
271300 | 271300 | 2020-06-24 | Outagamie | Wisconsin | 55087 | 415 | 8 |
268166 | 268166 | 2020-06-23 | Outagamie | Wisconsin | 55087 | 412 | 8 |
265037 | 265037 | 2020-06-22 | Outagamie | Wisconsin | 55087 | 402 | 8 |
261908 | 261908 | 2020-06-21 | Outagamie | Wisconsin | 55087 | 396 | 8 |
258781 | 258781 | 2020-06-20 | Outagamie | Wisconsin | 55087 | 387 | 8 |
255654 | 255654 | 2020-06-19 | Outagamie | Wisconsin | 55087 | 377 | 8 |
252535 | 252535 | 2020-06-18 | Outagamie | Wisconsin | 55087 | 366 | 8 |
249420 | 249420 | 2020-06-17 | Outagamie | Wisconsin | 55087 | 354 | 8 |
246308 | 246308 | 2020-06-16 | Outagamie | Wisconsin | 55087 | 345 | 8 |
243195 | 243195 | 2020-06-15 | Outagamie | Wisconsin | 55087 | 343 | 8 |
240084 | 240084 | 2020-06-14 | Outagamie | Wisconsin | 55087 | 337 | 8 |
236976 | 236976 | 2020-06-13 | Outagamie | Wisconsin | 55087 | 331 | 8 |
233869 | 233869 | 2020-06-12 | Outagamie | Wisconsin | 55087 | 318 | 8 |
230764 | 230764 | 2020-06-11 | Outagamie | Wisconsin | 55087 | 306 | 8 |
227660 | 227660 | 2020-06-10 | Outagamie | Wisconsin | 55087 | 294 | 8 |
224560 | 224560 | 2020-06-09 | Outagamie | Wisconsin | 55087 | 289 | 8 |
221464 | 221464 | 2020-06-08 | Outagamie | Wisconsin | 55087 | 277 | 8 |
218372 | 218372 | 2020-06-07 | Outagamie | Wisconsin | 55087 | 270 | 8 |
215282 | 215282 | 2020-06-06 | Outagamie | Wisconsin | 55087 | 263 | 8 |
212195 | 212195 | 2020-06-05 | Outagamie | Wisconsin | 55087 | 253 | 8 |
209110 | 209110 | 2020-06-04 | Outagamie | Wisconsin | 55087 | 246 | 8 |
206028 | 206028 | 2020-06-03 | Outagamie | Wisconsin | 55087 | 239 | 8 |
202949 | 202949 | 2020-06-02 | Outagamie | Wisconsin | 55087 | 232 | 8 |
199873 | 199873 | 2020-06-01 | Outagamie | Wisconsin | 55087 | 230 | 8 |
196800 | 196800 | 2020-05-31 | Outagamie | Wisconsin | 55087 | 227 | 8 |
193730 | 193730 | 2020-05-30 | Outagamie | Wisconsin | 55087 | 223 | 8 |
190664 | 190664 | 2020-05-29 | Outagamie | Wisconsin | 55087 | 213 | 8 |
187600 | 187600 | 2020-05-28 | Outagamie | Wisconsin | 55087 | 204 | 8 |
184543 | 184543 | 2020-05-27 | Outagamie | Wisconsin | 55087 | 198 | 8 |
181492 | 181492 | 2020-05-26 | Outagamie | Wisconsin | 55087 | 196 | 7 |
178448 | 178448 | 2020-05-25 | Outagamie | Wisconsin | 55087 | 193 | 7 |
175403 | 175403 | 2020-05-24 | Outagamie | Wisconsin | 55087 | 184 | 7 |
172360 | 172360 | 2020-05-23 | Outagamie | Wisconsin | 55087 | 181 | 6 |
169319 | 169319 | 2020-05-22 | Outagamie | Wisconsin | 55087 | 174 | 5 |
166283 | 166283 | 2020-05-21 | Outagamie | Wisconsin | 55087 | 161 | 5 |
163253 | 163253 | 2020-05-20 | Outagamie | Wisconsin | 55087 | 153 | 5 |
160225 | 160225 | 2020-05-19 | Outagamie | Wisconsin | 55087 | 146 | 5 |
157201 | 157201 | 2020-05-18 | Outagamie | Wisconsin | 55087 | 142 | 5 |
154185 | 154185 | 2020-05-17 | Outagamie | Wisconsin | 55087 | 139 | 4 |
151173 | 151173 | 2020-05-16 | Outagamie | Wisconsin | 55087 | 135 | 4 |
148164 | 148164 | 2020-05-15 | Outagamie | Wisconsin | 55087 | 128 | 4 |
145161 | 145161 | 2020-05-14 | Outagamie | Wisconsin | 55087 | 124 | 4 |
142163 | 142163 | 2020-05-13 | Outagamie | Wisconsin | 55087 | 122 | 2 |
139167 | 139167 | 2020-05-12 | Outagamie | Wisconsin | 55087 | 117 | 2 |
136176 | 136176 | 2020-05-11 | Outagamie | Wisconsin | 55087 | 117 | 2 |
133186 | 133186 | 2020-05-10 | Outagamie | Wisconsin | 55087 | 112 | 2 |
130196 | 130196 | 2020-05-09 | Outagamie | Wisconsin | 55087 | 111 | 2 |
127206 | 127206 | 2020-05-08 | Outagamie | Wisconsin | 55087 | 105 | 2 |
124221 | 124221 | 2020-05-07 | Outagamie | Wisconsin | 55087 | 93 | 2 |
121241 | 121241 | 2020-05-06 | Outagamie | Wisconsin | 55087 | 83 | 2 |
118275 | 118275 | 2020-05-05 | Outagamie | Wisconsin | 55087 | 77 | 2 |
115316 | 115316 | 2020-05-04 | Outagamie | Wisconsin | 55087 | 73 | 2 |
112433 | 112433 | 2020-05-03 | Outagamie | Wisconsin | 55087 | 68 | 2 |
109558 | 109558 | 2020-05-02 | Outagamie | Wisconsin | 55087 | 63 | 2 |
106689 | 106689 | 2020-05-01 | Outagamie | Wisconsin | 55087 | 62 | 2 |
103824 | 103824 | 2020-04-30 | Outagamie | Wisconsin | 55087 | 54 | 2 |
100969 | 100969 | 2020-04-29 | Outagamie | Wisconsin | 55087 | 54 | 2 |
98119 | 98119 | 2020-04-28 | Outagamie | Wisconsin | 55087 | 50 | 2 |
95274 | 95274 | 2020-04-27 | Outagamie | Wisconsin | 55087 | 47 | 2 |
92444 | 92444 | 2020-04-26 | Outagamie | Wisconsin | 55087 | 46 | 2 |
89626 | 89626 | 2020-04-25 | Outagamie | Wisconsin | 55087 | 43 | 2 |
86810 | 86810 | 2020-04-24 | Outagamie | Wisconsin | 55087 | 43 | 2 |
84003 | 84003 | 2020-04-23 | Outagamie | Wisconsin | 55087 | 38 | 2 |
81202 | 81202 | 2020-04-22 | Outagamie | Wisconsin | 55087 | 37 | 2 |
78409 | 78409 | 2020-04-21 | Outagamie | Wisconsin | 55087 | 35 | 2 |
75626 | 75626 | 2020-04-20 | Outagamie | Wisconsin | 55087 | 35 | 2 |
72850 | 72850 | 2020-04-19 | Outagamie | Wisconsin | 55087 | 35 | 2 |
70081 | 70081 | 2020-04-18 | Outagamie | Wisconsin | 55087 | 33 | 2 |
67319 | 67319 | 2020-04-17 | Outagamie | Wisconsin | 55087 | 31 | 2 |
64571 | 64571 | 2020-04-16 | Outagamie | Wisconsin | 55087 | 31 | 2 |
61838 | 61838 | 2020-04-15 | Outagamie | Wisconsin | 55087 | 31 | 2 |
59119 | 59119 | 2020-04-14 | Outagamie | Wisconsin | 55087 | 29 | 2 |
56412 | 56412 | 2020-04-13 | Outagamie | Wisconsin | 55087 | 29 | 2 |
53721 | 53721 | 2020-04-12 | Outagamie | Wisconsin | 55087 | 29 | 2 |
51044 | 51044 | 2020-04-11 | Outagamie | Wisconsin | 55087 | 29 | 2 |
48384 | 48384 | 2020-04-10 | Outagamie | Wisconsin | 55087 | 29 | 2 |
45756 | 45756 | 2020-04-09 | Outagamie | Wisconsin | 55087 | 26 | 2 |
43159 | 43159 | 2020-04-08 | Outagamie | Wisconsin | 55087 | 25 | 2 |
40587 | 40587 | 2020-04-07 | Outagamie | Wisconsin | 55087 | 25 | 1 |
38045 | 38045 | 2020-04-06 | Outagamie | Wisconsin | 55087 | 22 | 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);