ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 41033 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176443 | 2176443 | 2022-02-02 | Josephine | Oregon | 41033 | 14653 | 303 |
2173189 | 2173189 | 2022-02-01 | Josephine | Oregon | 41033 | 14529 | 302 |
2169937 | 2169937 | 2022-01-31 | Josephine | Oregon | 41033 | 14451 | 296 |
2166682 | 2166682 | 2022-01-30 | Josephine | Oregon | 41033 | 14190 | 296 |
2163427 | 2163427 | 2022-01-29 | Josephine | Oregon | 41033 | 14190 | 296 |
2160172 | 2160172 | 2022-01-28 | Josephine | Oregon | 41033 | 14190 | 296 |
2156917 | 2156917 | 2022-01-27 | Josephine | Oregon | 41033 | 14040 | 296 |
2153664 | 2153664 | 2022-01-26 | Josephine | Oregon | 41033 | 13899 | 296 |
2150412 | 2150412 | 2022-01-25 | Josephine | Oregon | 41033 | 13676 | 293 |
2147160 | 2147160 | 2022-01-24 | Josephine | Oregon | 41033 | 13575 | 291 |
2143906 | 2143906 | 2022-01-23 | Josephine | Oregon | 41033 | 13233 | 291 |
2140651 | 2140651 | 2022-01-22 | Josephine | Oregon | 41033 | 13233 | 291 |
2137395 | 2137395 | 2022-01-21 | Josephine | Oregon | 41033 | 13233 | 291 |
2134141 | 2134141 | 2022-01-20 | Josephine | Oregon | 41033 | 12992 | 291 |
2130889 | 2130889 | 2022-01-19 | Josephine | Oregon | 41033 | 12835 | 290 |
2127635 | 2127635 | 2022-01-18 | Josephine | Oregon | 41033 | 12651 | 289 |
2124383 | 2124383 | 2022-01-17 | Josephine | Oregon | 41033 | 12201 | 284 |
2121131 | 2121131 | 2022-01-16 | Josephine | Oregon | 41033 | 12201 | 284 |
2117879 | 2117879 | 2022-01-15 | Josephine | Oregon | 41033 | 12201 | 284 |
2114628 | 2114628 | 2022-01-14 | Josephine | Oregon | 41033 | 12201 | 284 |
2111376 | 2111376 | 2022-01-13 | Josephine | Oregon | 41033 | 12052 | 281 |
2108124 | 2108124 | 2022-01-12 | Josephine | Oregon | 41033 | 11928 | 281 |
2104873 | 2104873 | 2022-01-11 | Josephine | Oregon | 41033 | 11771 | 279 |
2101622 | 2101622 | 2022-01-10 | Josephine | Oregon | 41033 | 11696 | 276 |
2098371 | 2098371 | 2022-01-09 | Josephine | Oregon | 41033 | 11496 | 274 |
2095119 | 2095119 | 2022-01-08 | Josephine | Oregon | 41033 | 11496 | 274 |
2091867 | 2091867 | 2022-01-07 | Josephine | Oregon | 41033 | 11496 | 274 |
2088615 | 2088615 | 2022-01-06 | Josephine | Oregon | 41033 | 11402 | 272 |
2085364 | 2085364 | 2022-01-05 | Josephine | Oregon | 41033 | 11298 | 271 |
2082112 | 2082112 | 2022-01-04 | Josephine | Oregon | 41033 | 11208 | 270 |
2078860 | 2078860 | 2022-01-03 | Josephine | Oregon | 41033 | 11154 | 267 |
2075609 | 2075609 | 2022-01-02 | Josephine | Oregon | 41033 | 10997 | 266 |
2072358 | 2072358 | 2022-01-01 | Josephine | Oregon | 41033 | 10997 | 266 |
2069107 | 2069107 | 2021-12-31 | Josephine | Oregon | 41033 | 10997 | 266 |
2065856 | 2065856 | 2021-12-30 | Josephine | Oregon | 41033 | 10997 | 266 |
2062606 | 2062606 | 2021-12-29 | Josephine | Oregon | 41033 | 10949 | 266 |
2059356 | 2059356 | 2021-12-28 | Josephine | Oregon | 41033 | 10905 | 263 |
2056107 | 2056107 | 2021-12-27 | Josephine | Oregon | 41033 | 10872 | 262 |
2052858 | 2052858 | 2021-12-26 | Josephine | Oregon | 41033 | 10768 | 261 |
2049608 | 2049608 | 2021-12-25 | Josephine | Oregon | 41033 | 10768 | 261 |
2046358 | 2046358 | 2021-12-24 | Josephine | Oregon | 41033 | 10768 | 261 |
2043108 | 2043108 | 2021-12-23 | Josephine | Oregon | 41033 | 10768 | 261 |
2039859 | 2039859 | 2021-12-22 | Josephine | Oregon | 41033 | 10733 | 260 |
2036609 | 2036609 | 2021-12-21 | Josephine | Oregon | 41033 | 10695 | 260 |
2033359 | 2033359 | 2021-12-20 | Josephine | Oregon | 41033 | 10678 | 259 |
2030109 | 2030109 | 2021-12-19 | Josephine | Oregon | 41033 | 10620 | 259 |
2026858 | 2026858 | 2021-12-18 | Josephine | Oregon | 41033 | 10620 | 259 |
2023607 | 2023607 | 2021-12-17 | Josephine | Oregon | 41033 | 10620 | 259 |
2020356 | 2020356 | 2021-12-16 | Josephine | Oregon | 41033 | 10588 | 259 |
2017105 | 2017105 | 2021-12-15 | Josephine | Oregon | 41033 | 10562 | 257 |
2013855 | 2013855 | 2021-12-14 | Josephine | Oregon | 41033 | 10526 | 254 |
2010604 | 2010604 | 2021-12-13 | Josephine | Oregon | 41033 | 10510 | 254 |
2007353 | 2007353 | 2021-12-12 | Josephine | Oregon | 41033 | 10455 | 254 |
2004102 | 2004102 | 2021-12-11 | Josephine | Oregon | 41033 | 10455 | 254 |
2000851 | 2000851 | 2021-12-10 | Josephine | Oregon | 41033 | 10455 | 254 |
1997601 | 1997601 | 2021-12-09 | Josephine | Oregon | 41033 | 10431 | 252 |
1994350 | 1994350 | 2021-12-08 | Josephine | Oregon | 41033 | 10414 | 250 |
1991099 | 1991099 | 2021-12-07 | Josephine | Oregon | 41033 | 10388 | 249 |
1987848 | 1987848 | 2021-12-06 | Josephine | Oregon | 41033 | 10357 | 248 |
1984598 | 1984598 | 2021-12-05 | Josephine | Oregon | 41033 | 10278 | 247 |
1981348 | 1981348 | 2021-12-04 | Josephine | Oregon | 41033 | 10278 | 247 |
1978098 | 1978098 | 2021-12-03 | Josephine | Oregon | 41033 | 10278 | 247 |
1974848 | 1974848 | 2021-12-02 | Josephine | Oregon | 41033 | 10245 | 246 |
1971599 | 1971599 | 2021-12-01 | Josephine | Oregon | 41033 | 10201 | 246 |
1968349 | 1968349 | 2021-11-30 | Josephine | Oregon | 41033 | 10148 | 244 |
1965098 | 1965098 | 2021-11-29 | Josephine | Oregon | 41033 | 10134 | 242 |
1961846 | 1961846 | 2021-11-28 | Josephine | Oregon | 41033 | 10057 | 240 |
1958595 | 1958595 | 2021-11-27 | Josephine | Oregon | 41033 | 10057 | 240 |
1955344 | 1955344 | 2021-11-26 | Josephine | Oregon | 41033 | 10057 | 240 |
1952093 | 1952093 | 2021-11-25 | Josephine | Oregon | 41033 | 10057 | 240 |
1948842 | 1948842 | 2021-11-24 | Josephine | Oregon | 41033 | 10057 | 240 |
1945591 | 1945591 | 2021-11-23 | Josephine | Oregon | 41033 | 10046 | 237 |
1942340 | 1942340 | 2021-11-22 | Josephine | Oregon | 41033 | 10031 | 234 |
1939090 | 1939090 | 2021-11-21 | Josephine | Oregon | 41033 | 9994 | 225 |
1935840 | 1935840 | 2021-11-20 | Josephine | Oregon | 41033 | 9994 | 225 |
1932590 | 1932590 | 2021-11-19 | Josephine | Oregon | 41033 | 9994 | 225 |
1929339 | 1929339 | 2021-11-18 | Josephine | Oregon | 41033 | 9965 | 223 |
1926089 | 1926089 | 2021-11-17 | Josephine | Oregon | 41033 | 9936 | 222 |
1922839 | 1922839 | 2021-11-16 | Josephine | Oregon | 41033 | 9910 | 222 |
1919590 | 1919590 | 2021-11-15 | Josephine | Oregon | 41033 | 9904 | 217 |
1916340 | 1916340 | 2021-11-14 | Josephine | Oregon | 41033 | 9848 | 214 |
1913090 | 1913090 | 2021-11-13 | Josephine | Oregon | 41033 | 9848 | 214 |
1909840 | 1909840 | 2021-11-12 | Josephine | Oregon | 41033 | 9848 | 214 |
1906591 | 1906591 | 2021-11-11 | Josephine | Oregon | 41033 | 9811 | 214 |
1903342 | 1903342 | 2021-11-10 | Josephine | Oregon | 41033 | 9811 | 214 |
1900092 | 1900092 | 2021-11-09 | Josephine | Oregon | 41033 | 9782 | 211 |
1896842 | 1896842 | 2021-11-08 | Josephine | Oregon | 41033 | 9763 | 209 |
1893592 | 1893592 | 2021-11-07 | Josephine | Oregon | 41033 | 9712 | 206 |
1890342 | 1890342 | 2021-11-06 | Josephine | Oregon | 41033 | 9712 | 206 |
1887092 | 1887092 | 2021-11-05 | Josephine | Oregon | 41033 | 9712 | 206 |
1883842 | 1883842 | 2021-11-04 | Josephine | Oregon | 41033 | 9695 | 206 |
1880593 | 1880593 | 2021-11-03 | Josephine | Oregon | 41033 | 9669 | 203 |
1877344 | 1877344 | 2021-11-02 | Josephine | Oregon | 41033 | 9631 | 200 |
1874095 | 1874095 | 2021-11-01 | Josephine | Oregon | 41033 | 9604 | 199 |
1870846 | 1870846 | 2021-10-31 | Josephine | Oregon | 41033 | 9531 | 198 |
1867597 | 1867597 | 2021-10-30 | Josephine | Oregon | 41033 | 9531 | 198 |
1864348 | 1864348 | 2021-10-29 | Josephine | Oregon | 41033 | 9531 | 198 |
1861099 | 1861099 | 2021-10-28 | Josephine | Oregon | 41033 | 9499 | 198 |
1857850 | 1857850 | 2021-10-27 | Josephine | Oregon | 41033 | 9476 | 198 |
1854601 | 1854601 | 2021-10-26 | Josephine | Oregon | 41033 | 9451 | 198 |
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);