ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
191 rows where deaths = 42 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 |
---|---|---|---|---|---|---|---|
2381342 | 2381342 | 2022-04-06 | Hood River | Oregon | 41027 | 3560 | 42 |
2378087 | 2378087 | 2022-04-05 | Hood River | Oregon | 41027 | 3559 | 42 |
2374833 | 2374833 | 2022-04-04 | Hood River | Oregon | 41027 | 3555 | 42 |
2371581 | 2371581 | 2022-04-03 | Hood River | Oregon | 41027 | 3548 | 42 |
2368328 | 2368328 | 2022-04-02 | Hood River | Oregon | 41027 | 3548 | 42 |
2365075 | 2365075 | 2022-04-01 | Hood River | Oregon | 41027 | 3548 | 42 |
2361822 | 2361822 | 2022-03-31 | Hood River | Oregon | 41027 | 3546 | 42 |
2358568 | 2358568 | 2022-03-30 | Hood River | Oregon | 41027 | 3545 | 42 |
2355314 | 2355314 | 2022-03-29 | Hood River | Oregon | 41027 | 3535 | 42 |
2352061 | 2352061 | 2022-03-28 | Hood River | Oregon | 41027 | 3533 | 42 |
2348799 | 2348799 | 2022-03-27 | Clatsop | Oregon | 41007 | 4579 | 42 |
2348809 | 2348809 | 2022-03-27 | Hood River | Oregon | 41027 | 3533 | 42 |
2345546 | 2345546 | 2022-03-26 | Clatsop | Oregon | 41007 | 4579 | 42 |
2345556 | 2345556 | 2022-03-26 | Hood River | Oregon | 41027 | 3533 | 42 |
2342293 | 2342293 | 2022-03-25 | Clatsop | Oregon | 41007 | 4579 | 42 |
2342303 | 2342303 | 2022-03-25 | Hood River | Oregon | 41027 | 3533 | 42 |
2339040 | 2339040 | 2022-03-24 | Clatsop | Oregon | 41007 | 4577 | 42 |
2339050 | 2339050 | 2022-03-24 | Hood River | Oregon | 41027 | 3532 | 42 |
2335786 | 2335786 | 2022-03-23 | Clatsop | Oregon | 41007 | 4573 | 42 |
2335796 | 2335796 | 2022-03-23 | Hood River | Oregon | 41027 | 3530 | 42 |
2332542 | 2332542 | 2022-03-22 | Hood River | Oregon | 41027 | 3527 | 42 |
2329289 | 2329289 | 2022-03-21 | Hood River | Oregon | 41027 | 3524 | 42 |
2326037 | 2326037 | 2022-03-20 | Hood River | Oregon | 41027 | 3521 | 42 |
2322784 | 2322784 | 2022-03-19 | Hood River | Oregon | 41027 | 3521 | 42 |
2319530 | 2319530 | 2022-03-18 | Hood River | Oregon | 41027 | 3521 | 42 |
2316276 | 2316276 | 2022-03-17 | Hood River | Oregon | 41027 | 3518 | 42 |
2313023 | 2313023 | 2022-03-16 | Hood River | Oregon | 41027 | 3518 | 42 |
2309770 | 2309770 | 2022-03-15 | Hood River | Oregon | 41027 | 3512 | 42 |
2306517 | 2306517 | 2022-03-14 | Hood River | Oregon | 41027 | 3509 | 42 |
2303266 | 2303266 | 2022-03-13 | Hood River | Oregon | 41027 | 3506 | 42 |
2300014 | 2300014 | 2022-03-12 | Hood River | Oregon | 41027 | 3506 | 42 |
2296762 | 2296762 | 2022-03-11 | Hood River | Oregon | 41027 | 3506 | 42 |
2293510 | 2293510 | 2022-03-10 | Hood River | Oregon | 41027 | 3504 | 42 |
2290258 | 2290258 | 2022-03-09 | Hood River | Oregon | 41027 | 3501 | 42 |
2287006 | 2287006 | 2022-03-08 | Hood River | Oregon | 41027 | 3499 | 42 |
2283754 | 2283754 | 2022-03-07 | Hood River | Oregon | 41027 | 3499 | 42 |
2280502 | 2280502 | 2022-03-06 | Hood River | Oregon | 41027 | 3491 | 42 |
2277249 | 2277249 | 2022-03-05 | Hood River | Oregon | 41027 | 3491 | 42 |
2273996 | 2273996 | 2022-03-04 | Hood River | Oregon | 41027 | 3491 | 42 |
2270743 | 2270743 | 2022-03-03 | Hood River | Oregon | 41027 | 3487 | 42 |
2267491 | 2267491 | 2022-03-02 | Hood River | Oregon | 41027 | 3482 | 42 |
2264238 | 2264238 | 2022-03-01 | Hood River | Oregon | 41027 | 3470 | 42 |
2260988 | 2260988 | 2022-02-28 | Hood River | Oregon | 41027 | 3464 | 42 |
2257737 | 2257737 | 2022-02-27 | Hood River | Oregon | 41027 | 3461 | 42 |
2254486 | 2254486 | 2022-02-26 | Hood River | Oregon | 41027 | 3461 | 42 |
2251235 | 2251235 | 2022-02-25 | Hood River | Oregon | 41027 | 3461 | 42 |
2247984 | 2247984 | 2022-02-24 | Hood River | Oregon | 41027 | 3457 | 42 |
2244733 | 2244733 | 2022-02-23 | Hood River | Oregon | 41027 | 3454 | 42 |
2241482 | 2241482 | 2022-02-22 | Hood River | Oregon | 41027 | 3450 | 42 |
2238231 | 2238231 | 2022-02-21 | Hood River | Oregon | 41027 | 3429 | 42 |
2234980 | 2234980 | 2022-02-20 | Hood River | Oregon | 41027 | 3429 | 42 |
2231729 | 2231729 | 2022-02-19 | Hood River | Oregon | 41027 | 3429 | 42 |
2228478 | 2228478 | 2022-02-18 | Hood River | Oregon | 41027 | 3429 | 42 |
2225227 | 2225227 | 2022-02-17 | Hood River | Oregon | 41027 | 3414 | 42 |
2221976 | 2221976 | 2022-02-16 | Hood River | Oregon | 41027 | 3403 | 42 |
2192689 | 2192689 | 2022-02-07 | Baker | Oregon | 41001 | 3061 | 42 |
2189435 | 2189435 | 2022-02-06 | Baker | Oregon | 41001 | 3039 | 42 |
2186182 | 2186182 | 2022-02-05 | Baker | Oregon | 41001 | 3039 | 42 |
2182930 | 2182930 | 2022-02-04 | Baker | Oregon | 41001 | 3039 | 42 |
2179678 | 2179678 | 2022-02-03 | Baker | Oregon | 41001 | 3016 | 42 |
2179685 | 2179685 | 2022-02-03 | Curry | Oregon | 41015 | 2943 | 42 |
2176427 | 2176427 | 2022-02-02 | Baker | Oregon | 41001 | 2992 | 42 |
2176434 | 2176434 | 2022-02-02 | Curry | Oregon | 41015 | 2906 | 42 |
2173173 | 2173173 | 2022-02-01 | Baker | Oregon | 41001 | 2962 | 42 |
2169921 | 2169921 | 2022-01-31 | Baker | Oregon | 41001 | 2953 | 42 |
2166666 | 2166666 | 2022-01-30 | Baker | Oregon | 41001 | 2915 | 42 |
2163411 | 2163411 | 2022-01-29 | Baker | Oregon | 41001 | 2915 | 42 |
2160156 | 2160156 | 2022-01-28 | Baker | Oregon | 41001 | 2915 | 42 |
2039844 | 2039844 | 2021-12-22 | Benton | Oregon | 41003 | 6468 | 42 |
2036594 | 2036594 | 2021-12-21 | Benton | Oregon | 41003 | 6447 | 42 |
2033344 | 2033344 | 2021-12-20 | Benton | Oregon | 41003 | 6429 | 42 |
2030094 | 2030094 | 2021-12-19 | Benton | Oregon | 41003 | 6388 | 42 |
2026843 | 2026843 | 2021-12-18 | Benton | Oregon | 41003 | 6388 | 42 |
2023592 | 2023592 | 2021-12-17 | Benton | Oregon | 41003 | 6388 | 42 |
2020341 | 2020341 | 2021-12-16 | Benton | Oregon | 41003 | 6367 | 42 |
2017090 | 2017090 | 2021-12-15 | Benton | Oregon | 41003 | 6351 | 42 |
2013840 | 2013840 | 2021-12-14 | Benton | Oregon | 41003 | 6342 | 42 |
1939102 | 1939102 | 2021-11-21 | Tillamook | Oregon | 41057 | 2127 | 42 |
1935852 | 1935852 | 2021-11-20 | Tillamook | Oregon | 41057 | 2127 | 42 |
1932602 | 1932602 | 2021-11-19 | Tillamook | Oregon | 41057 | 2127 | 42 |
1929351 | 1929351 | 2021-11-18 | Tillamook | Oregon | 41057 | 2123 | 42 |
1926101 | 1926101 | 2021-11-17 | Tillamook | Oregon | 41057 | 2119 | 42 |
1922851 | 1922851 | 2021-11-16 | Tillamook | Oregon | 41057 | 2114 | 42 |
1919602 | 1919602 | 2021-11-15 | Tillamook | Oregon | 41057 | 2113 | 42 |
1916352 | 1916352 | 2021-11-14 | Tillamook | Oregon | 41057 | 2100 | 42 |
1913102 | 1913102 | 2021-11-13 | Tillamook | Oregon | 41057 | 2100 | 42 |
1909852 | 1909852 | 2021-11-12 | Tillamook | Oregon | 41057 | 2100 | 42 |
1906603 | 1906603 | 2021-11-11 | Tillamook | Oregon | 41057 | 2088 | 42 |
1903354 | 1903354 | 2021-11-10 | Tillamook | Oregon | 41057 | 2088 | 42 |
1802603 | 1802603 | 2021-10-10 | Crook | Oregon | 41013 | 2563 | 42 |
1799354 | 1799354 | 2021-10-09 | Crook | Oregon | 41013 | 2563 | 42 |
1796105 | 1796105 | 2021-10-08 | Crook | Oregon | 41013 | 2563 | 42 |
1792856 | 1792856 | 2021-10-07 | Crook | Oregon | 41013 | 2513 | 42 |
1623925 | 1623925 | 2021-08-16 | Coos | Oregon | 41011 | 2768 | 42 |
1620688 | 1620688 | 2021-08-15 | Jefferson | Oregon | 41031 | 2623 | 42 |
1617440 | 1617440 | 2021-08-14 | Jefferson | Oregon | 41031 | 2623 | 42 |
1614192 | 1614192 | 2021-08-13 | Jefferson | Oregon | 41031 | 2623 | 42 |
1610943 | 1610943 | 2021-08-12 | Jefferson | Oregon | 41031 | 2604 | 42 |
1607695 | 1607695 | 2021-08-11 | Jefferson | Oregon | 41031 | 2584 | 42 |
1604446 | 1604446 | 2021-08-10 | Jefferson | Oregon | 41031 | 2575 | 42 |
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);