ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55015 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063155 | 1063155 | 2021-02-24 | Calumet | Wisconsin | 55015 | 5984 | 45 |
1059910 | 1059910 | 2021-02-23 | Calumet | Wisconsin | 55015 | 5976 | 45 |
1056664 | 1056664 | 2021-02-22 | Calumet | Wisconsin | 55015 | 5970 | 45 |
1053418 | 1053418 | 2021-02-21 | Calumet | Wisconsin | 55015 | 5965 | 45 |
1050171 | 1050171 | 2021-02-20 | Calumet | Wisconsin | 55015 | 5958 | 45 |
1046924 | 1046924 | 2021-02-19 | Calumet | Wisconsin | 55015 | 5949 | 45 |
1043679 | 1043679 | 2021-02-18 | Calumet | Wisconsin | 55015 | 5935 | 45 |
1040434 | 1040434 | 2021-02-17 | Calumet | Wisconsin | 55015 | 5928 | 44 |
1037189 | 1037189 | 2021-02-16 | Calumet | Wisconsin | 55015 | 5922 | 43 |
1033944 | 1033944 | 2021-02-15 | Calumet | Wisconsin | 55015 | 5916 | 43 |
1030698 | 1030698 | 2021-02-14 | Calumet | Wisconsin | 55015 | 5910 | 43 |
1027451 | 1027451 | 2021-02-13 | Calumet | Wisconsin | 55015 | 5904 | 43 |
1024206 | 1024206 | 2021-02-12 | Calumet | Wisconsin | 55015 | 5893 | 43 |
1020961 | 1020961 | 2021-02-11 | Calumet | Wisconsin | 55015 | 5885 | 42 |
1017716 | 1017716 | 2021-02-10 | Calumet | Wisconsin | 55015 | 5865 | 42 |
1014471 | 1014471 | 2021-02-09 | Calumet | Wisconsin | 55015 | 5854 | 41 |
1011226 | 1011226 | 2021-02-08 | Calumet | Wisconsin | 55015 | 5844 | 41 |
1007980 | 1007980 | 2021-02-07 | Calumet | Wisconsin | 55015 | 5833 | 41 |
1004734 | 1004734 | 2021-02-06 | Calumet | Wisconsin | 55015 | 5830 | 41 |
1001488 | 1001488 | 2021-02-05 | Calumet | Wisconsin | 55015 | 5820 | 41 |
998242 | 998242 | 2021-02-04 | Calumet | Wisconsin | 55015 | 5801 | 41 |
994996 | 994996 | 2021-02-03 | Calumet | Wisconsin | 55015 | 5769 | 41 |
991750 | 991750 | 2021-02-02 | Calumet | Wisconsin | 55015 | 5746 | 41 |
988504 | 988504 | 2021-02-01 | Calumet | Wisconsin | 55015 | 5738 | 41 |
985257 | 985257 | 2021-01-31 | Calumet | Wisconsin | 55015 | 5727 | 41 |
982010 | 982010 | 2021-01-30 | Calumet | Wisconsin | 55015 | 5706 | 41 |
978764 | 978764 | 2021-01-29 | Calumet | Wisconsin | 55015 | 5683 | 41 |
975519 | 975519 | 2021-01-28 | Calumet | Wisconsin | 55015 | 5660 | 41 |
972274 | 972274 | 2021-01-27 | Calumet | Wisconsin | 55015 | 5633 | 41 |
969029 | 969029 | 2021-01-26 | Calumet | Wisconsin | 55015 | 5619 | 41 |
965785 | 965785 | 2021-01-25 | Calumet | Wisconsin | 55015 | 5595 | 41 |
962540 | 962540 | 2021-01-24 | Calumet | Wisconsin | 55015 | 5580 | 41 |
959295 | 959295 | 2021-01-23 | Calumet | Wisconsin | 55015 | 5557 | 41 |
956049 | 956049 | 2021-01-22 | Calumet | Wisconsin | 55015 | 5539 | 41 |
952804 | 952804 | 2021-01-21 | Calumet | Wisconsin | 55015 | 5522 | 41 |
949559 | 949559 | 2021-01-20 | Calumet | Wisconsin | 55015 | 5499 | 41 |
946313 | 946313 | 2021-01-19 | Calumet | Wisconsin | 55015 | 5485 | 41 |
943066 | 943066 | 2021-01-18 | Calumet | Wisconsin | 55015 | 5473 | 40 |
939821 | 939821 | 2021-01-17 | Calumet | Wisconsin | 55015 | 5466 | 40 |
936576 | 936576 | 2021-01-16 | Calumet | Wisconsin | 55015 | 5451 | 40 |
933331 | 933331 | 2021-01-15 | Calumet | Wisconsin | 55015 | 5410 | 40 |
930086 | 930086 | 2021-01-14 | Calumet | Wisconsin | 55015 | 5380 | 40 |
926841 | 926841 | 2021-01-13 | Calumet | Wisconsin | 55015 | 5359 | 40 |
923595 | 923595 | 2021-01-12 | Calumet | Wisconsin | 55015 | 5331 | 40 |
920350 | 920350 | 2021-01-11 | Calumet | Wisconsin | 55015 | 5315 | 39 |
917105 | 917105 | 2021-01-10 | Calumet | Wisconsin | 55015 | 5294 | 39 |
913860 | 913860 | 2021-01-09 | Calumet | Wisconsin | 55015 | 5261 | 39 |
910615 | 910615 | 2021-01-08 | Calumet | Wisconsin | 55015 | 5220 | 38 |
907370 | 907370 | 2021-01-07 | Calumet | Wisconsin | 55015 | 5177 | 38 |
904124 | 904124 | 2021-01-06 | Calumet | Wisconsin | 55015 | 5142 | 37 |
900879 | 900879 | 2021-01-05 | Calumet | Wisconsin | 55015 | 5110 | 37 |
897634 | 897634 | 2021-01-04 | Calumet | Wisconsin | 55015 | 5089 | 37 |
894388 | 894388 | 2021-01-03 | Calumet | Wisconsin | 55015 | 5075 | 37 |
891142 | 891142 | 2021-01-02 | Calumet | Wisconsin | 55015 | 5054 | 37 |
887895 | 887895 | 2021-01-01 | Calumet | Wisconsin | 55015 | 5040 | 37 |
884650 | 884650 | 2020-12-31 | Calumet | Wisconsin | 55015 | 5015 | 37 |
881405 | 881405 | 2020-12-30 | Calumet | Wisconsin | 55015 | 4980 | 37 |
878160 | 878160 | 2020-12-29 | Calumet | Wisconsin | 55015 | 4947 | 37 |
874915 | 874915 | 2020-12-28 | Calumet | Wisconsin | 55015 | 4938 | 36 |
871670 | 871670 | 2020-12-27 | Calumet | Wisconsin | 55015 | 4927 | 35 |
868425 | 868425 | 2020-12-26 | Calumet | Wisconsin | 55015 | 4912 | 35 |
865180 | 865180 | 2020-12-25 | Calumet | Wisconsin | 55015 | 4909 | 35 |
861935 | 861935 | 2020-12-24 | Calumet | Wisconsin | 55015 | 4897 | 35 |
858690 | 858690 | 2020-12-23 | Calumet | Wisconsin | 55015 | 4874 | 35 |
855445 | 855445 | 2020-12-22 | Calumet | Wisconsin | 55015 | 4851 | 35 |
852200 | 852200 | 2020-12-21 | Calumet | Wisconsin | 55015 | 4836 | 32 |
848955 | 848955 | 2020-12-20 | Calumet | Wisconsin | 55015 | 4823 | 32 |
845710 | 845710 | 2020-12-19 | Calumet | Wisconsin | 55015 | 4807 | 32 |
842464 | 842464 | 2020-12-18 | Calumet | Wisconsin | 55015 | 4775 | 33 |
839219 | 839219 | 2020-12-17 | Calumet | Wisconsin | 55015 | 4742 | 32 |
835974 | 835974 | 2020-12-16 | Calumet | Wisconsin | 55015 | 4721 | 31 |
832728 | 832728 | 2020-12-15 | Calumet | Wisconsin | 55015 | 4703 | 31 |
829481 | 829481 | 2020-12-14 | Calumet | Wisconsin | 55015 | 4684 | 31 |
826235 | 826235 | 2020-12-13 | Calumet | Wisconsin | 55015 | 4661 | 31 |
822988 | 822988 | 2020-12-12 | Calumet | Wisconsin | 55015 | 4628 | 31 |
819742 | 819742 | 2020-12-11 | Calumet | Wisconsin | 55015 | 4589 | 31 |
816496 | 816496 | 2020-12-10 | Calumet | Wisconsin | 55015 | 4557 | 30 |
813250 | 813250 | 2020-12-09 | Calumet | Wisconsin | 55015 | 4538 | 30 |
810006 | 810006 | 2020-12-08 | Calumet | Wisconsin | 55015 | 4519 | 30 |
806761 | 806761 | 2020-12-07 | Calumet | Wisconsin | 55015 | 4483 | 29 |
803516 | 803516 | 2020-12-06 | Calumet | Wisconsin | 55015 | 4468 | 29 |
800271 | 800271 | 2020-12-05 | Calumet | Wisconsin | 55015 | 4419 | 29 |
797026 | 797026 | 2020-12-04 | Calumet | Wisconsin | 55015 | 4398 | 28 |
793781 | 793781 | 2020-12-03 | Calumet | Wisconsin | 55015 | 4356 | 27 |
790536 | 790536 | 2020-12-02 | Calumet | Wisconsin | 55015 | 4312 | 27 |
787291 | 787291 | 2020-12-01 | Calumet | Wisconsin | 55015 | 4292 | 27 |
784047 | 784047 | 2020-11-30 | Calumet | Wisconsin | 55015 | 4273 | 26 |
780802 | 780802 | 2020-11-29 | Calumet | Wisconsin | 55015 | 4251 | 26 |
777556 | 777556 | 2020-11-28 | Calumet | Wisconsin | 55015 | 4238 | 26 |
774311 | 774311 | 2020-11-27 | Calumet | Wisconsin | 55015 | 4199 | 26 |
771066 | 771066 | 2020-11-26 | Calumet | Wisconsin | 55015 | 4196 | 26 |
767820 | 767820 | 2020-11-25 | Calumet | Wisconsin | 55015 | 4169 | 26 |
764575 | 764575 | 2020-11-24 | Calumet | Wisconsin | 55015 | 4128 | 26 |
761330 | 761330 | 2020-11-23 | Calumet | Wisconsin | 55015 | 4077 | 26 |
758085 | 758085 | 2020-11-22 | Calumet | Wisconsin | 55015 | 4047 | 26 |
754838 | 754838 | 2020-11-21 | Calumet | Wisconsin | 55015 | 3996 | 26 |
751592 | 751592 | 2020-11-20 | Calumet | Wisconsin | 55015 | 3942 | 26 |
748346 | 748346 | 2020-11-19 | Calumet | Wisconsin | 55015 | 3897 | 23 |
745100 | 745100 | 2020-11-18 | Calumet | Wisconsin | 55015 | 3841 | 22 |
741853 | 741853 | 2020-11-17 | Calumet | Wisconsin | 55015 | 3787 | 22 |
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);