ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Hood River" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176440 | 2176440 | 2022-02-02 | Hood River | Oregon | 41027 | 3227 | 41 |
2173186 | 2173186 | 2022-02-01 | Hood River | Oregon | 41027 | 3203 | 40 |
2169934 | 2169934 | 2022-01-31 | Hood River | Oregon | 41027 | 3167 | 40 |
2166679 | 2166679 | 2022-01-30 | Hood River | Oregon | 41027 | 3107 | 40 |
2163424 | 2163424 | 2022-01-29 | Hood River | Oregon | 41027 | 3107 | 40 |
2160169 | 2160169 | 2022-01-28 | Hood River | Oregon | 41027 | 3107 | 40 |
2156914 | 2156914 | 2022-01-27 | Hood River | Oregon | 41027 | 3070 | 40 |
2153661 | 2153661 | 2022-01-26 | Hood River | Oregon | 41027 | 3035 | 40 |
2150409 | 2150409 | 2022-01-25 | Hood River | Oregon | 41027 | 2983 | 40 |
2147157 | 2147157 | 2022-01-24 | Hood River | Oregon | 41027 | 2930 | 39 |
2143903 | 2143903 | 2022-01-23 | Hood River | Oregon | 41027 | 2866 | 38 |
2140648 | 2140648 | 2022-01-22 | Hood River | Oregon | 41027 | 2866 | 38 |
2137392 | 2137392 | 2022-01-21 | Hood River | Oregon | 41027 | 2866 | 38 |
2134138 | 2134138 | 2022-01-20 | Hood River | Oregon | 41027 | 2823 | 38 |
2130886 | 2130886 | 2022-01-19 | Hood River | Oregon | 41027 | 2771 | 38 |
2127632 | 2127632 | 2022-01-18 | Hood River | Oregon | 41027 | 2663 | 38 |
2124380 | 2124380 | 2022-01-17 | Hood River | Oregon | 41027 | 2621 | 38 |
2121128 | 2121128 | 2022-01-16 | Hood River | Oregon | 41027 | 2621 | 38 |
2117876 | 2117876 | 2022-01-15 | Hood River | Oregon | 41027 | 2621 | 38 |
2114625 | 2114625 | 2022-01-14 | Hood River | Oregon | 41027 | 2621 | 38 |
2111373 | 2111373 | 2022-01-13 | Hood River | Oregon | 41027 | 2571 | 38 |
2108121 | 2108121 | 2022-01-12 | Hood River | Oregon | 41027 | 2544 | 38 |
2104870 | 2104870 | 2022-01-11 | Hood River | Oregon | 41027 | 2505 | 38 |
2101619 | 2101619 | 2022-01-10 | Hood River | Oregon | 41027 | 2462 | 38 |
2098368 | 2098368 | 2022-01-09 | Hood River | Oregon | 41027 | 2376 | 38 |
2095116 | 2095116 | 2022-01-08 | Hood River | Oregon | 41027 | 2376 | 38 |
2091864 | 2091864 | 2022-01-07 | Hood River | Oregon | 41027 | 2376 | 38 |
2088612 | 2088612 | 2022-01-06 | Hood River | Oregon | 41027 | 2375 | 38 |
2085361 | 2085361 | 2022-01-05 | Hood River | Oregon | 41027 | 2348 | 38 |
2082109 | 2082109 | 2022-01-04 | Hood River | Oregon | 41027 | 2311 | 38 |
2078857 | 2078857 | 2022-01-03 | Hood River | Oregon | 41027 | 2311 | 38 |
2075606 | 2075606 | 2022-01-02 | Hood River | Oregon | 41027 | 2304 | 38 |
2072355 | 2072355 | 2022-01-01 | Hood River | Oregon | 41027 | 2304 | 38 |
2069104 | 2069104 | 2021-12-31 | Hood River | Oregon | 41027 | 2304 | 38 |
2065853 | 2065853 | 2021-12-30 | Hood River | Oregon | 41027 | 2304 | 38 |
2062603 | 2062603 | 2021-12-29 | Hood River | Oregon | 41027 | 2286 | 38 |
2059353 | 2059353 | 2021-12-28 | Hood River | Oregon | 41027 | 2271 | 38 |
2056104 | 2056104 | 2021-12-27 | Hood River | Oregon | 41027 | 2258 | 38 |
2052855 | 2052855 | 2021-12-26 | Hood River | Oregon | 41027 | 2245 | 38 |
2049605 | 2049605 | 2021-12-25 | Hood River | Oregon | 41027 | 2245 | 38 |
2046355 | 2046355 | 2021-12-24 | Hood River | Oregon | 41027 | 2245 | 38 |
2043105 | 2043105 | 2021-12-23 | Hood River | Oregon | 41027 | 2245 | 38 |
2039856 | 2039856 | 2021-12-22 | Hood River | Oregon | 41027 | 2240 | 38 |
2036606 | 2036606 | 2021-12-21 | Hood River | Oregon | 41027 | 2234 | 38 |
2033356 | 2033356 | 2021-12-20 | Hood River | Oregon | 41027 | 2227 | 38 |
2030106 | 2030106 | 2021-12-19 | Hood River | Oregon | 41027 | 2221 | 38 |
2026855 | 2026855 | 2021-12-18 | Hood River | Oregon | 41027 | 2221 | 38 |
2023604 | 2023604 | 2021-12-17 | Hood River | Oregon | 41027 | 2221 | 38 |
2020353 | 2020353 | 2021-12-16 | Hood River | Oregon | 41027 | 2217 | 38 |
2017102 | 2017102 | 2021-12-15 | Hood River | Oregon | 41027 | 2214 | 37 |
2013852 | 2013852 | 2021-12-14 | Hood River | Oregon | 41027 | 2209 | 37 |
2010601 | 2010601 | 2021-12-13 | Hood River | Oregon | 41027 | 2206 | 37 |
2007350 | 2007350 | 2021-12-12 | Hood River | Oregon | 41027 | 2203 | 37 |
2004099 | 2004099 | 2021-12-11 | Hood River | Oregon | 41027 | 2203 | 37 |
2000848 | 2000848 | 2021-12-10 | Hood River | Oregon | 41027 | 2203 | 37 |
1997598 | 1997598 | 2021-12-09 | Hood River | Oregon | 41027 | 2197 | 37 |
1994347 | 1994347 | 2021-12-08 | Hood River | Oregon | 41027 | 2189 | 37 |
1991096 | 1991096 | 2021-12-07 | Hood River | Oregon | 41027 | 2186 | 37 |
1987845 | 1987845 | 2021-12-06 | Hood River | Oregon | 41027 | 2172 | 37 |
1984595 | 1984595 | 2021-12-05 | Hood River | Oregon | 41027 | 2165 | 37 |
1981345 | 1981345 | 2021-12-04 | Hood River | Oregon | 41027 | 2165 | 37 |
1978095 | 1978095 | 2021-12-03 | Hood River | Oregon | 41027 | 2165 | 37 |
1974845 | 1974845 | 2021-12-02 | Hood River | Oregon | 41027 | 2151 | 37 |
1971596 | 1971596 | 2021-12-01 | Hood River | Oregon | 41027 | 2145 | 37 |
1968346 | 1968346 | 2021-11-30 | Hood River | Oregon | 41027 | 2137 | 37 |
1965095 | 1965095 | 2021-11-29 | Hood River | Oregon | 41027 | 2119 | 37 |
1961843 | 1961843 | 2021-11-28 | Hood River | Oregon | 41027 | 2113 | 37 |
1958592 | 1958592 | 2021-11-27 | Hood River | Oregon | 41027 | 2113 | 37 |
1955341 | 1955341 | 2021-11-26 | Hood River | Oregon | 41027 | 2113 | 37 |
1952090 | 1952090 | 2021-11-25 | Hood River | Oregon | 41027 | 2113 | 37 |
1948839 | 1948839 | 2021-11-24 | Hood River | Oregon | 41027 | 2113 | 37 |
1945588 | 1945588 | 2021-11-23 | Hood River | Oregon | 41027 | 2105 | 37 |
1942337 | 1942337 | 2021-11-22 | Hood River | Oregon | 41027 | 2095 | 37 |
1939087 | 1939087 | 2021-11-21 | Hood River | Oregon | 41027 | 2086 | 37 |
1935837 | 1935837 | 2021-11-20 | Hood River | Oregon | 41027 | 2086 | 37 |
1932587 | 1932587 | 2021-11-19 | Hood River | Oregon | 41027 | 2086 | 37 |
1929336 | 1929336 | 2021-11-18 | Hood River | Oregon | 41027 | 2077 | 37 |
1926086 | 1926086 | 2021-11-17 | Hood River | Oregon | 41027 | 2074 | 37 |
1922836 | 1922836 | 2021-11-16 | Hood River | Oregon | 41027 | 2056 | 37 |
1919587 | 1919587 | 2021-11-15 | Hood River | Oregon | 41027 | 2050 | 37 |
1916337 | 1916337 | 2021-11-14 | Hood River | Oregon | 41027 | 2043 | 37 |
1913087 | 1913087 | 2021-11-13 | Hood River | Oregon | 41027 | 2043 | 37 |
1909837 | 1909837 | 2021-11-12 | Hood River | Oregon | 41027 | 2043 | 37 |
1906588 | 1906588 | 2021-11-11 | Hood River | Oregon | 41027 | 2038 | 37 |
1903339 | 1903339 | 2021-11-10 | Hood River | Oregon | 41027 | 2038 | 37 |
1900089 | 1900089 | 2021-11-09 | Hood River | Oregon | 41027 | 2035 | 37 |
1896839 | 1896839 | 2021-11-08 | Hood River | Oregon | 41027 | 2019 | 37 |
1893589 | 1893589 | 2021-11-07 | Hood River | Oregon | 41027 | 2007 | 37 |
1890339 | 1890339 | 2021-11-06 | Hood River | Oregon | 41027 | 2007 | 37 |
1887089 | 1887089 | 2021-11-05 | Hood River | Oregon | 41027 | 2007 | 37 |
1883839 | 1883839 | 2021-11-04 | Hood River | Oregon | 41027 | 2002 | 37 |
1880590 | 1880590 | 2021-11-03 | Hood River | Oregon | 41027 | 1997 | 37 |
1877341 | 1877341 | 2021-11-02 | Hood River | Oregon | 41027 | 1992 | 37 |
1874092 | 1874092 | 2021-11-01 | Hood River | Oregon | 41027 | 1985 | 37 |
1870843 | 1870843 | 2021-10-31 | Hood River | Oregon | 41027 | 1973 | 37 |
1867594 | 1867594 | 2021-10-30 | Hood River | Oregon | 41027 | 1973 | 37 |
1864345 | 1864345 | 2021-10-29 | Hood River | Oregon | 41027 | 1973 | 37 |
1861096 | 1861096 | 2021-10-28 | Hood River | Oregon | 41027 | 1967 | 37 |
1857847 | 1857847 | 2021-10-27 | Hood River | Oregon | 41027 | 1966 | 37 |
1854598 | 1854598 | 2021-10-26 | Hood River | Oregon | 41027 | 1958 | 37 |
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);