ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
155 rows where deaths = 34 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501835 | 2501835 | 2022-05-13 | Morrow | Oregon | 41049 | 2980 | 34 |
2498577 | 2498577 | 2022-05-12 | Morrow | Oregon | 41049 | 2980 | 34 |
2495319 | 2495319 | 2022-05-11 | Morrow | Oregon | 41049 | 2980 | 34 |
2492061 | 2492061 | 2022-05-10 | Morrow | Oregon | 41049 | 2978 | 34 |
2488803 | 2488803 | 2022-05-09 | Morrow | Oregon | 41049 | 2977 | 34 |
2485546 | 2485546 | 2022-05-08 | Morrow | Oregon | 41049 | 2973 | 34 |
2482288 | 2482288 | 2022-05-07 | Morrow | Oregon | 41049 | 2973 | 34 |
2479030 | 2479030 | 2022-05-06 | Morrow | Oregon | 41049 | 2973 | 34 |
2475772 | 2475772 | 2022-05-05 | Morrow | Oregon | 41049 | 2972 | 34 |
2472515 | 2472515 | 2022-05-04 | Morrow | Oregon | 41049 | 2971 | 34 |
2469259 | 2469259 | 2022-05-03 | Morrow | Oregon | 41049 | 2970 | 34 |
2466003 | 2466003 | 2022-05-02 | Morrow | Oregon | 41049 | 2968 | 34 |
2462748 | 2462748 | 2022-05-01 | Morrow | Oregon | 41049 | 2967 | 34 |
2459492 | 2459492 | 2022-04-30 | Morrow | Oregon | 41049 | 2967 | 34 |
2456236 | 2456236 | 2022-04-29 | Morrow | Oregon | 41049 | 2967 | 34 |
2452980 | 2452980 | 2022-04-28 | Morrow | Oregon | 41049 | 2965 | 34 |
2449724 | 2449724 | 2022-04-27 | Morrow | Oregon | 41049 | 2965 | 34 |
2446467 | 2446467 | 2022-04-26 | Morrow | Oregon | 41049 | 2963 | 34 |
2443212 | 2443212 | 2022-04-25 | Morrow | Oregon | 41049 | 2962 | 34 |
2439956 | 2439956 | 2022-04-24 | Morrow | Oregon | 41049 | 2960 | 34 |
2436700 | 2436700 | 2022-04-23 | Morrow | Oregon | 41049 | 2960 | 34 |
2433444 | 2433444 | 2022-04-22 | Morrow | Oregon | 41049 | 2960 | 34 |
2430188 | 2430188 | 2022-04-21 | Morrow | Oregon | 41049 | 2959 | 34 |
2426932 | 2426932 | 2022-04-20 | Morrow | Oregon | 41049 | 2958 | 34 |
2423676 | 2423676 | 2022-04-19 | Morrow | Oregon | 41049 | 2957 | 34 |
2420419 | 2420419 | 2022-04-18 | Morrow | Oregon | 41049 | 2953 | 34 |
2417164 | 2417164 | 2022-04-17 | Morrow | Oregon | 41049 | 2953 | 34 |
2413908 | 2413908 | 2022-04-16 | Morrow | Oregon | 41049 | 2953 | 34 |
2410652 | 2410652 | 2022-04-15 | Morrow | Oregon | 41049 | 2953 | 34 |
2407396 | 2407396 | 2022-04-14 | Morrow | Oregon | 41049 | 2953 | 34 |
2134137 | 2134137 | 2022-01-20 | Harney | Oregon | 41025 | 1304 | 34 |
2130885 | 2130885 | 2022-01-19 | Harney | Oregon | 41025 | 1300 | 34 |
2127631 | 2127631 | 2022-01-18 | Harney | Oregon | 41025 | 1298 | 34 |
2124379 | 2124379 | 2022-01-17 | Harney | Oregon | 41025 | 1283 | 34 |
2121127 | 2121127 | 2022-01-16 | Harney | Oregon | 41025 | 1283 | 34 |
2117875 | 2117875 | 2022-01-15 | Harney | Oregon | 41025 | 1283 | 34 |
2114624 | 2114624 | 2022-01-14 | Harney | Oregon | 41025 | 1283 | 34 |
2111372 | 2111372 | 2022-01-13 | Harney | Oregon | 41025 | 1283 | 34 |
2108120 | 2108120 | 2022-01-12 | Harney | Oregon | 41025 | 1277 | 34 |
2104869 | 2104869 | 2022-01-11 | Harney | Oregon | 41025 | 1275 | 34 |
2101618 | 2101618 | 2022-01-10 | Harney | Oregon | 41025 | 1274 | 34 |
2098367 | 2098367 | 2022-01-09 | Harney | Oregon | 41025 | 1270 | 34 |
2095115 | 2095115 | 2022-01-08 | Harney | Oregon | 41025 | 1270 | 34 |
2091863 | 2091863 | 2022-01-07 | Harney | Oregon | 41025 | 1270 | 34 |
2088611 | 2088611 | 2022-01-06 | Harney | Oregon | 41025 | 1265 | 34 |
2085360 | 2085360 | 2022-01-05 | Harney | Oregon | 41025 | 1265 | 34 |
2082108 | 2082108 | 2022-01-04 | Harney | Oregon | 41025 | 1265 | 34 |
2078856 | 2078856 | 2022-01-03 | Harney | Oregon | 41025 | 1261 | 34 |
2075605 | 2075605 | 2022-01-02 | Harney | Oregon | 41025 | 1254 | 34 |
2072354 | 2072354 | 2022-01-01 | Harney | Oregon | 41025 | 1254 | 34 |
2069103 | 2069103 | 2021-12-31 | Harney | Oregon | 41025 | 1254 | 34 |
2065852 | 2065852 | 2021-12-30 | Harney | Oregon | 41025 | 1254 | 34 |
2062602 | 2062602 | 2021-12-29 | Harney | Oregon | 41025 | 1252 | 34 |
2059352 | 2059352 | 2021-12-28 | Harney | Oregon | 41025 | 1252 | 34 |
2056103 | 2056103 | 2021-12-27 | Harney | Oregon | 41025 | 1249 | 34 |
2052854 | 2052854 | 2021-12-26 | Harney | Oregon | 41025 | 1241 | 34 |
2049604 | 2049604 | 2021-12-25 | Harney | Oregon | 41025 | 1241 | 34 |
2046354 | 2046354 | 2021-12-24 | Harney | Oregon | 41025 | 1241 | 34 |
2043104 | 2043104 | 2021-12-23 | Harney | Oregon | 41025 | 1241 | 34 |
2039855 | 2039855 | 2021-12-22 | Harney | Oregon | 41025 | 1241 | 34 |
1994334 | 1994334 | 2021-12-08 | Baker | Oregon | 41001 | 2234 | 34 |
1874107 | 1874107 | 2021-11-01 | Tillamook | Oregon | 41057 | 2005 | 34 |
1870858 | 1870858 | 2021-10-31 | Tillamook | Oregon | 41057 | 1995 | 34 |
1867609 | 1867609 | 2021-10-30 | Tillamook | Oregon | 41057 | 1995 | 34 |
1864360 | 1864360 | 2021-10-29 | Tillamook | Oregon | 41057 | 1995 | 34 |
1812366 | 1812366 | 2021-10-13 | Lincoln | Oregon | 41041 | 3081 | 34 |
1711657 | 1711657 | 2021-09-12 | Union | Oregon | 41061 | 2508 | 34 |
1708410 | 1708410 | 2021-09-11 | Union | Oregon | 41061 | 2508 | 34 |
1705163 | 1705163 | 2021-09-10 | Union | Oregon | 41061 | 2508 | 34 |
1701913 | 1701913 | 2021-09-09 | Union | Oregon | 41061 | 2465 | 34 |
1698664 | 1698664 | 2021-09-08 | Union | Oregon | 41061 | 2443 | 34 |
1695416 | 1695416 | 2021-09-07 | Union | Oregon | 41061 | 2436 | 34 |
1692168 | 1692168 | 2021-09-06 | Union | Oregon | 41061 | 2379 | 34 |
1688919 | 1688919 | 2021-09-05 | Union | Oregon | 41061 | 2379 | 34 |
1685669 | 1685669 | 2021-09-04 | Union | Oregon | 41061 | 2379 | 34 |
1682418 | 1682418 | 2021-09-03 | Union | Oregon | 41061 | 2379 | 34 |
1679168 | 1679168 | 2021-09-02 | Union | Oregon | 41061 | 2364 | 34 |
1675894 | 1675894 | 2021-09-01 | Columbia | Oregon | 41009 | 2809 | 34 |
1672647 | 1672647 | 2021-08-31 | Columbia | Oregon | 41009 | 2788 | 34 |
1669399 | 1669399 | 2021-08-30 | Columbia | Oregon | 41009 | 2765 | 34 |
1666152 | 1666152 | 2021-08-29 | Columbia | Oregon | 41009 | 2699 | 34 |
1662904 | 1662904 | 2021-08-28 | Columbia | Oregon | 41009 | 2699 | 34 |
1659656 | 1659656 | 2021-08-27 | Columbia | Oregon | 41009 | 2699 | 34 |
1656407 | 1656407 | 2021-08-26 | Columbia | Oregon | 41009 | 2672 | 34 |
1653160 | 1653160 | 2021-08-25 | Columbia | Oregon | 41009 | 2649 | 34 |
1623933 | 1623933 | 2021-08-16 | Hood River | Oregon | 41027 | 1367 | 34 |
1620686 | 1620686 | 2021-08-15 | Hood River | Oregon | 41027 | 1359 | 34 |
1617438 | 1617438 | 2021-08-14 | Hood River | Oregon | 41027 | 1359 | 34 |
1614190 | 1614190 | 2021-08-13 | Hood River | Oregon | 41027 | 1359 | 34 |
1610941 | 1610941 | 2021-08-12 | Hood River | Oregon | 41027 | 1341 | 34 |
1607693 | 1607693 | 2021-08-11 | Hood River | Oregon | 41027 | 1330 | 34 |
1604444 | 1604444 | 2021-08-10 | Hood River | Oregon | 41027 | 1324 | 34 |
1601195 | 1601195 | 2021-08-09 | Hood River | Oregon | 41027 | 1317 | 34 |
1597947 | 1597947 | 2021-08-08 | Hood River | Oregon | 41027 | 1302 | 34 |
1594698 | 1594698 | 2021-08-07 | Hood River | Oregon | 41027 | 1302 | 34 |
1591449 | 1591449 | 2021-08-06 | Hood River | Oregon | 41027 | 1302 | 34 |
1588200 | 1588200 | 2021-08-05 | Hood River | Oregon | 41027 | 1292 | 34 |
1584950 | 1584950 | 2021-08-04 | Hood River | Oregon | 41027 | 1289 | 34 |
1581700 | 1581700 | 2021-08-03 | Hood River | Oregon | 41027 | 1286 | 34 |
1578451 | 1578451 | 2021-08-02 | Hood River | Oregon | 41027 | 1280 | 34 |
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);