ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where deaths = 48 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 |
---|---|---|---|---|---|---|---|
2501811 | 2501811 | 2022-05-13 | Baker | Oregon | 41001 | 3231 | 48 |
2498553 | 2498553 | 2022-05-12 | Baker | Oregon | 41001 | 3230 | 48 |
2495295 | 2495295 | 2022-05-11 | Baker | Oregon | 41001 | 3226 | 48 |
2492037 | 2492037 | 2022-05-10 | Baker | Oregon | 41001 | 3226 | 48 |
2488779 | 2488779 | 2022-05-09 | Baker | Oregon | 41001 | 3226 | 48 |
2485522 | 2485522 | 2022-05-08 | Baker | Oregon | 41001 | 3226 | 48 |
2482264 | 2482264 | 2022-05-07 | Baker | Oregon | 41001 | 3226 | 48 |
2479006 | 2479006 | 2022-05-06 | Baker | Oregon | 41001 | 3226 | 48 |
2475748 | 2475748 | 2022-05-05 | Baker | Oregon | 41001 | 3220 | 48 |
2472491 | 2472491 | 2022-05-04 | Baker | Oregon | 41001 | 3219 | 48 |
2469235 | 2469235 | 2022-05-03 | Baker | Oregon | 41001 | 3217 | 48 |
2465979 | 2465979 | 2022-05-02 | Baker | Oregon | 41001 | 3217 | 48 |
2462724 | 2462724 | 2022-05-01 | Baker | Oregon | 41001 | 3215 | 48 |
2459468 | 2459468 | 2022-04-30 | Baker | Oregon | 41001 | 3215 | 48 |
2456212 | 2456212 | 2022-04-29 | Baker | Oregon | 41001 | 3215 | 48 |
2452956 | 2452956 | 2022-04-28 | Baker | Oregon | 41001 | 3214 | 48 |
2449700 | 2449700 | 2022-04-27 | Baker | Oregon | 41001 | 3214 | 48 |
2446443 | 2446443 | 2022-04-26 | Baker | Oregon | 41001 | 3214 | 48 |
2443188 | 2443188 | 2022-04-25 | Baker | Oregon | 41001 | 3214 | 48 |
2439932 | 2439932 | 2022-04-24 | Baker | Oregon | 41001 | 3214 | 48 |
2436676 | 2436676 | 2022-04-23 | Baker | Oregon | 41001 | 3214 | 48 |
2433420 | 2433420 | 2022-04-22 | Baker | Oregon | 41001 | 3214 | 48 |
2430164 | 2430164 | 2022-04-21 | Baker | Oregon | 41001 | 3214 | 48 |
2426908 | 2426908 | 2022-04-20 | Baker | Oregon | 41001 | 3212 | 48 |
2423652 | 2423652 | 2022-04-19 | Baker | Oregon | 41001 | 3210 | 48 |
2420395 | 2420395 | 2022-04-18 | Baker | Oregon | 41001 | 3210 | 48 |
2417140 | 2417140 | 2022-04-17 | Baker | Oregon | 41001 | 3210 | 48 |
2413884 | 2413884 | 2022-04-16 | Baker | Oregon | 41001 | 3210 | 48 |
2410628 | 2410628 | 2022-04-15 | Baker | Oregon | 41001 | 3210 | 48 |
2407372 | 2407372 | 2022-04-14 | Baker | Oregon | 41001 | 3210 | 48 |
2404116 | 2404116 | 2022-04-13 | Baker | Oregon | 41001 | 3210 | 48 |
2400861 | 2400861 | 2022-04-12 | Baker | Oregon | 41001 | 3210 | 48 |
2397606 | 2397606 | 2022-04-11 | Baker | Oregon | 41001 | 3210 | 48 |
2397609 | 2397609 | 2022-04-11 | Clatsop | Oregon | 41007 | 4605 | 48 |
2394351 | 2394351 | 2022-04-10 | Baker | Oregon | 41001 | 3209 | 48 |
2394354 | 2394354 | 2022-04-10 | Clatsop | Oregon | 41007 | 4601 | 48 |
2391095 | 2391095 | 2022-04-09 | Baker | Oregon | 41001 | 3209 | 48 |
2391098 | 2391098 | 2022-04-09 | Clatsop | Oregon | 41007 | 4601 | 48 |
2387839 | 2387839 | 2022-04-08 | Baker | Oregon | 41001 | 3209 | 48 |
2387842 | 2387842 | 2022-04-08 | Clatsop | Oregon | 41007 | 4601 | 48 |
2384584 | 2384584 | 2022-04-07 | Baker | Oregon | 41001 | 3209 | 48 |
2384587 | 2384587 | 2022-04-07 | Clatsop | Oregon | 41007 | 4601 | 48 |
2381329 | 2381329 | 2022-04-06 | Baker | Oregon | 41001 | 3208 | 48 |
2381332 | 2381332 | 2022-04-06 | Clatsop | Oregon | 41007 | 4601 | 48 |
2378074 | 2378074 | 2022-04-05 | Baker | Oregon | 41001 | 3208 | 48 |
2378077 | 2378077 | 2022-04-05 | Clatsop | Oregon | 41007 | 4600 | 48 |
2374820 | 2374820 | 2022-04-04 | Baker | Oregon | 41001 | 3208 | 48 |
2374823 | 2374823 | 2022-04-04 | Clatsop | Oregon | 41007 | 4598 | 48 |
2332536 | 2332536 | 2022-03-22 | Curry | Oregon | 41015 | 3326 | 48 |
2150397 | 2150397 | 2022-01-25 | Benton | Oregon | 41003 | 11988 | 48 |
2098387 | 2098387 | 2022-01-09 | Wasco | Oregon | 41065 | 3443 | 48 |
2095135 | 2095135 | 2022-01-08 | Wasco | Oregon | 41065 | 3443 | 48 |
2091883 | 2091883 | 2022-01-07 | Wasco | Oregon | 41065 | 3443 | 48 |
2088631 | 2088631 | 2022-01-06 | Wasco | Oregon | 41065 | 3417 | 48 |
2085380 | 2085380 | 2022-01-05 | Wasco | Oregon | 41065 | 3396 | 48 |
2082128 | 2082128 | 2022-01-04 | Wasco | Oregon | 41065 | 3373 | 48 |
2078876 | 2078876 | 2022-01-03 | Wasco | Oregon | 41065 | 3343 | 48 |
2075625 | 2075625 | 2022-01-02 | Wasco | Oregon | 41065 | 3322 | 48 |
2072374 | 2072374 | 2022-01-01 | Wasco | Oregon | 41065 | 3322 | 48 |
2069123 | 2069123 | 2021-12-31 | Wasco | Oregon | 41065 | 3322 | 48 |
2065872 | 2065872 | 2021-12-30 | Wasco | Oregon | 41065 | 3322 | 48 |
2062618 | 2062618 | 2021-12-29 | Tillamook | Oregon | 41057 | 2367 | 48 |
2062622 | 2062622 | 2021-12-29 | Wasco | Oregon | 41065 | 3312 | 48 |
2059368 | 2059368 | 2021-12-28 | Tillamook | Oregon | 41057 | 2361 | 48 |
2059372 | 2059372 | 2021-12-28 | Wasco | Oregon | 41065 | 3301 | 48 |
2056119 | 2056119 | 2021-12-27 | Tillamook | Oregon | 41057 | 2361 | 48 |
2056123 | 2056123 | 2021-12-27 | Wasco | Oregon | 41065 | 3281 | 48 |
2052870 | 2052870 | 2021-12-26 | Tillamook | Oregon | 41057 | 2349 | 48 |
2052874 | 2052874 | 2021-12-26 | Wasco | Oregon | 41065 | 3271 | 48 |
2049620 | 2049620 | 2021-12-25 | Tillamook | Oregon | 41057 | 2349 | 48 |
2049624 | 2049624 | 2021-12-25 | Wasco | Oregon | 41065 | 3271 | 48 |
2046370 | 2046370 | 2021-12-24 | Tillamook | Oregon | 41057 | 2349 | 48 |
2046374 | 2046374 | 2021-12-24 | Wasco | Oregon | 41065 | 3271 | 48 |
2043120 | 2043120 | 2021-12-23 | Tillamook | Oregon | 41057 | 2349 | 48 |
2043124 | 2043124 | 2021-12-23 | Wasco | Oregon | 41065 | 3271 | 48 |
2039871 | 2039871 | 2021-12-22 | Tillamook | Oregon | 41057 | 2342 | 48 |
2039875 | 2039875 | 2021-12-22 | Wasco | Oregon | 41065 | 3269 | 48 |
2036621 | 2036621 | 2021-12-21 | Tillamook | Oregon | 41057 | 2336 | 48 |
2036625 | 2036625 | 2021-12-21 | Wasco | Oregon | 41065 | 3264 | 48 |
2033371 | 2033371 | 2021-12-20 | Tillamook | Oregon | 41057 | 2332 | 48 |
2033375 | 2033375 | 2021-12-20 | Wasco | Oregon | 41065 | 3257 | 48 |
2030121 | 2030121 | 2021-12-19 | Tillamook | Oregon | 41057 | 2303 | 48 |
2030125 | 2030125 | 2021-12-19 | Wasco | Oregon | 41065 | 3251 | 48 |
2026870 | 2026870 | 2021-12-18 | Tillamook | Oregon | 41057 | 2303 | 48 |
2026874 | 2026874 | 2021-12-18 | Wasco | Oregon | 41065 | 3251 | 48 |
2023619 | 2023619 | 2021-12-17 | Tillamook | Oregon | 41057 | 2303 | 48 |
2023623 | 2023623 | 2021-12-17 | Wasco | Oregon | 41065 | 3251 | 48 |
2020368 | 2020368 | 2021-12-16 | Tillamook | Oregon | 41057 | 2295 | 48 |
2020372 | 2020372 | 2021-12-16 | Wasco | Oregon | 41065 | 3245 | 48 |
2017117 | 2017117 | 2021-12-15 | Tillamook | Oregon | 41057 | 2286 | 48 |
1896830 | 1896830 | 2021-11-08 | Columbia | Oregon | 41009 | 4052 | 48 |
1835118 | 1835118 | 2021-10-20 | Union | Oregon | 41061 | 3173 | 48 |
1831869 | 1831869 | 2021-10-19 | Union | Oregon | 41061 | 3165 | 48 |
1760373 | 1760373 | 2021-09-27 | Jefferson | Oregon | 41031 | 3297 | 48 |
1649914 | 1649914 | 2021-08-24 | Coos | Oregon | 41011 | 3084 | 48 |
1192114 | 1192114 | 2021-04-05 | Polk | Oregon | 41053 | 3289 | 48 |
1188865 | 1188865 | 2021-04-04 | Polk | Oregon | 41053 | 3275 | 48 |
1185618 | 1185618 | 2021-04-03 | Polk | Oregon | 41053 | 3262 | 48 |
1182371 | 1182371 | 2021-04-02 | Polk | Oregon | 41053 | 3251 | 48 |
1179124 | 1179124 | 2021-04-01 | Polk | Oregon | 41053 | 3235 | 48 |
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);