ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 23023 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110327 | 2110327 | 2022-01-13 | Sagadahoc | Maine | 23023 | 3206 | 23 |
2107076 | 2107076 | 2022-01-12 | Sagadahoc | Maine | 23023 | 3179 | 23 |
2103825 | 2103825 | 2022-01-11 | Sagadahoc | Maine | 23023 | 3156 | 23 |
2100574 | 2100574 | 2022-01-10 | Sagadahoc | Maine | 23023 | 3113 | 23 |
2097323 | 2097323 | 2022-01-09 | Sagadahoc | Maine | 23023 | 3113 | 23 |
2094071 | 2094071 | 2022-01-08 | Sagadahoc | Maine | 23023 | 3113 | 23 |
2090819 | 2090819 | 2022-01-07 | Sagadahoc | Maine | 23023 | 3092 | 23 |
2087568 | 2087568 | 2022-01-06 | Sagadahoc | Maine | 23023 | 3058 | 23 |
2084316 | 2084316 | 2022-01-05 | Sagadahoc | Maine | 23023 | 3042 | 23 |
2081064 | 2081064 | 2022-01-04 | Sagadahoc | Maine | 23023 | 3034 | 21 |
2077812 | 2077812 | 2022-01-03 | Sagadahoc | Maine | 23023 | 3016 | 21 |
2074561 | 2074561 | 2022-01-02 | Sagadahoc | Maine | 23023 | 3016 | 21 |
2071310 | 2071310 | 2022-01-01 | Sagadahoc | Maine | 23023 | 3016 | 21 |
2068059 | 2068059 | 2021-12-31 | Sagadahoc | Maine | 23023 | 3016 | 21 |
2064808 | 2064808 | 2021-12-30 | Sagadahoc | Maine | 23023 | 2987 | 20 |
2061558 | 2061558 | 2021-12-29 | Sagadahoc | Maine | 23023 | 2969 | 20 |
2058309 | 2058309 | 2021-12-28 | Sagadahoc | Maine | 23023 | 2932 | 18 |
2055060 | 2055060 | 2021-12-27 | Sagadahoc | Maine | 23023 | 2901 | 18 |
2051810 | 2051810 | 2021-12-26 | Sagadahoc | Maine | 23023 | 2900 | 18 |
2048560 | 2048560 | 2021-12-25 | Sagadahoc | Maine | 23023 | 2900 | 18 |
2045310 | 2045310 | 2021-12-24 | Sagadahoc | Maine | 23023 | 2900 | 18 |
2042061 | 2042061 | 2021-12-23 | Sagadahoc | Maine | 23023 | 2868 | 18 |
2038811 | 2038811 | 2021-12-22 | Sagadahoc | Maine | 23023 | 2832 | 18 |
2035561 | 2035561 | 2021-12-21 | Sagadahoc | Maine | 23023 | 2821 | 18 |
2032311 | 2032311 | 2021-12-20 | Sagadahoc | Maine | 23023 | 2786 | 16 |
2029060 | 2029060 | 2021-12-19 | Sagadahoc | Maine | 23023 | 2786 | 16 |
2025809 | 2025809 | 2021-12-18 | Sagadahoc | Maine | 23023 | 2786 | 16 |
2022558 | 2022558 | 2021-12-17 | Sagadahoc | Maine | 23023 | 2748 | 16 |
2019307 | 2019307 | 2021-12-16 | Sagadahoc | Maine | 23023 | 2718 | 16 |
2016057 | 2016057 | 2021-12-15 | Sagadahoc | Maine | 23023 | 2704 | 16 |
2012806 | 2012806 | 2021-12-14 | Sagadahoc | Maine | 23023 | 2702 | 16 |
2009555 | 2009555 | 2021-12-13 | Sagadahoc | Maine | 23023 | 2663 | 16 |
2006304 | 2006304 | 2021-12-12 | Sagadahoc | Maine | 23023 | 2661 | 16 |
2003053 | 2003053 | 2021-12-11 | Sagadahoc | Maine | 23023 | 2658 | 16 |
1999803 | 1999803 | 2021-12-10 | Sagadahoc | Maine | 23023 | 2621 | 16 |
1996552 | 1996552 | 2021-12-09 | Sagadahoc | Maine | 23023 | 2579 | 16 |
1993301 | 1993301 | 2021-12-08 | Sagadahoc | Maine | 23023 | 2518 | 16 |
1990050 | 1990050 | 2021-12-07 | Sagadahoc | Maine | 23023 | 2502 | 16 |
1986800 | 1986800 | 2021-12-06 | Sagadahoc | Maine | 23023 | 2490 | 16 |
1983550 | 1983550 | 2021-12-05 | Sagadahoc | Maine | 23023 | 2490 | 16 |
1980300 | 1980300 | 2021-12-04 | Sagadahoc | Maine | 23023 | 2490 | 16 |
1977050 | 1977050 | 2021-12-03 | Sagadahoc | Maine | 23023 | 2477 | 16 |
1973801 | 1973801 | 2021-12-02 | Sagadahoc | Maine | 23023 | 2465 | 16 |
1970551 | 1970551 | 2021-12-01 | Sagadahoc | Maine | 23023 | 2421 | 16 |
1967301 | 1967301 | 2021-11-30 | Sagadahoc | Maine | 23023 | 2418 | 16 |
1964049 | 1964049 | 2021-11-29 | Sagadahoc | Maine | 23023 | 2401 | 14 |
1960798 | 1960798 | 2021-11-28 | Sagadahoc | Maine | 23023 | 2397 | 14 |
1957547 | 1957547 | 2021-11-27 | Sagadahoc | Maine | 23023 | 2397 | 14 |
1954296 | 1954296 | 2021-11-26 | Sagadahoc | Maine | 23023 | 2397 | 14 |
1951045 | 1951045 | 2021-11-25 | Sagadahoc | Maine | 23023 | 2397 | 14 |
1947794 | 1947794 | 2021-11-24 | Sagadahoc | Maine | 23023 | 2384 | 14 |
1944543 | 1944543 | 2021-11-23 | Sagadahoc | Maine | 23023 | 2369 | 14 |
1941293 | 1941293 | 2021-11-22 | Sagadahoc | Maine | 23023 | 2339 | 14 |
1938043 | 1938043 | 2021-11-21 | Sagadahoc | Maine | 23023 | 2339 | 14 |
1934793 | 1934793 | 2021-11-20 | Sagadahoc | Maine | 23023 | 2339 | 14 |
1931542 | 1931542 | 2021-11-19 | Sagadahoc | Maine | 23023 | 2313 | 14 |
1928291 | 1928291 | 2021-11-18 | Sagadahoc | Maine | 23023 | 2289 | 14 |
1925041 | 1925041 | 2021-11-17 | Sagadahoc | Maine | 23023 | 2270 | 14 |
1921792 | 1921792 | 2021-11-16 | Sagadahoc | Maine | 23023 | 2236 | 14 |
1918542 | 1918542 | 2021-11-15 | Sagadahoc | Maine | 23023 | 2202 | 13 |
1915292 | 1915292 | 2021-11-14 | Sagadahoc | Maine | 23023 | 2202 | 13 |
1912042 | 1912042 | 2021-11-13 | Sagadahoc | Maine | 23023 | 2202 | 13 |
1908793 | 1908793 | 2021-11-12 | Sagadahoc | Maine | 23023 | 2186 | 13 |
1905544 | 1905544 | 2021-11-11 | Sagadahoc | Maine | 23023 | 2186 | 13 |
1902294 | 1902294 | 2021-11-10 | Sagadahoc | Maine | 23023 | 2177 | 13 |
1899044 | 1899044 | 2021-11-09 | Sagadahoc | Maine | 23023 | 2151 | 13 |
1895794 | 1895794 | 2021-11-08 | Sagadahoc | Maine | 23023 | 2117 | 13 |
1892544 | 1892544 | 2021-11-07 | Sagadahoc | Maine | 23023 | 2117 | 13 |
1889294 | 1889294 | 2021-11-06 | Sagadahoc | Maine | 23023 | 2117 | 13 |
1886044 | 1886044 | 2021-11-05 | Sagadahoc | Maine | 23023 | 2094 | 13 |
1882795 | 1882795 | 2021-11-04 | Sagadahoc | Maine | 23023 | 2070 | 13 |
1879546 | 1879546 | 2021-11-03 | Sagadahoc | Maine | 23023 | 2067 | 13 |
1876297 | 1876297 | 2021-11-02 | Sagadahoc | Maine | 23023 | 2058 | 13 |
1873048 | 1873048 | 2021-11-01 | Sagadahoc | Maine | 23023 | 2026 | 13 |
1869799 | 1869799 | 2021-10-31 | Sagadahoc | Maine | 23023 | 2026 | 13 |
1866550 | 1866550 | 2021-10-30 | Sagadahoc | Maine | 23023 | 2026 | 13 |
1863301 | 1863301 | 2021-10-29 | Sagadahoc | Maine | 23023 | 2013 | 13 |
1860052 | 1860052 | 2021-10-28 | Sagadahoc | Maine | 23023 | 1998 | 13 |
1856803 | 1856803 | 2021-10-27 | Sagadahoc | Maine | 23023 | 1986 | 13 |
1853554 | 1853554 | 2021-10-26 | Sagadahoc | Maine | 23023 | 1973 | 13 |
1850305 | 1850305 | 2021-10-25 | Sagadahoc | Maine | 23023 | 1948 | 12 |
1847055 | 1847055 | 2021-10-24 | Sagadahoc | Maine | 23023 | 1948 | 12 |
1843805 | 1843805 | 2021-10-23 | Sagadahoc | Maine | 23023 | 1948 | 12 |
1840555 | 1840555 | 2021-10-22 | Sagadahoc | Maine | 23023 | 1940 | 12 |
1837306 | 1837306 | 2021-10-21 | Sagadahoc | Maine | 23023 | 1931 | 12 |
1834057 | 1834057 | 2021-10-20 | Sagadahoc | Maine | 23023 | 1918 | 12 |
1830808 | 1830808 | 2021-10-19 | Sagadahoc | Maine | 23023 | 1907 | 12 |
1827559 | 1827559 | 2021-10-18 | Sagadahoc | Maine | 23023 | 1889 | 12 |
1824310 | 1824310 | 2021-10-17 | Sagadahoc | Maine | 23023 | 1889 | 12 |
1821061 | 1821061 | 2021-10-16 | Sagadahoc | Maine | 23023 | 1889 | 12 |
1817812 | 1817812 | 2021-10-15 | Sagadahoc | Maine | 23023 | 1887 | 12 |
1814564 | 1814564 | 2021-10-14 | Sagadahoc | Maine | 23023 | 1879 | 12 |
1811315 | 1811315 | 2021-10-13 | Sagadahoc | Maine | 23023 | 1865 | 12 |
1808066 | 1808066 | 2021-10-12 | Sagadahoc | Maine | 23023 | 1840 | 12 |
1804815 | 1804815 | 2021-10-11 | Sagadahoc | Maine | 23023 | 1840 | 12 |
1801566 | 1801566 | 2021-10-10 | Sagadahoc | Maine | 23023 | 1840 | 12 |
1798317 | 1798317 | 2021-10-09 | Sagadahoc | Maine | 23023 | 1840 | 12 |
1795068 | 1795068 | 2021-10-08 | Sagadahoc | Maine | 23023 | 1832 | 12 |
1791820 | 1791820 | 2021-10-07 | Sagadahoc | Maine | 23023 | 1823 | 12 |
1788571 | 1788571 | 2021-10-06 | Sagadahoc | Maine | 23023 | 1805 | 12 |
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);