ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 55121 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177413 | 2177413 | 2022-02-02 | Trempealeau | Wisconsin | 55121 | 8047 | 58 |
2174160 | 2174160 | 2022-02-01 | Trempealeau | Wisconsin | 55121 | 8041 | 58 |
2170908 | 2170908 | 2022-01-31 | Trempealeau | Wisconsin | 55121 | 8030 | 58 |
2167655 | 2167655 | 2022-01-30 | Trempealeau | Wisconsin | 55121 | 7974 | 58 |
2164400 | 2164400 | 2022-01-29 | Trempealeau | Wisconsin | 55121 | 7974 | 58 |
2161145 | 2161145 | 2022-01-28 | Trempealeau | Wisconsin | 55121 | 7974 | 58 |
2157889 | 2157889 | 2022-01-27 | Trempealeau | Wisconsin | 55121 | 7906 | 58 |
2154636 | 2154636 | 2022-01-26 | Trempealeau | Wisconsin | 55121 | 7837 | 58 |
2151383 | 2151383 | 2022-01-25 | Trempealeau | Wisconsin | 55121 | 7787 | 58 |
2148131 | 2148131 | 2022-01-24 | Trempealeau | Wisconsin | 55121 | 7728 | 58 |
2144879 | 2144879 | 2022-01-23 | Trempealeau | Wisconsin | 55121 | 7596 | 58 |
2141624 | 2141624 | 2022-01-22 | Trempealeau | Wisconsin | 55121 | 7596 | 58 |
2138368 | 2138368 | 2022-01-21 | Trempealeau | Wisconsin | 55121 | 7596 | 58 |
2135113 | 2135113 | 2022-01-20 | Trempealeau | Wisconsin | 55121 | 7513 | 57 |
2131861 | 2131861 | 2022-01-19 | Trempealeau | Wisconsin | 55121 | 7415 | 57 |
2128607 | 2128607 | 2022-01-18 | Trempealeau | Wisconsin | 55121 | 7290 | 57 |
2125354 | 2125354 | 2022-01-17 | Trempealeau | Wisconsin | 55121 | 7218 | 56 |
2122102 | 2122102 | 2022-01-16 | Trempealeau | Wisconsin | 55121 | 6941 | 56 |
2118850 | 2118850 | 2022-01-15 | Trempealeau | Wisconsin | 55121 | 6941 | 56 |
2115598 | 2115598 | 2022-01-14 | Trempealeau | Wisconsin | 55121 | 6941 | 56 |
2112346 | 2112346 | 2022-01-13 | Trempealeau | Wisconsin | 55121 | 6833 | 56 |
2109094 | 2109094 | 2022-01-12 | Trempealeau | Wisconsin | 55121 | 6739 | 56 |
2105843 | 2105843 | 2022-01-11 | Trempealeau | Wisconsin | 55121 | 6653 | 56 |
2102592 | 2102592 | 2022-01-10 | Trempealeau | Wisconsin | 55121 | 6607 | 56 |
2099341 | 2099341 | 2022-01-09 | Trempealeau | Wisconsin | 55121 | 6466 | 56 |
2096090 | 2096090 | 2022-01-08 | Trempealeau | Wisconsin | 55121 | 6466 | 56 |
2092838 | 2092838 | 2022-01-07 | Trempealeau | Wisconsin | 55121 | 6466 | 56 |
2089586 | 2089586 | 2022-01-06 | Trempealeau | Wisconsin | 55121 | 6402 | 56 |
2086335 | 2086335 | 2022-01-05 | Trempealeau | Wisconsin | 55121 | 6330 | 56 |
2083083 | 2083083 | 2022-01-04 | Trempealeau | Wisconsin | 55121 | 6263 | 56 |
2079831 | 2079831 | 2022-01-03 | Trempealeau | Wisconsin | 55121 | 6243 | 55 |
2076579 | 2076579 | 2022-01-02 | Trempealeau | Wisconsin | 55121 | 6192 | 55 |
2073328 | 2073328 | 2022-01-01 | Trempealeau | Wisconsin | 55121 | 6192 | 55 |
2070077 | 2070077 | 2021-12-31 | Trempealeau | Wisconsin | 55121 | 6192 | 55 |
2066826 | 2066826 | 2021-12-30 | Trempealeau | Wisconsin | 55121 | 6148 | 55 |
2063576 | 2063576 | 2021-12-29 | Trempealeau | Wisconsin | 55121 | 6103 | 55 |
2060326 | 2060326 | 2021-12-28 | Trempealeau | Wisconsin | 55121 | 6069 | 54 |
2057077 | 2057077 | 2021-12-27 | Trempealeau | Wisconsin | 55121 | 6048 | 54 |
2053828 | 2053828 | 2021-12-26 | Trempealeau | Wisconsin | 55121 | 6011 | 54 |
2050578 | 2050578 | 2021-12-25 | Trempealeau | Wisconsin | 55121 | 6011 | 54 |
2047328 | 2047328 | 2021-12-24 | Trempealeau | Wisconsin | 55121 | 6011 | 54 |
2044078 | 2044078 | 2021-12-23 | Trempealeau | Wisconsin | 55121 | 6000 | 54 |
2040829 | 2040829 | 2021-12-22 | Trempealeau | Wisconsin | 55121 | 5974 | 54 |
2037579 | 2037579 | 2021-12-21 | Trempealeau | Wisconsin | 55121 | 5941 | 54 |
2034329 | 2034329 | 2021-12-20 | Trempealeau | Wisconsin | 55121 | 5919 | 54 |
2031079 | 2031079 | 2021-12-19 | Trempealeau | Wisconsin | 55121 | 5876 | 54 |
2027828 | 2027828 | 2021-12-18 | Trempealeau | Wisconsin | 55121 | 5876 | 54 |
2024577 | 2024577 | 2021-12-17 | Trempealeau | Wisconsin | 55121 | 5876 | 54 |
2021326 | 2021326 | 2021-12-16 | Trempealeau | Wisconsin | 55121 | 5859 | 54 |
2018075 | 2018075 | 2021-12-15 | Trempealeau | Wisconsin | 55121 | 5840 | 52 |
2014825 | 2014825 | 2021-12-14 | Trempealeau | Wisconsin | 55121 | 5816 | 52 |
2011574 | 2011574 | 2021-12-13 | Trempealeau | Wisconsin | 55121 | 5805 | 52 |
2008323 | 2008323 | 2021-12-12 | Trempealeau | Wisconsin | 55121 | 5754 | 52 |
2005072 | 2005072 | 2021-12-11 | Trempealeau | Wisconsin | 55121 | 5754 | 52 |
2001821 | 2001821 | 2021-12-10 | Trempealeau | Wisconsin | 55121 | 5754 | 52 |
1998571 | 1998571 | 2021-12-09 | Trempealeau | Wisconsin | 55121 | 5713 | 52 |
1995320 | 1995320 | 2021-12-08 | Trempealeau | Wisconsin | 55121 | 5689 | 52 |
1992069 | 1992069 | 2021-12-07 | Trempealeau | Wisconsin | 55121 | 5624 | 52 |
1988818 | 1988818 | 2021-12-06 | Trempealeau | Wisconsin | 55121 | 5624 | 52 |
1985568 | 1985568 | 2021-12-05 | Trempealeau | Wisconsin | 55121 | 5624 | 52 |
1982318 | 1982318 | 2021-12-04 | Trempealeau | Wisconsin | 55121 | 5624 | 52 |
1979068 | 1979068 | 2021-12-03 | Trempealeau | Wisconsin | 55121 | 5624 | 52 |
1975818 | 1975818 | 2021-12-02 | Trempealeau | Wisconsin | 55121 | 5609 | 52 |
1972569 | 1972569 | 2021-12-01 | Trempealeau | Wisconsin | 55121 | 5589 | 52 |
1969319 | 1969319 | 2021-11-30 | Trempealeau | Wisconsin | 55121 | 5565 | 52 |
1966069 | 1966069 | 2021-11-29 | Trempealeau | Wisconsin | 55121 | 5549 | 52 |
1962817 | 1962817 | 2021-11-28 | Trempealeau | Wisconsin | 55121 | 5507 | 52 |
1959566 | 1959566 | 2021-11-27 | Trempealeau | Wisconsin | 55121 | 5507 | 52 |
1956315 | 1956315 | 2021-11-26 | Trempealeau | Wisconsin | 55121 | 5507 | 52 |
1953064 | 1953064 | 2021-11-25 | Trempealeau | Wisconsin | 55121 | 5491 | 52 |
1949813 | 1949813 | 2021-11-24 | Trempealeau | Wisconsin | 55121 | 5467 | 52 |
1946562 | 1946562 | 2021-11-23 | Trempealeau | Wisconsin | 55121 | 5442 | 52 |
1943311 | 1943311 | 2021-11-22 | Trempealeau | Wisconsin | 55121 | 5427 | 52 |
1940061 | 1940061 | 2021-11-21 | Trempealeau | Wisconsin | 55121 | 5369 | 52 |
1936811 | 1936811 | 2021-11-20 | Trempealeau | Wisconsin | 55121 | 5369 | 52 |
1933561 | 1933561 | 2021-11-19 | Trempealeau | Wisconsin | 55121 | 5369 | 52 |
1930309 | 1930309 | 2021-11-18 | Trempealeau | Wisconsin | 55121 | 5344 | 52 |
1927059 | 1927059 | 2021-11-17 | Trempealeau | Wisconsin | 55121 | 5316 | 52 |
1923809 | 1923809 | 2021-11-16 | Trempealeau | Wisconsin | 55121 | 5287 | 52 |
1920560 | 1920560 | 2021-11-15 | Trempealeau | Wisconsin | 55121 | 5271 | 52 |
1917310 | 1917310 | 2021-11-14 | Trempealeau | Wisconsin | 55121 | 5228 | 52 |
1914060 | 1914060 | 2021-11-13 | Trempealeau | Wisconsin | 55121 | 5228 | 52 |
1910810 | 1910810 | 2021-11-12 | Trempealeau | Wisconsin | 55121 | 5228 | 52 |
1907561 | 1907561 | 2021-11-11 | Trempealeau | Wisconsin | 55121 | 5200 | 52 |
1904312 | 1904312 | 2021-11-10 | Trempealeau | Wisconsin | 55121 | 5168 | 52 |
1901062 | 1901062 | 2021-11-09 | Trempealeau | Wisconsin | 55121 | 5148 | 52 |
1897812 | 1897812 | 2021-11-08 | Trempealeau | Wisconsin | 55121 | 5139 | 52 |
1894562 | 1894562 | 2021-11-07 | Trempealeau | Wisconsin | 55121 | 5092 | 52 |
1891312 | 1891312 | 2021-11-06 | Trempealeau | Wisconsin | 55121 | 5092 | 52 |
1888062 | 1888062 | 2021-11-05 | Trempealeau | Wisconsin | 55121 | 5092 | 52 |
1884812 | 1884812 | 2021-11-04 | Trempealeau | Wisconsin | 55121 | 5073 | 52 |
1881563 | 1881563 | 2021-11-03 | Trempealeau | Wisconsin | 55121 | 5053 | 52 |
1878314 | 1878314 | 2021-11-02 | Trempealeau | Wisconsin | 55121 | 5037 | 52 |
1875065 | 1875065 | 2021-11-01 | Trempealeau | Wisconsin | 55121 | 5029 | 52 |
1871816 | 1871816 | 2021-10-31 | Trempealeau | Wisconsin | 55121 | 5000 | 52 |
1868567 | 1868567 | 2021-10-30 | Trempealeau | Wisconsin | 55121 | 5000 | 52 |
1865318 | 1865318 | 2021-10-29 | Trempealeau | Wisconsin | 55121 | 5000 | 52 |
1862069 | 1862069 | 2021-10-28 | Trempealeau | Wisconsin | 55121 | 4993 | 52 |
1858820 | 1858820 | 2021-10-27 | Trempealeau | Wisconsin | 55121 | 4976 | 52 |
1855571 | 1855571 | 2021-10-26 | Trempealeau | Wisconsin | 55121 | 4956 | 52 |
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);