ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 127, fips = 41053 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
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 |
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);