ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 55101 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112336 | 2112336 | 2022-01-13 | Racine | Wisconsin | 55101 | 48399 | 549 |
2109084 | 2109084 | 2022-01-12 | Racine | Wisconsin | 55101 | 47558 | 549 |
2105833 | 2105833 | 2022-01-11 | Racine | Wisconsin | 55101 | 46684 | 533 |
2102582 | 2102582 | 2022-01-10 | Racine | Wisconsin | 55101 | 45953 | 532 |
2099331 | 2099331 | 2022-01-09 | Racine | Wisconsin | 55101 | 44923 | 522 |
2096080 | 2096080 | 2022-01-08 | Racine | Wisconsin | 55101 | 44923 | 522 |
2092828 | 2092828 | 2022-01-07 | Racine | Wisconsin | 55101 | 44923 | 522 |
2089576 | 2089576 | 2022-01-06 | Racine | Wisconsin | 55101 | 43935 | 521 |
2086325 | 2086325 | 2022-01-05 | Racine | Wisconsin | 55101 | 42975 | 521 |
2083073 | 2083073 | 2022-01-04 | Racine | Wisconsin | 55101 | 41945 | 518 |
2079821 | 2079821 | 2022-01-03 | Racine | Wisconsin | 55101 | 41185 | 515 |
2076569 | 2076569 | 2022-01-02 | Racine | Wisconsin | 55101 | 40917 | 515 |
2073318 | 2073318 | 2022-01-01 | Racine | Wisconsin | 55101 | 40917 | 515 |
2070067 | 2070067 | 2021-12-31 | Racine | Wisconsin | 55101 | 40917 | 515 |
2066816 | 2066816 | 2021-12-30 | Racine | Wisconsin | 55101 | 40474 | 515 |
2063566 | 2063566 | 2021-12-29 | Racine | Wisconsin | 55101 | 40034 | 515 |
2060316 | 2060316 | 2021-12-28 | Racine | Wisconsin | 55101 | 39661 | 513 |
2057067 | 2057067 | 2021-12-27 | Racine | Wisconsin | 55101 | 39020 | 510 |
2053818 | 2053818 | 2021-12-26 | Racine | Wisconsin | 55101 | 38939 | 510 |
2050568 | 2050568 | 2021-12-25 | Racine | Wisconsin | 55101 | 38939 | 510 |
2047318 | 2047318 | 2021-12-24 | Racine | Wisconsin | 55101 | 38939 | 510 |
2044068 | 2044068 | 2021-12-23 | Racine | Wisconsin | 55101 | 38738 | 509 |
2040819 | 2040819 | 2021-12-22 | Racine | Wisconsin | 55101 | 38379 | 506 |
2037569 | 2037569 | 2021-12-21 | Racine | Wisconsin | 55101 | 38054 | 502 |
2034319 | 2034319 | 2021-12-20 | Racine | Wisconsin | 55101 | 37877 | 501 |
2031069 | 2031069 | 2021-12-19 | Racine | Wisconsin | 55101 | 37650 | 494 |
2027818 | 2027818 | 2021-12-18 | Racine | Wisconsin | 55101 | 37650 | 494 |
2024567 | 2024567 | 2021-12-17 | Racine | Wisconsin | 55101 | 37650 | 494 |
2021316 | 2021316 | 2021-12-16 | Racine | Wisconsin | 55101 | 37465 | 493 |
2018065 | 2018065 | 2021-12-15 | Racine | Wisconsin | 55101 | 37307 | 491 |
2014815 | 2014815 | 2021-12-14 | Racine | Wisconsin | 55101 | 37106 | 491 |
2011564 | 2011564 | 2021-12-13 | Racine | Wisconsin | 55101 | 36946 | 492 |
2008313 | 2008313 | 2021-12-12 | Racine | Wisconsin | 55101 | 36488 | 491 |
2005062 | 2005062 | 2021-12-11 | Racine | Wisconsin | 55101 | 36488 | 491 |
2001811 | 2001811 | 2021-12-10 | Racine | Wisconsin | 55101 | 36488 | 491 |
1998561 | 1998561 | 2021-12-09 | Racine | Wisconsin | 55101 | 36233 | 491 |
1995310 | 1995310 | 2021-12-08 | Racine | Wisconsin | 55101 | 36006 | 491 |
1992059 | 1992059 | 2021-12-07 | Racine | Wisconsin | 55101 | 35438 | 483 |
1988808 | 1988808 | 2021-12-06 | Racine | Wisconsin | 55101 | 35438 | 483 |
1985558 | 1985558 | 2021-12-05 | Racine | Wisconsin | 55101 | 35438 | 483 |
1982308 | 1982308 | 2021-12-04 | Racine | Wisconsin | 55101 | 35438 | 483 |
1979058 | 1979058 | 2021-12-03 | Racine | Wisconsin | 55101 | 35438 | 483 |
1975808 | 1975808 | 2021-12-02 | Racine | Wisconsin | 55101 | 35260 | 483 |
1972559 | 1972559 | 2021-12-01 | Racine | Wisconsin | 55101 | 35092 | 478 |
1969309 | 1969309 | 2021-11-30 | Racine | Wisconsin | 55101 | 34866 | 477 |
1966059 | 1966059 | 2021-11-29 | Racine | Wisconsin | 55101 | 34645 | 474 |
1962807 | 1962807 | 2021-11-28 | Racine | Wisconsin | 55101 | 34392 | 474 |
1959556 | 1959556 | 2021-11-27 | Racine | Wisconsin | 55101 | 34392 | 474 |
1956305 | 1956305 | 2021-11-26 | Racine | Wisconsin | 55101 | 34392 | 474 |
1953054 | 1953054 | 2021-11-25 | Racine | Wisconsin | 55101 | 34392 | 474 |
1949803 | 1949803 | 2021-11-24 | Racine | Wisconsin | 55101 | 34235 | 474 |
1946552 | 1946552 | 2021-11-23 | Racine | Wisconsin | 55101 | 34088 | 474 |
1943301 | 1943301 | 2021-11-22 | Racine | Wisconsin | 55101 | 33876 | 471 |
1940051 | 1940051 | 2021-11-21 | Racine | Wisconsin | 55101 | 33649 | 471 |
1936801 | 1936801 | 2021-11-20 | Racine | Wisconsin | 55101 | 33649 | 471 |
1933551 | 1933551 | 2021-11-19 | Racine | Wisconsin | 55101 | 33649 | 471 |
1930299 | 1930299 | 2021-11-18 | Racine | Wisconsin | 55101 | 33539 | 471 |
1927049 | 1927049 | 2021-11-17 | Racine | Wisconsin | 55101 | 33340 | 470 |
1923799 | 1923799 | 2021-11-16 | Racine | Wisconsin | 55101 | 33244 | 468 |
1920550 | 1920550 | 2021-11-15 | Racine | Wisconsin | 55101 | 33038 | 468 |
1917300 | 1917300 | 2021-11-14 | Racine | Wisconsin | 55101 | 32882 | 467 |
1914050 | 1914050 | 2021-11-13 | Racine | Wisconsin | 55101 | 32882 | 467 |
1910800 | 1910800 | 2021-11-12 | Racine | Wisconsin | 55101 | 32882 | 467 |
1907551 | 1907551 | 2021-11-11 | Racine | Wisconsin | 55101 | 32775 | 466 |
1904302 | 1904302 | 2021-11-10 | Racine | Wisconsin | 55101 | 32634 | 466 |
1901052 | 1901052 | 2021-11-09 | Racine | Wisconsin | 55101 | 32521 | 462 |
1897802 | 1897802 | 2021-11-08 | Racine | Wisconsin | 55101 | 32309 | 462 |
1894552 | 1894552 | 2021-11-07 | Racine | Wisconsin | 55101 | 32244 | 461 |
1891302 | 1891302 | 2021-11-06 | Racine | Wisconsin | 55101 | 32244 | 461 |
1888052 | 1888052 | 2021-11-05 | Racine | Wisconsin | 55101 | 32244 | 461 |
1884802 | 1884802 | 2021-11-04 | Racine | Wisconsin | 55101 | 32180 | 460 |
1881553 | 1881553 | 2021-11-03 | Racine | Wisconsin | 55101 | 32069 | 458 |
1878304 | 1878304 | 2021-11-02 | Racine | Wisconsin | 55101 | 32027 | 458 |
1875055 | 1875055 | 2021-11-01 | Racine | Wisconsin | 55101 | 31891 | 457 |
1871806 | 1871806 | 2021-10-31 | Racine | Wisconsin | 55101 | 31836 | 456 |
1868557 | 1868557 | 2021-10-30 | Racine | Wisconsin | 55101 | 31836 | 456 |
1865308 | 1865308 | 2021-10-29 | Racine | Wisconsin | 55101 | 31836 | 456 |
1862059 | 1862059 | 2021-10-28 | Racine | Wisconsin | 55101 | 31767 | 456 |
1858810 | 1858810 | 2021-10-27 | Racine | Wisconsin | 55101 | 31721 | 456 |
1855561 | 1855561 | 2021-10-26 | Racine | Wisconsin | 55101 | 31677 | 456 |
1852312 | 1852312 | 2021-10-25 | Racine | Wisconsin | 55101 | 31533 | 453 |
1849062 | 1849062 | 2021-10-24 | Racine | Wisconsin | 55101 | 31441 | 447 |
1845812 | 1845812 | 2021-10-23 | Racine | Wisconsin | 55101 | 31441 | 447 |
1842562 | 1842562 | 2021-10-22 | Racine | Wisconsin | 55101 | 31441 | 447 |
1839313 | 1839313 | 2021-10-21 | Racine | Wisconsin | 55101 | 31389 | 446 |
1836064 | 1836064 | 2021-10-20 | Racine | Wisconsin | 55101 | 31324 | 445 |
1832815 | 1832815 | 2021-10-19 | Racine | Wisconsin | 55101 | 31274 | 444 |
1829566 | 1829566 | 2021-10-18 | Racine | Wisconsin | 55101 | 31226 | 444 |
1826317 | 1826317 | 2021-10-17 | Racine | Wisconsin | 55101 | 31155 | 444 |
1823068 | 1823068 | 2021-10-16 | Racine | Wisconsin | 55101 | 31041 | 444 |
1819819 | 1819819 | 2021-10-15 | Racine | Wisconsin | 55101 | 31041 | 444 |
1816570 | 1816570 | 2021-10-14 | Racine | Wisconsin | 55101 | 31041 | 444 |
1813322 | 1813322 | 2021-10-13 | Racine | Wisconsin | 55101 | 30981 | 443 |
1810073 | 1810073 | 2021-10-12 | Racine | Wisconsin | 55101 | 30922 | 443 |
1806824 | 1806824 | 2021-10-11 | Racine | Wisconsin | 55101 | 30826 | 441 |
1803573 | 1803573 | 2021-10-10 | Racine | Wisconsin | 55101 | 30664 | 441 |
1800324 | 1800324 | 2021-10-09 | Racine | Wisconsin | 55101 | 30664 | 441 |
1797075 | 1797075 | 2021-10-08 | Racine | Wisconsin | 55101 | 30664 | 441 |
1793826 | 1793826 | 2021-10-07 | Racine | Wisconsin | 55101 | 30575 | 440 |
1790577 | 1790577 | 2021-10-06 | Racine | Wisconsin | 55101 | 30496 | 440 |
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);