ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55109 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177411 | 2177411 | 2022-02-02 | St. Croix | Wisconsin | 55109 | 23347 | 132 |
2174158 | 2174158 | 2022-02-01 | St. Croix | Wisconsin | 55109 | 23283 | 129 |
2170906 | 2170906 | 2022-01-31 | St. Croix | Wisconsin | 55109 | 23214 | 128 |
2167653 | 2167653 | 2022-01-30 | St. Croix | Wisconsin | 55109 | 22912 | 126 |
2164398 | 2164398 | 2022-01-29 | St. Croix | Wisconsin | 55109 | 22912 | 126 |
2161143 | 2161143 | 2022-01-28 | St. Croix | Wisconsin | 55109 | 22912 | 126 |
2157887 | 2157887 | 2022-01-27 | St. Croix | Wisconsin | 55109 | 22751 | 126 |
2154634 | 2154634 | 2022-01-26 | St. Croix | Wisconsin | 55109 | 22605 | 126 |
2151381 | 2151381 | 2022-01-25 | St. Croix | Wisconsin | 55109 | 22510 | 125 |
2148129 | 2148129 | 2022-01-24 | St. Croix | Wisconsin | 55109 | 22383 | 126 |
2144877 | 2144877 | 2022-01-23 | St. Croix | Wisconsin | 55109 | 21988 | 126 |
2141622 | 2141622 | 2022-01-22 | St. Croix | Wisconsin | 55109 | 21988 | 126 |
2138366 | 2138366 | 2022-01-21 | St. Croix | Wisconsin | 55109 | 21988 | 126 |
2135111 | 2135111 | 2022-01-20 | St. Croix | Wisconsin | 55109 | 21795 | 126 |
2131859 | 2131859 | 2022-01-19 | St. Croix | Wisconsin | 55109 | 21528 | 125 |
2128605 | 2128605 | 2022-01-18 | St. Croix | Wisconsin | 55109 | 21340 | 124 |
2125352 | 2125352 | 2022-01-17 | St. Croix | Wisconsin | 55109 | 21097 | 124 |
2122100 | 2122100 | 2022-01-16 | St. Croix | Wisconsin | 55109 | 20553 | 124 |
2118848 | 2118848 | 2022-01-15 | St. Croix | Wisconsin | 55109 | 20553 | 124 |
2115596 | 2115596 | 2022-01-14 | St. Croix | Wisconsin | 55109 | 20553 | 124 |
2112344 | 2112344 | 2022-01-13 | St. Croix | Wisconsin | 55109 | 20261 | 123 |
2109092 | 2109092 | 2022-01-12 | St. Croix | Wisconsin | 55109 | 20000 | 121 |
2105841 | 2105841 | 2022-01-11 | St. Croix | Wisconsin | 55109 | 19837 | 121 |
2102590 | 2102590 | 2022-01-10 | St. Croix | Wisconsin | 55109 | 19633 | 118 |
2099339 | 2099339 | 2022-01-09 | St. Croix | Wisconsin | 55109 | 19057 | 118 |
2096088 | 2096088 | 2022-01-08 | St. Croix | Wisconsin | 55109 | 19057 | 118 |
2092836 | 2092836 | 2022-01-07 | St. Croix | Wisconsin | 55109 | 19057 | 118 |
2089584 | 2089584 | 2022-01-06 | St. Croix | Wisconsin | 55109 | 18892 | 117 |
2086333 | 2086333 | 2022-01-05 | St. Croix | Wisconsin | 55109 | 18637 | 118 |
2083081 | 2083081 | 2022-01-04 | St. Croix | Wisconsin | 55109 | 18519 | 116 |
2079829 | 2079829 | 2022-01-03 | St. Croix | Wisconsin | 55109 | 18392 | 116 |
2076577 | 2076577 | 2022-01-02 | St. Croix | Wisconsin | 55109 | 18144 | 116 |
2073326 | 2073326 | 2022-01-01 | St. Croix | Wisconsin | 55109 | 18144 | 116 |
2070075 | 2070075 | 2021-12-31 | St. Croix | Wisconsin | 55109 | 18144 | 116 |
2066824 | 2066824 | 2021-12-30 | St. Croix | Wisconsin | 55109 | 18010 | 113 |
2063574 | 2063574 | 2021-12-29 | St. Croix | Wisconsin | 55109 | 17923 | 112 |
2060324 | 2060324 | 2021-12-28 | St. Croix | Wisconsin | 55109 | 17868 | 112 |
2057075 | 2057075 | 2021-12-27 | St. Croix | Wisconsin | 55109 | 17821 | 114 |
2053826 | 2053826 | 2021-12-26 | St. Croix | Wisconsin | 55109 | 17678 | 113 |
2050576 | 2050576 | 2021-12-25 | St. Croix | Wisconsin | 55109 | 17678 | 113 |
2047326 | 2047326 | 2021-12-24 | St. Croix | Wisconsin | 55109 | 17678 | 113 |
2044076 | 2044076 | 2021-12-23 | St. Croix | Wisconsin | 55109 | 17617 | 113 |
2040827 | 2040827 | 2021-12-22 | St. Croix | Wisconsin | 55109 | 17564 | 111 |
2037577 | 2037577 | 2021-12-21 | St. Croix | Wisconsin | 55109 | 17497 | 110 |
2034327 | 2034327 | 2021-12-20 | St. Croix | Wisconsin | 55109 | 17408 | 110 |
2031077 | 2031077 | 2021-12-19 | St. Croix | Wisconsin | 55109 | 17324 | 110 |
2027826 | 2027826 | 2021-12-18 | St. Croix | Wisconsin | 55109 | 17324 | 110 |
2024575 | 2024575 | 2021-12-17 | St. Croix | Wisconsin | 55109 | 17324 | 110 |
2021324 | 2021324 | 2021-12-16 | St. Croix | Wisconsin | 55109 | 17229 | 109 |
2018073 | 2018073 | 2021-12-15 | St. Croix | Wisconsin | 55109 | 17167 | 106 |
2014823 | 2014823 | 2021-12-14 | St. Croix | Wisconsin | 55109 | 17136 | 102 |
2011572 | 2011572 | 2021-12-13 | St. Croix | Wisconsin | 55109 | 17039 | 100 |
2008321 | 2008321 | 2021-12-12 | St. Croix | Wisconsin | 55109 | 16885 | 100 |
2005070 | 2005070 | 2021-12-11 | St. Croix | Wisconsin | 55109 | 16885 | 100 |
2001819 | 2001819 | 2021-12-10 | St. Croix | Wisconsin | 55109 | 16885 | 100 |
1998569 | 1998569 | 2021-12-09 | St. Croix | Wisconsin | 55109 | 16735 | 100 |
1995318 | 1995318 | 2021-12-08 | St. Croix | Wisconsin | 55109 | 16621 | 100 |
1992067 | 1992067 | 2021-12-07 | St. Croix | Wisconsin | 55109 | 16333 | 96 |
1988816 | 1988816 | 2021-12-06 | St. Croix | Wisconsin | 55109 | 16333 | 96 |
1985566 | 1985566 | 2021-12-05 | St. Croix | Wisconsin | 55109 | 16333 | 96 |
1982316 | 1982316 | 2021-12-04 | St. Croix | Wisconsin | 55109 | 16333 | 96 |
1979066 | 1979066 | 2021-12-03 | St. Croix | Wisconsin | 55109 | 16333 | 96 |
1975816 | 1975816 | 2021-12-02 | St. Croix | Wisconsin | 55109 | 16232 | 94 |
1972567 | 1972567 | 2021-12-01 | St. Croix | Wisconsin | 55109 | 16104 | 91 |
1969317 | 1969317 | 2021-11-30 | St. Croix | Wisconsin | 55109 | 15997 | 91 |
1966067 | 1966067 | 2021-11-29 | St. Croix | Wisconsin | 55109 | 15926 | 90 |
1962815 | 1962815 | 2021-11-28 | St. Croix | Wisconsin | 55109 | 15640 | 90 |
1959564 | 1959564 | 2021-11-27 | St. Croix | Wisconsin | 55109 | 15640 | 90 |
1956313 | 1956313 | 2021-11-26 | St. Croix | Wisconsin | 55109 | 15640 | 90 |
1953062 | 1953062 | 2021-11-25 | St. Croix | Wisconsin | 55109 | 15640 | 90 |
1949811 | 1949811 | 2021-11-24 | St. Croix | Wisconsin | 55109 | 15553 | 90 |
1946560 | 1946560 | 2021-11-23 | St. Croix | Wisconsin | 55109 | 15446 | 89 |
1943309 | 1943309 | 2021-11-22 | St. Croix | Wisconsin | 55109 | 15359 | 88 |
1940059 | 1940059 | 2021-11-21 | St. Croix | Wisconsin | 55109 | 15082 | 87 |
1936809 | 1936809 | 2021-11-20 | St. Croix | Wisconsin | 55109 | 15082 | 87 |
1933559 | 1933559 | 2021-11-19 | St. Croix | Wisconsin | 55109 | 15082 | 87 |
1930307 | 1930307 | 2021-11-18 | St. Croix | Wisconsin | 55109 | 14970 | 87 |
1927057 | 1927057 | 2021-11-17 | St. Croix | Wisconsin | 55109 | 14859 | 87 |
1923807 | 1923807 | 2021-11-16 | St. Croix | Wisconsin | 55109 | 14740 | 87 |
1920558 | 1920558 | 2021-11-15 | St. Croix | Wisconsin | 55109 | 14659 | 86 |
1917308 | 1917308 | 2021-11-14 | St. Croix | Wisconsin | 55109 | 14400 | 86 |
1914058 | 1914058 | 2021-11-13 | St. Croix | Wisconsin | 55109 | 14400 | 86 |
1910808 | 1910808 | 2021-11-12 | St. Croix | Wisconsin | 55109 | 14400 | 86 |
1907559 | 1907559 | 2021-11-11 | St. Croix | Wisconsin | 55109 | 14274 | 86 |
1904310 | 1904310 | 2021-11-10 | St. Croix | Wisconsin | 55109 | 14137 | 86 |
1901060 | 1901060 | 2021-11-09 | St. Croix | Wisconsin | 55109 | 14040 | 86 |
1897810 | 1897810 | 2021-11-08 | St. Croix | Wisconsin | 55109 | 13941 | 86 |
1894560 | 1894560 | 2021-11-07 | St. Croix | Wisconsin | 55109 | 13705 | 86 |
1891310 | 1891310 | 2021-11-06 | St. Croix | Wisconsin | 55109 | 13705 | 86 |
1888060 | 1888060 | 2021-11-05 | St. Croix | Wisconsin | 55109 | 13705 | 86 |
1884810 | 1884810 | 2021-11-04 | St. Croix | Wisconsin | 55109 | 13610 | 86 |
1881561 | 1881561 | 2021-11-03 | St. Croix | Wisconsin | 55109 | 13495 | 86 |
1878312 | 1878312 | 2021-11-02 | St. Croix | Wisconsin | 55109 | 13445 | 86 |
1875063 | 1875063 | 2021-11-01 | St. Croix | Wisconsin | 55109 | 13372 | 86 |
1871814 | 1871814 | 2021-10-31 | St. Croix | Wisconsin | 55109 | 13160 | 86 |
1868565 | 1868565 | 2021-10-30 | St. Croix | Wisconsin | 55109 | 13160 | 86 |
1865316 | 1865316 | 2021-10-29 | St. Croix | Wisconsin | 55109 | 13160 | 86 |
1862067 | 1862067 | 2021-10-28 | St. Croix | Wisconsin | 55109 | 13100 | 86 |
1858818 | 1858818 | 2021-10-27 | St. Croix | Wisconsin | 55109 | 13021 | 85 |
1855569 | 1855569 | 2021-10-26 | St. Croix | Wisconsin | 55109 | 12974 | 85 |
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);