ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lincoln" and fips = 41041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176447 | 2176447 | 2022-02-02 | Lincoln | Oregon | 41041 | 6134 | 65 |
2173193 | 2173193 | 2022-02-01 | Lincoln | Oregon | 41041 | 6036 | 65 |
2169941 | 2169941 | 2022-01-31 | Lincoln | Oregon | 41041 | 5960 | 64 |
2166686 | 2166686 | 2022-01-30 | Lincoln | Oregon | 41041 | 5833 | 64 |
2163431 | 2163431 | 2022-01-29 | Lincoln | Oregon | 41041 | 5833 | 64 |
2160176 | 2160176 | 2022-01-28 | Lincoln | Oregon | 41041 | 5833 | 64 |
2156921 | 2156921 | 2022-01-27 | Lincoln | Oregon | 41041 | 5744 | 64 |
2153668 | 2153668 | 2022-01-26 | Lincoln | Oregon | 41041 | 5649 | 64 |
2150416 | 2150416 | 2022-01-25 | Lincoln | Oregon | 41041 | 5580 | 64 |
2147164 | 2147164 | 2022-01-24 | Lincoln | Oregon | 41041 | 5509 | 62 |
2143910 | 2143910 | 2022-01-23 | Lincoln | Oregon | 41041 | 5304 | 62 |
2140655 | 2140655 | 2022-01-22 | Lincoln | Oregon | 41041 | 5304 | 62 |
2137399 | 2137399 | 2022-01-21 | Lincoln | Oregon | 41041 | 5304 | 62 |
2134145 | 2134145 | 2022-01-20 | Lincoln | Oregon | 41041 | 5195 | 62 |
2130893 | 2130893 | 2022-01-19 | Lincoln | Oregon | 41041 | 5027 | 62 |
2127639 | 2127639 | 2022-01-18 | Lincoln | Oregon | 41041 | 4892 | 60 |
2124387 | 2124387 | 2022-01-17 | Lincoln | Oregon | 41041 | 4709 | 60 |
2121135 | 2121135 | 2022-01-16 | Lincoln | Oregon | 41041 | 4709 | 60 |
2117883 | 2117883 | 2022-01-15 | Lincoln | Oregon | 41041 | 4709 | 60 |
2114632 | 2114632 | 2022-01-14 | Lincoln | Oregon | 41041 | 4709 | 60 |
2111380 | 2111380 | 2022-01-13 | Lincoln | Oregon | 41041 | 4594 | 60 |
2108128 | 2108128 | 2022-01-12 | Lincoln | Oregon | 41041 | 4511 | 59 |
2104877 | 2104877 | 2022-01-11 | Lincoln | Oregon | 41041 | 4302 | 59 |
2101626 | 2101626 | 2022-01-10 | Lincoln | Oregon | 41041 | 4254 | 59 |
2098375 | 2098375 | 2022-01-09 | Lincoln | Oregon | 41041 | 4189 | 59 |
2095123 | 2095123 | 2022-01-08 | Lincoln | Oregon | 41041 | 4189 | 59 |
2091871 | 2091871 | 2022-01-07 | Lincoln | Oregon | 41041 | 4189 | 59 |
2088619 | 2088619 | 2022-01-06 | Lincoln | Oregon | 41041 | 4147 | 58 |
2085368 | 2085368 | 2022-01-05 | Lincoln | Oregon | 41041 | 4074 | 58 |
2082116 | 2082116 | 2022-01-04 | Lincoln | Oregon | 41041 | 4021 | 58 |
2078864 | 2078864 | 2022-01-03 | Lincoln | Oregon | 41041 | 4008 | 58 |
2075613 | 2075613 | 2022-01-02 | Lincoln | Oregon | 41041 | 3915 | 58 |
2072362 | 2072362 | 2022-01-01 | Lincoln | Oregon | 41041 | 3915 | 58 |
2069111 | 2069111 | 2021-12-31 | Lincoln | Oregon | 41041 | 3915 | 58 |
2065860 | 2065860 | 2021-12-30 | Lincoln | Oregon | 41041 | 3915 | 58 |
2062610 | 2062610 | 2021-12-29 | Lincoln | Oregon | 41041 | 3879 | 58 |
2059360 | 2059360 | 2021-12-28 | Lincoln | Oregon | 41041 | 3856 | 58 |
2056111 | 2056111 | 2021-12-27 | Lincoln | Oregon | 41041 | 3842 | 58 |
2052862 | 2052862 | 2021-12-26 | Lincoln | Oregon | 41041 | 3810 | 58 |
2049612 | 2049612 | 2021-12-25 | Lincoln | Oregon | 41041 | 3810 | 58 |
2046362 | 2046362 | 2021-12-24 | Lincoln | Oregon | 41041 | 3810 | 58 |
2043112 | 2043112 | 2021-12-23 | Lincoln | Oregon | 41041 | 3810 | 58 |
2039863 | 2039863 | 2021-12-22 | Lincoln | Oregon | 41041 | 3808 | 58 |
2036613 | 2036613 | 2021-12-21 | Lincoln | Oregon | 41041 | 3804 | 58 |
2033363 | 2033363 | 2021-12-20 | Lincoln | Oregon | 41041 | 3800 | 58 |
2030113 | 2030113 | 2021-12-19 | Lincoln | Oregon | 41041 | 3784 | 58 |
2026862 | 2026862 | 2021-12-18 | Lincoln | Oregon | 41041 | 3784 | 58 |
2023611 | 2023611 | 2021-12-17 | Lincoln | Oregon | 41041 | 3784 | 58 |
2020360 | 2020360 | 2021-12-16 | Lincoln | Oregon | 41041 | 3778 | 58 |
2017109 | 2017109 | 2021-12-15 | Lincoln | Oregon | 41041 | 3761 | 57 |
2013859 | 2013859 | 2021-12-14 | Lincoln | Oregon | 41041 | 3753 | 57 |
2010608 | 2010608 | 2021-12-13 | Lincoln | Oregon | 41041 | 3748 | 57 |
2007357 | 2007357 | 2021-12-12 | Lincoln | Oregon | 41041 | 3728 | 57 |
2004106 | 2004106 | 2021-12-11 | Lincoln | Oregon | 41041 | 3728 | 57 |
2000855 | 2000855 | 2021-12-10 | Lincoln | Oregon | 41041 | 3728 | 57 |
1997605 | 1997605 | 2021-12-09 | Lincoln | Oregon | 41041 | 3709 | 56 |
1994354 | 1994354 | 2021-12-08 | Lincoln | Oregon | 41041 | 3699 | 55 |
1991103 | 1991103 | 2021-12-07 | Lincoln | Oregon | 41041 | 3691 | 55 |
1987852 | 1987852 | 2021-12-06 | Lincoln | Oregon | 41041 | 3679 | 52 |
1984602 | 1984602 | 2021-12-05 | Lincoln | Oregon | 41041 | 3658 | 52 |
1981352 | 1981352 | 2021-12-04 | Lincoln | Oregon | 41041 | 3658 | 52 |
1978102 | 1978102 | 2021-12-03 | Lincoln | Oregon | 41041 | 3658 | 52 |
1974852 | 1974852 | 2021-12-02 | Lincoln | Oregon | 41041 | 3644 | 52 |
1971603 | 1971603 | 2021-12-01 | Lincoln | Oregon | 41041 | 3638 | 52 |
1968353 | 1968353 | 2021-11-30 | Lincoln | Oregon | 41041 | 3621 | 52 |
1965102 | 1965102 | 2021-11-29 | Lincoln | Oregon | 41041 | 3607 | 52 |
1961850 | 1961850 | 2021-11-28 | Lincoln | Oregon | 41041 | 3572 | 52 |
1958599 | 1958599 | 2021-11-27 | Lincoln | Oregon | 41041 | 3572 | 52 |
1955348 | 1955348 | 2021-11-26 | Lincoln | Oregon | 41041 | 3572 | 52 |
1952097 | 1952097 | 2021-11-25 | Lincoln | Oregon | 41041 | 3572 | 52 |
1948846 | 1948846 | 2021-11-24 | Lincoln | Oregon | 41041 | 3572 | 52 |
1945595 | 1945595 | 2021-11-23 | Lincoln | Oregon | 41041 | 3557 | 51 |
1942344 | 1942344 | 2021-11-22 | Lincoln | Oregon | 41041 | 3556 | 50 |
1939094 | 1939094 | 2021-11-21 | Lincoln | Oregon | 41041 | 3504 | 50 |
1935844 | 1935844 | 2021-11-20 | Lincoln | Oregon | 41041 | 3504 | 50 |
1932594 | 1932594 | 2021-11-19 | Lincoln | Oregon | 41041 | 3504 | 50 |
1929343 | 1929343 | 2021-11-18 | Lincoln | Oregon | 41041 | 3489 | 50 |
1926093 | 1926093 | 2021-11-17 | Lincoln | Oregon | 41041 | 3474 | 50 |
1922843 | 1922843 | 2021-11-16 | Lincoln | Oregon | 41041 | 3456 | 49 |
1919594 | 1919594 | 2021-11-15 | Lincoln | Oregon | 41041 | 3455 | 49 |
1916344 | 1916344 | 2021-11-14 | Lincoln | Oregon | 41041 | 3437 | 46 |
1913094 | 1913094 | 2021-11-13 | Lincoln | Oregon | 41041 | 3437 | 46 |
1909844 | 1909844 | 2021-11-12 | Lincoln | Oregon | 41041 | 3437 | 46 |
1906595 | 1906595 | 2021-11-11 | Lincoln | Oregon | 41041 | 3412 | 46 |
1903346 | 1903346 | 2021-11-10 | Lincoln | Oregon | 41041 | 3412 | 46 |
1900096 | 1900096 | 2021-11-09 | Lincoln | Oregon | 41041 | 3396 | 46 |
1896846 | 1896846 | 2021-11-08 | Lincoln | Oregon | 41041 | 3374 | 46 |
1893596 | 1893596 | 2021-11-07 | Lincoln | Oregon | 41041 | 3352 | 45 |
1890346 | 1890346 | 2021-11-06 | Lincoln | Oregon | 41041 | 3352 | 45 |
1887096 | 1887096 | 2021-11-05 | Lincoln | Oregon | 41041 | 3352 | 45 |
1883846 | 1883846 | 2021-11-04 | Lincoln | Oregon | 41041 | 3342 | 45 |
1880597 | 1880597 | 2021-11-03 | Lincoln | Oregon | 41041 | 3330 | 43 |
1877348 | 1877348 | 2021-11-02 | Lincoln | Oregon | 41041 | 3316 | 43 |
1874099 | 1874099 | 2021-11-01 | Lincoln | Oregon | 41041 | 3305 | 41 |
1870850 | 1870850 | 2021-10-31 | Lincoln | Oregon | 41041 | 3282 | 41 |
1867601 | 1867601 | 2021-10-30 | Lincoln | Oregon | 41041 | 3282 | 41 |
1864352 | 1864352 | 2021-10-29 | Lincoln | Oregon | 41041 | 3282 | 41 |
1861103 | 1861103 | 2021-10-28 | Lincoln | Oregon | 41041 | 3269 | 40 |
1857854 | 1857854 | 2021-10-27 | Lincoln | Oregon | 41041 | 3255 | 40 |
1854605 | 1854605 | 2021-10-26 | Lincoln | Oregon | 41041 | 3241 | 39 |
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);