johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where active = 100 and country_or_region = "Colombia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: combined_key, last_update (date)
province_or_state 9
country_or_region 1
- Colombia · 16 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3631805 | 3631805 | 2021-07-14 | Colombia | Guaviare | 4856 | 84 | 4672 | 100 | 1.0654 | -73.2603 | 2021-07-15 04:21:48 | Guaviare, Colombia | ||
3085155 | 3085155 | 2021-04-05 | Colombia | Putumayo | 8247 | 326 | 7821 | 100 | 0.436 | -75.5277 | 2021-04-06 04:20:32 | Putumayo, Colombia | ||
3600873 | 3600873 | 2021-02-17 | Colombia | Amazonas | 4496 | 152 | 4244 | 100 | -1.4429 | -71.5724 | 2021-02-18 05:22:58 | Amazonas, Colombia | ||
3978409 | 3978409 | 2021-02-10 | Colombia | Amazonas | 4188 | 144 | 3944 | 100 | -1.4429 | -71.5724 | 2021-02-11 05:23:55 | Amazonas, Colombia | ||
1751113 | 1751113 | 2020-12-14 | Colombia | Choco | 4619 | 167 | 4352 | 100 | 5.2528 | -76.82600000000002 | 2020-12-15 05:26:38 | Choco, Colombia | ||
3651414 | 3651414 | 2020-10-24 | Colombia | Choco | 4140 | 161 | 3879 | 100 | 5.2528 | -76.82600000000002 | 2020-10-25 04:24:36 | Choco, Colombia | ||
1045665 | 1045665 | 2020-09-30 | Colombia | Guaviare | 805 | 17 | 688 | 100 | 1.0654 | -73.2603 | 2020-10-01 04:23:42 | Guaviare, Colombia | ||
1996504 | 1996504 | 2020-08-26 | Colombia | San Andres y Providencia | 172 | 1 | 71 | 100 | 12.5567 | -81.7185 | 2020-08-27 04:28:15 | San Andres y Providencia, Colombia | ||
206119 | 206119 | 2020-08-19 | Colombia | Vaupes | 163 | 1 | 62 | 100 | 0.8554 | -70.812 | 2020-08-20 04:27:43 | Vaupes, Colombia | ||
367186 | 367186 | 2020-07-16 | Colombia | Amazonas | 2433 | 103 | 2230 | 100 | -1.4429 | -71.5724 | 2020-07-17 04:34:50 | Amazonas, Colombia | ||
367531 | 367531 | 2020-07-16 | Colombia | Putumayo | 123 | 10 | 13 | 100 | 0.436 | -75.5277 | 2020-07-17 04:34:50 | Putumayo, Colombia | ||
2625308 | 2625308 | 2020-06-25 | Colombia | Unknown | 100 | 0 | 0 | 100 | 2020-06-26 04:33:43 | Unknown, Colombia | ||||
2700546 | 2700546 | 2020-06-24 | Colombia | Boyaca | 313 | 16 | 197 | 100 | 5.4545 | -73.362 | 2020-06-25 05:26:54 | Boyaca, Colombia | ||
1522231 | 1522231 | 2020-06-23 | Colombia | Boyaca | 313 | 16 | 197 | 100 | 5.4545 | -73.362 | 2020-06-24 04:33:28 | Boyaca, Colombia | ||
1281104 | 1281104 | 2020-06-04 | Colombia | Cordoba | 163 | 7 | 56 | 100 | 8.0493 | -75.574 | 2020-06-05 02:33:06 | Cordoba, Colombia | ||
3866615 | 3866615 | 2020-06-03 | Colombia | Boyaca | 212 | 11 | 101 | 100 | 5.4545 | -73.362 | 2020-06-04 02:33:14 | Boyaca, 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]);