ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where deaths = 127 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Oregon · 61 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2371594 | 2371594 | 2022-04-03 | Polk | Oregon | 41053 | 15243 | 127 |
2368341 | 2368341 | 2022-04-02 | Polk | Oregon | 41053 | 15243 | 127 |
2365088 | 2365088 | 2022-04-01 | Polk | Oregon | 41053 | 15243 | 127 |
2361835 | 2361835 | 2022-03-31 | Polk | Oregon | 41053 | 15243 | 127 |
2358581 | 2358581 | 2022-03-30 | Polk | Oregon | 41053 | 15235 | 127 |
2355327 | 2355327 | 2022-03-29 | Polk | Oregon | 41053 | 15234 | 127 |
2352074 | 2352074 | 2022-03-28 | Polk | Oregon | 41053 | 15233 | 127 |
2348822 | 2348822 | 2022-03-27 | Polk | Oregon | 41053 | 15224 | 127 |
2345569 | 2345569 | 2022-03-26 | Polk | Oregon | 41053 | 15224 | 127 |
2342316 | 2342316 | 2022-03-25 | Polk | Oregon | 41053 | 15224 | 127 |
2339063 | 2339063 | 2022-03-24 | Polk | Oregon | 41053 | 15219 | 127 |
2335809 | 2335809 | 2022-03-23 | Polk | Oregon | 41053 | 15214 | 127 |
2332555 | 2332555 | 2022-03-22 | Polk | Oregon | 41053 | 15213 | 127 |
2329302 | 2329302 | 2022-03-21 | Polk | Oregon | 41053 | 15206 | 127 |
2326050 | 2326050 | 2022-03-20 | Polk | Oregon | 41053 | 15198 | 127 |
2322797 | 2322797 | 2022-03-19 | Polk | Oregon | 41053 | 15198 | 127 |
2319543 | 2319543 | 2022-03-18 | Polk | Oregon | 41053 | 15198 | 127 |
2316289 | 2316289 | 2022-03-17 | Polk | Oregon | 41053 | 15193 | 127 |
2313036 | 2313036 | 2022-03-16 | Polk | Oregon | 41053 | 15190 | 127 |
2309783 | 2309783 | 2022-03-15 | Polk | Oregon | 41053 | 15185 | 127 |
2306530 | 2306530 | 2022-03-14 | Polk | Oregon | 41053 | 15176 | 127 |
2303279 | 2303279 | 2022-03-13 | Polk | Oregon | 41053 | 15164 | 127 |
2300027 | 2300027 | 2022-03-12 | Polk | Oregon | 41053 | 15164 | 127 |
2296775 | 2296775 | 2022-03-11 | Polk | Oregon | 41053 | 15164 | 127 |
2293523 | 2293523 | 2022-03-10 | Polk | Oregon | 41053 | 15156 | 127 |
2290271 | 2290271 | 2022-03-09 | Polk | Oregon | 41053 | 15146 | 127 |
2287019 | 2287019 | 2022-03-08 | Polk | Oregon | 41053 | 15138 | 127 |
2283767 | 2283767 | 2022-03-07 | Polk | Oregon | 41053 | 15130 | 127 |
2280515 | 2280515 | 2022-03-06 | Polk | Oregon | 41053 | 15117 | 127 |
2277262 | 2277262 | 2022-03-05 | Polk | Oregon | 41053 | 15117 | 127 |
2274009 | 2274009 | 2022-03-04 | Polk | Oregon | 41053 | 15117 | 127 |
2270756 | 2270756 | 2022-03-03 | Polk | Oregon | 41053 | 15105 | 127 |
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 |
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 |
1835109 | 1835109 | 2021-10-20 | Linn | Oregon | 41043 | 12732 | 127 |
1747393 | 1747393 | 2021-09-23 | Umatilla | Oregon | 41059 | 12914 | 127 |
1240821 | 1240821 | 2021-04-20 | Jackson | Oregon | 41029 | 9984 | 127 |
1237574 | 1237574 | 2021-04-19 | Jackson | Oregon | 41029 | 9938 | 127 |
1234327 | 1234327 | 2021-04-18 | Jackson | Oregon | 41029 | 9923 | 127 |
1231079 | 1231079 | 2021-04-17 | Jackson | Oregon | 41029 | 9904 | 127 |
1227831 | 1227831 | 2021-04-16 | Jackson | Oregon | 41029 | 9846 | 127 |
1224583 | 1224583 | 2021-04-15 | Jackson | Oregon | 41029 | 9793 | 127 |
1078469 | 1078469 | 2021-03-01 | Lane | Oregon | 41039 | 10287 | 127 |
757175 | 757175 | 2020-11-22 | Marion | Oregon | 41047 | 8321 | 127 |
753928 | 753928 | 2020-11-21 | Marion | Oregon | 41047 | 8145 | 127 |
750682 | 750682 | 2020-11-20 | Marion | Oregon | 41047 | 8025 | 127 |
747436 | 747436 | 2020-11-19 | Marion | Oregon | 41047 | 7914 | 127 |
744190 | 744190 | 2020-11-18 | Marion | Oregon | 41047 | 7830 | 127 |
740943 | 740943 | 2020-11-17 | Marion | Oregon | 41047 | 7747 | 127 |
533431 | 533431 | 2020-09-14 | Multnomah | Oregon | 41051 | 6584 | 127 |
530196 | 530196 | 2020-09-13 | Multnomah | Oregon | 41051 | 6556 | 127 |
520487 | 520487 | 2020-09-10 | Multnomah | Oregon | 41051 | 6399 | 127 |
517251 | 517251 | 2020-09-09 | Multnomah | Oregon | 41051 | 6365 | 127 |
514016 | 514016 | 2020-09-08 | Multnomah | Oregon | 41051 | 6343 | 127 |
510783 | 510783 | 2020-09-07 | Multnomah | Oregon | 41051 | 6302 | 127 |
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);