ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36121 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111034 | 2111034 | 2022-01-13 | Wyoming | New York | 36121 | 7168 | 75 |
2107782 | 2107782 | 2022-01-12 | Wyoming | New York | 36121 | 7081 | 75 |
2104531 | 2104531 | 2022-01-11 | Wyoming | New York | 36121 | 6993 | 75 |
2101280 | 2101280 | 2022-01-10 | Wyoming | New York | 36121 | 6927 | 75 |
2098029 | 2098029 | 2022-01-09 | Wyoming | New York | 36121 | 6885 | 75 |
2094777 | 2094777 | 2022-01-08 | Wyoming | New York | 36121 | 6786 | 74 |
2091525 | 2091525 | 2022-01-07 | Wyoming | New York | 36121 | 6675 | 74 |
2088274 | 2088274 | 2022-01-06 | Wyoming | New York | 36121 | 6596 | 74 |
2085022 | 2085022 | 2022-01-05 | Wyoming | New York | 36121 | 6503 | 74 |
2081770 | 2081770 | 2022-01-04 | Wyoming | New York | 36121 | 6422 | 74 |
2078518 | 2078518 | 2022-01-03 | Wyoming | New York | 36121 | 6369 | 74 |
2075267 | 2075267 | 2022-01-02 | Wyoming | New York | 36121 | 6345 | 74 |
2072016 | 2072016 | 2022-01-01 | Wyoming | New York | 36121 | 6310 | 74 |
2068765 | 2068765 | 2021-12-31 | Wyoming | New York | 36121 | 6254 | 74 |
2065514 | 2065514 | 2021-12-30 | Wyoming | New York | 36121 | 6198 | 74 |
2062264 | 2062264 | 2021-12-29 | Wyoming | New York | 36121 | 6166 | 74 |
2059015 | 2059015 | 2021-12-28 | Wyoming | New York | 36121 | 6109 | 74 |
2055766 | 2055766 | 2021-12-27 | Wyoming | New York | 36121 | 6092 | 74 |
2052516 | 2052516 | 2021-12-26 | Wyoming | New York | 36121 | 6088 | 73 |
2049266 | 2049266 | 2021-12-25 | Wyoming | New York | 36121 | 6072 | 73 |
2046016 | 2046016 | 2021-12-24 | Wyoming | New York | 36121 | 6072 | 73 |
2042766 | 2042766 | 2021-12-23 | Wyoming | New York | 36121 | 6041 | 73 |
2039517 | 2039517 | 2021-12-22 | Wyoming | New York | 36121 | 5994 | 73 |
2036267 | 2036267 | 2021-12-21 | Wyoming | New York | 36121 | 5967 | 73 |
2033017 | 2033017 | 2021-12-20 | Wyoming | New York | 36121 | 5945 | 72 |
2029767 | 2029767 | 2021-12-19 | Wyoming | New York | 36121 | 5936 | 72 |
2026516 | 2026516 | 2021-12-18 | Wyoming | New York | 36121 | 5903 | 72 |
2023265 | 2023265 | 2021-12-17 | Wyoming | New York | 36121 | 5875 | 72 |
2020014 | 2020014 | 2021-12-16 | Wyoming | New York | 36121 | 5844 | 72 |
2016763 | 2016763 | 2021-12-15 | Wyoming | New York | 36121 | 5825 | 72 |
2013513 | 2013513 | 2021-12-14 | Wyoming | New York | 36121 | 5791 | 71 |
2010262 | 2010262 | 2021-12-13 | Wyoming | New York | 36121 | 5772 | 71 |
2007011 | 2007011 | 2021-12-12 | Wyoming | New York | 36121 | 5757 | 71 |
2003760 | 2003760 | 2021-12-11 | Wyoming | New York | 36121 | 5741 | 71 |
2000509 | 2000509 | 2021-12-10 | Wyoming | New York | 36121 | 5723 | 71 |
1997259 | 1997259 | 2021-12-09 | Wyoming | New York | 36121 | 5690 | 71 |
1994008 | 1994008 | 2021-12-08 | Wyoming | New York | 36121 | 5628 | 71 |
1990757 | 1990757 | 2021-12-07 | Wyoming | New York | 36121 | 5583 | 70 |
1987506 | 1987506 | 2021-12-06 | Wyoming | New York | 36121 | 5566 | 70 |
1984256 | 1984256 | 2021-12-05 | Wyoming | New York | 36121 | 5548 | 69 |
1981006 | 1981006 | 2021-12-04 | Wyoming | New York | 36121 | 5515 | 69 |
1977756 | 1977756 | 2021-12-03 | Wyoming | New York | 36121 | 5463 | 67 |
1974506 | 1974506 | 2021-12-02 | Wyoming | New York | 36121 | 5403 | 67 |
1971257 | 1971257 | 2021-12-01 | Wyoming | New York | 36121 | 5356 | 67 |
1968007 | 1968007 | 2021-11-30 | Wyoming | New York | 36121 | 5302 | 66 |
1964756 | 1964756 | 2021-11-29 | Wyoming | New York | 36121 | 5278 | 66 |
1961504 | 1961504 | 2021-11-28 | Wyoming | New York | 36121 | 5252 | 65 |
1958253 | 1958253 | 2021-11-27 | Wyoming | New York | 36121 | 5229 | 64 |
1955002 | 1955002 | 2021-11-26 | Wyoming | New York | 36121 | 5199 | 64 |
1951751 | 1951751 | 2021-11-25 | Wyoming | New York | 36121 | 5166 | 64 |
1948500 | 1948500 | 2021-11-24 | Wyoming | New York | 36121 | 5123 | 64 |
1945249 | 1945249 | 2021-11-23 | Wyoming | New York | 36121 | 5076 | 63 |
1941998 | 1941998 | 2021-11-22 | Wyoming | New York | 36121 | 5055 | 63 |
1938748 | 1938748 | 2021-11-21 | Wyoming | New York | 36121 | 5039 | 63 |
1935498 | 1935498 | 2021-11-20 | Wyoming | New York | 36121 | 5007 | 63 |
1932248 | 1932248 | 2021-11-19 | Wyoming | New York | 36121 | 4964 | 63 |
1928997 | 1928997 | 2021-11-18 | Wyoming | New York | 36121 | 4929 | 63 |
1925747 | 1925747 | 2021-11-17 | Wyoming | New York | 36121 | 4886 | 62 |
1922498 | 1922498 | 2021-11-16 | Wyoming | New York | 36121 | 4858 | 62 |
1919248 | 1919248 | 2021-11-15 | Wyoming | New York | 36121 | 4843 | 62 |
1915998 | 1915998 | 2021-11-14 | Wyoming | New York | 36121 | 4823 | 62 |
1912748 | 1912748 | 2021-11-13 | Wyoming | New York | 36121 | 4793 | 62 |
1909498 | 1909498 | 2021-11-12 | Wyoming | New York | 36121 | 4763 | 62 |
1906249 | 1906249 | 2021-11-11 | Wyoming | New York | 36121 | 4742 | 62 |
1903000 | 1903000 | 2021-11-10 | Wyoming | New York | 36121 | 4710 | 62 |
1899750 | 1899750 | 2021-11-09 | Wyoming | New York | 36121 | 4690 | 60 |
1896500 | 1896500 | 2021-11-08 | Wyoming | New York | 36121 | 4676 | 59 |
1893250 | 1893250 | 2021-11-07 | Wyoming | New York | 36121 | 4665 | 59 |
1890000 | 1890000 | 2021-11-06 | Wyoming | New York | 36121 | 4641 | 59 |
1886750 | 1886750 | 2021-11-05 | Wyoming | New York | 36121 | 4622 | 59 |
1883501 | 1883501 | 2021-11-04 | Wyoming | New York | 36121 | 4598 | 59 |
1880252 | 1880252 | 2021-11-03 | Wyoming | New York | 36121 | 4568 | 59 |
1877003 | 1877003 | 2021-11-02 | Wyoming | New York | 36121 | 4531 | 59 |
1873754 | 1873754 | 2021-11-01 | Wyoming | New York | 36121 | 4513 | 59 |
1870505 | 1870505 | 2021-10-31 | Wyoming | New York | 36121 | 4504 | 59 |
1867256 | 1867256 | 2021-10-30 | Wyoming | New York | 36121 | 4488 | 59 |
1864007 | 1864007 | 2021-10-29 | Wyoming | New York | 36121 | 4478 | 59 |
1860758 | 1860758 | 2021-10-28 | Wyoming | New York | 36121 | 4461 | 58 |
1857509 | 1857509 | 2021-10-27 | Wyoming | New York | 36121 | 4447 | 58 |
1854260 | 1854260 | 2021-10-26 | Wyoming | New York | 36121 | 4436 | 58 |
1851011 | 1851011 | 2021-10-25 | Wyoming | New York | 36121 | 4434 | 58 |
1847761 | 1847761 | 2021-10-24 | Wyoming | New York | 36121 | 4428 | 58 |
1844511 | 1844511 | 2021-10-23 | Wyoming | New York | 36121 | 4418 | 58 |
1841261 | 1841261 | 2021-10-22 | Wyoming | New York | 36121 | 4407 | 58 |
1838012 | 1838012 | 2021-10-21 | Wyoming | New York | 36121 | 4393 | 58 |
1834763 | 1834763 | 2021-10-20 | Wyoming | New York | 36121 | 4371 | 58 |
1831514 | 1831514 | 2021-10-19 | Wyoming | New York | 36121 | 4349 | 58 |
1828265 | 1828265 | 2021-10-18 | Wyoming | New York | 36121 | 4344 | 58 |
1825016 | 1825016 | 2021-10-17 | Wyoming | New York | 36121 | 4336 | 57 |
1821767 | 1821767 | 2021-10-16 | Wyoming | New York | 36121 | 4326 | 57 |
1818518 | 1818518 | 2021-10-15 | Wyoming | New York | 36121 | 4309 | 57 |
1815269 | 1815269 | 2021-10-14 | Wyoming | New York | 36121 | 4292 | 57 |
1812021 | 1812021 | 2021-10-13 | Wyoming | New York | 36121 | 4276 | 57 |
1808772 | 1808772 | 2021-10-12 | Wyoming | New York | 36121 | 4252 | 56 |
1805521 | 1805521 | 2021-10-11 | Wyoming | New York | 36121 | 4240 | 56 |
1802272 | 1802272 | 2021-10-10 | Wyoming | New York | 36121 | 4217 | 55 |
1799023 | 1799023 | 2021-10-09 | Wyoming | New York | 36121 | 4199 | 55 |
1795774 | 1795774 | 2021-10-08 | Wyoming | New York | 36121 | 4178 | 55 |
1792525 | 1792525 | 2021-10-07 | Wyoming | New York | 36121 | 4153 | 55 |
1789276 | 1789276 | 2021-10-06 | Wyoming | New York | 36121 | 4127 | 55 |
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);