ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where county = "Grant", deaths = 18 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2332540 | 2332540 | 2022-03-22 | Grant | Oregon | 41023 | 1652 | 18 |
2329287 | 2329287 | 2022-03-21 | Grant | Oregon | 41023 | 1647 | 18 |
2326035 | 2326035 | 2022-03-20 | Grant | Oregon | 41023 | 1647 | 18 |
2322782 | 2322782 | 2022-03-19 | Grant | Oregon | 41023 | 1647 | 18 |
2319528 | 2319528 | 2022-03-18 | Grant | Oregon | 41023 | 1647 | 18 |
2316274 | 2316274 | 2022-03-17 | Grant | Oregon | 41023 | 1644 | 18 |
2313021 | 2313021 | 2022-03-16 | Grant | Oregon | 41023 | 1635 | 18 |
2309768 | 2309768 | 2022-03-15 | Grant | Oregon | 41023 | 1632 | 18 |
2306515 | 2306515 | 2022-03-14 | Grant | Oregon | 41023 | 1626 | 18 |
2303264 | 2303264 | 2022-03-13 | Grant | Oregon | 41023 | 1609 | 18 |
2300012 | 2300012 | 2022-03-12 | Grant | Oregon | 41023 | 1609 | 18 |
2296760 | 2296760 | 2022-03-11 | Grant | Oregon | 41023 | 1609 | 18 |
2293508 | 2293508 | 2022-03-10 | Grant | Oregon | 41023 | 1603 | 18 |
2290256 | 2290256 | 2022-03-09 | Grant | Oregon | 41023 | 1597 | 18 |
2287004 | 2287004 | 2022-03-08 | Grant | Oregon | 41023 | 1593 | 18 |
2283752 | 2283752 | 2022-03-07 | Grant | Oregon | 41023 | 1585 | 18 |
2280500 | 2280500 | 2022-03-06 | Grant | Oregon | 41023 | 1572 | 18 |
2277247 | 2277247 | 2022-03-05 | Grant | Oregon | 41023 | 1572 | 18 |
2273994 | 2273994 | 2022-03-04 | Grant | Oregon | 41023 | 1572 | 18 |
2270741 | 2270741 | 2022-03-03 | Grant | Oregon | 41023 | 1569 | 18 |
2267489 | 2267489 | 2022-03-02 | Grant | Oregon | 41023 | 1564 | 18 |
2264236 | 2264236 | 2022-03-01 | Grant | Oregon | 41023 | 1564 | 18 |
2260986 | 2260986 | 2022-02-28 | Grant | Oregon | 41023 | 1558 | 18 |
2257735 | 2257735 | 2022-02-27 | Grant | Oregon | 41023 | 1555 | 18 |
2254484 | 2254484 | 2022-02-26 | Grant | Oregon | 41023 | 1555 | 18 |
2251233 | 2251233 | 2022-02-25 | Grant | Oregon | 41023 | 1555 | 18 |
2247982 | 2247982 | 2022-02-24 | Grant | Oregon | 41023 | 1546 | 18 |
2244731 | 2244731 | 2022-02-23 | Grant | Oregon | 41023 | 1546 | 18 |
2241480 | 2241480 | 2022-02-22 | Grant | Oregon | 41023 | 1546 | 18 |
2238229 | 2238229 | 2022-02-21 | Grant | Oregon | 41023 | 1546 | 18 |
2234978 | 2234978 | 2022-02-20 | Grant | Oregon | 41023 | 1546 | 18 |
2231727 | 2231727 | 2022-02-19 | Grant | Oregon | 41023 | 1546 | 18 |
2228476 | 2228476 | 2022-02-18 | Grant | Oregon | 41023 | 1546 | 18 |
2225225 | 2225225 | 2022-02-17 | Grant | Oregon | 41023 | 1546 | 18 |
2221974 | 2221974 | 2022-02-16 | Grant | Oregon | 41023 | 1536 | 18 |
2218723 | 2218723 | 2022-02-15 | Grant | Oregon | 41023 | 1533 | 18 |
2215472 | 2215472 | 2022-02-14 | Grant | Oregon | 41023 | 1528 | 18 |
2212221 | 2212221 | 2022-02-13 | Grant | Oregon | 41023 | 1528 | 18 |
2208968 | 2208968 | 2022-02-12 | Grant | Oregon | 41023 | 1528 | 18 |
2205715 | 2205715 | 2022-02-11 | Grant | Oregon | 41023 | 1528 | 18 |
2202462 | 2202462 | 2022-02-10 | Grant | Oregon | 41023 | 1526 | 18 |
2199208 | 2199208 | 2022-02-09 | Grant | Oregon | 41023 | 1527 | 18 |
2195954 | 2195954 | 2022-02-08 | Grant | Oregon | 41023 | 1519 | 18 |
2192700 | 2192700 | 2022-02-07 | Grant | Oregon | 41023 | 1506 | 18 |
2189446 | 2189446 | 2022-02-06 | Grant | Oregon | 41023 | 1506 | 18 |
2186193 | 2186193 | 2022-02-05 | Grant | Oregon | 41023 | 1506 | 18 |
2182941 | 2182941 | 2022-02-04 | Grant | Oregon | 41023 | 1506 | 18 |
2179689 | 2179689 | 2022-02-03 | Grant | Oregon | 41023 | 1491 | 18 |
2176438 | 2176438 | 2022-02-02 | Grant | Oregon | 41023 | 1485 | 18 |
2173184 | 2173184 | 2022-02-01 | Grant | Oregon | 41023 | 1479 | 18 |
2169932 | 2169932 | 2022-01-31 | Grant | Oregon | 41023 | 1469 | 18 |
2166677 | 2166677 | 2022-01-30 | Grant | Oregon | 41023 | 1469 | 18 |
2163422 | 2163422 | 2022-01-29 | Grant | Oregon | 41023 | 1469 | 18 |
2160167 | 2160167 | 2022-01-28 | Grant | Oregon | 41023 | 1469 | 18 |
2156912 | 2156912 | 2022-01-27 | Grant | Oregon | 41023 | 1454 | 18 |
2153659 | 2153659 | 2022-01-26 | Grant | Oregon | 41023 | 1452 | 18 |
2150407 | 2150407 | 2022-01-25 | Grant | Oregon | 41023 | 1411 | 18 |
2147155 | 2147155 | 2022-01-24 | Grant | Oregon | 41023 | 1410 | 18 |
2143901 | 2143901 | 2022-01-23 | Grant | Oregon | 41023 | 1374 | 18 |
2140646 | 2140646 | 2022-01-22 | Grant | Oregon | 41023 | 1374 | 18 |
2137390 | 2137390 | 2022-01-21 | Grant | Oregon | 41023 | 1374 | 18 |
2134136 | 2134136 | 2022-01-20 | Grant | Oregon | 41023 | 1374 | 18 |
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);