ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
874 rows where deaths = 3 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Klickitat 279
- Pacific 121
- Lewis 114
- Douglas 65
- Walla Walla 41
- Jefferson 34
- Grant 22
- Skamania 22
- Clallam 17
- Lincoln 16
- Pend Oreille 15
- Columbia 14
- Wahkiakum 13
- Mason 12
- Stevens 12
- Okanogan 10
- Chelan 9
- Asotin 8
- Grays Harbor 8
- Kitsap 6
- Clark 5
- Cowlitz 5
- Snohomish 5
- Skagit 4
- Yakima 4
- Whitman 3
- Adams 2
- Ferry 2
- Garfield 2
- Island 2
- …
state 1
- Washington · 874 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1764467 | 1764467 | 2021-09-28 | Skamania | Washington | 53059 | 637 | 3 |
1761218 | 1761218 | 2021-09-27 | Skamania | Washington | 53059 | 632 | 3 |
1757970 | 1757970 | 2021-09-26 | Skamania | Washington | 53059 | 619 | 3 |
1754722 | 1754722 | 2021-09-25 | Skamania | Washington | 53059 | 619 | 3 |
1751474 | 1751474 | 2021-09-24 | Skamania | Washington | 53059 | 619 | 3 |
1748225 | 1748225 | 2021-09-23 | Skamania | Washington | 53059 | 614 | 3 |
1744975 | 1744975 | 2021-09-22 | Skamania | Washington | 53059 | 610 | 3 |
1741726 | 1741726 | 2021-09-21 | Skamania | Washington | 53059 | 610 | 3 |
1738477 | 1738477 | 2021-09-20 | Skamania | Washington | 53059 | 605 | 3 |
1735228 | 1735228 | 2021-09-19 | Skamania | Washington | 53059 | 585 | 3 |
1731978 | 1731978 | 2021-09-18 | Skamania | Washington | 53059 | 585 | 3 |
1728728 | 1728728 | 2021-09-17 | Skamania | Washington | 53059 | 585 | 3 |
1725478 | 1725478 | 2021-09-16 | Skamania | Washington | 53059 | 583 | 3 |
1722229 | 1722229 | 2021-09-15 | Skamania | Washington | 53059 | 576 | 3 |
1718981 | 1718981 | 2021-09-14 | Skamania | Washington | 53059 | 574 | 3 |
1715733 | 1715733 | 2021-09-13 | Skamania | Washington | 53059 | 561 | 3 |
1712487 | 1712487 | 2021-09-12 | Skamania | Washington | 53059 | 550 | 3 |
1709240 | 1709240 | 2021-09-11 | Skamania | Washington | 53059 | 550 | 3 |
1705993 | 1705993 | 2021-09-10 | Skamania | Washington | 53059 | 550 | 3 |
1702743 | 1702743 | 2021-09-09 | Skamania | Washington | 53059 | 543 | 3 |
1699494 | 1699494 | 2021-09-08 | Skamania | Washington | 53059 | 540 | 3 |
1696246 | 1696246 | 2021-09-07 | Skamania | Washington | 53059 | 530 | 3 |
1598799 | 1598799 | 2021-08-08 | Wahkiakum | Washington | 53069 | 175 | 3 |
1595550 | 1595550 | 2021-08-07 | Wahkiakum | Washington | 53069 | 175 | 3 |
1592301 | 1592301 | 2021-08-06 | Wahkiakum | Washington | 53069 | 175 | 3 |
1589052 | 1589052 | 2021-08-05 | Wahkiakum | Washington | 53069 | 173 | 3 |
1585803 | 1585803 | 2021-08-04 | Wahkiakum | Washington | 53069 | 172 | 3 |
1582553 | 1582553 | 2021-08-03 | Wahkiakum | Washington | 53069 | 172 | 3 |
1579303 | 1579303 | 2021-08-02 | Wahkiakum | Washington | 53069 | 169 | 3 |
1576055 | 1576055 | 2021-08-01 | Wahkiakum | Washington | 53069 | 163 | 3 |
1572807 | 1572807 | 2021-07-31 | Wahkiakum | Washington | 53069 | 163 | 3 |
1569559 | 1569559 | 2021-07-30 | Wahkiakum | Washington | 53069 | 163 | 3 |
1566311 | 1566311 | 2021-07-29 | Wahkiakum | Washington | 53069 | 163 | 3 |
1563063 | 1563063 | 2021-07-28 | Wahkiakum | Washington | 53069 | 163 | 3 |
1559815 | 1559815 | 2021-07-27 | Wahkiakum | Washington | 53069 | 162 | 3 |
1355290 | 1355290 | 2021-05-25 | Jefferson | Washington | 53031 | 414 | 3 |
1352044 | 1352044 | 2021-05-24 | Jefferson | Washington | 53031 | 412 | 3 |
1348798 | 1348798 | 2021-05-23 | Jefferson | Washington | 53031 | 411 | 3 |
1345550 | 1345550 | 2021-05-22 | Jefferson | Washington | 53031 | 411 | 3 |
1342302 | 1342302 | 2021-05-21 | Jefferson | Washington | 53031 | 411 | 3 |
1339054 | 1339054 | 2021-05-20 | Jefferson | Washington | 53031 | 411 | 3 |
1335807 | 1335807 | 2021-05-19 | Jefferson | Washington | 53031 | 411 | 3 |
1332560 | 1332560 | 2021-05-18 | Jefferson | Washington | 53031 | 412 | 3 |
1329313 | 1329313 | 2021-05-17 | Jefferson | Washington | 53031 | 412 | 3 |
1326067 | 1326067 | 2021-05-16 | Jefferson | Washington | 53031 | 412 | 3 |
1322821 | 1322821 | 2021-05-15 | Jefferson | Washington | 53031 | 412 | 3 |
1319575 | 1319575 | 2021-05-14 | Jefferson | Washington | 53031 | 412 | 3 |
1316327 | 1316327 | 2021-05-13 | Jefferson | Washington | 53031 | 412 | 3 |
1313081 | 1313081 | 2021-05-12 | Jefferson | Washington | 53031 | 407 | 3 |
1309834 | 1309834 | 2021-05-11 | Jefferson | Washington | 53031 | 406 | 3 |
1306588 | 1306588 | 2021-05-10 | Jefferson | Washington | 53031 | 405 | 3 |
1303342 | 1303342 | 2021-05-09 | Jefferson | Washington | 53031 | 403 | 3 |
1300095 | 1300095 | 2021-05-08 | Jefferson | Washington | 53031 | 403 | 3 |
1296848 | 1296848 | 2021-05-07 | Jefferson | Washington | 53031 | 402 | 3 |
1293602 | 1293602 | 2021-05-06 | Jefferson | Washington | 53031 | 400 | 3 |
1290356 | 1290356 | 2021-05-05 | Jefferson | Washington | 53031 | 398 | 3 |
1287110 | 1287110 | 2021-05-04 | Jefferson | Washington | 53031 | 397 | 3 |
1283864 | 1283864 | 2021-05-03 | Jefferson | Washington | 53031 | 396 | 3 |
1280617 | 1280617 | 2021-05-02 | Jefferson | Washington | 53031 | 395 | 3 |
1277370 | 1277370 | 2021-05-01 | Jefferson | Washington | 53031 | 395 | 3 |
1274123 | 1274123 | 2021-04-30 | Jefferson | Washington | 53031 | 390 | 3 |
1270876 | 1270876 | 2021-04-29 | Jefferson | Washington | 53031 | 388 | 3 |
1267629 | 1267629 | 2021-04-28 | Jefferson | Washington | 53031 | 388 | 3 |
1264382 | 1264382 | 2021-04-27 | Jefferson | Washington | 53031 | 385 | 3 |
1261135 | 1261135 | 2021-04-26 | Jefferson | Washington | 53031 | 385 | 3 |
1257888 | 1257888 | 2021-04-25 | Jefferson | Washington | 53031 | 385 | 3 |
1254641 | 1254641 | 2021-04-24 | Jefferson | Washington | 53031 | 385 | 3 |
1251394 | 1251394 | 2021-04-23 | Jefferson | Washington | 53031 | 381 | 3 |
1248147 | 1248147 | 2021-04-22 | Jefferson | Washington | 53031 | 380 | 3 |
949477 | 949477 | 2021-01-20 | Klickitat | Washington | 53039 | 577 | 3 |
946231 | 946231 | 2021-01-19 | Klickitat | Washington | 53039 | 569 | 3 |
942984 | 942984 | 2021-01-18 | Klickitat | Washington | 53039 | 569 | 3 |
939739 | 939739 | 2021-01-17 | Klickitat | Washington | 53039 | 569 | 3 |
936494 | 936494 | 2021-01-16 | Klickitat | Washington | 53039 | 557 | 3 |
933249 | 933249 | 2021-01-15 | Klickitat | Washington | 53039 | 557 | 3 |
930004 | 930004 | 2021-01-14 | Klickitat | Washington | 53039 | 554 | 3 |
926749 | 926749 | 2021-01-13 | Ferry | Washington | 53019 | 196 | 3 |
926751 | 926751 | 2021-01-13 | Garfield | Washington | 53023 | 100 | 3 |
926759 | 926759 | 2021-01-13 | Klickitat | Washington | 53039 | 550 | 3 |
923503 | 923503 | 2021-01-12 | Ferry | Washington | 53019 | 196 | 3 |
923505 | 923505 | 2021-01-12 | Garfield | Washington | 53023 | 100 | 3 |
923513 | 923513 | 2021-01-12 | Klickitat | Washington | 53039 | 550 | 3 |
920268 | 920268 | 2021-01-11 | Klickitat | Washington | 53039 | 540 | 3 |
917023 | 917023 | 2021-01-10 | Klickitat | Washington | 53039 | 540 | 3 |
913778 | 913778 | 2021-01-09 | Klickitat | Washington | 53039 | 540 | 3 |
910533 | 910533 | 2021-01-08 | Klickitat | Washington | 53039 | 529 | 3 |
907288 | 907288 | 2021-01-07 | Klickitat | Washington | 53039 | 506 | 3 |
904042 | 904042 | 2021-01-06 | Klickitat | Washington | 53039 | 502 | 3 |
900797 | 900797 | 2021-01-05 | Klickitat | Washington | 53039 | 498 | 3 |
897552 | 897552 | 2021-01-04 | Klickitat | Washington | 53039 | 491 | 3 |
894306 | 894306 | 2021-01-03 | Klickitat | Washington | 53039 | 491 | 3 |
891060 | 891060 | 2021-01-02 | Klickitat | Washington | 53039 | 476 | 3 |
887813 | 887813 | 2021-01-01 | Klickitat | Washington | 53039 | 476 | 3 |
884568 | 884568 | 2020-12-31 | Klickitat | Washington | 53039 | 476 | 3 |
881323 | 881323 | 2020-12-30 | Klickitat | Washington | 53039 | 443 | 3 |
878078 | 878078 | 2020-12-29 | Klickitat | Washington | 53039 | 441 | 3 |
874833 | 874833 | 2020-12-28 | Klickitat | Washington | 53039 | 437 | 3 |
871588 | 871588 | 2020-12-27 | Klickitat | Washington | 53039 | 434 | 3 |
868343 | 868343 | 2020-12-26 | Klickitat | Washington | 53039 | 434 | 3 |
865098 | 865098 | 2020-12-25 | Klickitat | Washington | 53039 | 422 | 3 |
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);