ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
743 rows where county = "Lincoln" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177386 | 2177386 | 2022-02-02 | Lincoln | Wisconsin | 55069 | 6712 | 130 |
2174133 | 2174133 | 2022-02-01 | Lincoln | Wisconsin | 55069 | 6672 | 129 |
2170881 | 2170881 | 2022-01-31 | Lincoln | Wisconsin | 55069 | 6669 | 128 |
2167628 | 2167628 | 2022-01-30 | Lincoln | Wisconsin | 55069 | 6597 | 128 |
2164373 | 2164373 | 2022-01-29 | Lincoln | Wisconsin | 55069 | 6597 | 128 |
2161118 | 2161118 | 2022-01-28 | Lincoln | Wisconsin | 55069 | 6597 | 128 |
2157862 | 2157862 | 2022-01-27 | Lincoln | Wisconsin | 55069 | 6552 | 126 |
2154609 | 2154609 | 2022-01-26 | Lincoln | Wisconsin | 55069 | 6495 | 126 |
2151356 | 2151356 | 2022-01-25 | Lincoln | Wisconsin | 55069 | 6452 | 126 |
2148104 | 2148104 | 2022-01-24 | Lincoln | Wisconsin | 55069 | 6422 | 126 |
2144852 | 2144852 | 2022-01-23 | Lincoln | Wisconsin | 55069 | 6320 | 126 |
2141597 | 2141597 | 2022-01-22 | Lincoln | Wisconsin | 55069 | 6320 | 126 |
2138341 | 2138341 | 2022-01-21 | Lincoln | Wisconsin | 55069 | 6320 | 126 |
2135086 | 2135086 | 2022-01-20 | Lincoln | Wisconsin | 55069 | 6257 | 126 |
2131834 | 2131834 | 2022-01-19 | Lincoln | Wisconsin | 55069 | 6205 | 125 |
2128580 | 2128580 | 2022-01-18 | Lincoln | Wisconsin | 55069 | 6154 | 125 |
2125327 | 2125327 | 2022-01-17 | Lincoln | Wisconsin | 55069 | 6116 | 125 |
2122075 | 2122075 | 2022-01-16 | Lincoln | Wisconsin | 55069 | 5976 | 125 |
2118823 | 2118823 | 2022-01-15 | Lincoln | Wisconsin | 55069 | 5976 | 125 |
2115571 | 2115571 | 2022-01-14 | Lincoln | Wisconsin | 55069 | 5976 | 125 |
2112319 | 2112319 | 2022-01-13 | Lincoln | Wisconsin | 55069 | 5887 | 125 |
2109067 | 2109067 | 2022-01-12 | Lincoln | Wisconsin | 55069 | 5837 | 125 |
2105816 | 2105816 | 2022-01-11 | Lincoln | Wisconsin | 55069 | 5805 | 125 |
2102565 | 2102565 | 2022-01-10 | Lincoln | Wisconsin | 55069 | 5726 | 125 |
2099314 | 2099314 | 2022-01-09 | Lincoln | Wisconsin | 55069 | 5639 | 125 |
2096063 | 2096063 | 2022-01-08 | Lincoln | Wisconsin | 55069 | 5639 | 125 |
2092811 | 2092811 | 2022-01-07 | Lincoln | Wisconsin | 55069 | 5639 | 125 |
2089559 | 2089559 | 2022-01-06 | Lincoln | Wisconsin | 55069 | 5589 | 125 |
2086308 | 2086308 | 2022-01-05 | Lincoln | Wisconsin | 55069 | 5540 | 125 |
2083056 | 2083056 | 2022-01-04 | Lincoln | Wisconsin | 55069 | 5495 | 125 |
2079804 | 2079804 | 2022-01-03 | Lincoln | Wisconsin | 55069 | 5458 | 125 |
2076552 | 2076552 | 2022-01-02 | Lincoln | Wisconsin | 55069 | 5413 | 125 |
2073301 | 2073301 | 2022-01-01 | Lincoln | Wisconsin | 55069 | 5413 | 125 |
2070050 | 2070050 | 2021-12-31 | Lincoln | Wisconsin | 55069 | 5413 | 125 |
2066799 | 2066799 | 2021-12-30 | Lincoln | Wisconsin | 55069 | 5386 | 125 |
2063549 | 2063549 | 2021-12-29 | Lincoln | Wisconsin | 55069 | 5368 | 126 |
2060299 | 2060299 | 2021-12-28 | Lincoln | Wisconsin | 55069 | 5333 | 126 |
2057050 | 2057050 | 2021-12-27 | Lincoln | Wisconsin | 55069 | 5324 | 126 |
2053801 | 2053801 | 2021-12-26 | Lincoln | Wisconsin | 55069 | 5318 | 126 |
2050551 | 2050551 | 2021-12-25 | Lincoln | Wisconsin | 55069 | 5318 | 126 |
2047301 | 2047301 | 2021-12-24 | Lincoln | Wisconsin | 55069 | 5318 | 126 |
2044051 | 2044051 | 2021-12-23 | Lincoln | Wisconsin | 55069 | 5288 | 126 |
2040802 | 2040802 | 2021-12-22 | Lincoln | Wisconsin | 55069 | 5272 | 124 |
2037552 | 2037552 | 2021-12-21 | Lincoln | Wisconsin | 55069 | 5254 | 123 |
2034302 | 2034302 | 2021-12-20 | Lincoln | Wisconsin | 55069 | 5237 | 122 |
2031052 | 2031052 | 2021-12-19 | Lincoln | Wisconsin | 55069 | 5214 | 122 |
2027801 | 2027801 | 2021-12-18 | Lincoln | Wisconsin | 55069 | 5214 | 122 |
2024550 | 2024550 | 2021-12-17 | Lincoln | Wisconsin | 55069 | 5214 | 122 |
2021299 | 2021299 | 2021-12-16 | Lincoln | Wisconsin | 55069 | 5201 | 122 |
2018048 | 2018048 | 2021-12-15 | Lincoln | Wisconsin | 55069 | 5180 | 121 |
2014798 | 2014798 | 2021-12-14 | Lincoln | Wisconsin | 55069 | 5149 | 120 |
2011547 | 2011547 | 2021-12-13 | Lincoln | Wisconsin | 55069 | 5129 | 120 |
2008296 | 2008296 | 2021-12-12 | Lincoln | Wisconsin | 55069 | 5098 | 120 |
2005045 | 2005045 | 2021-12-11 | Lincoln | Wisconsin | 55069 | 5098 | 120 |
2001794 | 2001794 | 2021-12-10 | Lincoln | Wisconsin | 55069 | 5098 | 120 |
1998544 | 1998544 | 2021-12-09 | Lincoln | Wisconsin | 55069 | 5067 | 120 |
1995293 | 1995293 | 2021-12-08 | Lincoln | Wisconsin | 55069 | 5043 | 120 |
1992042 | 1992042 | 2021-12-07 | Lincoln | Wisconsin | 55069 | 4957 | 120 |
1988791 | 1988791 | 2021-12-06 | Lincoln | Wisconsin | 55069 | 4957 | 120 |
1985541 | 1985541 | 2021-12-05 | Lincoln | Wisconsin | 55069 | 4957 | 120 |
1982291 | 1982291 | 2021-12-04 | Lincoln | Wisconsin | 55069 | 4957 | 120 |
1979041 | 1979041 | 2021-12-03 | Lincoln | Wisconsin | 55069 | 4957 | 120 |
1975791 | 1975791 | 2021-12-02 | Lincoln | Wisconsin | 55069 | 4925 | 118 |
1972542 | 1972542 | 2021-12-01 | Lincoln | Wisconsin | 55069 | 4901 | 116 |
1969292 | 1969292 | 2021-11-30 | Lincoln | Wisconsin | 55069 | 4875 | 116 |
1966042 | 1966042 | 2021-11-29 | Lincoln | Wisconsin | 55069 | 4852 | 116 |
1962790 | 1962790 | 2021-11-28 | Lincoln | Wisconsin | 55069 | 4840 | 116 |
1959539 | 1959539 | 2021-11-27 | Lincoln | Wisconsin | 55069 | 4840 | 116 |
1956288 | 1956288 | 2021-11-26 | Lincoln | Wisconsin | 55069 | 4840 | 116 |
1953037 | 1953037 | 2021-11-25 | Lincoln | Wisconsin | 55069 | 4838 | 116 |
1949786 | 1949786 | 2021-11-24 | Lincoln | Wisconsin | 55069 | 4828 | 116 |
1946535 | 1946535 | 2021-11-23 | Lincoln | Wisconsin | 55069 | 4807 | 113 |
1943284 | 1943284 | 2021-11-22 | Lincoln | Wisconsin | 55069 | 4792 | 113 |
1940034 | 1940034 | 2021-11-21 | Lincoln | Wisconsin | 55069 | 4765 | 113 |
1936784 | 1936784 | 2021-11-20 | Lincoln | Wisconsin | 55069 | 4765 | 113 |
1933534 | 1933534 | 2021-11-19 | Lincoln | Wisconsin | 55069 | 4765 | 113 |
1930282 | 1930282 | 2021-11-18 | Lincoln | Wisconsin | 55069 | 4749 | 113 |
1927032 | 1927032 | 2021-11-17 | Lincoln | Wisconsin | 55069 | 4732 | 113 |
1923782 | 1923782 | 2021-11-16 | Lincoln | Wisconsin | 55069 | 4714 | 113 |
1920533 | 1920533 | 2021-11-15 | Lincoln | Wisconsin | 55069 | 4682 | 113 |
1917283 | 1917283 | 2021-11-14 | Lincoln | Wisconsin | 55069 | 4648 | 113 |
1914033 | 1914033 | 2021-11-13 | Lincoln | Wisconsin | 55069 | 4648 | 113 |
1910783 | 1910783 | 2021-11-12 | Lincoln | Wisconsin | 55069 | 4648 | 113 |
1907534 | 1907534 | 2021-11-11 | Lincoln | Wisconsin | 55069 | 4631 | 113 |
1904285 | 1904285 | 2021-11-10 | Lincoln | Wisconsin | 55069 | 4609 | 113 |
1901035 | 1901035 | 2021-11-09 | Lincoln | Wisconsin | 55069 | 4595 | 112 |
1897785 | 1897785 | 2021-11-08 | Lincoln | Wisconsin | 55069 | 4565 | 112 |
1894535 | 1894535 | 2021-11-07 | Lincoln | Wisconsin | 55069 | 4535 | 112 |
1891285 | 1891285 | 2021-11-06 | Lincoln | Wisconsin | 55069 | 4535 | 112 |
1888035 | 1888035 | 2021-11-05 | Lincoln | Wisconsin | 55069 | 4535 | 112 |
1884785 | 1884785 | 2021-11-04 | Lincoln | Wisconsin | 55069 | 4520 | 112 |
1881536 | 1881536 | 2021-11-03 | Lincoln | Wisconsin | 55069 | 4493 | 112 |
1878287 | 1878287 | 2021-11-02 | Lincoln | Wisconsin | 55069 | 4480 | 111 |
1875038 | 1875038 | 2021-11-01 | Lincoln | Wisconsin | 55069 | 4452 | 110 |
1871789 | 1871789 | 2021-10-31 | Lincoln | Wisconsin | 55069 | 4432 | 110 |
1868540 | 1868540 | 2021-10-30 | Lincoln | Wisconsin | 55069 | 4432 | 110 |
1865291 | 1865291 | 2021-10-29 | Lincoln | Wisconsin | 55069 | 4432 | 110 |
1862042 | 1862042 | 2021-10-28 | Lincoln | Wisconsin | 55069 | 4407 | 110 |
1858793 | 1858793 | 2021-10-27 | Lincoln | Wisconsin | 55069 | 4386 | 110 |
1855544 | 1855544 | 2021-10-26 | Lincoln | Wisconsin | 55069 | 4371 | 110 |
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);