ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

30,893 rows where state = "Washington" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • Washington · 30,893 ✖
Link rowid date ▲ county state fips cases deaths
2502643 2502643 2022-05-13 Adams Washington 53001 4926 39
2502644 2502644 2022-05-13 Asotin Washington 53003 4554 66
2502645 2502645 2022-05-13 Benton Washington 53005 53006 472
2502646 2502646 2022-05-13 Chelan Washington 53007 20463 162
2502647 2502647 2022-05-13 Clallam Washington 53009 11901 141
2502648 2502648 2022-05-13 Clark Washington 53011 91435 804
2502649 2502649 2022-05-13 Columbia Washington 53013 613 16
2502650 2502650 2022-05-13 Cowlitz Washington 53015 23312 347
2502651 2502651 2022-05-13 Douglas Washington 53017 11269 70
2502652 2502652 2022-05-13 Ferry Washington 53019 1420 29
2502653 2502653 2022-05-13 Franklin Washington 53021 32668 214
2502654 2502654 2022-05-13 Garfield Washington 53023 389 7
2502655 2502655 2022-05-13 Grant Washington 53025 27251 259
2502656 2502656 2022-05-13 Grays Harbor Washington 53027 16620 198
2502657 2502657 2022-05-13 Island Washington 53029 10635 76
2502658 2502658 2022-05-13 Jefferson Washington 53031 3198 29
2502659 2502659 2022-05-13 King Washington 53033 410322 2774
2502660 2502660 2022-05-13 Kitsap Washington 53035 41506 344
2502661 2502661 2022-05-13 Kittitas Washington 53037 8607 66
2502662 2502662 2022-05-13 Klickitat Washington 53039 3612 47
2502663 2502663 2022-05-13 Lewis Washington 53041 17798 254
2502664 2502664 2022-05-13 Lincoln Washington 53043 2224 28
2502665 2502665 2022-05-13 Mason Washington 53045 12661 139
2502666 2502666 2022-05-13 Okanogan Washington 53047 8660 125
2502667 2502667 2022-05-13 Pacific Washington 53049 3795 57
2502668 2502668 2022-05-13 Pend Oreille Washington 53051 2508 36
2502669 2502669 2022-05-13 Pierce Washington 53053 198375 1409
2502670 2502670 2022-05-13 San Juan Washington 53055 1450 2
2502671 2502671 2022-05-13 Skagit Washington 53057 22747 204
2502672 2502672 2022-05-13 Skamania Washington 53059 1531 12
2502673 2502673 2022-05-13 Snohomish Washington 53061 159246 1145
2502674 2502674 2022-05-13 Spokane Washington 53063 126131 1378
2502675 2502675 2022-05-13 Stevens Washington 53065 8277 147
2502676 2502676 2022-05-13 Thurston Washington 53067 49071 417
2502677 2502677 2022-05-13 Unknown Washington   3265 0
2502678 2502678 2022-05-13 Wahkiakum Washington 53069 537 7
2502679 2502679 2022-05-13 Walla Walla Washington 53071 16305 142
2502680 2502680 2022-05-13 Whatcom Washington 53073 39343 301
2502681 2502681 2022-05-13 Whitman Washington 53075 8806 90
2502682 2502682 2022-05-13 Yakima Washington 53077 73887 790
2499385 2499385 2022-05-12 Adams Washington 53001 4925 39
2499386 2499386 2022-05-12 Asotin Washington 53003 4545 66
2499387 2499387 2022-05-12 Benton Washington 53005 52943 472
2499388 2499388 2022-05-12 Chelan Washington 53007 20426 162
2499389 2499389 2022-05-12 Clallam Washington 53009 11826 140
2499390 2499390 2022-05-12 Clark Washington 53011 91106 801
2499391 2499391 2022-05-12 Columbia Washington 53013 613 16
2499392 2499392 2022-05-12 Cowlitz Washington 53015 23251 347
2499393 2499393 2022-05-12 Douglas Washington 53017 11246 70
2499394 2499394 2022-05-12 Ferry Washington 53019 1420 29
2499395 2499395 2022-05-12 Franklin Washington 53021 32654 214
2499396 2499396 2022-05-12 Garfield Washington 53023 389 7
2499397 2499397 2022-05-12 Grant Washington 53025 27251 259
2499398 2499398 2022-05-12 Grays Harbor Washington 53027 16566 198
2499399 2499399 2022-05-12 Island Washington 53029 10569 76
2499400 2499400 2022-05-12 Jefferson Washington 53031 3180 29
2499401 2499401 2022-05-12 King Washington 53033 407538 2765
2499402 2499402 2022-05-12 Kitsap Washington 53035 41312 343
2499403 2499403 2022-05-12 Kittitas Washington 53037 8585 66
2499404 2499404 2022-05-12 Klickitat Washington 53039 3604 46
2499405 2499405 2022-05-12 Lewis Washington 53041 17762 254
2499406 2499406 2022-05-12 Lincoln Washington 53043 2219 28
2499407 2499407 2022-05-12 Mason Washington 53045 12589 139
2499408 2499408 2022-05-12 Okanogan Washington 53047 8653 125
2499409 2499409 2022-05-12 Pacific Washington 53049 3792 57
2499410 2499410 2022-05-12 Pend Oreille Washington 53051 2507 36
2499411 2499411 2022-05-12 Pierce Washington 53053 197657 1406
2499412 2499412 2022-05-12 San Juan Washington 53055 1403 2
2499413 2499413 2022-05-12 Skagit Washington 53057 22693 204
2499414 2499414 2022-05-12 Skamania Washington 53059 1529 13
2499415 2499415 2022-05-12 Snohomish Washington 53061 158407 1145
2499416 2499416 2022-05-12 Spokane Washington 53063 125953 1374
2499417 2499417 2022-05-12 Stevens Washington 53065 8269 147
2499418 2499418 2022-05-12 Thurston Washington 53067 48867 417
2499419 2499419 2022-05-12 Unknown Washington   3265 0
2499420 2499420 2022-05-12 Wahkiakum Washington 53069 537 7
2499421 2499421 2022-05-12 Walla Walla Washington 53071 16290 141
2499422 2499422 2022-05-12 Whatcom Washington 53073 39188 300
2499423 2499423 2022-05-12 Whitman Washington 53075 8789 90
2499424 2499424 2022-05-12 Yakima Washington 53077 73738 790
2496127 2496127 2022-05-11 Adams Washington 53001 4925 39
2496128 2496128 2022-05-11 Asotin Washington 53003 4545 66
2496129 2496129 2022-05-11 Benton Washington 53005 52943 472
2496130 2496130 2022-05-11 Chelan Washington 53007 20426 162
2496131 2496131 2022-05-11 Clallam Washington 53009 11826 140
2496132 2496132 2022-05-11 Clark Washington 53011 91106 801
2496133 2496133 2022-05-11 Columbia Washington 53013 613 16
2496134 2496134 2022-05-11 Cowlitz Washington 53015 23251 347
2496135 2496135 2022-05-11 Douglas Washington 53017 11246 70
2496136 2496136 2022-05-11 Ferry Washington 53019 1420 29
2496137 2496137 2022-05-11 Franklin Washington 53021 32654 214
2496138 2496138 2022-05-11 Garfield Washington 53023 389 7
2496139 2496139 2022-05-11 Grant Washington 53025 27146 259
2496140 2496140 2022-05-11 Grays Harbor Washington 53027 16566 198
2496141 2496141 2022-05-11 Island Washington 53029 10569 76
2496142 2496142 2022-05-11 Jefferson Washington 53031 3180 29
2496143 2496143 2022-05-11 King Washington 53033 407538 2765
2496144 2496144 2022-05-11 Kitsap Washington 53035 41312 343
2496145 2496145 2022-05-11 Kittitas Washington 53037 8585 66
2496146 2496146 2022-05-11 Klickitat Washington 53039 3604 46

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);