daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

40 rows where "last_update" is on date 2022-05-21 and province_or_state = "Washington" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Washington · 40 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-05-20 US Washington Adams 53001 4934 38 0   46.98299757 -118.5601734 2022-05-21 04:20:58 Adams, Washington, US
2022-05-20 US Washington Asotin 53003 4580 67 0   46.18894415 -117.2022851 2022-05-21 04:20:58 Asotin, Washington, US
2022-05-20 US Washington Benton 53005 53224 472 0   46.23946995 -119.5120834 2022-05-21 04:20:58 Benton, Washington, US
2022-05-20 US Washington Chelan 53007 20620 162 0   47.87046092 -120.6173956 2022-05-21 04:20:58 Chelan, Washington, US
2022-05-20 US Washington Clallam 53009 12246 142 0   48.04754642 -123.9226319 2022-05-21 04:20:58 Clallam, Washington, US
2022-05-20 US Washington Clark 53011 92553 809 0   45.77568046 -122.4829204 2022-05-21 04:20:58 Clark, Washington, US
2022-05-20 US Washington Columbia 53013 619 16 0   46.29442881 -117.9051983 2022-05-21 04:20:58 Columbia, Washington, US
2022-05-20 US Washington Cowlitz 53015 23479 347 0   46.19074721 -122.6782231 2022-05-21 04:20:58 Cowlitz, Washington, US
2022-05-20 US Washington Douglas 53017 11355 70 0   47.7361335 -119.692937 2022-05-21 04:20:58 Douglas, Washington, US
2022-05-20 US Washington Ferry 53019 1433 29 0   48.4711431 -118.5154041 2022-05-21 04:20:58 Ferry, Washington, US
2022-05-20 US Washington Franklin 53021 32747 214 0   46.53351425 -118.9018212 2022-05-21 04:20:58 Franklin, Washington, US
2022-05-20 US Washington Garfield 53023 392 7 0   46.43197502 -117.5454032 2022-05-21 04:20:58 Garfield, Washington, US
2022-05-20 US Washington Grant 53025 26036 216 0   47.20753737 -119.4500749 2022-05-21 04:20:58 Grant, Washington, US
2022-05-20 US Washington Grays Harbor 53027 17186 198 0   47.14003705 -123.7820567 2022-05-21 04:20:58 Grays Harbor, Washington, US
2022-05-20 US Washington Island 53029 10824 77 0   48.14713305 -122.5216407 2022-05-21 04:20:58 Island, Washington, US
2022-05-20 US Washington Jefferson 53031 3293 29 0   47.75003077 -123.5609704 2022-05-21 04:20:58 Jefferson, Washington, US
2022-05-20 US Washington King 53033 419201 2778 0   47.49137892 -121.8346131 2022-05-21 04:20:58 King, Washington, US
2022-05-20 US Washington Kitsap 53035 42074 346 0   47.63479026 -122.6436061 2022-05-21 04:20:58 Kitsap, Washington, US
2022-05-20 US Washington Kittitas 53037 8658 66 0   47.12521214 -120.679439 2022-05-21 04:20:58 Kittitas, Washington, US
2022-05-20 US Washington Klickitat 53039 3648 48 0   45.87325839 -120.7913598 2022-05-21 04:20:58 Klickitat, Washington, US
2022-05-20 US Washington Lewis 53041 17913 257 0   46.57756476 -122.3925769 2022-05-21 04:20:58 Lewis, Washington, US
2022-05-20 US Washington Lincoln 53043 2247 28 0   47.57705241 -118.4194388 2022-05-21 04:20:58 Lincoln, Washington, US
2022-05-20 US Washington Mason 53045 12783 139 0   47.35007586 -123.1863685 2022-05-21 04:20:58 Mason, Washington, US
2022-05-20 US Washington Okanogan 53047 8680 125 0   48.54855019 -119.7387224 2022-05-21 04:20:58 Okanogan, Washington, US
2022-05-20 US Washington Pacific 53049 3823 58 0   46.55418369 -123.7285716 2022-05-21 04:20:58 Pacific, Washington, US
2022-05-20 US Washington Pend Oreille 53051 2520 36 0   48.53234021 -117.2741804 2022-05-21 04:20:58 Pend Oreille, Washington, US
2022-05-20 US Washington Pierce 53053 201144 1426 0   47.03892768 -122.1405958 2022-05-21 04:20:58 Pierce, Washington, US
2022-05-20 US Washington San Juan 53055 1531 2 0   48.60182783 -122.96745 2022-05-21 04:20:58 San Juan, Washington, US
2022-05-20 US Washington Skagit 53057 22967 206 0   48.48171488 -121.766131 2022-05-21 04:20:58 Skagit, Washington, US
2022-05-20 US Washington Skamania 53059 1551 12 0   46.02408726 -121.9164403 2022-05-21 04:20:58 Skamania, Washington, US
2022-05-20 US Washington Snohomish 53061 161812 1152 0   48.04615983 -121.7170703 2022-05-21 04:20:58 Snohomish, Washington, US
2022-05-20 US Washington Spokane 53063 127093 1383 0   47.62113146 -117.4046494 2022-05-21 04:20:58 Spokane, Washington, US
2022-05-20 US Washington Stevens 53065 8319 147 0   48.40035475 -117.8542701 2022-05-21 04:20:58 Stevens, Washington, US
2022-05-20 US Washington Thurston 53067 49953 423 0   46.9291895 -122.8290656 2022-05-21 04:20:58 Thurston, Washington, US
2022-05-20 US Washington Unassigned 90053 3882 7 0   48.82227976 0.0 2022-05-21 04:20:58 Unassigned, Washington, US
2022-05-20 US Washington Wahkiakum 53069 538 7 0   46.2918004 -123.4250831 2022-05-21 04:20:58 Wahkiakum, Washington, US
2022-05-20 US Washington Walla Walla 53071 15739 142 0   46.23040051 -118.4775539 2022-05-21 04:20:58 Walla Walla, Washington, US
2022-05-20 US Washington Whatcom 53073 39911 301 0   48.82227976 -121.7490018 2022-05-21 04:20:58 Whatcom, Washington, US
2022-05-20 US Washington Whitman 53075 8855 90 0   46.90022523 -117.5241763 2022-05-21 04:20:58 Whitman, Washington, US
2022-05-20 US Washington Yakima 53077 72593 791 0   46.45738486 -120.7380126 2022-05-21 04:20:58 Yakima, Washington, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;