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 rowid
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 |
296 | 296 | 2020-02-24 | Spokane | Washington | 53063 | 4 | 0 |
312 | 312 | 2020-02-25 | Snohomish | Washington | 53061 | 1 | 0 |
313 | 313 | 2020-02-25 | Spokane | Washington | 53063 | 4 | 0 |
332 | 332 | 2020-02-26 | Snohomish | Washington | 53061 | 1 | 0 |
333 | 333 | 2020-02-26 | Spokane | Washington | 53063 | 4 | 0 |
352 | 352 | 2020-02-27 | Snohomish | Washington | 53061 | 1 | 0 |
353 | 353 | 2020-02-27 | Spokane | Washington | 53063 | 4 | 0 |
373 | 373 | 2020-02-28 | King | Washington | 53033 | 1 | 0 |
374 | 374 | 2020-02-28 | Snohomish | Washington | 53061 | 2 | 0 |
375 | 375 | 2020-02-28 | Spokane | Washington | 53063 | 4 | 0 |
395 | 395 | 2020-02-29 | King | Washington | 53033 | 4 | 1 |
396 | 396 | 2020-02-29 | Snohomish | Washington | 53061 | 2 | 0 |
397 | 397 | 2020-02-29 | Spokane | Washington | 53063 | 4 | 0 |
422 | 422 | 2020-03-01 | King | Washington | 53033 | 11 | 3 |
423 | 423 | 2020-03-01 | Snohomish | Washington | 53061 | 2 | 0 |
424 | 424 | 2020-03-01 | Spokane | Washington | 53063 | 4 | 0 |
454 | 454 | 2020-03-02 | King | Washington | 53033 | 15 | 6 |
455 | 455 | 2020-03-02 | Snohomish | Washington | 53061 | 3 | 0 |
456 | 456 | 2020-03-02 | Spokane | Washington | 53063 | 4 | 0 |
457 | 457 | 2020-03-02 | Walla Walla | Washington | 53071 | 1 | 0 |
489 | 489 | 2020-03-03 | King | Washington | 53033 | 22 | 10 |
490 | 490 | 2020-03-03 | Snohomish | Washington | 53061 | 5 | 0 |
491 | 491 | 2020-03-03 | Spokane | Washington | 53063 | 4 | 0 |
492 | 492 | 2020-03-03 | Walla Walla | Washington | 53071 | 1 | 0 |
527 | 527 | 2020-03-04 | Chelan | Washington | 53007 | 1 | 0 |
528 | 528 | 2020-03-04 | King | Washington | 53033 | 33 | 11 |
529 | 529 | 2020-03-04 | Snohomish | Washington | 53061 | 8 | 0 |
530 | 530 | 2020-03-04 | Spokane | Washington | 53063 | 4 | 0 |
531 | 531 | 2020-03-04 | Walla Walla | Washington | 53071 | 1 | 0 |
576 | 576 | 2020-03-05 | Chelan | Washington | 53007 | 1 | 0 |
577 | 577 | 2020-03-05 | King | Washington | 53033 | 52 | 11 |
578 | 578 | 2020-03-05 | Snohomish | Washington | 53061 | 17 | 0 |
579 | 579 | 2020-03-05 | Spokane | Washington | 53063 | 4 | 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 |
650 | 650 | 2020-03-06 | King | Washington | 53033 | 59 | 12 |
651 | 651 | 2020-03-06 | Pierce | Washington | 53053 | 1 | 0 |
652 | 652 | 2020-03-06 | Snohomish | Washington | 53061 | 18 | 0 |
653 | 653 | 2020-03-06 | Spokane | Washington | 53063 | 4 | 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 |
744 | 744 | 2020-03-07 | King | Washington | 53033 | 72 | 16 |
745 | 745 | 2020-03-07 | Kittitas | Washington | 53037 | 1 | 0 |
746 | 746 | 2020-03-07 | Pierce | Washington | 53053 | 3 | 0 |
747 | 747 | 2020-03-07 | Snohomish | Washington | 53061 | 26 | 0 |
748 | 748 | 2020-03-07 | Spokane | Washington | 53063 | 4 | 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 |
856 | 856 | 2020-03-08 | King | Washington | 53033 | 91 | 18 |
857 | 857 | 2020-03-08 | Kitsap | Washington | 53035 | 1 | 0 |
858 | 858 | 2020-03-08 | Kittitas | Washington | 53037 | 1 | 0 |
859 | 859 | 2020-03-08 | Pierce | Washington | 53053 | 4 | 0 |
860 | 860 | 2020-03-08 | Snohomish | Washington | 53061 | 36 | 0 |
861 | 861 | 2020-03-08 | Spokane | Washington | 53063 | 4 | 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 |
987 | 987 | 2020-03-09 | King | Washington | 53033 | 117 | 21 |
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);