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 = "Huila" sorted by last_update
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
813427 | 813427 | 2020-09-05 | Colombia | Huila | 5918 | 172 | 3915 | 1831 | 2.5359 | -75.5277 | 2020-09-06 04:28:33 | Huila, Colombia | ||
3161472 | 3161472 | 2020-09-06 | Colombia | Huila | 6238 | 186 | 4163 | 1889 | 2.5359 | -75.5277 | 2020-09-07 04:28:30 | Huila, Colombia | ||
427187 | 427187 | 2020-09-07 | Colombia | Huila | 6238 | 186 | 4163 | 1889 | 2.5359 | -75.5277 | 2020-09-08 04:28:25 | Huila, Colombia | ||
1243608 | 1243608 | 2020-09-08 | Colombia | Huila | 6507 | 191 | 4446 | 1870 | 2.5359 | -75.5277 | 2020-09-09 04:28:48 | Huila, Colombia | ||
2171399 | 2171399 | 2020-09-09 | Colombia | Huila | 6996 | 208 | 4875 | 1913 | 2.5359 | -75.5277 | 2020-09-10 04:29:01 | Huila, Colombia | ||
1173034 | 1173034 | 2020-09-10 | Colombia | Huila | 7195 | 213 | 5205 | 1777 | 2.5359 | -75.5277 | 2020-09-11 04:46:23 | Huila, Colombia | ||
1444433 | 1444433 | 2020-09-11 | Colombia | Huila | 7386 | 220 | 5411 | 1755 | 2.5359 | -75.5277 | 2020-09-12 04:25:05 | Huila, Colombia | ||
546604 | 546604 | 2020-09-12 | Colombia | Huila | 7635 | 224 | 5540 | 1871 | 2.5359 | -75.5277 | 2020-09-13 04:30:52 | Huila, Colombia | ||
2868565 | 2868565 | 2020-09-13 | Colombia | Huila | 7864 | 234 | 5694 | 1936 | 2.5359 | -75.5277 | 2020-09-14 04:26:00 | Huila, Colombia | ||
344126 | 344126 | 2020-09-14 | Colombia | Huila | 7953 | 242 | 5850 | 1861 | 2.5359 | -75.5277 | 2020-09-15 03:22:50 | Huila, Colombia | ||
2728854 | 2728854 | 2020-09-15 | Colombia | Huila | 8192 | 246 | 5872 | 2074 | 2.5359 | -75.5277 | 2020-09-16 04:22:53 | Huila, Colombia | ||
666129 | 666129 | 2020-09-16 | Colombia | Huila | 8506 | 255 | 5901 | 2350 | 2.5359 | -75.5277 | 2020-09-17 04:22:00 | Huila, Colombia | ||
1121440 | 1121440 | 2020-09-17 | Colombia | Huila | 8756 | 261 | 6018 | 2477 | 2.5359 | -75.5277 | 2020-09-18 05:05:00 | Huila, Colombia | ||
2848691 | 2848691 | 2020-09-18 | Colombia | Huila | 9049 | 261 | 6018 | 2770 | 2.5359 | -75.5277 | 2020-09-19 04:22:00 | Huila, Colombia | ||
2454622 | 2454622 | 2020-09-19 | Colombia | Huila | 9380 | 282 | 6258 | 2840 | 2.5359 | -75.5277 | 2020-09-20 04:22:00 | Huila, Colombia | ||
3093272 | 3093272 | 2020-09-20 | Colombia | Huila | 9545 | 290 | 6453 | 2802 | 2.5359 | -75.5277 | 2020-09-21 04:23:00 | Huila, Colombia | ||
2836667 | 2836667 | 2020-09-21 | Colombia | Huila | 9644 | 301 | 6642 | 2701 | 2.5359 | -75.5277 | 2020-09-22 04:23:00 | Huila, Colombia | ||
3316068 | 3316068 | 2020-09-22 | Colombia | Huila | 9910 | 301 | 6642 | 2967 | 2.5359 | -75.5277 | 2020-09-23 04:23:00 | Huila, Colombia | ||
2653619 | 2653619 | 2020-09-23 | Colombia | Huila | 10082 | 310 | 7155 | 2617 | 2.5359 | -75.5277 | 2020-09-24 04:23:00 | Huila, Colombia | ||
2605876 | 2605876 | 2020-09-24 | Colombia | Huila | 10451 | 315 | 7650 | 2486 | 2.5359 | -75.5277 | 2020-09-25 04:23:00 | Huila, Colombia | ||
2812599 | 2812599 | 2020-09-25 | Colombia | Huila | 10763 | 324 | 8069 | 2370 | 2.5359 | -75.5277 | 2020-09-26 04:23:00 | Huila, Colombia | ||
2613884 | 2613884 | 2020-09-26 | Colombia | Huila | 11000 | 332 | 8395 | 2273 | 2.5359 | -75.5277 | 2020-09-27 04:23:00 | Huila, Colombia | ||
2581832 | 2581832 | 2020-09-27 | Colombia | Huila | 11281 | 344 | 8799 | 2138 | 2.5359 | -75.5277 | 2020-09-28 04:23:00 | Huila, Colombia | ||
1515244 | 1515244 | 2020-09-28 | Colombia | Huila | 11435 | 354 | 9317 | 1764 | 2.5359 | -75.5277 | 2020-09-29 04:23:42 | Huila, Colombia | ||
966747 | 966747 | 2020-09-29 | Colombia | Huila | 11637 | 361 | 9750 | 1526 | 2.5359 | -75.5277 | 2020-09-30 04:23:33 | Huila, Colombia | ||
1045666 | 1045666 | 2020-09-30 | Colombia | Huila | 11738 | 370 | 10149 | 1219 | 2.5359 | -75.5277 | 2020-10-01 04:23:42 | Huila, Colombia | ||
2379480 | 2379480 | 2020-10-01 | Colombia | Huila | 11918 | 376 | 10452 | 1090 | 2.5359 | -75.5277 | 2020-10-02 04:23:51 | Huila, Colombia | ||
3389239 | 3389239 | 2020-10-02 | Colombia | Huila | 12213 | 382 | 10491 | 1340 | 2.5359 | -75.5277 | 2020-10-03 04:23:40 | Huila, Colombia | ||
2514021 | 2514021 | 2020-10-03 | Colombia | Huila | 12496 | 387 | 10704 | 1405 | 2.5359 | -75.5277 | 2020-10-04 04:23:44 | Huila, Colombia | ||
1822637 | 1822637 | 2020-10-04 | Colombia | Huila | 12700 | 401 | 10894 | 1405 | 2.5359 | -75.5277 | 2020-10-05 04:23:33 | Huila, Colombia | ||
3801747 | 3801747 | 2020-10-05 | Colombia | Huila | 13032 | 405 | 10894 | 1733 | 2.5359 | -75.5277 | 2020-10-06 04:23:33 | Huila, Colombia | ||
3117335 | 3117335 | 2020-10-06 | Colombia | Huila | 13314 | 415 | 10911 | 1988 | 2.5359 | -75.5277 | 2020-10-07 04:23:40 | Huila, Colombia | ||
1041674 | 1041674 | 2020-10-07 | Colombia | Huila | 13564 | 428 | 10949 | 2187 | 2.5359 | -75.5277 | 2020-10-08 04:23:56 | Huila, Colombia | ||
2689532 | 2689532 | 2020-10-08 | Colombia | Huila | 13874 | 428 | 10949 | 2497 | 2.5359 | -75.5277 | 2020-10-09 04:23:59 | Huila, Colombia | ||
817417 | 817417 | 2020-10-09 | Colombia | Huila | 14190 | 432 | 11041 | 2717 | 2.5359 | -75.5277 | 2020-10-10 04:23:57 | Huila, Colombia | ||
2601884 | 2601884 | 2020-10-10 | Colombia | Huila | 14655 | 447 | 11119 | 3089 | 2.5359 | -75.5277 | 2020-10-11 04:23:46 | Huila, Colombia | ||
3785746 | 3785746 | 2020-10-11 | Colombia | Huila | 15240 | 447 | 11119 | 3674 | 2.5359 | -75.5277 | 2020-10-12 04:23:45 | Huila, Colombia | ||
2291293 | 2291293 | 2020-10-12 | Colombia | Huila | 15637 | 469 | 11820 | 3348 | 2.5359 | -75.5277 | 2020-10-13 04:24:02 | Huila, Colombia | ||
3781753 | 3781753 | 2020-10-13 | Colombia | Huila | 15831 | 477 | 12208 | 3146 | 2.5359 | -75.5277 | 2020-10-14 04:24:05 | Huila, Colombia | ||
78938 | 78938 | 2020-10-14 | Colombia | Huila | 15998 | 484 | 12772 | 2742 | 2.5359 | -75.5277 | 2020-10-15 04:24:28 | Huila, Colombia | ||
786227 | 786227 | 2020-10-15 | Colombia | Huila | 16348 | 488 | 13301 | 2559 | 2.5359 | -75.5277 | 2020-10-16 04:24:01 | Huila, Colombia | ||
2856697 | 2856697 | 2020-10-16 | Colombia | Huila | 16776 | 488 | 13301 | 2987 | 2.5359 | -75.5277 | 2020-10-17 04:24:12 | Huila, Colombia | ||
1026202 | 1026202 | 2020-10-17 | Colombia | Huila | 17130 | 502 | 14080 | 2548 | 2.5359 | -75.5277 | 2020-10-18 04:24:25 | Huila, Colombia | ||
762164 | 762164 | 2020-10-18 | Colombia | Huila | 17399 | 509 | 14537 | 2353 | 2.5359 | -75.5277 | 2020-10-19 04:24:16 | Huila, Colombia | ||
1794480 | 1794480 | 2020-10-19 | Colombia | Huila | 17719 | 515 | 15069 | 2135 | 2.5359 | -75.5277 | 2020-10-20 04:24:22 | Huila, Colombia | ||
3990460 | 3990460 | 2020-10-20 | Colombia | Huila | 18256 | 524 | 15468 | 2264 | 2.5359 | -75.5277 | 2020-10-21 04:24:14 | Huila, Colombia | ||
2191449 | 2191449 | 2020-10-21 | Colombia | Huila | 18502 | 535 | 15955 | 2012 | 2.5359 | -75.5277 | 2020-10-22 04:24:27 | Huila, Colombia | ||
1177344 | 1177344 | 2020-10-22 | Colombia | Huila | 18950 | 546 | 16416 | 1988 | 2.5359 | -75.5277 | 2020-10-23 04:24:46 | Huila, Colombia | ||
1053674 | 1053674 | 2020-10-23 | Colombia | Huila | 19288 | 553 | 16820 | 1915 | 2.5359 | -75.5277 | 2020-10-24 04:24:46 | Huila, Colombia | ||
3651419 | 3651419 | 2020-10-24 | Colombia | Huila | 19509 | 561 | 17107 | 1841 | 2.5359 | -75.5277 | 2020-10-25 04:24:36 | Huila, Colombia | ||
8182 | 8182 | 2020-10-25 | Colombia | Huila | 20039 | 574 | 17365 | 2100 | 2.5359 | -75.5277 | 2020-10-26 04:25:02 | Huila, Colombia | ||
3480161 | 3480161 | 2020-10-26 | Colombia | Huila | 20547 | 585 | 17879 | 2083 | 2.5359 | -75.5277 | 2020-10-27 04:24:45 | Huila, Colombia | ||
1452437 | 1452437 | 2020-10-27 | Colombia | Huila | 20776 | 607 | 18239 | 1930 | 2.5359 | -75.5277 | 2020-10-28 04:24:39 | Huila, Colombia | ||
754152 | 754152 | 2020-10-28 | Colombia | Huila | 21164 | 620 | 18662 | 1882 | 2.5359 | -75.5277 | 2020-10-29 04:24:49 | Huila, Colombia | ||
210090 | 210090 | 2020-10-29 | Colombia | Huila | 21583 | 620 | 18662 | 2301 | 2.5359 | -75.5277 | 2020-10-30 04:24:49 | Huila, Colombia | ||
2243235 | 2243235 | 2020-10-30 | Colombia | Huila | 21583 | 630 | 18954 | 1999 | 2.5359 | -75.5277 | 2020-10-31 04:24:44 | Huila, Colombia | ||
2079782 | 2079782 | 2020-10-31 | Colombia | Huila | 22648 | 650 | 19664 | 2334 | 2.5359 | -75.5277 | 2020-11-01 04:36:19 | Huila, Colombia | ||
3409293 | 3409293 | 2020-11-01 | Colombia | Huila | 23123 | 670 | 20329 | 2124 | 2.5359 | -75.5277 | 2020-11-02 05:25:04 | Huila, Colombia | ||
3304044 | 3304044 | 2020-11-02 | Colombia | Huila | 23673 | 676 | 20726 | 2271 | 2.5359 | -75.5277 | 2020-11-03 06:00:16 | Huila, Colombia | ||
2497869 | 2497869 | 2020-11-03 | Colombia | Huila | 24096 | 691 | 21244 | 2161 | 2.5359 | -75.5277 | 2020-11-04 05:25:09 | Huila, Colombia | ||
2919032 | 2919032 | 2020-11-04 | Colombia | Huila | 24375 | 701 | 21532 | 2142 | 2.5359 | -75.5277 | 2020-11-05 06:05:03 | Huila, Colombia | ||
891970 | 891970 | 2020-11-05 | Colombia | Huila | 24830 | 714 | 21797 | 2319 | 2.5359 | -75.5277 | 2020-11-06 05:24:55 | Huila, Colombia | ||
376032 | 376032 | 2020-11-06 | Colombia | Huila | 25228 | 725 | 22217 | 2286 | 2.5359 | -75.5277 | 2020-11-07 05:24:52 | Huila, Colombia | ||
1543794 | 1543794 | 2020-11-07 | Colombia | Huila | 25543 | 733 | 22678 | 2132 | 2.5359 | -75.5277 | 2020-11-08 05:24:56 | Huila, Colombia | ||
1728334 | 1728334 | 2020-11-08 | Colombia | Huila | 25776 | 744 | 23066 | 1966 | 2.5359 | -75.5277 | 2020-11-09 05:25:45 | Huila, Colombia | ||
1988482 | 1988482 | 2020-11-09 | Colombia | Huila | 26007 | 755 | 23494 | 1758 | 2.5359 | -75.5277 | 2020-11-10 05:40:07 | Huila, Colombia | ||
272005 | 272005 | 2020-11-10 | Colombia | Huila | 26123 | 769 | 23798 | 1556 | 2.5359 | -75.5277 | 2020-11-11 05:25:30 | Huila, Colombia | ||
3440665 | 3440665 | 2020-11-11 | Colombia | Huila | 26361 | 780 | 24195 | 1386 | 2.5359 | -75.5277 | 2020-11-12 05:25:55 | Huila, Colombia | ||
864620 | 864620 | 2020-11-12 | Colombia | Huila | 26518 | 788 | 24605 | 1125 | 2.5359 | -75.5277 | 2020-11-13 05:25:30 | Huila, Colombia | ||
2784855 | 2784855 | 2020-11-13 | Colombia | Huila | 26833 | 788 | 24605 | 1440 | 2.5359 | -75.5277 | 2020-11-14 05:25:37 | Huila, Colombia | ||
2915033 | 2915033 | 2020-11-14 | Colombia | Huila | 27705 | 801 | 24793 | 2111 | 2.5359 | -75.5277 | 2020-11-15 05:26:53 | Huila, Colombia | ||
2880055 | 2880055 | 2020-11-15 | Colombia | Huila | 27302 | 828 | 25581 | 893 | 2.5359 | -75.5277 | 2020-11-16 05:25:57 | Huila, Colombia | ||
3169487 | 3169487 | 2020-11-16 | Colombia | Huila | 27524 | 838 | 25821 | 865 | 2.5359 | -75.5277 | 2020-11-17 05:25:54 | Huila, Colombia | ||
3338442 | 3338442 | 2020-11-17 | Colombia | Huila | 27692 | 846 | 26058 | 788 | 2.5359 | -75.5277 | 2020-11-18 05:40:31 | Huila, Colombia | ||
122554 | 122554 | 2020-11-18 | Colombia | Huila | 27896 | 852 | 26236 | 808 | 2.5359 | -75.5277 | 2020-11-19 05:25:23 | Huila, Colombia | ||
821420 | 821420 | 2020-11-19 | Colombia | Huila | 28035 | 864 | 26445 | 726 | 2.5359 | -75.5277 | 2020-11-20 05:26:28 | Huila, Colombia | ||
2701360 | 2701360 | 2020-11-20 | Colombia | Huila | 28375 | 874 | 26549 | 952 | 2.5359 | -75.5277 | 2020-11-21 05:25:51 | Huila, Colombia | ||
3836332 | 3836332 | 2020-11-21 | Colombia | Huila | 28551 | 884 | 26868 | 799 | 2.5359 | -75.5277 | 2020-11-22 05:25:45 | Huila, Colombia | ||
3189838 | 3189838 | 2020-11-22 | Colombia | Huila | 28656 | 900 | 27045 | 711 | 2.5359 | -75.5277 | 2020-11-23 05:25:26 | Huila, Colombia | ||
678162 | 678162 | 2020-11-23 | Colombia | Huila | 28902 | 910 | 27183 | 809 | 2.5359 | -75.5277 | 2020-11-24 05:27:31 | Huila, Colombia | ||
1350168 | 1350168 | 2020-11-24 | Colombia | Huila | 28976 | 915 | 27352 | 709 | 2.5359 | -75.5277 | 2020-11-25 05:27:20 | Huila, Colombia | ||
1972437 | 1972437 | 2020-11-25 | Colombia | Huila | 29121 | 921 | 27450 | 750 | 2.5359 | -75.5277 | 2020-11-26 05:27:44 | Huila, Colombia | ||
923532 | 923532 | 2020-11-26 | Colombia | Huila | 29222 | 927 | 27558 | 737 | 2.5359 | -75.5277 | 2020-11-27 05:26:53 | Huila, Colombia | ||
392085 | 392085 | 2020-11-27 | Colombia | Huila | 29357 | 937 | 27719 | 701 | 2.5359 | -75.5277 | 2020-11-28 05:25:50 | Huila, Colombia | ||
2935082 | 2935082 | 2020-11-28 | Colombia | Huila | 29602 | 949 | 27861 | 792 | 2.5359 | -75.5277 | 2020-11-29 05:25:55 | Huila, Colombia | ||
3566417 | 3566417 | 2020-11-29 | Colombia | Huila | 29839 | 955 | 28098 | 786 | 2.5359 | -75.5277 | 2020-11-30 05:26:13 | Huila, Colombia | ||
1584014 | 1584014 | 2020-11-30 | Colombia | Huila | 30100 | 963 | 28254 | 883 | 2.5359 | -75.5277 | 2020-12-01 05:26:18 | Huila, Colombia | ||
2537245 | 2537245 | 2020-12-01 | Colombia | Huila | 30355 | 969 | 28469 | 917 | 2.5359 | -75.5277 | 2020-12-02 05:27:41 | Huila, Colombia | ||
738151 | 738151 | 2020-12-02 | Colombia | Huila | 30460 | 977 | 28688 | 795 | 2.5359 | -75.5277 | 2020-12-03 05:28:22 | Huila, Colombia | ||
74939 | 74939 | 2020-12-03 | Colombia | Huila | 30563 | 981 | 28825 | 757 | 2.5359 | -75.5277 | 2020-12-04 05:27:27 | Huila, Colombia | ||
3859681 | 3859681 | 2020-12-04 | Colombia | Huila | 30723 | 984 | 28953 | 786 | 2.5359 | -75.5277 | 2020-12-05 05:27:36 | Huila, Colombia | ||
1632153 | 1632153 | 2020-12-05 | Colombia | Huila | 30870 | 985 | 29061 | 824 | 2.5359 | -75.5277 | 2020-12-06 05:26:18 | Huila, Colombia | ||
1006144 | 1006144 | 2020-12-06 | Colombia | Huila | 31044 | 990 | 29166 | 888 | 2.5359 | -75.5277 | 2020-12-07 05:26:14 | Huila, Colombia | ||
2347274 | 2347274 | 2020-12-07 | Colombia | Huila | 31117 | 1000 | 29383 | 734 | 2.5359 | -75.5277 | 2020-12-08 05:27:42 | Huila, Colombia | ||
1818638 | 1818638 | 2020-12-08 | Colombia | Huila | 31194 | 1006 | 29551 | 637 | 2.5359 | -75.5277 | 2020-12-09 05:28:01 | Huila, Colombia | ||
2975078 | 2975078 | 2020-12-09 | Colombia | Huila | 31307 | 1011 | 29635 | 661 | 2.5359 | -75.5277 | 2020-12-10 05:26:19 | Huila, Colombia | ||
1600069 | 1600069 | 2020-12-10 | Colombia | Huila | 31391 | 1015 | 29736 | 640 | 2.5359 | -75.5277 | 2020-12-11 05:26:59 | Huila, Colombia | ||
860527 | 860527 | 2020-12-11 | Colombia | Huila | 31546 | 1020 | 29831 | 695 | 2.5359 | -75.5277 | 2020-12-12 05:26:19 | Huila, Colombia | ||
845420 | 845420 | 2020-12-12 | Colombia | Huila | 31705 | 1026 | 29909 | 770 | 2.5359 | -75.5277 | 2020-12-13 05:27:20 | Huila, Colombia | ||
3847638 | 3847638 | 2020-12-13 | Colombia | Huila | 31817 | 1030 | 29965 | 822 | 2.5359 | -75.5277 | 2020-12-14 05:26:27 | Huila, 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]);