johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where deaths = 55 and province_or_state = "Hawaii" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: admin2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3632863 | 3632863 | 2021-07-14 | US | Hawaii | Hawaii | 15001 | 3381 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-15 04:21:48 | Hawaii, Hawaii, US | |
579738 | 579738 | 2021-07-13 | US | Hawaii | Hawaii | 15001 | 3375 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-14 04:21:35 | Hawaii, Hawaii, US | |
3741987 | 3741987 | 2021-07-12 | US | Hawaii | Hawaii | 15001 | 3368 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-13 04:21:18 | Hawaii, Hawaii, US | |
3660500 | 3660500 | 2021-07-11 | US | Hawaii | Hawaii | 15001 | 3353 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-12 04:21:34 | Hawaii, Hawaii, US | |
626784 | 626784 | 2021-07-10 | US | Hawaii | Hawaii | 15001 | 3341 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-11 04:21:43 | Hawaii, Hawaii, US | |
830503 | 830503 | 2021-07-09 | US | Hawaii | Hawaii | 15001 | 3321 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-10 04:21:25 | Hawaii, Hawaii, US | |
779267 | 779267 | 2021-07-08 | US | Hawaii | Hawaii | 15001 | 3312 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-09 04:21:21 | Hawaii, Hawaii, US | |
1441489 | 1441489 | 2021-07-07 | US | Hawaii | Hawaii | 15001 | 3304 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-08 04:21:26 | Hawaii, Hawaii, US | |
2694594 | 2694594 | 2021-07-06 | US | Hawaii | Hawaii | 15001 | 3295 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-07 04:21:20 | Hawaii, Hawaii, US | |
1933343 | 1933343 | 2021-07-05 | US | Hawaii | Hawaii | 15001 | 3293 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-06 04:21:32 | Hawaii, Hawaii, US | |
1166074 | 1166074 | 2021-07-04 | US | Hawaii | Hawaii | 15001 | 3287 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-05 04:21:28 | Hawaii, Hawaii, US | |
1496508 | 1496508 | 2021-07-03 | US | Hawaii | Hawaii | 15001 | 3279 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-04 04:21:38 | Hawaii, Hawaii, US | |
2072823 | 2072823 | 2021-07-02 | US | Hawaii | Hawaii | 15001 | 3274 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-03 04:21:37 | Hawaii, Hawaii, US | |
2765839 | 2765839 | 2021-07-01 | US | Hawaii | Hawaii | 15001 | 3267 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-02 04:21:47 | Hawaii, Hawaii, US | |
1894047 | 1894047 | 2021-06-30 | US | Hawaii | Hawaii | 15001 | 3265 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-07-01 04:21:19 | Hawaii, Hawaii, US | |
401170 | 401170 | 2021-06-29 | US | Hawaii | Hawaii | 15001 | 3256 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-06-30 04:21:41 | Hawaii, Hawaii, US | |
3126413 | 3126413 | 2021-06-28 | US | Hawaii | Hawaii | 15001 | 3253 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-06-29 04:21:28 | Hawaii, Hawaii, US | |
2590908 | 2590908 | 2021-06-27 | US | Hawaii | Hawaii | 15001 | 3251 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-06-28 04:21:29 | Hawaii, Hawaii, US | |
3959412 | 3959412 | 2021-06-26 | US | Hawaii | Hawaii | 15001 | 3238 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-06-27 04:21:39 | Hawaii, Hawaii, US | |
1713231 | 1713231 | 2021-06-25 | US | Hawaii | Hawaii | 15001 | 3230 | 55 | 0 | 19.60121157 | -155.5210167 | 2021-06-26 04:21:43 | Hawaii, Hawaii, US | |
2912080 | 2912080 | 2021-06-17 | US | Hawaii | Maui | 15009 | 4810 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-18 04:22:16 | Maui, Hawaii, US | |
3031196 | 3031196 | 2021-06-16 | US | Hawaii | Maui | 15009 | 4807 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-17 04:22:36 | Maui, Hawaii, US | |
2340302 | 2340302 | 2021-06-15 | US | Hawaii | Maui | 15009 | 4804 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-16 04:22:32 | Maui, Hawaii, US | |
1564998 | 1564998 | 2021-06-14 | US | Hawaii | Maui | 15009 | 4802 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-15 04:22:22 | Maui, Hawaii, US | |
3382281 | 3382281 | 2021-06-13 | US | Hawaii | Maui | 15009 | 4788 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-14 04:22:46 | Maui, Hawaii, US | |
1737415 | 1737415 | 2021-06-12 | US | Hawaii | Maui | 15009 | 4776 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-13 04:22:44 | Maui, Hawaii, US | |
3971456 | 3971456 | 2021-06-11 | US | Hawaii | Maui | 15009 | 4758 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-12 04:22:22 | Maui, Hawaii, US | |
2717878 | 2717878 | 2021-06-10 | US | Hawaii | Maui | 15009 | 4748 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-11 04:23:20 | Maui, Hawaii, US | |
523763 | 523763 | 2021-06-09 | US | Hawaii | Maui | 15009 | 4731 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-10 04:23:17 | Maui, Hawaii, US | |
3473203 | 3473203 | 2021-06-08 | US | Hawaii | Maui | 15009 | 4714 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-09 04:23:31 | Maui, Hawaii, US | |
3146487 | 3146487 | 2021-06-07 | US | Hawaii | Maui | 15009 | 4701 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-08 04:22:35 | Maui, Hawaii, US | |
826489 | 826489 | 2021-06-06 | US | Hawaii | Maui | 15009 | 4689 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-07 04:22:51 | Maui, Hawaii, US | |
2586894 | 2586894 | 2021-06-05 | US | Hawaii | Maui | 15009 | 4677 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-06 04:24:03 | Maui, Hawaii, US | |
2316208 | 2316208 | 2021-06-04 | US | Hawaii | Maui | 15009 | 4664 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-05 04:23:03 | Maui, Hawaii, US | |
1449493 | 1449493 | 2021-06-03 | US | Hawaii | Maui | 15009 | 4651 | 55 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-04 04:23:37 | 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]);