ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 50003 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177108 | 2177108 | 2022-02-02 | Bennington | Vermont | 50003 | 8079 | 56 |
2173855 | 2173855 | 2022-02-01 | Bennington | Vermont | 50003 | 8039 | 56 |
2170603 | 2170603 | 2022-01-31 | Bennington | Vermont | 50003 | 8002 | 56 |
2167349 | 2167349 | 2022-01-30 | Bennington | Vermont | 50003 | 7980 | 55 |
2164094 | 2164094 | 2022-01-29 | Bennington | Vermont | 50003 | 7953 | 55 |
2160839 | 2160839 | 2022-01-28 | Bennington | Vermont | 50003 | 7927 | 55 |
2157583 | 2157583 | 2022-01-27 | Bennington | Vermont | 50003 | 7863 | 54 |
2154330 | 2154330 | 2022-01-26 | Bennington | Vermont | 50003 | 7807 | 54 |
2151078 | 2151078 | 2022-01-25 | Bennington | Vermont | 50003 | 7706 | 54 |
2147826 | 2147826 | 2022-01-24 | Bennington | Vermont | 50003 | 7630 | 54 |
2144572 | 2144572 | 2022-01-23 | Bennington | Vermont | 50003 | 7577 | 54 |
2141317 | 2141317 | 2022-01-22 | Bennington | Vermont | 50003 | 7529 | 54 |
2138061 | 2138061 | 2022-01-21 | Bennington | Vermont | 50003 | 7458 | 54 |
2134807 | 2134807 | 2022-01-20 | Bennington | Vermont | 50003 | 7180 | 52 |
2131555 | 2131555 | 2022-01-19 | Bennington | Vermont | 50003 | 7180 | 52 |
2128301 | 2128301 | 2022-01-18 | Bennington | Vermont | 50003 | 7127 | 49 |
2125049 | 2125049 | 2022-01-17 | Bennington | Vermont | 50003 | 7036 | 49 |
2121797 | 2121797 | 2022-01-16 | Bennington | Vermont | 50003 | 7036 | 49 |
2118545 | 2118545 | 2022-01-15 | Bennington | Vermont | 50003 | 6942 | 49 |
2115293 | 2115293 | 2022-01-14 | Bennington | Vermont | 50003 | 6857 | 48 |
2112041 | 2112041 | 2022-01-13 | Bennington | Vermont | 50003 | 6727 | 47 |
2108789 | 2108789 | 2022-01-12 | Bennington | Vermont | 50003 | 6626 | 47 |
2105538 | 2105538 | 2022-01-11 | Bennington | Vermont | 50003 | 6367 | 46 |
2102287 | 2102287 | 2022-01-10 | Bennington | Vermont | 50003 | 6367 | 46 |
2099036 | 2099036 | 2022-01-09 | Bennington | Vermont | 50003 | 6367 | 46 |
2095784 | 2095784 | 2022-01-08 | Bennington | Vermont | 50003 | 6302 | 46 |
2092532 | 2092532 | 2022-01-07 | Bennington | Vermont | 50003 | 5987 | 46 |
2089280 | 2089280 | 2022-01-06 | Bennington | Vermont | 50003 | 5964 | 46 |
2086029 | 2086029 | 2022-01-05 | Bennington | Vermont | 50003 | 5943 | 46 |
2082777 | 2082777 | 2022-01-04 | Bennington | Vermont | 50003 | 5847 | 46 |
2079525 | 2079525 | 2022-01-03 | Bennington | Vermont | 50003 | 5776 | 46 |
2076274 | 2076274 | 2022-01-02 | Bennington | Vermont | 50003 | 5524 | 45 |
2073023 | 2073023 | 2022-01-01 | Bennington | Vermont | 50003 | 5524 | 45 |
2069772 | 2069772 | 2021-12-31 | Bennington | Vermont | 50003 | 5524 | 45 |
2066521 | 2066521 | 2021-12-30 | Bennington | Vermont | 50003 | 5524 | 45 |
2063271 | 2063271 | 2021-12-29 | Bennington | Vermont | 50003 | 5430 | 45 |
2060021 | 2060021 | 2021-12-28 | Bennington | Vermont | 50003 | 5332 | 43 |
2056772 | 2056772 | 2021-12-27 | Bennington | Vermont | 50003 | 5309 | 43 |
2053523 | 2053523 | 2021-12-26 | Bennington | Vermont | 50003 | 5187 | 43 |
2050273 | 2050273 | 2021-12-25 | Bennington | Vermont | 50003 | 5187 | 43 |
2047023 | 2047023 | 2021-12-24 | Bennington | Vermont | 50003 | 5187 | 43 |
2043773 | 2043773 | 2021-12-23 | Bennington | Vermont | 50003 | 5187 | 43 |
2040524 | 2040524 | 2021-12-22 | Bennington | Vermont | 50003 | 5140 | 42 |
2037274 | 2037274 | 2021-12-21 | Bennington | Vermont | 50003 | 5070 | 42 |
2034024 | 2034024 | 2021-12-20 | Bennington | Vermont | 50003 | 5055 | 42 |
2030774 | 2030774 | 2021-12-19 | Bennington | Vermont | 50003 | 5034 | 42 |
2027523 | 2027523 | 2021-12-18 | Bennington | Vermont | 50003 | 4988 | 42 |
2024272 | 2024272 | 2021-12-17 | Bennington | Vermont | 50003 | 4949 | 42 |
2021021 | 2021021 | 2021-12-16 | Bennington | Vermont | 50003 | 4895 | 42 |
2017770 | 2017770 | 2021-12-15 | Bennington | Vermont | 50003 | 4853 | 41 |
2014520 | 2014520 | 2021-12-14 | Bennington | Vermont | 50003 | 4789 | 40 |
2011269 | 2011269 | 2021-12-13 | Bennington | Vermont | 50003 | 4778 | 39 |
2008018 | 2008018 | 2021-12-12 | Bennington | Vermont | 50003 | 4754 | 39 |
2004767 | 2004767 | 2021-12-11 | Bennington | Vermont | 50003 | 4728 | 39 |
2001516 | 2001516 | 2021-12-10 | Bennington | Vermont | 50003 | 4694 | 39 |
1998266 | 1998266 | 2021-12-09 | Bennington | Vermont | 50003 | 4665 | 39 |
1995015 | 1995015 | 2021-12-08 | Bennington | Vermont | 50003 | 4622 | 39 |
1991764 | 1991764 | 2021-12-07 | Bennington | Vermont | 50003 | 4549 | 37 |
1988513 | 1988513 | 2021-12-06 | Bennington | Vermont | 50003 | 4535 | 37 |
1985263 | 1985263 | 2021-12-05 | Bennington | Vermont | 50003 | 4488 | 37 |
1982013 | 1982013 | 2021-12-04 | Bennington | Vermont | 50003 | 4450 | 36 |
1978763 | 1978763 | 2021-12-03 | Bennington | Vermont | 50003 | 4407 | 36 |
1975513 | 1975513 | 2021-12-02 | Bennington | Vermont | 50003 | 4348 | 35 |
1972264 | 1972264 | 2021-12-01 | Bennington | Vermont | 50003 | 4274 | 34 |
1969014 | 1969014 | 2021-11-30 | Bennington | Vermont | 50003 | 4141 | 33 |
1965763 | 1965763 | 2021-11-29 | Bennington | Vermont | 50003 | 4121 | 33 |
1962511 | 1962511 | 2021-11-28 | Bennington | Vermont | 50003 | 3966 | 32 |
1959260 | 1959260 | 2021-11-27 | Bennington | Vermont | 50003 | 3966 | 32 |
1956009 | 1956009 | 2021-11-26 | Bennington | Vermont | 50003 | 3966 | 32 |
1952758 | 1952758 | 2021-11-25 | Bennington | Vermont | 50003 | 3966 | 32 |
1949507 | 1949507 | 2021-11-24 | Bennington | Vermont | 50003 | 3966 | 32 |
1946256 | 1946256 | 2021-11-23 | Bennington | Vermont | 50003 | 3899 | 32 |
1943005 | 1943005 | 2021-11-22 | Bennington | Vermont | 50003 | 3892 | 32 |
1939755 | 1939755 | 2021-11-21 | Bennington | Vermont | 50003 | 3873 | 32 |
1936505 | 1936505 | 2021-11-20 | Bennington | Vermont | 50003 | 3842 | 32 |
1933255 | 1933255 | 2021-11-19 | Bennington | Vermont | 50003 | 3803 | 31 |
1930004 | 1930004 | 2021-11-18 | Bennington | Vermont | 50003 | 3745 | 31 |
1926754 | 1926754 | 2021-11-17 | Bennington | Vermont | 50003 | 3700 | 31 |
1923504 | 1923504 | 2021-11-16 | Bennington | Vermont | 50003 | 3655 | 31 |
1920255 | 1920255 | 2021-11-15 | Bennington | Vermont | 50003 | 3645 | 30 |
1917005 | 1917005 | 2021-11-14 | Bennington | Vermont | 50003 | 3640 | 30 |
1913755 | 1913755 | 2021-11-13 | Bennington | Vermont | 50003 | 3618 | 30 |
1910505 | 1910505 | 2021-11-12 | Bennington | Vermont | 50003 | 3586 | 30 |
1907256 | 1907256 | 2021-11-11 | Bennington | Vermont | 50003 | 3546 | 30 |
1904007 | 1904007 | 2021-11-10 | Bennington | Vermont | 50003 | 3494 | 29 |
1900757 | 1900757 | 2021-11-09 | Bennington | Vermont | 50003 | 3447 | 28 |
1897507 | 1897507 | 2021-11-08 | Bennington | Vermont | 50003 | 3433 | 27 |
1894257 | 1894257 | 2021-11-07 | Bennington | Vermont | 50003 | 3419 | 27 |
1891007 | 1891007 | 2021-11-06 | Bennington | Vermont | 50003 | 3394 | 27 |
1887757 | 1887757 | 2021-11-05 | Bennington | Vermont | 50003 | 3336 | 27 |
1884507 | 1884507 | 2021-11-04 | Bennington | Vermont | 50003 | 3300 | 27 |
1881258 | 1881258 | 2021-11-03 | Bennington | Vermont | 50003 | 3243 | 26 |
1878009 | 1878009 | 2021-11-02 | Bennington | Vermont | 50003 | 3201 | 26 |
1874760 | 1874760 | 2021-11-01 | Bennington | Vermont | 50003 | 3190 | 26 |
1871511 | 1871511 | 2021-10-31 | Bennington | Vermont | 50003 | 3186 | 26 |
1868262 | 1868262 | 2021-10-30 | Bennington | Vermont | 50003 | 3164 | 26 |
1865013 | 1865013 | 2021-10-29 | Bennington | Vermont | 50003 | 3154 | 26 |
1861764 | 1861764 | 2021-10-28 | Bennington | Vermont | 50003 | 3136 | 26 |
1858515 | 1858515 | 2021-10-27 | Bennington | Vermont | 50003 | 3127 | 26 |
1855266 | 1855266 | 2021-10-26 | Bennington | Vermont | 50003 | 3092 | 26 |
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);