ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Juneau" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112313 | 2112313 | 2022-01-13 | Juneau | Wisconsin | 55057 | 6245 | 55 |
2109061 | 2109061 | 2022-01-12 | Juneau | Wisconsin | 55057 | 6198 | 54 |
2105810 | 2105810 | 2022-01-11 | Juneau | Wisconsin | 55057 | 6080 | 54 |
2102559 | 2102559 | 2022-01-10 | Juneau | Wisconsin | 55057 | 5939 | 54 |
2099308 | 2099308 | 2022-01-09 | Juneau | Wisconsin | 55057 | 5785 | 54 |
2096057 | 2096057 | 2022-01-08 | Juneau | Wisconsin | 55057 | 5785 | 54 |
2092805 | 2092805 | 2022-01-07 | Juneau | Wisconsin | 55057 | 5785 | 54 |
2089553 | 2089553 | 2022-01-06 | Juneau | Wisconsin | 55057 | 5725 | 54 |
2086302 | 2086302 | 2022-01-05 | Juneau | Wisconsin | 55057 | 5711 | 54 |
2083050 | 2083050 | 2022-01-04 | Juneau | Wisconsin | 55057 | 5643 | 53 |
2079798 | 2079798 | 2022-01-03 | Juneau | Wisconsin | 55057 | 5622 | 50 |
2076546 | 2076546 | 2022-01-02 | Juneau | Wisconsin | 55057 | 5569 | 50 |
2073295 | 2073295 | 2022-01-01 | Juneau | Wisconsin | 55057 | 5569 | 50 |
2070044 | 2070044 | 2021-12-31 | Juneau | Wisconsin | 55057 | 5569 | 50 |
2066793 | 2066793 | 2021-12-30 | Juneau | Wisconsin | 55057 | 5551 | 50 |
2063543 | 2063543 | 2021-12-29 | Juneau | Wisconsin | 55057 | 5527 | 50 |
2060293 | 2060293 | 2021-12-28 | Juneau | Wisconsin | 55057 | 5517 | 50 |
2057044 | 2057044 | 2021-12-27 | Juneau | Wisconsin | 55057 | 5496 | 50 |
2053795 | 2053795 | 2021-12-26 | Juneau | Wisconsin | 55057 | 5478 | 50 |
2050545 | 2050545 | 2021-12-25 | Juneau | Wisconsin | 55057 | 5478 | 50 |
2047295 | 2047295 | 2021-12-24 | Juneau | Wisconsin | 55057 | 5478 | 50 |
2044045 | 2044045 | 2021-12-23 | Juneau | Wisconsin | 55057 | 5467 | 50 |
2040796 | 2040796 | 2021-12-22 | Juneau | Wisconsin | 55057 | 5444 | 49 |
2037546 | 2037546 | 2021-12-21 | Juneau | Wisconsin | 55057 | 5436 | 49 |
2034296 | 2034296 | 2021-12-20 | Juneau | Wisconsin | 55057 | 5421 | 48 |
2031046 | 2031046 | 2021-12-19 | Juneau | Wisconsin | 55057 | 5389 | 48 |
2027795 | 2027795 | 2021-12-18 | Juneau | Wisconsin | 55057 | 5389 | 48 |
2024544 | 2024544 | 2021-12-17 | Juneau | Wisconsin | 55057 | 5389 | 48 |
2021293 | 2021293 | 2021-12-16 | Juneau | Wisconsin | 55057 | 5371 | 48 |
2018042 | 2018042 | 2021-12-15 | Juneau | Wisconsin | 55057 | 5328 | 47 |
2014792 | 2014792 | 2021-12-14 | Juneau | Wisconsin | 55057 | 5308 | 47 |
2011541 | 2011541 | 2021-12-13 | Juneau | Wisconsin | 55057 | 5300 | 46 |
2008290 | 2008290 | 2021-12-12 | Juneau | Wisconsin | 55057 | 5233 | 46 |
2005039 | 2005039 | 2021-12-11 | Juneau | Wisconsin | 55057 | 5233 | 46 |
2001788 | 2001788 | 2021-12-10 | Juneau | Wisconsin | 55057 | 5233 | 46 |
1998538 | 1998538 | 2021-12-09 | Juneau | Wisconsin | 55057 | 5202 | 46 |
1995287 | 1995287 | 2021-12-08 | Juneau | Wisconsin | 55057 | 5163 | 45 |
1992036 | 1992036 | 2021-12-07 | Juneau | Wisconsin | 55057 | 5062 | 44 |
1988785 | 1988785 | 2021-12-06 | Juneau | Wisconsin | 55057 | 5062 | 44 |
1985535 | 1985535 | 2021-12-05 | Juneau | Wisconsin | 55057 | 5062 | 44 |
1982285 | 1982285 | 2021-12-04 | Juneau | Wisconsin | 55057 | 5062 | 44 |
1979035 | 1979035 | 2021-12-03 | Juneau | Wisconsin | 55057 | 5062 | 44 |
1975785 | 1975785 | 2021-12-02 | Juneau | Wisconsin | 55057 | 5027 | 44 |
1972536 | 1972536 | 2021-12-01 | Juneau | Wisconsin | 55057 | 4998 | 41 |
1969286 | 1969286 | 2021-11-30 | Juneau | Wisconsin | 55057 | 4937 | 39 |
1966036 | 1966036 | 2021-11-29 | Juneau | Wisconsin | 55057 | 4920 | 39 |
1962784 | 1962784 | 2021-11-28 | Juneau | Wisconsin | 55057 | 4817 | 39 |
1959533 | 1959533 | 2021-11-27 | Juneau | Wisconsin | 55057 | 4817 | 39 |
1956282 | 1956282 | 2021-11-26 | Juneau | Wisconsin | 55057 | 4817 | 39 |
1953031 | 1953031 | 2021-11-25 | Juneau | Wisconsin | 55057 | 4817 | 39 |
1949780 | 1949780 | 2021-11-24 | Juneau | Wisconsin | 55057 | 4786 | 39 |
1946529 | 1946529 | 2021-11-23 | Juneau | Wisconsin | 55057 | 4777 | 39 |
1943278 | 1943278 | 2021-11-22 | Juneau | Wisconsin | 55057 | 4753 | 39 |
1940028 | 1940028 | 2021-11-21 | Juneau | Wisconsin | 55057 | 4669 | 39 |
1936778 | 1936778 | 2021-11-20 | Juneau | Wisconsin | 55057 | 4669 | 39 |
1933528 | 1933528 | 2021-11-19 | Juneau | Wisconsin | 55057 | 4669 | 39 |
1930276 | 1930276 | 2021-11-18 | Juneau | Wisconsin | 55057 | 4629 | 38 |
1927026 | 1927026 | 2021-11-17 | Juneau | Wisconsin | 55057 | 4608 | 38 |
1923776 | 1923776 | 2021-11-16 | Juneau | Wisconsin | 55057 | 4586 | 37 |
1920527 | 1920527 | 2021-11-15 | Juneau | Wisconsin | 55057 | 4562 | 37 |
1917277 | 1917277 | 2021-11-14 | Juneau | Wisconsin | 55057 | 4466 | 36 |
1914027 | 1914027 | 2021-11-13 | Juneau | Wisconsin | 55057 | 4466 | 36 |
1910777 | 1910777 | 2021-11-12 | Juneau | Wisconsin | 55057 | 4466 | 36 |
1907528 | 1907528 | 2021-11-11 | Juneau | Wisconsin | 55057 | 4451 | 36 |
1904279 | 1904279 | 2021-11-10 | Juneau | Wisconsin | 55057 | 4410 | 36 |
1901029 | 1901029 | 2021-11-09 | Juneau | Wisconsin | 55057 | 4388 | 36 |
1897779 | 1897779 | 2021-11-08 | Juneau | Wisconsin | 55057 | 4375 | 36 |
1894529 | 1894529 | 2021-11-07 | Juneau | Wisconsin | 55057 | 4313 | 36 |
1891279 | 1891279 | 2021-11-06 | Juneau | Wisconsin | 55057 | 4313 | 36 |
1888029 | 1888029 | 2021-11-05 | Juneau | Wisconsin | 55057 | 4313 | 36 |
1884779 | 1884779 | 2021-11-04 | Juneau | Wisconsin | 55057 | 4290 | 36 |
1881530 | 1881530 | 2021-11-03 | Juneau | Wisconsin | 55057 | 4270 | 36 |
1878281 | 1878281 | 2021-11-02 | Juneau | Wisconsin | 55057 | 4263 | 36 |
1875032 | 1875032 | 2021-11-01 | Juneau | Wisconsin | 55057 | 4261 | 36 |
1871783 | 1871783 | 2021-10-31 | Juneau | Wisconsin | 55057 | 4237 | 36 |
1868534 | 1868534 | 2021-10-30 | Juneau | Wisconsin | 55057 | 4237 | 36 |
1865285 | 1865285 | 2021-10-29 | Juneau | Wisconsin | 55057 | 4237 | 36 |
1862036 | 1862036 | 2021-10-28 | Juneau | Wisconsin | 55057 | 4228 | 36 |
1858787 | 1858787 | 2021-10-27 | Juneau | Wisconsin | 55057 | 4214 | 35 |
1855538 | 1855538 | 2021-10-26 | Juneau | Wisconsin | 55057 | 4206 | 35 |
1852289 | 1852289 | 2021-10-25 | Juneau | Wisconsin | 55057 | 4203 | 35 |
1849039 | 1849039 | 2021-10-24 | Juneau | Wisconsin | 55057 | 4174 | 35 |
1845789 | 1845789 | 2021-10-23 | Juneau | Wisconsin | 55057 | 4174 | 35 |
1842539 | 1842539 | 2021-10-22 | Juneau | Wisconsin | 55057 | 4174 | 35 |
1839290 | 1839290 | 2021-10-21 | Juneau | Wisconsin | 55057 | 4158 | 34 |
1836041 | 1836041 | 2021-10-20 | Juneau | Wisconsin | 55057 | 4149 | 34 |
1832792 | 1832792 | 2021-10-19 | Juneau | Wisconsin | 55057 | 4142 | 34 |
1829543 | 1829543 | 2021-10-18 | Juneau | Wisconsin | 55057 | 4138 | 34 |
1826294 | 1826294 | 2021-10-17 | Juneau | Wisconsin | 55057 | 4122 | 34 |
1823045 | 1823045 | 2021-10-16 | Juneau | Wisconsin | 55057 | 4089 | 34 |
1819796 | 1819796 | 2021-10-15 | Juneau | Wisconsin | 55057 | 4089 | 34 |
1816547 | 1816547 | 2021-10-14 | Juneau | Wisconsin | 55057 | 4089 | 34 |
1813299 | 1813299 | 2021-10-13 | Juneau | Wisconsin | 55057 | 4078 | 34 |
1810050 | 1810050 | 2021-10-12 | Juneau | Wisconsin | 55057 | 4071 | 34 |
1806801 | 1806801 | 2021-10-11 | Juneau | Wisconsin | 55057 | 4065 | 34 |
1803550 | 1803550 | 2021-10-10 | Juneau | Wisconsin | 55057 | 4043 | 34 |
1800301 | 1800301 | 2021-10-09 | Juneau | Wisconsin | 55057 | 4043 | 34 |
1797052 | 1797052 | 2021-10-08 | Juneau | Wisconsin | 55057 | 4043 | 34 |
1793803 | 1793803 | 2021-10-07 | Juneau | Wisconsin | 55057 | 4017 | 34 |
1790554 | 1790554 | 2021-10-06 | Juneau | Wisconsin | 55057 | 3990 | 33 |
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);