johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where deaths = 140 and province_or_state = "Hawaii" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: fips, confirmed, latitude, longitude, last_update, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
166959 | 166959 | 2022-06-21 | US | Hawaii | Maui | 15009 | 35735 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-22 04:20:54 | Maui, Hawaii, US | |
1764242 | 1764242 | 2022-06-20 | US | Hawaii | Maui | 15009 | 35735 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-21 04:20:56 | Maui, Hawaii, US | |
3270428 | 3270428 | 2022-06-19 | US | Hawaii | Maui | 15009 | 35735 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-20 04:21:01 | Maui, Hawaii, US | |
3398340 | 3398340 | 2022-06-18 | US | Hawaii | Maui | 15009 | 35735 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-19 04:20:51 | Maui, Hawaii, US | |
2312217 | 2312217 | 2022-06-17 | US | Hawaii | Maui | 15009 | 35735 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-18 04:21:10 | Maui, Hawaii, US | |
559721 | 559721 | 2022-06-16 | US | Hawaii | Maui | 15009 | 35735 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-17 04:20:56 | Maui, Hawaii, US | |
3983523 | 3983523 | 2022-06-15 | US | Hawaii | Maui | 15009 | 35735 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-16 04:20:55 | Maui, Hawaii, US | |
947764 | 947764 | 2022-06-14 | US | Hawaii | Maui | 15009 | 35113 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-15 04:20:54 | Maui, Hawaii, US | |
2980172 | 2980172 | 2022-06-13 | US | Hawaii | Maui | 15009 | 35113 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-14 04:20:52 | Maui, Hawaii, US | |
2236298 | 2236298 | 2022-06-12 | US | Hawaii | Maui | 15009 | 35113 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-13 04:21:14 | Maui, Hawaii, US | |
3142496 | 3142496 | 2022-06-11 | US | Hawaii | Maui | 15009 | 35113 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-12 04:20:53 | Maui, Hawaii, US | |
1945412 | 1945412 | 2022-06-10 | US | Hawaii | Maui | 15009 | 35113 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-11 04:21:01 | Maui, Hawaii, US | |
3158551 | 3158551 | 2022-06-09 | US | Hawaii | Maui | 15009 | 35113 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-10 04:20:55 | Maui, Hawaii, US | |
1422018 | 1422018 | 2022-06-08 | US | Hawaii | Maui | 15009 | 35113 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-09 04:20:54 | Maui, Hawaii, US | |
3727132 | 3727132 | 2022-06-07 | US | Hawaii | Maui | 15009 | 34240 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-08 04:20:55 | Maui, Hawaii, US | |
3888534 | 3888534 | 2022-06-06 | US | Hawaii | Maui | 15009 | 34240 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-07 04:21:08 | Maui, Hawaii, US | |
3508303 | 3508303 | 2022-06-05 | US | Hawaii | Maui | 15009 | 34240 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-06 04:20:57 | Maui, Hawaii, US | |
3528380 | 3528380 | 2022-06-04 | US | Hawaii | Maui | 15009 | 34240 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-05 04:20:55 | Maui, Hawaii, US | |
3134466 | 3134466 | 2022-06-03 | US | Hawaii | Maui | 15009 | 34240 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-04 04:20:58 | Maui, Hawaii, US | |
3579541 | 3579541 | 2022-06-02 | US | Hawaii | Maui | 15009 | 34240 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-03 04:20:58 | Maui, Hawaii, US | |
971834 | 971834 | 2022-06-01 | US | Hawaii | Maui | 15009 | 34240 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-02 05:20:39 | Maui, Hawaii, US | |
230141 | 230141 | 2022-05-31 | US | Hawaii | Maui | 15009 | 33592 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-06-01 04:20:55 | Maui, Hawaii, US | |
3186906 | 3186906 | 2022-05-30 | US | Hawaii | Maui | 15009 | 33592 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-31 04:20:51 | Maui, Hawaii, US | |
3199055 | 3199055 | 2022-05-29 | US | Hawaii | Maui | 15009 | 33592 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-30 04:20:50 | Maui, Hawaii, US | |
2725933 | 2725933 | 2022-05-28 | US | Hawaii | Maui | 15009 | 33592 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-29 04:20:53 | Maui, Hawaii, US | |
1315114 | 1315114 | 2022-05-27 | US | Hawaii | Maui | 15009 | 33592 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-28 04:21:07 | Maui, Hawaii, US | |
1850906 | 1850906 | 2022-05-26 | US | Hawaii | Maui | 15009 | 33592 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-27 04:20:56 | Maui, Hawaii, US | |
2048782 | 2048782 | 2022-05-25 | US | Hawaii | Maui | 15009 | 33592 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-26 04:20:50 | Maui, Hawaii, US | |
622793 | 622793 | 2022-05-22 | US | Hawaii | Maui | 15009 | 33592 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-26 04:20:50 | Maui, Hawaii, US | |
3583557 | 3583557 | 2022-05-17 | US | Hawaii | Maui | 15009 | 32001 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-18 04:20:50 | Maui, Hawaii, US | |
1504514 | 1504514 | 2022-05-16 | US | Hawaii | Maui | 15009 | 32001 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-17 04:20:59 | Maui, Hawaii, US | |
2084873 | 2084873 | 2022-05-15 | US | Hawaii | Maui | 15009 | 32001 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-16 04:20:47 | Maui, Hawaii, US | |
3355583 | 3355583 | 2022-05-14 | US | Hawaii | Maui | 15009 | 32001 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-15 04:20:53 | Maui, Hawaii, US | |
659228 | 659228 | 2022-05-13 | US | Hawaii | Maui | 15009 | 32001 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-14 04:20:48 | Maui, Hawaii, US | |
2534311 | 2534311 | 2022-05-12 | US | Hawaii | Maui | 15009 | 32001 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-13 04:20:51 | Maui, Hawaii, US | |
3445757 | 3445757 | 2022-05-11 | US | Hawaii | Maui | 15009 | 32001 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-12 04:20:54 | Maui, Hawaii, US | |
3536374 | 3536374 | 2022-05-10 | US | Hawaii | Maui | 15009 | 31312 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-11 04:20:48 | Maui, Hawaii, US | |
222909 | 222909 | 2022-05-09 | US | Hawaii | Maui | 15009 | 31312 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-10 04:20:50 | Maui, Hawaii, US | |
2332294 | 2332294 | 2022-05-08 | US | Hawaii | Maui | 15009 | 31312 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-09 04:20:54 | Maui, Hawaii, US | |
361256 | 361256 | 2022-05-07 | US | Hawaii | Maui | 15009 | 31312 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-08 04:20:49 | Maui, Hawaii, US | |
1398607 | 1398607 | 2022-05-06 | US | Hawaii | Maui | 15009 | 31312 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-07 04:21:09 | Maui, Hawaii, US | |
2598962 | 2598962 | 2022-05-05 | US | Hawaii | Maui | 15009 | 31312 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-06 04:21:00 | Maui, Hawaii, US | |
3266411 | 3266411 | 2022-05-04 | US | Hawaii | Maui | 15009 | 31312 | 140 | 0 | 20.86399628 | -156.5689097 | 2022-05-05 04:20:55 | Maui, Hawaii, US | |
405204 | 405204 | 2021-12-07 | US | Hawaii | Hawaii | 15001 | 11802 | 140 | 0 | 19.60121157 | -155.5210167 | 2021-12-08 04:22:46 | Hawaii, Hawaii, US | |
1031286 | 1031286 | 2021-12-06 | US | Hawaii | Hawaii | 15001 | 11795 | 140 | 0 | 19.60121157 | -155.5210167 | 2021-12-07 04:22:34 | Hawaii, Hawaii, US | |
1741449 | 1741449 | 2021-12-05 | US | Hawaii | Hawaii | 15001 | 11783 | 140 | 0 | 19.60121157 | -155.5210167 | 2021-12-06 04:22:34 | Hawaii, Hawaii, US | |
138881 | 138881 | 2021-12-04 | US | Hawaii | Hawaii | 15001 | 11765 | 140 | 0 | 19.60121157 | -155.5210167 | 2021-12-05 04:22:25 | Hawaii, Hawaii, US | |
2196534 | 2196534 | 2021-12-03 | US | Hawaii | Hawaii | 15001 | 11739 | 140 | 0 | 19.60121157 | -155.5210167 | 2021-12-04 04:22:18 | Hawaii, Hawaii, US | |
2602928 | 2602928 | 2020-10-10 | US | Hawaii | Honolulu | 15003 | 11954 | 140 | 0 | 11814 | 21.45803166 | -157.97121819999995 | 2020-10-11 04:23:46 | Honolulu, 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]);