ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 50017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177115 | 2177115 | 2022-02-02 | Orange | Vermont | 50017 | 3053 | 11 |
2173862 | 2173862 | 2022-02-01 | Orange | Vermont | 50017 | 3046 | 11 |
2170610 | 2170610 | 2022-01-31 | Orange | Vermont | 50017 | 3034 | 10 |
2167356 | 2167356 | 2022-01-30 | Orange | Vermont | 50017 | 3034 | 10 |
2164101 | 2164101 | 2022-01-29 | Orange | Vermont | 50017 | 3023 | 10 |
2160846 | 2160846 | 2022-01-28 | Orange | Vermont | 50017 | 3009 | 10 |
2157590 | 2157590 | 2022-01-27 | Orange | Vermont | 50017 | 2989 | 10 |
2154337 | 2154337 | 2022-01-26 | Orange | Vermont | 50017 | 2965 | 10 |
2151085 | 2151085 | 2022-01-25 | Orange | Vermont | 50017 | 2920 | 10 |
2147833 | 2147833 | 2022-01-24 | Orange | Vermont | 50017 | 2873 | 10 |
2144579 | 2144579 | 2022-01-23 | Orange | Vermont | 50017 | 2833 | 10 |
2141324 | 2141324 | 2022-01-22 | Orange | Vermont | 50017 | 2772 | 10 |
2138068 | 2138068 | 2022-01-21 | Orange | Vermont | 50017 | 2727 | 10 |
2134814 | 2134814 | 2022-01-20 | Orange | Vermont | 50017 | 2678 | 10 |
2131562 | 2131562 | 2022-01-19 | Orange | Vermont | 50017 | 2678 | 10 |
2128308 | 2128308 | 2022-01-18 | Orange | Vermont | 50017 | 2640 | 10 |
2125056 | 2125056 | 2022-01-17 | Orange | Vermont | 50017 | 2591 | 10 |
2121804 | 2121804 | 2022-01-16 | Orange | Vermont | 50017 | 2591 | 10 |
2118552 | 2118552 | 2022-01-15 | Orange | Vermont | 50017 | 2557 | 10 |
2115300 | 2115300 | 2022-01-14 | Orange | Vermont | 50017 | 2544 | 9 |
2112048 | 2112048 | 2022-01-13 | Orange | Vermont | 50017 | 2506 | 9 |
2108796 | 2108796 | 2022-01-12 | Orange | Vermont | 50017 | 2433 | 9 |
2105545 | 2105545 | 2022-01-11 | Orange | Vermont | 50017 | 2331 | 9 |
2102294 | 2102294 | 2022-01-10 | Orange | Vermont | 50017 | 2331 | 9 |
2099043 | 2099043 | 2022-01-09 | Orange | Vermont | 50017 | 2331 | 9 |
2095791 | 2095791 | 2022-01-08 | Orange | Vermont | 50017 | 2321 | 9 |
2092539 | 2092539 | 2022-01-07 | Orange | Vermont | 50017 | 2295 | 9 |
2089287 | 2089287 | 2022-01-06 | Orange | Vermont | 50017 | 2271 | 9 |
2086036 | 2086036 | 2022-01-05 | Orange | Vermont | 50017 | 2231 | 9 |
2082784 | 2082784 | 2022-01-04 | Orange | Vermont | 50017 | 2214 | 9 |
2079532 | 2079532 | 2022-01-03 | Orange | Vermont | 50017 | 2203 | 9 |
2076281 | 2076281 | 2022-01-02 | Orange | Vermont | 50017 | 2132 | 9 |
2073030 | 2073030 | 2022-01-01 | Orange | Vermont | 50017 | 2132 | 9 |
2069779 | 2069779 | 2021-12-31 | Orange | Vermont | 50017 | 2132 | 9 |
2066528 | 2066528 | 2021-12-30 | Orange | Vermont | 50017 | 2132 | 9 |
2063278 | 2063278 | 2021-12-29 | Orange | Vermont | 50017 | 2097 | 9 |
2060028 | 2060028 | 2021-12-28 | Orange | Vermont | 50017 | 2083 | 9 |
2056779 | 2056779 | 2021-12-27 | Orange | Vermont | 50017 | 2078 | 9 |
2053530 | 2053530 | 2021-12-26 | Orange | Vermont | 50017 | 2051 | 9 |
2050280 | 2050280 | 2021-12-25 | Orange | Vermont | 50017 | 2051 | 9 |
2047030 | 2047030 | 2021-12-24 | Orange | Vermont | 50017 | 2051 | 9 |
2043780 | 2043780 | 2021-12-23 | Orange | Vermont | 50017 | 2051 | 9 |
2040531 | 2040531 | 2021-12-22 | Orange | Vermont | 50017 | 2031 | 9 |
2037281 | 2037281 | 2021-12-21 | Orange | Vermont | 50017 | 2023 | 9 |
2034031 | 2034031 | 2021-12-20 | Orange | Vermont | 50017 | 2016 | 9 |
2030781 | 2030781 | 2021-12-19 | Orange | Vermont | 50017 | 2011 | 9 |
2027530 | 2027530 | 2021-12-18 | Orange | Vermont | 50017 | 1990 | 9 |
2024279 | 2024279 | 2021-12-17 | Orange | Vermont | 50017 | 1978 | 9 |
2021028 | 2021028 | 2021-12-16 | Orange | Vermont | 50017 | 1967 | 9 |
2017777 | 2017777 | 2021-12-15 | Orange | Vermont | 50017 | 1941 | 8 |
2014527 | 2014527 | 2021-12-14 | Orange | Vermont | 50017 | 1932 | 8 |
2011276 | 2011276 | 2021-12-13 | Orange | Vermont | 50017 | 1926 | 8 |
2008025 | 2008025 | 2021-12-12 | Orange | Vermont | 50017 | 1914 | 8 |
2004774 | 2004774 | 2021-12-11 | Orange | Vermont | 50017 | 1902 | 8 |
2001523 | 2001523 | 2021-12-10 | Orange | Vermont | 50017 | 1896 | 8 |
1998273 | 1998273 | 2021-12-09 | Orange | Vermont | 50017 | 1877 | 7 |
1995022 | 1995022 | 2021-12-08 | Orange | Vermont | 50017 | 1858 | 7 |
1991771 | 1991771 | 2021-12-07 | Orange | Vermont | 50017 | 1855 | 7 |
1988520 | 1988520 | 2021-12-06 | Orange | Vermont | 50017 | 1844 | 7 |
1985270 | 1985270 | 2021-12-05 | Orange | Vermont | 50017 | 1830 | 7 |
1982020 | 1982020 | 2021-12-04 | Orange | Vermont | 50017 | 1809 | 7 |
1978770 | 1978770 | 2021-12-03 | Orange | Vermont | 50017 | 1788 | 7 |
1975520 | 1975520 | 2021-12-02 | Orange | Vermont | 50017 | 1769 | 7 |
1972271 | 1972271 | 2021-12-01 | Orange | Vermont | 50017 | 1754 | 7 |
1969021 | 1969021 | 2021-11-30 | Orange | Vermont | 50017 | 1741 | 7 |
1965770 | 1965770 | 2021-11-29 | Orange | Vermont | 50017 | 1727 | 7 |
1962518 | 1962518 | 2021-11-28 | Orange | Vermont | 50017 | 1682 | 6 |
1959267 | 1959267 | 2021-11-27 | Orange | Vermont | 50017 | 1682 | 6 |
1956016 | 1956016 | 2021-11-26 | Orange | Vermont | 50017 | 1682 | 6 |
1952765 | 1952765 | 2021-11-25 | Orange | Vermont | 50017 | 1682 | 6 |
1949514 | 1949514 | 2021-11-24 | Orange | Vermont | 50017 | 1682 | 6 |
1946263 | 1946263 | 2021-11-23 | Orange | Vermont | 50017 | 1674 | 6 |
1943012 | 1943012 | 2021-11-22 | Orange | Vermont | 50017 | 1669 | 6 |
1939762 | 1939762 | 2021-11-21 | Orange | Vermont | 50017 | 1662 | 6 |
1936512 | 1936512 | 2021-11-20 | Orange | Vermont | 50017 | 1651 | 6 |
1933262 | 1933262 | 2021-11-19 | Orange | Vermont | 50017 | 1634 | 6 |
1930011 | 1930011 | 2021-11-18 | Orange | Vermont | 50017 | 1618 | 6 |
1926761 | 1926761 | 2021-11-17 | Orange | Vermont | 50017 | 1602 | 6 |
1923511 | 1923511 | 2021-11-16 | Orange | Vermont | 50017 | 1595 | 6 |
1920262 | 1920262 | 2021-11-15 | Orange | Vermont | 50017 | 1587 | 6 |
1917012 | 1917012 | 2021-11-14 | Orange | Vermont | 50017 | 1584 | 6 |
1913762 | 1913762 | 2021-11-13 | Orange | Vermont | 50017 | 1567 | 6 |
1910512 | 1910512 | 2021-11-12 | Orange | Vermont | 50017 | 1543 | 6 |
1907263 | 1907263 | 2021-11-11 | Orange | Vermont | 50017 | 1528 | 6 |
1904014 | 1904014 | 2021-11-10 | Orange | Vermont | 50017 | 1508 | 6 |
1900764 | 1900764 | 2021-11-09 | Orange | Vermont | 50017 | 1497 | 6 |
1897514 | 1897514 | 2021-11-08 | Orange | Vermont | 50017 | 1493 | 5 |
1894264 | 1894264 | 2021-11-07 | Orange | Vermont | 50017 | 1475 | 5 |
1891014 | 1891014 | 2021-11-06 | Orange | Vermont | 50017 | 1460 | 5 |
1887764 | 1887764 | 2021-11-05 | Orange | Vermont | 50017 | 1451 | 5 |
1884514 | 1884514 | 2021-11-04 | Orange | Vermont | 50017 | 1434 | 5 |
1881265 | 1881265 | 2021-11-03 | Orange | Vermont | 50017 | 1405 | 5 |
1878016 | 1878016 | 2021-11-02 | Orange | Vermont | 50017 | 1384 | 5 |
1874767 | 1874767 | 2021-11-01 | Orange | Vermont | 50017 | 1380 | 5 |
1871518 | 1871518 | 2021-10-31 | Orange | Vermont | 50017 | 1374 | 5 |
1868269 | 1868269 | 2021-10-30 | Orange | Vermont | 50017 | 1355 | 5 |
1865020 | 1865020 | 2021-10-29 | Orange | Vermont | 50017 | 1347 | 5 |
1861771 | 1861771 | 2021-10-28 | Orange | Vermont | 50017 | 1325 | 5 |
1858522 | 1858522 | 2021-10-27 | Orange | Vermont | 50017 | 1318 | 5 |
1855273 | 1855273 | 2021-10-26 | Orange | Vermont | 50017 | 1312 | 5 |
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);