ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 25015 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175431 | 2175431 | 2022-02-02 | Hampshire | Massachusetts | 25015 | 24396 | 381 |
2172178 | 2172178 | 2022-02-01 | Hampshire | Massachusetts | 25015 | 24253 | 379 |
2168925 | 2168925 | 2022-01-31 | Hampshire | Massachusetts | 25015 | 24165 | 378 |
2165670 | 2165670 | 2022-01-30 | Hampshire | Massachusetts | 25015 | 23855 | 375 |
2162415 | 2162415 | 2022-01-29 | Hampshire | Massachusetts | 25015 | 23855 | 375 |
2159160 | 2159160 | 2022-01-28 | Hampshire | Massachusetts | 25015 | 23855 | 375 |
2155906 | 2155906 | 2022-01-27 | Hampshire | Massachusetts | 25015 | 23618 | 376 |
2152653 | 2152653 | 2022-01-26 | Hampshire | Massachusetts | 25015 | 23430 | 373 |
2149401 | 2149401 | 2022-01-25 | Hampshire | Massachusetts | 25015 | 23225 | 371 |
2146149 | 2146149 | 2022-01-24 | Hampshire | Massachusetts | 25015 | 23119 | 368 |
2142894 | 2142894 | 2022-01-23 | Hampshire | Massachusetts | 25015 | 22379 | 366 |
2139639 | 2139639 | 2022-01-22 | Hampshire | Massachusetts | 25015 | 22379 | 366 |
2136383 | 2136383 | 2022-01-21 | Hampshire | Massachusetts | 25015 | 22379 | 366 |
2133131 | 2133131 | 2022-01-20 | Hampshire | Massachusetts | 25015 | 21949 | 366 |
2129878 | 2129878 | 2022-01-19 | Hampshire | Massachusetts | 25015 | 21465 | 365 |
2126624 | 2126624 | 2022-01-18 | Hampshire | Massachusetts | 25015 | 21297 | 363 |
2123372 | 2123372 | 2022-01-17 | Hampshire | Massachusetts | 25015 | 20218 | 362 |
2120120 | 2120120 | 2022-01-16 | Hampshire | Massachusetts | 25015 | 20218 | 362 |
2116868 | 2116868 | 2022-01-15 | Hampshire | Massachusetts | 25015 | 20218 | 362 |
2113617 | 2113617 | 2022-01-14 | Hampshire | Massachusetts | 25015 | 20218 | 362 |
2110365 | 2110365 | 2022-01-13 | Hampshire | Massachusetts | 25015 | 19784 | 361 |
2107114 | 2107114 | 2022-01-12 | Hampshire | Massachusetts | 25015 | 19545 | 361 |
2103863 | 2103863 | 2022-01-11 | Hampshire | Massachusetts | 25015 | 19072 | 361 |
2100612 | 2100612 | 2022-01-10 | Hampshire | Massachusetts | 25015 | 18842 | 358 |
2097361 | 2097361 | 2022-01-09 | Hampshire | Massachusetts | 25015 | 17779 | 357 |
2094109 | 2094109 | 2022-01-08 | Hampshire | Massachusetts | 25015 | 17779 | 357 |
2090857 | 2090857 | 2022-01-07 | Hampshire | Massachusetts | 25015 | 17779 | 357 |
2087606 | 2087606 | 2022-01-06 | Hampshire | Massachusetts | 25015 | 17157 | 355 |
2084354 | 2084354 | 2022-01-05 | Hampshire | Massachusetts | 25015 | 16888 | 352 |
2081102 | 2081102 | 2022-01-04 | Hampshire | Massachusetts | 25015 | 16557 | 351 |
2077850 | 2077850 | 2022-01-03 | Hampshire | Massachusetts | 25015 | 16294 | 347 |
2074599 | 2074599 | 2022-01-02 | Hampshire | Massachusetts | 25015 | 15988 | 347 |
2071348 | 2071348 | 2022-01-01 | Hampshire | Massachusetts | 25015 | 15988 | 347 |
2068097 | 2068097 | 2021-12-31 | Hampshire | Massachusetts | 25015 | 15988 | 347 |
2064846 | 2064846 | 2021-12-30 | Hampshire | Massachusetts | 25015 | 15701 | 344 |
2061596 | 2061596 | 2021-12-29 | Hampshire | Massachusetts | 25015 | 15452 | 343 |
2058347 | 2058347 | 2021-12-28 | Hampshire | Massachusetts | 25015 | 15324 | 343 |
2055098 | 2055098 | 2021-12-27 | Hampshire | Massachusetts | 25015 | 15170 | 342 |
2051848 | 2051848 | 2021-12-26 | Hampshire | Massachusetts | 25015 | 14941 | 340 |
2048598 | 2048598 | 2021-12-25 | Hampshire | Massachusetts | 25015 | 14941 | 340 |
2045348 | 2045348 | 2021-12-24 | Hampshire | Massachusetts | 25015 | 14941 | 340 |
2042098 | 2042098 | 2021-12-23 | Hampshire | Massachusetts | 25015 | 14757 | 340 |
2038849 | 2038849 | 2021-12-22 | Hampshire | Massachusetts | 25015 | 14581 | 339 |
2035599 | 2035599 | 2021-12-21 | Hampshire | Massachusetts | 25015 | 14498 | 337 |
2032349 | 2032349 | 2021-12-20 | Hampshire | Massachusetts | 25015 | 14439 | 338 |
2029098 | 2029098 | 2021-12-19 | Hampshire | Massachusetts | 25015 | 14139 | 335 |
2025847 | 2025847 | 2021-12-18 | Hampshire | Massachusetts | 25015 | 14139 | 335 |
2022596 | 2022596 | 2021-12-17 | Hampshire | Massachusetts | 25015 | 14139 | 335 |
2019345 | 2019345 | 2021-12-16 | Hampshire | Massachusetts | 25015 | 14034 | 334 |
2016095 | 2016095 | 2021-12-15 | Hampshire | Massachusetts | 25015 | 13912 | 334 |
2012844 | 2012844 | 2021-12-14 | Hampshire | Massachusetts | 25015 | 13809 | 334 |
2009593 | 2009593 | 2021-12-13 | Hampshire | Massachusetts | 25015 | 13716 | 331 |
2006342 | 2006342 | 2021-12-12 | Hampshire | Massachusetts | 25015 | 13513 | 331 |
2003091 | 2003091 | 2021-12-11 | Hampshire | Massachusetts | 25015 | 13513 | 331 |
1999841 | 1999841 | 2021-12-10 | Hampshire | Massachusetts | 25015 | 13513 | 331 |
1996590 | 1996590 | 2021-12-09 | Hampshire | Massachusetts | 25015 | 13370 | 330 |
1993339 | 1993339 | 2021-12-08 | Hampshire | Massachusetts | 25015 | 13241 | 330 |
1990088 | 1990088 | 2021-12-07 | Hampshire | Massachusetts | 25015 | 13143 | 330 |
1986838 | 1986838 | 2021-12-06 | Hampshire | Massachusetts | 25015 | 13088 | 330 |
1983588 | 1983588 | 2021-12-05 | Hampshire | Massachusetts | 25015 | 12876 | 329 |
1980338 | 1980338 | 2021-12-04 | Hampshire | Massachusetts | 25015 | 12876 | 329 |
1977088 | 1977088 | 2021-12-03 | Hampshire | Massachusetts | 25015 | 12876 | 329 |
1973838 | 1973838 | 2021-12-02 | Hampshire | Massachusetts | 25015 | 12757 | 327 |
1970589 | 1970589 | 2021-12-01 | Hampshire | Massachusetts | 25015 | 12691 | 327 |
1967339 | 1967339 | 2021-11-30 | Hampshire | Massachusetts | 25015 | 12608 | 325 |
1964087 | 1964087 | 2021-11-29 | Hampshire | Massachusetts | 25015 | 12566 | 324 |
1960836 | 1960836 | 2021-11-28 | Hampshire | Massachusetts | 25015 | 12484 | 324 |
1957585 | 1957585 | 2021-11-27 | Hampshire | Massachusetts | 25015 | 12484 | 324 |
1954334 | 1954334 | 2021-11-26 | Hampshire | Massachusetts | 25015 | 12484 | 324 |
1951083 | 1951083 | 2021-11-25 | Hampshire | Massachusetts | 25015 | 12382 | 324 |
1947832 | 1947832 | 2021-11-24 | Hampshire | Massachusetts | 25015 | 12382 | 324 |
1944581 | 1944581 | 2021-11-23 | Hampshire | Massachusetts | 25015 | 12342 | 324 |
1941330 | 1941330 | 2021-11-22 | Hampshire | Massachusetts | 25015 | 12319 | 324 |
1938080 | 1938080 | 2021-11-21 | Hampshire | Massachusetts | 25015 | 12204 | 324 |
1934830 | 1934830 | 2021-11-20 | Hampshire | Massachusetts | 25015 | 12204 | 324 |
1931580 | 1931580 | 2021-11-19 | Hampshire | Massachusetts | 25015 | 12204 | 324 |
1928329 | 1928329 | 2021-11-18 | Hampshire | Massachusetts | 25015 | 12153 | 323 |
1925079 | 1925079 | 2021-11-17 | Hampshire | Massachusetts | 25015 | 12108 | 323 |
1921830 | 1921830 | 2021-11-16 | Hampshire | Massachusetts | 25015 | 12063 | 323 |
1918580 | 1918580 | 2021-11-15 | Hampshire | Massachusetts | 25015 | 12041 | 322 |
1915330 | 1915330 | 2021-11-14 | Hampshire | Massachusetts | 25015 | 11973 | 322 |
1912080 | 1912080 | 2021-11-13 | Hampshire | Massachusetts | 25015 | 11973 | 322 |
1908830 | 1908830 | 2021-11-12 | Hampshire | Massachusetts | 25015 | 11973 | 322 |
1905581 | 1905581 | 2021-11-11 | Hampshire | Massachusetts | 25015 | 11904 | 321 |
1902332 | 1902332 | 2021-11-10 | Hampshire | Massachusetts | 25015 | 11904 | 321 |
1899082 | 1899082 | 2021-11-09 | Hampshire | Massachusetts | 25015 | 11896 | 321 |
1895832 | 1895832 | 2021-11-08 | Hampshire | Massachusetts | 25015 | 11880 | 320 |
1892582 | 1892582 | 2021-11-07 | Hampshire | Massachusetts | 25015 | 11797 | 320 |
1889332 | 1889332 | 2021-11-06 | Hampshire | Massachusetts | 25015 | 11797 | 320 |
1886082 | 1886082 | 2021-11-05 | Hampshire | Massachusetts | 25015 | 11797 | 320 |
1882833 | 1882833 | 2021-11-04 | Hampshire | Massachusetts | 25015 | 11781 | 320 |
1879584 | 1879584 | 2021-11-03 | Hampshire | Massachusetts | 25015 | 11758 | 320 |
1876335 | 1876335 | 2021-11-02 | Hampshire | Massachusetts | 25015 | 11743 | 320 |
1873086 | 1873086 | 2021-11-01 | Hampshire | Massachusetts | 25015 | 11730 | 318 |
1869837 | 1869837 | 2021-10-31 | Hampshire | Massachusetts | 25015 | 11664 | 318 |
1866588 | 1866588 | 2021-10-30 | Hampshire | Massachusetts | 25015 | 11664 | 318 |
1863339 | 1863339 | 2021-10-29 | Hampshire | Massachusetts | 25015 | 11664 | 318 |
1860090 | 1860090 | 2021-10-28 | Hampshire | Massachusetts | 25015 | 11647 | 319 |
1856841 | 1856841 | 2021-10-27 | Hampshire | Massachusetts | 25015 | 11626 | 318 |
1853592 | 1853592 | 2021-10-26 | Hampshire | Massachusetts | 25015 | 11606 | 318 |
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);