ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Ulster" 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 |
---|---|---|---|---|---|---|---|
2111029 | 2111029 | 2022-01-13 | Ulster | New York | 36111 | 26406 | 319 |
2107777 | 2107777 | 2022-01-12 | Ulster | New York | 36111 | 26093 | 317 |
2104526 | 2104526 | 2022-01-11 | Ulster | New York | 36111 | 25719 | 317 |
2101275 | 2101275 | 2022-01-10 | Ulster | New York | 36111 | 25526 | 316 |
2098024 | 2098024 | 2022-01-09 | Ulster | New York | 36111 | 25225 | 316 |
2094772 | 2094772 | 2022-01-08 | Ulster | New York | 36111 | 24817 | 316 |
2091520 | 2091520 | 2022-01-07 | Ulster | New York | 36111 | 24346 | 316 |
2088269 | 2088269 | 2022-01-06 | Ulster | New York | 36111 | 23967 | 315 |
2085017 | 2085017 | 2022-01-05 | Ulster | New York | 36111 | 23689 | 314 |
2081765 | 2081765 | 2022-01-04 | Ulster | New York | 36111 | 23308 | 314 |
2078513 | 2078513 | 2022-01-03 | Ulster | New York | 36111 | 23089 | 314 |
2075262 | 2075262 | 2022-01-02 | Ulster | New York | 36111 | 22855 | 313 |
2072011 | 2072011 | 2022-01-01 | Ulster | New York | 36111 | 22596 | 313 |
2068760 | 2068760 | 2021-12-31 | Ulster | New York | 36111 | 22326 | 312 |
2065509 | 2065509 | 2021-12-30 | Ulster | New York | 36111 | 22112 | 312 |
2062259 | 2062259 | 2021-12-29 | Ulster | New York | 36111 | 21912 | 312 |
2059010 | 2059010 | 2021-12-28 | Ulster | New York | 36111 | 21676 | 312 |
2055761 | 2055761 | 2021-12-27 | Ulster | New York | 36111 | 21565 | 311 |
2052511 | 2052511 | 2021-12-26 | Ulster | New York | 36111 | 21494 | 310 |
2049261 | 2049261 | 2021-12-25 | Ulster | New York | 36111 | 21275 | 309 |
2046011 | 2046011 | 2021-12-24 | Ulster | New York | 36111 | 21275 | 309 |
2042761 | 2042761 | 2021-12-23 | Ulster | New York | 36111 | 21150 | 309 |
2039512 | 2039512 | 2021-12-22 | Ulster | New York | 36111 | 20989 | 308 |
2036262 | 2036262 | 2021-12-21 | Ulster | New York | 36111 | 20872 | 306 |
2033012 | 2033012 | 2021-12-20 | Ulster | New York | 36111 | 20798 | 305 |
2029762 | 2029762 | 2021-12-19 | Ulster | New York | 36111 | 20722 | 305 |
2026511 | 2026511 | 2021-12-18 | Ulster | New York | 36111 | 20642 | 305 |
2023260 | 2023260 | 2021-12-17 | Ulster | New York | 36111 | 20531 | 304 |
2020009 | 2020009 | 2021-12-16 | Ulster | New York | 36111 | 20435 | 303 |
2016758 | 2016758 | 2021-12-15 | Ulster | New York | 36111 | 20331 | 302 |
2013508 | 2013508 | 2021-12-14 | Ulster | New York | 36111 | 20254 | 302 |
2010257 | 2010257 | 2021-12-13 | Ulster | New York | 36111 | 20201 | 299 |
2007006 | 2007006 | 2021-12-12 | Ulster | New York | 36111 | 20157 | 299 |
2003755 | 2003755 | 2021-12-11 | Ulster | New York | 36111 | 20042 | 298 |
2000504 | 2000504 | 2021-12-10 | Ulster | New York | 36111 | 19961 | 298 |
1997254 | 1997254 | 2021-12-09 | Ulster | New York | 36111 | 19849 | 297 |
1994003 | 1994003 | 2021-12-08 | Ulster | New York | 36111 | 19752 | 296 |
1990752 | 1990752 | 2021-12-07 | Ulster | New York | 36111 | 19676 | 295 |
1987501 | 1987501 | 2021-12-06 | Ulster | New York | 36111 | 19624 | 294 |
1984251 | 1984251 | 2021-12-05 | Ulster | New York | 36111 | 19554 | 294 |
1981001 | 1981001 | 2021-12-04 | Ulster | New York | 36111 | 19468 | 293 |
1977751 | 1977751 | 2021-12-03 | Ulster | New York | 36111 | 19396 | 293 |
1974501 | 1974501 | 2021-12-02 | Ulster | New York | 36111 | 19260 | 293 |
1971252 | 1971252 | 2021-12-01 | Ulster | New York | 36111 | 19155 | 292 |
1968002 | 1968002 | 2021-11-30 | Ulster | New York | 36111 | 19063 | 291 |
1964751 | 1964751 | 2021-11-29 | Ulster | New York | 36111 | 19008 | 291 |
1961499 | 1961499 | 2021-11-28 | Ulster | New York | 36111 | 18957 | 290 |
1958248 | 1958248 | 2021-11-27 | Ulster | New York | 36111 | 18908 | 290 |
1954997 | 1954997 | 2021-11-26 | Ulster | New York | 36111 | 18865 | 288 |
1951746 | 1951746 | 2021-11-25 | Ulster | New York | 36111 | 18785 | 288 |
1948495 | 1948495 | 2021-11-24 | Ulster | New York | 36111 | 18701 | 288 |
1945244 | 1945244 | 2021-11-23 | Ulster | New York | 36111 | 18629 | 287 |
1941993 | 1941993 | 2021-11-22 | Ulster | New York | 36111 | 18592 | 287 |
1938743 | 1938743 | 2021-11-21 | Ulster | New York | 36111 | 18523 | 287 |
1935493 | 1935493 | 2021-11-20 | Ulster | New York | 36111 | 18463 | 287 |
1932243 | 1932243 | 2021-11-19 | Ulster | New York | 36111 | 18403 | 287 |
1928992 | 1928992 | 2021-11-18 | Ulster | New York | 36111 | 18320 | 287 |
1925742 | 1925742 | 2021-11-17 | Ulster | New York | 36111 | 18250 | 287 |
1922493 | 1922493 | 2021-11-16 | Ulster | New York | 36111 | 18200 | 287 |
1919243 | 1919243 | 2021-11-15 | Ulster | New York | 36111 | 18156 | 287 |
1915993 | 1915993 | 2021-11-14 | Ulster | New York | 36111 | 18114 | 287 |
1912743 | 1912743 | 2021-11-13 | Ulster | New York | 36111 | 18074 | 287 |
1909493 | 1909493 | 2021-11-12 | Ulster | New York | 36111 | 18016 | 287 |
1906244 | 1906244 | 2021-11-11 | Ulster | New York | 36111 | 17928 | 287 |
1902995 | 1902995 | 2021-11-10 | Ulster | New York | 36111 | 17853 | 286 |
1899745 | 1899745 | 2021-11-09 | Ulster | New York | 36111 | 17809 | 286 |
1896495 | 1896495 | 2021-11-08 | Ulster | New York | 36111 | 17785 | 286 |
1893245 | 1893245 | 2021-11-07 | Ulster | New York | 36111 | 17760 | 286 |
1889995 | 1889995 | 2021-11-06 | Ulster | New York | 36111 | 17728 | 286 |
1886745 | 1886745 | 2021-11-05 | Ulster | New York | 36111 | 17687 | 286 |
1883496 | 1883496 | 2021-11-04 | Ulster | New York | 36111 | 17655 | 286 |
1880247 | 1880247 | 2021-11-03 | Ulster | New York | 36111 | 17619 | 286 |
1876998 | 1876998 | 2021-11-02 | Ulster | New York | 36111 | 17591 | 286 |
1873749 | 1873749 | 2021-11-01 | Ulster | New York | 36111 | 17567 | 286 |
1870500 | 1870500 | 2021-10-31 | Ulster | New York | 36111 | 17557 | 286 |
1867251 | 1867251 | 2021-10-30 | Ulster | New York | 36111 | 17530 | 284 |
1864002 | 1864002 | 2021-10-29 | Ulster | New York | 36111 | 17499 | 283 |
1860753 | 1860753 | 2021-10-28 | Ulster | New York | 36111 | 17458 | 283 |
1857504 | 1857504 | 2021-10-27 | Ulster | New York | 36111 | 17421 | 283 |
1854255 | 1854255 | 2021-10-26 | Ulster | New York | 36111 | 17394 | 282 |
1851006 | 1851006 | 2021-10-25 | Ulster | New York | 36111 | 17373 | 280 |
1847756 | 1847756 | 2021-10-24 | Ulster | New York | 36111 | 17349 | 280 |
1844506 | 1844506 | 2021-10-23 | Ulster | New York | 36111 | 17327 | 280 |
1841256 | 1841256 | 2021-10-22 | Ulster | New York | 36111 | 17300 | 280 |
1838007 | 1838007 | 2021-10-21 | Ulster | New York | 36111 | 17273 | 278 |
1834758 | 1834758 | 2021-10-20 | Ulster | New York | 36111 | 17248 | 278 |
1831509 | 1831509 | 2021-10-19 | Ulster | New York | 36111 | 17224 | 278 |
1828260 | 1828260 | 2021-10-18 | Ulster | New York | 36111 | 17205 | 278 |
1825011 | 1825011 | 2021-10-17 | Ulster | New York | 36111 | 17179 | 277 |
1821762 | 1821762 | 2021-10-16 | Ulster | New York | 36111 | 17148 | 277 |
1818513 | 1818513 | 2021-10-15 | Ulster | New York | 36111 | 17120 | 276 |
1815264 | 1815264 | 2021-10-14 | Ulster | New York | 36111 | 17091 | 276 |
1812016 | 1812016 | 2021-10-13 | Ulster | New York | 36111 | 17043 | 276 |
1808767 | 1808767 | 2021-10-12 | Ulster | New York | 36111 | 17005 | 276 |
1805516 | 1805516 | 2021-10-11 | Ulster | New York | 36111 | 16974 | 276 |
1802267 | 1802267 | 2021-10-10 | Ulster | New York | 36111 | 16933 | 276 |
1799018 | 1799018 | 2021-10-09 | Ulster | New York | 36111 | 16922 | 276 |
1795769 | 1795769 | 2021-10-08 | Ulster | New York | 36111 | 16886 | 275 |
1792520 | 1792520 | 2021-10-07 | Ulster | New York | 36111 | 16848 | 275 |
1789271 | 1789271 | 2021-10-06 | Ulster | New York | 36111 | 16817 | 275 |
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);