ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Kennebec" and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110321 | 2110321 | 2022-01-13 | Kennebec | Maine | 23011 | 15455 | 165 |
2107070 | 2107070 | 2022-01-12 | Kennebec | Maine | 23011 | 15357 | 163 |
2103819 | 2103819 | 2022-01-11 | Kennebec | Maine | 23011 | 15280 | 163 |
2100568 | 2100568 | 2022-01-10 | Kennebec | Maine | 23011 | 15169 | 156 |
2097317 | 2097317 | 2022-01-09 | Kennebec | Maine | 23011 | 15169 | 156 |
2094065 | 2094065 | 2022-01-08 | Kennebec | Maine | 23011 | 15169 | 156 |
2090813 | 2090813 | 2022-01-07 | Kennebec | Maine | 23011 | 15068 | 155 |
2087562 | 2087562 | 2022-01-06 | Kennebec | Maine | 23011 | 14915 | 153 |
2084310 | 2084310 | 2022-01-05 | Kennebec | Maine | 23011 | 14798 | 151 |
2081058 | 2081058 | 2022-01-04 | Kennebec | Maine | 23011 | 14642 | 149 |
2077806 | 2077806 | 2022-01-03 | Kennebec | Maine | 23011 | 14514 | 148 |
2074555 | 2074555 | 2022-01-02 | Kennebec | Maine | 23011 | 14514 | 148 |
2071304 | 2071304 | 2022-01-01 | Kennebec | Maine | 23011 | 14514 | 148 |
2068053 | 2068053 | 2021-12-31 | Kennebec | Maine | 23011 | 14514 | 148 |
2064802 | 2064802 | 2021-12-30 | Kennebec | Maine | 23011 | 14384 | 146 |
2061552 | 2061552 | 2021-12-29 | Kennebec | Maine | 23011 | 14243 | 146 |
2058303 | 2058303 | 2021-12-28 | Kennebec | Maine | 23011 | 14116 | 145 |
2055054 | 2055054 | 2021-12-27 | Kennebec | Maine | 23011 | 14021 | 142 |
2051804 | 2051804 | 2021-12-26 | Kennebec | Maine | 23011 | 14020 | 142 |
2048554 | 2048554 | 2021-12-25 | Kennebec | Maine | 23011 | 14020 | 142 |
2045304 | 2045304 | 2021-12-24 | Kennebec | Maine | 23011 | 14020 | 142 |
2042055 | 2042055 | 2021-12-23 | Kennebec | Maine | 23011 | 13900 | 142 |
2038805 | 2038805 | 2021-12-22 | Kennebec | Maine | 23011 | 13761 | 142 |
2035555 | 2035555 | 2021-12-21 | Kennebec | Maine | 23011 | 13578 | 141 |
2032305 | 2032305 | 2021-12-20 | Kennebec | Maine | 23011 | 13432 | 139 |
2029054 | 2029054 | 2021-12-19 | Kennebec | Maine | 23011 | 13432 | 139 |
2025803 | 2025803 | 2021-12-18 | Kennebec | Maine | 23011 | 13431 | 139 |
2022552 | 2022552 | 2021-12-17 | Kennebec | Maine | 23011 | 13377 | 138 |
2019301 | 2019301 | 2021-12-16 | Kennebec | Maine | 23011 | 13162 | 137 |
2016051 | 2016051 | 2021-12-15 | Kennebec | Maine | 23011 | 13044 | 135 |
2012800 | 2012800 | 2021-12-14 | Kennebec | Maine | 23011 | 12911 | 134 |
2009549 | 2009549 | 2021-12-13 | Kennebec | Maine | 23011 | 12784 | 133 |
2006298 | 2006298 | 2021-12-12 | Kennebec | Maine | 23011 | 12784 | 133 |
2003047 | 2003047 | 2021-12-11 | Kennebec | Maine | 23011 | 12783 | 133 |
1999797 | 1999797 | 2021-12-10 | Kennebec | Maine | 23011 | 12650 | 133 |
1996546 | 1996546 | 2021-12-09 | Kennebec | Maine | 23011 | 12475 | 131 |
1993295 | 1993295 | 2021-12-08 | Kennebec | Maine | 23011 | 12349 | 130 |
1990044 | 1990044 | 2021-12-07 | Kennebec | Maine | 23011 | 12148 | 126 |
1986794 | 1986794 | 2021-12-06 | Kennebec | Maine | 23011 | 12056 | 125 |
1983544 | 1983544 | 2021-12-05 | Kennebec | Maine | 23011 | 12056 | 125 |
1980294 | 1980294 | 2021-12-04 | Kennebec | Maine | 23011 | 12056 | 125 |
1977044 | 1977044 | 2021-12-03 | Kennebec | Maine | 23011 | 11974 | 123 |
1973795 | 1973795 | 2021-12-02 | Kennebec | Maine | 23011 | 11866 | 123 |
1970545 | 1970545 | 2021-12-01 | Kennebec | Maine | 23011 | 11829 | 122 |
1967295 | 1967295 | 2021-11-30 | Kennebec | Maine | 23011 | 11671 | 122 |
1964043 | 1964043 | 2021-11-29 | Kennebec | Maine | 23011 | 11600 | 120 |
1960792 | 1960792 | 2021-11-28 | Kennebec | Maine | 23011 | 11591 | 120 |
1957541 | 1957541 | 2021-11-27 | Kennebec | Maine | 23011 | 11591 | 120 |
1954290 | 1954290 | 2021-11-26 | Kennebec | Maine | 23011 | 11591 | 120 |
1951039 | 1951039 | 2021-11-25 | Kennebec | Maine | 23011 | 11591 | 120 |
1947788 | 1947788 | 2021-11-24 | Kennebec | Maine | 23011 | 11482 | 120 |
1944537 | 1944537 | 2021-11-23 | Kennebec | Maine | 23011 | 11382 | 118 |
1941287 | 1941287 | 2021-11-22 | Kennebec | Maine | 23011 | 11252 | 113 |
1938037 | 1938037 | 2021-11-21 | Kennebec | Maine | 23011 | 11252 | 113 |
1934787 | 1934787 | 2021-11-20 | Kennebec | Maine | 23011 | 11252 | 113 |
1931536 | 1931536 | 2021-11-19 | Kennebec | Maine | 23011 | 11177 | 113 |
1928285 | 1928285 | 2021-11-18 | Kennebec | Maine | 23011 | 11117 | 111 |
1925035 | 1925035 | 2021-11-17 | Kennebec | Maine | 23011 | 11032 | 111 |
1921786 | 1921786 | 2021-11-16 | Kennebec | Maine | 23011 | 10905 | 111 |
1918536 | 1918536 | 2021-11-15 | Kennebec | Maine | 23011 | 10792 | 110 |
1915286 | 1915286 | 2021-11-14 | Kennebec | Maine | 23011 | 10792 | 110 |
1912036 | 1912036 | 2021-11-13 | Kennebec | Maine | 23011 | 10792 | 110 |
1908787 | 1908787 | 2021-11-12 | Kennebec | Maine | 23011 | 10733 | 110 |
1905538 | 1905538 | 2021-11-11 | Kennebec | Maine | 23011 | 10733 | 110 |
1902288 | 1902288 | 2021-11-10 | Kennebec | Maine | 23011 | 10641 | 109 |
1899038 | 1899038 | 2021-11-09 | Kennebec | Maine | 23011 | 10464 | 109 |
1895788 | 1895788 | 2021-11-08 | Kennebec | Maine | 23011 | 10350 | 107 |
1892538 | 1892538 | 2021-11-07 | Kennebec | Maine | 23011 | 10350 | 107 |
1889288 | 1889288 | 2021-11-06 | Kennebec | Maine | 23011 | 10350 | 107 |
1886038 | 1886038 | 2021-11-05 | Kennebec | Maine | 23011 | 10269 | 106 |
1882789 | 1882789 | 2021-11-04 | Kennebec | Maine | 23011 | 10196 | 106 |
1879540 | 1879540 | 2021-11-03 | Kennebec | Maine | 23011 | 10135 | 106 |
1876291 | 1876291 | 2021-11-02 | Kennebec | Maine | 23011 | 10063 | 106 |
1873042 | 1873042 | 2021-11-01 | Kennebec | Maine | 23011 | 9939 | 103 |
1869793 | 1869793 | 2021-10-31 | Kennebec | Maine | 23011 | 9939 | 103 |
1866544 | 1866544 | 2021-10-30 | Kennebec | Maine | 23011 | 9939 | 103 |
1863295 | 1863295 | 2021-10-29 | Kennebec | Maine | 23011 | 9873 | 103 |
1860046 | 1860046 | 2021-10-28 | Kennebec | Maine | 23011 | 9810 | 103 |
1856797 | 1856797 | 2021-10-27 | Kennebec | Maine | 23011 | 9763 | 103 |
1853548 | 1853548 | 2021-10-26 | Kennebec | Maine | 23011 | 9720 | 102 |
1850299 | 1850299 | 2021-10-25 | Kennebec | Maine | 23011 | 9636 | 102 |
1847049 | 1847049 | 2021-10-24 | Kennebec | Maine | 23011 | 9636 | 102 |
1843799 | 1843799 | 2021-10-23 | Kennebec | Maine | 23011 | 9636 | 102 |
1840549 | 1840549 | 2021-10-22 | Kennebec | Maine | 23011 | 9592 | 101 |
1837300 | 1837300 | 2021-10-21 | Kennebec | Maine | 23011 | 9537 | 101 |
1834051 | 1834051 | 2021-10-20 | Kennebec | Maine | 23011 | 9470 | 101 |
1830802 | 1830802 | 2021-10-19 | Kennebec | Maine | 23011 | 9413 | 100 |
1827553 | 1827553 | 2021-10-18 | Kennebec | Maine | 23011 | 9299 | 100 |
1824304 | 1824304 | 2021-10-17 | Kennebec | Maine | 23011 | 9299 | 100 |
1821055 | 1821055 | 2021-10-16 | Kennebec | Maine | 23011 | 9299 | 100 |
1817806 | 1817806 | 2021-10-15 | Kennebec | Maine | 23011 | 9270 | 100 |
1814558 | 1814558 | 2021-10-14 | Kennebec | Maine | 23011 | 9212 | 100 |
1811309 | 1811309 | 2021-10-13 | Kennebec | Maine | 23011 | 9141 | 99 |
1808060 | 1808060 | 2021-10-12 | Kennebec | Maine | 23011 | 9055 | 98 |
1804809 | 1804809 | 2021-10-11 | Kennebec | Maine | 23011 | 9055 | 98 |
1801560 | 1801560 | 2021-10-10 | Kennebec | Maine | 23011 | 9055 | 98 |
1798311 | 1798311 | 2021-10-09 | Kennebec | Maine | 23011 | 9055 | 98 |
1795062 | 1795062 | 2021-10-08 | Kennebec | Maine | 23011 | 8992 | 97 |
1791814 | 1791814 | 2021-10-07 | Kennebec | Maine | 23011 | 8962 | 97 |
1788565 | 1788565 | 2021-10-06 | Kennebec | Maine | 23011 | 8880 | 97 |
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);