ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 36069 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 |
---|---|---|---|---|---|---|---|
2111010 | 2111010 | 2022-01-13 | Ontario | New York | 36069 | 16385 | 154 |
2107758 | 2107758 | 2022-01-12 | Ontario | New York | 36069 | 16175 | 153 |
2104507 | 2104507 | 2022-01-11 | Ontario | New York | 36069 | 15964 | 152 |
2101256 | 2101256 | 2022-01-10 | Ontario | New York | 36069 | 15823 | 150 |
2098005 | 2098005 | 2022-01-09 | Ontario | New York | 36069 | 15707 | 149 |
2094753 | 2094753 | 2022-01-08 | Ontario | New York | 36069 | 15483 | 148 |
2091501 | 2091501 | 2022-01-07 | Ontario | New York | 36069 | 15226 | 146 |
2088250 | 2088250 | 2022-01-06 | Ontario | New York | 36069 | 15005 | 146 |
2084998 | 2084998 | 2022-01-05 | Ontario | New York | 36069 | 14795 | 146 |
2081746 | 2081746 | 2022-01-04 | Ontario | New York | 36069 | 14592 | 146 |
2078494 | 2078494 | 2022-01-03 | Ontario | New York | 36069 | 14509 | 146 |
2075243 | 2075243 | 2022-01-02 | Ontario | New York | 36069 | 14386 | 145 |
2071992 | 2071992 | 2022-01-01 | Ontario | New York | 36069 | 14302 | 144 |
2068741 | 2068741 | 2021-12-31 | Ontario | New York | 36069 | 14122 | 144 |
2065490 | 2065490 | 2021-12-30 | Ontario | New York | 36069 | 13970 | 142 |
2062240 | 2062240 | 2021-12-29 | Ontario | New York | 36069 | 13834 | 142 |
2058991 | 2058991 | 2021-12-28 | Ontario | New York | 36069 | 13675 | 141 |
2055742 | 2055742 | 2021-12-27 | Ontario | New York | 36069 | 13640 | 140 |
2052492 | 2052492 | 2021-12-26 | Ontario | New York | 36069 | 13619 | 139 |
2049242 | 2049242 | 2021-12-25 | Ontario | New York | 36069 | 13540 | 139 |
2045992 | 2045992 | 2021-12-24 | Ontario | New York | 36069 | 13540 | 139 |
2042742 | 2042742 | 2021-12-23 | Ontario | New York | 36069 | 13463 | 138 |
2039493 | 2039493 | 2021-12-22 | Ontario | New York | 36069 | 13383 | 137 |
2036243 | 2036243 | 2021-12-21 | Ontario | New York | 36069 | 13310 | 137 |
2032993 | 2032993 | 2021-12-20 | Ontario | New York | 36069 | 13247 | 135 |
2029743 | 2029743 | 2021-12-19 | Ontario | New York | 36069 | 13203 | 134 |
2026492 | 2026492 | 2021-12-18 | Ontario | New York | 36069 | 13136 | 133 |
2023241 | 2023241 | 2021-12-17 | Ontario | New York | 36069 | 13037 | 132 |
2019990 | 2019990 | 2021-12-16 | Ontario | New York | 36069 | 12959 | 129 |
2016739 | 2016739 | 2021-12-15 | Ontario | New York | 36069 | 12878 | 128 |
2013489 | 2013489 | 2021-12-14 | Ontario | New York | 36069 | 12814 | 126 |
2010238 | 2010238 | 2021-12-13 | Ontario | New York | 36069 | 12770 | 126 |
2006987 | 2006987 | 2021-12-12 | Ontario | New York | 36069 | 12720 | 126 |
2003736 | 2003736 | 2021-12-11 | Ontario | New York | 36069 | 12647 | 123 |
2000485 | 2000485 | 2021-12-10 | Ontario | New York | 36069 | 12561 | 121 |
1997235 | 1997235 | 2021-12-09 | Ontario | New York | 36069 | 12485 | 121 |
1993984 | 1993984 | 2021-12-08 | Ontario | New York | 36069 | 12377 | 121 |
1990733 | 1990733 | 2021-12-07 | Ontario | New York | 36069 | 12310 | 121 |
1987482 | 1987482 | 2021-12-06 | Ontario | New York | 36069 | 12223 | 121 |
1984232 | 1984232 | 2021-12-05 | Ontario | New York | 36069 | 12164 | 121 |
1980982 | 1980982 | 2021-12-04 | Ontario | New York | 36069 | 12079 | 121 |
1977732 | 1977732 | 2021-12-03 | Ontario | New York | 36069 | 11974 | 121 |
1974482 | 1974482 | 2021-12-02 | Ontario | New York | 36069 | 11866 | 119 |
1971233 | 1971233 | 2021-12-01 | Ontario | New York | 36069 | 11776 | 119 |
1967983 | 1967983 | 2021-11-30 | Ontario | New York | 36069 | 11683 | 119 |
1964732 | 1964732 | 2021-11-29 | Ontario | New York | 36069 | 11631 | 119 |
1961480 | 1961480 | 2021-11-28 | Ontario | New York | 36069 | 11592 | 119 |
1958229 | 1958229 | 2021-11-27 | Ontario | New York | 36069 | 11552 | 119 |
1954978 | 1954978 | 2021-11-26 | Ontario | New York | 36069 | 11499 | 118 |
1951727 | 1951727 | 2021-11-25 | Ontario | New York | 36069 | 11437 | 118 |
1948476 | 1948476 | 2021-11-24 | Ontario | New York | 36069 | 11364 | 118 |
1945225 | 1945225 | 2021-11-23 | Ontario | New York | 36069 | 11292 | 117 |
1941974 | 1941974 | 2021-11-22 | Ontario | New York | 36069 | 11219 | 116 |
1938724 | 1938724 | 2021-11-21 | Ontario | New York | 36069 | 11170 | 116 |
1935474 | 1935474 | 2021-11-20 | Ontario | New York | 36069 | 11094 | 114 |
1932224 | 1932224 | 2021-11-19 | Ontario | New York | 36069 | 11018 | 114 |
1928973 | 1928973 | 2021-11-18 | Ontario | New York | 36069 | 10927 | 114 |
1925723 | 1925723 | 2021-11-17 | Ontario | New York | 36069 | 10818 | 114 |
1922474 | 1922474 | 2021-11-16 | Ontario | New York | 36069 | 10741 | 114 |
1919224 | 1919224 | 2021-11-15 | Ontario | New York | 36069 | 10669 | 113 |
1915974 | 1915974 | 2021-11-14 | Ontario | New York | 36069 | 10587 | 113 |
1912724 | 1912724 | 2021-11-13 | Ontario | New York | 36069 | 10501 | 113 |
1909474 | 1909474 | 2021-11-12 | Ontario | New York | 36069 | 10416 | 112 |
1906225 | 1906225 | 2021-11-11 | Ontario | New York | 36069 | 10342 | 112 |
1902976 | 1902976 | 2021-11-10 | Ontario | New York | 36069 | 10258 | 111 |
1899726 | 1899726 | 2021-11-09 | Ontario | New York | 36069 | 10185 | 111 |
1896476 | 1896476 | 2021-11-08 | Ontario | New York | 36069 | 10114 | 111 |
1893226 | 1893226 | 2021-11-07 | Ontario | New York | 36069 | 10065 | 111 |
1889976 | 1889976 | 2021-11-06 | Ontario | New York | 36069 | 10004 | 111 |
1886726 | 1886726 | 2021-11-05 | Ontario | New York | 36069 | 9944 | 111 |
1883477 | 1883477 | 2021-11-04 | Ontario | New York | 36069 | 9891 | 111 |
1880228 | 1880228 | 2021-11-03 | Ontario | New York | 36069 | 9829 | 111 |
1876979 | 1876979 | 2021-11-02 | Ontario | New York | 36069 | 9754 | 111 |
1873730 | 1873730 | 2021-11-01 | Ontario | New York | 36069 | 9722 | 111 |
1870481 | 1870481 | 2021-10-31 | Ontario | New York | 36069 | 9677 | 111 |
1867232 | 1867232 | 2021-10-30 | Ontario | New York | 36069 | 9627 | 111 |
1863983 | 1863983 | 2021-10-29 | Ontario | New York | 36069 | 9598 | 111 |
1860734 | 1860734 | 2021-10-28 | Ontario | New York | 36069 | 9553 | 111 |
1857485 | 1857485 | 2021-10-27 | Ontario | New York | 36069 | 9520 | 111 |
1854236 | 1854236 | 2021-10-26 | Ontario | New York | 36069 | 9480 | 111 |
1850987 | 1850987 | 2021-10-25 | Ontario | New York | 36069 | 9467 | 111 |
1847737 | 1847737 | 2021-10-24 | Ontario | New York | 36069 | 9436 | 110 |
1844487 | 1844487 | 2021-10-23 | Ontario | New York | 36069 | 9423 | 110 |
1841237 | 1841237 | 2021-10-22 | Ontario | New York | 36069 | 9378 | 110 |
1837988 | 1837988 | 2021-10-21 | Ontario | New York | 36069 | 9352 | 110 |
1834739 | 1834739 | 2021-10-20 | Ontario | New York | 36069 | 9321 | 110 |
1831490 | 1831490 | 2021-10-19 | Ontario | New York | 36069 | 9296 | 110 |
1828241 | 1828241 | 2021-10-18 | Ontario | New York | 36069 | 9278 | 110 |
1824992 | 1824992 | 2021-10-17 | Ontario | New York | 36069 | 9244 | 110 |
1821743 | 1821743 | 2021-10-16 | Ontario | New York | 36069 | 9224 | 110 |
1818494 | 1818494 | 2021-10-15 | Ontario | New York | 36069 | 9183 | 110 |
1815245 | 1815245 | 2021-10-14 | Ontario | New York | 36069 | 9124 | 110 |
1811997 | 1811997 | 2021-10-13 | Ontario | New York | 36069 | 9104 | 108 |
1808748 | 1808748 | 2021-10-12 | Ontario | New York | 36069 | 9080 | 107 |
1805497 | 1805497 | 2021-10-11 | Ontario | New York | 36069 | 9064 | 105 |
1802248 | 1802248 | 2021-10-10 | Ontario | New York | 36069 | 9033 | 105 |
1798999 | 1798999 | 2021-10-09 | Ontario | New York | 36069 | 9012 | 104 |
1795750 | 1795750 | 2021-10-08 | Ontario | New York | 36069 | 8993 | 103 |
1792501 | 1792501 | 2021-10-07 | Ontario | New York | 36069 | 8973 | 103 |
1789252 | 1789252 | 2021-10-06 | Ontario | New York | 36069 | 8943 | 102 |
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);