johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where active = 429 and country_or_region = "Colombia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, latitude, last_update (date)
province_or_state 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1165023 | 1165023 | 2021-07-04 | Colombia | Putumayo | 13814 | 568 | 12817 | 429 | 0.436 | -75.5277 | 2021-07-05 04:21:28 | Putumayo, Colombia | ||
2884208 | 2884208 | 2021-06-20 | Colombia | Caqueta | 19554 | 730 | 18395 | 429 | 0.8699 | -73.8419 | 2021-06-21 04:21:41 | Caqueta, Colombia | ||
2020567 | 2020567 | 2021-04-20 | Colombia | Choco | 7439 | 213 | 6797 | 429 | 5.2528 | -76.82600000000002 | 2021-04-21 04:21:14 | Choco, Colombia | ||
12190 | 12190 | 2021-01-26 | Colombia | La Guajira | 15353 | 590 | 14334 | 429 | 11.3548 | -72.5205 | 2021-01-27 05:23:41 | La Guajira, Colombia | ||
2567514 | 2567514 | 2021-01-25 | Colombia | La Guajira | 15353 | 590 | 14334 | 429 | 11.3548 | -72.5205 | 2021-01-26 05:22:02 | La Guajira, Colombia | ||
2127835 | 2127835 | 2020-12-17 | Colombia | Casanare | 7977 | 162 | 7386 | 429 | 5.7589 | -71.5724 | 2020-12-18 05:28:18 | Casanare, Colombia | ||
1177345 | 1177345 | 2020-10-22 | Colombia | La Guajira | 9386 | 381 | 8576 | 429 | 11.3548 | -72.5205 | 2020-10-23 04:24:46 | La Guajira, Colombia | ||
3785752 | 3785752 | 2020-10-11 | Colombia | Putumayo | 4012 | 184 | 3399 | 429 | 0.436 | -75.5277 | 2020-10-12 04:23:45 | Putumayo, Colombia | ||
2991130 | 2991130 | 2020-08-24 | Colombia | Quindio | 977 | 29 | 519 | 429 | 4.461 | -75.6674 | 2020-08-25 04:28:02 | Quindio, Colombia | ||
2708735 | 2708735 | 2020-07-17 | Colombia | Risaralda | 926 | 21 | 476 | 429 | 5.3158 | -75.9928 | 2020-07-18 04:34:45 | Risaralda, Colombia | ||
3237364 | 3237364 | 2020-07-10 | Colombia | Cauca | 653 | 23 | 201 | 429 | 2.705 | -76.82600000000002 | 2020-07-11 04:34:26 | Cauca, 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]);