ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55045 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112307 | 2112307 | 2022-01-13 | Green | Wisconsin | 55045 | 7108 | 46 |
2109055 | 2109055 | 2022-01-12 | Green | Wisconsin | 55045 | 6988 | 46 |
2105804 | 2105804 | 2022-01-11 | Green | Wisconsin | 55045 | 6917 | 46 |
2102553 | 2102553 | 2022-01-10 | Green | Wisconsin | 55045 | 6839 | 46 |
2099302 | 2099302 | 2022-01-09 | Green | Wisconsin | 55045 | 6607 | 45 |
2096051 | 2096051 | 2022-01-08 | Green | Wisconsin | 55045 | 6607 | 45 |
2092799 | 2092799 | 2022-01-07 | Green | Wisconsin | 55045 | 6607 | 45 |
2089547 | 2089547 | 2022-01-06 | Green | Wisconsin | 55045 | 6545 | 45 |
2086296 | 2086296 | 2022-01-05 | Green | Wisconsin | 55045 | 6497 | 45 |
2083044 | 2083044 | 2022-01-04 | Green | Wisconsin | 55045 | 6435 | 45 |
2079792 | 2079792 | 2022-01-03 | Green | Wisconsin | 55045 | 6404 | 45 |
2076540 | 2076540 | 2022-01-02 | Green | Wisconsin | 55045 | 6299 | 45 |
2073289 | 2073289 | 2022-01-01 | Green | Wisconsin | 55045 | 6299 | 45 |
2070038 | 2070038 | 2021-12-31 | Green | Wisconsin | 55045 | 6299 | 45 |
2066787 | 2066787 | 2021-12-30 | Green | Wisconsin | 55045 | 6250 | 44 |
2063537 | 2063537 | 2021-12-29 | Green | Wisconsin | 55045 | 6203 | 44 |
2060287 | 2060287 | 2021-12-28 | Green | Wisconsin | 55045 | 6181 | 44 |
2057038 | 2057038 | 2021-12-27 | Green | Wisconsin | 55045 | 6167 | 43 |
2053789 | 2053789 | 2021-12-26 | Green | Wisconsin | 55045 | 6107 | 42 |
2050539 | 2050539 | 2021-12-25 | Green | Wisconsin | 55045 | 6107 | 42 |
2047289 | 2047289 | 2021-12-24 | Green | Wisconsin | 55045 | 6107 | 42 |
2044039 | 2044039 | 2021-12-23 | Green | Wisconsin | 55045 | 6086 | 42 |
2040790 | 2040790 | 2021-12-22 | Green | Wisconsin | 55045 | 6061 | 40 |
2037540 | 2037540 | 2021-12-21 | Green | Wisconsin | 55045 | 6028 | 40 |
2034290 | 2034290 | 2021-12-20 | Green | Wisconsin | 55045 | 5995 | 40 |
2031040 | 2031040 | 2021-12-19 | Green | Wisconsin | 55045 | 5924 | 40 |
2027789 | 2027789 | 2021-12-18 | Green | Wisconsin | 55045 | 5924 | 40 |
2024538 | 2024538 | 2021-12-17 | Green | Wisconsin | 55045 | 5924 | 40 |
2021287 | 2021287 | 2021-12-16 | Green | Wisconsin | 55045 | 5893 | 40 |
2018036 | 2018036 | 2021-12-15 | Green | Wisconsin | 55045 | 5856 | 40 |
2014786 | 2014786 | 2021-12-14 | Green | Wisconsin | 55045 | 5837 | 39 |
2011535 | 2011535 | 2021-12-13 | Green | Wisconsin | 55045 | 5817 | 39 |
2008284 | 2008284 | 2021-12-12 | Green | Wisconsin | 55045 | 5739 | 38 |
2005033 | 2005033 | 2021-12-11 | Green | Wisconsin | 55045 | 5739 | 38 |
2001782 | 2001782 | 2021-12-10 | Green | Wisconsin | 55045 | 5739 | 38 |
1998532 | 1998532 | 2021-12-09 | Green | Wisconsin | 55045 | 5696 | 38 |
1995281 | 1995281 | 2021-12-08 | Green | Wisconsin | 55045 | 5652 | 38 |
1992030 | 1992030 | 2021-12-07 | Green | Wisconsin | 55045 | 5537 | 38 |
1988779 | 1988779 | 2021-12-06 | Green | Wisconsin | 55045 | 5537 | 38 |
1985529 | 1985529 | 2021-12-05 | Green | Wisconsin | 55045 | 5537 | 38 |
1982279 | 1982279 | 2021-12-04 | Green | Wisconsin | 55045 | 5537 | 38 |
1979029 | 1979029 | 2021-12-03 | Green | Wisconsin | 55045 | 5537 | 38 |
1975779 | 1975779 | 2021-12-02 | Green | Wisconsin | 55045 | 5500 | 38 |
1972530 | 1972530 | 2021-12-01 | Green | Wisconsin | 55045 | 5465 | 37 |
1969280 | 1969280 | 2021-11-30 | Green | Wisconsin | 55045 | 5426 | 37 |
1966030 | 1966030 | 2021-11-29 | Green | Wisconsin | 55045 | 5407 | 37 |
1962778 | 1962778 | 2021-11-28 | Green | Wisconsin | 55045 | 5349 | 36 |
1959527 | 1959527 | 2021-11-27 | Green | Wisconsin | 55045 | 5349 | 36 |
1956276 | 1956276 | 2021-11-26 | Green | Wisconsin | 55045 | 5349 | 36 |
1953025 | 1953025 | 2021-11-25 | Green | Wisconsin | 55045 | 5314 | 36 |
1949774 | 1949774 | 2021-11-24 | Green | Wisconsin | 55045 | 5286 | 37 |
1946523 | 1946523 | 2021-11-23 | Green | Wisconsin | 55045 | 5253 | 35 |
1943272 | 1943272 | 2021-11-22 | Green | Wisconsin | 55045 | 5235 | 35 |
1940022 | 1940022 | 2021-11-21 | Green | Wisconsin | 55045 | 5167 | 35 |
1936772 | 1936772 | 2021-11-20 | Green | Wisconsin | 55045 | 5167 | 35 |
1933522 | 1933522 | 2021-11-19 | Green | Wisconsin | 55045 | 5167 | 35 |
1930270 | 1930270 | 2021-11-18 | Green | Wisconsin | 55045 | 5146 | 35 |
1927020 | 1927020 | 2021-11-17 | Green | Wisconsin | 55045 | 5090 | 35 |
1923770 | 1923770 | 2021-11-16 | Green | Wisconsin | 55045 | 5067 | 35 |
1920521 | 1920521 | 2021-11-15 | Green | Wisconsin | 55045 | 5044 | 35 |
1917271 | 1917271 | 2021-11-14 | Green | Wisconsin | 55045 | 4959 | 34 |
1914021 | 1914021 | 2021-11-13 | Green | Wisconsin | 55045 | 4959 | 34 |
1910771 | 1910771 | 2021-11-12 | Green | Wisconsin | 55045 | 4959 | 34 |
1907522 | 1907522 | 2021-11-11 | Green | Wisconsin | 55045 | 4943 | 34 |
1904273 | 1904273 | 2021-11-10 | Green | Wisconsin | 55045 | 4907 | 34 |
1901023 | 1901023 | 2021-11-09 | Green | Wisconsin | 55045 | 4875 | 34 |
1897773 | 1897773 | 2021-11-08 | Green | Wisconsin | 55045 | 4858 | 34 |
1894523 | 1894523 | 2021-11-07 | Green | Wisconsin | 55045 | 4785 | 34 |
1891273 | 1891273 | 2021-11-06 | Green | Wisconsin | 55045 | 4785 | 34 |
1888023 | 1888023 | 2021-11-05 | Green | Wisconsin | 55045 | 4785 | 34 |
1884773 | 1884773 | 2021-11-04 | Green | Wisconsin | 55045 | 4757 | 34 |
1881524 | 1881524 | 2021-11-03 | Green | Wisconsin | 55045 | 4728 | 34 |
1878275 | 1878275 | 2021-11-02 | Green | Wisconsin | 55045 | 4712 | 33 |
1875026 | 1875026 | 2021-11-01 | Green | Wisconsin | 55045 | 4705 | 33 |
1871777 | 1871777 | 2021-10-31 | Green | Wisconsin | 55045 | 4657 | 33 |
1868528 | 1868528 | 2021-10-30 | Green | Wisconsin | 55045 | 4657 | 33 |
1865279 | 1865279 | 2021-10-29 | Green | Wisconsin | 55045 | 4657 | 33 |
1862030 | 1862030 | 2021-10-28 | Green | Wisconsin | 55045 | 4628 | 33 |
1858781 | 1858781 | 2021-10-27 | Green | Wisconsin | 55045 | 4618 | 31 |
1855532 | 1855532 | 2021-10-26 | Green | Wisconsin | 55045 | 4610 | 31 |
1852283 | 1852283 | 2021-10-25 | Green | Wisconsin | 55045 | 4598 | 31 |
1849033 | 1849033 | 2021-10-24 | Green | Wisconsin | 55045 | 4565 | 30 |
1845783 | 1845783 | 2021-10-23 | Green | Wisconsin | 55045 | 4565 | 30 |
1842533 | 1842533 | 2021-10-22 | Green | Wisconsin | 55045 | 4565 | 30 |
1839284 | 1839284 | 2021-10-21 | Green | Wisconsin | 55045 | 4545 | 30 |
1836035 | 1836035 | 2021-10-20 | Green | Wisconsin | 55045 | 4522 | 30 |
1832786 | 1832786 | 2021-10-19 | Green | Wisconsin | 55045 | 4509 | 29 |
1829537 | 1829537 | 2021-10-18 | Green | Wisconsin | 55045 | 4498 | 29 |
1826288 | 1826288 | 2021-10-17 | Green | Wisconsin | 55045 | 4474 | 29 |
1823039 | 1823039 | 2021-10-16 | Green | Wisconsin | 55045 | 4432 | 29 |
1819790 | 1819790 | 2021-10-15 | Green | Wisconsin | 55045 | 4432 | 29 |
1816541 | 1816541 | 2021-10-14 | Green | Wisconsin | 55045 | 4432 | 29 |
1813293 | 1813293 | 2021-10-13 | Green | Wisconsin | 55045 | 4418 | 29 |
1810044 | 1810044 | 2021-10-12 | Green | Wisconsin | 55045 | 4402 | 29 |
1806795 | 1806795 | 2021-10-11 | Green | Wisconsin | 55045 | 4393 | 29 |
1803544 | 1803544 | 2021-10-10 | Green | Wisconsin | 55045 | 4365 | 28 |
1800295 | 1800295 | 2021-10-09 | Green | Wisconsin | 55045 | 4365 | 28 |
1797046 | 1797046 | 2021-10-08 | Green | Wisconsin | 55045 | 4365 | 28 |
1793797 | 1793797 | 2021-10-07 | Green | Wisconsin | 55045 | 4350 | 28 |
1790548 | 1790548 | 2021-10-06 | Green | Wisconsin | 55045 | 4343 | 26 |
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);