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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026193 | 1026193 | 2020-10-17 | Colombia | Caqueta | 10154 | 351 | 8840 | 963 | 0.8699 | -73.8419 | 2020-10-18 04:24:25 | Caqueta, Colombia | ||
2856688 | 2856688 | 2020-10-16 | Colombia | Caqueta | 10044 | 348 | 8691 | 1005 | 0.8699 | -73.8419 | 2020-10-17 04:24:12 | Caqueta, Colombia | ||
786218 | 786218 | 2020-10-15 | Colombia | Caqueta | 9942 | 348 | 8691 | 903 | 0.8699 | -73.8419 | 2020-10-16 04:24:01 | Caqueta, Colombia | ||
78929 | 78929 | 2020-10-14 | Colombia | Caqueta | 9901 | 346 | 8543 | 1012 | 0.8699 | -73.8419 | 2020-10-15 04:24:28 | Caqueta, Colombia | ||
3781744 | 3781744 | 2020-10-13 | Colombia | Caqueta | 9892 | 345 | 8482 | 1065 | 0.8699 | -73.8419 | 2020-10-14 04:24:05 | Caqueta, Colombia | ||
2291284 | 2291284 | 2020-10-12 | Colombia | Caqueta | 9870 | 340 | 8427 | 1103 | 0.8699 | -73.8419 | 2020-10-13 04:24:02 | Caqueta, Colombia | ||
3785737 | 3785737 | 2020-10-11 | Colombia | Caqueta | 9649 | 335 | 8006 | 1308 | 0.8699 | -73.8419 | 2020-10-12 04:23:45 | Caqueta, Colombia | ||
2601875 | 2601875 | 2020-10-10 | Colombia | Caqueta | 9559 | 335 | 8006 | 1218 | 0.8699 | -73.8419 | 2020-10-11 04:23:46 | Caqueta, Colombia | ||
817408 | 817408 | 2020-10-09 | Colombia | Caqueta | 9485 | 328 | 7902 | 1255 | 0.8699 | -73.8419 | 2020-10-10 04:23:57 | Caqueta, Colombia | ||
2689523 | 2689523 | 2020-10-08 | Colombia | Caqueta | 9430 | 321 | 7868 | 1241 | 0.8699 | -73.8419 | 2020-10-09 04:23:59 | Caqueta, Colombia | ||
1041665 | 1041665 | 2020-10-07 | Colombia | Caqueta | 9259 | 321 | 7868 | 1070 | 0.8699 | -73.8419 | 2020-10-08 04:23:56 | Caqueta, Colombia | ||
3117326 | 3117326 | 2020-10-06 | Colombia | Caqueta | 9109 | 317 | 7858 | 934 | 0.8699 | -73.8419 | 2020-10-07 04:23:40 | Caqueta, Colombia | ||
3801738 | 3801738 | 2020-10-05 | Colombia | Caqueta | 8946 | 314 | 7842 | 790 | 0.8699 | -73.8419 | 2020-10-06 04:23:33 | Caqueta, Colombia | ||
1822628 | 1822628 | 2020-10-04 | Colombia | Caqueta | 8748 | 311 | 7841 | 596 | 0.8699 | -73.8419 | 2020-10-05 04:23:33 | Caqueta, Colombia | ||
2514012 | 2514012 | 2020-10-03 | Colombia | Caqueta | 8730 | 308 | 7820 | 602 | 0.8699 | -73.8419 | 2020-10-04 04:23:44 | Caqueta, Colombia | ||
3389230 | 3389230 | 2020-10-02 | Colombia | Caqueta | 8598 | 305 | 7744 | 549 | 0.8699 | -73.8419 | 2020-10-03 04:23:40 | Caqueta, Colombia | ||
2379471 | 2379471 | 2020-10-01 | Colombia | Caqueta | 8500 | 304 | 7732 | 464 | 0.8699 | -73.8419 | 2020-10-02 04:23:51 | Caqueta, Colombia | ||
1045657 | 1045657 | 2020-09-30 | Colombia | Caqueta | 8488 | 304 | 7605 | 579 | 0.8699 | -73.8419 | 2020-10-01 04:23:42 | Caqueta, Colombia | ||
966738 | 966738 | 2020-09-29 | Colombia | Caqueta | 8476 | 297 | 7540 | 639 | 0.8699 | -73.8419 | 2020-09-30 04:23:33 | Caqueta, Colombia | ||
1515235 | 1515235 | 2020-09-28 | Colombia | Caqueta | 8457 | 297 | 7352 | 808 | 0.8699 | -73.8419 | 2020-09-29 04:23:42 | Caqueta, Colombia | ||
2581823 | 2581823 | 2020-09-27 | Colombia | Caqueta | 8429 | 296 | 7115 | 1018 | 0.8699 | -73.8419 | 2020-09-28 04:23:00 | Caqueta, Colombia | ||
2613875 | 2613875 | 2020-09-26 | Colombia | Caqueta | 8370 | 289 | 7019 | 1062 | 0.8699 | -73.8419 | 2020-09-27 04:23:00 | Caqueta, Colombia | ||
2812590 | 2812590 | 2020-09-25 | Colombia | Caqueta | 8202 | 284 | 6957 | 961 | 0.8699 | -73.8419 | 2020-09-26 04:23:00 | Caqueta, Colombia | ||
2605867 | 2605867 | 2020-09-24 | Colombia | Caqueta | 8036 | 282 | 6889 | 865 | 0.8699 | -73.8419 | 2020-09-25 04:23:00 | Caqueta, Colombia | ||
2653610 | 2653610 | 2020-09-23 | Colombia | Caqueta | 7843 | 282 | 6799 | 762 | 0.8699 | -73.8419 | 2020-09-24 04:23:00 | Caqueta, Colombia | ||
3316059 | 3316059 | 2020-09-22 | Colombia | Caqueta | 7793 | 277 | 6718 | 798 | 0.8699 | -73.8419 | 2020-09-23 04:23:00 | Caqueta, Colombia | ||
2836658 | 2836658 | 2020-09-21 | Colombia | Caqueta | 7789 | 277 | 6718 | 794 | 0.8699 | -73.8419 | 2020-09-22 04:23:00 | Caqueta, Colombia | ||
3093263 | 3093263 | 2020-09-20 | Colombia | Caqueta | 7783 | 274 | 6679 | 830 | 0.8699 | -73.8419 | 2020-09-21 04:23:00 | Caqueta, Colombia | ||
2454613 | 2454613 | 2020-09-19 | Colombia | Caqueta | 7759 | 274 | 6504 | 981 | 0.8699 | -73.8419 | 2020-09-20 04:22:00 | Caqueta, Colombia | ||
2848682 | 2848682 | 2020-09-18 | Colombia | Caqueta | 7536 | 269 | 6438 | 829 | 0.8699 | -73.8419 | 2020-09-19 04:22:00 | Caqueta, Colombia | ||
1121431 | 1121431 | 2020-09-17 | Colombia | Caqueta | 7387 | 269 | 6438 | 680 | 0.8699 | -73.8419 | 2020-09-18 05:05:00 | Caqueta, Colombia | ||
666120 | 666120 | 2020-09-16 | Colombia | Caqueta | 7357 | 268 | 6413 | 676 | 0.8699 | -73.8419 | 2020-09-17 04:22:00 | Caqueta, Colombia | ||
2728845 | 2728845 | 2020-09-15 | Colombia | Caqueta | 7346 | 265 | 6389 | 692 | 0.8699 | -73.8419 | 2020-09-16 04:22:53 | Caqueta, Colombia | ||
344117 | 344117 | 2020-09-14 | Colombia | Caqueta | 7319 | 262 | 6384 | 673 | 0.8699 | -73.8419 | 2020-09-15 03:22:50 | Caqueta, Colombia | ||
2868556 | 2868556 | 2020-09-13 | Colombia | Caqueta | 7308 | 258 | 6270 | 780 | 0.8699 | -73.8419 | 2020-09-14 04:26:00 | Caqueta, Colombia | ||
546595 | 546595 | 2020-09-12 | Colombia | Caqueta | 7249 | 256 | 6218 | 775 | 0.8699 | -73.8419 | 2020-09-13 04:30:52 | Caqueta, Colombia | ||
1444424 | 1444424 | 2020-09-11 | Colombia | Caqueta | 7239 | 249 | 6161 | 829 | 0.8699 | -73.8419 | 2020-09-12 04:25:05 | Caqueta, Colombia | ||
1173025 | 1173025 | 2020-09-10 | Colombia | Caqueta | 7179 | 245 | 6048 | 886 | 0.8699 | -73.8419 | 2020-09-11 04:46:23 | Caqueta, Colombia | ||
2171390 | 2171390 | 2020-09-09 | Colombia | Caqueta | 7113 | 240 | 5915 | 958 | 0.8699 | -73.8419 | 2020-09-10 04:29:01 | Caqueta, Colombia | ||
1243599 | 1243599 | 2020-09-08 | Colombia | Caqueta | 6897 | 228 | 5417 | 1252 | 0.8699 | -73.8419 | 2020-09-09 04:28:48 | Caqueta, Colombia | ||
427178 | 427178 | 2020-09-07 | Colombia | Caqueta | 6789 | 223 | 5215 | 1351 | 0.8699 | -73.8419 | 2020-09-08 04:28:25 | Caqueta, Colombia | ||
3161463 | 3161463 | 2020-09-06 | Colombia | Caqueta | 6789 | 223 | 5215 | 1351 | 0.8699 | -73.8419 | 2020-09-07 04:28:30 | Caqueta, Colombia | ||
813418 | 813418 | 2020-09-05 | Colombia | Caqueta | 6521 | 215 | 4930 | 1376 | 0.8699 | -73.8419 | 2020-09-06 04:28:33 | 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 | ||
1354158 | 1354158 | 2020-09-03 | Colombia | Caqueta | 6316 | 211 | 4525 | 1580 | 0.8699 | -73.8419 | 2020-09-04 04:28:26 | 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 | ||
2059724 | 2059724 | 2020-09-01 | Colombia | Caqueta | 6165 | 204 | 4229 | 1732 | 0.8699 | -73.8419 | 2020-09-02 04:28:25 | 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 | ||
3931868 | 3931868 | 2020-08-30 | Colombia | Caqueta | 5860 | 196 | 3992 | 1672 | 0.8699 | -73.8419 | 2020-08-31 04:28:27 | 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 | ||
1523025 | 1523025 | 2020-08-28 | Colombia | Caqueta | 5536 | 189 | 3763 | 1584 | 0.8699 | -73.8419 | 2020-08-29 04:28:19 | 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 | ||
1996486 | 1996486 | 2020-08-26 | Colombia | Caqueta | 5206 | 177 | 3463 | 1566 | 0.8699 | -73.8419 | 2020-08-27 04:28:15 | 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 | ||
2991114 | 2991114 | 2020-08-24 | Colombia | Caqueta | 5069 | 166 | 3082 | 1821 | 0.8699 | -73.8419 | 2020-08-25 04:28:02 | 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 | ||
2299291 | 2299291 | 2020-08-22 | Colombia | Caqueta | 4603 | 141 | 2491 | 1971 | 0.8699 | -73.8419 | 2020-08-23 04:27:48 | 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 | ||
3484147 | 3484147 | 2020-08-20 | Colombia | Caqueta | 4428 | 135 | 2260 | 2033 | 0.8699 | -73.8419 | 2020-08-21 04:27:41 | 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 | ||
3177850 | 3177850 | 2020-08-18 | Colombia | Caqueta | 4129 | 120 | 1791 | 2218 | 0.8699 | -73.8419 | 2020-08-19 04:27:00 | 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 | ||
1555812 | 1555812 | 2020-08-16 | Colombia | Caqueta | 3750 | 103 | 1520 | 2127 | 0.8699 | -73.8419 | 2020-08-17 04:27:20 | 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 | ||
1612089 | 1612089 | 2020-08-14 | Colombia | Caqueta | 3328 | 91 | 1155 | 2082 | 0.8699 | -73.8419 | 2020-08-15 04:27:31 | 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 | ||
3531292 | 3531292 | 2020-08-12 | Colombia | Caqueta | 2944 | 82 | 958 | 1904 | 0.8699 | -73.8419 | 2020-08-13 04:29:15 | 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 | ||
1920236 | 1920236 | 2020-08-10 | Colombia | Caqueta | 2619 | 68 | 762 | 1789 | 0.8699 | -73.8419 | 2020-08-11 04:35:08 | 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 | ||
371213 | 371213 | 2020-08-08 | Colombia | Caqueta | 2141 | 54 | 539 | 1548 | 0.8699 | -73.8419 | 2020-08-09 04:34:54 | 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 | ||
3612082 | 3612082 | 2020-08-06 | Colombia | Caqueta | 1868 | 47 | 466 | 1355 | 0.8699 | -73.8419 | 2020-08-07 04:35:11 | 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 | ||
98148 | 98148 | 2020-08-04 | Colombia | Caqueta | 1647 | 41 | 359 | 1247 | 0.8699 | -73.8419 | 2020-08-05 04:34:43 | 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 | ||
2807783 | 2807783 | 2020-08-02 | Colombia | Caqueta | 1276 | 29 | 248 | 999 | 0.8699 | -73.8419 | 2020-08-03 04:34:35 | 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 | ||
3264516 | 3264516 | 2020-07-31 | Colombia | Caqueta | 934 | 21 | 200 | 713 | 0.8699 | -73.8419 | 2020-08-01 04:36:27 | 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 | ||
2958391 | 2958391 | 2020-07-29 | Colombia | Caqueta | 816 | 16 | 128 | 672 | 0.8699 | -73.8419 | 2020-07-30 04:35:05 | 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 | ||
177059 | 177059 | 2020-07-27 | Colombia | Caqueta | 678 | 12 | 97 | 569 | 0.8699 | -73.8419 | 2020-07-28 04:58:43 | 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 | ||
1502616 | 1502616 | 2020-07-25 | Colombia | Caqueta | 542 | 8 | 69 | 465 | 0.8699 | -73.8419 | 2020-07-26 04:35:00 | 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 | ||
61814 | 61814 | 2020-07-23 | Colombia | Caqueta | 485 | 8 | 54 | 423 | 0.8699 | -73.8419 | 2020-07-24 05:30:40 | 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 | ||
1707345 | 1707345 | 2020-07-21 | Colombia | Caqueta | 450 | 7 | 45 | 398 | 0.8699 | -73.8419 | 2020-07-22 04:34:42 | 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 | ||
121741 | 121741 | 2020-07-19 | Colombia | Caqueta | 324 | 5 | 38 | 281 | 0.8699 | -73.8419 | 2020-07-20 05:34:40 | 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 | ||
2708432 | 2708432 | 2020-07-17 | Colombia | Caqueta | 182 | 4 | 32 | 146 | 0.8699 | -73.8419 | 2020-07-18 04:34:45 | 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 | ||
2747919 | 2747919 | 2020-07-15 | Colombia | Caqueta | 124 | 3 | 25 | 96 | 0.8699 | -73.8419 | 2020-07-16 04:44:59 | 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 | ||
3491204 | 3491204 | 2020-07-13 | Colombia | Caqueta | 112 | 3 | 23 | 86 | 0.8699 | -73.8419 | 2020-07-14 04:34:46 | 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 | ||
3435861 | 3435861 | 2020-07-11 | Colombia | Caqueta | 86 | 3 | 23 | 60 | 0.8699 | -73.8419 | 2020-07-12 04:34:30 | 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 |
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]);