ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55127 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177416 | 2177416 | 2022-02-02 | Walworth | Wisconsin | 55127 | 25999 | 258 |
2174163 | 2174163 | 2022-02-01 | Walworth | Wisconsin | 55127 | 25902 | 258 |
2170911 | 2170911 | 2022-01-31 | Walworth | Wisconsin | 55127 | 25603 | 254 |
2167658 | 2167658 | 2022-01-30 | Walworth | Wisconsin | 55127 | 25495 | 253 |
2164403 | 2164403 | 2022-01-29 | Walworth | Wisconsin | 55127 | 25495 | 253 |
2161148 | 2161148 | 2022-01-28 | Walworth | Wisconsin | 55127 | 25495 | 253 |
2157892 | 2157892 | 2022-01-27 | Walworth | Wisconsin | 55127 | 25495 | 253 |
2154639 | 2154639 | 2022-01-26 | Walworth | Wisconsin | 55127 | 25234 | 251 |
2151386 | 2151386 | 2022-01-25 | Walworth | Wisconsin | 55127 | 25234 | 250 |
2148134 | 2148134 | 2022-01-24 | Walworth | Wisconsin | 55127 | 24868 | 246 |
2144882 | 2144882 | 2022-01-23 | Walworth | Wisconsin | 55127 | 24502 | 244 |
2141627 | 2141627 | 2022-01-22 | Walworth | Wisconsin | 55127 | 24502 | 244 |
2138371 | 2138371 | 2022-01-21 | Walworth | Wisconsin | 55127 | 24502 | 244 |
2135116 | 2135116 | 2022-01-20 | Walworth | Wisconsin | 55127 | 24499 | 241 |
2131864 | 2131864 | 2022-01-19 | Walworth | Wisconsin | 55127 | 24088 | 237 |
2128610 | 2128610 | 2022-01-18 | Walworth | Wisconsin | 55127 | 24088 | 237 |
2125357 | 2125357 | 2022-01-17 | Walworth | Wisconsin | 55127 | 23567 | 234 |
2122105 | 2122105 | 2022-01-16 | Walworth | Wisconsin | 55127 | 22695 | 234 |
2118853 | 2118853 | 2022-01-15 | Walworth | Wisconsin | 55127 | 22695 | 234 |
2115601 | 2115601 | 2022-01-14 | Walworth | Wisconsin | 55127 | 22695 | 234 |
2112349 | 2112349 | 2022-01-13 | Walworth | Wisconsin | 55127 | 22512 | 233 |
2109097 | 2109097 | 2022-01-12 | Walworth | Wisconsin | 55127 | 21774 | 230 |
2105846 | 2105846 | 2022-01-11 | Walworth | Wisconsin | 55127 | 21774 | 230 |
2102595 | 2102595 | 2022-01-10 | Walworth | Wisconsin | 55127 | 21287 | 229 |
2099344 | 2099344 | 2022-01-09 | Walworth | Wisconsin | 55127 | 20794 | 224 |
2096093 | 2096093 | 2022-01-08 | Walworth | Wisconsin | 55127 | 20794 | 224 |
2092841 | 2092841 | 2022-01-07 | Walworth | Wisconsin | 55127 | 20794 | 224 |
2089589 | 2089589 | 2022-01-06 | Walworth | Wisconsin | 55127 | 20507 | 224 |
2086338 | 2086338 | 2022-01-05 | Walworth | Wisconsin | 55127 | 19971 | 223 |
2083086 | 2083086 | 2022-01-04 | Walworth | Wisconsin | 55127 | 19925 | 218 |
2079834 | 2079834 | 2022-01-03 | Walworth | Wisconsin | 55127 | 19673 | 218 |
2076582 | 2076582 | 2022-01-02 | Walworth | Wisconsin | 55127 | 19674 | 218 |
2073331 | 2073331 | 2022-01-01 | Walworth | Wisconsin | 55127 | 19674 | 218 |
2070080 | 2070080 | 2021-12-31 | Walworth | Wisconsin | 55127 | 19674 | 218 |
2066829 | 2066829 | 2021-12-30 | Walworth | Wisconsin | 55127 | 19675 | 218 |
2063579 | 2063579 | 2021-12-29 | Walworth | Wisconsin | 55127 | 19439 | 218 |
2060329 | 2060329 | 2021-12-28 | Walworth | Wisconsin | 55127 | 19439 | 218 |
2057080 | 2057080 | 2021-12-27 | Walworth | Wisconsin | 55127 | 19218 | 216 |
2053831 | 2053831 | 2021-12-26 | Walworth | Wisconsin | 55127 | 19218 | 216 |
2050581 | 2050581 | 2021-12-25 | Walworth | Wisconsin | 55127 | 19218 | 216 |
2047331 | 2047331 | 2021-12-24 | Walworth | Wisconsin | 55127 | 19218 | 216 |
2044081 | 2044081 | 2021-12-23 | Walworth | Wisconsin | 55127 | 19218 | 216 |
2040832 | 2040832 | 2021-12-22 | Walworth | Wisconsin | 55127 | 19218 | 216 |
2037582 | 2037582 | 2021-12-21 | Walworth | Wisconsin | 55127 | 19096 | 214 |
2034332 | 2034332 | 2021-12-20 | Walworth | Wisconsin | 55127 | 18778 | 209 |
2031082 | 2031082 | 2021-12-19 | Walworth | Wisconsin | 55127 | 18778 | 209 |
2027831 | 2027831 | 2021-12-18 | Walworth | Wisconsin | 55127 | 18778 | 209 |
2024580 | 2024580 | 2021-12-17 | Walworth | Wisconsin | 55127 | 18778 | 209 |
2021329 | 2021329 | 2021-12-16 | Walworth | Wisconsin | 55127 | 18778 | 209 |
2018078 | 2018078 | 2021-12-15 | Walworth | Wisconsin | 55127 | 18586 | 207 |
2014828 | 2014828 | 2021-12-14 | Walworth | Wisconsin | 55127 | 18586 | 207 |
2011577 | 2011577 | 2021-12-13 | Walworth | Wisconsin | 55127 | 18243 | 207 |
2008326 | 2008326 | 2021-12-12 | Walworth | Wisconsin | 55127 | 18153 | 207 |
2005075 | 2005075 | 2021-12-11 | Walworth | Wisconsin | 55127 | 18153 | 207 |
2001824 | 2001824 | 2021-12-10 | Walworth | Wisconsin | 55127 | 18153 | 207 |
1998574 | 1998574 | 2021-12-09 | Walworth | Wisconsin | 55127 | 18153 | 207 |
1995323 | 1995323 | 2021-12-08 | Walworth | Wisconsin | 55127 | 18034 | 206 |
1992072 | 1992072 | 2021-12-07 | Walworth | Wisconsin | 55127 | 18034 | 206 |
1988821 | 1988821 | 2021-12-06 | Walworth | Wisconsin | 55127 | 17699 | 202 |
1985571 | 1985571 | 2021-12-05 | Walworth | Wisconsin | 55127 | 17699 | 202 |
1982321 | 1982321 | 2021-12-04 | Walworth | Wisconsin | 55127 | 17699 | 202 |
1979071 | 1979071 | 2021-12-03 | Walworth | Wisconsin | 55127 | 17699 | 202 |
1975821 | 1975821 | 2021-12-02 | Walworth | Wisconsin | 55127 | 17699 | 201 |
1972572 | 1972572 | 2021-12-01 | Walworth | Wisconsin | 55127 | 17472 | 201 |
1969322 | 1969322 | 2021-11-30 | Walworth | Wisconsin | 55127 | 17420 | 201 |
1966072 | 1966072 | 2021-11-29 | Walworth | Wisconsin | 55127 | 17318 | 200 |
1962820 | 1962820 | 2021-11-28 | Walworth | Wisconsin | 55127 | 17318 | 199 |
1959569 | 1959569 | 2021-11-27 | Walworth | Wisconsin | 55127 | 17318 | 199 |
1956318 | 1956318 | 2021-11-26 | Walworth | Wisconsin | 55127 | 17318 | 199 |
1953067 | 1953067 | 2021-11-25 | Walworth | Wisconsin | 55127 | 17318 | 199 |
1949816 | 1949816 | 2021-11-24 | Walworth | Wisconsin | 55127 | 17318 | 199 |
1946565 | 1946565 | 2021-11-23 | Walworth | Wisconsin | 55127 | 17017 | 199 |
1943314 | 1943314 | 2021-11-22 | Walworth | Wisconsin | 55127 | 16923 | 195 |
1940064 | 1940064 | 2021-11-21 | Walworth | Wisconsin | 55127 | 16923 | 195 |
1936814 | 1936814 | 2021-11-20 | Walworth | Wisconsin | 55127 | 16923 | 195 |
1933564 | 1933564 | 2021-11-19 | Walworth | Wisconsin | 55127 | 16923 | 195 |
1930312 | 1930312 | 2021-11-18 | Walworth | Wisconsin | 55127 | 16923 | 194 |
1927062 | 1927062 | 2021-11-17 | Walworth | Wisconsin | 55127 | 16767 | 194 |
1923812 | 1923812 | 2021-11-16 | Walworth | Wisconsin | 55127 | 16767 | 194 |
1920563 | 1920563 | 2021-11-15 | Walworth | Wisconsin | 55127 | 16522 | 194 |
1917313 | 1917313 | 2021-11-14 | Walworth | Wisconsin | 55127 | 16522 | 194 |
1914063 | 1914063 | 2021-11-13 | Walworth | Wisconsin | 55127 | 16522 | 194 |
1910813 | 1910813 | 2021-11-12 | Walworth | Wisconsin | 55127 | 16522 | 194 |
1907564 | 1907564 | 2021-11-11 | Walworth | Wisconsin | 55127 | 16522 | 194 |
1904315 | 1904315 | 2021-11-10 | Walworth | Wisconsin | 55127 | 16372 | 194 |
1901065 | 1901065 | 2021-11-09 | Walworth | Wisconsin | 55127 | 16372 | 194 |
1897815 | 1897815 | 2021-11-08 | Walworth | Wisconsin | 55127 | 16128 | 193 |
1894565 | 1894565 | 2021-11-07 | Walworth | Wisconsin | 55127 | 16128 | 193 |
1891315 | 1891315 | 2021-11-06 | Walworth | Wisconsin | 55127 | 16128 | 193 |
1888065 | 1888065 | 2021-11-05 | Walworth | Wisconsin | 55127 | 16128 | 193 |
1884815 | 1884815 | 2021-11-04 | Walworth | Wisconsin | 55127 | 16128 | 193 |
1881566 | 1881566 | 2021-11-03 | Walworth | Wisconsin | 55127 | 15936 | 190 |
1878317 | 1878317 | 2021-11-02 | Walworth | Wisconsin | 55127 | 15936 | 190 |
1875068 | 1875068 | 2021-11-01 | Walworth | Wisconsin | 55127 | 15835 | 190 |
1871819 | 1871819 | 2021-10-31 | Walworth | Wisconsin | 55127 | 15835 | 190 |
1868570 | 1868570 | 2021-10-30 | Walworth | Wisconsin | 55127 | 15835 | 190 |
1865321 | 1865321 | 2021-10-29 | Walworth | Wisconsin | 55127 | 15835 | 190 |
1862072 | 1862072 | 2021-10-28 | Walworth | Wisconsin | 55127 | 15835 | 190 |
1858823 | 1858823 | 2021-10-27 | Walworth | Wisconsin | 55127 | 15759 | 190 |
1855574 | 1855574 | 2021-10-26 | Walworth | Wisconsin | 55127 | 15759 | 190 |
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);