ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 27145 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175595 | 2175595 | 2022-02-02 | Stearns | Minnesota | 27145 | 47823 | 343 |
2172342 | 2172342 | 2022-02-01 | Stearns | Minnesota | 27145 | 47391 | 342 |
2169089 | 2169089 | 2022-01-31 | Stearns | Minnesota | 27145 | 46761 | 340 |
2165834 | 2165834 | 2022-01-30 | Stearns | Minnesota | 27145 | 46065 | 338 |
2162579 | 2162579 | 2022-01-29 | Stearns | Minnesota | 27145 | 46065 | 338 |
2159324 | 2159324 | 2022-01-28 | Stearns | Minnesota | 27145 | 46065 | 338 |
2156070 | 2156070 | 2022-01-27 | Stearns | Minnesota | 27145 | 45744 | 338 |
2152817 | 2152817 | 2022-01-26 | Stearns | Minnesota | 27145 | 44815 | 337 |
2149565 | 2149565 | 2022-01-25 | Stearns | Minnesota | 27145 | 44460 | 333 |
2146313 | 2146313 | 2022-01-24 | Stearns | Minnesota | 27145 | 43601 | 333 |
2143058 | 2143058 | 2022-01-23 | Stearns | Minnesota | 27145 | 43259 | 333 |
2139803 | 2139803 | 2022-01-22 | Stearns | Minnesota | 27145 | 43259 | 333 |
2136547 | 2136547 | 2022-01-21 | Stearns | Minnesota | 27145 | 43259 | 333 |
2133295 | 2133295 | 2022-01-20 | Stearns | Minnesota | 27145 | 42766 | 332 |
2130042 | 2130042 | 2022-01-19 | Stearns | Minnesota | 27145 | 42286 | 330 |
2126788 | 2126788 | 2022-01-18 | Stearns | Minnesota | 27145 | 41043 | 330 |
2123536 | 2123536 | 2022-01-17 | Stearns | Minnesota | 27145 | 40702 | 329 |
2120284 | 2120284 | 2022-01-16 | Stearns | Minnesota | 27145 | 40702 | 329 |
2117032 | 2117032 | 2022-01-15 | Stearns | Minnesota | 27145 | 40702 | 329 |
2113781 | 2113781 | 2022-01-14 | Stearns | Minnesota | 27145 | 40702 | 329 |
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 |
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);