ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and fips = 5143 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1803800 | 1803800 | 2021-10-11 | Washington | Arkansas | 5143 | 43893 | 464 |
1800551 | 1800551 | 2021-10-10 | Washington | Arkansas | 5143 | 43872 | 464 |
1797302 | 1797302 | 2021-10-09 | Washington | Arkansas | 5143 | 43841 | 457 |
1794053 | 1794053 | 2021-10-08 | Washington | Arkansas | 5143 | 43776 | 456 |
1790805 | 1790805 | 2021-10-07 | Washington | Arkansas | 5143 | 43725 | 456 |
1787556 | 1787556 | 2021-10-06 | Washington | Arkansas | 5143 | 43665 | 456 |
1784307 | 1784307 | 2021-10-05 | Washington | Arkansas | 5143 | 43571 | 456 |
1781058 | 1781058 | 2021-10-04 | Washington | Arkansas | 5143 | 43527 | 455 |
1777808 | 1777808 | 2021-10-03 | Washington | Arkansas | 5143 | 43510 | 455 |
1774558 | 1774558 | 2021-10-02 | Washington | Arkansas | 5143 | 43459 | 455 |
1771308 | 1771308 | 2021-10-01 | Washington | Arkansas | 5143 | 43400 | 455 |
1768059 | 1768059 | 2021-09-30 | Washington | Arkansas | 5143 | 43298 | 455 |
1764810 | 1764810 | 2021-09-29 | Washington | Arkansas | 5143 | 43233 | 455 |
1761561 | 1761561 | 2021-09-28 | Washington | Arkansas | 5143 | 43125 | 454 |
1758313 | 1758313 | 2021-09-27 | Washington | Arkansas | 5143 | 43048 | 450 |
1755065 | 1755065 | 2021-09-26 | Washington | Arkansas | 5143 | 43017 | 446 |
1751817 | 1751817 | 2021-09-25 | Washington | Arkansas | 5143 | 42995 | 446 |
1748568 | 1748568 | 2021-09-24 | Washington | Arkansas | 5143 | 42921 | 446 |
1745318 | 1745318 | 2021-09-23 | Washington | Arkansas | 5143 | 42847 | 445 |
1742069 | 1742069 | 2021-09-22 | Washington | Arkansas | 5143 | 42753 | 445 |
1738820 | 1738820 | 2021-09-21 | Washington | Arkansas | 5143 | 42649 | 442 |
1735571 | 1735571 | 2021-09-20 | Washington | Arkansas | 5143 | 42556 | 439 |
1732321 | 1732321 | 2021-09-19 | Washington | Arkansas | 5143 | 42542 | 438 |
1729071 | 1729071 | 2021-09-18 | Washington | Arkansas | 5143 | 42496 | 437 |
1725821 | 1725821 | 2021-09-17 | Washington | Arkansas | 5143 | 42388 | 436 |
1722572 | 1722572 | 2021-09-16 | Washington | Arkansas | 5143 | 42084 | 435 |
1719323 | 1719323 | 2021-09-15 | Washington | Arkansas | 5143 | 41975 | 435 |
1716075 | 1716075 | 2021-09-14 | Washington | Arkansas | 5143 | 41827 | 433 |
1712829 | 1712829 | 2021-09-13 | Washington | Arkansas | 5143 | 41737 | 433 |
1709582 | 1709582 | 2021-09-12 | Washington | Arkansas | 5143 | 41702 | 432 |
1706335 | 1706335 | 2021-09-11 | Washington | Arkansas | 5143 | 41609 | 429 |
1703087 | 1703087 | 2021-09-10 | Washington | Arkansas | 5143 | 41489 | 426 |
1699837 | 1699837 | 2021-09-09 | Washington | Arkansas | 5143 | 41351 | 424 |
1696588 | 1696588 | 2021-09-08 | Washington | Arkansas | 5143 | 41147 | 422 |
1693340 | 1693340 | 2021-09-07 | Washington | Arkansas | 5143 | 40951 | 419 |
1690091 | 1690091 | 2021-09-06 | Washington | Arkansas | 5143 | 40922 | 416 |
1686841 | 1686841 | 2021-09-05 | Washington | Arkansas | 5143 | 40829 | 415 |
1683591 | 1683591 | 2021-09-04 | Washington | Arkansas | 5143 | 40764 | 415 |
1680340 | 1680340 | 2021-09-03 | Washington | Arkansas | 5143 | 40626 | 415 |
1677092 | 1677092 | 2021-09-02 | Washington | Arkansas | 5143 | 40497 | 413 |
1673845 | 1673845 | 2021-09-01 | Washington | Arkansas | 5143 | 40314 | 412 |
1670597 | 1670597 | 2021-08-31 | Washington | Arkansas | 5143 | 39948 | 409 |
1667350 | 1667350 | 2021-08-30 | Washington | Arkansas | 5143 | 39789 | 409 |
1664103 | 1664103 | 2021-08-29 | Washington | Arkansas | 5143 | 39730 | 408 |
1660855 | 1660855 | 2021-08-28 | Washington | Arkansas | 5143 | 39660 | 408 |
1657607 | 1657607 | 2021-08-27 | Washington | Arkansas | 5143 | 39525 | 408 |
1654359 | 1654359 | 2021-08-26 | Washington | Arkansas | 5143 | 39229 | 407 |
1651112 | 1651112 | 2021-08-25 | Washington | Arkansas | 5143 | 39013 | 404 |
1647863 | 1647863 | 2021-08-24 | Washington | Arkansas | 5143 | 38641 | 402 |
1644615 | 1644615 | 2021-08-23 | Washington | Arkansas | 5143 | 38491 | 400 |
1641365 | 1641365 | 2021-08-22 | Washington | Arkansas | 5143 | 38403 | 399 |
1638115 | 1638115 | 2021-08-21 | Washington | Arkansas | 5143 | 38273 | 397 |
1634865 | 1634865 | 2021-08-20 | Washington | Arkansas | 5143 | 38041 | 397 |
1631616 | 1631616 | 2021-08-19 | Washington | Arkansas | 5143 | 37821 | 397 |
1628369 | 1628369 | 2021-08-18 | Washington | Arkansas | 5143 | 37355 | 395 |
1625122 | 1625122 | 2021-08-17 | Washington | Arkansas | 5143 | 37164 | 394 |
1621875 | 1621875 | 2021-08-16 | Washington | Arkansas | 5143 | 36958 | 392 |
1618628 | 1618628 | 2021-08-15 | Washington | Arkansas | 5143 | 36913 | 387 |
1615380 | 1615380 | 2021-08-14 | Washington | Arkansas | 5143 | 36809 | 385 |
1612131 | 1612131 | 2021-08-13 | Washington | Arkansas | 5143 | 36675 | 385 |
1608883 | 1608883 | 2021-08-12 | Washington | Arkansas | 5143 | 36362 | 384 |
1605634 | 1605634 | 2021-08-11 | Washington | Arkansas | 5143 | 36088 | 383 |
1602385 | 1602385 | 2021-08-10 | Washington | Arkansas | 5143 | 35725 | 382 |
1599136 | 1599136 | 2021-08-09 | Washington | Arkansas | 5143 | 35571 | 380 |
1595887 | 1595887 | 2021-08-08 | Washington | Arkansas | 5143 | 35524 | 376 |
1592638 | 1592638 | 2021-08-07 | Washington | Arkansas | 5143 | 35435 | 374 |
1589389 | 1589389 | 2021-08-06 | Washington | Arkansas | 5143 | 35241 | 374 |
1586140 | 1586140 | 2021-08-05 | Washington | Arkansas | 5143 | 35011 | 373 |
1582890 | 1582890 | 2021-08-04 | Washington | Arkansas | 5143 | 34771 | 373 |
1579640 | 1579640 | 2021-08-03 | Washington | Arkansas | 5143 | 34480 | 372 |
1576392 | 1576392 | 2021-08-02 | Washington | Arkansas | 5143 | 34291 | 372 |
1573144 | 1573144 | 2021-08-01 | Washington | Arkansas | 5143 | 34218 | 370 |
1569896 | 1569896 | 2021-07-31 | Washington | Arkansas | 5143 | 34032 | 367 |
1566648 | 1566648 | 2021-07-30 | Washington | Arkansas | 5143 | 33907 | 366 |
1563400 | 1563400 | 2021-07-29 | Washington | Arkansas | 5143 | 33718 | 365 |
1560152 | 1560152 | 2021-07-28 | Washington | Arkansas | 5143 | 33509 | 365 |
1556905 | 1556905 | 2021-07-27 | Washington | Arkansas | 5143 | 33377 | 365 |
1553658 | 1553658 | 2021-07-26 | Washington | Arkansas | 5143 | 33266 | 364 |
1550411 | 1550411 | 2021-07-25 | Washington | Arkansas | 5143 | 33204 | 363 |
1547164 | 1547164 | 2021-07-24 | Washington | Arkansas | 5143 | 33169 | 363 |
1543917 | 1543917 | 2021-07-23 | Washington | Arkansas | 5143 | 33024 | 362 |
1540669 | 1540669 | 2021-07-22 | Washington | Arkansas | 5143 | 32862 | 361 |
1537422 | 1537422 | 2021-07-21 | Washington | Arkansas | 5143 | 32770 | 361 |
1534174 | 1534174 | 2021-07-20 | Washington | Arkansas | 5143 | 32646 | 360 |
1530927 | 1530927 | 2021-07-19 | Washington | Arkansas | 5143 | 32525 | 360 |
1527680 | 1527680 | 2021-07-18 | Washington | Arkansas | 5143 | 32371 | 360 |
1524433 | 1524433 | 2021-07-17 | Washington | Arkansas | 5143 | 32371 | 360 |
1521185 | 1521185 | 2021-07-16 | Washington | Arkansas | 5143 | 32371 | 360 |
1517937 | 1517937 | 2021-07-15 | Washington | Arkansas | 5143 | 32284 | 360 |
1514690 | 1514690 | 2021-07-14 | Washington | Arkansas | 5143 | 32252 | 360 |
1511444 | 1511444 | 2021-07-13 | Washington | Arkansas | 5143 | 32158 | 360 |
1508197 | 1508197 | 2021-07-12 | Washington | Arkansas | 5143 | 32015 | 360 |
1504951 | 1504951 | 2021-07-11 | Washington | Arkansas | 5143 | 31908 | 360 |
1501705 | 1501705 | 2021-07-10 | Washington | Arkansas | 5143 | 31908 | 360 |
1498459 | 1498459 | 2021-07-09 | Washington | Arkansas | 5143 | 31908 | 360 |
1495212 | 1495212 | 2021-07-08 | Washington | Arkansas | 5143 | 31868 | 360 |
1491965 | 1491965 | 2021-07-07 | Washington | Arkansas | 5143 | 31802 | 360 |
1488718 | 1488718 | 2021-07-06 | Washington | Arkansas | 5143 | 31759 | 357 |
1485471 | 1485471 | 2021-07-05 | Washington | Arkansas | 5143 | 31746 | 357 |
1482225 | 1482225 | 2021-07-04 | Washington | Arkansas | 5143 | 31691 | 357 |
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);