daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Caqueta" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-06-07 | Colombia | Caqueta | 23 | 1 | 20 | 2 | 0.8699 | -73.8419 | 2020-06-08 03:33:22 | Caqueta, Colombia | ||
2020-06-06 | Colombia | Caqueta | 24 | 2 | 19 | 3 | 0.8699 | -73.8419 | 2020-06-07 03:53:30 | Caqueta, Colombia | ||
2020-06-01 | Colombia | Caqueta | 24 | 1 | 13 | 10 | 0.8699 | -73.8419 | 2020-06-02 02:33:08 | Caqueta, Colombia | ||
2020-06-05 | Colombia | Caqueta | 24 | 2 | 19 | 3 | 0.8699 | -73.8419 | 2020-06-06 02:33:00 | Caqueta, Colombia | ||
2020-06-04 | Colombia | Caqueta | 24 | 2 | 18 | 4 | 0.8699 | -73.8419 | 2020-06-05 02:33:06 | Caqueta, Colombia | ||
2020-05-29 | Colombia | Caqueta | 24 | 1 | 7 | 16 | 0.8699 | -73.8419 | 2020-05-30 02:32:48 | Caqueta, Colombia | ||
2020-05-31 | Colombia | Caqueta | 24 | 1 | 7 | 16 | 0.8699 | -73.8419 | 2020-06-01 02:32:46 | Caqueta, Colombia | ||
2020-06-02 | Colombia | Caqueta | 24 | 1 | 16 | 7 | 0.8699 | -73.8419 | 2020-06-03 02:33:13 | Caqueta, Colombia | ||
2020-05-28 | Colombia | Caqueta | 24 | 1 | 7 | 16 | 0.8699 | -73.8419 | 2020-05-29 02:32:50 | Caqueta, Colombia | ||
2020-05-30 | Colombia | Caqueta | 24 | 1 | 7 | 16 | 0.8699 | -73.8419 | 2020-05-31 02:32:45 | Caqueta, Colombia | ||
2020-06-03 | Colombia | Caqueta | 24 | 2 | 18 | 4 | 0.8699 | -73.8419 | 2020-06-04 02:33:14 | Caqueta, Colombia | ||
2020-06-08 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-09 03:33:03 | Caqueta, Colombia | ||
2020-06-15 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-16 04:33:09 | Caqueta, Colombia | ||
2020-06-12 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-13 03:33:14 | Caqueta, Colombia | ||
2020-06-09 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-10 04:07:00 | Caqueta, Colombia | ||
2020-06-11 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-12 05:09:52 | Caqueta, Colombia | ||
2020-06-14 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-15 03:33:14 | Caqueta, Colombia | ||
2020-06-16 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-17 04:33:21 | Caqueta, Colombia | ||
2020-06-10 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-11 03:33:41 | Caqueta, Colombia | ||
2020-06-13 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-14 03:33:15 | Caqueta, Colombia | ||
2020-06-26 | Colombia | Caqueta | 26 | 2 | 22 | 2 | 0.8699 | -73.8419 | 2020-06-27 04:33:35 | Caqueta, Colombia | ||
2020-06-27 | Colombia | Caqueta | 26 | 2 | 22 | 2 | 0.8699 | -73.8419 | 2020-06-28 04:34:04 | Caqueta, Colombia | ||
2020-06-17 | Colombia | Caqueta | 28 | 2 | 21 | 5 | 0.8699 | -73.8419 | 2020-06-18 04:33:18 | Caqueta, Colombia | ||
2020-06-18 | Colombia | Caqueta | 28 | 2 | 21 | 5 | 0.8699 | -73.8419 | 2020-06-19 04:33:17 | Caqueta, Colombia | ||
2020-06-23 | Colombia | Caqueta | 29 | 2 | 22 | 5 | 0.8699 | -73.8419 | 2020-06-24 04:33:28 | Caqueta, Colombia | ||
2020-06-19 | Colombia | Caqueta | 29 | 2 | 21 | 6 | 0.8699 | -73.8419 | 2020-06-20 04:33:19 | Caqueta, Colombia | ||
2020-06-20 | Colombia | Caqueta | 29 | 2 | 22 | 5 | 0.8699 | -73.8419 | 2020-06-21 04:33:19 | Caqueta, Colombia | ||
2020-06-25 | Colombia | Caqueta | 29 | 2 | 22 | 5 | 0.8699 | -73.8419 | 2020-06-26 04:33:43 | Caqueta, Colombia | ||
2020-06-24 | Colombia | Caqueta | 29 | 2 | 22 | 5 | 0.8699 | -73.8419 | 2020-06-25 05:26:54 | Caqueta, Colombia | ||
2020-06-22 | Colombia | Caqueta | 30 | 2 | 22 | 6 | 0.8699 | -73.8419 | 2020-06-23 04:33:22 | Caqueta, Colombia | ||
2020-06-21 | Colombia | Caqueta | 30 | 2 | 22 | 6 | 0.8699 | -73.8419 | 2020-06-22 04:33:20 | Caqueta, Colombia | ||
2020-07-01 | Colombia | Caqueta | 35 | 2 | 22 | 11 | 0.8699 | -73.8419 | 2020-07-02 04:33:46 | Caqueta, Colombia | ||
2020-06-28 | Colombia | Caqueta | 35 | 2 | 22 | 11 | 0.8699 | -73.8419 | 2020-06-29 04:33:44 | Caqueta, Colombia | ||
2020-06-29 | Colombia | Caqueta | 35 | 2 | 22 | 11 | 0.8699 | -73.8419 | 2020-06-30 04:33:48 | Caqueta, Colombia | ||
2020-06-30 | Colombia | Caqueta | 35 | 2 | 22 | 11 | 0.8699 | -73.8419 | 2020-07-01 04:33:52 | Caqueta, Colombia | ||
2020-07-02 | Colombia | Caqueta | 39 | 2 | 22 | 15 | 0.8699 | -73.8419 | 2020-07-03 04:33:54 | Caqueta, Colombia | ||
2020-07-04 | Colombia | Caqueta | 43 | 2 | 22 | 19 | 0.8699 | -73.8419 | 2020-07-05 04:33:46 | Caqueta, Colombia | ||
2020-07-03 | Colombia | Caqueta | 43 | 2 | 22 | 19 | 0.8699 | -73.8419 | 2020-07-04 04:33:51 | Caqueta, Colombia | ||
2020-07-05 | Colombia | Caqueta | 54 | 2 | 22 | 30 | 0.8699 | -73.8419 | 2020-07-06 04:33:57 | Caqueta, Colombia | ||
2020-07-06 | Colombia | Caqueta | 55 | 2 | 22 | 31 | 0.8699 | -73.8419 | 2020-07-07 04:34:00 | Caqueta, Colombia | ||
2020-07-07 | Colombia | Caqueta | 60 | 2 | 22 | 36 | 0.8699 | -73.8419 | 2020-07-08 05:33:48 | Caqueta, Colombia | ||
2020-07-08 | Colombia | Caqueta | 67 | 2 | 23 | 42 | 0.8699 | -73.8419 | 2020-07-09 04:34:23 | Caqueta, Colombia | ||
2020-07-10 | Colombia | Caqueta | 81 | 2 | 23 | 56 | 0.8699 | -73.8419 | 2020-07-11 04:34:26 | Caqueta, Colombia | ||
2020-07-09 | Colombia | Caqueta | 82 | 2 | 23 | 57 | 0.8699 | -73.8419 | 2020-07-10 04:34:24 | Caqueta, Colombia | ||
2020-07-11 | Colombia | Caqueta | 86 | 3 | 23 | 60 | 0.8699 | -73.8419 | 2020-07-12 04:34:30 | Caqueta, Colombia | ||
2020-07-12 | Colombia | Caqueta | 97 | 3 | 23 | 71 | 0.8699 | -73.8419 | 2020-07-13 04:43:04 | Caqueta, Colombia | ||
2020-07-13 | Colombia | Caqueta | 112 | 3 | 23 | 86 | 0.8699 | -73.8419 | 2020-07-14 04:34:46 | Caqueta, Colombia | ||
2020-07-14 | Colombia | Caqueta | 118 | 3 | 23 | 92 | 0.8699 | -73.8419 | 2020-07-15 04:34:39 | Caqueta, Colombia | ||
2020-07-15 | Colombia | Caqueta | 124 | 3 | 25 | 96 | 0.8699 | -73.8419 | 2020-07-16 04:44:59 | Caqueta, Colombia | ||
2020-07-16 | Colombia | Caqueta | 128 | 3 | 26 | 99 | 0.8699 | -73.8419 | 2020-07-17 04:34:50 | Caqueta, Colombia | ||
2020-07-17 | Colombia | Caqueta | 182 | 4 | 32 | 146 | 0.8699 | -73.8419 | 2020-07-18 04:34:45 | Caqueta, Colombia | ||
2020-07-18 | Colombia | Caqueta | 220 | 4 | 36 | 180 | 0.8699 | -73.8419 | 2020-07-19 04:34:58 | Caqueta, Colombia | ||
2020-07-19 | Colombia | Caqueta | 324 | 5 | 38 | 281 | 0.8699 | -73.8419 | 2020-07-20 05:34:40 | Caqueta, Colombia | ||
2020-07-20 | Colombia | Caqueta | 393 | 7 | 40 | 346 | 0.8699 | -73.8419 | 2020-07-21 04:38:46 | Caqueta, Colombia | ||
2020-07-21 | Colombia | Caqueta | 450 | 7 | 45 | 398 | 0.8699 | -73.8419 | 2020-07-22 04:34:42 | Caqueta, Colombia | ||
2020-07-22 | Colombia | Caqueta | 476 | 7 | 52 | 417 | 0.8699 | -73.8419 | 2020-07-23 05:15:04 | Caqueta, Colombia | ||
2020-07-23 | Colombia | Caqueta | 485 | 8 | 54 | 423 | 0.8699 | -73.8419 | 2020-07-24 05:30:40 | Caqueta, Colombia | ||
2020-07-24 | Colombia | Caqueta | 489 | 8 | 55 | 426 | 0.8699 | -73.8419 | 2020-07-25 04:47:39 | Caqueta, Colombia | ||
2020-07-26 | Colombia | Caqueta | 542 | 8 | 69 | 465 | 0.8699 | -73.8419 | 2020-07-27 04:35:02 | Caqueta, Colombia | ||
2020-07-25 | Colombia | Caqueta | 542 | 8 | 69 | 465 | 0.8699 | -73.8419 | 2020-07-26 04:35:00 | Caqueta, Colombia | ||
2020-07-27 | Colombia | Caqueta | 678 | 12 | 97 | 569 | 0.8699 | -73.8419 | 2020-07-28 04:58:43 | Caqueta, Colombia | ||
2020-07-28 | Colombia | Caqueta | 742 | 15 | 116 | 611 | 0.8699 | -73.8419 | 2020-07-29 04:35:11 | Caqueta, Colombia | ||
2020-07-29 | Colombia | Caqueta | 816 | 16 | 128 | 672 | 0.8699 | -73.8419 | 2020-07-30 04:35:05 | Caqueta, Colombia | ||
2020-07-30 | Colombia | Caqueta | 884 | 18 | 155 | 711 | 0.8699 | -73.8419 | 2020-07-31 04:35:18 | Caqueta, Colombia | ||
2020-07-31 | Colombia | Caqueta | 934 | 21 | 200 | 713 | 0.8699 | -73.8419 | 2020-08-01 04:36:27 | Caqueta, Colombia | ||
2020-08-01 | Colombia | Caqueta | 1116 | 23 | 231 | 862 | 0.8699 | -73.8419 | 2020-08-02 04:34:47 | Caqueta, Colombia | ||
2020-08-02 | Colombia | Caqueta | 1276 | 29 | 248 | 999 | 0.8699 | -73.8419 | 2020-08-03 04:34:35 | Caqueta, Colombia | ||
2020-08-03 | Colombia | Caqueta | 1515 | 33 | 255 | 1227 | 0.8699 | -73.8419 | 2020-08-04 04:41:59 | Caqueta, Colombia | ||
2020-08-04 | Colombia | Caqueta | 1647 | 41 | 359 | 1247 | 0.8699 | -73.8419 | 2020-08-05 04:34:43 | Caqueta, Colombia | ||
2020-08-05 | Colombia | Caqueta | 1839 | 43 | 394 | 1402 | 0.8699 | -73.8419 | 2020-08-06 04:35:02 | Caqueta, Colombia | ||
2020-08-06 | Colombia | Caqueta | 1868 | 47 | 466 | 1355 | 0.8699 | -73.8419 | 2020-08-07 04:35:11 | Caqueta, Colombia | ||
2020-08-07 | Colombia | Caqueta | 2042 | 50 | 492 | 1500 | 0.8699 | -73.8419 | 2020-08-08 04:34:53 | Caqueta, Colombia | ||
2020-08-08 | Colombia | Caqueta | 2141 | 54 | 539 | 1548 | 0.8699 | -73.8419 | 2020-08-09 04:34:54 | Caqueta, Colombia | ||
2020-08-09 | Colombia | Caqueta | 2493 | 59 | 693 | 1741 | 0.8699 | -73.8419 | 2020-08-10 04:34:55 | Caqueta, Colombia | ||
2020-08-10 | Colombia | Caqueta | 2619 | 68 | 762 | 1789 | 0.8699 | -73.8419 | 2020-08-11 04:35:08 | Caqueta, Colombia | ||
2020-08-11 | Colombia | Caqueta | 2794 | 74 | 860 | 1860 | 0.8699 | -73.8419 | 2020-08-12 04:27:29 | Caqueta, Colombia | ||
2020-08-12 | Colombia | Caqueta | 2944 | 82 | 958 | 1904 | 0.8699 | -73.8419 | 2020-08-13 04:29:15 | Caqueta, Colombia | ||
2020-08-13 | Colombia | Caqueta | 3068 | 84 | 1009 | 1975 | 0.8699 | -73.8419 | 2020-08-14 04:51:19 | Caqueta, Colombia | ||
2020-08-14 | Colombia | Caqueta | 3328 | 91 | 1155 | 2082 | 0.8699 | -73.8419 | 2020-08-15 04:27:31 | Caqueta, Colombia | ||
2020-08-15 | Colombia | Caqueta | 3511 | 100 | 1307 | 2104 | 0.8699 | -73.8419 | 2020-08-16 04:27:42 | Caqueta, Colombia | ||
2020-08-16 | Colombia | Caqueta | 3750 | 103 | 1520 | 2127 | 0.8699 | -73.8419 | 2020-08-17 04:27:20 | Caqueta, Colombia | ||
2020-08-17 | Colombia | Caqueta | 3922 | 113 | 1721 | 2088 | 0.8699 | -73.8419 | 2020-08-18 04:27:56 | Caqueta, Colombia | ||
2020-08-18 | Colombia | Caqueta | 4129 | 120 | 1791 | 2218 | 0.8699 | -73.8419 | 2020-08-19 04:27:00 | Caqueta, Colombia | ||
2020-08-19 | Colombia | Caqueta | 4339 | 131 | 2014 | 2194 | 0.8699 | -73.8419 | 2020-08-20 04:27:43 | Caqueta, Colombia | ||
2020-08-20 | Colombia | Caqueta | 4428 | 135 | 2260 | 2033 | 0.8699 | -73.8419 | 2020-08-21 04:27:41 | Caqueta, Colombia | ||
2020-08-21 | Colombia | Caqueta | 4603 | 141 | 2491 | 1971 | 0.8699 | -73.8419 | 2020-08-22 04:27:49 | Caqueta, Colombia | ||
2020-08-22 | Colombia | Caqueta | 4603 | 141 | 2491 | 1971 | 0.8699 | -73.8419 | 2020-08-23 04:27:48 | Caqueta, Colombia | ||
2020-08-23 | Colombia | Caqueta | 4836 | 160 | 2968 | 1708 | 0.8699 | -73.8419 | 2020-08-24 04:27:56 | Caqueta, Colombia | ||
2020-08-24 | Colombia | Caqueta | 5069 | 166 | 3082 | 1821 | 0.8699 | -73.8419 | 2020-08-25 04:28:02 | Caqueta, Colombia | ||
2020-08-25 | Colombia | Caqueta | 5179 | 173 | 3220 | 1786 | 0.8699 | -73.8419 | 2020-08-26 04:28:11 | Caqueta, Colombia | ||
2020-08-26 | Colombia | Caqueta | 5206 | 177 | 3463 | 1566 | 0.8699 | -73.8419 | 2020-08-27 04:28:15 | Caqueta, Colombia | ||
2020-08-27 | Colombia | Caqueta | 5346 | 180 | 3587 | 1579 | 0.8699 | -73.8419 | 2020-08-28 04:28:11 | Caqueta, Colombia | ||
2020-08-28 | Colombia | Caqueta | 5536 | 189 | 3763 | 1584 | 0.8699 | -73.8419 | 2020-08-29 04:28:19 | Caqueta, Colombia | ||
2020-08-29 | Colombia | Caqueta | 5724 | 195 | 3918 | 1611 | 0.8699 | -73.8419 | 2020-08-30 04:28:22 | Caqueta, Colombia | ||
2020-08-30 | Colombia | Caqueta | 5860 | 196 | 3992 | 1672 | 0.8699 | -73.8419 | 2020-08-31 04:28:27 | Caqueta, Colombia | ||
2020-08-31 | Colombia | Caqueta | 6067 | 197 | 4122 | 1748 | 0.8699 | -73.8419 | 2020-09-01 04:28:31 | Caqueta, Colombia | ||
2020-09-01 | Colombia | Caqueta | 6165 | 204 | 4229 | 1732 | 0.8699 | -73.8419 | 2020-09-02 04:28:25 | Caqueta, Colombia | ||
2020-09-02 | Colombia | Caqueta | 6307 | 207 | 4346 | 1754 | 0.8699 | -73.8419 | 2020-09-03 04:28:22 | Caqueta, Colombia | ||
2020-09-03 | Colombia | Caqueta | 6316 | 211 | 4525 | 1580 | 0.8699 | -73.8419 | 2020-09-04 04:28:26 | Caqueta, Colombia | ||
2020-09-04 | Colombia | Caqueta | 6316 | 211 | 4525 | 1580 | 0.8699 | -73.8419 | 2020-09-05 04:28:19 | Caqueta, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;