johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where country_or_region = "Cabo Verde" and deaths = 112 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
country_or_region 1
- Cabo Verde · 9 ✖
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1010067 | 1010067 | 2020-12-30 | Cabo Verde | 11793 | 112 | 11530 | 151 | 16.5388 | -23.0418 | 2020-12-31 05:22:49 | Cabo Verde | |||
766082 | 766082 | 2020-12-29 | Cabo Verde | 11752 | 112 | 11504 | 136 | 16.5388 | -23.0418 | 2020-12-30 05:22:34 | Cabo Verde | |||
3761346 | 3761346 | 2020-12-28 | Cabo Verde | 11723 | 112 | 11499 | 112 | 16.5388 | -23.0418 | 2020-12-29 05:22:37 | Cabo Verde | |||
3777666 | 3777666 | 2020-12-27 | Cabo Verde | 11714 | 112 | 11447 | 155 | 16.5388 | -23.0418 | 2020-12-28 05:22:06 | Cabo Verde | |||
2223271 | 2223271 | 2020-12-26 | Cabo Verde | 11698 | 112 | 11426 | 160 | 16.5388 | -23.0418 | 2020-12-27 05:22:55 | Cabo Verde | |||
202018 | 202018 | 2020-12-25 | Cabo Verde | 11696 | 112 | 11381 | 203 | 16.5388 | -23.0418 | 2020-12-26 05:22:28 | Cabo Verde | |||
3691241 | 3691241 | 2020-12-24 | Cabo Verde | 11688 | 112 | 11366 | 210 | 16.5388 | -23.0418 | 2020-12-25 05:22:48 | Cabo Verde | |||
2406593 | 2406593 | 2020-12-23 | Cabo Verde | 11668 | 112 | 11311 | 245 | 16.5388 | -23.0418 | 2020-12-24 05:23:04 | Cabo Verde | |||
3769639 | 3769639 | 2020-12-22 | Cabo Verde | 11636 | 112 | 11275 | 249 | 16.5388 | -23.0418 | 2020-12-23 05:22:03 | Cabo Verde |
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]);