johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where deaths = 18 and province_or_state = "Hawaii" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day, admin2, fips, active, latitude, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1216480 | 1216480 | 2022-01-08 | US | Hawaii | Kauai | 15007 | 5087 | 18 | 0 | 22.03935037 | -159.5966786 | 2022-01-09 04:21:46 | Kauai, Hawaii, US | |
1390573 | 1390573 | 2022-01-07 | US | Hawaii | Kauai | 15007 | 4902 | 18 | 0 | 22.03935037 | -159.5966786 | 2022-01-08 04:21:53 | Kauai, Hawaii, US | |
2610960 | 2610960 | 2022-01-06 | US | Hawaii | Kauai | 15007 | 4665 | 18 | 0 | 22.03935037 | -159.5966786 | 2022-01-07 04:22:09 | Kauai, Hawaii, US | |
1282902 | 1282902 | 2022-01-05 | US | Hawaii | Kauai | 15007 | 4452 | 18 | 0 | 22.03935037 | -159.5966786 | 2022-01-06 04:22:09 | Kauai, Hawaii, US | |
1286918 | 1286918 | 2022-01-04 | US | Hawaii | Kauai | 15007 | 4341 | 18 | 0 | 22.03935037 | -159.5966786 | 2022-01-05 04:21:59 | Kauai, Hawaii, US | |
1701262 | 1701262 | 2022-01-03 | US | Hawaii | Kauai | 15007 | 4299 | 18 | 0 | 22.03935037 | -159.5966786 | 2022-01-04 04:22:17 | Kauai, Hawaii, US | |
3520345 | 3520345 | 2022-01-02 | US | Hawaii | Kauai | 15007 | 4175 | 18 | 0 | 22.03935037 | -159.5966786 | 2022-01-03 02:22:25 | Kauai, Hawaii, US | |
2168475 | 2168475 | 2022-01-01 | US | Hawaii | Kauai | 15007 | 4046 | 18 | 0 | 22.03935037 | -159.5966786 | 2022-01-02 04:20:52 | Kauai, Hawaii, US | |
2777906 | 2777906 | 2021-12-31 | US | Hawaii | Kauai | 15007 | 3969 | 18 | 0 | 22.03935037 | -159.5966786 | 2022-01-01 04:22:14 | Kauai, Hawaii, US | |
3999563 | 3999563 | 2021-12-30 | US | Hawaii | Kauai | 15007 | 3842 | 18 | 0 | 22.03935037 | -159.5966786 | 2021-12-31 04:21:50 | Kauai, Hawaii, US | |
1669370 | 1669370 | 2021-12-29 | US | Hawaii | Kauai | 15007 | 3695 | 18 | 0 | 22.03935037 | -159.5966786 | 2021-12-30 04:21:25 | Kauai, Hawaii, US | |
1433479 | 1433479 | 2021-12-28 | US | Hawaii | Kauai | 15007 | 3637 | 18 | 0 | 22.03935037 | -159.5966786 | 2021-12-29 03:21:43 | Kauai, Hawaii, US | |
731440 | 731440 | 2021-12-27 | US | Hawaii | Kauai | 15007 | 3597 | 18 | 0 | 22.03935037 | -159.5966786 | 2021-12-28 04:21:47 | Kauai, Hawaii, US | |
2112612 | 2112612 | 2021-12-26 | US | Hawaii | Kauai | 15007 | 3529 | 18 | 0 | 22.03935037 | -159.5966786 | 2021-12-27 04:21:58 | Kauai, Hawaii, US | |
3605984 | 3605984 | 2021-12-25 | US | Hawaii | Kauai | 15007 | 3529 | 18 | 0 | 22.03935037 | -159.5966786 | 2021-12-26 04:21:50 | Kauai, Hawaii, US | |
775250 | 775250 | 2021-01-12 | US | Hawaii | Maui | 15009 | 1813 | 18 | 0 | 1795 | 20.86399628 | -156.56890969999995 | 2021-01-13 05:22:15 | Maui, Hawaii, US |
190971 | 190971 | 2021-01-11 | US | Hawaii | Maui | 15009 | 1792 | 18 | 0 | 1774 | 20.86399628 | -156.56890969999995 | 2021-01-12 05:22:15 | Maui, Hawaii, US |
2626774 | 2626774 | 2021-01-10 | US | Hawaii | Maui | 15009 | 1759 | 18 | 0 | 1741 | 20.86399628 | -156.56890969999995 | 2021-01-11 05:21:50 | Maui, Hawaii, US |
3900862 | 3900862 | 2021-01-09 | US | Hawaii | Maui | 15009 | 1729 | 18 | 0 | 1711 | 20.86399628 | -156.56890969999995 | 2021-01-10 05:22:12 | Maui, Hawaii, US |
154885 | 154885 | 2021-01-08 | US | Hawaii | Maui | 15009 | 1679 | 18 | 0 | 1661 | 20.86399628 | -156.56890969999995 | 2021-01-09 05:22:18 | Maui, Hawaii, US |
2542309 | 2542309 | 2021-01-07 | US | Hawaii | Maui | 15009 | 1622 | 18 | 0 | 1604 | 20.86399628 | -156.56890969999995 | 2021-01-08 05:22:42 | Maui, Hawaii, US |
2865618 | 2865618 | 2021-01-06 | US | Hawaii | Maui | 15009 | 1566 | 18 | 0 | 1548 | 20.86399628 | -156.56890969999995 | 2021-01-07 05:22:03 | Maui, Hawaii, US |
1453486 | 1453486 | 2020-10-27 | US | Hawaii | Maui | 15009 | 507 | 18 | 0 | 489 | 20.86399628 | -156.56890969999995 | 2020-10-28 04:24:39 | Maui, Hawaii, US |
3481210 | 3481210 | 2020-10-26 | US | Hawaii | Maui | 15009 | 497 | 18 | 0 | 479 | 20.86399628 | -156.56890969999995 | 2020-10-27 04:24:45 | Maui, Hawaii, US |
9231 | 9231 | 2020-10-25 | US | Hawaii | Maui | 15009 | 497 | 18 | 0 | 479 | 20.86399628 | -156.56890969999995 | 2020-10-26 04:25:02 | Maui, Hawaii, US |
3652468 | 3652468 | 2020-10-24 | US | Hawaii | Maui | 15009 | 480 | 18 | 0 | 462 | 20.86399628 | -156.56890969999995 | 2020-10-25 04:24:36 | Maui, Hawaii, US |
1054723 | 1054723 | 2020-10-23 | US | Hawaii | Maui | 15009 | 464 | 18 | 0 | 446 | 20.86399628 | -156.56890969999995 | 2020-10-24 04:24:46 | Maui, Hawaii, US |
1178393 | 1178393 | 2020-10-22 | US | Hawaii | Maui | 15009 | 435 | 18 | 0 | 417 | 20.86399628 | -156.56890969999995 | 2020-10-23 04:24:46 | Maui, Hawaii, US |
2192498 | 2192498 | 2020-10-21 | US | Hawaii | Maui | 15009 | 417 | 18 | 0 | 399 | 20.86399628 | -156.56890969999995 | 2020-10-22 04:24:27 | Maui, Hawaii, US |
3991506 | 3991506 | 2020-10-20 | US | Hawaii | Hawaii | 15001 | 1083 | 18 | 0 | 1065 | 19.60121157 | -155.5210167 | 2020-10-21 04:24:14 | Hawaii, Hawaii, US |
3991509 | 3991509 | 2020-10-20 | US | Hawaii | Maui | 15009 | 413 | 18 | 0 | 395 | 20.86399628 | -156.56890969999995 | 2020-10-21 04:24:14 | Maui, Hawaii, US |
1795526 | 1795526 | 2020-10-19 | US | Hawaii | Hawaii | 15001 | 1059 | 18 | 0 | 1041 | 19.60121157 | -155.5210167 | 2020-10-20 04:24:22 | Hawaii, Hawaii, US |
1795529 | 1795529 | 2020-10-19 | US | Hawaii | Maui | 15009 | 411 | 18 | 0 | 393 | 20.86399628 | -156.56890969999995 | 2020-10-20 04:24:22 | Maui, Hawaii, US |
763209 | 763209 | 2020-10-18 | US | Hawaii | Hawaii | 15001 | 1052 | 18 | 0 | 1034 | 19.60121157 | -155.5210167 | 2020-10-19 04:24:16 | Hawaii, Hawaii, US |
763212 | 763212 | 2020-10-18 | US | Hawaii | Maui | 15009 | 411 | 18 | 0 | 393 | 20.86399628 | -156.56890969999995 | 2020-10-19 04:24:16 | Maui, Hawaii, US |
1027247 | 1027247 | 2020-10-17 | US | Hawaii | Hawaii | 15001 | 1038 | 18 | 0 | 1020 | 19.60121157 | -155.5210167 | 2020-10-18 04:24:25 | Hawaii, Hawaii, US |
1027250 | 1027250 | 2020-10-17 | US | Hawaii | Maui | 15009 | 411 | 18 | 0 | 393 | 20.86399628 | -156.56890969999995 | 2020-10-18 04:24:25 | Maui, Hawaii, US |
2857742 | 2857742 | 2020-10-16 | US | Hawaii | Hawaii | 15001 | 1026 | 18 | 0 | 1008 | 19.60121157 | -155.5210167 | 2020-10-17 04:24:12 | Hawaii, Hawaii, US |
2857745 | 2857745 | 2020-10-16 | US | Hawaii | Maui | 15009 | 411 | 18 | 0 | 393 | 20.86399628 | -156.56890969999995 | 2020-10-17 04:24:12 | Maui, Hawaii, US |
787271 | 787271 | 2020-10-15 | US | Hawaii | Hawaii | 15001 | 1005 | 18 | 0 | 987 | 19.60121157 | -155.5210167 | 2020-10-16 04:24:01 | Hawaii, Hawaii, US |
787274 | 787274 | 2020-10-15 | US | Hawaii | Maui | 15009 | 411 | 18 | 0 | 393 | 20.86399628 | -156.56890969999995 | 2020-10-16 04:24:01 | Maui, Hawaii, US |
79982 | 79982 | 2020-10-14 | US | Hawaii | Hawaii | 15001 | 992 | 18 | 0 | 974 | 19.60121157 | -155.5210167 | 2020-10-15 04:24:28 | Hawaii, Hawaii, US |
79985 | 79985 | 2020-10-14 | US | Hawaii | Maui | 15009 | 409 | 18 | 0 | 391 | 20.86399628 | -156.56890969999995 | 2020-10-15 04:24:28 | Maui, Hawaii, US |
842600 | 842600 | 2020-07-22 | US | Hawaii | Honolulu | 15003 | 1117 | 18 | 0 | 1099 | 21.45803166 | -157.97121819999995 | 2020-07-23 05:15:04 | 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]);