ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lincoln" and fips = 23015 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175389 | 2175389 | 2022-02-02 | Lincoln | Maine | 23015 | 3720 | 20 |
2172136 | 2172136 | 2022-02-01 | Lincoln | Maine | 23015 | 3704 | 20 |
2168883 | 2168883 | 2022-01-31 | Lincoln | Maine | 23015 | 3679 | 19 |
2165628 | 2165628 | 2022-01-30 | Lincoln | Maine | 23015 | 3679 | 19 |
2162373 | 2162373 | 2022-01-29 | Lincoln | Maine | 23015 | 3679 | 19 |
2159118 | 2159118 | 2022-01-28 | Lincoln | Maine | 23015 | 3651 | 19 |
2155864 | 2155864 | 2022-01-27 | Lincoln | Maine | 23015 | 3614 | 19 |
2152611 | 2152611 | 2022-01-26 | Lincoln | Maine | 23015 | 3579 | 19 |
2149359 | 2149359 | 2022-01-25 | Lincoln | Maine | 23015 | 3572 | 19 |
2146107 | 2146107 | 2022-01-24 | Lincoln | Maine | 23015 | 3494 | 19 |
2142852 | 2142852 | 2022-01-23 | Lincoln | Maine | 23015 | 3494 | 19 |
2139597 | 2139597 | 2022-01-22 | Lincoln | Maine | 23015 | 3494 | 19 |
2136341 | 2136341 | 2022-01-21 | Lincoln | Maine | 23015 | 3456 | 19 |
2133089 | 2133089 | 2022-01-20 | Lincoln | Maine | 23015 | 3419 | 19 |
2129836 | 2129836 | 2022-01-19 | Lincoln | Maine | 23015 | 3372 | 18 |
2126582 | 2126582 | 2022-01-18 | Lincoln | Maine | 23015 | 3338 | 16 |
2123330 | 2123330 | 2022-01-17 | Lincoln | Maine | 23015 | 3335 | 16 |
2120078 | 2120078 | 2022-01-16 | Lincoln | Maine | 23015 | 3335 | 16 |
2116826 | 2116826 | 2022-01-15 | Lincoln | Maine | 23015 | 3335 | 16 |
2113575 | 2113575 | 2022-01-14 | Lincoln | Maine | 23015 | 3290 | 16 |
2110323 | 2110323 | 2022-01-13 | Lincoln | Maine | 23015 | 3262 | 16 |
2107072 | 2107072 | 2022-01-12 | Lincoln | Maine | 23015 | 3214 | 16 |
2103821 | 2103821 | 2022-01-11 | Lincoln | Maine | 23015 | 3201 | 16 |
2100570 | 2100570 | 2022-01-10 | Lincoln | Maine | 23015 | 3113 | 15 |
2097319 | 2097319 | 2022-01-09 | Lincoln | Maine | 23015 | 3113 | 15 |
2094067 | 2094067 | 2022-01-08 | Lincoln | Maine | 23015 | 3113 | 15 |
2090815 | 2090815 | 2022-01-07 | Lincoln | Maine | 23015 | 3067 | 15 |
2087564 | 2087564 | 2022-01-06 | Lincoln | Maine | 23015 | 3030 | 15 |
2084312 | 2084312 | 2022-01-05 | Lincoln | Maine | 23015 | 2964 | 14 |
2081060 | 2081060 | 2022-01-04 | Lincoln | Maine | 23015 | 2941 | 13 |
2077808 | 2077808 | 2022-01-03 | Lincoln | Maine | 23015 | 2896 | 11 |
2074557 | 2074557 | 2022-01-02 | Lincoln | Maine | 23015 | 2896 | 11 |
2071306 | 2071306 | 2022-01-01 | Lincoln | Maine | 23015 | 2896 | 11 |
2068055 | 2068055 | 2021-12-31 | Lincoln | Maine | 23015 | 2896 | 11 |
2064804 | 2064804 | 2021-12-30 | Lincoln | Maine | 23015 | 2837 | 12 |
2061554 | 2061554 | 2021-12-29 | Lincoln | Maine | 23015 | 2783 | 11 |
2058305 | 2058305 | 2021-12-28 | Lincoln | Maine | 23015 | 2739 | 11 |
2055056 | 2055056 | 2021-12-27 | Lincoln | Maine | 23015 | 2683 | 11 |
2051806 | 2051806 | 2021-12-26 | Lincoln | Maine | 23015 | 2682 | 11 |
2048556 | 2048556 | 2021-12-25 | Lincoln | Maine | 23015 | 2682 | 11 |
2045306 | 2045306 | 2021-12-24 | Lincoln | Maine | 23015 | 2682 | 11 |
2042057 | 2042057 | 2021-12-23 | Lincoln | Maine | 23015 | 2636 | 11 |
2038807 | 2038807 | 2021-12-22 | Lincoln | Maine | 23015 | 2603 | 11 |
2035557 | 2035557 | 2021-12-21 | Lincoln | Maine | 23015 | 2564 | 11 |
2032307 | 2032307 | 2021-12-20 | Lincoln | Maine | 23015 | 2493 | 11 |
2029056 | 2029056 | 2021-12-19 | Lincoln | Maine | 23015 | 2493 | 11 |
2025805 | 2025805 | 2021-12-18 | Lincoln | Maine | 23015 | 2493 | 11 |
2022554 | 2022554 | 2021-12-17 | Lincoln | Maine | 23015 | 2472 | 10 |
2019303 | 2019303 | 2021-12-16 | Lincoln | Maine | 23015 | 2438 | 10 |
2016053 | 2016053 | 2021-12-15 | Lincoln | Maine | 23015 | 2419 | 10 |
2012802 | 2012802 | 2021-12-14 | Lincoln | Maine | 23015 | 2410 | 10 |
2009551 | 2009551 | 2021-12-13 | Lincoln | Maine | 23015 | 2390 | 10 |
2006300 | 2006300 | 2021-12-12 | Lincoln | Maine | 23015 | 2390 | 10 |
2003049 | 2003049 | 2021-12-11 | Lincoln | Maine | 23015 | 2390 | 10 |
1999799 | 1999799 | 2021-12-10 | Lincoln | Maine | 23015 | 2347 | 10 |
1996548 | 1996548 | 2021-12-09 | Lincoln | Maine | 23015 | 2300 | 10 |
1993297 | 1993297 | 2021-12-08 | Lincoln | Maine | 23015 | 2247 | 10 |
1990046 | 1990046 | 2021-12-07 | Lincoln | Maine | 23015 | 2231 | 10 |
1986796 | 1986796 | 2021-12-06 | Lincoln | Maine | 23015 | 2202 | 10 |
1983546 | 1983546 | 2021-12-05 | Lincoln | Maine | 23015 | 2202 | 10 |
1980296 | 1980296 | 2021-12-04 | Lincoln | Maine | 23015 | 2202 | 10 |
1977046 | 1977046 | 2021-12-03 | Lincoln | Maine | 23015 | 2189 | 10 |
1973797 | 1973797 | 2021-12-02 | Lincoln | Maine | 23015 | 2175 | 10 |
1970547 | 1970547 | 2021-12-01 | Lincoln | Maine | 23015 | 2151 | 10 |
1967297 | 1967297 | 2021-11-30 | Lincoln | Maine | 23015 | 2148 | 10 |
1964045 | 1964045 | 2021-11-29 | Lincoln | Maine | 23015 | 2125 | 9 |
1960794 | 1960794 | 2021-11-28 | Lincoln | Maine | 23015 | 2119 | 9 |
1957543 | 1957543 | 2021-11-27 | Lincoln | Maine | 23015 | 2119 | 9 |
1954292 | 1954292 | 2021-11-26 | Lincoln | Maine | 23015 | 2119 | 9 |
1951041 | 1951041 | 2021-11-25 | Lincoln | Maine | 23015 | 2119 | 9 |
1947790 | 1947790 | 2021-11-24 | Lincoln | Maine | 23015 | 2112 | 9 |
1944539 | 1944539 | 2021-11-23 | Lincoln | Maine | 23015 | 2091 | 8 |
1941289 | 1941289 | 2021-11-22 | Lincoln | Maine | 23015 | 2071 | 8 |
1938039 | 1938039 | 2021-11-21 | Lincoln | Maine | 23015 | 2071 | 8 |
1934789 | 1934789 | 2021-11-20 | Lincoln | Maine | 23015 | 2071 | 8 |
1931538 | 1931538 | 2021-11-19 | Lincoln | Maine | 23015 | 2047 | 8 |
1928287 | 1928287 | 2021-11-18 | Lincoln | Maine | 23015 | 2032 | 8 |
1925037 | 1925037 | 2021-11-17 | Lincoln | Maine | 23015 | 2003 | 8 |
1921788 | 1921788 | 2021-11-16 | Lincoln | Maine | 23015 | 1981 | 8 |
1918538 | 1918538 | 2021-11-15 | Lincoln | Maine | 23015 | 1963 | 8 |
1915288 | 1915288 | 2021-11-14 | Lincoln | Maine | 23015 | 1963 | 8 |
1912038 | 1912038 | 2021-11-13 | Lincoln | Maine | 23015 | 1963 | 8 |
1908789 | 1908789 | 2021-11-12 | Lincoln | Maine | 23015 | 1948 | 7 |
1905540 | 1905540 | 2021-11-11 | Lincoln | Maine | 23015 | 1948 | 7 |
1902290 | 1902290 | 2021-11-10 | Lincoln | Maine | 23015 | 1939 | 7 |
1899040 | 1899040 | 2021-11-09 | Lincoln | Maine | 23015 | 1929 | 7 |
1895790 | 1895790 | 2021-11-08 | Lincoln | Maine | 23015 | 1913 | 7 |
1892540 | 1892540 | 2021-11-07 | Lincoln | Maine | 23015 | 1913 | 7 |
1889290 | 1889290 | 2021-11-06 | Lincoln | Maine | 23015 | 1913 | 7 |
1886040 | 1886040 | 2021-11-05 | Lincoln | Maine | 23015 | 1898 | 7 |
1882791 | 1882791 | 2021-11-04 | Lincoln | Maine | 23015 | 1885 | 7 |
1879542 | 1879542 | 2021-11-03 | Lincoln | Maine | 23015 | 1873 | 7 |
1876293 | 1876293 | 2021-11-02 | Lincoln | Maine | 23015 | 1857 | 6 |
1873044 | 1873044 | 2021-11-01 | Lincoln | Maine | 23015 | 1836 | 6 |
1869795 | 1869795 | 2021-10-31 | Lincoln | Maine | 23015 | 1836 | 6 |
1866546 | 1866546 | 2021-10-30 | Lincoln | Maine | 23015 | 1836 | 6 |
1863297 | 1863297 | 2021-10-29 | Lincoln | Maine | 23015 | 1829 | 6 |
1860048 | 1860048 | 2021-10-28 | Lincoln | Maine | 23015 | 1819 | 6 |
1856799 | 1856799 | 2021-10-27 | Lincoln | Maine | 23015 | 1804 | 6 |
1853550 | 1853550 | 2021-10-26 | Lincoln | Maine | 23015 | 1798 | 6 |
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);