ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where fips = 41011 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 532 ✖
- 32 15
- 31 14
- 30 12
- 1 10
- 93 7
- 91 6
- 126 5
- 196 5
- 2147 5
- 5573 5
- 42 4
- 80 4
- 84 4
- 2166 4
- 2191 4
- 3543 4
- 6201 4
- 6396 4
- 7772 4
- 10312 4
- 10695 4
- 40 3
- 41 3
- 131 3
- 2157 3
- 2205 3
- 2227 3
- 2268 3
- 2319 3
- 2463 3
- 2708 3
- 2957 3
- 3249 3
- 3799 3
- 4064 3
- 4362 3
- 4575 3
- 4743 3
- 4896 3
- 5037 3
- 5165 3
- 5294 3
- 5387 3
- 5509 3
- 5768 3
- 5952 3
- 6101 3
- 6922 3
- 8563 3
- 9270 3
- 9794 3
- 10129 3
- 10432 3
- 10492 3
- 10557 3
- 10596 3
- 10620 3
- 10647 3
- 10676 3
- 10716 3
- 10739 3
- 10779 3
- 4 2
- 15 2
- 21 2
- 28 2
- 29 2
- 33 2
- 36 2
- 37 2
- 39 2
- 52 2
- 54 2
- 69 2
- 76 2
- 90 2
- 106 2
- 116 2
- 132 2
- 134 2
- 136 2
- 157 2
- 236 2
- 314 2
- 418 2
- 707 2
- 769 2
- 1086 2
- 1281 2
- 1900 2
- 1903 2
- 1924 2
- 2032 2
- 2039 2
- 2046 2
- 2050 2
- 2104 2
- 2146 2
- 2148 2
- 2152 2
- 2188 2
- 2189 2
- 2202 2
- 5376 2
- 2 1
- 3 1
- 8 1
- 12 1
- 14 1
- 20 1
- 25 1
- 27 1
- 46 1
- 48 1
- 53 1
- 55 1
- 58 1
- 60 1
- 64 1
- 67 1
- 70 1
- 73 1
- 79 1
- 85 1
- 88 1
- 89 1
- 94 1
- 97 1
- 98 1
- 99 1
- 101 1
- 110 1
- 112 1
- 115 1
- 118 1
- 122 1
- 123 1
- 129 1
- 138 1
- 142 1
- 145 1
- 147 1
- 149 1
- 152 1
- 156 1
- 158 1
- 160 1
- 165 1
- 167 1
- 173 1
- 176 1
- 179 1
- 186 1
- 192 1
- 193 1
- 199 1
- 200 1
- 205 1
- 210 1
- 214 1
- 222 1
- 225 1
- 229 1
- 231 1
- 238 1
- 246 1
- 251 1
- 259 1
- 260 1
- 262 1
- 266 1
- 271 1
- 272 1
- 273 1
- 275 1
- 276 1
- 282 1
- 286 1
- 290 1
- 296 1
- 304 1
- 320 1
- 334 1
- 338 1
- 342 1
- 347 1
- 352 1
- 360 1
- 368 1
- 374 1
- 383 1
- 390 1
- 396 1
- 406 1
- 421 1
- 425 1
- 430 1
- 443 1
- 453 1
- 458 1
- 487 1
- 505 1
- 515 1
- 523 1
- 530 1
- 548 1
- 558 1
- 564 1
- 572 1
- 582 1
- 589 1
- 597 1
- 609 1
- 614 1
- 632 1
- 648 1
- 653 1
- 658 1
- 672 1
- 676 1
- 687 1
- 690 1
- 691 1
- 734 1
- 748 1
- 756 1
- 789 1
- 808 1
- 825 1
- 838 1
- 845 1
- 863 1
- 875 1
- 884 1
- 897 1
- 905 1
- 913 1
- 923 1
- 926 1
- 933 1
- 937 1
- 938 1
- 941 1
- 952 1
- 962 1
- 972 1
- 983 1
- 1009 1
- 1020 1
- 1021 1
- 1029 1
- 1055 1
- 1070 1
- 1105 1
- 1115 1
- 1131 1
- 1147 1
- 1166 1
- 1178 1
- 1189 1
- 1204 1
- 1212 1
- 1227 1
- 1243 1
- 1250 1
- 1270 1
- 1292 1
- 1301 1
- 1309 1
- 1335 1
- 1347 1
- 1356 1
- 1374 1
- 1385 1
- 1401 1
- 1425 1
- 1440 1
- 1482 1
- 1491 1
- 1497 1
- 1500 1
- 1524 1
- 1545 1
- 1576 1
- 1591 1
- 1595 1
- 1599 1
- 1626 1
- 1644 1
- 1658 1
- 1679 1
- 1692 1
- 1703 1
- 1716 1
- 1719 1
- 1729 1
- 1751 1
- 1774 1
- 1790 1
- 1795 1
- 1803 1
- 1806 1
- 1818 1
- 1830 1
- 1845 1
- 1855 1
- 1862 1
- 1869 1
- 1874 1
- 1881 1
- 1888 1
- 1912 1
- 1917 1
- 1928 1
- 1934 1
- 1935 1
- 1947 1
- 1951 1
- 1960 1
- 1966 1
- 1968 1
- 1975 1
- 1978 1
- 1984 1
- 1986 1
- 1992 1
- 1998 1
- 2002 1
- 2005 1
- 2010 1
- 2016 1
- 2019 1
- 2022 1
- 2028 1
- 2033 1
- 2042 1
- 2049 1
- 2059 1
- 2066 1
- 2071 1
- 2077 1
- 2089 1
- 2098 1
- 2114 1
- 2121 1
- 2125 1
- 2128 1
- 2131 1
- 2134 1
- 2135 1
- 2139 1
- 2141 1
- 2144 1
- 2154 1
- 2155 1
- 2159 1
- 2162 1
- 2164 1
- 2167 1
- 2175 1
- 2177 1
- 2181 1
- 2186 1
- 2190 1
- 2196 1
- 2212 1
- 2216 1
- 2220 1
- 2223 1
- 2240 1
- 2252 1
- 2256 1
- 2262 1
- 2272 1
- 2276 1
- 2284 1
- 2304 1
- 2341 1
- 2376 1
- 2410 1
- 2439 1
- 2509 1
- 2581 1
- 2604 1
- 2658 1
- 2768 1
- 2843 1
- 2875 1
- 2912 1
- 3019 1
- 3084 1
- 3143 1
- 3163 1
- 3327 1
- 3414 1
- 3469 1
- 3508 1
- 3573 1
- 3726 1
- 3768 1
- 3854 1
- 3926 1
- 3981 1
- 4028 1
- 4120 1
- 4206 1
- 4253 1
- 4314 1
- 4397 1
- 4462 1
- 4511 1
- 4547 1
- 4622 1
- 4652 1
- 4684 1
- 4718 1
- 4785 1
- 4815 1
- 4842 1
- 4868 1
- 4925 1
- 4954 1
- 4980 1
- 5012 1
- 5078 1
- 5102 1
- 5123 1
- 5145 1
- 5198 1
- 5222 1
- 5248 1
- 5274 1
- 5332 1
- 5353 1
- 5415 1
- 5449 1
- 5473 1
- 5488 1
- 5539 1
- 5560 1
- 5600 1
- 5664 1
- 5693 1
- 5728 1
- 5806 1
- 5854 1
- 5878 1
- 5913 1
- 5994 1
- 6037 1
- 6058 1
- 6085 1
- 6138 1
- 6160 1
- 6184 1
- 6227 1
- 6322 1
- 6358 1
- 6439 1
- 6443 1
- 6578 1
- 6797 1
- 7133 1
- 7225 1
- 7468 1
- 7596 1
- 8111 1
- 8224 1
- 8365 1
- 8765 1
- 8848 1
- 9006 1
- 9153 1
- 9429 1
- 9522 1
- 9614 1
- 9713 1
- 9903 1
- 9952 1
- 10027 1
- 10068 1
- 10199 1
- 10235 1
- 10259 1
- 10282 1
- 10374 1
- 10392 1
- 10406 1
- 10449 1
- 10459 1
- 10469 1
- 10480 1
- 10511 1
- 10520 1
- 10534 1
- 10549 1
- 10572 1
- 10578 1
- 10583 1
- 10594 1
- 10603 1
- 10606 1
- 10614 1
- 10617 1
- 10621 1
- 10626 1
- 10632 1
- 10637 1
- 10653 1
- 10659 1
- 10670 1
- 10672 1
- 10684 1
- 10688 1
- 10692 1
- 10693 1
- 10706 1
- 10709 1
- 10712 1
- 10723 1
- 10727 1
- 10730 1
- 10736 1
- 10745 1
- 10764 1
- 10774 1
- 10777 1
- 10791 1
- 10808 1
- 10820 1
- 10837 1
- 10849 1
state 1
- Oregon · 763 ✖
fips 1
- 41011 · 763 ✖
county 1
- Coos 763
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501816 | 2501816 | 2022-05-13 | Coos | Oregon | 41011 | 10849 | 153 |
2498558 | 2498558 | 2022-05-12 | Coos | Oregon | 41011 | 10837 | 153 |
2495300 | 2495300 | 2022-05-11 | Coos | Oregon | 41011 | 10820 | 153 |
2492042 | 2492042 | 2022-05-10 | Coos | Oregon | 41011 | 10808 | 153 |
2488784 | 2488784 | 2022-05-09 | Coos | Oregon | 41011 | 10791 | 153 |
2485527 | 2485527 | 2022-05-08 | Coos | Oregon | 41011 | 10779 | 153 |
2482269 | 2482269 | 2022-05-07 | Coos | Oregon | 41011 | 10779 | 153 |
2479011 | 2479011 | 2022-05-06 | Coos | Oregon | 41011 | 10779 | 153 |
2475753 | 2475753 | 2022-05-05 | Coos | Oregon | 41011 | 10777 | 153 |
2472496 | 2472496 | 2022-05-04 | Coos | Oregon | 41011 | 10774 | 153 |
2469240 | 2469240 | 2022-05-03 | Coos | Oregon | 41011 | 10764 | 153 |
2465984 | 2465984 | 2022-05-02 | Coos | Oregon | 41011 | 10745 | 153 |
2462729 | 2462729 | 2022-05-01 | Coos | Oregon | 41011 | 10739 | 153 |
2459473 | 2459473 | 2022-04-30 | Coos | Oregon | 41011 | 10739 | 153 |
2456217 | 2456217 | 2022-04-29 | Coos | Oregon | 41011 | 10739 | 153 |
2452961 | 2452961 | 2022-04-28 | Coos | Oregon | 41011 | 10736 | 153 |
2449705 | 2449705 | 2022-04-27 | Coos | Oregon | 41011 | 10730 | 153 |
2446448 | 2446448 | 2022-04-26 | Coos | Oregon | 41011 | 10727 | 153 |
2443193 | 2443193 | 2022-04-25 | Coos | Oregon | 41011 | 10723 | 153 |
2439937 | 2439937 | 2022-04-24 | Coos | Oregon | 41011 | 10716 | 152 |
2436681 | 2436681 | 2022-04-23 | Coos | Oregon | 41011 | 10716 | 152 |
2433425 | 2433425 | 2022-04-22 | Coos | Oregon | 41011 | 10716 | 152 |
2430169 | 2430169 | 2022-04-21 | Coos | Oregon | 41011 | 10712 | 152 |
2426913 | 2426913 | 2022-04-20 | Coos | Oregon | 41011 | 10709 | 152 |
2423657 | 2423657 | 2022-04-19 | Coos | Oregon | 41011 | 10706 | 152 |
2420400 | 2420400 | 2022-04-18 | Coos | Oregon | 41011 | 10695 | 152 |
2417145 | 2417145 | 2022-04-17 | Coos | Oregon | 41011 | 10695 | 152 |
2413889 | 2413889 | 2022-04-16 | Coos | Oregon | 41011 | 10695 | 152 |
2410633 | 2410633 | 2022-04-15 | Coos | Oregon | 41011 | 10695 | 152 |
2407377 | 2407377 | 2022-04-14 | Coos | Oregon | 41011 | 10693 | 152 |
2404121 | 2404121 | 2022-04-13 | Coos | Oregon | 41011 | 10692 | 152 |
2400866 | 2400866 | 2022-04-12 | Coos | Oregon | 41011 | 10688 | 152 |
2397611 | 2397611 | 2022-04-11 | Coos | Oregon | 41011 | 10684 | 150 |
2394356 | 2394356 | 2022-04-10 | Coos | Oregon | 41011 | 10676 | 149 |
2391100 | 2391100 | 2022-04-09 | Coos | Oregon | 41011 | 10676 | 149 |
2387844 | 2387844 | 2022-04-08 | Coos | Oregon | 41011 | 10676 | 149 |
2384589 | 2384589 | 2022-04-07 | Coos | Oregon | 41011 | 10672 | 149 |
2381334 | 2381334 | 2022-04-06 | Coos | Oregon | 41011 | 10670 | 149 |
2378079 | 2378079 | 2022-04-05 | Coos | Oregon | 41011 | 10659 | 149 |
2374825 | 2374825 | 2022-04-04 | Coos | Oregon | 41011 | 10653 | 149 |
2371573 | 2371573 | 2022-04-03 | Coos | Oregon | 41011 | 10647 | 149 |
2368320 | 2368320 | 2022-04-02 | Coos | Oregon | 41011 | 10647 | 149 |
2365067 | 2365067 | 2022-04-01 | Coos | Oregon | 41011 | 10647 | 149 |
2361814 | 2361814 | 2022-03-31 | Coos | Oregon | 41011 | 10637 | 149 |
2358560 | 2358560 | 2022-03-30 | Coos | Oregon | 41011 | 10632 | 149 |
2355306 | 2355306 | 2022-03-29 | Coos | Oregon | 41011 | 10626 | 149 |
2352053 | 2352053 | 2022-03-28 | Coos | Oregon | 41011 | 10621 | 148 |
2348801 | 2348801 | 2022-03-27 | Coos | Oregon | 41011 | 10620 | 147 |
2345548 | 2345548 | 2022-03-26 | Coos | Oregon | 41011 | 10620 | 147 |
2342295 | 2342295 | 2022-03-25 | Coos | Oregon | 41011 | 10620 | 147 |
2339042 | 2339042 | 2022-03-24 | Coos | Oregon | 41011 | 10617 | 147 |
2335788 | 2335788 | 2022-03-23 | Coos | Oregon | 41011 | 10614 | 147 |
2332534 | 2332534 | 2022-03-22 | Coos | Oregon | 41011 | 10606 | 146 |
2329281 | 2329281 | 2022-03-21 | Coos | Oregon | 41011 | 10603 | 146 |
2326029 | 2326029 | 2022-03-20 | Coos | Oregon | 41011 | 10596 | 146 |
2322776 | 2322776 | 2022-03-19 | Coos | Oregon | 41011 | 10596 | 146 |
2319522 | 2319522 | 2022-03-18 | Coos | Oregon | 41011 | 10596 | 146 |
2316268 | 2316268 | 2022-03-17 | Coos | Oregon | 41011 | 10594 | 146 |
2313015 | 2313015 | 2022-03-16 | Coos | Oregon | 41011 | 10583 | 146 |
2309762 | 2309762 | 2022-03-15 | Coos | Oregon | 41011 | 10578 | 145 |
2306509 | 2306509 | 2022-03-14 | Coos | Oregon | 41011 | 10572 | 145 |
2303258 | 2303258 | 2022-03-13 | Coos | Oregon | 41011 | 10557 | 145 |
2300006 | 2300006 | 2022-03-12 | Coos | Oregon | 41011 | 10557 | 145 |
2296754 | 2296754 | 2022-03-11 | Coos | Oregon | 41011 | 10557 | 145 |
2293502 | 2293502 | 2022-03-10 | Coos | Oregon | 41011 | 10549 | 145 |
2290250 | 2290250 | 2022-03-09 | Coos | Oregon | 41011 | 10534 | 144 |
2286998 | 2286998 | 2022-03-08 | Coos | Oregon | 41011 | 10520 | 144 |
2283746 | 2283746 | 2022-03-07 | Coos | Oregon | 41011 | 10511 | 143 |
2280494 | 2280494 | 2022-03-06 | Coos | Oregon | 41011 | 10492 | 143 |
2277241 | 2277241 | 2022-03-05 | Coos | Oregon | 41011 | 10492 | 143 |
2273988 | 2273988 | 2022-03-04 | Coos | Oregon | 41011 | 10492 | 143 |
2270735 | 2270735 | 2022-03-03 | Coos | Oregon | 41011 | 10480 | 143 |
2267483 | 2267483 | 2022-03-02 | Coos | Oregon | 41011 | 10469 | 143 |
2264230 | 2264230 | 2022-03-01 | Coos | Oregon | 41011 | 10459 | 143 |
2260980 | 2260980 | 2022-02-28 | Coos | Oregon | 41011 | 10449 | 142 |
2257729 | 2257729 | 2022-02-27 | Coos | Oregon | 41011 | 10432 | 142 |
2254478 | 2254478 | 2022-02-26 | Coos | Oregon | 41011 | 10432 | 142 |
2251227 | 2251227 | 2022-02-25 | Coos | Oregon | 41011 | 10432 | 142 |
2247976 | 2247976 | 2022-02-24 | Coos | Oregon | 41011 | 10406 | 142 |
2244725 | 2244725 | 2022-02-23 | Coos | Oregon | 41011 | 10392 | 138 |
2241474 | 2241474 | 2022-02-22 | Coos | Oregon | 41011 | 10374 | 136 |
2238223 | 2238223 | 2022-02-21 | Coos | Oregon | 41011 | 10312 | 136 |
2234972 | 2234972 | 2022-02-20 | Coos | Oregon | 41011 | 10312 | 136 |
2231721 | 2231721 | 2022-02-19 | Coos | Oregon | 41011 | 10312 | 136 |
2228470 | 2228470 | 2022-02-18 | Coos | Oregon | 41011 | 10312 | 136 |
2225219 | 2225219 | 2022-02-17 | Coos | Oregon | 41011 | 10282 | 136 |
2221968 | 2221968 | 2022-02-16 | Coos | Oregon | 41011 | 10259 | 135 |
2218717 | 2218717 | 2022-02-15 | Coos | Oregon | 41011 | 10235 | 134 |
2215466 | 2215466 | 2022-02-14 | Coos | Oregon | 41011 | 10199 | 133 |
2212215 | 2212215 | 2022-02-13 | Coos | Oregon | 41011 | 10129 | 133 |
2208962 | 2208962 | 2022-02-12 | Coos | Oregon | 41011 | 10129 | 133 |
2205709 | 2205709 | 2022-02-11 | Coos | Oregon | 41011 | 10129 | 133 |
2202456 | 2202456 | 2022-02-10 | Coos | Oregon | 41011 | 10068 | 133 |
2199202 | 2199202 | 2022-02-09 | Coos | Oregon | 41011 | 10027 | 133 |
2195948 | 2195948 | 2022-02-08 | Coos | Oregon | 41011 | 9952 | 133 |
2192694 | 2192694 | 2022-02-07 | Coos | Oregon | 41011 | 9903 | 132 |
2189440 | 2189440 | 2022-02-06 | Coos | Oregon | 41011 | 9794 | 132 |
2186187 | 2186187 | 2022-02-05 | Coos | Oregon | 41011 | 9794 | 132 |
2182935 | 2182935 | 2022-02-04 | Coos | Oregon | 41011 | 9794 | 132 |
2179683 | 2179683 | 2022-02-03 | Coos | Oregon | 41011 | 9713 | 132 |
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);