ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "La Crosse" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1852292 | 1852292 | 2021-10-25 | La Crosse | Wisconsin | 55063 | 17266 | 111 |
1849042 | 1849042 | 2021-10-24 | La Crosse | Wisconsin | 55063 | 17186 | 110 |
1845792 | 1845792 | 2021-10-23 | La Crosse | Wisconsin | 55063 | 17186 | 110 |
1842542 | 1842542 | 2021-10-22 | La Crosse | Wisconsin | 55063 | 17186 | 110 |
1839293 | 1839293 | 2021-10-21 | La Crosse | Wisconsin | 55063 | 17147 | 110 |
1836044 | 1836044 | 2021-10-20 | La Crosse | Wisconsin | 55063 | 17110 | 109 |
1832795 | 1832795 | 2021-10-19 | La Crosse | Wisconsin | 55063 | 17041 | 109 |
1829546 | 1829546 | 2021-10-18 | La Crosse | Wisconsin | 55063 | 17034 | 109 |
1826297 | 1826297 | 2021-10-17 | La Crosse | Wisconsin | 55063 | 16966 | 109 |
1823048 | 1823048 | 2021-10-16 | La Crosse | Wisconsin | 55063 | 16882 | 109 |
1819799 | 1819799 | 2021-10-15 | La Crosse | Wisconsin | 55063 | 16882 | 109 |
1816550 | 1816550 | 2021-10-14 | La Crosse | Wisconsin | 55063 | 16882 | 109 |
1813302 | 1813302 | 2021-10-13 | La Crosse | Wisconsin | 55063 | 16838 | 109 |
1810053 | 1810053 | 2021-10-12 | La Crosse | Wisconsin | 55063 | 16786 | 108 |
1806804 | 1806804 | 2021-10-11 | La Crosse | Wisconsin | 55063 | 16732 | 107 |
1803553 | 1803553 | 2021-10-10 | La Crosse | Wisconsin | 55063 | 16634 | 106 |
1800304 | 1800304 | 2021-10-09 | La Crosse | Wisconsin | 55063 | 16634 | 106 |
1797055 | 1797055 | 2021-10-08 | La Crosse | Wisconsin | 55063 | 16634 | 106 |
1793806 | 1793806 | 2021-10-07 | La Crosse | Wisconsin | 55063 | 16578 | 105 |
1790557 | 1790557 | 2021-10-06 | La Crosse | Wisconsin | 55063 | 16522 | 105 |
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);