ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
833 rows where fips = 25025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175436 | 2175436 | 2022-02-02 | Suffolk | Massachusetts | 25025 | 199366 | 2178 |
2172183 | 2172183 | 2022-02-01 | Suffolk | Massachusetts | 25025 | 198821 | 2169 |
2168930 | 2168930 | 2022-01-31 | Suffolk | Massachusetts | 25025 | 198467 | 2156 |
2165675 | 2165675 | 2022-01-30 | Suffolk | Massachusetts | 25025 | 197025 | 2144 |
2162420 | 2162420 | 2022-01-29 | Suffolk | Massachusetts | 25025 | 197025 | 2144 |
2159165 | 2159165 | 2022-01-28 | Suffolk | Massachusetts | 25025 | 197025 | 2144 |
2155911 | 2155911 | 2022-01-27 | Suffolk | Massachusetts | 25025 | 196144 | 2138 |
2152658 | 2152658 | 2022-01-26 | Suffolk | Massachusetts | 25025 | 195110 | 2132 |
2149406 | 2149406 | 2022-01-25 | Suffolk | Massachusetts | 25025 | 194264 | 2125 |
2146154 | 2146154 | 2022-01-24 | Suffolk | Massachusetts | 25025 | 193353 | 2109 |
2142899 | 2142899 | 2022-01-23 | Suffolk | Massachusetts | 25025 | 190442 | 2099 |
2139644 | 2139644 | 2022-01-22 | Suffolk | Massachusetts | 25025 | 190442 | 2099 |
2136388 | 2136388 | 2022-01-21 | Suffolk | Massachusetts | 25025 | 190442 | 2099 |
2133136 | 2133136 | 2022-01-20 | Suffolk | Massachusetts | 25025 | 188635 | 2090 |
2129883 | 2129883 | 2022-01-19 | Suffolk | Massachusetts | 25025 | 186921 | 2084 |
2126629 | 2126629 | 2022-01-18 | Suffolk | Massachusetts | 25025 | 185219 | 2063 |
2123377 | 2123377 | 2022-01-17 | Suffolk | Massachusetts | 25025 | 177968 | 2055 |
2120125 | 2120125 | 2022-01-16 | Suffolk | Massachusetts | 25025 | 177968 | 2055 |
2116873 | 2116873 | 2022-01-15 | Suffolk | Massachusetts | 25025 | 177968 | 2055 |
2113622 | 2113622 | 2022-01-14 | Suffolk | Massachusetts | 25025 | 177968 | 2055 |
2110370 | 2110370 | 2022-01-13 | Suffolk | Massachusetts | 25025 | 176203 | 2051 |
2107119 | 2107119 | 2022-01-12 | Suffolk | Massachusetts | 25025 | 173920 | 2049 |
2103868 | 2103868 | 2022-01-11 | Suffolk | Massachusetts | 25025 | 170767 | 2039 |
2100617 | 2100617 | 2022-01-10 | Suffolk | Massachusetts | 25025 | 168020 | 2028 |
2097366 | 2097366 | 2022-01-09 | Suffolk | Massachusetts | 25025 | 158998 | 2021 |
2094114 | 2094114 | 2022-01-08 | Suffolk | Massachusetts | 25025 | 158998 | 2021 |
2090862 | 2090862 | 2022-01-07 | Suffolk | Massachusetts | 25025 | 158998 | 2021 |
2087611 | 2087611 | 2022-01-06 | Suffolk | Massachusetts | 25025 | 154591 | 2017 |
2084359 | 2084359 | 2022-01-05 | Suffolk | Massachusetts | 25025 | 151046 | 2014 |
2081107 | 2081107 | 2022-01-04 | Suffolk | Massachusetts | 25025 | 147263 | 2010 |
2077855 | 2077855 | 2022-01-03 | Suffolk | Massachusetts | 25025 | 145136 | 2000 |
2074604 | 2074604 | 2022-01-02 | Suffolk | Massachusetts | 25025 | 139704 | 2000 |
2071353 | 2071353 | 2022-01-01 | Suffolk | Massachusetts | 25025 | 139704 | 2000 |
2068102 | 2068102 | 2021-12-31 | Suffolk | Massachusetts | 25025 | 139704 | 2000 |
2064851 | 2064851 | 2021-12-30 | Suffolk | Massachusetts | 25025 | 136536 | 1995 |
2061601 | 2061601 | 2021-12-29 | Suffolk | Massachusetts | 25025 | 133305 | 1992 |
2058352 | 2058352 | 2021-12-28 | Suffolk | Massachusetts | 25025 | 130951 | 1989 |
2055103 | 2055103 | 2021-12-27 | Suffolk | Massachusetts | 25025 | 129709 | 1985 |
2051853 | 2051853 | 2021-12-26 | Suffolk | Massachusetts | 25025 | 127627 | 1985 |
2048603 | 2048603 | 2021-12-25 | Suffolk | Massachusetts | 25025 | 127627 | 1985 |
2045353 | 2045353 | 2021-12-24 | Suffolk | Massachusetts | 25025 | 127627 | 1985 |
2042103 | 2042103 | 2021-12-23 | Suffolk | Massachusetts | 25025 | 125978 | 1982 |
2038854 | 2038854 | 2021-12-22 | Suffolk | Massachusetts | 25025 | 124585 | 1976 |
2035604 | 2035604 | 2021-12-21 | Suffolk | Massachusetts | 25025 | 123452 | 1974 |
2032354 | 2032354 | 2021-12-20 | Suffolk | Massachusetts | 25025 | 122621 | 1972 |
2029103 | 2029103 | 2021-12-19 | Suffolk | Massachusetts | 25025 | 120820 | 1970 |
2025852 | 2025852 | 2021-12-18 | Suffolk | Massachusetts | 25025 | 120820 | 1970 |
2022601 | 2022601 | 2021-12-17 | Suffolk | Massachusetts | 25025 | 120820 | 1970 |
2019350 | 2019350 | 2021-12-16 | Suffolk | Massachusetts | 25025 | 120054 | 1966 |
2016100 | 2016100 | 2021-12-15 | Suffolk | Massachusetts | 25025 | 119248 | 1961 |
2012849 | 2012849 | 2021-12-14 | Suffolk | Massachusetts | 25025 | 118716 | 1958 |
2009598 | 2009598 | 2021-12-13 | Suffolk | Massachusetts | 25025 | 118384 | 1955 |
2006347 | 2006347 | 2021-12-12 | Suffolk | Massachusetts | 25025 | 117320 | 1952 |
2003096 | 2003096 | 2021-12-11 | Suffolk | Massachusetts | 25025 | 117320 | 1952 |
1999846 | 1999846 | 2021-12-10 | Suffolk | Massachusetts | 25025 | 117320 | 1952 |
1996595 | 1996595 | 2021-12-09 | Suffolk | Massachusetts | 25025 | 116811 | 1950 |
1993344 | 1993344 | 2021-12-08 | Suffolk | Massachusetts | 25025 | 116325 | 1946 |
1990093 | 1990093 | 2021-12-07 | Suffolk | Massachusetts | 25025 | 115874 | 1946 |
1986843 | 1986843 | 2021-12-06 | Suffolk | Massachusetts | 25025 | 115434 | 1945 |
1983593 | 1983593 | 2021-12-05 | Suffolk | Massachusetts | 25025 | 114395 | 1945 |
1980343 | 1980343 | 2021-12-04 | Suffolk | Massachusetts | 25025 | 114395 | 1945 |
1977093 | 1977093 | 2021-12-03 | Suffolk | Massachusetts | 25025 | 114395 | 1945 |
1973843 | 1973843 | 2021-12-02 | Suffolk | Massachusetts | 25025 | 113925 | 1943 |
1970594 | 1970594 | 2021-12-01 | Suffolk | Massachusetts | 25025 | 113469 | 1942 |
1967344 | 1967344 | 2021-11-30 | Suffolk | Massachusetts | 25025 | 113123 | 1941 |
1964092 | 1964092 | 2021-11-29 | Suffolk | Massachusetts | 25025 | 112915 | 1940 |
1960841 | 1960841 | 2021-11-28 | Suffolk | Massachusetts | 25025 | 112490 | 1937 |
1957590 | 1957590 | 2021-11-27 | Suffolk | Massachusetts | 25025 | 112490 | 1937 |
1954339 | 1954339 | 2021-11-26 | Suffolk | Massachusetts | 25025 | 112490 | 1937 |
1951088 | 1951088 | 2021-11-25 | Suffolk | Massachusetts | 25025 | 112045 | 1936 |
1947837 | 1947837 | 2021-11-24 | Suffolk | Massachusetts | 25025 | 112045 | 1936 |
1944586 | 1944586 | 2021-11-23 | Suffolk | Massachusetts | 25025 | 111813 | 1935 |
1941335 | 1941335 | 2021-11-22 | Suffolk | Massachusetts | 25025 | 111661 | 1933 |
1938085 | 1938085 | 2021-11-21 | Suffolk | Massachusetts | 25025 | 111037 | 1934 |
1934835 | 1934835 | 2021-11-20 | Suffolk | Massachusetts | 25025 | 111037 | 1934 |
1931585 | 1931585 | 2021-11-19 | Suffolk | Massachusetts | 25025 | 111037 | 1934 |
1928334 | 1928334 | 2021-11-18 | Suffolk | Massachusetts | 25025 | 110764 | 1932 |
1925084 | 1925084 | 2021-11-17 | Suffolk | Massachusetts | 25025 | 110455 | 1932 |
1921835 | 1921835 | 2021-11-16 | Suffolk | Massachusetts | 25025 | 110233 | 1932 |
1918585 | 1918585 | 2021-11-15 | Suffolk | Massachusetts | 25025 | 110095 | 1930 |
1915335 | 1915335 | 2021-11-14 | Suffolk | Massachusetts | 25025 | 109609 | 1928 |
1912085 | 1912085 | 2021-11-13 | Suffolk | Massachusetts | 25025 | 109609 | 1928 |
1908835 | 1908835 | 2021-11-12 | Suffolk | Massachusetts | 25025 | 109609 | 1928 |
1905586 | 1905586 | 2021-11-11 | Suffolk | Massachusetts | 25025 | 109231 | 1929 |
1902337 | 1902337 | 2021-11-10 | Suffolk | Massachusetts | 25025 | 109231 | 1929 |
1899087 | 1899087 | 2021-11-09 | Suffolk | Massachusetts | 25025 | 109101 | 1926 |
1895837 | 1895837 | 2021-11-08 | Suffolk | Massachusetts | 25025 | 108983 | 1925 |
1892587 | 1892587 | 2021-11-07 | Suffolk | Massachusetts | 25025 | 108615 | 1924 |
1889337 | 1889337 | 2021-11-06 | Suffolk | Massachusetts | 25025 | 108615 | 1924 |
1886087 | 1886087 | 2021-11-05 | Suffolk | Massachusetts | 25025 | 108615 | 1924 |
1882838 | 1882838 | 2021-11-04 | Suffolk | Massachusetts | 25025 | 108425 | 1923 |
1879589 | 1879589 | 2021-11-03 | Suffolk | Massachusetts | 25025 | 108237 | 1921 |
1876340 | 1876340 | 2021-11-02 | Suffolk | Massachusetts | 25025 | 108157 | 1921 |
1873091 | 1873091 | 2021-11-01 | Suffolk | Massachusetts | 25025 | 108069 | 1920 |
1869842 | 1869842 | 2021-10-31 | Suffolk | Massachusetts | 25025 | 107738 | 1920 |
1866593 | 1866593 | 2021-10-30 | Suffolk | Massachusetts | 25025 | 107738 | 1920 |
1863344 | 1863344 | 2021-10-29 | Suffolk | Massachusetts | 25025 | 107738 | 1920 |
1860095 | 1860095 | 2021-10-28 | Suffolk | Massachusetts | 25025 | 107600 | 1919 |
1856846 | 1856846 | 2021-10-27 | Suffolk | Massachusetts | 25025 | 107461 | 1918 |
1853597 | 1853597 | 2021-10-26 | Suffolk | Massachusetts | 25025 | 107357 | 1918 |
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);