ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lincoln" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177279 | 2177279 | 2022-02-02 | Lincoln | Washington | 53043 | 2030 | 27 |
2174026 | 2174026 | 2022-02-01 | Lincoln | Washington | 53043 | 1999 | 27 |
2170774 | 2170774 | 2022-01-31 | Lincoln | Washington | 53043 | 1999 | 27 |
2167521 | 2167521 | 2022-01-30 | Lincoln | Washington | 53043 | 1953 | 27 |
2164266 | 2164266 | 2022-01-29 | Lincoln | Washington | 53043 | 1953 | 27 |
2161011 | 2161011 | 2022-01-28 | Lincoln | Washington | 53043 | 1953 | 27 |
2157755 | 2157755 | 2022-01-27 | Lincoln | Washington | 53043 | 1936 | 26 |
2154502 | 2154502 | 2022-01-26 | Lincoln | Washington | 53043 | 1936 | 26 |
2151249 | 2151249 | 2022-01-25 | Lincoln | Washington | 53043 | 1872 | 26 |
2147997 | 2147997 | 2022-01-24 | Lincoln | Washington | 53043 | 1872 | 26 |
2144745 | 2144745 | 2022-01-23 | Lincoln | Washington | 53043 | 1819 | 26 |
2141490 | 2141490 | 2022-01-22 | Lincoln | Washington | 53043 | 1819 | 26 |
2138234 | 2138234 | 2022-01-21 | Lincoln | Washington | 53043 | 1819 | 26 |
2134979 | 2134979 | 2022-01-20 | Lincoln | Washington | 53043 | 1792 | 26 |
2131727 | 2131727 | 2022-01-19 | Lincoln | Washington | 53043 | 1761 | 26 |
2128473 | 2128473 | 2022-01-18 | Lincoln | Washington | 53043 | 1739 | 26 |
2125220 | 2125220 | 2022-01-17 | Lincoln | Washington | 53043 | 1700 | 26 |
2121968 | 2121968 | 2022-01-16 | Lincoln | Washington | 53043 | 1700 | 26 |
2118716 | 2118716 | 2022-01-15 | Lincoln | Washington | 53043 | 1700 | 26 |
2115464 | 2115464 | 2022-01-14 | Lincoln | Washington | 53043 | 1700 | 26 |
2112212 | 2112212 | 2022-01-13 | Lincoln | Washington | 53043 | 1684 | 26 |
2108960 | 2108960 | 2022-01-12 | Lincoln | Washington | 53043 | 1665 | 26 |
2105709 | 2105709 | 2022-01-11 | Lincoln | Washington | 53043 | 1634 | 26 |
2102458 | 2102458 | 2022-01-10 | Lincoln | Washington | 53043 | 1615 | 26 |
2099207 | 2099207 | 2022-01-09 | Lincoln | Washington | 53043 | 1591 | 26 |
2095956 | 2095956 | 2022-01-08 | Lincoln | Washington | 53043 | 1591 | 26 |
2092704 | 2092704 | 2022-01-07 | Lincoln | Washington | 53043 | 1591 | 26 |
2089452 | 2089452 | 2022-01-06 | Lincoln | Washington | 53043 | 1581 | 26 |
2086201 | 2086201 | 2022-01-05 | Lincoln | Washington | 53043 | 1568 | 26 |
2082949 | 2082949 | 2022-01-04 | Lincoln | Washington | 53043 | 1556 | 26 |
2079697 | 2079697 | 2022-01-03 | Lincoln | Washington | 53043 | 1552 | 26 |
2076445 | 2076445 | 2022-01-02 | Lincoln | Washington | 53043 | 1539 | 26 |
2073194 | 2073194 | 2022-01-01 | Lincoln | Washington | 53043 | 1539 | 26 |
2069943 | 2069943 | 2021-12-31 | Lincoln | Washington | 53043 | 1539 | 26 |
2066692 | 2066692 | 2021-12-30 | Lincoln | Washington | 53043 | 1539 | 26 |
2063442 | 2063442 | 2021-12-29 | Lincoln | Washington | 53043 | 1533 | 26 |
2060192 | 2060192 | 2021-12-28 | Lincoln | Washington | 53043 | 1528 | 26 |
2056943 | 2056943 | 2021-12-27 | Lincoln | Washington | 53043 | 1525 | 26 |
2053694 | 2053694 | 2021-12-26 | Lincoln | Washington | 53043 | 1524 | 26 |
2050444 | 2050444 | 2021-12-25 | Lincoln | Washington | 53043 | 1524 | 26 |
2047194 | 2047194 | 2021-12-24 | Lincoln | Washington | 53043 | 1524 | 26 |
2043944 | 2043944 | 2021-12-23 | Lincoln | Washington | 53043 | 1524 | 26 |
2040695 | 2040695 | 2021-12-22 | Lincoln | Washington | 53043 | 1523 | 26 |
2037445 | 2037445 | 2021-12-21 | Lincoln | Washington | 53043 | 1523 | 25 |
2034195 | 2034195 | 2021-12-20 | Lincoln | Washington | 53043 | 1521 | 25 |
2030945 | 2030945 | 2021-12-19 | Lincoln | Washington | 53043 | 1521 | 25 |
2027694 | 2027694 | 2021-12-18 | Lincoln | Washington | 53043 | 1521 | 25 |
2024443 | 2024443 | 2021-12-17 | Lincoln | Washington | 53043 | 1521 | 25 |
2021192 | 2021192 | 2021-12-16 | Lincoln | Washington | 53043 | 1519 | 25 |
2017941 | 2017941 | 2021-12-15 | Lincoln | Washington | 53043 | 1519 | 25 |
2014691 | 2014691 | 2021-12-14 | Lincoln | Washington | 53043 | 1517 | 25 |
2011440 | 2011440 | 2021-12-13 | Lincoln | Washington | 53043 | 1515 | 25 |
2008189 | 2008189 | 2021-12-12 | Lincoln | Washington | 53043 | 1513 | 25 |
2004938 | 2004938 | 2021-12-11 | Lincoln | Washington | 53043 | 1513 | 25 |
2001687 | 2001687 | 2021-12-10 | Lincoln | Washington | 53043 | 1513 | 25 |
1998437 | 1998437 | 2021-12-09 | Lincoln | Washington | 53043 | 1511 | 25 |
1995186 | 1995186 | 2021-12-08 | Lincoln | Washington | 53043 | 1510 | 25 |
1991935 | 1991935 | 2021-12-07 | Lincoln | Washington | 53043 | 1507 | 25 |
1988684 | 1988684 | 2021-12-06 | Lincoln | Washington | 53043 | 1504 | 25 |
1985434 | 1985434 | 2021-12-05 | Lincoln | Washington | 53043 | 1502 | 25 |
1982184 | 1982184 | 2021-12-04 | Lincoln | Washington | 53043 | 1502 | 25 |
1978934 | 1978934 | 2021-12-03 | Lincoln | Washington | 53043 | 1502 | 25 |
1975684 | 1975684 | 2021-12-02 | Lincoln | Washington | 53043 | 1502 | 25 |
1972435 | 1972435 | 2021-12-01 | Lincoln | Washington | 53043 | 1495 | 25 |
1969185 | 1969185 | 2021-11-30 | Lincoln | Washington | 53043 | 1495 | 25 |
1965935 | 1965935 | 2021-11-29 | Lincoln | Washington | 53043 | 1492 | 25 |
1962683 | 1962683 | 2021-11-28 | Lincoln | Washington | 53043 | 1489 | 25 |
1959432 | 1959432 | 2021-11-27 | Lincoln | Washington | 53043 | 1489 | 25 |
1956181 | 1956181 | 2021-11-26 | Lincoln | Washington | 53043 | 1489 | 25 |
1952930 | 1952930 | 2021-11-25 | Lincoln | Washington | 53043 | 1489 | 25 |
1949679 | 1949679 | 2021-11-24 | Lincoln | Washington | 53043 | 1489 | 25 |
1946428 | 1946428 | 2021-11-23 | Lincoln | Washington | 53043 | 1488 | 25 |
1943177 | 1943177 | 2021-11-22 | Lincoln | Washington | 53043 | 1484 | 25 |
1939927 | 1939927 | 2021-11-21 | Lincoln | Washington | 53043 | 1482 | 24 |
1936677 | 1936677 | 2021-11-20 | Lincoln | Washington | 53043 | 1482 | 24 |
1933427 | 1933427 | 2021-11-19 | Lincoln | Washington | 53043 | 1482 | 24 |
1930175 | 1930175 | 2021-11-18 | Lincoln | Washington | 53043 | 1475 | 24 |
1926925 | 1926925 | 2021-11-17 | Lincoln | Washington | 53043 | 1469 | 24 |
1923675 | 1923675 | 2021-11-16 | Lincoln | Washington | 53043 | 1464 | 23 |
1920426 | 1920426 | 2021-11-15 | Lincoln | Washington | 53043 | 1456 | 23 |
1917176 | 1917176 | 2021-11-14 | Lincoln | Washington | 53043 | 1449 | 23 |
1913926 | 1913926 | 2021-11-13 | Lincoln | Washington | 53043 | 1449 | 23 |
1910676 | 1910676 | 2021-11-12 | Lincoln | Washington | 53043 | 1449 | 23 |
1907427 | 1907427 | 2021-11-11 | Lincoln | Washington | 53043 | 1435 | 22 |
1904178 | 1904178 | 2021-11-10 | Lincoln | Washington | 53043 | 1435 | 22 |
1900928 | 1900928 | 2021-11-09 | Lincoln | Washington | 53043 | 1429 | 22 |
1897678 | 1897678 | 2021-11-08 | Lincoln | Washington | 53043 | 1418 | 22 |
1894428 | 1894428 | 2021-11-07 | Lincoln | Washington | 53043 | 1412 | 22 |
1891178 | 1891178 | 2021-11-06 | Lincoln | Washington | 53043 | 1412 | 22 |
1887928 | 1887928 | 2021-11-05 | Lincoln | Washington | 53043 | 1412 | 22 |
1884678 | 1884678 | 2021-11-04 | Lincoln | Washington | 53043 | 1407 | 22 |
1881429 | 1881429 | 2021-11-03 | Lincoln | Washington | 53043 | 1406 | 22 |
1878180 | 1878180 | 2021-11-02 | Lincoln | Washington | 53043 | 1407 | 22 |
1874931 | 1874931 | 2021-11-01 | Lincoln | Washington | 53043 | 1402 | 22 |
1871682 | 1871682 | 2021-10-31 | Lincoln | Washington | 53043 | 1390 | 22 |
1868433 | 1868433 | 2021-10-30 | Lincoln | Washington | 53043 | 1390 | 22 |
1865184 | 1865184 | 2021-10-29 | Lincoln | Washington | 53043 | 1390 | 22 |
1861935 | 1861935 | 2021-10-28 | Lincoln | Washington | 53043 | 1385 | 22 |
1858686 | 1858686 | 2021-10-27 | Lincoln | Washington | 53043 | 1370 | 22 |
1855437 | 1855437 | 2021-10-26 | Lincoln | Washington | 53043 | 1362 | 22 |
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);