ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 25017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175432 | 2175432 | 2022-02-02 | Middlesex | Massachusetts | 25017 | 307188 | 4486 |
2172179 | 2172179 | 2022-02-01 | Middlesex | Massachusetts | 25017 | 306086 | 4473 |
2168926 | 2168926 | 2022-01-31 | Middlesex | Massachusetts | 25017 | 305536 | 4443 |
2165671 | 2165671 | 2022-01-30 | Middlesex | Massachusetts | 25017 | 303054 | 4421 |
2162416 | 2162416 | 2022-01-29 | Middlesex | Massachusetts | 25017 | 303054 | 4421 |
2159161 | 2159161 | 2022-01-28 | Middlesex | Massachusetts | 25017 | 303054 | 4421 |
2155907 | 2155907 | 2022-01-27 | Middlesex | Massachusetts | 25017 | 301631 | 4398 |
2152654 | 2152654 | 2022-01-26 | Middlesex | Massachusetts | 25017 | 299948 | 4381 |
2149402 | 2149402 | 2022-01-25 | Middlesex | Massachusetts | 25017 | 298050 | 4364 |
2146150 | 2146150 | 2022-01-24 | Middlesex | Massachusetts | 25017 | 296675 | 4340 |
2142895 | 2142895 | 2022-01-23 | Middlesex | Massachusetts | 25017 | 291711 | 4323 |
2139640 | 2139640 | 2022-01-22 | Middlesex | Massachusetts | 25017 | 291711 | 4323 |
2136384 | 2136384 | 2022-01-21 | Middlesex | Massachusetts | 25017 | 291711 | 4323 |
2133132 | 2133132 | 2022-01-20 | Middlesex | Massachusetts | 25017 | 289046 | 4301 |
2129879 | 2129879 | 2022-01-19 | Middlesex | Massachusetts | 25017 | 286132 | 4285 |
2126625 | 2126625 | 2022-01-18 | Middlesex | Massachusetts | 25017 | 282467 | 4242 |
2123373 | 2123373 | 2022-01-17 | Middlesex | Massachusetts | 25017 | 270534 | 4228 |
2120121 | 2120121 | 2022-01-16 | Middlesex | Massachusetts | 25017 | 270534 | 4228 |
2116869 | 2116869 | 2022-01-15 | Middlesex | Massachusetts | 25017 | 270534 | 4228 |
2113618 | 2113618 | 2022-01-14 | Middlesex | Massachusetts | 25017 | 270534 | 4228 |
2110366 | 2110366 | 2022-01-13 | Middlesex | Massachusetts | 25017 | 267670 | 4222 |
2107115 | 2107115 | 2022-01-12 | Middlesex | Massachusetts | 25017 | 263784 | 4214 |
2103864 | 2103864 | 2022-01-11 | Middlesex | Massachusetts | 25017 | 258623 | 4201 |
2100613 | 2100613 | 2022-01-10 | Middlesex | Massachusetts | 25017 | 254872 | 4179 |
2097362 | 2097362 | 2022-01-09 | Middlesex | Massachusetts | 25017 | 241111 | 4166 |
2094110 | 2094110 | 2022-01-08 | Middlesex | Massachusetts | 25017 | 241111 | 4166 |
2090858 | 2090858 | 2022-01-07 | Middlesex | Massachusetts | 25017 | 241111 | 4166 |
2087607 | 2087607 | 2022-01-06 | Middlesex | Massachusetts | 25017 | 235997 | 4157 |
2084355 | 2084355 | 2022-01-05 | Middlesex | Massachusetts | 25017 | 229701 | 4153 |
2081103 | 2081103 | 2022-01-04 | Middlesex | Massachusetts | 25017 | 223261 | 4144 |
2077851 | 2077851 | 2022-01-03 | Middlesex | Massachusetts | 25017 | 219876 | 4135 |
2074600 | 2074600 | 2022-01-02 | Middlesex | Massachusetts | 25017 | 213486 | 4129 |
2071349 | 2071349 | 2022-01-01 | Middlesex | Massachusetts | 25017 | 213486 | 4129 |
2068098 | 2068098 | 2021-12-31 | Middlesex | Massachusetts | 25017 | 213486 | 4129 |
2064847 | 2064847 | 2021-12-30 | Middlesex | Massachusetts | 25017 | 208865 | 4124 |
2061597 | 2061597 | 2021-12-29 | Middlesex | Massachusetts | 25017 | 204638 | 4117 |
2058348 | 2058348 | 2021-12-28 | Middlesex | Massachusetts | 25017 | 201332 | 4109 |
2055099 | 2055099 | 2021-12-27 | Middlesex | Massachusetts | 25017 | 199271 | 4097 |
2051849 | 2051849 | 2021-12-26 | Middlesex | Massachusetts | 25017 | 196703 | 4094 |
2048599 | 2048599 | 2021-12-25 | Middlesex | Massachusetts | 25017 | 196703 | 4094 |
2045349 | 2045349 | 2021-12-24 | Middlesex | Massachusetts | 25017 | 196703 | 4094 |
2042099 | 2042099 | 2021-12-23 | Middlesex | Massachusetts | 25017 | 194544 | 4088 |
2038850 | 2038850 | 2021-12-22 | Middlesex | Massachusetts | 25017 | 192450 | 4076 |
2035600 | 2035600 | 2021-12-21 | Middlesex | Massachusetts | 25017 | 190649 | 4068 |
2032350 | 2032350 | 2021-12-20 | Middlesex | Massachusetts | 25017 | 189533 | 4059 |
2029099 | 2029099 | 2021-12-19 | Middlesex | Massachusetts | 25017 | 186874 | 4057 |
2025848 | 2025848 | 2021-12-18 | Middlesex | Massachusetts | 25017 | 186874 | 4057 |
2022597 | 2022597 | 2021-12-17 | Middlesex | Massachusetts | 25017 | 186874 | 4057 |
2019346 | 2019346 | 2021-12-16 | Middlesex | Massachusetts | 25017 | 185583 | 4045 |
2016096 | 2016096 | 2021-12-15 | Middlesex | Massachusetts | 25017 | 184434 | 4042 |
2012845 | 2012845 | 2021-12-14 | Middlesex | Massachusetts | 25017 | 183387 | 4037 |
2009594 | 2009594 | 2021-12-13 | Middlesex | Massachusetts | 25017 | 182713 | 4029 |
2006343 | 2006343 | 2021-12-12 | Middlesex | Massachusetts | 25017 | 180554 | 4022 |
2003092 | 2003092 | 2021-12-11 | Middlesex | Massachusetts | 25017 | 180554 | 4022 |
1999842 | 1999842 | 2021-12-10 | Middlesex | Massachusetts | 25017 | 180554 | 4022 |
1996591 | 1996591 | 2021-12-09 | Middlesex | Massachusetts | 25017 | 179618 | 4016 |
1993340 | 1993340 | 2021-12-08 | Middlesex | Massachusetts | 25017 | 178510 | 4013 |
1990089 | 1990089 | 2021-12-07 | Middlesex | Massachusetts | 25017 | 177499 | 4011 |
1986839 | 1986839 | 2021-12-06 | Middlesex | Massachusetts | 25017 | 176891 | 4001 |
1983589 | 1983589 | 2021-12-05 | Middlesex | Massachusetts | 25017 | 174735 | 3998 |
1980339 | 1980339 | 2021-12-04 | Middlesex | Massachusetts | 25017 | 174735 | 3998 |
1977089 | 1977089 | 2021-12-03 | Middlesex | Massachusetts | 25017 | 174735 | 3998 |
1973839 | 1973839 | 2021-12-02 | Middlesex | Massachusetts | 25017 | 173693 | 3993 |
1970590 | 1970590 | 2021-12-01 | Middlesex | Massachusetts | 25017 | 172710 | 3983 |
1967340 | 1967340 | 2021-11-30 | Middlesex | Massachusetts | 25017 | 171732 | 3980 |
1964088 | 1964088 | 2021-11-29 | Middlesex | Massachusetts | 25017 | 171126 | 3974 |
1960837 | 1960837 | 2021-11-28 | Middlesex | Massachusetts | 25017 | 170099 | 3973 |
1957586 | 1957586 | 2021-11-27 | Middlesex | Massachusetts | 25017 | 170099 | 3973 |
1954335 | 1954335 | 2021-11-26 | Middlesex | Massachusetts | 25017 | 170099 | 3973 |
1951084 | 1951084 | 2021-11-25 | Middlesex | Massachusetts | 25017 | 169160 | 3969 |
1947833 | 1947833 | 2021-11-24 | Middlesex | Massachusetts | 25017 | 169160 | 3969 |
1944582 | 1944582 | 2021-11-23 | Middlesex | Massachusetts | 25017 | 168570 | 3967 |
1941331 | 1941331 | 2021-11-22 | Middlesex | Massachusetts | 25017 | 168126 | 3961 |
1938081 | 1938081 | 2021-11-21 | Middlesex | Massachusetts | 25017 | 166818 | 3959 |
1934831 | 1934831 | 2021-11-20 | Middlesex | Massachusetts | 25017 | 166818 | 3959 |
1931581 | 1931581 | 2021-11-19 | Middlesex | Massachusetts | 25017 | 166818 | 3959 |
1928330 | 1928330 | 2021-11-18 | Middlesex | Massachusetts | 25017 | 166268 | 3953 |
1925080 | 1925080 | 2021-11-17 | Middlesex | Massachusetts | 25017 | 165657 | 3953 |
1921831 | 1921831 | 2021-11-16 | Middlesex | Massachusetts | 25017 | 165102 | 3950 |
1918581 | 1918581 | 2021-11-15 | Middlesex | Massachusetts | 25017 | 164749 | 3947 |
1915331 | 1915331 | 2021-11-14 | Middlesex | Massachusetts | 25017 | 163654 | 3944 |
1912081 | 1912081 | 2021-11-13 | Middlesex | Massachusetts | 25017 | 163654 | 3944 |
1908831 | 1908831 | 2021-11-12 | Middlesex | Massachusetts | 25017 | 163654 | 3944 |
1905582 | 1905582 | 2021-11-11 | Middlesex | Massachusetts | 25017 | 162934 | 3943 |
1902333 | 1902333 | 2021-11-10 | Middlesex | Massachusetts | 25017 | 162934 | 3943 |
1899083 | 1899083 | 2021-11-09 | Middlesex | Massachusetts | 25017 | 162565 | 3940 |
1895833 | 1895833 | 2021-11-08 | Middlesex | Massachusetts | 25017 | 162297 | 3935 |
1892583 | 1892583 | 2021-11-07 | Middlesex | Massachusetts | 25017 | 161457 | 3935 |
1889333 | 1889333 | 2021-11-06 | Middlesex | Massachusetts | 25017 | 161457 | 3935 |
1886083 | 1886083 | 2021-11-05 | Middlesex | Massachusetts | 25017 | 161457 | 3935 |
1882834 | 1882834 | 2021-11-04 | Middlesex | Massachusetts | 25017 | 161124 | 3932 |
1879585 | 1879585 | 2021-11-03 | Middlesex | Massachusetts | 25017 | 160772 | 3929 |
1876336 | 1876336 | 2021-11-02 | Middlesex | Massachusetts | 25017 | 160515 | 3928 |
1873087 | 1873087 | 2021-11-01 | Middlesex | Massachusetts | 25017 | 160294 | 3926 |
1869838 | 1869838 | 2021-10-31 | Middlesex | Massachusetts | 25017 | 159612 | 3925 |
1866589 | 1866589 | 2021-10-30 | Middlesex | Massachusetts | 25017 | 159612 | 3925 |
1863340 | 1863340 | 2021-10-29 | Middlesex | Massachusetts | 25017 | 159612 | 3925 |
1860091 | 1860091 | 2021-10-28 | Middlesex | Massachusetts | 25017 | 159335 | 3923 |
1856842 | 1856842 | 2021-10-27 | Middlesex | Massachusetts | 25017 | 159020 | 3920 |
1853593 | 1853593 | 2021-10-26 | Middlesex | Massachusetts | 25017 | 158740 | 3917 |
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);