johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6,083 rows where province_or_state = "Hawaii" sorted by latitude descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: admin2, fips, deaths, latitude, longitude, combined_key, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1242 | 1242 | 2021-12-02 | US | Hawaii | Kauai | 15007 | 3156 | 13 | 0 | 22.03935037 | -159.5966786 | 2021-12-03 04:23:05 | Kauai, Hawaii, US | |
1244 | 1244 | 2021-12-02 | US | Hawaii | Out of HI | 80015 | 2930 | 11 | 0 | 22.03935037 | 0.0 | 2021-12-03 04:23:05 | Out of HI, Hawaii, US | |
1245 | 1245 | 2021-12-02 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Hawaii, US | |
5257 | 5257 | 2021-10-28 | US | Hawaii | Kauai | 15007 | 2595 | 9 | 0 | 22.03935037 | -159.5966786 | 2021-10-29 04:22:03 | Kauai, Hawaii, US | |
5259 | 5259 | 2021-10-28 | US | Hawaii | Out of HI | 80015 | 2664 | 5 | 0 | 22.03935037 | 0.0 | 2021-10-29 04:22:03 | Out of HI, Hawaii, US | |
5260 | 5260 | 2021-10-28 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Hawaii, US | |
9230 | 9230 | 2020-10-25 | US | Hawaii | Kauai | 15007 | 61 | 0 | 0 | 61 | 22.03935037 | -159.5966786 | 2020-10-26 04:25:02 | Kauai, Hawaii, US |
9232 | 9232 | 2020-10-25 | US | Hawaii | Out of HI | 80015 | 54 | 1 | 0 | 53 | 22.03935037 | 0.0 | 2020-10-26 04:25:02 | Out of HI, Hawaii, US |
9233 | 9233 | 2020-10-25 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Hawaii, US |
13242 | 13242 | 2021-01-26 | US | Hawaii | Kauai | 15007 | 179 | 1 | 0 | 178 | 22.03935037 | -159.5966786 | 2021-01-27 05:23:41 | Kauai, Hawaii, US |
13244 | 13244 | 2021-01-26 | US | Hawaii | Out of HI | 80015 | 758 | 3 | 0 | 755 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Out of HI, Hawaii, US |
13245 | 13245 | 2021-01-26 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Hawaii, US |
17264 | 17264 | 2021-09-18 | US | Hawaii | Kauai | 15007 | 1952 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-19 04:21:34 | Kauai, Hawaii, US | |
17266 | 17266 | 2021-09-18 | US | Hawaii | Out of HI | 80015 | 2319 | 5 | 0 | 22.03935037 | 0.0 | 2021-09-19 04:21:34 | Out of HI, Hawaii, US | |
17267 | 17267 | 2021-09-18 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Hawaii, US | |
21275 | 21275 | 2021-05-28 | US | Hawaii | Kauai | 15007 | 318 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-29 04:20:41 | Kauai, Hawaii, US | |
21277 | 21277 | 2021-05-28 | US | Hawaii | Out of HI | 80015 | 1232 | 3 | 0 | 22.03935037 | 0.0 | 2021-05-29 04:20:41 | Out of HI, Hawaii, US | |
21278 | 21278 | 2021-05-28 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Hawaii, US | |
25313 | 25313 | 2022-03-20 | US | Hawaii | Kauai | 15007 | 11692 | 29 | 0 | 22.03935037 | -159.5966786 | 2022-03-21 04:20:50 | Kauai, Hawaii, US | |
25315 | 25315 | 2022-03-20 | US | Hawaii | Out of HI | 80015 | 5919 | 12 | 0 | 22.03935037 | 0.0 | 2022-03-21 04:20:50 | Out of HI, Hawaii, US | |
25316 | 25316 | 2022-03-20 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Hawaii, US | |
29328 | 29328 | 2021-11-11 | US | Hawaii | Kauai | 15007 | 2839 | 11 | 0 | 22.03935037 | -159.5966786 | 2021-11-12 04:22:01 | Kauai, Hawaii, US | |
29330 | 29330 | 2021-11-11 | US | Hawaii | Out of HI | 80015 | 2780 | 10 | 0 | 22.03935037 | 0.0 | 2021-11-12 04:22:01 | Out of HI, Hawaii, US | |
29331 | 29331 | 2021-11-11 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Hawaii, US | |
33324 | 33324 | 2021-08-25 | US | Hawaii | Kauai | 15007 | 1087 | 3 | 0 | 22.03935037 | -159.5966786 | 2021-08-26 04:21:28 | Kauai, Hawaii, US | |
33326 | 33326 | 2021-08-25 | US | Hawaii | Out of HI | 80015 | 2079 | 3 | 0 | 22.03935037 | 0.0 | 2021-08-26 04:21:28 | Out of HI, Hawaii, US | |
33327 | 33327 | 2021-08-25 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Hawaii, US | |
37334 | 37334 | 2021-04-12 | US | Hawaii | Kauai | 15007 | 202 | 1 | 0 | 22.03935037 | -159.5966786 | 2021-04-13 04:20:37 | Kauai, Hawaii, US | |
37336 | 37336 | 2021-04-12 | US | Hawaii | Out of HI | 80015 | 1020 | 3 | 0 | 22.03935037 | 0.0 | 2021-04-13 04:20:37 | Out of HI, Hawaii, US | |
37337 | 37337 | 2021-04-12 | US | Hawaii | Unassigned | 90015 | 4 | 0 | 0 | 22.03935037 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Hawaii, US | |
41590 | 41590 | 2020-04-13 | US | Hawaii | Kauai | 15007 | 21 | 0 | 0 | 21 | 22.03935037 | -159.5966786 | 2020-04-13 23:07:54 | Kauai, Hawaii, US |
42203 | 42203 | 2020-04-13 | US | Hawaii | Out of HI | 80015 | 2 | 0 | 0 | 2 | 22.03935037 | 0.0 | 2020-04-13 23:07:54 | Out of HI, Hawaii, US |
42783 | 42783 | 2020-04-13 | US | Hawaii | Unassigned | 90015 | 3 | 0 | 0 | 3 | 22.03935037 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Hawaii, US |
44620 | 44620 | 2021-11-02 | US | Hawaii | Kauai | 15007 | 2666 | 9 | 0 | 22.03935037 | -159.5966786 | 2021-11-03 06:22:09 | Kauai, Hawaii, US | |
44622 | 44622 | 2021-11-02 | US | Hawaii | Out of HI | 80015 | 2713 | 8 | 0 | 22.03935037 | 0.0 | 2021-11-03 06:22:09 | Out of HI, Hawaii, US | |
44623 | 44623 | 2021-11-02 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-11-03 06:22:09 | Unassigned, Hawaii, US | |
48659 | 48659 | 2020-04-17 | US | Hawaii | Kauai | 15007 | 21 | 0 | 0 | 21 | 22.03935037 | -159.5966786 | 2020-04-17 23:30:52 | Kauai, Hawaii, US |
49286 | 49286 | 2020-04-17 | US | Hawaii | Out of HI | 80015 | 6 | 0 | 0 | 6 | 22.03935037 | 0.0 | 2020-04-17 23:30:52 | Out of HI, Hawaii, US |
49876 | 49876 | 2020-04-17 | US | Hawaii | Unassigned | 90015 | 5 | 0 | 0 | 5 | 22.03935037 | 0.0 | 2020-04-17 23:30:52 | Unassigned, Hawaii, US |
51696 | 51696 | 2021-05-29 | US | Hawaii | Kauai | 15007 | 318 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-30 04:20:55 | Kauai, Hawaii, US | |
51698 | 51698 | 2021-05-29 | US | Hawaii | Out of HI | 80015 | 1235 | 3 | 0 | 22.03935037 | 0.0 | 2021-05-30 04:20:55 | Out of HI, Hawaii, US | |
51699 | 51699 | 2021-05-29 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-05-30 04:20:55 | Unassigned, Hawaii, US | |
55707 | 55707 | 2021-03-07 | US | Hawaii | Kauai | 15007 | 188 | 1 | 0 | 22.03935037 | -159.5966786 | 2021-03-08 05:24:48 | Kauai, Hawaii, US | |
55709 | 55709 | 2021-03-07 | US | Hawaii | Out of HI | 80015 | 925 | 3 | 0 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Out of HI, Hawaii, US | |
55710 | 55710 | 2021-03-07 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Hawaii, US | |
59999 | 59999 | 2020-07-23 | US | Hawaii | Kauai | 15007 | 43 | 0 | 0 | 43 | 22.03935037 | -159.5966786 | 2020-07-24 05:30:40 | Kauai, Hawaii, US |
60708 | 60708 | 2020-07-23 | US | Hawaii | Out of HI | 80015 | 22 | 1 | 0 | 21 | 22.03935037 | 0.0 | 2020-07-24 05:30:40 | Out of HI, Hawaii, US |
61405 | 61405 | 2020-07-23 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-07-24 05:30:40 | Unassigned, Hawaii, US |
63978 | 63978 | 2022-11-12 | US | Hawaii | Kauai | 15007 | 18258 | 46 | 0 | 22.03935037 | -159.5966786 | 2022-11-13 04:21:14 | Kauai, Hawaii, US | |
63980 | 63980 | 2022-11-12 | US | Hawaii | Out of HI | 80015 | 8829 | 12 | 0 | 22.03935037 | 0.0 | 2022-11-13 04:21:14 | Out of HI, Hawaii, US | |
63981 | 63981 | 2022-11-12 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2022-11-13 04:21:14 | Unassigned, Hawaii, US | |
67969 | 67969 | 2021-09-01 | US | Hawaii | Kauai | 15007 | 1327 | 3 | 0 | 22.03935037 | -159.5966786 | 2021-09-02 04:21:15 | Kauai, Hawaii, US | |
67971 | 67971 | 2021-09-01 | US | Hawaii | Out of HI | 80015 | 2157 | 4 | 0 | 22.03935037 | 0.0 | 2021-09-02 04:21:15 | Out of HI, Hawaii, US | |
67972 | 67972 | 2021-09-01 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-09-02 04:21:15 | Unassigned, Hawaii, US | |
72003 | 72003 | 2022-02-07 | US | Hawaii | Kauai | 15007 | 10530 | 22 | 0 | 22.03935037 | -159.5966786 | 2022-02-08 04:21:15 | Kauai, Hawaii, US | |
72005 | 72005 | 2022-02-07 | US | Hawaii | Out of HI | 80015 | 5301 | 12 | 0 | 22.03935037 | 0.0 | 2022-02-08 04:21:15 | Out of HI, Hawaii, US | |
72006 | 72006 | 2022-02-07 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Hawaii, US | |
75990 | 75990 | 2020-12-03 | US | Hawaii | Kauai | 15007 | 117 | 1 | 0 | 116 | 22.03935037 | -159.5966786 | 2020-12-04 05:27:27 | Kauai, Hawaii, US |
75992 | 75992 | 2020-12-03 | US | Hawaii | Out of HI | 80015 | 228 | 2 | 0 | 226 | 22.03935037 | 0.0 | 2020-12-04 05:27:27 | Out of HI, Hawaii, US |
75993 | 75993 | 2020-12-03 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-12-04 05:27:27 | Unassigned, Hawaii, US |
79984 | 79984 | 2020-10-14 | US | Hawaii | Kauai | 15007 | 59 | 0 | 0 | 59 | 22.03935037 | -159.5966786 | 2020-10-15 04:24:28 | Kauai, Hawaii, US |
79986 | 79986 | 2020-10-14 | US | Hawaii | Out of HI | 80015 | 38 | 1 | 0 | 37 | 22.03935037 | 0.0 | 2020-10-15 04:24:28 | Out of HI, Hawaii, US |
79987 | 79987 | 2020-10-14 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-10-15 04:24:28 | Unassigned, Hawaii, US |
83999 | 83999 | 2021-05-25 | US | Hawaii | Kauai | 15007 | 318 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-26 04:20:35 | Kauai, Hawaii, US | |
84001 | 84001 | 2021-05-25 | US | Hawaii | Out of HI | 80015 | 1216 | 3 | 0 | 22.03935037 | 0.0 | 2021-05-26 04:20:35 | Out of HI, Hawaii, US | |
84002 | 84002 | 2021-05-25 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-05-26 04:20:35 | Unassigned, Hawaii, US | |
88037 | 88037 | 2021-11-09 | US | Hawaii | Kauai | 15007 | 2792 | 11 | 0 | 22.03935037 | -159.5966786 | 2021-11-10 04:21:38 | Kauai, Hawaii, US | |
88039 | 88039 | 2021-11-09 | US | Hawaii | Out of HI | 80015 | 2764 | 10 | 0 | 22.03935037 | 0.0 | 2021-11-10 04:21:38 | Out of HI, Hawaii, US | |
88040 | 88040 | 2021-11-09 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Hawaii, US | |
92055 | 92055 | 2022-07-23 | US | Hawaii | Kauai | 15007 | 16265 | 35 | 0 | 22.03935037 | -159.5966786 | 2022-07-24 04:20:47 | Kauai, Hawaii, US | |
92057 | 92057 | 2022-07-23 | US | Hawaii | Out of HI | 80015 | 8064 | 12 | 0 | 22.03935037 | 0.0 | 2022-07-24 04:20:47 | Out of HI, Hawaii, US | |
92058 | 92058 | 2022-07-23 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2022-07-24 04:20:47 | Unassigned, Hawaii, US | |
96324 | 96324 | 2020-08-04 | US | Hawaii | Kauai | 15007 | 47 | 0 | 0 | 47 | 22.03935037 | -159.5966786 | 2020-08-05 04:34:43 | Kauai, Hawaii, US |
97035 | 97035 | 2020-08-04 | US | Hawaii | Out of HI | 80015 | 23 | 1 | 0 | 22 | 22.03935037 | 0.0 | 2020-08-05 04:34:43 | Out of HI, Hawaii, US |
97735 | 97735 | 2020-08-04 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-08-05 04:34:43 | Unassigned, Hawaii, US |
100238 | 100238 | 2022-01-14 | US | Hawaii | Kauai | 15007 | 6017 | 20 | 0 | 22.03935037 | -159.5966786 | 2022-01-15 04:21:07 | Kauai, Hawaii, US | |
100240 | 100240 | 2022-01-14 | US | Hawaii | Out of HI | 80015 | 4192 | 11 | 0 | 22.03935037 | 0.0 | 2022-01-15 04:21:07 | Out of HI, Hawaii, US | |
100241 | 100241 | 2022-01-14 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2022-01-15 04:21:07 | Unassigned, Hawaii, US | |
104234 | 104234 | 2021-08-15 | US | Hawaii | Kauai | 15007 | 839 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-16 04:21:31 | Kauai, Hawaii, US | |
104236 | 104236 | 2021-08-15 | US | Hawaii | Out of HI | 80015 | 1995 | 3 | 0 | 22.03935037 | 0.0 | 2021-08-16 04:21:31 | Out of HI, Hawaii, US | |
104237 | 104237 | 2021-08-15 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-08-16 04:21:31 | Unassigned, Hawaii, US | |
108358 | 108358 | 2021-06-19 | US | Hawaii | Kauai | 15007 | 346 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-20 04:21:48 | Kauai, Hawaii, US | |
108360 | 108360 | 2021-06-19 | US | Hawaii | Out of HI | 80015 | 1317 | 3 | 0 | 22.03935037 | 0.0 | 2021-06-20 04:21:48 | Out of HI, Hawaii, US | |
108361 | 108361 | 2021-06-19 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-06-20 04:21:48 | Unassigned, Hawaii, US | |
112507 | 112507 | 2020-05-08 | US | Hawaii | Kauai | 15007 | 21 | 0 | 0 | 21 | 22.03935037 | -159.5966786 | 2020-05-09 02:32:35 | Kauai, Hawaii, US |
113165 | 113165 | 2020-05-08 | US | Hawaii | Out of HI | 80015 | 10 | 0 | 0 | 10 | 22.03935037 | 0.0 | 2020-05-09 02:32:35 | Out of HI, Hawaii, US |
113794 | 113794 | 2020-05-08 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-05-09 02:32:35 | Unassigned, Hawaii, US |
115665 | 115665 | 2022-09-06 | US | Hawaii | Kauai | 15007 | 17080 | 42 | 0 | 22.03935037 | -159.5966786 | 2022-09-07 04:20:59 | Kauai, Hawaii, US | |
115667 | 115667 | 2022-09-06 | US | Hawaii | Out of HI | 80015 | 8419 | 12 | 0 | 22.03935037 | 0.0 | 2022-09-07 04:20:59 | Out of HI, Hawaii, US | |
115668 | 115668 | 2022-09-06 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2022-09-07 04:20:59 | Unassigned, Hawaii, US | |
119926 | 119926 | 2020-07-19 | US | Hawaii | Kauai | 15007 | 43 | 0 | 0 | 43 | 22.03935037 | -159.5966786 | 2020-07-20 05:34:40 | Kauai, Hawaii, US |
120635 | 120635 | 2020-07-19 | US | Hawaii | Out of HI | 80015 | 22 | 1 | 0 | 21 | 22.03935037 | 0.0 | 2020-07-20 05:34:40 | Out of HI, Hawaii, US |
121329 | 121329 | 2020-07-19 | US | Hawaii | Unassigned | 90015 | 3 | 0 | 0 | 3 | 22.03935037 | 0.0 | 2020-07-20 05:34:40 | Unassigned, Hawaii, US |
123605 | 123605 | 2020-11-18 | US | Hawaii | Kauai | 15007 | 83 | 0 | 0 | 83 | 22.03935037 | -159.5966786 | 2020-11-19 05:25:23 | Kauai, Hawaii, US |
123607 | 123607 | 2020-11-18 | US | Hawaii | Out of HI | 80015 | 157 | 1 | 0 | 156 | 22.03935037 | 0.0 | 2020-11-19 05:25:23 | Out of HI, Hawaii, US |
123608 | 123608 | 2020-11-18 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-11-19 05:25:23 | Unassigned, Hawaii, US |
127645 | 127645 | 2022-01-09 | US | Hawaii | Kauai | 15007 | 5313 | 19 | 0 | 22.03935037 | -159.5966786 | 2022-01-10 04:22:07 | Kauai, Hawaii, US | |
127647 | 127647 | 2022-01-09 | US | Hawaii | Out of HI | 80015 | 3962 | 11 | 0 | 22.03935037 | 0.0 | 2022-01-10 04:22:07 | Out of HI, Hawaii, US | |
127648 | 127648 | 2022-01-09 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2022-01-10 04:22:07 | Unassigned, Hawaii, US | |
131666 | 131666 | 2022-10-04 | US | Hawaii | Kauai | 15007 | 17816 | 45 | 0 | 22.03935037 | -159.5966786 | 2022-10-05 04:23:06 | Kauai, Hawaii, 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]);