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 |
---|---|---|---|---|---|---|---|
1702871 | 1702871 | 2021-09-09 | Unknown | Wisconsin | 1 | 0 | |
1699621 | 1699621 | 2021-09-08 | Unknown | Wisconsin | 1 | 0 | |
690006 | 690006 | 2020-11-01 | Unknown | Wisconsin | 1 | 0 | |
686761 | 686761 | 2020-10-31 | Unknown | Wisconsin | 1 | 0 | |
644591 | 644591 | 2020-10-18 | Unknown | Wisconsin | 0 | 14 | |
641343 | 641343 | 2020-10-17 | Unknown | Wisconsin | 0 | 14 | |
638096 | 638096 | 2020-10-16 | Unknown | Wisconsin | 0 | 14 | |
634851 | 634851 | 2020-10-15 | Unknown | Wisconsin | 0 | 12 | |
631606 | 631606 | 2020-10-14 | Unknown | Wisconsin | 0 | 11 | |
628362 | 628362 | 2020-10-13 | Unknown | Wisconsin | 0 | 10 | |
625119 | 625119 | 2020-10-12 | Unknown | Wisconsin | 0 | 10 | |
621876 | 621876 | 2020-10-11 | Unknown | Wisconsin | 0 | 10 | |
618633 | 618633 | 2020-10-10 | Unknown | Wisconsin | 0 | 10 | |
615391 | 615391 | 2020-10-09 | Unknown | Wisconsin | 0 | 11 | |
612150 | 612150 | 2020-10-08 | Unknown | Wisconsin | 0 | 11 | |
608908 | 608908 | 2020-10-07 | Unknown | Wisconsin | 0 | 11 | |
605665 | 605665 | 2020-10-06 | Unknown | Wisconsin | 0 | 11 | |
602423 | 602423 | 2020-10-05 | Unknown | Wisconsin | 0 | 11 | |
599180 | 599180 | 2020-10-04 | Unknown | Wisconsin | 0 | 11 | |
595937 | 595937 | 2020-10-03 | Unknown | Wisconsin | 0 | 11 | |
592695 | 592695 | 2020-10-02 | Unknown | Wisconsin | 0 | 10 | |
589455 | 589455 | 2020-10-01 | Unknown | Wisconsin | 0 | 10 | |
586214 | 586214 | 2020-09-30 | Unknown | Wisconsin | 0 | 10 | |
582974 | 582974 | 2020-09-29 | Unknown | Wisconsin | 0 | 10 | |
579735 | 579735 | 2020-09-28 | Unknown | Wisconsin | 0 | 10 | |
576494 | 576494 | 2020-09-27 | Unknown | Wisconsin | 0 | 10 | |
573250 | 573250 | 2020-09-26 | Unknown | Wisconsin | 0 | 10 | |
570008 | 570008 | 2020-09-25 | Unknown | Wisconsin | 0 | 10 | |
566767 | 566767 | 2020-09-24 | Unknown | Wisconsin | 0 | 10 | |
563526 | 563526 | 2020-09-23 | Unknown | Wisconsin | 0 | 9 | |
560287 | 560287 | 2020-09-22 | Unknown | Wisconsin | 0 | 8 | |
557051 | 557051 | 2020-09-21 | Unknown | Wisconsin | 0 | 8 | |
553814 | 553814 | 2020-09-20 | Unknown | Wisconsin | 0 | 8 | |
550575 | 550575 | 2020-09-19 | Unknown | Wisconsin | 0 | 8 | |
547336 | 547336 | 2020-09-18 | Unknown | Wisconsin | 0 | 8 | |
544099 | 544099 | 2020-09-17 | Unknown | Wisconsin | 0 | 8 | |
540863 | 540863 | 2020-09-16 | Unknown | Wisconsin | 0 | 9 | |
537626 | 537626 | 2020-09-15 | Unknown | Wisconsin | 0 | 9 | |
534390 | 534390 | 2020-09-14 | Unknown | Wisconsin | 0 | 8 | |
531155 | 531155 | 2020-09-13 | Unknown | Wisconsin | 0 | 8 | |
527918 | 527918 | 2020-09-12 | Unknown | Wisconsin | 0 | 8 | |
524682 | 524682 | 2020-09-11 | Unknown | Wisconsin | 0 | 8 | |
521446 | 521446 | 2020-09-10 | Unknown | Wisconsin | 0 | 8 | |
518209 | 518209 | 2020-09-09 | Unknown | Wisconsin | 0 | 8 | |
514974 | 514974 | 2020-09-08 | Unknown | Wisconsin | 0 | 8 | |
511741 | 511741 | 2020-09-07 | Unknown | Wisconsin | 0 | 8 | |
508508 | 508508 | 2020-09-06 | Unknown | Wisconsin | 0 | 8 | |
505276 | 505276 | 2020-09-05 | Unknown | Wisconsin | 0 | 8 | |
502042 | 502042 | 2020-09-04 | Unknown | Wisconsin | 0 | 8 | |
498808 | 498808 | 2020-09-03 | Unknown | Wisconsin | 4469 | 8 | |
495575 | 495575 | 2020-09-02 | Unknown | Wisconsin | 4456 | 8 | |
492341 | 492341 | 2020-09-01 | Unknown | Wisconsin | 4423 | 9 | |
489108 | 489108 | 2020-08-31 | Unknown | Wisconsin | 4368 | 8 | |
485875 | 485875 | 2020-08-30 | Unknown | Wisconsin | 4381 | 8 | |
482640 | 482640 | 2020-08-29 | Unknown | Wisconsin | 4348 | 8 | |
479406 | 479406 | 2020-08-28 | Unknown | Wisconsin | 4305 | 8 | |
476173 | 476173 | 2020-08-27 | Unknown | Wisconsin | 4284 | 8 | |
472940 | 472940 | 2020-08-26 | Unknown | Wisconsin | 4250 | 8 | |
469708 | 469708 | 2020-08-25 | Unknown | Wisconsin | 4232 | 8 | |
466479 | 466479 | 2020-08-24 | Unknown | Wisconsin | 4183 | 8 | |
463250 | 463250 | 2020-08-23 | Unknown | Wisconsin | 4182 | 8 | |
460021 | 460021 | 2020-08-22 | Unknown | Wisconsin | 4164 | 8 | |
456794 | 456794 | 2020-08-21 | Unknown | Wisconsin | 4139 | 7 | |
453566 | 453566 | 2020-08-20 | Unknown | Wisconsin | 4117 | 7 | |
450338 | 450338 | 2020-08-19 | Unknown | Wisconsin | 4088 | 7 | |
447110 | 447110 | 2020-08-18 | Unknown | Wisconsin | 4041 | 7 | |
443883 | 443883 | 2020-08-17 | Unknown | Wisconsin | 3966 | 7 | |
440657 | 440657 | 2020-08-16 | Unknown | Wisconsin | 3956 | 7 | |
437431 | 437431 | 2020-08-15 | Unknown | Wisconsin | 3942 | 7 | |
434205 | 434205 | 2020-08-14 | Unknown | Wisconsin | 3905 | 7 | |
430980 | 430980 | 2020-08-13 | Unknown | Wisconsin | 3867 | 7 | |
427752 | 427752 | 2020-08-12 | Unknown | Wisconsin | 3842 | 7 | |
424528 | 424528 | 2020-08-11 | Unknown | Wisconsin | 3789 | 7 | |
421307 | 421307 | 2020-08-10 | Unknown | Wisconsin | 3746 | 7 | |
418086 | 418086 | 2020-08-09 | Unknown | Wisconsin | 3741 | 7 | |
414865 | 414865 | 2020-08-08 | Unknown | Wisconsin | 3740 | 7 | |
411645 | 411645 | 2020-08-07 | Unknown | Wisconsin | 3720 | 7 | |
408426 | 408426 | 2020-08-06 | Unknown | Wisconsin | 3666 | 7 | |
405206 | 405206 | 2020-08-05 | Unknown | Wisconsin | 3630 | 7 | |
401988 | 401988 | 2020-08-04 | Unknown | Wisconsin | 3576 | 7 | |
398772 | 398772 | 2020-08-03 | Unknown | Wisconsin | 3533 | 7 | |
395556 | 395556 | 2020-08-02 | Unknown | Wisconsin | 3543 | 7 | |
392340 | 392340 | 2020-08-01 | Unknown | Wisconsin | 3533 | 7 | |
389123 | 389123 | 2020-07-31 | Unknown | Wisconsin | 3471 | 7 | |
385906 | 385906 | 2020-07-30 | Unknown | Wisconsin | 3453 | 7 | |
382688 | 382688 | 2020-07-29 | Unknown | Wisconsin | 3418 | 7 | |
379471 | 379471 | 2020-07-28 | Unknown | Wisconsin | 3367 | 7 | |
376255 | 376255 | 2020-07-27 | Unknown | Wisconsin | 3345 | 7 | |
373041 | 373041 | 2020-07-26 | Unknown | Wisconsin | 3352 | 7 | |
369829 | 369829 | 2020-07-25 | Unknown | Wisconsin | 3344 | 7 | |
366619 | 366619 | 2020-07-24 | Unknown | Wisconsin | 3314 | 7 | |
363412 | 363412 | 2020-07-23 | Unknown | Wisconsin | 3276 | 7 | |
360206 | 360206 | 2020-07-22 | Unknown | Wisconsin | 3240 | 7 | |
357001 | 357001 | 2020-07-21 | Unknown | Wisconsin | 3207 | 7 | |
353798 | 353798 | 2020-07-20 | Unknown | Wisconsin | 3163 | 7 | |
350596 | 350596 | 2020-07-19 | Unknown | Wisconsin | 3154 | 7 | |
347395 | 347395 | 2020-07-18 | Unknown | Wisconsin | 3135 | 7 | |
344195 | 344195 | 2020-07-17 | Unknown | Wisconsin | 3082 | 7 | |
340996 | 340996 | 2020-07-16 | Unknown | Wisconsin | 3041 | 7 | |
337800 | 337800 | 2020-07-15 | Unknown | Wisconsin | 2996 | 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);