ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Polk" and fips = 41053 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176453 | 2176453 | 2022-02-02 | Polk | Oregon | 41053 | 13775 | 117 |
2173199 | 2173199 | 2022-02-01 | Polk | Oregon | 41053 | 13630 | 117 |
2169947 | 2169947 | 2022-01-31 | Polk | Oregon | 41053 | 13485 | 117 |
2166692 | 2166692 | 2022-01-30 | Polk | Oregon | 41053 | 13176 | 116 |
2163437 | 2163437 | 2022-01-29 | Polk | Oregon | 41053 | 13176 | 116 |
2160182 | 2160182 | 2022-01-28 | Polk | Oregon | 41053 | 13176 | 116 |
2156927 | 2156927 | 2022-01-27 | Polk | Oregon | 41053 | 13009 | 116 |
2153674 | 2153674 | 2022-01-26 | Polk | Oregon | 41053 | 12834 | 115 |
2150422 | 2150422 | 2022-01-25 | Polk | Oregon | 41053 | 12587 | 115 |
2147170 | 2147170 | 2022-01-24 | Polk | Oregon | 41053 | 12394 | 115 |
2143916 | 2143916 | 2022-01-23 | Polk | Oregon | 41053 | 11966 | 115 |
2140661 | 2140661 | 2022-01-22 | Polk | Oregon | 41053 | 11966 | 115 |
2137405 | 2137405 | 2022-01-21 | Polk | Oregon | 41053 | 11966 | 115 |
2134151 | 2134151 | 2022-01-20 | Polk | Oregon | 41053 | 11697 | 112 |
2130899 | 2130899 | 2022-01-19 | Polk | Oregon | 41053 | 11462 | 112 |
2127645 | 2127645 | 2022-01-18 | Polk | Oregon | 41053 | 11193 | 112 |
2124393 | 2124393 | 2022-01-17 | Polk | Oregon | 41053 | 10651 | 112 |
2121141 | 2121141 | 2022-01-16 | Polk | Oregon | 41053 | 10651 | 112 |
2117889 | 2117889 | 2022-01-15 | Polk | Oregon | 41053 | 10651 | 112 |
2114638 | 2114638 | 2022-01-14 | Polk | Oregon | 41053 | 10651 | 112 |
2111386 | 2111386 | 2022-01-13 | Polk | Oregon | 41053 | 10443 | 112 |
2108134 | 2108134 | 2022-01-12 | Polk | Oregon | 41053 | 10221 | 112 |
2104883 | 2104883 | 2022-01-11 | Polk | Oregon | 41053 | 10009 | 112 |
2101632 | 2101632 | 2022-01-10 | Polk | Oregon | 41053 | 9867 | 112 |
2098381 | 2098381 | 2022-01-09 | Polk | Oregon | 41053 | 9601 | 112 |
2095129 | 2095129 | 2022-01-08 | Polk | Oregon | 41053 | 9601 | 112 |
2091877 | 2091877 | 2022-01-07 | Polk | Oregon | 41053 | 9601 | 112 |
2088625 | 2088625 | 2022-01-06 | Polk | Oregon | 41053 | 9416 | 112 |
2085374 | 2085374 | 2022-01-05 | Polk | Oregon | 41053 | 9140 | 112 |
2082122 | 2082122 | 2022-01-04 | Polk | Oregon | 41053 | 9045 | 111 |
2078870 | 2078870 | 2022-01-03 | Polk | Oregon | 41053 | 8924 | 111 |
2075619 | 2075619 | 2022-01-02 | Polk | Oregon | 41053 | 8857 | 111 |
2072368 | 2072368 | 2022-01-01 | Polk | Oregon | 41053 | 8857 | 111 |
2069117 | 2069117 | 2021-12-31 | Polk | Oregon | 41053 | 8857 | 111 |
2065866 | 2065866 | 2021-12-30 | Polk | Oregon | 41053 | 8857 | 111 |
2062616 | 2062616 | 2021-12-29 | Polk | Oregon | 41053 | 8817 | 111 |
2059366 | 2059366 | 2021-12-28 | Polk | Oregon | 41053 | 8777 | 110 |
2056117 | 2056117 | 2021-12-27 | Polk | Oregon | 41053 | 8703 | 110 |
2052868 | 2052868 | 2021-12-26 | Polk | Oregon | 41053 | 8680 | 110 |
2049618 | 2049618 | 2021-12-25 | Polk | Oregon | 41053 | 8680 | 110 |
2046368 | 2046368 | 2021-12-24 | Polk | Oregon | 41053 | 8680 | 110 |
2043118 | 2043118 | 2021-12-23 | Polk | Oregon | 41053 | 8680 | 110 |
2039869 | 2039869 | 2021-12-22 | Polk | Oregon | 41053 | 8652 | 109 |
2036619 | 2036619 | 2021-12-21 | Polk | Oregon | 41053 | 8630 | 109 |
2033369 | 2033369 | 2021-12-20 | Polk | Oregon | 41053 | 8608 | 109 |
2030119 | 2030119 | 2021-12-19 | Polk | Oregon | 41053 | 8591 | 109 |
2026868 | 2026868 | 2021-12-18 | Polk | Oregon | 41053 | 8591 | 109 |
2023617 | 2023617 | 2021-12-17 | Polk | Oregon | 41053 | 8591 | 109 |
2020366 | 2020366 | 2021-12-16 | Polk | Oregon | 41053 | 8569 | 109 |
2017115 | 2017115 | 2021-12-15 | Polk | Oregon | 41053 | 8540 | 108 |
2013865 | 2013865 | 2021-12-14 | Polk | Oregon | 41053 | 8511 | 108 |
2010614 | 2010614 | 2021-12-13 | Polk | Oregon | 41053 | 8478 | 106 |
2007363 | 2007363 | 2021-12-12 | Polk | Oregon | 41053 | 8464 | 105 |
2004112 | 2004112 | 2021-12-11 | Polk | Oregon | 41053 | 8464 | 105 |
2000861 | 2000861 | 2021-12-10 | Polk | Oregon | 41053 | 8464 | 105 |
1997611 | 1997611 | 2021-12-09 | Polk | Oregon | 41053 | 8440 | 105 |
1994360 | 1994360 | 2021-12-08 | Polk | Oregon | 41053 | 8409 | 104 |
1991109 | 1991109 | 2021-12-07 | Polk | Oregon | 41053 | 8384 | 103 |
1987858 | 1987858 | 2021-12-06 | Polk | Oregon | 41053 | 8347 | 103 |
1984608 | 1984608 | 2021-12-05 | Polk | Oregon | 41053 | 8325 | 102 |
1981358 | 1981358 | 2021-12-04 | Polk | Oregon | 41053 | 8325 | 102 |
1978108 | 1978108 | 2021-12-03 | Polk | Oregon | 41053 | 8325 | 102 |
1974858 | 1974858 | 2021-12-02 | Polk | Oregon | 41053 | 8268 | 102 |
1971609 | 1971609 | 2021-12-01 | Polk | Oregon | 41053 | 8248 | 102 |
1968359 | 1968359 | 2021-11-30 | Polk | Oregon | 41053 | 8212 | 100 |
1965108 | 1965108 | 2021-11-29 | Polk | Oregon | 41053 | 8162 | 100 |
1961856 | 1961856 | 2021-11-28 | Polk | Oregon | 41053 | 8136 | 98 |
1958605 | 1958605 | 2021-11-27 | Polk | Oregon | 41053 | 8136 | 98 |
1955354 | 1955354 | 2021-11-26 | Polk | Oregon | 41053 | 8136 | 98 |
1952103 | 1952103 | 2021-11-25 | Polk | Oregon | 41053 | 8136 | 98 |
1948852 | 1948852 | 2021-11-24 | Polk | Oregon | 41053 | 8136 | 98 |
1945601 | 1945601 | 2021-11-23 | Polk | Oregon | 41053 | 8113 | 98 |
1942350 | 1942350 | 2021-11-22 | Polk | Oregon | 41053 | 8059 | 97 |
1939100 | 1939100 | 2021-11-21 | Polk | Oregon | 41053 | 8028 | 93 |
1935850 | 1935850 | 2021-11-20 | Polk | Oregon | 41053 | 8028 | 93 |
1932600 | 1932600 | 2021-11-19 | Polk | Oregon | 41053 | 8028 | 93 |
1929349 | 1929349 | 2021-11-18 | Polk | Oregon | 41053 | 8004 | 92 |
1926099 | 1926099 | 2021-11-17 | Polk | Oregon | 41053 | 7977 | 92 |
1922849 | 1922849 | 2021-11-16 | Polk | Oregon | 41053 | 7948 | 91 |
1919600 | 1919600 | 2021-11-15 | Polk | Oregon | 41053 | 7907 | 88 |
1916350 | 1916350 | 2021-11-14 | Polk | Oregon | 41053 | 7867 | 88 |
1913100 | 1913100 | 2021-11-13 | Polk | Oregon | 41053 | 7867 | 88 |
1909850 | 1909850 | 2021-11-12 | Polk | Oregon | 41053 | 7867 | 88 |
1906601 | 1906601 | 2021-11-11 | Polk | Oregon | 41053 | 7836 | 88 |
1903352 | 1903352 | 2021-11-10 | Polk | Oregon | 41053 | 7836 | 88 |
1900102 | 1900102 | 2021-11-09 | Polk | Oregon | 41053 | 7809 | 88 |
1896852 | 1896852 | 2021-11-08 | Polk | Oregon | 41053 | 7769 | 88 |
1893602 | 1893602 | 2021-11-07 | Polk | Oregon | 41053 | 7737 | 87 |
1890352 | 1890352 | 2021-11-06 | Polk | Oregon | 41053 | 7737 | 87 |
1887102 | 1887102 | 2021-11-05 | Polk | Oregon | 41053 | 7737 | 87 |
1883852 | 1883852 | 2021-11-04 | Polk | Oregon | 41053 | 7713 | 86 |
1880603 | 1880603 | 2021-11-03 | Polk | Oregon | 41053 | 7685 | 84 |
1877354 | 1877354 | 2021-11-02 | Polk | Oregon | 41053 | 7648 | 82 |
1874105 | 1874105 | 2021-11-01 | Polk | Oregon | 41053 | 7601 | 82 |
1870856 | 1870856 | 2021-10-31 | Polk | Oregon | 41053 | 7561 | 82 |
1867607 | 1867607 | 2021-10-30 | Polk | Oregon | 41053 | 7561 | 82 |
1864358 | 1864358 | 2021-10-29 | Polk | Oregon | 41053 | 7561 | 82 |
1861109 | 1861109 | 2021-10-28 | Polk | Oregon | 41053 | 7533 | 81 |
1857860 | 1857860 | 2021-10-27 | Polk | Oregon | 41053 | 7502 | 81 |
1854611 | 1854611 | 2021-10-26 | Polk | Oregon | 41053 | 7464 | 81 |
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);