johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where country_or_region = "Colombia" and deaths = 928 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, latitude, combined_key, day (date)
country_or_region 1
- Colombia · 9 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43533 | 43533 | 2021-11-02 | Colombia | Casanare | 35667 | 928 | 0 | 5.7589 | -71.5724 | 2021-11-03 06:22:09 | Casanare, Colombia | |||
2462632 | 2462632 | 2021-09-14 | Colombia | Caqueta | 22771 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-15 03:22:37 | Caqueta, Colombia | |||
1385471 | 1385471 | 2021-09-13 | Colombia | Caqueta | 22769 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-14 04:21:41 | Caqueta, Colombia | |||
1884840 | 1884840 | 2021-09-12 | Colombia | Caqueta | 22765 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-13 04:21:15 | Caqueta, Colombia | |||
3805743 | 3805743 | 2021-09-11 | Colombia | Caqueta | 22761 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-12 04:21:13 | Caqueta, Colombia | |||
3448683 | 3448683 | 2021-09-10 | Colombia | Caqueta | 22760 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-11 04:21:30 | Caqueta, Colombia | |||
742170 | 742170 | 2021-02-20 | Colombia | Quindio | 31601 | 928 | 30108 | 565 | 4.461 | -75.6674 | 2021-02-21 05:24:33 | Quindio, Colombia | ||
272007 | 272007 | 2020-11-10 | Colombia | Magdalena | 18011 | 928 | 16334 | 749 | 10.4113 | -74.4057 | 2020-11-11 05:25:30 | Magdalena, Colombia | ||
1612094 | 1612094 | 2020-08-14 | Colombia | Cordoba | 12587 | 928 | 5809 | 5850 | 8.0493 | -75.574 | 2020-08-15 04:27:31 | Cordoba, Colombia |
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]);