ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Douglas" and fips = 53017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177266 | 2177266 | 2022-02-02 | Douglas | Washington | 53017 | 10154 | 56 |
2174013 | 2174013 | 2022-02-01 | Douglas | Washington | 53017 | 9982 | 55 |
2170761 | 2170761 | 2022-01-31 | Douglas | Washington | 53017 | 9982 | 55 |
2167508 | 2167508 | 2022-01-30 | Douglas | Washington | 53017 | 9494 | 55 |
2164253 | 2164253 | 2022-01-29 | Douglas | Washington | 53017 | 9494 | 55 |
2160998 | 2160998 | 2022-01-28 | Douglas | Washington | 53017 | 9494 | 55 |
2157742 | 2157742 | 2022-01-27 | Douglas | Washington | 53017 | 9183 | 55 |
2154489 | 2154489 | 2022-01-26 | Douglas | Washington | 53017 | 9183 | 55 |
2151236 | 2151236 | 2022-01-25 | Douglas | Washington | 53017 | 8913 | 55 |
2147984 | 2147984 | 2022-01-24 | Douglas | Washington | 53017 | 8825 | 55 |
2144732 | 2144732 | 2022-01-23 | Douglas | Washington | 53017 | 8425 | 55 |
2141477 | 2141477 | 2022-01-22 | Douglas | Washington | 53017 | 8336 | 55 |
2138221 | 2138221 | 2022-01-21 | Douglas | Washington | 53017 | 8425 | 55 |
2134966 | 2134966 | 2022-01-20 | Douglas | Washington | 53017 | 8273 | 55 |
2131714 | 2131714 | 2022-01-19 | Douglas | Washington | 53017 | 8243 | 55 |
2128460 | 2128460 | 2022-01-18 | Douglas | Washington | 53017 | 8112 | 55 |
2125207 | 2125207 | 2022-01-17 | Douglas | Washington | 53017 | 7806 | 55 |
2121955 | 2121955 | 2022-01-16 | Douglas | Washington | 53017 | 7806 | 55 |
2118703 | 2118703 | 2022-01-15 | Douglas | Washington | 53017 | 7806 | 55 |
2115451 | 2115451 | 2022-01-14 | Douglas | Washington | 53017 | 7806 | 55 |
2112199 | 2112199 | 2022-01-13 | Douglas | Washington | 53017 | 7622 | 55 |
2108947 | 2108947 | 2022-01-12 | Douglas | Washington | 53017 | 7510 | 54 |
2105696 | 2105696 | 2022-01-11 | Douglas | Washington | 53017 | 7388 | 54 |
2102445 | 2102445 | 2022-01-10 | Douglas | Washington | 53017 | 7296 | 54 |
2099194 | 2099194 | 2022-01-09 | Douglas | Washington | 53017 | 7190 | 54 |
2095943 | 2095943 | 2022-01-08 | Douglas | Washington | 53017 | 7190 | 54 |
2092691 | 2092691 | 2022-01-07 | Douglas | Washington | 53017 | 7190 | 54 |
2089439 | 2089439 | 2022-01-06 | Douglas | Washington | 53017 | 7149 | 54 |
2086188 | 2086188 | 2022-01-05 | Douglas | Washington | 53017 | 7084 | 54 |
2082936 | 2082936 | 2022-01-04 | Douglas | Washington | 53017 | 7062 | 54 |
2079684 | 2079684 | 2022-01-03 | Douglas | Washington | 53017 | 6974 | 54 |
2076432 | 2076432 | 2022-01-02 | Douglas | Washington | 53017 | 6933 | 54 |
2073181 | 2073181 | 2022-01-01 | Douglas | Washington | 53017 | 6933 | 54 |
2069930 | 2069930 | 2021-12-31 | Douglas | Washington | 53017 | 6933 | 54 |
2066679 | 2066679 | 2021-12-30 | Douglas | Washington | 53017 | 6933 | 54 |
2063429 | 2063429 | 2021-12-29 | Douglas | Washington | 53017 | 6916 | 54 |
2060179 | 2060179 | 2021-12-28 | Douglas | Washington | 53017 | 6912 | 54 |
2056930 | 2056930 | 2021-12-27 | Douglas | Washington | 53017 | 6879 | 54 |
2053681 | 2053681 | 2021-12-26 | Douglas | Washington | 53017 | 6879 | 54 |
2050431 | 2050431 | 2021-12-25 | Douglas | Washington | 53017 | 6879 | 54 |
2047181 | 2047181 | 2021-12-24 | Douglas | Washington | 53017 | 6879 | 54 |
2043931 | 2043931 | 2021-12-23 | Douglas | Washington | 53017 | 6879 | 54 |
2040682 | 2040682 | 2021-12-22 | Douglas | Washington | 53017 | 6869 | 54 |
2037432 | 2037432 | 2021-12-21 | Douglas | Washington | 53017 | 6847 | 54 |
2034182 | 2034182 | 2021-12-20 | Douglas | Washington | 53017 | 6847 | 54 |
2030932 | 2030932 | 2021-12-19 | Douglas | Washington | 53017 | 6828 | 54 |
2027681 | 2027681 | 2021-12-18 | Douglas | Washington | 53017 | 6828 | 54 |
2024430 | 2024430 | 2021-12-17 | Douglas | Washington | 53017 | 6828 | 54 |
2021179 | 2021179 | 2021-12-16 | Douglas | Washington | 53017 | 6828 | 54 |
2017928 | 2017928 | 2021-12-15 | Douglas | Washington | 53017 | 6818 | 54 |
2014678 | 2014678 | 2021-12-14 | Douglas | Washington | 53017 | 6805 | 51 |
2011427 | 2011427 | 2021-12-13 | Douglas | Washington | 53017 | 6805 | 51 |
2008176 | 2008176 | 2021-12-12 | Douglas | Washington | 53017 | 6796 | 51 |
2004925 | 2004925 | 2021-12-11 | Douglas | Washington | 53017 | 6796 | 51 |
2001674 | 2001674 | 2021-12-10 | Douglas | Washington | 53017 | 6796 | 51 |
1998424 | 1998424 | 2021-12-09 | Douglas | Washington | 53017 | 6782 | 50 |
1995173 | 1995173 | 2021-12-08 | Douglas | Washington | 53017 | 6774 | 49 |
1991922 | 1991922 | 2021-12-07 | Douglas | Washington | 53017 | 6768 | 49 |
1988671 | 1988671 | 2021-12-06 | Douglas | Washington | 53017 | 6740 | 47 |
1985421 | 1985421 | 2021-12-05 | Douglas | Washington | 53017 | 6729 | 47 |
1982171 | 1982171 | 2021-12-04 | Douglas | Washington | 53017 | 6729 | 47 |
1978921 | 1978921 | 2021-12-03 | Douglas | Washington | 53017 | 6729 | 47 |
1975671 | 1975671 | 2021-12-02 | Douglas | Washington | 53017 | 6715 | 47 |
1972422 | 1972422 | 2021-12-01 | Douglas | Washington | 53017 | 6702 | 47 |
1969172 | 1969172 | 2021-11-30 | Douglas | Washington | 53017 | 6628 | 47 |
1965922 | 1965922 | 2021-11-29 | Douglas | Washington | 53017 | 6628 | 45 |
1962670 | 1962670 | 2021-11-28 | Douglas | Washington | 53017 | 6628 | 44 |
1959419 | 1959419 | 2021-11-27 | Douglas | Washington | 53017 | 6628 | 44 |
1956168 | 1956168 | 2021-11-26 | Douglas | Washington | 53017 | 6628 | 44 |
1952917 | 1952917 | 2021-11-25 | Douglas | Washington | 53017 | 6628 | 44 |
1949666 | 1949666 | 2021-11-24 | Douglas | Washington | 53017 | 6628 | 44 |
1946415 | 1946415 | 2021-11-23 | Douglas | Washington | 53017 | 6619 | 44 |
1943164 | 1943164 | 2021-11-22 | Douglas | Washington | 53017 | 6560 | 43 |
1939914 | 1939914 | 2021-11-21 | Douglas | Washington | 53017 | 6560 | 43 |
1936664 | 1936664 | 2021-11-20 | Douglas | Washington | 53017 | 6560 | 43 |
1933414 | 1933414 | 2021-11-19 | Douglas | Washington | 53017 | 6560 | 43 |
1930162 | 1930162 | 2021-11-18 | Douglas | Washington | 53017 | 6539 | 43 |
1926912 | 1926912 | 2021-11-17 | Douglas | Washington | 53017 | 6514 | 42 |
1923662 | 1923662 | 2021-11-16 | Douglas | Washington | 53017 | 6502 | 42 |
1920413 | 1920413 | 2021-11-15 | Douglas | Washington | 53017 | 6398 | 41 |
1917163 | 1917163 | 2021-11-14 | Douglas | Washington | 53017 | 6342 | 41 |
1913913 | 1913913 | 2021-11-13 | Douglas | Washington | 53017 | 6342 | 41 |
1910663 | 1910663 | 2021-11-12 | Douglas | Washington | 53017 | 6342 | 41 |
1907414 | 1907414 | 2021-11-11 | Douglas | Washington | 53017 | 6277 | 39 |
1904165 | 1904165 | 2021-11-10 | Douglas | Washington | 53017 | 6277 | 39 |
1900915 | 1900915 | 2021-11-09 | Douglas | Washington | 53017 | 6254 | 39 |
1897665 | 1897665 | 2021-11-08 | Douglas | Washington | 53017 | 6240 | 38 |
1894415 | 1894415 | 2021-11-07 | Douglas | Washington | 53017 | 6193 | 38 |
1891165 | 1891165 | 2021-11-06 | Douglas | Washington | 53017 | 6193 | 38 |
1887915 | 1887915 | 2021-11-05 | Douglas | Washington | 53017 | 6193 | 38 |
1884665 | 1884665 | 2021-11-04 | Douglas | Washington | 53017 | 6174 | 38 |
1881416 | 1881416 | 2021-11-03 | Douglas | Washington | 53017 | 6173 | 38 |
1878167 | 1878167 | 2021-11-02 | Douglas | Washington | 53017 | 6173 | 38 |
1874918 | 1874918 | 2021-11-01 | Douglas | Washington | 53017 | 6173 | 38 |
1871669 | 1871669 | 2021-10-31 | Douglas | Washington | 53017 | 6136 | 38 |
1868420 | 1868420 | 2021-10-30 | Douglas | Washington | 53017 | 6136 | 38 |
1865171 | 1865171 | 2021-10-29 | Douglas | Washington | 53017 | 6136 | 38 |
1861922 | 1861922 | 2021-10-28 | Douglas | Washington | 53017 | 6136 | 38 |
1858673 | 1858673 | 2021-10-27 | Douglas | Washington | 53017 | 6111 | 39 |
1855424 | 1855424 | 2021-10-26 | Douglas | Washington | 53017 | 6111 | 39 |
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);