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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 53035 796
- 53037 796
- 53053 796
- 53061 796
- 53063 796
- 53071 796
- 53007 795
- 53011 795
- 53031 795
- 53033 795
- 53057 795
- 53073 795
- 53029 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
- Kitsap 796
- Kittitas 796
- Pierce 796
- Snohomish 796
- Spokane 796
- Walla Walla 796
- Chelan 795
- Clark 795
- Jefferson 795
- King 795
- Skagit 795
- Whatcom 795
- Island 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 |
---|---|---|---|---|---|---|---|
988 | 988 | 2020-03-09 | Kitsap | Washington | 53035 | 1 | 0 |
989 | 989 | 2020-03-09 | Kittitas | Washington | 53037 | 1 | 0 |
990 | 990 | 2020-03-09 | Pierce | Washington | 53053 | 7 | 0 |
991 | 991 | 2020-03-09 | Snohomish | Washington | 53061 | 45 | 0 |
992 | 992 | 2020-03-09 | Spokane | Washington | 53063 | 4 | 0 |
993 | 993 | 2020-03-09 | Walla Walla | Washington | 53071 | 1 | 0 |
1147 | 1147 | 2020-03-10 | Chelan | Washington | 53007 | 1 | 1 |
1148 | 1148 | 2020-03-10 | Clark | Washington | 53011 | 1 | 0 |
1149 | 1149 | 2020-03-10 | Jefferson | Washington | 53031 | 1 | 0 |
1150 | 1150 | 2020-03-10 | King | Washington | 53033 | 191 | 23 |
1151 | 1151 | 2020-03-10 | Kitsap | Washington | 53035 | 2 | 0 |
1152 | 1152 | 2020-03-10 | Kittitas | Washington | 53037 | 1 | 0 |
1153 | 1153 | 2020-03-10 | Pierce | Washington | 53053 | 14 | 0 |
1154 | 1154 | 2020-03-10 | Skagit | Washington | 53057 | 1 | 0 |
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 |
1346 | 1346 | 2020-03-11 | Chelan | Washington | 53007 | 1 | 1 |
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 |
1350 | 1350 | 2020-03-11 | King | Washington | 53033 | 235 | 27 |
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 |
1355 | 1355 | 2020-03-11 | Snohomish | Washington | 53061 | 69 | 1 |
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 |
1598 | 1598 | 2020-03-12 | Chelan | Washington | 53007 | 1 | 1 |
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 |
1604 | 1604 | 2020-03-12 | King | Washington | 53033 | 271 | 28 |
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 |
1609 | 1609 | 2020-03-12 | Snohomish | Washington | 53061 | 107 | 3 |
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 |
1908 | 1908 | 2020-03-13 | Chelan | Washington | 53007 | 1 | 1 |
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 |
1915 | 1915 | 2020-03-13 | King | Washington | 53033 | 329 | 33 |
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 |
1920 | 1920 | 2020-03-13 | Snohomish | Washington | 53061 | 132 | 3 |
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 |
2281 | 2281 | 2020-03-14 | Chelan | Washington | 53007 | 1 | 1 |
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 |
2288 | 2288 | 2020-03-14 | King | Washington | 53033 | 389 | 36 |
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 |
2294 | 2294 | 2020-03-14 | Snohomish | Washington | 53061 | 154 | 3 |
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 |
2708 | 2708 | 2020-03-15 | Chelan | Washington | 53007 | 1 | 1 |
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 |
2715 | 2715 | 2020-03-15 | King | Washington | 53033 | 421 | 38 |
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 |
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);