johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
56 rows where active = 13 and country_or_region = "Colombia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 7
country_or_region 1
- Colombia · 56 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903820 | 3903820 | 2021-07-31 | Colombia | Guainia | 2214 | 29 | 2172 | 13 | 2.5854 | -68.5247 | 2021-08-01 04:21:50 | Guainia, Colombia | ||
1378354 | 1378354 | 2021-07-25 | Colombia | Guainia | 2208 | 29 | 2166 | 13 | 2.5854 | -68.5247 | 2021-07-26 04:21:28 | Guainia, Colombia | ||
1330094 | 1330094 | 2021-07-24 | Colombia | Guainia | 2207 | 29 | 2165 | 13 | 2.5854 | -68.5247 | 2021-07-25 04:22:12 | Guainia, Colombia | ||
3958370 | 3958370 | 2021-06-26 | Colombia | Vaupes | 1669 | 15 | 1641 | 13 | 0.8554 | -70.812 | 2021-06-27 04:21:39 | Vaupes, Colombia | ||
2422754 | 2422754 | 2021-06-23 | Colombia | Vaupes | 1664 | 15 | 1636 | 13 | 0.8554 | -70.812 | 2021-06-24 04:21:55 | Vaupes, Colombia | ||
2820635 | 2820635 | 2021-05-10 | Colombia | Vaupes | 1326 | 13 | 1300 | 13 | 0.8554 | -70.812 | 2021-05-11 04:20:41 | Vaupes, Colombia | ||
2760766 | 2760766 | 2021-05-03 | Colombia | Guainia | 1440 | 22 | 1405 | 13 | 2.5854 | -68.5247 | 2021-05-04 04:20:34 | Guainia, Colombia | ||
1636163 | 1636163 | 2021-04-29 | Colombia | Guainia | 1416 | 22 | 1381 | 13 | 2.5854 | -68.5247 | 2021-04-30 04:21:03 | Guainia, Colombia | ||
887984 | 887984 | 2021-04-26 | Colombia | Vaupes | 1226 | 13 | 1200 | 13 | 0.8554 | -70.812 | 2021-04-27 04:20:52 | Vaupes, Colombia | ||
1408891 | 1408891 | 2021-04-23 | Colombia | Guaviare | 2325 | 40 | 2272 | 13 | 1.0654 | -73.2603 | 2021-04-24 04:20:38 | Guaviare, Colombia | ||
3129369 | 3129369 | 2021-04-18 | Colombia | Guaviare | 2311 | 40 | 2258 | 13 | 1.0654 | -73.2603 | 2021-04-19 04:20:57 | Guaviare, Colombia | ||
982797 | 982797 | 2021-04-17 | Colombia | Guaviare | 2311 | 40 | 2258 | 13 | 1.0654 | -73.2603 | 2021-04-18 04:20:41 | Guaviare, Colombia | ||
3883436 | 3883436 | 2021-04-11 | Colombia | Guainia | 1347 | 22 | 1312 | 13 | 2.5854 | -68.5247 | 2021-04-12 04:21:00 | Guainia, Colombia | ||
2983121 | 2983121 | 2021-04-10 | Colombia | Vaupes | 1178 | 13 | 1152 | 13 | 0.8554 | -70.812 | 2021-04-11 04:20:56 | Vaupes, Colombia | ||
388081 | 388081 | 2021-04-04 | Colombia | San Andres y Providencia | 2780 | 45 | 2722 | 13 | 12.5567 | -81.7185 | 2021-04-05 04:20:35 | San Andres y Providencia, Colombia | ||
637782 | 637782 | 2021-03-31 | Colombia | San Andres y Providencia | 2758 | 45 | 2700 | 13 | 12.5567 | -81.7185 | 2021-04-01 04:27:05 | San Andres y Providencia, Colombia | ||
1289864 | 1289864 | 2021-03-29 | Colombia | San Andres y Providencia | 2750 | 45 | 2692 | 13 | 12.5567 | -81.7185 | 2021-03-30 04:26:23 | San Andres y Providencia, Colombia | ||
1880844 | 1880844 | 2021-03-26 | Colombia | San Andres y Providencia | 2738 | 45 | 2680 | 13 | 12.5567 | -81.7185 | 2021-03-27 05:25:04 | San Andres y Providencia, Colombia | ||
1798487 | 1798487 | 2021-03-23 | Colombia | Guaviare | 2292 | 40 | 2239 | 13 | 1.0654 | -73.2603 | 2021-03-24 05:25:40 | Guaviare, Colombia | ||
3452705 | 3452705 | 2021-03-18 | Colombia | Guaviare | 2288 | 40 | 2235 | 13 | 1.0654 | -73.2603 | 2021-03-19 05:26:09 | Guaviare, Colombia | ||
1580017 | 1580017 | 2021-03-13 | Colombia | Vichada | 1394 | 22 | 1359 | 13 | 4.4234 | -69.2878 | 2021-03-14 05:25:37 | Vichada, Colombia | ||
3962368 | 3962368 | 2021-03-10 | Colombia | Guaviare | 2256 | 40 | 2203 | 13 | 1.0654 | -73.2603 | 2021-03-11 05:25:48 | Guaviare, Colombia | ||
3663456 | 3663456 | 2021-03-09 | Colombia | Guaviare | 2256 | 40 | 2203 | 13 | 1.0654 | -73.2603 | 2021-03-10 05:24:35 | Guaviare, Colombia | ||
2359315 | 2359315 | 2021-03-08 | Colombia | Guaviare | 2256 | 40 | 2203 | 13 | 1.0654 | -73.2603 | 2021-03-09 05:28:19 | Guaviare, Colombia | ||
54653 | 54653 | 2021-03-07 | Colombia | Guaviare | 2256 | 40 | 2203 | 13 | 1.0654 | -73.2603 | 2021-03-08 05:24:48 | Guaviare, Colombia | ||
2207502 | 2207502 | 2021-03-04 | Colombia | Guaviare | 2252 | 40 | 2199 | 13 | 1.0654 | -73.2603 | 2021-03-05 05:26:29 | Guaviare, Colombia | ||
1089923 | 1089923 | 2021-03-03 | Colombia | Guaviare | 2252 | 40 | 2199 | 13 | 1.0654 | -73.2603 | 2021-03-04 05:24:24 | Guaviare, Colombia | ||
3065857 | 3065857 | 2021-02-27 | Colombia | San Andres y Providencia | 2704 | 45 | 2646 | 13 | 12.5567 | -81.7185 | 2021-02-28 05:22:20 | San Andres y Providencia, Colombia | ||
2183441 | 2183441 | 2021-02-26 | Colombia | San Andres y Providencia | 2702 | 45 | 2644 | 13 | 12.5567 | -81.7185 | 2021-02-27 05:22:28 | San Andres y Providencia, Colombia | ||
1338123 | 1338123 | 2021-02-15 | Colombia | Guaviare | 2207 | 39 | 2155 | 13 | 1.0654 | -73.2603 | 2021-02-16 05:24:38 | Guaviare, Colombia | ||
1093935 | 1093935 | 2021-01-20 | Colombia | Guainia | 1252 | 20 | 1219 | 13 | 2.5854 | -68.5247 | 2021-01-21 05:22:01 | Guainia, Colombia | ||
908043 | 908043 | 2021-01-19 | Colombia | Vichada | 1192 | 20 | 1159 | 13 | 4.4234 | -69.2878 | 2021-01-20 05:21:54 | Vichada, Colombia | ||
3515268 | 3515268 | 2021-01-15 | Colombia | Vichada | 1176 | 17 | 1146 | 13 | 4.4234 | -69.2878 | 2021-01-16 05:22:40 | Vichada, Colombia | ||
189934 | 189934 | 2021-01-11 | Colombia | Vichada | 1171 | 15 | 1143 | 13 | 4.4234 | -69.2878 | 2021-01-12 05:22:15 | Vichada, Colombia | ||
2864581 | 2864581 | 2021-01-06 | Colombia | Vichada | 1160 | 14 | 1133 | 13 | 4.4234 | -69.2878 | 2021-01-07 05:22:03 | Vichada, Colombia | ||
3034168 | 3034168 | 2021-01-05 | Colombia | Vichada | 1160 | 14 | 1133 | 13 | 4.4234 | -69.2878 | 2021-01-06 05:22:16 | Vichada, Colombia | ||
2127859 | 2127859 | 2020-12-17 | Colombia | Vichada | 1093 | 14 | 1066 | 13 | 4.4234 | -69.2878 | 2020-12-18 05:28:18 | Vichada, Colombia | ||
3847637 | 3847637 | 2020-12-13 | Colombia | Guaviare | 1883 | 35 | 1835 | 13 | 1.0654 | -73.2603 | 2020-12-14 05:26:27 | Guaviare, Colombia | ||
860510 | 860510 | 2020-12-11 | Colombia | Amazonas | 3169 | 123 | 3033 | 13 | -1.4429 | -71.5724 | 2020-12-12 05:26:19 | Amazonas, Colombia | ||
1600085 | 1600085 | 2020-12-10 | Colombia | Vichada | 1049 | 12 | 1024 | 13 | 4.4234 | -69.2878 | 2020-12-11 05:26:59 | Vichada, Colombia | ||
1818621 | 1818621 | 2020-12-08 | Colombia | Amazonas | 3163 | 123 | 3027 | 13 | -1.4429 | -71.5724 | 2020-12-09 05:28:01 | Amazonas, Colombia | ||
2935098 | 2935098 | 2020-11-28 | Colombia | Vichada | 896 | 11 | 872 | 13 | 4.4234 | -69.2878 | 2020-11-29 05:25:55 | Vichada, Colombia | ||
821436 | 821436 | 2020-11-19 | Colombia | Vichada | 883 | 11 | 859 | 13 | 4.4234 | -69.2878 | 2020-11-20 05:26:28 | Vichada, Colombia | ||
2497884 | 2497884 | 2020-11-03 | Colombia | Vaupes | 1070 | 12 | 1045 | 13 | 0.8554 | -70.812 | 2020-11-04 05:25:09 | Vaupes, Colombia | ||
2613867 | 2613867 | 2020-09-26 | Colombia | Amazonas | 2742 | 117 | 2612 | 13 | -1.4429 | -71.5724 | 2020-09-27 04:23:00 | Amazonas, Colombia | ||
2812582 | 2812582 | 2020-09-25 | Colombia | Amazonas | 2741 | 117 | 2611 | 13 | -1.4429 | -71.5724 | 2020-09-26 04:23:00 | Amazonas, Colombia | ||
2653602 | 2653602 | 2020-09-23 | Colombia | Amazonas | 2739 | 116 | 2610 | 13 | -1.4429 | -71.5724 | 2020-09-24 04:23:00 | Amazonas, Colombia | ||
2728837 | 2728837 | 2020-09-15 | Colombia | Amazonas | 2725 | 115 | 2597 | 13 | -1.4429 | -71.5724 | 2020-09-16 04:22:53 | Amazonas, Colombia | ||
2299298 | 2299298 | 2020-08-22 | Colombia | Guainia | 28 | 2 | 13 | 13 | 2.5854 | -68.5247 | 2020-08-23 04:27:48 | Guainia, Colombia | ||
1479405 | 1479405 | 2020-08-21 | Colombia | Guainia | 28 | 2 | 13 | 13 | 2.5854 | -68.5247 | 2020-08-22 04:27:49 | Guainia, Colombia | ||
3484154 | 3484154 | 2020-08-20 | Colombia | Guainia | 28 | 2 | 13 | 13 | 2.5854 | -68.5247 | 2020-08-21 04:27:41 | Guainia, Colombia | ||
3612404 | 3612404 | 2020-08-06 | Colombia | San Andres y Providencia | 45 | 0 | 32 | 13 | 12.5567 | -81.7185 | 2020-08-07 04:35:11 | San Andres y Providencia, Colombia | ||
3793234 | 3793234 | 2020-08-05 | Colombia | San Andres y Providencia | 45 | 0 | 32 | 13 | 12.5567 | -81.7185 | 2020-08-06 04:35:02 | San Andres y Providencia, Colombia | ||
98470 | 98470 | 2020-08-04 | Colombia | San Andres y Providencia | 45 | 0 | 32 | 13 | 12.5567 | -81.7185 | 2020-08-05 04:34:43 | San Andres y Providencia, Colombia | ||
3045492 | 3045492 | 2020-07-02 | Colombia | Putumayo | 28 | 6 | 9 | 13 | 0.436 | -75.5277 | 2020-07-03 04:33:54 | Putumayo, Colombia | ||
303183 | 303183 | 2020-07-01 | Colombia | Putumayo | 28 | 6 | 9 | 13 | 0.436 | -75.5277 | 2020-07-02 04:33:46 | Putumayo, 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]);