ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
178 rows where deaths = 32 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2355325 | 2355325 | 2022-03-29 | Morrow | Oregon | 41049 | 2950 | 32 |
2352072 | 2352072 | 2022-03-28 | Morrow | Oregon | 41049 | 2950 | 32 |
2348820 | 2348820 | 2022-03-27 | Morrow | Oregon | 41049 | 2950 | 32 |
2345567 | 2345567 | 2022-03-26 | Morrow | Oregon | 41049 | 2950 | 32 |
2342314 | 2342314 | 2022-03-25 | Morrow | Oregon | 41049 | 2950 | 32 |
2339061 | 2339061 | 2022-03-24 | Morrow | Oregon | 41049 | 2950 | 32 |
2335807 | 2335807 | 2022-03-23 | Morrow | Oregon | 41049 | 2950 | 32 |
2332553 | 2332553 | 2022-03-22 | Morrow | Oregon | 41049 | 2950 | 32 |
2329300 | 2329300 | 2022-03-21 | Morrow | Oregon | 41049 | 2950 | 32 |
2326048 | 2326048 | 2022-03-20 | Morrow | Oregon | 41049 | 2950 | 32 |
2322795 | 2322795 | 2022-03-19 | Morrow | Oregon | 41049 | 2950 | 32 |
2319541 | 2319541 | 2022-03-18 | Morrow | Oregon | 41049 | 2950 | 32 |
2316287 | 2316287 | 2022-03-17 | Morrow | Oregon | 41049 | 2947 | 32 |
2313034 | 2313034 | 2022-03-16 | Morrow | Oregon | 41049 | 2947 | 32 |
2309781 | 2309781 | 2022-03-15 | Morrow | Oregon | 41049 | 2946 | 32 |
2306528 | 2306528 | 2022-03-14 | Morrow | Oregon | 41049 | 2946 | 32 |
2303277 | 2303277 | 2022-03-13 | Morrow | Oregon | 41049 | 2946 | 32 |
2300025 | 2300025 | 2022-03-12 | Morrow | Oregon | 41049 | 2946 | 32 |
2296773 | 2296773 | 2022-03-11 | Morrow | Oregon | 41049 | 2946 | 32 |
2293521 | 2293521 | 2022-03-10 | Morrow | Oregon | 41049 | 2946 | 32 |
2290269 | 2290269 | 2022-03-09 | Morrow | Oregon | 41049 | 2946 | 32 |
1965094 | 1965094 | 2021-11-29 | Harney | Oregon | 41025 | 1195 | 32 |
1961842 | 1961842 | 2021-11-28 | Harney | Oregon | 41025 | 1193 | 32 |
1958591 | 1958591 | 2021-11-27 | Harney | Oregon | 41025 | 1193 | 32 |
1955340 | 1955340 | 2021-11-26 | Harney | Oregon | 41025 | 1193 | 32 |
1952089 | 1952089 | 2021-11-25 | Harney | Oregon | 41025 | 1193 | 32 |
1948838 | 1948838 | 2021-11-24 | Harney | Oregon | 41025 | 1193 | 32 |
1919577 | 1919577 | 2021-11-15 | Clatsop | Oregon | 41007 | 2539 | 32 |
1916327 | 1916327 | 2021-11-14 | Clatsop | Oregon | 41007 | 2529 | 32 |
1916331 | 1916331 | 2021-11-14 | Curry | Oregon | 41015 | 1860 | 32 |
1913077 | 1913077 | 2021-11-13 | Clatsop | Oregon | 41007 | 2529 | 32 |
1913081 | 1913081 | 2021-11-13 | Curry | Oregon | 41015 | 1860 | 32 |
1909827 | 1909827 | 2021-11-12 | Clatsop | Oregon | 41007 | 2529 | 32 |
1909831 | 1909831 | 2021-11-12 | Curry | Oregon | 41015 | 1860 | 32 |
1906578 | 1906578 | 2021-11-11 | Clatsop | Oregon | 41007 | 2520 | 32 |
1906582 | 1906582 | 2021-11-11 | Curry | Oregon | 41015 | 1857 | 32 |
1903329 | 1903329 | 2021-11-10 | Clatsop | Oregon | 41007 | 2520 | 32 |
1903333 | 1903333 | 2021-11-10 | Curry | Oregon | 41015 | 1857 | 32 |
1900077 | 1900077 | 2021-11-09 | Benton | Oregon | 41003 | 5836 | 32 |
1851364 | 1851364 | 2021-10-25 | Tillamook | Oregon | 41057 | 1979 | 32 |
1848114 | 1848114 | 2021-10-24 | Tillamook | Oregon | 41057 | 1969 | 32 |
1844864 | 1844864 | 2021-10-23 | Tillamook | Oregon | 41057 | 1969 | 32 |
1841614 | 1841614 | 2021-10-22 | Tillamook | Oregon | 41057 | 1969 | 32 |
1838365 | 1838365 | 2021-10-21 | Tillamook | Oregon | 41057 | 1964 | 32 |
1802617 | 1802617 | 2021-10-10 | Lincoln | Oregon | 41041 | 3026 | 32 |
1799368 | 1799368 | 2021-10-09 | Lincoln | Oregon | 41041 | 3026 | 32 |
1796119 | 1796119 | 2021-10-08 | Lincoln | Oregon | 41041 | 3026 | 32 |
1792870 | 1792870 | 2021-10-07 | Lincoln | Oregon | 41041 | 3016 | 32 |
1789621 | 1789621 | 2021-10-06 | Lincoln | Oregon | 41041 | 3007 | 32 |
1701889 | 1701889 | 2021-09-09 | Crook | Oregon | 41013 | 1957 | 32 |
1698640 | 1698640 | 2021-09-08 | Crook | Oregon | 41013 | 1919 | 32 |
1695392 | 1695392 | 2021-09-07 | Crook | Oregon | 41013 | 1889 | 32 |
1692144 | 1692144 | 2021-09-06 | Crook | Oregon | 41013 | 1874 | 32 |
1688895 | 1688895 | 2021-09-05 | Crook | Oregon | 41013 | 1874 | 32 |
1685645 | 1685645 | 2021-09-04 | Crook | Oregon | 41013 | 1874 | 32 |
1682394 | 1682394 | 2021-09-03 | Crook | Oregon | 41013 | 1874 | 32 |
1679144 | 1679144 | 2021-09-02 | Crook | Oregon | 41013 | 1858 | 32 |
1675896 | 1675896 | 2021-09-01 | Crook | Oregon | 41013 | 1833 | 32 |
1672649 | 1672649 | 2021-08-31 | Crook | Oregon | 41013 | 1814 | 32 |
1672673 | 1672673 | 2021-08-31 | Union | Oregon | 41061 | 2323 | 32 |
1607684 | 1607684 | 2021-08-11 | Columbia | Oregon | 41009 | 2274 | 32 |
1604435 | 1604435 | 2021-08-10 | Columbia | Oregon | 41009 | 2192 | 32 |
1601186 | 1601186 | 2021-08-09 | Columbia | Oregon | 41009 | 2186 | 32 |
1601214 | 1601214 | 2021-08-09 | Wasco | Oregon | 41065 | 1665 | 32 |
1597938 | 1597938 | 2021-08-08 | Columbia | Oregon | 41009 | 2169 | 32 |
1594689 | 1594689 | 2021-08-07 | Columbia | Oregon | 41009 | 2169 | 32 |
1591440 | 1591440 | 2021-08-06 | Columbia | Oregon | 41009 | 2169 | 32 |
1588191 | 1588191 | 2021-08-05 | Columbia | Oregon | 41009 | 2166 | 32 |
1584941 | 1584941 | 2021-08-04 | Columbia | Oregon | 41009 | 2137 | 32 |
1581691 | 1581691 | 2021-08-03 | Columbia | Oregon | 41009 | 2124 | 32 |
1578442 | 1578442 | 2021-08-02 | Columbia | Oregon | 41009 | 2108 | 32 |
1575194 | 1575194 | 2021-08-01 | Columbia | Oregon | 41009 | 2087 | 32 |
1571946 | 1571946 | 2021-07-31 | Columbia | Oregon | 41009 | 2087 | 32 |
1568698 | 1568698 | 2021-07-30 | Columbia | Oregon | 41009 | 2087 | 32 |
1565450 | 1565450 | 2021-07-29 | Columbia | Oregon | 41009 | 2081 | 32 |
1562202 | 1562202 | 2021-07-28 | Columbia | Oregon | 41009 | 2076 | 32 |
1558954 | 1558954 | 2021-07-27 | Columbia | Oregon | 41009 | 2067 | 32 |
1555707 | 1555707 | 2021-07-26 | Columbia | Oregon | 41009 | 2054 | 32 |
1552460 | 1552460 | 2021-07-25 | Columbia | Oregon | 41009 | 2047 | 32 |
1549213 | 1549213 | 2021-07-24 | Columbia | Oregon | 41009 | 2047 | 32 |
1545966 | 1545966 | 2021-07-23 | Columbia | Oregon | 41009 | 2047 | 32 |
1542719 | 1542719 | 2021-07-22 | Columbia | Oregon | 41009 | 2037 | 32 |
1539471 | 1539471 | 2021-07-21 | Columbia | Oregon | 41009 | 2029 | 32 |
1536224 | 1536224 | 2021-07-20 | Columbia | Oregon | 41009 | 2021 | 32 |
1532976 | 1532976 | 2021-07-19 | Columbia | Oregon | 41009 | 2008 | 32 |
1529729 | 1529729 | 2021-07-18 | Columbia | Oregon | 41009 | 2001 | 32 |
1526482 | 1526482 | 2021-07-17 | Columbia | Oregon | 41009 | 2001 | 32 |
1523235 | 1523235 | 2021-07-16 | Columbia | Oregon | 41009 | 2001 | 32 |
1519987 | 1519987 | 2021-07-15 | Columbia | Oregon | 41009 | 1994 | 32 |
1516739 | 1516739 | 2021-07-14 | Columbia | Oregon | 41009 | 1986 | 32 |
1513492 | 1513492 | 2021-07-13 | Columbia | Oregon | 41009 | 1984 | 32 |
1399896 | 1399896 | 2021-06-08 | Hood River | Oregon | 41027 | 1210 | 32 |
1396651 | 1396651 | 2021-06-07 | Hood River | Oregon | 41027 | 1210 | 32 |
1393404 | 1393404 | 2021-06-06 | Hood River | Oregon | 41027 | 1210 | 32 |
1390159 | 1390159 | 2021-06-05 | Hood River | Oregon | 41027 | 1210 | 32 |
1386914 | 1386914 | 2021-06-04 | Hood River | Oregon | 41027 | 1207 | 32 |
1383669 | 1383669 | 2021-06-03 | Hood River | Oregon | 41027 | 1207 | 32 |
1380423 | 1380423 | 2021-06-02 | Hood River | Oregon | 41027 | 1205 | 32 |
1377178 | 1377178 | 2021-06-01 | Hood River | Oregon | 41027 | 1204 | 32 |
1373932 | 1373932 | 2021-05-31 | Hood River | Oregon | 41027 | 1204 | 32 |
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);