johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where country_or_region = "Gambia" and deaths = 123 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3761489 | 3761489 | 2020-12-28 | Gambia | 3793 | 123 | 3660 | 10 | 13.4432 | -15.3101 | 2020-12-29 05:22:37 | Gambia | |||
3777809 | 3777809 | 2020-12-27 | Gambia | 3793 | 123 | 3660 | 10 | 13.4432 | -15.3101 | 2020-12-28 05:22:06 | Gambia | |||
2223414 | 2223414 | 2020-12-26 | Gambia | 3791 | 123 | 3659 | 9 | 13.4432 | -15.3101 | 2020-12-27 05:22:55 | Gambia | |||
202161 | 202161 | 2020-12-25 | Gambia | 3791 | 123 | 3659 | 9 | 13.4432 | -15.3101 | 2020-12-26 05:22:28 | Gambia | |||
3691384 | 3691384 | 2020-12-24 | Gambia | 3791 | 123 | 3659 | 9 | 13.4432 | -15.3101 | 2020-12-25 05:22:48 | Gambia | |||
2406736 | 2406736 | 2020-12-23 | Gambia | 3791 | 123 | 3659 | 9 | 13.4432 | -15.3101 | 2020-12-24 05:23:04 | Gambia | |||
3769782 | 3769782 | 2020-12-22 | Gambia | 3791 | 123 | 3659 | 9 | 13.4432 | -15.3101 | 2020-12-23 05:22:03 | Gambia | |||
927598 | 927598 | 2020-12-21 | Gambia | 3786 | 123 | 3656 | 7 | 13.4432 | -15.3101 | 2020-12-22 05:22:33 | Gambia | |||
2119619 | 2119619 | 2020-12-20 | Gambia | 3786 | 123 | 3656 | 7 | 13.4432 | -15.3101 | 2020-12-21 05:27:58 | Gambia | |||
2931126 | 2931126 | 2020-12-19 | Gambia | 3786 | 123 | 3656 | 7 | 13.4432 | -15.3101 | 2020-12-20 05:27:32 | Gambia | |||
1901072 | 1901072 | 2020-12-18 | Gambia | 3786 | 123 | 3654 | 9 | 13.4432 | -15.3101 | 2020-12-19 05:27:52 | Gambia | |||
2127898 | 2127898 | 2020-12-17 | Gambia | 3786 | 123 | 3654 | 9 | 13.4432 | -15.3101 | 2020-12-18 05:28:18 | Gambia | |||
3149498 | 3149498 | 2020-12-16 | Gambia | 3786 | 123 | 3653 | 10 | 13.4432 | -15.3101 | 2020-12-17 05:28:12 | Gambia | |||
1034279 | 1034279 | 2020-12-15 | Gambia | 3785 | 123 | 3653 | 9 | 13.4432 | -15.3101 | 2020-12-16 05:28:04 | Gambia | |||
1751173 | 1751173 | 2020-12-14 | Gambia | 3782 | 123 | 3647 | 12 | 13.4432 | -15.3101 | 2020-12-15 05:26:38 | Gambia | |||
3847693 | 3847693 | 2020-12-13 | Gambia | 3782 | 123 | 3647 | 12 | 13.4432 | -15.3101 | 2020-12-14 05:26:27 | Gambia | |||
845475 | 845475 | 2020-12-12 | Gambia | 3779 | 123 | 3645 | 11 | 13.4432 | -15.3101 | 2020-12-13 05:27:20 | Gambia | |||
860582 | 860582 | 2020-12-11 | Gambia | 3779 | 123 | 3645 | 11 | 13.4432 | -15.3101 | 2020-12-12 05:26:19 | Gambia | |||
1600124 | 1600124 | 2020-12-10 | Gambia | 3777 | 123 | 3645 | 9 | 13.4432 | -15.3101 | 2020-12-11 05:26:59 | Gambia | |||
2975133 | 2975133 | 2020-12-09 | Gambia | 3776 | 123 | 3631 | 22 | 13.4432 | -15.3101 | 2020-12-10 05:26:19 | Gambia | |||
1818693 | 1818693 | 2020-12-08 | Gambia | 3776 | 123 | 3631 | 22 | 13.4432 | -15.3101 | 2020-12-09 05:28:01 | Gambia | |||
2347329 | 2347329 | 2020-12-07 | Gambia | 3770 | 123 | 3615 | 32 | 13.4432 | -15.3101 | 2020-12-08 05:27:42 | Gambia | |||
1006199 | 1006199 | 2020-12-06 | Gambia | 3770 | 123 | 3615 | 32 | 13.4432 | -15.3101 | 2020-12-07 05:26:14 | Gambia | |||
1632208 | 1632208 | 2020-12-05 | Gambia | 3770 | 123 | 3615 | 32 | 13.4432 | -15.3101 | 2020-12-06 05:26:18 | Gambia | |||
3859736 | 3859736 | 2020-12-04 | Gambia | 3768 | 123 | 3613 | 32 | 13.4432 | -15.3101 | 2020-12-05 05:27:36 | Gambia | |||
74994 | 74994 | 2020-12-03 | Gambia | 3767 | 123 | 3610 | 34 | 13.4432 | -15.3101 | 2020-12-04 05:27:27 | Gambia | |||
738206 | 738206 | 2020-12-02 | Gambia | 3765 | 123 | 3609 | 33 | 13.4432 | -15.3101 | 2020-12-03 05:28:22 | Gambia | |||
2537300 | 2537300 | 2020-12-01 | Gambia | 3743 | 123 | 3607 | 13 | 13.4432 | -15.3101 | 2020-12-02 05:27:41 | Gambia | |||
1584069 | 1584069 | 2020-11-30 | Gambia | 3742 | 123 | 3601 | 18 | 13.4432 | -15.3101 | 2020-12-01 05:26:18 | Gambia | |||
3566472 | 3566472 | 2020-11-29 | Gambia | 3734 | 123 | 3591 | 20 | 13.4432 | -15.3101 | 2020-11-30 05:26:13 | Gambia | |||
2935137 | 2935137 | 2020-11-28 | Gambia | 3731 | 123 | 3590 | 18 | 13.4432 | -15.3101 | 2020-11-29 05:25:55 | Gambia | |||
392140 | 392140 | 2020-11-27 | Gambia | 3731 | 123 | 3590 | 18 | 13.4432 | -15.3101 | 2020-11-28 05:25:50 | Gambia | |||
923587 | 923587 | 2020-11-26 | Gambia | 3728 | 123 | 3588 | 17 | 13.4432 | -15.3101 | 2020-11-27 05:26:53 | Gambia | |||
1972492 | 1972492 | 2020-11-25 | Gambia | 3727 | 123 | 3587 | 17 | 13.4432 | -15.3101 | 2020-11-26 05:27:44 | Gambia | |||
1350223 | 1350223 | 2020-11-24 | Gambia | 3726 | 123 | 3585 | 18 | 13.4432 | -15.3101 | 2020-11-25 05:27:20 | Gambia | |||
678217 | 678217 | 2020-11-23 | Gambia | 3726 | 123 | 3582 | 21 | 13.4432 | -15.3101 | 2020-11-24 05:27:31 | Gambia | |||
3189893 | 3189893 | 2020-11-22 | Gambia | 3726 | 123 | 3582 | 21 | 13.4432 | -15.3101 | 2020-11-23 05:25:26 | Gambia | |||
3836387 | 3836387 | 2020-11-21 | Gambia | 3726 | 123 | 3582 | 21 | 13.4432 | -15.3101 | 2020-11-22 05:25:45 | 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]);