ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 23001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175382 | 2175382 | 2022-02-02 | Androscoggin | Maine | 23001 | 17847 | 190 |
2172129 | 2172129 | 2022-02-01 | Androscoggin | Maine | 23001 | 17733 | 190 |
2168876 | 2168876 | 2022-01-31 | Androscoggin | Maine | 23001 | 17596 | 189 |
2165621 | 2165621 | 2022-01-30 | Androscoggin | Maine | 23001 | 17596 | 189 |
2162366 | 2162366 | 2022-01-29 | Androscoggin | Maine | 23001 | 17596 | 189 |
2159111 | 2159111 | 2022-01-28 | Androscoggin | Maine | 23001 | 17465 | 187 |
2155857 | 2155857 | 2022-01-27 | Androscoggin | Maine | 23001 | 17332 | 187 |
2152604 | 2152604 | 2022-01-26 | Androscoggin | Maine | 23001 | 17228 | 185 |
2149352 | 2149352 | 2022-01-25 | Androscoggin | Maine | 23001 | 17140 | 185 |
2146100 | 2146100 | 2022-01-24 | Androscoggin | Maine | 23001 | 17032 | 184 |
2142845 | 2142845 | 2022-01-23 | Androscoggin | Maine | 23001 | 17032 | 184 |
2139590 | 2139590 | 2022-01-22 | Androscoggin | Maine | 23001 | 17032 | 184 |
2136334 | 2136334 | 2022-01-21 | Androscoggin | Maine | 23001 | 16906 | 183 |
2133082 | 2133082 | 2022-01-20 | Androscoggin | Maine | 23001 | 16792 | 182 |
2129829 | 2129829 | 2022-01-19 | Androscoggin | Maine | 23001 | 16723 | 183 |
2126575 | 2126575 | 2022-01-18 | Androscoggin | Maine | 23001 | 16623 | 179 |
2123323 | 2123323 | 2022-01-17 | Androscoggin | Maine | 23001 | 16536 | 179 |
2120071 | 2120071 | 2022-01-16 | Androscoggin | Maine | 23001 | 16536 | 179 |
2116819 | 2116819 | 2022-01-15 | Androscoggin | Maine | 23001 | 16536 | 179 |
2113568 | 2113568 | 2022-01-14 | Androscoggin | Maine | 23001 | 16454 | 178 |
2110316 | 2110316 | 2022-01-13 | Androscoggin | Maine | 23001 | 16325 | 173 |
2107065 | 2107065 | 2022-01-12 | Androscoggin | Maine | 23001 | 16173 | 173 |
2103814 | 2103814 | 2022-01-11 | Androscoggin | Maine | 23001 | 16099 | 173 |
2100563 | 2100563 | 2022-01-10 | Androscoggin | Maine | 23001 | 15980 | 170 |
2097312 | 2097312 | 2022-01-09 | Androscoggin | Maine | 23001 | 15980 | 170 |
2094060 | 2094060 | 2022-01-08 | Androscoggin | Maine | 23001 | 15980 | 170 |
2090808 | 2090808 | 2022-01-07 | Androscoggin | Maine | 23001 | 15855 | 169 |
2087557 | 2087557 | 2022-01-06 | Androscoggin | Maine | 23001 | 15778 | 167 |
2084305 | 2084305 | 2022-01-05 | Androscoggin | Maine | 23001 | 15749 | 166 |
2081053 | 2081053 | 2022-01-04 | Androscoggin | Maine | 23001 | 15652 | 163 |
2077801 | 2077801 | 2022-01-03 | Androscoggin | Maine | 23001 | 15522 | 158 |
2074550 | 2074550 | 2022-01-02 | Androscoggin | Maine | 23001 | 15522 | 158 |
2071299 | 2071299 | 2022-01-01 | Androscoggin | Maine | 23001 | 15522 | 158 |
2068048 | 2068048 | 2021-12-31 | Androscoggin | Maine | 23001 | 15522 | 158 |
2064797 | 2064797 | 2021-12-30 | Androscoggin | Maine | 23001 | 15358 | 157 |
2061547 | 2061547 | 2021-12-29 | Androscoggin | Maine | 23001 | 15282 | 157 |
2058298 | 2058298 | 2021-12-28 | Androscoggin | Maine | 23001 | 15196 | 154 |
2055049 | 2055049 | 2021-12-27 | Androscoggin | Maine | 23001 | 15101 | 154 |
2051799 | 2051799 | 2021-12-26 | Androscoggin | Maine | 23001 | 15100 | 154 |
2048549 | 2048549 | 2021-12-25 | Androscoggin | Maine | 23001 | 15100 | 154 |
2045299 | 2045299 | 2021-12-24 | Androscoggin | Maine | 23001 | 15100 | 154 |
2042050 | 2042050 | 2021-12-23 | Androscoggin | Maine | 23001 | 15002 | 154 |
2038800 | 2038800 | 2021-12-22 | Androscoggin | Maine | 23001 | 14924 | 154 |
2035550 | 2035550 | 2021-12-21 | Androscoggin | Maine | 23001 | 14779 | 153 |
2032300 | 2032300 | 2021-12-20 | Androscoggin | Maine | 23001 | 14588 | 144 |
2029049 | 2029049 | 2021-12-19 | Androscoggin | Maine | 23001 | 14588 | 144 |
2025798 | 2025798 | 2021-12-18 | Androscoggin | Maine | 23001 | 14588 | 144 |
2022547 | 2022547 | 2021-12-17 | Androscoggin | Maine | 23001 | 14525 | 141 |
2019296 | 2019296 | 2021-12-16 | Androscoggin | Maine | 23001 | 14454 | 137 |
2016046 | 2016046 | 2021-12-15 | Androscoggin | Maine | 23001 | 14319 | 133 |
2012795 | 2012795 | 2021-12-14 | Androscoggin | Maine | 23001 | 14143 | 133 |
2009544 | 2009544 | 2021-12-13 | Androscoggin | Maine | 23001 | 14051 | 131 |
2006293 | 2006293 | 2021-12-12 | Androscoggin | Maine | 23001 | 14051 | 131 |
2003042 | 2003042 | 2021-12-11 | Androscoggin | Maine | 23001 | 14051 | 131 |
1999792 | 1999792 | 2021-12-10 | Androscoggin | Maine | 23001 | 13950 | 131 |
1996541 | 1996541 | 2021-12-09 | Androscoggin | Maine | 23001 | 13753 | 129 |
1993290 | 1993290 | 2021-12-08 | Androscoggin | Maine | 23001 | 13622 | 129 |
1990039 | 1990039 | 2021-12-07 | Androscoggin | Maine | 23001 | 13434 | 128 |
1986789 | 1986789 | 2021-12-06 | Androscoggin | Maine | 23001 | 13318 | 125 |
1983539 | 1983539 | 2021-12-05 | Androscoggin | Maine | 23001 | 13318 | 125 |
1980289 | 1980289 | 2021-12-04 | Androscoggin | Maine | 23001 | 13318 | 125 |
1977039 | 1977039 | 2021-12-03 | Androscoggin | Maine | 23001 | 13250 | 125 |
1973790 | 1973790 | 2021-12-02 | Androscoggin | Maine | 23001 | 13143 | 125 |
1970540 | 1970540 | 2021-12-01 | Androscoggin | Maine | 23001 | 13023 | 125 |
1967290 | 1967290 | 2021-11-30 | Androscoggin | Maine | 23001 | 12961 | 125 |
1964038 | 1964038 | 2021-11-29 | Androscoggin | Maine | 23001 | 12849 | 121 |
1960787 | 1960787 | 2021-11-28 | Androscoggin | Maine | 23001 | 12800 | 121 |
1957536 | 1957536 | 2021-11-27 | Androscoggin | Maine | 23001 | 12800 | 121 |
1954285 | 1954285 | 2021-11-26 | Androscoggin | Maine | 23001 | 12800 | 121 |
1951034 | 1951034 | 2021-11-25 | Androscoggin | Maine | 23001 | 12800 | 121 |
1947783 | 1947783 | 2021-11-24 | Androscoggin | Maine | 23001 | 12743 | 121 |
1944532 | 1944532 | 2021-11-23 | Androscoggin | Maine | 23001 | 12600 | 121 |
1941282 | 1941282 | 2021-11-22 | Androscoggin | Maine | 23001 | 12436 | 117 |
1938032 | 1938032 | 2021-11-21 | Androscoggin | Maine | 23001 | 12436 | 117 |
1934782 | 1934782 | 2021-11-20 | Androscoggin | Maine | 23001 | 12436 | 117 |
1931531 | 1931531 | 2021-11-19 | Androscoggin | Maine | 23001 | 12298 | 117 |
1928280 | 1928280 | 2021-11-18 | Androscoggin | Maine | 23001 | 12202 | 113 |
1925030 | 1925030 | 2021-11-17 | Androscoggin | Maine | 23001 | 12061 | 112 |
1921781 | 1921781 | 2021-11-16 | Androscoggin | Maine | 23001 | 11913 | 112 |
1918531 | 1918531 | 2021-11-15 | Androscoggin | Maine | 23001 | 11823 | 110 |
1915281 | 1915281 | 2021-11-14 | Androscoggin | Maine | 23001 | 11823 | 110 |
1912031 | 1912031 | 2021-11-13 | Androscoggin | Maine | 23001 | 11823 | 110 |
1908782 | 1908782 | 2021-11-12 | Androscoggin | Maine | 23001 | 11708 | 110 |
1905533 | 1905533 | 2021-11-11 | Androscoggin | Maine | 23001 | 11708 | 110 |
1902283 | 1902283 | 2021-11-10 | Androscoggin | Maine | 23001 | 11573 | 110 |
1899033 | 1899033 | 2021-11-09 | Androscoggin | Maine | 23001 | 11481 | 110 |
1895783 | 1895783 | 2021-11-08 | Androscoggin | Maine | 23001 | 11365 | 109 |
1892533 | 1892533 | 2021-11-07 | Androscoggin | Maine | 23001 | 11365 | 109 |
1889283 | 1889283 | 2021-11-06 | Androscoggin | Maine | 23001 | 11365 | 109 |
1886033 | 1886033 | 2021-11-05 | Androscoggin | Maine | 23001 | 11287 | 109 |
1882784 | 1882784 | 2021-11-04 | Androscoggin | Maine | 23001 | 11184 | 108 |
1879535 | 1879535 | 2021-11-03 | Androscoggin | Maine | 23001 | 11099 | 108 |
1876286 | 1876286 | 2021-11-02 | Androscoggin | Maine | 23001 | 11047 | 104 |
1873037 | 1873037 | 2021-11-01 | Androscoggin | Maine | 23001 | 10973 | 101 |
1869788 | 1869788 | 2021-10-31 | Androscoggin | Maine | 23001 | 10973 | 101 |
1866539 | 1866539 | 2021-10-30 | Androscoggin | Maine | 23001 | 10973 | 101 |
1863290 | 1863290 | 2021-10-29 | Androscoggin | Maine | 23001 | 10898 | 100 |
1860041 | 1860041 | 2021-10-28 | Androscoggin | Maine | 23001 | 10837 | 99 |
1856792 | 1856792 | 2021-10-27 | Androscoggin | Maine | 23001 | 10779 | 99 |
1853543 | 1853543 | 2021-10-26 | Androscoggin | Maine | 23001 | 10726 | 99 |
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);