johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where active = 467 and country_or_region = "Colombia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
country_or_region 1
- Colombia · 11 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3740921 | 3740921 | 2021-07-12 | Colombia | Caqueta | 21153 | 809 | 19877 | 467 | 0.8699 | -73.8419 | 2021-07-13 04:21:18 | Caqueta, Colombia | ||
3659449 | 3659449 | 2021-07-11 | Colombia | Putumayo | 14170 | 580 | 13123 | 467 | 0.436 | -75.5277 | 2021-07-12 04:21:34 | Putumayo, Colombia | ||
3709981 | 3709981 | 2021-04-03 | Colombia | Cauca | 28236 | 777 | 26992 | 467 | 2.705 | -76.82600000000002 | 2021-04-04 04:20:49 | Cauca, Colombia | ||
1289858 | 1289858 | 2021-03-29 | Colombia | Meta | 43673 | 996 | 42210 | 467 | 3.272 | -73.0877 | 2021-03-30 04:26:23 | Meta, Colombia | ||
3369185 | 3369185 | 2021-03-21 | Colombia | Quindio | 33608 | 1003 | 32138 | 467 | 4.461 | -75.6674 | 2021-03-22 05:25:43 | Quindio, Colombia | ||
2055735 | 2055735 | 2021-03-15 | Colombia | Meta | 43033 | 985 | 41581 | 467 | 3.272 | -73.0877 | 2021-03-16 05:25:13 | Meta, Colombia | ||
3149454 | 3149454 | 2020-12-16 | Colombia | Sucre | 16970 | 667 | 15836 | 467 | 8.814 | -74.7233 | 2020-12-17 05:28:12 | Sucre, Colombia | ||
3847649 | 3847649 | 2020-12-13 | Colombia | Sucre | 16898 | 665 | 15766 | 467 | 8.814 | -74.7233 | 2020-12-14 05:26:27 | Sucre, Colombia | ||
376033 | 376033 | 2020-11-06 | Colombia | La Guajira | 10484 | 420 | 9597 | 467 | 11.3548 | -72.5205 | 2020-11-07 05:24:52 | La Guajira, Colombia | ||
2079793 | 2079793 | 2020-10-31 | Colombia | Sucre | 15433 | 614 | 14352 | 467 | 8.814 | -74.7233 | 2020-11-01 04:36:19 | Sucre, Colombia | ||
3651430 | 3651430 | 2020-10-24 | Colombia | Sucre | 15188 | 607 | 14114 | 467 | 8.814 | -74.7233 | 2020-10-25 04:24:36 | Sucre, 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]);