ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where "date" is on date 2021-06-11 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 39
- 53001 1
- 53003 1
- 53005 1
- 53007 1
- 53009 1
- 53011 1
- 53013 1
- 53015 1
- 53017 1
- 53019 1
- 53021 1
- 53023 1
- 53025 1
- 53027 1
- 53029 1
- 53031 1
- 53033 1
- 53035 1
- 53037 1
- 53039 1
- 53041 1
- 53043 1
- 53045 1
- 53047 1
- 53049 1
- 53051 1
- 53053 1
- 53055 1
- 53057 1
- 53059 1
- 53061 1
- 53063 1
- 53065 1
- 53067 1
- 53069 1
- 53071 1
- 53073 1
- 53075 1
- 53077 1
county 39
- Adams 1
- Asotin 1
- Benton 1
- Chelan 1
- Clallam 1
- Clark 1
- Columbia 1
- Cowlitz 1
- Douglas 1
- Ferry 1
- Franklin 1
- Garfield 1
- Grant 1
- Grays Harbor 1
- Island 1
- Jefferson 1
- King 1
- Kitsap 1
- Kittitas 1
- Klickitat 1
- Lewis 1
- Lincoln 1
- Mason 1
- Okanogan 1
- Pacific 1
- Pend Oreille 1
- Pierce 1
- San Juan 1
- Skagit 1
- Skamania 1
- Snohomish 1
- Spokane 1
- Stevens 1
- Thurston 1
- Wahkiakum 1
- Walla Walla 1
- Whatcom 1
- Whitman 1
- Yakima 1
state 1
- Washington · 39 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1410450 | 1410450 | 2021-06-11 | Adams | Washington | 53001 | 2208 | 24 |
1410451 | 1410451 | 2021-06-11 | Asotin | Washington | 53003 | 1490 | 29 |
1410452 | 1410452 | 2021-06-11 | Benton | Washington | 53005 | 17492 | 222 |
1410453 | 1410453 | 2021-06-11 | Chelan | Washington | 53007 | 7037 | 68 |
1410454 | 1410454 | 2021-06-11 | Clallam | Washington | 53009 | 1373 | 12 |
1410455 | 1410455 | 2021-06-11 | Clark | Washington | 53011 | 25454 | 282 |
1410456 | 1410456 | 2021-06-11 | Columbia | Washington | 53013 | 128 | 6 |
1410457 | 1410457 | 2021-06-11 | Cowlitz | Washington | 53015 | 6416 | 85 |
1410458 | 1410458 | 2021-06-11 | Douglas | Washington | 53017 | 3732 | 23 |
1410459 | 1410459 | 2021-06-11 | Ferry | Washington | 53019 | 390 | 8 |
1410460 | 1410460 | 2021-06-11 | Franklin | Washington | 53021 | 12664 | 114 |
1410461 | 1410461 | 2021-06-11 | Garfield | Washington | 53023 | 126 | 5 |
1410462 | 1410462 | 2021-06-11 | Grant | Washington | 53025 | 10603 | 124 |
1410463 | 1410463 | 2021-06-11 | Grays Harbor | Washington | 53027 | 4514 | 74 |
1410464 | 1410464 | 2021-06-11 | Island | Washington | 53029 | 1816 | 29 |
1410465 | 1410465 | 2021-06-11 | Jefferson | Washington | 53031 | 426 | 4 |
1410466 | 1410466 | 2021-06-11 | King | Washington | 53033 | 110939 | 1616 |
1410467 | 1410467 | 2021-06-11 | Kitsap | Washington | 53035 | 8616 | 114 |
1410468 | 1410468 | 2021-06-11 | Kittitas | Washington | 53037 | 3222 | 33 |
1410469 | 1410469 | 2021-06-11 | Klickitat | Washington | 53039 | 831 | 10 |
1410470 | 1410470 | 2021-06-11 | Lewis | Washington | 53041 | 5149 | 73 |
1410471 | 1410471 | 2021-06-11 | Lincoln | Washington | 53043 | 657 | 10 |
1410472 | 1410472 | 2021-06-11 | Mason | Washington | 53045 | 2875 | 37 |
1410473 | 1410473 | 2021-06-11 | Okanogan | Washington | 53047 | 2715 | 41 |
1410474 | 1410474 | 2021-06-11 | Pacific | Washington | 53049 | 991 | 12 |
1410475 | 1410475 | 2021-06-11 | Pend Oreille | Washington | 53051 | 815 | 9 |
1410476 | 1410476 | 2021-06-11 | Pierce | Washington | 53053 | 56159 | 663 |
1410477 | 1410477 | 2021-06-11 | San Juan | Washington | 53055 | 186 | 0 |
1410478 | 1410478 | 2021-06-11 | Skagit | Washington | 53057 | 5961 | 74 |
1410479 | 1410479 | 2021-06-11 | Skamania | Washington | 53059 | 371 | 1 |
1410480 | 1410480 | 2021-06-11 | Snohomish | Washington | 53061 | 39458 | 586 |
1410481 | 1410481 | 2021-06-11 | Spokane | Washington | 53063 | 46696 | 668 |
1410482 | 1410482 | 2021-06-11 | Stevens | Washington | 53065 | 2343 | 28 |
1410483 | 1410483 | 2021-06-11 | Thurston | Washington | 53067 | 10680 | 109 |
1410484 | 1410484 | 2021-06-11 | Wahkiakum | Washington | 53069 | 148 | 1 |
1410485 | 1410485 | 2021-06-11 | Walla Walla | Washington | 53071 | 5292 | 67 |
1410486 | 1410486 | 2021-06-11 | Whatcom | Washington | 53073 | 9698 | 99 |
1410487 | 1410487 | 2021-06-11 | Whitman | Washington | 53075 | 4370 | 50 |
1410488 | 1410488 | 2021-06-11 | Yakima | Washington | 53077 | 31447 | 447 |
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);