ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 55079 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389101 | 389101 | 2020-07-31 | Milwaukee | Wisconsin | 55079 | 19248 | 438 |
385884 | 385884 | 2020-07-30 | Milwaukee | Wisconsin | 55079 | 19069 | 433 |
382666 | 382666 | 2020-07-29 | Milwaukee | Wisconsin | 55079 | 18827 | 429 |
379449 | 379449 | 2020-07-28 | Milwaukee | Wisconsin | 55079 | 18528 | 428 |
376233 | 376233 | 2020-07-27 | Milwaukee | Wisconsin | 55079 | 18302 | 427 |
373019 | 373019 | 2020-07-26 | Milwaukee | Wisconsin | 55079 | 18140 | 427 |
369807 | 369807 | 2020-07-25 | Milwaukee | Wisconsin | 55079 | 17861 | 427 |
366597 | 366597 | 2020-07-24 | Milwaukee | Wisconsin | 55079 | 17655 | 422 |
363390 | 363390 | 2020-07-23 | Milwaukee | Wisconsin | 55079 | 17197 | 422 |
360184 | 360184 | 2020-07-22 | Milwaukee | Wisconsin | 55079 | 16911 | 417 |
356979 | 356979 | 2020-07-21 | Milwaukee | Wisconsin | 55079 | 16570 | 416 |
353776 | 353776 | 2020-07-20 | Milwaukee | Wisconsin | 55079 | 16275 | 411 |
350574 | 350574 | 2020-07-19 | Milwaukee | Wisconsin | 55079 | 15985 | 411 |
347373 | 347373 | 2020-07-18 | Milwaukee | Wisconsin | 55079 | 15632 | 411 |
344173 | 344173 | 2020-07-17 | Milwaukee | Wisconsin | 55079 | 15426 | 404 |
340974 | 340974 | 2020-07-16 | Milwaukee | Wisconsin | 55079 | 15179 | 403 |
337778 | 337778 | 2020-07-15 | Milwaukee | Wisconsin | 55079 | 14807 | 403 |
334583 | 334583 | 2020-07-14 | Milwaukee | Wisconsin | 55079 | 14478 | 402 |
331390 | 331390 | 2020-07-13 | Milwaukee | Wisconsin | 55079 | 14196 | 398 |
328204 | 328204 | 2020-07-12 | Milwaukee | Wisconsin | 55079 | 13928 | 398 |
325018 | 325018 | 2020-07-11 | Milwaukee | Wisconsin | 55079 | 13661 | 398 |
321837 | 321837 | 2020-07-10 | Milwaukee | Wisconsin | 55079 | 13430 | 398 |
318658 | 318658 | 2020-07-09 | Milwaukee | Wisconsin | 55079 | 13096 | 397 |
315485 | 315485 | 2020-07-08 | Milwaukee | Wisconsin | 55079 | 12834 | 397 |
312310 | 312310 | 2020-07-07 | Milwaukee | Wisconsin | 55079 | 12577 | 398 |
309141 | 309141 | 2020-07-06 | Milwaukee | Wisconsin | 55079 | 12436 | 391 |
305972 | 305972 | 2020-07-05 | Milwaukee | Wisconsin | 55079 | 12233 | 391 |
302808 | 302808 | 2020-07-04 | Milwaukee | Wisconsin | 55079 | 12083 | 391 |
299644 | 299644 | 2020-07-03 | Milwaukee | Wisconsin | 55079 | 11899 | 391 |
296482 | 296482 | 2020-07-02 | Milwaukee | Wisconsin | 55079 | 11672 | 391 |
293327 | 293327 | 2020-07-01 | Milwaukee | Wisconsin | 55079 | 11553 | 390 |
290174 | 290174 | 2020-06-30 | Milwaukee | Wisconsin | 55079 | 11397 | 390 |
287024 | 287024 | 2020-06-29 | Milwaukee | Wisconsin | 55079 | 11232 | 389 |
283878 | 283878 | 2020-06-28 | Milwaukee | Wisconsin | 55079 | 11110 | 389 |
280732 | 280732 | 2020-06-27 | Milwaukee | Wisconsin | 55079 | 10983 | 389 |
277584 | 277584 | 2020-06-26 | Milwaukee | Wisconsin | 55079 | 10818 | 382 |
274436 | 274436 | 2020-06-25 | Milwaukee | Wisconsin | 55079 | 10736 | 381 |
271296 | 271296 | 2020-06-24 | Milwaukee | Wisconsin | 55079 | 10582 | 377 |
268162 | 268162 | 2020-06-23 | Milwaukee | Wisconsin | 55079 | 10438 | 373 |
265033 | 265033 | 2020-06-22 | Milwaukee | Wisconsin | 55079 | 10358 | 371 |
261904 | 261904 | 2020-06-21 | Milwaukee | Wisconsin | 55079 | 10267 | 371 |
258777 | 258777 | 2020-06-20 | Milwaukee | Wisconsin | 55079 | 10167 | 371 |
255650 | 255650 | 2020-06-19 | Milwaukee | Wisconsin | 55079 | 10087 | 362 |
252531 | 252531 | 2020-06-18 | Milwaukee | Wisconsin | 55079 | 9995 | 360 |
249416 | 249416 | 2020-06-17 | Milwaukee | Wisconsin | 55079 | 9818 | 356 |
246304 | 246304 | 2020-06-16 | Milwaukee | Wisconsin | 55079 | 9678 | 352 |
243191 | 243191 | 2020-06-15 | Milwaukee | Wisconsin | 55079 | 9610 | 350 |
240080 | 240080 | 2020-06-14 | Milwaukee | Wisconsin | 55079 | 9511 | 350 |
236972 | 236972 | 2020-06-13 | Milwaukee | Wisconsin | 55079 | 9438 | 350 |
233865 | 233865 | 2020-06-12 | Milwaukee | Wisconsin | 55079 | 9310 | 349 |
230760 | 230760 | 2020-06-11 | Milwaukee | Wisconsin | 55079 | 9220 | 346 |
227656 | 227656 | 2020-06-10 | Milwaukee | Wisconsin | 55079 | 9161 | 336 |
224556 | 224556 | 2020-06-09 | Milwaukee | Wisconsin | 55079 | 9001 | 331 |
221460 | 221460 | 2020-06-08 | Milwaukee | Wisconsin | 55079 | 8925 | 325 |
218368 | 218368 | 2020-06-07 | Milwaukee | Wisconsin | 55079 | 8827 | 326 |
215278 | 215278 | 2020-06-06 | Milwaukee | Wisconsin | 55079 | 8709 | 325 |
212191 | 212191 | 2020-06-05 | Milwaukee | Wisconsin | 55079 | 8608 | 317 |
209106 | 209106 | 2020-06-04 | Milwaukee | Wisconsin | 55079 | 8463 | 316 |
206024 | 206024 | 2020-06-03 | Milwaukee | Wisconsin | 55079 | 8206 | 315 |
202945 | 202945 | 2020-06-02 | Milwaukee | Wisconsin | 55079 | 8016 | 309 |
199869 | 199869 | 2020-06-01 | Milwaukee | Wisconsin | 55079 | 7800 | 299 |
196796 | 196796 | 2020-05-31 | Milwaukee | Wisconsin | 55079 | 7750 | 299 |
193726 | 193726 | 2020-05-30 | Milwaukee | Wisconsin | 55079 | 7672 | 299 |
190660 | 190660 | 2020-05-29 | Milwaukee | Wisconsin | 55079 | 7498 | 294 |
187596 | 187596 | 2020-05-28 | Milwaukee | Wisconsin | 55079 | 7182 | 285 |
184539 | 184539 | 2020-05-27 | Milwaukee | Wisconsin | 55079 | 6848 | 282 |
181488 | 181488 | 2020-05-26 | Milwaukee | Wisconsin | 55079 | 6577 | 277 |
178444 | 178444 | 2020-05-25 | Milwaukee | Wisconsin | 55079 | 6403 | 276 |
175399 | 175399 | 2020-05-24 | Milwaukee | Wisconsin | 55079 | 6265 | 276 |
172356 | 172356 | 2020-05-23 | Milwaukee | Wisconsin | 55079 | 6092 | 276 |
169315 | 169315 | 2020-05-22 | Milwaukee | Wisconsin | 55079 | 5893 | 270 |
166279 | 166279 | 2020-05-21 | Milwaukee | Wisconsin | 55079 | 5631 | 269 |
163249 | 163249 | 2020-05-20 | Milwaukee | Wisconsin | 55079 | 5531 | 265 |
160221 | 160221 | 2020-05-19 | Milwaukee | Wisconsin | 55079 | 5185 | 260 |
157197 | 157197 | 2020-05-18 | Milwaukee | Wisconsin | 55079 | 5040 | 256 |
154181 | 154181 | 2020-05-17 | Milwaukee | Wisconsin | 55079 | 4973 | 252 |
151169 | 151169 | 2020-05-16 | Milwaukee | Wisconsin | 55079 | 4936 | 252 |
148160 | 148160 | 2020-05-15 | Milwaukee | Wisconsin | 55079 | 4694 | 249 |
145157 | 145157 | 2020-05-14 | Milwaukee | Wisconsin | 55079 | 4387 | 242 |
142159 | 142159 | 2020-05-13 | Milwaukee | Wisconsin | 55079 | 4215 | 236 |
139163 | 139163 | 2020-05-12 | Milwaukee | Wisconsin | 55079 | 4069 | 235 |
136172 | 136172 | 2020-05-11 | Milwaukee | Wisconsin | 55079 | 4022 | 231 |
133182 | 133182 | 2020-05-10 | Milwaukee | Wisconsin | 55079 | 3952 | 225 |
130192 | 130192 | 2020-05-09 | Milwaukee | Wisconsin | 55079 | 3854 | 224 |
127202 | 127202 | 2020-05-08 | Milwaukee | Wisconsin | 55079 | 3722 | 219 |
124217 | 124217 | 2020-05-07 | Milwaukee | Wisconsin | 55079 | 3573 | 212 |
121237 | 121237 | 2020-05-06 | Milwaukee | Wisconsin | 55079 | 3469 | 204 |
118271 | 118271 | 2020-05-05 | Milwaukee | Wisconsin | 55079 | 3353 | 201 |
115312 | 115312 | 2020-05-04 | Milwaukee | Wisconsin | 55079 | 3296 | 195 |
112429 | 112429 | 2020-05-03 | Milwaukee | Wisconsin | 55079 | 3244 | 195 |
109554 | 109554 | 2020-05-02 | Milwaukee | Wisconsin | 55079 | 3147 | 191 |
106685 | 106685 | 2020-05-01 | Milwaukee | Wisconsin | 55079 | 3044 | 186 |
103820 | 103820 | 2020-04-30 | Milwaukee | Wisconsin | 55079 | 2940 | 181 |
100965 | 100965 | 2020-04-29 | Milwaukee | Wisconsin | 55079 | 2815 | 177 |
98115 | 98115 | 2020-04-28 | Milwaukee | Wisconsin | 55079 | 2722 | 174 |
95270 | 95270 | 2020-04-27 | Milwaukee | Wisconsin | 55079 | 2674 | 167 |
92440 | 92440 | 2020-04-26 | Milwaukee | Wisconsin | 55079 | 2629 | 162 |
89622 | 89622 | 2020-04-25 | Milwaukee | Wisconsin | 55079 | 2525 | 157 |
86806 | 86806 | 2020-04-24 | Milwaukee | Wisconsin | 55079 | 2431 | 154 |
83999 | 83999 | 2020-04-23 | Milwaukee | Wisconsin | 55079 | 2382 | 150 |
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);