ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Coos" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176432 | 2176432 | 2022-02-02 | Coos | Oregon | 41011 | 9614 | 132 |
2173178 | 2173178 | 2022-02-01 | Coos | Oregon | 41011 | 9522 | 132 |
2169926 | 2169926 | 2022-01-31 | Coos | Oregon | 41011 | 9429 | 131 |
2166671 | 2166671 | 2022-01-30 | Coos | Oregon | 41011 | 9270 | 130 |
2163416 | 2163416 | 2022-01-29 | Coos | Oregon | 41011 | 9270 | 130 |
2160161 | 2160161 | 2022-01-28 | Coos | Oregon | 41011 | 9270 | 130 |
2156906 | 2156906 | 2022-01-27 | Coos | Oregon | 41011 | 9153 | 130 |
2153653 | 2153653 | 2022-01-26 | Coos | Oregon | 41011 | 9006 | 130 |
2150401 | 2150401 | 2022-01-25 | Coos | Oregon | 41011 | 8848 | 130 |
2147149 | 2147149 | 2022-01-24 | Coos | Oregon | 41011 | 8765 | 129 |
2143895 | 2143895 | 2022-01-23 | Coos | Oregon | 41011 | 8563 | 128 |
2140640 | 2140640 | 2022-01-22 | Coos | Oregon | 41011 | 8563 | 128 |
2137384 | 2137384 | 2022-01-21 | Coos | Oregon | 41011 | 8563 | 128 |
2134130 | 2134130 | 2022-01-20 | Coos | Oregon | 41011 | 8365 | 128 |
2130878 | 2130878 | 2022-01-19 | Coos | Oregon | 41011 | 8224 | 128 |
2127624 | 2127624 | 2022-01-18 | Coos | Oregon | 41011 | 8111 | 128 |
2124372 | 2124372 | 2022-01-17 | Coos | Oregon | 41011 | 7772 | 128 |
2121120 | 2121120 | 2022-01-16 | Coos | Oregon | 41011 | 7772 | 128 |
2117868 | 2117868 | 2022-01-15 | Coos | Oregon | 41011 | 7772 | 128 |
2114617 | 2114617 | 2022-01-14 | Coos | Oregon | 41011 | 7772 | 128 |
2111365 | 2111365 | 2022-01-13 | Coos | Oregon | 41011 | 7596 | 127 |
2108113 | 2108113 | 2022-01-12 | Coos | Oregon | 41011 | 7468 | 127 |
2104862 | 2104862 | 2022-01-11 | Coos | Oregon | 41011 | 7225 | 127 |
2101611 | 2101611 | 2022-01-10 | Coos | Oregon | 41011 | 7133 | 125 |
2098360 | 2098360 | 2022-01-09 | Coos | Oregon | 41011 | 6922 | 124 |
2095108 | 2095108 | 2022-01-08 | Coos | Oregon | 41011 | 6922 | 124 |
2091856 | 2091856 | 2022-01-07 | Coos | Oregon | 41011 | 6922 | 124 |
2088604 | 2088604 | 2022-01-06 | Coos | Oregon | 41011 | 6797 | 123 |
2085353 | 2085353 | 2022-01-05 | Coos | Oregon | 41011 | 6578 | 123 |
2082101 | 2082101 | 2022-01-04 | Coos | Oregon | 41011 | 6443 | 122 |
2078849 | 2078849 | 2022-01-03 | Coos | Oregon | 41011 | 6439 | 122 |
2075598 | 2075598 | 2022-01-02 | Coos | Oregon | 41011 | 6396 | 122 |
2072347 | 2072347 | 2022-01-01 | Coos | Oregon | 41011 | 6396 | 122 |
2069096 | 2069096 | 2021-12-31 | Coos | Oregon | 41011 | 6396 | 122 |
2065845 | 2065845 | 2021-12-30 | Coos | Oregon | 41011 | 6396 | 122 |
2062595 | 2062595 | 2021-12-29 | Coos | Oregon | 41011 | 6358 | 119 |
2059345 | 2059345 | 2021-12-28 | Coos | Oregon | 41011 | 6322 | 118 |
2056096 | 2056096 | 2021-12-27 | Coos | Oregon | 41011 | 6227 | 118 |
2052847 | 2052847 | 2021-12-26 | Coos | Oregon | 41011 | 6201 | 118 |
2049597 | 2049597 | 2021-12-25 | Coos | Oregon | 41011 | 6201 | 118 |
2046347 | 2046347 | 2021-12-24 | Coos | Oregon | 41011 | 6201 | 118 |
2043097 | 2043097 | 2021-12-23 | Coos | Oregon | 41011 | 6201 | 118 |
2039848 | 2039848 | 2021-12-22 | Coos | Oregon | 41011 | 6184 | 118 |
2036598 | 2036598 | 2021-12-21 | Coos | Oregon | 41011 | 6160 | 117 |
2033348 | 2033348 | 2021-12-20 | Coos | Oregon | 41011 | 6138 | 115 |
2030098 | 2030098 | 2021-12-19 | Coos | Oregon | 41011 | 6101 | 115 |
2026847 | 2026847 | 2021-12-18 | Coos | Oregon | 41011 | 6101 | 115 |
2023596 | 2023596 | 2021-12-17 | Coos | Oregon | 41011 | 6101 | 115 |
2020345 | 2020345 | 2021-12-16 | Coos | Oregon | 41011 | 6085 | 114 |
2017094 | 2017094 | 2021-12-15 | Coos | Oregon | 41011 | 6058 | 114 |
2013844 | 2013844 | 2021-12-14 | Coos | Oregon | 41011 | 6037 | 113 |
2010593 | 2010593 | 2021-12-13 | Coos | Oregon | 41011 | 5994 | 113 |
2007342 | 2007342 | 2021-12-12 | Coos | Oregon | 41011 | 5952 | 113 |
2004091 | 2004091 | 2021-12-11 | Coos | Oregon | 41011 | 5952 | 113 |
2000840 | 2000840 | 2021-12-10 | Coos | Oregon | 41011 | 5952 | 113 |
1997590 | 1997590 | 2021-12-09 | Coos | Oregon | 41011 | 5913 | 110 |
1994339 | 1994339 | 2021-12-08 | Coos | Oregon | 41011 | 5878 | 109 |
1991088 | 1991088 | 2021-12-07 | Coos | Oregon | 41011 | 5854 | 109 |
1987837 | 1987837 | 2021-12-06 | Coos | Oregon | 41011 | 5806 | 109 |
1984587 | 1984587 | 2021-12-05 | Coos | Oregon | 41011 | 5768 | 109 |
1981337 | 1981337 | 2021-12-04 | Coos | Oregon | 41011 | 5768 | 109 |
1978087 | 1978087 | 2021-12-03 | Coos | Oregon | 41011 | 5768 | 109 |
1974837 | 1974837 | 2021-12-02 | Coos | Oregon | 41011 | 5728 | 108 |
1971588 | 1971588 | 2021-12-01 | Coos | Oregon | 41011 | 5693 | 107 |
1968338 | 1968338 | 2021-11-30 | Coos | Oregon | 41011 | 5664 | 106 |
1965087 | 1965087 | 2021-11-29 | Coos | Oregon | 41011 | 5600 | 106 |
1961835 | 1961835 | 2021-11-28 | Coos | Oregon | 41011 | 5573 | 106 |
1958584 | 1958584 | 2021-11-27 | Coos | Oregon | 41011 | 5573 | 106 |
1955333 | 1955333 | 2021-11-26 | Coos | Oregon | 41011 | 5573 | 106 |
1952082 | 1952082 | 2021-11-25 | Coos | Oregon | 41011 | 5573 | 106 |
1948831 | 1948831 | 2021-11-24 | Coos | Oregon | 41011 | 5573 | 106 |
1945580 | 1945580 | 2021-11-23 | Coos | Oregon | 41011 | 5560 | 104 |
1942329 | 1942329 | 2021-11-22 | Coos | Oregon | 41011 | 5539 | 104 |
1939079 | 1939079 | 2021-11-21 | Coos | Oregon | 41011 | 5509 | 104 |
1935829 | 1935829 | 2021-11-20 | Coos | Oregon | 41011 | 5509 | 104 |
1932579 | 1932579 | 2021-11-19 | Coos | Oregon | 41011 | 5509 | 104 |
1929328 | 1929328 | 2021-11-18 | Coos | Oregon | 41011 | 5488 | 104 |
1926078 | 1926078 | 2021-11-17 | Coos | Oregon | 41011 | 5473 | 104 |
1922828 | 1922828 | 2021-11-16 | Coos | Oregon | 41011 | 5449 | 104 |
1919579 | 1919579 | 2021-11-15 | Coos | Oregon | 41011 | 5415 | 103 |
1916329 | 1916329 | 2021-11-14 | Coos | Oregon | 41011 | 5387 | 103 |
1913079 | 1913079 | 2021-11-13 | Coos | Oregon | 41011 | 5387 | 103 |
1909829 | 1909829 | 2021-11-12 | Coos | Oregon | 41011 | 5387 | 103 |
1906580 | 1906580 | 2021-11-11 | Coos | Oregon | 41011 | 5376 | 103 |
1903331 | 1903331 | 2021-11-10 | Coos | Oregon | 41011 | 5376 | 103 |
1900081 | 1900081 | 2021-11-09 | Coos | Oregon | 41011 | 5353 | 101 |
1896831 | 1896831 | 2021-11-08 | Coos | Oregon | 41011 | 5332 | 100 |
1893581 | 1893581 | 2021-11-07 | Coos | Oregon | 41011 | 5294 | 98 |
1890331 | 1890331 | 2021-11-06 | Coos | Oregon | 41011 | 5294 | 98 |
1887081 | 1887081 | 2021-11-05 | Coos | Oregon | 41011 | 5294 | 98 |
1883831 | 1883831 | 2021-11-04 | Coos | Oregon | 41011 | 5274 | 98 |
1880582 | 1880582 | 2021-11-03 | Coos | Oregon | 41011 | 5248 | 96 |
1877333 | 1877333 | 2021-11-02 | Coos | Oregon | 41011 | 5222 | 96 |
1874084 | 1874084 | 2021-11-01 | Coos | Oregon | 41011 | 5198 | 96 |
1870835 | 1870835 | 2021-10-31 | Coos | Oregon | 41011 | 5165 | 96 |
1867586 | 1867586 | 2021-10-30 | Coos | Oregon | 41011 | 5165 | 96 |
1864337 | 1864337 | 2021-10-29 | Coos | Oregon | 41011 | 5165 | 96 |
1861088 | 1861088 | 2021-10-28 | Coos | Oregon | 41011 | 5145 | 96 |
1857839 | 1857839 | 2021-10-27 | Coos | Oregon | 41011 | 5123 | 96 |
1854590 | 1854590 | 2021-10-26 | Coos | Oregon | 41011 | 5102 | 95 |
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);