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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462632 | 2462632 | 2021-09-14 | Colombia | Caqueta | 22771 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-15 03:22:37 | Caqueta, Colombia | |||
1385471 | 1385471 | 2021-09-13 | Colombia | Caqueta | 22769 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-14 04:21:41 | Caqueta, Colombia | |||
1884840 | 1884840 | 2021-09-12 | Colombia | Caqueta | 22765 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-13 04:21:15 | Caqueta, Colombia | |||
3805743 | 3805743 | 2021-09-11 | Colombia | Caqueta | 22761 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-12 04:21:13 | Caqueta, Colombia | |||
3448683 | 3448683 | 2021-09-10 | Colombia | Caqueta | 22760 | 928 | 0 | 0.8699 | -73.8419 | 2021-09-11 04:21:30 | Caqueta, Colombia | |||
1262629 | 1262629 | 2021-09-09 | Colombia | Caqueta | 22753 | 927 | 0 | 0.8699 | -73.8419 | 2021-09-10 04:21:20 | Caqueta, Colombia | |||
2278999 | 2278999 | 2021-09-08 | Colombia | Caqueta | 22736 | 927 | 0 | 0.8699 | -73.8419 | 2021-09-09 04:21:27 | Caqueta, Colombia | |||
641778 | 641778 | 2021-09-07 | Colombia | Caqueta | 22732 | 926 | 0 | 0.8699 | -73.8419 | 2021-09-08 04:21:31 | Caqueta, Colombia | |||
3193841 | 3193841 | 2021-09-06 | Colombia | Caqueta | 22731 | 925 | 0 | 0.8699 | -73.8419 | 2021-09-07 04:21:35 | Caqueta, Colombia | |||
3280709 | 3280709 | 2021-09-05 | Colombia | Caqueta | 22724 | 925 | 0 | 0.8699 | -73.8419 | 2021-09-06 04:21:22 | Caqueta, Colombia | |||
249123 | 249123 | 2021-09-04 | Colombia | Caqueta | 22718 | 923 | 0 | 0.8699 | -73.8419 | 2021-09-05 04:21:33 | Caqueta, Colombia | |||
3974404 | 3974404 | 2021-09-03 | Colombia | Caqueta | 22710 | 923 | 0 | 0.8699 | -73.8419 | 2021-09-04 04:21:28 | Caqueta, Colombia | |||
177866 | 177866 | 2021-09-02 | Colombia | Caqueta | 22701 | 923 | 0 | 0.8699 | -73.8419 | 2021-09-03 04:21:20 | Caqueta, Colombia | |||
66901 | 66901 | 2021-09-01 | Colombia | Caqueta | 22695 | 923 | 0 | 0.8699 | -73.8419 | 2021-09-02 04:21:15 | Caqueta, Colombia | |||
2067743 | 2067743 | 2021-08-31 | Colombia | Caqueta | 22687 | 922 | 0 | 0.8699 | -73.8419 | 2021-09-01 04:21:38 | Caqueta, Colombia | |||
1775197 | 1775197 | 2021-08-30 | Colombia | Caqueta | 22687 | 922 | 0 | 0.8699 | -73.8419 | 2021-08-31 04:21:46 | Caqueta, Colombia | |||
3891771 | 3891771 | 2021-08-29 | Colombia | Caqueta | 22671 | 920 | 0 | 0.8699 | -73.8419 | 2021-08-30 04:21:23 | Caqueta, Colombia | |||
2792874 | 2792874 | 2021-08-28 | Colombia | Caqueta | 22666 | 918 | 0 | 0.8699 | -73.8419 | 2021-08-29 04:21:14 | Caqueta, Colombia | |||
2923033 | 2923033 | 2021-08-27 | Colombia | Caqueta | 22660 | 915 | 0 | 0.8699 | -73.8419 | 2021-08-28 04:21:28 | Caqueta, Colombia | |||
1596047 | 1596047 | 2021-08-26 | Colombia | Caqueta | 22659 | 913 | 0 | 0.8699 | -73.8419 | 2021-08-27 04:21:37 | Caqueta, Colombia | |||
32256 | 32256 | 2021-08-25 | Colombia | Caqueta | 22639 | 912 | 0 | 0.8699 | -73.8419 | 2021-08-26 04:21:28 | Caqueta, Colombia | |||
3105295 | 3105295 | 2021-08-24 | Colombia | Caqueta | 22639 | 911 | 0 | 0.8699 | -73.8419 | 2021-08-25 04:21:41 | Caqueta, Colombia | |||
3165466 | 3165466 | 2021-08-23 | Colombia | Caqueta | 22630 | 911 | 0 | 0.8699 | -73.8419 | 2021-08-24 04:21:19 | Caqueta, Colombia | |||
2175393 | 2175393 | 2021-08-22 | Colombia | Caqueta | 22606 | 909 | 0 | 0.8699 | -73.8419 | 2021-08-23 04:21:27 | Caqueta, Colombia | |||
3555489 | 3555489 | 2021-08-21 | Colombia | Caqueta | 22585 | 906 | 0 | 0.8699 | -73.8419 | 2021-08-22 04:21:29 | Caqueta, Colombia | |||
1853831 | 1853831 | 2021-08-20 | Colombia | Caqueta | 22570 | 906 | 0 | 0.8699 | -73.8419 | 2021-08-21 04:21:38 | Caqueta, Colombia | |||
511538 | 511538 | 2021-08-19 | Colombia | Caqueta | 22546 | 905 | 0 | 0.8699 | -73.8419 | 2021-08-20 04:21:33 | Caqueta, Colombia | |||
2518017 | 2518017 | 2021-08-18 | Colombia | Caqueta | 22538 | 903 | 0 | 0.8699 | -73.8419 | 2021-08-19 04:21:15 | Caqueta, Colombia | |||
245109 | 245109 | 2021-08-17 | Colombia | Caqueta | 22531 | 901 | 0 | 0.8699 | -73.8419 | 2021-08-18 04:21:35 | Caqueta, Colombia | |||
1604072 | 1604072 | 2021-08-16 | Colombia | Caqueta | 22525 | 900 | 0 | 0.8699 | -73.8419 | 2021-08-17 04:21:49 | Caqueta, Colombia | |||
103166 | 103166 | 2021-08-15 | Colombia | Caqueta | 22499 | 899 | 0 | 0.8699 | -73.8419 | 2021-08-16 04:21:31 | Caqueta, Colombia | |||
507524 | 507524 | 2021-08-14 | Colombia | Caqueta | 22499 | 897 | 0 | 0.8699 | -73.8419 | 2021-08-15 04:21:41 | Caqueta, Colombia | |||
1483396 | 1483396 | 2021-08-13 | Colombia | Caqueta | 22480 | 896 | 0 | 0.8699 | -73.8419 | 2021-08-14 04:21:25 | Caqueta, Colombia | |||
2899526 | 2899526 | 2021-08-12 | Colombia | Caqueta | 22461 | 896 | 0 | 0.8699 | -73.8419 | 2021-08-13 04:21:24 | Caqueta, Colombia | |||
1342130 | 1342130 | 2021-08-11 | Colombia | Caqueta | 22422 | 895 | 0 | 0.8699 | -73.8419 | 2021-08-12 04:21:25 | Caqueta, Colombia | |||
2351277 | 2351277 | 2021-08-10 | Colombia | Caqueta | 22400 | 893 | 0 | 0.8699 | -73.8419 | 2021-08-11 04:21:58 | Caqueta, Colombia | |||
649806 | 649806 | 2021-08-09 | Colombia | Caqueta | 22384 | 893 | 0 | 0.8699 | -73.8419 | 2021-08-10 04:21:27 | Caqueta, Colombia | |||
589468 | 589468 | 2021-08-08 | Colombia | Caqueta | 22372 | 892 | 0 | 0.8699 | -73.8419 | 2021-08-09 04:21:24 | Caqueta, Colombia | |||
2203480 | 2203480 | 2021-08-07 | Colombia | Caqueta | 22300 | 889 | 0 | 0.8699 | -73.8419 | 2021-08-08 04:21:33 | Caqueta, Colombia | |||
1117430 | 1117430 | 2021-08-06 | Colombia | Caqueta | 22269 | 889 | 0 | 0.8699 | -73.8419 | 2021-08-07 04:21:30 | Caqueta, Colombia | |||
1956367 | 1956367 | 2021-08-05 | Colombia | Caqueta | 22232 | 887 | 0 | 0.8699 | -73.8419 | 2021-08-06 04:21:18 | Caqueta, Colombia | |||
331746 | 331746 | 2021-08-04 | Colombia | Caqueta | 22196 | 885 | 20895 | 416 | 0.8699 | -73.8419 | 2021-08-05 04:21:51 | Caqueta, Colombia | ||
3468017 | 3468017 | 2021-08-03 | Colombia | Caqueta | 22169 | 884 | 20866 | 419 | 0.8699 | -73.8419 | 2021-08-04 04:21:25 | Caqueta, Colombia | ||
3683291 | 3683291 | 2021-08-02 | Colombia | Caqueta | 22150 | 881 | 20837 | 432 | 0.8699 | -73.8419 | 2021-08-03 04:21:39 | Caqueta, Colombia | ||
3015190 | 3015190 | 2021-08-01 | Colombia | Caqueta | 22125 | 878 | 20803 | 444 | 0.8699 | -73.8419 | 2021-08-02 04:21:36 | Caqueta, Colombia | ||
3903813 | 3903813 | 2021-07-31 | Colombia | Caqueta | 22088 | 877 | 20783 | 428 | 0.8699 | -73.8419 | 2021-08-01 04:21:50 | Caqueta, Colombia | ||
3296018 | 3296018 | 2021-07-30 | Colombia | Caqueta | 22066 | 875 | 20747 | 444 | 0.8699 | -73.8419 | 2021-07-31 04:21:35 | Caqueta, Colombia | ||
3385229 | 3385229 | 2021-07-29 | Colombia | Caqueta | 22026 | 874 | 20701 | 451 | 0.8699 | -73.8419 | 2021-07-30 04:21:34 | Caqueta, Colombia | ||
408134 | 408134 | 2021-07-28 | Colombia | Caqueta | 21971 | 874 | 20645 | 452 | 0.8699 | -73.8419 | 2021-07-29 04:21:33 | Caqueta, Colombia | ||
1305995 | 1305995 | 2021-07-27 | Colombia | Caqueta | 21934 | 872 | 20602 | 460 | 0.8699 | -73.8419 | 2021-07-28 04:21:39 | Caqueta, Colombia | ||
3218138 | 3218138 | 2021-07-26 | Colombia | Caqueta | 21909 | 869 | 20530 | 510 | 0.8699 | -73.8419 | 2021-07-27 04:21:18 | Caqueta, Colombia | ||
1378347 | 1378347 | 2021-07-25 | Colombia | Caqueta | 21836 | 867 | 20495 | 474 | 0.8699 | -73.8419 | 2021-07-26 04:21:28 | Caqueta, Colombia | ||
1330087 | 1330087 | 2021-07-24 | Colombia | Caqueta | 21817 | 859 | 20469 | 489 | 0.8699 | -73.8419 | 2021-07-25 04:22:12 | Caqueta, Colombia | ||
3137391 | 3137391 | 2021-07-23 | Colombia | Caqueta | 21741 | 851 | 20370 | 520 | 0.8699 | -73.8419 | 2021-07-24 00:21:36 | Caqueta, Colombia | ||
3476151 | 3476151 | 2021-07-22 | Colombia | Caqueta | 21741 | 851 | 20370 | 520 | 0.8699 | -73.8419 | 2021-07-23 04:21:29 | Caqueta, Colombia | ||
3331370 | 3331370 | 2021-07-21 | Colombia | Caqueta | 21705 | 846 | 20324 | 535 | 0.8699 | -73.8419 | 2021-07-22 04:21:19 | Caqueta, Colombia | ||
2371351 | 2371351 | 2021-07-20 | Colombia | Caqueta | 21474 | 842 | 20272 | 360 | 0.8699 | -73.8419 | 2021-07-21 04:21:40 | Caqueta, Colombia | ||
483430 | 483430 | 2021-07-19 | Colombia | Caqueta | 21474 | 838 | 20223 | 413 | 0.8699 | -73.8419 | 2021-07-20 04:21:48 | Caqueta, Colombia | ||
2673653 | 2673653 | 2021-07-18 | Colombia | Caqueta | 21474 | 833 | 20164 | 477 | 0.8699 | -73.8419 | 2021-07-19 04:21:24 | Caqueta, Colombia | ||
3705965 | 3705965 | 2021-07-17 | Colombia | Caqueta | 21474 | 829 | 20129 | 516 | 0.8699 | -73.8419 | 2021-07-18 04:22:07 | Caqueta, Colombia | ||
2947196 | 2947196 | 2021-07-16 | Colombia | Caqueta | 21413 | 825 | 20077 | 511 | 0.8699 | -73.8419 | 2021-07-17 04:22:22 | Caqueta, Colombia | ||
295852 | 295852 | 2021-07-15 | Colombia | Caqueta | 21334 | 821 | 20033 | 480 | 0.8699 | -73.8419 | 2021-07-16 04:21:22 | Caqueta, Colombia | ||
3631797 | 3631797 | 2021-07-14 | Colombia | Caqueta | 21295 | 817 | 19980 | 498 | 0.8699 | -73.8419 | 2021-07-15 04:21:48 | Caqueta, Colombia | ||
578672 | 578672 | 2021-07-13 | Colombia | Caqueta | 21233 | 813 | 19936 | 484 | 0.8699 | -73.8419 | 2021-07-14 04:21:35 | Caqueta, Colombia | ||
3740921 | 3740921 | 2021-07-12 | Colombia | Caqueta | 21153 | 809 | 19877 | 467 | 0.8699 | -73.8419 | 2021-07-13 04:21:18 | Caqueta, Colombia | ||
3659434 | 3659434 | 2021-07-11 | Colombia | Caqueta | 21154 | 807 | 19698 | 649 | 0.8699 | -73.8419 | 2021-07-12 04:21:34 | Caqueta, Colombia | ||
625718 | 625718 | 2021-07-10 | Colombia | Caqueta | 21045 | 807 | 19698 | 540 | 0.8699 | -73.8419 | 2021-07-11 04:21:43 | Caqueta, Colombia | ||
829437 | 829437 | 2021-07-09 | Colombia | Caqueta | 20979 | 807 | 19576 | 596 | 0.8699 | -73.8419 | 2021-07-10 04:21:25 | Caqueta, Colombia | ||
778201 | 778201 | 2021-07-08 | Colombia | Caqueta | 20929 | 803 | 19576 | 550 | 0.8699 | -73.8419 | 2021-07-09 04:21:21 | Caqueta, Colombia | ||
1440423 | 1440423 | 2021-07-07 | Colombia | Caqueta | 20896 | 795 | 19533 | 568 | 0.8699 | -73.8419 | 2021-07-08 04:21:26 | Caqueta, Colombia | ||
2693528 | 2693528 | 2021-07-06 | Colombia | Caqueta | 20811 | 791 | 19510 | 510 | 0.8699 | -73.8419 | 2021-07-07 04:21:20 | Caqueta, Colombia | ||
1932277 | 1932277 | 2021-07-05 | Colombia | Caqueta | 20693 | 787 | 19332 | 574 | 0.8699 | -73.8419 | 2021-07-06 04:21:32 | Caqueta, Colombia | ||
1165008 | 1165008 | 2021-07-04 | Colombia | Caqueta | 20549 | 783 | 19286 | 480 | 0.8699 | -73.8419 | 2021-07-05 04:21:28 | Caqueta, Colombia | ||
1495442 | 1495442 | 2021-07-03 | Colombia | Caqueta | 20456 | 783 | 19199 | 474 | 0.8699 | -73.8419 | 2021-07-04 04:21:38 | Caqueta, Colombia | ||
2071757 | 2071757 | 2021-07-02 | Colombia | Caqueta | 20390 | 780 | 19152 | 458 | 0.8699 | -73.8419 | 2021-07-03 04:21:37 | Caqueta, Colombia | ||
2764773 | 2764773 | 2021-07-01 | Colombia | Caqueta | 20351 | 778 | 19100 | 473 | 0.8699 | -73.8419 | 2021-07-02 04:21:47 | Caqueta, Colombia | ||
1892981 | 1892981 | 2021-06-30 | Colombia | Caqueta | 20273 | 774 | 19053 | 446 | 0.8699 | -73.8419 | 2021-07-01 04:21:19 | Caqueta, Colombia | ||
400104 | 400104 | 2021-06-29 | Colombia | Caqueta | 20204 | 774 | 18989 | 441 | 0.8699 | -73.8419 | 2021-06-30 04:21:41 | Caqueta, Colombia | ||
3125347 | 3125347 | 2021-06-28 | Colombia | Caqueta | 20126 | 773 | 18930 | 423 | 0.8699 | -73.8419 | 2021-06-29 04:21:28 | Caqueta, Colombia | ||
2589842 | 2589842 | 2021-06-27 | Colombia | Caqueta | 20089 | 770 | 18799 | 520 | 0.8699 | -73.8419 | 2021-06-28 04:21:29 | Caqueta, Colombia | ||
3958346 | 3958346 | 2021-06-26 | Colombia | Caqueta | 19951 | 769 | 18739 | 443 | 0.8699 | -73.8419 | 2021-06-27 04:21:39 | Caqueta, Colombia | ||
1712165 | 1712165 | 2021-06-25 | Colombia | Caqueta | 19867 | 765 | 18693 | 409 | 0.8699 | -73.8419 | 2021-06-26 04:21:43 | Caqueta, Colombia | ||
2295290 | 2295290 | 2021-06-24 | Colombia | Caqueta | 19804 | 757 | 18671 | 376 | 0.8699 | -73.8419 | 2021-06-25 04:21:33 | Caqueta, Colombia | ||
2422730 | 2422730 | 2021-06-23 | Colombia | Caqueta | 19756 | 749 | 18567 | 440 | 0.8699 | -73.8419 | 2021-06-24 04:21:55 | Caqueta, Colombia | ||
562807 | 562807 | 2021-06-22 | Colombia | Caqueta | 19661 | 741 | 18501 | 419 | 0.8699 | -73.8419 | 2021-06-23 04:21:46 | Caqueta, Colombia | ||
3358509 | 3358509 | 2021-06-21 | Colombia | Caqueta | 19585 | 738 | 18444 | 403 | 0.8699 | -73.8419 | 2021-06-22 04:21:34 | Caqueta, Colombia | ||
2884208 | 2884208 | 2021-06-20 | Colombia | Caqueta | 19554 | 730 | 18395 | 429 | 0.8699 | -73.8419 | 2021-06-21 04:21:41 | Caqueta, Colombia | ||
107291 | 107291 | 2021-06-19 | Colombia | Caqueta | 19482 | 725 | 18369 | 388 | 0.8699 | -73.8419 | 2021-06-20 04:21:48 | Caqueta, Colombia | ||
1125434 | 1125434 | 2021-06-18 | Colombia | Caqueta | 19455 | 719 | 18333 | 403 | 0.8699 | -73.8419 | 2021-06-19 04:22:33 | Caqueta, Colombia | ||
2911012 | 2911012 | 2021-06-17 | Colombia | Caqueta | 19413 | 714 | 18106 | 593 | 0.8699 | -73.8419 | 2021-06-18 04:22:16 | Caqueta, Colombia | ||
3030130 | 3030130 | 2021-06-16 | Colombia | Caqueta | 19069 | 706 | 17933 | 430 | 0.8699 | -73.8419 | 2021-06-17 04:22:36 | Caqueta, Colombia | ||
2339236 | 2339236 | 2021-06-15 | Colombia | Caqueta | 18815 | 700 | 17874 | 241 | 0.8699 | -73.8419 | 2021-06-16 04:22:32 | Caqueta, Colombia | ||
1563932 | 1563932 | 2021-06-14 | Colombia | Caqueta | 18815 | 700 | 17874 | 241 | 0.8699 | -73.8419 | 2021-06-15 04:22:22 | Caqueta, Colombia | ||
3381215 | 3381215 | 2021-06-13 | Colombia | Caqueta | 18815 | 700 | 17831 | 284 | 0.8699 | -73.8419 | 2021-06-14 04:22:46 | Caqueta, Colombia | ||
1736349 | 1736349 | 2021-06-12 | Colombia | Caqueta | 18815 | 700 | 17811 | 304 | 0.8699 | -73.8419 | 2021-06-13 04:22:44 | Caqueta, Colombia | ||
3970390 | 3970390 | 2021-06-11 | Colombia | Caqueta | 18778 | 700 | 17776 | 302 | 0.8699 | -73.8419 | 2021-06-12 04:22:22 | Caqueta, Colombia | ||
2716812 | 2716812 | 2021-06-10 | Colombia | Caqueta | 18733 | 700 | 17726 | 307 | 0.8699 | -73.8419 | 2021-06-11 04:23:20 | Caqueta, Colombia | ||
522697 | 522697 | 2021-06-09 | Colombia | Caqueta | 18697 | 698 | 17698 | 301 | 0.8699 | -73.8419 | 2021-06-10 04:23:17 | Caqueta, Colombia | ||
3472137 | 3472137 | 2021-06-08 | Colombia | Caqueta | 18660 | 696 | 17654 | 310 | 0.8699 | -73.8419 | 2021-06-09 04:23:31 | Caqueta, Colombia | ||
3145421 | 3145421 | 2021-06-07 | Colombia | Caqueta | 18660 | 696 | 17654 | 310 | 0.8699 | -73.8419 | 2021-06-08 04:22:35 | 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]);