ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Polk" and fips = 27119 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175582 | 2175582 | 2022-02-02 | Polk | Minnesota | 27119 | 7815 | 95 |
2172329 | 2172329 | 2022-02-01 | Polk | Minnesota | 27119 | 7753 | 95 |
2169076 | 2169076 | 2022-01-31 | Polk | Minnesota | 27119 | 7617 | 95 |
2165821 | 2165821 | 2022-01-30 | Polk | Minnesota | 27119 | 7492 | 95 |
2162566 | 2162566 | 2022-01-29 | Polk | Minnesota | 27119 | 7492 | 95 |
2159311 | 2159311 | 2022-01-28 | Polk | Minnesota | 27119 | 7492 | 95 |
2156057 | 2156057 | 2022-01-27 | Polk | Minnesota | 27119 | 7414 | 93 |
2152804 | 2152804 | 2022-01-26 | Polk | Minnesota | 27119 | 7267 | 93 |
2149552 | 2149552 | 2022-01-25 | Polk | Minnesota | 27119 | 7197 | 93 |
2146300 | 2146300 | 2022-01-24 | Polk | Minnesota | 27119 | 7067 | 92 |
2143045 | 2143045 | 2022-01-23 | Polk | Minnesota | 27119 | 7009 | 92 |
2139790 | 2139790 | 2022-01-22 | Polk | Minnesota | 27119 | 7009 | 92 |
2136534 | 2136534 | 2022-01-21 | Polk | Minnesota | 27119 | 7009 | 92 |
2133282 | 2133282 | 2022-01-20 | Polk | Minnesota | 27119 | 6905 | 92 |
2130029 | 2130029 | 2022-01-19 | Polk | Minnesota | 27119 | 6840 | 92 |
2126775 | 2126775 | 2022-01-18 | Polk | Minnesota | 27119 | 6740 | 92 |
2123523 | 2123523 | 2022-01-17 | Polk | Minnesota | 27119 | 6701 | 92 |
2120271 | 2120271 | 2022-01-16 | Polk | Minnesota | 27119 | 6701 | 92 |
2117019 | 2117019 | 2022-01-15 | Polk | Minnesota | 27119 | 6701 | 92 |
2113768 | 2113768 | 2022-01-14 | Polk | Minnesota | 27119 | 6701 | 92 |
2110516 | 2110516 | 2022-01-13 | Polk | Minnesota | 27119 | 6663 | 92 |
2107265 | 2107265 | 2022-01-12 | Polk | Minnesota | 27119 | 6619 | 92 |
2104014 | 2104014 | 2022-01-11 | Polk | Minnesota | 27119 | 6589 | 92 |
2100763 | 2100763 | 2022-01-10 | Polk | Minnesota | 27119 | 6477 | 92 |
2097512 | 2097512 | 2022-01-09 | Polk | Minnesota | 27119 | 6449 | 92 |
2094260 | 2094260 | 2022-01-08 | Polk | Minnesota | 27119 | 6449 | 92 |
2091008 | 2091008 | 2022-01-07 | Polk | Minnesota | 27119 | 6449 | 92 |
2087757 | 2087757 | 2022-01-06 | Polk | Minnesota | 27119 | 6426 | 92 |
2084505 | 2084505 | 2022-01-05 | Polk | Minnesota | 27119 | 6396 | 92 |
2081253 | 2081253 | 2022-01-04 | Polk | Minnesota | 27119 | 6384 | 92 |
2078001 | 2078001 | 2022-01-03 | Polk | Minnesota | 27119 | 6367 | 91 |
2074750 | 2074750 | 2022-01-02 | Polk | Minnesota | 27119 | 6357 | 91 |
2071499 | 2071499 | 2022-01-01 | Polk | Minnesota | 27119 | 6357 | 91 |
2068248 | 2068248 | 2021-12-31 | Polk | Minnesota | 27119 | 6357 | 91 |
2064997 | 2064997 | 2021-12-30 | Polk | Minnesota | 27119 | 6357 | 91 |
2061747 | 2061747 | 2021-12-29 | Polk | Minnesota | 27119 | 6353 | 91 |
2058498 | 2058498 | 2021-12-28 | Polk | Minnesota | 27119 | 6343 | 91 |
2055249 | 2055249 | 2021-12-27 | Polk | Minnesota | 27119 | 6332 | 91 |
2051999 | 2051999 | 2021-12-26 | Polk | Minnesota | 27119 | 6319 | 91 |
2048749 | 2048749 | 2021-12-25 | Polk | Minnesota | 27119 | 6319 | 91 |
2045499 | 2045499 | 2021-12-24 | Polk | Minnesota | 27119 | 6319 | 91 |
2042249 | 2042249 | 2021-12-23 | Polk | Minnesota | 27119 | 6319 | 91 |
2039000 | 2039000 | 2021-12-22 | Polk | Minnesota | 27119 | 6305 | 91 |
2035750 | 2035750 | 2021-12-21 | Polk | Minnesota | 27119 | 6294 | 91 |
2032500 | 2032500 | 2021-12-20 | Polk | Minnesota | 27119 | 6272 | 90 |
2029249 | 2029249 | 2021-12-19 | Polk | Minnesota | 27119 | 6257 | 90 |
2025998 | 2025998 | 2021-12-18 | Polk | Minnesota | 27119 | 6257 | 90 |
2022747 | 2022747 | 2021-12-17 | Polk | Minnesota | 27119 | 6257 | 90 |
2019496 | 2019496 | 2021-12-16 | Polk | Minnesota | 27119 | 6244 | 90 |
2016246 | 2016246 | 2021-12-15 | Polk | Minnesota | 27119 | 6236 | 89 |
2012995 | 2012995 | 2021-12-14 | Polk | Minnesota | 27119 | 6218 | 89 |
2009744 | 2009744 | 2021-12-13 | Polk | Minnesota | 27119 | 6192 | 89 |
2006493 | 2006493 | 2021-12-12 | Polk | Minnesota | 27119 | 6179 | 89 |
2003242 | 2003242 | 2021-12-11 | Polk | Minnesota | 27119 | 6179 | 89 |
1999992 | 1999992 | 2021-12-10 | Polk | Minnesota | 27119 | 6179 | 89 |
1996741 | 1996741 | 2021-12-09 | Polk | Minnesota | 27119 | 6164 | 89 |
1993490 | 1993490 | 2021-12-08 | Polk | Minnesota | 27119 | 6155 | 89 |
1990239 | 1990239 | 2021-12-07 | Polk | Minnesota | 27119 | 6136 | 88 |
1986989 | 1986989 | 2021-12-06 | Polk | Minnesota | 27119 | 6114 | 88 |
1983739 | 1983739 | 2021-12-05 | Polk | Minnesota | 27119 | 6089 | 87 |
1980489 | 1980489 | 2021-12-04 | Polk | Minnesota | 27119 | 6089 | 87 |
1977239 | 1977239 | 2021-12-03 | Polk | Minnesota | 27119 | 6089 | 87 |
1973989 | 1973989 | 2021-12-02 | Polk | Minnesota | 27119 | 6061 | 87 |
1970740 | 1970740 | 2021-12-01 | Polk | Minnesota | 27119 | 6031 | 87 |
1967490 | 1967490 | 2021-11-30 | Polk | Minnesota | 27119 | 5994 | 84 |
1964238 | 1964238 | 2021-11-29 | Polk | Minnesota | 27119 | 5945 | 84 |
1960987 | 1960987 | 2021-11-28 | Polk | Minnesota | 27119 | 5916 | 84 |
1957736 | 1957736 | 2021-11-27 | Polk | Minnesota | 27119 | 5916 | 84 |
1954485 | 1954485 | 2021-11-26 | Polk | Minnesota | 27119 | 5916 | 84 |
1951234 | 1951234 | 2021-11-25 | Polk | Minnesota | 27119 | 5891 | 84 |
1947983 | 1947983 | 2021-11-24 | Polk | Minnesota | 27119 | 5891 | 84 |
1944732 | 1944732 | 2021-11-23 | Polk | Minnesota | 27119 | 5854 | 84 |
1941481 | 1941481 | 2021-11-22 | Polk | Minnesota | 27119 | 5810 | 84 |
1938231 | 1938231 | 2021-11-21 | Polk | Minnesota | 27119 | 5775 | 84 |
1934981 | 1934981 | 2021-11-20 | Polk | Minnesota | 27119 | 5775 | 84 |
1931731 | 1931731 | 2021-11-19 | Polk | Minnesota | 27119 | 5775 | 84 |
1928480 | 1928480 | 2021-11-18 | Polk | Minnesota | 27119 | 5755 | 84 |
1925230 | 1925230 | 2021-11-17 | Polk | Minnesota | 27119 | 5727 | 84 |
1921981 | 1921981 | 2021-11-16 | Polk | Minnesota | 27119 | 5714 | 83 |
1918731 | 1918731 | 2021-11-15 | Polk | Minnesota | 27119 | 5667 | 83 |
1915481 | 1915481 | 2021-11-14 | Polk | Minnesota | 27119 | 5640 | 83 |
1912231 | 1912231 | 2021-11-13 | Polk | Minnesota | 27119 | 5640 | 83 |
1908981 | 1908981 | 2021-11-12 | Polk | Minnesota | 27119 | 5640 | 83 |
1905732 | 1905732 | 2021-11-11 | Polk | Minnesota | 27119 | 5611 | 82 |
1902483 | 1902483 | 2021-11-10 | Polk | Minnesota | 27119 | 5565 | 82 |
1899233 | 1899233 | 2021-11-09 | Polk | Minnesota | 27119 | 5539 | 82 |
1895983 | 1895983 | 2021-11-08 | Polk | Minnesota | 27119 | 5497 | 82 |
1892733 | 1892733 | 2021-11-07 | Polk | Minnesota | 27119 | 5478 | 82 |
1889483 | 1889483 | 2021-11-06 | Polk | Minnesota | 27119 | 5478 | 82 |
1886233 | 1886233 | 2021-11-05 | Polk | Minnesota | 27119 | 5478 | 82 |
1882984 | 1882984 | 2021-11-04 | Polk | Minnesota | 27119 | 5440 | 81 |
1879735 | 1879735 | 2021-11-03 | Polk | Minnesota | 27119 | 5421 | 81 |
1876486 | 1876486 | 2021-11-02 | Polk | Minnesota | 27119 | 5394 | 81 |
1873237 | 1873237 | 2021-11-01 | Polk | Minnesota | 27119 | 5349 | 81 |
1869988 | 1869988 | 2021-10-31 | Polk | Minnesota | 27119 | 5286 | 81 |
1866739 | 1866739 | 2021-10-30 | Polk | Minnesota | 27119 | 5286 | 81 |
1863490 | 1863490 | 2021-10-29 | Polk | Minnesota | 27119 | 5286 | 81 |
1860241 | 1860241 | 2021-10-28 | Polk | Minnesota | 27119 | 5256 | 81 |
1856992 | 1856992 | 2021-10-27 | Polk | Minnesota | 27119 | 5236 | 81 |
1853743 | 1853743 | 2021-10-26 | Polk | Minnesota | 27119 | 5200 | 80 |
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);