johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where active = 272 and country_or_region = "Colombia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, combined_key, day (date)
province_or_state 5
- Amazonas 2
- Arauca 1
- Choco 1
- Norte de Santander 1
- Putumayo 1
country_or_region 1
- Colombia · 6 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
982793 | 982793 | 2021-04-17 | Colombia | Choco | 7203 | 212 | 6719 | 272 | 5.2528 | -76.82600000000002 | 2021-04-18 04:20:41 | Choco, Colombia | ||
3859687 | 3859687 | 2020-12-04 | Colombia | Putumayo | 5065 | 229 | 4564 | 272 | 0.436 | -75.5277 | 2020-12-05 05:27:36 | Putumayo, Colombia | ||
2836652 | 2836652 | 2020-09-21 | Colombia | Arauca | 1478 | 36 | 1170 | 272 | 7.0762 | -70.7105 | 2020-09-22 04:23:00 | Arauca, Colombia | ||
3436091 | 3436091 | 2020-07-11 | Colombia | Norte de Santander | 511 | 27 | 212 | 272 | 7.9463 | -72.8988 | 2020-07-12 04:34:30 | Norte de Santander, Colombia | ||
529691 | 529691 | 2020-07-04 | Colombia | Amazonas | 2328 | 90 | 1966 | 272 | -1.4429 | -71.5724 | 2020-07-05 04:33:46 | Amazonas, Colombia | ||
2974215 | 2974215 | 2020-06-30 | Colombia | Amazonas | 2276 | 90 | 1914 | 272 | -1.4429 | -71.5724 | 2020-07-01 04:33:52 | Amazonas, 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]);