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 |
---|---|---|---|---|---|---|---|
2176076 | 2176076 | 2022-02-02 | Ontario | New York | 36069 | 18688 | 166 |
2172823 | 2172823 | 2022-02-01 | Ontario | New York | 36069 | 18622 | 166 |
2169570 | 2169570 | 2022-01-31 | Ontario | New York | 36069 | 18574 | 166 |
2166315 | 2166315 | 2022-01-30 | Ontario | New York | 36069 | 18539 | 166 |
2163060 | 2163060 | 2022-01-29 | Ontario | New York | 36069 | 18440 | 166 |
2159805 | 2159805 | 2022-01-28 | Ontario | New York | 36069 | 18353 | 165 |
2156550 | 2156550 | 2022-01-27 | Ontario | New York | 36069 | 18261 | 164 |
2153297 | 2153297 | 2022-01-26 | Ontario | New York | 36069 | 18129 | 164 |
2150045 | 2150045 | 2022-01-25 | Ontario | New York | 36069 | 18030 | 163 |
2146793 | 2146793 | 2022-01-24 | Ontario | New York | 36069 | 17979 | 162 |
2143539 | 2143539 | 2022-01-23 | Ontario | New York | 36069 | 17900 | 162 |
2140284 | 2140284 | 2022-01-22 | Ontario | New York | 36069 | 17784 | 162 |
2137028 | 2137028 | 2022-01-21 | Ontario | New York | 36069 | 17637 | 161 |
2133775 | 2133775 | 2022-01-20 | Ontario | New York | 36069 | 17442 | 161 |
2130523 | 2130523 | 2022-01-19 | Ontario | New York | 36069 | 17284 | 159 |
2127269 | 2127269 | 2022-01-18 | Ontario | New York | 36069 | 17197 | 158 |
2124017 | 2124017 | 2022-01-17 | Ontario | New York | 36069 | 17089 | 157 |
2120765 | 2120765 | 2022-01-16 | Ontario | New York | 36069 | 16999 | 157 |
2117513 | 2117513 | 2022-01-15 | Ontario | New York | 36069 | 16805 | 156 |
2114262 | 2114262 | 2022-01-14 | Ontario | New York | 36069 | 16644 | 154 |
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 |
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);