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 |
---|---|---|---|---|---|---|---|
2177403 | 2177403 | 2022-02-02 | Racine | Wisconsin | 55101 | 54659 | 608 |
2174150 | 2174150 | 2022-02-01 | Racine | Wisconsin | 55101 | 54533 | 603 |
2170898 | 2170898 | 2022-01-31 | Racine | Wisconsin | 55101 | 54442 | 598 |
2167645 | 2167645 | 2022-01-30 | Racine | Wisconsin | 55101 | 54037 | 594 |
2164390 | 2164390 | 2022-01-29 | Racine | Wisconsin | 55101 | 54037 | 594 |
2161135 | 2161135 | 2022-01-28 | Racine | Wisconsin | 55101 | 54037 | 594 |
2157879 | 2157879 | 2022-01-27 | Racine | Wisconsin | 55101 | 53853 | 592 |
2154626 | 2154626 | 2022-01-26 | Racine | Wisconsin | 55101 | 53640 | 591 |
2151373 | 2151373 | 2022-01-25 | Racine | Wisconsin | 55101 | 53442 | 587 |
2148121 | 2148121 | 2022-01-24 | Racine | Wisconsin | 55101 | 53295 | 587 |
2144869 | 2144869 | 2022-01-23 | Racine | Wisconsin | 55101 | 52720 | 586 |
2141614 | 2141614 | 2022-01-22 | Racine | Wisconsin | 55101 | 52720 | 586 |
2138358 | 2138358 | 2022-01-21 | Racine | Wisconsin | 55101 | 52720 | 586 |
2135103 | 2135103 | 2022-01-20 | Racine | Wisconsin | 55101 | 52425 | 582 |
2131851 | 2131851 | 2022-01-19 | Racine | Wisconsin | 55101 | 52065 | 579 |
2128597 | 2128597 | 2022-01-18 | Racine | Wisconsin | 55101 | 51745 | 565 |
2125344 | 2125344 | 2022-01-17 | Racine | Wisconsin | 55101 | 51396 | 562 |
2122092 | 2122092 | 2022-01-16 | Racine | Wisconsin | 55101 | 49602 | 557 |
2118840 | 2118840 | 2022-01-15 | Racine | Wisconsin | 55101 | 49602 | 557 |
2115588 | 2115588 | 2022-01-14 | Racine | Wisconsin | 55101 | 49602 | 557 |
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 |
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);