ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 27145 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110529 | 2110529 | 2022-01-13 | Stearns | Minnesota | 27145 | 40179 | 328 |
2107278 | 2107278 | 2022-01-12 | Stearns | Minnesota | 27145 | 39749 | 322 |
2104027 | 2104027 | 2022-01-11 | Stearns | Minnesota | 27145 | 39519 | 322 |
2100776 | 2100776 | 2022-01-10 | Stearns | Minnesota | 27145 | 38403 | 322 |
2097525 | 2097525 | 2022-01-09 | Stearns | Minnesota | 27145 | 38068 | 321 |
2094273 | 2094273 | 2022-01-08 | Stearns | Minnesota | 27145 | 38068 | 321 |
2091021 | 2091021 | 2022-01-07 | Stearns | Minnesota | 27145 | 38068 | 321 |
2087770 | 2087770 | 2022-01-06 | Stearns | Minnesota | 27145 | 37643 | 321 |
2084518 | 2084518 | 2022-01-05 | Stearns | Minnesota | 27145 | 37529 | 320 |
2081266 | 2081266 | 2022-01-04 | Stearns | Minnesota | 27145 | 37455 | 316 |
2078014 | 2078014 | 2022-01-03 | Stearns | Minnesota | 27145 | 37250 | 314 |
2074763 | 2074763 | 2022-01-02 | Stearns | Minnesota | 27145 | 37185 | 311 |
2071512 | 2071512 | 2022-01-01 | Stearns | Minnesota | 27145 | 37185 | 311 |
2068261 | 2068261 | 2021-12-31 | Stearns | Minnesota | 27145 | 37185 | 311 |
2065010 | 2065010 | 2021-12-30 | Stearns | Minnesota | 27145 | 37185 | 311 |
2061760 | 2061760 | 2021-12-29 | Stearns | Minnesota | 27145 | 37020 | 311 |
2058511 | 2058511 | 2021-12-28 | Stearns | Minnesota | 27145 | 36903 | 310 |
2055262 | 2055262 | 2021-12-27 | Stearns | Minnesota | 27145 | 36613 | 309 |
2052012 | 2052012 | 2021-12-26 | Stearns | Minnesota | 27145 | 36480 | 306 |
2048762 | 2048762 | 2021-12-25 | Stearns | Minnesota | 27145 | 36480 | 306 |
2045512 | 2045512 | 2021-12-24 | Stearns | Minnesota | 27145 | 36480 | 306 |
2042262 | 2042262 | 2021-12-23 | Stearns | Minnesota | 27145 | 36480 | 306 |
2039013 | 2039013 | 2021-12-22 | Stearns | Minnesota | 27145 | 36384 | 303 |
2035763 | 2035763 | 2021-12-21 | Stearns | Minnesota | 27145 | 36313 | 303 |
2032513 | 2032513 | 2021-12-20 | Stearns | Minnesota | 27145 | 36089 | 300 |
2029262 | 2029262 | 2021-12-19 | Stearns | Minnesota | 27145 | 35975 | 298 |
2026011 | 2026011 | 2021-12-18 | Stearns | Minnesota | 27145 | 35975 | 298 |
2022760 | 2022760 | 2021-12-17 | Stearns | Minnesota | 27145 | 35975 | 298 |
2019509 | 2019509 | 2021-12-16 | Stearns | Minnesota | 27145 | 35860 | 298 |
2016259 | 2016259 | 2021-12-15 | Stearns | Minnesota | 27145 | 35708 | 298 |
2013008 | 2013008 | 2021-12-14 | Stearns | Minnesota | 27145 | 35618 | 298 |
2009757 | 2009757 | 2021-12-13 | Stearns | Minnesota | 27145 | 35262 | 297 |
2006506 | 2006506 | 2021-12-12 | Stearns | Minnesota | 27145 | 35130 | 296 |
2003255 | 2003255 | 2021-12-11 | Stearns | Minnesota | 27145 | 35130 | 296 |
2000005 | 2000005 | 2021-12-10 | Stearns | Minnesota | 27145 | 35130 | 296 |
1996754 | 1996754 | 2021-12-09 | Stearns | Minnesota | 27145 | 34958 | 295 |
1993503 | 1993503 | 2021-12-08 | Stearns | Minnesota | 27145 | 34789 | 293 |
1990252 | 1990252 | 2021-12-07 | Stearns | Minnesota | 27145 | 34679 | 289 |
1987002 | 1987002 | 2021-12-06 | Stearns | Minnesota | 27145 | 34249 | 288 |
1983752 | 1983752 | 2021-12-05 | Stearns | Minnesota | 27145 | 34021 | 287 |
1980502 | 1980502 | 2021-12-04 | Stearns | Minnesota | 27145 | 34021 | 287 |
1977252 | 1977252 | 2021-12-03 | Stearns | Minnesota | 27145 | 34021 | 287 |
1974002 | 1974002 | 2021-12-02 | Stearns | Minnesota | 27145 | 33805 | 283 |
1970753 | 1970753 | 2021-12-01 | Stearns | Minnesota | 27145 | 33631 | 279 |
1967503 | 1967503 | 2021-11-30 | Stearns | Minnesota | 27145 | 33475 | 276 |
1964251 | 1964251 | 2021-11-29 | Stearns | Minnesota | 27145 | 32978 | 276 |
1961000 | 1961000 | 2021-11-28 | Stearns | Minnesota | 27145 | 32821 | 275 |
1957749 | 1957749 | 2021-11-27 | Stearns | Minnesota | 27145 | 32821 | 275 |
1954498 | 1954498 | 2021-11-26 | Stearns | Minnesota | 27145 | 32821 | 275 |
1951247 | 1951247 | 2021-11-25 | Stearns | Minnesota | 27145 | 32672 | 274 |
1947996 | 1947996 | 2021-11-24 | Stearns | Minnesota | 27145 | 32672 | 274 |
1944745 | 1944745 | 2021-11-23 | Stearns | Minnesota | 27145 | 32543 | 271 |
1941494 | 1941494 | 2021-11-22 | Stearns | Minnesota | 27145 | 32146 | 271 |
1938244 | 1938244 | 2021-11-21 | Stearns | Minnesota | 27145 | 31982 | 270 |
1934994 | 1934994 | 2021-11-20 | Stearns | Minnesota | 27145 | 31982 | 270 |
1931744 | 1931744 | 2021-11-19 | Stearns | Minnesota | 27145 | 31982 | 270 |
1928493 | 1928493 | 2021-11-18 | Stearns | Minnesota | 27145 | 31791 | 270 |
1925243 | 1925243 | 2021-11-17 | Stearns | Minnesota | 27145 | 31591 | 269 |
1921994 | 1921994 | 2021-11-16 | Stearns | Minnesota | 27145 | 31493 | 268 |
1918744 | 1918744 | 2021-11-15 | Stearns | Minnesota | 27145 | 31142 | 263 |
1915494 | 1915494 | 2021-11-14 | Stearns | Minnesota | 27145 | 30974 | 263 |
1912244 | 1912244 | 2021-11-13 | Stearns | Minnesota | 27145 | 30974 | 263 |
1908994 | 1908994 | 2021-11-12 | Stearns | Minnesota | 27145 | 30974 | 263 |
1905745 | 1905745 | 2021-11-11 | Stearns | Minnesota | 27145 | 30823 | 262 |
1902496 | 1902496 | 2021-11-10 | Stearns | Minnesota | 27145 | 30635 | 261 |
1899246 | 1899246 | 2021-11-09 | Stearns | Minnesota | 27145 | 30475 | 261 |
1895996 | 1895996 | 2021-11-08 | Stearns | Minnesota | 27145 | 30255 | 260 |
1892746 | 1892746 | 2021-11-07 | Stearns | Minnesota | 27145 | 30110 | 260 |
1889496 | 1889496 | 2021-11-06 | Stearns | Minnesota | 27145 | 30110 | 260 |
1886246 | 1886246 | 2021-11-05 | Stearns | Minnesota | 27145 | 30110 | 260 |
1882997 | 1882997 | 2021-11-04 | Stearns | Minnesota | 27145 | 29998 | 259 |
1879748 | 1879748 | 2021-11-03 | Stearns | Minnesota | 27145 | 29849 | 259 |
1876499 | 1876499 | 2021-11-02 | Stearns | Minnesota | 27145 | 29763 | 259 |
1873250 | 1873250 | 2021-11-01 | Stearns | Minnesota | 27145 | 29547 | 259 |
1870001 | 1870001 | 2021-10-31 | Stearns | Minnesota | 27145 | 29213 | 259 |
1866752 | 1866752 | 2021-10-30 | Stearns | Minnesota | 27145 | 29213 | 259 |
1863503 | 1863503 | 2021-10-29 | Stearns | Minnesota | 27145 | 29213 | 259 |
1860254 | 1860254 | 2021-10-28 | Stearns | Minnesota | 27145 | 29087 | 258 |
1857005 | 1857005 | 2021-10-27 | Stearns | Minnesota | 27145 | 28957 | 257 |
1853756 | 1853756 | 2021-10-26 | Stearns | Minnesota | 27145 | 28901 | 255 |
1850507 | 1850507 | 2021-10-25 | Stearns | Minnesota | 27145 | 28657 | 254 |
1847257 | 1847257 | 2021-10-24 | Stearns | Minnesota | 27145 | 28419 | 253 |
1844007 | 1844007 | 2021-10-23 | Stearns | Minnesota | 27145 | 28419 | 253 |
1840757 | 1840757 | 2021-10-22 | Stearns | Minnesota | 27145 | 28419 | 253 |
1837508 | 1837508 | 2021-10-21 | Stearns | Minnesota | 27145 | 28397 | 253 |
1834259 | 1834259 | 2021-10-20 | Stearns | Minnesota | 27145 | 28364 | 253 |
1831010 | 1831010 | 2021-10-19 | Stearns | Minnesota | 27145 | 28298 | 252 |
1827761 | 1827761 | 2021-10-18 | Stearns | Minnesota | 27145 | 28036 | 252 |
1824512 | 1824512 | 2021-10-17 | Stearns | Minnesota | 27145 | 27922 | 252 |
1821263 | 1821263 | 2021-10-16 | Stearns | Minnesota | 27145 | 27922 | 252 |
1818014 | 1818014 | 2021-10-15 | Stearns | Minnesota | 27145 | 27922 | 252 |
1814765 | 1814765 | 2021-10-14 | Stearns | Minnesota | 27145 | 27814 | 252 |
1811517 | 1811517 | 2021-10-13 | Stearns | Minnesota | 27145 | 27701 | 252 |
1808268 | 1808268 | 2021-10-12 | Stearns | Minnesota | 27145 | 27602 | 251 |
1805017 | 1805017 | 2021-10-11 | Stearns | Minnesota | 27145 | 27241 | 251 |
1801768 | 1801768 | 2021-10-10 | Stearns | Minnesota | 27145 | 27119 | 251 |
1798519 | 1798519 | 2021-10-09 | Stearns | Minnesota | 27145 | 27119 | 251 |
1795270 | 1795270 | 2021-10-08 | Stearns | Minnesota | 27145 | 27119 | 251 |
1792021 | 1792021 | 2021-10-07 | Stearns | Minnesota | 27145 | 26986 | 251 |
1788772 | 1788772 | 2021-10-06 | Stearns | Minnesota | 27145 | 26864 | 249 |
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);