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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: admin2, deaths, latitude, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1240 | 1240 | 2021-12-02 | US | Hawaii | Hawaii | 15001 | 11725 | 139 | 0 | 19.60121157 | -155.5210167 | 2021-12-03 04:23:05 | Hawaii, Hawaii, US | |
1241 | 1241 | 2021-12-02 | US | Hawaii | Honolulu | 15003 | 59673 | 762 | 0 | 21.45803166 | -157.97121819999995 | 2021-12-03 04:23:05 | Honolulu, Hawaii, US | |
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 | |
1243 | 1243 | 2021-12-02 | US | Hawaii | Maui | 15009 | 10414 | 102 | 0 | 20.86399628 | -156.56890969999995 | 2021-12-03 04:23:05 | Maui, 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 | |
5255 | 5255 | 2021-10-28 | US | Hawaii | Hawaii | 15001 | 11002 | 113 | 0 | 19.60121157 | -155.5210167 | 2021-10-29 04:22:03 | Hawaii, Hawaii, US | |
5256 | 5256 | 2021-10-28 | US | Hawaii | Honolulu | 15003 | 57694 | 670 | 0 | 21.45803166 | -157.97121819999995 | 2021-10-29 04:22:03 | Honolulu, 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 | |
5258 | 5258 | 2021-10-28 | US | Hawaii | Maui | 15009 | 9877 | 94 | 0 | 20.86399628 | -156.56890969999995 | 2021-10-29 04:22:03 | Maui, 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 | |
17262 | 17262 | 2021-09-18 | US | Hawaii | Hawaii | 15001 | 9375 | 75 | 0 | 19.60121157 | -155.5210167 | 2021-09-19 04:21:34 | Hawaii, Hawaii, US | |
17263 | 17263 | 2021-09-18 | US | Hawaii | Honolulu | 15003 | 52349 | 532 | 0 | 21.45803166 | -157.97121819999995 | 2021-09-19 04:21:34 | Honolulu, 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 | |
17265 | 17265 | 2021-09-18 | US | Hawaii | Maui | 15009 | 9011 | 82 | 0 | 20.86399628 | -156.56890969999995 | 2021-09-19 04:21:34 | Maui, 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 | |
21273 | 21273 | 2021-05-28 | US | Hawaii | Hawaii | 15001 | 2875 | 53 | 0 | 19.60121157 | -155.5210167 | 2021-05-29 04:20:41 | Hawaii, Hawaii, US | |
21274 | 21274 | 2021-05-28 | US | Hawaii | Honolulu | 15003 | 27031 | 386 | 0 | 21.45803166 | -157.97121819999995 | 2021-05-29 04:20:41 | Honolulu, 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 | |
21276 | 21276 | 2021-05-28 | US | Hawaii | Maui | 15009 | 4620 | 54 | 0 | 20.86399628 | -156.56890969999995 | 2021-05-29 04:20:41 | Maui, 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 | |
25311 | 25311 | 2022-03-20 | US | Hawaii | Hawaii | 15001 | 26089 | 184 | 0 | 19.60121157 | -155.5210167 | 2022-03-21 04:20:50 | Hawaii, Hawaii, US | |
25312 | 25312 | 2022-03-20 | US | Hawaii | Honolulu | 15003 | 165272 | 1009 | 0 | 21.45803166 | -157.97121819999995 | 2022-03-21 04:20:50 | Honolulu, 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 | |
25314 | 25314 | 2022-03-20 | US | Hawaii | Maui | 15009 | 29792 | 134 | 0 | 20.86399628 | -156.56890969999995 | 2022-03-21 04:20:50 | Maui, 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 | |
29326 | 29326 | 2021-11-11 | US | Hawaii | Hawaii | 15001 | 11334 | 125 | 0 | 19.60121157 | -155.5210167 | 2021-11-12 04:22:01 | Hawaii, Hawaii, US | |
29327 | 29327 | 2021-11-11 | US | Hawaii | Honolulu | 15003 | 58476 | 727 | 0 | 21.45803166 | -157.97121819999995 | 2021-11-12 04:22:01 | Honolulu, 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 | |
29329 | 29329 | 2021-11-11 | US | Hawaii | Maui | 15009 | 10061 | 98 | 0 | 20.86399628 | -156.56890969999995 | 2021-11-12 04:22:01 | Maui, 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 | |
33322 | 33322 | 2021-08-25 | US | Hawaii | Hawaii | 15001 | 6740 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-26 04:21:28 | Hawaii, Hawaii, US | |
33323 | 33323 | 2021-08-25 | US | Hawaii | Honolulu | 15003 | 40751 | 441 | 0 | 21.45803166 | -157.97121819999995 | 2021-08-26 04:21:28 | Honolulu, 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 | |
33325 | 33325 | 2021-08-25 | US | Hawaii | Maui | 15009 | 7090 | 67 | 0 | 20.86399628 | -156.56890969999995 | 2021-08-26 04:21:28 | Maui, 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 | |
37332 | 37332 | 2021-04-12 | US | Hawaii | Hawaii | 15001 | 2634 | 53 | 0 | 19.60121157 | -155.5210167 | 2021-04-13 04:20:37 | Hawaii, Hawaii, US | |
37333 | 37333 | 2021-04-12 | US | Hawaii | Honolulu | 15003 | 24291 | 370 | 0 | 21.45803166 | -157.97121819999995 | 2021-04-13 04:20:37 | Honolulu, 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 | |
37335 | 37335 | 2021-04-12 | US | Hawaii | Maui | 15009 | 3986 | 44 | 0 | 20.86399628 | -156.56890969999995 | 2021-04-13 04:20:37 | Maui, 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 | |
44618 | 44618 | 2021-11-02 | US | Hawaii | Hawaii | 15001 | 11122 | 118 | 0 | 19.60121157 | -155.5210167 | 2021-11-03 06:22:09 | Hawaii, Hawaii, US | |
44619 | 44619 | 2021-11-02 | US | Hawaii | Honolulu | 15003 | 57956 | 687 | 0 | 21.45803166 | -157.97121819999995 | 2021-11-03 06:22:09 | Honolulu, 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 | |
44621 | 44621 | 2021-11-02 | US | Hawaii | Maui | 15009 | 9945 | 94 | 0 | 20.86399628 | -156.56890969999995 | 2021-11-03 06:22:09 | Maui, 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 | |
51694 | 51694 | 2021-05-29 | US | Hawaii | Hawaii | 15001 | 2886 | 53 | 0 | 19.60121157 | -155.5210167 | 2021-05-30 04:20:55 | Hawaii, Hawaii, US | |
51695 | 51695 | 2021-05-29 | US | Hawaii | Honolulu | 15003 | 27059 | 387 | 0 | 21.45803166 | -157.97121819999995 | 2021-05-30 04:20:55 | Honolulu, 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 | |
51697 | 51697 | 2021-05-29 | US | Hawaii | Maui | 15009 | 4626 | 54 | 0 | 20.86399628 | -156.56890969999995 | 2021-05-30 04:20:55 | Maui, 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 | |
55705 | 55705 | 2021-03-07 | US | Hawaii | Hawaii | 15001 | 2305 | 53 | 0 | 19.60121157 | -155.5210167 | 2021-03-08 05:24:48 | Hawaii, Hawaii, US | |
55706 | 55706 | 2021-03-07 | US | Hawaii | Honolulu | 15003 | 22367 | 353 | 0 | 21.45803166 | -157.97121819999995 | 2021-03-08 05:24:48 | Honolulu, 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 | |
55708 | 55708 | 2021-03-07 | US | Hawaii | Maui | 15009 | 2961 | 35 | 0 | 20.86399628 | -156.56890969999995 | 2021-03-08 05:24:48 | Maui, 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 | |
63976 | 63976 | 2022-11-12 | US | Hawaii | Hawaii | 15001 | 40663 | 220 | 0 | 19.60121157 | -155.5210167 | 2022-11-13 04:21:14 | Hawaii, Hawaii, US | |
63977 | 63977 | 2022-11-12 | US | Hawaii | Honolulu | 15003 | 252694 | 1272 | 0 | 21.45803166 | -157.9712182 | 2022-11-13 04:21:14 | Honolulu, 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 | |
63979 | 63979 | 2022-11-12 | US | Hawaii | Maui | 15009 | 43678 | 166 | 0 | 20.86399628 | -156.5689097 | 2022-11-13 04:21:14 | Maui, 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 | |
67967 | 67967 | 2021-09-01 | US | Hawaii | Hawaii | 15001 | 7698 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-09-02 04:21:15 | Hawaii, Hawaii, US | |
67968 | 67968 | 2021-09-01 | US | Hawaii | Honolulu | 15003 | 45055 | 464 | 0 | 21.45803166 | -157.97121819999995 | 2021-09-02 04:21:15 | Honolulu, 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 | |
67970 | 67970 | 2021-09-01 | US | Hawaii | Maui | 15009 | 7720 | 72 | 0 | 20.86399628 | -156.56890969999995 | 2021-09-02 04:21:15 | Maui, 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 | |
72001 | 72001 | 2022-02-07 | US | Hawaii | Hawaii | 15001 | 24543 | 167 | 0 | 19.60121157 | -155.5210167 | 2022-02-08 04:21:15 | Hawaii, Hawaii, US | |
72002 | 72002 | 2022-02-07 | US | Hawaii | Honolulu | 15003 | 158481 | 906 | 0 | 21.45803166 | -157.97121819999995 | 2022-02-08 04:21:15 | Honolulu, 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 | |
72004 | 72004 | 2022-02-07 | US | Hawaii | Maui | 15009 | 28429 | 119 | 0 | 20.86399628 | -156.56890969999995 | 2022-02-08 04:21:15 | Maui, 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 | |
83997 | 83997 | 2021-05-25 | US | Hawaii | Hawaii | 15001 | 2855 | 53 | 0 | 19.60121157 | -155.5210167 | 2021-05-26 04:20:35 | Hawaii, Hawaii, US | |
83998 | 83998 | 2021-05-25 | US | Hawaii | Honolulu | 15003 | 26939 | 384 | 0 | 21.45803166 | -157.97121819999995 | 2021-05-26 04:20:35 | Honolulu, 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 | |
84000 | 84000 | 2021-05-25 | US | Hawaii | Maui | 15009 | 4596 | 54 | 0 | 20.86399628 | -156.56890969999995 | 2021-05-26 04:20:35 | Maui, 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 | |
88035 | 88035 | 2021-11-09 | US | Hawaii | Hawaii | 15001 | 11279 | 125 | 0 | 19.60121157 | -155.5210167 | 2021-11-10 04:21:38 | Hawaii, Hawaii, US | |
88036 | 88036 | 2021-11-09 | US | Hawaii | Honolulu | 15003 | 58356 | 718 | 0 | 21.45803166 | -157.97121819999995 | 2021-11-10 04:21:38 | Honolulu, 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 | |
88038 | 88038 | 2021-11-09 | US | Hawaii | Maui | 15009 | 10027 | 98 | 0 | 20.86399628 | -156.56890969999995 | 2021-11-10 04:21:38 | Maui, 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 | |
92053 | 92053 | 2022-07-23 | US | Hawaii | Hawaii | 15001 | 35717 | 200 | 0 | 19.60121157 | -155.5210167 | 2022-07-24 04:20:47 | Hawaii, Hawaii, US | |
92054 | 92054 | 2022-07-23 | US | Hawaii | Honolulu | 15003 | 223313 | 1153 | 0 | 21.45803166 | -157.9712182 | 2022-07-24 04:20:47 | Honolulu, 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 | |
92056 | 92056 | 2022-07-23 | US | Hawaii | Maui | 15009 | 38510 | 148 | 0 | 20.86399628 | -156.5689097 | 2022-07-24 04:20:47 | Maui, 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]);