ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30,893 rows where state = "Washington" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 53033 805
- 53007 797
- 53061 795
- 53063 795
- 53071 795
- 53073 795
- 53011 794
- 53029 794
- 53031 794
- 53035 794
- 53037 794
- 53053 794
- 53057 794
- 53067 794
- 53013 793
- 53027 793
- 53077 793
- 53025 792
- 53039 791
- 53041 790
- 53043 790
- 53021 788
- 53045 788
- 53005 787
- 53009 786
- 53015 785
- 53055 785
- 53065 785
- 53075 783
- 53001 782
- …
county >30
- King 805
- Chelan 797
- Snohomish 795
- Spokane 795
- Walla Walla 795
- Whatcom 795
- Clark 794
- Island 794
- Jefferson 794
- Kitsap 794
- Kittitas 794
- Pierce 794
- Skagit 794
- Thurston 794
- Columbia 793
- Grays Harbor 793
- Yakima 793
- Grant 792
- Klickitat 791
- Lewis 790
- Lincoln 790
- Franklin 788
- Mason 788
- Benton 787
- Clallam 786
- Cowlitz 785
- San Juan 785
- Stevens 785
- Whitman 783
- Adams 782
- …
state 1
- Washington · 30,793 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1155 | 1155 | 2020-03-10 | Snohomish | Washington | 53061 | 61 | 0 |
1156 | 1156 | 2020-03-10 | Spokane | Washington | 53063 | 4 | 0 |
1157 | 1157 | 2020-03-10 | Walla Walla | Washington | 53071 | 1 | 0 |
1158 | 1158 | 2020-03-10 | Whatcom | Washington | 53073 | 1 | 0 |
1347 | 1347 | 2020-03-11 | Clark | Washington | 53011 | 1 | 0 |
1348 | 1348 | 2020-03-11 | Island | Washington | 53029 | 1 | 0 |
1349 | 1349 | 2020-03-11 | Jefferson | Washington | 53031 | 1 | 0 |
1351 | 1351 | 2020-03-11 | Kitsap | Washington | 53035 | 2 | 0 |
1352 | 1352 | 2020-03-11 | Kittitas | Washington | 53037 | 3 | 0 |
1353 | 1353 | 2020-03-11 | Pierce | Washington | 53053 | 17 | 0 |
1354 | 1354 | 2020-03-11 | Skagit | Washington | 53057 | 1 | 0 |
1356 | 1356 | 2020-03-11 | Spokane | Washington | 53063 | 4 | 0 |
1357 | 1357 | 2020-03-11 | Thurston | Washington | 53067 | 1 | 0 |
1358 | 1358 | 2020-03-11 | Walla Walla | Washington | 53071 | 1 | 0 |
1359 | 1359 | 2020-03-11 | Whatcom | Washington | 53073 | 1 | 0 |
1599 | 1599 | 2020-03-12 | Clark | Washington | 53011 | 1 | 0 |
1600 | 1600 | 2020-03-12 | Columbia | Washington | 53013 | 1 | 0 |
1601 | 1601 | 2020-03-12 | Grays Harbor | Washington | 53027 | 1 | 0 |
1602 | 1602 | 2020-03-12 | Island | Washington | 53029 | 3 | 0 |
1603 | 1603 | 2020-03-12 | Jefferson | Washington | 53031 | 1 | 0 |
1605 | 1605 | 2020-03-12 | Kitsap | Washington | 53035 | 2 | 0 |
1606 | 1606 | 2020-03-12 | Kittitas | Washington | 53037 | 3 | 0 |
1607 | 1607 | 2020-03-12 | Pierce | Washington | 53053 | 17 | 0 |
1608 | 1608 | 2020-03-12 | Skagit | Washington | 53057 | 2 | 0 |
1610 | 1610 | 2020-03-12 | Spokane | Washington | 53063 | 4 | 0 |
1611 | 1611 | 2020-03-12 | Thurston | Washington | 53067 | 1 | 0 |
1612 | 1612 | 2020-03-12 | Walla Walla | Washington | 53071 | 1 | 0 |
1613 | 1613 | 2020-03-12 | Whatcom | Washington | 53073 | 1 | 0 |
1614 | 1614 | 2020-03-12 | Yakima | Washington | 53077 | 2 | 0 |
1909 | 1909 | 2020-03-13 | Clark | Washington | 53011 | 3 | 0 |
1910 | 1910 | 2020-03-13 | Columbia | Washington | 53013 | 1 | 0 |
1911 | 1911 | 2020-03-13 | Grant | Washington | 53025 | 1 | 0 |
1912 | 1912 | 2020-03-13 | Grays Harbor | Washington | 53027 | 1 | 0 |
1913 | 1913 | 2020-03-13 | Island | Washington | 53029 | 3 | 0 |
1914 | 1914 | 2020-03-13 | Jefferson | Washington | 53031 | 1 | 0 |
1916 | 1916 | 2020-03-13 | Kitsap | Washington | 53035 | 3 | 0 |
1917 | 1917 | 2020-03-13 | Kittitas | Washington | 53037 | 3 | 0 |
1918 | 1918 | 2020-03-13 | Pierce | Washington | 53053 | 19 | 0 |
1919 | 1919 | 2020-03-13 | Skagit | Washington | 53057 | 3 | 0 |
1921 | 1921 | 2020-03-13 | Spokane | Washington | 53063 | 4 | 0 |
1922 | 1922 | 2020-03-13 | Thurston | Washington | 53067 | 3 | 0 |
1923 | 1923 | 2020-03-13 | Walla Walla | Washington | 53071 | 1 | 0 |
1924 | 1924 | 2020-03-13 | Whatcom | Washington | 53073 | 1 | 0 |
1925 | 1925 | 2020-03-13 | Yakima | Washington | 53077 | 2 | 0 |
2282 | 2282 | 2020-03-14 | Clark | Washington | 53011 | 3 | 0 |
2283 | 2283 | 2020-03-14 | Columbia | Washington | 53013 | 1 | 0 |
2284 | 2284 | 2020-03-14 | Grant | Washington | 53025 | 1 | 0 |
2285 | 2285 | 2020-03-14 | Grays Harbor | Washington | 53027 | 1 | 0 |
2286 | 2286 | 2020-03-14 | Island | Washington | 53029 | 6 | 0 |
2287 | 2287 | 2020-03-14 | Jefferson | Washington | 53031 | 1 | 0 |
2289 | 2289 | 2020-03-14 | Kitsap | Washington | 53035 | 3 | 0 |
2290 | 2290 | 2020-03-14 | Kittitas | Washington | 53037 | 3 | 0 |
2291 | 2291 | 2020-03-14 | Klickitat | Washington | 53039 | 1 | 0 |
2292 | 2292 | 2020-03-14 | Pierce | Washington | 53053 | 26 | 0 |
2293 | 2293 | 2020-03-14 | Skagit | Washington | 53057 | 3 | 0 |
2295 | 2295 | 2020-03-14 | Spokane | Washington | 53063 | 7 | 0 |
2296 | 2296 | 2020-03-14 | Thurston | Washington | 53067 | 3 | 0 |
2297 | 2297 | 2020-03-14 | Walla Walla | Washington | 53071 | 1 | 0 |
2298 | 2298 | 2020-03-14 | Whatcom | Washington | 53073 | 2 | 0 |
2299 | 2299 | 2020-03-14 | Yakima | Washington | 53077 | 3 | 0 |
2709 | 2709 | 2020-03-15 | Clark | Washington | 53011 | 3 | 0 |
2710 | 2710 | 2020-03-15 | Columbia | Washington | 53013 | 1 | 0 |
2711 | 2711 | 2020-03-15 | Grant | Washington | 53025 | 1 | 0 |
2712 | 2712 | 2020-03-15 | Grays Harbor | Washington | 53027 | 1 | 0 |
2713 | 2713 | 2020-03-15 | Island | Washington | 53029 | 6 | 0 |
2714 | 2714 | 2020-03-15 | Jefferson | Washington | 53031 | 3 | 0 |
2716 | 2716 | 2020-03-15 | Kitsap | Washington | 53035 | 5 | 0 |
2717 | 2717 | 2020-03-15 | Kittitas | Washington | 53037 | 3 | 0 |
2718 | 2718 | 2020-03-15 | Klickitat | Washington | 53039 | 1 | 0 |
2719 | 2719 | 2020-03-15 | Lewis | Washington | 53041 | 1 | 0 |
2720 | 2720 | 2020-03-15 | Lincoln | Washington | 53043 | 1 | 0 |
2721 | 2721 | 2020-03-15 | Pierce | Washington | 53053 | 29 | 0 |
2722 | 2722 | 2020-03-15 | Skagit | Washington | 53057 | 4 | 0 |
2724 | 2724 | 2020-03-15 | Spokane | Washington | 53063 | 7 | 0 |
2725 | 2725 | 2020-03-15 | Thurston | Washington | 53067 | 4 | 0 |
2726 | 2726 | 2020-03-15 | Walla Walla | Washington | 53071 | 1 | 0 |
2727 | 2727 | 2020-03-15 | Whatcom | Washington | 53073 | 3 | 0 |
2728 | 2728 | 2020-03-15 | Yakima | Washington | 53077 | 4 | 0 |
3183 | 3183 | 2020-03-16 | Clark | Washington | 53011 | 4 | 0 |
3184 | 3184 | 2020-03-16 | Columbia | Washington | 53013 | 1 | 0 |
3185 | 3185 | 2020-03-16 | Grant | Washington | 53025 | 6 | 0 |
3186 | 3186 | 2020-03-16 | Grays Harbor | Washington | 53027 | 1 | 0 |
3187 | 3187 | 2020-03-16 | Island | Washington | 53029 | 7 | 0 |
3188 | 3188 | 2020-03-16 | Jefferson | Washington | 53031 | 3 | 0 |
3190 | 3190 | 2020-03-16 | Kitsap | Washington | 53035 | 7 | 0 |
3191 | 3191 | 2020-03-16 | Kittitas | Washington | 53037 | 3 | 0 |
3192 | 3192 | 2020-03-16 | Klickitat | Washington | 53039 | 1 | 0 |
3193 | 3193 | 2020-03-16 | Lewis | Washington | 53041 | 1 | 0 |
3194 | 3194 | 2020-03-16 | Lincoln | Washington | 53043 | 1 | 0 |
3195 | 3195 | 2020-03-16 | Pierce | Washington | 53053 | 44 | 0 |
3196 | 3196 | 2020-03-16 | Skagit | Washington | 53057 | 7 | 0 |
3198 | 3198 | 2020-03-16 | Spokane | Washington | 53063 | 7 | 0 |
3199 | 3199 | 2020-03-16 | Thurston | Washington | 53067 | 4 | 0 |
3200 | 3200 | 2020-03-16 | Walla Walla | Washington | 53071 | 1 | 0 |
3201 | 3201 | 2020-03-16 | Whatcom | Washington | 53073 | 3 | 0 |
3202 | 3202 | 2020-03-16 | Yakima | Washington | 53077 | 4 | 0 |
3724 | 3724 | 2020-03-17 | Columbia | Washington | 53013 | 1 | 0 |
3725 | 3725 | 2020-03-17 | Franklin | Washington | 53021 | 1 | 0 |
3726 | 3726 | 2020-03-17 | Grant | Washington | 53025 | 6 | 0 |
3727 | 3727 | 2020-03-17 | Grays Harbor | Washington | 53027 | 1 | 0 |
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);