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 admin2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
197792 | 197792 | 2020-01-24 | US | Washington | 1 | 0 | 0 | 48.82227976 | 0.0 | 1/24/20 17:00 | ||||
197871 | 197871 | 2020-01-29 | US | Washington | 1 | 0 | 0 | 48.82227976 | 0.0 | 1/29/20 19:30 | ||||
339637 | 339637 | 2020-03-21 | US | Washington | 1793 | 94 | 0 | 47.4009 | -121.4905 | 2020-03-21T22:43:04 | ||||
415864 | 415864 | 2020-01-26 | US | Washington | 1 | 0 | 0 | 48.82227976 | 0.0 | 1/26/20 16:00 | ||||
864408 | 864408 | 2020-01-23 | US | Washington | 1 | 0 | 0 | 48.82227976 | 0.0 | 1/23/20 17:00 | ||||
1176895 | 1176895 | 2020-03-18 | US | Washington | 1014 | 55 | 0 | 47.4009 | -121.4905 | 2020-03-18T14:13:56 | ||||
1305786 | 1305786 | 2020-01-28 | US | Washington | 1 | 0 | 0 | 48.82227976 | 0.0 | 1/28/20 23:00 | ||||
1463486 | 1463486 | 2020-03-15 | US | Washington | 643 | 40 | 1 | 47.4009 | -121.4905 | 2020-03-15T02:13:21 | ||||
1526887 | 1526887 | 2020-03-19 | US | Washington | 1376 | 74 | 0 | 47.4009 | -121.4905 | 2020-03-19T23:43:04 | ||||
1527524 | 1527524 | 2020-01-30 | US | Washington | 1 | 0 | 0 | 48.82227976 | 0.0 | 1/30/20 16:00 | ||||
1802371 | 1802371 | 2020-01-22 | US | Washington | 1 | 0 | 0 | 48.82227976 | 0.0 | 1/22/2020 17:00 | ||||
2111112 | 2111112 | 2020-03-14 | US | Washington | 572 | 37 | 1 | 47.4009 | -121.4905 | 2020-03-14T22:13:19 | ||||
2127457 | 2127457 | 2020-03-11 | US | Washington | 366 | 29 | 1 | 47.4009 | -121.4905 | 2020-03-11T22:33:03 | ||||
2255134 | 2255134 | 2020-03-16 | US | Washington | 904 | 48 | 1 | 47.4009 | -121.4905 | 2020-03-16T23:53:03 | ||||
2282886 | 2282886 | 2020-03-12 | US | Washington | 442 | 31 | 1 | 47.4009 | -121.4905 | 2020-03-12T23:44:33 | ||||
2938965 | 2938965 | 2020-01-25 | US | Washington | 1 | 0 | 0 | 48.82227976 | 0.0 | 1/25/20 17:00 | ||||
3733935 | 3733935 | 2020-03-20 | US | Washington | 1524 | 83 | 0 | 47.4009 | -121.4905 | 2020-03-20T23:43:03 | ||||
3752844 | 3752844 | 2020-03-10 | US | Washington | 267 | 23 | 1 | 47.4009 | -121.4905 | 2020-03-10T22:13:11 | ||||
3753089 | 3753089 | 2020-01-27 | US | Washington | 1 | 0 | 0 | 48.82227976 | 0.0 | 1/27/20 23:59 | ||||
3761226 | 3761226 | 2020-01-31 | US | Washington | 1 | 0 | 0 | 48.82227976 | 0.0 | 1/31/2020 23:59 | ||||
3765501 | 3765501 | 2020-03-13 | US | Washington | 568 | 37 | 1 | 47.400902 | -121.490494 | 2020-03-11T20:00:00 | ||||
3891324 | 3891324 | 2020-03-17 | US | Washington | 1076 | 55 | 1 | 47.4009 | -121.4905 | 2020-03-17T23:33:03 | ||||
3760 | 3760 | 2021-12-02 | US | Washington | Adams | 53001 | 3363 | 34 | 0 | 46.98299757 | -118.56017340000001 | 2021-12-03 04:23:05 | Adams, Washington, US | |
7775 | 7775 | 2021-10-28 | US | Washington | Adams | 53001 | 3210 | 32 | 0 | 46.98299757 | -118.56017340000001 | 2021-10-29 04:22:03 | Adams, Washington, US | |
11747 | 11747 | 2020-10-25 | US | Washington | Adams | 53001 | 916 | 11 | 0 | 905 | 46.98299757 | -118.5601734 | 2020-10-26 04:25:02 | Adams, Washington, US |
15760 | 15760 | 2021-01-26 | US | Washington | Adams | 53001 | 1757 | 19 | 0 | 1738 | 46.98299757 | -118.5601734 | 2021-01-27 05:23:41 | Adams, Washington, US |
19782 | 19782 | 2021-09-18 | US | Washington | Adams | 53001 | 2849 | 25 | 0 | 46.98299757 | -118.56017340000001 | 2021-09-19 04:21:34 | Adams, Washington, US | |
23793 | 23793 | 2021-05-28 | US | Washington | Adams | 53001 | 2184 | 23 | 0 | 46.98299757 | -118.5601734 | 2021-05-29 04:20:41 | Adams, Washington, US | |
27831 | 27831 | 2022-03-20 | US | Washington | Adams | 53001 | 4902 | 38 | 0 | 46.98299757 | -118.56017340000001 | 2022-03-21 04:20:50 | Adams, Washington, US | |
31846 | 31846 | 2021-11-11 | US | Washington | Adams | 53001 | 3294 | 33 | 0 | 46.98299757 | -118.56017340000001 | 2021-11-12 04:22:01 | Adams, Washington, US | |
35842 | 35842 | 2021-08-25 | US | Washington | Adams | 53001 | 2501 | 25 | 0 | 46.98299757 | -118.56017340000001 | 2021-08-26 04:21:28 | Adams, Washington, US | |
39852 | 39852 | 2021-04-12 | US | Washington | Adams | 53001 | 2033 | 22 | 0 | 46.98299757 | -118.5601734 | 2021-04-13 04:20:37 | Adams, Washington, US | |
40356 | 40356 | 2020-04-13 | US | Washington | Adams | 53001 | 37 | 0 | 0 | 37 | 46.98299757 | -118.56017340000001 | 2020-04-13 23:07:54 | Adams, Washington, US |
47138 | 47138 | 2021-11-02 | US | Washington | Adams | 53001 | 3241 | 32 | 0 | 46.98299757 | -118.56017340000001 | 2021-11-03 06:22:09 | Adams, Washington, US | |
47411 | 47411 | 2020-04-17 | US | Washington | Adams | 53001 | 40 | 0 | 0 | 40 | 46.98299757 | -118.56017340000001 | 2020-04-17 23:30:52 | Adams, Washington, US |
54214 | 54214 | 2021-05-29 | US | Washington | Adams | 53001 | 2189 | 23 | 0 | 46.98299757 | -118.5601734 | 2021-05-30 04:20:55 | Adams, Washington, US | |
58225 | 58225 | 2021-03-07 | US | Washington | Adams | 53001 | 1931 | 21 | 0 | 46.98299757 | -118.5601734 | 2021-03-08 05:24:48 | Adams, Washington, US | |
58524 | 58524 | 2020-07-23 | US | Washington | Adams | 53001 | 325 | 1 | 0 | 324 | 46.98299757 | -118.5601734 | 2020-07-24 05:30:40 | Adams, Washington, US |
66496 | 66496 | 2022-11-12 | US | Washington | Adams | 53001 | 5544 | 44 | 0 | 46.98299757 | -118.5601734 | 2022-11-13 04:21:14 | Adams, Washington, US | |
70487 | 70487 | 2021-09-01 | US | Washington | Adams | 53001 | 2587 | 25 | 0 | 46.98299757 | -118.56017340000001 | 2021-09-02 04:21:15 | Adams, Washington, US | |
74521 | 74521 | 2022-02-07 | US | Washington | Adams | 53001 | 4746 | 35 | 0 | 46.98299757 | -118.56017340000001 | 2022-02-08 04:21:15 | Adams, Washington, US | |
78507 | 78507 | 2020-12-03 | US | Washington | Adams | 53001 | 1380 | 12 | 0 | 1368 | 46.98299757 | -118.5601734 | 2020-12-04 05:27:27 | Adams, Washington, US |
82501 | 82501 | 2020-10-14 | US | Washington | Adams | 53001 | 898 | 11 | 0 | 887 | 46.98299757 | -118.5601734 | 2020-10-15 04:24:28 | Adams, Washington, US |
86517 | 86517 | 2021-05-25 | US | Washington | Adams | 53001 | 2175 | 23 | 0 | 46.98299757 | -118.5601734 | 2021-05-26 04:20:35 | Adams, Washington, US | |
90555 | 90555 | 2021-11-09 | US | Washington | Adams | 53001 | 3286 | 33 | 0 | 46.98299757 | -118.56017340000001 | 2021-11-10 04:21:38 | Adams, Washington, US | |
94573 | 94573 | 2022-07-23 | US | Washington | Adams | 53001 | 5244 | 39 | 0 | 46.98299757 | -118.5601734 | 2022-07-24 04:20:47 | Adams, Washington, US | |
94846 | 94846 | 2020-08-04 | US | Washington | Adams | 53001 | 405 | 4 | 0 | 401 | 46.98299757 | -118.5601734 | 2020-08-05 04:34:43 | Adams, Washington, US |
102756 | 102756 | 2022-01-14 | US | Washington | Adams | 53001 | 3782 | 35 | 0 | 46.98299757 | -118.56017340000001 | 2022-01-15 04:21:07 | Adams, Washington, US | |
106752 | 106752 | 2021-08-15 | US | Washington | Adams | 53001 | 2376 | 25 | 0 | 46.98299757 | -118.56017340000001 | 2021-08-16 04:21:31 | Adams, Washington, US | |
110876 | 110876 | 2021-06-19 | US | Washington | Adams | 53001 | 2233 | 24 | 0 | 46.98299757 | -118.5601734 | 2021-06-20 04:21:48 | Adams, Washington, US | |
111168 | 111168 | 2020-05-08 | US | Washington | Adams | 53001 | 49 | 0 | 0 | 49 | 46.98299757 | -118.5601734 | 2020-05-09 02:32:35 | Adams, Washington, US |
118183 | 118183 | 2022-09-06 | US | Washington | Adams | 53001 | 5456 | 40 | 0 | 46.98299757 | -118.5601734 | 2022-09-07 04:20:59 | Adams, Washington, US | |
118455 | 118455 | 2020-07-19 | US | Washington | Adams | 53001 | 302 | 0 | 0 | 302 | 46.98299757 | -118.5601734 | 2020-07-20 05:34:40 | Adams, Washington, US |
126122 | 126122 | 2020-11-18 | US | Washington | Adams | 53001 | 1198 | 12 | 0 | 1186 | 46.98299757 | -118.5601734 | 2020-11-19 05:25:23 | Adams, Washington, US |
130163 | 130163 | 2022-01-09 | US | Washington | Adams | 53001 | 3536 | 35 | 0 | 46.98299757 | -118.56017340000001 | 2022-01-10 04:22:07 | Adams, Washington, US | |
134184 | 134184 | 2022-10-04 | US | Washington | Adams | 53001 | 5524 | 42 | 0 | 46.98299757 | -118.5601734 | 2022-10-05 04:23:06 | Adams, Washington, US | |
134452 | 134452 | 2020-04-29 | US | Washington | Adams | 53001 | 47 | 0 | 0 | 47 | 46.98299757 | -118.56017340000001 | 2020-04-30 02:32:27 | Adams, Washington, US |
141401 | 141401 | 2021-12-04 | US | Washington | Adams | 53001 | 3365 | 34 | 0 | 46.98299757 | -118.56017340000001 | 2021-12-05 04:22:25 | Adams, Washington, US | |
145419 | 145419 | 2022-07-09 | US | Washington | Adams | 53001 | 5120 | 39 | 0 | 46.98299757 | -118.5601734 | 2022-07-10 04:20:54 | Adams, Washington, US | |
149374 | 149374 | 2020-08-15 | US | Washington | Adams | 53001 | 499 | 6 | 0 | 493 | 46.98299757 | -118.5601734 | 2020-08-16 04:27:42 | Adams, Washington, US |
153414 | 153414 | 2021-11-29 | US | Washington | Adams | 53001 | 3351 | 34 | 0 | 46.98299757 | -118.56017340000001 | 2021-11-30 04:22:53 | Adams, Washington, US | |
157401 | 157401 | 2021-01-08 | US | Washington | Adams | 53001 | 1675 | 16 | 0 | 1659 | 46.98299757 | -118.5601734 | 2021-01-09 05:22:18 | Adams, Washington, US |
161443 | 161443 | 2022-03-29 | US | Washington | Adams | 53001 | 4912 | 38 | 0 | 46.98299757 | -118.56017340000001 | 2022-03-30 04:20:45 | Adams, Washington, US | |
165458 | 165458 | 2021-11-19 | US | Washington | Adams | 53001 | 3328 | 34 | 0 | 46.98299757 | -118.56017340000001 | 2021-11-20 04:22:17 | Adams, Washington, US | |
169476 | 169476 | 2022-06-21 | US | Washington | Adams | 53001 | 4994 | 38 | 0 | 46.98299757 | -118.5601734 | 2022-06-22 04:20:54 | Adams, Washington, US | |
173466 | 173466 | 2021-04-16 | US | Washington | Adams | 53001 | 2046 | 22 | 0 | 46.98299757 | -118.5601734 | 2021-04-17 04:20:40 | Adams, Washington, US | |
173763 | 173763 | 2020-07-27 | US | Washington | Adams | 53001 | 363 | 2 | 0 | 361 | 46.98299757 | -118.5601734 | 2020-07-28 04:58:43 | Adams, Washington, US |
181452 | 181452 | 2021-09-02 | US | Washington | Adams | 53001 | 2604 | 25 | 0 | 46.98299757 | -118.56017340000001 | 2021-09-03 04:21:20 | Adams, Washington, US | |
185460 | 185460 | 2021-02-21 | US | Washington | Adams | 53001 | 1899 | 21 | 0 | 1878 | 46.98299757 | -118.5601734 | 2021-02-22 05:24:21 | Adams, Washington, US |
189501 | 189501 | 2022-02-13 | US | Washington | Adams | 53001 | 4798 | 36 | 0 | 46.98299757 | -118.56017340000001 | 2022-02-14 04:20:51 | Adams, Washington, US | |
193487 | 193487 | 2021-01-11 | US | Washington | Adams | 53001 | 1689 | 16 | 0 | 1673 | 46.98299757 | -118.5601734 | 2021-01-12 05:22:15 | Adams, Washington, US |
197478 | 197478 | 2020-08-31 | US | Washington | Adams | 53001 | 632 | 9 | 0 | 623 | 46.98299757 | -118.5601734 | 2020-09-01 04:28:31 | Adams, Washington, US |
201693 | 201693 | 2022-10-19 | US | Washington | Adams | 53001 | 5532 | 43 | 0 | 46.98299757 | -118.5601734 | 2022-10-20 04:22:59 | Adams, Washington, US | |
205674 | 205674 | 2020-12-25 | US | Washington | Adams | 53001 | 1590 | 16 | 0 | 1574 | 46.98299757 | -118.5601734 | 2020-12-26 05:22:28 | Adams, Washington, US |
209660 | 209660 | 2020-08-19 | US | Washington | Adams | 53001 | 521 | 6 | 0 | 515 | 46.98299757 | -118.5601734 | 2020-08-20 04:27:43 | Adams, Washington, US |
213656 | 213656 | 2020-10-29 | US | Washington | Adams | 53001 | 927 | 11 | 0 | 916 | 46.98299757 | -118.5601734 | 2020-10-30 04:24:49 | Adams, Washington, US |
213954 | 213954 | 2020-06-08 | US | Washington | Adams | 53001 | 80 | 0 | 0 | 80 | 46.98299757 | -118.5601734 | 2020-06-09 03:33:03 | Adams, Washington, US |
221414 | 221414 | 2022-12-26 | US | Washington | Adams | 53001 | 5566 | 44 | 0 | 46.98299757 | -118.5601734 | 2022-12-27 04:21:07 | Adams, Washington, US | |
225426 | 225426 | 2022-05-09 | US | Washington | Adams | 53001 | 4921 | 38 | 0 | 46.98299757 | -118.5601734 | 2022-05-10 04:20:50 | Adams, Washington, US | |
225698 | 225698 | 2020-04-30 | US | Washington | Adams | 53001 | 47 | 0 | 0 | 47 | 46.98299757 | -118.56017340000001 | 2020-05-01 02:32:28 | Adams, Washington, US |
232658 | 232658 | 2022-05-31 | US | Washington | Adams | 53001 | 4947 | 38 | 0 | 46.98299757 | -118.5601734 | 2022-06-01 04:20:55 | Adams, Washington, US | |
236673 | 236673 | 2022-02-11 | US | Washington | Adams | 53001 | 4798 | 36 | 0 | 46.98299757 | -118.56017340000001 | 2022-02-12 04:21:06 | Adams, Washington, US | |
240660 | 240660 | 2021-01-18 | US | Washington | Adams | 53001 | 1719 | 17 | 0 | 1702 | 46.98299757 | -118.5601734 | 2021-01-19 05:22:15 | Adams, Washington, US |
244677 | 244677 | 2021-04-02 | US | Washington | Adams | 53001 | 2001 | 22 | 0 | 46.98299757 | -118.5601734 | 2021-04-03 04:20:44 | Adams, Washington, US | |
248695 | 248695 | 2021-08-17 | US | Washington | Adams | 53001 | 2409 | 25 | 0 | 46.98299757 | -118.56017340000001 | 2021-08-18 04:21:35 | Adams, Washington, US | |
252709 | 252709 | 2021-09-04 | US | Washington | Adams | 53001 | 2630 | 25 | 0 | 46.98299757 | -118.56017340000001 | 2021-09-05 04:21:33 | Adams, Washington, US | |
256745 | 256745 | 2022-09-08 | US | Washington | Adams | 53001 | 5464 | 40 | 0 | 46.98299757 | -118.5601734 | 2022-09-09 04:21:11 | Adams, Washington, US | |
260764 | 260764 | 2022-12-10 | US | Washington | Adams | 53001 | 5554 | 44 | 0 | 46.98299757 | -118.5601734 | 2022-12-11 04:20:50 | Adams, Washington, US | |
264963 | 264963 | 2022-03-15 | US | Washington | Adams | 53001 | 4901 | 38 | 0 | 46.98299757 | -118.56017340000001 | 2022-03-16 04:20:50 | Adams, Washington, US | |
265236 | 265236 | 2020-05-21 | US | Washington | Adams | 53001 | 50 | 0 | 0 | 50 | 46.98299757 | -118.5601734 | 2020-05-22 02:36:51 | Adams, Washington, US |
268671 | 268671 | 2020-04-28 | US | Washington | Adams | 53001 | 46 | 0 | 0 | 46 | 46.98299757 | -118.5601734 | 2020-04-29 02:32:29 | Adams, Washington, US |
275572 | 275572 | 2020-11-10 | US | Washington | Adams | 53001 | 993 | 12 | 0 | 981 | 46.98299757 | -118.5601734 | 2020-11-11 05:25:30 | Adams, Washington, US |
279613 | 279613 | 2021-11-03 | US | Washington | Adams | 53001 | 3252 | 32 | 0 | 46.98299757 | -118.56017340000001 | 2021-11-04 04:22:20 | Adams, Washington, US | |
283603 | 283603 | 2021-02-24 | US | Washington | Adams | 53001 | 1906 | 21 | 0 | 1885 | 46.98299757 | -118.5601734 | 2021-02-25 05:24:57 | Adams, Washington, US |
283901 | 283901 | 2020-06-15 | US | Washington | Adams | 53001 | 99 | 0 | 0 | 99 | 46.98299757 | -118.5601734 | 2020-06-16 04:33:09 | Adams, Washington, US |
291425 | 291425 | 2021-10-31 | US | Washington | Adams | 53001 | 3220 | 32 | 0 | 46.98299757 | -118.56017340000001 | 2021-11-01 04:22:01 | Adams, Washington, US | |
295447 | 295447 | 2022-11-15 | US | Washington | Adams | 53001 | 5544 | 44 | 0 | 46.98299757 | -118.5601734 | 2022-11-16 04:21:09 | Adams, Washington, US | |
299438 | 299438 | 2021-07-15 | US | Washington | Adams | 53001 | 2280 | 24 | 0 | 46.98299757 | -118.5601734 | 2021-07-16 04:21:22 | Adams, Washington, US | |
299730 | 299730 | 2020-07-01 | US | Washington | Adams | 53001 | 145 | 0 | 0 | 145 | 46.98299757 | -118.5601734 | 2020-07-02 04:33:46 | Adams, Washington, US |
307299 | 307299 | 2022-04-16 | US | Washington | Adams | 53001 | 4913 | 38 | 0 | 46.98299757 | -118.56017340000001 | 2022-04-17 04:20:59 | Adams, 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]);