ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Klamath" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176444 | 2176444 | 2022-02-02 | Klamath | Oregon | 41035 | 12881 | 182 |
2173190 | 2173190 | 2022-02-01 | Klamath | Oregon | 41035 | 12797 | 182 |
2169938 | 2169938 | 2022-01-31 | Klamath | Oregon | 41035 | 12719 | 181 |
2166683 | 2166683 | 2022-01-30 | Klamath | Oregon | 41035 | 12350 | 181 |
2163428 | 2163428 | 2022-01-29 | Klamath | Oregon | 41035 | 12350 | 181 |
2160173 | 2160173 | 2022-01-28 | Klamath | Oregon | 41035 | 12350 | 181 |
2156918 | 2156918 | 2022-01-27 | Klamath | Oregon | 41035 | 12159 | 181 |
2153665 | 2153665 | 2022-01-26 | Klamath | Oregon | 41035 | 12019 | 181 |
2150413 | 2150413 | 2022-01-25 | Klamath | Oregon | 41035 | 11864 | 179 |
2147161 | 2147161 | 2022-01-24 | Klamath | Oregon | 41035 | 11734 | 179 |
2143907 | 2143907 | 2022-01-23 | Klamath | Oregon | 41035 | 11286 | 179 |
2140652 | 2140652 | 2022-01-22 | Klamath | Oregon | 41035 | 11286 | 179 |
2137396 | 2137396 | 2022-01-21 | Klamath | Oregon | 41035 | 11286 | 179 |
2134142 | 2134142 | 2022-01-20 | Klamath | Oregon | 41035 | 11033 | 178 |
2130890 | 2130890 | 2022-01-19 | Klamath | Oregon | 41035 | 10887 | 178 |
2127636 | 2127636 | 2022-01-18 | Klamath | Oregon | 41035 | 10781 | 178 |
2124384 | 2124384 | 2022-01-17 | Klamath | Oregon | 41035 | 10267 | 178 |
2121132 | 2121132 | 2022-01-16 | Klamath | Oregon | 41035 | 10267 | 178 |
2117880 | 2117880 | 2022-01-15 | Klamath | Oregon | 41035 | 10267 | 178 |
2114629 | 2114629 | 2022-01-14 | Klamath | Oregon | 41035 | 10267 | 178 |
2111377 | 2111377 | 2022-01-13 | Klamath | Oregon | 41035 | 10146 | 178 |
2108125 | 2108125 | 2022-01-12 | Klamath | Oregon | 41035 | 10024 | 178 |
2104874 | 2104874 | 2022-01-11 | Klamath | Oregon | 41035 | 9955 | 175 |
2101623 | 2101623 | 2022-01-10 | Klamath | Oregon | 41035 | 9748 | 174 |
2098372 | 2098372 | 2022-01-09 | Klamath | Oregon | 41035 | 9666 | 172 |
2095120 | 2095120 | 2022-01-08 | Klamath | Oregon | 41035 | 9666 | 172 |
2091868 | 2091868 | 2022-01-07 | Klamath | Oregon | 41035 | 9666 | 172 |
2088616 | 2088616 | 2022-01-06 | Klamath | Oregon | 41035 | 9603 | 170 |
2085365 | 2085365 | 2022-01-05 | Klamath | Oregon | 41035 | 9533 | 170 |
2082113 | 2082113 | 2022-01-04 | Klamath | Oregon | 41035 | 9507 | 170 |
2078861 | 2078861 | 2022-01-03 | Klamath | Oregon | 41035 | 9421 | 168 |
2075610 | 2075610 | 2022-01-02 | Klamath | Oregon | 41035 | 9396 | 169 |
2072359 | 2072359 | 2022-01-01 | Klamath | Oregon | 41035 | 9396 | 169 |
2069108 | 2069108 | 2021-12-31 | Klamath | Oregon | 41035 | 9396 | 169 |
2065857 | 2065857 | 2021-12-30 | Klamath | Oregon | 41035 | 9396 | 169 |
2062607 | 2062607 | 2021-12-29 | Klamath | Oregon | 41035 | 9361 | 167 |
2059357 | 2059357 | 2021-12-28 | Klamath | Oregon | 41035 | 9347 | 167 |
2056108 | 2056108 | 2021-12-27 | Klamath | Oregon | 41035 | 9307 | 166 |
2052859 | 2052859 | 2021-12-26 | Klamath | Oregon | 41035 | 9289 | 164 |
2049609 | 2049609 | 2021-12-25 | Klamath | Oregon | 41035 | 9289 | 164 |
2046359 | 2046359 | 2021-12-24 | Klamath | Oregon | 41035 | 9289 | 164 |
2043109 | 2043109 | 2021-12-23 | Klamath | Oregon | 41035 | 9289 | 164 |
2039860 | 2039860 | 2021-12-22 | Klamath | Oregon | 41035 | 9280 | 164 |
2036610 | 2036610 | 2021-12-21 | Klamath | Oregon | 41035 | 9262 | 164 |
2033360 | 2033360 | 2021-12-20 | Klamath | Oregon | 41035 | 9243 | 163 |
2030110 | 2030110 | 2021-12-19 | Klamath | Oregon | 41035 | 9231 | 162 |
2026859 | 2026859 | 2021-12-18 | Klamath | Oregon | 41035 | 9231 | 162 |
2023608 | 2023608 | 2021-12-17 | Klamath | Oregon | 41035 | 9231 | 162 |
2020357 | 2020357 | 2021-12-16 | Klamath | Oregon | 41035 | 9221 | 162 |
2017106 | 2017106 | 2021-12-15 | Klamath | Oregon | 41035 | 9211 | 162 |
2013856 | 2013856 | 2021-12-14 | Klamath | Oregon | 41035 | 9193 | 160 |
2010605 | 2010605 | 2021-12-13 | Klamath | Oregon | 41035 | 9175 | 157 |
2007354 | 2007354 | 2021-12-12 | Klamath | Oregon | 41035 | 9171 | 156 |
2004103 | 2004103 | 2021-12-11 | Klamath | Oregon | 41035 | 9171 | 156 |
2000852 | 2000852 | 2021-12-10 | Klamath | Oregon | 41035 | 9171 | 156 |
1997602 | 1997602 | 2021-12-09 | Klamath | Oregon | 41035 | 9163 | 156 |
1994351 | 1994351 | 2021-12-08 | Klamath | Oregon | 41035 | 9149 | 153 |
1991100 | 1991100 | 2021-12-07 | Klamath | Oregon | 41035 | 9144 | 153 |
1987849 | 1987849 | 2021-12-06 | Klamath | Oregon | 41035 | 9120 | 152 |
1984599 | 1984599 | 2021-12-05 | Klamath | Oregon | 41035 | 9112 | 149 |
1981349 | 1981349 | 2021-12-04 | Klamath | Oregon | 41035 | 9112 | 149 |
1978099 | 1978099 | 2021-12-03 | Klamath | Oregon | 41035 | 9112 | 149 |
1974849 | 1974849 | 2021-12-02 | Klamath | Oregon | 41035 | 9090 | 149 |
1971600 | 1971600 | 2021-12-01 | Klamath | Oregon | 41035 | 9072 | 147 |
1968350 | 1968350 | 2021-11-30 | Klamath | Oregon | 41035 | 9053 | 146 |
1965099 | 1965099 | 2021-11-29 | Klamath | Oregon | 41035 | 9002 | 145 |
1961847 | 1961847 | 2021-11-28 | Klamath | Oregon | 41035 | 8979 | 145 |
1958596 | 1958596 | 2021-11-27 | Klamath | Oregon | 41035 | 8979 | 145 |
1955345 | 1955345 | 2021-11-26 | Klamath | Oregon | 41035 | 8979 | 145 |
1952094 | 1952094 | 2021-11-25 | Klamath | Oregon | 41035 | 8979 | 145 |
1948843 | 1948843 | 2021-11-24 | Klamath | Oregon | 41035 | 8979 | 145 |
1945592 | 1945592 | 2021-11-23 | Klamath | Oregon | 41035 | 8958 | 144 |
1942341 | 1942341 | 2021-11-22 | Klamath | Oregon | 41035 | 8918 | 141 |
1939091 | 1939091 | 2021-11-21 | Klamath | Oregon | 41035 | 8899 | 136 |
1935841 | 1935841 | 2021-11-20 | Klamath | Oregon | 41035 | 8899 | 136 |
1932591 | 1932591 | 2021-11-19 | Klamath | Oregon | 41035 | 8899 | 136 |
1929340 | 1929340 | 2021-11-18 | Klamath | Oregon | 41035 | 8864 | 135 |
1926090 | 1926090 | 2021-11-17 | Klamath | Oregon | 41035 | 8844 | 135 |
1922840 | 1922840 | 2021-11-16 | Klamath | Oregon | 41035 | 8813 | 135 |
1919591 | 1919591 | 2021-11-15 | Klamath | Oregon | 41035 | 8813 | 134 |
1916341 | 1916341 | 2021-11-14 | Klamath | Oregon | 41035 | 8760 | 133 |
1913091 | 1913091 | 2021-11-13 | Klamath | Oregon | 41035 | 8760 | 133 |
1909841 | 1909841 | 2021-11-12 | Klamath | Oregon | 41035 | 8760 | 133 |
1906592 | 1906592 | 2021-11-11 | Klamath | Oregon | 41035 | 8689 | 129 |
1903343 | 1903343 | 2021-11-10 | Klamath | Oregon | 41035 | 8689 | 129 |
1900093 | 1900093 | 2021-11-09 | Klamath | Oregon | 41035 | 8673 | 128 |
1896843 | 1896843 | 2021-11-08 | Klamath | Oregon | 41035 | 8574 | 127 |
1893593 | 1893593 | 2021-11-07 | Klamath | Oregon | 41035 | 8552 | 127 |
1890343 | 1890343 | 2021-11-06 | Klamath | Oregon | 41035 | 8552 | 127 |
1887093 | 1887093 | 2021-11-05 | Klamath | Oregon | 41035 | 8552 | 127 |
1883843 | 1883843 | 2021-11-04 | Klamath | Oregon | 41035 | 8513 | 127 |
1880594 | 1880594 | 2021-11-03 | Klamath | Oregon | 41035 | 8475 | 124 |
1877345 | 1877345 | 2021-11-02 | Klamath | Oregon | 41035 | 8453 | 123 |
1874096 | 1874096 | 2021-11-01 | Klamath | Oregon | 41035 | 8345 | 123 |
1870847 | 1870847 | 2021-10-31 | Klamath | Oregon | 41035 | 8293 | 123 |
1867598 | 1867598 | 2021-10-30 | Klamath | Oregon | 41035 | 8293 | 123 |
1864349 | 1864349 | 2021-10-29 | Klamath | Oregon | 41035 | 8293 | 123 |
1861100 | 1861100 | 2021-10-28 | Klamath | Oregon | 41035 | 8256 | 122 |
1857851 | 1857851 | 2021-10-27 | Klamath | Oregon | 41035 | 8194 | 122 |
1854602 | 1854602 | 2021-10-26 | Klamath | Oregon | 41035 | 8146 | 122 |
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);