ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" 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 |
---|---|---|---|---|---|---|---|
2176097 | 2176097 | 2022-02-02 | Washington | New York | 36115 | 11325 | 106 |
2172844 | 2172844 | 2022-02-01 | Washington | New York | 36115 | 11269 | 106 |
2169591 | 2169591 | 2022-01-31 | Washington | New York | 36115 | 11233 | 106 |
2166336 | 2166336 | 2022-01-30 | Washington | New York | 36115 | 11201 | 106 |
2163081 | 2163081 | 2022-01-29 | Washington | New York | 36115 | 11162 | 106 |
2159826 | 2159826 | 2022-01-28 | Washington | New York | 36115 | 11104 | 105 |
2156571 | 2156571 | 2022-01-27 | Washington | New York | 36115 | 11031 | 105 |
2153318 | 2153318 | 2022-01-26 | Washington | New York | 36115 | 10956 | 105 |
2150066 | 2150066 | 2022-01-25 | Washington | New York | 36115 | 10895 | 104 |
2146814 | 2146814 | 2022-01-24 | Washington | New York | 36115 | 10856 | 104 |
2143560 | 2143560 | 2022-01-23 | Washington | New York | 36115 | 10816 | 103 |
2140305 | 2140305 | 2022-01-22 | Washington | New York | 36115 | 10757 | 103 |
2137049 | 2137049 | 2022-01-21 | Washington | New York | 36115 | 10649 | 102 |
2133796 | 2133796 | 2022-01-20 | Washington | New York | 36115 | 10559 | 101 |
2130544 | 2130544 | 2022-01-19 | Washington | New York | 36115 | 10446 | 101 |
2127290 | 2127290 | 2022-01-18 | Washington | New York | 36115 | 10386 | 100 |
2124038 | 2124038 | 2022-01-17 | Washington | New York | 36115 | 10333 | 99 |
2120786 | 2120786 | 2022-01-16 | Washington | New York | 36115 | 10257 | 98 |
2117534 | 2117534 | 2022-01-15 | Washington | New York | 36115 | 10141 | 98 |
2114283 | 2114283 | 2022-01-14 | Washington | New York | 36115 | 9998 | 97 |
2111031 | 2111031 | 2022-01-13 | Washington | New York | 36115 | 9828 | 96 |
2107779 | 2107779 | 2022-01-12 | Washington | New York | 36115 | 9677 | 96 |
2104528 | 2104528 | 2022-01-11 | Washington | New York | 36115 | 9548 | 96 |
2101277 | 2101277 | 2022-01-10 | Washington | New York | 36115 | 9461 | 95 |
2098026 | 2098026 | 2022-01-09 | Washington | New York | 36115 | 9363 | 94 |
2094774 | 2094774 | 2022-01-08 | Washington | New York | 36115 | 9241 | 94 |
2091522 | 2091522 | 2022-01-07 | Washington | New York | 36115 | 9085 | 93 |
2088271 | 2088271 | 2022-01-06 | Washington | New York | 36115 | 8951 | 93 |
2085019 | 2085019 | 2022-01-05 | Washington | New York | 36115 | 8783 | 93 |
2081767 | 2081767 | 2022-01-04 | Washington | New York | 36115 | 8641 | 92 |
2078515 | 2078515 | 2022-01-03 | Washington | New York | 36115 | 8582 | 92 |
2075264 | 2075264 | 2022-01-02 | Washington | New York | 36115 | 8502 | 91 |
2072013 | 2072013 | 2022-01-01 | Washington | New York | 36115 | 8413 | 91 |
2068762 | 2068762 | 2021-12-31 | Washington | New York | 36115 | 8325 | 91 |
2065511 | 2065511 | 2021-12-30 | Washington | New York | 36115 | 8248 | 91 |
2062261 | 2062261 | 2021-12-29 | Washington | New York | 36115 | 8145 | 90 |
2059012 | 2059012 | 2021-12-28 | Washington | New York | 36115 | 8049 | 90 |
2055763 | 2055763 | 2021-12-27 | Washington | New York | 36115 | 8029 | 89 |
2052513 | 2052513 | 2021-12-26 | Washington | New York | 36115 | 8019 | 89 |
2049263 | 2049263 | 2021-12-25 | Washington | New York | 36115 | 7978 | 88 |
2046013 | 2046013 | 2021-12-24 | Washington | New York | 36115 | 7978 | 88 |
2042763 | 2042763 | 2021-12-23 | Washington | New York | 36115 | 7917 | 88 |
2039514 | 2039514 | 2021-12-22 | Washington | New York | 36115 | 7856 | 88 |
2036264 | 2036264 | 2021-12-21 | Washington | New York | 36115 | 7811 | 87 |
2033014 | 2033014 | 2021-12-20 | Washington | New York | 36115 | 7780 | 87 |
2029764 | 2029764 | 2021-12-19 | Washington | New York | 36115 | 7735 | 87 |
2026513 | 2026513 | 2021-12-18 | Washington | New York | 36115 | 7684 | 87 |
2023262 | 2023262 | 2021-12-17 | Washington | New York | 36115 | 7641 | 87 |
2020011 | 2020011 | 2021-12-16 | Washington | New York | 36115 | 7584 | 87 |
2016760 | 2016760 | 2021-12-15 | Washington | New York | 36115 | 7533 | 87 |
2013510 | 2013510 | 2021-12-14 | Washington | New York | 36115 | 7471 | 86 |
2010259 | 2010259 | 2021-12-13 | Washington | New York | 36115 | 7426 | 86 |
2007008 | 2007008 | 2021-12-12 | Washington | New York | 36115 | 7388 | 86 |
2003757 | 2003757 | 2021-12-11 | Washington | New York | 36115 | 7343 | 85 |
2000506 | 2000506 | 2021-12-10 | Washington | New York | 36115 | 7303 | 85 |
1997256 | 1997256 | 2021-12-09 | Washington | New York | 36115 | 7251 | 84 |
1994005 | 1994005 | 2021-12-08 | Washington | New York | 36115 | 7190 | 84 |
1990754 | 1990754 | 2021-12-07 | Washington | New York | 36115 | 7134 | 84 |
1987503 | 1987503 | 2021-12-06 | Washington | New York | 36115 | 7083 | 84 |
1984253 | 1984253 | 2021-12-05 | Washington | New York | 36115 | 7052 | 83 |
1981003 | 1981003 | 2021-12-04 | Washington | New York | 36115 | 6989 | 82 |
1977753 | 1977753 | 2021-12-03 | Washington | New York | 36115 | 6913 | 80 |
1974503 | 1974503 | 2021-12-02 | Washington | New York | 36115 | 6841 | 80 |
1971254 | 1971254 | 2021-12-01 | Washington | New York | 36115 | 6755 | 80 |
1968004 | 1968004 | 2021-11-30 | Washington | New York | 36115 | 6685 | 80 |
1964753 | 1964753 | 2021-11-29 | Washington | New York | 36115 | 6643 | 79 |
1961501 | 1961501 | 2021-11-28 | Washington | New York | 36115 | 6606 | 78 |
1958250 | 1958250 | 2021-11-27 | Washington | New York | 36115 | 6562 | 77 |
1954999 | 1954999 | 2021-11-26 | Washington | New York | 36115 | 6523 | 76 |
1951748 | 1951748 | 2021-11-25 | Washington | New York | 36115 | 6456 | 76 |
1948497 | 1948497 | 2021-11-24 | Washington | New York | 36115 | 6370 | 75 |
1945246 | 1945246 | 2021-11-23 | Washington | New York | 36115 | 6309 | 74 |
1941995 | 1941995 | 2021-11-22 | Washington | New York | 36115 | 6257 | 74 |
1938745 | 1938745 | 2021-11-21 | Washington | New York | 36115 | 6216 | 74 |
1935495 | 1935495 | 2021-11-20 | Washington | New York | 36115 | 6136 | 74 |
1932245 | 1932245 | 2021-11-19 | Washington | New York | 36115 | 6056 | 74 |
1928994 | 1928994 | 2021-11-18 | Washington | New York | 36115 | 5921 | 73 |
1925744 | 1925744 | 2021-11-17 | Washington | New York | 36115 | 5827 | 72 |
1922495 | 1922495 | 2021-11-16 | Washington | New York | 36115 | 5777 | 72 |
1919245 | 1919245 | 2021-11-15 | Washington | New York | 36115 | 5693 | 72 |
1915995 | 1915995 | 2021-11-14 | Washington | New York | 36115 | 5650 | 72 |
1912745 | 1912745 | 2021-11-13 | Washington | New York | 36115 | 5581 | 72 |
1909495 | 1909495 | 2021-11-12 | Washington | New York | 36115 | 5477 | 72 |
1906246 | 1906246 | 2021-11-11 | Washington | New York | 36115 | 5431 | 72 |
1902997 | 1902997 | 2021-11-10 | Washington | New York | 36115 | 5358 | 72 |
1899747 | 1899747 | 2021-11-09 | Washington | New York | 36115 | 5278 | 72 |
1896497 | 1896497 | 2021-11-08 | Washington | New York | 36115 | 5233 | 71 |
1893247 | 1893247 | 2021-11-07 | Washington | New York | 36115 | 5206 | 71 |
1889997 | 1889997 | 2021-11-06 | Washington | New York | 36115 | 5149 | 71 |
1886747 | 1886747 | 2021-11-05 | Washington | New York | 36115 | 5090 | 71 |
1883498 | 1883498 | 2021-11-04 | Washington | New York | 36115 | 5045 | 71 |
1880249 | 1880249 | 2021-11-03 | Washington | New York | 36115 | 4986 | 70 |
1877000 | 1877000 | 2021-11-02 | Washington | New York | 36115 | 4942 | 69 |
1873751 | 1873751 | 2021-11-01 | Washington | New York | 36115 | 4920 | 69 |
1870502 | 1870502 | 2021-10-31 | Washington | New York | 36115 | 4884 | 69 |
1867253 | 1867253 | 2021-10-30 | Washington | New York | 36115 | 4864 | 69 |
1864004 | 1864004 | 2021-10-29 | Washington | New York | 36115 | 4834 | 69 |
1860755 | 1860755 | 2021-10-28 | Washington | New York | 36115 | 4805 | 69 |
1857506 | 1857506 | 2021-10-27 | Washington | New York | 36115 | 4769 | 68 |
1854257 | 1854257 | 2021-10-26 | Washington | New York | 36115 | 4729 | 68 |
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);