ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lincoln" and fips = 29113 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175751 | 2175751 | 2022-02-02 | Lincoln | Missouri | 29113 | 14732 | 111 |
2172498 | 2172498 | 2022-02-01 | Lincoln | Missouri | 29113 | 14592 | 111 |
2169245 | 2169245 | 2022-01-31 | Lincoln | Missouri | 29113 | 14550 | 105 |
2165990 | 2165990 | 2022-01-30 | Lincoln | Missouri | 29113 | 14540 | 105 |
2162735 | 2162735 | 2022-01-29 | Lincoln | Missouri | 29113 | 14524 | 105 |
2159480 | 2159480 | 2022-01-28 | Lincoln | Missouri | 29113 | 14490 | 105 |
2156226 | 2156226 | 2022-01-27 | Lincoln | Missouri | 29113 | 14436 | 105 |
2152973 | 2152973 | 2022-01-26 | Lincoln | Missouri | 29113 | 14367 | 105 |
2149721 | 2149721 | 2022-01-25 | Lincoln | Missouri | 29113 | 14256 | 104 |
2146469 | 2146469 | 2022-01-24 | Lincoln | Missouri | 29113 | 14184 | 104 |
2143214 | 2143214 | 2022-01-23 | Lincoln | Missouri | 29113 | 14132 | 104 |
2139959 | 2139959 | 2022-01-22 | Lincoln | Missouri | 29113 | 14050 | 104 |
2136703 | 2136703 | 2022-01-21 | Lincoln | Missouri | 29113 | 13982 | 104 |
2133451 | 2133451 | 2022-01-20 | Lincoln | Missouri | 29113 | 13805 | 102 |
2130198 | 2130198 | 2022-01-19 | Lincoln | Missouri | 29113 | 13675 | 102 |
2126944 | 2126944 | 2022-01-18 | Lincoln | Missouri | 29113 | 13531 | 101 |
2123692 | 2123692 | 2022-01-17 | Lincoln | Missouri | 29113 | 13284 | 101 |
2120440 | 2120440 | 2022-01-16 | Lincoln | Missouri | 29113 | 13284 | 101 |
2117188 | 2117188 | 2022-01-15 | Lincoln | Missouri | 29113 | 13284 | 101 |
2113937 | 2113937 | 2022-01-14 | Lincoln | Missouri | 29113 | 13082 | 101 |
2110685 | 2110685 | 2022-01-13 | Lincoln | Missouri | 29113 | 12960 | 101 |
2107434 | 2107434 | 2022-01-12 | Lincoln | Missouri | 29113 | 12816 | 101 |
2104183 | 2104183 | 2022-01-11 | Lincoln | Missouri | 29113 | 12657 | 101 |
2100932 | 2100932 | 2022-01-10 | Lincoln | Missouri | 29113 | 12504 | 101 |
2097681 | 2097681 | 2022-01-09 | Lincoln | Missouri | 29113 | 12418 | 101 |
2094429 | 2094429 | 2022-01-08 | Lincoln | Missouri | 29113 | 12378 | 101 |
2091177 | 2091177 | 2022-01-07 | Lincoln | Missouri | 29113 | 12165 | 101 |
2087926 | 2087926 | 2022-01-06 | Lincoln | Missouri | 29113 | 11984 | 101 |
2084674 | 2084674 | 2022-01-05 | Lincoln | Missouri | 29113 | 11826 | 100 |
2081422 | 2081422 | 2022-01-04 | Lincoln | Missouri | 29113 | 11704 | 100 |
2078170 | 2078170 | 2022-01-03 | Lincoln | Missouri | 29113 | 11634 | 101 |
2074919 | 2074919 | 2022-01-02 | Lincoln | Missouri | 29113 | 11380 | 101 |
2071668 | 2071668 | 2022-01-01 | Lincoln | Missouri | 29113 | 11380 | 101 |
2068417 | 2068417 | 2021-12-31 | Lincoln | Missouri | 29113 | 11380 | 101 |
2065166 | 2065166 | 2021-12-30 | Lincoln | Missouri | 29113 | 11380 | 101 |
2061916 | 2061916 | 2021-12-29 | Lincoln | Missouri | 29113 | 11310 | 101 |
2058667 | 2058667 | 2021-12-28 | Lincoln | Missouri | 29113 | 11238 | 100 |
2055418 | 2055418 | 2021-12-27 | Lincoln | Missouri | 29113 | 11197 | 97 |
2052168 | 2052168 | 2021-12-26 | Lincoln | Missouri | 29113 | 11086 | 97 |
2048918 | 2048918 | 2021-12-25 | Lincoln | Missouri | 29113 | 11086 | 97 |
2045668 | 2045668 | 2021-12-24 | Lincoln | Missouri | 29113 | 11086 | 97 |
2042418 | 2042418 | 2021-12-23 | Lincoln | Missouri | 29113 | 11086 | 97 |
2039169 | 2039169 | 2021-12-22 | Lincoln | Missouri | 29113 | 11016 | 97 |
2035919 | 2035919 | 2021-12-21 | Lincoln | Missouri | 29113 | 10955 | 97 |
2032669 | 2032669 | 2021-12-20 | Lincoln | Missouri | 29113 | 10919 | 97 |
2029418 | 2029418 | 2021-12-19 | Lincoln | Missouri | 29113 | 10911 | 97 |
2026167 | 2026167 | 2021-12-18 | Lincoln | Missouri | 29113 | 10892 | 97 |
2022916 | 2022916 | 2021-12-17 | Lincoln | Missouri | 29113 | 10857 | 97 |
2019665 | 2019665 | 2021-12-16 | Lincoln | Missouri | 29113 | 10817 | 97 |
2016415 | 2016415 | 2021-12-15 | Lincoln | Missouri | 29113 | 10754 | 97 |
2013164 | 2013164 | 2021-12-14 | Lincoln | Missouri | 29113 | 10712 | 97 |
2009913 | 2009913 | 2021-12-13 | Lincoln | Missouri | 29113 | 10689 | 94 |
2006662 | 2006662 | 2021-12-12 | Lincoln | Missouri | 29113 | 10679 | 94 |
2003411 | 2003411 | 2021-12-11 | Lincoln | Missouri | 29113 | 10643 | 94 |
2000161 | 2000161 | 2021-12-10 | Lincoln | Missouri | 29113 | 10617 | 94 |
1996910 | 1996910 | 2021-12-09 | Lincoln | Missouri | 29113 | 10566 | 94 |
1993659 | 1993659 | 2021-12-08 | Lincoln | Missouri | 29113 | 10484 | 94 |
1990408 | 1990408 | 2021-12-07 | Lincoln | Missouri | 29113 | 10424 | 94 |
1987158 | 1987158 | 2021-12-06 | Lincoln | Missouri | 29113 | 10393 | 94 |
1983908 | 1983908 | 2021-12-05 | Lincoln | Missouri | 29113 | 10334 | 94 |
1980658 | 1980658 | 2021-12-04 | Lincoln | Missouri | 29113 | 10321 | 94 |
1977408 | 1977408 | 2021-12-03 | Lincoln | Missouri | 29113 | 10231 | 94 |
1974158 | 1974158 | 2021-12-02 | Lincoln | Missouri | 29113 | 10231 | 94 |
1970909 | 1970909 | 2021-12-01 | Lincoln | Missouri | 29113 | 10163 | 94 |
1967659 | 1967659 | 2021-11-30 | Lincoln | Missouri | 29113 | 10123 | 94 |
1964407 | 1964407 | 2021-11-29 | Lincoln | Missouri | 29113 | 10108 | 94 |
1961156 | 1961156 | 2021-11-28 | Lincoln | Missouri | 29113 | 9996 | 93 |
1957905 | 1957905 | 2021-11-27 | Lincoln | Missouri | 29113 | 9996 | 93 |
1954654 | 1954654 | 2021-11-26 | Lincoln | Missouri | 29113 | 9996 | 93 |
1951403 | 1951403 | 2021-11-25 | Lincoln | Missouri | 29113 | 9996 | 93 |
1948152 | 1948152 | 2021-11-24 | Lincoln | Missouri | 29113 | 9996 | 93 |
1944901 | 1944901 | 2021-11-23 | Lincoln | Missouri | 29113 | 9971 | 93 |
1941650 | 1941650 | 2021-11-22 | Lincoln | Missouri | 29113 | 9949 | 91 |
1938400 | 1938400 | 2021-11-21 | Lincoln | Missouri | 29113 | 9940 | 91 |
1935150 | 1935150 | 2021-11-20 | Lincoln | Missouri | 29113 | 9920 | 91 |
1931900 | 1931900 | 2021-11-19 | Lincoln | Missouri | 29113 | 9890 | 91 |
1928649 | 1928649 | 2021-11-18 | Lincoln | Missouri | 29113 | 9860 | 91 |
1925399 | 1925399 | 2021-11-17 | Lincoln | Missouri | 29113 | 9641 | 73 |
1922150 | 1922150 | 2021-11-16 | Lincoln | Missouri | 29113 | 9618 | 73 |
1918900 | 1918900 | 2021-11-15 | Lincoln | Missouri | 29113 | 9606 | 73 |
1915650 | 1915650 | 2021-11-14 | Lincoln | Missouri | 29113 | 9595 | 73 |
1912400 | 1912400 | 2021-11-13 | Lincoln | Missouri | 29113 | 9576 | 73 |
1909150 | 1909150 | 2021-11-12 | Lincoln | Missouri | 29113 | 9559 | 73 |
1905901 | 1905901 | 2021-11-11 | Lincoln | Missouri | 29113 | 9513 | 73 |
1902652 | 1902652 | 2021-11-10 | Lincoln | Missouri | 29113 | 9513 | 73 |
1899402 | 1899402 | 2021-11-09 | Lincoln | Missouri | 29113 | 9478 | 74 |
1896152 | 1896152 | 2021-11-08 | Lincoln | Missouri | 29113 | 9462 | 71 |
1892902 | 1892902 | 2021-11-07 | Lincoln | Missouri | 29113 | 9455 | 71 |
1889652 | 1889652 | 2021-11-06 | Lincoln | Missouri | 29113 | 9440 | 71 |
1886402 | 1886402 | 2021-11-05 | Lincoln | Missouri | 29113 | 9421 | 71 |
1883153 | 1883153 | 2021-11-04 | Lincoln | Missouri | 29113 | 9408 | 71 |
1879904 | 1879904 | 2021-11-03 | Lincoln | Missouri | 29113 | 9389 | 71 |
1876655 | 1876655 | 2021-11-02 | Lincoln | Missouri | 29113 | 9369 | 71 |
1873406 | 1873406 | 2021-11-01 | Lincoln | Missouri | 29113 | 9361 | 69 |
1870157 | 1870157 | 2021-10-31 | Lincoln | Missouri | 29113 | 9353 | 69 |
1866908 | 1866908 | 2021-10-30 | Lincoln | Missouri | 29113 | 9336 | 69 |
1863659 | 1863659 | 2021-10-29 | Lincoln | Missouri | 29113 | 9317 | 69 |
1860410 | 1860410 | 2021-10-28 | Lincoln | Missouri | 29113 | 9297 | 69 |
1857161 | 1857161 | 2021-10-27 | Lincoln | Missouri | 29113 | 9280 | 69 |
1853912 | 1853912 | 2021-10-26 | Lincoln | Missouri | 29113 | 9261 | 69 |
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);