johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where country_or_region = "US", deaths = 30 and province_or_state = "Hawaii" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
947763 | 947763 | 2022-06-14 | US | Hawaii | Kauai | 15007 | 14705 | 30 | 0 | 22.03935037 | -159.5966786 | 2022-06-15 04:20:54 | Kauai, Hawaii, US | |
2980171 | 2980171 | 2022-06-13 | US | Hawaii | Kauai | 15007 | 14705 | 30 | 0 | 22.03935037 | -159.5966786 | 2022-06-14 04:20:52 | Kauai, Hawaii, US | |
2236297 | 2236297 | 2022-06-12 | US | Hawaii | Kauai | 15007 | 14705 | 30 | 0 | 22.03935037 | -159.5966786 | 2022-06-13 04:21:14 | Kauai, Hawaii, US | |
3142495 | 3142495 | 2022-06-11 | US | Hawaii | Kauai | 15007 | 14705 | 30 | 0 | 22.03935037 | -159.5966786 | 2022-06-12 04:20:53 | Kauai, Hawaii, US | |
1945411 | 1945411 | 2022-06-10 | US | Hawaii | Kauai | 15007 | 14705 | 30 | 0 | 22.03935037 | -159.5966786 | 2022-06-11 04:21:01 | Kauai, Hawaii, US | |
3158550 | 3158550 | 2022-06-09 | US | Hawaii | Kauai | 15007 | 14705 | 30 | 0 | 22.03935037 | -159.5966786 | 2022-06-10 04:20:55 | Kauai, Hawaii, US | |
1422017 | 1422017 | 2022-06-08 | US | Hawaii | Kauai | 15007 | 14705 | 30 | 0 | 22.03935037 | -159.5966786 | 2022-06-09 04:20:54 | Kauai, Hawaii, US | |
1937354 | 1937354 | 2021-02-23 | US | Hawaii | Maui | 15009 | 2680 | 30 | 0 | 2650 | 20.86399628 | -156.56890969999995 | 2021-02-24 05:29:16 | Maui, Hawaii, US |
531609 | 531609 | 2021-02-22 | US | Hawaii | Maui | 15009 | 2663 | 30 | 0 | 2633 | 20.86399628 | -156.56890969999995 | 2021-02-23 05:23:41 | Maui, Hawaii, US |
182943 | 182943 | 2021-02-21 | US | Hawaii | Maui | 15009 | 2636 | 30 | 0 | 2606 | 20.86399628 | -156.56890969999995 | 2021-02-22 05:24:21 | Maui, Hawaii, US |
743217 | 743217 | 2021-02-20 | US | Hawaii | Maui | 15009 | 2608 | 30 | 0 | 2578 | 20.86399628 | -156.56890969999995 | 2021-02-21 05:24:33 | Maui, Hawaii, US |
472315 | 472315 | 2021-02-19 | US | Hawaii | Maui | 15009 | 2596 | 30 | 0 | 2566 | 20.86399628 | -156.56890969999995 | 2021-02-20 05:22:51 | Maui, Hawaii, US |
211137 | 211137 | 2020-10-29 | US | Hawaii | Hawaii | 15001 | 1246 | 30 | 0 | 1216 | 19.60121157 | -155.5210167 | 2020-10-30 04:24:49 | Hawaii, Hawaii, US |
755199 | 755199 | 2020-10-28 | US | Hawaii | Hawaii | 15001 | 1238 | 30 | 0 | 1208 | 19.60121157 | -155.5210167 | 2020-10-29 04:24:49 | Hawaii, Hawaii, US |
1453483 | 1453483 | 2020-10-27 | US | Hawaii | Hawaii | 15001 | 1233 | 30 | 0 | 1203 | 19.60121157 | -155.5210167 | 2020-10-28 04:24:39 | Hawaii, 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]);