ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where deaths = 39 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 |
---|---|---|---|---|---|---|---|
2309760 | 2309760 | 2022-03-15 | Clatsop | Oregon | 41007 | 4553 | 39 |
2286996 | 2286996 | 2022-03-08 | Clatsop | Oregon | 41007 | 4538 | 39 |
2283744 | 2283744 | 2022-03-07 | Clatsop | Oregon | 41007 | 4536 | 39 |
2280492 | 2280492 | 2022-03-06 | Clatsop | Oregon | 41007 | 4527 | 39 |
2277239 | 2277239 | 2022-03-05 | Clatsop | Oregon | 41007 | 4527 | 39 |
2273986 | 2273986 | 2022-03-04 | Clatsop | Oregon | 41007 | 4527 | 39 |
2270733 | 2270733 | 2022-03-03 | Clatsop | Oregon | 41007 | 4527 | 39 |
2147157 | 2147157 | 2022-01-24 | Hood River | Oregon | 41027 | 2930 | 39 |
2036600 | 2036600 | 2021-12-21 | Curry | Oregon | 41015 | 1974 | 39 |
2033350 | 2033350 | 2021-12-20 | Curry | Oregon | 41015 | 1970 | 39 |
2030100 | 2030100 | 2021-12-19 | Curry | Oregon | 41015 | 1966 | 39 |
2026849 | 2026849 | 2021-12-18 | Curry | Oregon | 41015 | 1966 | 39 |
2023598 | 2023598 | 2021-12-17 | Curry | Oregon | 41015 | 1966 | 39 |
2020347 | 2020347 | 2021-12-16 | Curry | Oregon | 41015 | 1965 | 39 |
2017096 | 2017096 | 2021-12-15 | Curry | Oregon | 41015 | 1961 | 39 |
2013846 | 2013846 | 2021-12-14 | Curry | Oregon | 41015 | 1954 | 39 |
2010595 | 2010595 | 2021-12-13 | Curry | Oregon | 41015 | 1949 | 39 |
2007344 | 2007344 | 2021-12-12 | Curry | Oregon | 41015 | 1947 | 39 |
2004093 | 2004093 | 2021-12-11 | Curry | Oregon | 41015 | 1947 | 39 |
2000842 | 2000842 | 2021-12-10 | Curry | Oregon | 41015 | 1947 | 39 |
1997592 | 1997592 | 2021-12-09 | Curry | Oregon | 41015 | 1946 | 39 |
1994341 | 1994341 | 2021-12-08 | Curry | Oregon | 41015 | 1946 | 39 |
1991090 | 1991090 | 2021-12-07 | Curry | Oregon | 41015 | 1946 | 39 |
1987839 | 1987839 | 2021-12-06 | Curry | Oregon | 41015 | 1942 | 39 |
1984589 | 1984589 | 2021-12-05 | Curry | Oregon | 41015 | 1939 | 39 |
1981339 | 1981339 | 2021-12-04 | Curry | Oregon | 41015 | 1939 | 39 |
1978089 | 1978089 | 2021-12-03 | Curry | Oregon | 41015 | 1939 | 39 |
1974839 | 1974839 | 2021-12-02 | Curry | Oregon | 41015 | 1931 | 39 |
1971590 | 1971590 | 2021-12-01 | Curry | Oregon | 41015 | 1924 | 39 |
1968340 | 1968340 | 2021-11-30 | Curry | Oregon | 41015 | 1919 | 39 |
1965089 | 1965089 | 2021-11-29 | Curry | Oregon | 41015 | 1910 | 39 |
1900104 | 1900104 | 2021-11-09 | Tillamook | Oregon | 41057 | 2081 | 39 |
1896854 | 1896854 | 2021-11-08 | Tillamook | Oregon | 41057 | 2074 | 39 |
1854605 | 1854605 | 2021-10-26 | Lincoln | Oregon | 41041 | 3241 | 39 |
1851356 | 1851356 | 2021-10-25 | Lincoln | Oregon | 41041 | 3242 | 39 |
1848106 | 1848106 | 2021-10-24 | Lincoln | Oregon | 41041 | 3199 | 39 |
1844856 | 1844856 | 2021-10-23 | Lincoln | Oregon | 41041 | 3199 | 39 |
1841606 | 1841606 | 2021-10-22 | Lincoln | Oregon | 41041 | 3199 | 39 |
1838357 | 1838357 | 2021-10-21 | Lincoln | Oregon | 41041 | 3180 | 39 |
1812378 | 1812378 | 2021-10-13 | Wasco | Oregon | 41065 | 2773 | 39 |
1809129 | 1809129 | 2021-10-12 | Wasco | Oregon | 41065 | 2758 | 39 |
1805879 | 1805879 | 2021-10-11 | Wasco | Oregon | 41065 | 2731 | 39 |
1802629 | 1802629 | 2021-10-10 | Wasco | Oregon | 41065 | 2719 | 39 |
1799380 | 1799380 | 2021-10-09 | Wasco | Oregon | 41065 | 2719 | 39 |
1796131 | 1796131 | 2021-10-08 | Wasco | Oregon | 41065 | 2719 | 39 |
1792882 | 1792882 | 2021-10-07 | Wasco | Oregon | 41065 | 2708 | 39 |
1789605 | 1789605 | 2021-10-06 | Columbia | Oregon | 41009 | 3559 | 39 |
1789633 | 1789633 | 2021-10-06 | Wasco | Oregon | 41065 | 2696 | 39 |
1786357 | 1786357 | 2021-10-05 | Columbia | Oregon | 41009 | 3552 | 39 |
1786385 | 1786385 | 2021-10-05 | Wasco | Oregon | 41065 | 2685 | 39 |
1783108 | 1783108 | 2021-10-04 | Columbia | Oregon | 41009 | 3537 | 39 |
1783136 | 1783136 | 2021-10-04 | Wasco | Oregon | 41065 | 2657 | 39 |
1779859 | 1779859 | 2021-10-03 | Columbia | Oregon | 41009 | 3488 | 39 |
1779887 | 1779887 | 2021-10-03 | Wasco | Oregon | 41065 | 2618 | 39 |
1776609 | 1776609 | 2021-10-02 | Columbia | Oregon | 41009 | 3488 | 39 |
1776637 | 1776637 | 2021-10-02 | Wasco | Oregon | 41065 | 2618 | 39 |
1773359 | 1773359 | 2021-10-01 | Columbia | Oregon | 41009 | 3488 | 39 |
1773387 | 1773387 | 2021-10-01 | Wasco | Oregon | 41065 | 2618 | 39 |
1770109 | 1770109 | 2021-09-30 | Columbia | Oregon | 41009 | 3462 | 39 |
1770111 | 1770111 | 2021-09-30 | Crook | Oregon | 41013 | 2330 | 39 |
1770135 | 1770135 | 2021-09-30 | Union | Oregon | 41061 | 2942 | 39 |
1770137 | 1770137 | 2021-09-30 | Wasco | Oregon | 41065 | 2597 | 39 |
1766860 | 1766860 | 2021-09-29 | Columbia | Oregon | 41009 | 3429 | 39 |
1766862 | 1766862 | 2021-09-29 | Crook | Oregon | 41013 | 2296 | 39 |
1766886 | 1766886 | 2021-09-29 | Union | Oregon | 41061 | 2918 | 39 |
1766888 | 1766888 | 2021-09-29 | Wasco | Oregon | 41065 | 2553 | 39 |
1763611 | 1763611 | 2021-09-28 | Columbia | Oregon | 41009 | 3405 | 39 |
1763613 | 1763613 | 2021-09-28 | Crook | Oregon | 41013 | 2272 | 39 |
1763637 | 1763637 | 2021-09-28 | Union | Oregon | 41061 | 2886 | 39 |
1763639 | 1763639 | 2021-09-28 | Wasco | Oregon | 41065 | 2527 | 39 |
1760362 | 1760362 | 2021-09-27 | Columbia | Oregon | 41009 | 3390 | 39 |
1760364 | 1760364 | 2021-09-27 | Crook | Oregon | 41013 | 2249 | 39 |
1760390 | 1760390 | 2021-09-27 | Wasco | Oregon | 41065 | 2501 | 39 |
1757114 | 1757114 | 2021-09-26 | Columbia | Oregon | 41009 | 3335 | 39 |
1757116 | 1757116 | 2021-09-26 | Crook | Oregon | 41013 | 2206 | 39 |
1757142 | 1757142 | 2021-09-26 | Wasco | Oregon | 41065 | 2481 | 39 |
1753866 | 1753866 | 2021-09-25 | Columbia | Oregon | 41009 | 3335 | 39 |
1753868 | 1753868 | 2021-09-25 | Crook | Oregon | 41013 | 2206 | 39 |
1753894 | 1753894 | 2021-09-25 | Wasco | Oregon | 41065 | 2481 | 39 |
1750618 | 1750618 | 2021-09-24 | Columbia | Oregon | 41009 | 3335 | 39 |
1750620 | 1750620 | 2021-09-24 | Crook | Oregon | 41013 | 2206 | 39 |
1750646 | 1750646 | 2021-09-24 | Wasco | Oregon | 41065 | 2481 | 39 |
1747368 | 1747368 | 2021-09-23 | Columbia | Oregon | 41009 | 3305 | 39 |
1747370 | 1747370 | 2021-09-23 | Crook | Oregon | 41013 | 2168 | 39 |
1747397 | 1747397 | 2021-09-23 | Wasco | Oregon | 41065 | 2456 | 39 |
1744119 | 1744119 | 2021-09-22 | Columbia | Oregon | 41009 | 3288 | 39 |
1744121 | 1744121 | 2021-09-22 | Crook | Oregon | 41013 | 2148 | 39 |
1744147 | 1744147 | 2021-09-22 | Wasco | Oregon | 41065 | 2441 | 39 |
1740870 | 1740870 | 2021-09-21 | Columbia | Oregon | 41009 | 3254 | 39 |
1740872 | 1740872 | 2021-09-21 | Crook | Oregon | 41013 | 2136 | 39 |
1740898 | 1740898 | 2021-09-21 | Wasco | Oregon | 41065 | 2423 | 39 |
1737649 | 1737649 | 2021-09-20 | Wasco | Oregon | 41065 | 2390 | 39 |
1734399 | 1734399 | 2021-09-19 | Wasco | Oregon | 41065 | 2367 | 39 |
1731149 | 1731149 | 2021-09-18 | Wasco | Oregon | 41065 | 2367 | 39 |
1727899 | 1727899 | 2021-09-17 | Wasco | Oregon | 41065 | 2367 | 39 |
1724650 | 1724650 | 2021-09-16 | Wasco | Oregon | 41065 | 2337 | 39 |
1721401 | 1721401 | 2021-09-15 | Wasco | Oregon | 41065 | 2319 | 39 |
1581692 | 1581692 | 2021-08-03 | Coos | Oregon | 41011 | 2376 | 39 |
1578443 | 1578443 | 2021-08-02 | Coos | Oregon | 41011 | 2341 | 39 |
1575195 | 1575195 | 2021-08-01 | Coos | Oregon | 41011 | 2319 | 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);