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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 53061 844
- 53063 810
- 53033 806
- 53071 803
- 53007 801
- 53011 799
- 53031 799
- 53053 799
- 53037 798
- 53035 797
- 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
- Snohomish 844
- Spokane 810
- King 806
- Walla Walla 803
- Chelan 801
- Clark 799
- Jefferson 799
- Pierce 799
- Kittitas 798
- Kitsap 797
- 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,893 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1 | 1 | 2020-01-21 | Snohomish | Washington | 53061 | 1 | 0 |
2 | 2 | 2020-01-22 | Snohomish | Washington | 53061 | 1 | 0 |
3 | 3 | 2020-01-23 | Snohomish | Washington | 53061 | 1 | 0 |
5 | 5 | 2020-01-24 | Snohomish | Washington | 53061 | 1 | 0 |
8 | 8 | 2020-01-25 | Snohomish | Washington | 53061 | 1 | 0 |
13 | 13 | 2020-01-26 | Snohomish | Washington | 53061 | 1 | 0 |
18 | 18 | 2020-01-27 | Snohomish | Washington | 53061 | 1 | 0 |
23 | 23 | 2020-01-28 | Snohomish | Washington | 53061 | 1 | 0 |
28 | 28 | 2020-01-29 | Snohomish | Washington | 53061 | 1 | 0 |
33 | 33 | 2020-01-30 | Snohomish | Washington | 53061 | 1 | 0 |
39 | 39 | 2020-01-31 | Snohomish | Washington | 53061 | 1 | 0 |
46 | 46 | 2020-02-01 | Snohomish | Washington | 53061 | 1 | 0 |
54 | 54 | 2020-02-02 | Snohomish | Washington | 53061 | 1 | 0 |
62 | 62 | 2020-02-03 | Snohomish | Washington | 53061 | 1 | 0 |
70 | 70 | 2020-02-04 | Snohomish | Washington | 53061 | 1 | 0 |
78 | 78 | 2020-02-05 | Snohomish | Washington | 53061 | 1 | 0 |
87 | 87 | 2020-02-06 | Snohomish | Washington | 53061 | 1 | 0 |
96 | 96 | 2020-02-07 | Snohomish | Washington | 53061 | 1 | 0 |
105 | 105 | 2020-02-08 | Snohomish | Washington | 53061 | 1 | 0 |
114 | 114 | 2020-02-09 | Snohomish | Washington | 53061 | 1 | 0 |
124 | 124 | 2020-02-10 | Snohomish | Washington | 53061 | 1 | 0 |
134 | 134 | 2020-02-11 | Snohomish | Washington | 53061 | 1 | 0 |
145 | 145 | 2020-02-12 | Snohomish | Washington | 53061 | 1 | 0 |
156 | 156 | 2020-02-13 | Snohomish | Washington | 53061 | 1 | 0 |
167 | 167 | 2020-02-14 | Snohomish | Washington | 53061 | 1 | 0 |
178 | 178 | 2020-02-15 | Snohomish | Washington | 53061 | 1 | 0 |
189 | 189 | 2020-02-16 | Snohomish | Washington | 53061 | 1 | 0 |
201 | 201 | 2020-02-17 | Snohomish | Washington | 53061 | 1 | 0 |
213 | 213 | 2020-02-18 | Snohomish | Washington | 53061 | 1 | 0 |
225 | 225 | 2020-02-19 | Snohomish | Washington | 53061 | 1 | 0 |
238 | 238 | 2020-02-20 | Snohomish | Washington | 53061 | 1 | 0 |
252 | 252 | 2020-02-21 | Snohomish | Washington | 53061 | 1 | 0 |
266 | 266 | 2020-02-22 | Snohomish | Washington | 53061 | 1 | 0 |
280 | 280 | 2020-02-23 | Snohomish | Washington | 53061 | 1 | 0 |
295 | 295 | 2020-02-24 | Snohomish | Washington | 53061 | 1 | 0 |
312 | 312 | 2020-02-25 | Snohomish | Washington | 53061 | 1 | 0 |
332 | 332 | 2020-02-26 | Snohomish | Washington | 53061 | 1 | 0 |
352 | 352 | 2020-02-27 | Snohomish | Washington | 53061 | 1 | 0 |
373 | 373 | 2020-02-28 | King | Washington | 53033 | 1 | 0 |
457 | 457 | 2020-03-02 | Walla Walla | Washington | 53071 | 1 | 0 |
492 | 492 | 2020-03-03 | Walla Walla | Washington | 53071 | 1 | 0 |
527 | 527 | 2020-03-04 | Chelan | Washington | 53007 | 1 | 0 |
531 | 531 | 2020-03-04 | Walla Walla | Washington | 53071 | 1 | 0 |
576 | 576 | 2020-03-05 | Chelan | Washington | 53007 | 1 | 0 |
580 | 580 | 2020-03-05 | Walla Walla | Washington | 53071 | 1 | 0 |
647 | 647 | 2020-03-06 | Chelan | Washington | 53007 | 1 | 0 |
648 | 648 | 2020-03-06 | Clark | Washington | 53011 | 1 | 0 |
649 | 649 | 2020-03-06 | Jefferson | Washington | 53031 | 1 | 0 |
651 | 651 | 2020-03-06 | Pierce | Washington | 53053 | 1 | 0 |
654 | 654 | 2020-03-06 | Walla Walla | Washington | 53071 | 1 | 0 |
741 | 741 | 2020-03-07 | Chelan | Washington | 53007 | 1 | 0 |
742 | 742 | 2020-03-07 | Clark | Washington | 53011 | 1 | 0 |
743 | 743 | 2020-03-07 | Jefferson | Washington | 53031 | 1 | 0 |
745 | 745 | 2020-03-07 | Kittitas | Washington | 53037 | 1 | 0 |
749 | 749 | 2020-03-07 | Walla Walla | Washington | 53071 | 1 | 0 |
853 | 853 | 2020-03-08 | Chelan | Washington | 53007 | 1 | 1 |
854 | 854 | 2020-03-08 | Clark | Washington | 53011 | 1 | 0 |
855 | 855 | 2020-03-08 | Jefferson | Washington | 53031 | 1 | 0 |
857 | 857 | 2020-03-08 | Kitsap | Washington | 53035 | 1 | 0 |
858 | 858 | 2020-03-08 | Kittitas | Washington | 53037 | 1 | 0 |
862 | 862 | 2020-03-08 | Walla Walla | Washington | 53071 | 1 | 0 |
984 | 984 | 2020-03-09 | Chelan | Washington | 53007 | 1 | 1 |
985 | 985 | 2020-03-09 | Clark | Washington | 53011 | 1 | 0 |
986 | 986 | 2020-03-09 | Jefferson | Washington | 53031 | 1 | 0 |
988 | 988 | 2020-03-09 | Kitsap | Washington | 53035 | 1 | 0 |
989 | 989 | 2020-03-09 | Kittitas | Washington | 53037 | 1 | 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 |
1152 | 1152 | 2020-03-10 | Kittitas | Washington | 53037 | 1 | 0 |
1154 | 1154 | 2020-03-10 | Skagit | Washington | 53057 | 1 | 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 |
1354 | 1354 | 2020-03-11 | Skagit | Washington | 53057 | 1 | 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 |
1603 | 1603 | 2020-03-12 | Jefferson | Washington | 53031 | 1 | 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 |
1908 | 1908 | 2020-03-13 | Chelan | Washington | 53007 | 1 | 1 |
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 |
1914 | 1914 | 2020-03-13 | Jefferson | Washington | 53031 | 1 | 0 |
1923 | 1923 | 2020-03-13 | Walla Walla | Washington | 53071 | 1 | 0 |
1924 | 1924 | 2020-03-13 | Whatcom | Washington | 53073 | 1 | 0 |
2281 | 2281 | 2020-03-14 | Chelan | Washington | 53007 | 1 | 1 |
2283 | 2283 | 2020-03-14 | Columbia | Washington | 53013 | 1 | 0 |
2284 | 2284 | 2020-03-14 | Grant | Washington | 53025 | 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);