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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462641 | 2462641 | 2021-09-14 | Colombia | Huila | 88024 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-15 03:22:37 | Huila, Colombia | |||
1385480 | 1385480 | 2021-09-13 | Colombia | Huila | 88012 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-14 04:21:41 | Huila, Colombia | |||
1884849 | 1884849 | 2021-09-12 | Colombia | Huila | 88008 | 3130 | 0 | 2.5359 | -75.5277 | 2021-09-13 04:21:15 | Huila, Colombia | |||
3805752 | 3805752 | 2021-09-11 | Colombia | Huila | 87994 | 3129 | 0 | 2.5359 | -75.5277 | 2021-09-12 04:21:13 | Huila, Colombia | |||
3448692 | 3448692 | 2021-09-10 | Colombia | Huila | 87975 | 3128 | 0 | 2.5359 | -75.5277 | 2021-09-11 04:21:30 | Huila, Colombia | |||
1262638 | 1262638 | 2021-09-09 | Colombia | Huila | 87948 | 3127 | 0 | 2.5359 | -75.5277 | 2021-09-10 04:21:20 | Huila, Colombia | |||
2279008 | 2279008 | 2021-09-08 | Colombia | Huila | 87937 | 3126 | 0 | 2.5359 | -75.5277 | 2021-09-09 04:21:27 | Huila, Colombia | |||
641787 | 641787 | 2021-09-07 | Colombia | Huila | 87921 | 3124 | 0 | 2.5359 | -75.5277 | 2021-09-08 04:21:31 | Huila, Colombia | |||
3193850 | 3193850 | 2021-09-06 | Colombia | Huila | 87914 | 3122 | 0 | 2.5359 | -75.5277 | 2021-09-07 04:21:35 | Huila, Colombia | |||
3280718 | 3280718 | 2021-09-05 | Colombia | Huila | 87901 | 3118 | 0 | 2.5359 | -75.5277 | 2021-09-06 04:21:22 | Huila, Colombia | |||
249132 | 249132 | 2021-09-04 | Colombia | Huila | 87881 | 3117 | 0 | 2.5359 | -75.5277 | 2021-09-05 04:21:33 | Huila, Colombia | |||
3974413 | 3974413 | 2021-09-03 | Colombia | Huila | 87858 | 3116 | 0 | 2.5359 | -75.5277 | 2021-09-04 04:21:28 | Huila, Colombia | |||
177875 | 177875 | 2021-09-02 | Colombia | Huila | 87838 | 3113 | 0 | 2.5359 | -75.5277 | 2021-09-03 04:21:20 | Huila, Colombia | |||
66910 | 66910 | 2021-09-01 | Colombia | Huila | 87817 | 3112 | 0 | 2.5359 | -75.5277 | 2021-09-02 04:21:15 | Huila, Colombia | |||
2067752 | 2067752 | 2021-08-31 | Colombia | Huila | 87794 | 3108 | 0 | 2.5359 | -75.5277 | 2021-09-01 04:21:38 | Huila, Colombia | |||
1775206 | 1775206 | 2021-08-30 | Colombia | Huila | 87775 | 3108 | 0 | 2.5359 | -75.5277 | 2021-08-31 04:21:46 | Huila, Colombia | |||
3891780 | 3891780 | 2021-08-29 | Colombia | Huila | 87741 | 3105 | 0 | 2.5359 | -75.5277 | 2021-08-30 04:21:23 | Huila, Colombia | |||
2792883 | 2792883 | 2021-08-28 | Colombia | Huila | 87699 | 3102 | 0 | 2.5359 | -75.5277 | 2021-08-29 04:21:14 | Huila, Colombia | |||
2923042 | 2923042 | 2021-08-27 | Colombia | Huila | 87662 | 3100 | 0 | 2.5359 | -75.5277 | 2021-08-28 04:21:28 | Huila, Colombia | |||
1596056 | 1596056 | 2021-08-26 | Colombia | Huila | 87625 | 3097 | 0 | 2.5359 | -75.5277 | 2021-08-27 04:21:37 | Huila, Colombia | |||
32265 | 32265 | 2021-08-25 | Colombia | Huila | 87566 | 3095 | 0 | 2.5359 | -75.5277 | 2021-08-26 04:21:28 | Huila, Colombia | |||
3105304 | 3105304 | 2021-08-24 | Colombia | Huila | 87566 | 3093 | 0 | 2.5359 | -75.5277 | 2021-08-25 04:21:41 | Huila, Colombia | |||
3165475 | 3165475 | 2021-08-23 | Colombia | Huila | 87528 | 3092 | 0 | 2.5359 | -75.5277 | 2021-08-24 04:21:19 | Huila, Colombia | |||
2175402 | 2175402 | 2021-08-22 | Colombia | Huila | 87498 | 3090 | 0 | 2.5359 | -75.5277 | 2021-08-23 04:21:27 | Huila, Colombia | |||
3555498 | 3555498 | 2021-08-21 | Colombia | Huila | 87456 | 3082 | 0 | 2.5359 | -75.5277 | 2021-08-22 04:21:29 | Huila, Colombia | |||
1853840 | 1853840 | 2021-08-20 | Colombia | Huila | 87406 | 3082 | 0 | 2.5359 | -75.5277 | 2021-08-21 04:21:38 | Huila, Colombia | |||
511547 | 511547 | 2021-08-19 | Colombia | Huila | 87347 | 3081 | 0 | 2.5359 | -75.5277 | 2021-08-20 04:21:33 | Huila, Colombia | |||
2518026 | 2518026 | 2021-08-18 | Colombia | Huila | 87314 | 3072 | 0 | 2.5359 | -75.5277 | 2021-08-19 04:21:15 | Huila, Colombia | |||
245118 | 245118 | 2021-08-17 | Colombia | Huila | 87280 | 3072 | 0 | 2.5359 | -75.5277 | 2021-08-18 04:21:35 | Huila, Colombia | |||
1604081 | 1604081 | 2021-08-16 | Colombia | Huila | 87246 | 3067 | 0 | 2.5359 | -75.5277 | 2021-08-17 04:21:49 | Huila, Colombia | |||
103175 | 103175 | 2021-08-15 | Colombia | Huila | 87110 | 3061 | 0 | 2.5359 | -75.5277 | 2021-08-16 04:21:31 | Huila, Colombia | |||
507533 | 507533 | 2021-08-14 | Colombia | Huila | 87110 | 3058 | 0 | 2.5359 | -75.5277 | 2021-08-15 04:21:41 | Huila, Colombia | |||
1483405 | 1483405 | 2021-08-13 | Colombia | Huila | 87051 | 3050 | 0 | 2.5359 | -75.5277 | 2021-08-14 04:21:25 | Huila, Colombia | |||
2899535 | 2899535 | 2021-08-12 | Colombia | Huila | 86972 | 3048 | 0 | 2.5359 | -75.5277 | 2021-08-13 04:21:24 | Huila, Colombia | |||
1342139 | 1342139 | 2021-08-11 | Colombia | Huila | 86834 | 3041 | 0 | 2.5359 | -75.5277 | 2021-08-12 04:21:25 | Huila, Colombia | |||
2351286 | 2351286 | 2021-08-10 | Colombia | Huila | 86739 | 3030 | 0 | 2.5359 | -75.5277 | 2021-08-11 04:21:58 | Huila, Colombia | |||
649815 | 649815 | 2021-08-09 | Colombia | Huila | 86690 | 3015 | 0 | 2.5359 | -75.5277 | 2021-08-10 04:21:27 | Huila, Colombia | |||
589477 | 589477 | 2021-08-08 | Colombia | Huila | 86596 | 3008 | 0 | 2.5359 | -75.5277 | 2021-08-09 04:21:24 | Huila, Colombia | |||
2203489 | 2203489 | 2021-08-07 | Colombia | Huila | 86490 | 3003 | 0 | 2.5359 | -75.5277 | 2021-08-08 04:21:33 | Huila, Colombia | |||
1117439 | 1117439 | 2021-08-06 | Colombia | Huila | 86363 | 2998 | 0 | 2.5359 | -75.5277 | 2021-08-07 04:21:30 | Huila, Colombia | |||
1956376 | 1956376 | 2021-08-05 | Colombia | Huila | 86208 | 2991 | 0 | 2.5359 | -75.5277 | 2021-08-06 04:21:18 | Huila, Colombia | |||
331755 | 331755 | 2021-08-04 | Colombia | Huila | 86087 | 2986 | 81215 | 1886 | 2.5359 | -75.5277 | 2021-08-05 04:21:51 | Huila, Colombia | ||
3468026 | 3468026 | 2021-08-03 | Colombia | Huila | 85949 | 2978 | 81027 | 1944 | 2.5359 | -75.5277 | 2021-08-04 04:21:25 | Huila, Colombia | ||
3683300 | 3683300 | 2021-08-02 | Colombia | Huila | 85768 | 2963 | 80848 | 1957 | 2.5359 | -75.5277 | 2021-08-03 04:21:39 | Huila, Colombia | ||
3015199 | 3015199 | 2021-08-01 | Colombia | Huila | 85600 | 2946 | 80644 | 2010 | 2.5359 | -75.5277 | 2021-08-02 04:21:36 | Huila, Colombia | ||
3903822 | 3903822 | 2021-07-31 | Colombia | Huila | 85366 | 2930 | 80459 | 1977 | 2.5359 | -75.5277 | 2021-08-01 04:21:50 | Huila, Colombia | ||
3296027 | 3296027 | 2021-07-30 | Colombia | Huila | 85150 | 2920 | 80310 | 1920 | 2.5359 | -75.5277 | 2021-07-31 04:21:35 | Huila, Colombia | ||
3385238 | 3385238 | 2021-07-29 | Colombia | Huila | 84991 | 2905 | 80107 | 1979 | 2.5359 | -75.5277 | 2021-07-30 04:21:34 | Huila, Colombia | ||
408143 | 408143 | 2021-07-28 | Colombia | Huila | 84756 | 2893 | 79879 | 1984 | 2.5359 | -75.5277 | 2021-07-29 04:21:33 | Huila, Colombia | ||
1306004 | 1306004 | 2021-07-27 | Colombia | Huila | 84612 | 2880 | 79383 | 2349 | 2.5359 | -75.5277 | 2021-07-28 04:21:39 | Huila, Colombia | ||
3218147 | 3218147 | 2021-07-26 | Colombia | Huila | 84225 | 2864 | 78863 | 2498 | 2.5359 | -75.5277 | 2021-07-27 04:21:18 | Huila, Colombia | ||
1378356 | 1378356 | 2021-07-25 | Colombia | Huila | 84033 | 2853 | 78461 | 2719 | 2.5359 | -75.5277 | 2021-07-26 04:21:28 | Huila, Colombia | ||
1330096 | 1330096 | 2021-07-24 | Colombia | Huila | 83843 | 2844 | 78203 | 2796 | 2.5359 | -75.5277 | 2021-07-25 04:22:12 | Huila, Colombia | ||
3137400 | 3137400 | 2021-07-23 | Colombia | Huila | 83198 | 2802 | 77544 | 2852 | 2.5359 | -75.5277 | 2021-07-24 00:21:36 | Huila, Colombia | ||
3476160 | 3476160 | 2021-07-22 | Colombia | Huila | 83198 | 2802 | 77544 | 2852 | 2.5359 | -75.5277 | 2021-07-23 04:21:29 | Huila, Colombia | ||
3331379 | 3331379 | 2021-07-21 | Colombia | Huila | 82897 | 2788 | 77235 | 2874 | 2.5359 | -75.5277 | 2021-07-22 04:21:19 | Huila, Colombia | ||
2371360 | 2371360 | 2021-07-20 | Colombia | Huila | 80852 | 2766 | 76803 | 1283 | 2.5359 | -75.5277 | 2021-07-21 04:21:40 | Huila, Colombia | ||
483439 | 483439 | 2021-07-19 | Colombia | Huila | 80852 | 2749 | 76334 | 1769 | 2.5359 | -75.5277 | 2021-07-20 04:21:48 | Huila, Colombia | ||
2673662 | 2673662 | 2021-07-18 | Colombia | Huila | 80852 | 2734 | 75725 | 2393 | 2.5359 | -75.5277 | 2021-07-19 04:21:24 | Huila, Colombia | ||
3705974 | 3705974 | 2021-07-17 | Colombia | Huila | 80852 | 2724 | 75529 | 2599 | 2.5359 | -75.5277 | 2021-07-18 04:22:07 | Huila, Colombia | ||
2947205 | 2947205 | 2021-07-16 | Colombia | Huila | 80579 | 2712 | 75200 | 2667 | 2.5359 | -75.5277 | 2021-07-17 04:22:22 | Huila, Colombia | ||
295861 | 295861 | 2021-07-15 | Colombia | Huila | 80173 | 2686 | 74860 | 2627 | 2.5359 | -75.5277 | 2021-07-16 04:21:22 | Huila, Colombia | ||
3631806 | 3631806 | 2021-07-14 | Colombia | Huila | 79655 | 2665 | 74391 | 2599 | 2.5359 | -75.5277 | 2021-07-15 04:21:48 | Huila, Colombia | ||
578681 | 578681 | 2021-07-13 | Colombia | Huila | 79129 | 2647 | 73985 | 2497 | 2.5359 | -75.5277 | 2021-07-14 04:21:35 | Huila, Colombia | ||
3740930 | 3740930 | 2021-07-12 | Colombia | Huila | 78074 | 2638 | 73152 | 2284 | 2.5359 | -75.5277 | 2021-07-13 04:21:18 | Huila, Colombia | ||
3659443 | 3659443 | 2021-07-11 | Colombia | Huila | 78072 | 2579 | 71981 | 3512 | 2.5359 | -75.5277 | 2021-07-12 04:21:34 | Huila, Colombia | ||
625727 | 625727 | 2021-07-10 | Colombia | Huila | 77736 | 2579 | 71981 | 3176 | 2.5359 | -75.5277 | 2021-07-11 04:21:43 | Huila, Colombia | ||
829446 | 829446 | 2021-07-09 | Colombia | Huila | 77173 | 2579 | 71014 | 3580 | 2.5359 | -75.5277 | 2021-07-10 04:21:25 | Huila, Colombia | ||
778210 | 778210 | 2021-07-08 | Colombia | Huila | 76845 | 2551 | 71014 | 3280 | 2.5359 | -75.5277 | 2021-07-09 04:21:21 | Huila, Colombia | ||
1440432 | 1440432 | 2021-07-07 | Colombia | Huila | 76250 | 2531 | 70339 | 3380 | 2.5359 | -75.5277 | 2021-07-08 04:21:26 | Huila, Colombia | ||
2693537 | 2693537 | 2021-07-06 | Colombia | Huila | 75438 | 2512 | 70042 | 2884 | 2.5359 | -75.5277 | 2021-07-07 04:21:20 | Huila, Colombia | ||
1932286 | 1932286 | 2021-07-05 | Colombia | Huila | 74705 | 2494 | 69096 | 3115 | 2.5359 | -75.5277 | 2021-07-06 04:21:32 | Huila, Colombia | ||
1165017 | 1165017 | 2021-07-04 | Colombia | Huila | 74109 | 2473 | 68529 | 3107 | 2.5359 | -75.5277 | 2021-07-05 04:21:28 | Huila, Colombia | ||
1495451 | 1495451 | 2021-07-03 | Colombia | Huila | 73271 | 2454 | 67947 | 2870 | 2.5359 | -75.5277 | 2021-07-04 04:21:38 | Huila, Colombia | ||
2071766 | 2071766 | 2021-07-02 | Colombia | Huila | 72631 | 2435 | 67594 | 2602 | 2.5359 | -75.5277 | 2021-07-03 04:21:37 | Huila, Colombia | ||
2764782 | 2764782 | 2021-07-01 | Colombia | Huila | 72170 | 2418 | 67221 | 2531 | 2.5359 | -75.5277 | 2021-07-02 04:21:47 | Huila, Colombia | ||
1892990 | 1892990 | 2021-06-30 | Colombia | Huila | 71843 | 2405 | 66930 | 2508 | 2.5359 | -75.5277 | 2021-07-01 04:21:19 | Huila, Colombia | ||
400113 | 400113 | 2021-06-29 | Colombia | Huila | 71568 | 2385 | 66204 | 2979 | 2.5359 | -75.5277 | 2021-06-30 04:21:41 | Huila, Colombia | ||
3125356 | 3125356 | 2021-06-28 | Colombia | Huila | 70724 | 2368 | 65598 | 2758 | 2.5359 | -75.5277 | 2021-06-29 04:21:28 | Huila, Colombia | ||
2589851 | 2589851 | 2021-06-27 | Colombia | Huila | 69820 | 2352 | 65087 | 2381 | 2.5359 | -75.5277 | 2021-06-28 04:21:29 | Huila, Colombia | ||
3958355 | 3958355 | 2021-06-26 | Colombia | Huila | 69233 | 2339 | 64655 | 2239 | 2.5359 | -75.5277 | 2021-06-27 04:21:39 | Huila, Colombia | ||
1712174 | 1712174 | 2021-06-25 | Colombia | Huila | 68732 | 2318 | 64316 | 2098 | 2.5359 | -75.5277 | 2021-06-26 04:21:43 | Huila, Colombia | ||
2295299 | 2295299 | 2021-06-24 | Colombia | Huila | 68316 | 2306 | 64002 | 2008 | 2.5359 | -75.5277 | 2021-06-25 04:21:33 | Huila, Colombia | ||
2422739 | 2422739 | 2021-06-23 | Colombia | Huila | 68007 | 2294 | 63542 | 2171 | 2.5359 | -75.5277 | 2021-06-24 04:21:55 | Huila, Colombia | ||
562816 | 562816 | 2021-06-22 | Colombia | Huila | 67617 | 2278 | 62924 | 2415 | 2.5359 | -75.5277 | 2021-06-23 04:21:46 | Huila, Colombia | ||
3358518 | 3358518 | 2021-06-21 | Colombia | Huila | 67017 | 2247 | 62449 | 2321 | 2.5359 | -75.5277 | 2021-06-22 04:21:34 | Huila, Colombia | ||
2884217 | 2884217 | 2021-06-20 | Colombia | Huila | 66679 | 2243 | 62153 | 2283 | 2.5359 | -75.5277 | 2021-06-21 04:21:41 | Huila, Colombia | ||
107300 | 107300 | 2021-06-19 | Colombia | Huila | 66301 | 2235 | 61938 | 2128 | 2.5359 | -75.5277 | 2021-06-20 04:21:48 | Huila, Colombia | ||
1125443 | 1125443 | 2021-06-18 | Colombia | Huila | 66098 | 2228 | 61402 | 2468 | 2.5359 | -75.5277 | 2021-06-19 04:22:33 | Huila, Colombia | ||
2911021 | 2911021 | 2021-06-17 | Colombia | Huila | 65483 | 2218 | 61073 | 2192 | 2.5359 | -75.5277 | 2021-06-18 04:22:16 | Huila, Colombia | ||
3030139 | 3030139 | 2021-06-16 | Colombia | Huila | 64650 | 2189 | 60111 | 2350 | 2.5359 | -75.5277 | 2021-06-17 04:22:36 | Huila, Colombia | ||
2339245 | 2339245 | 2021-06-15 | Colombia | Huila | 63204 | 2178 | 59592 | 1434 | 2.5359 | -75.5277 | 2021-06-16 04:22:32 | Huila, Colombia | ||
1563941 | 1563941 | 2021-06-14 | Colombia | Huila | 63204 | 2178 | 59592 | 1434 | 2.5359 | -75.5277 | 2021-06-15 04:22:22 | Huila, Colombia | ||
3381224 | 3381224 | 2021-06-13 | Colombia | Huila | 63204 | 2166 | 59163 | 1875 | 2.5359 | -75.5277 | 2021-06-14 04:22:46 | Huila, Colombia | ||
1736358 | 1736358 | 2021-06-12 | Colombia | Huila | 63204 | 2148 | 58879 | 2177 | 2.5359 | -75.5277 | 2021-06-13 04:22:44 | Huila, Colombia | ||
3970399 | 3970399 | 2021-06-11 | Colombia | Huila | 62729 | 2141 | 58680 | 1908 | 2.5359 | -75.5277 | 2021-06-12 04:22:22 | Huila, Colombia | ||
2716821 | 2716821 | 2021-06-10 | Colombia | Huila | 62285 | 2133 | 58325 | 1827 | 2.5359 | -75.5277 | 2021-06-11 04:23:20 | Huila, Colombia | ||
522706 | 522706 | 2021-06-09 | Colombia | Huila | 61827 | 2123 | 58074 | 1630 | 2.5359 | -75.5277 | 2021-06-10 04:23:17 | Huila, Colombia | ||
3472146 | 3472146 | 2021-06-08 | Colombia | Huila | 61376 | 2110 | 57738 | 1528 | 2.5359 | -75.5277 | 2021-06-09 04:23:31 | Huila, Colombia | ||
3145430 | 3145430 | 2021-06-07 | Colombia | Huila | 61376 | 2110 | 57738 | 1528 | 2.5359 | -75.5277 | 2021-06-08 04:22:35 | 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]);