ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 27131 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175588 | 2175588 | 2022-02-02 | Rice | Minnesota | 27131 | 16534 | 162 |
2172335 | 2172335 | 2022-02-01 | Rice | Minnesota | 27131 | 16443 | 159 |
2169082 | 2169082 | 2022-01-31 | Rice | Minnesota | 27131 | 16191 | 159 |
2165827 | 2165827 | 2022-01-30 | Rice | Minnesota | 27131 | 16024 | 159 |
2162572 | 2162572 | 2022-01-29 | Rice | Minnesota | 27131 | 16024 | 159 |
2159317 | 2159317 | 2022-01-28 | Rice | Minnesota | 27131 | 16024 | 159 |
2156063 | 2156063 | 2022-01-27 | Rice | Minnesota | 27131 | 15899 | 159 |
2152810 | 2152810 | 2022-01-26 | Rice | Minnesota | 27131 | 15752 | 157 |
2149558 | 2149558 | 2022-01-25 | Rice | Minnesota | 27131 | 15353 | 156 |
2146306 | 2146306 | 2022-01-24 | Rice | Minnesota | 27131 | 14931 | 156 |
2143051 | 2143051 | 2022-01-23 | Rice | Minnesota | 27131 | 14803 | 156 |
2139796 | 2139796 | 2022-01-22 | Rice | Minnesota | 27131 | 14803 | 156 |
2136540 | 2136540 | 2022-01-21 | Rice | Minnesota | 27131 | 14803 | 156 |
2133288 | 2133288 | 2022-01-20 | Rice | Minnesota | 27131 | 14585 | 156 |
2130035 | 2130035 | 2022-01-19 | Rice | Minnesota | 27131 | 14437 | 156 |
2126781 | 2126781 | 2022-01-18 | Rice | Minnesota | 27131 | 13804 | 155 |
2123529 | 2123529 | 2022-01-17 | Rice | Minnesota | 27131 | 13712 | 154 |
2120277 | 2120277 | 2022-01-16 | Rice | Minnesota | 27131 | 13712 | 154 |
2117025 | 2117025 | 2022-01-15 | Rice | Minnesota | 27131 | 13712 | 154 |
2113774 | 2113774 | 2022-01-14 | Rice | Minnesota | 27131 | 13712 | 154 |
2110522 | 2110522 | 2022-01-13 | Rice | Minnesota | 27131 | 13616 | 152 |
2107271 | 2107271 | 2022-01-12 | Rice | Minnesota | 27131 | 13462 | 152 |
2104020 | 2104020 | 2022-01-11 | Rice | Minnesota | 27131 | 13334 | 152 |
2100769 | 2100769 | 2022-01-10 | Rice | Minnesota | 27131 | 13068 | 152 |
2097518 | 2097518 | 2022-01-09 | Rice | Minnesota | 27131 | 12938 | 151 |
2094266 | 2094266 | 2022-01-08 | Rice | Minnesota | 27131 | 12938 | 151 |
2091014 | 2091014 | 2022-01-07 | Rice | Minnesota | 27131 | 12938 | 151 |
2087763 | 2087763 | 2022-01-06 | Rice | Minnesota | 27131 | 12854 | 151 |
2084511 | 2084511 | 2022-01-05 | Rice | Minnesota | 27131 | 12772 | 151 |
2081259 | 2081259 | 2022-01-04 | Rice | Minnesota | 27131 | 12714 | 149 |
2078007 | 2078007 | 2022-01-03 | Rice | Minnesota | 27131 | 12595 | 149 |
2074756 | 2074756 | 2022-01-02 | Rice | Minnesota | 27131 | 12539 | 148 |
2071505 | 2071505 | 2022-01-01 | Rice | Minnesota | 27131 | 12539 | 148 |
2068254 | 2068254 | 2021-12-31 | Rice | Minnesota | 27131 | 12539 | 148 |
2065003 | 2065003 | 2021-12-30 | Rice | Minnesota | 27131 | 12539 | 148 |
2061753 | 2061753 | 2021-12-29 | Rice | Minnesota | 27131 | 12478 | 147 |
2058504 | 2058504 | 2021-12-28 | Rice | Minnesota | 27131 | 12441 | 147 |
2055255 | 2055255 | 2021-12-27 | Rice | Minnesota | 27131 | 12372 | 147 |
2052005 | 2052005 | 2021-12-26 | Rice | Minnesota | 27131 | 12341 | 147 |
2048755 | 2048755 | 2021-12-25 | Rice | Minnesota | 27131 | 12341 | 147 |
2045505 | 2045505 | 2021-12-24 | Rice | Minnesota | 27131 | 12341 | 147 |
2042255 | 2042255 | 2021-12-23 | Rice | Minnesota | 27131 | 12341 | 147 |
2039006 | 2039006 | 2021-12-22 | Rice | Minnesota | 27131 | 12316 | 147 |
2035756 | 2035756 | 2021-12-21 | Rice | Minnesota | 27131 | 12290 | 147 |
2032506 | 2032506 | 2021-12-20 | Rice | Minnesota | 27131 | 12208 | 147 |
2029255 | 2029255 | 2021-12-19 | Rice | Minnesota | 27131 | 12178 | 147 |
2026004 | 2026004 | 2021-12-18 | Rice | Minnesota | 27131 | 12178 | 147 |
2022753 | 2022753 | 2021-12-17 | Rice | Minnesota | 27131 | 12178 | 147 |
2019502 | 2019502 | 2021-12-16 | Rice | Minnesota | 27131 | 12132 | 147 |
2016252 | 2016252 | 2021-12-15 | Rice | Minnesota | 27131 | 12088 | 147 |
2013001 | 2013001 | 2021-12-14 | Rice | Minnesota | 27131 | 12054 | 147 |
2009750 | 2009750 | 2021-12-13 | Rice | Minnesota | 27131 | 11959 | 147 |
2006499 | 2006499 | 2021-12-12 | Rice | Minnesota | 27131 | 11932 | 146 |
2003248 | 2003248 | 2021-12-11 | Rice | Minnesota | 27131 | 11932 | 146 |
1999998 | 1999998 | 2021-12-10 | Rice | Minnesota | 27131 | 11932 | 146 |
1996747 | 1996747 | 2021-12-09 | Rice | Minnesota | 27131 | 11881 | 145 |
1993496 | 1993496 | 2021-12-08 | Rice | Minnesota | 27131 | 11831 | 144 |
1990245 | 1990245 | 2021-12-07 | Rice | Minnesota | 27131 | 11789 | 141 |
1986995 | 1986995 | 2021-12-06 | Rice | Minnesota | 27131 | 11649 | 141 |
1983745 | 1983745 | 2021-12-05 | Rice | Minnesota | 27131 | 11578 | 139 |
1980495 | 1980495 | 2021-12-04 | Rice | Minnesota | 27131 | 11578 | 139 |
1977245 | 1977245 | 2021-12-03 | Rice | Minnesota | 27131 | 11578 | 139 |
1973995 | 1973995 | 2021-12-02 | Rice | Minnesota | 27131 | 11505 | 139 |
1970746 | 1970746 | 2021-12-01 | Rice | Minnesota | 27131 | 11451 | 138 |
1967496 | 1967496 | 2021-11-30 | Rice | Minnesota | 27131 | 11410 | 138 |
1964244 | 1964244 | 2021-11-29 | Rice | Minnesota | 27131 | 11286 | 138 |
1960993 | 1960993 | 2021-11-28 | Rice | Minnesota | 27131 | 11234 | 138 |
1957742 | 1957742 | 2021-11-27 | Rice | Minnesota | 27131 | 11234 | 138 |
1954491 | 1954491 | 2021-11-26 | Rice | Minnesota | 27131 | 11234 | 138 |
1951240 | 1951240 | 2021-11-25 | Rice | Minnesota | 27131 | 11172 | 138 |
1947989 | 1947989 | 2021-11-24 | Rice | Minnesota | 27131 | 11172 | 138 |
1944738 | 1944738 | 2021-11-23 | Rice | Minnesota | 27131 | 11112 | 137 |
1941487 | 1941487 | 2021-11-22 | Rice | Minnesota | 27131 | 10992 | 137 |
1938237 | 1938237 | 2021-11-21 | Rice | Minnesota | 27131 | 10943 | 137 |
1934987 | 1934987 | 2021-11-20 | Rice | Minnesota | 27131 | 10943 | 137 |
1931737 | 1931737 | 2021-11-19 | Rice | Minnesota | 27131 | 10943 | 137 |
1928486 | 1928486 | 2021-11-18 | Rice | Minnesota | 27131 | 10869 | 137 |
1925236 | 1925236 | 2021-11-17 | Rice | Minnesota | 27131 | 10819 | 137 |
1921987 | 1921987 | 2021-11-16 | Rice | Minnesota | 27131 | 10789 | 137 |
1918737 | 1918737 | 2021-11-15 | Rice | Minnesota | 27131 | 10669 | 136 |
1915487 | 1915487 | 2021-11-14 | Rice | Minnesota | 27131 | 10626 | 136 |
1912237 | 1912237 | 2021-11-13 | Rice | Minnesota | 27131 | 10626 | 136 |
1908987 | 1908987 | 2021-11-12 | Rice | Minnesota | 27131 | 10626 | 136 |
1905738 | 1905738 | 2021-11-11 | Rice | Minnesota | 27131 | 10575 | 136 |
1902489 | 1902489 | 2021-11-10 | Rice | Minnesota | 27131 | 10526 | 136 |
1899239 | 1899239 | 2021-11-09 | Rice | Minnesota | 27131 | 10472 | 135 |
1895989 | 1895989 | 2021-11-08 | Rice | Minnesota | 27131 | 10430 | 135 |
1892739 | 1892739 | 2021-11-07 | Rice | Minnesota | 27131 | 10398 | 134 |
1889489 | 1889489 | 2021-11-06 | Rice | Minnesota | 27131 | 10398 | 134 |
1886239 | 1886239 | 2021-11-05 | Rice | Minnesota | 27131 | 10398 | 134 |
1882990 | 1882990 | 2021-11-04 | Rice | Minnesota | 27131 | 10365 | 133 |
1879741 | 1879741 | 2021-11-03 | Rice | Minnesota | 27131 | 10333 | 133 |
1876492 | 1876492 | 2021-11-02 | Rice | Minnesota | 27131 | 10304 | 132 |
1873243 | 1873243 | 2021-11-01 | Rice | Minnesota | 27131 | 10252 | 132 |
1869994 | 1869994 | 2021-10-31 | Rice | Minnesota | 27131 | 10120 | 132 |
1866745 | 1866745 | 2021-10-30 | Rice | Minnesota | 27131 | 10120 | 132 |
1863496 | 1863496 | 2021-10-29 | Rice | Minnesota | 27131 | 10120 | 132 |
1860247 | 1860247 | 2021-10-28 | Rice | Minnesota | 27131 | 10099 | 131 |
1856998 | 1856998 | 2021-10-27 | Rice | Minnesota | 27131 | 10070 | 131 |
1853749 | 1853749 | 2021-10-26 | Rice | Minnesota | 27131 | 10062 | 131 |
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);