johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where country_or_region = "Gambia" and deaths = 119 sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1177399 | 1177399 | 2020-10-22 | Gambia | 3659 | 119 | 2660 | 880 | 13.4432 | -15.3101 | 2020-10-23 04:24:46 | Gambia | |||
1053729 | 1053729 | 2020-10-23 | Gambia | 3659 | 119 | 2660 | 880 | 13.4432 | -15.3101 | 2020-10-24 04:24:46 | Gambia | |||
3651474 | 3651474 | 2020-10-24 | Gambia | 3659 | 119 | 2660 | 880 | 13.4432 | -15.3101 | 2020-10-25 04:24:36 | Gambia | |||
8237 | 8237 | 2020-10-25 | Gambia | 3660 | 119 | 2660 | 881 | 13.4432 | -15.3101 | 2020-10-26 04:25:02 | Gambia | |||
3480216 | 3480216 | 2020-10-26 | Gambia | 3665 | 119 | 2660 | 886 | 13.4432 | -15.3101 | 2020-10-27 04:24:45 | Gambia | |||
1452492 | 1452492 | 2020-10-27 | Gambia | 3666 | 119 | 2666 | 881 | 13.4432 | -15.3101 | 2020-10-28 04:24:39 | Gambia | |||
754207 | 754207 | 2020-10-28 | Gambia | 3666 | 119 | 2666 | 881 | 13.4432 | -15.3101 | 2020-10-29 04:24:49 | Gambia | |||
210145 | 210145 | 2020-10-29 | Gambia | 3666 | 119 | 2666 | 881 | 13.4432 | -15.3101 | 2020-10-30 04:24:49 | Gambia | |||
2243290 | 2243290 | 2020-10-30 | Gambia | 3670 | 119 | 2876 | 675 | 13.4432 | -15.3101 | 2020-10-31 04:24:44 | Gambia | |||
2079837 | 2079837 | 2020-10-31 | Gambia | 3672 | 119 | 3196 | 357 | 13.4432 | -15.3101 | 2020-11-01 04:36:19 | Gambia | |||
3409348 | 3409348 | 2020-11-01 | Gambia | 3672 | 119 | 3196 | 357 | 13.4432 | -15.3101 | 2020-11-02 05:25:04 | Gambia | |||
3304099 | 3304099 | 2020-11-02 | Gambia | 3672 | 119 | 3196 | 357 | 13.4432 | -15.3101 | 2020-11-03 06:00:16 | Gambia |
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]);