johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where country_or_region = "US", deaths = 162 and province_or_state = "Hawaii" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 15 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2757837 | 2757837 | 2022-10-18 | US | Hawaii | Maui | 15009 | 43125 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-19 04:22:26 | Maui, Hawaii, US | |
2025671 | 2025671 | 2022-10-17 | US | Hawaii | Maui | 15009 | 43125 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-18 04:22:42 | Maui, Hawaii, US | |
2160449 | 2160449 | 2022-10-16 | US | Hawaii | Maui | 15009 | 43125 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-17 04:20:31 | Maui, Hawaii, US | |
516646 | 516646 | 2022-10-15 | US | Hawaii | Maui | 15009 | 43125 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-16 04:22:39 | Maui, Hawaii, US | |
2033703 | 2033703 | 2022-10-14 | US | Hawaii | Maui | 15009 | 43125 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-15 04:22:00 | Maui, Hawaii, US | |
3754391 | 3754391 | 2022-10-13 | US | Hawaii | Maui | 15009 | 43125 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-14 04:22:28 | Maui, Hawaii, US | |
3215216 | 3215216 | 2022-10-12 | US | Hawaii | Maui | 15009 | 43125 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-13 04:22:39 | Maui, Hawaii, US | |
3251065 | 3251065 | 2022-10-11 | US | Hawaii | Maui | 15009 | 43033 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-12 04:22:51 | Maui, Hawaii, US | |
2968324 | 2968324 | 2022-10-10 | US | Hawaii | Maui | 15009 | 43033 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-11 04:23:05 | Maui, Hawaii, US | |
3098360 | 3098360 | 2022-10-09 | US | Hawaii | Maui | 15009 | 43033 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-10 04:22:32 | Maui, Hawaii, US | |
4003585 | 4003585 | 2022-10-08 | US | Hawaii | Maui | 15009 | 43033 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-09 04:21:16 | Maui, Hawaii, US | |
397182 | 397182 | 2022-10-07 | US | Hawaii | Maui | 15009 | 43033 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-08 04:22:56 | Maui, Hawaii, US | |
2530299 | 2530299 | 2022-10-06 | US | Hawaii | Maui | 15009 | 43033 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-07 04:23:08 | Maui, Hawaii, US | |
1811693 | 1811693 | 2022-10-05 | US | Hawaii | Maui | 15009 | 43033 | 162 | 0 | 20.86399628 | -156.5689097 | 2022-10-06 04:21:22 | Maui, Hawaii, US | |
1054721 | 1054721 | 2020-10-23 | US | Hawaii | Honolulu | 15003 | 12734 | 162 | 0 | 12572 | 21.45803166 | -157.97121819999995 | 2020-10-24 04:24: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]);