ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
431 rows where deaths = 8 and state = "Washington" 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 |
---|---|---|---|---|---|---|---|
2037453 | 2037453 | 2021-12-21 | Skamania | Washington | 53059 | 895 | 8 |
1920411 | 1920411 | 2021-11-15 | Columbia | Washington | 53013 | 373 | 8 |
1917161 | 1917161 | 2021-11-14 | Columbia | Washington | 53013 | 371 | 8 |
1913911 | 1913911 | 2021-11-13 | Columbia | Washington | 53013 | 371 | 8 |
1910661 | 1910661 | 2021-11-12 | Columbia | Washington | 53013 | 371 | 8 |
1907412 | 1907412 | 2021-11-11 | Columbia | Washington | 53013 | 370 | 8 |
1904163 | 1904163 | 2021-11-10 | Columbia | Washington | 53013 | 370 | 8 |
1900913 | 1900913 | 2021-11-09 | Columbia | Washington | 53013 | 370 | 8 |
1897663 | 1897663 | 2021-11-08 | Columbia | Washington | 53013 | 368 | 8 |
1894413 | 1894413 | 2021-11-07 | Columbia | Washington | 53013 | 367 | 8 |
1891163 | 1891163 | 2021-11-06 | Columbia | Washington | 53013 | 367 | 8 |
1887913 | 1887913 | 2021-11-05 | Columbia | Washington | 53013 | 367 | 8 |
1884663 | 1884663 | 2021-11-04 | Columbia | Washington | 53013 | 367 | 8 |
1881414 | 1881414 | 2021-11-03 | Columbia | Washington | 53013 | 367 | 8 |
1878165 | 1878165 | 2021-11-02 | Columbia | Washington | 53013 | 367 | 8 |
1874916 | 1874916 | 2021-11-01 | Columbia | Washington | 53013 | 366 | 8 |
1871667 | 1871667 | 2021-10-31 | Columbia | Washington | 53013 | 366 | 8 |
1868418 | 1868418 | 2021-10-30 | Columbia | Washington | 53013 | 366 | 8 |
1865169 | 1865169 | 2021-10-29 | Columbia | Washington | 53013 | 366 | 8 |
1861920 | 1861920 | 2021-10-28 | Columbia | Washington | 53013 | 366 | 8 |
1858671 | 1858671 | 2021-10-27 | Columbia | Washington | 53013 | 366 | 8 |
1855422 | 1855422 | 2021-10-26 | Columbia | Washington | 53013 | 365 | 8 |
1852173 | 1852173 | 2021-10-25 | Columbia | Washington | 53013 | 364 | 8 |
1848923 | 1848923 | 2021-10-24 | Columbia | Washington | 53013 | 363 | 8 |
1845673 | 1845673 | 2021-10-23 | Columbia | Washington | 53013 | 363 | 8 |
1842423 | 1842423 | 2021-10-22 | Columbia | Washington | 53013 | 363 | 8 |
1839174 | 1839174 | 2021-10-21 | Columbia | Washington | 53013 | 359 | 8 |
1835925 | 1835925 | 2021-10-20 | Columbia | Washington | 53013 | 358 | 8 |
1832676 | 1832676 | 2021-10-19 | Columbia | Washington | 53013 | 357 | 8 |
1829427 | 1829427 | 2021-10-18 | Columbia | Washington | 53013 | 352 | 8 |
1826178 | 1826178 | 2021-10-17 | Columbia | Washington | 53013 | 352 | 8 |
1822929 | 1822929 | 2021-10-16 | Columbia | Washington | 53013 | 352 | 8 |
1819680 | 1819680 | 2021-10-15 | Columbia | Washington | 53013 | 352 | 8 |
1816431 | 1816431 | 2021-10-14 | Columbia | Washington | 53013 | 350 | 8 |
1813183 | 1813183 | 2021-10-13 | Columbia | Washington | 53013 | 347 | 8 |
1809934 | 1809934 | 2021-10-12 | Columbia | Washington | 53013 | 343 | 8 |
1806685 | 1806685 | 2021-10-11 | Columbia | Washington | 53013 | 344 | 8 |
1611768 | 1611768 | 2021-08-12 | Ferry | Washington | 53019 | 440 | 8 |
1608521 | 1608521 | 2021-08-11 | Ferry | Washington | 53019 | 438 | 8 |
1605272 | 1605272 | 2021-08-10 | Ferry | Washington | 53019 | 436 | 8 |
1602022 | 1602022 | 2021-08-09 | Ferry | Washington | 53019 | 436 | 8 |
1598774 | 1598774 | 2021-08-08 | Ferry | Washington | 53019 | 436 | 8 |
1595525 | 1595525 | 2021-08-07 | Ferry | Washington | 53019 | 436 | 8 |
1592276 | 1592276 | 2021-08-06 | Ferry | Washington | 53019 | 436 | 8 |
1589027 | 1589027 | 2021-08-05 | Ferry | Washington | 53019 | 433 | 8 |
1585778 | 1585778 | 2021-08-04 | Ferry | Washington | 53019 | 429 | 8 |
1582528 | 1582528 | 2021-08-03 | Ferry | Washington | 53019 | 425 | 8 |
1579278 | 1579278 | 2021-08-02 | Ferry | Washington | 53019 | 423 | 8 |
1576030 | 1576030 | 2021-08-01 | Ferry | Washington | 53019 | 421 | 8 |
1572782 | 1572782 | 2021-07-31 | Ferry | Washington | 53019 | 421 | 8 |
1569534 | 1569534 | 2021-07-30 | Ferry | Washington | 53019 | 421 | 8 |
1566286 | 1566286 | 2021-07-29 | Ferry | Washington | 53019 | 418 | 8 |
1563038 | 1563038 | 2021-07-28 | Ferry | Washington | 53019 | 416 | 8 |
1559790 | 1559790 | 2021-07-27 | Ferry | Washington | 53019 | 414 | 8 |
1556543 | 1556543 | 2021-07-26 | Ferry | Washington | 53019 | 414 | 8 |
1553296 | 1553296 | 2021-07-25 | Ferry | Washington | 53019 | 414 | 8 |
1550049 | 1550049 | 2021-07-24 | Ferry | Washington | 53019 | 414 | 8 |
1546802 | 1546802 | 2021-07-23 | Ferry | Washington | 53019 | 414 | 8 |
1543555 | 1543555 | 2021-07-22 | Ferry | Washington | 53019 | 414 | 8 |
1540307 | 1540307 | 2021-07-21 | Ferry | Washington | 53019 | 411 | 8 |
1537060 | 1537060 | 2021-07-20 | Ferry | Washington | 53019 | 407 | 8 |
1533812 | 1533812 | 2021-07-19 | Ferry | Washington | 53019 | 406 | 8 |
1530565 | 1530565 | 2021-07-18 | Ferry | Washington | 53019 | 405 | 8 |
1527318 | 1527318 | 2021-07-17 | Ferry | Washington | 53019 | 405 | 8 |
1524071 | 1524071 | 2021-07-16 | Ferry | Washington | 53019 | 405 | 8 |
1520823 | 1520823 | 2021-07-15 | Ferry | Washington | 53019 | 405 | 8 |
1517575 | 1517575 | 2021-07-14 | Ferry | Washington | 53019 | 405 | 8 |
1514328 | 1514328 | 2021-07-13 | Ferry | Washington | 53019 | 405 | 8 |
1511082 | 1511082 | 2021-07-12 | Ferry | Washington | 53019 | 405 | 8 |
1507835 | 1507835 | 2021-07-11 | Ferry | Washington | 53019 | 404 | 8 |
1504589 | 1504589 | 2021-07-10 | Ferry | Washington | 53019 | 404 | 8 |
1501343 | 1501343 | 2021-07-09 | Ferry | Washington | 53019 | 404 | 8 |
1498097 | 1498097 | 2021-07-08 | Ferry | Washington | 53019 | 404 | 8 |
1494850 | 1494850 | 2021-07-07 | Ferry | Washington | 53019 | 404 | 8 |
1491603 | 1491603 | 2021-07-06 | Ferry | Washington | 53019 | 404 | 8 |
1488356 | 1488356 | 2021-07-05 | Ferry | Washington | 53019 | 404 | 8 |
1485109 | 1485109 | 2021-07-04 | Ferry | Washington | 53019 | 404 | 8 |
1481863 | 1481863 | 2021-07-03 | Ferry | Washington | 53019 | 404 | 8 |
1478616 | 1478616 | 2021-07-02 | Ferry | Washington | 53019 | 404 | 8 |
1475370 | 1475370 | 2021-07-01 | Ferry | Washington | 53019 | 399 | 8 |
1472124 | 1472124 | 2021-06-30 | Ferry | Washington | 53019 | 399 | 8 |
1468879 | 1468879 | 2021-06-29 | Ferry | Washington | 53019 | 399 | 8 |
1465634 | 1465634 | 2021-06-28 | Ferry | Washington | 53019 | 399 | 8 |
1462389 | 1462389 | 2021-06-27 | Ferry | Washington | 53019 | 399 | 8 |
1459144 | 1459144 | 2021-06-26 | Ferry | Washington | 53019 | 399 | 8 |
1455899 | 1455899 | 2021-06-25 | Ferry | Washington | 53019 | 399 | 8 |
1452654 | 1452654 | 2021-06-24 | Ferry | Washington | 53019 | 399 | 8 |
1449408 | 1449408 | 2021-06-23 | Ferry | Washington | 53019 | 397 | 8 |
1446163 | 1446163 | 2021-06-22 | Ferry | Washington | 53019 | 397 | 8 |
1442918 | 1442918 | 2021-06-21 | Ferry | Washington | 53019 | 397 | 8 |
1439673 | 1439673 | 2021-06-20 | Ferry | Washington | 53019 | 397 | 8 |
1436426 | 1436426 | 2021-06-19 | Ferry | Washington | 53019 | 397 | 8 |
1433179 | 1433179 | 2021-06-18 | Ferry | Washington | 53019 | 395 | 8 |
1429933 | 1429933 | 2021-06-17 | Ferry | Washington | 53019 | 394 | 8 |
1426688 | 1426688 | 2021-06-16 | Ferry | Washington | 53019 | 394 | 8 |
1423442 | 1423442 | 2021-06-15 | Ferry | Washington | 53019 | 394 | 8 |
1420195 | 1420195 | 2021-06-14 | Ferry | Washington | 53019 | 394 | 8 |
1416950 | 1416950 | 2021-06-13 | Ferry | Washington | 53019 | 394 | 8 |
1413704 | 1413704 | 2021-06-12 | Ferry | Washington | 53019 | 394 | 8 |
1410459 | 1410459 | 2021-06-11 | Ferry | Washington | 53019 | 390 | 8 |
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);