ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "St. Croix" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1852320 | 1852320 | 2021-10-25 | St. Croix | Wisconsin | 55109 | 12925 | 85 |
1849070 | 1849070 | 2021-10-24 | St. Croix | Wisconsin | 55109 | 12788 | 85 |
1845820 | 1845820 | 2021-10-23 | St. Croix | Wisconsin | 55109 | 12788 | 85 |
1842570 | 1842570 | 2021-10-22 | St. Croix | Wisconsin | 55109 | 12788 | 85 |
1839321 | 1839321 | 2021-10-21 | St. Croix | Wisconsin | 55109 | 12738 | 85 |
1836072 | 1836072 | 2021-10-20 | St. Croix | Wisconsin | 55109 | 12674 | 85 |
1832823 | 1832823 | 2021-10-19 | St. Croix | Wisconsin | 55109 | 12641 | 85 |
1829574 | 1829574 | 2021-10-18 | St. Croix | Wisconsin | 55109 | 12613 | 84 |
1826325 | 1826325 | 2021-10-17 | St. Croix | Wisconsin | 55109 | 12551 | 84 |
1823076 | 1823076 | 2021-10-16 | St. Croix | Wisconsin | 55109 | 12463 | 84 |
1819827 | 1819827 | 2021-10-15 | St. Croix | Wisconsin | 55109 | 12463 | 84 |
1816578 | 1816578 | 2021-10-14 | St. Croix | Wisconsin | 55109 | 12463 | 84 |
1813330 | 1813330 | 2021-10-13 | St. Croix | Wisconsin | 55109 | 12386 | 83 |
1810081 | 1810081 | 2021-10-12 | St. Croix | Wisconsin | 55109 | 12363 | 83 |
1806832 | 1806832 | 2021-10-11 | St. Croix | Wisconsin | 55109 | 12327 | 83 |
1803581 | 1803581 | 2021-10-10 | St. Croix | Wisconsin | 55109 | 12210 | 83 |
1800332 | 1800332 | 2021-10-09 | St. Croix | Wisconsin | 55109 | 12210 | 83 |
1797083 | 1797083 | 2021-10-08 | St. Croix | Wisconsin | 55109 | 12210 | 83 |
1793834 | 1793834 | 2021-10-07 | St. Croix | Wisconsin | 55109 | 12154 | 83 |
1790585 | 1790585 | 2021-10-06 | St. Croix | Wisconsin | 55109 | 12078 | 83 |
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);