ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55017 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923596 | 923596 | 2021-01-12 | Chippewa | Wisconsin | 55017 | 6460 | 72 |
920351 | 920351 | 2021-01-11 | Chippewa | Wisconsin | 55017 | 6411 | 72 |
917106 | 917106 | 2021-01-10 | Chippewa | Wisconsin | 55017 | 6379 | 72 |
913861 | 913861 | 2021-01-09 | Chippewa | Wisconsin | 55017 | 6342 | 72 |
910616 | 910616 | 2021-01-08 | Chippewa | Wisconsin | 55017 | 6293 | 69 |
907371 | 907371 | 2021-01-07 | Chippewa | Wisconsin | 55017 | 6208 | 69 |
904125 | 904125 | 2021-01-06 | Chippewa | Wisconsin | 55017 | 6177 | 69 |
900880 | 900880 | 2021-01-05 | Chippewa | Wisconsin | 55017 | 6118 | 69 |
897635 | 897635 | 2021-01-04 | Chippewa | Wisconsin | 55017 | 6106 | 68 |
894389 | 894389 | 2021-01-03 | Chippewa | Wisconsin | 55017 | 6074 | 68 |
891143 | 891143 | 2021-01-02 | Chippewa | Wisconsin | 55017 | 6025 | 67 |
887896 | 887896 | 2021-01-01 | Chippewa | Wisconsin | 55017 | 6025 | 67 |
884651 | 884651 | 2020-12-31 | Chippewa | Wisconsin | 55017 | 6005 | 67 |
881406 | 881406 | 2020-12-30 | Chippewa | Wisconsin | 55017 | 5938 | 67 |
878161 | 878161 | 2020-12-29 | Chippewa | Wisconsin | 55017 | 5912 | 67 |
874916 | 874916 | 2020-12-28 | Chippewa | Wisconsin | 55017 | 5895 | 67 |
871671 | 871671 | 2020-12-27 | Chippewa | Wisconsin | 55017 | 5883 | 67 |
868426 | 868426 | 2020-12-26 | Chippewa | Wisconsin | 55017 | 5831 | 67 |
865181 | 865181 | 2020-12-25 | Chippewa | Wisconsin | 55017 | 5827 | 67 |
861936 | 861936 | 2020-12-24 | Chippewa | Wisconsin | 55017 | 5826 | 67 |
858691 | 858691 | 2020-12-23 | Chippewa | Wisconsin | 55017 | 5787 | 67 |
855446 | 855446 | 2020-12-22 | Chippewa | Wisconsin | 55017 | 5760 | 67 |
852201 | 852201 | 2020-12-21 | Chippewa | Wisconsin | 55017 | 5739 | 67 |
848956 | 848956 | 2020-12-20 | Chippewa | Wisconsin | 55017 | 5718 | 66 |
845711 | 845711 | 2020-12-19 | Chippewa | Wisconsin | 55017 | 5697 | 65 |
842465 | 842465 | 2020-12-18 | Chippewa | Wisconsin | 55017 | 5662 | 65 |
839220 | 839220 | 2020-12-17 | Chippewa | Wisconsin | 55017 | 5628 | 65 |
835975 | 835975 | 2020-12-16 | Chippewa | Wisconsin | 55017 | 5593 | 65 |
832729 | 832729 | 2020-12-15 | Chippewa | Wisconsin | 55017 | 5558 | 64 |
829482 | 829482 | 2020-12-14 | Chippewa | Wisconsin | 55017 | 5544 | 63 |
826236 | 826236 | 2020-12-13 | Chippewa | Wisconsin | 55017 | 5506 | 62 |
822989 | 822989 | 2020-12-12 | Chippewa | Wisconsin | 55017 | 5490 | 61 |
819743 | 819743 | 2020-12-11 | Chippewa | Wisconsin | 55017 | 5454 | 59 |
816497 | 816497 | 2020-12-10 | Chippewa | Wisconsin | 55017 | 5393 | 60 |
813251 | 813251 | 2020-12-09 | Chippewa | Wisconsin | 55017 | 5356 | 59 |
810007 | 810007 | 2020-12-08 | Chippewa | Wisconsin | 55017 | 5328 | 59 |
806762 | 806762 | 2020-12-07 | Chippewa | Wisconsin | 55017 | 5298 | 57 |
803517 | 803517 | 2020-12-06 | Chippewa | Wisconsin | 55017 | 5265 | 57 |
800272 | 800272 | 2020-12-05 | Chippewa | Wisconsin | 55017 | 5215 | 57 |
797027 | 797027 | 2020-12-04 | Chippewa | Wisconsin | 55017 | 5128 | 55 |
793782 | 793782 | 2020-12-03 | Chippewa | Wisconsin | 55017 | 5065 | 55 |
790537 | 790537 | 2020-12-02 | Chippewa | Wisconsin | 55017 | 4979 | 55 |
787292 | 787292 | 2020-12-01 | Chippewa | Wisconsin | 55017 | 4846 | 54 |
784048 | 784048 | 2020-11-30 | Chippewa | Wisconsin | 55017 | 4717 | 53 |
780803 | 780803 | 2020-11-29 | Chippewa | Wisconsin | 55017 | 4649 | 53 |
777557 | 777557 | 2020-11-28 | Chippewa | Wisconsin | 55017 | 4585 | 52 |
774312 | 774312 | 2020-11-27 | Chippewa | Wisconsin | 55017 | 4581 | 52 |
771067 | 771067 | 2020-11-26 | Chippewa | Wisconsin | 55017 | 4580 | 51 |
767821 | 767821 | 2020-11-25 | Chippewa | Wisconsin | 55017 | 4502 | 50 |
764576 | 764576 | 2020-11-24 | Chippewa | Wisconsin | 55017 | 4420 | 49 |
761331 | 761331 | 2020-11-23 | Chippewa | Wisconsin | 55017 | 4348 | 47 |
758086 | 758086 | 2020-11-22 | Chippewa | Wisconsin | 55017 | 4298 | 47 |
754839 | 754839 | 2020-11-21 | Chippewa | Wisconsin | 55017 | 4218 | 47 |
751593 | 751593 | 2020-11-20 | Chippewa | Wisconsin | 55017 | 4009 | 46 |
748347 | 748347 | 2020-11-19 | Chippewa | Wisconsin | 55017 | 3933 | 45 |
745101 | 745101 | 2020-11-18 | Chippewa | Wisconsin | 55017 | 3836 | 44 |
741854 | 741854 | 2020-11-17 | Chippewa | Wisconsin | 55017 | 3733 | 43 |
738607 | 738607 | 2020-11-16 | Chippewa | Wisconsin | 55017 | 3620 | 43 |
735363 | 735363 | 2020-11-15 | Chippewa | Wisconsin | 55017 | 3551 | 40 |
732117 | 732117 | 2020-11-14 | Chippewa | Wisconsin | 55017 | 3478 | 38 |
728872 | 728872 | 2020-11-13 | Chippewa | Wisconsin | 55017 | 3398 | 38 |
725629 | 725629 | 2020-11-12 | Chippewa | Wisconsin | 55017 | 3263 | 37 |
722386 | 722386 | 2020-11-11 | Chippewa | Wisconsin | 55017 | 3126 | 35 |
719143 | 719143 | 2020-11-10 | Chippewa | Wisconsin | 55017 | 3022 | 33 |
715900 | 715900 | 2020-11-09 | Chippewa | Wisconsin | 55017 | 2838 | 33 |
712656 | 712656 | 2020-11-08 | Chippewa | Wisconsin | 55017 | 2791 | 31 |
709412 | 709412 | 2020-11-07 | Chippewa | Wisconsin | 55017 | 2751 | 31 |
706168 | 706168 | 2020-11-06 | Chippewa | Wisconsin | 55017 | 2642 | 28 |
702925 | 702925 | 2020-11-05 | Chippewa | Wisconsin | 55017 | 2472 | 28 |
699682 | 699682 | 2020-11-04 | Chippewa | Wisconsin | 55017 | 2298 | 26 |
696438 | 696438 | 2020-11-03 | Chippewa | Wisconsin | 55017 | 2163 | 26 |
693196 | 693196 | 2020-11-02 | Chippewa | Wisconsin | 55017 | 2069 | 26 |
689952 | 689952 | 2020-11-01 | Chippewa | Wisconsin | 55017 | 1994 | 26 |
686707 | 686707 | 2020-10-31 | Chippewa | Wisconsin | 55017 | 1976 | 26 |
683464 | 683464 | 2020-10-30 | Chippewa | Wisconsin | 55017 | 1901 | 23 |
680221 | 680221 | 2020-10-29 | Chippewa | Wisconsin | 55017 | 1825 | 21 |
676978 | 676978 | 2020-10-28 | Chippewa | Wisconsin | 55017 | 1719 | 15 |
673735 | 673735 | 2020-10-27 | Chippewa | Wisconsin | 55017 | 1615 | 13 |
670493 | 670493 | 2020-10-26 | Chippewa | Wisconsin | 55017 | 1567 | 13 |
667250 | 667250 | 2020-10-25 | Chippewa | Wisconsin | 55017 | 1430 | 12 |
664005 | 664005 | 2020-10-24 | Chippewa | Wisconsin | 55017 | 1430 | 12 |
660761 | 660761 | 2020-10-23 | Chippewa | Wisconsin | 55017 | 1347 | 10 |
657517 | 657517 | 2020-10-22 | Chippewa | Wisconsin | 55017 | 1308 | 7 |
654272 | 654272 | 2020-10-21 | Chippewa | Wisconsin | 55017 | 1245 | 7 |
651027 | 651027 | 2020-10-20 | Chippewa | Wisconsin | 55017 | 1159 | 6 |
647783 | 647783 | 2020-10-19 | Chippewa | Wisconsin | 55017 | 1153 | 5 |
644537 | 644537 | 2020-10-18 | Chippewa | Wisconsin | 55017 | 1046 | 2 |
641289 | 641289 | 2020-10-17 | Chippewa | Wisconsin | 55017 | 1046 | 2 |
638042 | 638042 | 2020-10-16 | Chippewa | Wisconsin | 55017 | 1046 | 2 |
634797 | 634797 | 2020-10-15 | Chippewa | Wisconsin | 55017 | 988 | 2 |
631552 | 631552 | 2020-10-14 | Chippewa | Wisconsin | 55017 | 916 | 1 |
628308 | 628308 | 2020-10-13 | Chippewa | Wisconsin | 55017 | 888 | 1 |
625065 | 625065 | 2020-10-12 | Chippewa | Wisconsin | 55017 | 860 | 0 |
621822 | 621822 | 2020-10-11 | Chippewa | Wisconsin | 55017 | 839 | 0 |
618579 | 618579 | 2020-10-10 | Chippewa | Wisconsin | 55017 | 814 | 0 |
615337 | 615337 | 2020-10-09 | Chippewa | Wisconsin | 55017 | 790 | 0 |
612096 | 612096 | 2020-10-08 | Chippewa | Wisconsin | 55017 | 757 | 0 |
608854 | 608854 | 2020-10-07 | Chippewa | Wisconsin | 55017 | 725 | 0 |
605611 | 605611 | 2020-10-06 | Chippewa | Wisconsin | 55017 | 694 | 0 |
602369 | 602369 | 2020-10-05 | Chippewa | Wisconsin | 55017 | 677 | 0 |
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);