ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
544 rows where deaths = 6 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Fond du Lac 61
- Eau Claire 40
- Iowa 33
- Barron 28
- Burnett 25
- Lafayette 24
- Pierce 23
- Green 21
- Buffalo 16
- Jefferson 16
- Marinette 14
- Clark 13
- Pepin 13
- Price 11
- Richland 11
- Sauk 11
- Unknown 11
- Adams 10
- Jackson 9
- Iron 8
- Juneau 8
- Taylor 8
- Waupaca 7
- Waushara 7
- Bayfield 6
- Dodge 6
- Grant 6
- Washburn 6
- Florence 5
- Forest 5
- …
state 1
- Wisconsin · 544 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
943105 | 943105 | 2021-01-18 | Pepin | Wisconsin | 55091 | 772 | 6 |
943109 | 943109 | 2021-01-18 | Price | Wisconsin | 55099 | 1097 | 6 |
939860 | 939860 | 2021-01-17 | Pepin | Wisconsin | 55091 | 772 | 6 |
939864 | 939864 | 2021-01-17 | Price | Wisconsin | 55099 | 1088 | 6 |
936615 | 936615 | 2021-01-16 | Pepin | Wisconsin | 55091 | 770 | 6 |
936619 | 936619 | 2021-01-16 | Price | Wisconsin | 55099 | 1082 | 6 |
933370 | 933370 | 2021-01-15 | Pepin | Wisconsin | 55091 | 769 | 6 |
933374 | 933374 | 2021-01-15 | Price | Wisconsin | 55099 | 1079 | 6 |
930125 | 930125 | 2021-01-14 | Pepin | Wisconsin | 55091 | 762 | 6 |
930129 | 930129 | 2021-01-14 | Price | Wisconsin | 55099 | 1070 | 6 |
926880 | 926880 | 2021-01-13 | Pepin | Wisconsin | 55091 | 761 | 6 |
926884 | 926884 | 2021-01-13 | Price | Wisconsin | 55099 | 1068 | 6 |
923634 | 923634 | 2021-01-12 | Pepin | Wisconsin | 55091 | 753 | 6 |
923638 | 923638 | 2021-01-12 | Price | Wisconsin | 55099 | 1060 | 6 |
920389 | 920389 | 2021-01-11 | Pepin | Wisconsin | 55091 | 743 | 6 |
920393 | 920393 | 2021-01-11 | Price | Wisconsin | 55099 | 1056 | 6 |
917130 | 917130 | 2021-01-10 | Lafayette | Wisconsin | 55065 | 1406 | 6 |
917144 | 917144 | 2021-01-10 | Pepin | Wisconsin | 55091 | 740 | 6 |
917148 | 917148 | 2021-01-10 | Price | Wisconsin | 55099 | 1054 | 6 |
913885 | 913885 | 2021-01-09 | Lafayette | Wisconsin | 55065 | 1390 | 6 |
913899 | 913899 | 2021-01-09 | Pepin | Wisconsin | 55091 | 732 | 6 |
913903 | 913903 | 2021-01-09 | Price | Wisconsin | 55099 | 1053 | 6 |
910640 | 910640 | 2021-01-08 | Lafayette | Wisconsin | 55065 | 1384 | 6 |
910654 | 910654 | 2021-01-08 | Pepin | Wisconsin | 55091 | 724 | 6 |
910658 | 910658 | 2021-01-08 | Price | Wisconsin | 55099 | 1047 | 6 |
907395 | 907395 | 2021-01-07 | Lafayette | Wisconsin | 55065 | 1377 | 6 |
907409 | 907409 | 2021-01-07 | Pepin | Wisconsin | 55091 | 716 | 6 |
904149 | 904149 | 2021-01-06 | Lafayette | Wisconsin | 55065 | 1374 | 6 |
904163 | 904163 | 2021-01-06 | Pepin | Wisconsin | 55091 | 710 | 6 |
900904 | 900904 | 2021-01-05 | Lafayette | Wisconsin | 55065 | 1363 | 6 |
897659 | 897659 | 2021-01-04 | Lafayette | Wisconsin | 55065 | 1360 | 6 |
894413 | 894413 | 2021-01-03 | Lafayette | Wisconsin | 55065 | 1360 | 6 |
891167 | 891167 | 2021-01-02 | Lafayette | Wisconsin | 55065 | 1357 | 6 |
887920 | 887920 | 2021-01-01 | Lafayette | Wisconsin | 55065 | 1349 | 6 |
884675 | 884675 | 2020-12-31 | Lafayette | Wisconsin | 55065 | 1350 | 6 |
881430 | 881430 | 2020-12-30 | Lafayette | Wisconsin | 55065 | 1347 | 6 |
878185 | 878185 | 2020-12-29 | Lafayette | Wisconsin | 55065 | 1338 | 6 |
874940 | 874940 | 2020-12-28 | Lafayette | Wisconsin | 55065 | 1335 | 6 |
871687 | 871687 | 2020-12-27 | Iowa | Wisconsin | 55049 | 1710 | 6 |
871695 | 871695 | 2020-12-27 | Lafayette | Wisconsin | 55065 | 1332 | 6 |
868423 | 868423 | 2020-12-26 | Buffalo | Wisconsin | 55011 | 976 | 6 |
868442 | 868442 | 2020-12-26 | Iowa | Wisconsin | 55049 | 1701 | 6 |
868450 | 868450 | 2020-12-26 | Lafayette | Wisconsin | 55065 | 1330 | 6 |
865178 | 865178 | 2020-12-25 | Buffalo | Wisconsin | 55011 | 976 | 6 |
865197 | 865197 | 2020-12-25 | Iowa | Wisconsin | 55049 | 1701 | 6 |
865205 | 865205 | 2020-12-25 | Lafayette | Wisconsin | 55065 | 1321 | 6 |
861933 | 861933 | 2020-12-24 | Buffalo | Wisconsin | 55011 | 975 | 6 |
861952 | 861952 | 2020-12-24 | Iowa | Wisconsin | 55049 | 1696 | 6 |
861960 | 861960 | 2020-12-24 | Lafayette | Wisconsin | 55065 | 1317 | 6 |
858688 | 858688 | 2020-12-23 | Buffalo | Wisconsin | 55011 | 965 | 6 |
858707 | 858707 | 2020-12-23 | Iowa | Wisconsin | 55049 | 1688 | 6 |
858715 | 858715 | 2020-12-23 | Lafayette | Wisconsin | 55065 | 1314 | 6 |
855443 | 855443 | 2020-12-22 | Buffalo | Wisconsin | 55011 | 959 | 6 |
855462 | 855462 | 2020-12-22 | Iowa | Wisconsin | 55049 | 1673 | 6 |
855470 | 855470 | 2020-12-22 | Lafayette | Wisconsin | 55065 | 1303 | 6 |
852198 | 852198 | 2020-12-21 | Buffalo | Wisconsin | 55011 | 956 | 6 |
852217 | 852217 | 2020-12-21 | Iowa | Wisconsin | 55049 | 1660 | 6 |
852225 | 852225 | 2020-12-21 | Lafayette | Wisconsin | 55065 | 1292 | 6 |
848953 | 848953 | 2020-12-20 | Buffalo | Wisconsin | 55011 | 955 | 6 |
848972 | 848972 | 2020-12-20 | Iowa | Wisconsin | 55049 | 1644 | 6 |
848980 | 848980 | 2020-12-20 | Lafayette | Wisconsin | 55065 | 1280 | 6 |
845708 | 845708 | 2020-12-19 | Buffalo | Wisconsin | 55011 | 952 | 6 |
845727 | 845727 | 2020-12-19 | Iowa | Wisconsin | 55049 | 1636 | 6 |
845735 | 845735 | 2020-12-19 | Lafayette | Wisconsin | 55065 | 1274 | 6 |
842462 | 842462 | 2020-12-18 | Buffalo | Wisconsin | 55011 | 944 | 6 |
842481 | 842481 | 2020-12-18 | Iowa | Wisconsin | 55049 | 1625 | 6 |
842489 | 842489 | 2020-12-18 | Lafayette | Wisconsin | 55065 | 1270 | 6 |
839217 | 839217 | 2020-12-17 | Buffalo | Wisconsin | 55011 | 942 | 6 |
839236 | 839236 | 2020-12-17 | Iowa | Wisconsin | 55049 | 1601 | 6 |
835972 | 835972 | 2020-12-16 | Buffalo | Wisconsin | 55011 | 934 | 6 |
835991 | 835991 | 2020-12-16 | Iowa | Wisconsin | 55049 | 1575 | 6 |
835993 | 835993 | 2020-12-16 | Jackson | Wisconsin | 55053 | 2130 | 6 |
832726 | 832726 | 2020-12-15 | Buffalo | Wisconsin | 55011 | 927 | 6 |
832745 | 832745 | 2020-12-15 | Iowa | Wisconsin | 55049 | 1563 | 6 |
832747 | 832747 | 2020-12-15 | Jackson | Wisconsin | 55053 | 2116 | 6 |
829479 | 829479 | 2020-12-14 | Buffalo | Wisconsin | 55011 | 924 | 6 |
829498 | 829498 | 2020-12-14 | Iowa | Wisconsin | 55049 | 1552 | 6 |
829500 | 829500 | 2020-12-14 | Jackson | Wisconsin | 55053 | 2096 | 6 |
826233 | 826233 | 2020-12-13 | Buffalo | Wisconsin | 55011 | 920 | 6 |
826252 | 826252 | 2020-12-13 | Iowa | Wisconsin | 55049 | 1544 | 6 |
826254 | 826254 | 2020-12-13 | Jackson | Wisconsin | 55053 | 2091 | 6 |
822986 | 822986 | 2020-12-12 | Buffalo | Wisconsin | 55011 | 916 | 6 |
823005 | 823005 | 2020-12-12 | Iowa | Wisconsin | 55049 | 1535 | 6 |
823007 | 823007 | 2020-12-12 | Jackson | Wisconsin | 55053 | 2085 | 6 |
819740 | 819740 | 2020-12-11 | Buffalo | Wisconsin | 55011 | 916 | 6 |
819759 | 819759 | 2020-12-11 | Iowa | Wisconsin | 55049 | 1513 | 6 |
819761 | 819761 | 2020-12-11 | Jackson | Wisconsin | 55053 | 2053 | 6 |
816513 | 816513 | 2020-12-10 | Iowa | Wisconsin | 55049 | 1489 | 6 |
816515 | 816515 | 2020-12-10 | Jackson | Wisconsin | 55053 | 2041 | 6 |
813267 | 813267 | 2020-12-09 | Iowa | Wisconsin | 55049 | 1463 | 6 |
813269 | 813269 | 2020-12-09 | Jackson | Wisconsin | 55053 | 2029 | 6 |
810023 | 810023 | 2020-12-08 | Iowa | Wisconsin | 55049 | 1440 | 6 |
810025 | 810025 | 2020-12-08 | Jackson | Wisconsin | 55053 | 2006 | 6 |
810064 | 810064 | 2020-12-08 | Washburn | Wisconsin | 55129 | 872 | 6 |
806778 | 806778 | 2020-12-07 | Iowa | Wisconsin | 55049 | 1429 | 6 |
806819 | 806819 | 2020-12-07 | Washburn | Wisconsin | 55129 | 848 | 6 |
803531 | 803531 | 2020-12-06 | Green | Wisconsin | 55045 | 1900 | 6 |
803533 | 803533 | 2020-12-06 | Iowa | Wisconsin | 55049 | 1414 | 6 |
803574 | 803574 | 2020-12-06 | Washburn | Wisconsin | 55129 | 835 | 6 |
800286 | 800286 | 2020-12-05 | Green | Wisconsin | 55045 | 1889 | 6 |
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);