ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
661 rows where deaths = 6 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 |
---|---|---|---|---|---|---|---|
2501838 | 2501838 | 2022-05-13 | Sherman | Oregon | 41055 | 321 | 6 |
2498580 | 2498580 | 2022-05-12 | Sherman | Oregon | 41055 | 321 | 6 |
2495322 | 2495322 | 2022-05-11 | Sherman | Oregon | 41055 | 321 | 6 |
2492064 | 2492064 | 2022-05-10 | Sherman | Oregon | 41055 | 321 | 6 |
2488806 | 2488806 | 2022-05-09 | Sherman | Oregon | 41055 | 321 | 6 |
2485549 | 2485549 | 2022-05-08 | Sherman | Oregon | 41055 | 321 | 6 |
2482291 | 2482291 | 2022-05-07 | Sherman | Oregon | 41055 | 321 | 6 |
2479033 | 2479033 | 2022-05-06 | Sherman | Oregon | 41055 | 321 | 6 |
2475775 | 2475775 | 2022-05-05 | Sherman | Oregon | 41055 | 321 | 6 |
2472518 | 2472518 | 2022-05-04 | Sherman | Oregon | 41055 | 321 | 6 |
2469262 | 2469262 | 2022-05-03 | Sherman | Oregon | 41055 | 320 | 6 |
2466006 | 2466006 | 2022-05-02 | Sherman | Oregon | 41055 | 320 | 6 |
2462751 | 2462751 | 2022-05-01 | Sherman | Oregon | 41055 | 320 | 6 |
2459495 | 2459495 | 2022-04-30 | Sherman | Oregon | 41055 | 320 | 6 |
2456239 | 2456239 | 2022-04-29 | Sherman | Oregon | 41055 | 320 | 6 |
2452983 | 2452983 | 2022-04-28 | Sherman | Oregon | 41055 | 320 | 6 |
2449727 | 2449727 | 2022-04-27 | Sherman | Oregon | 41055 | 320 | 6 |
2446470 | 2446470 | 2022-04-26 | Sherman | Oregon | 41055 | 320 | 6 |
2443215 | 2443215 | 2022-04-25 | Sherman | Oregon | 41055 | 319 | 6 |
2439959 | 2439959 | 2022-04-24 | Sherman | Oregon | 41055 | 319 | 6 |
2436703 | 2436703 | 2022-04-23 | Sherman | Oregon | 41055 | 319 | 6 |
2433447 | 2433447 | 2022-04-22 | Sherman | Oregon | 41055 | 319 | 6 |
2430191 | 2430191 | 2022-04-21 | Sherman | Oregon | 41055 | 319 | 6 |
2426935 | 2426935 | 2022-04-20 | Sherman | Oregon | 41055 | 320 | 6 |
2423679 | 2423679 | 2022-04-19 | Sherman | Oregon | 41055 | 319 | 6 |
2420422 | 2420422 | 2022-04-18 | Sherman | Oregon | 41055 | 318 | 6 |
2417167 | 2417167 | 2022-04-17 | Sherman | Oregon | 41055 | 318 | 6 |
2413911 | 2413911 | 2022-04-16 | Sherman | Oregon | 41055 | 318 | 6 |
2410655 | 2410655 | 2022-04-15 | Sherman | Oregon | 41055 | 318 | 6 |
2407399 | 2407399 | 2022-04-14 | Sherman | Oregon | 41055 | 318 | 6 |
2404143 | 2404143 | 2022-04-13 | Sherman | Oregon | 41055 | 319 | 6 |
2400888 | 2400888 | 2022-04-12 | Sherman | Oregon | 41055 | 319 | 6 |
2397633 | 2397633 | 2022-04-11 | Sherman | Oregon | 41055 | 319 | 6 |
2394378 | 2394378 | 2022-04-10 | Sherman | Oregon | 41055 | 319 | 6 |
2391122 | 2391122 | 2022-04-09 | Sherman | Oregon | 41055 | 319 | 6 |
2387866 | 2387866 | 2022-04-08 | Sherman | Oregon | 41055 | 319 | 6 |
2384611 | 2384611 | 2022-04-07 | Sherman | Oregon | 41055 | 319 | 6 |
2381356 | 2381356 | 2022-04-06 | Sherman | Oregon | 41055 | 319 | 6 |
2378101 | 2378101 | 2022-04-05 | Sherman | Oregon | 41055 | 319 | 6 |
2374847 | 2374847 | 2022-04-04 | Sherman | Oregon | 41055 | 318 | 6 |
1718152 | 1718152 | 2021-09-14 | Wallowa | Oregon | 41063 | 486 | 6 |
1714904 | 1714904 | 2021-09-13 | Wallowa | Oregon | 41063 | 481 | 6 |
1711658 | 1711658 | 2021-09-12 | Wallowa | Oregon | 41063 | 478 | 6 |
1708411 | 1708411 | 2021-09-11 | Wallowa | Oregon | 41063 | 478 | 6 |
1705164 | 1705164 | 2021-09-10 | Wallowa | Oregon | 41063 | 478 | 6 |
1701914 | 1701914 | 2021-09-09 | Wallowa | Oregon | 41063 | 469 | 6 |
1698665 | 1698665 | 2021-09-08 | Wallowa | Oregon | 41063 | 466 | 6 |
1695417 | 1695417 | 2021-09-07 | Wallowa | Oregon | 41063 | 464 | 6 |
1692169 | 1692169 | 2021-09-06 | Wallowa | Oregon | 41063 | 445 | 6 |
1688920 | 1688920 | 2021-09-05 | Wallowa | Oregon | 41063 | 445 | 6 |
1685670 | 1685670 | 2021-09-04 | Wallowa | Oregon | 41063 | 445 | 6 |
1682419 | 1682419 | 2021-09-03 | Wallowa | Oregon | 41063 | 445 | 6 |
1679169 | 1679169 | 2021-09-02 | Wallowa | Oregon | 41063 | 422 | 6 |
1675921 | 1675921 | 2021-09-01 | Wallowa | Oregon | 41063 | 419 | 6 |
1672674 | 1672674 | 2021-08-31 | Wallowa | Oregon | 41063 | 412 | 6 |
1669426 | 1669426 | 2021-08-30 | Wallowa | Oregon | 41063 | 405 | 6 |
1666179 | 1666179 | 2021-08-29 | Wallowa | Oregon | 41063 | 373 | 6 |
1662931 | 1662931 | 2021-08-28 | Wallowa | Oregon | 41063 | 373 | 6 |
1659683 | 1659683 | 2021-08-27 | Wallowa | Oregon | 41063 | 373 | 6 |
1656434 | 1656434 | 2021-08-26 | Wallowa | Oregon | 41063 | 365 | 6 |
1653187 | 1653187 | 2021-08-25 | Wallowa | Oregon | 41063 | 357 | 6 |
1649940 | 1649940 | 2021-08-24 | Wallowa | Oregon | 41063 | 352 | 6 |
1646691 | 1646691 | 2021-08-23 | Wallowa | Oregon | 41063 | 348 | 6 |
1643439 | 1643439 | 2021-08-22 | Tillamook | Oregon | 41057 | 1177 | 6 |
1643442 | 1643442 | 2021-08-22 | Wallowa | Oregon | 41063 | 332 | 6 |
1640189 | 1640189 | 2021-08-21 | Tillamook | Oregon | 41057 | 1177 | 6 |
1640192 | 1640192 | 2021-08-21 | Wallowa | Oregon | 41063 | 332 | 6 |
1636939 | 1636939 | 2021-08-20 | Tillamook | Oregon | 41057 | 1177 | 6 |
1636942 | 1636942 | 2021-08-20 | Wallowa | Oregon | 41063 | 332 | 6 |
1633689 | 1633689 | 2021-08-19 | Tillamook | Oregon | 41057 | 1141 | 6 |
1633692 | 1633692 | 2021-08-19 | Wallowa | Oregon | 41063 | 327 | 6 |
1630445 | 1630445 | 2021-08-18 | Wallowa | Oregon | 41063 | 311 | 6 |
1627198 | 1627198 | 2021-08-17 | Wallowa | Oregon | 41063 | 301 | 6 |
1623951 | 1623951 | 2021-08-16 | Wallowa | Oregon | 41063 | 297 | 6 |
1620704 | 1620704 | 2021-08-15 | Wallowa | Oregon | 41063 | 286 | 6 |
1617456 | 1617456 | 2021-08-14 | Wallowa | Oregon | 41063 | 286 | 6 |
1614208 | 1614208 | 2021-08-13 | Wallowa | Oregon | 41063 | 286 | 6 |
1610959 | 1610959 | 2021-08-12 | Wallowa | Oregon | 41063 | 280 | 6 |
1607711 | 1607711 | 2021-08-11 | Wallowa | Oregon | 41063 | 273 | 6 |
1604462 | 1604462 | 2021-08-10 | Wallowa | Oregon | 41063 | 271 | 6 |
1601213 | 1601213 | 2021-08-09 | Wallowa | Oregon | 41063 | 263 | 6 |
1597965 | 1597965 | 2021-08-08 | Wallowa | Oregon | 41063 | 257 | 6 |
1594716 | 1594716 | 2021-08-07 | Wallowa | Oregon | 41063 | 257 | 6 |
1591467 | 1591467 | 2021-08-06 | Wallowa | Oregon | 41063 | 257 | 6 |
1588218 | 1588218 | 2021-08-05 | Wallowa | Oregon | 41063 | 256 | 6 |
1584968 | 1584968 | 2021-08-04 | Wallowa | Oregon | 41063 | 248 | 6 |
1581718 | 1581718 | 2021-08-03 | Wallowa | Oregon | 41063 | 245 | 6 |
1578469 | 1578469 | 2021-08-02 | Wallowa | Oregon | 41063 | 240 | 6 |
1575221 | 1575221 | 2021-08-01 | Wallowa | Oregon | 41063 | 239 | 6 |
1571973 | 1571973 | 2021-07-31 | Wallowa | Oregon | 41063 | 239 | 6 |
1568725 | 1568725 | 2021-07-30 | Wallowa | Oregon | 41063 | 239 | 6 |
1565477 | 1565477 | 2021-07-29 | Wallowa | Oregon | 41063 | 228 | 6 |
1562229 | 1562229 | 2021-07-28 | Wallowa | Oregon | 41063 | 225 | 6 |
1558981 | 1558981 | 2021-07-27 | Wallowa | Oregon | 41063 | 218 | 6 |
1555734 | 1555734 | 2021-07-26 | Wallowa | Oregon | 41063 | 215 | 6 |
1552487 | 1552487 | 2021-07-25 | Wallowa | Oregon | 41063 | 208 | 6 |
1549240 | 1549240 | 2021-07-24 | Wallowa | Oregon | 41063 | 208 | 6 |
1545993 | 1545993 | 2021-07-23 | Wallowa | Oregon | 41063 | 208 | 6 |
1542746 | 1542746 | 2021-07-22 | Wallowa | Oregon | 41063 | 208 | 6 |
1539498 | 1539498 | 2021-07-21 | Wallowa | Oregon | 41063 | 203 | 6 |
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);