ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Rensselaer" 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 |
---|---|---|---|---|---|---|---|
2111016 | 2111016 | 2022-01-13 | Rensselaer | New York | 36083 | 25800 | 226 |
2107764 | 2107764 | 2022-01-12 | Rensselaer | New York | 36083 | 25358 | 224 |
2104513 | 2104513 | 2022-01-11 | Rensselaer | New York | 36083 | 25022 | 223 |
2101262 | 2101262 | 2022-01-10 | Rensselaer | New York | 36083 | 24707 | 222 |
2098011 | 2098011 | 2022-01-09 | Rensselaer | New York | 36083 | 24329 | 221 |
2094759 | 2094759 | 2022-01-08 | Rensselaer | New York | 36083 | 23915 | 219 |
2091507 | 2091507 | 2022-01-07 | Rensselaer | New York | 36083 | 23354 | 219 |
2088256 | 2088256 | 2022-01-06 | Rensselaer | New York | 36083 | 22852 | 218 |
2085004 | 2085004 | 2022-01-05 | Rensselaer | New York | 36083 | 22423 | 218 |
2081752 | 2081752 | 2022-01-04 | Rensselaer | New York | 36083 | 22025 | 217 |
2078500 | 2078500 | 2022-01-03 | Rensselaer | New York | 36083 | 21915 | 216 |
2075249 | 2075249 | 2022-01-02 | Rensselaer | New York | 36083 | 21708 | 215 |
2071998 | 2071998 | 2022-01-01 | Rensselaer | New York | 36083 | 21441 | 215 |
2068747 | 2068747 | 2021-12-31 | Rensselaer | New York | 36083 | 21133 | 213 |
2065496 | 2065496 | 2021-12-30 | Rensselaer | New York | 36083 | 20809 | 213 |
2062246 | 2062246 | 2021-12-29 | Rensselaer | New York | 36083 | 20635 | 212 |
2058997 | 2058997 | 2021-12-28 | Rensselaer | New York | 36083 | 20431 | 209 |
2055748 | 2055748 | 2021-12-27 | Rensselaer | New York | 36083 | 20307 | 208 |
2052498 | 2052498 | 2021-12-26 | Rensselaer | New York | 36083 | 20247 | 208 |
2049248 | 2049248 | 2021-12-25 | Rensselaer | New York | 36083 | 20014 | 208 |
2045998 | 2045998 | 2021-12-24 | Rensselaer | New York | 36083 | 20014 | 208 |
2042748 | 2042748 | 2021-12-23 | Rensselaer | New York | 36083 | 19880 | 208 |
2039499 | 2039499 | 2021-12-22 | Rensselaer | New York | 36083 | 19737 | 208 |
2036249 | 2036249 | 2021-12-21 | Rensselaer | New York | 36083 | 19610 | 206 |
2032999 | 2032999 | 2021-12-20 | Rensselaer | New York | 36083 | 19516 | 204 |
2029749 | 2029749 | 2021-12-19 | Rensselaer | New York | 36083 | 19438 | 204 |
2026498 | 2026498 | 2021-12-18 | Rensselaer | New York | 36083 | 19331 | 204 |
2023247 | 2023247 | 2021-12-17 | Rensselaer | New York | 36083 | 19222 | 203 |
2019996 | 2019996 | 2021-12-16 | Rensselaer | New York | 36083 | 19102 | 203 |
2016745 | 2016745 | 2021-12-15 | Rensselaer | New York | 36083 | 19015 | 203 |
2013495 | 2013495 | 2021-12-14 | Rensselaer | New York | 36083 | 18914 | 203 |
2010244 | 2010244 | 2021-12-13 | Rensselaer | New York | 36083 | 18862 | 201 |
2006993 | 2006993 | 2021-12-12 | Rensselaer | New York | 36083 | 18819 | 201 |
2003742 | 2003742 | 2021-12-11 | Rensselaer | New York | 36083 | 18703 | 201 |
2000491 | 2000491 | 2021-12-10 | Rensselaer | New York | 36083 | 18581 | 201 |
1997241 | 1997241 | 2021-12-09 | Rensselaer | New York | 36083 | 18447 | 201 |
1993990 | 1993990 | 2021-12-08 | Rensselaer | New York | 36083 | 18322 | 200 |
1990739 | 1990739 | 2021-12-07 | Rensselaer | New York | 36083 | 18229 | 199 |
1987488 | 1987488 | 2021-12-06 | Rensselaer | New York | 36083 | 18137 | 198 |
1984238 | 1984238 | 2021-12-05 | Rensselaer | New York | 36083 | 18059 | 197 |
1980988 | 1980988 | 2021-12-04 | Rensselaer | New York | 36083 | 17938 | 197 |
1977738 | 1977738 | 2021-12-03 | Rensselaer | New York | 36083 | 17811 | 197 |
1974488 | 1974488 | 2021-12-02 | Rensselaer | New York | 36083 | 17633 | 195 |
1971239 | 1971239 | 2021-12-01 | Rensselaer | New York | 36083 | 17502 | 193 |
1967989 | 1967989 | 2021-11-30 | Rensselaer | New York | 36083 | 17411 | 193 |
1964738 | 1964738 | 2021-11-29 | Rensselaer | New York | 36083 | 17336 | 192 |
1961486 | 1961486 | 2021-11-28 | Rensselaer | New York | 36083 | 17260 | 192 |
1958235 | 1958235 | 2021-11-27 | Rensselaer | New York | 36083 | 17188 | 192 |
1954984 | 1954984 | 2021-11-26 | Rensselaer | New York | 36083 | 17147 | 192 |
1951733 | 1951733 | 2021-11-25 | Rensselaer | New York | 36083 | 17067 | 192 |
1948482 | 1948482 | 2021-11-24 | Rensselaer | New York | 36083 | 16941 | 190 |
1945231 | 1945231 | 2021-11-23 | Rensselaer | New York | 36083 | 16851 | 190 |
1941980 | 1941980 | 2021-11-22 | Rensselaer | New York | 36083 | 16790 | 190 |
1938730 | 1938730 | 2021-11-21 | Rensselaer | New York | 36083 | 16716 | 189 |
1935480 | 1935480 | 2021-11-20 | Rensselaer | New York | 36083 | 16649 | 189 |
1932230 | 1932230 | 2021-11-19 | Rensselaer | New York | 36083 | 16540 | 189 |
1928979 | 1928979 | 2021-11-18 | Rensselaer | New York | 36083 | 16466 | 188 |
1925729 | 1925729 | 2021-11-17 | Rensselaer | New York | 36083 | 16342 | 188 |
1922480 | 1922480 | 2021-11-16 | Rensselaer | New York | 36083 | 16273 | 187 |
1919230 | 1919230 | 2021-11-15 | Rensselaer | New York | 36083 | 16240 | 186 |
1915980 | 1915980 | 2021-11-14 | Rensselaer | New York | 36083 | 16194 | 186 |
1912730 | 1912730 | 2021-11-13 | Rensselaer | New York | 36083 | 16144 | 186 |
1909480 | 1909480 | 2021-11-12 | Rensselaer | New York | 36083 | 16073 | 185 |
1906231 | 1906231 | 2021-11-11 | Rensselaer | New York | 36083 | 16003 | 184 |
1902982 | 1902982 | 2021-11-10 | Rensselaer | New York | 36083 | 15865 | 183 |
1899732 | 1899732 | 2021-11-09 | Rensselaer | New York | 36083 | 15809 | 181 |
1896482 | 1896482 | 2021-11-08 | Rensselaer | New York | 36083 | 15757 | 181 |
1893232 | 1893232 | 2021-11-07 | Rensselaer | New York | 36083 | 15702 | 180 |
1889982 | 1889982 | 2021-11-06 | Rensselaer | New York | 36083 | 15630 | 179 |
1886732 | 1886732 | 2021-11-05 | Rensselaer | New York | 36083 | 15562 | 178 |
1883483 | 1883483 | 2021-11-04 | Rensselaer | New York | 36083 | 15490 | 178 |
1880234 | 1880234 | 2021-11-03 | Rensselaer | New York | 36083 | 15432 | 175 |
1876985 | 1876985 | 2021-11-02 | Rensselaer | New York | 36083 | 15389 | 174 |
1873736 | 1873736 | 2021-11-01 | Rensselaer | New York | 36083 | 15339 | 173 |
1870487 | 1870487 | 2021-10-31 | Rensselaer | New York | 36083 | 15312 | 173 |
1867238 | 1867238 | 2021-10-30 | Rensselaer | New York | 36083 | 15274 | 172 |
1863989 | 1863989 | 2021-10-29 | Rensselaer | New York | 36083 | 15213 | 172 |
1860740 | 1860740 | 2021-10-28 | Rensselaer | New York | 36083 | 15127 | 172 |
1857491 | 1857491 | 2021-10-27 | Rensselaer | New York | 36083 | 15081 | 172 |
1854242 | 1854242 | 2021-10-26 | Rensselaer | New York | 36083 | 15024 | 171 |
1850993 | 1850993 | 2021-10-25 | Rensselaer | New York | 36083 | 15006 | 170 |
1847743 | 1847743 | 2021-10-24 | Rensselaer | New York | 36083 | 14947 | 170 |
1844493 | 1844493 | 2021-10-23 | Rensselaer | New York | 36083 | 14902 | 169 |
1841243 | 1841243 | 2021-10-22 | Rensselaer | New York | 36083 | 14839 | 167 |
1837994 | 1837994 | 2021-10-21 | Rensselaer | New York | 36083 | 14808 | 167 |
1834745 | 1834745 | 2021-10-20 | Rensselaer | New York | 36083 | 14761 | 167 |
1831496 | 1831496 | 2021-10-19 | Rensselaer | New York | 36083 | 14692 | 167 |
1828247 | 1828247 | 2021-10-18 | Rensselaer | New York | 36083 | 14669 | 167 |
1824998 | 1824998 | 2021-10-17 | Rensselaer | New York | 36083 | 14618 | 167 |
1821749 | 1821749 | 2021-10-16 | Rensselaer | New York | 36083 | 14570 | 165 |
1818500 | 1818500 | 2021-10-15 | Rensselaer | New York | 36083 | 14517 | 165 |
1815251 | 1815251 | 2021-10-14 | Rensselaer | New York | 36083 | 14443 | 165 |
1812003 | 1812003 | 2021-10-13 | Rensselaer | New York | 36083 | 14398 | 165 |
1808754 | 1808754 | 2021-10-12 | Rensselaer | New York | 36083 | 14358 | 163 |
1805503 | 1805503 | 2021-10-11 | Rensselaer | New York | 36083 | 14324 | 162 |
1802254 | 1802254 | 2021-10-10 | Rensselaer | New York | 36083 | 14239 | 162 |
1799005 | 1799005 | 2021-10-09 | Rensselaer | New York | 36083 | 14209 | 160 |
1795756 | 1795756 | 2021-10-08 | Rensselaer | New York | 36083 | 14145 | 160 |
1792507 | 1792507 | 2021-10-07 | Rensselaer | New York | 36083 | 14067 | 160 |
1789258 | 1789258 | 2021-10-06 | Rensselaer | New York | 36083 | 14015 | 160 |
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);