ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Walworth" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1852325 | 1852325 | 2021-10-25 | Walworth | Wisconsin | 55127 | 15627 | 188 |
1849075 | 1849075 | 2021-10-24 | Walworth | Wisconsin | 55127 | 15627 | 188 |
1845825 | 1845825 | 2021-10-23 | Walworth | Wisconsin | 55127 | 15627 | 188 |
1842575 | 1842575 | 2021-10-22 | Walworth | Wisconsin | 55127 | 15627 | 188 |
1839326 | 1839326 | 2021-10-21 | Walworth | Wisconsin | 55127 | 15627 | 188 |
1836077 | 1836077 | 2021-10-20 | Walworth | Wisconsin | 55127 | 15505 | 187 |
1832828 | 1832828 | 2021-10-19 | Walworth | Wisconsin | 55127 | 15505 | 187 |
1829579 | 1829579 | 2021-10-18 | Walworth | Wisconsin | 55127 | 15380 | 187 |
1826330 | 1826330 | 2021-10-17 | Walworth | Wisconsin | 55127 | 15380 | 187 |
1823081 | 1823081 | 2021-10-16 | Walworth | Wisconsin | 55127 | 15380 | 187 |
1819832 | 1819832 | 2021-10-15 | Walworth | Wisconsin | 55127 | 15380 | 187 |
1816583 | 1816583 | 2021-10-14 | Walworth | Wisconsin | 55127 | 15380 | 187 |
1813335 | 1813335 | 2021-10-13 | Walworth | Wisconsin | 55127 | 15289 | 187 |
1810086 | 1810086 | 2021-10-12 | Walworth | Wisconsin | 55127 | 15289 | 187 |
1806837 | 1806837 | 2021-10-11 | Walworth | Wisconsin | 55127 | 15095 | 185 |
1803586 | 1803586 | 2021-10-10 | Walworth | Wisconsin | 55127 | 15095 | 185 |
1800337 | 1800337 | 2021-10-09 | Walworth | Wisconsin | 55127 | 15095 | 185 |
1797088 | 1797088 | 2021-10-08 | Walworth | Wisconsin | 55127 | 15095 | 185 |
1793839 | 1793839 | 2021-10-07 | Walworth | Wisconsin | 55127 | 15095 | 185 |
1790590 | 1790590 | 2021-10-06 | Walworth | Wisconsin | 55127 | 14934 | 183 |
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);