ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 55063 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177383 | 2177383 | 2022-02-02 | La Crosse | Wisconsin | 55063 | 32708 | 154 |
2174130 | 2174130 | 2022-02-01 | La Crosse | Wisconsin | 55063 | 32571 | 153 |
2170878 | 2170878 | 2022-01-31 | La Crosse | Wisconsin | 55063 | 32379 | 152 |
2167625 | 2167625 | 2022-01-30 | La Crosse | Wisconsin | 55063 | 32100 | 151 |
2164370 | 2164370 | 2022-01-29 | La Crosse | Wisconsin | 55063 | 32100 | 151 |
2161115 | 2161115 | 2022-01-28 | La Crosse | Wisconsin | 55063 | 32100 | 151 |
2157859 | 2157859 | 2022-01-27 | La Crosse | Wisconsin | 55063 | 31875 | 151 |
2154606 | 2154606 | 2022-01-26 | La Crosse | Wisconsin | 55063 | 31600 | 151 |
2151353 | 2151353 | 2022-01-25 | La Crosse | Wisconsin | 55063 | 31325 | 150 |
2148101 | 2148101 | 2022-01-24 | La Crosse | Wisconsin | 55063 | 30933 | 150 |
2144849 | 2144849 | 2022-01-23 | La Crosse | Wisconsin | 55063 | 30327 | 149 |
2141594 | 2141594 | 2022-01-22 | La Crosse | Wisconsin | 55063 | 30327 | 149 |
2138338 | 2138338 | 2022-01-21 | La Crosse | Wisconsin | 55063 | 30327 | 149 |
2135083 | 2135083 | 2022-01-20 | La Crosse | Wisconsin | 55063 | 29788 | 147 |
2131831 | 2131831 | 2022-01-19 | La Crosse | Wisconsin | 55063 | 29151 | 146 |
2128577 | 2128577 | 2022-01-18 | La Crosse | Wisconsin | 55063 | 28645 | 146 |
2125324 | 2125324 | 2022-01-17 | La Crosse | Wisconsin | 55063 | 28345 | 145 |
2122072 | 2122072 | 2022-01-16 | La Crosse | Wisconsin | 55063 | 27413 | 143 |
2118820 | 2118820 | 2022-01-15 | La Crosse | Wisconsin | 55063 | 27413 | 143 |
2115568 | 2115568 | 2022-01-14 | La Crosse | Wisconsin | 55063 | 27413 | 143 |
2112316 | 2112316 | 2022-01-13 | La Crosse | Wisconsin | 55063 | 26579 | 143 |
2109064 | 2109064 | 2022-01-12 | La Crosse | Wisconsin | 55063 | 25899 | 142 |
2105813 | 2105813 | 2022-01-11 | La Crosse | Wisconsin | 55063 | 25431 | 141 |
2102562 | 2102562 | 2022-01-10 | La Crosse | Wisconsin | 55063 | 25192 | 141 |
2099311 | 2099311 | 2022-01-09 | La Crosse | Wisconsin | 55063 | 24320 | 141 |
2096060 | 2096060 | 2022-01-08 | La Crosse | Wisconsin | 55063 | 24320 | 141 |
2092808 | 2092808 | 2022-01-07 | La Crosse | Wisconsin | 55063 | 24320 | 141 |
2089556 | 2089556 | 2022-01-06 | La Crosse | Wisconsin | 55063 | 23904 | 139 |
2086305 | 2086305 | 2022-01-05 | La Crosse | Wisconsin | 55063 | 23510 | 139 |
2083053 | 2083053 | 2022-01-04 | La Crosse | Wisconsin | 55063 | 23040 | 139 |
2079801 | 2079801 | 2022-01-03 | La Crosse | Wisconsin | 55063 | 22639 | 139 |
2076549 | 2076549 | 2022-01-02 | La Crosse | Wisconsin | 55063 | 22297 | 139 |
2073298 | 2073298 | 2022-01-01 | La Crosse | Wisconsin | 55063 | 22297 | 139 |
2070047 | 2070047 | 2021-12-31 | La Crosse | Wisconsin | 55063 | 22297 | 139 |
2066796 | 2066796 | 2021-12-30 | La Crosse | Wisconsin | 55063 | 22210 | 139 |
2063546 | 2063546 | 2021-12-29 | La Crosse | Wisconsin | 55063 | 22106 | 139 |
2060296 | 2060296 | 2021-12-28 | La Crosse | Wisconsin | 55063 | 21895 | 139 |
2057047 | 2057047 | 2021-12-27 | La Crosse | Wisconsin | 55063 | 21797 | 139 |
2053798 | 2053798 | 2021-12-26 | La Crosse | Wisconsin | 55063 | 21664 | 139 |
2050548 | 2050548 | 2021-12-25 | La Crosse | Wisconsin | 55063 | 21664 | 139 |
2047298 | 2047298 | 2021-12-24 | La Crosse | Wisconsin | 55063 | 21664 | 139 |
2044048 | 2044048 | 2021-12-23 | La Crosse | Wisconsin | 55063 | 21507 | 139 |
2040799 | 2040799 | 2021-12-22 | La Crosse | Wisconsin | 55063 | 21421 | 139 |
2037549 | 2037549 | 2021-12-21 | La Crosse | Wisconsin | 55063 | 21257 | 139 |
2034299 | 2034299 | 2021-12-20 | La Crosse | Wisconsin | 55063 | 21191 | 139 |
2031049 | 2031049 | 2021-12-19 | La Crosse | Wisconsin | 55063 | 21046 | 139 |
2027798 | 2027798 | 2021-12-18 | La Crosse | Wisconsin | 55063 | 21046 | 139 |
2024547 | 2024547 | 2021-12-17 | La Crosse | Wisconsin | 55063 | 21046 | 139 |
2021296 | 2021296 | 2021-12-16 | La Crosse | Wisconsin | 55063 | 20961 | 137 |
2018045 | 2018045 | 2021-12-15 | La Crosse | Wisconsin | 55063 | 20868 | 136 |
2014795 | 2014795 | 2021-12-14 | La Crosse | Wisconsin | 55063 | 20778 | 134 |
2011544 | 2011544 | 2021-12-13 | La Crosse | Wisconsin | 55063 | 20736 | 134 |
2008293 | 2008293 | 2021-12-12 | La Crosse | Wisconsin | 55063 | 20509 | 130 |
2005042 | 2005042 | 2021-12-11 | La Crosse | Wisconsin | 55063 | 20509 | 130 |
2001791 | 2001791 | 2021-12-10 | La Crosse | Wisconsin | 55063 | 20509 | 130 |
1998541 | 1998541 | 2021-12-09 | La Crosse | Wisconsin | 55063 | 20341 | 130 |
1995290 | 1995290 | 2021-12-08 | La Crosse | Wisconsin | 55063 | 20252 | 128 |
1992039 | 1992039 | 2021-12-07 | La Crosse | Wisconsin | 55063 | 19958 | 128 |
1988788 | 1988788 | 2021-12-06 | La Crosse | Wisconsin | 55063 | 19958 | 128 |
1985538 | 1985538 | 2021-12-05 | La Crosse | Wisconsin | 55063 | 19958 | 128 |
1982288 | 1982288 | 2021-12-04 | La Crosse | Wisconsin | 55063 | 19958 | 128 |
1979038 | 1979038 | 2021-12-03 | La Crosse | Wisconsin | 55063 | 19958 | 128 |
1975788 | 1975788 | 2021-12-02 | La Crosse | Wisconsin | 55063 | 19850 | 125 |
1972539 | 1972539 | 2021-12-01 | La Crosse | Wisconsin | 55063 | 19731 | 125 |
1969289 | 1969289 | 2021-11-30 | La Crosse | Wisconsin | 55063 | 19597 | 125 |
1966039 | 1966039 | 2021-11-29 | La Crosse | Wisconsin | 55063 | 19478 | 124 |
1962787 | 1962787 | 2021-11-28 | La Crosse | Wisconsin | 55063 | 19248 | 123 |
1959536 | 1959536 | 2021-11-27 | La Crosse | Wisconsin | 55063 | 19248 | 123 |
1956285 | 1956285 | 2021-11-26 | La Crosse | Wisconsin | 55063 | 19248 | 123 |
1953034 | 1953034 | 2021-11-25 | La Crosse | Wisconsin | 55063 | 19250 | 123 |
1949783 | 1949783 | 2021-11-24 | La Crosse | Wisconsin | 55063 | 19198 | 123 |
1946532 | 1946532 | 2021-11-23 | La Crosse | Wisconsin | 55063 | 19097 | 123 |
1943281 | 1943281 | 2021-11-22 | La Crosse | Wisconsin | 55063 | 19043 | 123 |
1940031 | 1940031 | 2021-11-21 | La Crosse | Wisconsin | 55063 | 18877 | 123 |
1936781 | 1936781 | 2021-11-20 | La Crosse | Wisconsin | 55063 | 18877 | 123 |
1933531 | 1933531 | 2021-11-19 | La Crosse | Wisconsin | 55063 | 18877 | 123 |
1930279 | 1930279 | 2021-11-18 | La Crosse | Wisconsin | 55063 | 18807 | 123 |
1927029 | 1927029 | 2021-11-17 | La Crosse | Wisconsin | 55063 | 18696 | 121 |
1923779 | 1923779 | 2021-11-16 | La Crosse | Wisconsin | 55063 | 18624 | 121 |
1920530 | 1920530 | 2021-11-15 | La Crosse | Wisconsin | 55063 | 18554 | 120 |
1917280 | 1917280 | 2021-11-14 | La Crosse | Wisconsin | 55063 | 18316 | 117 |
1914030 | 1914030 | 2021-11-13 | La Crosse | Wisconsin | 55063 | 18316 | 117 |
1910780 | 1910780 | 2021-11-12 | La Crosse | Wisconsin | 55063 | 18316 | 117 |
1907531 | 1907531 | 2021-11-11 | La Crosse | Wisconsin | 55063 | 18262 | 117 |
1904282 | 1904282 | 2021-11-10 | La Crosse | Wisconsin | 55063 | 18150 | 117 |
1901032 | 1901032 | 2021-11-09 | La Crosse | Wisconsin | 55063 | 18079 | 117 |
1897782 | 1897782 | 2021-11-08 | La Crosse | Wisconsin | 55063 | 18003 | 116 |
1894532 | 1894532 | 2021-11-07 | La Crosse | Wisconsin | 55063 | 17832 | 116 |
1891282 | 1891282 | 2021-11-06 | La Crosse | Wisconsin | 55063 | 17832 | 116 |
1888032 | 1888032 | 2021-11-05 | La Crosse | Wisconsin | 55063 | 17832 | 116 |
1884782 | 1884782 | 2021-11-04 | La Crosse | Wisconsin | 55063 | 17759 | 115 |
1881533 | 1881533 | 2021-11-03 | La Crosse | Wisconsin | 55063 | 17707 | 114 |
1878284 | 1878284 | 2021-11-02 | La Crosse | Wisconsin | 55063 | 17636 | 114 |
1875035 | 1875035 | 2021-11-01 | La Crosse | Wisconsin | 55063 | 17579 | 113 |
1871786 | 1871786 | 2021-10-31 | La Crosse | Wisconsin | 55063 | 17465 | 112 |
1868537 | 1868537 | 2021-10-30 | La Crosse | Wisconsin | 55063 | 17465 | 112 |
1865288 | 1865288 | 2021-10-29 | La Crosse | Wisconsin | 55063 | 17465 | 112 |
1862039 | 1862039 | 2021-10-28 | La Crosse | Wisconsin | 55063 | 17411 | 111 |
1858790 | 1858790 | 2021-10-27 | La Crosse | Wisconsin | 55063 | 17367 | 111 |
1855541 | 1855541 | 2021-10-26 | La Crosse | Wisconsin | 55063 | 17314 | 111 |
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);