ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
429 rows where deaths = 5 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Dodge 79
- Green 26
- Pepin 23
- Jefferson 19
- Price 18
- Waushara 18
- Sheboygan 14
- Rusk 13
- Fond du Lac 11
- Lafayette 11
- Manitowoc 11
- Juneau 10
- Wood 10
- Green Lake 9
- Marinette 9
- Ashland 8
- Buffalo 8
- Pierce 8
- Sawyer 8
- Lincoln 7
- Polk 7
- Adams 6
- Calumet 6
- Columbia 6
- Jackson 6
- Oneida 6
- Vilas 6
- Waupaca 6
- Kenosha 5
- Outagamie 5
- …
state 1
- Wisconsin · 429 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
907413 | 907413 | 2021-01-07 | Price | Wisconsin | 55099 | 1043 | 5 |
904167 | 904167 | 2021-01-06 | Price | Wisconsin | 55099 | 1038 | 5 |
900918 | 900918 | 2021-01-05 | Pepin | Wisconsin | 55091 | 705 | 5 |
900922 | 900922 | 2021-01-05 | Price | Wisconsin | 55099 | 1036 | 5 |
897673 | 897673 | 2021-01-04 | Pepin | Wisconsin | 55091 | 700 | 5 |
897677 | 897677 | 2021-01-04 | Price | Wisconsin | 55099 | 1027 | 5 |
894427 | 894427 | 2021-01-03 | Pepin | Wisconsin | 55091 | 700 | 5 |
894431 | 894431 | 2021-01-03 | Price | Wisconsin | 55099 | 1027 | 5 |
891181 | 891181 | 2021-01-02 | Pepin | Wisconsin | 55091 | 700 | 5 |
891185 | 891185 | 2021-01-02 | Price | Wisconsin | 55099 | 1015 | 5 |
887934 | 887934 | 2021-01-01 | Pepin | Wisconsin | 55091 | 699 | 5 |
887938 | 887938 | 2021-01-01 | Price | Wisconsin | 55099 | 1015 | 5 |
884689 | 884689 | 2020-12-31 | Pepin | Wisconsin | 55091 | 693 | 5 |
884693 | 884693 | 2020-12-31 | Price | Wisconsin | 55099 | 1015 | 5 |
881444 | 881444 | 2020-12-30 | Pepin | Wisconsin | 55091 | 688 | 5 |
881448 | 881448 | 2020-12-30 | Price | Wisconsin | 55099 | 1003 | 5 |
878199 | 878199 | 2020-12-29 | Pepin | Wisconsin | 55091 | 675 | 5 |
878203 | 878203 | 2020-12-29 | Price | Wisconsin | 55099 | 999 | 5 |
874954 | 874954 | 2020-12-28 | Pepin | Wisconsin | 55091 | 661 | 5 |
874958 | 874958 | 2020-12-28 | Price | Wisconsin | 55099 | 992 | 5 |
871709 | 871709 | 2020-12-27 | Pepin | Wisconsin | 55091 | 658 | 5 |
871713 | 871713 | 2020-12-27 | Price | Wisconsin | 55099 | 990 | 5 |
868464 | 868464 | 2020-12-26 | Pepin | Wisconsin | 55091 | 649 | 5 |
868468 | 868468 | 2020-12-26 | Price | Wisconsin | 55099 | 980 | 5 |
865219 | 865219 | 2020-12-25 | Pepin | Wisconsin | 55091 | 649 | 5 |
865223 | 865223 | 2020-12-25 | Price | Wisconsin | 55099 | 980 | 5 |
861974 | 861974 | 2020-12-24 | Pepin | Wisconsin | 55091 | 649 | 5 |
861978 | 861978 | 2020-12-24 | Price | Wisconsin | 55099 | 978 | 5 |
858729 | 858729 | 2020-12-23 | Pepin | Wisconsin | 55091 | 639 | 5 |
858733 | 858733 | 2020-12-23 | Price | Wisconsin | 55099 | 970 | 5 |
855484 | 855484 | 2020-12-22 | Pepin | Wisconsin | 55091 | 630 | 5 |
852239 | 852239 | 2020-12-21 | Pepin | Wisconsin | 55091 | 628 | 5 |
848994 | 848994 | 2020-12-20 | Pepin | Wisconsin | 55091 | 624 | 5 |
845749 | 845749 | 2020-12-19 | Pepin | Wisconsin | 55091 | 623 | 5 |
839244 | 839244 | 2020-12-17 | Lafayette | Wisconsin | 55065 | 1260 | 5 |
835999 | 835999 | 2020-12-16 | Lafayette | Wisconsin | 55065 | 1255 | 5 |
832753 | 832753 | 2020-12-15 | Lafayette | Wisconsin | 55065 | 1249 | 5 |
829506 | 829506 | 2020-12-14 | Lafayette | Wisconsin | 55065 | 1244 | 5 |
829520 | 829520 | 2020-12-14 | Pepin | Wisconsin | 55091 | 587 | 5 |
826260 | 826260 | 2020-12-13 | Lafayette | Wisconsin | 55065 | 1240 | 5 |
826274 | 826274 | 2020-12-13 | Pepin | Wisconsin | 55091 | 587 | 5 |
823013 | 823013 | 2020-12-12 | Lafayette | Wisconsin | 55065 | 1232 | 5 |
823027 | 823027 | 2020-12-12 | Pepin | Wisconsin | 55091 | 587 | 5 |
819767 | 819767 | 2020-12-11 | Lafayette | Wisconsin | 55065 | 1228 | 5 |
819781 | 819781 | 2020-12-11 | Pepin | Wisconsin | 55091 | 579 | 5 |
816494 | 816494 | 2020-12-10 | Buffalo | Wisconsin | 55011 | 908 | 5 |
816521 | 816521 | 2020-12-10 | Lafayette | Wisconsin | 55065 | 1217 | 5 |
816535 | 816535 | 2020-12-10 | Pepin | Wisconsin | 55091 | 552 | 5 |
813248 | 813248 | 2020-12-09 | Buffalo | Wisconsin | 55011 | 900 | 5 |
813275 | 813275 | 2020-12-09 | Lafayette | Wisconsin | 55065 | 1209 | 5 |
810004 | 810004 | 2020-12-08 | Buffalo | Wisconsin | 55011 | 889 | 5 |
810031 | 810031 | 2020-12-08 | Lafayette | Wisconsin | 55065 | 1206 | 5 |
806759 | 806759 | 2020-12-07 | Buffalo | Wisconsin | 55011 | 881 | 5 |
806780 | 806780 | 2020-12-07 | Jackson | Wisconsin | 55053 | 1986 | 5 |
806786 | 806786 | 2020-12-07 | Lafayette | Wisconsin | 55065 | 1199 | 5 |
803514 | 803514 | 2020-12-06 | Buffalo | Wisconsin | 55011 | 879 | 5 |
803535 | 803535 | 2020-12-06 | Jackson | Wisconsin | 55053 | 1980 | 5 |
800269 | 800269 | 2020-12-05 | Buffalo | Wisconsin | 55011 | 875 | 5 |
800290 | 800290 | 2020-12-05 | Jackson | Wisconsin | 55053 | 1964 | 5 |
797024 | 797024 | 2020-12-04 | Buffalo | Wisconsin | 55011 | 860 | 5 |
797045 | 797045 | 2020-12-04 | Jackson | Wisconsin | 55053 | 1823 | 5 |
797069 | 797069 | 2020-12-04 | Price | Wisconsin | 55099 | 835 | 5 |
793779 | 793779 | 2020-12-03 | Buffalo | Wisconsin | 55011 | 854 | 5 |
793800 | 793800 | 2020-12-03 | Jackson | Wisconsin | 55053 | 1798 | 5 |
793824 | 793824 | 2020-12-03 | Price | Wisconsin | 55099 | 821 | 5 |
790555 | 790555 | 2020-12-02 | Jackson | Wisconsin | 55053 | 1775 | 5 |
790594 | 790594 | 2020-12-02 | Washburn | Wisconsin | 55129 | 776 | 5 |
787299 | 787299 | 2020-12-01 | Douglas | Wisconsin | 55031 | 2217 | 5 |
787349 | 787349 | 2020-12-01 | Washburn | Wisconsin | 55129 | 762 | 5 |
767836 | 767836 | 2020-11-25 | Green Lake | Wisconsin | 55047 | 1381 | 5 |
764591 | 764591 | 2020-11-24 | Green Lake | Wisconsin | 55047 | 1364 | 5 |
761346 | 761346 | 2020-11-23 | Green Lake | Wisconsin | 55047 | 1344 | 5 |
761377 | 761377 | 2020-11-23 | Rusk | Wisconsin | 55107 | 781 | 5 |
758089 | 758089 | 2020-11-22 | Crawford | Wisconsin | 55023 | 830 | 5 |
758101 | 758101 | 2020-11-22 | Green Lake | Wisconsin | 55047 | 1334 | 5 |
758132 | 758132 | 2020-11-22 | Rusk | Wisconsin | 55107 | 764 | 5 |
754854 | 754854 | 2020-11-21 | Green Lake | Wisconsin | 55047 | 1324 | 5 |
754885 | 754885 | 2020-11-21 | Rusk | Wisconsin | 55107 | 748 | 5 |
751608 | 751608 | 2020-11-20 | Green Lake | Wisconsin | 55047 | 1310 | 5 |
751639 | 751639 | 2020-11-20 | Rusk | Wisconsin | 55107 | 723 | 5 |
748355 | 748355 | 2020-11-19 | Dunn | Wisconsin | 55033 | 2307 | 5 |
748362 | 748362 | 2020-11-19 | Green Lake | Wisconsin | 55047 | 1285 | 5 |
748393 | 748393 | 2020-11-19 | Rusk | Wisconsin | 55107 | 726 | 5 |
745109 | 745109 | 2020-11-18 | Dunn | Wisconsin | 55033 | 2246 | 5 |
745116 | 745116 | 2020-11-18 | Green Lake | Wisconsin | 55047 | 1270 | 5 |
745147 | 745147 | 2020-11-18 | Rusk | Wisconsin | 55107 | 698 | 5 |
745149 | 745149 | 2020-11-18 | Sawyer | Wisconsin | 55113 | 716 | 5 |
741868 | 741868 | 2020-11-17 | Green | Wisconsin | 55045 | 1445 | 5 |
741869 | 741869 | 2020-11-17 | Green Lake | Wisconsin | 55047 | 1252 | 5 |
741900 | 741900 | 2020-11-17 | Rusk | Wisconsin | 55107 | 651 | 5 |
741902 | 741902 | 2020-11-17 | Sawyer | Wisconsin | 55113 | 691 | 5 |
738621 | 738621 | 2020-11-16 | Green | Wisconsin | 55045 | 1431 | 5 |
738653 | 738653 | 2020-11-16 | Rusk | Wisconsin | 55107 | 638 | 5 |
738655 | 738655 | 2020-11-16 | Sawyer | Wisconsin | 55113 | 666 | 5 |
738661 | 738661 | 2020-11-16 | Vernon | Wisconsin | 55123 | 861 | 5 |
735377 | 735377 | 2020-11-15 | Green | Wisconsin | 55045 | 1414 | 5 |
735403 | 735403 | 2020-11-15 | Polk | Wisconsin | 55095 | 1516 | 5 |
735409 | 735409 | 2020-11-15 | Rusk | Wisconsin | 55107 | 614 | 5 |
735411 | 735411 | 2020-11-15 | Sawyer | Wisconsin | 55113 | 653 | 5 |
735417 | 735417 | 2020-11-15 | Vernon | Wisconsin | 55123 | 830 | 5 |
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);