johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where active = 2 and country_or_region = "Colombia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, longitude
country_or_region 1
- Colombia · 44 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
927558 | 927558 | 2020-12-21 | Colombia | Vaupes | 1127 | 12 | 1113 | 2 | 0.8554 | -70.812 | 2020-12-22 05:22:33 | Vaupes, Colombia | ||
2119579 | 2119579 | 2020-12-20 | Colombia | Vaupes | 1127 | 12 | 1113 | 2 | 0.8554 | -70.812 | 2020-12-21 05:27:58 | Vaupes, Colombia | ||
2808199 | 2808199 | 2020-08-02 | Colombia | Vichada | 3 | 0 | 1 | 2 | 4.4234 | -69.2878 | 2020-08-03 04:34:35 | Vichada, Colombia | ||
367321 | 367321 | 2020-07-16 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-17 04:34:50 | Guainia, Colombia | ||
2747989 | 2747989 | 2020-07-15 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-16 04:44:59 | Guainia, Colombia | ||
2158633 | 2158633 | 2020-07-14 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-15 04:34:39 | Guainia, Colombia | ||
3491274 | 3491274 | 2020-07-13 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-14 04:34:46 | Guainia, Colombia | ||
3737537 | 3737537 | 2020-07-12 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-13 04:43:04 | Guainia, Colombia | ||
3435932 | 3435932 | 2020-07-11 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-12 04:34:30 | Guainia, Colombia | ||
3237430 | 3237430 | 2020-07-10 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-11 04:34:26 | Guainia, Colombia | ||
1005415 | 1005415 | 2020-07-09 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-10 04:34:24 | Guainia, Colombia | ||
2222631 | 2222631 | 2020-07-08 | Colombia | Guainia | 14 | 1 | 11 | 2 | 2.5854 | -68.5247 | 2020-07-09 04:34:23 | Guainia, Colombia | ||
2039655 | 2039655 | 2020-06-27 | Colombia | Caqueta | 26 | 2 | 22 | 2 | 0.8699 | -73.8419 | 2020-06-28 04:34:04 | Caqueta, Colombia | ||
1135936 | 1135936 | 2020-06-26 | Colombia | Caqueta | 26 | 2 | 22 | 2 | 0.8699 | -73.8419 | 2020-06-27 04:33:35 | Caqueta, Colombia | ||
1691665 | 1691665 | 2020-06-19 | Colombia | San Andres y Providencia | 20 | 1 | 17 | 2 | 12.5567 | -81.7185 | 2020-06-20 04:33:19 | San Andres y Providencia, Colombia | ||
3682814 | 3682814 | 2020-06-18 | Colombia | San Andres y Providencia | 20 | 1 | 17 | 2 | 12.5567 | -81.7185 | 2020-06-19 04:33:17 | San Andres y Providencia, Colombia | ||
2386467 | 2386467 | 2020-06-16 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-17 04:33:21 | Caqueta, Colombia | ||
2386780 | 2386780 | 2020-06-16 | Colombia | San Andres y Providencia | 19 | 0 | 17 | 2 | 12.5567 | -81.7185 | 2020-06-17 04:33:21 | San Andres y Providencia, Colombia | ||
287030 | 287030 | 2020-06-15 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-16 04:33:09 | Caqueta, Colombia | ||
287343 | 287343 | 2020-06-15 | Colombia | San Andres y Providencia | 19 | 0 | 17 | 2 | 12.5567 | -81.7185 | 2020-06-16 04:33:09 | San Andres y Providencia, Colombia | ||
1836981 | 1836981 | 2020-06-14 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-15 03:33:14 | Caqueta, Colombia | ||
1837057 | 1837057 | 2020-06-14 | Colombia | Guaviare | 2 | 0 | 0 | 2 | 1.0654 | -73.2603 | 2020-06-15 03:33:14 | Guaviare, Colombia | ||
3061033 | 3061033 | 2020-06-13 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-14 03:33:15 | Caqueta, Colombia | ||
3061109 | 3061109 | 2020-06-13 | Colombia | Guaviare | 2 | 0 | 0 | 2 | 1.0654 | -73.2603 | 2020-06-14 03:33:15 | Guaviare, Colombia | ||
737353 | 737353 | 2020-06-12 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-13 03:33:14 | Caqueta, Colombia | ||
737429 | 737429 | 2020-06-12 | Colombia | Guaviare | 2 | 0 | 0 | 2 | 1.0654 | -73.2603 | 2020-06-13 03:33:14 | Guaviare, Colombia | ||
737666 | 737666 | 2020-06-12 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-13 03:33:14 | San Andres y Providencia, Colombia | ||
1273323 | 1273323 | 2020-06-11 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-12 05:09:52 | Caqueta, Colombia | ||
1273399 | 1273399 | 2020-06-11 | Colombia | Guaviare | 2 | 0 | 0 | 2 | 1.0654 | -73.2603 | 2020-06-12 05:09:52 | Guaviare, Colombia | ||
1273636 | 1273636 | 2020-06-11 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-12 05:09:52 | San Andres y Providencia, Colombia | ||
2863767 | 2863767 | 2020-06-10 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-11 03:33:41 | Caqueta, Colombia | ||
2863842 | 2863842 | 2020-06-10 | Colombia | Guaviare | 2 | 0 | 0 | 2 | 1.0654 | -73.2603 | 2020-06-11 03:33:41 | Guaviare, Colombia | ||
2864078 | 2864078 | 2020-06-10 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-11 03:33:41 | San Andres y Providencia, Colombia | ||
1210620 | 1210620 | 2020-06-09 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-10 04:07:00 | Caqueta, Colombia | ||
1210904 | 1210904 | 2020-06-09 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-10 04:07:00 | San Andres y Providencia, Colombia | ||
217047 | 217047 | 2020-06-08 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-09 03:33:03 | Caqueta, Colombia | ||
217331 | 217331 | 2020-06-08 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-09 03:33:03 | San Andres y Providencia, Colombia | ||
2799844 | 2799844 | 2020-06-07 | Colombia | Caqueta | 23 | 1 | 20 | 2 | 0.8699 | -73.8419 | 2020-06-08 03:33:22 | Caqueta, Colombia | ||
2800127 | 2800127 | 2020-06-07 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-08 03:33:22 | San Andres y Providencia, Colombia | ||
574183 | 574183 | 2020-06-06 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-07 03:53:30 | San Andres y Providencia, Colombia | ||
1269880 | 1269880 | 2020-06-05 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-06 02:33:00 | San Andres y Providencia, Colombia | ||
1281349 | 1281349 | 2020-06-04 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-05 02:33:06 | San Andres y Providencia, Colombia | ||
3866904 | 3866904 | 2020-06-03 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-04 02:33:14 | San Andres y Providencia, Colombia | ||
2555946 | 2555946 | 2020-06-02 | Colombia | San Andres y Providencia | 17 | 0 | 15 | 2 | 12.5567 | -81.7185 | 2020-06-03 02:33:13 | San Andres y Providencia, 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]);