johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where country_or_region = "US", deaths = 59 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67967 | 67967 | 2021-09-01 | US | Hawaii | Hawaii | 15001 | 7698 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-09-02 04:21:15 | Hawaii, Hawaii, US | |
2068809 | 2068809 | 2021-08-31 | US | Hawaii | Hawaii | 15001 | 7634 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-09-01 04:21:38 | Hawaii, Hawaii, US | |
1776263 | 1776263 | 2021-08-30 | US | Hawaii | Hawaii | 15001 | 7569 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-31 04:21:46 | Hawaii, Hawaii, US | |
3892837 | 3892837 | 2021-08-29 | US | Hawaii | Hawaii | 15001 | 7430 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-30 04:21:23 | Hawaii, Hawaii, US | |
2793940 | 2793940 | 2021-08-28 | US | Hawaii | Hawaii | 15001 | 7216 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-29 04:21:14 | Hawaii, Hawaii, US | |
2924099 | 2924099 | 2021-08-27 | US | Hawaii | Hawaii | 15001 | 7100 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-28 04:21:28 | Hawaii, Hawaii, US | |
1597113 | 1597113 | 2021-08-26 | US | Hawaii | Hawaii | 15001 | 6916 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-27 04:21:37 | Hawaii, Hawaii, US | |
33322 | 33322 | 2021-08-25 | US | Hawaii | Hawaii | 15001 | 6740 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-26 04:21:28 | Hawaii, Hawaii, US | |
3106361 | 3106361 | 2021-08-24 | US | Hawaii | Hawaii | 15001 | 6656 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-25 04:21:41 | Hawaii, Hawaii, US | |
3166532 | 3166532 | 2021-08-23 | US | Hawaii | Hawaii | 15001 | 6556 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-24 04:21:19 | Hawaii, Hawaii, US | |
2176459 | 2176459 | 2021-08-22 | US | Hawaii | Hawaii | 15001 | 6449 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-23 04:21:27 | Hawaii, Hawaii, US | |
3556555 | 3556555 | 2021-08-21 | US | Hawaii | Hawaii | 15001 | 6291 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-22 04:21:29 | Hawaii, Hawaii, US | |
1854897 | 1854897 | 2021-08-20 | US | Hawaii | Hawaii | 15001 | 6165 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-21 04:21:38 | Hawaii, Hawaii, US | |
512604 | 512604 | 2021-08-19 | US | Hawaii | Hawaii | 15001 | 6003 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-20 04:21:33 | Hawaii, Hawaii, US | |
2519083 | 2519083 | 2021-08-18 | US | Hawaii | Hawaii | 15001 | 5840 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-19 04:21:15 | Hawaii, Hawaii, US | |
246175 | 246175 | 2021-08-17 | US | Hawaii | Hawaii | 15001 | 5753 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-18 04:21:35 | Hawaii, Hawaii, US | |
1605138 | 1605138 | 2021-08-16 | US | Hawaii | Hawaii | 15001 | 5669 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-17 04:21:49 | Hawaii, Hawaii, US | |
104232 | 104232 | 2021-08-15 | US | Hawaii | Hawaii | 15001 | 5589 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-16 04:21:31 | Hawaii, Hawaii, US | |
508590 | 508590 | 2021-08-14 | US | Hawaii | Hawaii | 15001 | 5442 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-15 04:21:41 | Hawaii, Hawaii, US | |
1484462 | 1484462 | 2021-08-13 | US | Hawaii | Hawaii | 15001 | 5308 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-14 04:21:25 | Hawaii, Hawaii, US | |
2900592 | 2900592 | 2021-08-12 | US | Hawaii | Hawaii | 15001 | 5157 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-13 04:21:24 | Hawaii, Hawaii, US | |
1343196 | 1343196 | 2021-08-11 | US | Hawaii | Hawaii | 15001 | 5035 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-12 04:21:25 | Hawaii, Hawaii, US | |
2352343 | 2352343 | 2021-08-10 | US | Hawaii | Hawaii | 15001 | 4956 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-11 04:21:58 | Hawaii, Hawaii, US | |
650872 | 650872 | 2021-08-09 | US | Hawaii | Hawaii | 15001 | 4880 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-10 04:21:27 | Hawaii, Hawaii, US | |
590534 | 590534 | 2021-08-08 | US | Hawaii | Hawaii | 15001 | 4813 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-09 04:21:24 | Hawaii, Hawaii, US | |
2204546 | 2204546 | 2021-08-07 | US | Hawaii | Hawaii | 15001 | 4695 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-08 04:21:33 | Hawaii, Hawaii, US | |
1118496 | 1118496 | 2021-08-06 | US | Hawaii | Hawaii | 15001 | 4594 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-07 04:21:30 | Hawaii, Hawaii, US | |
194961 | 194961 | 2020-08-31 | US | Hawaii | Honolulu | 15003 | 7691 | 59 | 0 | 7632 | 21.45803166 | -157.97121819999995 | 2020-09-01 04:28:31 | 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]);