johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Caqueta" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2712160 | 2712160 | 2020-05-28 | Colombia | Caqueta | 24 | 1 | 7 | 16 | 0.8699 | -73.8419 | 2020-05-29 02:32:50 | Caqueta, Colombia | ||
1790280 | 1790280 | 2020-05-29 | Colombia | Caqueta | 24 | 1 | 7 | 16 | 0.8699 | -73.8419 | 2020-05-30 02:32:48 | Caqueta, Colombia | ||
3638739 | 3638739 | 2020-05-30 | Colombia | Caqueta | 24 | 1 | 7 | 16 | 0.8699 | -73.8419 | 2020-05-31 02:32:45 | Caqueta, Colombia | ||
1793846 | 1793846 | 2020-05-31 | Colombia | Caqueta | 24 | 1 | 7 | 16 | 0.8699 | -73.8419 | 2020-06-01 02:32:46 | Caqueta, Colombia | ||
805211 | 805211 | 2020-06-01 | Colombia | Caqueta | 24 | 1 | 13 | 10 | 0.8699 | -73.8419 | 2020-06-02 02:33:08 | Caqueta, Colombia | ||
2555675 | 2555675 | 2020-06-02 | Colombia | Caqueta | 24 | 1 | 16 | 7 | 0.8699 | -73.8419 | 2020-06-03 02:33:13 | Caqueta, Colombia | ||
3866632 | 3866632 | 2020-06-03 | Colombia | Caqueta | 24 | 2 | 18 | 4 | 0.8699 | -73.8419 | 2020-06-04 02:33:14 | Caqueta, Colombia | ||
1281077 | 1281077 | 2020-06-04 | Colombia | Caqueta | 24 | 2 | 18 | 4 | 0.8699 | -73.8419 | 2020-06-05 02:33:06 | Caqueta, Colombia | ||
1269597 | 1269597 | 2020-06-05 | Colombia | Caqueta | 24 | 2 | 19 | 3 | 0.8699 | -73.8419 | 2020-06-06 02:33:00 | Caqueta, Colombia | ||
573900 | 573900 | 2020-06-06 | Colombia | Caqueta | 24 | 2 | 19 | 3 | 0.8699 | -73.8419 | 2020-06-07 03:53:30 | Caqueta, Colombia | ||
2799844 | 2799844 | 2020-06-07 | Colombia | Caqueta | 23 | 1 | 20 | 2 | 0.8699 | -73.8419 | 2020-06-08 03:33:22 | Caqueta, Colombia | ||
217047 | 217047 | 2020-06-08 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-09 03:33:03 | Caqueta, Colombia | ||
1210620 | 1210620 | 2020-06-09 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-10 04:07:00 | Caqueta, Colombia | ||
2863767 | 2863767 | 2020-06-10 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-11 03:33:41 | Caqueta, Colombia | ||
1273323 | 1273323 | 2020-06-11 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-12 05:09:52 | Caqueta, Colombia | ||
737353 | 737353 | 2020-06-12 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-13 03:33:14 | Caqueta, Colombia | ||
3061033 | 3061033 | 2020-06-13 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-14 03:33:15 | Caqueta, Colombia | ||
1836981 | 1836981 | 2020-06-14 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-15 03:33:14 | Caqueta, Colombia | ||
287030 | 287030 | 2020-06-15 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-16 04:33:09 | Caqueta, Colombia | ||
2386467 | 2386467 | 2020-06-16 | Colombia | Caqueta | 25 | 2 | 21 | 2 | 0.8699 | -73.8419 | 2020-06-17 04:33:21 | Caqueta, Colombia | ||
1195704 | 1195704 | 2020-06-17 | Colombia | Caqueta | 28 | 2 | 21 | 5 | 0.8699 | -73.8419 | 2020-06-18 04:33:18 | Caqueta, Colombia | ||
3682501 | 3682501 | 2020-06-18 | Colombia | Caqueta | 28 | 2 | 21 | 5 | 0.8699 | -73.8419 | 2020-06-19 04:33:17 | Caqueta, Colombia | ||
1691352 | 1691352 | 2020-06-19 | Colombia | Caqueta | 29 | 2 | 21 | 6 | 0.8699 | -73.8419 | 2020-06-20 04:33:19 | Caqueta, Colombia | ||
2437774 | 2437774 | 2020-06-20 | Colombia | Caqueta | 29 | 2 | 22 | 5 | 0.8699 | -73.8419 | 2020-06-21 04:33:19 | Caqueta, Colombia | ||
3249181 | 3249181 | 2020-06-21 | Colombia | Caqueta | 30 | 2 | 22 | 6 | 0.8699 | -73.8419 | 2020-06-22 04:33:20 | Caqueta, Colombia | ||
1510442 | 1510442 | 2020-06-22 | Colombia | Caqueta | 30 | 2 | 22 | 6 | 0.8699 | -73.8419 | 2020-06-23 04:33:22 | Caqueta, Colombia | ||
1522248 | 1522248 | 2020-06-23 | Colombia | Caqueta | 29 | 2 | 22 | 5 | 0.8699 | -73.8419 | 2020-06-24 04:33:28 | Caqueta, Colombia | ||
2700563 | 2700563 | 2020-06-24 | Colombia | Caqueta | 29 | 2 | 22 | 5 | 0.8699 | -73.8419 | 2020-06-25 05:26:54 | Caqueta, Colombia | ||
2624923 | 2624923 | 2020-06-25 | Colombia | Caqueta | 29 | 2 | 22 | 5 | 0.8699 | -73.8419 | 2020-06-26 04:33:43 | 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 | ||
2039655 | 2039655 | 2020-06-27 | Colombia | Caqueta | 26 | 2 | 22 | 2 | 0.8699 | -73.8419 | 2020-06-28 04:34:04 | Caqueta, Colombia | ||
2306320 | 2306320 | 2020-06-28 | Colombia | Caqueta | 35 | 2 | 22 | 11 | 0.8699 | -73.8419 | 2020-06-29 04:33:44 | Caqueta, Colombia | ||
2632757 | 2632757 | 2020-06-29 | Colombia | Caqueta | 35 | 2 | 22 | 11 | 0.8699 | -73.8419 | 2020-06-30 04:33:48 | Caqueta, Colombia | ||
2974280 | 2974280 | 2020-06-30 | Colombia | Caqueta | 35 | 2 | 22 | 11 | 0.8699 | -73.8419 | 2020-07-01 04:33:52 | Caqueta, Colombia | ||
302902 | 302902 | 2020-07-01 | Colombia | Caqueta | 35 | 2 | 22 | 11 | 0.8699 | -73.8419 | 2020-07-02 04:33:46 | Caqueta, Colombia | ||
3045211 | 3045211 | 2020-07-02 | Colombia | Caqueta | 39 | 2 | 22 | 15 | 0.8699 | -73.8419 | 2020-07-03 04:33:54 | Caqueta, Colombia | ||
2234417 | 2234417 | 2020-07-03 | Colombia | Caqueta | 43 | 2 | 22 | 19 | 0.8699 | -73.8419 | 2020-07-04 04:33:51 | Caqueta, Colombia | ||
529756 | 529756 | 2020-07-04 | Colombia | Caqueta | 43 | 2 | 22 | 19 | 0.8699 | -73.8419 | 2020-07-05 04:33:46 | Caqueta, Colombia | ||
415194 | 415194 | 2020-07-05 | Colombia | Caqueta | 54 | 2 | 22 | 30 | 0.8699 | -73.8419 | 2020-07-06 04:33:57 | Caqueta, Colombia | ||
2684729 | 2684729 | 2020-07-06 | Colombia | Caqueta | 55 | 2 | 22 | 31 | 0.8699 | -73.8419 | 2020-07-07 04:34:00 | Caqueta, Colombia | ||
887169 | 887169 | 2020-07-07 | Colombia | Caqueta | 60 | 2 | 22 | 36 | 0.8699 | -73.8419 | 2020-07-08 05:33:48 | Caqueta, Colombia | ||
2222560 | 2222560 | 2020-07-08 | Colombia | Caqueta | 67 | 2 | 23 | 42 | 0.8699 | -73.8419 | 2020-07-09 04:34:23 | Caqueta, Colombia | ||
1005344 | 1005344 | 2020-07-09 | Colombia | Caqueta | 82 | 2 | 23 | 57 | 0.8699 | -73.8419 | 2020-07-10 04:34:24 | Caqueta, Colombia | ||
3237359 | 3237359 | 2020-07-10 | Colombia | Caqueta | 81 | 2 | 23 | 56 | 0.8699 | -73.8419 | 2020-07-11 04:34:26 | Caqueta, Colombia | ||
3435861 | 3435861 | 2020-07-11 | Colombia | Caqueta | 86 | 3 | 23 | 60 | 0.8699 | -73.8419 | 2020-07-12 04:34:30 | Caqueta, Colombia | ||
3737466 | 3737466 | 2020-07-12 | Colombia | Caqueta | 97 | 3 | 23 | 71 | 0.8699 | -73.8419 | 2020-07-13 04:43:04 | Caqueta, Colombia | ||
3491204 | 3491204 | 2020-07-13 | Colombia | Caqueta | 112 | 3 | 23 | 86 | 0.8699 | -73.8419 | 2020-07-14 04:34:46 | Caqueta, Colombia | ||
2158563 | 2158563 | 2020-07-14 | Colombia | Caqueta | 118 | 3 | 23 | 92 | 0.8699 | -73.8419 | 2020-07-15 04:34:39 | Caqueta, Colombia | ||
2747919 | 2747919 | 2020-07-15 | Colombia | Caqueta | 124 | 3 | 25 | 96 | 0.8699 | -73.8419 | 2020-07-16 04:44:59 | Caqueta, Colombia | ||
367251 | 367251 | 2020-07-16 | Colombia | Caqueta | 128 | 3 | 26 | 99 | 0.8699 | -73.8419 | 2020-07-17 04:34:50 | Caqueta, Colombia | ||
2708432 | 2708432 | 2020-07-17 | Colombia | Caqueta | 182 | 4 | 32 | 146 | 0.8699 | -73.8419 | 2020-07-18 04:34:45 | Caqueta, Colombia | ||
3205130 | 3205130 | 2020-07-18 | Colombia | Caqueta | 220 | 4 | 36 | 180 | 0.8699 | -73.8419 | 2020-07-19 04:34:58 | Caqueta, Colombia | ||
121741 | 121741 | 2020-07-19 | Colombia | Caqueta | 324 | 5 | 38 | 281 | 0.8699 | -73.8419 | 2020-07-20 05:34:40 | Caqueta, Colombia | ||
326836 | 326836 | 2020-07-20 | Colombia | Caqueta | 393 | 7 | 40 | 346 | 0.8699 | -73.8419 | 2020-07-21 04:38:46 | Caqueta, Colombia | ||
1707345 | 1707345 | 2020-07-21 | Colombia | Caqueta | 450 | 7 | 45 | 398 | 0.8699 | -73.8419 | 2020-07-22 04:34:42 | Caqueta, Colombia | ||
844606 | 844606 | 2020-07-22 | Colombia | Caqueta | 476 | 7 | 52 | 417 | 0.8699 | -73.8419 | 2020-07-23 05:15:04 | Caqueta, Colombia | ||
61814 | 61814 | 2020-07-23 | Colombia | Caqueta | 485 | 8 | 54 | 423 | 0.8699 | -73.8419 | 2020-07-24 05:30:40 | Caqueta, Colombia | ||
2563586 | 2563586 | 2020-07-24 | Colombia | Caqueta | 489 | 8 | 55 | 426 | 0.8699 | -73.8419 | 2020-07-25 04:47:39 | Caqueta, Colombia | ||
1502616 | 1502616 | 2020-07-25 | Colombia | Caqueta | 542 | 8 | 69 | 465 | 0.8699 | -73.8419 | 2020-07-26 04:35:00 | Caqueta, Colombia | ||
442372 | 442372 | 2020-07-26 | Colombia | Caqueta | 542 | 8 | 69 | 465 | 0.8699 | -73.8419 | 2020-07-27 04:35:02 | Caqueta, Colombia | ||
177059 | 177059 | 2020-07-27 | Colombia | Caqueta | 678 | 12 | 97 | 569 | 0.8699 | -73.8419 | 2020-07-28 04:58:43 | Caqueta, Colombia | ||
3185007 | 3185007 | 2020-07-28 | Colombia | Caqueta | 742 | 15 | 116 | 611 | 0.8699 | -73.8419 | 2020-07-29 04:35:11 | Caqueta, Colombia | ||
2958391 | 2958391 | 2020-07-29 | Colombia | Caqueta | 816 | 16 | 128 | 672 | 0.8699 | -73.8419 | 2020-07-30 04:35:05 | Caqueta, Colombia | ||
1928223 | 1928223 | 2020-07-30 | Colombia | Caqueta | 884 | 18 | 155 | 711 | 0.8699 | -73.8419 | 2020-07-31 04:35:18 | Caqueta, Colombia | ||
3264516 | 3264516 | 2020-07-31 | Colombia | Caqueta | 934 | 21 | 200 | 713 | 0.8699 | -73.8419 | 2020-08-01 04:36:27 | Caqueta, Colombia | ||
753351 | 753351 | 2020-08-01 | Colombia | Caqueta | 1116 | 23 | 231 | 862 | 0.8699 | -73.8419 | 2020-08-02 04:34:47 | Caqueta, Colombia | ||
2807783 | 2807783 | 2020-08-02 | Colombia | Caqueta | 1276 | 29 | 248 | 999 | 0.8699 | -73.8419 | 2020-08-03 04:34:35 | Caqueta, Colombia | ||
2740031 | 2740031 | 2020-08-03 | Colombia | Caqueta | 1515 | 33 | 255 | 1227 | 0.8699 | -73.8419 | 2020-08-04 04:41:59 | Caqueta, Colombia | ||
98148 | 98148 | 2020-08-04 | Colombia | Caqueta | 1647 | 41 | 359 | 1247 | 0.8699 | -73.8419 | 2020-08-05 04:34:43 | Caqueta, Colombia | ||
3792912 | 3792912 | 2020-08-05 | Colombia | Caqueta | 1839 | 43 | 394 | 1402 | 0.8699 | -73.8419 | 2020-08-06 04:35:02 | Caqueta, Colombia | ||
3612082 | 3612082 | 2020-08-06 | Colombia | Caqueta | 1868 | 47 | 466 | 1355 | 0.8699 | -73.8419 | 2020-08-07 04:35:11 | Caqueta, Colombia | ||
458397 | 458397 | 2020-08-07 | Colombia | Caqueta | 2042 | 50 | 492 | 1500 | 0.8699 | -73.8419 | 2020-08-08 04:34:53 | Caqueta, Colombia | ||
371213 | 371213 | 2020-08-08 | Colombia | Caqueta | 2141 | 54 | 539 | 1548 | 0.8699 | -73.8419 | 2020-08-09 04:34:54 | Caqueta, Colombia | ||
3923045 | 3923045 | 2020-08-09 | Colombia | Caqueta | 2493 | 59 | 693 | 1741 | 0.8699 | -73.8419 | 2020-08-10 04:34:55 | Caqueta, Colombia | ||
1920236 | 1920236 | 2020-08-10 | Colombia | Caqueta | 2619 | 68 | 762 | 1789 | 0.8699 | -73.8419 | 2020-08-11 04:35:08 | Caqueta, Colombia | ||
662141 | 662141 | 2020-08-11 | Colombia | Caqueta | 2794 | 74 | 860 | 1860 | 0.8699 | -73.8419 | 2020-08-12 04:27:29 | Caqueta, Colombia | ||
3531292 | 3531292 | 2020-08-12 | Colombia | Caqueta | 2944 | 82 | 958 | 1904 | 0.8699 | -73.8419 | 2020-08-13 04:29:15 | Caqueta, Colombia | ||
582673 | 582673 | 2020-08-13 | Colombia | Caqueta | 3068 | 84 | 1009 | 1975 | 0.8699 | -73.8419 | 2020-08-14 04:51:19 | Caqueta, Colombia | ||
1612089 | 1612089 | 2020-08-14 | Colombia | Caqueta | 3328 | 91 | 1155 | 2082 | 0.8699 | -73.8419 | 2020-08-15 04:27:31 | Caqueta, Colombia | ||
145814 | 145814 | 2020-08-15 | Colombia | Caqueta | 3511 | 100 | 1307 | 2104 | 0.8699 | -73.8419 | 2020-08-16 04:27:42 | Caqueta, Colombia | ||
1555812 | 1555812 | 2020-08-16 | Colombia | Caqueta | 3750 | 103 | 1520 | 2127 | 0.8699 | -73.8419 | 2020-08-17 04:27:20 | Caqueta, Colombia | ||
837454 | 837454 | 2020-08-17 | Colombia | Caqueta | 3922 | 113 | 1721 | 2088 | 0.8699 | -73.8419 | 2020-08-18 04:27:56 | Caqueta, Colombia | ||
3177850 | 3177850 | 2020-08-18 | Colombia | Caqueta | 4129 | 120 | 1791 | 2218 | 0.8699 | -73.8419 | 2020-08-19 04:27:00 | Caqueta, Colombia | ||
206096 | 206096 | 2020-08-19 | Colombia | Caqueta | 4339 | 131 | 2014 | 2194 | 0.8699 | -73.8419 | 2020-08-20 04:27:43 | Caqueta, Colombia | ||
3484147 | 3484147 | 2020-08-20 | Colombia | Caqueta | 4428 | 135 | 2260 | 2033 | 0.8699 | -73.8419 | 2020-08-21 04:27:41 | Caqueta, Colombia | ||
1479398 | 1479398 | 2020-08-21 | Colombia | Caqueta | 4603 | 141 | 2491 | 1971 | 0.8699 | -73.8419 | 2020-08-22 04:27:49 | Caqueta, Colombia | ||
2299291 | 2299291 | 2020-08-22 | Colombia | Caqueta | 4603 | 141 | 2491 | 1971 | 0.8699 | -73.8419 | 2020-08-23 04:27:48 | Caqueta, Colombia | ||
2215509 | 2215509 | 2020-08-23 | Colombia | Caqueta | 4836 | 160 | 2968 | 1708 | 0.8699 | -73.8419 | 2020-08-24 04:27:56 | Caqueta, Colombia | ||
2991114 | 2991114 | 2020-08-24 | Colombia | Caqueta | 5069 | 166 | 3082 | 1821 | 0.8699 | -73.8419 | 2020-08-25 04:28:02 | Caqueta, Colombia | ||
3562410 | 3562410 | 2020-08-25 | Colombia | Caqueta | 5179 | 173 | 3220 | 1786 | 0.8699 | -73.8419 | 2020-08-26 04:28:11 | Caqueta, Colombia | ||
1996486 | 1996486 | 2020-08-26 | Colombia | Caqueta | 5206 | 177 | 3463 | 1566 | 0.8699 | -73.8419 | 2020-08-27 04:28:15 | Caqueta, Colombia | ||
2510026 | 2510026 | 2020-08-27 | Colombia | Caqueta | 5346 | 180 | 3587 | 1579 | 0.8699 | -73.8419 | 2020-08-28 04:28:11 | Caqueta, Colombia | ||
1523025 | 1523025 | 2020-08-28 | Colombia | Caqueta | 5536 | 189 | 3763 | 1584 | 0.8699 | -73.8419 | 2020-08-29 04:28:19 | Caqueta, Colombia | ||
609530 | 609530 | 2020-08-29 | Colombia | Caqueta | 5724 | 195 | 3918 | 1611 | 0.8699 | -73.8419 | 2020-08-30 04:28:22 | Caqueta, Colombia | ||
3931868 | 3931868 | 2020-08-30 | Colombia | Caqueta | 5860 | 196 | 3992 | 1672 | 0.8699 | -73.8419 | 2020-08-31 04:28:27 | Caqueta, Colombia | ||
193909 | 193909 | 2020-08-31 | Colombia | Caqueta | 6067 | 197 | 4122 | 1748 | 0.8699 | -73.8419 | 2020-09-01 04:28:31 | Caqueta, Colombia | ||
2059724 | 2059724 | 2020-09-01 | Colombia | Caqueta | 6165 | 204 | 4229 | 1732 | 0.8699 | -73.8419 | 2020-09-02 04:28:25 | Caqueta, Colombia | ||
1105395 | 1105395 | 2020-09-02 | Colombia | Caqueta | 6307 | 207 | 4346 | 1754 | 0.8699 | -73.8419 | 2020-09-03 04:28:22 | Caqueta, Colombia | ||
1354158 | 1354158 | 2020-09-03 | Colombia | Caqueta | 6316 | 211 | 4525 | 1580 | 0.8699 | -73.8419 | 2020-09-04 04:28:26 | Caqueta, Colombia | ||
2661618 | 2661618 | 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 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]);