ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 27157 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175602 | 2175602 | 2022-02-02 | Wabasha | Minnesota | 27157 | 5130 | 14 |
2172349 | 2172349 | 2022-02-01 | Wabasha | Minnesota | 27157 | 5091 | 14 |
2169096 | 2169096 | 2022-01-31 | Wabasha | Minnesota | 27157 | 5016 | 14 |
2165841 | 2165841 | 2022-01-30 | Wabasha | Minnesota | 27157 | 4954 | 14 |
2162586 | 2162586 | 2022-01-29 | Wabasha | Minnesota | 27157 | 4954 | 14 |
2159331 | 2159331 | 2022-01-28 | Wabasha | Minnesota | 27157 | 4954 | 14 |
2156077 | 2156077 | 2022-01-27 | Wabasha | Minnesota | 27157 | 4916 | 14 |
2152824 | 2152824 | 2022-01-26 | Wabasha | Minnesota | 27157 | 4837 | 13 |
2149572 | 2149572 | 2022-01-25 | Wabasha | Minnesota | 27157 | 4795 | 13 |
2146320 | 2146320 | 2022-01-24 | Wabasha | Minnesota | 27157 | 4699 | 13 |
2143065 | 2143065 | 2022-01-23 | Wabasha | Minnesota | 27157 | 4651 | 13 |
2139810 | 2139810 | 2022-01-22 | Wabasha | Minnesota | 27157 | 4651 | 13 |
2136554 | 2136554 | 2022-01-21 | Wabasha | Minnesota | 27157 | 4651 | 13 |
2133302 | 2133302 | 2022-01-20 | Wabasha | Minnesota | 27157 | 4591 | 13 |
2130049 | 2130049 | 2022-01-19 | Wabasha | Minnesota | 27157 | 4552 | 13 |
2126795 | 2126795 | 2022-01-18 | Wabasha | Minnesota | 27157 | 4417 | 13 |
2123543 | 2123543 | 2022-01-17 | Wabasha | Minnesota | 27157 | 4399 | 13 |
2120291 | 2120291 | 2022-01-16 | Wabasha | Minnesota | 27157 | 4399 | 13 |
2117039 | 2117039 | 2022-01-15 | Wabasha | Minnesota | 27157 | 4399 | 13 |
2113788 | 2113788 | 2022-01-14 | Wabasha | Minnesota | 27157 | 4399 | 13 |
2110536 | 2110536 | 2022-01-13 | Wabasha | Minnesota | 27157 | 4378 | 13 |
2107285 | 2107285 | 2022-01-12 | Wabasha | Minnesota | 27157 | 4347 | 13 |
2104034 | 2104034 | 2022-01-11 | Wabasha | Minnesota | 27157 | 4322 | 13 |
2100783 | 2100783 | 2022-01-10 | Wabasha | Minnesota | 27157 | 4222 | 13 |
2097532 | 2097532 | 2022-01-09 | Wabasha | Minnesota | 27157 | 4201 | 13 |
2094280 | 2094280 | 2022-01-08 | Wabasha | Minnesota | 27157 | 4201 | 13 |
2091028 | 2091028 | 2022-01-07 | Wabasha | Minnesota | 27157 | 4201 | 13 |
2087777 | 2087777 | 2022-01-06 | Wabasha | Minnesota | 27157 | 4175 | 13 |
2084525 | 2084525 | 2022-01-05 | Wabasha | Minnesota | 27157 | 4160 | 13 |
2081273 | 2081273 | 2022-01-04 | Wabasha | Minnesota | 27157 | 4148 | 12 |
2078021 | 2078021 | 2022-01-03 | Wabasha | Minnesota | 27157 | 4126 | 12 |
2074770 | 2074770 | 2022-01-02 | Wabasha | Minnesota | 27157 | 4118 | 12 |
2071519 | 2071519 | 2022-01-01 | Wabasha | Minnesota | 27157 | 4118 | 12 |
2068268 | 2068268 | 2021-12-31 | Wabasha | Minnesota | 27157 | 4118 | 12 |
2065017 | 2065017 | 2021-12-30 | Wabasha | Minnesota | 27157 | 4118 | 12 |
2061767 | 2061767 | 2021-12-29 | Wabasha | Minnesota | 27157 | 4106 | 12 |
2058518 | 2058518 | 2021-12-28 | Wabasha | Minnesota | 27157 | 4095 | 12 |
2055269 | 2055269 | 2021-12-27 | Wabasha | Minnesota | 27157 | 4064 | 12 |
2052019 | 2052019 | 2021-12-26 | Wabasha | Minnesota | 27157 | 4055 | 12 |
2048769 | 2048769 | 2021-12-25 | Wabasha | Minnesota | 27157 | 4055 | 12 |
2045519 | 2045519 | 2021-12-24 | Wabasha | Minnesota | 27157 | 4055 | 12 |
2042269 | 2042269 | 2021-12-23 | Wabasha | Minnesota | 27157 | 4055 | 12 |
2039020 | 2039020 | 2021-12-22 | Wabasha | Minnesota | 27157 | 4053 | 12 |
2035770 | 2035770 | 2021-12-21 | Wabasha | Minnesota | 27157 | 4045 | 12 |
2032520 | 2032520 | 2021-12-20 | Wabasha | Minnesota | 27157 | 4015 | 11 |
2029269 | 2029269 | 2021-12-19 | Wabasha | Minnesota | 27157 | 4004 | 11 |
2026018 | 2026018 | 2021-12-18 | Wabasha | Minnesota | 27157 | 4004 | 11 |
2022767 | 2022767 | 2021-12-17 | Wabasha | Minnesota | 27157 | 4004 | 11 |
2019516 | 2019516 | 2021-12-16 | Wabasha | Minnesota | 27157 | 3989 | 11 |
2016266 | 2016266 | 2021-12-15 | Wabasha | Minnesota | 27157 | 3981 | 11 |
2013015 | 2013015 | 2021-12-14 | Wabasha | Minnesota | 27157 | 3966 | 11 |
2009764 | 2009764 | 2021-12-13 | Wabasha | Minnesota | 27157 | 3926 | 11 |
2006513 | 2006513 | 2021-12-12 | Wabasha | Minnesota | 27157 | 3910 | 10 |
2003262 | 2003262 | 2021-12-11 | Wabasha | Minnesota | 27157 | 3910 | 10 |
2000012 | 2000012 | 2021-12-10 | Wabasha | Minnesota | 27157 | 3910 | 10 |
1996761 | 1996761 | 2021-12-09 | Wabasha | Minnesota | 27157 | 3900 | 10 |
1993510 | 1993510 | 2021-12-08 | Wabasha | Minnesota | 27157 | 3880 | 10 |
1990259 | 1990259 | 2021-12-07 | Wabasha | Minnesota | 27157 | 3876 | 10 |
1987009 | 1987009 | 2021-12-06 | Wabasha | Minnesota | 27157 | 3828 | 10 |
1983759 | 1983759 | 2021-12-05 | Wabasha | Minnesota | 27157 | 3801 | 10 |
1980509 | 1980509 | 2021-12-04 | Wabasha | Minnesota | 27157 | 3801 | 10 |
1977259 | 1977259 | 2021-12-03 | Wabasha | Minnesota | 27157 | 3801 | 10 |
1974009 | 1974009 | 2021-12-02 | Wabasha | Minnesota | 27157 | 3774 | 10 |
1970760 | 1970760 | 2021-12-01 | Wabasha | Minnesota | 27157 | 3755 | 10 |
1967510 | 1967510 | 2021-11-30 | Wabasha | Minnesota | 27157 | 3736 | 10 |
1964258 | 1964258 | 2021-11-29 | Wabasha | Minnesota | 27157 | 3692 | 10 |
1961007 | 1961007 | 2021-11-28 | Wabasha | Minnesota | 27157 | 3660 | 10 |
1957756 | 1957756 | 2021-11-27 | Wabasha | Minnesota | 27157 | 3660 | 10 |
1954505 | 1954505 | 2021-11-26 | Wabasha | Minnesota | 27157 | 3660 | 10 |
1951254 | 1951254 | 2021-11-25 | Wabasha | Minnesota | 27157 | 3637 | 10 |
1948003 | 1948003 | 2021-11-24 | Wabasha | Minnesota | 27157 | 3637 | 10 |
1944752 | 1944752 | 2021-11-23 | Wabasha | Minnesota | 27157 | 3617 | 10 |
1941501 | 1941501 | 2021-11-22 | Wabasha | Minnesota | 27157 | 3576 | 9 |
1938251 | 1938251 | 2021-11-21 | Wabasha | Minnesota | 27157 | 3560 | 9 |
1935001 | 1935001 | 2021-11-20 | Wabasha | Minnesota | 27157 | 3560 | 9 |
1931751 | 1931751 | 2021-11-19 | Wabasha | Minnesota | 27157 | 3560 | 9 |
1928500 | 1928500 | 2021-11-18 | Wabasha | Minnesota | 27157 | 3529 | 9 |
1925250 | 1925250 | 2021-11-17 | Wabasha | Minnesota | 27157 | 3513 | 9 |
1922001 | 1922001 | 2021-11-16 | Wabasha | Minnesota | 27157 | 3500 | 9 |
1918751 | 1918751 | 2021-11-15 | Wabasha | Minnesota | 27157 | 3438 | 9 |
1915501 | 1915501 | 2021-11-14 | Wabasha | Minnesota | 27157 | 3411 | 9 |
1912251 | 1912251 | 2021-11-13 | Wabasha | Minnesota | 27157 | 3411 | 9 |
1909001 | 1909001 | 2021-11-12 | Wabasha | Minnesota | 27157 | 3411 | 9 |
1905752 | 1905752 | 2021-11-11 | Wabasha | Minnesota | 27157 | 3383 | 8 |
1902503 | 1902503 | 2021-11-10 | Wabasha | Minnesota | 27157 | 3361 | 8 |
1899253 | 1899253 | 2021-11-09 | Wabasha | Minnesota | 27157 | 3331 | 8 |
1896003 | 1896003 | 2021-11-08 | Wabasha | Minnesota | 27157 | 3308 | 8 |
1892753 | 1892753 | 2021-11-07 | Wabasha | Minnesota | 27157 | 3285 | 8 |
1889503 | 1889503 | 2021-11-06 | Wabasha | Minnesota | 27157 | 3285 | 8 |
1886253 | 1886253 | 2021-11-05 | Wabasha | Minnesota | 27157 | 3285 | 8 |
1883004 | 1883004 | 2021-11-04 | Wabasha | Minnesota | 27157 | 3274 | 8 |
1879755 | 1879755 | 2021-11-03 | Wabasha | Minnesota | 27157 | 3237 | 8 |
1876506 | 1876506 | 2021-11-02 | Wabasha | Minnesota | 27157 | 3209 | 8 |
1873257 | 1873257 | 2021-11-01 | Wabasha | Minnesota | 27157 | 3163 | 8 |
1870008 | 1870008 | 2021-10-31 | Wabasha | Minnesota | 27157 | 3127 | 8 |
1866759 | 1866759 | 2021-10-30 | Wabasha | Minnesota | 27157 | 3127 | 8 |
1863510 | 1863510 | 2021-10-29 | Wabasha | Minnesota | 27157 | 3127 | 8 |
1860261 | 1860261 | 2021-10-28 | Wabasha | Minnesota | 27157 | 3092 | 8 |
1857012 | 1857012 | 2021-10-27 | Wabasha | Minnesota | 27157 | 3076 | 8 |
1853763 | 1853763 | 2021-10-26 | Wabasha | Minnesota | 27157 | 3060 | 8 |
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);