daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40,499 rows where province_or_state = "Washington" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-08 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-09 02:32:35 | Garfield, Washington, US |
2020-04-29 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-04-30 02:32:27 | Garfield, Washington, US |
2020-06-08 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-09 03:33:03 | Garfield, Washington, US |
2020-04-30 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-05-01 02:32:28 | Garfield, Washington, US |
2020-05-21 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-22 02:36:51 | Garfield, Washington, US |
2020-04-28 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-04-29 02:32:29 | Garfield, Washington, US |
2020-06-15 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-16 04:33:09 | Garfield, Washington, US |
2020-07-01 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-07-02 04:33:46 | Garfield, Washington, US |
2020-07-05 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-07-06 04:33:57 | Garfield, Washington, US |
2020-07-04 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-07-05 04:33:46 | Garfield, Washington, US |
2020-06-06 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-07 03:53:30 | Garfield, Washington, US |
2020-06-12 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-13 03:33:14 | Garfield, Washington, US |
2020-06-01 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-02 02:33:08 | Garfield, Washington, US |
2020-03-27 | US | Washington | Asotin | 53003 | 0 | 0 | 0 | 0 | 46.18894415 | -117.2022851 | 2020-03-27 22:14:55 | Asotin, Washington, US |
2020-03-27 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-03-27 22:14:55 | Garfield, Washington, US |
2020-03-27 | US | Washington | Pacific | 53049 | 0 | 0 | 0 | 0 | 46.55418369 | -123.7285716 | 2020-03-27 22:14:55 | Pacific, Washington, US |
2020-03-27 | US | Washington | Pend Oreille | 53051 | 0 | 0 | 0 | 0 | 48.53234021 | -117.2741804 | 2020-03-27 22:14:55 | Pend Oreille, Washington, US |
2020-03-27 | US | Washington | Skamania | 53059 | 0 | 0 | 0 | 0 | 46.02408726 | -121.91644029999999 | 2020-03-27 22:14:55 | Skamania, Washington, US |
2020-03-27 | US | Washington | Wahkiakum | 53069 | 0 | 0 | 0 | 0 | 46.29180039999999 | -123.4250831 | 2020-03-27 22:14:55 | Wahkiakum, Washington, US |
2020-05-24 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-25 02:32:44 | Garfield, Washington, US |
2020-07-07 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-07-08 05:33:48 | Garfield, Washington, US |
2020-03-26 | US | Washington | Asotin | 53003 | 0 | 0 | 0 | 0 | 46.18894415 | -117.2022851 | 2020-03-26 23:48:35 | Asotin, Washington, US |
2020-03-26 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-03-26 23:48:35 | Garfield, Washington, US |
2020-03-26 | US | Washington | Pacific | 53049 | 0 | 0 | 0 | 0 | 46.55418369 | -123.7285716 | 2020-03-26 23:48:35 | Pacific, Washington, US |
2020-03-26 | US | Washington | Pend Oreille | 53051 | 0 | 0 | 0 | 0 | 48.53234021 | -117.2741804 | 2020-03-26 23:48:35 | Pend Oreille, Washington, US |
2020-03-26 | US | Washington | Skamania | 53059 | 0 | 0 | 0 | 0 | 46.02408726 | -121.91644029999999 | 2020-03-26 23:48:35 | Skamania, Washington, US |
2020-03-26 | US | Washington | Wahkiakum | 53069 | 0 | 0 | 0 | 0 | 46.29180039999999 | -123.4250831 | 2020-03-26 23:48:35 | Wahkiakum, Washington, US |
2020-05-23 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-24 02:32:43 | Garfield, Washington, US |
2020-07-09 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-07-10 04:34:24 | Garfield, Washington, US |
2020-05-26 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-27 02:32:31 | Garfield, Washington, US |
2020-05-25 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-26 02:32:35 | Garfield, Washington, US |
2020-03-25 | US | Washington | Asotin | 53003 | 0 | 0 | 0 | 0 | 46.18894415 | -117.2022851 | 2020-03-25 23:33:19 | Asotin, Washington, US |
2020-03-25 | US | Washington | Ferry | 53019 | 0 | 0 | 0 | 0 | 48.471143100000006 | -118.5154041 | 2020-03-25 23:33:19 | Ferry, Washington, US |
2020-03-25 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-03-25 23:33:19 | Garfield, Washington, US |
2020-03-25 | US | Washington | Okanogan | 53047 | 0 | 0 | 0 | 0 | 48.54855019 | -119.73872240000001 | 2020-03-25 23:33:19 | Okanogan, Washington, US |
2020-03-25 | US | Washington | Pacific | 53049 | 0 | 0 | 0 | 0 | 46.55418369 | -123.7285716 | 2020-03-25 23:33:19 | Pacific, Washington, US |
2020-03-25 | US | Washington | Pend Oreille | 53051 | 0 | 0 | 0 | 0 | 48.53234021 | -117.2741804 | 2020-03-25 23:33:19 | Pend Oreille, Washington, US |
2020-03-25 | US | Washington | Skamania | 53059 | 0 | 0 | 0 | 0 | 46.02408726 | -121.91644029999999 | 2020-03-25 23:33:19 | Skamania, Washington, US |
2020-03-25 | US | Washington | Wahkiakum | 53069 | 0 | 0 | 0 | 0 | 46.29180039999999 | -123.4250831 | 2020-03-25 23:33:19 | Wahkiakum, Washington, US |
2020-06-26 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-27 04:33:35 | Garfield, Washington, US |
2020-05-01 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-05-02 02:32:27 | Garfield, Washington, US |
2020-06-17 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-18 04:33:18 | Garfield, Washington, US |
2020-06-09 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-06-10 04:07:00 | Garfield, Washington, US |
2020-06-05 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-06 02:33:00 | Garfield, Washington, US |
2020-06-11 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-06-12 05:09:52 | Garfield, Washington, US |
2020-06-04 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-05 02:33:06 | Garfield, Washington, US |
2020-05-14 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-15 02:33:02 | Garfield, Washington, US |
2020-05-20 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-21 02:32:48 | Garfield, Washington, US |
2020-04-24 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-04-24 00:00:00 | Garfield, Washington, US |
2020-03-24 | US | Washington | Asotin | 53003 | 0 | 0 | 0 | 0 | 46.18894415 | -117.2022851 | 2020-03-24 23:37:31 | Asotin, Washington, US |
2020-03-24 | US | Washington | Ferry | 53019 | 0 | 0 | 0 | 0 | 48.471143100000006 | -118.5154041 | 2020-03-24 23:37:31 | Ferry, Washington, US |
2020-03-24 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-03-24 23:37:31 | Garfield, Washington, US |
2020-03-24 | US | Washington | Okanogan | 53047 | 0 | 0 | 0 | 0 | 48.54855019 | -119.73872240000001 | 2020-03-24 23:37:31 | Okanogan, Washington, US |
2020-03-24 | US | Washington | Pacific | 53049 | 0 | 0 | 0 | 0 | 46.55418369 | -123.7285716 | 2020-03-24 23:37:31 | Pacific, Washington, US |
2020-03-24 | US | Washington | Pend Oreille | 53051 | 0 | 0 | 0 | 0 | 48.53234021 | -117.2741804 | 2020-03-24 23:37:31 | Pend Oreille, Washington, US |
2020-03-24 | US | Washington | Skamania | 53059 | 0 | 0 | 0 | 0 | 46.02408726 | -121.91644029999999 | 2020-03-24 23:37:31 | Skamania, Washington, US |
2020-03-24 | US | Washington | Wahkiakum | 53069 | 0 | 0 | 0 | 0 | 46.29180039999999 | -123.4250831 | 2020-03-24 23:37:31 | Wahkiakum, Washington, US |
2020-06-22 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-23 04:33:22 | Garfield, Washington, US |
2020-06-23 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-24 04:33:28 | Garfield, Washington, US |
2020-06-19 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-06-20 04:33:19 | Garfield, Washington, US |
2020-05-29 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-30 02:32:48 | Garfield, Washington, US |
2020-05-31 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-01 02:32:46 | Garfield, Washington, US |
2020-05-16 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-17 02:32:32 | Garfield, Washington, US |
2020-06-14 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-15 03:33:14 | Garfield, Washington, US |
2020-05-22 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-23 02:32:42 | Garfield, Washington, US |
2020-03-30 | US | Washington | Asotin | 53003 | 0 | 0 | 0 | 0 | 46.18894415 | -117.2022851 | 3/30/20 22:52 | Asotin, Washington, US |
2020-03-30 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 3/30/20 22:52 | Garfield, Washington, US |
2020-03-30 | US | Washington | Pacific | 53049 | 0 | 0 | 0 | 0 | 46.55418369 | -123.7285716 | 3/30/20 22:52 | Pacific, Washington, US |
2020-03-30 | US | Washington | Pend Oreille | 53051 | 0 | 0 | 0 | 0 | 48.53234021 | -117.2741804 | 3/30/20 22:52 | Pend Oreille, Washington, US |
2020-03-30 | US | Washington | Wahkiakum | 53069 | 0 | 0 | 0 | 0 | 46.2918004 | -123.4250831 | 3/30/20 22:52 | Wahkiakum, Washington, US |
2020-05-05 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-05-06 02:32:31 | Garfield, Washington, US |
2020-06-27 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-28 04:34:04 | Garfield, Washington, US |
2020-05-02 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-05-03 02:32:28 | Garfield, Washington, US |
2020-05-06 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-05-07 02:32:28 | Garfield, Washington, US |
2020-03-23 | US | Washington | Asotin | 53003 | 0 | 0 | 0 | 0 | 46.18894415 | -117.2022851 | 2020-03-23 23:19:34 | Asotin, Washington, US |
2020-03-23 | US | Washington | Ferry | 53019 | 0 | 0 | 0 | 0 | 48.471143100000006 | -118.5154041 | 2020-03-23 23:19:34 | Ferry, Washington, US |
2020-03-23 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-03-23 23:19:34 | Garfield, Washington, US |
2020-03-23 | US | Washington | Okanogan | 53047 | 0 | 0 | 0 | 0 | 48.54855019 | -119.73872240000001 | 2020-03-23 23:19:34 | Okanogan, Washington, US |
2020-03-23 | US | Washington | Pacific | 53049 | 0 | 0 | 0 | 0 | 46.55418369 | -123.7285716 | 2020-03-23 23:19:34 | Pacific, Washington, US |
2020-03-23 | US | Washington | Pend Oreille | 53051 | 0 | 0 | 0 | 0 | 48.53234021 | -117.2741804 | 2020-03-23 23:19:34 | Pend Oreille, Washington, US |
2020-03-23 | US | Washington | Skamania | 53059 | 0 | 0 | 0 | 0 | 46.02408726 | -121.91644029999999 | 2020-03-23 23:19:34 | Skamania, Washington, US |
2020-03-23 | US | Washington | Wahkiakum | 53069 | 0 | 0 | 0 | 0 | 46.29180039999999 | -123.4250831 | 2020-03-23 23:19:34 | Wahkiakum, Washington, US |
2020-07-08 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-07-09 04:34:23 | Garfield, Washington, US |
2020-07-03 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-07-04 04:33:51 | Garfield, Washington, US |
2020-05-03 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-05-04 02:32:28 | Garfield, Washington, US |
2020-06-28 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-29 04:33:44 | Garfield, Washington, US |
2020-06-16 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-17 04:33:21 | Garfield, Washington, US |
2020-05-19 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-20 02:32:19 | Garfield, Washington, US |
2020-06-20 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-06-21 04:33:19 | Garfield, Washington, US |
2020-04-23 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-04-23 00:00:00 | Garfield, Washington, US |
2020-05-27 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-28 02:32:31 | Garfield, Washington, US |
2020-06-02 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-03 02:33:13 | Garfield, Washington, US |
2020-05-12 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-13 03:32:26 | Garfield, Washington, US |
2020-06-25 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-26 04:33:43 | Garfield, Washington, US |
2020-06-29 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-06-30 04:33:48 | Garfield, Washington, US |
2020-07-06 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-07-07 04:34:00 | Garfield, Washington, US |
2020-06-24 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-25 05:26:54 | Garfield, Washington, US |
2020-05-28 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-05-29 02:32:50 | Garfield, Washington, US |
2020-06-07 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.5454032 | 2020-06-08 03:33:22 | Garfield, Washington, US |
2020-06-10 | US | Washington | Garfield | 53023 | 0 | 0 | 0 | 0 | 46.43197502 | -117.54540320000001 | 2020-06-11 03:33:41 | Garfield, Washington, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;