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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491435 | 1491435 | 2021-10-12 | Colombia | Huila | 88303 | 3142 | 0 | 2.5359 | -75.5277 | 2021-10-13 04:20:51 | Huila, Colombia | |||
3007168 | 3007168 | 2021-10-11 | Colombia | Huila | 88300 | 3141 | 0 | 2.5359 | -75.5277 | 2021-10-12 04:21:09 | Huila, Colombia | |||
423184 | 423184 | 2021-10-10 | Colombia | Huila | 88293 | 3141 | 0 | 2.5359 | -75.5277 | 2021-10-11 04:21:31 | Huila, Colombia | |||
2876041 | 2876041 | 2021-10-09 | Colombia | Huila | 88292 | 3141 | 0 | 2.5359 | -75.5277 | 2021-10-10 04:21:38 | Huila, Colombia | |||
2959207 | 2959207 | 2021-10-08 | Colombia | Huila | 88279 | 3140 | 0 | 2.5359 | -75.5277 | 2021-10-09 04:21:34 | Huila, Colombia | |||
467245 | 467245 | 2021-10-07 | Colombia | Huila | 88266 | 3140 | 0 | 2.5359 | -75.5277 | 2021-10-08 04:21:25 | Huila, Colombia | |||
2458625 | 2458625 | 2021-10-06 | Colombia | Huila | 88241 | 3140 | 0 | 2.5359 | -75.5277 | 2021-10-07 04:21:36 | Huila, Colombia | |||
3832319 | 3832319 | 2021-10-05 | Colombia | Huila | 88238 | 3140 | 0 | 2.5359 | -75.5277 | 2021-10-06 04:21:33 | Huila, Colombia | |||
986812 | 986812 | 2021-10-04 | Colombia | Huila | 88235 | 3140 | 0 | 2.5359 | -75.5277 | 2021-10-05 04:21:27 | Huila, Colombia | |||
1274122 | 1274122 | 2021-10-03 | Colombia | Huila | 88234 | 3139 | 0 | 2.5359 | -75.5277 | 2021-10-04 04:21:31 | Huila, Colombia | |||
3927875 | 3927875 | 2021-10-02 | Colombia | Huila | 88223 | 3139 | 0 | 2.5359 | -75.5277 | 2021-10-03 04:21:24 | Huila, Colombia | |||
2131855 | 2131855 | 2021-10-01 | Colombia | Huila | 88206 | 3139 | 0 | 2.5359 | -75.5277 | 2021-10-02 04:21:25 | Huila, Colombia | |||
2772812 | 2772812 | 2021-09-30 | Colombia | Huila | 88195 | 3139 | 0 | 2.5359 | -75.5277 | 2021-10-01 04:21:35 | Huila, Colombia | |||
706268 | 706268 | 2021-09-29 | Colombia | Huila | 88187 | 3139 | 0 | 2.5359 | -75.5277 | 2021-09-30 04:21:20 | Huila, Colombia | |||
1334110 | 1334110 | 2021-09-28 | Colombia | Huila | 88186 | 3139 | 0 | 2.5359 | -75.5277 | 2021-09-29 04:21:45 | Huila, Colombia | |||
1235479 | 1235479 | 2021-09-27 | Colombia | Huila | 88168 | 3139 | 0 | 2.5359 | -75.5277 | 2021-09-28 04:21:28 | Huila, Colombia | |||
2075780 | 2075780 | 2021-09-26 | Colombia | Huila | 88168 | 3138 | 0 | 2.5359 | -75.5277 | 2021-09-27 04:21:16 | Huila, Colombia | |||
1724332 | 1724332 | 2021-09-25 | Colombia | Huila | 88158 | 3137 | 0 | 2.5359 | -75.5277 | 2021-09-26 04:21:29 | Huila, Colombia | |||
1921052 | 1921052 | 2021-09-24 | Colombia | Huila | 88149 | 3137 | 0 | 2.5359 | -75.5277 | 2021-09-25 04:21:31 | Huila, Colombia | |||
601523 | 601523 | 2021-09-23 | Colombia | Huila | 88142 | 3135 | 0 | 2.5359 | -75.5277 | 2021-09-24 04:21:44 | Huila, Colombia | |||
3011184 | 3011184 | 2021-09-22 | Colombia | Huila | 88126 | 3135 | 0 | 2.5359 | -75.5277 | 2021-09-23 04:21:43 | Huila, Colombia | |||
3757322 | 3757322 | 2021-09-21 | Colombia | Huila | 88111 | 3135 | 0 | 2.5359 | -75.5277 | 2021-09-22 04:21:45 | Huila, Colombia | |||
809425 | 809425 | 2021-09-20 | Colombia | Huila | 88105 | 3135 | 0 | 2.5359 | -75.5277 | 2021-09-21 04:21:26 | Huila, Colombia | |||
1814624 | 1814624 | 2021-09-19 | Colombia | Huila | 88099 | 3134 | 0 | 2.5359 | -75.5277 | 2021-09-20 04:21:22 | Huila, Colombia | |||
16204 | 16204 | 2021-09-18 | Colombia | Huila | 88080 | 3133 | 0 | 2.5359 | -75.5277 | 2021-09-19 04:21:34 | Huila, Colombia | |||
2617889 | 2617889 | 2021-09-17 | Colombia | Huila | 88066 | 3132 | 0 | 2.5359 | -75.5277 | 2021-09-18 04:21:24 | Huila, Colombia | |||
2808597 | 2808597 | 2021-09-16 | Colombia | Huila | 88049 | 3132 | 0 | 2.5359 | -75.5277 | 2021-09-17 04:21:46 | Huila, Colombia | |||
1374342 | 1374342 | 2021-09-15 | Colombia | Huila | 88024 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-16 04:22:19 | Huila, Colombia | |||
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 |
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]);