ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55007 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923591 | 923591 | 2021-01-12 | Bayfield | Wisconsin | 55007 | 1012 | 18 |
920346 | 920346 | 2021-01-11 | Bayfield | Wisconsin | 55007 | 1006 | 18 |
917101 | 917101 | 2021-01-10 | Bayfield | Wisconsin | 55007 | 999 | 18 |
913856 | 913856 | 2021-01-09 | Bayfield | Wisconsin | 55007 | 992 | 18 |
910611 | 910611 | 2021-01-08 | Bayfield | Wisconsin | 55007 | 988 | 18 |
907366 | 907366 | 2021-01-07 | Bayfield | Wisconsin | 55007 | 983 | 18 |
904120 | 904120 | 2021-01-06 | Bayfield | Wisconsin | 55007 | 981 | 18 |
900875 | 900875 | 2021-01-05 | Bayfield | Wisconsin | 55007 | 973 | 18 |
897630 | 897630 | 2021-01-04 | Bayfield | Wisconsin | 55007 | 970 | 18 |
894384 | 894384 | 2021-01-03 | Bayfield | Wisconsin | 55007 | 968 | 18 |
891138 | 891138 | 2021-01-02 | Bayfield | Wisconsin | 55007 | 964 | 18 |
887891 | 887891 | 2021-01-01 | Bayfield | Wisconsin | 55007 | 964 | 18 |
884646 | 884646 | 2020-12-31 | Bayfield | Wisconsin | 55007 | 964 | 18 |
881401 | 881401 | 2020-12-30 | Bayfield | Wisconsin | 55007 | 950 | 18 |
878156 | 878156 | 2020-12-29 | Bayfield | Wisconsin | 55007 | 946 | 18 |
874911 | 874911 | 2020-12-28 | Bayfield | Wisconsin | 55007 | 940 | 18 |
871666 | 871666 | 2020-12-27 | Bayfield | Wisconsin | 55007 | 939 | 18 |
868421 | 868421 | 2020-12-26 | Bayfield | Wisconsin | 55007 | 928 | 18 |
865176 | 865176 | 2020-12-25 | Bayfield | Wisconsin | 55007 | 928 | 18 |
861931 | 861931 | 2020-12-24 | Bayfield | Wisconsin | 55007 | 923 | 18 |
858686 | 858686 | 2020-12-23 | Bayfield | Wisconsin | 55007 | 914 | 17 |
855441 | 855441 | 2020-12-22 | Bayfield | Wisconsin | 55007 | 910 | 17 |
852196 | 852196 | 2020-12-21 | Bayfield | Wisconsin | 55007 | 905 | 16 |
848951 | 848951 | 2020-12-20 | Bayfield | Wisconsin | 55007 | 902 | 16 |
845706 | 845706 | 2020-12-19 | Bayfield | Wisconsin | 55007 | 897 | 16 |
842460 | 842460 | 2020-12-18 | Bayfield | Wisconsin | 55007 | 888 | 16 |
839215 | 839215 | 2020-12-17 | Bayfield | Wisconsin | 55007 | 882 | 16 |
835970 | 835970 | 2020-12-16 | Bayfield | Wisconsin | 55007 | 870 | 16 |
832724 | 832724 | 2020-12-15 | Bayfield | Wisconsin | 55007 | 865 | 16 |
829477 | 829477 | 2020-12-14 | Bayfield | Wisconsin | 55007 | 853 | 16 |
826231 | 826231 | 2020-12-13 | Bayfield | Wisconsin | 55007 | 841 | 16 |
822984 | 822984 | 2020-12-12 | Bayfield | Wisconsin | 55007 | 827 | 16 |
819738 | 819738 | 2020-12-11 | Bayfield | Wisconsin | 55007 | 821 | 16 |
816492 | 816492 | 2020-12-10 | Bayfield | Wisconsin | 55007 | 808 | 16 |
813246 | 813246 | 2020-12-09 | Bayfield | Wisconsin | 55007 | 792 | 16 |
810002 | 810002 | 2020-12-08 | Bayfield | Wisconsin | 55007 | 787 | 16 |
806757 | 806757 | 2020-12-07 | Bayfield | Wisconsin | 55007 | 773 | 16 |
803512 | 803512 | 2020-12-06 | Bayfield | Wisconsin | 55007 | 766 | 16 |
800267 | 800267 | 2020-12-05 | Bayfield | Wisconsin | 55007 | 753 | 16 |
797022 | 797022 | 2020-12-04 | Bayfield | Wisconsin | 55007 | 743 | 16 |
793777 | 793777 | 2020-12-03 | Bayfield | Wisconsin | 55007 | 725 | 16 |
790532 | 790532 | 2020-12-02 | Bayfield | Wisconsin | 55007 | 716 | 14 |
787287 | 787287 | 2020-12-01 | Bayfield | Wisconsin | 55007 | 703 | 14 |
784043 | 784043 | 2020-11-30 | Bayfield | Wisconsin | 55007 | 697 | 13 |
780798 | 780798 | 2020-11-29 | Bayfield | Wisconsin | 55007 | 688 | 12 |
777552 | 777552 | 2020-11-28 | Bayfield | Wisconsin | 55007 | 688 | 11 |
774307 | 774307 | 2020-11-27 | Bayfield | Wisconsin | 55007 | 661 | 11 |
771062 | 771062 | 2020-11-26 | Bayfield | Wisconsin | 55007 | 661 | 10 |
767816 | 767816 | 2020-11-25 | Bayfield | Wisconsin | 55007 | 653 | 9 |
764571 | 764571 | 2020-11-24 | Bayfield | Wisconsin | 55007 | 644 | 9 |
761326 | 761326 | 2020-11-23 | Bayfield | Wisconsin | 55007 | 639 | 7 |
758081 | 758081 | 2020-11-22 | Bayfield | Wisconsin | 55007 | 634 | 7 |
754834 | 754834 | 2020-11-21 | Bayfield | Wisconsin | 55007 | 625 | 7 |
751588 | 751588 | 2020-11-20 | Bayfield | Wisconsin | 55007 | 613 | 6 |
748342 | 748342 | 2020-11-19 | Bayfield | Wisconsin | 55007 | 604 | 6 |
745096 | 745096 | 2020-11-18 | Bayfield | Wisconsin | 55007 | 589 | 6 |
741849 | 741849 | 2020-11-17 | Bayfield | Wisconsin | 55007 | 580 | 6 |
738602 | 738602 | 2020-11-16 | Bayfield | Wisconsin | 55007 | 560 | 6 |
735358 | 735358 | 2020-11-15 | Bayfield | Wisconsin | 55007 | 542 | 6 |
732112 | 732112 | 2020-11-14 | Bayfield | Wisconsin | 55007 | 519 | 3 |
728867 | 728867 | 2020-11-13 | Bayfield | Wisconsin | 55007 | 501 | 3 |
725624 | 725624 | 2020-11-12 | Bayfield | Wisconsin | 55007 | 482 | 3 |
722381 | 722381 | 2020-11-11 | Bayfield | Wisconsin | 55007 | 454 | 3 |
719138 | 719138 | 2020-11-10 | Bayfield | Wisconsin | 55007 | 446 | 3 |
715895 | 715895 | 2020-11-09 | Bayfield | Wisconsin | 55007 | 418 | 3 |
712651 | 712651 | 2020-11-08 | Bayfield | Wisconsin | 55007 | 402 | 3 |
709407 | 709407 | 2020-11-07 | Bayfield | Wisconsin | 55007 | 393 | 3 |
706163 | 706163 | 2020-11-06 | Bayfield | Wisconsin | 55007 | 371 | 3 |
702920 | 702920 | 2020-11-05 | Bayfield | Wisconsin | 55007 | 356 | 2 |
699677 | 699677 | 2020-11-04 | Bayfield | Wisconsin | 55007 | 350 | 2 |
696433 | 696433 | 2020-11-03 | Bayfield | Wisconsin | 55007 | 326 | 2 |
693191 | 693191 | 2020-11-02 | Bayfield | Wisconsin | 55007 | 316 | 2 |
689947 | 689947 | 2020-11-01 | Bayfield | Wisconsin | 55007 | 292 | 2 |
686702 | 686702 | 2020-10-31 | Bayfield | Wisconsin | 55007 | 277 | 2 |
683459 | 683459 | 2020-10-30 | Bayfield | Wisconsin | 55007 | 266 | 2 |
680216 | 680216 | 2020-10-29 | Bayfield | Wisconsin | 55007 | 255 | 2 |
676973 | 676973 | 2020-10-28 | Bayfield | Wisconsin | 55007 | 240 | 2 |
673730 | 673730 | 2020-10-27 | Bayfield | Wisconsin | 55007 | 235 | 2 |
670488 | 670488 | 2020-10-26 | Bayfield | Wisconsin | 55007 | 231 | 1 |
667245 | 667245 | 2020-10-25 | Bayfield | Wisconsin | 55007 | 218 | 1 |
664000 | 664000 | 2020-10-24 | Bayfield | Wisconsin | 55007 | 214 | 1 |
660756 | 660756 | 2020-10-23 | Bayfield | Wisconsin | 55007 | 210 | 1 |
657512 | 657512 | 2020-10-22 | Bayfield | Wisconsin | 55007 | 202 | 1 |
654267 | 654267 | 2020-10-21 | Bayfield | Wisconsin | 55007 | 196 | 1 |
651022 | 651022 | 2020-10-20 | Bayfield | Wisconsin | 55007 | 194 | 1 |
647778 | 647778 | 2020-10-19 | Bayfield | Wisconsin | 55007 | 186 | 1 |
644532 | 644532 | 2020-10-18 | Bayfield | Wisconsin | 55007 | 178 | 1 |
641284 | 641284 | 2020-10-17 | Bayfield | Wisconsin | 55007 | 178 | 1 |
638037 | 638037 | 2020-10-16 | Bayfield | Wisconsin | 55007 | 178 | 1 |
634792 | 634792 | 2020-10-15 | Bayfield | Wisconsin | 55007 | 176 | 1 |
631547 | 631547 | 2020-10-14 | Bayfield | Wisconsin | 55007 | 170 | 1 |
628303 | 628303 | 2020-10-13 | Bayfield | Wisconsin | 55007 | 166 | 1 |
625060 | 625060 | 2020-10-12 | Bayfield | Wisconsin | 55007 | 159 | 1 |
621817 | 621817 | 2020-10-11 | Bayfield | Wisconsin | 55007 | 159 | 1 |
618574 | 618574 | 2020-10-10 | Bayfield | Wisconsin | 55007 | 156 | 1 |
615332 | 615332 | 2020-10-09 | Bayfield | Wisconsin | 55007 | 145 | 1 |
612091 | 612091 | 2020-10-08 | Bayfield | Wisconsin | 55007 | 141 | 1 |
608849 | 608849 | 2020-10-07 | Bayfield | Wisconsin | 55007 | 141 | 1 |
605606 | 605606 | 2020-10-06 | Bayfield | Wisconsin | 55007 | 141 | 1 |
602364 | 602364 | 2020-10-05 | Bayfield | Wisconsin | 55007 | 140 | 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);