johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40,499 rows where province_or_state = "Washington" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756338 | 2756338 | 2022-12-29 | US | Washington | Adams | 53001 | 5570 | 45 | 0 | 46.98299757 | -118.5601734 | 2022-12-30 04:21:04 | Adams, Washington, US | |
2756339 | 2756339 | 2022-12-29 | US | Washington | Asotin | 53003 | 5443 | 81 | 0 | 46.18894415 | -117.2022851 | 2022-12-30 04:21:04 | Asotin, Washington, US | |
2756340 | 2756340 | 2022-12-29 | US | Washington | Benton | 53005 | 61017 | 523 | 0 | 46.23946995 | -119.5120834 | 2022-12-30 04:21:04 | Benton, Washington, US | |
2756341 | 2756341 | 2022-12-29 | US | Washington | Chelan | 53007 | 23809 | 192 | 0 | 47.87046092 | -120.6173956 | 2022-12-30 04:21:04 | Chelan, Washington, US | |
2756342 | 2756342 | 2022-12-29 | US | Washington | Clallam | 53009 | 15469 | 191 | 0 | 48.04754642 | -123.9226319 | 2022-12-30 04:21:04 | Clallam, Washington, US | |
2756343 | 2756343 | 2022-12-29 | US | Washington | Clark | 53011 | 109868 | 985 | 0 | 45.77568046 | -122.4829204 | 2022-12-30 04:21:04 | Clark, Washington, US | |
2756344 | 2756344 | 2022-12-29 | US | Washington | Columbia | 53013 | 730 | 17 | 0 | 46.29442881 | -117.9051983 | 2022-12-30 04:21:04 | Columbia, Washington, US | |
2756345 | 2756345 | 2022-12-29 | US | Washington | Cowlitz | 53015 | 26932 | 395 | 0 | 46.19074721 | -122.6782231 | 2022-12-30 04:21:04 | Cowlitz, Washington, US | |
2756346 | 2756346 | 2022-12-29 | US | Washington | Douglas | 53017 | 13113 | 84 | 0 | 47.7361335 | -119.692937 | 2022-12-30 04:21:04 | Douglas, Washington, US | |
2756347 | 2756347 | 2022-12-29 | US | Washington | Ferry | 53019 | 1772 | 32 | 0 | 48.4711431 | -118.5154041 | 2022-12-30 04:21:04 | Ferry, Washington, US | |
2756348 | 2756348 | 2022-12-29 | US | Washington | Franklin | 53021 | 36431 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-30 04:21:04 | Franklin, Washington, US | |
2756349 | 2756349 | 2022-12-29 | US | Washington | Garfield | 53023 | 490 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-12-30 04:21:04 | Garfield, Washington, US | |
2756350 | 2756350 | 2022-12-29 | US | Washington | Grant | 53025 | 30851 | 237 | 0 | 47.20753737 | -119.4500749 | 2022-12-30 04:21:04 | Grant, Washington, US | |
2756351 | 2756351 | 2022-12-29 | US | Washington | Grays Harbor | 53027 | 20118 | 244 | 0 | 47.14003705 | -123.7820567 | 2022-12-30 04:21:04 | Grays Harbor, Washington, US | |
2756352 | 2756352 | 2022-12-29 | US | Washington | Island | 53029 | 13362 | 111 | 0 | 48.14713305 | -122.5216407 | 2022-12-30 04:21:04 | Island, Washington, US | |
2756353 | 2756353 | 2022-12-29 | US | Washington | Jefferson | 53031 | 4657 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-30 04:21:04 | Jefferson, Washington, US | |
2756354 | 2756354 | 2022-12-29 | US | Washington | King | 53033 | 536662 | 3368 | 0 | 47.49137892 | -121.8346131 | 2022-12-30 04:21:04 | King, Washington, US | |
2756355 | 2756355 | 2022-12-29 | US | Washington | Kitsap | 53035 | 51235 | 404 | 0 | 47.63479026 | -122.6436061 | 2022-12-30 04:21:04 | Kitsap, Washington, US | |
2756356 | 2756356 | 2022-12-29 | US | Washington | Kittitas | 53037 | 10196 | 90 | 0 | 47.12521214 | -120.679439 | 2022-12-30 04:21:04 | Kittitas, Washington, US | |
2756357 | 2756357 | 2022-12-29 | US | Washington | Klickitat | 53039 | 4258 | 59 | 0 | 45.87325839 | -120.7913598 | 2022-12-30 04:21:04 | Klickitat, Washington, US | |
2756358 | 2756358 | 2022-12-29 | US | Washington | Lewis | 53041 | 20489 | 288 | 0 | 46.57756476 | -122.3925769 | 2022-12-30 04:21:04 | Lewis, Washington, US | |
2756359 | 2756359 | 2022-12-29 | US | Washington | Lincoln | 53043 | 2631 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-12-30 04:21:04 | Lincoln, Washington, US | |
2756360 | 2756360 | 2022-12-29 | US | Washington | Mason | 53045 | 15474 | 174 | 0 | 47.35007586 | -123.1863685 | 2022-12-30 04:21:04 | Mason, Washington, US | |
2756361 | 2756361 | 2022-12-29 | US | Washington | Okanogan | 53047 | 10343 | 137 | 0 | 48.54855019 | -119.7387224 | 2022-12-30 04:21:04 | Okanogan, Washington, US | |
2756362 | 2756362 | 2022-12-29 | US | Washington | Pacific | 53049 | 4765 | 73 | 0 | 46.55418369 | -123.7285716 | 2022-12-30 04:21:04 | Pacific, Washington, US | |
2756363 | 2756363 | 2022-12-29 | US | Washington | Pend Oreille | 53051 | 2921 | 43 | 0 | 48.53234021 | -117.2741804 | 2022-12-30 04:21:04 | Pend Oreille, Washington, US | |
2756364 | 2756364 | 2022-12-29 | US | Washington | Pierce | 53053 | 238907 | 1562 | 0 | 47.03892768 | -122.1405958 | 2022-12-30 04:21:04 | Pierce, Washington, US | |
2756365 | 2756365 | 2022-12-29 | US | Washington | San Juan | 53055 | 1923 | 3 | 0 | 48.60182783 | -122.96745 | 2022-12-30 04:21:04 | San Juan, Washington, US | |
2756366 | 2756366 | 2022-12-29 | US | Washington | Skagit | 53057 | 27952 | 253 | 0 | 48.48171488 | -121.766131 | 2022-12-30 04:21:04 | Skagit, Washington, US | |
2756367 | 2756367 | 2022-12-29 | US | Washington | Skamania | 53059 | 1775 | 17 | 0 | 46.02408726 | -121.9164403 | 2022-12-30 04:21:04 | Skamania, Washington, US | |
2756368 | 2756368 | 2022-12-29 | US | Washington | Snohomish | 53061 | 199657 | 1379 | 0 | 48.04615983 | -121.7170703 | 2022-12-30 04:21:04 | Snohomish, Washington, US | |
2756369 | 2756369 | 2022-12-29 | US | Washington | Spokane | 53063 | 150451 | 1615 | 0 | 47.62113146 | -117.4046494 | 2022-12-30 04:21:04 | Spokane, Washington, US | |
2756370 | 2756370 | 2022-12-29 | US | Washington | Stevens | 53065 | 9846 | 162 | 0 | 48.40035475 | -117.8542701 | 2022-12-30 04:21:04 | Stevens, Washington, US | |
2756371 | 2756371 | 2022-12-29 | US | Washington | Thurston | 53067 | 61542 | 495 | 0 | 46.9291895 | -122.8290656 | 2022-12-30 04:21:04 | Thurston, Washington, US | |
2756372 | 2756372 | 2022-12-29 | US | Washington | Unassigned | 90053 | 3296 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Washington, US | |
2756373 | 2756373 | 2022-12-29 | US | Washington | Wahkiakum | 53069 | 632 | 10 | 0 | 46.2918004 | -123.4250831 | 2022-12-30 04:21:04 | Wahkiakum, Washington, US | |
2756374 | 2756374 | 2022-12-29 | US | Washington | Walla Walla | 53071 | 18541 | 168 | 0 | 46.23040051 | -118.4775539 | 2022-12-30 04:21:04 | Walla Walla, Washington, US | |
2756375 | 2756375 | 2022-12-29 | US | Washington | Whatcom | 53073 | 48335 | 353 | 0 | 48.82227976 | -121.7490018 | 2022-12-30 04:21:04 | Whatcom, Washington, US | |
2756376 | 2756376 | 2022-12-29 | US | Washington | Whitman | 53075 | 9941 | 98 | 0 | 46.90022523 | -117.5241763 | 2022-12-30 04:21:04 | Whitman, Washington, US | |
2756377 | 2756377 | 2022-12-29 | US | Washington | Yakima | 53077 | 82272 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-30 04:21:04 | Yakima, Washington, US | |
1077344 | 1077344 | 2022-12-28 | US | Washington | Adams | 53001 | 5570 | 45 | 0 | 46.98299757 | -118.5601734 | 2022-12-29 04:21:01 | Adams, Washington, US | |
1077345 | 1077345 | 2022-12-28 | US | Washington | Asotin | 53003 | 5443 | 81 | 0 | 46.18894415 | -117.2022851 | 2022-12-29 04:21:01 | Asotin, Washington, US | |
1077346 | 1077346 | 2022-12-28 | US | Washington | Benton | 53005 | 61017 | 523 | 0 | 46.23946995 | -119.5120834 | 2022-12-29 04:21:01 | Benton, Washington, US | |
1077347 | 1077347 | 2022-12-28 | US | Washington | Chelan | 53007 | 23809 | 192 | 0 | 47.87046092 | -120.6173956 | 2022-12-29 04:21:01 | Chelan, Washington, US | |
1077348 | 1077348 | 2022-12-28 | US | Washington | Clallam | 53009 | 15469 | 191 | 0 | 48.04754642 | -123.9226319 | 2022-12-29 04:21:01 | Clallam, Washington, US | |
1077349 | 1077349 | 2022-12-28 | US | Washington | Clark | 53011 | 109868 | 985 | 0 | 45.77568046 | -122.4829204 | 2022-12-29 04:21:01 | Clark, Washington, US | |
1077350 | 1077350 | 2022-12-28 | US | Washington | Columbia | 53013 | 730 | 17 | 0 | 46.29442881 | -117.9051983 | 2022-12-29 04:21:01 | Columbia, Washington, US | |
1077351 | 1077351 | 2022-12-28 | US | Washington | Cowlitz | 53015 | 26932 | 395 | 0 | 46.19074721 | -122.6782231 | 2022-12-29 04:21:01 | Cowlitz, Washington, US | |
1077352 | 1077352 | 2022-12-28 | US | Washington | Douglas | 53017 | 13113 | 84 | 0 | 47.7361335 | -119.692937 | 2022-12-29 04:21:01 | Douglas, Washington, US | |
1077353 | 1077353 | 2022-12-28 | US | Washington | Ferry | 53019 | 1772 | 32 | 0 | 48.4711431 | -118.5154041 | 2022-12-29 04:21:01 | Ferry, Washington, US | |
1077354 | 1077354 | 2022-12-28 | US | Washington | Franklin | 53021 | 36431 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-29 04:21:01 | Franklin, Washington, US | |
1077355 | 1077355 | 2022-12-28 | US | Washington | Garfield | 53023 | 490 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-12-29 04:21:01 | Garfield, Washington, US | |
1077356 | 1077356 | 2022-12-28 | US | Washington | Grant | 53025 | 30851 | 237 | 0 | 47.20753737 | -119.4500749 | 2022-12-29 04:21:01 | Grant, Washington, US | |
1077357 | 1077357 | 2022-12-28 | US | Washington | Grays Harbor | 53027 | 20118 | 244 | 0 | 47.14003705 | -123.7820567 | 2022-12-29 04:21:01 | Grays Harbor, Washington, US | |
1077358 | 1077358 | 2022-12-28 | US | Washington | Island | 53029 | 13362 | 111 | 0 | 48.14713305 | -122.5216407 | 2022-12-29 04:21:01 | Island, Washington, US | |
1077359 | 1077359 | 2022-12-28 | US | Washington | Jefferson | 53031 | 4657 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-29 04:21:01 | Jefferson, Washington, US | |
1077360 | 1077360 | 2022-12-28 | US | Washington | King | 53033 | 536662 | 3368 | 0 | 47.49137892 | -121.8346131 | 2022-12-29 04:21:01 | King, Washington, US | |
1077361 | 1077361 | 2022-12-28 | US | Washington | Kitsap | 53035 | 51235 | 404 | 0 | 47.63479026 | -122.6436061 | 2022-12-29 04:21:01 | Kitsap, Washington, US | |
1077362 | 1077362 | 2022-12-28 | US | Washington | Kittitas | 53037 | 10196 | 90 | 0 | 47.12521214 | -120.679439 | 2022-12-29 04:21:01 | Kittitas, Washington, US | |
1077363 | 1077363 | 2022-12-28 | US | Washington | Klickitat | 53039 | 4258 | 59 | 0 | 45.87325839 | -120.7913598 | 2022-12-29 04:21:01 | Klickitat, Washington, US | |
1077364 | 1077364 | 2022-12-28 | US | Washington | Lewis | 53041 | 20489 | 288 | 0 | 46.57756476 | -122.3925769 | 2022-12-29 04:21:01 | Lewis, Washington, US | |
1077365 | 1077365 | 2022-12-28 | US | Washington | Lincoln | 53043 | 2631 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-12-29 04:21:01 | Lincoln, Washington, US | |
1077366 | 1077366 | 2022-12-28 | US | Washington | Mason | 53045 | 15474 | 174 | 0 | 47.35007586 | -123.1863685 | 2022-12-29 04:21:01 | Mason, Washington, US | |
1077367 | 1077367 | 2022-12-28 | US | Washington | Okanogan | 53047 | 10343 | 137 | 0 | 48.54855019 | -119.7387224 | 2022-12-29 04:21:01 | Okanogan, Washington, US | |
1077368 | 1077368 | 2022-12-28 | US | Washington | Pacific | 53049 | 4765 | 73 | 0 | 46.55418369 | -123.7285716 | 2022-12-29 04:21:01 | Pacific, Washington, US | |
1077369 | 1077369 | 2022-12-28 | US | Washington | Pend Oreille | 53051 | 2921 | 43 | 0 | 48.53234021 | -117.2741804 | 2022-12-29 04:21:01 | Pend Oreille, Washington, US | |
1077370 | 1077370 | 2022-12-28 | US | Washington | Pierce | 53053 | 238907 | 1562 | 0 | 47.03892768 | -122.1405958 | 2022-12-29 04:21:01 | Pierce, Washington, US | |
1077371 | 1077371 | 2022-12-28 | US | Washington | San Juan | 53055 | 1923 | 3 | 0 | 48.60182783 | -122.96745 | 2022-12-29 04:21:01 | San Juan, Washington, US | |
1077372 | 1077372 | 2022-12-28 | US | Washington | Skagit | 53057 | 27952 | 253 | 0 | 48.48171488 | -121.766131 | 2022-12-29 04:21:01 | Skagit, Washington, US | |
1077373 | 1077373 | 2022-12-28 | US | Washington | Skamania | 53059 | 1775 | 17 | 0 | 46.02408726 | -121.9164403 | 2022-12-29 04:21:01 | Skamania, Washington, US | |
1077374 | 1077374 | 2022-12-28 | US | Washington | Snohomish | 53061 | 199657 | 1379 | 0 | 48.04615983 | -121.7170703 | 2022-12-29 04:21:01 | Snohomish, Washington, US | |
1077375 | 1077375 | 2022-12-28 | US | Washington | Spokane | 53063 | 150451 | 1615 | 0 | 47.62113146 | -117.4046494 | 2022-12-29 04:21:01 | Spokane, Washington, US | |
1077376 | 1077376 | 2022-12-28 | US | Washington | Stevens | 53065 | 9846 | 162 | 0 | 48.40035475 | -117.8542701 | 2022-12-29 04:21:01 | Stevens, Washington, US | |
1077377 | 1077377 | 2022-12-28 | US | Washington | Thurston | 53067 | 61542 | 495 | 0 | 46.9291895 | -122.8290656 | 2022-12-29 04:21:01 | Thurston, Washington, US | |
1077378 | 1077378 | 2022-12-28 | US | Washington | Unassigned | 90053 | 3296 | 6 | 0 | 48.82227976 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Washington, US | |
1077379 | 1077379 | 2022-12-28 | US | Washington | Wahkiakum | 53069 | 632 | 10 | 0 | 46.2918004 | -123.4250831 | 2022-12-29 04:21:01 | Wahkiakum, Washington, US | |
1077380 | 1077380 | 2022-12-28 | US | Washington | Walla Walla | 53071 | 18541 | 168 | 0 | 46.23040051 | -118.4775539 | 2022-12-29 04:21:01 | Walla Walla, Washington, US | |
1077381 | 1077381 | 2022-12-28 | US | Washington | Whatcom | 53073 | 48335 | 353 | 0 | 48.82227976 | -121.7490018 | 2022-12-29 04:21:01 | Whatcom, Washington, US | |
1077382 | 1077382 | 2022-12-28 | US | Washington | Whitman | 53075 | 9941 | 98 | 0 | 46.90022523 | -117.5241763 | 2022-12-29 04:21:01 | Whitman, Washington, US | |
1077383 | 1077383 | 2022-12-28 | US | Washington | Yakima | 53077 | 82272 | 847 | 0 | 46.45738486 | -120.7380126 | 2022-12-29 04:21:01 | Yakima, Washington, US | |
331341 | 331341 | 2022-12-27 | US | Washington | Adams | 53001 | 5566 | 44 | 0 | 46.98299757 | -118.5601734 | 2022-12-28 04:21:04 | Adams, Washington, US | |
331342 | 331342 | 2022-12-27 | US | Washington | Asotin | 53003 | 5425 | 79 | 0 | 46.18894415 | -117.2022851 | 2022-12-28 04:21:04 | Asotin, Washington, US | |
331343 | 331343 | 2022-12-27 | US | Washington | Benton | 53005 | 60914 | 523 | 0 | 46.23946995 | -119.5120834 | 2022-12-28 04:21:04 | Benton, Washington, US | |
331344 | 331344 | 2022-12-27 | US | Washington | Chelan | 53007 | 23781 | 192 | 0 | 47.87046092 | -120.6173956 | 2022-12-28 04:21:04 | Chelan, Washington, US | |
331345 | 331345 | 2022-12-27 | US | Washington | Clallam | 53009 | 15434 | 189 | 0 | 48.04754642 | -123.9226319 | 2022-12-28 04:21:04 | Clallam, Washington, US | |
331346 | 331346 | 2022-12-27 | US | Washington | Clark | 53011 | 109709 | 980 | 0 | 45.77568046 | -122.4829204 | 2022-12-28 04:21:04 | Clark, Washington, US | |
331347 | 331347 | 2022-12-27 | US | Washington | Columbia | 53013 | 729 | 17 | 0 | 46.29442881 | -117.9051983 | 2022-12-28 04:21:04 | Columbia, Washington, US | |
331348 | 331348 | 2022-12-27 | US | Washington | Cowlitz | 53015 | 26873 | 392 | 0 | 46.19074721 | -122.6782231 | 2022-12-28 04:21:04 | Cowlitz, Washington, US | |
331349 | 331349 | 2022-12-27 | US | Washington | Douglas | 53017 | 13101 | 84 | 0 | 47.7361335 | -119.692937 | 2022-12-28 04:21:04 | Douglas, Washington, US | |
331350 | 331350 | 2022-12-27 | US | Washington | Ferry | 53019 | 1766 | 32 | 0 | 48.4711431 | -118.5154041 | 2022-12-28 04:21:04 | Ferry, Washington, US | |
331351 | 331351 | 2022-12-27 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-28 04:21:04 | Franklin, Washington, US | |
331352 | 331352 | 2022-12-27 | US | Washington | Garfield | 53023 | 489 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-12-28 04:21:04 | Garfield, Washington, US | |
331353 | 331353 | 2022-12-27 | US | Washington | Grant | 53025 | 30792 | 236 | 0 | 47.20753737 | -119.4500749 | 2022-12-28 04:21:04 | Grant, Washington, US | |
331354 | 331354 | 2022-12-27 | US | Washington | Grays Harbor | 53027 | 20083 | 243 | 0 | 47.14003705 | -123.7820567 | 2022-12-28 04:21:04 | Grays Harbor, Washington, US | |
331355 | 331355 | 2022-12-27 | US | Washington | Island | 53029 | 13307 | 109 | 0 | 48.14713305 | -122.5216407 | 2022-12-28 04:21:04 | Island, Washington, US | |
331356 | 331356 | 2022-12-27 | US | Washington | Jefferson | 53031 | 4634 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-28 04:21:04 | Jefferson, Washington, US | |
331357 | 331357 | 2022-12-27 | US | Washington | King | 53033 | 535278 | 3359 | 0 | 47.49137892 | -121.8346131 | 2022-12-28 04:21:04 | King, Washington, US | |
331358 | 331358 | 2022-12-27 | US | Washington | Kitsap | 53035 | 51105 | 400 | 0 | 47.63479026 | -122.6436061 | 2022-12-28 04:21:04 | Kitsap, Washington, US | |
331359 | 331359 | 2022-12-27 | US | Washington | Kittitas | 53037 | 10166 | 90 | 0 | 47.12521214 | -120.679439 | 2022-12-28 04:21:04 | Kittitas, Washington, US | |
331360 | 331360 | 2022-12-27 | US | Washington | Klickitat | 53039 | 4244 | 59 | 0 | 45.87325839 | -120.7913598 | 2022-12-28 04:21:04 | Klickitat, Washington, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);