johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where country_or_region = "US", deaths = 57 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
409200 | 409200 | 2021-07-28 | US | Hawaii | Hawaii | 15001 | 3785 | 57 | 0 | 19.60121157 | -155.5210167 | 2021-07-29 04:21:33 | Hawaii, Hawaii, US | |
3332439 | 3332439 | 2021-07-21 | US | Hawaii | Maui | 15009 | 5042 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-22 04:21:19 | Maui, Hawaii, US | |
2372420 | 2372420 | 2021-07-20 | US | Hawaii | Maui | 15009 | 5024 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-21 04:21:40 | Maui, Hawaii, US | |
484499 | 484499 | 2021-07-19 | US | Hawaii | Maui | 15009 | 5018 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-20 04:21:48 | Maui, Hawaii, US | |
2674722 | 2674722 | 2021-07-18 | US | Hawaii | Maui | 15009 | 5009 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-19 04:21:24 | Maui, Hawaii, US | |
3707034 | 3707034 | 2021-07-17 | US | Hawaii | Maui | 15009 | 4997 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-18 04:22:07 | Maui, Hawaii, US | |
2948265 | 2948265 | 2021-07-16 | US | Hawaii | Maui | 15009 | 4988 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-17 04:22:22 | Maui, Hawaii, US | |
296921 | 296921 | 2021-07-15 | US | Hawaii | Maui | 15009 | 4980 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-16 04:21:22 | Maui, Hawaii, US | |
3632866 | 3632866 | 2021-07-14 | US | Hawaii | Maui | 15009 | 4958 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-15 04:21:48 | Maui, Hawaii, US | |
579741 | 579741 | 2021-07-13 | US | Hawaii | Maui | 15009 | 4951 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-14 04:21:35 | Maui, Hawaii, US | |
3741990 | 3741990 | 2021-07-12 | US | Hawaii | Maui | 15009 | 4950 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-13 04:21:18 | Maui, Hawaii, US | |
3660503 | 3660503 | 2021-07-11 | US | Hawaii | Maui | 15009 | 4944 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-12 04:21:34 | Maui, Hawaii, US | |
626787 | 626787 | 2021-07-10 | US | Hawaii | Maui | 15009 | 4931 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-11 04:21:43 | Maui, Hawaii, US | |
830506 | 830506 | 2021-07-09 | US | Hawaii | Maui | 15009 | 4924 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-10 04:21:25 | Maui, Hawaii, US | |
779270 | 779270 | 2021-07-08 | US | Hawaii | Maui | 15009 | 4920 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-09 04:21:21 | Maui, Hawaii, US | |
1441492 | 1441492 | 2021-07-07 | US | Hawaii | Maui | 15009 | 4913 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-08 04:21:26 | Maui, Hawaii, US | |
2694597 | 2694597 | 2021-07-06 | US | Hawaii | Maui | 15009 | 4912 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-07 04:21:20 | Maui, Hawaii, US | |
1933346 | 1933346 | 2021-07-05 | US | Hawaii | Maui | 15009 | 4909 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-06 04:21:32 | Maui, Hawaii, US | |
1166077 | 1166077 | 2021-07-04 | US | Hawaii | Maui | 15009 | 4908 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-05 04:21:28 | Maui, Hawaii, US | |
1496511 | 1496511 | 2021-07-03 | US | Hawaii | Maui | 15009 | 4903 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-04 04:21:38 | Maui, Hawaii, US | |
2072826 | 2072826 | 2021-07-02 | US | Hawaii | Maui | 15009 | 4896 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-03 04:21:37 | Maui, Hawaii, US | |
2765842 | 2765842 | 2021-07-01 | US | Hawaii | Maui | 15009 | 4891 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-02 04:21:47 | Maui, Hawaii, US | |
1894050 | 1894050 | 2021-06-30 | US | Hawaii | Maui | 15009 | 4891 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-07-01 04:21:19 | Maui, Hawaii, US | |
401173 | 401173 | 2021-06-29 | US | Hawaii | Maui | 15009 | 4887 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-30 04:21:41 | Maui, Hawaii, US | |
3126416 | 3126416 | 2021-06-28 | US | Hawaii | Maui | 15009 | 4879 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-29 04:21:28 | Maui, Hawaii, US | |
2590911 | 2590911 | 2021-06-27 | US | Hawaii | Maui | 15009 | 4877 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-28 04:21:29 | Maui, Hawaii, US | |
3959415 | 3959415 | 2021-06-26 | US | Hawaii | Maui | 15009 | 4870 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-27 04:21:39 | Maui, Hawaii, US | |
1713234 | 1713234 | 2021-06-25 | US | Hawaii | Maui | 15009 | 4867 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-26 04:21:43 | Maui, Hawaii, US | |
2296359 | 2296359 | 2021-06-24 | US | Hawaii | Maui | 15009 | 4858 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-25 04:21:33 | Maui, Hawaii, US | |
2423798 | 2423798 | 2021-06-23 | US | Hawaii | Maui | 15009 | 4847 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-24 04:21:55 | Maui, Hawaii, US | |
563875 | 563875 | 2021-06-22 | US | Hawaii | Maui | 15009 | 4845 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-23 04:21:46 | Maui, Hawaii, US | |
3359577 | 3359577 | 2021-06-21 | US | Hawaii | Maui | 15009 | 4842 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-22 04:21:34 | Maui, Hawaii, US | |
2885276 | 2885276 | 2021-06-20 | US | Hawaii | Maui | 15009 | 4842 | 57 | 0 | 20.86399628 | -156.56890969999995 | 2021-06-21 04:21:41 | Maui, 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]);