ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 55059 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112314 | 2112314 | 2022-01-13 | Kenosha | Wisconsin | 55059 | 35200 | 504 |
2109062 | 2109062 | 2022-01-12 | Kenosha | Wisconsin | 55059 | 34769 | 502 |
2105811 | 2105811 | 2022-01-11 | Kenosha | Wisconsin | 55059 | 34448 | 500 |
2102560 | 2102560 | 2022-01-10 | Kenosha | Wisconsin | 55059 | 33885 | 497 |
2099309 | 2099309 | 2022-01-09 | Kenosha | Wisconsin | 55059 | 32667 | 495 |
2096058 | 2096058 | 2022-01-08 | Kenosha | Wisconsin | 55059 | 32667 | 495 |
2092806 | 2092806 | 2022-01-07 | Kenosha | Wisconsin | 55059 | 32667 | 495 |
2089554 | 2089554 | 2022-01-06 | Kenosha | Wisconsin | 55059 | 32062 | 492 |
2086303 | 2086303 | 2022-01-05 | Kenosha | Wisconsin | 55059 | 31939 | 488 |
2083051 | 2083051 | 2022-01-04 | Kenosha | Wisconsin | 55059 | 31812 | 481 |
2079799 | 2079799 | 2022-01-03 | Kenosha | Wisconsin | 55059 | 31582 | 478 |
2076547 | 2076547 | 2022-01-02 | Kenosha | Wisconsin | 55059 | 31434 | 476 |
2073296 | 2073296 | 2022-01-01 | Kenosha | Wisconsin | 55059 | 31434 | 476 |
2070045 | 2070045 | 2021-12-31 | Kenosha | Wisconsin | 55059 | 31434 | 476 |
2066794 | 2066794 | 2021-12-30 | Kenosha | Wisconsin | 55059 | 31214 | 470 |
2063544 | 2063544 | 2021-12-29 | Kenosha | Wisconsin | 55059 | 30918 | 462 |
2060294 | 2060294 | 2021-12-28 | Kenosha | Wisconsin | 55059 | 30518 | 458 |
2057045 | 2057045 | 2021-12-27 | Kenosha | Wisconsin | 55059 | 30333 | 453 |
2053796 | 2053796 | 2021-12-26 | Kenosha | Wisconsin | 55059 | 30247 | 452 |
2050546 | 2050546 | 2021-12-25 | Kenosha | Wisconsin | 55059 | 30247 | 452 |
2047296 | 2047296 | 2021-12-24 | Kenosha | Wisconsin | 55059 | 30247 | 452 |
2044046 | 2044046 | 2021-12-23 | Kenosha | Wisconsin | 55059 | 30148 | 448 |
2040797 | 2040797 | 2021-12-22 | Kenosha | Wisconsin | 55059 | 30029 | 445 |
2037547 | 2037547 | 2021-12-21 | Kenosha | Wisconsin | 55059 | 29827 | 440 |
2034297 | 2034297 | 2021-12-20 | Kenosha | Wisconsin | 55059 | 29572 | 437 |
2031047 | 2031047 | 2021-12-19 | Kenosha | Wisconsin | 55059 | 29044 | 431 |
2027796 | 2027796 | 2021-12-18 | Kenosha | Wisconsin | 55059 | 29044 | 431 |
2024545 | 2024545 | 2021-12-17 | Kenosha | Wisconsin | 55059 | 29044 | 431 |
2021294 | 2021294 | 2021-12-16 | Kenosha | Wisconsin | 55059 | 28873 | 428 |
2018043 | 2018043 | 2021-12-15 | Kenosha | Wisconsin | 55059 | 28469 | 423 |
2014793 | 2014793 | 2021-12-14 | Kenosha | Wisconsin | 55059 | 28260 | 420 |
2011542 | 2011542 | 2021-12-13 | Kenosha | Wisconsin | 55059 | 28048 | 419 |
2008291 | 2008291 | 2021-12-12 | Kenosha | Wisconsin | 55059 | 27706 | 419 |
2005040 | 2005040 | 2021-12-11 | Kenosha | Wisconsin | 55059 | 27706 | 419 |
2001789 | 2001789 | 2021-12-10 | Kenosha | Wisconsin | 55059 | 27706 | 419 |
1998539 | 1998539 | 2021-12-09 | Kenosha | Wisconsin | 55059 | 27608 | 419 |
1995288 | 1995288 | 2021-12-08 | Kenosha | Wisconsin | 55059 | 27461 | 418 |
1992037 | 1992037 | 2021-12-07 | Kenosha | Wisconsin | 55059 | 26937 | 414 |
1988786 | 1988786 | 2021-12-06 | Kenosha | Wisconsin | 55059 | 26937 | 414 |
1985536 | 1985536 | 2021-12-05 | Kenosha | Wisconsin | 55059 | 26937 | 414 |
1982286 | 1982286 | 2021-12-04 | Kenosha | Wisconsin | 55059 | 26937 | 414 |
1979036 | 1979036 | 2021-12-03 | Kenosha | Wisconsin | 55059 | 26937 | 414 |
1975786 | 1975786 | 2021-12-02 | Kenosha | Wisconsin | 55059 | 26787 | 412 |
1972537 | 1972537 | 2021-12-01 | Kenosha | Wisconsin | 55059 | 26640 | 411 |
1969287 | 1969287 | 2021-11-30 | Kenosha | Wisconsin | 55059 | 26509 | 407 |
1966037 | 1966037 | 2021-11-29 | Kenosha | Wisconsin | 55059 | 26362 | 406 |
1962785 | 1962785 | 2021-11-28 | Kenosha | Wisconsin | 55059 | 26113 | 406 |
1959534 | 1959534 | 2021-11-27 | Kenosha | Wisconsin | 55059 | 26113 | 406 |
1956283 | 1956283 | 2021-11-26 | Kenosha | Wisconsin | 55059 | 26113 | 406 |
1953032 | 1953032 | 2021-11-25 | Kenosha | Wisconsin | 55059 | 26113 | 406 |
1949781 | 1949781 | 2021-11-24 | Kenosha | Wisconsin | 55059 | 26056 | 403 |
1946530 | 1946530 | 2021-11-23 | Kenosha | Wisconsin | 55059 | 25938 | 402 |
1943279 | 1943279 | 2021-11-22 | Kenosha | Wisconsin | 55059 | 25772 | 401 |
1940029 | 1940029 | 2021-11-21 | Kenosha | Wisconsin | 55059 | 25472 | 399 |
1936779 | 1936779 | 2021-11-20 | Kenosha | Wisconsin | 55059 | 25472 | 399 |
1933529 | 1933529 | 2021-11-19 | Kenosha | Wisconsin | 55059 | 25472 | 399 |
1930277 | 1930277 | 2021-11-18 | Kenosha | Wisconsin | 55059 | 25381 | 398 |
1927027 | 1927027 | 2021-11-17 | Kenosha | Wisconsin | 55059 | 25289 | 394 |
1923777 | 1923777 | 2021-11-16 | Kenosha | Wisconsin | 55059 | 25180 | 391 |
1920528 | 1920528 | 2021-11-15 | Kenosha | Wisconsin | 55059 | 25044 | 390 |
1917278 | 1917278 | 2021-11-14 | Kenosha | Wisconsin | 55059 | 24951 | 390 |
1914028 | 1914028 | 2021-11-13 | Kenosha | Wisconsin | 55059 | 24951 | 390 |
1910778 | 1910778 | 2021-11-12 | Kenosha | Wisconsin | 55059 | 24951 | 390 |
1907529 | 1907529 | 2021-11-11 | Kenosha | Wisconsin | 55059 | 24843 | 390 |
1904280 | 1904280 | 2021-11-10 | Kenosha | Wisconsin | 55059 | 24743 | 390 |
1901030 | 1901030 | 2021-11-09 | Kenosha | Wisconsin | 55059 | 24663 | 389 |
1897780 | 1897780 | 2021-11-08 | Kenosha | Wisconsin | 55059 | 24588 | 389 |
1894530 | 1894530 | 2021-11-07 | Kenosha | Wisconsin | 55059 | 24473 | 387 |
1891280 | 1891280 | 2021-11-06 | Kenosha | Wisconsin | 55059 | 24473 | 387 |
1888030 | 1888030 | 2021-11-05 | Kenosha | Wisconsin | 55059 | 24473 | 387 |
1884780 | 1884780 | 2021-11-04 | Kenosha | Wisconsin | 55059 | 24418 | 387 |
1881531 | 1881531 | 2021-11-03 | Kenosha | Wisconsin | 55059 | 24331 | 387 |
1878282 | 1878282 | 2021-11-02 | Kenosha | Wisconsin | 55059 | 24261 | 385 |
1875033 | 1875033 | 2021-11-01 | Kenosha | Wisconsin | 55059 | 24197 | 385 |
1871784 | 1871784 | 2021-10-31 | Kenosha | Wisconsin | 55059 | 24122 | 385 |
1868535 | 1868535 | 2021-10-30 | Kenosha | Wisconsin | 55059 | 24122 | 385 |
1865286 | 1865286 | 2021-10-29 | Kenosha | Wisconsin | 55059 | 24122 | 385 |
1862037 | 1862037 | 2021-10-28 | Kenosha | Wisconsin | 55059 | 24070 | 384 |
1858788 | 1858788 | 2021-10-27 | Kenosha | Wisconsin | 55059 | 24011 | 384 |
1855539 | 1855539 | 2021-10-26 | Kenosha | Wisconsin | 55059 | 23943 | 382 |
1852290 | 1852290 | 2021-10-25 | Kenosha | Wisconsin | 55059 | 23889 | 382 |
1849040 | 1849040 | 2021-10-24 | Kenosha | Wisconsin | 55059 | 23818 | 381 |
1845790 | 1845790 | 2021-10-23 | Kenosha | Wisconsin | 55059 | 23818 | 381 |
1842540 | 1842540 | 2021-10-22 | Kenosha | Wisconsin | 55059 | 23818 | 381 |
1839291 | 1839291 | 2021-10-21 | Kenosha | Wisconsin | 55059 | 23758 | 377 |
1836042 | 1836042 | 2021-10-20 | Kenosha | Wisconsin | 55059 | 23707 | 377 |
1832793 | 1832793 | 2021-10-19 | Kenosha | Wisconsin | 55059 | 23644 | 372 |
1829544 | 1829544 | 2021-10-18 | Kenosha | Wisconsin | 55059 | 23601 | 372 |
1826295 | 1826295 | 2021-10-17 | Kenosha | Wisconsin | 55059 | 23566 | 372 |
1823046 | 1823046 | 2021-10-16 | Kenosha | Wisconsin | 55059 | 23489 | 372 |
1819797 | 1819797 | 2021-10-15 | Kenosha | Wisconsin | 55059 | 23489 | 372 |
1816548 | 1816548 | 2021-10-14 | Kenosha | Wisconsin | 55059 | 23489 | 372 |
1813300 | 1813300 | 2021-10-13 | Kenosha | Wisconsin | 55059 | 23438 | 372 |
1810051 | 1810051 | 2021-10-12 | Kenosha | Wisconsin | 55059 | 23368 | 371 |
1806802 | 1806802 | 2021-10-11 | Kenosha | Wisconsin | 55059 | 23298 | 368 |
1803551 | 1803551 | 2021-10-10 | Kenosha | Wisconsin | 55059 | 23175 | 368 |
1800302 | 1800302 | 2021-10-09 | Kenosha | Wisconsin | 55059 | 23175 | 368 |
1797053 | 1797053 | 2021-10-08 | Kenosha | Wisconsin | 55059 | 23175 | 368 |
1793804 | 1793804 | 2021-10-07 | Kenosha | Wisconsin | 55059 | 23070 | 367 |
1790555 | 1790555 | 2021-10-06 | Kenosha | Wisconsin | 55059 | 22973 | 365 |
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);