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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
502042 | 502042 | 2020-09-04 | Unknown | Wisconsin | 0 | 8 | |
505276 | 505276 | 2020-09-05 | Unknown | Wisconsin | 0 | 8 | |
508508 | 508508 | 2020-09-06 | Unknown | Wisconsin | 0 | 8 | |
511741 | 511741 | 2020-09-07 | Unknown | Wisconsin | 0 | 8 | |
514974 | 514974 | 2020-09-08 | Unknown | Wisconsin | 0 | 8 | |
518209 | 518209 | 2020-09-09 | Unknown | Wisconsin | 0 | 8 | |
521446 | 521446 | 2020-09-10 | Unknown | Wisconsin | 0 | 8 | |
524682 | 524682 | 2020-09-11 | Unknown | Wisconsin | 0 | 8 | |
527918 | 527918 | 2020-09-12 | Unknown | Wisconsin | 0 | 8 | |
531155 | 531155 | 2020-09-13 | Unknown | Wisconsin | 0 | 8 | |
534390 | 534390 | 2020-09-14 | Unknown | Wisconsin | 0 | 8 | |
537626 | 537626 | 2020-09-15 | Unknown | Wisconsin | 0 | 9 | |
540863 | 540863 | 2020-09-16 | Unknown | Wisconsin | 0 | 9 | |
544099 | 544099 | 2020-09-17 | Unknown | Wisconsin | 0 | 8 | |
547336 | 547336 | 2020-09-18 | Unknown | Wisconsin | 0 | 8 | |
550575 | 550575 | 2020-09-19 | Unknown | Wisconsin | 0 | 8 | |
553814 | 553814 | 2020-09-20 | Unknown | Wisconsin | 0 | 8 | |
557051 | 557051 | 2020-09-21 | Unknown | Wisconsin | 0 | 8 | |
560287 | 560287 | 2020-09-22 | Unknown | Wisconsin | 0 | 8 | |
563526 | 563526 | 2020-09-23 | Unknown | Wisconsin | 0 | 9 | |
566767 | 566767 | 2020-09-24 | Unknown | Wisconsin | 0 | 10 | |
570008 | 570008 | 2020-09-25 | Unknown | Wisconsin | 0 | 10 | |
573250 | 573250 | 2020-09-26 | Unknown | Wisconsin | 0 | 10 | |
576494 | 576494 | 2020-09-27 | Unknown | Wisconsin | 0 | 10 | |
579735 | 579735 | 2020-09-28 | Unknown | Wisconsin | 0 | 10 | |
582974 | 582974 | 2020-09-29 | Unknown | Wisconsin | 0 | 10 | |
586214 | 586214 | 2020-09-30 | Unknown | Wisconsin | 0 | 10 | |
589455 | 589455 | 2020-10-01 | Unknown | Wisconsin | 0 | 10 | |
592695 | 592695 | 2020-10-02 | Unknown | Wisconsin | 0 | 10 | |
595937 | 595937 | 2020-10-03 | Unknown | Wisconsin | 0 | 11 | |
599180 | 599180 | 2020-10-04 | Unknown | Wisconsin | 0 | 11 | |
602423 | 602423 | 2020-10-05 | Unknown | Wisconsin | 0 | 11 | |
605665 | 605665 | 2020-10-06 | Unknown | Wisconsin | 0 | 11 | |
608908 | 608908 | 2020-10-07 | Unknown | Wisconsin | 0 | 11 | |
612150 | 612150 | 2020-10-08 | Unknown | Wisconsin | 0 | 11 | |
615391 | 615391 | 2020-10-09 | Unknown | Wisconsin | 0 | 11 | |
618633 | 618633 | 2020-10-10 | Unknown | Wisconsin | 0 | 10 | |
621876 | 621876 | 2020-10-11 | Unknown | Wisconsin | 0 | 10 | |
625119 | 625119 | 2020-10-12 | Unknown | Wisconsin | 0 | 10 | |
628362 | 628362 | 2020-10-13 | Unknown | Wisconsin | 0 | 10 | |
631606 | 631606 | 2020-10-14 | Unknown | Wisconsin | 0 | 11 | |
634851 | 634851 | 2020-10-15 | Unknown | Wisconsin | 0 | 12 | |
638096 | 638096 | 2020-10-16 | Unknown | Wisconsin | 0 | 14 | |
641343 | 641343 | 2020-10-17 | Unknown | Wisconsin | 0 | 14 | |
644591 | 644591 | 2020-10-18 | Unknown | Wisconsin | 0 | 14 | |
686761 | 686761 | 2020-10-31 | Unknown | Wisconsin | 1 | 0 | |
690006 | 690006 | 2020-11-01 | Unknown | Wisconsin | 1 | 0 | |
1699621 | 1699621 | 2021-09-08 | Unknown | Wisconsin | 1 | 0 | |
1702871 | 1702871 | 2021-09-09 | Unknown | Wisconsin | 1 | 0 | |
227678 | 227678 | 2020-06-10 | Unknown | Wisconsin | 2005 | 6 | |
230782 | 230782 | 2020-06-11 | Unknown | Wisconsin | 2048 | 6 | |
233887 | 233887 | 2020-06-12 | Unknown | Wisconsin | 2072 | 6 | |
236994 | 236994 | 2020-06-13 | Unknown | Wisconsin | 2072 | 6 | |
240102 | 240102 | 2020-06-14 | Unknown | Wisconsin | 2133 | 6 | |
243213 | 243213 | 2020-06-15 | Unknown | Wisconsin | 2138 | 6 | |
246326 | 246326 | 2020-06-16 | Unknown | Wisconsin | 2176 | 6 | |
249438 | 249438 | 2020-06-17 | Unknown | Wisconsin | 2207 | 6 | |
252553 | 252553 | 2020-06-18 | Unknown | Wisconsin | 2240 | 6 | |
255672 | 255672 | 2020-06-19 | Unknown | Wisconsin | 2272 | 6 | |
258799 | 258799 | 2020-06-20 | Unknown | Wisconsin | 2329 | 7 | |
265055 | 265055 | 2020-06-22 | Unknown | Wisconsin | 2341 | 6 | |
261926 | 261926 | 2020-06-21 | Unknown | Wisconsin | 2350 | 7 | |
268184 | 268184 | 2020-06-23 | Unknown | Wisconsin | 2364 | 7 | |
271318 | 271318 | 2020-06-24 | Unknown | Wisconsin | 2403 | 7 | |
274458 | 274458 | 2020-06-25 | Unknown | Wisconsin | 2446 | 7 | |
277606 | 277606 | 2020-06-26 | Unknown | Wisconsin | 2489 | 7 | |
280754 | 280754 | 2020-06-27 | Unknown | Wisconsin | 2521 | 7 | |
283900 | 283900 | 2020-06-28 | Unknown | Wisconsin | 2532 | 7 | |
287046 | 287046 | 2020-06-29 | Unknown | Wisconsin | 2538 | 7 | |
290196 | 290196 | 2020-06-30 | Unknown | Wisconsin | 2538 | 7 | |
293349 | 293349 | 2020-07-01 | Unknown | Wisconsin | 2588 | 7 | |
296504 | 296504 | 2020-07-02 | Unknown | Wisconsin | 2633 | 7 | |
299666 | 299666 | 2020-07-03 | Unknown | Wisconsin | 2676 | 7 | |
302830 | 302830 | 2020-07-04 | Unknown | Wisconsin | 2713 | 7 | |
309163 | 309163 | 2020-07-06 | Unknown | Wisconsin | 2722 | 7 | |
305994 | 305994 | 2020-07-05 | Unknown | Wisconsin | 2724 | 7 | |
312332 | 312332 | 2020-07-07 | Unknown | Wisconsin | 2762 | 7 | |
315507 | 315507 | 2020-07-08 | Unknown | Wisconsin | 2762 | 7 | |
318680 | 318680 | 2020-07-09 | Unknown | Wisconsin | 2855 | 7 | |
325040 | 325040 | 2020-07-11 | Unknown | Wisconsin | 2948 | 7 | |
331412 | 331412 | 2020-07-13 | Unknown | Wisconsin | 2970 | 7 | |
334605 | 334605 | 2020-07-14 | Unknown | Wisconsin | 2972 | 7 | |
328226 | 328226 | 2020-07-12 | Unknown | Wisconsin | 2976 | 7 | |
337800 | 337800 | 2020-07-15 | Unknown | Wisconsin | 2996 | 7 | |
321859 | 321859 | 2020-07-10 | Unknown | Wisconsin | 2999 | 7 | |
340996 | 340996 | 2020-07-16 | Unknown | Wisconsin | 3041 | 7 | |
344195 | 344195 | 2020-07-17 | Unknown | Wisconsin | 3082 | 7 | |
347395 | 347395 | 2020-07-18 | Unknown | Wisconsin | 3135 | 7 | |
350596 | 350596 | 2020-07-19 | Unknown | Wisconsin | 3154 | 7 | |
353798 | 353798 | 2020-07-20 | Unknown | Wisconsin | 3163 | 7 | |
357001 | 357001 | 2020-07-21 | Unknown | Wisconsin | 3207 | 7 | |
360206 | 360206 | 2020-07-22 | Unknown | Wisconsin | 3240 | 7 | |
363412 | 363412 | 2020-07-23 | Unknown | Wisconsin | 3276 | 7 | |
366619 | 366619 | 2020-07-24 | Unknown | Wisconsin | 3314 | 7 | |
369829 | 369829 | 2020-07-25 | Unknown | Wisconsin | 3344 | 7 | |
376255 | 376255 | 2020-07-27 | Unknown | Wisconsin | 3345 | 7 | |
373041 | 373041 | 2020-07-26 | Unknown | Wisconsin | 3352 | 7 | |
379471 | 379471 | 2020-07-28 | Unknown | Wisconsin | 3367 | 7 | |
382688 | 382688 | 2020-07-29 | Unknown | Wisconsin | 3418 | 7 | |
385906 | 385906 | 2020-07-30 | Unknown | Wisconsin | 3453 | 7 |
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);