ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lincoln" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175563 | 2175563 | 2022-02-02 | Lincoln | Minnesota | 27081 | 1165 | 5 |
2172310 | 2172310 | 2022-02-01 | Lincoln | Minnesota | 27081 | 1163 | 5 |
2169057 | 2169057 | 2022-01-31 | Lincoln | Minnesota | 27081 | 1145 | 5 |
2165802 | 2165802 | 2022-01-30 | Lincoln | Minnesota | 27081 | 1139 | 5 |
2162547 | 2162547 | 2022-01-29 | Lincoln | Minnesota | 27081 | 1139 | 5 |
2159292 | 2159292 | 2022-01-28 | Lincoln | Minnesota | 27081 | 1139 | 5 |
2156038 | 2156038 | 2022-01-27 | Lincoln | Minnesota | 27081 | 1129 | 5 |
2152785 | 2152785 | 2022-01-26 | Lincoln | Minnesota | 27081 | 1111 | 5 |
2149533 | 2149533 | 2022-01-25 | Lincoln | Minnesota | 27081 | 1102 | 5 |
2146281 | 2146281 | 2022-01-24 | Lincoln | Minnesota | 27081 | 1075 | 5 |
2143026 | 2143026 | 2022-01-23 | Lincoln | Minnesota | 27081 | 1065 | 5 |
2139771 | 2139771 | 2022-01-22 | Lincoln | Minnesota | 27081 | 1065 | 5 |
2136515 | 2136515 | 2022-01-21 | Lincoln | Minnesota | 27081 | 1065 | 5 |
2133263 | 2133263 | 2022-01-20 | Lincoln | Minnesota | 27081 | 1050 | 5 |
2130010 | 2130010 | 2022-01-19 | Lincoln | Minnesota | 27081 | 1037 | 5 |
2126756 | 2126756 | 2022-01-18 | Lincoln | Minnesota | 27081 | 1015 | 5 |
2123504 | 2123504 | 2022-01-17 | Lincoln | Minnesota | 27081 | 1007 | 5 |
2120252 | 2120252 | 2022-01-16 | Lincoln | Minnesota | 27081 | 1007 | 5 |
2117000 | 2117000 | 2022-01-15 | Lincoln | Minnesota | 27081 | 1007 | 5 |
2113749 | 2113749 | 2022-01-14 | Lincoln | Minnesota | 27081 | 1007 | 5 |
2110497 | 2110497 | 2022-01-13 | Lincoln | Minnesota | 27081 | 1002 | 5 |
2107246 | 2107246 | 2022-01-12 | Lincoln | Minnesota | 27081 | 994 | 5 |
2103995 | 2103995 | 2022-01-11 | Lincoln | Minnesota | 27081 | 986 | 5 |
2100744 | 2100744 | 2022-01-10 | Lincoln | Minnesota | 27081 | 973 | 5 |
2097493 | 2097493 | 2022-01-09 | Lincoln | Minnesota | 27081 | 967 | 5 |
2094241 | 2094241 | 2022-01-08 | Lincoln | Minnesota | 27081 | 967 | 5 |
2090989 | 2090989 | 2022-01-07 | Lincoln | Minnesota | 27081 | 967 | 5 |
2087738 | 2087738 | 2022-01-06 | Lincoln | Minnesota | 27081 | 964 | 5 |
2084486 | 2084486 | 2022-01-05 | Lincoln | Minnesota | 27081 | 963 | 5 |
2081234 | 2081234 | 2022-01-04 | Lincoln | Minnesota | 27081 | 960 | 5 |
2077982 | 2077982 | 2022-01-03 | Lincoln | Minnesota | 27081 | 953 | 5 |
2074731 | 2074731 | 2022-01-02 | Lincoln | Minnesota | 27081 | 947 | 5 |
2071480 | 2071480 | 2022-01-01 | Lincoln | Minnesota | 27081 | 947 | 5 |
2068229 | 2068229 | 2021-12-31 | Lincoln | Minnesota | 27081 | 947 | 5 |
2064978 | 2064978 | 2021-12-30 | Lincoln | Minnesota | 27081 | 947 | 5 |
2061728 | 2061728 | 2021-12-29 | Lincoln | Minnesota | 27081 | 942 | 5 |
2058479 | 2058479 | 2021-12-28 | Lincoln | Minnesota | 27081 | 941 | 5 |
2055230 | 2055230 | 2021-12-27 | Lincoln | Minnesota | 27081 | 939 | 5 |
2051980 | 2051980 | 2021-12-26 | Lincoln | Minnesota | 27081 | 936 | 5 |
2048730 | 2048730 | 2021-12-25 | Lincoln | Minnesota | 27081 | 936 | 5 |
2045480 | 2045480 | 2021-12-24 | Lincoln | Minnesota | 27081 | 936 | 5 |
2042230 | 2042230 | 2021-12-23 | Lincoln | Minnesota | 27081 | 936 | 5 |
2038981 | 2038981 | 2021-12-22 | Lincoln | Minnesota | 27081 | 934 | 5 |
2035731 | 2035731 | 2021-12-21 | Lincoln | Minnesota | 27081 | 930 | 5 |
2032481 | 2032481 | 2021-12-20 | Lincoln | Minnesota | 27081 | 929 | 5 |
2029230 | 2029230 | 2021-12-19 | Lincoln | Minnesota | 27081 | 928 | 5 |
2025979 | 2025979 | 2021-12-18 | Lincoln | Minnesota | 27081 | 928 | 5 |
2022728 | 2022728 | 2021-12-17 | Lincoln | Minnesota | 27081 | 928 | 5 |
2019477 | 2019477 | 2021-12-16 | Lincoln | Minnesota | 27081 | 925 | 5 |
2016227 | 2016227 | 2021-12-15 | Lincoln | Minnesota | 27081 | 925 | 5 |
2012976 | 2012976 | 2021-12-14 | Lincoln | Minnesota | 27081 | 923 | 5 |
2009725 | 2009725 | 2021-12-13 | Lincoln | Minnesota | 27081 | 919 | 5 |
2006474 | 2006474 | 2021-12-12 | Lincoln | Minnesota | 27081 | 916 | 5 |
2003223 | 2003223 | 2021-12-11 | Lincoln | Minnesota | 27081 | 916 | 5 |
1999973 | 1999973 | 2021-12-10 | Lincoln | Minnesota | 27081 | 916 | 5 |
1996722 | 1996722 | 2021-12-09 | Lincoln | Minnesota | 27081 | 915 | 5 |
1993471 | 1993471 | 2021-12-08 | Lincoln | Minnesota | 27081 | 910 | 5 |
1990220 | 1990220 | 2021-12-07 | Lincoln | Minnesota | 27081 | 907 | 5 |
1986970 | 1986970 | 2021-12-06 | Lincoln | Minnesota | 27081 | 901 | 5 |
1983720 | 1983720 | 2021-12-05 | Lincoln | Minnesota | 27081 | 891 | 5 |
1980470 | 1980470 | 2021-12-04 | Lincoln | Minnesota | 27081 | 891 | 5 |
1977220 | 1977220 | 2021-12-03 | Lincoln | Minnesota | 27081 | 891 | 5 |
1973970 | 1973970 | 2021-12-02 | Lincoln | Minnesota | 27081 | 888 | 5 |
1970721 | 1970721 | 2021-12-01 | Lincoln | Minnesota | 27081 | 880 | 5 |
1967471 | 1967471 | 2021-11-30 | Lincoln | Minnesota | 27081 | 874 | 5 |
1964219 | 1964219 | 2021-11-29 | Lincoln | Minnesota | 27081 | 872 | 5 |
1960968 | 1960968 | 2021-11-28 | Lincoln | Minnesota | 27081 | 870 | 5 |
1957717 | 1957717 | 2021-11-27 | Lincoln | Minnesota | 27081 | 870 | 5 |
1954466 | 1954466 | 2021-11-26 | Lincoln | Minnesota | 27081 | 870 | 5 |
1951215 | 1951215 | 2021-11-25 | Lincoln | Minnesota | 27081 | 866 | 5 |
1947964 | 1947964 | 2021-11-24 | Lincoln | Minnesota | 27081 | 866 | 5 |
1944713 | 1944713 | 2021-11-23 | Lincoln | Minnesota | 27081 | 866 | 5 |
1941462 | 1941462 | 2021-11-22 | Lincoln | Minnesota | 27081 | 859 | 5 |
1938212 | 1938212 | 2021-11-21 | Lincoln | Minnesota | 27081 | 857 | 5 |
1934962 | 1934962 | 2021-11-20 | Lincoln | Minnesota | 27081 | 857 | 5 |
1931712 | 1931712 | 2021-11-19 | Lincoln | Minnesota | 27081 | 857 | 5 |
1928461 | 1928461 | 2021-11-18 | Lincoln | Minnesota | 27081 | 853 | 5 |
1925211 | 1925211 | 2021-11-17 | Lincoln | Minnesota | 27081 | 851 | 5 |
1921962 | 1921962 | 2021-11-16 | Lincoln | Minnesota | 27081 | 848 | 5 |
1918712 | 1918712 | 2021-11-15 | Lincoln | Minnesota | 27081 | 845 | 5 |
1915462 | 1915462 | 2021-11-14 | Lincoln | Minnesota | 27081 | 844 | 5 |
1912212 | 1912212 | 2021-11-13 | Lincoln | Minnesota | 27081 | 844 | 5 |
1908962 | 1908962 | 2021-11-12 | Lincoln | Minnesota | 27081 | 844 | 5 |
1905713 | 1905713 | 2021-11-11 | Lincoln | Minnesota | 27081 | 844 | 5 |
1902464 | 1902464 | 2021-11-10 | Lincoln | Minnesota | 27081 | 837 | 5 |
1899214 | 1899214 | 2021-11-09 | Lincoln | Minnesota | 27081 | 834 | 5 |
1895964 | 1895964 | 2021-11-08 | Lincoln | Minnesota | 27081 | 832 | 5 |
1892714 | 1892714 | 2021-11-07 | Lincoln | Minnesota | 27081 | 827 | 5 |
1889464 | 1889464 | 2021-11-06 | Lincoln | Minnesota | 27081 | 827 | 5 |
1886214 | 1886214 | 2021-11-05 | Lincoln | Minnesota | 27081 | 827 | 5 |
1882965 | 1882965 | 2021-11-04 | Lincoln | Minnesota | 27081 | 821 | 5 |
1879716 | 1879716 | 2021-11-03 | Lincoln | Minnesota | 27081 | 815 | 5 |
1876467 | 1876467 | 2021-11-02 | Lincoln | Minnesota | 27081 | 814 | 5 |
1873218 | 1873218 | 2021-11-01 | Lincoln | Minnesota | 27081 | 812 | 5 |
1869969 | 1869969 | 2021-10-31 | Lincoln | Minnesota | 27081 | 800 | 5 |
1866720 | 1866720 | 2021-10-30 | Lincoln | Minnesota | 27081 | 800 | 5 |
1863471 | 1863471 | 2021-10-29 | Lincoln | Minnesota | 27081 | 800 | 5 |
1860222 | 1860222 | 2021-10-28 | Lincoln | Minnesota | 27081 | 796 | 5 |
1856973 | 1856973 | 2021-10-27 | Lincoln | Minnesota | 27081 | 793 | 5 |
1853724 | 1853724 | 2021-10-26 | Lincoln | Minnesota | 27081 | 789 | 5 |
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);