ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where county = "Unknown" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
334605 | 334605 | 2020-07-14 | Unknown | Wisconsin | 2972 | 7 | |
331412 | 331412 | 2020-07-13 | Unknown | Wisconsin | 2970 | 7 | |
328226 | 328226 | 2020-07-12 | Unknown | Wisconsin | 2976 | 7 | |
325040 | 325040 | 2020-07-11 | Unknown | Wisconsin | 2948 | 7 | |
321859 | 321859 | 2020-07-10 | Unknown | Wisconsin | 2999 | 7 | |
318680 | 318680 | 2020-07-09 | Unknown | Wisconsin | 2855 | 7 | |
315507 | 315507 | 2020-07-08 | Unknown | Wisconsin | 2762 | 7 | |
312332 | 312332 | 2020-07-07 | Unknown | Wisconsin | 2762 | 7 | |
309163 | 309163 | 2020-07-06 | Unknown | Wisconsin | 2722 | 7 | |
305994 | 305994 | 2020-07-05 | Unknown | Wisconsin | 2724 | 7 | |
302830 | 302830 | 2020-07-04 | Unknown | Wisconsin | 2713 | 7 | |
299666 | 299666 | 2020-07-03 | Unknown | Wisconsin | 2676 | 7 | |
296504 | 296504 | 2020-07-02 | Unknown | Wisconsin | 2633 | 7 | |
293349 | 293349 | 2020-07-01 | Unknown | Wisconsin | 2588 | 7 | |
290196 | 290196 | 2020-06-30 | Unknown | Wisconsin | 2538 | 7 | |
287046 | 287046 | 2020-06-29 | Unknown | Wisconsin | 2538 | 7 | |
283900 | 283900 | 2020-06-28 | Unknown | Wisconsin | 2532 | 7 | |
280754 | 280754 | 2020-06-27 | Unknown | Wisconsin | 2521 | 7 | |
277606 | 277606 | 2020-06-26 | Unknown | Wisconsin | 2489 | 7 | |
274458 | 274458 | 2020-06-25 | Unknown | Wisconsin | 2446 | 7 | |
271318 | 271318 | 2020-06-24 | Unknown | Wisconsin | 2403 | 7 | |
268184 | 268184 | 2020-06-23 | Unknown | Wisconsin | 2364 | 7 | |
265055 | 265055 | 2020-06-22 | Unknown | Wisconsin | 2341 | 6 | |
261926 | 261926 | 2020-06-21 | Unknown | Wisconsin | 2350 | 7 | |
258799 | 258799 | 2020-06-20 | Unknown | Wisconsin | 2329 | 7 | |
255672 | 255672 | 2020-06-19 | Unknown | Wisconsin | 2272 | 6 | |
252553 | 252553 | 2020-06-18 | Unknown | Wisconsin | 2240 | 6 | |
249438 | 249438 | 2020-06-17 | Unknown | Wisconsin | 2207 | 6 | |
246326 | 246326 | 2020-06-16 | Unknown | Wisconsin | 2176 | 6 | |
243213 | 243213 | 2020-06-15 | Unknown | Wisconsin | 2138 | 6 | |
240102 | 240102 | 2020-06-14 | Unknown | Wisconsin | 2133 | 6 | |
236994 | 236994 | 2020-06-13 | Unknown | Wisconsin | 2072 | 6 | |
233887 | 233887 | 2020-06-12 | Unknown | Wisconsin | 2072 | 6 | |
230782 | 230782 | 2020-06-11 | Unknown | Wisconsin | 2048 | 6 | |
227678 | 227678 | 2020-06-10 | Unknown | Wisconsin | 2005 | 6 |
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);