johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where deaths = 15 and province_or_state = "Hawaii" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: admin2, fips, latitude, longitude, combined_key, last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2964302 | 2964302 | 2021-12-24 | US | Hawaii | Kauai | 15007 | 3489 | 15 | 0 | 22.03935037 | -159.5966786 | 2021-12-25 04:21:37 | Kauai, Hawaii, US | |
3817334 | 3817334 | 2021-12-23 | US | Hawaii | Kauai | 15007 | 3422 | 15 | 0 | 22.03935037 | -159.5966786 | 2021-12-24 04:21:34 | Kauai, Hawaii, US | |
3782797 | 3782797 | 2020-10-13 | US | Hawaii | Hawaii | 15001 | 974 | 15 | 0 | 959 | 19.60121157 | -155.5210167 | 2020-10-14 04:24:05 | Hawaii, Hawaii, US |
2292337 | 2292337 | 2020-10-12 | US | Hawaii | Hawaii | 15001 | 953 | 15 | 0 | 938 | 19.60121157 | -155.5210167 | 2020-10-13 04:24:02 | Hawaii, Hawaii, US |
3786789 | 3786789 | 2020-10-11 | US | Hawaii | Hawaii | 15001 | 948 | 15 | 0 | 933 | 19.60121157 | -155.5210167 | 2020-10-12 04:23:45 | Hawaii, Hawaii, US |
2602927 | 2602927 | 2020-10-10 | US | Hawaii | Hawaii | 15001 | 924 | 15 | 0 | 909 | 19.60121157 | -155.5210167 | 2020-10-11 04:23:46 | Hawaii, Hawaii, US |
818460 | 818460 | 2020-10-09 | US | Hawaii | Hawaii | 15001 | 911 | 15 | 0 | 896 | 19.60121157 | -155.5210167 | 2020-10-10 04:23:57 | Hawaii, Hawaii, US |
2690575 | 2690575 | 2020-10-08 | US | Hawaii | Hawaii | 15001 | 866 | 15 | 0 | 851 | 19.60121157 | -155.5210167 | 2020-10-09 04:23:59 | Hawaii, Hawaii, US |
1042717 | 1042717 | 2020-10-07 | US | Hawaii | Hawaii | 15001 | 852 | 15 | 0 | 837 | 19.60121157 | -155.5210167 | 2020-10-08 04:23:56 | Hawaii, Hawaii, US |
3118378 | 3118378 | 2020-10-06 | US | Hawaii | Hawaii | 15001 | 834 | 15 | 0 | 819 | 19.60121157 | -155.5210167 | 2020-10-07 04:23:40 | Hawaii, Hawaii, US |
3802790 | 3802790 | 2020-10-05 | US | Hawaii | Hawaii | 15001 | 820 | 15 | 0 | 805 | 19.60121157 | -155.5210167 | 2020-10-06 04:23:33 | Hawaii, Hawaii, US |
1823680 | 1823680 | 2020-10-04 | US | Hawaii | Hawaii | 15001 | 810 | 15 | 0 | 795 | 19.60121157 | -155.5210167 | 2020-10-05 04:23:33 | Hawaii, Hawaii, US |
2515064 | 2515064 | 2020-10-03 | US | Hawaii | Hawaii | 15001 | 795 | 15 | 0 | 780 | 19.60121157 | -155.5210167 | 2020-10-04 04:23:44 | Hawaii, Hawaii, US |
3390282 | 3390282 | 2020-10-02 | US | Hawaii | Hawaii | 15001 | 752 | 15 | 0 | 737 | 19.60121157 | -155.5210167 | 2020-10-03 04:23:40 | Hawaii, Hawaii, US |
2380523 | 2380523 | 2020-10-01 | US | Hawaii | Hawaii | 15001 | 736 | 15 | 0 | 721 | 19.60121157 | -155.5210167 | 2020-10-02 04:23:51 | Hawaii, Hawaii, US |
1046709 | 1046709 | 2020-09-30 | US | Hawaii | Hawaii | 15001 | 730 | 15 | 0 | 715 | 19.60121157 | -155.5210167 | 2020-10-01 04:23:42 | Hawaii, Hawaii, US |
967790 | 967790 | 2020-09-29 | US | Hawaii | Hawaii | 15001 | 703 | 15 | 0 | 688 | 19.60121157 | -155.5210167 | 2020-09-30 04:23:33 | Hawaii, Hawaii, US |
1516287 | 1516287 | 2020-09-28 | US | Hawaii | Hawaii | 15001 | 700 | 15 | 0 | 685 | 19.60121157 | -155.5210167 | 2020-09-29 04:23:42 | Hawaii, Hawaii, US |
2582875 | 2582875 | 2020-09-27 | US | Hawaii | Hawaii | 15001 | 700 | 15 | 0 | 685 | 19.60121157 | -155.5210167 | 2020-09-28 04:23:00 | Hawaii, Hawaii, US |
2614927 | 2614927 | 2020-09-26 | US | Hawaii | Hawaii | 15001 | 693 | 15 | 0 | 678 | 19.60121157 | -155.5210167 | 2020-09-27 04:23:00 | Hawaii, Hawaii, US |
2813642 | 2813642 | 2020-09-25 | US | Hawaii | Hawaii | 15001 | 691 | 15 | 0 | 676 | 19.60121157 | -155.5210167 | 2020-09-26 04:23:00 | Hawaii, Hawaii, US |
2606919 | 2606919 | 2020-09-24 | US | Hawaii | Hawaii | 15001 | 677 | 15 | 0 | 662 | 19.60121157 | -155.5210167 | 2020-09-25 04:23:00 | Hawaii, Hawaii, US |
2654662 | 2654662 | 2020-09-23 | US | Hawaii | Hawaii | 15001 | 672 | 15 | 0 | 657 | 19.60121157 | -155.5210167 | 2020-09-24 04:23:00 | Hawaii, Hawaii, US |
3317111 | 3317111 | 2020-09-22 | US | Hawaii | Hawaii | 15001 | 659 | 15 | 0 | 644 | 19.60121157 | -155.5210167 | 2020-09-23 04:23:00 | Hawaii, Hawaii, US |
2837710 | 2837710 | 2020-09-21 | US | Hawaii | Hawaii | 15001 | 651 | 15 | 0 | 636 | 19.60121157 | -155.5210167 | 2020-09-22 04:23:00 | Hawaii, Hawaii, US |
3094314 | 3094314 | 2020-09-20 | US | Hawaii | Hawaii | 15001 | 644 | 15 | 0 | 629 | 19.60121157 | -155.5210167 | 2020-09-21 04:23:00 | Hawaii, Hawaii, US |
2455664 | 2455664 | 2020-09-19 | US | Hawaii | Hawaii | 15001 | 639 | 15 | 0 | 624 | 19.60121157 | -155.5210167 | 2020-09-20 04:22:00 | Hawaii, Hawaii, US |
2849733 | 2849733 | 2020-09-18 | US | Hawaii | Hawaii | 15001 | 632 | 15 | 0 | 617 | 19.60121157 | -155.5210167 | 2020-09-19 04:22:00 | Hawaii, Hawaii, US |
365294 | 365294 | 2020-07-16 | US | Hawaii | Honolulu | 15003 | 1002 | 15 | 0 | 987 | 21.45803166 | -157.97121819999995 | 2020-07-17 04:34:50 | Honolulu, Hawaii, US |
2745962 | 2745962 | 2020-07-15 | US | Hawaii | Honolulu | 15003 | 986 | 15 | 0 | 971 | 21.45803166 | -157.97121819999995 | 2020-07-16 04:44:59 | Honolulu, Hawaii, US |
2156607 | 2156607 | 2020-07-14 | US | Hawaii | Honolulu | 15003 | 960 | 15 | 0 | 945 | 21.45803166 | -157.97121819999995 | 2020-07-15 04:34:39 | Honolulu, Hawaii, US |
3489254 | 3489254 | 2020-07-13 | US | Hawaii | Honolulu | 15003 | 942 | 15 | 0 | 927 | 21.45803166 | -157.97121819999995 | 2020-07-14 04:34: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]);