ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Clark" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1819679 | 1819679 | 2021-10-15 | Clark | Washington | 53011 | 39759 | 461 |
1816430 | 1816430 | 2021-10-14 | Clark | Washington | 53011 | 39591 | 457 |
1813182 | 1813182 | 2021-10-13 | Clark | Washington | 53011 | 39431 | 455 |
1809933 | 1809933 | 2021-10-12 | Clark | Washington | 53011 | 39242 | 448 |
1806684 | 1806684 | 2021-10-11 | Clark | Washington | 53011 | 39091 | 448 |
1803433 | 1803433 | 2021-10-10 | Clark | Washington | 53011 | 38703 | 444 |
1800184 | 1800184 | 2021-10-09 | Clark | Washington | 53011 | 38703 | 444 |
1796935 | 1796935 | 2021-10-08 | Clark | Washington | 53011 | 38703 | 444 |
1793686 | 1793686 | 2021-10-07 | Clark | Washington | 53011 | 38571 | 442 |
1790437 | 1790437 | 2021-10-06 | Clark | Washington | 53011 | 38414 | 438 |
1787189 | 1787189 | 2021-10-05 | Clark | Washington | 53011 | 38258 | 431 |
1783940 | 1783940 | 2021-10-04 | Clark | Washington | 53011 | 38052 | 427 |
1780691 | 1780691 | 2021-10-03 | Clark | Washington | 53011 | 37651 | 423 |
1777441 | 1777441 | 2021-10-02 | Clark | Washington | 53011 | 37651 | 423 |
1774191 | 1774191 | 2021-10-01 | Clark | Washington | 53011 | 37651 | 423 |
1770941 | 1770941 | 2021-09-30 | Clark | Washington | 53011 | 37484 | 422 |
1767692 | 1767692 | 2021-09-29 | Clark | Washington | 53011 | 37307 | 419 |
1764443 | 1764443 | 2021-09-28 | Clark | Washington | 53011 | 37140 | 417 |
1761194 | 1761194 | 2021-09-27 | Clark | Washington | 53011 | 36961 | 415 |
1757946 | 1757946 | 2021-09-26 | Clark | Washington | 53011 | 36509 | 415 |
1754698 | 1754698 | 2021-09-25 | Clark | Washington | 53011 | 36509 | 415 |
1751450 | 1751450 | 2021-09-24 | Clark | Washington | 53011 | 36509 | 415 |
1748201 | 1748201 | 2021-09-23 | Clark | Washington | 53011 | 36324 | 412 |
1744951 | 1744951 | 2021-09-22 | Clark | Washington | 53011 | 36113 | 404 |
1741702 | 1741702 | 2021-09-21 | Clark | Washington | 53011 | 35945 | 398 |
1738453 | 1738453 | 2021-09-20 | Clark | Washington | 53011 | 35791 | 392 |
1735204 | 1735204 | 2021-09-19 | Clark | Washington | 53011 | 35364 | 389 |
1731954 | 1731954 | 2021-09-18 | Clark | Washington | 53011 | 35364 | 389 |
1728704 | 1728704 | 2021-09-17 | Clark | Washington | 53011 | 35364 | 389 |
1725454 | 1725454 | 2021-09-16 | Clark | Washington | 53011 | 35172 | 383 |
1722205 | 1722205 | 2021-09-15 | Clark | Washington | 53011 | 35001 | 379 |
1718957 | 1718957 | 2021-09-14 | Clark | Washington | 53011 | 34775 | 373 |
1715709 | 1715709 | 2021-09-13 | Clark | Washington | 53011 | 34505 | 368 |
1712463 | 1712463 | 2021-09-12 | Clark | Washington | 53011 | 34110 | 362 |
1709216 | 1709216 | 2021-09-11 | Clark | Washington | 53011 | 34110 | 362 |
1705969 | 1705969 | 2021-09-10 | Clark | Washington | 53011 | 34110 | 362 |
1702719 | 1702719 | 2021-09-09 | Clark | Washington | 53011 | 34000 | 355 |
1699470 | 1699470 | 2021-09-08 | Clark | Washington | 53011 | 33783 | 350 |
1696222 | 1696222 | 2021-09-07 | Clark | Washington | 53011 | 33598 | 349 |
1692974 | 1692974 | 2021-09-06 | Clark | Washington | 53011 | 32872 | 346 |
1689725 | 1689725 | 2021-09-05 | Clark | Washington | 53011 | 32872 | 346 |
1686475 | 1686475 | 2021-09-04 | Clark | Washington | 53011 | 32872 | 346 |
1683224 | 1683224 | 2021-09-03 | Clark | Washington | 53011 | 32872 | 346 |
1679974 | 1679974 | 2021-09-02 | Clark | Washington | 53011 | 32671 | 344 |
1676726 | 1676726 | 2021-09-01 | Clark | Washington | 53011 | 32462 | 340 |
1673479 | 1673479 | 2021-08-31 | Clark | Washington | 53011 | 32098 | 335 |
1670231 | 1670231 | 2021-08-30 | Clark | Washington | 53011 | 31860 | 330 |
1666984 | 1666984 | 2021-08-29 | Clark | Washington | 53011 | 31239 | 329 |
1663736 | 1663736 | 2021-08-28 | Clark | Washington | 53011 | 31239 | 329 |
1660488 | 1660488 | 2021-08-27 | Clark | Washington | 53011 | 31239 | 329 |
1657240 | 1657240 | 2021-08-26 | Clark | Washington | 53011 | 31018 | 329 |
1653992 | 1653992 | 2021-08-25 | Clark | Washington | 53011 | 30838 | 327 |
1650746 | 1650746 | 2021-08-24 | Clark | Washington | 53011 | 30683 | 325 |
1647497 | 1647497 | 2021-08-23 | Clark | Washington | 53011 | 30467 | 322 |
1644248 | 1644248 | 2021-08-22 | Clark | Washington | 53011 | 30066 | 322 |
1640998 | 1640998 | 2021-08-21 | Clark | Washington | 53011 | 30066 | 322 |
1637748 | 1637748 | 2021-08-20 | Clark | Washington | 53011 | 30066 | 322 |
1634498 | 1634498 | 2021-08-19 | Clark | Washington | 53011 | 29890 | 320 |
1631250 | 1631250 | 2021-08-18 | Clark | Washington | 53011 | 29662 | 318 |
1628003 | 1628003 | 2021-08-17 | Clark | Washington | 53011 | 29454 | 316 |
1624756 | 1624756 | 2021-08-16 | Clark | Washington | 53011 | 29293 | 316 |
1621509 | 1621509 | 2021-08-15 | Clark | Washington | 53011 | 28843 | 316 |
1618261 | 1618261 | 2021-08-14 | Clark | Washington | 53011 | 28843 | 316 |
1615013 | 1615013 | 2021-08-13 | Clark | Washington | 53011 | 28843 | 316 |
1611764 | 1611764 | 2021-08-12 | Clark | Washington | 53011 | 28671 | 314 |
1608517 | 1608517 | 2021-08-11 | Clark | Washington | 53011 | 28500 | 311 |
1605268 | 1605268 | 2021-08-10 | Clark | Washington | 53011 | 28167 | 310 |
1602018 | 1602018 | 2021-08-09 | Clark | Washington | 53011 | 28174 | 309 |
1598770 | 1598770 | 2021-08-08 | Clark | Washington | 53011 | 27817 | 309 |
1595521 | 1595521 | 2021-08-07 | Clark | Washington | 53011 | 27817 | 309 |
1592272 | 1592272 | 2021-08-06 | Clark | Washington | 53011 | 27817 | 309 |
1589023 | 1589023 | 2021-08-05 | Clark | Washington | 53011 | 27681 | 306 |
1585774 | 1585774 | 2021-08-04 | Clark | Washington | 53011 | 27539 | 303 |
1582524 | 1582524 | 2021-08-03 | Clark | Washington | 53011 | 27433 | 303 |
1579274 | 1579274 | 2021-08-02 | Clark | Washington | 53011 | 27269 | 303 |
1576026 | 1576026 | 2021-08-01 | Clark | Washington | 53011 | 27070 | 300 |
1572778 | 1572778 | 2021-07-31 | Clark | Washington | 53011 | 27070 | 300 |
1569530 | 1569530 | 2021-07-30 | Clark | Washington | 53011 | 27070 | 300 |
1566282 | 1566282 | 2021-07-29 | Clark | Washington | 53011 | 26992 | 299 |
1563034 | 1563034 | 2021-07-28 | Clark | Washington | 53011 | 26932 | 297 |
1559786 | 1559786 | 2021-07-27 | Clark | Washington | 53011 | 26890 | 297 |
1556539 | 1556539 | 2021-07-26 | Clark | Washington | 53011 | 26814 | 297 |
1553292 | 1553292 | 2021-07-25 | Clark | Washington | 53011 | 26630 | 296 |
1550045 | 1550045 | 2021-07-24 | Clark | Washington | 53011 | 26630 | 296 |
1546798 | 1546798 | 2021-07-23 | Clark | Washington | 53011 | 26630 | 296 |
1543551 | 1543551 | 2021-07-22 | Clark | Washington | 53011 | 26601 | 295 |
1540303 | 1540303 | 2021-07-21 | Clark | Washington | 53011 | 26553 | 294 |
1537056 | 1537056 | 2021-07-20 | Clark | Washington | 53011 | 26487 | 293 |
1533808 | 1533808 | 2021-07-19 | Clark | Washington | 53011 | 26416 | 293 |
1530561 | 1530561 | 2021-07-18 | Clark | Washington | 53011 | 26324 | 293 |
1527314 | 1527314 | 2021-07-17 | Clark | Washington | 53011 | 26324 | 293 |
1524067 | 1524067 | 2021-07-16 | Clark | Washington | 53011 | 26324 | 293 |
1520819 | 1520819 | 2021-07-15 | Clark | Washington | 53011 | 26290 | 293 |
1517571 | 1517571 | 2021-07-14 | Clark | Washington | 53011 | 26254 | 293 |
1514324 | 1514324 | 2021-07-13 | Clark | Washington | 53011 | 26229 | 293 |
1511078 | 1511078 | 2021-07-12 | Clark | Washington | 53011 | 26204 | 293 |
1507831 | 1507831 | 2021-07-11 | Clark | Washington | 53011 | 26137 | 293 |
1504585 | 1504585 | 2021-07-10 | Clark | Washington | 53011 | 26137 | 293 |
1501339 | 1501339 | 2021-07-09 | Clark | Washington | 53011 | 26137 | 293 |
1498093 | 1498093 | 2021-07-08 | Clark | Washington | 53011 | 26119 | 293 |
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);